public JsonResult GetOneOut(string ManuId)//获取菜单未添加的按钮 { //DataSet ds = OPBiz.ExecuteSqlToDataSet(" select * from RMS_Buttons where Id not in( select Id from Function_Buttons where Id='" + ManuId + "')"); //return Json(ds.Tables[0], JsonRequestBehavior.AllowGet); var mql = RMS_ButtonsSet.SelectAll().Where(RMS_ButtonsSet.Id.NotIn(RMS_MenuButtonsSet.Select(RMS_MenuButtonsSet.ButtonId).Where(RMS_MenuButtonsSet.ManuId.Equal(ManuId)))); List <RMS_Buttons> Rmodel = BDBiz.GetOwnList <RMS_Buttons>(mql); return(Json(Rmodel, JsonRequestBehavior.AllowGet)); }
public string SaveRoleOP(string RoleManus, string RoleManuButtons, string RoleId) { Guid roleid = Guid.Parse(RoleId); List <string> manu = RoleManus.Split('_').ToList(); int res = 0; var mql2 = RMS_RoleManusSet.RoleId.Equal(roleid); int f = RMBiz.Remove <RMS_RoleManusSet>(mql2); for (int i = 0; i < manu.Count; i++) { if (!string.IsNullOrEmpty(manu[i])) { RMS_RoleManus item = new RMS_RoleManus(); item.Id = Guid.NewGuid(); item.RoleId = roleid; item.ManuId = Guid.Parse(manu[i]); RMBiz.Add(item); res++; } } List <string> ManuButtons = RoleManuButtons.Split('_').ToList(); var mql = RMS_RoleManuButtonsSet.RoleId.Equal(roleid); int ff = RMBBiz.Remove <RMS_RoleManuButtonsSet>(mql); for (int i = 0; i < ManuButtons.Count; i++) { RMS_RoleManuButtons item = new RMS_RoleManuButtons(); item.Id = Guid.NewGuid(); string[] data = ManuButtons[i].Split(':'); if (!string.IsNullOrEmpty(data[0]) && !string.IsNullOrEmpty(data[1])) { item.RoleId = roleid; var sql = RMS_MenuButtonsSet.SelectAll().Where(RMS_MenuButtonsSet.ManuId.Equal(Guid.Parse(data[0])).And(RMS_MenuButtonsSet.ButtonId.Equal(Guid.Parse(data[1])))); RMS_MenuButtons bItem = MBBiz.GetEntity(sql); if (bItem != null) { item.MenuButtonsId = bItem.Id; } RMBBiz.Add(item); res++; } } if (res == manu.Count + ManuButtons.Count) { return("ok"); } else { return("Nok"); } }
/// <summary> /// //添加单按钮 /// </summary> /// <param name="btnId"></param> /// <param name="ManuId"></param> /// <returns></returns> public JsonResult AddManuBtn(string BtnId, string ManuId, string OrderNo) { var mql2 = RMS_MenuButtonsSet.SelectAll().Where(RMS_MenuButtonsSet.ButtonId.Equal(BtnId).And(RMS_MenuButtonsSet.ManuId.Equal(ManuId))); RMS_MenuButtons item = MBDBiz.GetEntity(mql2); if (item != null) { item.OrderNo = int.Parse(OrderNo); item.WhereExpression = RMS_MenuButtonsSet.Id.Equal(item.Id); // spmodel.GroupId = GroupId; if (MBDBiz.Update(item) > 0) { return(Json("OK", JsonRequestBehavior.AllowGet)); } } item = new RMS_MenuButtons(); item.Id = Guid.NewGuid(); item.ButtonId = Guid.Parse(BtnId); item.ManuId = Guid.Parse(ManuId); item.OrderNo = int.Parse(OrderNo); MBDBiz.Add(item); return(Json("OK", JsonRequestBehavior.AllowGet)); }
/// <summary> /// 获取每个菜单有的按钮 /// </summary> /// <returns></returns> public JsonResult GetMenuButtonsData() { List <RMS_MenuButtons> listMenuButtons = RDBiz.GetOwnList <RMS_MenuButtons>(RMS_MenuButtonsSet.SelectAll());//所有的菜单的按钮 return(Json(listMenuButtons)); }