◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2026-01-27 15:44:40
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>100530939</patientid><visited>100530939</visited><prescriptions><prescriptionrow><prescriptionrno>17769747</prescriptionrno></prescriptionrow><prescriptionrow><prescriptionrno>17769486</prescriptionrno></prescriptionrow><prescriptionrow><prescriptionrno>17768090</prescriptionrno></prescriptionrow></prescriptions><totalamount>137.8200</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2026-01-27 15:44:40
记录内容：'17769747','17769486','17768090'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2026-01-27 15:44:40
记录内容：2026-01-27 15:44:40
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2026-01-27 15:44:40
记录内容：2026-01-27 15:44:40
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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 ('20260127014058','100530939','曹晓磊','一般人员','自费',to_date('2026/01/27 15:44:40','yyyy/mm/dd hh24:mi:ss'),'137.82','137.82','CAO XIAO LEI ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026/01/27 15:44:40','yyyy/mm/dd hh24:mi:ss'),'6012','050101','100530939','曹晓磊','CAO XIAO LEI ','一般人员','自费','0','门诊处方','0','1','12.45','12.45','0304','XC','信息科','XC','20260127014058','1','202601273063','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026/01/27 15:44:40','yyyy/mm/dd hh24:mi:ss'),'6502','050101','100530939','曹晓磊','CAO XIAO LEI ','一般人员','自费','0','门诊处方','0','1','99.77','99.77','0304','XC','信息科','XC','20260127014058','5','202601273063','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026/01/27 15:44:40','yyyy/mm/dd hh24:mi:ss'),'6503','050101','100530939','曹晓磊','CAO XIAO LEI ','一般人员','自费','0','门诊处方','0','1','6.90','6.90','0304','XC','信息科','XC','20260127014058','1','202601273063','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026-01-27 15:44:40', 'yyyy-mm-dd hh24:mi:ss'),'6012','1','10203103230','0.3g*20','布洛芬缓释胶囊(芬必得)','中美天津史','0.3g*20','盒','1','12.45','12.45','.3;g;口服;2/日','1','1','0.3','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026-01-27 15:44:40', 'yyyy-mm-dd hh24:mi:ss'),'6502','1','10203103230','0.3g*20','布洛芬缓释胶囊(芬必得)','中美天津史','0.3g*20','盒','1','12.45','12.45','.3;g;口服;1/日','3','1','0.3','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026-01-27 15:44:40', 'yyyy-mm-dd hh24:mi:ss'),'6502','2','10101004270','0.25g*40','阿莫西林胶囊（0.25g*40）','华北制药股','0.25g*40','盒','1','5.26','5.26','.25;g;口服;1/日','4','1','0.25','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026-01-27 15:44:40', 'yyyy-mm-dd hh24:mi:ss'),'6502','3','10114040390','0.25g*30','左氧氟沙星片(0.25g*30)','浙江普利','0.25g*30','盒','1','7.48','7.48','.25;g;口服;1/日','5','1','0.25','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026-01-27 15:44:40', 'yyyy-mm-dd hh24:mi:ss'),'6502','4','10102073670','1g','注射用头孢曲松钠1g*','中诺药业','1g','瓶','1','1.92','1.92','1;g;静脉输液;1/日','6','1','1','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026-01-27 15:44:40', 'yyyy-mm-dd hh24:mi:ss'),'6502','5','10108005131','0.5g','[进]注射用阿奇霉素','pharmacia','0.5g','支','1','72.66','72.66','1;g;静脉输液;1/日','7','1','1','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026-01-27 15:44:40', 'yyyy-mm-dd hh24:mi:ss'),'6503','1','10102084270','0.25g*12','头孢克洛胶囊(0.25g*12)*','苏州中化','0.25g*12','盒','1','6.9','6.9','.25;g;口服;1/日','8','1','0.25','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026/1/27 11:30:26','yyyy/mm/dd hh24:mi:ss'),'6730','100530939','0','','0304','信息科','20260127014058','202601273063') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026/01/27 15:44:40','yyyy/mm/dd hh24:mi:ss'),'6730','20260127014058','1','E','E0003052','静脉采血','/','1','次','0329','7','7','0','1','B','050','900','1.0000','7.0000','1','','0','信息科','0304','0','*采血套餐八','15648','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026/01/27 15:44:40','yyyy/mm/dd hh24:mi:ss'),'6730','20260127014058','2','E','I0015681','一次性使用静脉血样采集针','J-7软连接式0.7/威高','1','支','0329','0.25','0.25','0','1','B','050','900','1.0000','0.2500','1','','0','信息科','0304','0','*采血套餐八','15648','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026/01/27 15:44:40','yyyy/mm/dd hh24:mi:ss'),'6730','20260127014058','3','E','I0015765','一次性使用人体静脉血样采集容器','EDTA-K2 2ml/威海威高','8','支','0329','3.36','3.36','0','1','B','050','900','1.0000','0.4200','1','','0','信息科','0304','0','*采血套餐八','15648','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026/01/27 15:44:40','yyyy/mm/dd hh24:mi:ss'),'6730','20260127014058','4','E','E0003052','静脉采血','/','1','次','0329','7','7','0','1','B','050','900','1.0000','7.0000','2','','0','信息科','0304','0','*采血套餐二','15642','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026/01/27 15:44:40','yyyy/mm/dd hh24:mi:ss'),'6730','20260127014058','5','E','I0015681','一次性使用静脉血样采集针','J-7软连接式0.7/威高','1','支','0329','0.25','0.25','0','1','B','050','900','1.0000','0.2500','2','','0','信息科','0304','0','*采血套餐二','15642','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026/01/27 15:44:40','yyyy/mm/dd hh24:mi:ss'),'6730','20260127014058','6','E','I0015765','一次性使用人体静脉血样采集容器','EDTA-K2 2ml/威海威高','2','支','0329','0.84','0.84','0','1','B','050','900','1.0000','0.4200','2','','0','信息科','0304','0','*采血套餐二','15642','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026/1/27 11:30:26','yyyy/mm/dd hh24:mi:ss'),'6731','100530939','1','门诊处方','0304','信息科','20260127014058','202601273063') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026/01/27 15:44:40','yyyy/mm/dd hh24:mi:ss'),'6731','20260127014058','1','A','10203103230','布洛芬缓释胶囊(芬必得)','0.3g*20中美天津史','1','盒','050101','12.45','12.45','0','1','B','050','900','1.0000','12.4500','1','.3;g;口服;2/日','0','信息科','0304','0','布洛芬缓释胶囊(芬必得)','10203103230','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026/1/27 11:30:26','yyyy/mm/dd hh24:mi:ss'),'6732','100530939','1','门诊处方','0304','信息科','20260127014058','202601273063') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026/01/27 15:44:40','yyyy/mm/dd hh24:mi:ss'),'6732','20260127014058','1','A','10203103230','布洛芬缓释胶囊(芬必得)','0.3g*20中美天津史','1','盒','050101','12.45','12.45','0','1','B','050','900','1.0000','12.4500','1','.3;g;口服;1/日','0','信息科','0304','0','布洛芬缓释胶囊(芬必得)','10203103230','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026/01/27 15:44:40','yyyy/mm/dd hh24:mi:ss'),'6732','20260127014058','2','A','10101004270','阿莫西林胶囊（0.25g*40）','0.25g*40华北制药股','1','盒','050101','5.26','5.26','0','1','B','050','900','1.0000','5.2600','2','.25;g;口服;1/日','0','信息科','0304','0','阿莫西林胶囊（0.25g*40）','10101004270','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026/01/27 15:44:40','yyyy/mm/dd hh24:mi:ss'),'6732','20260127014058','3','A','10114040390','左氧氟沙星片(0.25g*30)','0.25g*30浙江普利','1','盒','050101','7.48','7.48','0','1','B','050','900','1.0000','7.4800','3','.25;g;口服;1/日','0','信息科','0304','0','左氧氟沙星片(0.25g*30)','10114040390','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026/01/27 15:44:40','yyyy/mm/dd hh24:mi:ss'),'6732','20260127014058','4','A','10102073670','注射用头孢曲松钠1g*','1g中诺药业','1','瓶','050101','1.92','1.92','0','1','B','050','900','1.0000','1.9200','4','1;g;静脉输液;1/日','0','信息科','0304','0','注射用头孢曲松钠1g*','10102073670','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026/01/27 15:44:40','yyyy/mm/dd hh24:mi:ss'),'6732','20260127014058','5','A','10108005131','[进]注射用阿奇霉素','0.5gpharmacia','1','支','050101','72.66','72.66','0','1','B','050','900','1.0000','72.6600','5','1;g;静脉输液;1/日','0','信息科','0304','0','[进]注射用阿奇霉素','10108005131','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：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('2026/01/27 15:44:40','yyyy/mm/dd hh24:mi:ss'),'6732','20260127014058','6','A','10102084270','头孢克洛胶囊(0.25g*12)*','0.25g*12苏州中化','1','盒','050101','6.9','6.9','0','1','B','050','900','1.0000','6.9000','1','.25;g;口服;1/日','0','信息科','0304','0','头孢克洛胶囊(0.25g*12)*','10102084270','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20260127014058','1','微信','137.82','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17768090' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17768090' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17768090' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17768090' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17768090' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17768090' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:40
记录内容：1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17769486' and presc_no = '6012' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17769747' and presc_no = '6502' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17769747' and presc_no = '6502' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17769747' and presc_no = '6502' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17769747' and presc_no = '6502' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17769747' and presc_no = '6502' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17769747' and presc_no = '6503' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17768090' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17768090' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17768090' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17768090' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17768090' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17768090' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：6__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17768090'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：6__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17768090'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：6__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17768090'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：6__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17768090'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：6__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17768090'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：6__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17768090'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：1__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17769486'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：6__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17769747'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：6__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17769747'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：6__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17769747'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：6__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17769747'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：6__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17769747'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：6__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17769747'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：0__________UPDATE exam_appoints SET costs='37.40',charges='37.40',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：0__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100530939'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：0__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '100530939' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：0__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100530939'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:44:41
记录内容：0__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '100530939') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2026-01-27 15:44:41
记录内容：2026-01-27 15:44:41
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2026-01-27 15:44:41
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功113</returnresult></returnresult><hisinfo><pay_id>20260127014058</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2026-01-27 15:44:41
记录内容：2026-01-27 15:44:41
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2026-01-27 15:49:21
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>100530939</patientid><visited>100530939</visited><prescriptions><prescriptionrow><prescriptionrno>17769874</prescriptionrno></prescriptionrow></prescriptions><totalamount>30.2200</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2026-01-27 15:49:21
记录内容：'17769874'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2026-01-27 15:49:21
记录内容：2026-01-27 15:49:21
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2026-01-27 15:49:21
记录内容：2026-01-27 15:49:21
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:21
记录内容：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 ('20260127014145','100530939','曹晓磊','一般人员','自费',to_date('2026/01/27 15:49:21','yyyy/mm/dd hh24:mi:ss'),'30.22','30.22','CAO XIAO LEI ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:21
记录内容：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('2026/01/27 15:49:21','yyyy/mm/dd hh24:mi:ss'),'6815','050101','100530939','曹晓磊','CAO XIAO LEI ','一般人员','自费','0','门诊处方','0','1','15.11','15.11','0304','XC','信息科','XC','20260127014145','4','202601273063','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:21
记录内容：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('2026/01/27 15:49:21','yyyy/mm/dd hh24:mi:ss'),'6816','050101','100530939','曹晓磊','CAO XIAO LEI ','一般人员','自费','0','门诊处方','0','1','15.11','15.11','0304','XC','信息科','XC','20260127014145','4','202601273063','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:21
记录内容：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('2026-01-27 15:49:21', 'yyyy-mm-dd hh24:mi:ss'),'6815','1','11303035680','250ml(双层无菌)','5%葡萄糖注射液250ml','石家庄四药','250ml(双层无菌)','袋','1','6.67','6.67','250;ml;静脉输液;即刻','9','1','250','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：-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('2026-01-27 15:49:21', 'yyyy-mm-dd hh24:mi:ss'),'6815','1','11303035680','250ml(双层无菌)','5%葡萄糖注射液250ml','石家庄四药','250ml(双层无菌)','袋','1','6.67','6.67','250;ml;静脉输液;即刻','9','1','250','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：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('2026-01-27 15:49:21', 'yyyy-mm-dd hh24:mi:ss'),'6815','2','10501044590','2ml:15mg','吸入用盐酸氨溴索溶液*','河北凯威','2ml:15mg','支','1','8.44','8.44','2;mg;静脉输液;即刻','9','2','2','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：-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('2026-01-27 15:49:21', 'yyyy-mm-dd hh24:mi:ss'),'6815','2','10501044590','2ml:15mg','吸入用盐酸氨溴索溶液*','河北凯威','2ml:15mg','支','1','8.44','8.44','2;mg;静脉输液;即刻','9','2','2','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：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('2026-01-27 15:49:21', 'yyyy-mm-dd hh24:mi:ss'),'6816','1','11303035680','250ml(双层无菌)','5%葡萄糖注射液250ml','石家庄四药','250ml(双层无菌)','袋','1','6.67','6.67','250;ml;静脉输液;即刻','10','1','250','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：-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('2026-01-27 15:49:21', 'yyyy-mm-dd hh24:mi:ss'),'6816','1','11303035680','250ml(双层无菌)','5%葡萄糖注射液250ml','石家庄四药','250ml(双层无菌)','袋','1','6.67','6.67','250;ml;静脉输液;即刻','10','1','250','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：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('2026-01-27 15:49:21', 'yyyy-mm-dd hh24:mi:ss'),'6816','2','10501044590','2ml:15mg','吸入用盐酸氨溴索溶液*','河北凯威','2ml:15mg','支','1','8.44','8.44','2;mg;静脉输液;即刻','10','2','2','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：-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('2026-01-27 15:49:21', 'yyyy-mm-dd hh24:mi:ss'),'6816','2','10501044590','2ml:15mg','吸入用盐酸氨溴索溶液*','河北凯威','2ml:15mg','支','1','8.44','8.44','2;mg;静脉输液;即刻','10','2','2','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：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('2026/1/27 11:30:26','yyyy/mm/dd hh24:mi:ss'),'6832','100530939','1','门诊处方','0304','信息科','20260127014145','202601273063') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：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('2026/01/27 15:49:21','yyyy/mm/dd hh24:mi:ss'),'6832','20260127014145','1','A','11303035680','5%葡萄糖注射液250ml','250ml(双层无菌)石家庄四药','1','袋','050101','6.67','6.67','0','1','B','050','900','1.0000','6.6700','1','250;ml;静脉输液;即刻','0','信息科','0304','0','5%葡萄糖注射液250ml','11303035680','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：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('2026/01/27 15:49:21','yyyy/mm/dd hh24:mi:ss'),'6832','20260127014145','2','A','10501044590','吸入用盐酸氨溴索溶液*','2ml:15mg河北凯威','1','支','050101','8.44','8.44','0','1','B','050','900','1.0000','8.4400','2','2;mg;静脉输液;即刻','0','信息科','0304','0','吸入用盐酸氨溴索溶液*','10501044590','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：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('2026/01/27 15:49:21','yyyy/mm/dd hh24:mi:ss'),'6832','20260127014145','3','A','11303035680','5%葡萄糖注射液250ml','250ml(双层无菌)石家庄四药','1','袋','050101','6.67','6.67','0','1','B','050','900','1.0000','6.6700','1','250;ml;静脉输液;即刻','0','信息科','0304','0','5%葡萄糖注射液250ml','11303035680','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：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('2026/01/27 15:49:21','yyyy/mm/dd hh24:mi:ss'),'6832','20260127014145','4','A','10501044590','吸入用盐酸氨溴索溶液*','2ml:15mg河北凯威','1','支','050101','8.44','8.44','0','1','B','050','900','1.0000','8.4400','2','2;mg;静脉输液;即刻','0','信息科','0304','0','吸入用盐酸氨溴索溶液*','10501044590','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20260127014145','1','微信','30.22','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17769874' and presc_no = '6815' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17769874' and presc_no = '6815' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17769874' and presc_no = '6816' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17769874' and presc_no = '6816' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：4__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17769874'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：4__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17769874'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：4__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17769874'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：4__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17769874'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：0__________UPDATE exam_appoints SET costs='37.40',charges='37.40',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：0__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100530939'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：0__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '100530939' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：0__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100530939'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 15:49:22
记录内容：0__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '100530939') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2026-01-27 15:49:22
记录内容：2026-01-27 15:49:22
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2026-01-27 15:49:22
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功28</returnresult></returnresult><hisinfo><pay_id>20260127014145</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2026-01-27 15:49:22
记录内容：2026-01-27 15:49:22
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2026-01-27 16:19:20
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>100534418</patientid><visited>100534418</visited><prescriptions><prescriptionrow><prescriptionrno>17770040</prescriptionrno></prescriptionrow></prescriptions><totalamount>450.0000</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2026-01-27 16:19:20
记录内容：'17770040'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2026-01-27 16:19:20
记录内容：2026-01-27 16:19:20
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2026-01-27 16:19:21
记录内容：2026-01-27 16:19:21
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 16:19:21
记录内容：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 ('20260127014274','100534418','商俊虎','一般人员','自费',to_date('2026/01/27 16:19:20','yyyy/mm/dd hh24:mi:ss'),'450','450','SHANG JUN HU ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 16:19:21
记录内容：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('2026/1/26 7:35:52','yyyy/mm/dd hh24:mi:ss'),'7239','100534418','0','','0312','徐卫东','20260127014274','202601264388') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 16:19:21
记录内容：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('2026/01/27 16:19:20','yyyy/mm/dd hh24:mi:ss'),'7239','20260127014274','1','D','D1201238','磁共振(MR)平扫','/','1','部位','0406','450','450','0','1','B','050','900','1.0000','450.0000','1','','0','徐卫东','0312','0','左小腿磁共振平扫','JC0022715','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 16:19:21
记录内容：1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20260127014274','1','微信','450','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 16:19:21
记录内容：0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17770040' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 16:19:21
记录内容：1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17770040' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 16:19:21
记录内容：1__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17770040'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 16:19:21
记录内容：1__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5846099'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 16:19:21
记录内容：1__________UPDATE exam_appoints SET costs='450',charges='450',BILLING_INDICATOR='1' WHERE EXAM_NO = '5846099'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 16:19:21
记录内容：0__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100534418'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 16:19:21
记录内容：0__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '100534418' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 16:19:21
记录内容：1__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100534418'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2026-01-27 16:19:21
记录内容：1__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '100534418') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2026-01-27 16:19:21
记录内容：2026-01-27 16:19:21
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2026-01-27 16:19:21
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功9</returnresult></returnresult><hisinfo><pay_id>20260127014274</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2026-01-27 16:19:21
记录内容：2026-01-27 16:19:21
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆