/// <summary> /// 新增数据 /// </summary> public AjaxResult Insert(TbUserCost model, List <TbUserCostItem> items) { if (model == null) { return(AjaxResult.Warning("参数错误")); } model.InsertUserCode = OperatorProvider.Provider.CurrentUser.UserCode; model.Examinestatus = "未发起"; try { using (DbTrans trans = Db.Context.BeginTransaction()) { //添加信息 Repository <TbUserCost> .Insert(trans, model); //添加明细信息 Repository <TbUserCostItem> .Insert(trans, items); trans.Commit(); return(AjaxResult.Success()); } } catch (Exception ex) { return(AjaxResult.Error()); } }
/// <summary> /// 修改数据 /// </summary> public AjaxResult Update(TbUserCost model, List <TbUserCostItem> items) { if (model == null) { return(AjaxResult.Warning("参数错误")); } var anyRet = AnyInfo(model.ID); if (anyRet.state != ResultType.success.ToString()) { return(anyRet); } try { using (DbTrans trans = Db.Context.BeginTransaction())//使用事务 { //修改信息 Repository <TbUserCost> .Update(trans, model, p => p.ID == model.ID); if (items.Count > 0) { //删除历史明细信息 Repository <TbUserCostItem> .Delete(trans, p => p.CheckCode == model.CheckCode); //添加明细信息 Repository <TbUserCostItem> .Insert(trans, items); } trans.Commit();//提交事务 return(AjaxResult.Success()); } } catch (Exception ex) { return(AjaxResult.Error(ex.ToString())); } }