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;
}
}
