◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2024-11-08 08:31:45 记录内容：cyys_2017@123cyys_2017@123Z00071175Z000711751515066245.92001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2024-11-08 08:31:45 记录内容：'15150662' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2024-11-08 08:31:45 记录内容：2024-11-08 08:31:45 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2024-11-08 08:31:46 记录内容：2024-11-08 08:31:46 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 08:31:46 记录内容：__________ 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 ('20241108005400','Z00071175','李波','一般人员','自费',to_date('2024/11/08 08:31:45','yyyy/mm/dd hh24:mi:ss'),'45.92','45.92','LI BO ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 08:31:46 记录内容：__________ 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/11/08 08:31:45','yyyy/mm/dd hh24:mi:ss'),'1918','050101','Z00071175','李波','LI BO','一般人员','自费','0','门诊处方','0','1','45.92','45.92','0303','ZHANGJC','张杰俊','ZHANGJC','20241108005400','1','202411081838','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 08:31:46 记录内容：__________ 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-11-08 08:31:45', 'yyyy-mm-dd hh24:mi:ss'),'1918','1','10206020390','10mg*7','[进]酒石酸唑吡坦片*','赛诺菲','10mg*7','盒','2','45.92','45.92','10;mg;口服;睡前','1','1','10','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 08:31:46 记录内容：__________ 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/11/8 8:26:23','yyyy/mm/dd hh24:mi:ss'),'1965','Z00071175','1','门诊处方','0303','张杰俊','20241108005400','202411081838') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 08:31:46 记录内容：__________ 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/11/08 08:31:45','yyyy/mm/dd hh24:mi:ss'),'1965','20241108005400','1','A','10206020390','[进]酒石酸唑吡坦片*','10mg*7赛诺菲','2','盒','050101','45.92','45.92','0','1','C','022','300','1.0000','22.9600','1','10;mg;口服;睡前','0','张杰俊','0303','0','[进]酒石酸唑吡坦片*','10206020390','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 08:31:46 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20241108005400','1','微信','45.92','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 08:31:46 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15150662' and presc_no = '1918' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 08:31:46 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15150662' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 08:31:46 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'Z00071175' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 08:31:46 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = 'Z00071175' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 08:31:46 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'Z00071175' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 08:31:46 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = 'Z00071175') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2024-11-08 08:31:46 记录内容：2024-11-08 08:31:46 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2024-11-08 08:31:46 记录内容：1成功120241108005400 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2024-11-08 08:31:46 记录内容：2024-11-08 08:31:46 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2024-11-08 09:24:41 记录内容：cyys_2017@123cyys_2017@1231003661061003661061515150663.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2024-11-08 09:24:41 记录内容：'15151506' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2024-11-08 09:24:41 记录内容：2024-11-08 09:24:41 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2024-11-08 09:24:41 记录内容：2024-11-08 09:24:41 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 09:24:42 记录内容：__________ 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 ('20241108005703','100366106','王雪健','一般人员','自费',to_date('2024/11/08 09:24:41','yyyy/mm/dd hh24:mi:ss'),'63','63','WANG XUE JIAN ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 09:24:42 记录内容：__________ 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/11/8 8:41:00','yyyy/mm/dd hh24:mi:ss'),'3669','100366106','0','','0318','常庆华','20241108005703','202411082241') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 09:24:42 记录内容：__________ 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/11/08 09:24:41','yyyy/mm/dd hh24:mi:ss'),'3669','20241108005703','1','E','D0913011','伍德氏灯检查','/','1','次','0318','8','8','0','1','B','016','900','1.0000','8.0000','1','','0','常庆华','0318','0','伍德氏灯检查','11789','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 09:24:42 记录内容：__________ 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/11/08 09:24:41','yyyy/mm/dd hh24:mi:ss'),'3669','20241108005703','2','D','D0913028','皮肤镜检查','/','1','次','0318','55','55','0','1','J','044','150','1.0000','55.0000','2','','0','常庆华','0318','0','皮肤镜检查','JC001960','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 09:24:42 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20241108005703','1','微信','63','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 09:24:42 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15151506' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 09:24:42 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15151506' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 09:24:42 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15151506' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 09:24:42 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15151506' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 09:24:42 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15151506' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 09:24:42 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15151506' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 09:24:42 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 09:24:42 记录内容：__________UPDATE exam_appoints SET costs='126',charges='126',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 09:24:42 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100366106' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 09:24:42 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100366106' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 09:24:42 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100366106' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 09:24:42 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100366106') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2024-11-08 09:24:42 记录内容：2024-11-08 09:24:42 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2024-11-08 09:24:42 记录内容：1成功120241108005703 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2024-11-08 09:24:42 记录内容：2024-11-08 09:24:42 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2024-11-08 10:03:25 记录内容：cyys_2017@123cyys_2017@123100366106100366106151516501515205915152065151520691515205415152076780.17001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2024-11-08 10:03:25 记录内容：'15151650','15152059','15152065','15152069','15152054','15152076' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2024-11-08 10:03:25 记录内容：2024-11-08 10:03:25 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2024-11-08 10:03:25 记录内容：2024-11-08 10:03:25 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03: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 ('20241108006020','100366106','王雪健','一般人员','自费',to_date('2024/11/08 10:03:25','yyyy/mm/dd hh24:mi:ss'),'780.17','780.17','WANG XUE JIAN ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________ 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/11/08 10:03:25','yyyy/mm/dd hh24:mi:ss'),'3619','050101','100366106','王雪健','WANG XUE JIAN ','一般人员','自费','0','门诊处方','0','1','242.24','242.24','0318','CQH','常庆华','CQH','20241108006020','3','202411083179','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________ 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/11/08 10:03:25','yyyy/mm/dd hh24:mi:ss'),'4571','050101','100366106','王雪健','WANG XUE JIAN ','一般人员','自费','0','门诊处方','0','1','2.23','2.23','0316','HANWL','韩卫灵','HANWL','20241108006020','1','202411081740','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________ 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/11/08 10:03:25','yyyy/mm/dd hh24:mi:ss'),'4593','050101','100366106','王雪健','WANG XUE JIAN ','一般人员','自费','0','门诊处方','0','1','4.80','4.80','0316','HANWL','韩卫灵','HANWL','20241108006020','1','202411081740','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________ 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/11/08 10:03:25','yyyy/mm/dd hh24:mi:ss'),'4603','050101','100366106','王雪健','WANG XUE JIAN ','一般人员','自费','0','门诊处方','0','1','6.90','6.90','0316','HANWL','韩卫灵','HANWL','20241108006020','1','202411081740','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________ 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-11-08 10:03:25', 'yyyy-mm-dd hh24:mi:ss'),'3619','1','11403059440','10g','[进]卤米松/三氯生乳膏','希腊Famar','10g','盒','1','33.54','33.54','2;g;外用;2/日','1','1','2','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________ 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-11-08 10:03:25', 'yyyy-mm-dd hh24:mi:ss'),'3619','2','10607068390','1片*100','复方甘草酸苷片*','米诺发源','1片*100','盒','1','107.5','107.5','2;片;口服;3/日','2','1','2','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________ 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-11-08 10:03:25', 'yyyy-mm-dd hh24:mi:ss'),'3619','3','20118038450','2.5%*50g','积雪苷霜软膏','海南普利','2.5%*50g','盒','1','101.2','101.2','2;g;外用;2/日','3','1','2','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________ 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-11-08 10:03:25', 'yyyy-mm-dd hh24:mi:ss'),'4571','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-11-08 10:03:26 记录内容：__________ 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-11-08 10:03:25', 'yyyy-mm-dd hh24:mi:ss'),'4593','1','11403012450','4g(1%)','红霉素软膏*','北京双吉','4g(1%)','支','1','4.8','4.8','1;g;外用;2/日','2','1','1','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________ 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-11-08 10:03:25', 'yyyy-mm-dd hh24:mi:ss'),'4603','1','10102084270','0.25g*12','头孢克洛胶囊(0.25g*12)*','苏州中化','0.25g*12','盒','1','6.9','6.9','.25;g;口服;3/日','3','1','0.25','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03: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/11/8 8:41:00','yyyy/mm/dd hh24:mi:ss'),'4745','100366106','1','门诊处方','0318','常庆华','20241108006020','202411082241') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03: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/11/08 10:03:25','yyyy/mm/dd hh24:mi:ss'),'4745','20241108006020','1','A','11403059440','[进]卤米松/三氯生乳膏','10g希腊Famar','1','盒','050101','33.54','33.54','0','1','C','022','300','1.0000','33.5400','1','2;g;外用;2/日','0','常庆华','0318','0','[进]卤米松/三氯生乳膏','11403059440','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03: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/11/08 10:03:25','yyyy/mm/dd hh24:mi:ss'),'4745','20241108006020','2','A','10607068390','复方甘草酸苷片*','1片*100米诺发源','1','盒','050101','107.5','107.5','0','1','C','022','300','1.0000','107.5000','2','2;片;口服;3/日','0','常庆华','0318','0','复方甘草酸苷片*','10607068390','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03: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/11/08 10:03:25','yyyy/mm/dd hh24:mi:ss'),'4745','20241108006020','3','A','20118038450','积雪苷霜软膏','2.5%*50g海南普利','1','盒','050101','101.2','101.2','0','1','C','022','300','1.0000','101.2000','3','2;g;外用;2/日','0','常庆华','0318','0','积雪苷霜软膏','20118038450','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03: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/11/8 8:41:00','yyyy/mm/dd hh24:mi:ss'),'4746','100366106','0','','0318','常庆华','20241108006020','202411082241') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03: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/11/08 10:03:25','yyyy/mm/dd hh24:mi:ss'),'4746','20241108006020','1','E','D0911006','外阴活检术','/','1','次','0316','15','15','0','1','B','016','900','1.0000','15.0000','1','','0','韩卫灵','0316','0','外阴活检术','11649','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03: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/11/08 10:03:25','yyyy/mm/dd hh24:mi:ss'),'4746','20241108006020','2','H','F0000026','会阴冲洗','/','3','次','0316','9','9','0','1','E','026','140','1.0000','3.0000','2','','0','韩卫灵','0316','0','会阴冲洗','10094','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03: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/11/08 10:03:25','yyyy/mm/dd hh24:mi:ss'),'4746','20241108006020','3','F','G0000019','术中使用微波刀','/','1','次','0316','300','300','0','1','C','022','300','1.0000','300.0000','3','','0','韩卫灵','0316','0','术中使用微波刀','12180','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03: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/11/8 8:41:00','yyyy/mm/dd hh24:mi:ss'),'4747','100366106','1','门诊处方','0318','常庆华','20241108006020','202411082241') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03: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/11/08 10:03:25','yyyy/mm/dd hh24:mi:ss'),'4747','20241108006020','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','韩卫灵','0316','0','盐酸利多卡因注射液**','10214058680','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03: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/11/8 8:41:00','yyyy/mm/dd hh24:mi:ss'),'4748','100366106','1','门诊处方','0318','常庆华','20241108006020','202411082241') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03: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/11/08 10:03:25','yyyy/mm/dd hh24:mi:ss'),'4748','20241108006020','1','A','11403012450','红霉素软膏*','4g(1%)北京双吉','1','支','050101','4.8','4.8','0','1','A','032','200','1.0000','4.8000','1','1;g;外用;2/日','0','韩卫灵','0316','0','红霉素软膏*','11403012450','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03: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/11/8 8:41:00','yyyy/mm/dd hh24:mi:ss'),'4749','100366106','1','门诊处方','0318','常庆华','20241108006020','202411082241') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03: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/11/08 10:03:25','yyyy/mm/dd hh24:mi:ss'),'4749','20241108006020','1','A','10102084270','头孢克洛胶囊(0.25g*12)*','0.25g*12苏州中化','1','盒','050101','6.9','6.9','0','1','C','022','300','1.0000','6.9000','1','.25;g;口服;3/日','0','韩卫灵','0316','0','头孢克洛胶囊(0.25g*12)*','10102084270','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03: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/11/8 8:41:00','yyyy/mm/dd hh24:mi:ss'),'4750','100366106','0','','0318','常庆华','20241108006020','202411082241') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03: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/11/08 10:03:25','yyyy/mm/dd hh24:mi:ss'),'4750','20241108006020','1','D','H0802007','局部切除组织活检检查与诊断','/','1','每个部位','0412','180','180','0','1','J','015','150','1.0000','180.0000','4','','0','韩卫灵','0316','0','*小标本活检','10513','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03: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/11/08 10:03:25','yyyy/mm/dd hh24:mi:ss'),'4750','20241108006020','2','D','H0807010','显微摄影术','/','1','每个视野','0412','20','20','0','1','J','015','150','1.0000','20.0000','4','','0','韩卫灵','0316','0','*小标本活检','10513','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20241108006020','1','微信','780.17','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15151650' and presc_no = '3619' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15151650' and presc_no = '3619' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15151650' and presc_no = '3619' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15152054' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15152054' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15152054' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15152059' and presc_no = '4571' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15152065' and presc_no = '4593' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15152069' and presc_no = '4603' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15152076' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15152076' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15152054' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15152054' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15152054' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15152076' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15152076' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15151650' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15151650' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15151650' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15152054' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15152054' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15152054' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15152059' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15152065' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15152069' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15152076' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15152076' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE exam_appoints SET costs='126',charges='126',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100366106' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100366106' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100366106' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 10:03:26 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100366106') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2024-11-08 10:03:26 记录内容：2024-11-08 10:03:26 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2024-11-08 10:03:26 记录内容：1成功120241108006020 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2024-11-08 10:03:26 记录内容：2024-11-08 10:03:26 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2024-11-08 14:00:39 记录内容：cyys_2017@123cyys_2017@123106610101066101015154294180.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2024-11-08 14:00:39 记录内容：'15154294' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2024-11-08 14:00:39 记录内容：2024-11-08 14:00:39 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2024-11-08 14:00:40 记录内容：2024-11-08 14:00:40 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00: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 ('20241108007135','10661010','徐婉莹','一般人员','自费',to_date('2024/11/08 14:00:39','yyyy/mm/dd hh24:mi:ss'),'180','180','XU WAN YING ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00: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/11/8 13:54:57','yyyy/mm/dd hh24:mi:ss'),'8466','10661010','0','','0306','郭庆','20241108007135','202411088376') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00: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/11/08 14:00:39','yyyy/mm/dd hh24:mi:ss'),'8466','20241108007135','1','E','D0903002','纯音听阈测定','/','1','次','0306','30','30','0','1','B','016','900','1.0000','30.0000','1','','0','郭庆','0306','0','纯音听阈测定','10849','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00: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/11/08 14:00:39','yyyy/mm/dd hh24:mi:ss'),'8466','20241108007135','2','E','D0903010','声导抗测听','/','1','次','0306','50','50','0','1','B','016','900','1.0000','50.0000','2','','0','郭庆','0306','0','声导抗测听','10857','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00: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/11/08 14:00:39','yyyy/mm/dd hh24:mi:ss'),'8466','20241108007135','3','D','D0903049','电耳镜检查','/','1','次','0306','10','10','0','1','J','044','150','1.0000','10.0000','3','','0','郭庆','0306','0','电耳镜检查','10897','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00: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/11/08 14:00:40','yyyy/mm/dd hh24:mi:ss'),'8466','20241108007135','4','E','D0908021','电子内镜图文报告','/','1','次','0306','10','10','0','1','J','044','150','1.0000','10.0000','4','','0','郭庆','0306','0','电子内镜图文报告*','11457','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00: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/11/08 14:00:40','yyyy/mm/dd hh24:mi:ss'),'8466','20241108007135','5','D','D0903085','耳纤维内镜检查','/','1','次','0306','80','80','0','1','J','016','150','1.0000','80.0000','5','','0','郭庆','0306','0','耳纤维内镜检查','JC001092','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00:40 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20241108007135','1','微信','180','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00:40 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15154294' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00:40 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15154294' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00:40 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15154294' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00:40 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15154294' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00:40 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15154294' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00:40 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15154294' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00:40 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15154294' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00:40 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15154294' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00:40 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15154294' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00:40 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15154294' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00:40 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15154294' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00:40 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15154294' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00:40 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15154294' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00:40 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15154294' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00:40 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15154294' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00:40 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00:40 记录内容：__________UPDATE exam_appoints SET costs='900',charges='900',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00:40 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10661010' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00:40 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10661010' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00:40 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10661010' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 14:00:40 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10661010') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2024-11-08 14:00:40 记录内容：2024-11-08 14:00:40 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2024-11-08 14:00:40 记录内容：1成功120241108007135 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2024-11-08 14:00:40 记录内容：2024-11-08 14:00:40 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2024-11-08 15:03:56 记录内容：cyys_2017@123cyys_2017@12310045130010045130015154668161.32001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2024-11-08 15:03:56 记录内容：'15154668' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2024-11-08 15:03:56 记录内容：2024-11-08 15:03:56 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2024-11-08 15:03:56 记录内容：2024-11-08 15:03:56 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 15:03:56 记录内容：__________ INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20241108007431','100451300','王毅','一般人员','自费',to_date('2024/11/08 15:03:56','yyyy/mm/dd hh24:mi:ss'),'161.32','161.32','WANG YI ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 15:03:56 记录内容：__________ INSERT INTO drug_presc_master_temp (presc_date,presc_no,dispensary,PATIENT_ID,NAME,NAME_PHONETIC,IDENTITY,CHARGE_TYPE,PRESC_TYPE,PRESC_ATTR,PRESC_SOURCE,REPETITION,COSTS,PAYMENTS,ORDERED_BY,PRESCRIBED_BY,ENTERED_BY,DOCTOR_USER,RCPT_NO,COUNT_PER_REPETITION,CLINIC_NO,IS_SEND,SEND_WIN_NO) VALUES (to_date('2024/11/08 15:03:56','yyyy/mm/dd hh24:mi:ss'),'9171','050101','100451300','王毅','WANG YI ','一般人员','自费','0','门诊处方','0','1','161.32','161.32','0317','WANGJ','王君','WANGJ','20241108007431','3','202411089809','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 15:03:56 记录内容：__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2024-11-08 15:03:56', 'yyyy-mm-dd hh24:mi:ss'),'9171','1','10503073270','1粒*48','复方甲氧那明胶囊(48粒)','长兴制药','1粒*48','盒','1','21.11','21.11','2;粒;口服;3/日','1','1','2','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 15:03:56 记录内容：__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2024-11-08 15:03:56', 'yyyy-mm-dd hh24:mi:ss'),'9171','2','10102034270','0.1g*24','头孢地尼胶囊（0.1g*24）','石家庄四药','0.1g*24','盒','1','12.57','12.57','.2;g;口服;3/日','2','1','0.2','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 15:03:56 记录内容：__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2024-11-08 15:03:56', 'yyyy-mm-dd hh24:mi:ss'),'9171','3','20105022270','0.45g*30','十味龙胆花胶囊','藏药集团','0.45g*30','盒','2','127.64','127.64','1.35;g;口服;3/日','3','1','1.35','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 15:03:56 记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/11/8 14:14:28','yyyy/mm/dd hh24:mi:ss'),'9428','100451300','1','门诊处方','0317','王君','20241108007431','202411089809') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 15:03:56 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/08 15:03:56','yyyy/mm/dd hh24:mi:ss'),'9428','20241108007431','1','A','10503073270','复方甲氧那明胶囊(48粒)','1粒*48长兴制药','1','盒','050101','21.11','21.11','0','1','C','022','300','1.0000','21.1100','1','2;粒;口服;3/日','0','王君','0317','0','复方甲氧那明胶囊(48粒)','10503073270','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 15:03:56 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/08 15:03:56','yyyy/mm/dd hh24:mi:ss'),'9428','20241108007431','2','A','10102034270','头孢地尼胶囊（0.1g*24）','0.1g*24石家庄四药','1','盒','050101','12.57','12.57','0','1','C','022','300','1.0000','12.5700','2','.2;g;口服;3/日','0','王君','0317','0','头孢地尼胶囊（0.1g*24）','10102034270','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 15:03:56 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/08 15:03:56','yyyy/mm/dd hh24:mi:ss'),'9428','20241108007431','3','A','20105022270','十味龙胆花胶囊','0.45g*30藏药集团','2','盒','050101','127.64','127.64','0','1','C','022','300','1.0000','63.8200','3','1.35;g;口服;3/日','0','王君','0317','0','十味龙胆花胶囊','20105022270','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 15:03:56 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20241108007431','1','微信','161.32','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 15:03:56 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15154668' and presc_no = '9171' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 15:03:56 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15154668' and presc_no = '9171' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 15:03:56 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15154668' and presc_no = '9171' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 15:03:56 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15154668' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 15:03:56 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15154668' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 15:03:56 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15154668' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 15:03:56 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100451300' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 15:03:56 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100451300' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 15:03:56 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100451300' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-08 15:03:56 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100451300') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2024-11-08 15:03:56 记录内容：2024-11-08 15:03:56 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2024-11-08 15:03:56 记录内容：1成功120241108007431 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2024-11-08 15:03:56 记录内容：2024-11-08 15:03:56 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆