◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:24: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 ('20200105017386','10429867','武燕如','一般人员','自费',to_date('2020/1/5 10:16:36','yyyy/mm/dd hh24:mi:ss'),'85.03','85.03','WU YAN RU ','0','1','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:24: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('2020/01/05 10:24:47','yyyy/mm/dd hh24:mi:ss'),'5594','050101','10429867','武燕如','WU YAN RU','一般人员','自费','0','门诊处方','0','1','85.03','85.03','0302','FLJ','冯连静','FLJ','20200105017386','3','202001055022','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:24: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('2020-01-05 10:24:47', 'yyyy-mm-dd hh24:mi:ss'),'5594','1','10114012270','0.1g*24','诺氟沙星胶囊','欧意药业','0.1g*24','盒','2','17','17','.3;g;口服;2/日','1','1','0.3','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:24: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('2020-01-05 10:24:47', 'yyyy-mm-dd hh24:mi:ss'),'5594','2','10606016270','0.25g*36','地衣芽孢杆菌活菌胶囊(36粒)','京新药业','0.25g*36','盒','1','35.88','35.88','.5;g;口服;3/日','2','1','0.5','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:24: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('2020-01-05 10:24:47', 'yyyy-mm-dd hh24:mi:ss'),'5594','3','20103043140','0.5g*36','枫蓼肠胃康分散片','维康药业','0.5g*36','盒','1','32.15','32.15','2;g;口服;3/日','3','1','2','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:24: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('2020/1/5 10:16:36','yyyy/mm/dd hh24:mi:ss'),'5618','10429867','1','门诊处方','0302','冯连静','20200105017386','202001055022') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:24: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('2020/01/05 10:24:47','yyyy/mm/dd hh24:mi:ss'),'5618','20200105017386','1','A','10114012270','诺氟沙星胶囊','0.1g*24欧意药业','2','盒','050101','17','17','0','1','A','032','200','1.0000','8.5000','1','.3;g;口服;2/日','0','冯连静','0302','0','诺氟沙星胶囊','10114012270','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:24: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('2020/01/05 10:24:47','yyyy/mm/dd hh24:mi:ss'),'5618','20200105017386','2','A','10606016270','地衣芽孢杆菌活菌胶囊(36粒)','0.25g*36京新药业','1','盒','050101','35.88','35.88','0','1','A','032','200','1.0000','35.8800','2','.5;g;口服;3/日','0','冯连静','0302','0','地衣芽孢杆菌活菌胶囊(36粒)','10606016270','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:24: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('2020/01/05 10:24:47','yyyy/mm/dd hh24:mi:ss'),'5618','20200105017386','3','A','20103043140','枫蓼肠胃康分散片','0.5g*36维康药业','1','盒','050101','32.15','32.15','0','1','D','033','600','1.0000','32.1500','3','2;g;口服;3/日','0','冯连静','0302','0','枫蓼肠胃康分散片','20103043140','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:24:47
记录内容：语句： INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200105017386','1','微信','85.03','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:24:47
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7242051' and presc_no = '5594' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:24:47
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7242051' and presc_no = '5594' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:24:47
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7242051' and presc_no = '5594' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:24:47
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7242051' and order_class = 'A' and order_no = '1' and order_sub_no = '1' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:24:47
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7242051' and order_class = 'A' and order_no = '2' and order_sub_no = '1' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:24:47
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7242051' and order_class = 'A' and order_no = '3' and order_sub_no = '1' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:24:47
记录内容：语句：UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10429867'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:24:47
记录内容：语句：UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '10429867' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:24:47
记录内容：语句：UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10429867'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:24:47
记录内容：语句：UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '10429867') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:01
记录内容：语句： 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 ('20200105017559','100111649','杨玉涵','一般人员','自费',to_date('2020/1/4 22:42:15','yyyy/mm/dd hh24:mi:ss'),'216.9','216.9','YANG YU HAN ','0','1','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:01
记录内容：语句： 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('2020/1/4 22:42:15','yyyy/mm/dd hh24:mi:ss'),'6210','100111649','0','','0316','郑淑华','20200105017559','202001042877') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:01
记录内容：语句： 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,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('2020/01/05 10:58:01','yyyy/mm/dd hh24:mi:ss'),'6210','20200105017559','1','C','H0700093','病原体核糖核酸扩增定性检测','/','1','','0435','160','160','0','1','1.0000','160.0000','1','','0','郑淑华','0316','0','*生殖支原体核酸检测','JY001179','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:01
记录内容：语句： 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('2020/1/4 22:42:15','yyyy/mm/dd hh24:mi:ss'),'6211','100111649','0','','0316','郑淑华','20200105017559','202001042877') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:01
记录内容：语句： 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,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('2020/01/05 10:58:01','yyyy/mm/dd hh24:mi:ss'),'6211','20200105017559','1','J','0201290363','一次性阴道照明扩张器','YZYKQ-100*28沈阳康来福','1','个','0316','18.9','18.9','0','1','1.0000','18.9000','2','','0','郑淑华','0316','0','一次性阴道照明扩张器','0201290363','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:01
记录内容：语句： 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,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('2020/01/05 10:58:01','yyyy/mm/dd hh24:mi:ss'),'6211','20200105017559','2','D','D0911065','荧光检查(二合诊检查)','/','1','','0316','38','38','0','1','1.0000','38.0000','3','','0','郑淑华','0316','0','荧光检查(二合诊检查)','JC001095','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:01
记录内容：语句： INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200105017559','1','微信','216.9','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:01
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7242318' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:01
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7242319' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:01
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7242319' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:01
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7242318' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:01
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7242319' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:01
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7242319' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:01
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7242318' and order_class = 'C' and order_no = '1' and order_sub_no = '1' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:01
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7242319' and order_class = 'J' and order_no = '2' and order_sub_no = '1' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:01
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7242319' and order_class = 'D' and order_no = '3' and order_sub_no = '1' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:26
记录内容：语句：UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:53
记录内容：语句：UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:53
记录内容：语句：UPDATE exam_appoints SET costs='113.80',charges='113.80',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:53
记录内容：语句：UPDATE exam_appoints SET costs='160',charges='160',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001052639'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:53
记录内容：语句：UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100111649'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:53
记录内容：语句：UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '100111649' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:53
记录内容：语句：UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100111649'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 10:58:53
记录内容：语句：UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '100111649') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 11:00:20
记录内容：语句： 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 ('20200105017583','100111460','蒋励','一般人员','自费',to_date('2020/1/3 20:42:50','yyyy/mm/dd hh24:mi:ss'),'80','80','JIANG LI ','0','1','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 11:00:20
记录内容：语句： 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('2020/1/3 20:42:50','yyyy/mm/dd hh24:mi:ss'),'6234','100111460','0','','0360','顾秀玲','20200105017583','202001034997') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 11:00:20
记录内容：语句： 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,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('2020/01/05 11:00:20','yyyy/mm/dd hh24:mi:ss'),'6234','20200105017583','1','E','D0914001','精神科A类量表测查','/','1','','0360','20','20','0','1','1.0000','20.0000','1','','0','顾秀玲','0360','0','精神科A类量表测查','11851','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 11:00:20
记录内容：语句： 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,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('2020/01/05 11:00:20','yyyy/mm/dd hh24:mi:ss'),'6234','20200105017583','2','E','D0914103','精神科B类量表测查','/','1','','0360','30','30','0','1','1.0000','30.0000','2','','0','顾秀玲','0360','0','精神科B类量表测查','11953','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 11:00:20
记录内容：语句： 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,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('2020/01/05 11:00:20','yyyy/mm/dd hh24:mi:ss'),'6234','20200105017583','3','E','D0914145','精神科C类量表测查','/','1','','0360','30','30','0','1','1.0000','30.0000','3','','0','顾秀玲','0360','0','精神科C类量表测查','11995','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 11:00:20
记录内容：语句： INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200105017583','1','微信','80','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 11:00:20
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7242368' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 11:00:20
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7242368' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 11:00:20
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7242368' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 11:00:20
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7242368' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 11:00:20
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7242368' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 11:00:20
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7242368' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 11:00:21
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7242368' and order_class = 'E' and order_no = '1' and order_sub_no = '1' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 11:00:21
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7242368' and order_class = 'E' and order_no = '2' and order_sub_no = '1' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 11:00:21
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7242368' and order_class = 'E' and order_no = '3' and order_sub_no = '1' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 11:00:43
记录内容：语句：UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 11:00:43
记录内容：语句：UPDATE exam_appoints SET costs='240',charges='240',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 11:00:43
记录内容：语句：UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100111460'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 11:00:43
记录内容：语句：UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '100111460' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 11:00:43
记录内容：语句：UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100111460'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 11:00:43
记录内容：语句：UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '100111460') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 16:26:38
记录内容：语句： 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 ('20200105018510','10295021','余欢','一般人员','自费',to_date('2020/1/5 16:01:38','yyyy/mm/dd hh24:mi:ss'),'39.52','39.52','YU HUAN ','0','1','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 16:26:38
记录内容：语句： 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('2020/01/05 16:26:38','yyyy/mm/dd hh24:mi:ss'),'8929','050101','10295021','余欢','YU HUAN','一般人员','自费','0','门诊处方','0','1','39.52','39.52','0312','LIUHF','刘海峰','LIUHF','20200105018510','1','202001058759','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 16:26:38
记录内容：语句： 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('2020-01-05 16:26:38', 'yyyy-mm-dd hh24:mi:ss'),'8929','1','10203021441','0.2g：20g','双氯芬酸二乙胺乳胶剂','诺华制药','0.2g：20g','支','2','39.52','39.52','2;g;外用;2/日','1','1','2','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 16:26:38
记录内容：语句： 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('2020/1/5 16:01:38','yyyy/mm/dd hh24:mi:ss'),'8954','10295021','1','门诊处方','0312','刘海峰','20200105018510','202001058759') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 16:26:38
记录内容：语句： 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('2020/01/05 16:26:38','yyyy/mm/dd hh24:mi:ss'),'8954','20200105018510','1','A','10203021441','双氯芬酸二乙胺乳胶剂','0.2g：20g诺华制药','2','支','050101','39.52','39.52','0','1','A','032','200','1.0000','19.7600','1','2;g;外用;2/日','0','刘海峰','0312','0','双氯芬酸二乙胺乳胶剂','10203021441','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 16:26:38
记录内容：语句： INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200105018510','1','微信','39.52','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 16:26:38
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7243967' and presc_no = '8929' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 16:26:38
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7243967' and order_class = 'A' and order_no = '1' and order_sub_no = '1' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 16:26:38
记录内容：语句：UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10295021'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 16:26:38
记录内容：语句：UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '10295021' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 16:26:38
记录内容：语句：UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10295021'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 16:26:38
记录内容：语句：UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '10295021') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:01
记录内容：语句： 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 ('20200105018595','M00045405','冯宝原','一般人员','自费',to_date('2020/1/5 20:27:09','yyyy/mm/dd hh24:mi:ss'),'156','156','FENG BAO YUAN ','0','1','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:01
记录内容：语句： 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('2020/1/5 20:27:09','yyyy/mm/dd hh24:mi:ss'),'9336','M00045405','0','','0304','崔淑华','20200105018595','202001059322') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:01
记录内容：语句： 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,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('2020/01/05 20:34:01','yyyy/mm/dd hh24:mi:ss'),'9336','20200105018595','1','C','H0300087','C—反应蛋白测定(CRP)全血快速定量加收','/','1','','0411','40','40','0','1','1.0000','40.0000','1','','0','崔淑华','0304','0','*急诊血常规+急诊C-反应蛋白测定(CRP)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:01
记录内容：语句： 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,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('2020/01/05 20:34:01','yyyy/mm/dd hh24:mi:ss'),'9336','20200105018595','2','C','H0300070','C-反应蛋白测定(CRP)免疫比浊法','/','1','','0411','6','6','0','1','1.0000','6.0000','1','','0','崔淑华','0304','0','*急诊血常规+急诊C-反应蛋白测定(CRP)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:01
记录内容：语句： 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,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('2020/01/05 20:34:01','yyyy/mm/dd hh24:mi:ss'),'9336','20200105018595','3','C','H0000026','血细胞分析','/','11','','0411','11','11','0','1','1.0000','1.0000','1','','0','崔淑华','0304','0','*急诊血常规+急诊C-反应蛋白测定(CRP)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:01
记录内容：语句： 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,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('2020/01/05 20:34:01','yyyy/mm/dd hh24:mi:ss'),'9336','20200105018595','4','C','H0000053','血细胞分析(流式细胞仪法每增一项指标)','/','14','','0411','14','14','0','1','1.0000','1.0000','1','','0','崔淑华','0304','0','*急诊血常规+急诊C-反应蛋白测定(CRP)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:01
记录内容：语句： 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('2020/1/5 20:27:09','yyyy/mm/dd hh24:mi:ss'),'9337','M00045405','0','','0304','崔淑华','20200105018595','202001059322') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:01
记录内容：语句： 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,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('2020/01/05 20:34:01','yyyy/mm/dd hh24:mi:ss'),'9337','20200105018595','1','C','H0302199','甲型流感病原检测','/','1','','0411','50','50','0','1','1.0000','50.0000','2','','0','崔淑华','0304','0','*甲型/乙型流感病原检测','JY000162','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:01
记录内容：语句： 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,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('2020/01/05 20:34:01','yyyy/mm/dd hh24:mi:ss'),'9337','20200105018595','2','C','H1100070','乙型流感病原检测','/','1','','0411','35','35','0','1','1.0000','35.0000','2','','0','崔淑华','0304','0','*甲型/乙型流感病原检测','JY000162','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:01
记录内容：语句： INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200105018595','1','微信','156','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:01
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7244218' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:01
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7244218' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:01
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7244218' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:01
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7244218' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:01
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7244219' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:01
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7244219' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:01
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7244218' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:01
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7244218' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:01
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7244218' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:01
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7244218' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:02
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7244219' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:02
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7244219' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:02
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7244218' and order_class = 'C' and order_no = '1' and order_sub_no = '1' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:02
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7244218' and order_class = 'C' and order_no = '1' and order_sub_no = '1' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:02
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7244218' and order_class = 'C' and order_no = '1' and order_sub_no = '1' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:02
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7244218' and order_class = 'C' and order_no = '1' and order_sub_no = '1' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:02
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7244219' and order_class = 'C' and order_no = '2' and order_sub_no = '1' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:02
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7244219' and order_class = 'C' and order_no = '2' and order_sub_no = '1' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:25
记录内容：语句：UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:47
记录内容：语句：UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:47
记录内容：语句：UPDATE exam_appoints SET costs='71',charges='71',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001053576'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:47
记录内容：语句：UPDATE exam_appoints SET costs='85',charges='85',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001053577'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:47
记录内容：语句：UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'M00045405'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:47
记录内容：语句：UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = 'M00045405' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:47
记录内容：语句：UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'M00045405'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 20:34:47
记录内容：语句：UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = 'M00045405') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 21:06:20
记录内容：语句： 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 ('20200105018598','M00045405','冯宝原','一般人员','自费',to_date('2020/1/5 20:27:09','yyyy/mm/dd hh24:mi:ss'),'175.43','175.43','FENG BAO YUAN ','0','1','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 21:06:20
记录内容：语句： 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('2020/01/05 21:06:20','yyyy/mm/dd hh24:mi:ss'),'9399','050101','M00045405','冯宝原','FENG BAO YUAN','一般人员','自费','0','门诊处方','0','1','175.43','175.43','0304','CSH','崔淑华','CSH','20200105018598','2','202001059322','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 21:06:20
记录内容：语句： 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('2020-01-05 21:06:20', 'yyyy-mm-dd hh24:mi:ss'),'9399','1','10102001191','0.125g*6','头孢克洛干混悬剂','礼来苏州','0.125g*6','盒','4','85.04','85.04','.187;g;口服;3/日','1','1','0.187','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 21:06:20
记录内容：语句： 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('2020-01-05 21:06:20', 'yyyy-mm-dd hh24:mi:ss'),'9399','2','20119026290','2g*10','小儿咽扁颗粒','北京首儿','2g*10','盒','1','90.39','90.39','1;g;口服;3/日','2','1','1','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 21:06:20
记录内容：语句： 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('2020/1/5 20:27:09','yyyy/mm/dd hh24:mi:ss'),'9407','M00045405','1','门诊处方','0304','崔淑华','20200105018598','202001059322') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 21:06:20
记录内容：语句： 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('2020/01/05 21:06:20','yyyy/mm/dd hh24:mi:ss'),'9407','20200105018598','1','A','10102001191','头孢克洛干混悬剂','0.125g*6礼来苏州','4','盒','050101','85.04','85.04','0','1','A','032','200','1.0000','21.2600','1','.187;g;口服;3/日','0','崔淑华','0304','0','头孢克洛干混悬剂','10102001191','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 21:06:20
记录内容：语句： 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('2020/01/05 21:06:20','yyyy/mm/dd hh24:mi:ss'),'9407','20200105018598','2','A','20119026290','小儿咽扁颗粒','2g*10北京首儿','1','盒','050101','90.39','90.39','0','1','D','033','600','1.0000','90.3900','2','1;g;口服;3/日','0','崔淑华','0304','0','小儿咽扁颗粒','20119026290','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 21:06:20
记录内容：语句： INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200105018598','1','微信','175.43','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 21:06:20
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7244248' and presc_no = '9399' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 21:06:20
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7244248' and presc_no = '9399' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 21:06:20
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7244248' and order_class = 'A' and order_no = '1' and order_sub_no = '1' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 21:06:20
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7244248' and order_class = 'A' and order_no = '2' and order_sub_no = '1' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 21:06:48
记录内容：语句：UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 21:07:11
记录内容：语句：UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 21:07:12
记录内容：语句：UPDATE exam_appoints SET costs='71',charges='71',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001053576'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 21:07:12
记录内容：语句：UPDATE exam_appoints SET costs='85',charges='85',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001053577'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 21:07:12
记录内容：语句：UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'M00045405'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 21:07:12
记录内容：语句：UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = 'M00045405' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 21:07:12
记录内容：语句：UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'M00045405'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-05 21:07:12
记录内容：语句：UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = 'M00045405') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆