◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2024-08-30 08:38:21
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>100430013</patientid><visited>100430013</visited><prescriptions><prescriptionrow><prescriptionrno>14763623</prescriptionrno></prescriptionrow><prescriptionrow><prescriptionrno>14763624</prescriptionrno></prescriptionrow><prescriptionrow><prescriptionrno>14763627</prescriptionrno></prescriptionrow></prescriptions><totalamount>423.5700</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2024-08-30 08:38:21
记录内容：'14763623','14763624','14763627'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2024-08-30 08:38:21
记录内容：2024-08-30 08:38:21
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2024-08-30 08:38:22
记录内容：2024-08-30 08:38:22
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________ 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 ('20240830016317','100430013','杨小珍','一般人员','自费',to_date('2024/08/30 08:38:21','yyyy/mm/dd hh24:mi:ss'),'423.57','423.57','YANG XIAO ZHEN ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/8/28 17:42:30','yyyy/mm/dd hh24:mi:ss'),'6552','100430013','0','','0371','赵磐琳','20240830016317','202408282370') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 08:38:21','yyyy/mm/dd hh24:mi:ss'),'6552','20240830016317','1','C','H0209100','雌二醇测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','赵磐琳','0371','0','*性激素七项(生殖科)','JY001309','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 08:38:21','yyyy/mm/dd hh24:mi:ss'),'6552','20240830016317','2','C','H0209103','孕酮测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','赵磐琳','0371','0','*性激素七项(生殖科)','JY001309','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 08:38:21','yyyy/mm/dd hh24:mi:ss'),'6552','20240830016317','3','C','H0209006','血清泌乳素测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','赵磐琳','0371','0','*性激素七项(生殖科)','JY001309','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 08:38:21','yyyy/mm/dd hh24:mi:ss'),'6552','20240830016317','4','C','H0209082','睾酮测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','赵磐琳','0371','0','*性激素七项(生殖科)','JY001309','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 08:38:21','yyyy/mm/dd hh24:mi:ss'),'6552','20240830016317','5','C','H0209147','特异β人绒毛膜促性腺激素（β-HCG）测定','/','1','项','0441','60','60','0','1','C','022','300','1.0000','60.0000','1','','0','赵磐琳','0371','0','*性激素七项(生殖科)','JY001309','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 08:38:21','yyyy/mm/dd hh24:mi:ss'),'6552','20240830016317','6','C','H0209012','血清促卵泡刺激素测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','赵磐琳','0371','0','*性激素七项(生殖科)','JY001309','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 08:38:21','yyyy/mm/dd hh24:mi:ss'),'6552','20240830016317','7','C','H0209015','血清促黄体生成素测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','赵磐琳','0371','0','*性激素七项(生殖科)','JY001309','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/8/28 17:42:30','yyyy/mm/dd hh24:mi:ss'),'6553','100430013','0','','0371','赵磐琳','20240830016317','202408282370') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 08:38:21','yyyy/mm/dd hh24:mi:ss'),'6553','20240830016317','1','C','H0000026','血细胞分析','/','11','项','0411','11','11','0','1','M','025','190','1.0000','1.0000','2','','0','赵磐琳','0371','0','*血常规','21313','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 08:38:21','yyyy/mm/dd hh24:mi:ss'),'6553','20240830016317','2','C','H0000053','血细胞分析(流式细胞仪法每增一项指标)','/','13','项','0411','13','13','0','1','M','025','190','1.0000','1.0000','2','','0','赵磐琳','0371','0','*血常规','21313','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/8/28 17:42:30','yyyy/mm/dd hh24:mi:ss'),'6554','100430013','0','','0371','赵磐琳','20240830016317','202408282370') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 08:38:21','yyyy/mm/dd hh24:mi:ss'),'6554','20240830016317','1','E','E0003052','静脉采血','/','1','次','0371','7','7','0','1','C','022','300','1.0000','7.0000','3','','0','赵磐琳','0371','0','*采血套餐二','15642','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 08:38:21','yyyy/mm/dd hh24:mi:ss'),'6554','20240830016317','2','E','I0001053','一次性使用静脉血样采集针','0.7简易的','1','支','0371','0.47','0.47','0','1','L','031','170','1.0000','0.4700','3','','0','赵磐琳','0371','0','*采血套餐二','15642','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 08:38:21','yyyy/mm/dd hh24:mi:ss'),'6554','20240830016317','3','E','I0009141','一次性使用真空采血管','2ml/阳普','2','支','0371','2.1','2.1','0','1','L','031','170','1.0000','1.0500','3','','0','赵磐琳','0371','0','*采血套餐二','15642','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 08:38:21','yyyy/mm/dd hh24:mi:ss'),'6554','20240830016317','4','D','D1201121','腔内彩色多普勒超声检查','/','1','次','0371','90','90','0','1','J','006','150','1.0000','90.0000','4','','0','赵磐琳','0371','0','*生殖卵泡监测','JC000924','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240830016317','1','微信','423.57','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14763623' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14763623' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14763623' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14763623' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14763623' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14763623' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14763623' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14763624' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14763624' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14763627' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14763627' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14763627' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14763627' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14763623' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14763623' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14763623' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14763623' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14763623' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14763623' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14763623' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14763624' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14763624' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14763627' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14763627' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14763627' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14763627' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14763623'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14763623'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14763623'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14763623'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14763623'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14763623'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14763623'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14763624'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14763624'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14763627'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14763627'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14763627'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14763627'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2408305898'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2408305899'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE exam_appoints SET costs='199.14',charges='199.14',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE exam_appoints SET costs='300',charges='300',BILLING_INDICATOR='1' WHERE EXAM_NO = '2408305898'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE exam_appoints SET costs='24',charges='24',BILLING_INDICATOR='1' WHERE EXAM_NO = '2408305899'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100430013'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '100430013' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100430013'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 08:38:23
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '100430013') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2024-08-30 08:38:23
记录内容：2024-08-30 08:38:23
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2024-08-30 08:38:23
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20240830016317</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2024-08-30 08:38:23
记录内容：2024-08-30 08:38:23
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2024-08-30 09:06:02
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>100436458</patientid><visited>100436458</visited><prescriptions><prescriptionrow><prescriptionrno>14764120</prescriptionrno></prescriptionrow></prescriptions><totalamount>25.0000</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2024-08-30 09:06:02
记录内容：'14764120'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2024-08-30 09:06:02
记录内容：2024-08-30 09:06:02
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2024-08-30 09:06:03
记录内容：2024-08-30 09:06:03
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 09:06:03
记录内容：__________ 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 ('20240830016531','100436458','魏晓杰','一般人员','自费',to_date('2024/08/30 09:06:02','yyyy/mm/dd hh24:mi:ss'),'25','25','WEI XIAO JIE ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 09:06:03
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/8/30 8:36:24','yyyy/mm/dd hh24:mi:ss'),'7563','100436458','0','','0311','唐伟','20240830016531','202408302798') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 09:06:03
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 09:06:02','yyyy/mm/dd hh24:mi:ss'),'7563','20240830016531','1','E','E0005002','大换药','/','1','次','0311','25','25','0','1','B','016','900','1.0000','25.0000','1','','0','唐伟','0311','0','大换药','10145','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 09:06:03
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240830016531','1','微信','25','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 09:06:03
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14764120' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 09:06:03
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14764120' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 09:06:03
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14764120'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 09:06:03
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100436458'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 09:06:03
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '100436458' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 09:06:03
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100436458'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 09:06:03
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '100436458') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2024-08-30 09:06:03
记录内容：2024-08-30 09:06:03
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2024-08-30 09:06:03
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20240830016531</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2024-08-30 09:06:03
记录内容：2024-08-30 09:06:03
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2024-08-30 10:15:55
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>100430013</patientid><visited>100430013</visited><prescriptions><prescriptionrow><prescriptionrno>14765402</prescriptionrno></prescriptionrow><prescriptionrow><prescriptionrno>14765395</prescriptionrno></prescriptionrow><prescriptionrow><prescriptionrno>14765398</prescriptionrno></prescriptionrow><prescriptionrow><prescriptionrno>14765452</prescriptionrno></prescriptionrow></prescriptions><totalamount>3163.4600</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2024-08-30 10:15:55
记录内容：'14765402','14765395','14765398','14765452'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2024-08-30 10:15:55
记录内容：2024-08-30 10:15:55
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2024-08-30 10:15:55
记录内容：2024-08-30 10:15:55
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________ INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20240830017081','100430013','杨小珍','一般人员','自费',to_date('2024/08/30 10:15:55','yyyy/mm/dd hh24:mi:ss'),'3163.46','3163.46','YANG XIAO ZHEN ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________ 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('2024/08/30 10:15:55','yyyy/mm/dd hh24:mi:ss'),'9638','050111','100430013','杨小珍','YANG XIAO ZHEN ','一般人员','自费','0','门诊处方','0','1','2813.94','2813.94','0371','ZPL','赵磐琳','ZPL','20240830017081','1','202408302370','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________ 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('2024-08-30 10:15:55', 'yyyy-mm-dd hh24:mi:ss'),'9638','1','11002047670','0.72ml:600iu','重组促卵泡素β注射液','德国Gmbh','0.72ml:600iu','盒','2','2813.94','2813.94','200;iu;皮下注射;1/日','1','1','200','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/8/28 17:42:30','yyyy/mm/dd hh24:mi:ss'),'9815','100430013','0','','0371','赵磐琳','20240830017081','202408282370') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 10:15:55','yyyy/mm/dd hh24:mi:ss'),'9815','20240830017081','1','C','H0003014','阴道分泌物检查','/','1','项','0441','3','3','0','1','M','025','190','1.0000','3.0000','5','','0','赵磐琳','0371','0','*白带常规+细菌性阴道病检查(限生殖科)','JY001259','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 10:15:55','yyyy/mm/dd hh24:mi:ss'),'9815','20240830017081','2','C','H0400033','念珠菌镜检','/','1','每个取材','0441','5','5','0','1','M','025','190','1.0000','5.0000','5','','0','赵磐琳','0371','0','*白带常规+细菌性阴道病检查(限生殖科)','JY001259','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 10:15:55','yyyy/mm/dd hh24:mi:ss'),'9815','20240830017081','3','C','H0400052','细菌性阴道病唾液酸酶测定','/','1','项','0441','100','100','0','1','M','025','190','1.0000','100.0000','5','','0','赵磐琳','0371','0','*白带常规+细菌性阴道病检查(限生殖科)','JY001259','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 10:15:55','yyyy/mm/dd hh24:mi:ss'),'9815','20240830017081','4','C','H0400001','一般细菌涂片检查','/','1','项','0441','5','5','0','1','M','025','190','1.0000','5.0000','5','','0','赵磐琳','0371','0','*白带常规+细菌性阴道病检查(限生殖科)','JY001259','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/8/28 17:42:30','yyyy/mm/dd hh24:mi:ss'),'9816','100430013','0','','0371','赵磐琳','20240830017081','202408282370') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 10:15:55','yyyy/mm/dd hh24:mi:ss'),'9816','20240830017081','1','C','H0209015','血清促黄体生成素测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','6','','0','赵磐琳','0371','0','*性激素三项(生殖科)','JY001307','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 10:15:55','yyyy/mm/dd hh24:mi:ss'),'9816','20240830017081','2','C','H0209100','雌二醇测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','6','','0','赵磐琳','0371','0','*性激素三项(生殖科)','JY001307','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 10:15:55','yyyy/mm/dd hh24:mi:ss'),'9816','20240830017081','3','C','H0209103','孕酮测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','6','','0','赵磐琳','0371','0','*性激素三项(生殖科)','JY001307','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/8/28 17:42:30','yyyy/mm/dd hh24:mi:ss'),'9817','100430013','1','门诊处方','0371','赵磐琳','20240830017081','202408282370') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 10:15:55','yyyy/mm/dd hh24:mi:ss'),'9817','20240830017081','1','A','11002047670','重组促卵泡素β注射液','0.72ml:600iu德国Gmbh','2','盒','050111','2813.94','2813.94','0','1','C','022','300','1.0000','1406.9700','1','200;iu;皮下注射;1/日','0','赵磐琳','0371','0','重组促卵泡素β注射液','11002047670','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/8/28 17:42:30','yyyy/mm/dd hh24:mi:ss'),'9818','100430013','0','','0371','赵磐琳','20240830017081','202408282370') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 10:15:55','yyyy/mm/dd hh24:mi:ss'),'9818','20240830017081','1','E','E0003052','静脉采血','/','1','次','0371','7','7','0','1','C','022','300','1.0000','7.0000','7','','0','赵磐琳','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 10:15:55','yyyy/mm/dd hh24:mi:ss'),'9818','20240830017081','2','E','I0001053','一次性使用静脉血样采集针','0.7简易的','1','支','0371','0.47','0.47','0','1','L','031','170','1.0000','0.4700','7','','0','赵磐琳','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 10:15:55','yyyy/mm/dd hh24:mi:ss'),'9818','20240830017081','3','E','I0009141','一次性使用真空采血管','2ml/阳普','1','支','0371','1.05','1.05','0','1','L','031','170','1.0000','1.0500','7','','0','赵磐琳','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 10:15:55','yyyy/mm/dd hh24:mi:ss'),'9818','20240830017081','4','D','D1201121','腔内彩色多普勒超声检查','/','1','次','0371','90','90','0','1','J','006','150','1.0000','90.0000','8','','0','赵磐琳','0371','0','*生殖卵泡监测','JC000924','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 10:15:55','yyyy/mm/dd hh24:mi:ss'),'9818','20240830017081','5','E','E0003054','皮下注射','/','4','次','0371','18','18','0','1','C','022','300','1.0000','4.5000','9','','0','赵磐琳','0371','0','皮下注射','E0003052','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240830017081','1','微信','3163.46','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14765395' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14765395' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14765395' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14765395' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14765398' and presc_no = '0' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14765398' and presc_no = '0' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14765398' and presc_no = '0' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14765402' and presc_no = '9638' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14765452' and presc_no = '0' and item_no = '7'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14765452' and presc_no = '0' and item_no = '7'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14765452' and presc_no = '0' and item_no = '7'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14765452' and presc_no = '0' and item_no = '8'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14765452' and presc_no = '0' and item_no = '9'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14765395' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14765395' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14765395' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14765395' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14765398' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14765398' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14765398' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14765452' and item_no = '7'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14765452' and item_no = '7'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14765452' and item_no = '7'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14765452' and item_no = '8'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14765452' and item_no = '9'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14765395'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14765395'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14765395'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14765395'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14765398'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14765398'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14765398'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14765402'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14765452'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14765452'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14765452'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14765452'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14765452'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2408306669'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2408305898'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2408306677'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2408305899'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE exam_appoints SET costs='548.70',charges='548.70',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE exam_appoints SET costs='113',charges='113',BILLING_INDICATOR='1' WHERE EXAM_NO = '2408306669'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE exam_appoints SET costs='300',charges='300',BILLING_INDICATOR='1' WHERE EXAM_NO = '2408305898'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE exam_appoints SET costs='120',charges='120',BILLING_INDICATOR='1' WHERE EXAM_NO = '2408306677'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE exam_appoints SET costs='24',charges='24',BILLING_INDICATOR='1' WHERE EXAM_NO = '2408305899'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100430013'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '100430013' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100430013'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:15:57
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '100430013') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2024-08-30 10:15:57
记录内容：2024-08-30 10:15:57
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2024-08-30 10:15:57
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20240830017081</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2024-08-30 10:15:57
记录内容：2024-08-30 10:15:57
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2024-08-30 10:55:56
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>100310026</patientid><visited>100310026</visited><prescriptions><prescriptionrow><prescriptionrno>14766126</prescriptionrno></prescriptionrow><prescriptionrow><prescriptionrno>14766079</prescriptionrno></prescriptionrow></prescriptions><totalamount>263.5800</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2024-08-30 10:55:56
记录内容：'14766126','14766079'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2024-08-30 10:55:56
记录内容：2024-08-30 10:55:56
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2024-08-30 10:55:56
记录内容：2024-08-30 10:55:56
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________ 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 ('20240830017406','100310026','党嘉艺','一般人员','自费',to_date('2024/08/30 10:55:56','yyyy/mm/dd hh24:mi:ss'),'263.58','263.58','DANG JIA YI ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________ 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('2024/08/30 10:55:56','yyyy/mm/dd hh24:mi:ss'),'842','050101','100310026','党嘉艺','DANG JIA YI ','一般人员','自费','0','门诊处方','0','1','257.58','257.58','0327','GMM99','郭苗苗','GMM99','20240830017406','3','20240830587','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________ 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('2024-08-30 10:55:56', 'yyyy-mm-dd hh24:mi:ss'),'842','1','11404019110','0.4ml:0.4mg*20','双氯芬酸钠滴眼液','兴齐眼药','0.4ml:0.4mg*20','盒','2','77.18','77.18','.4;ml;滴双眼;2/日','1','1','0.4','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________ 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('2024-08-30 10:55:56', 'yyyy-mm-dd hh24:mi:ss'),'842','2','11404112110','0.4ml:1680iu*10','牛碱性成纤维细胞生长因子滴眼液*','亿胜生物','0.4ml:1680iu*10','盒','2','110.4','110.4','.4;ml;滴双眼;2/日','2','1','0.4','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________ 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('2024-08-30 10:55:56', 'yyyy-mm-dd hh24:mi:ss'),'842','3','20118030110','10ml','熊胆滴眼液*','云南傣药','10ml','支','2','70','70','1;ml;滴双眼;3/日','3','1','1','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/8/30 10:41:24','yyyy/mm/dd hh24:mi:ss'),'938','100310026','0','','0327','郭苗苗','20240830017406','20240830587') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 10:55:56','yyyy/mm/dd hh24:mi:ss'),'938','20240830017406','1','E','D0902076','裂隙灯检查','/','2','次','0327','6','6','0','1','J','044','150','1.0000','3.0000','1','','0','郭苗苗','0327','0','裂隙灯检查','10752','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/8/30 10:41:24','yyyy/mm/dd hh24:mi:ss'),'939','100310026','1','门诊处方','0327','郭苗苗','20240830017406','20240830587') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 10:55:56','yyyy/mm/dd hh24:mi:ss'),'939','20240830017406','1','A','11404019110','双氯芬酸钠滴眼液','0.4ml:0.4mg*20兴齐眼药','2','盒','050101','77.18','77.18','0','1','C','022','300','1.0000','38.5900','1','.4;ml;滴双眼;2/日','0','郭苗苗','0327','0','双氯芬酸钠滴眼液','11404019110','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 10:55:56','yyyy/mm/dd hh24:mi:ss'),'939','20240830017406','2','A','11404112110','牛碱性成纤维细胞生长因子滴眼液*','0.4ml:1680iu*10亿胜生物','2','盒','050101','110.4','110.4','0','1','C','022','300','1.0000','55.2000','2','.4;ml;滴双眼;2/日','0','郭苗苗','0327','0','牛碱性成纤维细胞生长因子滴眼液*','11404112110','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 10:55:56','yyyy/mm/dd hh24:mi:ss'),'939','20240830017406','3','A','20118030110','熊胆滴眼液*','10ml云南傣药','2','支','050101','70','70','0','1','D','033','600','1.0000','35.0000','3','1;ml;滴双眼;3/日','0','郭苗苗','0327','0','熊胆滴眼液*','20118030110','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240830017406','1','微信','263.58','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14766079' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14766126' and presc_no = '842' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14766126' and presc_no = '842' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14766126' and presc_no = '842' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14766079' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14766079'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14766126'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14766126'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14766126'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________UPDATE exam_appoints SET costs='6',charges='6',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100310026'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '100310026' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100310026'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 10:55:56
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '100310026') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2024-08-30 10:55:56
记录内容：2024-08-30 10:55:56
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2024-08-30 10:55:56
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20240830017406</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2024-08-30 10:55:56
记录内容：2024-08-30 10:55:56
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2024-08-30 15:14:30
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>10673182</patientid><visited>10673182</visited><prescriptions><prescriptionrow><prescriptionrno>14767674</prescriptionrno></prescriptionrow></prescriptions><totalamount>110.0000</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2024-08-30 15:14:30
记录内容：'14767674'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2024-08-30 15:14:30
记录内容：2024-08-30 15:14:30
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2024-08-30 15:14:30
记录内容：2024-08-30 15:14:30
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:14:30
记录内容：__________ INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20240830018439','10673182','林妍','一般人员','自费',to_date('2024/08/30 15:14:30','yyyy/mm/dd hh24:mi:ss'),'110','110','LIN  ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:14:30
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/8/30 14:46:18','yyyy/mm/dd hh24:mi:ss'),'3971','10673182','0','','0335','张红敏','20240830018439','202408303622') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:14:30
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 15:14:30','yyyy/mm/dd hh24:mi:ss'),'3971','20240830018439','1','D','D0602010','浅表器官彩色多普勒超声检查','/','2','每个部位','0409','100','100','0','1','J','006','150','1.0000','50.0000','1','','0','张红敏','0335','0','*乳腺+引流区淋巴结彩色多普勒超声','21245','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:14:30
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 15:14:30','yyyy/mm/dd hh24:mi:ss'),'3971','20240830018439','2','D','D0607008','超声计算机图文报告','/','1','次','0409','10','10','0','1','J','006','150','1.0000','10.0000','1','','0','张红敏','0335','0','*乳腺+引流区淋巴结彩色多普勒超声','21245','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:14:30
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240830018439','1','微信','110','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:14:30
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14767674' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:14:30
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14767674' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:14:30
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14767674' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:14:30
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14767674' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:14:30
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14767674'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:14:30
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14767674'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:14:30
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5118128'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:14:30
记录内容：__________UPDATE exam_appoints SET costs='110',charges='110',BILLING_INDICATOR='1' WHERE EXAM_NO = '5118128'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:14:30
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10673182'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:14:30
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '10673182' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:14:30
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10673182'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:14:30
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '10673182') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2024-08-30 15:14:30
记录内容：2024-08-30 15:14:30
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2024-08-30 15:14:30
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20240830018439</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2024-08-30 15:14:30
记录内容：2024-08-30 15:14:30
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2024-08-30 15:33:35
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>100436514</patientid><visited>100436514</visited><prescriptions><prescriptionrow><prescriptionrno>14767741</prescriptionrno></prescriptionrow><prescriptionrow><prescriptionrno>14767742</prescriptionrno></prescriptionrow></prescriptions><totalamount>720.0000</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2024-08-30 15:33:35
记录内容：'14767741','14767742'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2024-08-30 15:33:35
记录内容：2024-08-30 15:33:35
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2024-08-30 15:33:36
记录内容：2024-08-30 15:33:36
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________ INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20240830018533','100436514','熊安灿','一般人员','自费',to_date('2024/08/30 15:33:35','yyyy/mm/dd hh24:mi:ss'),'720','720','XIONG AN CAN ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/8/30 15:14:53','yyyy/mm/dd hh24:mi:ss'),'4260','100436514','0','','0304','陈云平','20240830018533','202408303975') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 15:33:35','yyyy/mm/dd hh24:mi:ss'),'4260','20240830018533','1','C','H0300087','C—反应蛋白测定(CRP)全血快速定量加收','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','陈云平','0304','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 15:33:35','yyyy/mm/dd hh24:mi:ss'),'4260','20240830018533','2','C','H0300070','C-反应蛋白测定(CRP)免疫比浊法','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','1','','0','陈云平','0304','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 15:33:35','yyyy/mm/dd hh24:mi:ss'),'4260','20240830018533','3','C','H0000026','血细胞分析','/','11','项','0411','11','11','0','1','M','025','190','1.0000','1.0000','1','','0','陈云平','0304','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 15:33:35','yyyy/mm/dd hh24:mi:ss'),'4260','20240830018533','4','C','H0000053','血细胞分析(流式细胞仪法每增一项指标)','/','13','项','0411','13','13','0','1','M','025','190','1.0000','1.0000','1','','0','陈云平','0304','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/8/30 15:14:53','yyyy/mm/dd hh24:mi:ss'),'4262','100436514','0','','0304','陈云平','20240830018533','202408303975') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 15:33:35','yyyy/mm/dd hh24:mi:ss'),'4262','20240830018533','1','C','H0304004','特殊变应原(多价变应原)筛查','/','10','项','0435','300','300','0','1','M','025','190','1.0000','30.0000','2','','0','陈云平','0304','0','过敏原21项检测','JY001550','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 15:33:35','yyyy/mm/dd hh24:mi:ss'),'4262','20240830018533','2','C','H0304008','专项变应原(单价变应原)筛查','/','10','项','0435','300','300','0','1','M','025','190','1.0000','30.0000','2','','0','陈云平','0304','0','过敏原21项检测','JY001550','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 15:33:36','yyyy/mm/dd hh24:mi:ss'),'4262','20240830018533','3','C','H0304016','总IgE测定（电化学发光法）','/','1','项','0435','50','50','0','1','M','025','190','1.0000','50.0000','2','','0','陈云平','0304','0','过敏原21项检测','JY001550','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240830018533','1','微信','720','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14767741' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14767741' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14767741' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14767741' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14767742' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14767742' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14767742' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14767741' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14767741' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14767741' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14767741' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14767742' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14767742' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14767742' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14767741'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14767741'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14767741'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14767741'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14767742'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14767742'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14767742'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2408307410'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2408307409'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE exam_appoints SET costs='650',charges='650',BILLING_INDICATOR='1' WHERE EXAM_NO = '2408307410'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE exam_appoints SET costs='70',charges='70',BILLING_INDICATOR='1' WHERE EXAM_NO = '2408307409'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100436514'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '100436514' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100436514'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:33:36
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '100436514') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2024-08-30 15:33:36
记录内容：2024-08-30 15:33:36
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2024-08-30 15:33:36
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20240830018533</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2024-08-30 15:33:36
记录内容：2024-08-30 15:33:36
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2024-08-30 15:42:14
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>100436514</patientid><visited>100436514</visited><prescriptions><prescriptionrow><prescriptionrno>14767839</prescriptionrno></prescriptionrow></prescriptions><totalamount>12.8300</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2024-08-30 15:42:14
记录内容：'14767839'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2024-08-30 15:42:14
记录内容：2024-08-30 15:42:14
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2024-08-30 15:42:15
记录内容：2024-08-30 15:42:15
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________ INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20240830018594','100436514','熊安灿','一般人员','自费',to_date('2024/08/30 15:42:14','yyyy/mm/dd hh24:mi:ss'),'12.83','12.83','XIONG AN CAN ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/8/30 15:14:53','yyyy/mm/dd hh24:mi:ss'),'4382','100436514','0','','0304','陈云平','20240830018594','202408303975') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 15:42:14','yyyy/mm/dd hh24:mi:ss'),'4382','20240830018594','1','E','E0003053','静脉采血(6周岁及以下儿童)','/','1','次','0304','9.1','9.1','0','1','C','022','300','1.0000','9.1000','3','','0','陈云平','0304','0','静脉采血(6周岁及以下儿童)','ZL000586','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 15:42:15','yyyy/mm/dd hh24:mi:ss'),'4382','20240830018594','2','J','I0010277','真空采血管','2.7ml/碧迪','2','支','0304','3.26','3.26','0','1','C','022','300','1.0000','1.6300','4','','0','陈云平','0304','0','真空采血管','I0010277','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 15:42:15','yyyy/mm/dd hh24:mi:ss'),'4382','20240830018594','3','J','I0005129','一次性使用静脉血样采集针','S-7输液式/威高','1','支','0304','0.47','0.47','0','1','L','031','170','1.0000','0.4700','5','','0','陈云平','0304','0','一次性使用静脉血样采集针','I0005129','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240830018594','1','微信','12.83','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14767839' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14767839' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14767839' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14767839' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14767839' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14767839' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14767839'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14767839'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14767839'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2408307410'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2408307409'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________UPDATE exam_appoints SET costs='38.49',charges='38.49',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________UPDATE exam_appoints SET costs='650',charges='650',BILLING_INDICATOR='1' WHERE EXAM_NO = '2408307410'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________UPDATE exam_appoints SET costs='70',charges='70',BILLING_INDICATOR='1' WHERE EXAM_NO = '2408307409'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100436514'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '100436514' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100436514'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 15:42:15
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '100436514') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2024-08-30 15:42:15
记录内容：2024-08-30 15:42:15
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2024-08-30 15:42:15
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20240830018594</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2024-08-30 15:42:15
记录内容：2024-08-30 15:42:15
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2024-08-30 16:46:13
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>100436514</patientid><visited>100436514</visited><prescriptions><prescriptionrow><prescriptionrno>14768132</prescriptionrno></prescriptionrow></prescriptions><totalamount>8.5200</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2024-08-30 16:46:13
记录内容：'14768132'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2024-08-30 16:46:13
记录内容：2024-08-30 16:46:13
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2024-08-30 16:46:13
记录内容：2024-08-30 16:46:13
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 16:46:14
记录内容：__________ INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20240830018821','100436514','熊安灿','一般人员','自费',to_date('2024/08/30 16:46:13','yyyy/mm/dd hh24:mi:ss'),'8.52','8.52','XIONG AN CAN ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 16:46:14
记录内容：__________ 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('2024/08/30 16:46:13','yyyy/mm/dd hh24:mi:ss'),'4931','050101','100436514','熊安灿','XIONG AN CAN ','一般人员','自费','0','门诊处方','0','1','8.52','8.52','0304','CYP11','陈云平','CYP11','20240830018821','1','202408304772','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 16:46:14
记录内容：__________ 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('2024-08-30 16:46:13', 'yyyy-mm-dd hh24:mi:ss'),'4931','1','11001044440','0.1%(5g:5mg)*10g','糠酸莫米松乳膏10g','武汉诺安','0.1%(5g:5mg)*10g','支','1','8.52','8.52','.1;g;外用;2/日','1','1','0.1','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 16:46:14
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/8/30 15:14:53','yyyy/mm/dd hh24:mi:ss'),'5011','100436514','1','门诊处方','0304','陈云平','20240830018821','202408303975') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 16:46:14
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/08/30 16:46:13','yyyy/mm/dd hh24:mi:ss'),'5011','20240830018821','1','A','11001044440','糠酸莫米松乳膏10g','0.1%(5g:5mg)*10g武汉诺安','1','支','050101','8.52','8.52','0','1','C','022','300','1.0000','8.5200','1','.1;g;外用;2/日','0','陈云平','0304','0','糠酸莫米松乳膏10g','11001044440','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 16:46:14
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240830018821','1','微信','8.52','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 16:46:14
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14768132' and presc_no = '4931' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 16:46:14
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14768132'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 16:46:14
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 16:46:14
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2408307410'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 16:46:14
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2408307409'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 16:46:14
记录内容：__________UPDATE exam_appoints SET costs='38.49',charges='38.49',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 16:46:14
记录内容：__________UPDATE exam_appoints SET costs='650',charges='650',BILLING_INDICATOR='1' WHERE EXAM_NO = '2408307410'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 16:46:14
记录内容：__________UPDATE exam_appoints SET costs='70',charges='70',BILLING_INDICATOR='1' WHERE EXAM_NO = '2408307409'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 16:46:14
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100436514'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 16:46:14
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '100436514' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 16:46:14
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100436514'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-08-30 16:46:14
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '100436514') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2024-08-30 16:46:14
记录内容：2024-08-30 16:46:14
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2024-08-30 16:46:14
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20240830018821</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2024-08-30 16:46:14
记录内容：2024-08-30 16:46:14
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆