◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2025-10-16 08:57:39
记录内容：cyys_2017@123cyys_2017@12310051407210051407217133823130.00001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2025-10-16 08:57:39
记录内容：'17133823'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2025-10-16 08:57:39
记录内容：2025-10-16 08:57:39
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2025-10-16 08:57:39
记录内容：2025-10-16 08:57:39
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 08:57:39
记录内容：1__________ 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 ('20251016005705','100514072','涂远兰','一般人员','自费',to_date('2025/10/16 08:57:39','yyyy/mm/dd hh24:mi:ss'),'130','130','TU YUAN LAN ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 08:57:39
记录内容：1__________ 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/10/15 12:24:27','yyyy/mm/dd hh24:mi:ss'),'4299','100514072','0','','0330','辛俊英','20251016005705','202510157786')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 08:57:39
记录内容：1__________ 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/10/16 08:57:39','yyyy/mm/dd hh24:mi:ss'),'4299','20251016005705','1','D','D1201161','彩色多普勒超声检查(常规)','/','1','部位','0409','110','110','0','1','J','044','150','1.0000','110.0000','1','','0','辛俊英','0330','0','阴式彩色多普勒超声检查','JC0022395','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 08:57:39
记录内容：1__________ 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/10/16 08:57:39','yyyy/mm/dd hh24:mi:ss'),'4299','20251016005705','2','D','D1201163','彩色多普勒超声检查(常规)-腔内检查(加收)','/','1','部位','0409','20','20','0','1','J','044','150','1.0000','20.0000','1','','0','辛俊英','0330','0','阴式彩色多普勒超声检查','JC0022395','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 08:57:39
记录内容：1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20251016005705','1','微信','130','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 08:57:39
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17133823' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 08:57:39
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17133823' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 08:57:39
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17133823' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 08:57:39
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17133823' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 08:57:39
记录内容：2__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17133823'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 08:57:39
记录内容：2__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17133823'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 08:57:39
记录内容：2__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100514072'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 08:57:39
记录内容：2__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100514072' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 08:57:39
记录内容：1__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100514072'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 08:57:39
记录内容：1__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100514072')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2025-10-16 08:57:39
记录内容：2025-10-16 08:57:39
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2025-10-16 08:57:39
记录内容：1成功1620251016005705
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2025-10-16 08:57:39
记录内容：2025-10-16 08:57:39
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2025-10-16 10:15:07
记录内容：cyys_2017@123cyys_2017@123Z00306634Z0030663417135263130.00001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2025-10-16 10:15:07
记录内容：'17135263'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2025-10-16 10:15:07
记录内容：2025-10-16 10:15:07
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2025-10-16 10:15:08
记录内容：2025-10-16 10:15:08
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:15:08
记录内容：1__________ 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 ('20251016006320','Z00306634','李晓晶','一般人员','自费',to_date('2025/10/16 10:15:07','yyyy/mm/dd hh24:mi:ss'),'130','130','LI XIAO JING ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:15:08
记录内容：1__________ 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/10/16 9:54:41','yyyy/mm/dd hh24:mi:ss'),'6838','Z00306634','0','','0371','许春月','20251016006320','202510166195')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:15:08
记录内容：1__________ 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/10/16 10:15:07','yyyy/mm/dd hh24:mi:ss'),'6838','20251016006320','1','D','D1201161','彩色多普勒超声检查(常规)','/','1','部位','0409','110','110','0','1','J','044','150','1.0000','110.0000','1','','0','许春月','0371','0','阴式彩色多普勒超声检查','JC0022395','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:15:08
记录内容：1__________ 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/10/16 10:15:07','yyyy/mm/dd hh24:mi:ss'),'6838','20251016006320','2','D','D1201163','彩色多普勒超声检查(常规)-腔内检查(加收)','/','1','部位','0409','20','20','0','1','J','044','150','1.0000','20.0000','1','','0','许春月','0371','0','阴式彩色多普勒超声检查','JC0022395','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:15:08
记录内容：1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20251016006320','1','微信','130','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:15:08
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17135263' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:15:08
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17135263' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:15:08
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17135263' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:15:08
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17135263' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:15:08
记录内容：2__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17135263'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:15:08
记录内容：2__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17135263'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:15:08
记录内容：1__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5696238'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:15:09
记录内容：1__________UPDATE exam_appoints SET costs='130',charges='130',BILLING_INDICATOR='1' WHERE EXAM_NO = '5696238'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:15:09
记录内容：186__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'Z00306634'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:15:09
记录内容：221__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = 'Z00306634' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:15:09
记录内容：27__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'Z00306634'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:15:09
记录内容：27__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = 'Z00306634')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2025-10-16 10:15:09
记录内容：2025-10-16 10:15:09
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2025-10-16 10:15:09
记录内容：1成功47320251016006320
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2025-10-16 10:15:09
记录内容：2025-10-16 10:15:09
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2025-10-16 10:26:26
记录内容：cyys_2017@123cyys_2017@1231002694061002694061713545817135459202.67001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2025-10-16 10:26:26
记录内容：'17135458','17135459'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2025-10-16 10:26:26
记录内容：2025-10-16 10:26:26
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2025-10-16 10:26:27
记录内容：2025-10-16 10:26:27
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：1__________ 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 ('20251016006398','100269406','王晔','一般人员','自费',to_date('2025/10/16 10:26:26','yyyy/mm/dd hh24:mi:ss'),'202.67','202.67','WANG ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：1__________ 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/10/16 10:01:52','yyyy/mm/dd hh24:mi:ss'),'7160','100269406','0','','0371','许春月','20251016006398','202510166432')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：1__________ 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/10/16 10:26:26','yyyy/mm/dd hh24:mi:ss'),'7160','20251016006398','1','C','H0209015','血清促黄体生成素测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','许春月','0371','0','*性激素三项(生殖科)','JY001307','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：1__________ 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/10/16 10:26:26','yyyy/mm/dd hh24:mi:ss'),'7160','20251016006398','2','C','H0209100','雌二醇测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','许春月','0371','0','*性激素三项(生殖科)','JY001307','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：1__________ 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/10/16 10:26:26','yyyy/mm/dd hh24:mi:ss'),'7160','20251016006398','3','C','H0209103','孕酮测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','许春月','0371','0','*性激素三项(生殖科)','JY001307','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：1__________ 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/10/16 10:01:52','yyyy/mm/dd hh24:mi:ss'),'7161','100269406','0','','0371','许春月','20251016006398','202510166432')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：1__________ 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/10/16 10:26:27','yyyy/mm/dd hh24:mi:ss'),'7161','20251016006398','1','E','E0003052','静脉采血','/','1','次','0371','7','7','0','1','B','016','900','1.0000','7.0000','2','','0','许春月','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：1__________ 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/10/16 10:26:27','yyyy/mm/dd hh24:mi:ss'),'7161','20251016006398','2','E','I0015681','一次性使用静脉血样采集针','J-7软连接式0.7/威高','1','支','0371','0.25','0.25','0','1','J','044','150','1.0000','0.2500','2','','0','许春月','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：1__________ 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/10/16 10:26:27','yyyy/mm/dd hh24:mi:ss'),'7161','20251016006398','3','E','I0015765','一次性使用人体静脉血样采集容器','EDTA-K2 2ml/威海威高','1','支','0371','0.42','0.42','0','1','J','044','150','1.0000','0.4200','2','','0','许春月','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：1__________ 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/10/16 10:26:27','yyyy/mm/dd hh24:mi:ss'),'7161','20251016006398','4','D','D1201157','B型超声检查-腔内检查(加收)','/','1','部位','0371','20','20','0','1','J','044','150','1.0000','20.0000','3','','0','许春月','0371','0','*生殖卵泡监测','JC000924','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：1__________ 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/10/16 10:26:27','yyyy/mm/dd hh24:mi:ss'),'7161','20251016006398','5','D','D1201165','彩色多普勒超声检查(常规)-排卵监测(减收)','/','1','部位','0371','55','55','0','1','J','044','150','1.0000','55.0000','3','','0','许春月','0371','0','*生殖卵泡监测','JC000924','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20251016006398','1','微信','202.67','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17135458' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17135458' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17135458' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17135459' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17135459' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17135459' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17135459' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17135459' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17135458' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17135458' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17135458' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17135459' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17135459' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17135459' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17135459' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17135459' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17135458'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17135458'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17135458'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：5__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17135459'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：5__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17135459'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：5__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17135459'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：5__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17135459'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：5__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17135459'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2510161927'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:27
记录内容：0__________UPDATE exam_appoints SET costs='165.34',charges='165.34',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:28
记录内容：0__________UPDATE exam_appoints SET costs='120',charges='120',BILLING_INDICATOR='1' WHERE EXAM_NO = '2510161927'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:28
记录内容：33__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100269406'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:28
记录内容：39__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100269406' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:28
记录内容：8__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100269406'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 10:26:28
记录内容：8__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100269406')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2025-10-16 10:26:28
记录内容：2025-10-16 10:26:28
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2025-10-16 10:26:28
记录内容：1成功14120251016006398
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2025-10-16 10:26:28
记录内容：2025-10-16 10:26:28
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2025-10-16 13:09:20
记录内容：cyys_2017@123cyys_2017@1231004092271004092271713672717136728171367301210.00001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2025-10-16 13:09:20
记录内容：'17136727','17136728','17136730'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2025-10-16 13:09:20
记录内容：2025-10-16 13:09:20
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2025-10-16 13:09:20
记录内容：2025-10-16 13:09:20
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:20
记录内容：1__________ 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 ('20251016007167','100409227','任家鑫','一般人员','自费',to_date('2025/10/16 13:09:20','yyyy/mm/dd hh24:mi:ss'),'1210','1210','REN JIA ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:20
记录内容：1__________ 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/10/16 12:48:57','yyyy/mm/dd hh24:mi:ss'),'9214','100409227','0','','0303','夏德雨','20251016007167','202510164904')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:20
记录内容：1__________ 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/10/16 13:09:20','yyyy/mm/dd hh24:mi:ss'),'9214','20251016007167','1','D','D1201238','磁共振(MR)平扫','/','1','部位','0406','450','450','0','1','J','044','150','1.0000','450.0000','1','','0','夏德雨','0303','0','颅脑磁共振平扫+磁共振弥散成像+颅脑磁敏感加权成像','JC0022543','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:20
记录内容：1__________ 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/10/16 13:09:20','yyyy/mm/dd hh24:mi:ss'),'9214','20251016007167','2','D','D1201239','磁共振(MR)平扫-特殊方式成像(加收)','/','1','项','0406','50','50','0','1','J','044','150','1.0000','50.0000','1','','0','夏德雨','0303','0','颅脑磁共振平扫+磁共振弥散成像+颅脑磁敏感加权成像','JC0022543','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:20
记录内容：1__________ 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/10/16 13:09:20','yyyy/mm/dd hh24:mi:ss'),'9214','20251016007167','3','D','D1201239','磁共振(MR)平扫-特殊方式成像(加收)','/','1','项','0406','50','50','0','1','J','044','150','1.0000','50.0000','1','','0','夏德雨','0303','0','颅脑磁共振平扫+磁共振弥散成像+颅脑磁敏感加权成像','JC0022543','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:20
记录内容：1__________ 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/10/16 12:48:57','yyyy/mm/dd hh24:mi:ss'),'9215','100409227','0','','0303','夏德雨','20251016007167','202510164904')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:20
记录内容：1__________ 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/10/16 13:09:20','yyyy/mm/dd hh24:mi:ss'),'9215','20251016007167','1','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-10-16 13:09:20
记录内容：1__________ 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/10/16 12:48:57','yyyy/mm/dd hh24:mi:ss'),'9216','100409227','0','','0303','夏德雨','20251016007167','202510164904')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：1__________ 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/10/16 13:09:20','yyyy/mm/dd hh24:mi:ss'),'9216','20251016007167','1','D','D1201201','多普勒检查(颅内血管)-栓子监测(扩展)','/','1','次','030301','70','70','0','1','J','044','150','1.0000','70.0000','3','','0','夏德雨','0303','0','*经颅多普勒超声栓子监测','JC001190','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：1__________ 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/10/16 13:09:20','yyyy/mm/dd hh24:mi:ss'),'9216','20251016007167','2','D','D1201197','多普勒检查(颅内血管)','/','1','次','030301','70','70','0','1','J','044','150','1.0000','70.0000','4','','0','夏德雨','0303','0','*颅内多普勒检查','JC000933','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20251016007167','1','微信','1210','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17136727' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17136727' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17136727' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17136728' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17136730' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17136730' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17136727' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17136727' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17136727' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17136728' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17136730' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17136730' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17136727'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17136727'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17136727'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：1__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17136728'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：2__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17136730'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：2__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17136730'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：0__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100409227'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：0__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100409227' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：5__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100409227'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:09:21
记录内容：6__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100409227')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2025-10-16 13:09:21
记录内容：2025-10-16 13:09:21
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2025-10-16 13:09:21
记录内容：1成功4120251016007167
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2025-10-16 13:09:21
记录内容：2025-10-16 13:09:21
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2025-10-16 13:23:50
记录内容：cyys_2017@123cyys_2017@12310026940610026940617136854171368571713686017136865328.17001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2025-10-16 13:23:50
记录内容：'17136854','17136857','17136860','17136865'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2025-10-16 13:23:50
记录内容：2025-10-16 13:23:50
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2025-10-16 13:23:50
记录内容：2025-10-16 13:23:50
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:50
记录内容：1__________ 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 ('20251016007235','100269406','王晔','一般人员','自费',to_date('2025/10/16 13:23:50','yyyy/mm/dd hh24:mi:ss'),'328.17','328.17','WANG ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:50
记录内容：1__________ 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/10/16 13:23:50','yyyy/mm/dd hh24:mi:ss'),'9376','050111','100269406','王晔','WANG ','一般人员','自费','0','门诊处方','0','1','22.31','22.31','0371','XUCY','许春月','XUCY','20251016007235','1','202510166432','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:50
记录内容：1__________ 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/10/16 13:23:50','yyyy/mm/dd hh24:mi:ss'),'9381','050111','100269406','王晔','WANG ','一般人员','自费','0','门诊处方','0','1','221.86','221.86','0371','XUCY','许春月','XUCY','20251016007235','1','202510166432','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:50
记录内容：1__________ 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-10-16 13:23:50', 'yyyy-mm-dd hh24:mi:ss'),'9376','1','11002023670','75u','注射用尿促性素','丽珠集团','75u','瓶','1','22.31','22.31','75;u;肌肉注射;1/日','1','1','75','','','','','','0','0','','','','0.0000','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:50
记录内容：1__________ 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-10-16 13:23:50', 'yyyy-mm-dd hh24:mi:ss'),'9381','1','11002030680','250ug;0.5ml','重组人绒促性素注射液','意大利 M','250ug;0.5ml','支','1','221.86','221.86','250;ug;皮下注射;1/日','2','1','250','','','','','','0','0','','','','0.0000','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:50
记录内容：1__________ 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/10/16 10:01:52','yyyy/mm/dd hh24:mi:ss'),'9413','100269406','1','门诊处方','0371','许春月','20251016007235','202510166432')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:50
记录内容：1__________ 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/10/16 13:23:50','yyyy/mm/dd hh24:mi:ss'),'9413','20251016007235','1','A','11002023670','注射用尿促性素','75u丽珠集团','1','瓶','050111','22.31','22.31','0','1','A','032','200','1.0000','22.3100','1','75;u;肌肉注射;1/日','0','许春月','0371','0','注射用尿促性素','11002023670','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:50
记录内容：1__________ 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/10/16 10:01:52','yyyy/mm/dd hh24:mi:ss'),'9414','100269406','1','门诊处方','0371','许春月','20251016007235','202510166432')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:50
记录内容：1__________ 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/10/16 13:23:50','yyyy/mm/dd hh24:mi:ss'),'9414','20251016007235','1','A','11002030680','重组人绒促性素注射液','250ug;0.5ml意大利 M','1','支','050111','221.86','221.86','0','1','J','044','150','1.0000','221.8600','1','250;ug;皮下注射;1/日','0','许春月','0371','0','重组人绒促性素注射液','11002030680','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:50
记录内容：1__________ 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/10/16 10:01:52','yyyy/mm/dd hh24:mi:ss'),'9415','100269406','0','','0371','许春月','20251016007235','202510166432')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:50
记录内容：1__________ 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/10/16 13:23:50','yyyy/mm/dd hh24:mi:ss'),'9415','20251016007235','1','D','D1201157','B型超声检查-腔内检查(加收)','/','1','部位','0371','20','20','0','1','J','044','150','1.0000','20.0000','4','','0','许春月','0371','0','*生殖卵泡监测','JC000924','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:50
记录内容：1__________ 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/10/16 13:23:50','yyyy/mm/dd hh24:mi:ss'),'9415','20251016007235','2','D','D1201165','彩色多普勒超声检查(常规)-排卵监测(减收)','/','1','部位','0371','55','55','0','1','J','044','150','1.0000','55.0000','4','','0','许春月','0371','0','*生殖卵泡监测','JC000924','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:50
记录内容：1__________ 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/10/16 10:01:52','yyyy/mm/dd hh24:mi:ss'),'9416','100269406','0','','0371','许春月','20251016007235','202510166432')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:50
记录内容：1__________ 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/10/16 13:23:50','yyyy/mm/dd hh24:mi:ss'),'9416','20251016007235','1','E','E0003040','肌肉注射','/','1','次','0371','4.5','4.5','0','1','J','044','150','1.0000','4.5000','5','','0','许春月','0371','0','肌肉注射','E0003040','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:50
记录内容：1__________ 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/10/16 13:23:50','yyyy/mm/dd hh24:mi:ss'),'9416','20251016007235','2','E','E0003054','皮下注射','/','1','次','0371','4.5','4.5','0','1','J','044','150','1.0000','4.5000','6','','0','许春月','0371','0','皮下注射','E0003052','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:50
记录内容：1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20251016007235','1','微信','328.17','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:50
记录内容：1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17136854' and presc_no = '9376' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:50
记录内容：1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17136857' and presc_no = '9381' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:50
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17136860' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:50
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17136860' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:50
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17136865' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:50
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17136865' and presc_no = '0' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:51
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17136860' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:51
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17136860' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:51
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17136865' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:51
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17136865' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:51
记录内容：1__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17136854'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:51
记录内容：1__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17136857'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:51
记录内容：2__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17136860'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:51
记录内容：2__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17136860'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:51
记录内容：2__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17136865'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:51
记录内容：2__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17136865'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:51
记录内容：0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:51
记录内容：0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2510161927'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:51
记录内容：0__________UPDATE exam_appoints SET costs='258.34',charges='258.34',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:51
记录内容：0__________UPDATE exam_appoints SET costs='120',charges='120',BILLING_INDICATOR='1' WHERE EXAM_NO = '2510161927'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:51
记录内容：34__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100269406'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:51
记录内容：40__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100269406' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:51
记录内容：8__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100269406'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:23:51
记录内容：8__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100269406')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2025-10-16 13:23:51
记录内容：2025-10-16 13:23:51
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2025-10-16 13:23:51
记录内容：1成功12120251016007235
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2025-10-16 13:23:51
记录内容：2025-10-16 13:23:51
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2025-10-16 13:32:06
记录内容：cyys_2017@123cyys_2017@12310040922710040922717136919330.00001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2025-10-16 13:32:06
记录内容：'17136919'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2025-10-16 13:32:07
记录内容：2025-10-16 13:32:07
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2025-10-16 13:32:07
记录内容：2025-10-16 13:32:07
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:32:07
记录内容：1__________ 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 ('20251016007284','100409227','任家鑫','一般人员','自费',to_date('2025/10/16 13:32:07','yyyy/mm/dd hh24:mi:ss'),'330','330','REN JIA ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:32:07
记录内容：1__________ 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/10/16 12:48:57','yyyy/mm/dd hh24:mi:ss'),'9537','100409227','0','','0303','夏德雨','20251016007284','202510164904')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:32:07
记录内容：1__________ 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/10/16 13:32:07','yyyy/mm/dd hh24:mi:ss'),'9537','20251016007284','1','D','D0900004','特殊脑电图','/','1','次','030301','65','65','0','1','J','008','150','1.0000','65.0000','5','','0','夏德雨','0303','0','脑ET(脑电图+脑地形图)','JC001463','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:32:07
记录内容：1__________ 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/10/16 13:32:07','yyyy/mm/dd hh24:mi:ss'),'9537','20251016007284','2','D','D0900005','脑地形图','/','1','次','030301','70','70','0','1','J','008','150','1.0000','70.0000','5','','0','夏德雨','0303','0','脑ET(脑电图+脑地形图)','JC001463','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:32:07
记录内容：1__________ 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/10/16 13:32:07','yyyy/mm/dd hh24:mi:ss'),'9537','20251016007284','3','D','D0900004','特殊脑电图','/','3','次','030301','195','195','0','1','J','008','150','1.0000','65.0000','6','','0','夏德雨','0303','0','脑电图检查(清醒+闪光刺激+蝶骨电极+睡眠诱导)','JC001460','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:32:07
记录内容：1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20251016007284','1','微信','330','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:32:07
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17136919' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:32:07
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17136919' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:32:07
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17136919' and presc_no = '0' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:32:07
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17136919' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:32:07
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17136919' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:32:07
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17136919' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:32:07
记录内容：3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17136919'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:32:07
记录内容：3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17136919'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:32:07
记录内容：3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17136919'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:32:07
记录内容：0__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100409227'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:32:07
记录内容：0__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100409227' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:32:07
记录内容：6__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100409227'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-10-16 13:32:07
记录内容：8__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100409227')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2025-10-16 13:32:07
记录内容：2025-10-16 13:32:07
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2025-10-16 13:32:07
记录内容：1成功3120251016007284
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2025-10-16 13:32:07
记录内容：2025-10-16 13:32:07
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆