/// <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()));
}
}
