◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2026-02-10 09:33:20
记录内容:cyys_2017@123cyys_2017@12310411336104113361784770717847713120.00001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2026-02-10 09:33:20
记录内容:'17847707','17847713'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2026-02-10 09:33:20
记录内容:2026-02-10 09:33:20
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2026-02-10 09:33:20
记录内容:2026-02-10 09:33:20
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:33: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 ('20260210016928','10411336','刘传芳','一般人员','自费',to_date('2026/02/10 09:33:20','yyyy/mm/dd hh24:mi:ss'),'120','120','LIU CHUAN FANG ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:33: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('2026/2/10 8:12:08','yyyy/mm/dd hh24:mi:ss'),'9478','10411336','0','','0354','王鹏飞','20260210016928','202602101574')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:33: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('2026/02/10 09:33:20','yyyy/mm/dd hh24:mi:ss'),'9478','20260210016928','1','D','D1201172','彩色多普勒超声检查(血管)','/','1','部位','0409','80','80','0','1','J','006','150','1.0000','80.0000','1','','0','王鹏飞','0354','0','右下肢静脉彩色多普勒超声检查','JC0022441','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:33: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('2026/2/10 8:12:08','yyyy/mm/dd hh24:mi:ss'),'9479','10411336','0','','0354','王鹏飞','20260210016928','202602101574')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:33: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('2026/02/10 09:33:20','yyyy/mm/dd hh24:mi:ss'),'9479','20260210016928','1','D','D1201203','彩色多普勒超声检查(血管)-从第二个部位开始,每个部位按50%收费,累计收费不超过360元','/','1','部位','0409','40','40','0','1','J','006','150','1.0000','40.0000','2','','0','王鹏飞','0354','0','左下肢静脉彩色多普勒超声检查(减收)','JC0022506','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:33:20
记录内容:1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20260210016928','1','微信','120','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:33:20
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17847707' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:33:20
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17847713' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:33:20
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17847707' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:33:20
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17847713' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:33:20
记录内容:1__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17847707'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:33:20
记录内容:1__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17847713'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:33:20
记录内容:2__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10411336'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:33:20
记录内容:2__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10411336' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:33:20
记录内容:8__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10411336'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:33:20
记录内容:9__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10411336')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2026-02-10 09:33:20
记录内容:2026-02-10 09:33:20
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2026-02-10 09:33:20
记录内容:1成功3020260210016928
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2026-02-10 09:33:20
记录内容:2026-02-10 09:33:20
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2026-02-10 09:54:00
记录内容:cyys_2017@123cyys_2017@1231004954491004954491784800220.00001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2026-02-10 09:54:00
记录内容:'17848002'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2026-02-10 09:54:00
记录内容:2026-02-10 09:54:00
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2026-02-10 09:54:00
记录内容:2026-02-10 09:54:00
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:54:00
记录内容: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 ('20260210017016','100495449','刘明阳','一般人员','廊坊居民',to_date('2026/02/10 09:54:00','yyyy/mm/dd hh24:mi:ss'),'20','20','LIU MING YANG ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:54:00
记录内容: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('2026/2/10 7:52:50','yyyy/mm/dd hh24:mi:ss'),'101','100495449','0','','0330','周雪静','20260210017016','202602106787')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:54:00
记录内容: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('2026/02/10 09:54:00','yyyy/mm/dd hh24:mi:ss'),'101','20260210017016','1','E','C0000035','特需服务费','/','0.1','项','0330','20','20','0','1','O','028','220','1.0000','200.0000','1','','0','周雪静','0330','0','特需服务费','C00000035','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:54:00
记录内容:1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20260210017016','1','微信','20','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:54:00
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17848002' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:54:00
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17848002' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:54:01
记录内容:1__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17848002'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:54:01
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:54:01
记录内容:0__________UPDATE exam_appoints SET costs='20',charges='20',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:54:01
记录内容:82__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100495449'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:54:01
记录内容:98__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100495449' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:54:01
记录内容:22__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100495449'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 09:54:01
记录内容:24__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100495449')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2026-02-10 09:54:01
记录内容:2026-02-10 09:54:01
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2026-02-10 09:54:01
记录内容:1成功23120260210017016
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2026-02-10 09:54:01
记录内容:2026-02-10 09:54:01
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2026-02-10 10:31:48
记录内容:cyys_2017@123cyys_2017@12310036368110036368117848458178484591784846224.72001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2026-02-10 10:31:48
记录内容:'17848458','17848459','17848462'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2026-02-10 10:31:48
记录内容:2026-02-10 10:31:48
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2026-02-10 10:31:48
记录内容:2026-02-10 10:31:48
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容: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 ('20260210017329','100363681','刘娟','一般人员','自费',to_date('2026/02/10 10:31:48','yyyy/mm/dd hh24:mi:ss'),'24.72','24.72','LIU JUAN ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容: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('2026/2/10 7:49:03','yyyy/mm/dd hh24:mi:ss'),'1150','100363681','0','','0330','林晶晶','20260210017329','202602106765')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容: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('2026/02/10 10:31:48','yyyy/mm/dd hh24:mi:ss'),'1150','20260210017329','1','C','H0201028','血细胞分析(五分类收)','/','1','项','0411','11','11','0','1','M','025','190','1.0000','11.0000','3','','0','林晶晶','0330','0','*血常规','21313','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容: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('2026/2/10 7:49:03','yyyy/mm/dd hh24:mi:ss'),'1151','100363681','0','','0330','林晶晶','20260210017329','202602106765')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容: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('2026/02/10 10:31:48','yyyy/mm/dd hh24:mi:ss'),'1151','20260210017329','1','C','H0001049','尿液分析','/','1','次','0411','6','6','0','1','M','025','190','1.0000','6.0000','4','','0','林晶晶','0330','0','尿常规','JY001411','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容: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('2026/2/10 7:49:03','yyyy/mm/dd hh24:mi:ss'),'1152','100363681','0','','0330','林晶晶','20260210017329','202602106765')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容: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('2026/02/10 10:31:48','yyyy/mm/dd hh24:mi:ss'),'1152','20260210017329','1','J','I0015681','一次性使用静脉血样采集针','J-7软连接式0.7/威高','1','支','0330','0.25','0.25','0','1','L','031','170','1.0000','0.2500','5','','0','林晶晶','0330','0','一次性使用静脉血样采集针','I0015681','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容: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('2026/02/10 10:31:48','yyyy/mm/dd hh24:mi:ss'),'1152','20260210017329','2','J','I0015763','一次性使用人体静脉血样采集容器','促凝剂+分离胶5ml/威海威高','1','支','0330','0.47','0.47','0','1','L','031','170','1.0000','0.4700','6','','0','林晶晶','0330','0','一次性使用人体静脉血样采集容器','I0015763','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容: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('2026/02/10 10:31:48','yyyy/mm/dd hh24:mi:ss'),'1152','20260210017329','3','E','E0003052','静脉采血','/','1','次','0330','7','7','0','1','B','016','900','1.0000','7.0000','7','','0','林晶晶','0330','0','静脉采血','ZL000585','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容:1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20260210017329','1','微信','24.72','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17848458' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17848459' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17848462' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17848462' and presc_no = '0' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17848462' and presc_no = '0' and item_no = '7'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17848458' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17848459' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17848462' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17848462' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17848462' and item_no = '7'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容:1__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17848458'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容:1__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17848459'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17848462'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17848462'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17848462'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容:1__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5863995'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:48
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2602100215'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:49
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101235'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:49
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101251'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:49
记录内容:0__________UPDATE exam_appoints SET costs='23.16',charges='23.16',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:49
记录内容:1__________UPDATE exam_appoints SET costs='160',charges='160',BILLING_INDICATOR='1' WHERE EXAM_NO = '5863995'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:50
记录内容:0__________UPDATE exam_appoints SET costs='6',charges='6',BILLING_INDICATOR='1' WHERE EXAM_NO = '2602100215'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:50
记录内容:0__________UPDATE exam_appoints SET costs='11',charges='11',BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101235'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:51
记录内容:0__________UPDATE exam_appoints SET costs='6',charges='6',BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101251'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:51
记录内容:69__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100363681'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:51
记录内容:74__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100363681' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:51
记录内容:23__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100363681'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:31:51
记录内容:27__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100363681')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2026-02-10 10:31:51
记录内容:2026-02-10 10:31:51
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2026-02-10 10:31:51
记录内容:1成功22020260210017329
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2026-02-10 10:31:51
记录内容:2026-02-10 10:31:51
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2026-02-10 10:38:47
记录内容:cyys_2017@123cyys_2017@12310053698510053698517848851178488541784885517848856241.00001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2026-02-10 10:38:47
记录内容:'17848851','17848854','17848855','17848856'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2026-02-10 10:38:47
记录内容:2026-02-10 10:38:47
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2026-02-10 10:38:47
记录内容:2026-02-10 10:38:47
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:47
记录内容: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 ('20260210017339','100536985','张一凡','一般人员','自费',to_date('2026/02/10 10:38:47','yyyy/mm/dd hh24:mi:ss'),'241','241','ZHANG YI FAN ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:47
记录内容: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('2026/2/10 10:20:53','yyyy/mm/dd hh24:mi:ss'),'1358','100536985','0','','0304','陈树新','20260210017339','20260210851')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:47
记录内容: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('2026/02/10 10:38:47','yyyy/mm/dd hh24:mi:ss'),'1358','20260210017339','1','D','D1201206','X线摄影成像','/','1','部位·体','0404','40','40','0','1','J','005','160','1.0000','40.0000','1','','0','陈树新','0304','0','左手正位(测骨龄)','JC0022952','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:47
记录内容: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('2026/2/10 10:20:53','yyyy/mm/dd hh24:mi:ss'),'1359','100536985','0','','0304','陈树新','20260210017339','20260210851')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:47
记录内容: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('2026/02/10 10:38:47','yyyy/mm/dd hh24:mi:ss'),'1359','20260210017339','1','C','H0208025','25-羟维生素D测定(25羟维生素D:化学发光法)','/','1','项','0435','80','80','0','1','M','025','190','1.0000','80.0000','2','','0','陈树新','0304','0','*25-羟维生素D检测','JY000115','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:47
记录内容: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('2026/2/10 10:20:53','yyyy/mm/dd hh24:mi:ss'),'1360','100536985','0','','0304','陈树新','20260210017339','20260210851')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:47
记录内容: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('2026/02/10 10:38:47','yyyy/mm/dd hh24:mi:ss'),'1360','20260210017339','1','C','H0209158','血清反T3测定化学发光法','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','3','','0','陈树新','0304','0','血清反T3测定(外检)','JY001556','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:47
记录内容: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('2026/2/10 10:20:53','yyyy/mm/dd hh24:mi:ss'),'1361','100536985','0','','0304','陈树新','20260210017339','20260210851')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:47
记录内容: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('2026/02/10 10:38:47','yyyy/mm/dd hh24:mi:ss'),'1361','20260210017339','1','C','H0301133','抗甲状腺球蛋白抗体测定(TGAb)','/','1','项','0411','25','25','0','1','M','025','190','1.0000','25.0000','4','','0','陈树新','0304','0','*甲状腺抗体二项','JY000143','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:47
记录内容: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('2026/02/10 10:38:47','yyyy/mm/dd hh24:mi:ss'),'1361','20260210017339','2','C','H0301139','甲状腺过氧化物酶抗体测定化学发光法','/','1','项','0411','56','56','0','1','M','025','190','1.0000','56.0000','4','','0','陈树新','0304','0','*甲状腺抗体二项','JY000143','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:47
记录内容:1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20260210017339','1','微信','241','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:47
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17848851' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:48
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17848854' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:48
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17848855' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:48
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17848856' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:48
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17848856' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:48
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17848851' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:48
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17848854' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:48
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17848855' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:48
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17848856' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:48
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17848856' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:48
记录内容:1__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17848851'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:48
记录内容:1__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17848854'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:48
记录内容:1__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17848855'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:48
记录内容:2__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17848856'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:48
记录内容:2__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17848856'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:48
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101350'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:48
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:48
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101348'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:48
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101366'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:48
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101365'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:48
记录内容:1__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5864583'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:48
记录内容:0__________UPDATE exam_appoints SET costs='40',charges='40',BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101350'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:48
记录内容:0__________UPDATE exam_appoints SET costs='36.15',charges='36.15',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:49
记录内容:0__________UPDATE exam_appoints SET costs='80',charges='80',BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101348'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:49
记录内容:0__________UPDATE exam_appoints SET costs='55',charges='55',BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101366'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:50
记录内容:0__________UPDATE exam_appoints SET costs='81',charges='81',BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101365'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:50
记录内容:1__________UPDATE exam_appoints SET costs='40',charges='40',BILLING_INDICATOR='1' WHERE EXAM_NO = '5864583'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:50
记录内容:4__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100536985'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:50
记录内容:4__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100536985' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:50
记录内容:1__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100536985'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 10:38:50
记录内容:1__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100536985')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2026-02-10 10:38:50
记录内容:2026-02-10 10:38:50
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2026-02-10 10:38:50
记录内容:1成功3420260210017339
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2026-02-10 10:38:50
记录内容:2026-02-10 10:38:50
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2026-02-10 14:24:11
记录内容:cyys_2017@123cyys_2017@12310053698510053698517850596178488581784886183.95001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2026-02-10 14:24:11
记录内容:'17850596','17848858','17848861'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2026-02-10 14:24:11
记录内容:2026-02-10 14:24:11
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2026-02-10 14:24:11
记录内容:2026-02-10 14:24:11
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容: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 ('20260210018471','100536985','张一凡','一般人员','自费',to_date('2026/02/10 14:24:11','yyyy/mm/dd hh24:mi:ss'),'83.95','83.95','ZHANG YI FAN ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容: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('2026/02/10 14:24:11','yyyy/mm/dd hh24:mi:ss'),'4289','050101','100536985','张一凡','ZHANG YI FAN ','一般人员','自费','0','门诊处方','0','1','16.90','16.90','0304','EYCSX','陈树新','EYCSX','20260210018471','1','202602101949','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容: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('2026-02-10 14:24:11', 'yyyy-mm-dd hh24:mi:ss'),'4289','1','11301040680','1ml:5mg(20万iu)','维生素D2注射液','赣南海欣','1ml:5mg(20万iu)','支','1','16.9','16.9','1;ml;肌肉注射;1/4周','1','1','1','','','','','','0','0','','','','0.0000','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容: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('2026/2/10 10:20:53','yyyy/mm/dd hh24:mi:ss'),'4298','100536985','0','','0304','陈树新','20260210018471','20260210851')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容: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('2026/02/10 14:24:11','yyyy/mm/dd hh24:mi:ss'),'4298','20260210018471','1','C','H0203038','微量元素测定','/','2','项','0411','16','16','0','1','M','025','190','1.0000','8.0000','5','','0','陈树新','0304','0','全血微量元素6项(外检)','JY001977','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容: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('2026/02/10 14:24:11','yyyy/mm/dd hh24:mi:ss'),'4298','20260210018471','2','C','H0203013','钙测定(离子选择电极法)','/','1','项','0411','10','10','0','1','M','025','190','1.0000','10.0000','5','','0','陈树新','0304','0','全血微量元素6项(外检)','JY001977','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容: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('2026/02/10 14:24:11','yyyy/mm/dd hh24:mi:ss'),'4298','20260210018471','3','C','H0203022','镁测定(离子选择电极法)','/','1','项','0411','10','10','0','1','M','025','190','1.0000','10.0000','5','','0','陈树新','0304','0','全血微量元素6项(外检)','JY001977','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容: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('2026/02/10 14:24:11','yyyy/mm/dd hh24:mi:ss'),'4298','20260210018471','4','C','H0203027','铁测定(离子选择电极法)','/','1','项','0411','10','10','0','1','M','025','190','1.0000','10.0000','5','','0','陈树新','0304','0','全血微量元素6项(外检)','JY001977','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容: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('2026/02/10 14:24:11','yyyy/mm/dd hh24:mi:ss'),'4298','20260210018471','5','C','H0203029','全血铅测定','/','1','项','0411','9','9','0','1','M','025','190','1.0000','9.0000','5','','0','陈树新','0304','0','全血微量元素6项(外检)','JY001977','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容: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('2026/2/10 10:20:53','yyyy/mm/dd hh24:mi:ss'),'4299','100536985','0','','0304','陈树新','20260210018471','20260210851')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容: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('2026/02/10 14:24:11','yyyy/mm/dd hh24:mi:ss'),'4299','20260210018471','1','E','E0003052','静脉采血','/','1','次','0304','7','7','0','1','B','016','900','1.0000','7.0000','6','','0','陈树新','0304','0','静脉采血','ZL000585','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容: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('2026/02/10 14:24:11','yyyy/mm/dd hh24:mi:ss'),'4299','20260210018471','2','J','I0015680','一次性使用静脉血样采集针','S-7软连接式0.7/威高','1','支','0304','0.25','0.25','0','1','L','031','170','1.0000','0.2500','7','','0','陈树新','0304','0','一次性使用静脉血样采集针','I0015680','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容: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('2026/02/10 14:24:11','yyyy/mm/dd hh24:mi:ss'),'4299','20260210018471','3','J','I0017000','真空采血管','2.7ml/碧迪','4','个','0304','4.8','4.8','0','1','L','031','170','1.0000','1.2000','8','','0','陈树新','0304','0','真空采血管','I0017000','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容: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('2026/2/10 10:20:53','yyyy/mm/dd hh24:mi:ss'),'4300','100536985','1','门诊处方','0304','陈树新','20260210018471','20260210851')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容: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('2026/02/10 14:24:11','yyyy/mm/dd hh24:mi:ss'),'4300','20260210018471','1','A','11301040680','维生素D2注射液','1ml:5mg(20万iu)赣南海欣','1','支','050101','16.9','16.9','0','1','A','032','200','1.0000','16.9000','1','1;ml;肌肉注射;1/4周','0','陈树新','0304','0','维生素D2注射液','11301040680','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容:1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20260210018471','1','微信','83.95','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17848858' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17848858' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17848858' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17848858' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17848858' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17848861' and presc_no = '0' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17848861' and presc_no = '0' and item_no = '7'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17848861' and presc_no = '0' and item_no = '8'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容:1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17850596' and presc_no = '4289' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17848858' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17848858' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17848858' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17848858' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17848858' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17848861' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17848861' and item_no = '7'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17848861' and item_no = '8'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容:5__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17848858'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容:5__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17848858'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:11
记录内容:5__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17848858'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:12
记录内容:5__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17848858'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:12
记录内容:5__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17848858'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:12
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17848861'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:12
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17848861'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:12
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17848861'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:12
记录内容:1__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17850596'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:12
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101350'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:12
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:12
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101348'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:12
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101366'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:12
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101365'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:12
记录内容:1__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5864583'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:12
记录内容:0__________UPDATE exam_appoints SET costs='40',charges='40',BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101350'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:12
记录内容:0__________UPDATE exam_appoints SET costs='36.15',charges='36.15',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:13
记录内容:0__________UPDATE exam_appoints SET costs='80',charges='80',BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101348'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:13
记录内容:0__________UPDATE exam_appoints SET costs='55',charges='55',BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101366'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:13
记录内容:0__________UPDATE exam_appoints SET costs='81',charges='81',BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101365'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:14
记录内容:1__________UPDATE exam_appoints SET costs='40',charges='40',BILLING_INDICATOR='1' WHERE EXAM_NO = '5864583'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:14
记录内容:8__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100536985'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:14
记录内容:8__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100536985' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:14
记录内容:1__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100536985'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:24:14
记录内容:1__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100536985')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2026-02-10 14:24:14
记录内容:2026-02-10 14:24:14
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2026-02-10 14:24:14
记录内容:1成功7920260210018471
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2026-02-10 14:24:14
记录内容:2026-02-10 14:24:14
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2026-02-10 14:30:14
记录内容:cyys_2017@123cyys_2017@12310053698510053698517850600178505971785060217850604103.27001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2026-02-10 14:30:14
记录内容:'17850600','17850597','17850602','17850604'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2026-02-10 14:30:14
记录内容:2026-02-10 14:30:14
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2026-02-10 14:30:14
记录内容:2026-02-10 14:30:14
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容: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 ('20260210018479','100536985','张一凡','一般人员','自费',to_date('2026/02/10 14:30:14','yyyy/mm/dd hh24:mi:ss'),'103.27','103.27','ZHANG YI FAN ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容: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('2026/02/10 14:30:14','yyyy/mm/dd hh24:mi:ss'),'4311','050101','100536985','张一凡','ZHANG YI FAN ','一般人员','自费','0','门诊处方','0','1','6.32','6.32','0304','EYCSX','陈树新','EYCSX','20260210018479','1','202602101949','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容: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('2026-02-10 14:30:14', 'yyyy-mm-dd hh24:mi:ss'),'4311','1','11401057270','0.25ug*20','骨化三醇软胶囊(0.25ug*20)','四川国为','0.25ug*20','盒','1','6.32','6.32','.25;ug;口服;1/日','2','1','0.25','','','','','','0','0','','','','0.0000','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容: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('2026/2/10 10:20:53','yyyy/mm/dd hh24:mi:ss'),'4392','100536985','0','','0304','陈树新','20260210018479','20260210851')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容: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('2026/02/10 14:30:14','yyyy/mm/dd hh24:mi:ss'),'4392','20260210018479','1','E','E0003040','肌肉注射','/','1','次','0304','4.5','4.5','0','1','B','016','900','1.0000','4.5000','9','','0','陈树新','0304','0','肌肉注射','E0003040','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容: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('2026/02/10 14:30:14','yyyy/mm/dd hh24:mi:ss'),'4392','20260210018479','2','E','C0000016','门急诊留观诊查费','/','1','小时','0304','4','4','0','1','B','016','900','1.0000','4.0000','10','','0','陈树新','0304','0','门急诊留观诊查费(小时)','ZL000003','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容: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('2026/2/10 10:20:53','yyyy/mm/dd hh24:mi:ss'),'4393','100536985','1','门诊处方','0304','陈树新','20260210018479','20260210851')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容: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('2026/02/10 14:30:14','yyyy/mm/dd hh24:mi:ss'),'4393','20260210018479','1','A','11401057270','骨化三醇软胶囊(0.25ug*20)','0.25ug*20四川国为','1','盒','050101','6.32','6.32','0','1','A','032','200','1.0000','6.3200','1','.25;ug;口服;1/日','0','陈树新','0304','0','骨化三醇软胶囊(0.25ug*20)','11401057270','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容: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('2026/2/10 10:20:53','yyyy/mm/dd hh24:mi:ss'),'4394','100536985','0','','0304','陈树新','20260210018479','20260210851')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容: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('2026/02/10 14:30:14','yyyy/mm/dd hh24:mi:ss'),'4394','20260210018479','1','C','H0208025','25-羟维生素D测定(25羟维生素D:化学发光法)','/','1','项','0435','80','80','0','1','M','025','190','1.0000','80.0000','11','','0','陈树新','0304','0','*25-羟维生素D检测','JY000115','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容: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('2026/2/10 10:20:53','yyyy/mm/dd hh24:mi:ss'),'4395','100536985','0','','0304','陈树新','20260210018479','20260210851')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容: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('2026/02/10 14:30:14','yyyy/mm/dd hh24:mi:ss'),'4395','20260210018479','1','E','E0003052','静脉采血','/','1','次','0304','7','7','0','1','B','016','900','1.0000','7.0000','12','','0','陈树新','0304','0','静脉采血','ZL000585','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容: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('2026/02/10 14:30:14','yyyy/mm/dd hh24:mi:ss'),'4395','20260210018479','2','J','I0015680','一次性使用静脉血样采集针','S-7软连接式0.7/威高','1','支','0304','0.25','0.25','0','1','L','031','170','1.0000','0.2500','13','','0','陈树新','0304','0','一次性使用静脉血样采集针','I0015680','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容: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('2026/02/10 14:30:14','yyyy/mm/dd hh24:mi:ss'),'4395','20260210018479','3','J','I0017000','真空采血管','2.7ml/碧迪','1','个','0304','1.2','1.2','0','1','L','031','170','1.0000','1.2000','14','','0','陈树新','0304','0','真空采血管','I0017000','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20260210018479','1','微信','103.27','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17850597' and presc_no = '0' and item_no = '9'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17850597' and presc_no = '0' and item_no = '10'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17850600' and presc_no = '4311' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17850602' and presc_no = '0' and item_no = '11'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17850604' and presc_no = '0' and item_no = '12'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17850604' and presc_no = '0' and item_no = '13'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17850604' and presc_no = '0' and item_no = '14'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17850597' and item_no = '9'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17850597' and item_no = '10'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17850602' and item_no = '11'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17850604' and item_no = '12'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17850604' and item_no = '13'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17850604' and item_no = '14'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:2__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17850597'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:2__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17850597'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:1__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17850600'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:1__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17850602'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17850604'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17850604'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17850604'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101350'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101348'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101919'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101366'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101365'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:1__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5864583'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:14
记录内容:0__________UPDATE exam_appoints SET costs='78.50',charges='78.50',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:15
记录内容:0__________UPDATE exam_appoints SET costs='40',charges='40',BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101350'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:15
记录内容:0__________UPDATE exam_appoints SET costs='80',charges='80',BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101348'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:16
记录内容:0__________UPDATE exam_appoints SET costs='80',charges='80',BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101919'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:16
记录内容:0__________UPDATE exam_appoints SET costs='55',charges='55',BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101366'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:17
记录内容:0__________UPDATE exam_appoints SET costs='81',charges='81',BILLING_INDICATOR='1' WHERE EXAM_NO = '2602101365'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:17
记录内容:1__________UPDATE exam_appoints SET costs='40',charges='40',BILLING_INDICATOR='1' WHERE EXAM_NO = '5864583'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:17
记录内容:9__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100536985'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:18
记录内容:9__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100536985' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:18
记录内容:1__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100536985'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 14:30:18
记录内容:1__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100536985')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2026-02-10 14:30:18
记录内容:2026-02-10 14:30:18
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2026-02-10 14:30:18
记录内容:1成功5820260210018479
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2026-02-10 14:30:18
记录内容:2026-02-10 14:30:18
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2026-02-10 15:52:19
记录内容:cyys_2017@123cyys_2017@123100537159100537159178512471785124854.67001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2026-02-10 15:52:19
记录内容:'17851247','17851248'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2026-02-10 15:52:19
记录内容:2026-02-10 15:52:19
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2026-02-10 15:52:19
记录内容:2026-02-10 15:52:19
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容: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 ('20260210018896','100537159','王九梅','一般人员','自费',to_date('2026/02/10 15:52:19','yyyy/mm/dd hh24:mi:ss'),'54.67','54.67','WANG JIU MEI ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容: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('2026/2/10 15:00:41','yyyy/mm/dd hh24:mi:ss'),'5546','100537159','0','','0335','王进','20260210018896','202602104837')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容: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('2026/02/10 15:52:19','yyyy/mm/dd hh24:mi:ss'),'5546','20260210018896','1','C','H0300087','C—反应蛋白测定(CRP)全血快速定量加收','/','1','项','0411','30','30','0','1','M','025','190','1.0000','30.0000','1','','0','王进','0335','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容: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('2026/02/10 15:52:19','yyyy/mm/dd hh24:mi:ss'),'5546','20260210018896','2','C','H0300070','C-反应蛋白测定(CRP)免疫比浊法','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','1','','0','王进','0335','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容: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('2026/02/10 15:52:19','yyyy/mm/dd hh24:mi:ss'),'5546','20260210018896','3','C','H0201028','血细胞分析(五分类收)','/','1','项','0411','11','11','0','1','M','025','190','1.0000','11.0000','1','','0','王进','0335','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容: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('2026/2/10 15:00:41','yyyy/mm/dd hh24:mi:ss'),'5547','100537159','0','','0335','王进','20260210018896','202602104837')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容: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('2026/02/10 15:52:19','yyyy/mm/dd hh24:mi:ss'),'5547','20260210018896','1','E','E0003052','静脉采血','/','1','次','0329','7','7','0','1','B','016','900','1.0000','7.0000','2','','0','王进','0335','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容: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('2026/02/10 15:52:19','yyyy/mm/dd hh24:mi:ss'),'5547','20260210018896','2','E','I0015681','一次性使用静脉血样采集针','J-7软连接式0.7/威高','1','支','0329','0.25','0.25','0','1','L','031','170','1.0000','0.2500','2','','0','王进','0335','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容: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('2026/02/10 15:52:19','yyyy/mm/dd hh24:mi:ss'),'5547','20260210018896','3','E','I0015765','一次性使用人体静脉血样采集容器','EDTA-K2 2ml/威海威高','1','支','0329','0.42','0.42','0','1','L','031','170','1.0000','0.4200','2','','0','王进','0335','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容:1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20260210018896','1','微信','54.67','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17851247' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17851247' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17851247' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17851248' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17851248' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17851248' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17851247' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17851247' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17851247' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17851248' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17851248' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17851248' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17851247'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17851247'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17851247'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17851248'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17851248'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17851248'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2602102165'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:19
记录内容:0__________UPDATE exam_appoints SET costs='7.67',charges='7.67',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:20
记录内容:0__________UPDATE exam_appoints SET costs='47',charges='47',BILLING_INDICATOR='1' WHERE EXAM_NO = '2602102165'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:20
记录内容:1__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100537159'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:20
记录内容:1__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100537159' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:20
记录内容:8__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100537159'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 15:52:20
记录内容:10__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100537159')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2026-02-10 15:52:20
记录内容:2026-02-10 15:52:20
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2026-02-10 15:52:20
记录内容:1成功5320260210018896
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2026-02-10 15:52:20
记录内容:2026-02-10 15:52:20
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2026-02-10 16:08:50
记录内容:cyys_2017@123cyys_2017@1231003477241003477241785136817851390127.67001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2026-02-10 16:08:50
记录内容:'17851368','17851390'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2026-02-10 16:08:50
记录内容:2026-02-10 16:08:50
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2026-02-10 16:08:50
记录内容:2026-02-10 16:08:50
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08: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 ('20260210019023','100347724','张小睿','一般人员','自费',to_date('2026/02/10 16:08:50','yyyy/mm/dd hh24:mi:ss'),'127.67','127.67','ZHANG XIAO ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容: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('2026/2/10 14:13:39','yyyy/mm/dd hh24:mi:ss'),'5701','100347724','0','','0315','张金环','20260210019023','202602104125')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容: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('2026/02/10 16:08:50','yyyy/mm/dd hh24:mi:ss'),'5701','20260210019023','1','C','H0209042','血清游离三碘甲状原氨酸(FT3)测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','张金环','0315','0','*甲功三项','21379','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容: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('2026/02/10 16:08:50','yyyy/mm/dd hh24:mi:ss'),'5701','20260210019023','2','C','H0209039','血清游离甲状腺素(FT4)测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','张金环','0315','0','*甲功三项','21379','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容: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('2026/02/10 16:08:50','yyyy/mm/dd hh24:mi:ss'),'5701','20260210019023','3','C','H0209003','血清促甲状腺激素测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','张金环','0315','0','*甲功三项','21379','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容: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('2026/2/10 14:13:39','yyyy/mm/dd hh24:mi:ss'),'5702','100347724','0','','0315','张金环','20260210019023','202602104125')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容: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('2026/02/10 16:08:50','yyyy/mm/dd hh24:mi:ss'),'5702','20260210019023','1','E','E0003052','静脉采血','/','1','次','0329','7','7','0','1','B','016','900','1.0000','7.0000','2','','0','张金环','0315','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容: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('2026/02/10 16:08:50','yyyy/mm/dd hh24:mi:ss'),'5702','20260210019023','2','E','I0015681','一次性使用静脉血样采集针','J-7软连接式0.7/威高','1','支','0329','0.25','0.25','0','1','L','031','170','1.0000','0.2500','2','','0','张金环','0315','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容: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('2026/02/10 16:08:50','yyyy/mm/dd hh24:mi:ss'),'5702','20260210019023','3','E','I0015765','一次性使用人体静脉血样采集容器','EDTA-K2 2ml/威海威高','1','支','0329','0.42','0.42','0','1','L','031','170','1.0000','0.4200','2','','0','张金环','0315','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20260210019023','1','微信','127.67','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17851368' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17851368' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17851368' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17851390' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17851390' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17851390' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17851368' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17851368' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17851368' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17851390' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17851390' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17851390' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17851368'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17851368'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17851368'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17851390'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17851390'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17851390'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:1__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5865022'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:1__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5865024'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:1__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5865025'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:1__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5865026'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:51
记录内容:1__________UPDATE exam_appoints SET costs='180',charges='180',BILLING_INDICATOR='1' WHERE EXAM_NO = '5865022'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:52
记录内容:1__________UPDATE exam_appoints SET costs='110',charges='110',BILLING_INDICATOR='1' WHERE EXAM_NO = '5865024'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:52
记录内容:1__________UPDATE exam_appoints SET costs='230',charges='230',BILLING_INDICATOR='1' WHERE EXAM_NO = '5865025'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:53
记录内容:1__________UPDATE exam_appoints SET costs='20',charges='20',BILLING_INDICATOR='1' WHERE EXAM_NO = '5865026'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:53
记录内容:60__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100347724'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:53
记录内容:84__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100347724' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:53
记录内容:14__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100347724'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:08:53
记录内容:14__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100347724')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2026-02-10 16:08:53
记录内容:2026-02-10 16:08:53
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2026-02-10 16:08:53
记录内容:1成功21320260210019023
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2026-02-10 16:08:53
记录内容:2026-02-10 16:08:53
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2026-02-10 16:16:13
记录内容:cyys_2017@123cyys_2017@1231003477241003477241785142428.61001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2026-02-10 16:16:13
记录内容:'17851424'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2026-02-10 16:16:13
记录内容:2026-02-10 16:16:13
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2026-02-10 16:16:13
记录内容:2026-02-10 16:16:13
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:16:13
记录内容: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 ('20260210019031','100347724','张小睿','一般人员','自费',to_date('2026/02/10 16:16:13','yyyy/mm/dd hh24:mi:ss'),'28.61','28.61','ZHANG XIAO ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:16:13
记录内容: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('2026/02/10 16:16:13','yyyy/mm/dd hh24:mi:ss'),'5776','050101','100347724','张小睿','ZHANG XIAO ','一般人员','自费','0','门诊处方','0','1','28.61','28.61','0315','ZJH01','张金环','ZJH01','20260210019031','1','202602105426','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:16:13
记录内容: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('2026-02-10 16:16:13', 'yyyy-mm-dd hh24:mi:ss'),'5776','1','11005001391','50ug*100','[进]左甲状腺素钠片','德国默克','50ug*100','盒','1','28.61','28.61','50;ug;口服;1/日','1','1','50','','','','','','0','0','','','','0.0000','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:16:13
记录内容: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('2026/2/10 14:13:39','yyyy/mm/dd hh24:mi:ss'),'5782','100347724','1','门诊处方','0315','张金环','20260210019031','202602104125')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:16:13
记录内容: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('2026/02/10 16:16:13','yyyy/mm/dd hh24:mi:ss'),'5782','20260210019031','1','A','11005001391','[进]左甲状腺素钠片','50ug*100德国默克','1','盒','050101','28.61','28.61','0','1','A','032','200','1.0000','28.6100','1','50;ug;口服;1/日','0','张金环','0315','0','[进]左甲状腺素钠片','11005001391','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:16:13
记录内容:1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20260210019031','1','微信','28.61','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:16:13
记录内容:1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17851424' and presc_no = '5776' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:16:13
记录内容:1__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17851424'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:16:13
记录内容:1__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5865022'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:16:13
记录内容:1__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5865025'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:16:13
记录内容:1__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5865024'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:16:13
记录内容:1__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5865026'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:16:14
记录内容:1__________UPDATE exam_appoints SET costs='180',charges='180',BILLING_INDICATOR='1' WHERE EXAM_NO = '5865022'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:16:15
记录内容:1__________UPDATE exam_appoints SET costs='230',charges='230',BILLING_INDICATOR='1' WHERE EXAM_NO = '5865025'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:16:15
记录内容:1__________UPDATE exam_appoints SET costs='110',charges='110',BILLING_INDICATOR='1' WHERE EXAM_NO = '5865024'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:16:16
记录内容:1__________UPDATE exam_appoints SET costs='20',charges='20',BILLING_INDICATOR='1' WHERE EXAM_NO = '5865026'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:16:16
记录内容:60__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100347724'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:16:16
记录内容:84__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100347724' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:16:16
记录内容:14__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100347724'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:16:16
记录内容:14__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100347724')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2026-02-10 16:16:16
记录内容:2026-02-10 16:16:16
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2026-02-10 16:16:16
记录内容:1成功18720260210019031
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2026-02-10 16:16:16
记录内容:2026-02-10 16:16:16
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2026-02-10 16:37:35
记录内容:cyys_2017@123cyys_2017@123100537159100537159178515309.93001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2026-02-10 16:37:35
记录内容:'17851530'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2026-02-10 16:37:35
记录内容:2026-02-10 16:37:35
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2026-02-10 16:37:35
记录内容:2026-02-10 16:37:35
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:37:35
记录内容: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 ('20260210019107','100537159','王九梅','一般人员','自费',to_date('2026/02/10 16:37:35','yyyy/mm/dd hh24:mi:ss'),'9.93','9.93','WANG JIU MEI ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:37:35
记录内容: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('2026/02/10 16:37:35','yyyy/mm/dd hh24:mi:ss'),'5954','050101','100537159','王九梅','WANG JIU MEI ','一般人员','自费','0','门诊处方','0','1','9.93','9.93','0335','WJ01','王进','WJ01','20260210019107','2','202602104837','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:37:35
记录内容: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('2026-02-10 16:37:35', 'yyyy-mm-dd hh24:mi:ss'),'5954','1','11303030680','100ml(双层无菌)','0.9%氯化钠注射液100ml','石家庄四药','100ml(双层无菌)','袋','1','6.09','6.09','100;ml;静脉输液;1/日','4','1','100','','','','','','0','0','','','','0.0000','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:37:35
记录内容: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('2026-02-10 16:37:35', 'yyyy-mm-dd hh24:mi:ss'),'5954','2','10102073670','1g','注射用头孢曲松钠1g*','中诺药业','1g','瓶','2','3.84','3.84','2;g;静脉输液;1/日','4','2','2','','','','','','0','0','','','','0.0000','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:37:36
记录内容: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('2026/2/10 15:00:41','yyyy/mm/dd hh24:mi:ss'),'5988','100537159','1','门诊处方','0335','王进','20260210019107','202602104837')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:37:36
记录内容: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('2026/02/10 16:37:35','yyyy/mm/dd hh24:mi:ss'),'5988','20260210019107','1','A','11303030680','0.9%氯化钠注射液100ml','100ml(双层无菌)石家庄四药','1','袋','050101','6.09','6.09','0','1','A','032','200','1.0000','6.0900','1','100;ml;静脉输液;1/日','0','王进','0335','0','0.9%氯化钠注射液100ml','11303030680','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:37:36
记录内容: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('2026/02/10 16:37:35','yyyy/mm/dd hh24:mi:ss'),'5988','20260210019107','2','A','10102073670','注射用头孢曲松钠1g*','1g中诺药业','2','瓶','050101','3.84','3.84','0','1','A','032','200','1.0000','1.9200','2','2;g;静脉输液;1/日','0','王进','0335','0','注射用头孢曲松钠1g*','10102073670','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:37:36
记录内容:1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20260210019107','1','微信','9.93','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:37:36
记录内容:1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17851530' and presc_no = '5954' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:37:36
记录内容:1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17851530' and presc_no = '5954' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:37:36
记录内容:2__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17851530'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:37:36
记录内容:2__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17851530'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:37:36
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:37:36
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2602102165'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:37:36
记录内容:0__________UPDATE exam_appoints SET costs='7.67',charges='7.67',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:37:36
记录内容:0__________UPDATE exam_appoints SET costs='47',charges='47',BILLING_INDICATOR='1' WHERE EXAM_NO = '2602102165'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:37:36
记录内容:2__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100537159'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:37:36
记录内容:2__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100537159' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:37:36
记录内容:8__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100537159'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:37:36
记录内容:10__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100537159')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2026-02-10 16:37:36
记录内容:2026-02-10 16:37:36
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2026-02-10 16:37:36
记录内容:1成功3520260210019107
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2026-02-10 16:37:36
记录内容:2026-02-10 16:37:36
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2026-02-10 16:49:45
记录内容:cyys_2017@123cyys_2017@123100537159100537159178515701785157241.01001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2026-02-10 16:49:45
记录内容:'17851570','17851572'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2026-02-10 16:49:45
记录内容:2026-02-10 16:49:45
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2026-02-10 16:49:45
记录内容:2026-02-10 16:49:45
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容: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 ('20260210019163','100537159','王九梅','一般人员','自费',to_date('2026/02/10 16:49:45','yyyy/mm/dd hh24:mi:ss'),'41.01','41.01','WANG JIU MEI ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容: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('2026/02/10 16:49:45','yyyy/mm/dd hh24:mi:ss'),'6043','050101','100537159','王九梅','WANG JIU MEI ','一般人员','自费','0','门诊处方','0','1','9.93','9.93','0323','LYB','林玉博','LYB','20260210019163','2','202602106024','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容: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('2026-02-10 16:49:45', 'yyyy-mm-dd hh24:mi:ss'),'6043','1','11303030680','100ml(双层无菌)','0.9%氯化钠注射液100ml','石家庄四药','100ml(双层无菌)','袋','1','6.09','6.09','100;ml;静脉输液;1/日','1','1','100','','','','','','0','0','','','','0.0000','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容: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('2026-02-10 16:49:45', 'yyyy-mm-dd hh24:mi:ss'),'6043','2','10102073670','1g','注射用头孢曲松钠1g*','中诺药业','1g','瓶','2','3.84','3.84','2;g;静脉输液;1/日','1','2','2','','','','','','0','0','','','','0.0000','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容: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('2026/2/10 15:00:41','yyyy/mm/dd hh24:mi:ss'),'6049','100537159','1','门诊处方','0323','林玉博','20260210019163','202602104837')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容: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('2026/02/10 16:49:45','yyyy/mm/dd hh24:mi:ss'),'6049','20260210019163','1','A','11303030680','0.9%氯化钠注射液100ml','100ml(双层无菌)石家庄四药','1','袋','050101','6.09','6.09','0','1','A','032','200','1.0000','6.0900','1','100;ml;静脉输液;1/日','0','林玉博','0323','0','0.9%氯化钠注射液100ml','11303030680','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容: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('2026/02/10 16:49:45','yyyy/mm/dd hh24:mi:ss'),'6049','20260210019163','2','A','10102073670','注射用头孢曲松钠1g*','1g中诺药业','2','瓶','050101','3.84','3.84','0','1','A','032','200','1.0000','1.9200','2','2;g;静脉输液;1/日','0','林玉博','0323','0','注射用头孢曲松钠1g*','10102073670','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容: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('2026/2/10 15:00:41','yyyy/mm/dd hh24:mi:ss'),'6050','100537159','0','','0323','林玉博','20260210019163','202602104837')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容: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('2026/02/10 16:49:45','yyyy/mm/dd hh24:mi:ss'),'6050','20260210019163','1','J','I0009380','一次性使用输液器(带针)','0.7#精密进气式/威高','1','支','0323','3.08','3.08','0','1','L','031','170','1.0000','3.0800','1','','0','林玉博','0323','0','一次性使用输液器(带针)','I0009380','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容: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('2026/02/10 16:49:45','yyyy/mm/dd hh24:mi:ss'),'6050','20260210019163','2','E','E0003045','静脉输液','/','1','次','0323','9','9','0','1','B','016','900','1.0000','9.0000','2','','0','林玉博','0323','0','静脉输液','E0003045','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容: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('2026/02/10 16:49:45','yyyy/mm/dd hh24:mi:ss'),'6050','20260210019163','3','H','F0001015','急诊留观护理','/','1','日','0323','19','19','0','1','E','026','140','1.0000','19.0000','3','','0','林玉博','0323','0','急诊留观护理','F0001015','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容:1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20260210019163','1','微信','41.01','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容:1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17851570' and presc_no = '6043' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容:1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17851570' and presc_no = '6043' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17851572' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17851572' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17851572' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17851572' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17851572' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17851572' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容:2__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17851570'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容:2__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17851570'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17851572'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17851572'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17851572'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容:0__________UPDATE exam_appoints SET costs='93.24',charges='93.24',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容:2__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100537159'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容:2__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100537159' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容:8__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100537159'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-10 16:49:45
记录内容:10__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100537159')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2026-02-10 16:49:45
记录内容:2026-02-10 16:49:45
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2026-02-10 16:49:45
记录内容:1成功5120260210019163
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2026-02-10 16:49:45
记录内容:2026-02-10 16:49:45
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆