◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句： 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 ('20200106000726','00361329','邹红军','一般人员','自费',to_date('2020/1/6 14:17:55','yyyy/mm/dd hh24:mi:ss'),'12.1','12.1','ZOU HONG JUN ','0','1','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句： 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/06 14:28:10','yyyy/mm/dd hh24:mi:ss'),'4800','050101','00361329','邹红军','ZOU HONG JUN','一般人员','自费','0','门诊处方','0','1','1.10','1.10','0318','CK01','陈凯','CK01','20200106000726','2','202001064668','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句： 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-06 14:28:10', 'yyyy-mm-dd hh24:mi:ss'),'4800','1','11303037670','10ml','氯化钠注射液','国药集团蓉','10ml','支','1','0.5','0.5','10;ml;皮试;即刻','1','1','10','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句： 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-06 14:28:10', 'yyyy-mm-dd hh24:mi:ss'),'4800','2','10101005170','160wu','注射用青霉素钠160万U','华北制药股','160wu','瓶','1','0.6','0.6','160;wu;皮试;即刻','1','2','160','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句： 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/6 14:17:55','yyyy/mm/dd hh24:mi:ss'),'4826','00361329','1','门诊处方','0318','陈凯','20200106000726','202001064668') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句： 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/06 14:28:10','yyyy/mm/dd hh24:mi:ss'),'4826','20200106000726','1','A','11303037670','氯化钠注射液','10ml国药集团蓉','1','支','050101','0.5','0.5','0','1','A','032','200','1.0000','0.5000','1','10;ml;皮试;即刻','0','陈凯','0318','0','氯化钠注射液','11303037670','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句： 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/06 14:28:10','yyyy/mm/dd hh24:mi:ss'),'4826','20200106000726','2','A','10101005170','注射用青霉素钠160万U','160wu华北制药股','1','瓶','050101','0.6','0.6','0','1','A','032','200','1.0000','0.6000','2','160;wu;皮试;即刻','0','陈凯','0318','0','注射用青霉素钠160万U','10101005170','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句： 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/6 14:17:55','yyyy/mm/dd hh24:mi:ss'),'4827','00361329','0','','0318','陈凯','20200106000726','202001064668') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句： 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/06 14:28:10','yyyy/mm/dd hh24:mi:ss'),'4827','20200106000726','1','E','E0003003','皮内注射','/','1','','0323','1','1','0','1','1.0000','1.0000','1','','0','陈凯','0318','0','*皮试套餐','15637','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句： 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/06 14:28:10','yyyy/mm/dd hh24:mi:ss'),'4827','20200106000726','2','E','E0003004','皮试加收','/','1','','0323','1','1','0','1','1.0000','1.0000','1','','0','陈凯','0318','0','*皮试套餐','15637','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句： 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/06 14:28:10','yyyy/mm/dd hh24:mi:ss'),'4827','20200106000726','3','E','0201220002','一次性使用无菌注射器 带针','5ml威高','1','','0318','0.5','0.5','0','1','1.0000','0.5000','1','','0','陈凯','0318','0','*皮试套餐','15637','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句： 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/06 14:28:10','yyyy/mm/dd hh24:mi:ss'),'4827','20200106000726','4','E','0201220002','一次性使用无菌注射器 带针','1ml 0.45*16威高','1','','0318','0.5','0.5','0','1','1.0000','0.5000','1','','0','陈凯','0318','0','*皮试套餐','15637','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句： 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/06 14:28:10','yyyy/mm/dd hh24:mi:ss'),'4827','20200106000726','5','E','C0000010','门急诊留观诊查费','/','1','','0323','8','8','0','1','1.0000','8.0000','2','','0','陈凯','0318','0','门急诊留观诊查费','10012','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句： INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200106000726','1','微信','12.1','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7247307' and presc_no = '4800' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7247307' and presc_no = '4800' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7247308' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7247308' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7247308' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7247308' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7247308' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7247308' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7247308' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7247308' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7247308' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7247308' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7247307' and order_class = 'A' and order_no = '1' and order_sub_no = '1' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7247307' and order_class = 'A' and order_no = '1' and order_sub_no = '2' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7247308' and order_class = 'E' and order_no = '1' and order_sub_no = '1' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7247308' and order_class = 'E' and order_no = '1' and order_sub_no = '1' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7247308' and order_class = 'E' and order_no = '1' and order_sub_no = '1' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7247308' and order_class = 'E' and order_no = '1' and order_sub_no = '1' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:10
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7247308' and order_class = 'E' and order_no = '2' and order_sub_no = '1' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:35
记录内容：语句：UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:35
记录内容：语句：UPDATE exam_appoints SET costs='22',charges='22',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:35
记录内容：语句：UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00361329'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:35
记录内容：语句：UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '00361329' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:35
记录内容：语句：UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00361329'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 14:28:35
记录内容：语句：UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '00361329') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10: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 ('20200106000956','00313229','李王梓','一般人员','自费',to_date('2020/1/6 15:01:34','yyyy/mm/dd hh24:mi:ss'),'149.49','149.49','LI WANG  ','0','1','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10: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('2020/1/6 15:01:34','yyyy/mm/dd hh24:mi:ss'),'5429','00313229','0','','0304','马官福','20200106000956','202001065283') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10: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,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/06 15:10:48','yyyy/mm/dd hh24:mi:ss'),'5429','20200106000956','1','D','D0101110','数字化摄影(DR)','/','1','','0404','60','60','0','1','1.0000','60.0000','1','','0','马官福','0304','0','*DR胸部正位片','20627','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10: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,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/06 15:10:48','yyyy/mm/dd hh24:mi:ss'),'5429','20200106000956','2','D','D0101125','14×17(加滤线器加收) ','/','1','','0404','2','2','0','1','1.0000','2.0000','1','','0','马官福','0304','0','*DR胸部正位片','20627','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10: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,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/06 15:10:48','yyyy/mm/dd hh24:mi:ss'),'5429','20200106000956','3','D','I0003473','胶片(14*17)','/广西巨星','1','','0304','16.49','16.49','0','1','1.0000','16.4900','1','','0','马官福','0304','0','*DR胸部正位片','20627','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10: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('2020/1/6 15:01:34','yyyy/mm/dd hh24:mi:ss'),'5430','00313229','0','','0304','马官福','20200106000956','202001065283') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10: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,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/06 15:10:48','yyyy/mm/dd hh24:mi:ss'),'5430','20200106000956','1','C','H0300087','C—反应蛋白测定(CRP)全血快速定量加收','/','1','','0411','40','40','0','1','1.0000','40.0000','2','','0','马官福','0304','0','*急诊血常规+急诊C-反应蛋白测定(CRP)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10: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,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/06 15:10:48','yyyy/mm/dd hh24:mi:ss'),'5430','20200106000956','2','C','H0300070','C-反应蛋白测定(CRP)免疫比浊法','/','1','','0411','6','6','0','1','1.0000','6.0000','2','','0','马官福','0304','0','*急诊血常规+急诊C-反应蛋白测定(CRP)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10: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,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/06 15:10:48','yyyy/mm/dd hh24:mi:ss'),'5430','20200106000956','3','C','H0000026','血细胞分析','/','11','','0411','11','11','0','1','1.0000','1.0000','2','','0','马官福','0304','0','*急诊血常规+急诊C-反应蛋白测定(CRP)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10: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,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/06 15:10:48','yyyy/mm/dd hh24:mi:ss'),'5430','20200106000956','4','C','H0000053','血细胞分析(流式细胞仪法每增一项指标)','/','14','','0411','14','14','0','1','1.0000','1.0000','2','','0','马官福','0304','0','*急诊血常规+急诊C-反应蛋白测定(CRP)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10:48
记录内容：语句： INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200106000956','1','微信','149.49','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10:48
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7247657' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10:48
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7247657' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10:48
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7247657' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10:48
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7247658' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10:48
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7247658' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10:48
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7247658' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10:48
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7247658' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10:48
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7247657' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10:48
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7247657' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10:48
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7247657' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10:48
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7247658' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10:48
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7247658' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10:48
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7247658' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10:48
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7247658' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10:48
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7247657' and order_class = 'D' and order_no = '1' and order_sub_no = '1' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10:48
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7247657' and order_class = 'D' and order_no = '1' and order_sub_no = '1' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10:48
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7247657' and order_class = 'D' and order_no = '1' and order_sub_no = '1' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10:48
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7247658' and order_class = 'C' and order_no = '2' and order_sub_no = '1' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10:48
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7247658' and order_class = 'C' and order_no = '2' and order_sub_no = '1' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10:48
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7247658' and order_class = 'C' and order_no = '2' and order_sub_no = '1' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:10:48
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7247658' and order_class = 'C' and order_no = '2' and order_sub_no = '1' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:11:14
记录内容：语句：UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:11:37
记录内容：语句：UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:11:37
记录内容：语句：UPDATE exam_appoints SET costs='71',charges='71',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001065519'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:11:38
记录内容：语句：UPDATE exam_appoints SET costs='78.49',charges='78.49',BILLING_INDICATOR='1' WHERE EXAM_NO = '3116061'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:11:38
记录内容：语句：UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00313229'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:11:38
记录内容：语句：UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '00313229' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:11:38
记录内容：语句：UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00313229'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:11:38
记录内容：语句：UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '00313229') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:13
记录内容：语句： 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 ('20200106000990','00361329','邹红军','一般人员','自费',to_date('2020/1/6 14:17:55','yyyy/mm/dd hh24:mi:ss'),'54.78','54.78','ZOU HONG JUN ','0','1','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:13
记录内容：语句： 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/06 15:16:13','yyyy/mm/dd hh24:mi:ss'),'5471','050101','00361329','邹红军','ZOU HONG JUN','一般人员','自费','0','门诊处方','0','1','51.60','51.60','0318','CK01','陈凯','CK01','20200106000990','2','202001064668','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:13
记录内容：语句： 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-06 15:16:13', 'yyyy-mm-dd hh24:mi:ss'),'5471','1','11303037670','10ml','氯化钠注射液','国药集团蓉','10ml','支','2','1','1','20;ml;肌肉注射;1/周','2','1','20','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:13
记录内容：语句： 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-06 15:16:13', 'yyyy-mm-dd hh24:mi:ss'),'5471','2','10101006170','120万iu','注射用苄星青霉素','中诺药业','120万iu','支','2','50.6','50.6','240;万iu;肌肉注射;1/周','2','2','240','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:13
记录内容：语句： 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/6 14:17:55','yyyy/mm/dd hh24:mi:ss'),'5503','00361329','0','','0318','陈凯','20200106000990','202001064668') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:13
记录内容：语句： 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/06 15:16:13','yyyy/mm/dd hh24:mi:ss'),'5503','20200106000990','1','E','E0003001','肌肉注射','/','2','','0323','2','2','0','1','1.0000','1.0000','3','','0','陈凯','0318','0','肌肉注射','10109','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:13
记录内容：语句： 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/06 15:16:13','yyyy/mm/dd hh24:mi:ss'),'5503','20200106000990','2','J','I0000026','一次性无菌注射器','10ml 21g/8# 0.8*38','2','支','0323','1.18','1.18','0','1','1.0000','0.5900','4','','0','陈凯','0318','0','一次性无菌注射器','I0000026','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:13
记录内容：语句： 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/6 14:17:55','yyyy/mm/dd hh24:mi:ss'),'5504','00361329','1','门诊处方','0318','陈凯','20200106000990','202001064668') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:13
记录内容：语句： 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/06 15:16:13','yyyy/mm/dd hh24:mi:ss'),'5504','20200106000990','1','A','11303037670','氯化钠注射液','10ml国药集团蓉','2','支','050101','1','1','0','1','A','032','200','1.0000','0.5000','1','20;ml;肌肉注射;1/周','0','陈凯','0318','0','氯化钠注射液','11303037670','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:13
记录内容：语句： 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/06 15:16:13','yyyy/mm/dd hh24:mi:ss'),'5504','20200106000990','2','A','10101006170','注射用苄星青霉素','120万iu中诺药业','2','支','050101','50.6','50.6','0','1','A','032','200','1.0000','25.3000','2','240;万iu;肌肉注射;1/周','0','陈凯','0318','0','注射用苄星青霉素','10101006170','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:13
记录内容：语句： INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200106000990','1','微信','54.78','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:13
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7247686' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:13
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7247686' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:13
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7247688' and presc_no = '5471' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:13
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7247688' and presc_no = '5471' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:13
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7247686' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:13
记录内容：语句：UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7247686' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:13
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7247686' and order_class = 'E' and order_no = '3' and order_sub_no = '1' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:13
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7247686' and order_class = 'J' and order_no = '4' and order_sub_no = '1' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:13
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7247688' and order_class = 'A' and order_no = '2' and order_sub_no = '1' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:13
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7247688' and order_class = 'A' and order_no = '2' and order_sub_no = '2' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:36
记录内容：语句：UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:36
记录内容：语句：UPDATE exam_appoints SET costs='28.36',charges='28.36',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:36
记录内容：语句：UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00361329'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:36
记录内容：语句：UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '00361329' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:36
记录内容：语句：UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00361329'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:16:36
记录内容：语句：UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '00361329') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:21:15
记录内容：语句： 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 ('20200106000998','100043202','杜莉','一般人员','自费',to_date('2020/1/5 20:35:20','yyyy/mm/dd hh24:mi:ss'),'141.51','141.51','DU LI ','0','1','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:21:15
记录内容：语句： 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/06 15:21:15','yyyy/mm/dd hh24:mi:ss'),'5525','050107','100043202','杜莉','','一般人员','自费','0','门诊处方','0','1','100.06','100.06','0316','ZANGY','藏禹','ZANGY','20200106000998','1','202001069340','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:21:15
记录内容：语句： 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/06 15:21:15','yyyy/mm/dd hh24:mi:ss'),'5530','050107','100043202','杜莉','','一般人员','自费','0','门诊处方','0','1','41.45','41.45','0316','ZANGY','藏禹','ZANGY','20200106000998','1','202001069340','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:21:15
记录内容：语句： 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-06 15:21:15', 'yyyy-mm-dd hh24:mi:ss'),'5525','1','11406006360','5g:0.1g*3','克林霉素磷酸酯阴道凝胶','多多药业','5g:0.1g*3','盒','2','100.06','100.06','5;g;阴道内置药;1/日','1','1','5','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:21:15
记录内容：语句： 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-06 15:21:15', 'yyyy-mm-dd hh24:mi:ss'),'5530','1','10110011270','0.1g*28','硝呋太尔胶囊','北京朗依','0.1g*28','盒','1','41.45','41.45','.2;g;口服;2/日','2','1','0.2','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:21:15
记录内容：语句： 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:35:20','yyyy/mm/dd hh24:mi:ss'),'5559','100043202','1','门诊处方','0316','藏禹','20200106000998','202001059340') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:21:15
记录内容：语句： 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/06 15:21:15','yyyy/mm/dd hh24:mi:ss'),'5559','20200106000998','1','A','11406006360','克林霉素磷酸酯阴道凝胶','5g:0.1g*3多多药业','2','盒','050107','100.06','100.06','0','1','A','032','200','1.0000','50.0300','1','5;g;阴道内置药;1/日','0','藏禹','0316','0','克林霉素磷酸酯阴道凝胶','11406006360','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:21:15
记录内容：语句： 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:35:20','yyyy/mm/dd hh24:mi:ss'),'5560','100043202','1','门诊处方','0316','藏禹','20200106000998','202001059340') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:21:15
记录内容：语句： 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/06 15:21:15','yyyy/mm/dd hh24:mi:ss'),'5560','20200106000998','1','A','10110011270','硝呋太尔胶囊','0.1g*28北京朗依','1','盒','050107','41.45','41.45','0','1','A','032','200','1.0000','41.4500','1','.2;g;口服;2/日','0','藏禹','0316','0','硝呋太尔胶囊','10110011270','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:21:15
记录内容：语句： INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200106000998','1','微信','141.51','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:21:15
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7247723' and presc_no = '5525' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:21:15
记录内容：语句：UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7247725' and presc_no = '5530' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:21:15
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7247723' and order_class = 'A' and order_no = '1' and order_sub_no = '1' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:21:15
记录内容：语句：UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7247725' and order_class = 'A' and order_no = '2' and order_sub_no = '1' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:21:42
记录内容：语句：UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:22:09
记录内容：语句：UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:22:09
记录内容：语句：UPDATE exam_appoints SET costs='113.80',charges='113.80',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:22:09
记录内容：语句：UPDATE exam_appoints SET costs='103',charges='103',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001065336'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:22:09
记录内容：语句：UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100043202'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:22:09
记录内容：语句：UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '100043202' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:22:09
记录内容：语句：UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100043202'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 15:22:09
记录内容：语句：UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '100043202') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 16:53:26
记录内容：语句：update clinic_master set registration_status='4' where visit_date=to_date('20200105','yyyy/mm/dd') and visit_no='5978' 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 16:55:04
记录内容：语句：update clinic_master set registration_status='4' where visit_date=to_date('20200105','yyyy/mm/dd') and visit_no='2565' 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 16:57:54
记录内容：语句：update clinic_master set registration_status='4' where visit_date=to_date('20200106','yyyy/mm/dd') and visit_no='8897' 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 16:58:23
记录内容：语句：update clinic_master set registration_status='4' where visit_date=to_date('20200111','yyyy/mm/dd') and visit_no='5068' 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：数据库写入单条：开始重新连接！
记录时间：2020-01-06 16:59:14
记录内容：语句：update clinic_master set registration_status='4' where visit_date=to_date('20200110','yyyy/mm/dd') and visit_no='725' 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆