/// <summary> /// 创建receipt后保存支付信息 /// </summary> private void Save() { BLL.CRUD biz = new CRUD(DbVendor.Oracle, Runtime.OracleConnStrLocal, true); try { etyH = new M_T_PAYMENT(); etyH.paymentid = Bizhub.FetchPaymentId(biz) + 1; etyH.amount = this.req.data.actualamount; etyH.leasenumber = this.req.data.leasenum; etyH.paydate = DateTime.Parse(this.req.data.actualpaydate); etyH.paytype = this.req.data.actualpaytype; etyH.status = "0"; // Status取值定义:0=本地保存完成;1=Receipt创建完成;2=分录创建完成。状态必须从0~2顺序转换。 biz.Create(etyH); Model.Req35dataDtl detail = null; etyD = new M_T_PAYMENT_INFO(); for (int i = 0; i < this.req.data.actualpayinfo.Count; i++) { detail = this.req.data.actualpayinfo[i]; etyD.actualpay = detail.actualpay; etyD.amount = detail.amount; etyD.chargecode = detail.chargecode; etyD.invoicenumber = detail.transno; etyD.invoicelinenum = detail.invoicelinenum; etyD.paymentid = etyH.paymentid; biz.Create(etyD); } biz.Commit(); } catch (Exception err) { biz.Abort(); throw err; } }
/// <summary> /// 创建receipt后保存支付信息 /// </summary> private void DAL_Insert_Pay() { DbHelper db = new DbHelper(Common.OracleConnStrLocal, true); try { etyH = new M_T_PAYMENT(); etyH.paymentid = BHelper.FetchPaymentId(db) + 1; etyH.amount = this.req.data.actualamount; etyH.leasenumber = this.req.data.leasenum; etyH.paydate = DateTime.Parse(this.req.data.actualpaydate); etyH.paytype = this.req.data.actualpaytype; etyH.status = "0"; // Status取值定义:0=本地保存完成;1=Receipt创建完成;2=分录创建完成。状态必须从0~2顺序转换。 Common.Insert <M_T_PAYMENT>(etyH, db); Req35_2 detail = null; etyD = new M_T_PAYMENT_INFO(); for (int i = 0; i < this.req.data.actualpayinfo.Count; i++) { detail = this.req.data.actualpayinfo[i]; etyD.actualpay = detail.actualpay; etyD.amount = detail.amount; etyD.chargecode = detail.chargecode; etyD.invoicenumber = detail.transno; etyD.invoicelinenum = detail.invoicelinenum; etyD.paymentid = etyH.paymentid; Common.Insert <M_T_PAYMENT_INFO>(etyD, db); } db.Commit(); } catch (Exception err) { db.Abort(); throw err; } }