◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2025-02-28 09:10:26
记录内容:cyys_2017@123cyys_2017@123Z00388326Z0038832615817810158178121581781915817821158178221581782515817850201.35001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2025-02-28 09:10:26
记录内容:'15817810','15817812','15817819','15817821','15817822','15817825','15817850'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2025-02-28 09:10:26
记录内容:2025-02-28 09:10:26
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2025-02-28 09:10:27
记录内容:2025-02-28 09:10:27
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________ 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 ('20250228004744','Z00388326','孙新丽','一般人员','自费',to_date('2025/02/28 09:10:26','yyyy/mm/dd hh24:mi:ss'),'201.35','201.35','SUN XIN LI ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________ 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/2/28 8:46:57','yyyy/mm/dd hh24:mi:ss'),'2491','Z00388326','0','','0337','彭艳艳','20250228004744','202502281753')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________ 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/02/28 09:10:26','yyyy/mm/dd hh24:mi:ss'),'2491','20250228004744','1','C','H0206004','尿素测定(酶促动力学法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','1','','0','彭艳艳','0337','0','*肾功4项','JY001224','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________ 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/02/28 09:10:26','yyyy/mm/dd hh24:mi:ss'),'2491','20250228004744','2','C','H0206007','肌酐测定(酶促动力学法)','/','1','项','0411','6','6','0','1','M','025','190','1.0000','6.0000','1','','0','彭艳艳','0337','0','*肾功4项','JY001224','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________ 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/02/28 09:10:26','yyyy/mm/dd hh24:mi:ss'),'2491','20250228004744','3','C','H0206012','血清尿酸测定','/','1','项','0411','5','5','0','1','M','025','190','1.0000','5.0000','1','','0','彭艳艳','0337','0','*肾功4项','JY001224','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________ 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/02/28 09:10:26','yyyy/mm/dd hh24:mi:ss'),'2491','20250228004744','4','C','H0206045','血清胱抑素(Cystatin C) 测定','/','1','项','0411','50','50','0','1','M','025','190','1.0000','50.0000','1','','0','彭艳艳','0337','0','*肾功4项','JY001224','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________ 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/2/28 8:46:57','yyyy/mm/dd hh24:mi:ss'),'2492','Z00388326','0','','0337','彭艳艳','20250228004744','202502281753')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________ 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/02/28 09:10:26','yyyy/mm/dd hh24:mi:ss'),'2492','20250228004744','1','C','H0201028','血细胞分析(五分类收)','/','1','项','0411','11','11','0','1','J','044','150','1.0000','11.0000','2','','0','彭艳艳','0337','0','*血常规','21313','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________ 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/2/28 8:46:57','yyyy/mm/dd hh24:mi:ss'),'2493','Z00388326','0','','0337','彭艳艳','20250228004744','202502281753')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________ 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/02/28 09:10:26','yyyy/mm/dd hh24:mi:ss'),'2493','20250228004744','1','C','H0001049','尿液分析','/','1','次','0411','6','6','0','1','J','044','150','1.0000','6.0000','3','','0','彭艳艳','0337','0','尿常规+尿沉渣镜检(急)','JY001536','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________ 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/02/28 09:10:26','yyyy/mm/dd hh24:mi:ss'),'2493','20250228004744','2','C','H0001033','尿沉渣镜检','/','1','项','0411','3','3','0','1','M','025','190','1.0000','3.0000','3','','0','彭艳艳','0337','0','尿常规+尿沉渣镜检(急)','JY001536','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________ 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/2/28 8:46:57','yyyy/mm/dd hh24:mi:ss'),'2494','Z00388326','0','','0337','彭艳艳','20250228004744','202502281753')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________ 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/02/28 09:10:26','yyyy/mm/dd hh24:mi:ss'),'2494','20250228004744','1','C','H0301130','类风湿因子(RF)测定(速率散射法)','/','1','项','0411','40','40','0','1','M','025','190','1.0000','40.0000','4','','0','彭艳艳','0337','0','*类风湿因子测定','21359','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________ 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/2/28 8:46:57','yyyy/mm/dd hh24:mi:ss'),'2495','Z00388326','0','','0337','彭艳艳','20250228004744','202502281753')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________ 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/02/28 09:10:26','yyyy/mm/dd hh24:mi:ss'),'2495','20250228004744','1','C','H0700090','抗环瓜氨酸肽抗体(抗CCP抗体)测定','/','1','项','0435','60','60','0','1','M','025','190','1.0000','60.0000','5','','0','彭艳艳','0337','0','抗环瓜氨酸肽抗体(抗CCP抗体)测定','JY001607','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________ 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/2/28 8:46:57','yyyy/mm/dd hh24:mi:ss'),'2496','Z00388326','0','','0337','彭艳艳','20250228004744','202502281753')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________ 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/02/28 09:10:26','yyyy/mm/dd hh24:mi:ss'),'2496','20250228004744','1','C','H0000016','红细胞沉降率测定(ESR)仪器法','/','1','项','0411','5','5','0','1','M','025','190','1.0000','5.0000','6','','0','彭艳艳','0337','0','*血沉','21335','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________ 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/2/28 8:46:57','yyyy/mm/dd hh24:mi:ss'),'2497','Z00388326','0','','0337','彭艳艳','20250228004744','202502281753')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________ 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/02/28 09:10:26','yyyy/mm/dd hh24:mi:ss'),'2497','20250228004744','1','E','E0003052','静脉采血','/','1','次','0329','7','7','0','1','B','016','900','1.0000','7.0000','7','','0','彭艳艳','0337','0','*采血套餐五','15645','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________ 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/02/28 09:10:26','yyyy/mm/dd hh24:mi:ss'),'2497','20250228004744','2','E','I0015681','一次性使用静脉血样采集针','J-7软连接式0.7/威高','1','支','0337','0.25','0.25','0','1','J','044','150','1.0000','0.2500','7','','0','彭艳艳','0337','0','*采血套餐五','15645','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________ 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/02/28 09:10:26','yyyy/mm/dd hh24:mi:ss'),'2497','20250228004744','3','E','I0015765','一次性使用人体静脉血样采集容器','EDTA-K2 2ml/威海威高','5','支','0337','2.1','2.1','0','1','J','044','150','1.0000','0.4200','7','','0','彭艳艳','0337','0','*采血套餐五','15645','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250228004744','1','微信','201.35','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15817810' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15817810' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15817810' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15817810' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15817812' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15817819' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15817819' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15817821' and presc_no = '0' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15817822' and presc_no = '0' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15817825' and presc_no = '0' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15817850' and presc_no = '0' and item_no = '7'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15817850' and presc_no = '0' and item_no = '7'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15817850' and presc_no = '0' and item_no = '7'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15817810' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15817810' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15817810' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15817810' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15817812' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15817819' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15817819' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15817821' and item_no = '4'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15817822' and item_no = '5'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15817825' and item_no = '6'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15817850' and item_no = '7'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15817850' and item_no = '7'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15817850' and item_no = '7'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15817810'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15817810'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15817810'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15817810'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15817812'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15817819'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15817819'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15817821'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15817822'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15817825'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15817850'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15817850'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15817850'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'Z00388326'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = 'Z00388326' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'Z00388326'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:10:27
记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = 'Z00388326')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2025-02-28 09:10:27
记录内容:2025-02-28 09:10:27
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2025-02-28 09:10:27
记录内容:1成功120250228004744
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2025-02-28 09:10:27
记录内容:2025-02-28 09:10:27
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2025-02-28 09:36:06
记录内容:cyys_2017@123cyys_2017@12300351996003519961581818859.11001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2025-02-28 09:36:06
记录内容:'15818188'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2025-02-28 09:36:06
记录内容:2025-02-28 09:36:06
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2025-02-28 09:36:07
记录内容:2025-02-28 09:36:07
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:36:07
记录内容:__________ 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 ('20250228004892','00351996','杨素然','一般人员','自费',to_date('2025/02/28 09:36:06','yyyy/mm/dd hh24:mi:ss'),'59.11','59.11','YANG SU RAN ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:36:07
记录内容:__________ 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/02/28 09:36:06','yyyy/mm/dd hh24:mi:ss'),'3125','050101','00351996','杨素然','YANG SU RAN','一般人员','自费','0','门诊处方','0','1','59.11','59.11','0312','LIUXC','刘兴超','LIUXC','20250228004892','1','202502284159','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:36:07
记录内容:__________ 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-02-28 09:36:06', 'yyyy-mm-dd hh24:mi:ss'),'3125','1','20116064720','1片(10cm*14cm)*10','神农镇痛膏','湛江吉民','1片(10cm*14cm)*10','盒','1','59.11','59.11','1;片;外用;1/日','1','1','1','','','','','','0','0','','','','0.0000','','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:36:07
记录内容:__________ 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/2/24 21:48:43','yyyy/mm/dd hh24:mi:ss'),'3322','00351996','1','门诊处方','0312','刘兴超','20250228004892','202502244159')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:36:07
记录内容:__________ 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/02/28 09:36:07','yyyy/mm/dd hh24:mi:ss'),'3322','20250228004892','1','A','20116064720','神农镇痛膏','1片(10cm*14cm)*10湛江吉民','1','盒','050101','59.11','59.11','0','1','J','044','150','1.0000','59.1100','1','1;片;外用;1/日','0','刘兴超','0312','0','神农镇痛膏','20116064720','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:36:07
记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250228004892','1','微信','59.11','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:36:07
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15818188' and presc_no = '3125' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:36:07
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15818188'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:36:07
记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00351996'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:36:07
记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '00351996' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:36:07
记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00351996'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:36:07
记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '00351996')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2025-02-28 09:36:07
记录内容:2025-02-28 09:36:07
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2025-02-28 09:36:07
记录内容:1成功120250228004892
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2025-02-28 09:36:07
记录内容:2025-02-28 09:36:07
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:参数
记录时间:2025-02-28 09:47:59
记录内容:cyys_2017@123cyys_2017@12310715119107151191581845115818467192.00001
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:处方号为:
记录时间:2025-02-28 09:47:59
记录内容:'15818451','15818467'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询
记录时间:2025-02-28 09:47:59
记录内容:2025-02-28 09:47:59
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行查询并操作
记录时间:2025-02-28 09:47:59
记录内容:2025-02-28 09:47:59
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________ INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20250228005010','10715119','何培臣','一般人员','自费',to_date('2025/02/28 09:47:59','yyyy/mm/dd hh24:mi:ss'),'192','192','HE PEI CHEN ','0','0','9328')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/2/28 9:09:04','yyyy/mm/dd hh24:mi:ss'),'3624','10715119','0','','0304','李海鹰','20250228005010','202502282457')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/02/28 09:47:59','yyyy/mm/dd hh24:mi:ss'),'3624','20250228005010','1','E','E0101004','婴幼儿健康体检','/','1','次','0304','31','31','0','1','B','016','900','1.0000','31.0000','1','','0','李海鹰','0304','0','*婴幼儿健康体检','E0101002','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/02/28 09:47:59','yyyy/mm/dd hh24:mi:ss'),'3624','20250228005010','2','D','D0701098','骨密度测定(超声)','/','1','次','0304','150','150','0','1','J','016','150','1.0000','150.0000','2','','0','李海鹰','0304','0','超声骨密度测量(儿科)','JC000974','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2025/2/28 9:09:04','yyyy/mm/dd hh24:mi:ss'),'3625','10715119','0','','0304','李海鹰','20250228005010','202502282457')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2025/02/28 09:47:59','yyyy/mm/dd hh24:mi:ss'),'3625','20250228005010','1','C','H0201028','血细胞分析(五分类收)','/','1','项','0411','11','11','0','1','J','044','150','1.0000','11.0000','3','','0','李海鹰','0304','0','*血常规(急)','JY000061','0.0000','0.0000','0.0000','0.0000','0','')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20250228005010','1','微信','192','0.00')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15818451' and presc_no = '0' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15818451' and presc_no = '0' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15818467' and presc_no = '0' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15818451' and item_no = '1'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15818451' and item_no = '2'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15818467' and item_no = '3'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15818451'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15818451'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15818467'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2502288891'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________UPDATE exam_appoints SET costs='362',charges='362',BILLING_INDICATOR='1' WHERE EXAM_NO = ''
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________UPDATE exam_appoints SET costs='11',charges='11',BILLING_INDICATOR='1' WHERE EXAM_NO = '2502288891'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10715119'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10715119' )
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10715119'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:SQL语句
记录时间:2025-02-28 09:47:59
记录内容:__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10715119')
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:执行写入
记录时间:2025-02-28 09:47:59
记录内容:2025-02-28 09:47:59
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:返回数据
记录时间:2025-02-28 09:47:59
记录内容:1成功120250228005010
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:跳出方法
记录时间:2025-02-28 09:47:59
记录内容:2025-02-28 09:47:59
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆