◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2024-06-07 08:47:03 记录内容:cyys_2017@123cyys_2017@123106833931068339314306927130.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2024-06-07 08:47:03 记录内容:'14306927' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2024-06-07 08:47:04 记录内容:2024-06-07 08:47:04 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2024-06-07 08:47:04 记录内容:2024-06-07 08:47:04 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 08:47: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 ('20240607012126','10683393','赵秋芳','一般人员','自费',to_date('2024/06/07 08:47:04','yyyy/mm/dd hh24:mi:ss'),'130','130','ZHAO QIU FANG ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 08:47: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('2024/6/4 10:49:11','yyyy/mm/dd hh24:mi:ss'),'8435','10683393','0','','0316','李二雷','20240607012126','20240604744') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 08:47: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('2024/06/07 08:47:04','yyyy/mm/dd hh24:mi:ss'),'8435','20240607012126','1','D','D0602038','腔内彩色多普勒超声检查(经阴道)','/','1','次','0409','120','120','0','1','J','006','150','1.0000','120.0000','1','','0','李二雷','0316','0','*阴式超声检查','JC000102','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 08:47: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('2024/06/07 08:47:04','yyyy/mm/dd hh24:mi:ss'),'8435','20240607012126','2','D','D0607008','超声计算机图文报告','/','1','次','0409','10','10','0','1','J','006','150','1.0000','10.0000','1','','0','李二雷','0316','0','*阴式超声检查','JC000102','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 08:47:04 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240607012126','1','微信','130','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 08:47:04 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14306927' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 08:47:04 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14306927' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 08:47:04 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14306927' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 08:47:04 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14306927' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 08:47:04 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14306927' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 08:47:04 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14306927' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 08:47:04 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10683393' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 08:47:04 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10683393' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 08:47:04 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10683393' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 08:47:04 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10683393') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2024-06-07 08:47:04 记录内容:2024-06-07 08:47:04 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2024-06-07 08:47:04 记录内容:1成功120240607012126 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2024-06-07 08:47:04 记录内容:2024-06-07 08:47:04 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2024-06-07 09:52:37 记录内容:cyys_2017@123cyys_2017@12310041850110041850114307948124.20001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2024-06-07 09:52:37 记录内容:'14307948' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2024-06-07 09:52:37 记录内容:2024-06-07 09:52:37 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2024-06-07 09:52:37 记录内容:2024-06-07 09:52:37 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:52: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 ('20240607012590','100418501','孙辉','一般人员','自费',to_date('2024/06/07 09:52:37','yyyy/mm/dd hh24:mi:ss'),'124.2','124.2','SUN HUI ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:52:37 记录内容:__________ 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('2024/06/07 09:52:37','yyyy/mm/dd hh24:mi:ss'),'355','050101','100418501','孙辉','SUN HUI ','一般人员','自费','0','门诊处方','0','1','124.20','124.20','0371','ZPL','赵磐琳','ZPL','20240607012590','1','202406074944','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:52:37 记录内容:__________ 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('2024-06-07 09:52:37', 'yyyy-mm-dd hh24:mi:ss'),'355','1','11002020390','10mg*20','[进]地屈孕酮片','荷兰Abbott','10mg*20','盒','1','124.2','124.2','10;mg;口服;2/日','1','1','10','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:52: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('2024/6/4 14:58:22','yyyy/mm/dd hh24:mi:ss'),'399','100418501','1','门诊处方','0371','赵磐琳','20240607012590','202406043947') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:52: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,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('2024/06/07 09:52:37','yyyy/mm/dd hh24:mi:ss'),'399','20240607012590','1','A','11002020390','[进]地屈孕酮片','10mg*20荷兰Abbott','1','盒','050101','124.2','124.2','0','1','C','022','300','1.0000','124.2000','1','10;mg;口服;2/日','0','赵磐琳','0371','0','[进]地屈孕酮片','11002020390','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:52:37 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240607012590','1','微信','124.2','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:52:37 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14307948' and presc_no = '355' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:52:37 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14307948' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:52:37 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100418501' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:52:37 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100418501' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:52:37 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100418501' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:52:37 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100418501') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2024-06-07 09:52:37 记录内容:2024-06-07 09:52:37 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2024-06-07 09:52:37 记录内容:1成功120240607012590 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2024-06-07 09:52:37 记录内容:2024-06-07 09:52:37 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2024-06-07 09:55:52 记录内容:cyys_2017@123cyys_2017@123Z00368937Z003689371430798314307986148.52001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2024-06-07 09:55:52 记录内容:'14307983','14307986' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2024-06-07 09:55:52 记录内容:2024-06-07 09:55:52 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2024-06-07 09:55:52 记录内容:2024-06-07 09:55:52 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________ 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 ('20240607012626','Z00368937','李晴','一般人员','异地医保',to_date('2024/06/07 09:55:52','yyyy/mm/dd hh24:mi:ss'),'148.52','148.52','LI QING ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/6/7 9:49:48','yyyy/mm/dd hh24:mi:ss'),'521','Z00368937','0','','0371','赵磐琳','20240607012626','20240607333') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________ 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('2024/06/07 09:55:52','yyyy/mm/dd hh24:mi:ss'),'521','20240607012626','1','C','H0209147','特异β人绒毛膜促性腺激素(β-HCG)测定','/','1','项','0441','60','60','0','1','C','022','300','1.0000','60.0000','1','','0','赵磐琳','0371','0','*早孕三项(生殖科)','JY001311','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________ 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('2024/06/07 09:55:52','yyyy/mm/dd hh24:mi:ss'),'521','20240607012626','2','C','H0209100','雌二醇测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','赵磐琳','0371','0','*早孕三项(生殖科)','JY001311','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________ 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('2024/06/07 09:55:52','yyyy/mm/dd hh24:mi:ss'),'521','20240607012626','3','C','H0209103','孕酮测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','赵磐琳','0371','0','*早孕三项(生殖科)','JY001311','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/6/7 9:49:48','yyyy/mm/dd hh24:mi:ss'),'522','Z00368937','0','','0371','赵磐琳','20240607012626','20240607333') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________ 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('2024/06/07 09:55:52','yyyy/mm/dd hh24:mi:ss'),'522','20240607012626','1','E','E0003052','静脉采血','/','1','次','0371','7','7','0','1','C','022','300','1.0000','7.0000','2','','0','赵磐琳','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________ 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('2024/06/07 09:55:52','yyyy/mm/dd hh24:mi:ss'),'522','20240607012626','2','E','I0001053','一次性使用静脉血样采集针','0.7简易的','1','支','0371','0.47','0.47','0','1','L','031','170','1.0000','0.4700','2','','0','赵磐琳','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________ 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('2024/06/07 09:55:52','yyyy/mm/dd hh24:mi:ss'),'522','20240607012626','3','E','I0009141','一次性使用真空采血管','2ml/阳普','1','支','0371','1.05','1.05','0','1','L','031','170','1.0000','1.0500','2','','0','赵磐琳','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240607012626','1','微信','148.52','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14307983' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14307983' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14307983' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14307986' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14307986' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14307986' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14307983' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14307983' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14307983' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14307986' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14307986' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14307986' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14307983' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14307983' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14307983' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14307986' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14307986' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14307986' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'Z00368937' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = 'Z00368937' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'Z00368937' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 09:55:52 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = 'Z00368937') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2024-06-07 09:55:52 记录内容:2024-06-07 09:55:52 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2024-06-07 09:55:52 记录内容:1成功120240607012626 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2024-06-07 09:55:52 记录内容:2024-06-07 09:55:52 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2024-06-07 11:43:00 记录内容:cyys_2017@123cyys_2017@123Z00368937Z0036893714309395143093881430938914309392498.65001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2024-06-07 11:43:00 记录内容:'14309395','14309388','14309389','14309392' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2024-06-07 11:43:00 记录内容:2024-06-07 11:43:00 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2024-06-07 11:43:00 记录内容:2024-06-07 11:43:00 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________ INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20240607013330','Z00368937','李晴','一般人员','异地医保',to_date('2024/06/07 11:43:00','yyyy/mm/dd hh24:mi:ss'),'498.65','498.65','LI QING ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________ 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('2024/06/07 11:43:00','yyyy/mm/dd hh24:mi:ss'),'2681','050111','Z00368937','李晴','LI QING','一般人员','异地医保','0','门诊处方','0','1','220.13','220.13','0371','ZPL','赵磐琳','ZPL','20240607013330','2','20240607333','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________ 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('2024-06-07 11:43:00', 'yyyy-mm-dd hh24:mi:ss'),'2681','1','11002020390','10mg*20','[进]地屈孕酮片','荷兰Abbott','10mg*20','盒','1','124.2','124.2','10;mg;口服;3/日','1','1','10','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________ 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('2024-06-07 11:43:00', 'yyyy-mm-dd hh24:mi:ss'),'2681','2','11002033460','0.1g*30','黄体酮软胶囊','Cyndea S.L','0.1g*30','盒','1','95.93','95.93','.1;g;阴道内置药;1/日','2','1','0.1','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/6/7 9:49:48','yyyy/mm/dd hh24:mi:ss'),'2715','Z00368937','0','','0371','赵磐琳','20240607013330','20240607333') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,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('2024/06/07 11:43:00','yyyy/mm/dd hh24:mi:ss'),'2715','20240607013330','1','C','H0209147','特异β人绒毛膜促性腺激素(β-HCG)测定','/','1','项','0441','60','60','0','1','C','022','300','1.0000','60.0000','3','','0','赵磐琳','0371','0','*早孕三项(生殖科)','JY001311','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,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('2024/06/07 11:43:00','yyyy/mm/dd hh24:mi:ss'),'2715','20240607013330','2','C','H0209100','雌二醇测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','3','','0','赵磐琳','0371','0','*早孕三项(生殖科)','JY001311','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,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('2024/06/07 11:43:00','yyyy/mm/dd hh24:mi:ss'),'2715','20240607013330','3','C','H0209103','孕酮测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','3','','0','赵磐琳','0371','0','*早孕三项(生殖科)','JY001311','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/6/7 9:49:48','yyyy/mm/dd hh24:mi:ss'),'2716','Z00368937','0','','0371','赵磐琳','20240607013330','20240607333') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,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('2024/06/07 11:43:00','yyyy/mm/dd hh24:mi:ss'),'2716','20240607013330','1','E','E0003052','静脉采血','/','1','次','0371','7','7','0','1','C','022','300','1.0000','7.0000','4','','0','赵磐琳','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,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('2024/06/07 11:43:00','yyyy/mm/dd hh24:mi:ss'),'2716','20240607013330','2','E','I0001053','一次性使用静脉血样采集针','0.7简易的','1','支','0371','0.47','0.47','0','1','L','031','170','1.0000','0.4700','4','','0','赵磐琳','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,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('2024/06/07 11:43:00','yyyy/mm/dd hh24:mi:ss'),'2716','20240607013330','3','E','I0009141','一次性使用真空采血管','2ml/阳普','1','支','0371','1.05','1.05','0','1','L','031','170','1.0000','1.0500','4','','0','赵磐琳','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/6/7 9:49:48','yyyy/mm/dd hh24:mi:ss'),'2717','Z00368937','0','','0371','赵磐琳','20240607013330','20240607333') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,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('2024/06/07 11:43:00','yyyy/mm/dd hh24:mi:ss'),'2717','20240607013330','1','D','D0602038','腔内彩色多普勒超声检查(经阴道)','/','1','次','0409','120','120','0','1','J','006','150','1.0000','120.0000','5','','0','赵磐琳','0371','0','*阴式超声检查','JC000102','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,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('2024/06/07 11:43:00','yyyy/mm/dd hh24:mi:ss'),'2717','20240607013330','2','D','D0607008','超声计算机图文报告','/','1','次','0409','10','10','0','1','J','006','150','1.0000','10.0000','5','','0','赵磐琳','0371','0','*阴式超声检查','JC000102','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/6/7 9:49:48','yyyy/mm/dd hh24:mi:ss'),'2718','Z00368937','1','门诊处方','0371','赵磐琳','20240607013330','20240607333') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,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('2024/06/07 11:43:00','yyyy/mm/dd hh24:mi:ss'),'2718','20240607013330','1','A','11002020390','[进]地屈孕酮片','10mg*20荷兰Abbott','1','盒','050111','124.2','124.2','0','1','C','022','300','1.0000','124.2000','1','10;mg;口服;3/日','0','赵磐琳','0371','0','[进]地屈孕酮片','11002020390','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,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('2024/06/07 11:43:00','yyyy/mm/dd hh24:mi:ss'),'2718','20240607013330','2','A','11002033460','黄体酮软胶囊','0.1g*30Cyndea S.L','1','盒','050111','95.93','95.93','0','1','C','022','300','1.0000','95.9300','2','.1;g;阴道内置药;1/日','0','赵磐琳','0371','0','黄体酮软胶囊','11002033460','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240607013330','1','微信','498.65','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14309388' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14309388' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14309388' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14309389' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14309389' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14309389' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14309392' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14309392' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14309395' and presc_no = '2681' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14309395' and presc_no = '2681' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14309388' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14309388' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14309388' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14309389' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14309389' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14309389' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14309392' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14309392' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14309388' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14309388' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14309388' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14309389' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14309389' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14309389' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14309392' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14309392' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14309395' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14309395' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'Z00368937' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = 'Z00368937' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'Z00368937' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 11:43:01 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = 'Z00368937') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2024-06-07 11:43:01 记录内容:2024-06-07 11:43:01 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2024-06-07 11:43:01 记录内容:1成功120240607013330 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2024-06-07 11:43:01 记录内容:2024-06-07 11:43:01 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2024-06-07 13:09:36 记录内容:cyys_2017@123cyys_2017@1231004067081004067081430959014309592128.52001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2024-06-07 13:09:36 记录内容:'14309590','14309592' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2024-06-07 13:09:36 记录内容:2024-06-07 13:09:36 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2024-06-07 13:09:37 记录内容:2024-06-07 13:09:37 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09: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 ('20240607013451','100406708','张晓秋','一般人员','自费',to_date('2024/06/07 13:09:36','yyyy/mm/dd hh24:mi:ss'),'128.52','128.52','ZHANG XIAO QIU ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09: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('2024/6/4 13:22:19','yyyy/mm/dd hh24:mi:ss'),'3053','100406708','0','','0371','许春月','20240607013451','202406042516') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09: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,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('2024/06/07 13:09:36','yyyy/mm/dd hh24:mi:ss'),'3053','20240607013451','1','C','H0209015','血清促黄体生成素测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','许春月','0371','0','*性激素三项(生殖科)','JY001307','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09: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,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('2024/06/07 13:09:36','yyyy/mm/dd hh24:mi:ss'),'3053','20240607013451','2','C','H0209100','雌二醇测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','许春月','0371','0','*性激素三项(生殖科)','JY001307','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09: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,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('2024/06/07 13:09:36','yyyy/mm/dd hh24:mi:ss'),'3053','20240607013451','3','C','H0209103','孕酮测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','许春月','0371','0','*性激素三项(生殖科)','JY001307','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09: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('2024/6/4 13:22:19','yyyy/mm/dd hh24:mi:ss'),'3054','100406708','0','','0371','许春月','20240607013451','202406042516') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09: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,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('2024/06/07 13:09:36','yyyy/mm/dd hh24:mi:ss'),'3054','20240607013451','1','E','E0003052','静脉采血','/','1','次','0371','7','7','0','1','C','022','300','1.0000','7.0000','2','','0','许春月','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09: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,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('2024/06/07 13:09:37','yyyy/mm/dd hh24:mi:ss'),'3054','20240607013451','2','E','I0001053','一次性使用静脉血样采集针','0.7简易的','1','支','0371','0.47','0.47','0','1','L','031','170','1.0000','0.4700','2','','0','许春月','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09: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,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('2024/06/07 13:09:37','yyyy/mm/dd hh24:mi:ss'),'3054','20240607013451','3','E','I0009141','一次性使用真空采血管','2ml/阳普','1','支','0371','1.05','1.05','0','1','L','031','170','1.0000','1.0500','2','','0','许春月','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09:37 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240607013451','1','微信','128.52','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09:37 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14309590' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09:37 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14309590' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09:37 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14309590' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09:37 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14309592' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09:37 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14309592' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09:37 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14309592' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09:37 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14309590' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09:37 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14309590' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09:37 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14309590' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09:37 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14309592' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09:37 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14309592' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09:37 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14309592' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09:37 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14309590' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09:37 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14309590' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09:37 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14309590' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09:37 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14309592' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09:37 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14309592' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09:37 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14309592' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09:37 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100406708' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09:37 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100406708' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09:37 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100406708' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-06-07 13:09:37 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100406708') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2024-06-07 13:09:37 记录内容:2024-06-07 13:09:37 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2024-06-07 13:09:37 记录内容:1成功120240607013451 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2024-06-07 13:09:37 记录内容:2024-06-07 13:09:37 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆