◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述:获取未缴费收费单参数
记录时间: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
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆