◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2026-02-27 15:55:15 记录内容:cyys_2017@123cyys_2017@123103881671038816717931954200.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2026-02-27 15:55:15 记录内容:'17931954' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2026-02-27 15:55:15 记录内容:2026-02-27 15:55:15 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2026-02-27 15:55:16 记录内容:2026-02-27 15:55:16 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 15:55:16 记录内容: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 ('20260227003430','10388167','李守强','一般人员','自费',to_date('2026/02/27 15:55:15','yyyy/mm/dd hh24:mi:ss'),'200','200','LI SHOU QIANG ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 15:55:16 记录内容: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/27 14:42:23','yyyy/mm/dd hh24:mi:ss'),'312','10388167','0','','0303','杨春景','20260227003430','202602278838') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 15:55:16 记录内容: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/27 15:55:15','yyyy/mm/dd hh24:mi:ss'),'312','20260227003430','1','D','D0903028','温度试验','/','1','次','030301','70','70','0','1','B','016','900','1.0000','70.0000','1','','0','杨春景','0303','0','温度试验(神经电生理)','JC001939','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 15:55:16 记录内容: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/27 15:55:15','yyyy/mm/dd hh24:mi:ss'),'312','20260227003430','2','D','D1201390','前庭功能检查费(常规)','/','2','项','030301','60','60','0','1','J','044','150','1.0000','30.0000','2','','0','杨春景','0303','0','红外眼震视图(自发眼震+前庭功能检查)','JC001938','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 15:55:16 记录内容: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/27 15:55:15','yyyy/mm/dd hh24:mi:ss'),'312','20260227003430','3','D','D0903029','自发眼震','/','1','次','030301','70','70','0','1','B','016','900','1.0000','70.0000','2','','0','杨春景','0303','0','红外眼震视图(自发眼震+前庭功能检查)','JC001938','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 15:55:16 记录内容:1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20260227003430','1','微信','200','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 15:55:16 记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17931954' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 15:55:16 记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17931954' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 15:55:16 记录内容:0__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17931954' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 15:55:16 记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17931954' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 15:55:16 记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17931954' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 15:55:16 记录内容:1__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '17931954' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 15:55:16 记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17931954' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 15:55:16 记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17931954' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 15:55:16 记录内容:3__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17931954' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 15:55:16 记录内容:0__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10388167' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 15:55:16 记录内容:0__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10388167' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 15:55:16 记录内容:1__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10388167' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 15:55:16 记录内容:2__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10388167') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2026-02-27 15:55:16 记录内容:2026-02-27 15:55:16 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2026-02-27 15:55:16 记录内容:1成功2020260227003430 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2026-02-27 15:55:16 记录内容:2026-02-27 15:55:16 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2026-02-27 17:01:36 记录内容:cyys_2017@123cyys_2017@123103881671038816717932283391.89001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2026-02-27 17:01:36 记录内容:'17932283' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2026-02-27 17:01:36 记录内容:2026-02-27 17:01:36 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2026-02-27 17:01:36 记录内容:2026-02-27 17:01:36 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:1__________ INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20260227003720','10388167','李守强','一般人员','自费',to_date('2026/02/27 17:01:36','yyyy/mm/dd hh24:mi:ss'),'391.89','391.89','LI SHOU QIANG ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:1__________ INSERT INTO drug_presc_master_temp (presc_date,presc_no,dispensary,PATIENT_ID,NAME,NAME_PHONETIC,IDENTITY,CHARGE_TYPE,PRESC_TYPE,PRESC_ATTR,PRESC_SOURCE,REPETITION,COSTS,PAYMENTS,ORDERED_BY,PRESCRIBED_BY,ENTERED_BY,DOCTOR_USER,RCPT_NO,COUNT_PER_REPETITION,CLINIC_NO,IS_SEND,SEND_WIN_NO) VALUES (to_date('2026/02/27 17:01:36','yyyy/mm/dd hh24:mi:ss'),'1153','050101','10388167','李守强','','一般人员','自费','0','门诊处方','0','1','391.89','391.89','0306','FENGPX','冯培习','FENGPX','20260227003720','4','202602279479','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:1__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2026-02-27 17:01:36', 'yyyy-mm-dd hh24:mi:ss'),'1153','1','11405021010','1喷(6ml:7.68mg)*120','[进]布地奈德鼻喷雾剂','健乔信元','1喷(6ml:7.68mg)*120','瓶','1','45.85','45.85','2;喷;外用;2/日','1','1','2','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:1__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2026-02-27 17:01:36', 'yyyy-mm-dd hh24:mi:ss'),'1153','2','11405059010','16.7mg','富马酸酮替芬鼻喷雾剂','京卫制药','16.7mg','支','1','83.84','83.84','.3;mg;外用;2/日','2','1','0.3','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:1__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2026-02-27 17:01:36', 'yyyy-mm-dd hh24:mi:ss'),'1153','3','10214060390','5mg*6','氢溴酸山莨菪碱片','成都第一','5mg*6','盒','1','112.7','112.7','5;mg;口服;2/日','3','1','5','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:1__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2026-02-27 17:01:36', 'yyyy-mm-dd hh24:mi:ss'),'1153','4','20101028580','30g(0.75g/10丸)','辛夷鼻炎丸','东莞市亚洲','30g(0.75g/10丸)','盒','2','149.5','149.5','3;g;口服;3/日','4','1','3','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:1__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2026/2/27 14:42:23','yyyy/mm/dd hh24:mi:ss'),'1162','10388167','1','门诊处方','0306','冯培习','20260227003720','202602278838') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:1__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2026/02/27 17:01:36','yyyy/mm/dd hh24:mi:ss'),'1162','20260227003720','1','A','11405021010','[进]布地奈德鼻喷雾剂','1喷(6ml:7.68mg)*120健乔信元','1','瓶','050101','45.85','45.85','0','1','A','032','200','1.0000','45.8500','1','2;喷;外用;2/日','0','冯培习','0306','0','[进]布地奈德鼻喷雾剂','11405021010','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:1__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2026/02/27 17:01:36','yyyy/mm/dd hh24:mi:ss'),'1162','20260227003720','2','A','11405059010','富马酸酮替芬鼻喷雾剂','16.7mg京卫制药','1','支','050101','83.84','83.84','0','1','A','032','200','1.0000','83.8400','2','.3;mg;外用;2/日','0','冯培习','0306','0','富马酸酮替芬鼻喷雾剂','11405059010','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:1__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2026/02/27 17:01:36','yyyy/mm/dd hh24:mi:ss'),'1162','20260227003720','3','A','10214060390','氢溴酸山莨菪碱片','5mg*6成都第一','1','盒','050101','112.7','112.7','0','1','A','032','200','1.0000','112.7000','3','5;mg;口服;2/日','0','冯培习','0306','0','氢溴酸山莨菪碱片','10214060390','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:1__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2026/02/27 17:01:36','yyyy/mm/dd hh24:mi:ss'),'1162','20260227003720','4','A','20101028580','辛夷鼻炎丸','30g(0.75g/10丸)东莞市亚洲','2','盒','050101','149.5','149.5','0','1','D','033','600','1.0000','74.7500','4','3;g;口服;3/日','0','冯培习','0306','0','辛夷鼻炎丸','20101028580','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:1__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20260227003720','1','微信','391.89','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17932283' and presc_no = '1153' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17932283' and presc_no = '1153' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17932283' and presc_no = '1153' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:1__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '17932283' and presc_no = '1153' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:4__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17932283' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:4__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17932283' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:4__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17932283' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:4__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '17932283' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:0__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10388167' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:0__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10388167' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:1__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10388167' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2026-02-27 17:01:36 记录内容:2__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10388167') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2026-02-27 17:01:36 记录内容:2026-02-27 17:01:36 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2026-02-27 17:01:36 记录内容:1成功3420260227003720 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2026-02-27 17:01:36 记录内容:2026-02-27 17:01:36 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆