◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2025-08-01 08:40:31
记录内容:cyys_2017@123cyys_2017@1231002615051002615051670138179.72001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2025-08-01 08:40:31
记录内容:'16701381'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2025-08-01 08:40:31
记录内容:2025-08-01 08:40:31
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2025-08-01 08:40:31
记录内容:2025-08-01 08:40:31
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 08:40:32
记录内容:__________ INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20250801004052','100261505','于永波','一般人员','自费',to_date('2025/08/01 08:40:31','yyyy/mm/dd hh24:mi:ss'),'79.72','79.72','YU YONG BO ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 08:40:32
记录内容:__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/8/1 8:18:34','yyyy/mm/dd hh24:mi:ss'),'1551','100261505','0','','0312','张晓刚','20250801004052','20250801897')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 08:40:32
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 08:40:31','yyyy/mm/dd hh24:mi:ss'),'1551','20250801004052','1','D','D1201312','X线摄影成像(从第二个体位开始,按25元/体位收取)','/','1','部位·体','0404','25','25','0','1','J','044','150','1.0000','25.0000','1','','0','张晓刚','0312','0','左踝关节正侧位','JC0022983','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 08:40:32
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 08:40:31','yyyy/mm/dd hh24:mi:ss'),'1551','20250801004052','2','D','D1201206','X线摄影成像','/','1','部位·体','0404','40','40','0','1','J','044','150','1.0000','40.0000','1','','0','张晓刚','0312','0','左踝关节正侧位','JC0022983','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 08:40:32
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 08:40:31','yyyy/mm/dd hh24:mi:ss'),'1551','20250801004052','3','D','I0012937','医用红外干式激光胶片','MDI-HLJ-Q 35cm*43cm/广西巨星','1','张','0312','14.72','14.72','0','1','J','044','150','1.0000','14.7200','1','','0','张晓刚','0312','0','左踝关节正侧位','JC0022983','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 08:40:32
记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250801004052','1','微信','79.72','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 08:40:32
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16701381' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 08:40:32
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16701381' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 08:40:32
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16701381' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 08:40:32
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16701381' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 08:40:32
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16701381' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 08:40:32
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16701381' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 08:40:32
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16701381'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 08:40:32
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16701381'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 08:40:32
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16701381'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 08:40:32
记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5592835'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 08:40:32
记录内容:__________UPDATE exam_appoints SET costs='79.72',charges='79.72',BILLING_INDICATOR='1' WHERE EXAM_NO = '5592835'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 08:40:32
记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100261505'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 08:40:32
记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100261505' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 08:40:32
记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100261505'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 08:40:32
记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100261505')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2025-08-01 08:40:32
记录内容:2025-08-01 08:40:32
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2025-08-01 08:40:32
记录内容:1成功120250801004052
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2025-08-01 08:40:32
记录内容:2025-08-01 08:40:32
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2025-08-01 10:17:23
记录内容:cyys_2017@123cyys_2017@123107387341073873416702335167027511670275516702765167027821900.00001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2025-08-01 10:17:23
记录内容:'16702335','16702751','16702755','16702765','16702782'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2025-08-01 10:17:24
记录内容:2025-08-01 10:17:24
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2025-08-01 10:17:24
记录内容:2025-08-01 10:17:24
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________ INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20250801004707','10738734','杨庆更','一般人员','自费',to_date('2025/08/01 10:17:24','yyyy/mm/dd hh24:mi:ss'),'1900','1900','YANG QING GENG ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/8/1 9:44:29','yyyy/mm/dd hh24:mi:ss'),'4204','10738734','0','','0312','张晓刚','20250801004707','202508013384')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 10:17:24','yyyy/mm/dd hh24:mi:ss'),'4204','20250801004707','1','D','D1201238','磁共振(MR)平扫','/','1','部位','0406','450','450','0','1','J','044','150','1.0000','450.0000','1','','0','张晓刚','0312','0','颈椎磁共振平扫','JC0022637','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/8/1 9:44:29','yyyy/mm/dd hh24:mi:ss'),'4205','10738734','0','','0312','张晓刚','20250801004707','202508013384')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 10:17:24','yyyy/mm/dd hh24:mi:ss'),'4205','20250801004707','1','D','D1201238','磁共振(MR)平扫','/','1','部位','0406','450','450','0','1','J','044','150','1.0000','450.0000','1','','0','杨春景','0303','0','颅脑磁共振平扫+磁共振弥散成像+颅脑磁敏感加权成像(SWI)','JC0022543','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 10:17:24','yyyy/mm/dd hh24:mi:ss'),'4205','20250801004707','2','D','D1201239','磁共振(MR)平扫-特殊方式成像(加收)','/','1','项','0406','50','50','0','1','J','044','150','1.0000','50.0000','1','','0','杨春景','0303','0','颅脑磁共振平扫+磁共振弥散成像+颅脑磁敏感加权成像(SWI)','JC0022543','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 10:17:24','yyyy/mm/dd hh24:mi:ss'),'4205','20250801004707','3','D','D1201239','磁共振(MR)平扫-特殊方式成像(加收)','/','1','项','0406','50','50','0','1','J','044','150','1.0000','50.0000','1','','0','杨春景','0303','0','颅脑磁共振平扫+磁共振弥散成像+颅脑磁敏感加权成像(SWI)','JC0022543','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 10:17:24','yyyy/mm/dd hh24:mi:ss'),'4205','20250801004707','4','D','D1201248','磁共振(MR)平扫成像(血管 )','/','1','血管','0406','520','520','0','1','J','044','150','1.0000','520.0000','2','','0','杨春景','0303','0','颅脑磁共振血管成像(MRA)','JC0022546','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/8/1 9:44:29','yyyy/mm/dd hh24:mi:ss'),'4206','10738734','0','','0312','张晓刚','20250801004707','202508013384')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 10:17:24','yyyy/mm/dd hh24:mi:ss'),'4206','20250801004707','1','D','D0903028','温度试验','/','1','次','030301','70','70','0','1','B','016','900','1.0000','70.0000','3','','0','杨春景','0303','0','温度试验(神经电生理)','JC001939','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 10:17:24','yyyy/mm/dd hh24:mi:ss'),'4206','20250801004707','2','D','D0903029','自发眼震','/','1','次','030301','70','70','0','1','B','016','900','1.0000','70.0000','4','','0','杨春景','0303','0','红外眼震视图(自发眼震+视动试验)','JC001938','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 10:17:24','yyyy/mm/dd hh24:mi:ss'),'4206','20250801004707','3','D','D0903033','视动试验','/','1','次','030301','80','80','0','1','B','016','900','1.0000','80.0000','4','','0','杨春景','0303','0','红外眼震视图(自发眼震+视动试验)','JC001938','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/8/1 9:44:29','yyyy/mm/dd hh24:mi:ss'),'4207','10738734','0','','0312','张晓刚','20250801004707','202508013384')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 10:17:24','yyyy/mm/dd hh24:mi:ss'),'4207','20250801004707','1','D','D1201172','彩色多普勒超声检查(血管)','/','1','部位','0409','80','80','0','1','J','044','150','1.0000','80.0000','5','','0','杨春景','0303','0','双侧颈动脉彩色多普勒超声检查','JC0022424','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/8/1 9:44:29','yyyy/mm/dd hh24:mi:ss'),'4208','10738734','0','','0312','张晓刚','20250801004707','202508013384')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 10:17:24','yyyy/mm/dd hh24:mi:ss'),'4208','20250801004707','1','D','D1201203','彩色多普勒超声检查(血管)-从第二个部位开始,每个部位按50%收费,累计收费不超过360元','/','1','部位','0409','40','40','0','1','J','044','150','1.0000','40.0000','6','','0','杨春景','0303','0','双侧椎动脉彩色多普勒超声检查(减收)','JC0022490','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 10:17:24','yyyy/mm/dd hh24:mi:ss'),'4208','20250801004707','2','D','D1201203','彩色多普勒超声检查(血管)-从第二个部位开始,每个部位按50%收费,累计收费不超过360元','/','1','部位','0409','40','40','0','1','J','044','150','1.0000','40.0000','7','','0','杨春景','0303','0','双侧锁骨下动脉彩色多普勒超声检查(减收)','JC0022489','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250801004707','1','微信','1900','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16702335' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16702751' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16702751' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16702751' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16702751' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16702755' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16702755' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16702755' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16702765' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16702782' and presc_no = '0' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16702782' and presc_no = '0' and item_no = '7'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16702335' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16702751' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16702751' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16702751' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16702751' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16702755' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16702755' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16702755' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16702765' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16702782' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16702782' and item_no = '7'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16702335'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16702751'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16702751'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16702751'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16702751'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16702755'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16702755'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16702755'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16702765'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16702782'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16702782'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5593100'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5593097'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5593093'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5593095'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE exam_appoints SET costs='160',charges='160',BILLING_INDICATOR='1' WHERE EXAM_NO = '5593100'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE exam_appoints SET costs='80',charges='80',BILLING_INDICATOR='1' WHERE EXAM_NO = '5593097'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE exam_appoints SET costs='2140',charges='2140',BILLING_INDICATOR='1' WHERE EXAM_NO = '5593093'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE exam_appoints SET costs='440',charges='440',BILLING_INDICATOR='1' WHERE EXAM_NO = '5593095'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10738734'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10738734' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10738734'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:17:26
记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10738734')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2025-08-01 10:17:26
记录内容:2025-08-01 10:17:26
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2025-08-01 10:17:26
记录内容:1成功120250801004707
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2025-08-01 10:17:26
记录内容:2025-08-01 10:17:26
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2025-08-01 10:32:24
记录内容:cyys_2017@123cyys_2017@123100438086100438086167029688.02001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2025-08-01 10:32:24
记录内容:'16702968'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2025-08-01 10:32:24
记录内容:2025-08-01 10:32:24
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2025-08-01 10:32:24
记录内容:2025-08-01 10:32:24
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:32:24
记录内容:__________ INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20250801004798','100438086','杨浥尘','一般人员','自费',to_date('2025/08/01 10:32:24','yyyy/mm/dd hh24:mi:ss'),'8.02','8.02','','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:32:24
记录内容:__________ INSERT INTO drug_presc_master_temp (presc_date,presc_no,dispensary,PATIENT_ID,NAME,NAME_PHONETIC,IDENTITY,CHARGE_TYPE,PRESC_TYPE,PRESC_ATTR,PRESC_SOURCE,REPETITION,COSTS,PAYMENTS,ORDERED_BY,PRESCRIBED_BY,ENTERED_BY,DOCTOR_USER,RCPT_NO,COUNT_PER_REPETITION,CLINIC_NO,IS_SEND,SEND_WIN_NO) VALUES (to_date('2025/08/01 10:32:24','yyyy/mm/dd hh24:mi:ss'),'4343','050101','100438086','杨浥尘','','一般人员','自费','0','门诊处方','0','1','8.02','8.02','0304','CYP11','陈云平','CYP11','20250801004798','2','202508013107','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:32:24
记录内容:__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2025-08-01 10:32:24', 'yyyy-mm-dd hh24:mi:ss'),'4343','1','11301053390','0.1g*100','维生素C片*','临汾宝珠','0.1g*100','盒','1','1.12','1.12','.1;g;口服;3/日','1','1','0.1','','','','','','0','0','','','','0.0000','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:32:24
记录内容:__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2025-08-01 10:32:24', 'yyyy-mm-dd hh24:mi:ss'),'4343','2','11301003391','1片*100','复合维生素B片','力生制药','1片*100','瓶','1','6.9','6.9','2;片;口服;3/日','2','1','2','','','','','','0','0','','','','0.0000','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:32:24
记录内容:__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/8/1 9:34:56','yyyy/mm/dd hh24:mi:ss'),'4610','100438086','1','门诊处方','0304','陈云平','20250801004798','202508013107')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:32:24
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 10:32:24','yyyy/mm/dd hh24:mi:ss'),'4610','20250801004798','1','A','11301053390','维生素C片*','0.1g*100临汾宝珠','1','盒','050101','1.12','1.12','0','1','A','032','200','1.0000','1.1200','1','.1;g;口服;3/日','0','陈云平','0304','0','维生素C片*','11301053390','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:32:24
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 10:32:24','yyyy/mm/dd hh24:mi:ss'),'4610','20250801004798','2','A','11301003391','复合维生素B片','1片*100力生制药','1','瓶','050101','6.9','6.9','0','1','A','032','200','1.0000','6.9000','2','2;片;口服;3/日','0','陈云平','0304','0','复合维生素B片','11301003391','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:32:24
记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250801004798','1','微信','8.02','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:32:24
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16702968' and presc_no = '4343' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:32:24
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16702968' and presc_no = '4343' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:32:24
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16702968'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:32:24
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16702968'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:32:24
记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100438086'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:32:24
记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100438086' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:32:24
记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100438086'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 10:32:24
记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100438086')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2025-08-01 10:32:24
记录内容:2025-08-01 10:32:24
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2025-08-01 10:32:24
记录内容:1成功120250801004798
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2025-08-01 10:32:24
记录内容:2025-08-01 10:32:24
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2025-08-01 11:13:07
记录内容:cyys_2017@123cyys_2017@1231075819510758195167035611670356516703568104.67001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2025-08-01 11:13:07
记录内容:'16703561','16703565','16703568'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2025-08-01 11:13:07
记录内容:2025-08-01 11:13:07
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2025-08-01 11:13:08
记录内容:2025-08-01 11:13:08
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________ INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20250801005142','10758195','邓伟伟','一般人员','自费',to_date('2025/08/01 11:13:07','yyyy/mm/dd hh24:mi:ss'),'104.67','104.67','DENG WEI WEI ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/8/1 10:56:09','yyyy/mm/dd hh24:mi:ss'),'5476','10758195','0','','0333','王茜','20250801005142','202508015153')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 11:13:07','yyyy/mm/dd hh24:mi:ss'),'5476','20250801005142','1','C','H0001049','尿液分析','/','1','次','0411','6','6','0','1','J','044','150','1.0000','6.0000','1','','0','王茜','0333','0','尿常规','JY001411','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/8/1 10:56:09','yyyy/mm/dd hh24:mi:ss'),'5477','10758195','0','','0333','王茜','20250801005142','202508015153')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 11:13:07','yyyy/mm/dd hh24:mi:ss'),'5477','20250801005142','1','C','H0204025','血清丙氨酸氨基转移酶测定(速率法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','2','','0','王茜','0333','0','*肝功10项','JY001305','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 11:13:07','yyyy/mm/dd hh24:mi:ss'),'5477','20250801005142','2','C','H0204029','血清天门冬氨酸氨基转移酶测定(速率法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','2','','0','王茜','0333','0','*肝功10项','JY001305','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 11:13:07','yyyy/mm/dd hh24:mi:ss'),'5477','20250801005142','3','C','H0204033','血清γ-谷氨酰基转移酶测定(速率法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','2','','0','王茜','0333','0','*肝功10项','JY001305','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 11:13:07','yyyy/mm/dd hh24:mi:ss'),'5477','20250801005142','4','C','H0204003','血清总胆红素测定(化学法或酶促法)','/','1','项','0411','5','5','0','1','M','025','190','1.0000','5.0000','2','','0','王茜','0333','0','*肝功10项','JY001305','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 11:13:07','yyyy/mm/dd hh24:mi:ss'),'5477','20250801005142','5','C','H0204007','血清直接胆红素测定(化学法或酶促法)','/','1','项','0411','5','5','0','1','M','025','190','1.0000','5.0000','2','','0','王茜','0333','0','*肝功10项','JY001305','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 11:13:07','yyyy/mm/dd hh24:mi:ss'),'5477','20250801005142','6','C','H0200003','血清总蛋白测定(化学法)','/','1','项','0411','5','5','0','1','M','025','190','1.0000','5.0000','2','','0','王茜','0333','0','*肝功10项','JY001305','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 11:13:07','yyyy/mm/dd hh24:mi:ss'),'5477','20250801005142','7','C','H0200007','血清白蛋白测定(化学法)','/','1','项','0411','5','5','0','1','M','025','190','1.0000','5.0000','2','','0','王茜','0333','0','*肝功10项','JY001305','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 11:13:07','yyyy/mm/dd hh24:mi:ss'),'5477','20250801005142','8','C','H0204038','血清碱性磷酸酶测定(速率法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','2','','0','王茜','0333','0','*肝功10项','JY001305','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 11:13:07','yyyy/mm/dd hh24:mi:ss'),'5477','20250801005142','9','C','H0206004','尿素测定(酶促动力学法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','3','','0','王茜','0333','0','*肾功3','21567','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 11:13:07','yyyy/mm/dd hh24:mi:ss'),'5477','20250801005142','10','C','H0206007','肌酐测定(酶促动力学法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','3','','0','王茜','0333','0','*肾功3','21567','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 11:13:07','yyyy/mm/dd hh24:mi:ss'),'5477','20250801005142','11','C','H0206012','血清尿酸测定','/','1','项','0411','5','5','0','1','M','025','190','1.0000','5.0000','3','','0','王茜','0333','0','*肾功3','21567','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 11:13:08','yyyy/mm/dd hh24:mi:ss'),'5477','20250801005142','12','C','H0203005','钠测定(火焰分光光亮度法或离子选择电极法)','/','1','项','0411','10','10','0','1','M','025','190','1.0000','10.0000','4','','0','王茜','0333','0','*电解质3项','JY000014','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 11:13:08','yyyy/mm/dd hh24:mi:ss'),'5477','20250801005142','13','C','H0203002','钾测定(火焰分光光亮度法或离子选择电极法)','/','1','项','0411','10','10','0','1','M','025','190','1.0000','10.0000','4','','0','王茜','0333','0','*电解质3项','JY000014','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 11:13:08','yyyy/mm/dd hh24:mi:ss'),'5477','20250801005142','14','C','H0203008','氯测定(离子选择电极法)','/','1','项','0411','10','10','0','1','M','025','190','1.0000','10.0000','4','','0','王茜','0333','0','*电解质3项','JY000014','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/8/1 10:56:09','yyyy/mm/dd hh24:mi:ss'),'5478','10758195','0','','0333','王茜','20250801005142','202508015153')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 11:13:08','yyyy/mm/dd hh24:mi:ss'),'5478','20250801005142','1','E','E0003052','静脉采血','/','1','次','0329','7','7','0','1','B','016','900','1.0000','7.0000','5','','0','王茜','0333','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 11:13:08','yyyy/mm/dd hh24:mi:ss'),'5478','20250801005142','2','E','I0015681','一次性使用静脉血样采集针','J-7软连接式0.7/威高','1','支','0333','0.25','0.25','0','1','J','044','150','1.0000','0.2500','5','','0','王茜','0333','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 11:13:08','yyyy/mm/dd hh24:mi:ss'),'5478','20250801005142','3','E','I0015765','一次性使用人体静脉血样采集容器','EDTA-K2 2ml/威海威高','1','支','0333','0.42','0.42','0','1','J','044','150','1.0000','0.4200','5','','0','王茜','0333','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250801005142','1','微信','104.67','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16703561' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16703565' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16703565' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16703565' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16703565' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16703565' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16703565' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16703565' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16703565' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16703565' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16703565' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16703565' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16703565' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16703565' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16703565' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16703568' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16703568' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16703568' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16703561' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16703565' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16703565' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16703565' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16703565' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16703565' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16703565' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16703565' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16703565' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16703565' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16703565' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16703565' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16703565' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16703565' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16703565' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16703568' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16703568' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16703568' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16703561'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16703565'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16703565'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16703565'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16703565'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16703565'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16703565'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16703565'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16703565'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16703565'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16703565'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16703565'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16703565'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16703565'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16703565'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16703568'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16703568'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16703568'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2508019256'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2508019255'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE exam_appoints SET costs='7.67',charges='7.67',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE exam_appoints SET costs='273',charges='273',BILLING_INDICATOR='1' WHERE EXAM_NO = '2508019256'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE exam_appoints SET costs='6',charges='6',BILLING_INDICATOR='1' WHERE EXAM_NO = '2508019255'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10758195'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10758195' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10758195'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 11:13:09
记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10758195')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2025-08-01 11:13:09
记录内容:2025-08-01 11:13:09
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2025-08-01 11:13:09
记录内容:1成功120250801005142
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2025-08-01 11:13:09
记录内容:2025-08-01 11:13:09
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2025-08-01 13:20:31
记录内容:cyys_2017@123cyys_2017@12310047965610047965616704082144.00001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2025-08-01 13:20:31
记录内容:'16704082'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2025-08-01 13:20:31
记录内容:2025-08-01 13:20:31
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2025-08-01 13:20:31
记录内容:2025-08-01 13:20:31
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:20:31
记录内容:__________ INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20250801005541','100479656','王从运','一般人员','自费',to_date('2025/08/01 13:20:31','yyyy/mm/dd hh24:mi:ss'),'144','144','WANG CONG YUN ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:20:31
记录内容:__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/8/1 12:02:33','yyyy/mm/dd hh24:mi:ss'),'6464','100479656','0','','0318','韩露露','20250801005541','202508016139')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:20:31
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 13:20:31','yyyy/mm/dd hh24:mi:ss'),'6464','20250801005541','1','C','H0400053','真菌D-葡聚糖检测','/','1','项','0318','144','144','0','1','J','044','150','1.0000','144.0000','1','','0','韩露露','0318','0','真菌D-葡聚糖检测(皮肤科)','JY001924','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:20:31
记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250801005541','1','微信','144','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:20:31
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16704082' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:20:31
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16704082' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:20:31
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16704082'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:20:31
记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:20:31
记录内容:__________UPDATE exam_appoints SET costs='144',charges='144',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:20:31
记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100479656'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:20:31
记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100479656' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:20:31
记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100479656'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:20:31
记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100479656')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2025-08-01 13:20:31
记录内容:2025-08-01 13:20:31
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2025-08-01 13:20:31
记录内容:1成功120250801005541
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2025-08-01 13:20:31
记录内容:2025-08-01 13:20:31
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2025-08-01 13:32:08
记录内容:cyys_2017@123cyys_2017@12310047965610047965616704168236.04001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2025-08-01 13:32:08
记录内容:'16704168'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2025-08-01 13:32:08
记录内容:2025-08-01 13:32:08
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2025-08-01 13:32:08
记录内容:2025-08-01 13:32:08
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:32:08
记录内容:__________ INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20250801005582','100479656','王从运','一般人员','自费',to_date('2025/08/01 13:32:08','yyyy/mm/dd hh24:mi:ss'),'236.04','236.04','WANG CONG YUN ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:32:08
记录内容:__________ INSERT INTO drug_presc_master_temp (presc_date,presc_no,dispensary,PATIENT_ID,NAME,NAME_PHONETIC,IDENTITY,CHARGE_TYPE,PRESC_TYPE,PRESC_ATTR,PRESC_SOURCE,REPETITION,COSTS,PAYMENTS,ORDERED_BY,PRESCRIBED_BY,ENTERED_BY,DOCTOR_USER,RCPT_NO,COUNT_PER_REPETITION,CLINIC_NO,IS_SEND,SEND_WIN_NO) VALUES (to_date('2025/08/01 13:32:08','yyyy/mm/dd hh24:mi:ss'),'6570','050101','100479656','王从运','WANG CONG YUN ','一般人员','自费','0','门诊处方','0','1','236.04','236.04','0318','HLL','韩露露','HLL','20250801005582','2','202508016139','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:32:08
记录内容:__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2025-08-01 13:32:08', 'yyyy-mm-dd hh24:mi:ss'),'6570','1','11403002441','10g;0.1g','盐酸特比萘芬乳膏','齐鲁制药','10g;0.1g','支','2','17.88','17.88','3;g;外用;2/日','1','1','3','','','','','','0','0','','','','0.0000','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:32:08
记录内容:__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2025-08-01 13:32:08', 'yyyy-mm-dd hh24:mi:ss'),'6570','2','10117003271','0.1g*14','伊曲康唑胶囊','西安杨森','0.1g*14','盒','2','218.16','218.16','.2;g;口服;1/日','2','1','0.2','','','','','','0','0','','','','0.0000','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:32:08
记录内容:__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/8/1 12:02:33','yyyy/mm/dd hh24:mi:ss'),'6591','100479656','1','门诊处方','0318','韩露露','20250801005582','202508016139')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:32:08
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 13:32:08','yyyy/mm/dd hh24:mi:ss'),'6591','20250801005582','1','A','11403002441','盐酸特比萘芬乳膏','10g;0.1g齐鲁制药','2','支','050101','17.88','17.88','0','1','A','032','200','1.0000','8.9400','1','3;g;外用;2/日','0','韩露露','0318','0','盐酸特比萘芬乳膏','11403002441','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:32:08
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/08/01 13:32:08','yyyy/mm/dd hh24:mi:ss'),'6591','20250801005582','2','A','10117003271','伊曲康唑胶囊','0.1g*14西安杨森','2','盒','050101','218.16','218.16','0','1','A','032','200','1.0000','109.0800','2','.2;g;口服;1/日','0','韩露露','0318','0','伊曲康唑胶囊','10117003271','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:32:08
记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250801005582','1','微信','236.04','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:32:08
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16704168' and presc_no = '6570' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:32:08
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16704168' and presc_no = '6570' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:32:08
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16704168'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:32:08
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16704168'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:32:08
记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:32:08
记录内容:__________UPDATE exam_appoints SET costs='144',charges='144',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:32:08
记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100479656'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:32:08
记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100479656' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:32:08
记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100479656'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-08-01 13:32:08
记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100479656')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2025-08-01 13:32:08
记录内容:2025-08-01 13:32:08
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2025-08-01 13:32:08
记录内容:1成功120250801005582
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2025-08-01 13:32:08
记录内容:2025-08-01 13:32:08
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆