◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2024-09-03 08:27:56
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>10518396</patientid><visited>10518396</visited><prescriptions><prescriptionrow><prescriptionrno>14786544</prescriptionrno></prescriptionrow></prescriptions><totalamount>66.7200</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2024-09-03 08:27:56
记录内容：'14786544'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2024-09-03 08:27:56
记录内容：2024-09-03 08:27:56
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2024-09-03 08:27:57
记录内容：2024-09-03 08:27:57
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:27: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 ('20240903008846','10518396','祝圣懿','一般人员','自费',to_date('2024/09/03 08:27:56','yyyy/mm/dd hh24:mi:ss'),'66.72','66.72','ZHU SHENG  ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:27: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/9/2 9:20:56','yyyy/mm/dd hh24:mi:ss'),'75','10518396','0','','0304','陈树新','20240903008846','20240902323') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:27: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/09/03 08:27:56','yyyy/mm/dd hh24:mi:ss'),'75','20240903008846','1','D','D0101110','数字化摄影(DR)','/','1','曝光次数','0404','50','50','0','1','C','022','300','1.0000','50.0000','1','','0','陈树新','0304','0','*DR双手正位','20088','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:27: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/09/03 08:27:56','yyyy/mm/dd hh24:mi:ss'),'75','20240903008846','2','D','D0101125','14×17(加滤线器加收) ','/','1','次','0404','2','2','0','1','J','005','160','1.0000','2.0000','1','','0','陈树新','0304','0','*DR双手正位','20088','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:27: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/09/03 08:27:56','yyyy/mm/dd hh24:mi:ss'),'75','20240903008846','3','D','I0012937','医用红外干式激光胶片','MDI-HLJ-Q 35cm*43cm/广西巨星','1','张','0304','14.72','14.72','0','1','C','022','300','1.0000','14.7200','1','','0','陈树新','0304','0','*DR双手正位','20088','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:27:57
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240903008846','1','微信','66.72','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:27:57
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14786544' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:27:57
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14786544' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:27:57
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14786544' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:27:57
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14786544' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:27:57
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14786544' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:27:57
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14786544' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:27:57
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14786544'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:27:57
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14786544'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:27:57
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14786544'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:27:57
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5122133'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:27:57
记录内容：__________UPDATE exam_appoints SET costs='66.72',charges='66.72',BILLING_INDICATOR='1' WHERE EXAM_NO = '5122133'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:27:57
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10518396'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:27:57
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '10518396' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:27:57
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10518396'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:27:57
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '10518396') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2024-09-03 08:27:57
记录内容：2024-09-03 08:27:57
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2024-09-03 08:27:57
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20240903008846</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2024-09-03 08:27:57
记录内容：2024-09-03 08:27:57
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2024-09-03 08:58:16
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>100437541</patientid><visited>100437541</visited><prescriptions><prescriptionrow><prescriptionrno>14787011</prescriptionrno></prescriptionrow></prescriptions><totalamount>446.0000</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2024-09-03 08:58:16
记录内容：'14787011'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2024-09-03 08:58:16
记录内容：2024-09-03 08:58:16
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2024-09-03 08:58:16
记录内容：2024-09-03 08:58:16
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:58:16
记录内容：__________ 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 ('20240903009051','100437541','胡运玉','一般人员','自费',to_date('2024/09/03 08:58:16','yyyy/mm/dd hh24:mi:ss'),'446','446','HU YUN YU ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:58:16
记录内容：__________ 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/9/2 16:17:58','yyyy/mm/dd hh24:mi:ss'),'1130','100437541','0','','0332','王佳璐','20240903009051','202409027812') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:58:16
记录内容：__________ 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/09/03 08:58:16','yyyy/mm/dd hh24:mi:ss'),'1130','20240903009051','1','D','D0300097','X线计算机体层(CT)成像','/','1','每个部位','0405','60','60','0','1','C','022','300','1.0000','60.0000','1','','0','王佳璐','0332','0','骨三维成像','JC001813','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:58:16
记录内容：__________ 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/09/03 08:58:16','yyyy/mm/dd hh24:mi:ss'),'1130','20240903009051','2','D','D0300124','X线计算机体层(CT)平扫','/','2','每个部位','0405','386','386','0','1','C','022','300','1.0000','193.0000','2','','0','王佳璐','0332','0','肋骨+胸部CT','JC001720','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:58:16
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240903009051','1','微信','446','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:58:16
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14787011' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:58:16
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14787011' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:58:16
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14787011' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:58:16
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14787011' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:58:16
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14787011'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:58:16
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14787011'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:58:16
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5122258'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:58:16
记录内容：__________UPDATE exam_appoints SET costs='892',charges='892',BILLING_INDICATOR='1' WHERE EXAM_NO = '5122258'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:58:16
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100437541'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:58:16
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '100437541' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:58:16
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100437541'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 08:58:16
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '100437541') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2024-09-03 08:58:16
记录内容：2024-09-03 08:58:16
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2024-09-03 08:58:16
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20240903009051</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2024-09-03 08:58:16
记录内容：2024-09-03 08:58:16
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2024-09-03 09:32:40
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>Z00208424</patientid><visited>Z00208424</visited><prescriptions><prescriptionrow><prescriptionrno>14787628</prescriptionrno></prescriptionrow></prescriptions><totalamount>20.0000</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2024-09-03 09:32:40
记录内容：'14787628'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2024-09-03 09:32:40
记录内容：2024-09-03 09:32:40
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2024-09-03 09:32:40
记录内容：2024-09-03 09:32:40
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:32:40
记录内容：__________ 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 ('20240903009322','Z00208424','李懿洋','一般人员','自费',to_date('2024/09/03 09:32:40','yyyy/mm/dd hh24:mi:ss'),'20','20','LI  YANG ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:32:40
记录内容：__________ 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/9/3 9:18:06','yyyy/mm/dd hh24:mi:ss'),'2284','Z00208424','0','','0318','范亚云','20240903009322','202409038872') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:32:40
记录内容：__________ 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/09/03 09:32:40','yyyy/mm/dd hh24:mi:ss'),'2284','20240903009322','1','E','E0600065','冷疗','/','1','每部位','0318','20','20','0','1','B','016','900','1.0000','20.0000','1','','0','范亚云','0318','0','冷冻治疗','15323','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:32:40
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240903009322','1','微信','20','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:32:40
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14787628' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:32:40
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14787628' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:32:40
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14787628'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:32:40
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:32:40
记录内容：__________UPDATE exam_appoints SET costs='20',charges='20',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:32:40
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'Z00208424'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:32:40
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = 'Z00208424' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:32:40
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'Z00208424'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:32:40
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = 'Z00208424') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2024-09-03 09:32:40
记录内容：2024-09-03 09:32:40
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2024-09-03 09:32:40
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20240903009322</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2024-09-03 09:32:40
记录内容：2024-09-03 09:32:40
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2024-09-03 09:40:40
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>10518396</patientid><visited>10518396</visited><prescriptions><prescriptionrow><prescriptionrno>14787742</prescriptionrno></prescriptionrow><prescriptionrow><prescriptionrno>14787768</prescriptionrno></prescriptionrow></prescriptions><totalamount>89.1000</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2024-09-03 09:40:40
记录内容：'14787742','14787768'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2024-09-03 09:40:40
记录内容：2024-09-03 09:40:40
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2024-09-03 09:40:40
记录内容：2024-09-03 09:40:40
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________ 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 ('20240903009384','10518396','祝圣懿','一般人员','自费',to_date('2024/09/03 09:40:40','yyyy/mm/dd hh24:mi:ss'),'89.1','89.1','ZHU SHENG  ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________ 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/9/2 9:20:56','yyyy/mm/dd hh24:mi:ss'),'2525','10518396','0','','0304','陈树新','20240903009384','20240902323') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________ 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/09/03 09:40:40','yyyy/mm/dd hh24:mi:ss'),'2525','20240903009384','1','C','H0208025','25-羟维生素D测定(25羟维生素D:化学发光法)','/','1','项','0411','80','80','0','1','M','025','190','1.0000','80.0000','2','','0','陈树新','0304','0','*25-羟维生素D检测','JY000115','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________ 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/9/2 9:20:56','yyyy/mm/dd hh24:mi:ss'),'2526','10518396','0','','0304','陈树新','20240903009384','20240902323') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________ 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/09/03 09:40:40','yyyy/mm/dd hh24:mi:ss'),'2526','20240903009384','1','E','E0003052','静脉采血','/','1','次','0304','7','7','0','1','C','022','300','1.0000','7.0000','3','','0','陈树新','0304','0','静脉采血','ZL000585','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________ 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/09/03 09:40:40','yyyy/mm/dd hh24:mi:ss'),'2526','20240903009384','2','J','I0005129','一次性使用静脉血样采集针','S-7输液式/威高','1','支','0304','0.47','0.47','0','1','L','031','170','1.0000','0.4700','4','','0','陈树新','0304','0','一次性使用静脉血样采集针','I0005129','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________ 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/09/03 09:40:40','yyyy/mm/dd hh24:mi:ss'),'2526','20240903009384','3','J','I0010277','真空采血管','2.7ml/碧迪','1','支','0304','1.63','1.63','0','1','C','022','300','1.0000','1.6300','5','','0','陈树新','0304','0','真空采血管','I0010277','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240903009384','1','微信','89.1','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14787742' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14787768' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14787768' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14787768' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14787742' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14787768' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14787768' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14787768' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14787742'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14787768'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14787768'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14787768'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2409036363'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5122133'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________UPDATE exam_appoints SET costs='27.30',charges='27.30',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________UPDATE exam_appoints SET costs='80',charges='80',BILLING_INDICATOR='1' WHERE EXAM_NO = '2409036363'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________UPDATE exam_appoints SET costs='66.72',charges='66.72',BILLING_INDICATOR='1' WHERE EXAM_NO = '5122133'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10518396'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '10518396' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10518396'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:40:41
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '10518396') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2024-09-03 09:40:41
记录内容：2024-09-03 09:40:41
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2024-09-03 09:40:41
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20240903009384</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2024-09-03 09:40:41
记录内容：2024-09-03 09:40:41
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2024-09-03 09:51:25
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>Z00333724</patientid><visited>Z00333724</visited><prescriptions><prescriptionrow><prescriptionrno>14788047</prescriptionrno></prescriptionrow></prescriptions><totalamount>9.5700</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2024-09-03 09:51:25
记录内容：'14788047'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2024-09-03 09:51:25
记录内容：2024-09-03 09:51:25
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2024-09-03 09:51:25
记录内容：2024-09-03 09:51:25
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________ INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20240903009463','Z00333724','康春丽','一般人员','自费',to_date('2024/09/03 09:51:25','yyyy/mm/dd hh24:mi:ss'),'9.57','9.57','KANG CHUN LI ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/9/3 8:38:16','yyyy/mm/dd hh24:mi:ss'),'2897','Z00333724','0','','0316','王兰','20240903009463','20240903424') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/09/03 09:51:25','yyyy/mm/dd hh24:mi:ss'),'2897','20240903009463','1','E','E0003052','静脉采血','/','1','次','0316','7','7','0','1','C','022','300','1.0000','7.0000','5','','0','王兰','0316','0','*采血套餐二','15642','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/09/03 09:51:25','yyyy/mm/dd hh24:mi:ss'),'2897','20240903009463','2','E','I0001053','一次性使用静脉血样采集针','0.7简易的','1','支','0316','0.47','0.47','0','1','L','031','170','1.0000','0.4700','5','','0','王兰','0316','0','*采血套餐二','15642','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/09/03 09:51:25','yyyy/mm/dd hh24:mi:ss'),'2897','20240903009463','3','E','I0009141','一次性使用真空采血管','2ml/阳普','2','支','0316','2.1','2.1','0','1','L','031','170','1.0000','1.0500','5','','0','王兰','0316','0','*采血套餐二','15642','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240903009463','1','微信','9.57','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14788047' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14788047' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14788047' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14788047' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14788047' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14788047' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14788047'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14788047'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14788047'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5122477'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2409036409'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2409036407'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________UPDATE exam_appoints SET costs='9.57',charges='9.57',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________UPDATE exam_appoints SET costs='130',charges='130',BILLING_INDICATOR='1' WHERE EXAM_NO = '5122477'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________UPDATE exam_appoints SET costs='180',charges='180',BILLING_INDICATOR='1' WHERE EXAM_NO = '2409036409'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________UPDATE exam_appoints SET costs='560',charges='560',BILLING_INDICATOR='1' WHERE EXAM_NO = '2409036407'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'Z00333724'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = 'Z00333724' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'Z00333724'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:51:26
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = 'Z00333724') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2024-09-03 09:51:26
记录内容：2024-09-03 09:51:26
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2024-09-03 09:51:26
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20240903009463</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2024-09-03 09:51:26
记录内容：2024-09-03 09:51:26
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2024-09-03 09:53:08
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>10552002</patientid><visited>10552002</visited><prescriptions><prescriptionrow><prescriptionrno>14788012</prescriptionrno></prescriptionrow></prescriptions><totalamount>240.0000</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2024-09-03 09:53:08
记录内容：'14788012'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2024-09-03 09:53:08
记录内容：2024-09-03 09:53:08
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2024-09-03 09:53:08
记录内容：2024-09-03 09:53:08
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________ 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 ('20240903009469','10552002','王志伶','一般人员','自费',to_date('2024/09/03 09:53:08','yyyy/mm/dd hh24:mi:ss'),'240','240','WANG ZHI LING ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________ 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/31 10:02:20','yyyy/mm/dd hh24:mi:ss'),'2961','10552002','0','','0359','李胜朝','20240903009469','202408319867') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________ 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/09/03 09:53:08','yyyy/mm/dd hh24:mi:ss'),'2961','20240903009469','1','D','D0606006','室壁运动分析','/','1','次','0359','30','30','0','1','J','006','150','1.0000','30.0000','1','','0','李胜朝','0359','0','室壁运动分析②','JC001921','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________ 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/09/03 09:53:08','yyyy/mm/dd hh24:mi:ss'),'2961','20240903009469','2','D','D0605004','心脏彩色多普勒超声','/','1','次','0359','120','120','0','1','J','006','150','1.0000','120.0000','2','','0','李胜朝','0359','0','心脏彩色多普勒超声检查','JC001919','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________ 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/09/03 09:53:08','yyyy/mm/dd hh24:mi:ss'),'2961','20240903009469','3','D','D0607008','超声计算机图文报告','/','1','次','0359','10','10','0','1','J','006','150','1.0000','10.0000','2','','0','李胜朝','0359','0','心脏彩色多普勒超声检查','JC001919','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________ 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/09/03 09:53:08','yyyy/mm/dd hh24:mi:ss'),'2961','20240903009469','4','D','D0606004','组织多普勒显像(TDl)','/','1','次','0359','30','30','0','1','C','022','300','1.0000','30.0000','3','','0','李胜朝','0359','0','组织多普勒显像(TDl)③','JC001922','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________ 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/09/03 09:53:08','yyyy/mm/dd hh24:mi:ss'),'2961','20240903009469','5','D','D0605025','左/右心功能测定','/','1','次','0359','50','50','0','1','C','022','300','1.0000','50.0000','4','','0','李胜朝','0359','0','左/右心功能测定⑤','JC001961','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240903009469','1','微信','240','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14788012' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14788012' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14788012' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14788012' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14788012' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14788012' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14788012' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14788012' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14788012' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14788012' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14788012'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14788012'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14788012'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14788012'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14788012'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10552002'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '10552002' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10552002'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 09:53:08
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '10552002') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2024-09-03 09:53:08
记录内容：2024-09-03 09:53:08
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2024-09-03 09:53:08
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20240903009469</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2024-09-03 09:53:08
记录内容：2024-09-03 09:53:08
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2024-09-03 10:26:07
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>100305248</patientid><visited>100305248</visited><prescriptions><prescriptionrow><prescriptionrno>14788494</prescriptionrno></prescriptionrow><prescriptionrow><prescriptionrno>14788497</prescriptionrno></prescriptionrow><prescriptionrow><prescriptionrno>14788502</prescriptionrno></prescriptionrow><prescriptionrow><prescriptionrno>14788533</prescriptionrno></prescriptionrow></prescriptions><totalamount>622.1801</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2024-09-03 10:26:07
记录内容：'14788494','14788497','14788502','14788533'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2024-09-03 10:26:07
记录内容：2024-09-03 10:26:07
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2024-09-03 10:26:07
记录内容：2024-09-03 10:26:07
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________ 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 ('20240903009776','100305248','刘木楠','一般人员','自费',to_date('2024/09/03 10:26:07','yyyy/mm/dd hh24:mi:ss'),'622.1801','622.1801','LIU MU  ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________ 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/9/3 9:31:37','yyyy/mm/dd hh24:mi:ss'),'4032','100305248','0','','0316','王兰','20240903009776','202409032259') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________ 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/09/03 10:26:07','yyyy/mm/dd hh24:mi:ss'),'4032','20240903009776','1','D','H0801014','脱落细胞学检查与诊断','/','1','例','0412','40','40','0','1','J','015','150','1.0000','40.0000','1','','0','王兰','0316','0','*妇科细胞学检查','21271','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________ 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/09/03 10:26:07','yyyy/mm/dd hh24:mi:ss'),'4032','20240903009776','2','D','H0807007','液基薄层细胞制片术(Thin Prep)','/','1','次','0412','120','120','0','1','J','015','150','1.0000','120.0000','1','','0','王兰','0316','0','*妇科细胞学检查','21271','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________ 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/9/3 9:31:37','yyyy/mm/dd hh24:mi:ss'),'4033','100305248','0','','0316','王兰','20240903009776','202409032259') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________ 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/09/03 10:26:07','yyyy/mm/dd hh24:mi:ss'),'4033','20240903009776','1','C','H0302218','人乳头瘤病毒(HPV)核酸检测','/','1','项','0435','300','300','0','1','J','015','150','1.0000','300.0000','2','','0','王兰','0316','0','*HPV核酸检测','JY000756','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________ 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/9/3 9:31:37','yyyy/mm/dd hh24:mi:ss'),'4034','100305248','0','','0316','王兰','20240903009776','202409032259') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________ 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/09/03 10:26:07','yyyy/mm/dd hh24:mi:ss'),'4034','20240903009776','1','J','I0006783','一次性医用垫','60*90*4/健琪','1','条','0316','4.73','4.73','0','1','L','031','170','1.0000','4.7300','3','','0','王兰','0316','0','一次性医用垫','I0006783','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________ 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/09/03 10:26:07','yyyy/mm/dd hh24:mi:ss'),'4034','20240903009776','2','D','D0911001','荧光检查','/','1','每个部位','0316','15','15','0','1','J','044','150','1.0000','15.0000','4','','0','王兰','0316','0','*荧光检查(二合诊检查)(医保)','JC001094','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________ 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/09/03 10:26:07','yyyy/mm/dd hh24:mi:ss'),'4034','20240903009776','3','D','D0911066','荧光检查(二合诊检查加收)','/','1','每个部位','0316','3','3','0','1','C','022','300','1.0000','3.0000','4','','0','王兰','0316','0','*荧光检查(二合诊检查)(医保)','JC001094','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________ 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/09/03 10:26:07','yyyy/mm/dd hh24:mi:ss'),'4034','20240903009776','4','J','I0012686','一次性阴道照明扩张器','YZYKQ-100*28/康来福','1','个','0316','9.45','9.45','0','1','C','022','300','1.0000','9.4500','5','','0','王兰','0316','0','一次性阴道照明扩张器','I0012686','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________ 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/9/3 9:31:37','yyyy/mm/dd hh24:mi:ss'),'4035','100305248','0','','0316','王兰','20240903009776','202409032259') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________ 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/09/03 10:26:07','yyyy/mm/dd hh24:mi:ss'),'4035','20240903009776','1','D','D0602038','腔内彩色多普勒超声检查（经阴道）','/','1','次','0409','120','120','0','1','J','006','150','1.0000','120.0000','6','','0','王兰','0316','0','*阴式超声检查','JC000102','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________ 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/09/03 10:26:07','yyyy/mm/dd hh24:mi:ss'),'4035','20240903009776','2','D','D0607008','超声计算机图文报告','/','1','次','0409','10','10','0','1','J','006','150','1.0000','10.0000','6','','0','王兰','0316','0','*阴式超声检查','JC000102','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240903009776','1','微信','622.1801','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14788494' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14788494' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14788497' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14788502' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14788502' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14788502' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14788502' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14788533' and presc_no = '0' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14788533' and presc_no = '0' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14788494' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14788494' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14788497' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14788502' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14788502' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14788502' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14788502' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14788533' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14788533' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14788494'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14788494'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14788497'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14788502'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14788502'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14788502'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14788502'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14788533'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14788533'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5122607'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2409036667'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5122636'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE exam_appoints SET costs='96.54',charges='96.54',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE exam_appoints SET costs='160',charges='160',BILLING_INDICATOR='1' WHERE EXAM_NO = '5122607'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE exam_appoints SET costs='300',charges='300',BILLING_INDICATOR='1' WHERE EXAM_NO = '2409036667'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE exam_appoints SET costs='130',charges='130',BILLING_INDICATOR='1' WHERE EXAM_NO = '5122636'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100305248'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '100305248' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100305248'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 10:26:09
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '100305248') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2024-09-03 10:26:09
记录内容：2024-09-03 10:26:09
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2024-09-03 10:26:09
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20240903009776</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2024-09-03 10:26:09
记录内容：2024-09-03 10:26:09
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2024-09-03 11:24:22
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>Z00041020</patientid><visited>Z00041020</visited><prescriptions><prescriptionrow><prescriptionrno>14789574</prescriptionrno></prescriptionrow><prescriptionrow><prescriptionrno>14789580</prescriptionrno></prescriptionrow><prescriptionrow><prescriptionrno>14789582</prescriptionrno></prescriptionrow><prescriptionrow><prescriptionrno>14789644</prescriptionrno></prescriptionrow><prescriptionrow><prescriptionrno>14789646</prescriptionrno></prescriptionrow></prescriptions><totalamount>226.6200</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2024-09-03 11:24:22
记录内容：'14789574','14789580','14789582','14789644','14789646'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2024-09-03 11:24:22
记录内容：2024-09-03 11:24:22
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2024-09-03 11:24:22
记录内容：2024-09-03 11:24:22
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________ 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 ('20240903010283','Z00041020','徐欢','一般人员','自费',to_date('2024/09/03 11:24:22','yyyy/mm/dd hh24:mi:ss'),'226.62','226.62','XU HUAN ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________ 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/9/3 11:16:50','yyyy/mm/dd hh24:mi:ss'),'5505','Z00041020','0','','0315','马伟杰','20240903010283','202409035351') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________ 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/09/03 11:24:22','yyyy/mm/dd hh24:mi:ss'),'5505','20240903010283','1','D','D0602010','浅表器官彩色多普勒超声检查','/','1','每个部位','0409','50','50','0','1','J','006','150','1.0000','50.0000','1','','0','马伟杰','0315','0','*甲状腺及颈部淋巴结彩色多普勒超声检查','21243','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________ 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/09/03 11:24:22','yyyy/mm/dd hh24:mi:ss'),'5505','20240903010283','2','D','D0607008','超声计算机图文报告','/','1','次','0409','10','10','0','1','J','006','150','1.0000','10.0000','1','','0','马伟杰','0315','0','*甲状腺及颈部淋巴结彩色多普勒超声检查','21243','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________ 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/9/3 11:16:50','yyyy/mm/dd hh24:mi:ss'),'5506','Z00041020','0','','0315','马伟杰','20240903010283','202409035351') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________ 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/09/03 11:24:22','yyyy/mm/dd hh24:mi:ss'),'5506','20240903010283','1','C','H0209027','甲状旁腺激素测定(化学发光法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','2','','0','马伟杰','0315','0','*全片段甲状旁腺激素','21716','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________ 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/9/3 11:16:50','yyyy/mm/dd hh24:mi:ss'),'5507','Z00041020','0','','0315','马伟杰','20240903010283','202409035351') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________ 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/09/03 11:24:22','yyyy/mm/dd hh24:mi:ss'),'5507','20240903010283','1','C','H0208025','25-羟维生素D测定(25羟维生素D:化学发光法)','/','1','项','0411','80','80','0','1','M','025','190','1.0000','80.0000','3','','0','马伟杰','0315','0','*25-羟维生素D检测','JY000115','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________ 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/9/3 11:16:50','yyyy/mm/dd hh24:mi:ss'),'5508','Z00041020','0','','0315','马伟杰','20240903010283','202409035351') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________ 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/09/03 11:24:22','yyyy/mm/dd hh24:mi:ss'),'5508','20240903010283','1','C','H0203002','钾测定(火焰分光光亮度法或离子选择电极法)','/','1','项','0411','10','10','0','1','M','025','190','1.0000','10.0000','4','','0','马伟杰','0315','0','电解质6项','JY001646','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________ 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/09/03 11:24:22','yyyy/mm/dd hh24:mi:ss'),'5508','20240903010283','2','C','H0203005','钠测定(火焰分光光亮度法或离子选择电极法)','/','1','项','0411','10','10','0','1','M','025','190','1.0000','10.0000','4','','0','马伟杰','0315','0','电解质6项','JY001646','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________ 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/09/03 11:24:22','yyyy/mm/dd hh24:mi:ss'),'5508','20240903010283','3','C','H0203008','氯测定(离子选择电极法)','/','1','项','0411','10','10','0','1','M','025','190','1.0000','10.0000','4','','0','马伟杰','0315','0','电解质6项','JY001646','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________ 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/09/03 11:24:22','yyyy/mm/dd hh24:mi:ss'),'5508','20240903010283','4','C','H0203020','镁测定(比色法)','/','1','项','0411','2','2','0','1','M','025','190','1.0000','2.0000','4','','0','马伟杰','0315','0','电解质6项','JY001646','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________ 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/09/03 11:24:22','yyyy/mm/dd hh24:mi:ss'),'5508','20240903010283','5','C','H0203016','无机磷测定(比色法)','/','1','项','0411','2','2','0','1','M','025','190','1.0000','2.0000','4','','0','马伟杰','0315','0','电解质6项','JY001646','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________ 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/09/03 11:24:22','yyyy/mm/dd hh24:mi:ss'),'5508','20240903010283','6','C','H0203011','钙测定(比色法)','/','1','项','0411','2','2','0','1','M','025','190','1.0000','2.0000','4','','0','马伟杰','0315','0','电解质6项','JY001646','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________ 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/9/3 11:16:50','yyyy/mm/dd hh24:mi:ss'),'5509','Z00041020','0','','0315','马伟杰','20240903010283','202409035351') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________ 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/09/03 11:24:22','yyyy/mm/dd hh24:mi:ss'),'5509','20240903010283','1','E','E0003052','静脉采血','/','1','次','0329','7','7','0','1','C','022','300','1.0000','7.0000','5','','0','马伟杰','0315','0','*采血套餐三','15643','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________ 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/09/03 11:24:22','yyyy/mm/dd hh24:mi:ss'),'5509','20240903010283','2','E','I0001053','一次性使用静脉血样采集针','0.7简易的','1','支','0315','0.47','0.47','0','1','L','031','170','1.0000','0.4700','5','','0','马伟杰','0315','0','*采血套餐三','15643','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________ 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/09/03 11:24:22','yyyy/mm/dd hh24:mi:ss'),'5509','20240903010283','3','E','I0009141','一次性使用真空采血管','2ml/阳普','3','支','0315','3.15','3.15','0','1','L','031','170','1.0000','1.0500','5','','0','马伟杰','0315','0','*采血套餐三','15643','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240903010283','1','微信','226.62','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14789574' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14789574' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14789580' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14789582' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14789644' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14789644' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14789644' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14789644' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14789644' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14789644' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14789646' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14789646' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14789646' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14789574' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14789574' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14789580' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14789582' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14789644' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14789644' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14789644' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14789644' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14789644' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14789644' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14789646' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14789646' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14789646' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14789574'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14789574'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14789580'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14789582'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14789644'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14789644'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14789644'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14789644'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14789644'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14789644'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14789646'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14789646'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14789646'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2409037097'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2409037098'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5122812'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2409037096'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE exam_appoints SET costs='10.62',charges='10.62',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE exam_appoints SET costs='80',charges='80',BILLING_INDICATOR='1' WHERE EXAM_NO = '2409037097'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE exam_appoints SET costs='36',charges='36',BILLING_INDICATOR='1' WHERE EXAM_NO = '2409037098'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE exam_appoints SET costs='60',charges='60',BILLING_INDICATOR='1' WHERE EXAM_NO = '5122812'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE exam_appoints SET costs='40',charges='40',BILLING_INDICATOR='1' WHERE EXAM_NO = '2409037096'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'Z00041020'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = 'Z00041020' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'Z00041020'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 11:24:24
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = 'Z00041020') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2024-09-03 11:24:24
记录内容：2024-09-03 11:24:24
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2024-09-03 11:24:24
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20240903010283</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2024-09-03 11:24:24
记录内容：2024-09-03 11:24:24
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：参数
记录时间：2024-09-03 13:50:58
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><patientid>100437541</patientid><visited>100437541</visited><prescriptions><prescriptionrow><prescriptionrno>14789984</prescriptionrno></prescriptionrow><prescriptionrow><prescriptionrno>14789985</prescriptionrno></prescriptionrow></prescriptions><totalamount>389.6500</totalamount><paytype>1</paytype></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：处方号为：
记录时间：2024-09-03 13:50:58
记录内容：'14789984','14789985'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询
记录时间：2024-09-03 13:50:58
记录内容：2024-09-03 13:50:58
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行查询并操作
记录时间：2024-09-03 13:50:58
记录内容：2024-09-03 13:50:58
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________ 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 ('20240903010746','100437541','胡运玉','一般人员','自费',to_date('2024/09/03 13:50:58','yyyy/mm/dd hh24:mi:ss'),'389.65','389.65','HU YUN YU ','0','0','9328') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________ 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/09/03 13:50:58','yyyy/mm/dd hh24:mi:ss'),'6039','050101','100437541','胡运玉','HU YUN YU ','一般人员','自费','0','门诊处方','0','1','69.65','69.65','0332','WJL1','王佳璐','WJL1','20240903010746','5','202409037812','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________ 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-09-03 13:50:58', 'yyyy-mm-dd hh24:mi:ss'),'6039','1','10214058680','5ml:0.1g','盐酸利多卡因注射液**','湖南科伦','5ml:0.1g','支','1','2.23','2.23','.1;g;局麻;即刻','1','1','0.1','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________ 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-09-03 13:50:58', 'yyyy-mm-dd hh24:mi:ss'),'6039','2','10214010671','5ml:37.5mg','盐酸布比卡因注射液','华鲁制药','5ml:37.5mg','支','1','16.29','16.29','20;mg;局部注射;即刻','2','1','20','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________ 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-09-03 13:50:58', 'yyyy-mm-dd hh24:mi:ss'),'6039','3','10704030680','1ml:0.25mg','维生素B12注射液0.25mg','天津金耀','1ml:0.25mg','支','2','0.74','0.74','.5;mg;局部注射;即刻','3','1','0.5','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________ 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-09-03 13:50:58', 'yyyy-mm-dd hh24:mi:ss'),'6039','4','11001012670','1ml','[进]复方倍他米松注射液','杭州默沙东','1ml','支','1','44.3','44.3','1;ml;局部注射;即刻','4','1','1','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________ 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-09-03 13:50:58', 'yyyy-mm-dd hh24:mi:ss'),'6039','5','11303030680','100ml(双层无菌)','0.9%氯化钠注射液100ml','石家庄四药','100ml(双层无菌)','袋','1','6.09','6.09','20;ml;局部注射;即刻','5','1','20','','','','','','0','0','','','','0.0000','','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________ 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/9/2 16:17:58','yyyy/mm/dd hh24:mi:ss'),'6829','100437541','1','门诊处方','0332','王佳璐','20240903010746','202409027812') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________ 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/09/03 13:50:58','yyyy/mm/dd hh24:mi:ss'),'6829','20240903010746','1','A','10214058680','盐酸利多卡因注射液**','5ml:0.1g湖南科伦','1','支','050101','2.23','2.23','0','1','C','022','300','1.0000','2.2300','1','.1;g;局麻;即刻','0','王佳璐','0332','0','盐酸利多卡因注射液**','10214058680','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________ 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/09/03 13:50:58','yyyy/mm/dd hh24:mi:ss'),'6829','20240903010746','2','A','10214010671','盐酸布比卡因注射液','5ml:37.5mg华鲁制药','1','支','050101','16.29','16.29','0','1','C','022','300','1.0000','16.2900','2','20;mg;局部注射;即刻','0','王佳璐','0332','0','盐酸布比卡因注射液','10214010671','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________ 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/09/03 13:50:58','yyyy/mm/dd hh24:mi:ss'),'6829','20240903010746','3','A','10704030680','维生素B12注射液0.25mg','1ml:0.25mg天津金耀','2','支','050101','0.74','0.74','0','1','C','022','300','1.0000','0.3700','3','.5;mg;局部注射;即刻','0','王佳璐','0332','0','维生素B12注射液0.25mg','10704030680','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________ 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/09/03 13:50:58','yyyy/mm/dd hh24:mi:ss'),'6829','20240903010746','4','A','11001012670','[进]复方倍他米松注射液','1ml杭州默沙东','1','支','050101','44.3','44.3','0','1','C','022','300','1.0000','44.3000','4','1;ml;局部注射;即刻','0','王佳璐','0332','0','[进]复方倍他米松注射液','11001012670','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________ 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/09/03 13:50:58','yyyy/mm/dd hh24:mi:ss'),'6829','20240903010746','5','A','11303030680','0.9%氯化钠注射液100ml','100ml(双层无菌)石家庄四药','1','袋','050101','6.09','6.09','0','1','A','032','200','1.0000','6.0900','5','20;ml;局部注射;即刻','0','王佳璐','0332','0','0.9%氯化钠注射液100ml','11303030680','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________ 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/9/2 16:17:58','yyyy/mm/dd hh24:mi:ss'),'6830','100437541','0','','0332','王佳璐','20240903010746','202409027812') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________ 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/09/03 13:50:58','yyyy/mm/dd hh24:mi:ss'),'6830','20240903010746','1','D','D0602040','临床操作的彩色多普勒超声引导','/','1','半小时','0332','120','120','0','1','J','006','150','1.0000','120.0000','3','','0','王佳璐','0332','0','**临床操作的彩色多普勒超声引导','JC001046','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________ 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/09/03 13:50:58','yyyy/mm/dd hh24:mi:ss'),'6830','20240903010746','2','E','D0900043','神经阻滞治疗','/','4','次','0332','200','200','0','1','B','016','900','1.0000','50.0000','4','','0','王佳璐','0332','0','神经阻滞治疗','10621','0.0000','0.0000','0.0000','0.0000','0','') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20240903010746','1','微信','389.65','0.00') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14789984' and presc_no = '6039' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14789984' and presc_no = '6039' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14789984' and presc_no = '6039' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14789984' and presc_no = '6039' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14789984' and presc_no = '6039' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14789985' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '14789985' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14789985' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '14789985' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14789984'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14789984'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14789984'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14789984'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14789984'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14789985'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '14789985'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5122258'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE exam_appoints SET costs='640',charges='640',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE exam_appoints SET costs='892',charges='892',BILLING_INDICATOR='1' WHERE EXAM_NO = '5122258'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100437541'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in  (select test_no from lab_test_master  WHERE patient_id = '100437541' ) 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100437541'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：SQL语句
记录时间：2024-09-03 13:50:59
记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in  (select  exam_no from  exam_appoints WHERE patient_id = '100437541') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：执行写入
记录时间：2024-09-03 13:50:59
记录内容：2024-09-03 13:50:59
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回数据
记录时间：2024-09-03 13:50:59
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><returnresult>成功1</returnresult></returnresult><hisinfo><pay_id>20240903010746</pay_id></hisinfo></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：跳出方法
记录时间：2024-09-03 13:50:59
记录内容：2024-09-03 13:50:59
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆