/// <summary>
/// 修改
/// </summary>
/// <param name="model">数据模型</param>
public int Update(BsMenu model)
{
return(DBContext.Update <BsMenu>("agent_bsmenu", model)
.AutoMap(x => x.SysNo)
.Where(x => x.SysNo)
.Execute());
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">数据模型</param>
public JResult Update(BsMenu model)
{
var response = new JResult()
{
Status = false,
Message = "更新失败！"
};
try
{
var row = Using <IBsMenu>().Update(model);
if (row > 0)
{
response.Status = true;
response.Message = "更新成功！";
}
}
catch (Exception ex)
{
response.Message = ex.Message;
}
return(response);
}
/// <summary>
/// 插入
/// </summary>
/// <param name="model">数据模型</param>
public int Insert(BsMenu model)
{
return(DBContext.Insert <BsMenu>("agent_bsmenu", model)
.AutoMap(x => x.SysNo)
.ExecuteReturnLastId <int>("sysNo"));
}
/// <summary>
/// 插入
/// </summary>
/// <param name="request">菜单</param>
/// <param name="privileges">权限</param>
public JResult Save(SaveOrUpdateMenuRequest request, List <int> privileges)
{
var response = new JResult()
{
Status = false,
Message = "添加失败！"
};
using (var tran = new TransactionScope())
{
try
{
var menu = new BsMenu()
{
SysNo = request.SysNo,
Name = request.Name,
ParentSysNo = request.ParentSysNo,
IsNav = request.IsNav,
Url = request.URL,
DisplayOrder = request.DisplayOrder,
Description = request.Description,
Status = request.Status
};
if (request.SysNo > 0)
{
//删除菜单权限
Using <IBsMenuPermission>().DeleteByMenuSysNo(request.SysNo);
if (privileges != null && privileges.Any())
{
privileges.ForEach(item =>
{
if (Using <IBsMenuPermission>().Insert(new BsMenuPermission()
{
PermissionSysNo = item,
MenuSysNo = request.SysNo,
}) <= 0)
{
throw new Exception("添加菜单权限失败！");
}
});
}
var row = Using <IBsMenu>().Update(menu);
if (row > 0)
{
tran.Complete();
response.Status = true;
response.Message = "添加成功！";
}
else
{
throw new Exception("添加失败！");
}
}
else
{
var menuSysNo = Using <IBsMenu>().Insert(menu);
if (menuSysNo > 0)
{
if (privileges != null && privileges.Any())
{
privileges.ForEach(item =>
{
if (Using <IBsMenuPermission>().Insert(new BsMenuPermission()
{
PermissionSysNo = item,
MenuSysNo = menuSysNo,
}) <= 0)
{
throw new Exception("添加菜单权限失败！");
}
});
}
tran.Complete();
response.Status = true;
response.Message = "更新成功！";
}
else
{
throw new Exception("更新成功！");
}
}
}
catch (Exception ex)
{
response.Message = ex.Message;
}
}
return(response);
}
