◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2025-01-03 08:26:39
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>10521198</patientid><visited>10521198</visited><prescriptions><prescriptionrow><prescriptionrno>15511890</prescriptionrno></prescriptionrow><prescriptionrow><prescriptionrno>15511894</prescriptionrno></prescriptionrow></prescriptions><totalamount>64.6700</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2025-01-03 08:26:39
记录内容：'15511890','15511894'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2025-01-03 08:26:39
记录内容：2025-01-03 08:26:39
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2025-01-03 08:26:41
记录内容：2025-01-03 08:26:41
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________ 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 ('20250103000336','10521198','席鹏园','一般人员','自费',to_date('2025/01/03 08:26:39','yyyy/mm/dd hh24:mi:ss'),'64.67','64.67','XI PENG YUAN ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/1/3 8:02:30','yyyy/mm/dd hh24:mi:ss'),'2957','10521198','0','','0317','刘建影','20250103000336','202501032416') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 08:26:39','yyyy/mm/dd hh24:mi:ss'),'2957','20250103000336','1','C','H0300087','C—反应蛋白测定(CRP)全血快速定量加收','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','刘建影','0317','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 08:26:39','yyyy/mm/dd hh24:mi:ss'),'2957','20250103000336','2','C','H0300070','C-反应蛋白测定(CRP)免疫比浊法','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','1','','0','刘建影','0317','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 08:26:39','yyyy/mm/dd hh24:mi:ss'),'2957','20250103000336','3','C','H0201028','血细胞分析（五分类收）','/','1','项','0411','11','11','0','1','D','033','600','1.0000','11.0000','1','','0','刘建影','0317','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/1/3 8:02:30','yyyy/mm/dd hh24:mi:ss'),'2958','10521198','0','','0317','刘建影','20250103000336','202501032416') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 08:26:39','yyyy/mm/dd hh24:mi:ss'),'2958','20250103000336','1','E','E0003052','静脉采血','/','1','次','0329','7','7','0','1','D','033','600','1.0000','7.0000','2','','0','刘建影','0317','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 08:26:39','yyyy/mm/dd hh24:mi:ss'),'2958','20250103000336','2','E','I0015681','一次性使用静脉血样采集针','J-7软连接式0.7/威高','1','支','0317','0.25','0.25','0','1','D','033','600','1.0000','0.2500','2','','0','刘建影','0317','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 08:26:39','yyyy/mm/dd hh24:mi:ss'),'2958','20250103000336','3','E','I0015765','一次性使用人体静脉血样采集容器','EDTA-K2 2ml/威海威高','1','支','0317','0.42','0.42','0','1','D','033','600','1.0000','0.4200','2','','0','刘建影','0317','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250103000336','1','微信','64.67','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15511890' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15511890' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15511890' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15511894' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15511894' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15511894' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15511890' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15511890' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15511890' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15511894' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15511894' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15511894' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15511890'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15511890'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15511890'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15511894'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15511894'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15511894'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2501030481'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE exam_appoints SET costs='7.67',charges='7.67',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE exam_appoints SET costs='57',charges='57',BILLING_INDICATOR='1' WHERE EXAM_NO = '2501030481'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10521198'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '10521198' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10521198'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:26:42
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '10521198') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2025-01-03 08:26:42
记录内容：2025-01-03 08:26:42
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2025-01-03 08:26:42
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20250103000336</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2025-01-03 08:26:42
记录内容：2025-01-03 08:26:42
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2025-01-03 08:59:47
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>100462617</patientid><visited>100462617</visited><prescriptions><prescriptionrow><prescriptionrno>15512369</prescriptionrno></prescriptionrow></prescriptions><totalamount>331.0000</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2025-01-03 08:59:47
记录内容：'15512369'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2025-01-03 08:59:47
记录内容：2025-01-03 08:59:47
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2025-01-03 08:59:48
记录内容：2025-01-03 08:59:48
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:59:48
记录内容：__________ 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 ('20250103000543','100462617','刘俊安','一般人员','自费',to_date('2025/01/03 08:59:47','yyyy/mm/dd hh24:mi:ss'),'331','331','LIU JUN AN ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:59:48
记录内容：__________ 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('2024/12/31 9:31:26','yyyy/mm/dd hh24:mi:ss'),'3999','100462617','0','','0304','李梅','20250103000543','202412311928') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:59:48
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 08:59:47','yyyy/mm/dd hh24:mi:ss'),'3999','20250103000543','1','E','E0101004','婴幼儿健康体检','/','1','次','0304','31','31','0','1','B','016','900','1.0000','31.0000','1','','0','李梅','0304','0','*婴幼儿健康体检','E0101002','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:59:48
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 08:59:47','yyyy/mm/dd hh24:mi:ss'),'3999','20250103000543','2','D','D0701098','骨密度测定(超声)','/','1','次','0304','150','150','0','1','J','016','150','1.0000','150.0000','2','','0','李梅','0304','0','超声骨密度测量（儿科）','JC000974','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:59:48
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 08:59:47','yyyy/mm/dd hh24:mi:ss'),'3999','20250103000543','3','D','D0701098','骨密度测定(超声)','/','1','次','0304','150','150','0','1','J','016','150','1.0000','150.0000','3','','0','李梅','0304','0','超声骨密度测量（儿科）','JC000974','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:59:48
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250103000543','1','微信','331','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:59:48
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15512369' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:59:48
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15512369' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:59:48
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15512369' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:59:48
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15512369' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:59:48
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15512369' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:59:48
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15512369' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:59:48
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15512369'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:59:48
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15512369'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:59:48
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15512369'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:59:48
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:59:48
记录内容：__________UPDATE exam_appoints SET costs='993',charges='993',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:59:48
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100462617'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:59:48
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '100462617' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:59:48
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100462617'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 08:59:48
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '100462617') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2025-01-03 08:59:48
记录内容：2025-01-03 08:59:48
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2025-01-03 08:59:48
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20250103000543</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2025-01-03 08:59:48
记录内容：2025-01-03 08:59:48
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2025-01-03 09:03:17
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>100462617</patientid><visited>100462617</visited><prescriptions><prescriptionrow><prescriptionrno>15512407</prescriptionrno></prescriptionrow></prescriptions><totalamount>201.0000</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2025-01-03 09:03:17
记录内容：'15512407'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2025-01-03 09:03:17
记录内容：2025-01-03 09:03:17
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2025-01-03 09:03:17
记录内容：2025-01-03 09:03:17
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:03:17
记录内容：__________ 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 ('20250103000544','100462617','刘俊安','一般人员','自费',to_date('2025/01/03 09:03:17','yyyy/mm/dd hh24:mi:ss'),'201','201','LIU JUN AN ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:03:17
记录内容：__________ 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('2024/12/31 9:31:26','yyyy/mm/dd hh24:mi:ss'),'4106','100462617','0','','0304','李梅','20250103000544','202412311928') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:03:17
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 09:03:17','yyyy/mm/dd hh24:mi:ss'),'4106','20250103000544','1','E','E0101004','婴幼儿健康体检','/','1','次','0304','31','31','0','1','B','016','900','1.0000','31.0000','4','','0','李梅','0304','0','*婴幼儿健康体检','E0101002','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:03:17
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 09:03:17','yyyy/mm/dd hh24:mi:ss'),'4106','20250103000544','2','D','D0701098','骨密度测定(超声)','/','1','次','0304','150','150','0','1','J','016','150','1.0000','150.0000','5','','0','李梅','0304','0','超声骨密度测量（儿科）','JC000974','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:03:17
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 09:03:17','yyyy/mm/dd hh24:mi:ss'),'4106','20250103000544','3','E','J0003003','儿童健康咨询','/','1','次','0304','20','20','0','1','B','016','900','1.0000','20.0000','6','','0','李梅','0304','0','儿童健康咨询','J0003003','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:03:17
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250103000544','1','微信','201','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:03:17
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15512407' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:03:17
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15512407' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:03:17
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15512407' and presc_no = '0' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:03:17
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15512407' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:03:17
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15512407' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:03:17
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15512407' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:03:17
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15512407'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:03:17
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15512407'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:03:17
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15512407'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:03:17
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:03:17
记录内容：__________UPDATE exam_appoints SET costs='1596',charges='1596',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:03:17
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100462617'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:03:17
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '100462617' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:03:17
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100462617'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:03:17
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '100462617') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2025-01-03 09:03:17
记录内容：2025-01-03 09:03:17
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2025-01-03 09:03:17
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20250103000544</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2025-01-03 09:03:17
记录内容：2025-01-03 09:03:17
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2025-01-03 09:32:47
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>10521198</patientid><visited>10521198</visited><prescriptions><prescriptionrow><prescriptionrno>15512838</prescriptionrno></prescriptionrow></prescriptions><totalamount>251.4100</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2025-01-03 09:32:47
记录内容：'15512838'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2025-01-03 09:32:47
记录内容：2025-01-03 09:32:47
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2025-01-03 09:32:47
记录内容：2025-01-03 09:32:47
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________ 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 ('20250103000732','10521198','席鹏园','一般人员','自费',to_date('2025/01/03 09:32:47','yyyy/mm/dd hh24:mi:ss'),'251.41','251.41','XI PENG YUAN ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________ INSERT INTO drug_presc_master_temp (presc_date,presc_no,dispensary,PATIENT_ID,NAME,NAME_PHONETIC,IDENTITY,CHARGE_TYPE,PRESC_TYPE,PRESC_ATTR,PRESC_SOURCE,REPETITION,COSTS,PAYMENTS,ORDERED_BY,PRESCRIBED_BY,ENTERED_BY,DOCTOR_USER,RCPT_NO,COUNT_PER_REPETITION,CLINIC_NO,IS_SEND,SEND_WIN_NO) VALUES (to_date('2025/01/03 09:32:47','yyyy/mm/dd hh24:mi:ss'),'4815','050101','10521198','席鹏园','XI PENG YUAN','一般人员','自费','0','门诊处方','0','1','251.41','251.41','0317','LJY','刘建影','LJY','20250103000732','3','202501032416','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2025-01-03 09:32:47', 'yyyy-mm-dd hh24:mi:ss'),'4815','1','10108021390','0.25g*6','阿奇霉素片','辉瑞制药','0.25g*6','盒','2','109.56','109.56','.5;g;口服;1/日','3','1','0.5','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2025-01-03 09:32:47', 'yyyy-mm-dd hh24:mi:ss'),'4815','2','20105010320','150ml','肺力咳合剂','贵州健兴','150ml','瓶','3','71.16','71.16','20;ml;口服;3/日','4','1','20','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2025-01-03 09:32:47', 'yyyy-mm-dd hh24:mi:ss'),'4815','3','20103138540','10ml*9','胆木浸膏糖浆','海南森祺','10ml*9','盒','1','70.69','70.69','10;ml;口服;3/日','5','1','10','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/1/3 8:02:30','yyyy/mm/dd hh24:mi:ss'),'4928','10521198','1','门诊处方','0317','刘建影','20250103000732','202501032416') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 09:32:47','yyyy/mm/dd hh24:mi:ss'),'4928','20250103000732','1','A','10108021390','阿奇霉素片','0.25g*6辉瑞制药','2','盒','050101','109.56','109.56','0','1','A','032','200','1.0000','54.7800','1','.5;g;口服;1/日','0','刘建影','0317','0','阿奇霉素片','10108021390','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 09:32:47','yyyy/mm/dd hh24:mi:ss'),'4928','20250103000732','2','A','20105010320','肺力咳合剂','150ml贵州健兴','3','瓶','050101','71.16','71.16','0','1','J','044','150','1.0000','23.7200','2','20;ml;口服;3/日','0','刘建影','0317','0','肺力咳合剂','20105010320','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 09:32:47','yyyy/mm/dd hh24:mi:ss'),'4928','20250103000732','3','A','20103138540','胆木浸膏糖浆','10ml*9海南森祺','1','盒','050101','70.69','70.69','0','1','J','044','150','1.0000','70.6900','3','10;ml;口服;3/日','0','刘建影','0317','0','胆木浸膏糖浆','20103138540','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250103000732','1','微信','251.41','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15512838' and presc_no = '4815' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15512838' and presc_no = '4815' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15512838' and presc_no = '4815' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15512838'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15512838'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15512838'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2501030481'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________UPDATE exam_appoints SET costs='7.67',charges='7.67',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________UPDATE exam_appoints SET costs='57',charges='57',BILLING_INDICATOR='1' WHERE EXAM_NO = '2501030481'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10521198'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '10521198' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10521198'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 09:32:47
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '10521198') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2025-01-03 09:32:47
记录内容：2025-01-03 09:32:47
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2025-01-03 09:32:47
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20250103000732</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2025-01-03 09:32:47
记录内容：2025-01-03 09:32:47
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2025-01-03 10:01:22
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>00433014</patientid><visited>00433014</visited><prescriptions><prescriptionrow><prescriptionrno>15513450</prescriptionrno></prescriptionrow></prescriptions><totalamount>120.0000</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2025-01-03 10:01:22
记录内容：'15513450'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2025-01-03 10:01:23
记录内容：2025-01-03 10:01:23
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2025-01-03 10:01:23
记录内容：2025-01-03 10:01:23
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:01:23
记录内容：__________ 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 ('20250103000875','00433014','王思齐','一般人员','自费',to_date('2025/01/03 10:01:23','yyyy/mm/dd hh24:mi:ss'),'120','120','WANG SI QI ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:01:23
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/1/3 9:52:25','yyyy/mm/dd hh24:mi:ss'),'5790','00433014','0','','0371','李丹丹','20250103000875','202501035531') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:01:23
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 10:01:23','yyyy/mm/dd hh24:mi:ss'),'5790','20250103000875','1','D','D1201121','腔内彩色多普勒超声检查','/','1','次','0371','120','120','0','1','J','044','150','1.0000','120.0000','1','','0','李丹丹','0371','0','*生殖卵泡监测','JC000924','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:01:23
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250103000875','1','微信','120','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:01:23
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15513450' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:01:23
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15513450' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:01:23
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15513450'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:01:23
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:01:23
记录内容：__________UPDATE exam_appoints SET costs='120',charges='120',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:01:23
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00433014'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:01:23
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '00433014' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:01:23
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00433014'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:01:23
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '00433014') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2025-01-03 10:01:23
记录内容：2025-01-03 10:01:23
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2025-01-03 10:01:23
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20250103000875</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2025-01-03 10:01:23
记录内容：2025-01-03 10:01:23
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2025-01-03 10:06:48
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>00433014</patientid><visited>00433014</visited><prescriptions><prescriptionrow><prescriptionrno>15513532</prescriptionrno></prescriptionrow><prescriptionrow><prescriptionrno>15513536</prescriptionrno></prescriptionrow></prescriptions><totalamount>127.6700</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2025-01-03 10:06:48
记录内容：'15513532','15513536'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2025-01-03 10:06:48
记录内容：2025-01-03 10:06:48
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2025-01-03 10:06:49
记录内容：2025-01-03 10:06:49
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________ 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 ('20250103001064','00433014','王思齐','一般人员','自费',to_date('2025/01/03 10:06:48','yyyy/mm/dd hh24:mi:ss'),'127.67','127.67','WANG SI QI ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/1/3 9:52:25','yyyy/mm/dd hh24:mi:ss'),'5961','00433014','0','','0371','李丹丹','20250103001064','202501035531') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 10:06:48','yyyy/mm/dd hh24:mi:ss'),'5961','20250103001064','1','C','H0209015','血清促黄体生成素测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','2','','0','李丹丹','0371','0','*性激素三项(生殖科)','JY001307','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 10:06:48','yyyy/mm/dd hh24:mi:ss'),'5961','20250103001064','2','C','H0209100','雌二醇测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','2','','0','李丹丹','0371','0','*性激素三项(生殖科)','JY001307','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 10:06:48','yyyy/mm/dd hh24:mi:ss'),'5961','20250103001064','3','C','H0209103','孕酮测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','2','','0','李丹丹','0371','0','*性激素三项(生殖科)','JY001307','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/1/3 9:52:25','yyyy/mm/dd hh24:mi:ss'),'5962','00433014','0','','0371','李丹丹','20250103001064','202501035531') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 10:06:49','yyyy/mm/dd hh24:mi:ss'),'5962','20250103001064','1','E','E0003052','静脉采血','/','1','次','0371','7','7','0','1','B','016','900','1.0000','7.0000','3','','0','李丹丹','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 10:06:49','yyyy/mm/dd hh24:mi:ss'),'5962','20250103001064','2','E','I0015681','一次性使用静脉血样采集针','J-7软连接式0.7/威高','1','支','0371','0.25','0.25','0','1','J','044','150','1.0000','0.2500','3','','0','李丹丹','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 10:06:49','yyyy/mm/dd hh24:mi:ss'),'5962','20250103001064','3','E','I0015765','一次性使用人体静脉血样采集容器','EDTA-K2 2ml/威海威高','1','支','0371','0.42','0.42','0','1','J','044','150','1.0000','0.4200','3','','0','李丹丹','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250103001064','1','微信','127.67','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15513532' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15513532' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15513532' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15513536' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15513536' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15513536' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15513532' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15513532' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15513532' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15513536' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15513536' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15513536' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15513532'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15513532'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15513532'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15513536'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15513536'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15513536'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2501031257'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE exam_appoints SET costs='127.67',charges='127.67',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE exam_appoints SET costs='120',charges='120',BILLING_INDICATOR='1' WHERE EXAM_NO = '2501031257'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00433014'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '00433014' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00433014'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:06:49
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '00433014') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2025-01-03 10:06:49
记录内容：2025-01-03 10:06:49
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2025-01-03 10:06:49
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20250103001064</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2025-01-03 10:06:49
记录内容：2025-01-03 10:06:49
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2025-01-03 10:28:26
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>10708189</patientid><visited>10708189</visited><prescriptions><prescriptionrow><prescriptionrno>15513446</prescriptionrno></prescriptionrow></prescriptions><totalamount>18.4000</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2025-01-03 10:28:26
记录内容：'15513446'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2025-01-03 10:28:26
记录内容：2025-01-03 10:28:26
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2025-01-03 10:28:26
记录内容：2025-01-03 10:28:26
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:28:26
记录内容：__________ INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20250103001231','10708189','杨宇桐','一般人员','自费',to_date('2025/01/03 10:28:26','yyyy/mm/dd hh24:mi:ss'),'18.4','18.4','YANG YU TONG ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:28:26
记录内容：__________ INSERT INTO drug_presc_master_temp (presc_date,presc_no,dispensary,PATIENT_ID,NAME,NAME_PHONETIC,IDENTITY,CHARGE_TYPE,PRESC_TYPE,PRESC_ATTR,PRESC_SOURCE,REPETITION,COSTS,PAYMENTS,ORDERED_BY,PRESCRIBED_BY,ENTERED_BY,DOCTOR_USER,RCPT_NO,COUNT_PER_REPETITION,CLINIC_NO,IS_SEND,SEND_WIN_NO) VALUES (to_date('2025/01/03 10:28:26','yyyy/mm/dd hh24:mi:ss'),'5756','050101','10708189','杨宇桐','','一般人员','自费','0','门诊处方','0','1','18.40','18.40','0303','CHIXIAOY','迟小雨','CHIXIAOY','20250103001231','1','202501032623','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:28:26
记录内容：__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2025-01-03 10:28:26', 'yyyy-mm-dd hh24:mi:ss'),'5756','1','10206004391','1mg*20','艾司唑仑片','华中药业','1mg*20','盒','2','18.4','18.4','1;mg;口服;3/日','1','1','1','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:28:26
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/1/3 9:58:25','yyyy/mm/dd hh24:mi:ss'),'6686','10708189','1','门诊处方','0303','迟小雨','20250103001231','202501032623') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:28:26
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 10:28:26','yyyy/mm/dd hh24:mi:ss'),'6686','20250103001231','1','A','10206004391','艾司唑仑片','1mg*20华中药业','2','盒','050101','18.4','18.4','0','1','J','044','150','1.0000','9.2000','1','1;mg;口服;3/日','0','迟小雨','0303','0','艾司唑仑片','10206004391','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:28:26
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250103001231','1','微信','18.4','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:28:26
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15513446' and presc_no = '5756' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:28:26
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15513446'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:28:26
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10708189'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:28:26
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '10708189' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:28:26
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10708189'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:28:26
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '10708189') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2025-01-03 10:28:26
记录内容：2025-01-03 10:28:26
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2025-01-03 10:28:26
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20250103001231</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2025-01-03 10:28:26
记录内容：2025-01-03 10:28:26
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2025-01-03 10:59:01
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>10385920</patientid><visited>10385920</visited><prescriptions><prescriptionrow><prescriptionrno>15514382</prescriptionrno></prescriptionrow><prescriptionrow><prescriptionrno>15514386</prescriptionrno></prescriptionrow><prescriptionrow><prescriptionrno>15514391</prescriptionrno></prescriptionrow></prescriptions><totalamount>132.0900</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2025-01-03 10:59:01
记录内容：'15514382','15514386','15514391'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2025-01-03 10:59:01
记录内容：2025-01-03 10:59:01
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2025-01-03 10:59:02
记录内容：2025-01-03 10:59:02
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________ 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 ('20250103001484','10385920','刘宝东','一般人员','自费',to_date('2025/01/03 10:59:01','yyyy/mm/dd hh24:mi:ss'),'132.09','132.09','LIU BAO DONG ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/1/3 10:20:57','yyyy/mm/dd hh24:mi:ss'),'7489','10385920','0','','0396','吴春明','20250103001484','202501036482') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 10:59:01','yyyy/mm/dd hh24:mi:ss'),'7489','20250103001484','1','C','H0102046','血浆凝血酶原时间测定(PT)仪器法','/','1','项','0411','20','20','0','1','M','025','190','1.0000','20.0000','1','','0','吴春明','0396','0','*凝血四项','21336','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 10:59:01','yyyy/mm/dd hh24:mi:ss'),'7489','20250103001484','2','C','H0102061','活化部分凝血活酶时间测定(APTT)仪器法','/','1','项','0411','20','20','0','1','M','025','190','1.0000','20.0000','1','','0','吴春明','0396','0','*凝血四项','21336','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 10:59:01','yyyy/mm/dd hh24:mi:ss'),'7489','20250103001484','3','C','H0102072','血浆纤维蛋白原测定(仪器法)','/','1','项','0411','20','20','0','1','M','025','190','1.0000','20.0000','1','','0','吴春明','0396','0','*凝血四项','21336','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 10:59:01','yyyy/mm/dd hh24:mi:ss'),'7489','20250103001484','4','C','H0102105','凝血酶时间测定(TT)仪器法','/','1','项','0411','20','20','0','1','M','025','190','1.0000','20.0000','1','','0','吴春明','0396','0','*凝血四项','21336','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/1/3 10:20:57','yyyy/mm/dd hh24:mi:ss'),'7490','10385920','0','','0396','吴春明','20250103001484','202501036482') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 10:59:01','yyyy/mm/dd hh24:mi:ss'),'7490','20250103001484','1','C','H0204025','血清丙氨酸氨基转移酶测定(速率法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','3','','0','吴春明','0396','0','*肝功10项','JY001305','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 10:59:01','yyyy/mm/dd hh24:mi:ss'),'7490','20250103001484','2','C','H0204029','血清天门冬氨酸氨基转移酶测定(速率法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','3','','0','吴春明','0396','0','*肝功10项','JY001305','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 10:59:01','yyyy/mm/dd hh24:mi:ss'),'7490','20250103001484','3','C','H0204033','血清γ-谷氨酰基转移酶测定(速率法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','3','','0','吴春明','0396','0','*肝功10项','JY001305','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 10:59:01','yyyy/mm/dd hh24:mi:ss'),'7490','20250103001484','4','C','H0204003','血清总胆红素测定(化学法或酶促法)','/','1','项','0411','5','5','0','1','M','025','190','1.0000','5.0000','3','','0','吴春明','0396','0','*肝功10项','JY001305','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 10:59:02','yyyy/mm/dd hh24:mi:ss'),'7490','20250103001484','5','C','H0204007','血清直接胆红素测定(化学法或酶促法)','/','1','项','0411','5','5','0','1','M','025','190','1.0000','5.0000','3','','0','吴春明','0396','0','*肝功10项','JY001305','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 10:59:02','yyyy/mm/dd hh24:mi:ss'),'7490','20250103001484','6','C','H0200003','血清总蛋白测定(化学法)','/','1','项','0411','5','5','0','1','M','025','190','1.0000','5.0000','3','','0','吴春明','0396','0','*肝功10项','JY001305','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 10:59:02','yyyy/mm/dd hh24:mi:ss'),'7490','20250103001484','7','C','H0200007','血清白蛋白测定(化学法)','/','1','项','0411','5','5','0','1','M','025','190','1.0000','5.0000','3','','0','吴春明','0396','0','*肝功10项','JY001305','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 10:59:02','yyyy/mm/dd hh24:mi:ss'),'7490','20250103001484','8','C','H0204038','血清碱性磷酸酶测定(速率法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','3','','0','吴春明','0396','0','*肝功10项','JY001305','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/1/3 10:20:57','yyyy/mm/dd hh24:mi:ss'),'7492','10385920','0','','0396','吴春明','20250103001484','202501036482') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 10:59:02','yyyy/mm/dd hh24:mi:ss'),'7492','20250103001484','1','E','E0003052','静脉采血','/','1','次','0329','7','7','0','1','B','016','900','1.0000','7.0000','4','','0','吴春明','0396','0','*采血套餐二','15642','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 10:59:02','yyyy/mm/dd hh24:mi:ss'),'7492','20250103001484','2','E','I0015681','一次性使用静脉血样采集针','J-7软连接式0.7/威高','1','支','0396','0.25','0.25','0','1','J','044','150','1.0000','0.2500','4','','0','吴春明','0396','0','*采血套餐二','15642','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 10:59:02','yyyy/mm/dd hh24:mi:ss'),'7492','20250103001484','3','E','I0015765','一次性使用人体静脉血样采集容器','EDTA-K2 2ml/威海威高','2','支','0396','0.84','0.84','0','1','J','044','150','1.0000','0.4200','4','','0','吴春明','0396','0','*采血套餐二','15642','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250103001484','1','微信','132.09','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15514382' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15514382' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15514382' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15514382' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15514386' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15514386' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15514386' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15514386' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15514386' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15514386' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15514386' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15514386' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15514391' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15514391' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15514391' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15514382' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15514382' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15514382' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15514382' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15514386' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15514386' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15514386' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15514386' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15514386' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15514386' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15514386' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15514386' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15514391' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15514391' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15514391' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15514382'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15514382'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15514382'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15514382'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15514386'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15514386'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15514386'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15514386'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15514386'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15514386'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15514386'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15514386'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15514391'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15514391'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15514391'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2501031620'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2501031622'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE exam_appoints SET costs='80',charges='80',BILLING_INDICATOR='1' WHERE EXAM_NO = '2501031620'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE exam_appoints SET costs='44',charges='44',BILLING_INDICATOR='1' WHERE EXAM_NO = '2501031622'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE exam_appoints SET costs='8.09',charges='8.09',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10385920'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '10385920' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10385920'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 10:59:03
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '10385920') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2025-01-03 10:59:03
记录内容：2025-01-03 10:59:03
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2025-01-03 10:59:03
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20250103001484</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2025-01-03 10:59:03
记录内容：2025-01-03 10:59:03
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2025-01-03 11:38:38
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>00433014</patientid><visited>00433014</visited><prescriptions><prescriptionrow><prescriptionrno>15514931</prescriptionrno></prescriptionrow><prescriptionrow><prescriptionrno>15514966</prescriptionrno></prescriptionrow></prescriptions><totalamount>302.6500</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2025-01-03 11:38:38
记录内容：'15514931','15514966'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2025-01-03 11:38:38
记录内容：2025-01-03 11:38:38
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2025-01-03 11:38:38
记录内容：2025-01-03 11:38:38
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________ 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 ('20250103001745','00433014','王思齐','一般人员','自费',to_date('2025/01/03 11:38:38','yyyy/mm/dd hh24:mi:ss'),'302.65','302.65','WANG SI QI ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________ INSERT INTO drug_presc_master_temp (presc_date,presc_no,dispensary,PATIENT_ID,NAME,NAME_PHONETIC,IDENTITY,CHARGE_TYPE,PRESC_TYPE,PRESC_ATTR,PRESC_SOURCE,REPETITION,COSTS,PAYMENTS,ORDERED_BY,PRESCRIBED_BY,ENTERED_BY,DOCTOR_USER,RCPT_NO,COUNT_PER_REPETITION,CLINIC_NO,IS_SEND,SEND_WIN_NO) VALUES (to_date('2025/01/03 11:38:38','yyyy/mm/dd hh24:mi:ss'),'8281','050101','00433014','王思齐','WANG SI QI','一般人员','自费','0','门诊处方','0','1','293.65','293.65','0371','LIDD','李丹丹','LIDD','20250103001745','3','202501035531','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2025-01-03 11:38:38', 'yyyy-mm-dd hh24:mi:ss'),'8281','1','11201143680','0.1mg;1ml','醋酸曲普瑞林注射液','德国GmbH','0.1mg;1ml','支','2','201.42','201.42','.2;mg;皮下注射;1/日','1','1','0.2','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2025-01-03 11:38:38', 'yyyy-mm-dd hh24:mi:ss'),'8281','2','11002048670','1000u','注射用绒促性素1000u','青岛冠龙','1000u','支','2','92','92','2000;u;肌肉注射;1/日','2','1','2000','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2025-01-03 11:38:38', 'yyyy-mm-dd hh24:mi:ss'),'8281','3','11303152680','10ml:90mg','氯化钠注射液10ml*','津药和平','10ml:90mg','支','1','0.23','0.23','2;ml;肌肉注射;1/日','3','1','2','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/1/3 9:52:25','yyyy/mm/dd hh24:mi:ss'),'8336','00433014','1','门诊处方','0371','李丹丹','20250103001745','202501035531') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 11:38:38','yyyy/mm/dd hh24:mi:ss'),'8336','20250103001745','1','A','11201143680','醋酸曲普瑞林注射液','0.1mg;1ml德国GmbH','2','支','050101','201.42','201.42','0','1','J','044','150','1.0000','100.7100','1','.2;mg;皮下注射;1/日','0','李丹丹','0371','0','醋酸曲普瑞林注射液','11201143680','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 11:38:38','yyyy/mm/dd hh24:mi:ss'),'8336','20250103001745','2','A','11002048670','注射用绒促性素1000u','1000u青岛冠龙','2','支','050101','92','92','0','1','J','044','150','1.0000','46.0000','2','2000;u;肌肉注射;1/日','0','李丹丹','0371','0','注射用绒促性素1000u','11002048670','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 11:38:38','yyyy/mm/dd hh24:mi:ss'),'8336','20250103001745','3','A','11303152680','氯化钠注射液10ml*','10ml:90mg津药和平','1','支','050101','0.23','0.23','0','1','J','044','150','1.0000','0.2300','3','2;ml;肌肉注射;1/日','0','李丹丹','0371','0','氯化钠注射液10ml*','11303152680','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/1/3 9:52:25','yyyy/mm/dd hh24:mi:ss'),'8337','00433014','0','','0371','李丹丹','20250103001745','202501035531') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 11:38:38','yyyy/mm/dd hh24:mi:ss'),'8337','20250103001745','1','E','E0003054','皮下注射','/','1','次','0371','4.5','4.5','0','1','J','044','150','1.0000','4.5000','4','','0','李丹丹','0371','0','皮下注射','E0003052','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 11:38:38','yyyy/mm/dd hh24:mi:ss'),'8337','20250103001745','2','E','E0003040','肌肉注射','/','1','次','0371','4.5','4.5','0','1','J','044','150','1.0000','4.5000','5','','0','李丹丹','0371','0','肌肉注射','E0003040','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250103001745','1','微信','302.65','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15514931' and presc_no = '8281' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15514931' and presc_no = '8281' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15514931' and presc_no = '8281' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15514966' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15514966' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15514966' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15514966' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15514931'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15514931'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15514931'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15514966'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15514966'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2501031257'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________UPDATE exam_appoints SET costs='145.67',charges='145.67',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________UPDATE exam_appoints SET costs='120',charges='120',BILLING_INDICATOR='1' WHERE EXAM_NO = '2501031257'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00433014'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '00433014' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00433014'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 11:38:39
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '00433014') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2025-01-03 11:38:39
记录内容：2025-01-03 11:38:39
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2025-01-03 11:38:39
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20250103001745</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2025-01-03 11:38:39
记录内容：2025-01-03 11:38:39
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2025-01-03 14:19:47
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>100058874</patientid><visited>100058874</visited><prescriptions><prescriptionrow><prescriptionrno>15515828</prescriptionrno></prescriptionrow></prescriptions><totalamount>6.5800</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2025-01-03 14:19:47
记录内容：'15515828'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2025-01-03 14:19:47
记录内容：2025-01-03 14:19:47
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2025-01-03 14:19:47
记录内容：2025-01-03 14:19:47
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 14:19:47
记录内容：__________ 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 ('20250103002367','100058874','费宏坤','一般人员','自费',to_date('2025/01/03 14:19:47','yyyy/mm/dd hh24:mi:ss'),'6.58','6.58','FEI HONG KUN ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 14:19:47
记录内容：__________ INSERT INTO drug_presc_master_temp (presc_date,presc_no,dispensary,PATIENT_ID,NAME,NAME_PHONETIC,IDENTITY,CHARGE_TYPE,PRESC_TYPE,PRESC_ATTR,PRESC_SOURCE,REPETITION,COSTS,PAYMENTS,ORDERED_BY,PRESCRIBED_BY,ENTERED_BY,DOCTOR_USER,RCPT_NO,COUNT_PER_REPETITION,CLINIC_NO,IS_SEND,SEND_WIN_NO) VALUES (to_date('2025/01/03 14:19:47','yyyy/mm/dd hh24:mi:ss'),'9995','050101','100058874','费宏坤','','一般人员','自费','0','门诊处方','0','1','6.58','6.58','0303','CHIXIAOY','迟小雨','CHIXIAOY','20250103002367','1','202501039606','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 14:19:47
记录内容：__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2025-01-03 14:19:47', 'yyyy-mm-dd hh24:mi:ss'),'9995','1','10206035390','3mg*14','右佐匹克隆片*','齐鲁制药','3mg*14','盒','1','6.58','6.58','3;mg;口服;睡前','1','1','3','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 14:19:47
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/1/3 13:55:49','yyyy/mm/dd hh24:mi:ss'),'7','100058874','1','门诊处方','0303','迟小雨','20250103002367','202501039606') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 14:19:47
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 14:19:47','yyyy/mm/dd hh24:mi:ss'),'7','20250103002367','1','A','10206035390','右佐匹克隆片*','3mg*14齐鲁制药','1','盒','050101','6.58','6.58','0','1','J','044','150','1.0000','6.5800','1','3;mg;口服;睡前','0','迟小雨','0303','0','右佐匹克隆片*','10206035390','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 14:19:47
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250103002367','1','微信','6.58','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 14:19:47
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15515828' and presc_no = '9995' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 14:19:47
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15515828'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 14:19:47
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100058874'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 14:19:47
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '100058874' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 14:19:47
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100058874'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 14:19:47
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '100058874') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2025-01-03 14:19:47
记录内容：2025-01-03 14:19:47
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2025-01-03 14:19:47
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20250103002367</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2025-01-03 14:19:47
记录内容：2025-01-03 14:19:47
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2025-01-03 15:18:46
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>10729475</patientid><visited>10729475</visited><prescriptions><prescriptionrow><prescriptionrno>15516302</prescriptionrno></prescriptionrow></prescriptions><totalamount>26.3600</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2025-01-03 15:18:46
记录内容：'15516302'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2025-01-03 15:18:46
记录内容：2025-01-03 15:18:46
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2025-01-03 15:18:47
记录内容：2025-01-03 15:18:47
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 15:18:47
记录内容：__________ 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 ('20250103002723','10729475','宫丽','一般人员','自费',to_date('2025/01/03 15:18:46','yyyy/mm/dd hh24:mi:ss'),'26.36','26.36','GONG LI ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 15:18:47
记录内容：__________ INSERT INTO drug_presc_master_temp (presc_date,presc_no,dispensary,PATIENT_ID,NAME,NAME_PHONETIC,IDENTITY,CHARGE_TYPE,PRESC_TYPE,PRESC_ATTR,PRESC_SOURCE,REPETITION,COSTS,PAYMENTS,ORDERED_BY,PRESCRIBED_BY,ENTERED_BY,DOCTOR_USER,RCPT_NO,COUNT_PER_REPETITION,CLINIC_NO,IS_SEND,SEND_WIN_NO) VALUES (to_date('2025/01/03 15:18:46','yyyy/mm/dd hh24:mi:ss'),'838','050101','10729475','宫丽','','一般人员','自费','0','门诊处方','0','1','26.36','26.36','0303','CHIXIAOY','迟小雨','CHIXIAOY','20250103002723','1','20250103438','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 15:18:47
记录内容：__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2025-01-03 15:18:46', 'yyyy-mm-dd hh24:mi:ss'),'838','1','10211014390','50mg*28','盐酸舍曲林片(50mg*28)','京新药业','50mg*28','盒','1','26.36','26.36','50;mg;口服;1/日','1','1','50','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 15:18:47
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/1/3 15:18:10','yyyy/mm/dd hh24:mi:ss'),'969','10729475','1','门诊处方','0303','迟小雨','20250103002723','20250103954') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 15:18:47
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/01/03 15:18:46','yyyy/mm/dd hh24:mi:ss'),'969','20250103002723','1','A','10211014390','盐酸舍曲林片(50mg*28)','50mg*28京新药业','1','盒','050101','26.36','26.36','0','1','J','044','150','1.0000','26.3600','1','50;mg;口服;1/日','0','迟小雨','0303','0','盐酸舍曲林片(50mg*28)','10211014390','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 15:18:47
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250103002723','1','微信','26.36','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 15:18:47
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15516302' and presc_no = '838' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 15:18:47
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15516302'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 15:18:47
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10729475'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 15:18:47
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '10729475' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 15:18:47
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10729475'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2025-01-03 15:18:47
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '10729475') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2025-01-03 15:18:47
记录内容：2025-01-03 15:18:47
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2025-01-03 15:18:47
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20250103002723</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2025-01-03 15:18:47
记录内容：2025-01-03 15:18:47
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆