◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2025-11-05 08:23:03
记录内容:cyys_2017@123cyys_2017@123100365910100365910172510911725109696.67001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2025-11-05 08:23:03
记录内容:'17251091','17251096'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2025-11-05 08:23:03
记录内容:2025-11-05 08:23:03
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2025-11-05 08:23:04
记录内容:2025-11-05 08:23:04
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________ 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 ('20251105010468','100365910','汤洪敏','一般人员','自费',to_date('2025/11/05 08:23:03','yyyy/mm/dd hh24:mi:ss'),'96.67','96.67','TANG HONG MIN ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________ 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/11/5 7:44:30','yyyy/mm/dd hh24:mi:ss'),'1415','100365910','0','','0359','张英','20251105010468','20251105771')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________ 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/11/05 08:23:03','yyyy/mm/dd hh24:mi:ss'),'1415','20251105010468','1','C','H0202003','血清总胆固醇测定(化学法或酶法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','1','','0','张英','0359','0','血脂五项','JY001471','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________ 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/11/05 08:23:03','yyyy/mm/dd hh24:mi:ss'),'1415','20251105010468','2','C','H0202007','血清甘油三酯测定(化学法或酶法)','/','1','项','0411','8','8','0','1','M','025','190','1.0000','8.0000','1','','0','张英','0359','0','血脂五项','JY001471','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________ 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/11/05 08:23:03','yyyy/mm/dd hh24:mi:ss'),'1415','20251105010468','3','C','H0202030','血清高密度脂蛋白胆固醇测定','/','1','项','0411','10','10','0','1','M','025','190','1.0000','10.0000','1','','0','张英','0359','0','血脂五项','JY001471','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________ 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/11/05 08:23:03','yyyy/mm/dd hh24:mi:ss'),'1415','20251105010468','4','C','H0202015','血清低密度脂蛋白胆固醇测定(其他方法)','/','1','项','0411','8','8','0','1','M','025','190','1.0000','8.0000','1','','0','张英','0359','0','血脂五项','JY001471','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________ 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/11/05 08:23:03','yyyy/mm/dd hh24:mi:ss'),'1415','20251105010468','5','C','H1100118','小密低密度脂蛋白(SDLDL)测定','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','张英','0359','0','血脂五项','JY001471','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________ 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/11/05 08:23:03','yyyy/mm/dd hh24:mi:ss'),'1415','20251105010468','6','C','H0206004','尿素测定(酶促动力学法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','2','','0','张英','0359','0','*肾功3','21567','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________ 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/11/05 08:23:03','yyyy/mm/dd hh24:mi:ss'),'1415','20251105010468','7','C','H0206007','肌酐测定(酶促动力学法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','2','','0','张英','0359','0','*肾功3','21567','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________ 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/11/05 08:23:03','yyyy/mm/dd hh24:mi:ss'),'1415','20251105010468','8','C','H0206012','血清尿酸测定','/','1','项','0411','5','5','0','1','M','025','190','1.0000','5.0000','2','','0','张英','0359','0','*肾功3','21567','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________ 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/11/5 7:44:30','yyyy/mm/dd hh24:mi:ss'),'1416','100365910','0','','0359','张英','20251105010468','20251105771')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________ 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/11/05 08:23:03','yyyy/mm/dd hh24:mi:ss'),'1416','20251105010468','1','E','E0003052','静脉采血','/','1','次','0329','7','7','0','1','B','016','900','1.0000','7.0000','3','','0','张英','0359','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________ 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/11/05 08:23:03','yyyy/mm/dd hh24:mi:ss'),'1416','20251105010468','2','E','I0015681','一次性使用静脉血样采集针','J-7软连接式0.7/威高','1','支','0329','0.25','0.25','0','1','J','044','150','1.0000','0.2500','3','','0','张英','0359','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________ 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/11/05 08:23:03','yyyy/mm/dd hh24:mi:ss'),'1416','20251105010468','3','E','I0015765','一次性使用人体静脉血样采集容器','EDTA-K2 2ml/威海威高','1','支','0329','0.42','0.42','0','1','J','044','150','1.0000','0.4200','3','','0','张英','0359','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20251105010468','1','微信','96.67','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17251091' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17251091' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17251091' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17251091' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17251091' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17251091' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17251091' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17251091' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17251096' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17251096' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17251096' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17251091' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17251091' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17251091' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17251091' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17251091' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17251091' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17251091' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17251091' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17251096' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17251096' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17251096' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:8__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17251091'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:8__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17251091'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:8__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17251091'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:8__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17251091'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:8__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17251091'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:8__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17251091'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:8__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17251091'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:8__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17251091'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17251096'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17251096'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17251096'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:45__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100365910'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:88__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100365910' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:9__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100365910'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 08:23:04
记录内容:9__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100365910')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2025-11-05 08:23:04
记录内容:2025-11-05 08:23:04
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2025-11-05 08:23:04
记录内容:1成功24920251105010468
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2025-11-05 08:23:04
记录内容:2025-11-05 08:23:04
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2025-11-05 09:22:31
记录内容:cyys_2017@123cyys_2017@12310409455104094551725202817252051127.67001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2025-11-05 09:22:31
记录内容:'17252028','17252051'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2025-11-05 09:22:31
记录内容:2025-11-05 09:22:31
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2025-11-05 09:22:32
记录内容:2025-11-05 09:22:32
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:1__________ 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 ('20251105010906','10409455','董莹','一般人员','自费',to_date('2025/11/05 09:22:31','yyyy/mm/dd hh24:mi:ss'),'127.67','127.67','DONG YING ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:1__________ 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/11/5 9:08:58','yyyy/mm/dd hh24:mi:ss'),'3448','10409455','0','','0315','马伟杰','20251105010906','202511053045')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:1__________ 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/11/05 09:22:31','yyyy/mm/dd hh24:mi:ss'),'3448','20251105010906','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-11-05 09:22:32
记录内容:1__________ 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/11/05 09:22:31','yyyy/mm/dd hh24:mi:ss'),'3448','20251105010906','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-11-05 09:22:32
记录内容:1__________ 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/11/05 09:22:31','yyyy/mm/dd hh24:mi:ss'),'3448','20251105010906','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-11-05 09:22:32
记录内容:1__________ 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/11/5 9:08:58','yyyy/mm/dd hh24:mi:ss'),'3449','10409455','0','','0315','马伟杰','20251105010906','202511053045')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:1__________ 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/11/05 09:22:31','yyyy/mm/dd hh24:mi:ss'),'3449','20251105010906','1','E','E0003052','静脉采血','/','1','次','0329','7','7','0','1','B','016','900','1.0000','7.0000','2','','0','马伟杰','0315','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:1__________ 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/11/05 09:22:31','yyyy/mm/dd hh24:mi:ss'),'3449','20251105010906','2','E','I0015681','一次性使用静脉血样采集针','J-7软连接式0.7/威高','1','支','0329','0.25','0.25','0','1','J','044','150','1.0000','0.2500','2','','0','马伟杰','0315','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:1__________ 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/11/05 09:22:31','yyyy/mm/dd hh24:mi:ss'),'3449','20251105010906','3','E','I0015765','一次性使用人体静脉血样采集容器','EDTA-K2 2ml/威海威高','1','支','0329','0.42','0.42','0','1','J','044','150','1.0000','0.4200','2','','0','马伟杰','0315','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20251105010906','1','微信','127.67','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17252028' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17252028' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17252028' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17252051' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17252051' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17252051' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17252028' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17252028' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17252028' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17252051' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17252051' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17252051' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17252028'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17252028'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17252028'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17252051'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17252051'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17252051'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2511054524'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:32
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:33
记录内容:0__________UPDATE exam_appoints SET costs='120',charges='120',BILLING_INDICATOR='1' WHERE EXAM_NO = '2511054524'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:33
记录内容:0__________UPDATE exam_appoints SET costs='7.67',charges='7.67',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:33
记录内容:125__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10409455'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:33
记录内容:133__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10409455' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:33
记录内容:21__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10409455'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:22:33
记录内容:21__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10409455')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2025-11-05 09:22:33
记录内容:2025-11-05 09:22:33
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2025-11-05 09:22:33
记录内容:1成功33320251105010906
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2025-11-05 09:22:33
记录内容:2025-11-05 09:22:33
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2025-11-05 09:36:49
记录内容:cyys_2017@123cyys_2017@1231002694061002694061725239517252401296.67001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2025-11-05 09:36:49
记录内容:'17252395','17252401'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2025-11-05 09:36:49
记录内容:2025-11-05 09:36:49
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2025-11-05 09:36:49
记录内容:2025-11-05 09:36:49
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________ 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 ('20251105011011','100269406','王晔','一般人员','自费',to_date('2025/11/05 09:36:49','yyyy/mm/dd hh24:mi:ss'),'296.67','296.67','WANG ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________ 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/11/5 9:29:22','yyyy/mm/dd hh24:mi:ss'),'3859','100269406','0','','0371','许春月','20251105011011','202511053646')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________ 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/11/05 09:36:49','yyyy/mm/dd hh24:mi:ss'),'3859','20251105011011','1','C','H0209012','血清促卵泡刺激素测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','许春月','0371','0','*性激素四项(生殖科)','JY001308','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________ 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/11/05 09:36:49','yyyy/mm/dd hh24:mi:ss'),'3859','20251105011011','2','C','H0209015','血清促黄体生成素测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','许春月','0371','0','*性激素四项(生殖科)','JY001308','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________ 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/11/05 09:36:49','yyyy/mm/dd hh24:mi:ss'),'3859','20251105011011','3','C','H0209100','雌二醇测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','许春月','0371','0','*性激素四项(生殖科)','JY001308','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________ 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/11/05 09:36:49','yyyy/mm/dd hh24:mi:ss'),'3859','20251105011011','4','C','H0209103','孕酮测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','许春月','0371','0','*性激素四项(生殖科)','JY001308','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________ 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/11/05 09:36:49','yyyy/mm/dd hh24:mi:ss'),'3859','20251105011011','5','C','H0209147','特异β人绒毛膜促性腺激素(β-HCG)测定','/','1','项','0441','54','54','0','1','J','044','150','1.0000','54.0000','2','','0','许春月','0371','0','*人绒毛膜促性腺激素测定(生殖科)','JY001320','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________ 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/11/5 9:29:22','yyyy/mm/dd hh24:mi:ss'),'3861','100269406','0','','0371','许春月','20251105011011','202511053646')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________ 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/11/05 09:36:49','yyyy/mm/dd hh24:mi:ss'),'3861','20251105011011','1','E','E0003052','静脉采血','/','1','次','0371','7','7','0','1','B','016','900','1.0000','7.0000','3','','0','许春月','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________ 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/11/05 09:36:49','yyyy/mm/dd hh24:mi:ss'),'3861','20251105011011','2','E','I0015681','一次性使用静脉血样采集针','J-7软连接式0.7/威高','1','支','0371','0.25','0.25','0','1','J','044','150','1.0000','0.2500','3','','0','许春月','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________ 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/11/05 09:36:49','yyyy/mm/dd hh24:mi:ss'),'3861','20251105011011','3','E','I0015765','一次性使用人体静脉血样采集容器','EDTA-K2 2ml/威海威高','1','支','0371','0.42','0.42','0','1','J','044','150','1.0000','0.4200','3','','0','许春月','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________ 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/11/05 09:36:49','yyyy/mm/dd hh24:mi:ss'),'3861','20251105011011','4','D','D1201157','B型超声检查-腔内检查(加收)','/','1','部位','0371','20','20','0','1','J','044','150','1.0000','20.0000','4','','0','许春月','0371','0','*生殖卵泡监测','JC000924','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________ 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/11/05 09:36:49','yyyy/mm/dd hh24:mi:ss'),'3861','20251105011011','5','D','D1201165','彩色多普勒超声检查(常规)-排卵监测(减收)','/','1','部位','0371','55','55','0','1','J','044','150','1.0000','55.0000','4','','0','许春月','0371','0','*生殖卵泡监测','JC000924','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20251105011011','1','微信','296.67','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17252395' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17252395' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17252395' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17252395' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17252395' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17252401' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17252401' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17252401' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17252401' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17252401' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17252395' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17252395' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17252395' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17252395' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17252395' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17252401' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17252401' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17252401' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17252401' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17252401' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:5__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17252395'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:49
记录内容:5__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17252395'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:50
记录内容:5__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17252395'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:50
记录内容:5__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17252395'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:50
记录内容:5__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17252395'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:50
记录内容:5__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17252401'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:50
记录内容:5__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17252401'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:50
记录内容:5__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17252401'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:50
记录内容:5__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17252401'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:50
记录内容:5__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17252401'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:50
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2511054721'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:50
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:50
记录内容:0__________UPDATE exam_appoints SET costs='428',charges='428',BILLING_INDICATOR='1' WHERE EXAM_NO = '2511054721'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:50
记录内容:0__________UPDATE exam_appoints SET costs='165.34',charges='165.34',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:50
记录内容:37__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100269406'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:50
记录内容:44__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100269406' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:50
记录内容:8__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100269406'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 09:36:50
记录内容:8__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100269406')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2025-11-05 09:36:50
记录内容:2025-11-05 09:36:50
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2025-11-05 09:36:50
记录内容:1成功17020251105011011
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2025-11-05 09:36:50
记录内容:2025-11-05 09:36:50
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2025-11-05 11:04:31
记录内容:cyys_2017@123cyys_2017@123Z00145639Z001456391725390017253903250.00001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2025-11-05 11:04:31
记录内容:'17253900','17253903'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2025-11-05 11:04:31
记录内容:2025-11-05 11:04:31
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2025-11-05 11:04:31
记录内容:2025-11-05 11:04:31
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 11:04:31
记录内容:1__________ 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 ('20251105011713','Z00145639','班千轶','一般人员','自费',to_date('2025/11/05 11:04:31','yyyy/mm/dd hh24:mi:ss'),'250','250','BAN QIAN ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 11:04:31
记录内容:1__________ 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/11/5 9:49:57','yyyy/mm/dd hh24:mi:ss'),'6338','Z00145639','0','','0359','陶林森','20251105011713','202511054271')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 11:04:31
记录内容:1__________ 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/11/05 11:04:31','yyyy/mm/dd hh24:mi:ss'),'6338','20251105011713','1','D','D1201167','彩色多普勒超声检查(心脏)','/','1','次','0359','230','230','0','1','J','044','150','1.0000','230.0000','1','','0','陶林森','0359','0','心脏彩色多普勒超声检查(心血管内科)','JC001925','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 11:04:31
记录内容:1__________ 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/11/5 9:49:57','yyyy/mm/dd hh24:mi:ss'),'6339','Z00145639','0','','0359','陶林森','20251105011713','202511054271')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 11:04:31
记录内容:1__________ 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/11/05 11:04:31','yyyy/mm/dd hh24:mi:ss'),'6339','20251105011713','1','D','D0906001','常规心电图检查','/','1','次','0359','10','10','0','1','J','007','150','1.0000','10.0000','2','','0','陶林森','0359','0','*常规心电图','JC000124','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 11:04:31
记录内容:1__________ 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/11/05 11:04:31','yyyy/mm/dd hh24:mi:ss'),'6339','20251105011713','2','D','D0906045','常规心电图检查(十二通道加收)','/','1','次','0359','10','10','0','1','J','007','150','1.0000','10.0000','2','','0','陶林森','0359','0','*常规心电图','JC000124','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 11:04:31
记录内容:1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20251105011713','1','微信','250','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 11:04:31
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17253900' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 11:04:31
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17253903' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 11:04:31
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17253903' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 11:04:31
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17253900' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 11:04:31
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17253903' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 11:04:31
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17253903' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 11:04:31
记录内容:1__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17253900'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 11:04:31
记录内容:2__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17253903'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 11:04:31
记录内容:2__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17253903'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 11:04:31
记录内容:105__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'Z00145639'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 11:04:31
记录内容:121__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = 'Z00145639' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 11:04:31
记录内容:28__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'Z00145639'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 11:04:31
记录内容:31__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = 'Z00145639')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2025-11-05 11:04:31
记录内容:2025-11-05 11:04:31
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2025-11-05 11:04:31
记录内容:1成功29920251105011713
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2025-11-05 11:04:31
记录内容:2025-11-05 11:04:31
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2025-11-05 13:38:28
记录内容:cyys_2017@123cyys_2017@123100365910100365910172547931144.00001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2025-11-05 13:38:28
记录内容:'17254793'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2025-11-05 13:38:28
记录内容:2025-11-05 13:38:28
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2025-11-05 13:38:28
记录内容:2025-11-05 13:38:28
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 13:38:28
记录内容:1__________ 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 ('20251105012368','100365910','汤洪敏','一般人员','自费',to_date('2025/11/05 13:38:28','yyyy/mm/dd hh24:mi:ss'),'1144','1144','TANG HONG MIN ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 13:38:28
记录内容:1__________ 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/11/05 13:38:28','yyyy/mm/dd hh24:mi:ss'),'7897','050101','100365910','汤洪敏','TANG HONG MIN ','一般人员','自费','0','门诊处方','0','1','1144','1144','0359','ZY1','张英','ZY1','20251105012368','1','20251105279','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 13:38:28
记录内容:1__________ 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-11-05 13:38:28', 'yyyy-mm-dd hh24:mi:ss'),'7897','1','11201395680','150mg(1ml)','托莱西单抗注射液','信达生物','150mg(1ml)','支','4','1144','1144','150;mg;皮下注射;1/2周','1','1','150','','','','','','0','0','','','','0.0000','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 13:38:28
记录内容:1__________ 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/11/5 7:44:30','yyyy/mm/dd hh24:mi:ss'),'7939','100365910','1','门诊处方','0359','张英','20251105012368','20251105771')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 13:38:28
记录内容:1__________ 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/11/05 13:38:28','yyyy/mm/dd hh24:mi:ss'),'7939','20251105012368','1','A','11201395680','托莱西单抗注射液','150mg(1ml)信达生物','4','支','050101','1144','1144','0','1','J','044','150','1.0000','286.0000','1','150;mg;皮下注射;1/2周','0','张英','0359','0','托莱西单抗注射液','11201395680','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 13:38:28
记录内容:1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20251105012368','1','微信','1144','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 13:38:28
记录内容:1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17254793' and presc_no = '7897' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 13:38:28
记录内容:1__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17254793'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 13:38:28
记录内容:46__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100365910'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 13:38:28
记录内容:90__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100365910' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 13:38:28
记录内容:9__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100365910'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 13:38:28
记录内容:9__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100365910')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2025-11-05 13:38:28
记录内容:2025-11-05 13:38:28
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2025-11-05 13:38:28
记录内容:1成功16120251105012368
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2025-11-05 13:38:28
记录内容:2025-11-05 13:38:28
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2025-11-05 15:11:36
记录内容:cyys_2017@123cyys_2017@1230044419600444196172549641725496617254967328.09001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2025-11-05 15:11:36
记录内容:'17254964','17254966','17254967'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2025-11-05 15:11:36
记录内容:2025-11-05 15:11:36
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2025-11-05 15:11:36
记录内容:2025-11-05 15:11:36
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________ 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 ('20251105012882','00444196','廖璇','一般人员','自费',to_date('2025/11/05 15:11:36','yyyy/mm/dd hh24:mi:ss'),'328.09','328.09','LIAO ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________ 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/11/5 14:05:42','yyyy/mm/dd hh24:mi:ss'),'9445','00444196','0','','0315','张金环','20251105012882','202511058345')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________ 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/11/05 15:11:36','yyyy/mm/dd hh24:mi:ss'),'9445','20251105012882','1','C','H0209006','血清泌乳素测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','张金环','0315','0','*性激素六项','21404','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________ 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/11/05 15:11:36','yyyy/mm/dd hh24:mi:ss'),'9445','20251105012882','2','C','H0209012','血清促卵泡刺激素测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','张金环','0315','0','*性激素六项','21404','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________ 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/11/05 15:11:36','yyyy/mm/dd hh24:mi:ss'),'9445','20251105012882','3','C','H0209015','血清促黄体生成素测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','张金环','0315','0','*性激素六项','21404','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________ 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/11/05 15:11:36','yyyy/mm/dd hh24:mi:ss'),'9445','20251105012882','4','C','H0209082','睾酮测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','张金环','0315','0','*性激素六项','21404','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________ 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/11/05 15:11:36','yyyy/mm/dd hh24:mi:ss'),'9445','20251105012882','5','C','H0209100','雌二醇测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','张金环','0315','0','*性激素六项','21404','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________ 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/11/05 15:11:36','yyyy/mm/dd hh24:mi:ss'),'9445','20251105012882','6','C','H0209103','孕酮测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','张金环','0315','0','*性激素六项','21404','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________ 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/11/5 14:05:42','yyyy/mm/dd hh24:mi:ss'),'9446','00444196','0','','0315','张金环','20251105012882','202511058345')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________ 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/11/05 15:11:36','yyyy/mm/dd hh24:mi:ss'),'9446','20251105012882','1','C','H0209054','血浆皮质醇测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','2','','0','张金环','0315','0','*血皮质醇测定','JY000035','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________ 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/11/05 15:11:36','yyyy/mm/dd hh24:mi:ss'),'9446','20251105012882','2','C','H0209018','血清促肾上腺皮质激素测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','3','','0','张金环','0315','0','血清促肾上腺皮质激素测定','JY000668','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________ 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/11/5 14:05:42','yyyy/mm/dd hh24:mi:ss'),'9447','00444196','0','','0315','张金环','20251105012882','202511058345')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________ 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/11/05 15:11:36','yyyy/mm/dd hh24:mi:ss'),'9447','20251105012882','1','E','E0003052','静脉采血','/','1','次','0329','7','7','0','1','B','016','900','1.0000','7.0000','4','','0','张金环','0315','0','*采血套餐二','15642','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________ 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/11/05 15:11:36','yyyy/mm/dd hh24:mi:ss'),'9447','20251105012882','2','E','I0015681','一次性使用静脉血样采集针','J-7软连接式0.7/威高','1','支','0329','0.25','0.25','0','1','J','044','150','1.0000','0.2500','4','','0','张金环','0315','0','*采血套餐二','15642','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________ 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/11/05 15:11:36','yyyy/mm/dd hh24:mi:ss'),'9447','20251105012882','3','E','I0015765','一次性使用人体静脉血样采集容器','EDTA-K2 2ml/威海威高','2','支','0329','0.84','0.84','0','1','J','044','150','1.0000','0.4200','4','','0','张金环','0315','0','*采血套餐二','15642','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20251105012882','1','微信','328.09','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17254964' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17254964' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17254964' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17254964' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17254964' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17254964' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17254966' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17254966' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17254967' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17254967' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17254967' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17254964' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17254964' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17254964' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17254964' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17254964' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17254964' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17254966' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17254966' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17254967' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17254967' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17254967' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:6__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17254964'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:6__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17254964'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:6__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17254964'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:6__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17254964'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:6__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17254964'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:6__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17254964'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:2__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17254966'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:2__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17254966'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17254967'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17254967'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17254967'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:2__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00444196'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:3__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '00444196' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:0__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00444196'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:11:36
记录内容:0__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '00444196')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2025-11-05 15:11:36
记录内容:2025-11-05 15:11:36
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2025-11-05 15:11:36
记录内容:1成功8020251105012882
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2025-11-05 15:11:36
记录内容:2025-11-05 15:11:36
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2025-11-05 15:38:57
记录内容:cyys_2017@123cyys_2017@12310409455104094551725585885.83001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2025-11-05 15:38:57
记录内容:'17255858'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2025-11-05 15:38:57
记录内容:2025-11-05 15:38:57
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2025-11-05 15:38:58
记录内容:2025-11-05 15:38:58
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:38:58
记录内容:1__________ 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 ('20251105013034','10409455','董莹','一般人员','自费',to_date('2025/11/05 15:38:57','yyyy/mm/dd hh24:mi:ss'),'85.83','85.83','DONG YING ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:38:58
记录内容:1__________ 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/11/05 15:38:57','yyyy/mm/dd hh24:mi:ss'),'9885','050101','10409455','董莹','DONG YING','一般人员','自费','0','门诊处方','0','1','85.83','85.83','0315','MAWJ','马伟杰','MAWJ','20251105013034','1','202511053045','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:38:58
记录内容:1__________ 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-11-05 15:38:57', 'yyyy-mm-dd hh24:mi:ss'),'9885','1','11005001391','50ug*100','[进]左甲状腺素钠片','德国默克','50ug*100','盒','3','85.83','85.83','200;ug;口服;1/日','1','1','200','','','','','','0','0','','','','0.0000','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:38:58
记录内容:1__________ 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/11/5 9:08:58','yyyy/mm/dd hh24:mi:ss'),'9933','10409455','1','门诊处方','0315','马伟杰','20251105013034','202511053045')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:38:58
记录内容:1__________ 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/11/05 15:38:57','yyyy/mm/dd hh24:mi:ss'),'9933','20251105013034','1','A','11005001391','[进]左甲状腺素钠片','50ug*100德国默克','3','盒','050101','85.83','85.83','0','1','J','044','150','1.0000','28.6100','1','200;ug;口服;1/日','0','马伟杰','0315','0','[进]左甲状腺素钠片','11005001391','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:38:58
记录内容:1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20251105013034','1','微信','85.83','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:38:58
记录内容:1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17255858' and presc_no = '9885' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:38:58
记录内容:1__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17255858'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:38:58
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2511054524'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:38:58
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:38:58
记录内容:0__________UPDATE exam_appoints SET costs='120',charges='120',BILLING_INDICATOR='1' WHERE EXAM_NO = '2511054524'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:38:58
记录内容:0__________UPDATE exam_appoints SET costs='7.67',charges='7.67',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:38:58
记录内容:126__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10409455'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:38:58
记录内容:134__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10409455' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:38:58
记录内容:21__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10409455'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-11-05 15:38:58
记录内容:21__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10409455')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2025-11-05 15:38:58
记录内容:2025-11-05 15:38:58
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2025-11-05 15:38:58
记录内容:1成功30920251105013034
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2025-11-05 15:38:58
记录内容:2025-11-05 15:38:58
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆