public void getUserMenuC(List <int> listMenuId, out List <int> listMenuIdC) { string s = string.Empty; foreach (int item in listMenuId) { s += "'" + item + "',"; } s = s.Length > 0 ? s.Remove(s.Length - 1, 1) : s; IDataParameter[] iparaMenuC = new IDataParameter[] { new SqlParameter("roleId", SqlDbType.Int, 4), new SqlParameter("menuId", SqlDbType.NVarChar, 500) }; iparaMenuC[0].Value = us.User.personaId; iparaMenuC[1].Value = s; listMenuIdC = new List <int>(); //目录ID model.menu menuMdC = new model.menu(); bll.menubll menuBllC = new bll.menubll(); List <model.menu> listMenuC = menuBllC.getMenu(iparaMenuC, "menuSelectCC");//子菜单 foreach (var item in listMenuC) { listMenuIdC.Add(item.Id); } if (listMenuC.Count == 0) { listMenuIdC.Add(9999); } us.MenuIdC = listMenuIdC; }
/// <summary> /// 得到一个对象实体 /// </summary> public List <model.menu> DataRowToModel(DataRowCollection rowCollection) { List <model.menu> list = new List <model.menu>(); foreach (DataRow row in rowCollection) { model.menu modelMd = new model.menu(); if (row != null) { if (row["Id"].ToString() != null && row["Id"].ToString() != "") { modelMd.Id = int.Parse(row["Id"].ToString()); } if (row["menuName"] != null) { modelMd.menuName = row["menuName"].ToString(); } if (row["MenuSrc"] != null) { modelMd.MenuSrc = row["MenuSrc"].ToString(); } if (row["MenuLevel"] != null && row["MenuLevel"].ToString() != "") { modelMd.MenuLevel = int.Parse(row["MenuLevel"].ToString()); } if (row["MenuIndex"] != null && row["MenuIndex"].ToString() != "") { modelMd.MenuIndex = int.Parse(row["MenuIndex"].ToString()); } if (row["UserId"] != null && row["UserId"].ToString() != "") { modelMd.UserId = int.Parse(row["UserId"].ToString()); } if (row["Def1"] != null) { modelMd.Def1 = row["Def1"].ToString(); } if (row["Def2"] != null) { modelMd.Def2 = row["Def2"].ToString(); } if (row["Def3"] != null) { modelMd.Def3 = row["Def3"].ToString(); } if (row["Def4"] != null) { modelMd.Def4 = row["Def4"].ToString(); } if (row["Def5"] != null) { modelMd.Def5 = row["Def5"].ToString(); } } list.Add(modelMd); } return(list); }
/// <summary> /// 主菜单权限控制 /// </summary> /// <param name="roleId"></param> /// <returns></returns> public List <int> getUserMenuF1(int roleId) { IDataParameter[] iparaMenu = new IDataParameter[] { new SqlParameter("roleId", SqlDbType.Int, 4), }; iparaMenu[0].Value = roleId; List <int> listMenuId = new List <int>(); //目录ID model.menu menuMd = new model.menu(); bll.menubll menuBll = new bll.menubll(); List <model.menu> listMenu = menuBll.getMenu(iparaMenu, "menuSelectFF");//主菜单 foreach (var item in listMenu) { listMenuId.Add(item.Id); } if (listMenu.Count == 0) { listMenuId.Add(9999); } menuBll = null; menuMd = null; return(listMenuId); }
/// <summary> /// 获取菜单名称 /// </summary> /// <returns></returns> public string getMenuName() { bll.menubll menuBll = new bll.menubll(); int id = helpcommon.ParmPerportys.GetNumParms(Request.Form["menuId"].ToString()); model.menu mdMenu = menuBll.getMenuName(id); return(mdMenu.menuName); }
public model.menu getMenuName(int id) { model.menu mdMenu = new model.menu(); model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext(); var s = from c in context.menu where c.Id == id select c; foreach (var item in s) { mdMenu = item; } return(mdMenu); }
/// <summary> /// 编辑菜单列表 /// </summary> /// <returns></returns> public ActionResult editdata(int id) { bll.menubll menuBll = new bll.menubll(); IDataParameter[] ipara = new IDataParameter[] { new SqlParameter("id", SqlDbType.Int, 4) }; ipara[0].Value = id; List <model.menu> list = menuBll.getMenu(ipara, "menuEdit"); model.menu menuMd = new model.menu(); menuMd = list.Where(c => c.Id == id).ToList()[0]; return(View(menuMd)); }
/// <summary> /// 删除用户 /// </summary> /// <returns></returns> public string del(int id) { string s = string.Empty; try { model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext(); model.menu p = (from c in context.menu where c.Id == id select c).FirstOrDefault(); context.menu.DeleteOnSubmit(p); context.SubmitChanges(); s = "删除成功!"; } catch (Exception ex) { s = "删除失败!"; } return(s); }
public void getUserMenuF(out List <int> listMenuId) { IDataParameter[] iparaMenu = new IDataParameter[] { new SqlParameter("roleId", SqlDbType.Int, 4), }; iparaMenu[0].Value = us.User.personaId; listMenuId = new List <int>(); //目录ID model.menu menuMd = new model.menu(); bll.menubll menuBll = new bll.menubll(); List <model.menu> listMenu = menuBll.getMenu(iparaMenu, "menuSelectFF");//主菜单 foreach (var item in listMenu) { listMenuId.Add(item.Id); } if (listMenu.Count == 0) { listMenuId.Add(9999); } us.MenuIdF = listMenuId; }
/// <summary> /// 子菜单权限控制 /// </summary> /// <param name="listMenuId"></param> /// <param name="roleId"></param> /// <returns></returns> public List <int> getUserMenuC1(List <int> listMenuId, int roleId) { List <int> listMenuIdC = new List <int>(); //菜单ID string s = string.Empty; foreach (int item in listMenuId) { s += "'" + item + "',"; } s = s.Length > 0 ? s.Remove(s.Length - 1, 1) : s; IDataParameter[] iparaMenuC = new IDataParameter[] { new SqlParameter("roleId", SqlDbType.Int, 4), new SqlParameter("menuId", SqlDbType.NVarChar, 500) }; iparaMenuC[0].Value = roleId; iparaMenuC[1].Value = s; model.menu menuMdC = new model.menu(); bll.menubll menuBllC = new bll.menubll(); List <model.menu> listMenuC = menuBllC.getMenu(iparaMenuC, "menuSelectCC");//子菜单 foreach (var item in listMenuC) { listMenuIdC.Add(item.Id); } if (listMenuC.Count == 0) { listMenuIdC.Add(9999); } menuBllC = null; menuMdC = null; return(listMenuIdC); }