◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2024-10-23 10:22:26 记录内容:cyys_2017@123cyys_2017@123DP028049DP02804915059047235.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2024-10-23 10:22:26 记录内容:'15059047' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2024-10-23 10:22:26 记录内容:2024-10-23 10:22:26 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2024-10-23 10:22:26 记录内容:2024-10-23 10:22:26 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________ 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 ('20241023015254','DP028049','金玉华','一般人员','自费',to_date('2024/10/23 10:22:26','yyyy/mm/dd hh24:mi:ss'),'235','235','JIN YU HUA ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/10/23 8:37:48','yyyy/mm/dd hh24:mi:ss'),'8090','DP028049','0','','0327','张仲凯','20241023015254','202410234674') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/23 10:22:26','yyyy/mm/dd hh24:mi:ss'),'8090','20241023015254','1','D','D0902031','双眼视觉检查','/','1','次','0327','10','10','0','1','J','044','150','1.0000','10.0000','1','','0','张仲凯','0327','0','双眼视觉检查','10707','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/23 10:22:26','yyyy/mm/dd hh24:mi:ss'),'8090','20241023015254','2','E','D0902044','眼压检查','/','1','次','0327','6','6','0','1','J','044','150','1.0000','6.0000','2','','0','张仲凯','0327','0','眼压检查','10719','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/23 10:22:26','yyyy/mm/dd hh24:mi:ss'),'8090','20241023015254','3','D','D0902103','光学相干断层成像(OCT)','/','1','次','0327','100','100','0','1','J','044','150','1.0000','100.0000','3','','0','张仲凯','0327','0','光学相干断层成像(OCT)','10779','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/23 10:22:26','yyyy/mm/dd hh24:mi:ss'),'8090','20241023015254','4','E','D0902119','青光眼视网膜神经纤维层计算机图像分析(增加定量分析加收)','/','1','次','0327','20','20','0','1','C','022','300','1.0000','20.0000','4','','0','张仲凯','0327','0','青光眼视网膜神经纤维层计算机图像分析(增加定量分析加收)','10729','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/23 10:22:26','yyyy/mm/dd hh24:mi:ss'),'8090','20241023015254','5','D','D0902018','试镜','/','1','项','0327','2','2','0','1','J','044','150','1.0000','2.0000','5','','0','张仲凯','0327','0','试镜','10694','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/23 10:22:26','yyyy/mm/dd hh24:mi:ss'),'8090','20241023015254','6','D','D0601004','浅表组织器官B超检查','/','1','每个部位','0327','25','25','0','1','J','006','150','1.0000','25.0000','6','','0','张仲凯','0327','0','眼部B超','D0600002','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/23 10:22:26','yyyy/mm/dd hh24:mi:ss'),'8090','20241023015254','7','E','D0902076','裂隙灯检查','/','1','次','0327','3','3','0','1','J','044','150','1.0000','3.0000','7','','0','张仲凯','0327','0','裂隙灯检查','10752','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/23 10:22:26','yyyy/mm/dd hh24:mi:ss'),'8090','20241023015254','8','D','D0902066','角膜内皮镜检查','/','1','次','0327','50','50','0','1','J','044','150','1.0000','50.0000','8','','0','张仲凯','0327','0','角膜内皮镜检查','D0902123','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/23 10:22:26','yyyy/mm/dd hh24:mi:ss'),'8090','20241023015254','9','D','D0902014','验光','/','1','项','0327','2','2','0','1','J','044','150','1.0000','2.0000','9','','0','张仲凯','0327','0','*显然验光','JC000012','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/23 10:22:26','yyyy/mm/dd hh24:mi:ss'),'8090','20241023015254','10','D','D0902018','试镜','/','1','项','0327','2','2','0','1','J','044','150','1.0000','2.0000','9','','0','张仲凯','0327','0','*显然验光','JC000012','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/10/23 10:22:26','yyyy/mm/dd hh24:mi:ss'),'8090','20241023015254','11','E','D0902084','眼底照相','/','1','次','0327','15','15','0','1','J','044','150','1.0000','15.0000','10','','0','张仲凯','0327','0','眼底照相','10760','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20241023015254','1','微信','235','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15059047' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15059047' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15059047' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15059047' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15059047' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15059047' and presc_no = '0' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15059047' and presc_no = '0' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15059047' and presc_no = '0' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15059047' and presc_no = '0' and item_no = '9' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15059047' and presc_no = '0' and item_no = '9' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15059047' and presc_no = '0' and item_no = '10' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15059047' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15059047' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15059047' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15059047' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15059047' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15059047' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15059047' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15059047' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15059047' and item_no = '9' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15059047' and item_no = '9' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15059047' and item_no = '10' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15059047' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15059047' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15059047' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15059047' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15059047' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15059047' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15059047' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15059047' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15059047' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15059047' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15059047' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'DP028049' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = 'DP028049' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'DP028049' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:22:26 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = 'DP028049') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2024-10-23 10:22:26 记录内容:2024-10-23 10:22:26 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2024-10-23 10:22:26 记录内容:1成功120241023015254 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2024-10-23 10:22:26 记录内容:2024-10-23 10:22:26 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2024-10-23 10:36:57 记录内容:cyys_2017@123cyys_2017@123DP028049DP02804915059270300.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2024-10-23 10:36:57 记录内容:'15059270' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2024-10-23 10:36:57 记录内容:2024-10-23 10:36:57 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2024-10-23 10:36:57 记录内容:2024-10-23 10:36:57 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________ 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 ('20241023015359','DP028049','金玉华','一般人员','自费',to_date('2024/10/23 10:36:57','yyyy/mm/dd hh24:mi:ss'),'300','300','JIN YU HUA ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________ 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/23 8:37:48','yyyy/mm/dd hh24:mi:ss'),'8474','DP028049','0','','0306','吴胜杰','20241023015359','202410234674') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________ 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/23 10:36:57','yyyy/mm/dd hh24:mi:ss'),'8474','20241023015359','1','D','D0903072','硬性鼻咽镜检查','/','1','次','0306','80','80','0','1','J','044','150','1.0000','80.0000','1','','0','吴胜杰','0306','0','硬性鼻咽镜检查','10956','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________ 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/23 10:36:57','yyyy/mm/dd hh24:mi:ss'),'8474','20241023015359','2','D','D0903085','耳纤维内镜检查','/','1','次','0306','80','80','0','1','J','016','150','1.0000','80.0000','2','','0','吴胜杰','0306','0','耳纤维内镜检查','JC001092','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________ 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/23 10:36:57','yyyy/mm/dd hh24:mi:ss'),'8474','20241023015359','3','E','D0903073','纤维喉镜检查','/','1','次','0306','100','100','0','1','J','044','150','1.0000','100.0000','3','','0','吴胜杰','0306','0','电子喉镜检查 (含活检、刷检)','10958','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________ 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/23 10:36:57','yyyy/mm/dd hh24:mi:ss'),'8474','20241023015359','4','E','D0903088','纤维喉镜检查(电子镜加收)','/','1','次','0306','30','30','0','1','C','022','300','1.0000','30.0000','3','','0','吴胜杰','0306','0','电子喉镜检查 (含活检、刷检)','10958','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________ 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/23 10:36:57','yyyy/mm/dd hh24:mi:ss'),'8474','20241023015359','5','E','D0908021','电子内镜图文报告','/','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语句 记录时间:2024-10-23 10:36:57 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20241023015359','1','微信','300','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15059270' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15059270' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15059270' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15059270' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15059270' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15059270' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15059270' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15059270' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15059270' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15059270' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15059270' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15059270' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15059270' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15059270' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15059270' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'DP028049' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = 'DP028049' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'DP028049' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 10:36:57 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = 'DP028049') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2024-10-23 10:36:57 记录内容:2024-10-23 10:36:57 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2024-10-23 10:36:57 记录内容:1成功120241023015359 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2024-10-23 10:36:57 记录内容:2024-10-23 10:36:57 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2024-10-23 11:32:15 记录内容:cyys_2017@123cyys_2017@123DP028049DP028049150598992.73001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2024-10-23 11:32:15 记录内容:'15059899' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2024-10-23 11:32:15 记录内容:2024-10-23 11:32:15 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2024-10-23 11:32:15 记录内容:2024-10-23 11:32:15 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 11:32:15 记录内容:__________ 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 ('20241023015768','DP028049','金玉华','一般人员','自费',to_date('2024/10/23 11:32:15','yyyy/mm/dd hh24:mi:ss'),'2.73','2.73','JIN YU HUA ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 11:32:15 记录内容:__________ 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/23 8:37:48','yyyy/mm/dd hh24:mi:ss'),'9626','DP028049','0','','0319','于亚丽','20241023015768','202410234674') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 11:32:15 记录内容:__________ 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/23 11:32:15','yyyy/mm/dd hh24:mi:ss'),'9626','20241023015768','1','J','I0015583','一次性使用齿科器械盒','CKQ-B(口腔护理包)/山东威高','1','支','0319','2.73','2.73','0','1','C','022','300','1.0000','2.7300','1','','0','于亚丽','0319','0','一次性使用齿科器械盒','I0015583','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 11:32:15 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20241023015768','1','微信','2.73','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 11:32:15 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15059899' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 11:32:15 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15059899' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 11:32:15 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15059899' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 11:32:15 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'DP028049' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 11:32:15 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = 'DP028049' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 11:32:15 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'DP028049' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 11:32:15 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = 'DP028049') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2024-10-23 11:32:15 记录内容:2024-10-23 11:32:15 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2024-10-23 11:32:15 记录内容:1成功120241023015768 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2024-10-23 11:32:15 记录内容:2024-10-23 11:32:15 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2024-10-23 15:16:15 记录内容:cyys_2017@123cyys_2017@123DP027207DP0272071506135532.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2024-10-23 15:16:15 记录内容:'15061355' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2024-10-23 15:16:15 记录内容:2024-10-23 15:16:15 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2024-10-23 15:16:15 记录内容:2024-10-23 15:16:15 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________ 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 ('20241023016590','DP027207','刘欣宇','一般人员','自费',to_date('2024/10/23 15:16:15','yyyy/mm/dd hh24:mi:ss'),'32','32','LIU XIN YU ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________ 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/22 21:14:00','yyyy/mm/dd hh24:mi:ss'),'2243','DP027207','0','','0327','张仲凯','20241023016590','202410222993') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________ 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/23 15:16:15','yyyy/mm/dd hh24:mi:ss'),'2243','20241023016590','1','D','D0902031','双眼视觉检查','/','1','次','0327','10','10','0','1','J','044','150','1.0000','10.0000','1','','0','张仲凯','0327','0','双眼视觉检查','10707','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________ 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/23 15:16:15','yyyy/mm/dd hh24:mi:ss'),'2243','20241023016590','2','E','D0902044','眼压检查','/','1','次','0327','6','6','0','1','J','044','150','1.0000','6.0000','2','','0','张仲凯','0327','0','眼压检查','10719','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________ 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/23 15:16:15','yyyy/mm/dd hh24:mi:ss'),'2243','20241023016590','3','D','D0902018','试镜','/','1','项','0327','2','2','0','1','J','044','150','1.0000','2.0000','3','','0','张仲凯','0327','0','试镜','10694','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________ 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/23 15:16:15','yyyy/mm/dd hh24:mi:ss'),'2243','20241023016590','4','E','D0902077','裂隙灯下眼底检查','/','1','次','0327','10','10','0','1','J','044','150','1.0000','10.0000','4','','0','张仲凯','0327','0','裂隙灯下眼底检查','10753','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________ 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/23 15:16:15','yyyy/mm/dd hh24:mi:ss'),'2243','20241023016590','5','D','D0902014','验光','/','1','项','0327','2','2','0','1','J','044','150','1.0000','2.0000','5','','0','张仲凯','0327','0','*显然验光','JC000012','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________ 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/23 15:16:15','yyyy/mm/dd hh24:mi:ss'),'2243','20241023016590','6','D','D0902018','试镜','/','1','项','0327','2','2','0','1','J','044','150','1.0000','2.0000','5','','0','张仲凯','0327','0','*显然验光','JC000012','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20241023016590','1','微信','32','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15061355' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15061355' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15061355' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15061355' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15061355' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15061355' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15061355' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15061355' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15061355' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15061355' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15061355' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15061355' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15061355' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15061355' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15061355' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15061355' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15061355' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15061355' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE exam_appoints SET costs='160',charges='160',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'DP027207' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = 'DP027207' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'DP027207' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2024-10-23 15:16:17 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = 'DP027207') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2024-10-23 15:16:17 记录内容:2024-10-23 15:16:17 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2024-10-23 15:16:17 记录内容:1成功120241023016590 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2024-10-23 15:16:17 记录内容:2024-10-23 15:16:17 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆