public ActionResult SaveRoles(FormCollection f, P_SystemRoles info)
{
int count = 0;
if (info.Role_Id > 0)
{
count = SugarFactory.GetInstance().Updateable <P_SystemRoles>(info).ExecuteCommand();
}
else
{
count = SugarFactory.GetInstance().Insertable <P_SystemRoles>(info).ExecuteCommand();
}
SugarFactory.GetInstance().Deleteable <P_RolesToMenu>().Where(it => it.RTM_Roles_Code == info.Role_Code).ExecuteCommand();
if (!String.IsNullOrEmpty(info.MenuCodes))
{
string[] strs = info.MenuCodes.TrimEnd(',').Split(',');
foreach (string item in strs)
{
P_RolesToMenu rtm = new P_RolesToMenu();
rtm.RTM_Menu_Code = Guid.Parse(item);
rtm.RTM_Roles_Code = info.Role_Code;
SugarFactory.GetInstance().Insertable <P_RolesToMenu>(rtm).ExecuteCommand();
}
}
if (info.Role_Id == 0)
{
if (count > 0)
{
return(Json(TipHelper.JsonData("新增角色成功！", "", IsAlertTip.No, TipType.Success, AlertTipPageType.ThisPage, OperateTypeAfterTip.CloseDialogAndRefreshThisPage)));
}
else
{
return(Json(TipHelper.JsonData("新增角色失败！", "", IsAlertTip.No, TipType.Success, AlertTipPageType.ThisPage, OperateTypeAfterTip.CloseDialogAndRefreshThisPage)));
}
}
else
{
if (count > 0)
{
return(Json(TipHelper.JsonData("更新角色成功！", "", IsAlertTip.No, TipType.Success, AlertTipPageType.ThisPage, OperateTypeAfterTip.CloseDialogAndRefreshThisPage)));
}
else
{
return(Json(TipHelper.JsonData("更新角色失败！", "", IsAlertTip.No, TipType.Success, AlertTipPageType.ThisPage, OperateTypeAfterTip.CloseDialogAndRefreshThisPage)));
}
}
}
public ActionResult AddRoles(string code)
{
ISugarQueryable <P_SystemMenu> sql = SugarFactory.GetInstance().Queryable <P_SystemMenu>().Where(it => it.Menu_Parent != 0).OrderBy(it => it.Menu_Id, SqlSugar.OrderByType.Asc);
P_SystemRoles sr = new P_SystemRoles();
if (String.IsNullOrEmpty(code))
{
ViewBag.MenuList = sql.ToList();
}
else
{
sr = SugarFactory.GetInstance().Queryable <P_SystemRoles>().Where(it => it.Role_Code == Guid.Parse(code)).Single();
List <P_SystemMenu> menulist = sql.AddJoinInfo("P_RolesToMenu", "rm", "rm.RTM_Menu_Code=Menu_Code and rm.RTM_Roles_Code='" + code + "'", JoinType.Left).Select("P_SystemMenu.*,RTM_Id").ToList();
ViewBag.MenuList = menulist;
}
return(View(sr));
}
