术申请单 op_record 住院病人 patient_type=’0’, op_record_status=’0’
门诊病人 patient_type=’2’ ,op_record_status=’0’, ward_code=null
手术安排 op_record op_record_status=’2’]
更改:schedule_date、 schedule_user 、 op_record_status 、 op_room_ID
划价 住院病人:1)诊疗 写入zy_detail_charge 直接上帐 charge_status=’2’
Apply_status=’1’
Order_no=’2’
Happen_date=op_record.apply_date
2)药品 写入zy_detail_charge 直接上帐 charge_status=’2’
Apply_status=’0’
Order_no=’2’
Happen_date=op_record.apply_date
Confirm_time = null
Confirm_opera=null
Page_no=0
Page_type=0
门诊病人:update mz_visit_table set max_order = max_order+ 1
写入mz_detail_charge 划价状态 charge_status=’1’
收费项目调用的视图:view_zy_charge_input_dept
打印领药单 :统领单为例[住院病人]
记录写入:yz_yp_page_no
更改zy_detail_charge page_no=( select page_no from yz_configure)
Page_type=’21’
确认:exec TransferOptoBak 1569, '00000'
撤销:exec TransferBakToOp 1569, '00000'
|
|