/// <summary> /// 修改数据 /// </summary> public AjaxResult Update(TbMonthCostHeSuan model, TbMonthCostHeSuanIncome incomeModel, List <TbMonthCostHeSuanCost> costModel, List <TbMonthCostHeSuanOtherCost> otherCostModel) { if (model == null) { return(AjaxResult.Warning("参数错误")); } var anyRet = AnyInfo(model.ID); if (anyRet.state.ToString() != ResultType.success.ToString()) { return(anyRet); } var anyRetType = AnyInfoType(model.HeSuanMonth, model.ProcessFactoryCode, model.HeSuanCode); if (anyRetType.state.ToString() != ResultType.success.ToString()) { return(anyRetType); } try { using (DbTrans trans = Db.Context.BeginTransaction())//使用事务 { //修改信息 Repository <TbMonthCostHeSuan> .Update(trans, model, p => p.ID == model.ID); //修改信息 Repository <TbMonthCostHeSuanIncome> .Update(trans, incomeModel, p => p.HeSuanCode == model.HeSuanCode); if (costModel.Count > 0) { //删除历史明细信息 Repository <TbMonthCostHeSuanCost> .Delete(trans, p => p.HeSuanCode == model.HeSuanCode); //添加明细信息 Repository <TbMonthCostHeSuanCost> .Insert(trans, costModel); } if (otherCostModel.Count > 0) { //删除历史明细信息 Repository <TbMonthCostHeSuanOtherCost> .Delete(trans, p => p.HeSuanCode == model.HeSuanCode); //添加明细信息 Repository <TbMonthCostHeSuanOtherCost> .Insert(trans, otherCostModel); } trans.Commit();//提交事务 return(AjaxResult.Success()); } } catch (Exception ex) { return(AjaxResult.Error(ex.ToString())); } }
/// <summary> /// 新增数据 /// </summary> public AjaxResult Insert(TbMonthCostHeSuan model, TbMonthCostHeSuanIncome incomeModel, List <TbMonthCostHeSuanCost> costModel, List <TbMonthCostHeSuanOtherCost> otherCostModel) { if (model == null) { return(AjaxResult.Warning("参数错误")); } //判断信息是否存在 var anyRet = AnyInfoType(model.HeSuanMonth, model.ProcessFactoryCode, model.HeSuanCode); if (anyRet.state.ToString() != ResultType.success.ToString()) { return(anyRet); } model.InsertUserCode = OperatorProvider.Provider.CurrentUser.UserCode; try { using (DbTrans trans = Db.Context.BeginTransaction()) { //添加信息 Repository <TbMonthCostHeSuan> .Insert(trans, model); //添加信息 Repository <TbMonthCostHeSuanIncome> .Insert(trans, incomeModel); //添加明细信息 Repository <TbMonthCostHeSuanCost> .Insert(trans, costModel); if (otherCostModel.Count > 0) { //添加明细信息 Repository <TbMonthCostHeSuanOtherCost> .Insert(trans, otherCostModel); } trans.Commit(); return(AjaxResult.Success()); } } catch (Exception ex) { return(AjaxResult.Error(ex.ToString())); } }