術(shù)申請單 op_record 住院病人 patient_type=’0’, op_record_status=’0’
門診病人 patient_type=’2’ ,op_record_status=’0’, ward_code=null
手術(shù)安排 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 劃價狀態(tài) charge_status=’1’
收費項目調(diào)用的視圖：view_zy_charge_input_dept
打印領(lǐng)藥單 ：統(tǒng)領(lǐng)單為例[住院病人]
記錄寫入：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'
|
|
資源大�。�9.14 KB 
