private void GetMenuTree(HttpContext context, string btn) { if (btn != "show") { context.Response.Write("[]"); return; } try { string treeJsonStr = "[{\"id\":0,\"text\":\"根菜单\",\"children\":"; BLL.System.sys_Menu bll = new BLL.System.sys_Menu(); DataTable dt = bll.GetList("").Tables[0]; if (dt != null && dt.Rows.Count > 0) { treeJsonStr += DtToTreeJson(dt, "ID", "MenuName", "SupId", "SortId", "0", "0"); } else { treeJsonStr += "\"\""; } treeJsonStr += "}]"; context.Response.Write(treeJsonStr); } catch { context.Response.Write("[]"); } }
private void GetData(HttpContext context, string btn) { if (btn != "show") { context.Response.Write("{\"status\":\"0.2\",\"msg\":\"对不起,您没有操作权限!\"}"); return; } try { int menuId = RequestHelper.GetInt("id", 1); BLL.System.sys_Menu bll = new BLL.System.sys_Menu(); DataTable dt = bll.GetList(menuId).Tables[0]; if (dt.Rows.Count == 0) { context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起,该条数据已被其他人删除!\"}"); return; } string rowsStr = Utils.ToJson(dt); DataTable pageDT = bll.GetPageList(menuId).Tables[0]; StringBuilder jsonStr = new StringBuilder(); jsonStr.Append("{\"status\":\"1\",\"msg\":\"数据获取成功!\",\"info\":"); jsonStr.Append(rowsStr); jsonStr.Append(",\"pageInfo\":{\"total\":" + pageDT.Rows.Count + ",\"rows\":" + Utils.ToJson(pageDT) + "}"); jsonStr.Append("}"); context.Response.Write(jsonStr); } catch (Exception e) { context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起,系统出错:" +Utils.HtmlEncode(e.Message) + "\"}"); return; } }
private void GetList(HttpContext context, string btn) { if (btn != "show") { context.Response.Write("{\"status\":\"0.2\",\"msg\":\"对不起,您没有操作权限!\"}"); return; } try { BLL.System.sys_Menu bll = new BLL.System.sys_Menu(); DataTable dt = bll.GetList("").Tables[0]; StringBuilder jsonStr = new StringBuilder(); jsonStr.Append("{\"status\":\"1\",\"msg\":\"数据获取成功!\",\"info\":"); jsonStr.Append("{\"total\":" + dt.Rows.Count + ",\"rows\":["); string flagDel = ""; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["FlagDel"].ToString() == "0") { flagDel = "否"; } else { flagDel = "是"; } jsonStr.Append("{\"ID\":" + dt.Rows[i]["ID"].ToString() + ",\"MenuName\":\"" + dt.Rows[i]["MenuName"].ToString() + "\",\"LinkUrl\":\"" + dt.Rows[i]["LinkUrl"].ToString() + "\",\"LevelId\":\"" + dt.Rows[i]["LevelId"].ToString() + "\",\"SortId\":\"" + dt.Rows[i]["SortId"].ToString() + "\",\"PowerList\":\"" + dt.Rows[i]["PowerList"].ToString() + "\",\"FlagDel\":\"" + flagDel + "\""); if (dt.Rows[i]["SupId"].ToString() != "0") { jsonStr.Append(",\"_parentId\":" + dt.Rows[i]["SupId"].ToString()); } if (dt.Select("SupId=" + dt.Rows[i]["ID"].ToString()).Length > 0) { jsonStr.Append(",\"state\":\"closed\""); } jsonStr.Append("}"); if (i < dt.Rows.Count - 1) { jsonStr.Append(","); } } } jsonStr.Append("]}}"); context.Response.Write(jsonStr); } catch (Exception e) { context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起,系统出错:" +Utils.HtmlEncode(e.Message) + "\"}"); return; } }
private void GetData(HttpContext context, string btn) { if (btn != "show") { context.Response.Write("{\"status\":\"0.2\",\"msg\":\"对不起,您没有操作权限!\"}"); return; } try { int roleId = RequestHelper.GetInt("id", 0); string roleStr = ""; BLL.System.sys_Role bll = new BLL.System.sys_Role(); if (roleId != 0) { DataTable dt = bll.GetList(roleId).Tables[0]; if (dt.Rows.Count == 0) { context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起,该条数据已被其他人删除!\"}"); return; } roleStr = Utils.ToJson(dt); } Model.System.sys_LoginUser loginUserModel = BaseWeb.GetLoginInfo(); StringBuilder strWhere = new StringBuilder(); if (!loginUserModel.IsAdmin) { strWhere.Append(" and MenuType<>'system'"); } BLL.System.sys_Menu menuBll = new BLL.System.sys_Menu(); DataTable menuDT = menuBll.GetList(strWhere.ToString()).Tables[0]; DataTable powerDT = bll.GetRolePowerAllList(roleId).Tables[0]; string menuStr = DtToRolePowerJson(menuDT, powerDT, 0); menuStr = "[" + menuStr.Substring(1) + "]"; StringBuilder jsonStr = new StringBuilder(); if (roleId != 0) { jsonStr.Append("{\"status\":\"1\",\"msg\":\"数据获取成功!\",\"roleInfo\":" + roleStr + ",\"menuInfo\":" + menuStr + "}"); } else { jsonStr.Append("{\"status\":\"1\",\"msg\":\"数据获取成功!\",\"roleInfo\":\"\",\"menuInfo\":" + menuStr + "}"); } context.Response.Write(jsonStr); } catch (Exception e) { context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起,系统出错:" +Utils.HtmlEncode(e.Message) + "\"}"); return; } }
/// <summary> /// 获取页面ID /// </summary> /// <param name="menuId"></param> /// <param name="url"></param> /// <returns></returns> public static int GetPageId(string menuId, string url) { int pageId = 0; BLL.System.sys_Menu menuBll = new BLL.System.sys_Menu(); DataTable menuPageDT = menuBll.GetListByCache_sys_MenuPage().Tables[0]; DataRow[] pageDR = menuPageDT.Select("MenuId=" + menuId + " and '" + url + "' like '%' + PageUrl +'%'"); if (pageDR.Length > 0) { pageId = Utils.ObjToInt(pageDR[0]["PageId"], 0); } return(pageId); }
private void GetHomePage(HttpContext context) { try { string loginSalt = RequestHelper.GetQueryString("LoginSalt"); Model.System.sys_LoginUser loginUserModel = BaseWeb.GetLoginInfo(); if (loginUserModel == null || loginUserModel.Salt != loginSalt) { context.Response.Write("{\"status\":\"0.1\",\"msg\":\"对不起,登录超时,请重新登录!\"}"); return; } string vt = new BLL.System.sys_Config().loadConfig().webversiontime; BLL.System.sys_Mail_Send mailBll = new BLL.System.sys_Mail_Send(); int receiveNoRead = mailBll.GetReceiveNoRead(loginUserModel.ID); BLL.sys_Bulletin bll = new BLL.sys_Bulletin(); int recordNumBulletin = RequestHelper.GetInt("recordNumBulletin", 0); string strWhere = ""; DataTable bulletinDT = bll.GetListByPower(strWhere, recordNumBulletin, loginUserModel.DepId).Tables[0]; string bulletinInfo = Utils.ToJson(bulletinDT); BLL.System.sys_Menu menuBll = new BLL.System.sys_Menu(); DataTable todoDT = menuBll.GetTodoList(loginUserModel.ID).Tables[0]; string todoInfo = Utils.ToJson(todoDT); DataTable nodoDT = menuBll.GetNodoList(loginUserModel.ID).Tables[0]; string nodoInfo = Utils.ToJson(nodoDT); StringBuilder jsonStr = new StringBuilder(); jsonStr.Append("{\"status\":\"1\",\"msg\":\"数据获取成功!\",\"vt\":\"" + vt + "\""); jsonStr.Append(",\"receiveNoRead\":" + receiveNoRead); jsonStr.Append(",\"bulletinInfo\":" + bulletinInfo); jsonStr.Append(",\"todoInfo\":" + todoInfo); jsonStr.Append(",\"nodoInfo\":" + nodoInfo); jsonStr.Append("}"); context.Response.Write(jsonStr); } catch (Exception e) { context.Response.Write("{\"status\":\"0\",\"msg\":\"" + e.Message + "\"}"); } }
private void GetData(HttpContext context, string btn) { if (btn != "show") { context.Response.Write("{\"status\":\"0.2\",\"msg\":\"对不起,您没有操作权限!\"}"); return; } int perId = RequestHelper.GetInt("id", 0); if (perId == 0) { context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起,人员ID不能为空!\"}"); return; } try { BLL.System.sys_PersonPower bll = new BLL.System.sys_PersonPower(); Model.System.sys_LoginUser loginUserModel = BaseWeb.GetLoginInfo(); StringBuilder strWhere = new StringBuilder(); if (!loginUserModel.IsAdmin) { strWhere.Append(" and MenuType<>'system'"); } BLL.System.sys_Menu menuBll = new BLL.System.sys_Menu(); DataTable menuDT = menuBll.GetList(strWhere.ToString()).Tables[0]; DataTable powerDT = bll.GetPerPowerAllList(perId).Tables[0]; string menuStr = DtToRolePowerJson(menuDT, powerDT, 0); menuStr = "[" + menuStr.Substring(1) + "]"; StringBuilder jsonStr = new StringBuilder(); jsonStr.Append("{\"status\":\"1\",\"msg\":\"数据获取成功!\",\"menuInfo\":" + menuStr + "}"); context.Response.Write(jsonStr); } catch (Exception e) { context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起,系统出错:" + Utils.HtmlEncode(e.Message) + "\"}"); return; } }
private void GetMenu(HttpContext context) { try { string loginSalt = RequestHelper.GetQueryString("LoginSalt"); if (loginSalt == "") { context.Response.Write("身份验证失败"); return; } Model.System.sys_LoginUser loginUserModel = BaseWeb.GetLoginInfo(); if (loginUserModel == null || loginUserModel.Salt != loginSalt) { //context.Response.Write("{\"status\":\"0\",\"msg\":\"身份验证失败!\"}"); context.Response.Write("身份验证失败"); return; } string htmlStr = ""; DataTable dt = null; if (loginUserModel.IsAdmin == true) { dt = new BLL.System.sys_Menu().GetList("").Tables[0]; } else { dt = new BLL.System.sys_Person().GetUserMenu(loginUserModel.ID).Tables[0]; } DataTable btnDT = new BLL.System.sys_Menu().GetNoPowerBtn(loginUserModel.ID).Tables[0]; int levelOpenId = dt.Select("levelId=1").Length > 4 ? 1 : 2; htmlStr = AddNode(dt, btnDT, 1, levelOpenId, "0", "ID", "menuName", "supId", "sortId", "linkUrl", "levelId"); context.Response.Write(htmlStr); } catch { context.Response.Write("身份验证失败"); return; } }
private void DelData(HttpContext context, string btn) { if (btn != "btnDel") { context.Response.Write("{\"status\":\"0.2\",\"msg\":\"对不起,您没有操作权限!\"}"); return; } string idStr = RequestHelper.GetString("idStr"); string nameStr = RequestHelper.GetString("nameStr"); if (idStr == "") { context.Response.Write("{\"status\":\"0\",\"msg\":\"请选择需要删除的记录!\"}"); return; } BLL.System.sys_Menu bll = new BLL.System.sys_Menu(); Model.System.sys_LoginUser loginUserModel = BaseWeb.GetLoginInfo(); string operaMessage = ""; string status = "0"; string operaAction = ""; string operaMemo = ""; try { if (bll.DeleteList(PageValidate.SafeLongFilter(idStr, 0), out operaMessage)) { status = "1"; operaAction = Enums.ActionEnum.Delete.ToString(); operaMemo = "删除菜单:" + nameStr + "(" + idStr + ")"; //写入操作日志 BaseWeb.AddOpera(loginUserModel, int.Parse(RequestHelper.GetQueryString("MenuId")), operaAction, operaMemo); } context.Response.Write("{\"status\":\"" + status + "\",\"msg\":\"" + operaMessage + "\"}"); } catch (Exception e) { context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起,系统出错:" +Utils.HtmlEncode(e.Message) + "\"}"); return; } }
private void GetMenuTreeNoRoot(HttpContext context, string btn) { if (btn != "show") { context.Response.Write(""); return; } try { string treeJsonStr = "{}"; BLL.System.sys_Menu bll = new BLL.System.sys_Menu(); DataTable dt = bll.GetList("").Tables[0]; if (dt != null && dt.Rows.Count > 0) { treeJsonStr = DtToTreeJson(dt, "ID", "MenuName", "SupId", "SortId", "0", "0"); } context.Response.Write(treeJsonStr); } catch { context.Response.Write("{}"); } }
/// <summary> /// 得到界面按钮列表 重新获取数据 /// </summary> /// <param name="perId"></param> /// <param name="pageId"></param> /// <returns>string[] 包含两列 第一列为btn,第二列为0,1;0没有权限,1有权限</returns> public static List <string[]> GetPageElementList(int perId, int pageId, out string roleIdStr) { List <string[]> pageElementPowerList = new List <string[]>(); string[] item; roleIdStr = ""; if (pageId == 0) { return(pageElementPowerList); } BLL.System.sys_Menu menuBll = new BLL.System.sys_Menu(); DataTable menuPageElementDT = menuBll.GetListByCache_sys_MenuPageElement().Tables[0]; DataRow[] powerDR = menuPageElementDT.Select("PageId=" + pageId); int powerCount = 0; for (int i = 0; i < powerDR.Length; i++) { string btn = powerDR[i]["ElementName"].ToString(); item = new string[] { btn, "1" }; if (CheckListContain(pageElementPowerList, item) == 0) { powerCount = 0; DataTable personRoleDT = new BLL.System.sys_Person().GetListByCache_sys_PersonRole(perId).Tables[0]; for (int j = 0; j < personRoleDT.Rows.Count; j++) { string tmpRoleIdstr = ",Cache_sys_RolePower_" + personRoleDT.Rows[j]["RoleId"].ToString(); if (!(roleIdStr + ",").Contains(tmpRoleIdstr + ",")) { roleIdStr += tmpRoleIdstr; } if (powerCount == 0) { DataTable rolePowerDT = new BLL.System.sys_Role().GetListByCache_sys_RolePower(Utils.ObjToInt(personRoleDT.Rows[j]["RoleId"], 0)).Tables[0]; powerCount += rolePowerDT.Select("PowerId=" + powerDR[i]["PowerId"].ToString()).Length; } } if (powerCount == 0) { DataTable personPowerDT = new BLL.System.sys_PersonPower().GetListByCache_sys_PersonPower(perId).Tables[0]; powerCount = personPowerDT.Select("PowerId=" + powerDR[i]["PowerId"].ToString()).Length; } item = new string[2] { btn, "0" }; int index = CheckListContain(pageElementPowerList, item); if (index > 0) { if (powerCount > 0) { pageElementPowerList.RemoveAt(index - 1); pageElementPowerList.Add(new string[] { btn, "1" }); } } else { if (powerCount > 0) { pageElementPowerList.Add(new string[] { btn, "1" }); } else { pageElementPowerList.Add(new string[] { btn, "0" }); } } } } return(pageElementPowerList); }
private void SaveData(HttpContext context, string btn) { if (btn != "btnSave") { context.Response.Write("{\"status\":\"0.2\",\"msg\":\"对不起,您没有操作权限!\"}"); return; } string id = RequestHelper.GetString("id"); string supId = RequestHelper.GetString("supId"); string menuName = RequestHelper.GetString("menuName"); string linkUrl = RequestHelper.GetString("linkUrl"); string sortId = RequestHelper.GetString("sortId"); string flagDel = RequestHelper.GetString("flagDel"); string powerList = RequestHelper.GetString("powerList"); string pageStr1 = RequestHelper.GetString("pageStr1"); string pageStr2 = RequestHelper.GetString("pageStr2"); string pageStr3 = RequestHelper.GetString("pageStr3"); string pageStr4 = RequestHelper.GetString("pageStr4"); string pageStr5 = RequestHelper.GetString("pageStr5"); string pageStr6 = RequestHelper.GetString("pageStr6"); string pageStr7 = RequestHelper.GetString("pageStr7"); string pageStr8 = RequestHelper.GetString("pageStr8"); if (supId == "") { context.Response.Write("{\"status\":\"0\",\"msg\":\"上级菜单编码不能为空!\"}"); return; } if (menuName == "") { context.Response.Write("{\"status\":\"0\",\"msg\":\"菜单名称不能为空!\"}"); return; } if (flagDel == "") { context.Response.Write("{\"status\":\"0\",\"msg\":\"是否隐藏不能为空!\"}"); return; } Model.System.sys_LoginUser loginUserModel = BaseWeb.GetLoginInfo(); BLL.System.sys_Menu bll = new BLL.System.sys_Menu(); Model.System.sys_Menu model = new Model.System.sys_Menu(); model.ID = Utils.StrToInt(id,0); model.MenuName = menuName; model.LinkUrl = linkUrl; model.SortId = int.Parse(sortId); model.SupId = int.Parse(supId); model.PowerList = powerList; model.FlagDel = Utils.StrToInt(flagDel, 0); DataTable dt = bll.GetList(int.Parse(supId)).Tables[0]; if (dt.Rows.Count > 0) { model.SupList = dt.Rows[0]["SupList"].ToString() + supId + ","; model.LevelId = Utils.ObjToInt(dt.Rows[0]["levelId"], 1) + 1; } else { model.SupList = supId + ","; model.LevelId = 1; } model.OperaName = loginUserModel.PerName; model.OperaTime = DateTime.Now; string operaMessage = ""; string status = "0"; string operaAction = ""; string operaMemo = ""; try { if (id == "") { model.ID = bll.Add(model, pageStr1, pageStr2, pageStr3, pageStr4, pageStr5, pageStr6, pageStr7, pageStr8, out operaMessage); if (model.ID > 0) { status = "1"; operaAction = Enums.ActionEnum.Add.ToString(); operaMemo = "新增菜单:" + model.MenuName + "(" + model.ID + ")"; //写入操作日志 BaseWeb.AddOpera(loginUserModel, int.Parse(RequestHelper.GetQueryString("MenuId")), operaAction, operaMemo); } } else { if (bll.Update(model, pageStr1, pageStr2, pageStr3, pageStr4, pageStr5, pageStr6, pageStr7, pageStr8, out operaMessage)) { status = "1"; operaAction = Enums.ActionEnum.Edit.ToString(); operaMemo = "修改菜单:" + model.MenuName + "(" + model.ID + ")"; //写入操作日志 BaseWeb.AddOpera(loginUserModel, int.Parse(RequestHelper.GetQueryString("MenuId")), operaAction, operaMemo); } } context.Response.Write("{\"status\":\"" + status + "\",\"msg\":\"" + operaMessage + "\"}"); return; } catch (Exception e) { context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起,系统出错:" + Utils.HtmlEncode(e.Message) + "\"}"); return; } }