◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 11:02:37 记录内容:语句: 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 ('20200104015488','00130454','孙珊珊','一般人员','自费',to_date('2020/1/3 16:36:09','yyyy/mm/dd hh24:mi:ss'),'210','210','SUN SHAN SHAN ','0','1','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 11:02:37 记录内容:语句: 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 16:36:09','yyyy/mm/dd hh24:mi:ss'),'9049','00130454','0','','0335','马颂章','20200104015488','202001034590') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 11:02:37 记录内容:语句: 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/04 11:02:37','yyyy/mm/dd hh24:mi:ss'),'9049','20200104015488','1','D','D0602010','浅表器官彩色多普勒超声检查','/','4','','0409','200','200','0','1','1.0000','50.0000','1','','0','马颂章','0335','0','*乳腺+引流区淋巴结彩色多普勒超声','21245','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 11:02:37 记录内容:语句: 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/04 11:02:37','yyyy/mm/dd hh24:mi:ss'),'9049','20200104015488','2','D','D0607008','超声计算机图文报告','/','1','','0409','10','10','0','1','1.0000','10.0000','1','','0','马颂章','0335','0','*乳腺+引流区淋巴结彩色多普勒超声','21245','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 11:02:37 记录内容:语句: INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200104015488','1','微信','210','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 11:02:37 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7238307' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 11:02:37 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7238307' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 11:02:37 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7238307' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 11:02:37 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7238307' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 11:02:37 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7238307' and order_class = 'D' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 11:02:37 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7238307' and order_class = 'D' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 11:03:03 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 11:03:03 记录内容:语句:UPDATE exam_appoints SET costs='210',charges='210',BILLING_INDICATOR='1' WHERE EXAM_NO = '3113526' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 11:03:03 记录内容:语句:UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00130454' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 11:03:03 记录内容:语句:UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '00130454' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 11:03:03 记录内容:语句:UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00130454' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 11:03:03 记录内容:语句:UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '00130454') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 15:35:37 记录内容:语句: 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 ('20200104016462','Z00109522','田宏达','一般人员','自费',to_date('2020/1/4 15:12:46','yyyy/mm/dd hh24:mi:ss'),'110','110','TIAN HONG DA ','0','1','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 15:35:37 记录内容:语句: 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 15:12:46','yyyy/mm/dd hh24:mi:ss'),'1991','Z00109522','0','','0316','郑淑华','20200104016462','202001041697') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 15:35:37 记录内容:语句: 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/04 15:35:37','yyyy/mm/dd hh24:mi:ss'),'1991','20200104016462','1','D','D0602006','妇科彩色多普勒超声常规检查','/','1','','0409','100','100','0','1','1.0000','100.0000','1','','0','郑淑华','0316','0','*妇科彩色多普勒超声常规检查','21200','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 15:35:37 记录内容:语句: 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/04 15:35:37','yyyy/mm/dd hh24:mi:ss'),'1991','20200104016462','2','D','D0607008','超声计算机图文报告','/','1','','0409','10','10','0','1','1.0000','10.0000','1','','0','郑淑华','0316','0','*妇科彩色多普勒超声常规检查','21200','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 15:35:37 记录内容:语句: INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200104016462','1','微信','110','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 15:35:37 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7240030' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 15:35:37 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7240030' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 15:35:37 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7240030' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 15:35:37 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7240030' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 15:35:37 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7240030' and order_class = 'D' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 15:35:37 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7240030' and order_class = 'D' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 15:36:10 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 15:36:11 记录内容:语句:UPDATE exam_appoints SET costs='110',charges='110',BILLING_INDICATOR='1' WHERE EXAM_NO = '3113857' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 15:36:11 记录内容:语句:UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'Z00109522' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 15:36:11 记录内容:语句:UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = 'Z00109522' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 15:36:11 记录内容:语句:UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'Z00109522' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 15:36:11 记录内容:语句:UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = 'Z00109522') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句: 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 ('20200104016721','10385209','邓轶卓','一般人员','自费',to_date('2020/1/4 19:06:12','yyyy/mm/dd hh24:mi:ss'),'145.26','145.26','DENG ZHUO ','0','1','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句: 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 19:06:12','yyyy/mm/dd hh24:mi:ss'),'2713','10385209','0','','0330','孙伟','20200104016721','202001042683') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句: 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/04 19:39:18','yyyy/mm/dd hh24:mi:ss'),'2713','20200104016721','1','D','D0911059','胎心监测(电子)','/','1','','0205','40','40','0','1','1.0000','40.0000','6','','0','孙伟','0330','0','电子胎心监护','JC000989','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句: 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 19:06:12','yyyy/mm/dd hh24:mi:ss'),'2714','10385209','0','','0330','孙伟','20200104016721','202001042683') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句: 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/04 19:39:18','yyyy/mm/dd hh24:mi:ss'),'2714','20200104016721','1','J','0201290363','一次性阴道照明扩张器','YZYKQ-100*28沈阳康来福','1','个','0330','18.9','18.9','0','1','1.0000','18.9000','7','','0','孙伟','0330','0','一次性阴道照明扩张器','0201290363','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句: 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/04 19:39:18','yyyy/mm/dd hh24:mi:ss'),'2714','20200104016721','2','J','0201240211','一次性无菌中单','120*240/','1','块','0330','3.36','3.36','0','1','1.0000','3.3600','8','','0','孙伟','0330','0','一次性无菌中单','0201240211','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句: 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/04 19:39:18','yyyy/mm/dd hh24:mi:ss'),'2714','20200104016721','3','E','D0911014','胎心监测','/','1','','0330','3','3','0','1','1.0000','3.0000','9','','0','孙伟','0330','0','胎心监测','11687','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句: 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/04 19:39:18','yyyy/mm/dd hh24:mi:ss'),'2714','20200104016721','4','Z','C0000018','特需服务费','/','4','','0330','80','80','0','1','1.0000','20.0000','10','','0','孙伟','0330','0','特需服务费1','C0001013','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句: INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200104016721','1','微信','145.26','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7240401' and presc_no = '0' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7240402' and presc_no = '0' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7240402' and presc_no = '0' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7240402' and presc_no = '0' and item_no = '9' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7240402' and presc_no = '0' and item_no = '10' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7240401' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7240402' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7240402' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7240402' and item_no = '9' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7240402' and item_no = '10' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7240401' and order_class = 'D' and order_no = '6' and order_sub_no = '1' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7240402' and order_class = 'J' and order_no = '7' and order_sub_no = '1' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7240402' and order_class = 'J' and order_no = '8' and order_sub_no = '1' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7240402' and order_class = 'E' and order_no = '9' and order_sub_no = '1' and item_no = '9' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:18 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7240402' and order_class = 'Z' and order_no = '10' and order_sub_no = '1' and item_no = '10' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:43 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:43 记录内容:语句:UPDATE exam_appoints SET costs='461.04',charges='461.04',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:43 记录内容:语句:UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10385209' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:43 记录内容:语句:UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10385209' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:43 记录内容:语句:UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10385209' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-04 19:39:43 记录内容:语句:UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10385209') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆