You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
8 lines
1014 B
8 lines
1014 B
11 months ago
|
SELECT * FROM Enrollment_FeeItem WHERE EID>80000 AND FeeItemName LIKE '%心电%'
|
||
|
|
|
||
|
|
[ID], [OEID], [GroupID], [EID], [PackID], [PackName], [FID], [FeeItemCode], [FeeItemName], [Quantity], [Unit], [Price], [SettlePrice], [ItemClass], [CreateTime], [CreatorCode], [Creator], [OrderNo], [DeptCode], [DeptName], [Seq], [RefundNo], [GiveUpTime], [GiveUpUser], [GiveUpCode], [KeyNo], [OldId], [IsSend]) VALUES (1030080, NULL, NULL, 80003, NULL, NULL, 572, '310701001C', '十二通道心电图检查', 1, '次', 25.00, .00, '普通', '2024-06-17 08:17:36.000', '0928', '赵菲', 84004, '0141', '健康管理中心/治未病', NULL, NULL, NULL, NULL, NULL, 'T94', NULL, '1');
|
||
|
|
|
||
|
|
|
||
|
|
SELECT * FROM vi_FeeItem WHERE ID=572
|
||
|
|
|
||
|
|
UPDATE [Enrollment_FeeItem] SET [KeyNo] = '87911192', [FeeItemCode] = '310701001C', [FeeItemName] = '十二通道心电图检查', [Price] = 25.00, [DeptCode] = '0141', [DeptName] = '健康管理中心/治未病', [Unit] = '次', [ItemClass] = '普通' WHERE EID>80000 AND FeeItemName LIKE '%心电%'
|