110,499
社区成员
发帖
与我相关
我的任务
分享
myConn.Open();
myTrans = myConn.BeginTransaction();
try
{
EPaybill = MPaybill.SelectByID(paybillEntry.FPARENTID); //订单表头记录
MPaybillEntry.Insert(myTrans, paybillEntry); //插入订单分录
EPaybill.FPASSTOTALAMOUNT = this.GetOrderTotalAmount(paybillEntry.FPARENTID); // 获取订单总金额
// 现在的问题是:在此这前事务还没提交,无法获取刚插入的记录,这里是不是需要嵌套事务?
MPaybill.Update(myTrans, EPaybill);
myTrans.Commit();
}
catch (Exception e)
{
bRetVal = false;
strFailedRetMess = Resources.MESSAGE_TRANS_FAILED;
myTrans.Rollback();
}
finally
{
myTrans.Dispose();
myConn.Close();
}
return bRetVal;
}