/// <summary>
/// 创建角色与菜单对应关系信息
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public string CreateMIR(MIREditModel info)
{
try
{
if (info == null || string.IsNullOrEmpty(info.roleInfoId))
{
throw new Exception("角色Id不能为空！");
}
RoleInfo role = _sql.Search <RoleInfo>(info.roleInfoId);
_sql.OpenDb();
_sql.BeginTrans();
_sql.Execute("DELETE FROM MenuInRole WHERE RoleInfoId = @id", new Dictionary <string, object> {
{ "@id", info.roleInfoId }
});
if (info.menuInfoIds != null && info.menuInfoIds.Length > 0)
{
foreach (string menuInfoId in info.menuInfoIds)
{
MenuInfo menu = _sql.Search <MenuInfo>(menuInfoId);
MenuInRole main = new MenuInRole();
main.RoleInfoId = role.RoleInfoId;
main.RoleCode = role.RoleCode;
main.MenuInfoId = menu.MenuInfoId;
main.MenuCode = menu.MenuCode;
_sql.Create(main);
}
}
_sql.Commit();
return(Constants.SaveSuccessMssg);
}
catch (Exception ex)
{
_sql.Rollback();
_log.Error(ex);
throw ex;
}
finally
{
_sql.CloseDb();
}
}
public void AddUpdateMenuInRole(MenuInRoleModel model)
{
DeleteMenuForRole(model.RoleId);
List <MenuInRole> urList = new List <MenuInRole>();
using (var db = new PCVEntities())
{
if (model.MenuId.IsNotBlank())
{
foreach (var item in model.MenuId)
{
MenuInRole oneRoleMenu = new MenuInRole();
oneRoleMenu.RoleId = model.RoleId;
oneRoleMenu.MenuId = item.To <long>();
oneRoleMenu.CreatedDate = DateTime.Now;
oneRoleMenu.CreatedBy = MySession.Current.UserName;
urList.Add(oneRoleMenu);
}
db.MenuInRole.AddRange(urList);
db.SaveChanges();
}
}
}
