◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2025-04-16 09:13:28 记录内容:cyys_2017@123cyys_2017@123103445341034453416102267161022781610235916102285542.48001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2025-04-16 09:13:28 记录内容:'16102267','16102278','16102359','16102285' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2025-04-16 09:13:28 记录内容:2025-04-16 09:13:28 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2025-04-16 09:13:29 记录内容:2025-04-16 09:13:29 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________ 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 ('20250416018423','10344534','王华丽','一般人员','自费',to_date('2025/04/16 09:13:28','yyyy/mm/dd hh24:mi:ss'),'542.48','542.48','WANG HUA LI ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________ 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('2025/04/16 09:13:28','yyyy/mm/dd hh24:mi:ss'),'9108','050101','10344534','王华丽','','一般人员','自费','0','门诊处方','0','1','85.48','85.48','0316','LGT01','李广太','LGT01','20250416018423','1','202504166452','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________ 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('2025-04-16 09:13:28', 'yyyy-mm-dd hh24:mi:ss'),'9108','1','11406003391','0.5g','[进]克霉唑阴道片','德国B.S.P','0.5g','片','2','85.48','85.48','.5;g;阴道内置药;1/周','1','1','0.5','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________ 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('2025/4/16 8:29:06','yyyy/mm/dd hh24:mi:ss'),'9455','10344534','1','门诊处方','0316','李广太','20250416018423','202504166452') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________ 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('2025/04/16 09:13:28','yyyy/mm/dd hh24:mi:ss'),'9455','20250416018423','1','A','11406003391','[进]克霉唑阴道片','0.5g德国B.S.P','2','片','050101','85.48','85.48','0','1','J','044','150','1.0000','42.7400','1','.5;g;阴道内置药;1/周','0','李广太','0316','0','[进]克霉唑阴道片','11406003391','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________ 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('2025/4/16 8:29:06','yyyy/mm/dd hh24:mi:ss'),'9456','10344534','0','','0316','李广太','20250416018423','202504166452') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________ 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('2025/04/16 09:13:28','yyyy/mm/dd hh24:mi:ss'),'9456','20250416018423','1','D','D0911066','荧光检查(二合诊检查加收)','/','1','每个部位','0316','3','3','0','1','J','044','150','1.0000','3.0000','1','','0','李广太','0316','0','*荧光检查(二合诊检查)(医保)','JC001094','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________ 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('2025/04/16 09:13:28','yyyy/mm/dd hh24:mi:ss'),'9456','20250416018423','2','D','D0911001','荧光检查','/','1','每个部位','0316','15','15','0','1','J','044','150','1.0000','15.0000','1','','0','李广太','0316','0','*荧光检查(二合诊检查)(医保)','JC001094','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________ 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('2025/04/16 09:13:28','yyyy/mm/dd hh24:mi:ss'),'9456','20250416018423','3','H','F0001022','会阴护理','/','1','次','0316','9','9','0','1','J','044','150','1.0000','9.0000','2','','0','李广太','0316','0','会阴护理','F0001022','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________ 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('2025/4/16 8:29:06','yyyy/mm/dd hh24:mi:ss'),'9457','10344534','0','','0316','李广太','20250416018423','202504166452') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________ 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('2025/04/16 09:13:28','yyyy/mm/dd hh24:mi:ss'),'9457','20250416018423','1','C','H0302218','人乳头瘤病毒(HPV)核酸检测','/','1','项','0435','270','270','0','1','J','044','150','1.0000','270.0000','5','','0','李广太','0316','0','*HPV核酸检测','JY000756','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________ 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('2025/4/16 8:29:06','yyyy/mm/dd hh24:mi:ss'),'9458','10344534','0','','0316','李广太','20250416018423','202504166452') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________ 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('2025/04/16 09:13:28','yyyy/mm/dd hh24:mi:ss'),'9458','20250416018423','1','D','H0807007','液基薄层细胞制片术(Thin Prep)','/','1','次','0412','120','120','0','1','J','015','150','1.0000','120.0000','6','','0','李广太','0316','0','*妇科细胞学检查','21271','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________ 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('2025/04/16 09:13:28','yyyy/mm/dd hh24:mi:ss'),'9458','20250416018423','2','D','H0801014','脱落细胞学检查与诊断','/','1','例','0412','40','40','0','1','J','015','150','1.0000','40.0000','6','','0','李广太','0316','0','*妇科细胞学检查','21271','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250416018423','1','微信','542.48','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16102267' and presc_no = '9108' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16102278' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16102278' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16102278' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16102285' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16102359' and presc_no = '0' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16102359' and presc_no = '0' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16102278' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16102278' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16102278' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16102285' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16102359' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16102359' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16102267' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16102278' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16102278' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16102278' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16102285' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16102359' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16102359' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10344534' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10344534' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10344534' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:13:29 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10344534') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2025-04-16 09:13:29 记录内容:2025-04-16 09:13:29 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2025-04-16 09:13:29 记录内容:1成功120250416018423 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2025-04-16 09:13:29 记录内容:2025-04-16 09:13:29 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2025-04-16 09:45:07 记录内容:cyys_2017@123cyys_2017@1231001676491001676491610303428.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2025-04-16 09:45:07 记录内容:'16103034' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2025-04-16 09:45:07 记录内容:2025-04-16 09:45:07 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2025-04-16 09:45:07 记录内容:2025-04-16 09:45:07 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:45: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 ('20250416018665','100167649','李尚','一般人员','廊坊居民',to_date('2025/04/16 09:45:07','yyyy/mm/dd hh24:mi:ss'),'28','28','LI SHANG ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:45: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('2025/4/16 8:18:57','yyyy/mm/dd hh24:mi:ss'),'520','100167649','0','','0330','郭佳丽','20250416018665','202504167403') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:45: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('2025/04/16 09:45:07','yyyy/mm/dd hh24:mi:ss'),'520','20250416018665','1','D','D1201150','胎心监测','/','1','胎/次','0330','20','20','0','1','J','044','150','1.0000','20.0000','1','','0','郭佳丽','0330','0','胎心监测','JC0022364','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:45: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('2025/04/16 09:45:07','yyyy/mm/dd hh24:mi:ss'),'520','20250416018665','2','D','D1201149','产前常规检查','/','1','次','0330','8','8','0','1','J','044','150','1.0000','8.0000','2','','0','郭佳丽','0330','0','产前常规检查','JC0022363','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:45:08 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250416018665','1','微信','28','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:45:08 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16103034' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:45:08 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16103034' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:45:08 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16103034' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:45:08 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16103034' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:45:08 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16103034' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:45:08 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16103034' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:45:08 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:45:08 记录内容:__________UPDATE exam_appoints SET costs='56',charges='56',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:45:08 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100167649' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:45:08 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100167649' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:45:08 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100167649' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 09:45:08 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100167649') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2025-04-16 09:45:08 记录内容:2025-04-16 09:45:08 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2025-04-16 09:45:08 记录内容:1成功120250416018665 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2025-04-16 09:45:08 记录内容:2025-04-16 09:45:08 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2025-04-16 10:47:45 记录内容:cyys_2017@123cyys_2017@1231004779901004779901610415730.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2025-04-16 10:47:45 记录内容:'16104157' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2025-04-16 10:47:45 记录内容:2025-04-16 10:47:45 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2025-04-16 10:47:45 记录内容:2025-04-16 10:47:45 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:47:45 记录内容:__________ 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 ('20250416019211','100477990','庞学文','一般人员','自费',to_date('2025/04/16 10:47:45','yyyy/mm/dd hh24:mi:ss'),'30','30','PANG XUE WEN ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:47:45 记录内容:__________ 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('2025/4/16 10:19:52','yyyy/mm/dd hh24:mi:ss'),'2482','100477990','0','','0318','范亚云','20250416019211','202504161609') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:47:45 记录内容:__________ 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('2025/04/16 10:47:45','yyyy/mm/dd hh24:mi:ss'),'2482','20250416019211','1','E','D0913014','醋酸白试验','/','1','次','0318','10','10','0','1','B','016','900','1.0000','10.0000','2','','0','范亚云','0318','0','醋酸白试验','11792','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:47:45 记录内容:__________ 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('2025/04/16 10:47:45','yyyy/mm/dd hh24:mi:ss'),'2482','20250416019211','2','E','D0913002','性病检查','/','1','次','0318','20','20','0','1','B','016','900','1.0000','20.0000','3','','0','范亚云','0318','0','性病检查','11778','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:47:45 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250416019211','1','微信','30','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:47:45 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16104157' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:47:45 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16104157' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:47:45 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16104157' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:47:45 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16104157' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:47:45 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16104157' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:47:45 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16104157' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:47:45 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:47:45 记录内容:__________UPDATE exam_appoints SET costs='60',charges='60',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:47:45 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100477990' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:47:45 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100477990' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:47:45 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100477990' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:47:45 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100477990') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2025-04-16 10:47:45 记录内容:2025-04-16 10:47:45 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2025-04-16 10:47:45 记录内容:1成功120250416019211 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2025-04-16 10:47:45 记录内容:2025-04-16 10:47:45 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2025-04-16 10:53:09 记录内容:cyys_2017@123cyys_2017@12310673182106731821610428427.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2025-04-16 10:53:09 记录内容:'16104284' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2025-04-16 10:53:09 记录内容:2025-04-16 10:53:09 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2025-04-16 10:53:09 记录内容:2025-04-16 10:53:09 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:53: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 ('20250416019270','10673182','林妍','一般人员','自费',to_date('2025/04/16 10:53:09','yyyy/mm/dd hh24:mi:ss'),'27','27','LIN ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:53: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('2025/4/16 10:33:48','yyyy/mm/dd hh24:mi:ss'),'2648','10673182','0','','0316','薛利娟','20250416019270','202504162021') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:53: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('2025/04/16 10:53:09','yyyy/mm/dd hh24:mi:ss'),'2648','20250416019270','1','D','D0911001','荧光检查','/','1','每个部位','0316','15','15','0','1','J','044','150','1.0000','15.0000','1','','0','薛利娟','0316','0','*荧光检查(二合诊检查)(医保)','JC001094','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:53: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('2025/04/16 10:53:09','yyyy/mm/dd hh24:mi:ss'),'2648','20250416019270','2','D','D0911066','荧光检查(二合诊检查加收)','/','1','每个部位','0316','3','3','0','1','J','044','150','1.0000','3.0000','1','','0','薛利娟','0316','0','*荧光检查(二合诊检查)(医保)','JC001094','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:53: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('2025/04/16 10:53:09','yyyy/mm/dd hh24:mi:ss'),'2648','20250416019270','3','H','F0001022','会阴护理','/','1','次','0316','9','9','0','1','J','044','150','1.0000','9.0000','2','','0','薛利娟','0316','0','会阴护理','F0001022','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:53:09 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250416019270','1','微信','27','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:53:09 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16104284' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:53:09 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16104284' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:53:09 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16104284' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:53:09 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16104284' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:53:09 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16104284' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:53:09 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16104284' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:53:09 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16104284' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:53:09 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16104284' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:53:09 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16104284' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:53:09 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:53:09 记录内容:__________UPDATE exam_appoints SET costs='54',charges='54',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:53:09 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10673182' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:53:09 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10673182' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:53:09 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10673182' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 10:53:09 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10673182') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2025-04-16 10:53:09 记录内容:2025-04-16 10:53:09 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2025-04-16 10:53:09 记录内容:1成功120250416019270 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2025-04-16 10:53:09 记录内容:2025-04-16 10:53:09 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2025-04-16 11:02:23 记录内容:cyys_2017@123cyys_2017@12310344534103445341610439159.94001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2025-04-16 11:02:23 记录内容:'16104391' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2025-04-16 11:02:23 记录内容:2025-04-16 11:02:23 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2025-04-16 11:02:23 记录内容:2025-04-16 11:02:23 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:02: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 ('20250416000017','10344534','王华丽','一般人员','自费',to_date('2025/04/16 11:02:23','yyyy/mm/dd hh24:mi:ss'),'59.94','59.94','WANG HUA LI ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:02:24 记录内容:__________ 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('2025/04/16 11:02:23','yyyy/mm/dd hh24:mi:ss'),'2805','050101','10344534','王华丽','','一般人员','自费','0','门诊处方','0','1','59.94','59.94','0360','ZW','张巍','ZW','20250416000017','1','202504161751','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:02:24 记录内容:__________ 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('2025-04-16 11:02:23', 'yyyy-mm-dd hh24:mi:ss'),'2805','1','10212039390','50mg*20','盐酸曲唑酮片*','美时化学','50mg*20','盒','1','59.94','59.94','50;mg;口服;1/日','1','1','50','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:02: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('2025/4/16 8:29:06','yyyy/mm/dd hh24:mi:ss'),'2909','10344534','1','门诊处方','0360','张巍','20250416000017','202504167736') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:02: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('2025/04/16 11:02:23','yyyy/mm/dd hh24:mi:ss'),'2909','20250416000017','1','A','10212039390','盐酸曲唑酮片*','50mg*20美时化学','1','盒','050101','59.94','59.94','0','1','J','044','150','1.0000','59.9400','1','50;mg;口服;1/日','0','张巍','0360','0','盐酸曲唑酮片*','10212039390','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:02:24 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250416000017','1','微信','59.94','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:02:24 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16104391' and presc_no = '2805' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:02:24 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16104391' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:02:24 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10344534' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:02:24 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10344534' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:02:24 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10344534' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:02:24 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10344534') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2025-04-16 11:02:24 记录内容:2025-04-16 11:02:24 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2025-04-16 11:02:24 记录内容:1成功120250416000017 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2025-04-16 11:02:24 记录内容:2025-04-16 11:02:24 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2025-04-16 11:05:12 记录内容:cyys_2017@123cyys_2017@12310047799010047799016104442400.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2025-04-16 11:05:12 记录内容:'16104442' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2025-04-16 11:05:13 记录内容:2025-04-16 11:05:13 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2025-04-16 11:05:13 记录内容:2025-04-16 11:05:13 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:05:13 记录内容:__________ 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 ('20250416000087','100477990','庞学文','一般人员','自费',to_date('2025/04/16 11:05:13','yyyy/mm/dd hh24:mi:ss'),'400','400','PANG XUE WEN ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:05:13 记录内容:__________ 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('2025/4/16 10:19:52','yyyy/mm/dd hh24:mi:ss'),'2978','100477990','0','','0318','范亚云','20250416000087','202504161609') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:05:13 记录内容:__________ 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('2025/04/16 11:05:13','yyyy/mm/dd hh24:mi:ss'),'2978','20250416000087','1','E','E0409008','阴茎赘生物电灼术','/','4','次','0318','400','400','0','1','J','044','150','1.0000','100.0000','4','','0','范亚云','0318','0','阴茎赘生物电灼术','11630','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:05:13 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250416000087','1','微信','400','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:05:13 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16104442' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:05:13 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16104442' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:05:13 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16104442' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:05:13 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:05:13 记录内容:__________UPDATE exam_appoints SET costs='460',charges='460',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:05:13 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100477990' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:05:13 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100477990' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:05:13 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100477990' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:05:13 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100477990') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2025-04-16 11:05:13 记录内容:2025-04-16 11:05:13 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2025-04-16 11:05:13 记录内容:1成功120250416000087 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2025-04-16 11:05:13 记录内容:2025-04-16 11:05:13 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2025-04-16 11:07:35 记录内容:cyys_2017@123cyys_2017@12310673182106731821610450616104508161045121610456016104562304.51001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2025-04-16 11:07:35 记录内容:'16104506','16104508','16104512','16104560','16104562' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2025-04-16 11:07:35 记录内容:2025-04-16 11:07:35 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2025-04-16 11:07:36 记录内容:2025-04-16 11:07:36 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________ 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 ('20250416000098','10673182','林妍','一般人员','自费',to_date('2025/04/16 11:07:35','yyyy/mm/dd hh24:mi:ss'),'304.51','304.51','LIN ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________ 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('2025/4/16 10:33:48','yyyy/mm/dd hh24:mi:ss'),'3046','10673182','0','','0316','薛利娟','20250416000098','202504162021') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________ 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('2025/04/16 11:07:35','yyyy/mm/dd hh24:mi:ss'),'3046','20250416000098','1','C','H0201028','血细胞分析(五分类收)','/','1','项','0411','11','11','0','1','J','044','150','1.0000','11.0000','3','','0','薛利娟','0316','0','*血常规','21313','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________ 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('2025/4/16 10:33:48','yyyy/mm/dd hh24:mi:ss'),'3047','10673182','0','','0316','薛利娟','20250416000098','202504162021') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________ 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('2025/04/16 11:07:35','yyyy/mm/dd hh24:mi:ss'),'3047','20250416000098','1','C','H0102046','血浆凝血酶原时间测定(PT)仪器法','/','1','项','0411','20','20','0','1','M','025','190','1.0000','20.0000','4','','0','薛利娟','0316','0','*凝血四项','21336','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________ 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('2025/04/16 11:07:35','yyyy/mm/dd hh24:mi:ss'),'3047','20250416000098','2','C','H0102061','活化部分凝血活酶时间测定(APTT)仪器法','/','1','项','0411','20','20','0','1','M','025','190','1.0000','20.0000','4','','0','薛利娟','0316','0','*凝血四项','21336','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________ 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('2025/04/16 11:07:36','yyyy/mm/dd hh24:mi:ss'),'3047','20250416000098','3','C','H0102072','血浆纤维蛋白原测定(仪器法)','/','1','项','0411','20','20','0','1','M','025','190','1.0000','20.0000','4','','0','薛利娟','0316','0','*凝血四项','21336','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________ 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('2025/04/16 11:07:36','yyyy/mm/dd hh24:mi:ss'),'3047','20250416000098','4','C','H0102105','凝血酶时间测定(TT)仪器法','/','1','项','0411','20','20','0','1','M','025','190','1.0000','20.0000','4','','0','薛利娟','0316','0','*凝血四项','21336','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________ 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('2025/4/16 10:33:48','yyyy/mm/dd hh24:mi:ss'),'3048','10673182','0','','0316','薛利娟','20250416000098','202504162021') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________ 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('2025/04/16 11:07:36','yyyy/mm/dd hh24:mi:ss'),'3048','20250416000098','1','C','H0302017','乙型肝炎表面抗原测定(HBsAg)','/','1','项','0411','5','5','0','1','M','025','190','1.0000','5.0000','5','','0','薛利娟','0316','0','*感染四项(定量)','JY000105','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________ 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('2025/04/16 11:07:36','yyyy/mm/dd hh24:mi:ss'),'3048','20250416000098','2','C','H0302200','感染免疫学检测(化学发光法定量加收)','/','1','项','0411','15','15','0','1','J','044','150','1.0000','15.0000','5','','0','薛利娟','0316','0','*感染四项(定量)','JY000105','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________ 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('2025/04/16 11:07:36','yyyy/mm/dd hh24:mi:ss'),'3048','20250416000098','3','C','H0302051','丙型肝炎抗体测定(Anti-HCV)','/','1','项','0411','25','25','0','1','M','025','190','1.0000','25.0000','5','','0','薛利娟','0316','0','*感染四项(定量)','JY000105','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________ 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('2025/04/16 11:07:36','yyyy/mm/dd hh24:mi:ss'),'3048','20250416000098','4','C','H0302223','丙型肝炎抗体测定(Anti–HCV:化学发光法加收)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','5','','0','薛利娟','0316','0','*感染四项(定量)','JY000105','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________ 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('2025/04/16 11:07:36','yyyy/mm/dd hh24:mi:ss'),'3048','20250416000098','5','C','H0302210','梅毒螺旋体特异抗体测定(化学发光法)','/','1','项','0411','50','50','0','1','M','025','190','1.0000','50.0000','5','','0','薛利娟','0316','0','*感染四项(定量)','JY000105','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________ 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('2025/04/16 11:07:36','yyyy/mm/dd hh24:mi:ss'),'3048','20250416000098','6','C','H0302073','人免疫缺陷病毒抗体测定(Anti-HIV:化学发光法)','/','1','项','0411','50','50','0','1','M','025','190','1.0000','50.0000','5','','0','薛利娟','0316','0','*感染四项(定量)','JY000105','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________ 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('2025/4/16 10:33:48','yyyy/mm/dd hh24:mi:ss'),'3049','10673182','0','','0316','薛利娟','20250416000098','202504162021') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________ 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('2025/04/16 11:07:36','yyyy/mm/dd hh24:mi:ss'),'3049','20250416000098','1','E','E0003052','静脉采血','/','1','次','0316','7','7','0','1','B','016','900','1.0000','7.0000','6','','0','薛利娟','0316','0','*采血套餐三','15643','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________ 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('2025/04/16 11:07:36','yyyy/mm/dd hh24:mi:ss'),'3049','20250416000098','2','E','I0015681','一次性使用静脉血样采集针','J-7软连接式0.7/威高','1','支','0316','0.25','0.25','0','1','J','044','150','1.0000','0.2500','6','','0','薛利娟','0316','0','*采血套餐三','15643','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________ 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('2025/04/16 11:07:36','yyyy/mm/dd hh24:mi:ss'),'3049','20250416000098','3','E','I0015765','一次性使用人体静脉血样采集容器','EDTA-K2 2ml/威海威高','3','支','0316','1.26','1.26','0','1','J','044','150','1.0000','0.4200','6','','0','薛利娟','0316','0','*采血套餐三','15643','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________ 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('2025/4/16 10:33:48','yyyy/mm/dd hh24:mi:ss'),'3050','10673182','0','','0316','薛利娟','20250416000098','202504162021') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________ 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('2025/04/16 11:07:36','yyyy/mm/dd hh24:mi:ss'),'3050','20250416000098','1','D','D0906001','常规心电图检查','/','1','次','020310','10','10','0','1','J','007','150','1.0000','10.0000','7','','0','薛利娟','0316','0','*常规心电图检查','21262','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________ 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('2025/04/16 11:07:36','yyyy/mm/dd hh24:mi:ss'),'3050','20250416000098','2','D','D0906045','常规心电图检查(十二通道加收)','/','1','次','020310','10','10','0','1','H','007','150','1.0000','10.0000','7','','0','薛利娟','0316','0','*常规心电图检查','21262','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250416000098','1','微信','304.51','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16104506' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16104508' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16104508' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16104508' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16104508' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16104512' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16104512' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16104512' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16104512' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16104512' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16104512' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16104560' and presc_no = '0' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16104560' and presc_no = '0' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16104560' and presc_no = '0' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16104562' and presc_no = '0' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16104562' and presc_no = '0' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16104506' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16104508' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16104508' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16104508' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16104508' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16104512' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16104512' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16104512' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16104512' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16104512' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16104512' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16104560' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16104560' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16104560' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16104562' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16104562' and item_no = '7' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16104506' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16104508' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16104508' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16104508' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16104508' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16104512' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16104512' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16104512' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16104512' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16104512' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16104512' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16104560' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16104560' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16104560' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16104562' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16104562' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2504167376' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5444376' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2504167370' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2504167368' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE exam_appoints SET costs='62.51',charges='62.51',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE exam_appoints SET costs='185',charges='185',BILLING_INDICATOR='1' WHERE EXAM_NO = '2504167376' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE exam_appoints SET costs='20',charges='20',BILLING_INDICATOR='1' WHERE EXAM_NO = '5444376' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE exam_appoints SET costs='80',charges='80',BILLING_INDICATOR='1' WHERE EXAM_NO = '2504167370' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE exam_appoints SET costs='11',charges='11',BILLING_INDICATOR='1' WHERE EXAM_NO = '2504167368' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10673182' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10673182' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10673182' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 11:07:38 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10673182') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2025-04-16 11:07:38 记录内容:2025-04-16 11:07:38 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2025-04-16 11:07:38 记录内容:1成功120250416000098 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2025-04-16 11:07:38 记录内容:2025-04-16 11:07:38 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2025-04-16 14:42:16 记录内容:cyys_2017@123cyys_2017@1231067318210673182161059431610593916105946630.90001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2025-04-16 14:42:16 记录内容:'16105943','16105939','16105946' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2025-04-16 14:42:16 记录内容:2025-04-16 14:42:16 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2025-04-16 14:42:16 记录内容:2025-04-16 14:42:16 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________ 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 ('20250416001102','10673182','林妍','一般人员','自费',to_date('2025/04/16 14:42:16','yyyy/mm/dd hh24:mi:ss'),'630.9','630.9','LIN ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________ 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('2025/04/16 14:42:16','yyyy/mm/dd hh24:mi:ss'),'5656','050101','10673182','林妍','','一般人员','自费','0','门诊处方','0','1','6.90','6.90','0316','XUELJ','薛利娟','XUELJ','20250416001102','1','202504162021','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________ 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('2025-04-16 14:42:16', 'yyyy-mm-dd hh24:mi:ss'),'5656','1','10102084270','0.25g*12','头孢克洛胶囊(0.25g*12)*','苏州中化','0.25g*12','盒','1','6.9','6.9','.25;g;口服;3/日','1','1','0.25','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________ 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('2025/4/16 10:33:48','yyyy/mm/dd hh24:mi:ss'),'5736','10673182','0','','0316','薛利娟','20250416001102','202504162021') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________ 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('2025/04/16 14:42:16','yyyy/mm/dd hh24:mi:ss'),'5736','20250416001102','1','F','G1302001','宫颈息肉切除术','/','1','次','0316','74','74','0','1','J','044','150','1.0000','74.0000','8','','0','薛利娟','0316','0','宫颈息肉切除术','14377','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________ 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('2025/04/16 14:42:16','yyyy/mm/dd hh24:mi:ss'),'5736','20250416001102','2','F','G0000019','术中使用微波刀','/','1','次','0316','300','300','0','1','C','022','300','1.0000','300.0000','9','','0','薛利娟','0316','0','术中使用微波刀','12180','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________ 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('2025/04/16 14:42:16','yyyy/mm/dd hh24:mi:ss'),'5736','20250416001102','3','E','D0911010','宫颈内口探查术','/','2','次','0316','30','30','0','1','B','016','900','1.0000','15.0000','10','','0','薛利娟','0316','0','宫颈内口探查术','11665','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________ 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('2025/04/16 14:42:16','yyyy/mm/dd hh24:mi:ss'),'5736','20250416001102','4','E','D0911008','阴道填塞','/','1','次','0316','20','20','0','1','B','016','900','1.0000','20.0000','11','','0','薛利娟','0316','0','阴道填塞','11655','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________ 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('2025/4/16 10:33:48','yyyy/mm/dd hh24:mi:ss'),'5737','10673182','1','门诊处方','0316','薛利娟','20250416001102','202504162021') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________ 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('2025/04/16 14:42:16','yyyy/mm/dd hh24:mi:ss'),'5737','20250416001102','1','A','10102084270','头孢克洛胶囊(0.25g*12)*','0.25g*12苏州中化','1','盒','050101','6.9','6.9','0','1','J','044','150','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语句 记录时间:2025-04-16 14:42:19 记录内容:__________ 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('2025/4/16 10:33:48','yyyy/mm/dd hh24:mi:ss'),'5738','10673182','0','','0316','薛利娟','20250416001102','202504162021') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________ 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('2025/04/16 14:42:16','yyyy/mm/dd hh24:mi:ss'),'5738','20250416001102','1','D','H0802007','局部切除组织活检检查与诊断','/','1','每个部位','0412','180','180','0','1','J','015','150','1.0000','180.0000','12','','0','薛利娟','0316','0','*小标本活检','10513','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________ 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('2025/04/16 14:42:16','yyyy/mm/dd hh24:mi:ss'),'5738','20250416001102','2','D','H0807010','显微摄影术','/','1','每个视野','0412','20','20','0','1','J','015','150','1.0000','20.0000','12','','0','薛利娟','0316','0','*小标本活检','10513','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250416001102','1','微信','630.9','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16105939' and presc_no = '0' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16105939' and presc_no = '0' and item_no = '9' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16105939' and presc_no = '0' and item_no = '10' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16105939' and presc_no = '0' and item_no = '11' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16105943' and presc_no = '5656' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16105946' and presc_no = '0' and item_no = '12' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16105946' and presc_no = '0' and item_no = '12' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16105939' and item_no = '8' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16105939' and item_no = '9' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16105939' and item_no = '10' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16105939' and item_no = '11' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16105946' and item_no = '12' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16105946' and item_no = '12' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16105939' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16105939' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16105939' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16105939' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16105943' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16105946' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16105946' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2504167376' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5444376' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5444735' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2504167370' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2504167368' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE exam_appoints SET costs='1758.51',charges='1758.51',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE exam_appoints SET costs='185',charges='185',BILLING_INDICATOR='1' WHERE EXAM_NO = '2504167376' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE exam_appoints SET costs='20',charges='20',BILLING_INDICATOR='1' WHERE EXAM_NO = '5444376' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE exam_appoints SET costs='200',charges='200',BILLING_INDICATOR='1' WHERE EXAM_NO = '5444735' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE exam_appoints SET costs='80',charges='80',BILLING_INDICATOR='1' WHERE EXAM_NO = '2504167370' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE exam_appoints SET costs='11',charges='11',BILLING_INDICATOR='1' WHERE EXAM_NO = '2504167368' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10673182' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10673182' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10673182' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:42:19 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10673182') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2025-04-16 14:42:19 记录内容:2025-04-16 14:42:19 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2025-04-16 14:42:19 记录内容:1成功120250416001102 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2025-04-16 14:42:19 记录内容:2025-04-16 14:42:19 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2025-04-16 14:43:29 记录内容:cyys_2017@123cyys_2017@1231004527481004527481610599657.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2025-04-16 14:43:29 记录内容:'16105996' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2025-04-16 14:43:29 记录内容:2025-04-16 14:43:29 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2025-04-16 14:43:29 记录内容:2025-04-16 14:43:29 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:43:30 记录内容:__________ INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20250416001103','100452748','冯乐一','一般人员','自费',to_date('2025/04/16 14:43:29','yyyy/mm/dd hh24:mi:ss'),'57','57','FENG LE YI ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:43:30 记录内容:__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/4/16 14:33:07','yyyy/mm/dd hh24:mi:ss'),'5760','100452748','0','','0304','刘婕','20250416001103','202504165576') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:43:30 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/04/16 14:43:29','yyyy/mm/dd hh24:mi:ss'),'5760','20250416001103','1','C','H0300087','C—反应蛋白测定(CRP)全血快速定量加收','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','刘婕','0304','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:43:30 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/04/16 14:43:29','yyyy/mm/dd hh24:mi:ss'),'5760','20250416001103','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语句 记录时间:2025-04-16 14:43:30 记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/04/16 14:43:29','yyyy/mm/dd hh24:mi:ss'),'5760','20250416001103','3','C','H0201028','血细胞分析(五分类收)','/','1','项','0411','11','11','0','1','J','044','150','1.0000','11.0000','1','','0','刘婕','0304','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:43:30 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250416001103','1','微信','57','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:43:30 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16105996' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:43:30 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16105996' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:43:30 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16105996' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:43:30 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16105996' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:43:30 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16105996' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:43:30 记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '16105996' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:43:30 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16105996' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:43:30 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16105996' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:43:30 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16105996' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:43:30 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2504167948' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:43:30 记录内容:__________UPDATE exam_appoints SET costs='57',charges='57',BILLING_INDICATOR='1' WHERE EXAM_NO = '2504167948' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:43:30 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100452748' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:43:30 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100452748' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:43:30 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100452748' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 14:43:30 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100452748') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2025-04-16 14:43:30 记录内容:2025-04-16 14:43:30 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2025-04-16 14:43:30 记录内容:1成功120250416001103 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2025-04-16 14:43:30 记录内容:2025-04-16 14:43:30 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:参数 记录时间:2025-04-16 15:28:17 记录内容:cyys_2017@123cyys_2017@1231004527481004527481610634616106348181.54001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:处方号为: 记录时间:2025-04-16 15:28:17 记录内容:'16106346','16106348' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询 记录时间:2025-04-16 15:28:17 记录内容:2025-04-16 15:28:17 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行查询并操作 记录时间:2025-04-16 15:28:17 记录内容:2025-04-16 15:28:17 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________ 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 ('20250416001374','100452748','冯乐一','一般人员','自费',to_date('2025/04/16 15:28:17','yyyy/mm/dd hh24:mi:ss'),'181.54','181.54','FENG LE YI ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________ 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('2025/04/16 15:28:17','yyyy/mm/dd hh24:mi:ss'),'6440','050101','100452748','冯乐一','FENG LE YI ','一般人员','自费','0','门诊处方','0','1','37.60','37.60','0304','LIUJ','刘婕','LIUJ','20250416001374','1','202504165576','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________ 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('2025/04/16 15:28:17','yyyy/mm/dd hh24:mi:ss'),'6448','050101','100452748','冯乐一','FENG LE YI ','一般人员','自费','0','门诊处方','0','1','143.94','143.94','0304','LIUJ','刘婕','LIUJ','20250416001374','2','202504165576','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________ 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('2025-04-16 15:28:17', 'yyyy-mm-dd hh24:mi:ss'),'6440','1','10108022190','0.15g*6','环酯红霉素干混悬剂','海南澳美','0.15g*6','盒','1','37.6','37.6','.15;g;口服;2/日','1','1','0.15','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________ 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('2025-04-16 15:28:17', 'yyyy-mm-dd hh24:mi:ss'),'6448','1','10203088430','60ml','氨咖愈敏溶液','杭州娃哈哈','60ml','瓶','1','68.24','68.24','2.5;ml;口服;3/日','2','1','2.5','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________ 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('2025-04-16 15:28:17', 'yyyy-mm-dd hh24:mi:ss'),'6448','2','20119003291','2g(无蔗糖)*9','小儿豉翘清热颗粒','济川药业','2g(无蔗糖)*9','盒','1','75.7','75.7','1;g;口服;3/日','3','1','1','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________ 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('2025/4/16 14:33:07','yyyy/mm/dd hh24:mi:ss'),'6608','100452748','1','门诊处方','0304','刘婕','20250416001374','202504165576') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________ 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('2025/04/16 15:28:17','yyyy/mm/dd hh24:mi:ss'),'6608','20250416001374','1','A','10108022190','环酯红霉素干混悬剂','0.15g*6海南澳美','1','盒','050101','37.6','37.6','0','1','J','044','150','1.0000','37.6000','1','.15;g;口服;2/日','0','刘婕','0304','0','环酯红霉素干混悬剂','10108022190','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________ 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('2025/4/16 14:33:07','yyyy/mm/dd hh24:mi:ss'),'6609','100452748','1','门诊处方','0304','刘婕','20250416001374','202504165576') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________ 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('2025/04/16 15:28:17','yyyy/mm/dd hh24:mi:ss'),'6609','20250416001374','1','A','10203088430','氨咖愈敏溶液','60ml杭州娃哈哈','1','瓶','050101','68.24','68.24','0','1','J','044','150','1.0000','68.2400','1','2.5;ml;口服;3/日','0','刘婕','0304','0','氨咖愈敏溶液','10203088430','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________ 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('2025/04/16 15:28:17','yyyy/mm/dd hh24:mi:ss'),'6609','20250416001374','2','A','20119003291','小儿豉翘清热颗粒','2g(无蔗糖)*9济川药业','1','盒','050101','75.7','75.7','0','1','D','033','600','1.0000','75.7000','2','1;g;口服;3/日','0','刘婕','0304','0','小儿豉翘清热颗粒','20119003291','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250416001374','1','微信','181.54','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16106346' and presc_no = '6440' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16106348' and presc_no = '6448' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '16106348' and presc_no = '6448' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16106346' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16106348' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '16106348' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2504167948' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________UPDATE exam_appoints SET costs='57',charges='57',BILLING_INDICATOR='1' WHERE EXAM_NO = '2504167948' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100452748' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100452748' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100452748' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:SQL语句 记录时间:2025-04-16 15:28:17 记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100452748') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:执行写入 记录时间:2025-04-16 15:28:17 记录内容:2025-04-16 15:28:17 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:返回数据 记录时间:2025-04-16 15:28:17 记录内容:1成功120250416001374 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:跳出方法 记录时间:2025-04-16 15:28:17 记录内容:2025-04-16 15:28:17 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆