◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取未缴费收费单参数 记录时间:2026-01-27 15:40:56 记录内容:cyys_2017@123cyys_2017@123100530939曹晓磊 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:查询sql记录 记录时间:2026-01-27 15:40:56 记录内容:dataTable2 select a.REPETITION,a.abidance,a.dosage,a.dosage_units,a.visit_date,a.visit_no,a.serial_no,0, a.item_no,a.item_class,a.drug_code,a.drug_name,a.drug_spec, a.units,0 as presc_no,'' as ADMINISTRATION,a.FREQUENCY as FREQUENCY,b.* from outp_presc_t a left join outp_orders_costs b on (a.visit_no=b.visit_no and a.serial_no=b.serial_no and a.visit_date=b.visit_date and a.drug_code = b.item_code and a.order_no = b.order_no) where (b.visit_date,a.visit_no) in (select visit_date,visit_no from clinic_master where patient_id = '100530939' and visit_date >=to_date('2026-01-27','yyyy-MM-dd')) and a.charge_indicator='0' union all select 0 as REPETITION,0 as abidance,0 as dosage,'' as dosage_units,a.visit_date,a.visit_no,a.serial_no,0, a.item_no,a.item_class, b.item_code, b.item_name, a.item_spec, a.units,0 as presc_no,'' as ADMINISTRATION,a.FREQUENCY as FREQUENCY,b.* from outp_treat_rec_t a left join outp_orders_costs b on(a.visit_no = b.visit_no and a.serial_no = b.serial_no and a.visit_date = b.visit_date and a.item_no = b.order_no) where (b.visit_date,a.visit_no) in (select visit_date,visit_no from clinic_master where patient_id = '100530939' and visit_date >=to_date('2026-01-27','yyyy-MM-dd')) and a.charge_indicator='0' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:查询sql记录 记录时间:2026-01-27 15:40:56 记录内容:select * from outp_mr a left join diagnosis_dict b on(a.diag_desc=b.diagnosis_name) where patient_id='100530939' and visit_date in (select visit_date from outp_mr where patient_id='100530939' and visit_date >=to_date('2026-01-27','yyyy-MM-dd')) and diagnosis_code is not null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:查询成功或失败返回记录 记录时间:2026-01-27 15:40:56 记录内容:1成功1776974717769747177697470106.67XC信息科
1010203103230布洛芬缓释胶囊(芬必得)0.3g*200.30g12.45111/日12.451A西药2010101004270阿莫西林胶囊(0.25g*40)0.25g*400.25g5.26111/日5.261A西药3010114040390左氧氟沙星片(0.25g*30)0.25g*300.25g7.48111/日7.481A西药4010102073670注射用头孢曲松钠1g*1g1g1.92111/日1.921A西药5010108005131[进]注射用阿奇霉素0.5g1g72.66111/日72.661A西药6010102084270头孢克洛胶囊(0.25g*12)*0.25g*120.25g6.9111/日6.91A西药
177694861776948617769486012.45XC信息科
1010203103230布洛芬缓释胶囊(芬必得)0.3g*200.30g12.45122/日12.451A西药
177680901776809017768090018.7XC信息科
11E0003052静脉采血071070E治疗21I0015681一次性使用静脉血样采集针00.25100.250E治疗31I0015765一次性使用人体静脉血样采集容器00.42803.360E治疗41E0003052静脉采血071070E治疗51I0015681一次性使用静脉血样采集针00.25100.250E治疗61I0015765一次性使用人体静脉血样采集容器00.42200.840E治疗
A西药119.12B中药0C化验0D检查0E治疗18.7F手术0G麻醉0H血费0I材料0J床位0K护理0L膳食0Z杂费0137.82137.82
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取未缴费收费单参数 记录时间:2026-01-27 15:41:38 记录内容:cyys_2017@123cyys_2017@123100530939曹晓磊 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:查询sql记录 记录时间:2026-01-27 15:41:38 记录内容:dataTable2 select a.REPETITION,a.abidance,a.dosage,a.dosage_units,a.visit_date,a.visit_no,a.serial_no,0, a.item_no,a.item_class,a.drug_code,a.drug_name,a.drug_spec, a.units,0 as presc_no,'' as ADMINISTRATION,a.FREQUENCY as FREQUENCY,b.* from outp_presc_t a left join outp_orders_costs b on (a.visit_no=b.visit_no and a.serial_no=b.serial_no and a.visit_date=b.visit_date and a.drug_code = b.item_code and a.order_no = b.order_no) where (b.visit_date,a.visit_no) in (select visit_date,visit_no from clinic_master where patient_id = '100530939' and visit_date >=to_date('2026-01-27','yyyy-MM-dd')) and a.charge_indicator='0' union all select 0 as REPETITION,0 as abidance,0 as dosage,'' as dosage_units,a.visit_date,a.visit_no,a.serial_no,0, a.item_no,a.item_class, b.item_code, b.item_name, a.item_spec, a.units,0 as presc_no,'' as ADMINISTRATION,a.FREQUENCY as FREQUENCY,b.* from outp_treat_rec_t a left join outp_orders_costs b on(a.visit_no = b.visit_no and a.serial_no = b.serial_no and a.visit_date = b.visit_date and a.item_no = b.order_no) where (b.visit_date,a.visit_no) in (select visit_date,visit_no from clinic_master where patient_id = '100530939' and visit_date >=to_date('2026-01-27','yyyy-MM-dd')) and a.charge_indicator='0' ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:查询sql记录 记录时间:2026-01-27 15:41:38 记录内容:select * from outp_mr a left join diagnosis_dict b on(a.diag_desc=b.diagnosis_name) where patient_id='100530939' and visit_date in (select visit_date from outp_mr where patient_id='100530939' and visit_date >=to_date('2026-01-27','yyyy-MM-dd')) and diagnosis_code is not null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:查询成功或失败返回记录 记录时间:2026-01-27 15:41:39 记录内容:1成功1776974717769747177697470106.67XC信息科
1010203103230布洛芬缓释胶囊(芬必得)0.3g*200.30g12.45111/日12.451A西药2010101004270阿莫西林胶囊(0.25g*40)0.25g*400.25g5.26111/日5.261A西药3010114040390左氧氟沙星片(0.25g*30)0.25g*300.25g7.48111/日7.481A西药4010102073670注射用头孢曲松钠1g*1g1g1.92111/日1.921A西药5010108005131[进]注射用阿奇霉素0.5g1g72.66111/日72.661A西药6010102084270头孢克洛胶囊(0.25g*12)*0.25g*120.25g6.9111/日6.91A西药
177694861776948617769486012.45XC信息科
1010203103230布洛芬缓释胶囊(芬必得)0.3g*200.30g12.45122/日12.451A西药
177680901776809017768090018.7XC信息科
11E0003052静脉采血071070E治疗21I0015681一次性使用静脉血样采集针00.25100.250E治疗31I0015765一次性使用人体静脉血样采集容器00.42803.360E治疗41E0003052静脉采血071070E治疗51I0015681一次性使用静脉血样采集针00.25100.250E治疗61I0015765一次性使用人体静脉血样采集容器00.42200.840E治疗
A西药119.12B中药0C化验0D检查0E治疗18.7F手术0G麻醉0H血费0I材料0J床位0K护理0L膳食0Z杂费0137.82137.82
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆