◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2024-10-25 08:17:31 记录内容：cyys_2017@123cyys_2017@12310002634510002634515068223113.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2024-10-25 08:17:31 记录内容：'15068223' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2024-10-25 08:17:31 记录内容：2024-10-25 08:17:31 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2024-10-25 08:17:32 记录内容：2024-10-25 08:17:32 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________ 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 ('20241025001000','100026345','王萌','一般人员','自费',to_date('2024/10/25 08:17:31','yyyy/mm/dd hh24:mi:ss'),'113','113','WANG MENG ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/10/25 8:13:56','yyyy/mm/dd hh24:mi:ss'),'5698','100026345','0','','0371','李丹丹','20241025001000','202410255582') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/25 08:17:31','yyyy/mm/dd hh24:mi:ss'),'5698','20241025001000','1','C','H0003014','阴道分泌物检查','/','1','项','0441','3','3','0','1','M','025','190','1.0000','3.0000','1','','0','李丹丹','0371','0','*白带常规+细菌性阴道病检查(限生殖科)','JY001259','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/25 08:17:31','yyyy/mm/dd hh24:mi:ss'),'5698','20241025001000','2','C','H0400033','念珠菌镜检','/','1','每个取材','0441','5','5','0','1','M','025','190','1.0000','5.0000','1','','0','李丹丹','0371','0','*白带常规+细菌性阴道病检查(限生殖科)','JY001259','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/25 08:17:31','yyyy/mm/dd hh24:mi:ss'),'5698','20241025001000','3','C','H0400052','细菌性阴道病唾液酸酶测定','/','1','项','0441','100','100','0','1','M','025','190','1.0000','100.0000','1','','0','李丹丹','0371','0','*白带常规+细菌性阴道病检查(限生殖科)','JY001259','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/25 08:17:31','yyyy/mm/dd hh24:mi:ss'),'5698','20241025001000','4','C','H0400001','一般细菌涂片检查','/','1','项','0441','5','5','0','1','M','025','190','1.0000','5.0000','1','','0','李丹丹','0371','0','*白带常规+细菌性阴道病检查(限生殖科)','JY001259','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20241025001000','1','微信','113','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15068223' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15068223' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15068223' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15068223' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15068223' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15068223' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15068223' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15068223' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15068223' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15068223' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15068223' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15068223' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2410253336' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________UPDATE exam_appoints SET costs='113',charges='113',BILLING_INDICATOR='1' WHERE EXAM_NO = '2410253336' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100026345' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100026345' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100026345' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 08:17:32 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100026345') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2024-10-25 08:17:32 记录内容：2024-10-25 08:17:32 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2024-10-25 08:17:32 记录内容：1成功120241025001000 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2024-10-25 08:17:32 记录内容：2024-10-25 08:17:32 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2024-10-25 12:13:59 记录内容：cyys_2017@123cyys_2017@1231071732210717322150714431507144615071447120.73001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2024-10-25 12:13:59 记录内容：'15071443','15071446','15071447' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2024-10-25 12:13:59 记录内容：2024-10-25 12:13:59 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2024-10-25 12:13:59 记录内容：2024-10-25 12:13:59 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________ INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20241025002528','10717322','赵宸萱','一般人员','自费',to_date('2024/10/25 12:13:59','yyyy/mm/dd hh24:mi:ss'),'120.73','120.73','ZHAO ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/10/25 10:52:38','yyyy/mm/dd hh24:mi:ss'),'1639','10717322','0','','0304','陈云平','20241025002528','20241025433') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/25 12:13:59','yyyy/mm/dd hh24:mi:ss'),'1639','20241025002528','1','C','H0300087','C—反应蛋白测定(CRP)全血快速定量加收','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','陈云平','0304','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/25 12:13:59','yyyy/mm/dd hh24:mi:ss'),'1639','20241025002528','2','C','H0300070','C-反应蛋白测定(CRP)免疫比浊法','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','1','','0','陈云平','0304','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/25 12:13:59','yyyy/mm/dd hh24:mi:ss'),'1639','20241025002528','3','C','H0000026','血细胞分析','/','11','项','0411','11','11','0','1','M','025','190','1.0000','1.0000','1','','0','陈云平','0304','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/25 12:13:59','yyyy/mm/dd hh24:mi:ss'),'1639','20241025002528','4','C','H0000053','血细胞分析(流式细胞仪法每增一项指标)','/','13','项','0411','13','13','0','1','M','025','190','1.0000','1.0000','1','','0','陈云平','0304','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/10/25 10:52:38','yyyy/mm/dd hh24:mi:ss'),'1640','10717322','0','','0304','陈云平','20241025002528','20241025433') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/25 12:13:59','yyyy/mm/dd hh24:mi:ss'),'1640','20241025002528','1','C','H0302212','抗链球菌溶血素O测定(ASO)(速率散射法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','2','','0','陈云平','0304','0','*抗链球菌溶血素“O”','21360','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/10/25 10:52:38','yyyy/mm/dd hh24:mi:ss'),'1641','10717322','0','','0304','陈云平','20241025002528','20241025433') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/25 12:13:59','yyyy/mm/dd hh24:mi:ss'),'1641','20241025002528','1','E','E0003052','静脉采血','/','1','次','0304','7','7','0','1','C','022','300','1.0000','7.0000','3','','0','陈云平','0304','0','静脉采血','ZL000585','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/25 12:13:59','yyyy/mm/dd hh24:mi:ss'),'1641','20241025002528','2','J','I0005129','一次性使用静脉血样采集针','S-7输液式/威高','1','支','0304','0.47','0.47','0','1','L','031','170','1.0000','0.4700','4','','0','陈云平','0304','0','一次性使用静脉血样采集针','I0005129','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/25 12:13:59','yyyy/mm/dd hh24:mi:ss'),'1641','20241025002528','3','J','I0010277','真空采血管','2.7ml/碧迪','2','支','0304','3.26','3.26','0','1','C','022','300','1.0000','1.6300','5','','0','陈云平','0304','0','真空采血管','I0010277','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20241025002528','1','微信','120.73','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15071443' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15071443' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15071443' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15071443' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15071446' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15071447' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15071447' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15071447' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15071443' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15071443' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15071443' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15071443' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15071446' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15071447' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15071447' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15071447' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15071443' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15071443' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15071443' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15071443' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15071446' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15071447' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15071447' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15071447' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2410254556' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2410254557' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE exam_appoints SET costs='32.19',charges='32.19',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE exam_appoints SET costs='70',charges='70',BILLING_INDICATOR='1' WHERE EXAM_NO = '2410254556' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE exam_appoints SET costs='40',charges='40',BILLING_INDICATOR='1' WHERE EXAM_NO = '2410254557' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10717322' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10717322' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10717322' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 12:14:01 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10717322') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2024-10-25 12:14:01 记录内容：2024-10-25 12:14:01 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2024-10-25 12:14:01 记录内容：1成功120241025002528 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2024-10-25 12:14:01 记录内容：2024-10-25 12:14:01 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2024-10-25 14:57:35 记录内容：cyys_2017@123cyys_2017@12310034185710034185715072461110.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2024-10-25 14:57:35 记录内容：'15072461' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2024-10-25 14:57:35 记录内容：2024-10-25 14:57:35 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2024-10-25 14:57:35 记录内容：2024-10-25 14:57:35 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 14:57:36 记录内容：__________ 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 ('20241025003136','100341857','胡丽','一般人员','自费',to_date('2024/10/25 14:57:35','yyyy/mm/dd hh24:mi:ss'),'110','110','HU LI ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 14:57:36 记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/10/24 10:27:10','yyyy/mm/dd hh24:mi:ss'),'3575','100341857','0','','0305','韩丽','20241025003136','202410248904') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 14:57:36 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/25 14:57:35','yyyy/mm/dd hh24:mi:ss'),'3575','20241025003136','1','D','D0602001','彩色多普勒超声常规检查','/','1','次','0409','100','100','0','1','J','006','150','1.0000','100.0000','1','','0','韩丽','0305','0','*腹部(肝胆胰脾双肾)彩色多普勒超声常规检查','21196','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 14:57:36 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/25 14:57:35','yyyy/mm/dd hh24:mi:ss'),'3575','20241025003136','2','D','D0607008','超声计算机图文报告','/','1','次','0409','10','10','0','1','J','006','150','1.0000','10.0000','1','','0','韩丽','0305','0','*腹部(肝胆胰脾双肾)彩色多普勒超声常规检查','21196','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 14:57:36 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20241025003136','1','微信','110','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 14:57:36 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15072461' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 14:57:36 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15072461' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 14:57:36 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15072461' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 14:57:36 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15072461' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 14:57:36 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15072461' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 14:57:36 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15072461' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 14:57:36 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5192198' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 14:57:36 记录内容：__________UPDATE exam_appoints SET costs='110',charges='110',BILLING_INDICATOR='1' WHERE EXAM_NO = '5192198' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 14:57:36 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100341857' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 14:57:36 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100341857' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 14:57:36 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100341857' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 14:57:36 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100341857') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2024-10-25 14:57:36 记录内容：2024-10-25 14:57:36 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2024-10-25 14:57:36 记录内容：1成功120241025003136 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2024-10-25 14:57:36 记录内容：2024-10-25 14:57:36 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2024-10-25 17:26:13 记录内容：cyys_2017@123cyys_2017@1231069053410690534150732191507322015073222289.52001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2024-10-25 17:26:13 记录内容：'15073219','15073220','15073222' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2024-10-25 17:26:13 记录内容：2024-10-25 17:26:13 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2024-10-25 17:26:13 记录内容：2024-10-25 17:26:13 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26: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 ('20241025003647','10690534','胡明月','一般人员','自费',to_date('2024/10/25 17:26:13','yyyy/mm/dd hh24:mi:ss'),'289.52','289.52','HU MING YUE ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26: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('2024/10/25 16:52:58','yyyy/mm/dd hh24:mi:ss'),'5273','10690534','0','','0305','王书台','20241025003647','202410255092') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26: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('2024/10/25 17:26:13','yyyy/mm/dd hh24:mi:ss'),'5273','20241025003647','1','C','H0300087','C—反应蛋白测定(CRP)全血快速定量加收','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','王书台','0305','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26: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('2024/10/25 17:26:13','yyyy/mm/dd hh24:mi:ss'),'5273','20241025003647','2','C','H0300070','C-反应蛋白测定(CRP)免疫比浊法','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','1','','0','王书台','0305','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26: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('2024/10/25 17:26:13','yyyy/mm/dd hh24:mi:ss'),'5273','20241025003647','3','C','H0000026','血细胞分析','/','11','项','0411','11','11','0','1','M','025','190','1.0000','1.0000','1','','0','王书台','0305','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26: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('2024/10/25 17:26:13','yyyy/mm/dd hh24:mi:ss'),'5273','20241025003647','4','C','H0000053','血细胞分析(流式细胞仪法每增一项指标)','/','13','项','0411','13','13','0','1','M','025','190','1.0000','1.0000','1','','0','王书台','0305','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26: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('2024/10/25 16:52:58','yyyy/mm/dd hh24:mi:ss'),'5274','10690534','0','','0305','王书台','20241025003647','202410255092') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26: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('2024/10/25 17:26:13','yyyy/mm/dd hh24:mi:ss'),'5274','20241025003647','1','C','H0302199','甲型流感病原检测','/','1','项','0411','50','50','0','1','M','025','190','1.0000','50.0000','2','','0','王书台','0305','0','甲型乙型流感病原检测+肺炎支原体抗原检测','JY001573','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26: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('2024/10/25 17:26:13','yyyy/mm/dd hh24:mi:ss'),'5274','20241025003647','2','C','H1100070','乙型流感病原检测','/','1','项','0411','35','35','0','1','M','025','190','1.0000','35.0000','2','','0','王书台','0305','0','甲型乙型流感病原检测+肺炎支原体抗原检测','JY001573','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26: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('2024/10/25 17:26:13','yyyy/mm/dd hh24:mi:ss'),'5274','20241025003647','3','C','H0303097','细菌抗原分析','/','1','项','0411','126','126','0','1','C','022','300','1.0000','126.0000','2','','0','王书台','0305','0','甲型乙型流感病原检测+肺炎支原体抗原检测','JY001573','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26: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('2024/10/25 16:52:58','yyyy/mm/dd hh24:mi:ss'),'5275','10690534','0','','0305','王书台','20241025003647','202410255092') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26: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('2024/10/25 17:26:13','yyyy/mm/dd hh24:mi:ss'),'5275','20241025003647','1','E','E0003052','静脉采血','/','1','次','0305','7','7','0','1','C','022','300','1.0000','7.0000','3','','0','王书台','0305','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26: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('2024/10/25 17:26:13','yyyy/mm/dd hh24:mi:ss'),'5275','20241025003647','2','E','I0001053','一次性使用静脉血样采集针','0.7简易的','1','支','0305','0.47','0.47','0','1','L','031','170','1.0000','0.4700','3','','0','王书台','0305','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26: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('2024/10/25 17:26:13','yyyy/mm/dd hh24:mi:ss'),'5275','20241025003647','3','E','I0009141','一次性使用真空采血管','2ml/阳普','1','支','0305','1.05','1.05','0','1','L','031','170','1.0000','1.0500','3','','0','王书台','0305','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20241025003647','1','微信','289.52','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15073219' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15073219' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15073219' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15073219' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15073220' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15073220' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15073220' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15073222' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15073222' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15073222' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15073219' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15073219' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15073219' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15073219' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15073220' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15073220' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15073220' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15073222' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15073222' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15073222' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15073219' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15073219' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15073219' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15073219' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15073220' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15073220' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15073220' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15073222' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15073222' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15073222' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2410255220' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2410255219' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE exam_appoints SET costs='8.52',charges='8.52',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE exam_appoints SET costs='211',charges='211',BILLING_INDICATOR='1' WHERE EXAM_NO = '2410255220' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE exam_appoints SET costs='70',charges='70',BILLING_INDICATOR='1' WHERE EXAM_NO = '2410255219' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10690534' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10690534' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10690534' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-10-25 17:26:14 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10690534') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2024-10-25 17:26:14 记录内容：2024-10-25 17:26:14 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2024-10-25 17:26:14 记录内容：1成功120241025003647 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2024-10-25 17:26:14 记录内容：2024-10-25 17:26:14 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆