◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2026-02-15 11:17:59
记录内容:cyys_2017@123cyys_2017@1231005383201005383201787651947.00001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2026-02-15 11:17:59
记录内容:'17876519'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2026-02-15 11:17:59
记录内容:2026-02-15 11:17:59
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2026-02-15 11:17:59
记录内容:2026-02-15 11:17:59
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-15 11:17:59
记录内容:1__________ INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20260215013263','100538320','郭溪瑶','一般人员','自费',to_date('2026/02/15 11:17:59','yyyy/mm/dd hh24:mi:ss'),'47','47','GUO XI YAO ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-15 11:17:59
记录内容:1__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2026/2/15 11:07:16','yyyy/mm/dd hh24:mi:ss'),'885','100538320','0','','0304','杨艳辉','20260215013263','20260215724')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-15 11:17:59
记录内容:1__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2026/02/15 11:17:59','yyyy/mm/dd hh24:mi:ss'),'885','20260215013263','1','C','H0300087','C—反应蛋白测定(CRP)全血快速定量加收','/','1','项','0411','30','30','0','1','M','025','190','1.0000','30.0000','1','','0','杨艳辉','0304','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-15 11:17:59
记录内容:1__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2026/02/15 11:17:59','yyyy/mm/dd hh24:mi:ss'),'885','20260215013263','2','C','H0300070','C-反应蛋白测定(CRP)免疫比浊法','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','1','','0','杨艳辉','0304','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-15 11:17:59
记录内容:1__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2026/02/15 11:17:59','yyyy/mm/dd hh24:mi:ss'),'885','20260215013263','3','C','H0201028','血细胞分析(五分类收)','/','1','项','0411','11','11','0','1','M','025','190','1.0000','11.0000','1','','0','杨艳辉','0304','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-15 11:17:59
记录内容:1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20260215013263','1','微信','47','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-15 11:17:59
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17876519' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-15 11:17:59
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17876519' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-15 11:17:59
记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17876519' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-15 11:17:59
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17876519' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-15 11:17:59
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17876519' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-15 11:17:59
记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17876519' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-15 11:17:59
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17876519'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-15 11:17:59
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17876519'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-15 11:17:59
记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17876519'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-15 11:17:59
记录内容:0__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2602152788'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-15 11:17:59
记录内容:0__________UPDATE exam_appoints SET costs='47',charges='47',BILLING_INDICATOR='1' WHERE EXAM_NO = '2602152788'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-15 11:17:59
记录内容:1__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100538320'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-15 11:17:59
记录内容:1__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100538320' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-15 11:17:59
记录内容:0__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100538320'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2026-02-15 11:17:59
记录内容:0__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100538320')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2026-02-15 11:17:59
记录内容:2026-02-15 11:17:59
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2026-02-15 11:17:59
记录内容:1成功1920260215013263
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2026-02-15 11:17:59
记录内容:2026-02-15 11:17:59
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆