◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2025-05-19 08:18:18 记录内容：cyys_2017@123cyys_2017@1231002804131002804131629137416291380220.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2025-05-19 08:18:18 记录内容：'16291374','16291380' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2025-05-19 08:18:18 记录内容：2025-05-19 08:18:18 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2025-05-19 08:18:18 记录内容：2025-05-19 08:18:18 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18: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 ('20250519000648','100280413','刘宝仪','一般人员','自费',to_date('2025/05/19 08:18:18','yyyy/mm/dd hh24:mi:ss'),'220','220','LIU BAO YI ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18: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('2025/5/19 7:52:58','yyyy/mm/dd hh24:mi:ss'),'1643','100280413','0','','0360','张晶晶','20250519000648','20250519231') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18: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('2025/05/19 08:18:18','yyyy/mm/dd hh24:mi:ss'),'1643','20250519000648','1','D','D0914213','临床量表评估（自评）','/','1','次.日','03112','10','10','0','1','J','044','150','1.0000','10.0000','1','','0','张晶晶','0360','0','河北认知辅助评估','JC0022369','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18: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('2025/05/19 08:18:18','yyyy/mm/dd hh24:mi:ss'),'1643','20250519000648','2','D','D0914216','临床量表评估(自评)-丁类评估(加收)','/','1','次.日','03112','15','15','0','1','J','044','150','1.0000','15.0000','1','','0','张晶晶','0360','0','河北认知辅助评估','JC0022369','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18: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('2025/05/19 08:18:18','yyyy/mm/dd hh24:mi:ss'),'1643','20250519000648','3','D','D0914217','临床量表评估(他评)','/','1','次.日','03112','15','15','0','1','J','044','150','1.0000','15.0000','2','','0','张晶晶','0360','0','临床记忆测验','JC0022217','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18: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('2025/05/19 08:18:18','yyyy/mm/dd hh24:mi:ss'),'1643','20250519000648','4','D','D0914220','临床量表评估(他评)-丁类评估(加收)','/','1','次.日','03112','45','45','0','1','J','044','150','1.0000','45.0000','2','','0','张晶晶','0360','0','临床记忆测验','JC0022217','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18: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('2025/5/19 7:52:58','yyyy/mm/dd hh24:mi:ss'),'1644','100280413','0','','0360','张晶晶','20250519000648','20250519231') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18: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('2025/05/19 08:18:18','yyyy/mm/dd hh24:mi:ss'),'1644','20250519000648','1','D','D0900004','特殊脑电图','/','1','次','030301','65','65','0','1','J','008','150','1.0000','65.0000','3','','0','张晶晶','0360','0','脑ET(脑电图+脑地形图)','JC001463','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18: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('2025/05/19 08:18:18','yyyy/mm/dd hh24:mi:ss'),'1644','20250519000648','2','D','D0900005','脑地形图','/','1','次','030301','70','70','0','1','J','008','150','1.0000','70.0000','3','','0','张晶晶','0360','0','脑ET(脑电图+脑地形图)','JC001463','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18:19 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250519000648','1','微信','220','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18:19 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16291374' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18:19 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16291374' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18:19 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16291374' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18:19 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16291374' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18:19 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16291380' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18:19 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16291380' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18:19 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16291374' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18:19 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16291374' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18:19 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16291374' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18:19 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16291374' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18:19 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16291380' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18:19 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16291380' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18:19 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16291374' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18:19 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16291374' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18:19 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16291374' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18:19 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16291374' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18:19 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16291380' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18:19 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16291380' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18:19 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100280413' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18:19 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100280413' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18:19 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100280413' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:18:19 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100280413') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2025-05-19 08:18:19 记录内容：2025-05-19 08:18:19 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2025-05-19 08:18:19 记录内容：1成功120250519000648 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2025-05-19 08:18:19 记录内容：2025-05-19 08:18:19 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2025-05-19 08:29:14 记录内容：cyys_2017@123cyys_2017@123Z00034451Z0003445116291655180.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2025-05-19 08:29:14 记录内容：'16291655' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2025-05-19 08:29:14 记录内容：2025-05-19 08:29:14 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2025-05-19 08:29:14 记录内容：2025-05-19 08:29:14 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________ 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 ('20250519000735','Z00034451','王菁洋','一般人员','自费',to_date('2025/05/19 08:29:14','yyyy/mm/dd hh24:mi:ss'),'180','180','WANG YANG ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________ 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('2025/5/19 8:21:42','yyyy/mm/dd hh24:mi:ss'),'2061','Z00034451','0','','0306','赵学林','20250519000735','202505191756') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________ 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('2025/05/19 08:29:14','yyyy/mm/dd hh24:mi:ss'),'2061','20250519000735','1','E','D0903002','纯音听阈测定','/','1','次','0306','30','30','0','1','B','016','900','1.0000','30.0000','1','','0','赵学林','0306','0','纯音听阈测定','10849','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________ 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('2025/05/19 08:29:14','yyyy/mm/dd hh24:mi:ss'),'2061','20250519000735','2','E','D0903010','声导抗测听','/','1','次','0306','50','50','0','1','B','016','900','1.0000','50.0000','2','','0','赵学林','0306','0','声导抗测听','10857','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________ 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('2025/05/19 08:29:14','yyyy/mm/dd hh24:mi:ss'),'2061','20250519000735','3','D','D0903049','电耳镜检查','/','1','次','0306','10','10','0','1','J','044','150','1.0000','10.0000','3','','0','赵学林','0306','0','电耳镜检查','10897','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________ 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('2025/05/19 08:29:14','yyyy/mm/dd hh24:mi:ss'),'2061','20250519000735','4','E','D120120','图文报告','/','1','次','0306','10','10','0','1','J','044','150','1.0000','10.0000','4','','0','赵学林','0306','0','电子内镜图文报告*','11457','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________ 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('2025/05/19 08:29:14','yyyy/mm/dd hh24:mi:ss'),'2061','20250519000735','5','D','D0903085','耳纤维内镜检查','/','1','次','0306','80','80','0','1','J','016','150','1.0000','80.0000','5','','0','赵学林','0306','0','耳纤维内镜检查','JC001092','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250519000735','1','微信','180','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16291655' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16291655' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16291655' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16291655' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16291655' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16291655' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16291655' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16291655' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16291655' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16291655' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16291655' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16291655' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16291655' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16291655' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16291655' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'Z00034451' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = 'Z00034451' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'Z00034451' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 08:29:14 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = 'Z00034451') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2025-05-19 08:29:14 记录内容：2025-05-19 08:29:14 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2025-05-19 08:29:14 记录内容：1成功120250519000735 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2025-05-19 08:29:14 记录内容：2025-05-19 08:29:14 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2025-05-19 09:13:19 记录内容：cyys_2017@123cyys_2017@1231074542210745422162923801629238816292463185.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2025-05-19 09:13:19 记录内容：'16292380','16292388','16292463' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2025-05-19 09:13:19 记录内容：2025-05-19 09:13:19 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2025-05-19 09:13:19 记录内容：2025-05-19 09:13:19 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13: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 ('20250519001100','10745422','唐欢','一般人员','自费',to_date('2025/05/19 09:13:19','yyyy/mm/dd hh24:mi:ss'),'185','185','TANG HUAN ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13: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('2025/5/19 8:21:50','yyyy/mm/dd hh24:mi:ss'),'3905','10745422','0','','0311','杨云波','20250519001100','202505191757') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13: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('2025/05/19 09:13:19','yyyy/mm/dd hh24:mi:ss'),'3905','20250519001100','1','C','H0001049','尿液分析','/','1','次','0411','6','6','0','1','J','044','150','1.0000','6.0000','1','','0','杨云波','0311','0','*尿常规+尿沉渣定量','JY000120','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13: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('2025/05/19 09:13:19','yyyy/mm/dd hh24:mi:ss'),'3905','20250519001100','2','C','H0001055','尿有形成分分析','/','1','项','0411','19','19','0','1','J','044','150','1.0000','19.0000','1','','0','杨云波','0311','0','*尿常规+尿沉渣定量','JY000120','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13: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('2025/5/19 8:21:50','yyyy/mm/dd hh24:mi:ss'),'3906','10745422','0','','0311','杨云波','20250519001100','202505191757') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13: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('2025/05/19 09:13:19','yyyy/mm/dd hh24:mi:ss'),'3906','20250519001100','1','C','H0400013','一般细菌培养及鉴定','/','1','项','0411','50','50','0','1','M','025','190','1.0000','50.0000','2','','0','杨云波','0311','0','*一般细菌培养及鉴定+药敏','JY000729','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13: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('2025/5/19 8:21:50','yyyy/mm/dd hh24:mi:ss'),'3907','10745422','0','','0311','杨云波','20250519001100','202505191757') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13: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('2025/05/19 09:13:19','yyyy/mm/dd hh24:mi:ss'),'3907','20250519001100','1','D','D1201161','彩色多普勒超声检查(常规)','/','1','部位','0409','110','110','0','1','J','044','150','1.0000','110.0000','3','','0','杨云波','0311','0','泌尿系彩色多普勒超声检查','JC0022382','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13:20 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250519001100','1','微信','185','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13:20 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16292380' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13:20 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16292380' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13:20 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16292388' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13:20 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16292463' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13:20 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16292380' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13:20 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16292380' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13:20 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16292388' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13:20 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16292463' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13:20 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16292380' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13:20 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16292380' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13:20 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16292388' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13:20 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16292463' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13:20 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2505192587' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13:20 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2505192579' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13:20 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5490757' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13:20 记录内容：__________UPDATE exam_appoints SET costs='50',charges='50',BILLING_INDICATOR='1' WHERE EXAM_NO = '2505192587' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13:20 记录内容：__________UPDATE exam_appoints SET costs='25',charges='25',BILLING_INDICATOR='1' WHERE EXAM_NO = '2505192579' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13:20 记录内容：__________UPDATE exam_appoints SET costs='110',charges='110',BILLING_INDICATOR='1' WHERE EXAM_NO = '5490757' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13:20 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10745422' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13:20 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10745422' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13:20 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10745422' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:13:20 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10745422') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2025-05-19 09:13:20 记录内容：2025-05-19 09:13:20 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2025-05-19 09:13:20 记录内容：1成功120250519001100 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2025-05-19 09:13:20 记录内容：2025-05-19 09:13:20 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2025-05-19 09:44:55 记录内容：cyys_2017@123cyys_2017@123Z00318143Z003181431629319375.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2025-05-19 09:44:55 记录内容：'16293193' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2025-05-19 09:44:55 记录内容：2025-05-19 09:44:55 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2025-05-19 09:44:55 记录内容：2025-05-19 09:44:55 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:44:55 记录内容：__________ 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 ('20250519001348','Z00318143','罗菲菲','一般人员','自费',to_date('2025/05/19 09:44:55','yyyy/mm/dd hh24:mi:ss'),'75','75','LUO FEI FEI ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:44:55 记录内容：__________ 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('2025/5/19 9:36:39','yyyy/mm/dd hh24:mi:ss'),'5053','Z00318143','0','','0371','李丹丹','20250519001348','202505194748') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:44:55 记录内容：__________ 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('2025/05/19 09:44:55','yyyy/mm/dd hh24:mi:ss'),'5053','20250519001348','1','D','D1201157','B型超声检查-腔内检查(加收)','/','1','部位','0371','20','20','0','1','J','044','150','1.0000','20.0000','1','','0','李丹丹','0371','0','*生殖卵泡监测','JC000924','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:44:55 记录内容：__________ 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('2025/05/19 09:44:55','yyyy/mm/dd hh24:mi:ss'),'5053','20250519001348','2','D','D1201165','彩色多普勒超声检查(常规)-排卵监测(减收)','/','1','部位','0371','55','55','0','1','J','044','150','1.0000','55.0000','1','','0','李丹丹','0371','0','*生殖卵泡监测','JC000924','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:44:55 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250519001348','1','微信','75','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:44:55 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16293193' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:44:55 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16293193' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:44:55 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16293193' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:44:55 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16293193' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:44:55 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16293193' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:44:55 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16293193' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:44:55 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:44:55 记录内容：__________UPDATE exam_appoints SET costs='75',charges='75',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:44:55 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'Z00318143' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:44:55 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = 'Z00318143' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:44:55 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'Z00318143' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 09:44:55 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = 'Z00318143') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2025-05-19 09:44:55 记录内容：2025-05-19 09:44:55 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2025-05-19 09:44:55 记录内容：1成功120250519001348 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2025-05-19 09:44:55 记录内容：2025-05-19 09:44:55 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2025-05-19 10:12:07 记录内容：cyys_2017@123cyys_2017@123Z00410932Z004109321629367816293683127.67001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2025-05-19 10:12:07 记录内容：'16293678','16293683' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2025-05-19 10:12:07 记录内容：2025-05-19 10:12:07 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2025-05-19 10:12:07 记录内容：2025-05-19 10:12:07 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________ 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 ('20250519001604','Z00410932','王鑫淼','一般人员','自费',to_date('2025/05/19 10:12:07','yyyy/mm/dd hh24:mi:ss'),'127.67','127.67','WANG ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________ 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('2025/5/18 10:27:52','yyyy/mm/dd hh24:mi:ss'),'5915','Z00410932','0','','0316','韩卫灵','20250519001604','202505185044') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________ 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('2025/05/19 10:12:07','yyyy/mm/dd hh24:mi:ss'),'5915','20250519001604','1','C','H0209103','孕酮测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','韩卫灵','0316','0','*早孕三项','JY001292','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________ 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('2025/05/19 10:12:07','yyyy/mm/dd hh24:mi:ss'),'5915','20250519001604','2','C','H0209100','雌二醇测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','韩卫灵','0316','0','*早孕三项','JY001292','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________ 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('2025/05/19 10:12:07','yyyy/mm/dd hh24:mi:ss'),'5915','20250519001604','3','C','H0209106','血清人绒毛膜促性腺激素测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','韩卫灵','0316','0','*早孕三项','JY001292','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________ 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('2025/5/18 10:27:52','yyyy/mm/dd hh24:mi:ss'),'5916','Z00410932','0','','0316','韩卫灵','20250519001604','202505185044') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________ 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('2025/05/19 10:12:07','yyyy/mm/dd hh24:mi:ss'),'5916','20250519001604','1','E','E0003052','静脉采血','/','1','次','0316','7','7','0','1','B','016','900','1.0000','7.0000','2','','0','韩卫灵','0316','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________ 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('2025/05/19 10:12:07','yyyy/mm/dd hh24:mi:ss'),'5916','20250519001604','2','E','I0015681','一次性使用静脉血样采集针','J-7软连接式0.7/威高','1','支','0316','0.25','0.25','0','1','J','044','150','1.0000','0.2500','2','','0','韩卫灵','0316','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________ 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('2025/05/19 10:12:07','yyyy/mm/dd hh24:mi:ss'),'5916','20250519001604','3','E','I0015765','一次性使用人体静脉血样采集容器','EDTA-K2 2ml/威海威高','1','支','0316','0.42','0.42','0','1','J','044','150','1.0000','0.4200','2','','0','韩卫灵','0316','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250519001604','1','微信','127.67','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16293678' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16293678' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16293678' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16293683' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16293683' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16293683' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16293678' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16293678' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16293678' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16293683' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16293683' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16293683' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16293678' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16293678' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16293678' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16293683' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16293683' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16293683' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2505193224' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE exam_appoints SET costs='7.67',charges='7.67',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE exam_appoints SET costs='120',charges='120',BILLING_INDICATOR='1' WHERE EXAM_NO = '2505193224' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'Z00410932' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = 'Z00410932' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'Z00410932' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:12:08 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = 'Z00410932') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2025-05-19 10:12:08 记录内容：2025-05-19 10:12:08 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2025-05-19 10:12:08 记录内容：1成功120250519001604 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2025-05-19 10:12:08 记录内容：2025-05-19 10:12:08 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2025-05-19 10:29:57 记录内容：cyys_2017@123cyys_2017@1231004027631004027631629400816294031162940331629403716294040228.93001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2025-05-19 10:29:57 记录内容：'16294008','16294031','16294033','16294037','16294040' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2025-05-19 10:29:57 记录内容：2025-05-19 10:29:57 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2025-05-19 10:29:57 记录内容：2025-05-19 10:29:57 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________ 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 ('20250519001756','100402763','曲莹','一般人员','自费',to_date('2025/05/19 10:29:57','yyyy/mm/dd hh24:mi:ss'),'228.93','228.93','QU YING ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________ 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('2025/5/18 23:32:22','yyyy/mm/dd hh24:mi:ss'),'6476','100402763','0','','0315','马伟杰','20250519001756','20250518496') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________ 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('2025/05/19 10:29:57','yyyy/mm/dd hh24:mi:ss'),'6476','20250519001756','1','C','H0209042','血清游离三碘甲状原氨酸(FT3)测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','马伟杰','0315','0','*游离甲功三项','JY000142','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________ 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('2025/05/19 10:29:57','yyyy/mm/dd hh24:mi:ss'),'6476','20250519001756','2','C','H0209039','血清游离甲状腺素(FT4)测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','马伟杰','0315','0','*游离甲功三项','JY000142','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________ 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('2025/05/19 10:29:57','yyyy/mm/dd hh24:mi:ss'),'6476','20250519001756','3','C','H0209003','血清促甲状腺激素测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','马伟杰','0315','0','*游离甲功三项','JY000142','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________ 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('2025/5/18 23:32:22','yyyy/mm/dd hh24:mi:ss'),'6478','100402763','0','','0315','马伟杰','20250519001756','20250518496') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________ 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('2025/05/19 10:29:57','yyyy/mm/dd hh24:mi:ss'),'6478','20250519001756','1','C','H0204003','血清总胆红素测定(化学法或酶促法)','/','1','项','0411','5','5','0','1','M','025','190','1.0000','5.0000','2','','0','马伟杰','0315','0','*肝功8','JY000028','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________ 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('2025/05/19 10:29:57','yyyy/mm/dd hh24:mi:ss'),'6478','20250519001756','2','C','H0204007','血清直接胆红素测定(化学法或酶促法)','/','1','项','0411','5','5','0','1','M','025','190','1.0000','5.0000','2','','0','马伟杰','0315','0','*肝功8','JY000028','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________ 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('2025/05/19 10:29:57','yyyy/mm/dd hh24:mi:ss'),'6478','20250519001756','3','C','H0204025','血清丙氨酸氨基转移酶测定(速率法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','2','','0','马伟杰','0315','0','*肝功8','JY000028','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________ 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('2025/05/19 10:29:57','yyyy/mm/dd hh24:mi:ss'),'6478','20250519001756','4','C','H0204029','血清天门冬氨酸氨基转移酶测定(速率法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','2','','0','马伟杰','0315','0','*肝功8','JY000028','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________ 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('2025/05/19 10:29:57','yyyy/mm/dd hh24:mi:ss'),'6478','20250519001756','5','C','H0204033','血清γ-谷氨酰基转移酶测定(速率法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','2','','0','马伟杰','0315','0','*肝功8','JY000028','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________ 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('2025/05/19 10:29:57','yyyy/mm/dd hh24:mi:ss'),'6478','20250519001756','6','C','H0204038','血清碱性磷酸酶测定(速率法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','2','','0','马伟杰','0315','0','*肝功8','JY000028','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________ 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('2025/05/19 10:29:57','yyyy/mm/dd hh24:mi:ss'),'6478','20250519001756','7','C','H0204046','血清胆碱酯酶测定(速率法)','/','1','项','0411','15','15','0','1','M','025','190','1.0000','15.0000','2','','0','马伟杰','0315','0','*肝功8','JY000028','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________ 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('2025/5/18 23:32:22','yyyy/mm/dd hh24:mi:ss'),'6479','100402763','0','','0315','马伟杰','20250519001756','20250518496') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________ 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('2025/05/19 10:29:57','yyyy/mm/dd hh24:mi:ss'),'6479','20250519001756','1','C','H0201028','血细胞分析（五分类收）','/','1','项','0411','11','11','0','1','A','032','200','1.0000','11.0000','3','','0','马伟杰','0315','0','*血常规','21313','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________ 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('2025/5/18 23:32:22','yyyy/mm/dd hh24:mi:ss'),'6480','100402763','0','','0315','马伟杰','20250519001756','20250518496') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________ 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('2025/05/19 10:29:57','yyyy/mm/dd hh24:mi:ss'),'6480','20250519001756','1','C','H0209051','促甲状腺素受体抗体测定(化学发光法)','/','1','项','0435','40','40','0','1','A','032','200','1.0000','40.0000','4','','0','马伟杰','0315','0','*促甲状腺素受体抗体测定','JY000670','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________ 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('2025/5/18 23:32:22','yyyy/mm/dd hh24:mi:ss'),'6481','100402763','0','','0315','马伟杰','20250519001756','20250518496') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________ 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('2025/05/19 10:29:57','yyyy/mm/dd hh24:mi:ss'),'6481','20250519001756','1','E','E0003052','静脉采血','/','1','次','0329','7','7','0','1','A','032','200','1.0000','7.0000','5','','0','马伟杰','0315','0','*采血套餐四','15644','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________ 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('2025/05/19 10:29:57','yyyy/mm/dd hh24:mi:ss'),'6481','20250519001756','2','E','I0015681','一次性使用静脉血样采集针','J-7软连接式0.7/威高','1','支','0315','0.25','0.25','0','1','A','032','200','1.0000','0.2500','5','','0','马伟杰','0315','0','*采血套餐四','15644','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________ 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('2025/05/19 10:29:57','yyyy/mm/dd hh24:mi:ss'),'6481','20250519001756','3','E','I0015765','一次性使用人体静脉血样采集容器','EDTA-K2 2ml/威海威高','4','支','0315','1.68','1.68','0','1','A','032','200','1.0000','0.4200','5','','0','马伟杰','0315','0','*采血套餐四','15644','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250519001756','1','微信','228.93','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16294008' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16294008' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16294008' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16294031' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16294031' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16294031' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16294031' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16294031' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16294031' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16294031' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16294033' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16294037' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16294040' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16294040' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16294040' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16294008' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16294008' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16294008' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16294031' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16294031' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16294031' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16294031' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16294031' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16294031' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16294031' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16294033' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16294037' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16294040' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16294040' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16294040' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16294008' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16294008' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16294008' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16294031' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16294031' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16294031' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16294031' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16294031' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16294031' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16294031' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16294033' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16294037' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16294040' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16294040' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16294040' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2505193442' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2505193443' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2505193437' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2505193440' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE exam_appoints SET costs='8.93',charges='8.93',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE exam_appoints SET costs='11',charges='11',BILLING_INDICATOR='1' WHERE EXAM_NO = '2505193442' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE exam_appoints SET costs='40',charges='40',BILLING_INDICATOR='1' WHERE EXAM_NO = '2505193443' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE exam_appoints SET costs='120',charges='120',BILLING_INDICATOR='1' WHERE EXAM_NO = '2505193437' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE exam_appoints SET costs='49',charges='49',BILLING_INDICATOR='1' WHERE EXAM_NO = '2505193440' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100402763' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100402763' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100402763' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 10:29:59 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100402763') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2025-05-19 10:29:59 记录内容：2025-05-19 10:29:59 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2025-05-19 10:29:59 记录内容：1成功120250519001756 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2025-05-19 10:29:59 记录内容：2025-05-19 10:29:59 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2025-05-19 11:25:30 记录内容：cyys_2017@123cyys_2017@1230011029000110290162948801629488216294884510.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2025-05-19 11:25:30 记录内容：'16294880','16294882','16294884' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2025-05-19 11:25:30 记录内容：2025-05-19 11:25:30 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2025-05-19 11:25:30 记录内容：2025-05-19 11:25:30 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________ 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 ('20250519002191','00110290','秦少博','一般人员','自费',to_date('2025/05/19 11:25:30','yyyy/mm/dd hh24:mi:ss'),'510','510','QIN SHAO BO ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________ 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('2025/5/19 9:05:14','yyyy/mm/dd hh24:mi:ss'),'7958','00110290','0','','0359','谭琛','20250519002191','202505193553') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________ 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('2025/05/19 11:25:30','yyyy/mm/dd hh24:mi:ss'),'7958','20250519002191','1','D','D0906041','十二导动态心电图','/','1','次','0359','260','260','0','1','J','007','150','1.0000','260.0000','1','','0','谭琛','0359','0','十二导动态心电图','11369','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________ 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('2025/5/19 9:05:14','yyyy/mm/dd hh24:mi:ss'),'7959','00110290','0','','0359','谭琛','20250519002191','202505193553') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________ 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('2025/05/19 11:25:30','yyyy/mm/dd hh24:mi:ss'),'7959','20250519002191','1','D','D1201167','彩色多普勒超声检查(心脏)','/','1','次','0359','230','230','0','1','J','044','150','1.0000','230.0000','2','','0','谭琛','0359','0','心脏彩色多普勒超声检查(心血管内科)','JC001925','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________ 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('2025/5/19 9:05:14','yyyy/mm/dd hh24:mi:ss'),'7960','00110290','0','','0359','谭琛','20250519002191','202505193553') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________ 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('2025/05/19 11:25:30','yyyy/mm/dd hh24:mi:ss'),'7960','20250519002191','1','D','D0906001','常规心电图检查','/','1','次','0359','10','10','0','1','J','007','150','1.0000','10.0000','3','','0','谭琛','0359','0','*常规心电图','JC000124','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________ 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('2025/05/19 11:25:30','yyyy/mm/dd hh24:mi:ss'),'7960','20250519002191','2','D','D0906045','常规心电图检查(十二通道加收)','/','1','次','0359','10','10','0','1','H','007','150','1.0000','10.0000','3','','0','谭琛','0359','0','*常规心电图','JC000124','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250519002191','1','微信','510','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16294880' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16294882' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16294884' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16294884' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16294880' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16294882' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16294884' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16294884' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16294880' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16294882' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16294884' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16294884' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5491481' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5491480' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5491482' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________UPDATE exam_appoints SET costs='230',charges='230',BILLING_INDICATOR='1' WHERE EXAM_NO = '5491481' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________UPDATE exam_appoints SET costs='260',charges='260',BILLING_INDICATOR='1' WHERE EXAM_NO = '5491480' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________UPDATE exam_appoints SET costs='20',charges='20',BILLING_INDICATOR='1' WHERE EXAM_NO = '5491482' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00110290' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '00110290' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00110290' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 11:25:31 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '00110290') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2025-05-19 11:25:31 记录内容：2025-05-19 11:25:31 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2025-05-19 11:25:31 记录内容：1成功120250519002191 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2025-05-19 11:25:31 记录内容：2025-05-19 11:25:31 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2025-05-19 12:24:30 记录内容：cyys_2017@123cyys_2017@123Z00276417Z002764171629518216295183208.41001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2025-05-19 12:24:30 记录内容：'16295182','16295183' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2025-05-19 12:24:30 记录内容：2025-05-19 12:24:30 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2025-05-19 12:24:30 记录内容：2025-05-19 12:24:30 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 12:24:30 记录内容：__________ 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 ('20250519002445','Z00276417','林鹏飞','一般人员','自费',to_date('2025/05/19 12:24:30','yyyy/mm/dd hh24:mi:ss'),'208.41','208.41','LIN PENG FEI ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 12:24:30 记录内容：__________ 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('2025/05/19 12:24:30','yyyy/mm/dd hh24:mi:ss'),'8426','050101','Z00276417','林鹏飞','','一般人员','自费','0','门诊处方','0','1','38.89','38.89','0359','TANC','谭琛','TANC','20250519002445','1','20250519475','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 12:24:30 记录内容：__________ 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('2025/05/19 12:24:30','yyyy/mm/dd hh24:mi:ss'),'8428','050101','Z00276417','林鹏飞','','一般人员','自费','0','门诊处方','0','1','169.52','169.52','0359','TANC','谭琛','TANC','20250519002445','1','20250519475','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 12:24:30 记录内容：__________ 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('2025-05-19 12:24:30', 'yyyy-mm-dd hh24:mi:ss'),'8426','1','10408041390','10mg*30','依折麦布片（10mg*30）','山德士','10mg*30','盒','1','38.89','38.89','10;mg;口服;1/日','1','1','10','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 12:24:30 记录内容：__________ 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('2025-05-19 12:24:30', 'yyyy-mm-dd hh24:mi:ss'),'8428','1','10408021390','10mg*7','[进]瑞舒伐他汀钙片*','阿斯利康','10mg*7','盒','4','169.52','169.52','10;mg;口服;1/日','2','1','10','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 12:24:30 记录内容：__________ 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('2025/5/19 11:07:34','yyyy/mm/dd hh24:mi:ss'),'8463','Z00276417','1','门诊处方','0359','谭琛','20250519002445','202505197565') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 12:24:30 记录内容：__________ 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('2025/05/19 12:24:30','yyyy/mm/dd hh24:mi:ss'),'8463','20250519002445','1','A','10408041390','依折麦布片（10mg*30）','10mg*30山德士','1','盒','050101','38.89','38.89','0','1','J','044','150','1.0000','38.8900','1','10;mg;口服;1/日','0','谭琛','0359','0','依折麦布片（10mg*30）','10408041390','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 12:24:30 记录内容：__________ 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('2025/5/19 11:07:34','yyyy/mm/dd hh24:mi:ss'),'8464','Z00276417','1','门诊处方','0359','谭琛','20250519002445','202505197565') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 12:24:30 记录内容：__________ 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('2025/05/19 12:24:30','yyyy/mm/dd hh24:mi:ss'),'8464','20250519002445','1','A','10408021390','[进]瑞舒伐他汀钙片*','10mg*7阿斯利康','4','盒','050101','169.52','169.52','0','1','J','044','150','1.0000','42.3800','1','10;mg;口服;1/日','0','谭琛','0359','0','[进]瑞舒伐他汀钙片*','10408021390','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 12:24:30 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250519002445','1','微信','208.41','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 12:24:30 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16295182' and presc_no = '8426' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 12:24:30 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16295183' and presc_no = '8428' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 12:24:30 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16295182' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 12:24:30 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16295183' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 12:24:30 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'Z00276417' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 12:24:30 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = 'Z00276417' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 12:24:30 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'Z00276417' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 12:24:30 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = 'Z00276417') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2025-05-19 12:24:30 记录内容：2025-05-19 12:24:30 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2025-05-19 12:24:30 记录内容：1成功120250519002445 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2025-05-19 12:24:30 记录内容：2025-05-19 12:24:30 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2025-05-19 14:42:02 记录内容：cyys_2017@123cyys_2017@123Z00410932Z004109321629586816295871127.67001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2025-05-19 14:42:02 记录内容：'16295868','16295871' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2025-05-19 14:42:02 记录内容：2025-05-19 14:42:02 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2025-05-19 14:42:03 记录内容：2025-05-19 14:42:03 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42: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 ('20250519002914','Z00410932','王鑫淼','一般人员','自费',to_date('2025/05/19 14:42:02','yyyy/mm/dd hh24:mi:ss'),'127.67','127.67','WANG ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42: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('2025/5/18 10:27:52','yyyy/mm/dd hh24:mi:ss'),'9937','Z00410932','0','','0316','韩卫灵','20250519002914','202505185044') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42: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('2025/05/19 14:42:02','yyyy/mm/dd hh24:mi:ss'),'9937','20250519002914','1','C','H0209103','孕酮测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','3','','0','韩卫灵','0316','0','*早孕三项','JY001292','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42: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('2025/05/19 14:42:02','yyyy/mm/dd hh24:mi:ss'),'9937','20250519002914','2','C','H0209100','雌二醇测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','3','','0','韩卫灵','0316','0','*早孕三项','JY001292','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42: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('2025/05/19 14:42:02','yyyy/mm/dd hh24:mi:ss'),'9937','20250519002914','3','C','H0209106','血清人绒毛膜促性腺激素测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','3','','0','韩卫灵','0316','0','*早孕三项','JY001292','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42: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('2025/5/18 10:27:52','yyyy/mm/dd hh24:mi:ss'),'9938','Z00410932','0','','0316','韩卫灵','20250519002914','202505185044') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42: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('2025/05/19 14:42:02','yyyy/mm/dd hh24:mi:ss'),'9938','20250519002914','1','E','E0003052','静脉采血','/','1','次','0316','7','7','0','1','B','016','900','1.0000','7.0000','4','','0','韩卫灵','0316','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42: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('2025/05/19 14:42:03','yyyy/mm/dd hh24:mi:ss'),'9938','20250519002914','2','E','I0015681','一次性使用静脉血样采集针','J-7软连接式0.7/威高','1','支','0316','0.25','0.25','0','1','J','044','150','1.0000','0.2500','4','','0','韩卫灵','0316','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42: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('2025/05/19 14:42:03','yyyy/mm/dd hh24:mi:ss'),'9938','20250519002914','3','E','I0015765','一次性使用人体静脉血样采集容器','EDTA-K2 2ml/威海威高','1','支','0316','0.42','0.42','0','1','J','044','150','1.0000','0.4200','4','','0','韩卫灵','0316','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250519002914','1','微信','127.67','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16295868' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16295868' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16295868' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16295871' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16295871' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16295871' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16295868' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16295868' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16295868' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16295871' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16295871' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16295871' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16295868' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16295868' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16295868' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16295871' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16295871' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16295871' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2505194342' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2505193224' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE exam_appoints SET costs='15.34',charges='15.34',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE exam_appoints SET costs='120',charges='120',BILLING_INDICATOR='1' WHERE EXAM_NO = '2505194342' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE exam_appoints SET costs='120',charges='120',BILLING_INDICATOR='1' WHERE EXAM_NO = '2505193224' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'Z00410932' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = 'Z00410932' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'Z00410932' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:42:04 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = 'Z00410932') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2025-05-19 14:42:04 记录内容：2025-05-19 14:42:04 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2025-05-19 14:42:04 记录内容：1成功120250519002914 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2025-05-19 14:42:04 记录内容：2025-05-19 14:42:04 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2025-05-19 14:59:35 记录内容：cyys_2017@123cyys_2017@123100058874100058874162960466.58001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2025-05-19 14:59:35 记录内容：'16296046' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2025-05-19 14:59:35 记录内容：2025-05-19 14:59:35 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2025-05-19 14:59:35 记录内容：2025-05-19 14:59:35 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:59:35 记录内容：__________ 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 ('20250519003011','100058874','费宏坤','一般人员','自费',to_date('2025/05/19 14:59:35','yyyy/mm/dd hh24:mi:ss'),'6.58','6.58','FEI HONG KUN ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:59:35 记录内容：__________ 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('2025/05/19 14:59:35','yyyy/mm/dd hh24:mi:ss'),'219','050101','100058874','费宏坤','','一般人员','自费','0','门诊处方','0','1','6.58','6.58','0303','CHIXIAOY','迟小雨','CHIXIAOY','20250519003011','1','202505193377','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:59:35 记录内容：__________ 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('2025-05-19 14:59:35', 'yyyy-mm-dd hh24:mi:ss'),'219','1','10206035390','3mg*14','右佐匹克隆片*','齐鲁制药','3mg*14','盒','1','6.58','6.58','3;mg;口服;1/日','1','1','3','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:59:35 记录内容：__________ 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('2025/5/19 14:53:14','yyyy/mm/dd hh24:mi:ss'),'232','100058874','1','门诊处方','0303','迟小雨','20250519003011','202505193377') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:59:35 记录内容：__________ 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('2025/05/19 14:59:35','yyyy/mm/dd hh24:mi:ss'),'232','20250519003011','1','A','10206035390','右佐匹克隆片*','3mg*14齐鲁制药','1','盒','050101','6.58','6.58','0','1','J','044','150','1.0000','6.5800','1','3;mg;口服;1/日','0','迟小雨','0303','0','右佐匹克隆片*','10206035390','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:59:35 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250519003011','1','微信','6.58','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:59:35 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16296046' and presc_no = '219' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:59:35 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16296046' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:59:35 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100058874' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:59:35 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100058874' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:59:35 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100058874' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2025-05-19 14:59:35 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100058874') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2025-05-19 14:59:35 记录内容：2025-05-19 14:59:35 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2025-05-19 14:59:35 记录内容：1成功120250519003011 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2025-05-19 14:59:35 记录内容：2025-05-19 14:59:35 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆