◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2024-11-21 08:09:18 记录内容：cyys_2017@123cyys_2017@1231004531591004531591522985190.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2024-11-21 08:09:18 记录内容：'15229851' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2024-11-21 08:09:18 记录内容：2024-11-21 08:09:18 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2024-11-21 08:09:18 记录内容：2024-11-21 08:09:18 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:18 记录内容：__________ 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 ('20241121008924','100453159','周明惠','一般人员','自费',to_date('2024/11/21 08:09:18','yyyy/mm/dd hh24:mi:ss'),'90','90','ZHOU MING HUI ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:18 记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/11/21 8:05:05','yyyy/mm/dd hh24:mi:ss'),'1895','100453159','0','','0371','梁静一','20241121008924','202411211797') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:18 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 08:09:18','yyyy/mm/dd hh24:mi:ss'),'1895','20241121008924','1','D','D1201121','腔内彩色多普勒超声检查','/','1','次','0371','90','90','0','1','J','006','150','1.0000','90.0000','1','','0','梁静一','0371','0','*生殖卵泡监测','JC000924','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:18 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20241121008924','1','微信','90','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:18 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15229851' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:18 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15229851' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:18 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15229851' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:18 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:18 记录内容：__________UPDATE exam_appoints SET costs='90',charges='90',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:18 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100453159' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:18 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100453159' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:18 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100453159' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:18 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100453159') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2024-11-21 08:09:18 记录内容：2024-11-21 08:09:18 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2024-11-21 08:09:18 记录内容：1成功120241121008924 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2024-11-21 08:09:18 记录内容：2024-11-21 08:09:18 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2024-11-21 08:09:31 记录内容：cyys_2017@123cyys_2017@1231067110710671107152298441522984015229847150.59001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2024-11-21 08:09:31 记录内容：'15229844','15229840','15229847' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2024-11-21 08:09:31 记录内容：2024-11-21 08:09:31 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2024-11-21 08:09:31 记录内容：2024-11-21 08:09:31 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________ 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 ('20241121008925','10671107','贾凯涵','一般人员','自费',to_date('2024/11/21 08:09:31','yyyy/mm/dd hh24:mi:ss'),'150.59','150.59','JIA KAI HAN ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________ INSERT INTO drug_presc_master_temp (presc_date,presc_no,dispensary,PATIENT_ID,NAME,NAME_PHONETIC,IDENTITY,CHARGE_TYPE,PRESC_TYPE,PRESC_ATTR,PRESC_SOURCE,REPETITION,COSTS,PAYMENTS,ORDERED_BY,PRESCRIBED_BY,ENTERED_BY,DOCTOR_USER,RCPT_NO,COUNT_PER_REPETITION,CLINIC_NO,IS_SEND,SEND_WIN_NO) VALUES (to_date('2024/11/21 08:09:31','yyyy/mm/dd hh24:mi:ss'),'1852','050101','10671107','贾凯涵','','一般人员','自费','0','门诊处方','0','1','57.51','57.51','0304','YYH','杨艳辉','YYH','20241121008925','2','20241121593','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2024-11-21 08:09:31', 'yyyy-mm-dd hh24:mi:ss'),'1852','1','11303030680','100ml(双层无菌)','0.9%氯化钠注射液100ml','石家庄四药','100ml(双层无菌)','袋','1','6.09','6.09','100;ml;静脉输液;1/日','1','1','100','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2024-11-21 08:09:31', 'yyyy-mm-dd hh24:mi:ss'),'1852','2','10102076670','0.5g','注射用头孢曲松钠0.5g','山东润泽','0.5g','瓶','3','51.42','51.42','1.5;g;静脉输液;1/日','1','2','1.5','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/11/20 16:38:57','yyyy/mm/dd hh24:mi:ss'),'1900','10671107','0','','0304','杨艳辉','20241121008925','20241120593') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 08:09:31','yyyy/mm/dd hh24:mi:ss'),'1900','20241121008925','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语句 记录时间：2024-11-21 08:09:32 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 08:09:31','yyyy/mm/dd hh24:mi:ss'),'1900','20241121008925','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语句 记录时间：2024-11-21 08:09:32 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 08:09:31','yyyy/mm/dd hh24:mi:ss'),'1900','20241121008925','3','C','H0000026','血细胞分析','/','11','项','0411','11','11','0','1','M','025','190','1.0000','1.0000','1','','0','杨艳辉','0304','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 08:09:31','yyyy/mm/dd hh24:mi:ss'),'1900','20241121008925','4','C','H0000053','血细胞分析(流式细胞仪法每增一项指标)','/','13','项','0411','13','13','0','1','M','025','190','1.0000','1.0000','1','','0','杨艳辉','0304','0','*血常规+C-反应蛋白测定(CRP)(急)','JY000116','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/11/20 16:38:57','yyyy/mm/dd hh24:mi:ss'),'1901','10671107','1','门诊处方','0304','杨艳辉','20241121008925','20241120593') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 08:09:31','yyyy/mm/dd hh24:mi:ss'),'1901','20241121008925','1','A','11303030680','0.9%氯化钠注射液100ml','100ml(双层无菌)石家庄四药','1','袋','050101','6.09','6.09','0','1','A','032','200','1.0000','6.0900','1','100;ml;静脉输液;1/日','0','杨艳辉','0304','0','0.9%氯化钠注射液100ml','11303030680','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 08:09:31','yyyy/mm/dd hh24:mi:ss'),'1901','20241121008925','2','A','10102076670','注射用头孢曲松钠0.5g','0.5g山东润泽','3','瓶','050101','51.42','51.42','0','1','C','022','300','1.0000','17.1400','2','1.5;g;静脉输液;1/日','0','杨艳辉','0304','0','注射用头孢曲松钠0.5g','10102076670','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/11/20 16:38:57','yyyy/mm/dd hh24:mi:ss'),'1902','10671107','0','','0304','杨艳辉','20241121008925','20241120593') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 08:09:31','yyyy/mm/dd hh24:mi:ss'),'1902','20241121008925','1','E','C0000010','门急诊留观诊察费','/','1','日','0304','8','8','0','1','H','002','180','1.0000','8.0000','2','','0','杨艳辉','0304','0','门急诊留观诊查费','10012','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 08:09:31','yyyy/mm/dd hh24:mi:ss'),'1902','20241121008925','2','J','I0009381','一次性使用输液器(带针)','0.55#精密进气式/威高','1','支','0304','3.08','3.08','0','1','C','022','300','1.0000','3.0800','3','','0','杨艳辉','0304','0','一次性使用输液器(带针)','I0009381','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 08:09:31','yyyy/mm/dd hh24:mi:ss'),'1902','20241121008925','3','Z','B0000025','门急诊输液观察座位费','/','1','日','0304','3','3','0','1','B','027','100','1.0000','3.0000','4','','0','杨艳辉','0304','0','门急诊输液观察座位费','10061','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 08:09:31','yyyy/mm/dd hh24:mi:ss'),'1902','20241121008925','4','E','E0003045','静脉输液','/','1','次','0304','9','9','0','1','C','022','300','1.0000','9.0000','5','','0','杨艳辉','0304','0','静脉输液','E0003045','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20241121008925','1','微信','150.59','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15229840' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15229840' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15229840' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15229840' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15229844' and presc_no = '1852' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15229844' and presc_no = '1852' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15229847' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15229847' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15229847' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15229847' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15229840' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15229840' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15229840' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15229840' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15229847' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15229847' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15229847' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15229847' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15229840' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15229840' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15229840' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15229840' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15229844' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15229844' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15229847' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15229847' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15229847' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15229847' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2411216168' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE exam_appoints SET costs='92.32',charges='92.32',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE exam_appoints SET costs='70',charges='70',BILLING_INDICATOR='1' WHERE EXAM_NO = '2411216168' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '10671107' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '10671107' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '10671107' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 08:09:32 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '10671107') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2024-11-21 08:09:32 记录内容：2024-11-21 08:09:32 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2024-11-21 08:09:32 记录内容：1成功120241121008925 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2024-11-21 08:09:32 记录内容：2024-11-21 08:09:32 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2024-11-21 09:34:21 记录内容：cyys_2017@123cyys_2017@123Z00306634Z0030663415231346152313601523136115231365184.36001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2024-11-21 09:34:21 记录内容：'15231346','15231360','15231361','15231365' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2024-11-21 09:34:21 记录内容：2024-11-21 09:34:21 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2024-11-21 09:34:22 记录内容：2024-11-21 09:34:22 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________ 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 ('20241121009481','Z00306634','李晓晶','一般人员','自费',to_date('2024/11/21 09:34:21','yyyy/mm/dd hh24:mi:ss'),'184.36','184.36','LI XIAO JING ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________ INSERT INTO drug_presc_master_temp (presc_date,presc_no,dispensary,PATIENT_ID,NAME,NAME_PHONETIC,IDENTITY,CHARGE_TYPE,PRESC_TYPE,PRESC_ATTR,PRESC_SOURCE,REPETITION,COSTS,PAYMENTS,ORDERED_BY,PRESCRIBED_BY,ENTERED_BY,DOCTOR_USER,RCPT_NO,COUNT_PER_REPETITION,CLINIC_NO,IS_SEND,SEND_WIN_NO) VALUES (to_date('2024/11/21 09:34:21','yyyy/mm/dd hh24:mi:ss'),'4734','050111','Z00306634','李晓晶','','一般人员','自费','0','门诊处方','0','1','96.06','96.06','0371','LJY01','梁静一','LJY01','20241121009481','1','202411214220','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2024-11-21 09:34:21', 'yyyy-mm-dd hh24:mi:ss'),'4734','1','11002008391','1mg*21','[进]戊酸雌二醇片','拜耳医药','1mg*21','盒','3','96.06','96.06','4;mg;口服;2/日','1','1','4','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/11/21 9:16:08','yyyy/mm/dd hh24:mi:ss'),'4815','Z00306634','1','门诊处方','0371','梁静一','20241121009481','202411214220') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 09:34:21','yyyy/mm/dd hh24:mi:ss'),'4815','20241121009481','1','A','11002008391','[进]戊酸雌二醇片','1mg*21拜耳医药','3','盒','050111','96.06','96.06','0','1','C','022','300','1.0000','32.0200','1','4;mg;口服;2/日','0','梁静一','0371','0','[进]戊酸雌二醇片','11002008391','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/11/21 9:16:08','yyyy/mm/dd hh24:mi:ss'),'4816','Z00306634','0','','0371','梁静一','20241121009481','202411214220') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 09:34:21','yyyy/mm/dd hh24:mi:ss'),'4816','20241121009481','1','C','H0209100','雌二醇测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','梁静一','0371','0','*雌二醇测定(生殖科)','JY001314','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/11/21 9:16:08','yyyy/mm/dd hh24:mi:ss'),'4817','Z00306634','0','','0371','梁静一','20241121009481','202411214220') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 09:34:22','yyyy/mm/dd hh24:mi:ss'),'4817','20241121009481','1','C','H0209103','孕酮测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','2','','0','梁静一','0371','0','*孕酮测定(生殖科)','JY001315','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/11/21 9:16:08','yyyy/mm/dd hh24:mi:ss'),'4818','Z00306634','0','','0371','梁静一','20241121009481','202411214220') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 09:34:22','yyyy/mm/dd hh24:mi:ss'),'4818','20241121009481','1','E','E0003052','静脉采血','/','1','次','0371','7','7','0','1','C','022','300','1.0000','7.0000','3','','0','梁静一','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 09:34:22','yyyy/mm/dd hh24:mi:ss'),'4818','20241121009481','2','E','I0015681','一次性使用静脉血样采集针','J-7软连接式0.7/威高','1','支','0371','0.25','0.25','0','1','C','022','300','1.0000','0.2500','3','','0','梁静一','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 09:34:22','yyyy/mm/dd hh24:mi:ss'),'4818','20241121009481','3','E','I0009141','一次性使用真空采血管','2ml/阳普','1','支','0371','1.05','1.05','0','1','L','031','170','1.0000','1.0500','3','','0','梁静一','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20241121009481','1','微信','184.36','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15231346' and presc_no = '4734' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15231360' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15231361' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15231365' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15231365' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15231365' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15231360' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15231361' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15231365' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15231365' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15231365' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15231346' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15231360' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15231361' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15231365' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15231365' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15231365' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2411216934' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2411216932' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE exam_appoints SET costs='8.30',charges='8.30',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE exam_appoints SET costs='40',charges='40',BILLING_INDICATOR='1' WHERE EXAM_NO = '2411216934' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE exam_appoints SET costs='40',charges='40',BILLING_INDICATOR='1' WHERE EXAM_NO = '2411216932' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'Z00306634' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = 'Z00306634' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'Z00306634' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:34:23 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = 'Z00306634') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2024-11-21 09:34:23 记录内容：2024-11-21 09:34:23 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2024-11-21 09:34:23 记录内容：1成功120241121009481 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2024-11-21 09:34:23 记录内容：2024-11-21 09:34:23 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2024-11-21 09:48:18 记录内容：cyys_2017@123cyys_2017@123DP027294DP0272941523153860.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2024-11-21 09:48:18 记录内容：'15231538' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2024-11-21 09:48:18 记录内容：2024-11-21 09:48:18 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2024-11-21 09:48:19 记录内容：2024-11-21 09:48:19 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48: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 ('20241121009585','DP027294','孔健','一般人员','自费',to_date('2024/11/21 09:48:18','yyyy/mm/dd hh24:mi:ss'),'60','60','KONG JIAN ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48: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('2024/11/20 17:22:52','yyyy/mm/dd hh24:mi:ss'),'5360','DP027294','0','','0327','苗恒','20241121009585','20241120874') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48: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('2024/11/21 09:48:18','yyyy/mm/dd hh24:mi:ss'),'5360','20241121009585','1','D','D0902031','双眼视觉检查','/','1','次','0327','10','10','0','1','J','044','150','1.0000','10.0000','1','','0','苗恒','0327','0','双眼视觉检查','10707','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48: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('2024/11/21 09:48:19','yyyy/mm/dd hh24:mi:ss'),'5360','20241121009585','2','E','D0902044','眼压检查','/','2','次','0327','12','12','0','1','J','044','150','1.0000','6.0000','2','','0','苗恒','0327','0','眼压检查','10719','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48: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('2024/11/21 09:48:19','yyyy/mm/dd hh24:mi:ss'),'5360','20241121009585','3','D','D0902018','试镜','/','2','项','0327','4','4','0','1','J','044','150','1.0000','2.0000','3','','0','苗恒','0327','0','试镜','10694','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48: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('2024/11/21 09:48:19','yyyy/mm/dd hh24:mi:ss'),'5360','20241121009585','4','E','D0902077','裂隙灯下眼底检查','/','2','次','0327','20','20','0','1','J','044','150','1.0000','10.0000','4','','0','苗恒','0327','0','裂隙灯下眼底检查','10753','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48: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('2024/11/21 09:48:19','yyyy/mm/dd hh24:mi:ss'),'5360','20241121009585','5','E','D0902076','裂隙灯检查','/','2','次','0327','6','6','0','1','J','044','150','1.0000','3.0000','5','','0','苗恒','0327','0','裂隙灯检查','10752','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48: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('2024/11/21 09:48:19','yyyy/mm/dd hh24:mi:ss'),'5360','20241121009585','6','D','D0902014','验光','/','2','项','0327','4','4','0','1','J','044','150','1.0000','2.0000','6','','0','苗恒','0327','0','*显然验光','JC000012','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48: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('2024/11/21 09:48:19','yyyy/mm/dd hh24:mi:ss'),'5360','20241121009585','7','D','D0902018','试镜','/','2','项','0327','4','4','0','1','J','044','150','1.0000','2.0000','6','','0','苗恒','0327','0','*显然验光','JC000012','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20241121009585','1','微信','60','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15231538' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15231538' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15231538' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15231538' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15231538' and presc_no = '0' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15231538' and presc_no = '0' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15231538' and presc_no = '0' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15231538' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15231538' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15231538' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15231538' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15231538' and item_no = '5' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15231538' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15231538' and item_no = '6' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15231538' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15231538' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15231538' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15231538' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15231538' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15231538' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15231538' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE exam_appoints SET costs='360',charges='360',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'DP027294' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = 'DP027294' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'DP027294' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:48:19 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = 'DP027294') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2024-11-21 09:48:19 记录内容：2024-11-21 09:48:19 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2024-11-21 09:48:19 记录内容：1成功120241121009585 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2024-11-21 09:48:19 记录内容：2024-11-21 09:48:19 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2024-11-21 09:55:41 记录内容：cyys_2017@123cyys_2017@123100058874100058874152317636.58001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2024-11-21 09:55:41 记录内容：'15231763' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2024-11-21 09:55:41 记录内容：2024-11-21 09:55:41 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2024-11-21 09:55:41 记录内容：2024-11-21 09:55:41 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:55:41 记录内容：__________ 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 ('20241121009646','100058874','费宏坤','一般人员','自费',to_date('2024/11/21 09:55:41','yyyy/mm/dd hh24:mi:ss'),'6.58','6.58','FEI HONG KUN ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:55:41 记录内容：__________ INSERT INTO drug_presc_master_temp (presc_date,presc_no,dispensary,PATIENT_ID,NAME,NAME_PHONETIC,IDENTITY,CHARGE_TYPE,PRESC_TYPE,PRESC_ATTR,PRESC_SOURCE,REPETITION,COSTS,PAYMENTS,ORDERED_BY,PRESCRIBED_BY,ENTERED_BY,DOCTOR_USER,RCPT_NO,COUNT_PER_REPETITION,CLINIC_NO,IS_SEND,SEND_WIN_NO) VALUES (to_date('2024/11/21 09:55:41','yyyy/mm/dd hh24:mi:ss'),'5550','050101','100058874','费宏坤','','一般人员','自费','0','门诊处方','0','1','6.58','6.58','0303','LIXN','李晓宁','LIXN','20241121009646','1','202411211112','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:55:41 记录内容：__________ INSERT INTO DRUG_PRESC_DETAIL_TEMP (PRESC_DATE,PRESC_NO,ITEM_NO,DRUG_CODE,DRUG_SPEC,DRUG_NAME,FIRM_ID,PACKAGE_SPEC,PACKAGE_UNITS,QUANTITY,COSTS,PAYMENTS,ADMINISTRATION,ORDER_NO,ORDER_SUB_NO,DOSAGE_EACH,DOSAGE_UNITS,FREQUENCY,FREQ_DETAIL,BATCH_NO,FLAG,PRESC_PSNO,SKINTEST,PURCHASE_PRICE_AMT,DIAG_DESC,SKIN_FLAG,ROUND_AMT,YJ_FLAG,YJ_DT_IMPBACK) VALUES (TO_DATE('2024-11-21 09:55:41', 'yyyy-mm-dd hh24:mi:ss'),'5550','1','10206035390','3mg*14','右佐匹克隆片*','齐鲁制药','3mg*14','盒','1','6.58','6.58','3;mg;口服;睡前','1','1','3','','','','','','0','0','','','','0.0000','','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:55:41 记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/11/21 9:42:10','yyyy/mm/dd hh24:mi:ss'),'5624','100058874','1','门诊处方','0303','李晓宁','20241121009646','202411211112') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:55:41 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 09:55:41','yyyy/mm/dd hh24:mi:ss'),'5624','20241121009646','1','A','10206035390','右佐匹克隆片*','3mg*14齐鲁制药','1','盒','050101','6.58','6.58','0','1','C','022','300','1.0000','6.5800','1','3;mg;口服;睡前','0','李晓宁','0303','0','右佐匹克隆片*','10206035390','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:55:41 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20241121009646','1','微信','6.58','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:55:41 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15231763' and presc_no = '5550' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:55:41 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15231763' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:55:41 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '100058874' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:55:41 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '100058874' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:55:41 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '100058874' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 09:55:41 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '100058874') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2024-11-21 09:55:41 记录内容：2024-11-21 09:55:41 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2024-11-21 09:55:41 记录内容：1成功120241121009646 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2024-11-21 09:55:41 记录内容：2024-11-21 09:55:41 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2024-11-21 13:38:41 记录内容：cyys_2017@123cyys_2017@123004330140043301415234073220.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2024-11-21 13:38:41 记录内容：'15234073' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2024-11-21 13:38:41 记录内容：2024-11-21 13:38:41 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2024-11-21 13:38:41 记录内容：2024-11-21 13:38:41 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________ INSERT INTO OUTP_RCPT_MASTER (RCPT_NO,PATIENT_ID,NAME,IDENTITY,CHARGE_TYPE,VISIT_DATE,TOTAL_COSTS,TOTAL_CHARGES,NAME_PHONETIC,INSUR_FLAG,CHARGE_INDICATOR,OPERATOR_NO) VALUES ('20241121010932','00433014','王思齐','一般人员','自费',to_date('2024/11/21 13:38:41','yyyy/mm/dd hh24:mi:ss'),'220','220','WANG SI QI ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/11/20 19:15:52','yyyy/mm/dd hh24:mi:ss'),'9587','00433014','0','','0371','许春月','20241121010932','202411201116') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 13:38:41','yyyy/mm/dd hh24:mi:ss'),'9587','20241121010932','1','C','H0209012','血清促卵泡刺激素测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','许春月','0371','0','*性激素四项(生殖科)','JY001308','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 13:38:41','yyyy/mm/dd hh24:mi:ss'),'9587','20241121010932','2','C','H0209015','血清促黄体生成素测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','许春月','0371','0','*性激素四项(生殖科)','JY001308','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 13:38:41','yyyy/mm/dd hh24:mi:ss'),'9587','20241121010932','3','C','H0209100','雌二醇测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','许春月','0371','0','*性激素四项(生殖科)','JY001308','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 13:38:41','yyyy/mm/dd hh24:mi:ss'),'9587','20241121010932','4','C','H0209103','孕酮测定(化学发光法)','/','1','项','0441','40','40','0','1','M','025','190','1.0000','40.0000','1','','0','许春月','0371','0','*性激素四项(生殖科)','JY001308','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 13:38:41','yyyy/mm/dd hh24:mi:ss'),'9587','20241121010932','5','C','H0209147','特异β人绒毛膜促性腺激素（β-HCG）测定','/','1','项','0441','60','60','0','1','C','022','300','1.0000','60.0000','2','','0','许春月','0371','0','*人绒毛膜促性腺激素测定(生殖科)','JY001320','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20241121010932','1','微信','220','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15234073' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15234073' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15234073' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15234073' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15234073' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15234073' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15234073' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15234073' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15234073' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15234073' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15234073' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15234073' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15234073' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15234073' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15234073' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2411217883' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________UPDATE exam_appoints SET costs='196.60',charges='196.60',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________UPDATE exam_appoints SET costs='440',charges='440',BILLING_INDICATOR='1' WHERE EXAM_NO = '2411217883' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00433014' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '00433014' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00433014' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:38:42 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '00433014') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2024-11-21 13:38:42 记录内容：2024-11-21 13:38:42 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2024-11-21 13:38:42 记录内容：1成功120241121010932 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2024-11-21 13:38:42 记录内容：2024-11-21 13:38:42 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2024-11-21 13:39:22 记录内容：cyys_2017@123cyys_2017@12300433014004330141523407498.30001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2024-11-21 13:39:22 记录内容：'15234074' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2024-11-21 13:39:22 记录内容：2024-11-21 13:39:22 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2024-11-21 13:39:22 记录内容：2024-11-21 13:39:22 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________ 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 ('20241121010935','00433014','王思齐','一般人员','自费',to_date('2024/11/21 13:39:22','yyyy/mm/dd hh24:mi:ss'),'98.3','98.3','WANG SI QI ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/11/20 19:15:52','yyyy/mm/dd hh24:mi:ss'),'9596','00433014','0','','0371','许春月','20241121010935','202411201116') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 13:39:22','yyyy/mm/dd hh24:mi:ss'),'9596','20241121010935','1','E','E0003052','静脉采血','/','1','次','0371','7','7','0','1','C','022','300','1.0000','7.0000','3','','0','许春月','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 13:39:22','yyyy/mm/dd hh24:mi:ss'),'9596','20241121010935','2','E','I0015681','一次性使用静脉血样采集针','J-7软连接式0.7/威高','1','支','0371','0.25','0.25','0','1','C','022','300','1.0000','0.2500','3','','0','许春月','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 13:39:22','yyyy/mm/dd hh24:mi:ss'),'9596','20241121010935','3','E','I0009141','一次性使用真空采血管','2ml/阳普','1','支','0371','1.05','1.05','0','1','L','031','170','1.0000','1.0500','3','','0','许春月','0371','0','*采血套餐一','15639','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 13:39:22','yyyy/mm/dd hh24:mi:ss'),'9596','20241121010935','4','D','D1201121','腔内彩色多普勒超声检查','/','1','次','0371','90','90','0','1','J','006','150','1.0000','90.0000','4','','0','许春月','0371','0','*生殖卵泡监测','JC000924','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20241121010935','1','微信','98.3','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15234074' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15234074' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15234074' and presc_no = '0' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15234074' and presc_no = '0' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15234074' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15234074' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15234074' and item_no = '3' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15234074' and item_no = '4' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15234074' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15234074' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15234074' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15234074' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2411217883' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________UPDATE exam_appoints SET costs='196.60',charges='196.60',BILLING_INDICATOR='1' WHERE EXAM_NO = '' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________UPDATE exam_appoints SET costs='440',charges='440',BILLING_INDICATOR='1' WHERE EXAM_NO = '2411217883' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = '00433014' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = '00433014' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = '00433014' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 13:39:23 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = '00433014') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2024-11-21 13:39:23 记录内容：2024-11-21 13:39:23 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2024-11-21 13:39:23 记录内容：1成功120241121010935 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2024-11-21 13:39:23 记录内容：2024-11-21 13:39:23 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：参数 记录时间：2024-11-21 15:54:14 记录内容：cyys_2017@123cyys_2017@123Z00368937Z003689371523531915235320136.00001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：处方号为： 记录时间：2024-11-21 15:54:14 记录内容：'15235319','15235320' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询 记录时间：2024-11-21 15:54:14 记录内容：2024-11-21 15:54:14 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行查询并操作 记录时间：2024-11-21 15:54:15 记录内容：2024-11-21 15:54:15 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________ 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 ('20241121011771','Z00368937','李晴','一般人员','自费',to_date('2024/11/21 15:54:14','yyyy/mm/dd hh24:mi:ss'),'136','136','LI QING ','0','0','9328') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/11/21 15:39:46','yyyy/mm/dd hh24:mi:ss'),'2078','Z00368937','0','','0330','辛俊英','20241121011771','202411211860') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 15:54:14','yyyy/mm/dd hh24:mi:ss'),'2078','20241121011771','1','D','D0602007','产科彩色多普勒超声常规检查','/','1','次','0409','100','100','0','1','J','006','150','1.0000','100.0000','1','','0','辛俊英','0330','0','*产科多普勒常规检查+宫颈管功能测量','JC000893','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 15:54:14','yyyy/mm/dd hh24:mi:ss'),'2078','20241121011771','2','D','D0602045','彩色多普勒超声常规检查','/','1','项','0409','20','20','0','1','J','006','150','1.0000','20.0000','1','','0','辛俊英','0330','0','*产科多普勒常规检查+宫颈管功能测量','JC000893','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 15:54:14','yyyy/mm/dd hh24:mi:ss'),'2078','20241121011771','3','D','D0607008','超声计算机图文报告','/','1','次','0409','10','10','0','1','J','006','150','1.0000','10.0000','1','','0','辛俊英','0330','0','*产科多普勒常规检查+宫颈管功能测量','JC000893','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________ INSERT INTO outp_order_desc (VISIT_DATE,VISIT_NO,PATIENT_ID,PRESC_INDICATOR,PRESC_ATTR,ORDERED_BY_DEPT,ORDERED_BY_DOCTOR,RCPT_NO,CLINIC_NO) VALUES (TO_DATE('2024/11/21 15:39:46','yyyy/mm/dd hh24:mi:ss'),'2079','Z00368937','0','','0330','辛俊英','20241121011771','202411211860') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________ INSERT INTO outp_bill_items (visit_date,visit_no,rcpt_no,item_no,item_class,item_code,item_name,item_spec,amount,units,performed_by,costs,charges,flag,repetition,class_on_rcpt,class_on_reckoning,subj_code,price_quotiety,item_price,order_no,administration,data_source,ordered_by_doctor,ordered_by_dept,writeoff,clinic_item_name,clinic_item_code,fee,feein,feeout,selfpay2,state,fee_type) VALUES (to_date('2024/11/21 15:54:14','yyyy/mm/dd hh24:mi:ss'),'2079','20241121011771','1','C','H0001049','尿液分析','/','1','次','0411','6','6','0','1','C','022','300','1.0000','6.0000','2','','0','辛俊英','0330','0','尿常规','JY001411','0.0000','0.0000','0.0000','0.0000','0','') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________ INSERT INTO OUTP_PAYMENTS_MONEY (RCPT_NO,PAYMENT_NO,MONEY_TYPE,PAYMENT_AMOUNT,REFUNDED_AMOUNT) VALUES ('20241121011771','1','微信','136','0.00') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15235319' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15235319' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15235319' and presc_no = '0' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________UPDATE outp_presc_t SET charge_indicator='1' WHERE serial_no = '15235320' and presc_no = '0' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15235319' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15235319' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15235319' and item_no = '1' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________UPDATE outp_treat_rec_t SET charge_indicator='1' WHERE serial_no = '15235320' and item_no = '2' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15235319' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15235319' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15235319' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________UPDATE outp_orders_costs SET charge_indicator='1' WHERE serial_no = '15235320' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '5232525' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________UPDATE EXAM_ITEMS SET BILLING_INDICATOR='1' WHERE EXAM_NO = '2411218268' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________UPDATE exam_appoints SET costs='130',charges='130',BILLING_INDICATOR='1' WHERE EXAM_NO = '5232525' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________UPDATE exam_appoints SET costs='6',charges='6',BILLING_INDICATOR='1' WHERE EXAM_NO = '2411218268' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________UPDATE lab_test_master SET billing_indicator=1 WHERE patient_id = 'Z00368937' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________UPDATE lab_test_items SET billing_indicator=1 WHERE test_no in (select test_no from lab_test_master WHERE patient_id = 'Z00368937' ) ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________UPDATE exam_appoints SET billing_indicator=1 WHERE patient_id = 'Z00368937' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：SQL语句 记录时间：2024-11-21 15:54:16 记录内容：__________UPDATE exam_items SET billing_indicator=1 WHERE exam_no in (select exam_no from exam_appoints WHERE patient_id = 'Z00368937') ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：执行写入 记录时间：2024-11-21 15:54:16 记录内容：2024-11-21 15:54:16 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：返回数据 记录时间：2024-11-21 15:54:16 记录内容：1成功120241121011771 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述：跳出方法 记录时间：2024-11-21 15:54:16 记录内容：2024-11-21 15:54:16 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆