《ic卡管理操作与数据库结果说明》由会员分享,可在线阅读,更多相关《ic卡管理操作与数据库结果说明(2页珍藏版)》请在金锄头文库上搜索。
1、1.购新卡 ic_register 基本信息卡类、卡号、P_ID Ic_register.card_no=ic_card_type.max_no+1 Balace := banlace-本次操作收费金额 Card_flag := 0; Ic_deposit Card_code:=卡类型 Card_no := Ic_register.card_no Ledger_sn=mz_patient_mi.max_ledger_sn+1 Patient_id := mz_patient_mi.patient_id; Charge:=金额 Depo_status : =1; Base_opera_code
2、:= 01 Ic_receipt Patient_id := mz_patient_mi.patient_id; Ledger_sn := ic_deposit.ledger_sn Receipt_sn= mz_patient_mi.max_receipt_sn+1 Charge_taotal :=本次操作所收取的费用(注意非卡上的金额) Charge_status := 4; Receipt_no :从 ic_op_receipt 取值 Ic_receipt_charge Patient_id := mz_patient_mi.patient_id; Ledger_sn := ic_depo
3、sit.ledger_sn Receipt_sn= mz_patient_mi.max_receipt_sn+1 Bill_code :=发票账单 Charge :=账单费用 Ic_detail_charge Patient_id := mz_patient_mi.patient_id; Ledger_sn := ic_deposit.ledger_sn Charge_code : Charge_status := 4 mz_patient_mi, 如果是新病人,则向这两个表中插入纪录 patient_id:=ID; name := name; balace :=0; 2.补费用 ic_reg
4、ister.balance= ic_register.balance+剩余金额 ic_deposit 增加一条纪录 Patient_id := mz_patient_mi.patient_id; Ledger_sn :=0 Depo_status :=1; Charge := 补费金额 3.退卡ic_register: card_flag := 2 ic_deposit 增加一条纪录 card_code,card_no ledger_sn :=新 ledger_sn charge := 负金额 Base_opera_code := 02 Depo_status := 2 ic_receipt
5、patient_id = ID; ledger_sn := 新 ledger_sn charge_taotal := 本次操作的费用ic_rceipt_charge 增加新纪录 patient_id = ID; ledger_sn := 新 ledger_sn bill_code : charge := 账单金额 4.补卡 与购新卡类似,收费项目为补发新卡定义 5.退费 修改 ic_register.balance,ic_deposit 插入操作纪录 6.卡作废: 置 ic_register.card_state=作废 7.卡挂失:置 ic_register.card_state=挂失 8.修改密码 修改 ic_register.password