◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 11:25: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 ('20200114017247','M00059844','赵子墨','一般人员','异地医保',to_date('2020/01/14 11:25:38','yyyy/mm/dd hh24:mi:ss'),'131.1','131.1','ZHAO ZI MO ','0','1','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 11:25: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/14 11:25:38','yyyy/mm/dd hh24:mi:ss'),'273','050101','M00059844','赵子墨','ZHAO ZI MO','一般人员','异地医保','0','门诊处方','0','1','92.90','92.90','0304','CSH','崔淑华','CSH','20200114017247','1','2020011458','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 11:25: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/14 11:25:38','yyyy/mm/dd hh24:mi:ss'),'289','050101','M00059844','赵子墨','ZHAO ZI MO','一般人员','异地医保','0','门诊处方','0','1','38.20','38.20','0304','CSH','崔淑华','CSH','20200114017247','1','2020011458','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 11:25: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-14 11:25:38', 'yyyy-mm-dd hh24:mi:ss'),'273','1','10108008390','0.25g*4','阿奇霉素片*','辉瑞制药','0.25g*4','盒','2','92.9','92.9','.25;g;口服;1/日','1','1','0.25','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 11:25: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-14 11:25:38', 'yyyy-mm-dd hh24:mi:ss'),'289','1','20110031320','50ml*2','康复新液','昆明赛诺','50ml*2','盒','1','38.2','38.2','5;ml;口服;2/日','2','1','5','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 11:25: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/14 9:32:45','yyyy/mm/dd hh24:mi:ss'),'2269','M00059844','1','门诊处方','0304','崔淑华','20200114017247','2020011458') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 11:25: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/14 11:25:38','yyyy/mm/dd hh24:mi:ss'),'2269','20200114017247','1','A','10108008390','阿奇霉素片*','0.25g*4辉瑞制药','2','盒','050101','92.9','92.9','0','1','A','032','200','1.0000','46.4500','1','.25;g;口服;1/日','0','崔淑华','0304','0','阿奇霉素片*','10108008390','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 11:25: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/14 9:32:45','yyyy/mm/dd hh24:mi:ss'),'2270','M00059844','1','门诊处方','0304','崔淑华','20200114017247','2020011458') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 11:25: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/14 11:25:38','yyyy/mm/dd hh24:mi:ss'),'2270','20200114017247','1','A','20110031320','康复新液','50ml*2昆明赛诺','1','盒','050101','38.2','38.2','0','1','D','033','600','1.0000','38.2000','1','5;ml;口服;2/日','0','崔淑华','0304','0','康复新液','20110031320','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 11:25:38 记录内容:语句: INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200114017247','1','微信','131.1','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 11:25:38 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7278203' and presc_no = '273' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 11:25:38 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7278206' and presc_no = '289' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 11:25:38 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7278203' and order_class = 'A' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 11:25:38 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7278206' and order_class = 'A' and order_no = '2' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 11:25:38 记录内容:语句:UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'M00059844' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 11:25:38 记录内容:语句:UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = 'M00059844' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 11:25:38 记录内容:语句:UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'M00059844' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 11:25:38 记录内容:语句:UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = 'M00059844') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:01:04 记录内容:语句: 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 ('20200114017384','00217263','杨超','一般人员','自费',to_date('2020/01/14 13:01:04','yyyy/mm/dd hh24:mi:ss'),'276.28','276.28','YANG CHAO ','0','1','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:01:04 记录内容:语句: 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/14 13:01:04','yyyy/mm/dd hh24:mi:ss'),'2790','050101','00217263','杨超','YANG CHAO','一般人员','自费','0','门诊处方','0','1','276.28','276.28','0315','ZHAOJS','赵景栓','ZHAOJS','20200114017384','1','202001148920','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:01:04 记录内容:语句: 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-14 13:01:04', 'yyyy-mm-dd hh24:mi:ss'),'2790','1','10607057390','25mg*30','双环醇片*','北京协和','25mg*30','盒','2','276.28','276.28','25;mg;口服;3/日','2','1','25','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:01:04 记录内容:语句: 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/14 8:46:57','yyyy/mm/dd hh24:mi:ss'),'2812','00217263','1','门诊处方','0315','赵景栓','20200114017384','202001148920') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:01:04 记录内容:语句: 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/14 13:01:04','yyyy/mm/dd hh24:mi:ss'),'2812','20200114017384','1','A','10607057390','双环醇片*','25mg*30北京协和','2','盒','050101','276.28','276.28','0','1','A','032','200','1.0000','138.1400','1','25;mg;口服;3/日','0','赵景栓','0315','0','双环醇片*','10607057390','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:01:04 记录内容:语句: INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200114017384','1','微信','276.28','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:01:04 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7279701' and presc_no = '2790' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:01:04 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7279701' and order_class = 'A' and order_no = '2' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:04:02 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:04:25 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:04:59 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:05:29 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:05:29 记录内容:语句:UPDATE exam_appoints SET costs='10.05',charges='10.05',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:05:29 记录内容:语句:UPDATE exam_appoints SET costs='49',charges='49',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001143030' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:05:29 记录内容:语句:UPDATE exam_appoints SET costs='27',charges='27',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001143036' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:05:29 记录内容:语句:UPDATE exam_appoints SET costs='180',charges='180',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001143037' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:05:30 记录内容:语句:UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00217263' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:05:30 记录内容:语句:UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '00217263' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:05:31 记录内容:语句:UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00217263' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:05:32 记录内容:语句:UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '00217263') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:18:03 记录内容:语句: insert into Clinical( patientid,doctorno, inquiryid, chief_complaint, present_medical_history, past_medical_history, examination, auxiliary_diagnose, preliminary_diagnose, handle_suggestion)values('100034367','LXH01','538','感冒发烧','感冒发烧','感冒发烧','感冒发烧','感冒发烧','感冒发烧','感冒发烧') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:54:19 记录内容:语句: 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 ('20200114017556','00197028','陈靖','一般人员','自费',to_date('2020/01/14 13:54:19','yyyy/mm/dd hh24:mi:ss'),'62.8','62.8','CHEN JING ','0','1','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:54:19 记录内容:语句: 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/14 13:54:19','yyyy/mm/dd hh24:mi:ss'),'3458','050101','00197028','陈靖','','一般人员','自费','0','门诊处方','0','1','62.80','62.80','0316','ZHENGSH','郑淑华','ZHENGSH','20200114017556','1','202001143344','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:54:19 记录内容:语句: 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-14 13:54:19', 'yyyy-mm-dd hh24:mi:ss'),'3458','1','11002003271','50mg*20','黄体酮胶囊','仙琚制药','50mg*20','盒','2','62.8','62.8','100;mg;口服;2/日','1','1','100','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:54:19 记录内容:语句: 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/14 13:45:03','yyyy/mm/dd hh24:mi:ss'),'3466','00197028','1','门诊处方','0316','郑淑华','20200114017556','202001143344') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:54:19 记录内容:语句: 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/14 13:54:19','yyyy/mm/dd hh24:mi:ss'),'3466','20200114017556','1','A','11002003271','黄体酮胶囊','50mg*20仙琚制药','2','盒','050101','62.8','62.8','0','1','A','032','200','1.0000','31.4000','1','100;mg;口服;2/日','0','郑淑华','0316','0','黄体酮胶囊','11002003271','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:54:19 记录内容:语句: INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200114017556','1','微信','62.8','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:54:19 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7280064' and presc_no = '3458' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:54:19 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7280064' and order_class = 'A' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:54:19 记录内容:语句:UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00197028' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:54:19 记录内容:语句:UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '00197028' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:54:19 记录内容:语句:UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00197028' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 13:54:19 记录内容:语句:UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '00197028') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:06:25 记录内容:语句: 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 ('20200114017929','100111775','房美琳','一般人员','自费',to_date('2020/01/14 15:06:25','yyyy/mm/dd hh24:mi:ss'),'110','110','FANG MEI LIN ','0','1','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:06:26 记录内容:语句: INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2020/1/14 14:43:51','yyyy/mm/dd hh24:mi:ss'),'4450','100111775','0','','0316','张东力','20200114017929','202001144129') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:06:26 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/14 15:06:25','yyyy/mm/dd hh24:mi:ss'),'4450','20200114017929','1','D','D0602006','妇科彩色多普勒超声常规检查','/','1','次','0409','100','100','0','1','J','006','150','1.0000','100.0000','1','','0','张东力','0316','0','*妇科彩色多普勒超声常规检查','21200','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:06:26 记录内容:语句: INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2020/01/14 15:06:25','yyyy/mm/dd hh24:mi:ss'),'4450','20200114017929','2','D','D0607008','超声计算机图文报告','/','1','次','0409','10','10','0','1','J','006','150','1.0000','10.0000','1','','0','张东力','0316','0','*妇科彩色多普勒超声常规检查','21200','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:06:26 记录内容:语句: INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200114017929','1','微信','110','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:06:26 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7280602' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:06:26 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7280602' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:06:26 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7280602' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:06:26 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7280602' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:06:26 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7280602' and order_class = 'D' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:06:26 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7280602' and order_class = 'D' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:06:52 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:06:52 记录内容:语句:UPDATE exam_appoints SET costs='110',charges='110',BILLING_INDICATOR='1' WHERE EXAM_NO = '3126285' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:06:52 记录内容:语句:UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100111775' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:06:52 记录内容:语句:UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100111775' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:06:52 记录内容:语句:UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100111775' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:06:52 记录内容:语句:UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100111775') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:07: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 ('20200114017932','00360839','王勇智','一般人员','自费',to_date('2020/01/14 15:07:13','yyyy/mm/dd hh24:mi:ss'),'1296','1296','WANG YONG ZHI ','0','1','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:07: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('2019/12/27 13:03:21','yyyy/mm/dd hh24:mi:ss'),'4454','00360839','0','','0337','王雁','20200114017932','20191227922') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:07: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/14 15:07:13','yyyy/mm/dd hh24:mi:ss'),'4454','20200114017932','1','D','D0200003','磁共振平扫','/','1','每个部位','0406','648','648','0','1','J','014','150','1.0000','648.0000','1','','0','王雁','0337','0','*骶椎磁共振平扫','21096','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:07: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('2019/12/27 13:03:21','yyyy/mm/dd hh24:mi:ss'),'4455','00360839','0','','0337','王雁','20200114017932','20191227922') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:07: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/14 15:07:13','yyyy/mm/dd hh24:mi:ss'),'4455','20200114017932','1','D','D0200003','磁共振平扫','/','1','每个部位','0406','648','648','0','1','J','014','150','1.0000','648.0000','2','','0','王雁','0337','0','*双髋关节磁共振平扫','21082','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:07:13 记录内容:语句: INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200114017932','1','微信','1296','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:07:13 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7280611' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:07:13 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7280612' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:07:13 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7280611' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:07:13 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7280612' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:07:13 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7280611' and order_class = 'D' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:07:13 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7280612' and order_class = 'D' and order_no = '2' and order_sub_no = '1' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:07:13 记录内容:语句:UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00360839' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:07:13 记录内容:语句:UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '00360839' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:07:13 记录内容:语句:UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00360839' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 15:07:13 记录内容:语句:UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '00360839') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12: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 ('20200114018208','100108955','崔庆浩','一般人员','异地医保',to_date('2020/01/14 16:12:20','yyyy/mm/dd hh24:mi:ss'),'33.05','33.05','CUI QING HAO ','0','1','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12: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/14 15:17:06','yyyy/mm/dd hh24:mi:ss'),'5206','100108955','0','','0307','陶林森','20200114018208','202001144576') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12: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/14 16:12:20','yyyy/mm/dd hh24:mi:ss'),'5206','20200114018208','1','C','H0000026','血细胞分析','/','11','项','0411','11','11','0','1','M','025','190','1.0000','1.0000','1','','0','陶林森','0307','0','*血常规','21313','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12: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/14 16:12:20','yyyy/mm/dd hh24:mi:ss'),'5206','20200114018208','2','C','H0000053','血细胞分析(流式细胞仪法每增一项指标)','/','16','项','0411','16','16','0','1','M','025','190','1.0000','1.0000','1','','0','陶林森','0307','0','*血常规','21313','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12: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/14 15:17:06','yyyy/mm/dd hh24:mi:ss'),'5207','100108955','0','','0307','陶林森','20200114018208','202001144576') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12: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/14 16:12:20','yyyy/mm/dd hh24:mi:ss'),'5207','20200114018208','1','E','E0003006','静脉采血','/','1','次','0329','3','3','0','1','B','016','900','1.0000','3.0000','2','','0','陶林森','0307','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12: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/14 16:12:20','yyyy/mm/dd hh24:mi:ss'),'5207','20200114018208','2','E','I0000483','真空采血管','/','1','支','0307','2','2','0','1','L','031','170','1.0000','2.0000','2','','0','陶林森','0307','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12: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/14 16:12:20','yyyy/mm/dd hh24:mi:ss'),'5207','20200114018208','3','E','I0000009','一次性使用静脉采血针(黑色)','/','1','支','0307','1.05','1.05','0','1','L','031','170','1.0000','1.0500','2','','0','陶林森','0307','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12:20 记录内容:语句: INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20200114018208','1','微信','33.05','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12:20 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7281068' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12:20 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7281068' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12:20 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7281070' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12:20 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7281070' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12:20 记录内容:语句:UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '7281070' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12:20 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7281068' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12:20 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7281068' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12:20 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7281070' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12:20 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7281070' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12:20 记录内容:语句:UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '7281070' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12:20 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7281068' and order_class = 'C' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12:20 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7281068' and order_class = 'C' and order_no = '1' and order_sub_no = '1' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12:20 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7281070' and order_class = 'E' and order_no = '2' and order_sub_no = '1' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12:20 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7281070' and order_class = 'E' and order_no = '2' and order_sub_no = '1' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12:20 记录内容:语句:UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '7281070' and order_class = 'E' and order_no = '2' and order_sub_no = '1' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:12:46 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:13:16 记录内容:语句:UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:13:16 记录内容:语句:UPDATE exam_appoints SET costs='6.05',charges='6.05',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:13:16 记录内容:语句:UPDATE exam_appoints SET costs='27',charges='27',BILLING_INDICATOR='1' WHERE EXAM_NO = '2001144423' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:13:16 记录内容:语句:UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100108955' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:13:16 记录内容:语句:UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100108955' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:13:16 记录内容:语句:UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100108955' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:数据库写入单条:开始重新连接! 记录时间:2020-01-14 16:13:16 记录内容:语句:UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100108955') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆