You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
882 lines
40 KiB
882 lines
40 KiB
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Linq;
|
|
using System.Web;
|
|
|
|
namespace FangYar.WebUI.ashx
|
|
{
|
|
/// <summary>
|
|
/// MenuHandler 的摘要说明
|
|
/// </summary>
|
|
public class ZYMenuHandler : IHttpHandler
|
|
{
|
|
|
|
private FangYar.BLL.BaseUserBLL bll = new BLL.BaseUserBLL();
|
|
private FangYar.BLL.FIRE.FIRE_ORG bll_org = new FangYar.BLL.FIRE.FIRE_ORG();
|
|
public void ProcessRequest(HttpContext context)
|
|
{
|
|
context.Response.ContentType = "text/json";
|
|
string action = context.Request.Params["Action"];
|
|
string returnstr = "";
|
|
switch (action)
|
|
{
|
|
case "List":
|
|
returnstr = GetUserList(context);
|
|
break;
|
|
case "Add":
|
|
returnstr = AddUser(context);
|
|
break;
|
|
case "Edit":
|
|
returnstr = DelUser(context);
|
|
break;
|
|
case "Del":
|
|
returnstr = DelUser(context);
|
|
break;
|
|
case "EditPwd":
|
|
returnstr = DelUser(context);
|
|
break;
|
|
case "GetUserMenu":
|
|
returnstr = GetUserMenu(context);
|
|
break;
|
|
case "typegetmenu":
|
|
returnstr = typegetmenu(context);
|
|
break;
|
|
case "GetUserMenuNoAuth":
|
|
returnstr = GetUserMenuNoAuth(context);
|
|
break;
|
|
}
|
|
context.Response.Write(returnstr);
|
|
}
|
|
//查询
|
|
private string GetUserList(HttpContext context)
|
|
{
|
|
string returnstr = "";
|
|
try
|
|
{
|
|
string keywords = context.Request.Params["keywords"];
|
|
string where = null;
|
|
if (!string.IsNullOrEmpty(keywords))
|
|
{
|
|
where = "USERS_UID like '" + keywords + "' or USERS_NAME like '" + keywords + "' ";
|
|
}
|
|
returnstr = "{\"code\":0,\"msg\":\"\",";
|
|
|
|
List<FangYar.Model.BaseUserModel> list = bll.QueryList(1, 10, where, null);
|
|
returnstr += "\"count\":" + list.Count + ",\"data\":";
|
|
if (list.Count == 0)
|
|
{
|
|
returnstr += "[]";
|
|
}
|
|
else
|
|
{
|
|
returnstr += FangYar.Common.JsonHelper.ToJson(list);
|
|
}
|
|
returnstr += "}";
|
|
}
|
|
catch
|
|
{
|
|
returnstr = "{\"code\":0,\"msg\":\"error\",\"count\":0,\"data\":[]";
|
|
}
|
|
return returnstr;
|
|
}
|
|
//添加
|
|
private string AddUser(HttpContext context)
|
|
{
|
|
string returnstr = "";
|
|
int code = -1;
|
|
string msg = "";
|
|
try
|
|
{
|
|
string userUID = context.Request.Params["userUID"];
|
|
string userPwd = context.Request.Params["userPwd"];
|
|
string userType = context.Request.Params["userType"];
|
|
string userName = context.Request.Params["userName"];
|
|
|
|
if (string.IsNullOrEmpty(userUID))
|
|
{
|
|
msg = "账号不能为空！";
|
|
}
|
|
else if (userUID.Length < 4)
|
|
{
|
|
msg = "账号长度最少为4个字符！";
|
|
}
|
|
|
|
else if (string.IsNullOrEmpty(userPwd))
|
|
{
|
|
msg = "密码不能为空！";
|
|
}
|
|
else if (userUID.Length < 4)
|
|
{
|
|
msg = "密码长度最少为4个字符！";
|
|
}
|
|
else if (string.IsNullOrEmpty(userName))
|
|
{
|
|
msg = "名称不能为空！";
|
|
}
|
|
else if (bll.CheckLoginByUserID(userUID) != null)
|
|
{
|
|
msg = "用户已存在！";
|
|
}
|
|
else
|
|
{
|
|
FangYar.Model.BaseUserModel model = new Model.BaseUserModel();
|
|
model.ID = Guid.NewGuid().ToString("N");
|
|
model.USERS_UID = userUID;
|
|
model.USERS_PWD = FangYar.Common.Md5.GetMD5String(userPwd);
|
|
model.USERS_NAME = userName;
|
|
model.USERS_TYPE = userType;
|
|
if (bll.AddUser(model))
|
|
{
|
|
msg = "添加成功！";
|
|
code = 1;
|
|
}
|
|
else
|
|
{
|
|
msg = "添加失败！";
|
|
|
|
}
|
|
}
|
|
|
|
}
|
|
catch
|
|
{
|
|
msg = "添加失败！";
|
|
}
|
|
returnstr = "{\"code\":" + code + ",\"msg\":\"" + msg + "\"}";
|
|
return returnstr;
|
|
}
|
|
//修改
|
|
private string EditUser(HttpContext context)
|
|
{
|
|
string returnstr = "";
|
|
int code = -1;
|
|
string msg = "";
|
|
try
|
|
{
|
|
string ID = context.Request.Params["ID"];
|
|
string userUID = context.Request.Params["userUID"];
|
|
string userPwd = context.Request.Params["userPwd"];
|
|
string userType = context.Request.Params["userType"];
|
|
string userName = context.Request.Params["userName"];
|
|
|
|
FangYar.Model.BaseUserModel model = bll.GetUserByID(ID);
|
|
if (model == null)
|
|
{
|
|
msg = "用户不存在！";
|
|
}
|
|
else
|
|
{
|
|
|
|
model.USERS_UID = userUID;
|
|
model.USERS_PWD = FangYar.Common.Md5.GetMD5String(userPwd);
|
|
model.USERS_NAME = userName;
|
|
model.USERS_TYPE = userType;
|
|
if (bll.AddUser(model))
|
|
{
|
|
msg = "修改成功！";
|
|
code = 1;
|
|
}
|
|
else
|
|
{
|
|
msg = "修改失败！";
|
|
|
|
}
|
|
}
|
|
|
|
}
|
|
catch
|
|
{
|
|
msg = "修改失败！";
|
|
}
|
|
returnstr = "{\"code\":" + code + ",\"msg\":\"" + msg + "\"}";
|
|
return returnstr;
|
|
}
|
|
//删除
|
|
private string DelUser(HttpContext context)
|
|
{
|
|
string returnstr = "";
|
|
int code = -1;
|
|
string msg = "";
|
|
try
|
|
{
|
|
string UIDList = context.Request.Params["UIDList"];
|
|
if (bll.DeleteUser(UIDList))
|
|
{
|
|
msg = "删除成功！";
|
|
code = 1;
|
|
}
|
|
else
|
|
{
|
|
msg = "删除失败！";
|
|
}
|
|
}
|
|
catch
|
|
{
|
|
msg = "删除失败！";
|
|
}
|
|
returnstr = "{\"code\":" + code + ",\"msg\":\"" + msg + "\"}";
|
|
return returnstr;
|
|
}
|
|
//修改密码
|
|
private string EditPwd(HttpContext context)
|
|
{
|
|
string returnstr = "";
|
|
int code = -1;
|
|
string msg = "";
|
|
try
|
|
{
|
|
string ID = context.Request.Params["ID"];
|
|
string userUID = context.Request.Params["userUID"];
|
|
string userPwd = context.Request.Params["userPwd"];
|
|
string userType = context.Request.Params["userType"];
|
|
string userName = context.Request.Params["userName"];
|
|
FangYar.Model.BaseUserModel model = bll.GetUserByID(ID);
|
|
if (string.IsNullOrEmpty(userPwd))
|
|
{
|
|
msg = "密码不能为空！";
|
|
}
|
|
else if (userUID.Length < 4)
|
|
{
|
|
msg = "密码长度最少为4个字符！";
|
|
}
|
|
else if (model == null)
|
|
{
|
|
msg = "用户不存在！";
|
|
}
|
|
else if (model.USERS_PWD == FangYar.Common.Md5.GetMD5String(userPwd))
|
|
{
|
|
msg = "修改密码不能和旧密码一致！";
|
|
}
|
|
else
|
|
{
|
|
|
|
model.USERS_UID = userUID;
|
|
model.USERS_PWD = FangYar.Common.Md5.GetMD5String(userPwd);
|
|
model.USERS_NAME = userName;
|
|
model.USERS_TYPE = userType;
|
|
if (bll.AddUser(model))
|
|
{
|
|
msg = "密码修改成功！";
|
|
code = 1;
|
|
}
|
|
else
|
|
{
|
|
msg = "密码修改失败！";
|
|
|
|
}
|
|
}
|
|
|
|
}
|
|
catch
|
|
{
|
|
msg = "密码修改失败！";
|
|
}
|
|
returnstr = "{\"code\":" + code + ",\"msg\":\"" + msg + "\"}";
|
|
return returnstr;
|
|
}
|
|
|
|
private string GetUserMenu2(HttpContext context)
|
|
{
|
|
string returnstr = "[";
|
|
try
|
|
{
|
|
FangYar.Model.LoginUserModel user = FangYar.Common.UserHelper.GetUser(context);
|
|
if (user != null)
|
|
{
|
|
DataTable dt = getmenu(user, null);
|
|
string id, title, url, fid, type, level, state, action, icon;
|
|
for (int i = 0; i < dt.Rows.Count; i++)
|
|
{
|
|
id = dt.Rows[i]["ID"].ToString();
|
|
title = dt.Rows[i]["MENU_TITLE"].ToString();
|
|
url = dt.Rows[i]["MENU_URL"].ToString();
|
|
fid = dt.Rows[i]["MENU_PARENT"].ToString();
|
|
type = dt.Rows[i]["MENU_TYPE"].ToString();
|
|
level = dt.Rows[i]["MENU_LEVEL"].ToString();
|
|
state = dt.Rows[i]["MENU_FLAG"].ToString();
|
|
action = dt.Rows[i]["MENU_ACTION"].ToString();
|
|
icon = dt.Rows[i]["MENU_ICON"].ToString();
|
|
if (i > 0) { returnstr += ","; }
|
|
returnstr += "{";
|
|
returnstr += "\"title\":\"" + title + "\"";
|
|
//returnstr += ",\"icon\":\"layui-icon " + icon + "\"";
|
|
returnstr += ",\"icon\":\"iconfont " + icon + "\"";
|
|
returnstr += ",\"spread\":\"false\"";
|
|
returnstr += ",\"href\":\"" + url + "\"";
|
|
returnstr += ",\"id\":\"" + id + "\"";
|
|
returnstr += ",\"type\":\"" + type + "\"";
|
|
returnstr += ",\"state\":\"" + state + "\"";
|
|
returnstr += ",\"level\":\"" + level + "\"";
|
|
returnstr += ",\"action\":\"" + action + "\"";
|
|
returnstr += ",\"children\":[";
|
|
DataTable dtc = getmenu(user, id);
|
|
|
|
for (int j = 0; j < dtc.Rows.Count; j++)
|
|
{
|
|
id = dtc.Rows[j]["ID"].ToString();
|
|
title = dtc.Rows[j]["MENU_TITLE"].ToString();
|
|
url = dtc.Rows[j]["MENU_URL"].ToString();
|
|
|
|
type = dtc.Rows[j]["MENU_TYPE"].ToString();
|
|
level = dtc.Rows[j]["MENU_LEVEL"].ToString();
|
|
state = dtc.Rows[j]["MENU_FLAG"].ToString();
|
|
action = dtc.Rows[j]["MENU_ACTION"].ToString();
|
|
icon = dtc.Rows[j]["MENU_ICON"].ToString();
|
|
if (j > 0) { returnstr += ","; }
|
|
returnstr += "{";
|
|
returnstr += "\"title\":\"" + title + "\"";
|
|
//returnstr += ",\"icon\":\"layui-icon " + "layui-icon-rate-half" + "\"";
|
|
returnstr += ",\"icon\":\"iconfont " + icon + "\"";
|
|
returnstr += ",\"spread\":\"false\"";
|
|
returnstr += ",\"href\":\"" + url + "\"";
|
|
returnstr += ",\"id\":\"" + id + "\"";
|
|
returnstr += ",\"type\":\"" + type + "\"";
|
|
returnstr += ",\"state\":\"" + state + "\"";
|
|
returnstr += ",\"level\":\"" + level + "\"";
|
|
returnstr += ",\"action\":\"" + action + "\"";
|
|
returnstr += ",\"children\":[";
|
|
DataTable dtcd = getmenu(user, id);
|
|
for (int k = 0; k < dtcd.Rows.Count; k++)
|
|
{
|
|
id = dtcd.Rows[k]["ID"].ToString();
|
|
title = dtcd.Rows[k]["MENU_TITLE"].ToString();
|
|
url = dtcd.Rows[k]["MENU_URL"].ToString();
|
|
|
|
type = dtcd.Rows[k]["MENU_TYPE"].ToString();
|
|
level = dtcd.Rows[k]["MENU_LEVEL"].ToString();
|
|
state = dtcd.Rows[k]["MENU_FLAG"].ToString();
|
|
action = dtcd.Rows[k]["MENU_ACTION"].ToString();
|
|
icon = dtcd.Rows[k]["MENU_ICON"].ToString();
|
|
if (k > 0) { returnstr += ","; }
|
|
returnstr += "{";
|
|
returnstr += "\"title\":\"" + title + "\"";
|
|
//returnstr += ",\"icon\":\"layui-icon " + "layui-icon-rate-half" + "\"";
|
|
returnstr += ",\"icon\":\"iconfont " + icon + "\"";
|
|
returnstr += ",\"spread\":\"false\"";
|
|
returnstr += ",\"href\":\"" + url + "\"";
|
|
returnstr += ",\"id\":\"" + id + "\"";
|
|
returnstr += ",\"type\":\"" + type + "\"";
|
|
returnstr += ",\"state\":\"" + state + "\"";
|
|
returnstr += ",\"level\":\"" + level + "\"";
|
|
returnstr += ",\"action\":\"" + action + "\"";
|
|
returnstr += "}";
|
|
}
|
|
returnstr += "]";
|
|
returnstr += "}";
|
|
}
|
|
returnstr += "]";
|
|
returnstr += "}";
|
|
}
|
|
}
|
|
}
|
|
catch (Exception e)
|
|
{
|
|
}
|
|
returnstr += "]";
|
|
return returnstr;
|
|
}
|
|
|
|
private string GetUserMenu(HttpContext context) //平台菜单、主菜单、子菜单需要设置好等级
|
|
{
|
|
string returnstr = "[";
|
|
try
|
|
{
|
|
FangYar.Model.LoginUserModel user = FangYar.Common.UserHelper.GetUser(context);
|
|
if (user != null)
|
|
{
|
|
DataTable dt = getmenu(user, null);
|
|
string id, title, url, fid, type, level, state, action, icon, idone, idtwo, flowtype;
|
|
var index = 0;
|
|
for (int i = 0; i < dt.Rows.Count; i++)
|
|
{
|
|
if (dt.Rows[i]["MENU_PARENT"].ToString() == "C85E05CA017A4ACF95916C45A264727E")
|
|
{
|
|
id = dt.Rows[i]["ID"].ToString();
|
|
title = dt.Rows[i]["MENU_TITLE"].ToString();
|
|
url = dt.Rows[i]["MENU_URL"].ToString();
|
|
fid = dt.Rows[i]["MENU_PARENT"].ToString();
|
|
type = dt.Rows[i]["MENU_TYPE"].ToString();
|
|
level = dt.Rows[i]["MENU_LEVEL"].ToString();
|
|
state = dt.Rows[i]["MENU_FLAG"].ToString();
|
|
action = dt.Rows[i]["MENU_ACTION"].ToString();
|
|
icon = dt.Rows[i]["MENU_ICON"].ToString();
|
|
flowtype = dt.Rows[i]["FLOWTYPE"].ToString();
|
|
if (index > 0) { returnstr += ","; }
|
|
returnstr += "{";
|
|
returnstr += "\"title\":\"" + title + "\"";
|
|
//returnstr += ",\"icon\":\"layui-icon " + icon + "\"";
|
|
returnstr += ",\"icon\":\"iconfont " + icon + "\"";
|
|
returnstr += ",\"spread\":\"false\"";
|
|
returnstr += ",\"href\":\"" + url + "\"";
|
|
returnstr += ",\"id\":\"" + id + "\"";
|
|
returnstr += ",\"type\":\"" + type + "\"";
|
|
returnstr += ",\"state\":\"" + state + "\"";
|
|
returnstr += ",\"level\":\"" + level + "\"";
|
|
returnstr += ",\"action\":\"" + action + "\"";
|
|
returnstr += ",\"flowtype\":\"" + flowtype + "\"";
|
|
returnstr += ",\"children\":[";
|
|
dt.Rows.RemoveAt(i);
|
|
i--; index++;
|
|
int a = 0;
|
|
idone = id;
|
|
for (int j = 0; j < dt.Rows.Count; j++)
|
|
{
|
|
string aw = dt.Rows[j]["MENU_TITLE"].ToString();
|
|
|
|
if (dt.Rows[j]["MENU_PARENT"].ToString() == idone)
|
|
{
|
|
|
|
id = dt.Rows[j]["ID"].ToString();
|
|
title = dt.Rows[j]["MENU_TITLE"].ToString();
|
|
url = dt.Rows[j]["MENU_URL"].ToString();
|
|
|
|
type = dt.Rows[j]["MENU_TYPE"].ToString();
|
|
level = dt.Rows[j]["MENU_LEVEL"].ToString();
|
|
state = dt.Rows[j]["MENU_FLAG"].ToString();
|
|
action = dt.Rows[j]["MENU_ACTION"].ToString();
|
|
icon = dt.Rows[j]["MENU_ICON"].ToString();
|
|
flowtype = dt.Rows[j]["FLOWTYPE"].ToString();
|
|
dt.Rows.RemoveAt(j);
|
|
j--;
|
|
if (a > 0) { returnstr += ","; }
|
|
a++;
|
|
returnstr += "{";
|
|
returnstr += "\"title\":\"" + title + "\"";
|
|
//returnstr += ",\"icon\":\"layui-icon " + "layui-icon-rate-half" + "\"";
|
|
returnstr += ",\"icon\":\"iconfont " + icon + "\"";
|
|
returnstr += ",\"spread\":\"false\"";
|
|
returnstr += ",\"href\":\"" + url + "\"";
|
|
returnstr += ",\"id\":\"" + id + "\"";
|
|
returnstr += ",\"type\":\"" + type + "\"";
|
|
returnstr += ",\"state\":\"" + state + "\"";
|
|
returnstr += ",\"level\":\"" + level + "\"";
|
|
returnstr += ",\"action\":\"" + action + "\"";
|
|
returnstr += ",\"flowtype\":\"" + flowtype + "\"";
|
|
returnstr += ",\"children\":[";
|
|
idtwo = id;
|
|
int b = 0;
|
|
for (int k = 0; k < dt.Rows.Count; k++)
|
|
{
|
|
string aaa = dt.Rows[k]["ID"].ToString();
|
|
if (dt.Rows[k]["MENU_PARENT"].ToString() == idtwo)
|
|
{
|
|
id = dt.Rows[k]["ID"].ToString();
|
|
title = dt.Rows[k]["MENU_TITLE"].ToString();
|
|
url = dt.Rows[k]["MENU_URL"].ToString();
|
|
|
|
type = dt.Rows[k]["MENU_TYPE"].ToString();
|
|
level = dt.Rows[k]["MENU_LEVEL"].ToString();
|
|
state = dt.Rows[k]["MENU_FLAG"].ToString();
|
|
action = dt.Rows[k]["MENU_ACTION"].ToString();
|
|
icon = dt.Rows[k]["MENU_ICON"].ToString();
|
|
flowtype = dt.Rows[k]["FLOWTYPE"].ToString();
|
|
dt.Rows.RemoveAt(k);
|
|
k--;
|
|
if (b > 0) { returnstr += ","; }
|
|
b++;
|
|
returnstr += "{";
|
|
returnstr += "\"title\":\"" + title + "\"";
|
|
//returnstr += ",\"icon\":\"layui-icon " + "layui-icon-rate-half" + "\"";
|
|
returnstr += ",\"icon\":\"iconfont " + icon + "\"";
|
|
returnstr += ",\"spread\":\"false\"";
|
|
returnstr += ",\"href\":\"" + url + "\"";
|
|
returnstr += ",\"id\":\"" + id + "\"";
|
|
returnstr += ",\"type\":\"" + type + "\"";
|
|
returnstr += ",\"state\":\"" + state + "\"";
|
|
returnstr += ",\"level\":\"" + level + "\"";
|
|
returnstr += ",\"action\":\"" + action + "\"";
|
|
returnstr += ",\"flowtype\":\"" + flowtype + "\"";
|
|
returnstr += ",\"children\":[";
|
|
returnstr += "]";
|
|
returnstr += "}";
|
|
}
|
|
}
|
|
returnstr += "]";
|
|
returnstr += "}";
|
|
}
|
|
}
|
|
returnstr += "]";
|
|
returnstr += "}";
|
|
}
|
|
}
|
|
}
|
|
}
|
|
catch (Exception e)
|
|
{
|
|
|
|
}
|
|
returnstr += "]";
|
|
return returnstr;
|
|
}
|
|
|
|
|
|
|
|
private DataTable getmenu(FangYar.Model.LoginUserModel user, string fid)
|
|
{
|
|
DataTable dt = new DataTable();
|
|
try
|
|
{
|
|
|
|
if (user != null)
|
|
{
|
|
string baseRoleId = ",''";
|
|
var org = bll_org.GetModel(user.OrgID);//所在单位
|
|
if (org != null)
|
|
{
|
|
//0:支队；1:特勤站；2:大队；3:总队
|
|
switch (org.EXTENDCODE1)
|
|
{
|
|
case "0":
|
|
baseRoleId = ",'d7f83a97208f4e049fe2e980095a7a65'";
|
|
break;
|
|
case "1":
|
|
baseRoleId = ",'03c85152f80a49f0ad3cfea202af00b4'";
|
|
break;
|
|
case "2":
|
|
baseRoleId = ",'5805857f2fae4daf9482996dbed726b7'";
|
|
break;
|
|
case "3":
|
|
baseRoleId = ",'ca8b271020d047db816cf6b18a6852ad'";
|
|
break;
|
|
}
|
|
}
|
|
|
|
string sqlwhere = " find_in_set(id,cids) and id in(select menu_id from TBL_SYS_ROLEMENU t where role_id in ('" + user.roles.Replace(",", "','") + "'" + baseRoleId + ")) " +
|
|
" and id not in (SELECT id from tbl_sys_menu WHERE id in(select menu_id from tbl_sys_rolemenu_not t where role_id in ('" + user.roles.Replace(",", "','") + "')) ) " + //and MENU_LEVEL = 3
|
|
" order by MENU_TYPE ,menu_level,menu_order ";
|
|
if (user.OrgID == "1" || user.UserCode == "iamasuperman")
|
|
{
|
|
sqlwhere = " 1=1 order by MENU_TYPE ,menu_level,menu_order ";
|
|
}
|
|
dt = new FangYar.BLL.CommomBLL().GetTableList("*", " tbl_sys_menu ,(select get_Menu_child_list('C85E05CA017A4ACF95916C45A264727E') cids) s ", sqlwhere);
|
|
}
|
|
else
|
|
{
|
|
|
|
}
|
|
}
|
|
catch (Exception e)
|
|
{
|
|
}
|
|
return dt;
|
|
}
|
|
|
|
|
|
|
|
private string GetUserMenuNoAuth(HttpContext context) //平台菜单、主菜单、子菜单需要设置好等级
|
|
{
|
|
string returnstr = "[";
|
|
try
|
|
{
|
|
string UsersUid = context.Request.Params["UsersUid"];
|
|
FangYar.BLL.TBL.SysUsersBLL bllUsers = new BLL.TBL.SysUsersBLL();
|
|
FangYar.Model.LoginUserModel user = bllUsers.GetLoginUserModelByUID(UsersUid);
|
|
|
|
//获取用户角色
|
|
string rolesid = FangYar.BLL.CommomBLL.GetTableIDS("rules_id", "users_uid", "TBL_SYS_USERSRULES", " where users_uid='" + UsersUid + "' and app_id='0001' and rules_type='2' ");
|
|
user.roles = rolesid;
|
|
|
|
if (user != null)
|
|
{
|
|
DataTable dt = getMenuNoAuth(user, null);
|
|
string id, title, url, fid, type, level, state, action, icon, idone, idtwo, flowtype;
|
|
var index = 0;
|
|
for (int i = 0; i < dt.Rows.Count; i++)
|
|
{
|
|
if (dt.Rows[i]["MENU_PARENT"].ToString() == "C85E05CA017A4ACF95916C45A264727E")
|
|
{
|
|
id = dt.Rows[i]["ID"].ToString();
|
|
title = dt.Rows[i]["MENU_TITLE"].ToString();
|
|
url = dt.Rows[i]["MENU_URL"].ToString();
|
|
fid = dt.Rows[i]["MENU_PARENT"].ToString();
|
|
type = dt.Rows[i]["MENU_TYPE"].ToString();
|
|
level = dt.Rows[i]["MENU_LEVEL"].ToString();
|
|
state = dt.Rows[i]["MENU_FLAG"].ToString();
|
|
action = dt.Rows[i]["MENU_ACTION"].ToString();
|
|
icon = dt.Rows[i]["MENU_ICON"].ToString();
|
|
flowtype = dt.Rows[i]["FLOWTYPE"].ToString();
|
|
if (index > 0) { returnstr += ","; }
|
|
returnstr += "{";
|
|
returnstr += "\"title\":\"" + title + "\"";
|
|
//returnstr += ",\"icon\":\"layui-icon " + icon + "\"";
|
|
returnstr += ",\"icon\":\"iconfont " + icon + "\"";
|
|
returnstr += ",\"spread\":\"false\"";
|
|
returnstr += ",\"href\":\"" + url + "\"";
|
|
returnstr += ",\"id\":\"" + id + "\"";
|
|
returnstr += ",\"type\":\"" + type + "\"";
|
|
returnstr += ",\"state\":\"" + state + "\"";
|
|
returnstr += ",\"level\":\"" + level + "\"";
|
|
returnstr += ",\"action\":\"" + action + "\"";
|
|
returnstr += ",\"flowtype\":\"" + flowtype + "\"";
|
|
returnstr += ",\"children\":[";
|
|
dt.Rows.RemoveAt(i);
|
|
i--; index++;
|
|
int a = 0;
|
|
idone = id;
|
|
for (int j = 0; j < dt.Rows.Count; j++)
|
|
{
|
|
string aw = dt.Rows[j]["MENU_TITLE"].ToString();
|
|
|
|
if (dt.Rows[j]["MENU_PARENT"].ToString() == idone)
|
|
{
|
|
|
|
id = dt.Rows[j]["ID"].ToString();
|
|
title = dt.Rows[j]["MENU_TITLE"].ToString();
|
|
url = dt.Rows[j]["MENU_URL"].ToString();
|
|
|
|
type = dt.Rows[j]["MENU_TYPE"].ToString();
|
|
level = dt.Rows[j]["MENU_LEVEL"].ToString();
|
|
state = dt.Rows[j]["MENU_FLAG"].ToString();
|
|
action = dt.Rows[j]["MENU_ACTION"].ToString();
|
|
icon = dt.Rows[j]["MENU_ICON"].ToString();
|
|
flowtype = dt.Rows[j]["FLOWTYPE"].ToString();
|
|
dt.Rows.RemoveAt(j);
|
|
j--;
|
|
if (a > 0) { returnstr += ","; }
|
|
a++;
|
|
returnstr += "{";
|
|
returnstr += "\"title\":\"" + title + "\"";
|
|
//returnstr += ",\"icon\":\"layui-icon " + "layui-icon-rate-half" + "\"";
|
|
returnstr += ",\"icon\":\"iconfont " + icon + "\"";
|
|
returnstr += ",\"spread\":\"false\"";
|
|
returnstr += ",\"href\":\"" + url + "\"";
|
|
returnstr += ",\"id\":\"" + id + "\"";
|
|
returnstr += ",\"type\":\"" + type + "\"";
|
|
returnstr += ",\"state\":\"" + state + "\"";
|
|
returnstr += ",\"level\":\"" + level + "\"";
|
|
returnstr += ",\"action\":\"" + action + "\"";
|
|
returnstr += ",\"flowtype\":\"" + flowtype + "\"";
|
|
returnstr += ",\"children\":[";
|
|
idtwo = id;
|
|
int b = 0;
|
|
for (int k = 0; k < dt.Rows.Count; k++)
|
|
{
|
|
string aaa = dt.Rows[k]["ID"].ToString();
|
|
if (dt.Rows[k]["MENU_PARENT"].ToString() == idtwo)
|
|
{
|
|
id = dt.Rows[k]["ID"].ToString();
|
|
title = dt.Rows[k]["MENU_TITLE"].ToString();
|
|
url = dt.Rows[k]["MENU_URL"].ToString();
|
|
|
|
type = dt.Rows[k]["MENU_TYPE"].ToString();
|
|
level = dt.Rows[k]["MENU_LEVEL"].ToString();
|
|
state = dt.Rows[k]["MENU_FLAG"].ToString();
|
|
action = dt.Rows[k]["MENU_ACTION"].ToString();
|
|
icon = dt.Rows[k]["MENU_ICON"].ToString();
|
|
flowtype = dt.Rows[k]["FLOWTYPE"].ToString();
|
|
dt.Rows.RemoveAt(k);
|
|
k--;
|
|
if (b > 0) { returnstr += ","; }
|
|
b++;
|
|
returnstr += "{";
|
|
returnstr += "\"title\":\"" + title + "\"";
|
|
//returnstr += ",\"icon\":\"layui-icon " + "layui-icon-rate-half" + "\"";
|
|
returnstr += ",\"icon\":\"iconfont " + icon + "\"";
|
|
returnstr += ",\"spread\":\"false\"";
|
|
returnstr += ",\"href\":\"" + url + "\"";
|
|
returnstr += ",\"id\":\"" + id + "\"";
|
|
returnstr += ",\"type\":\"" + type + "\"";
|
|
returnstr += ",\"state\":\"" + state + "\"";
|
|
returnstr += ",\"level\":\"" + level + "\"";
|
|
returnstr += ",\"action\":\"" + action + "\"";
|
|
returnstr += ",\"flowtype\":\"" + flowtype + "\"";
|
|
returnstr += ",\"children\":[";
|
|
returnstr += "]";
|
|
returnstr += "}";
|
|
}
|
|
}
|
|
returnstr += "]";
|
|
returnstr += "}";
|
|
}
|
|
}
|
|
returnstr += "]";
|
|
returnstr += "}";
|
|
}
|
|
}
|
|
}
|
|
}
|
|
catch (Exception e)
|
|
{
|
|
|
|
}
|
|
returnstr += "]";
|
|
return returnstr;
|
|
}
|
|
|
|
|
|
|
|
private DataTable getMenuNoAuth(FangYar.Model.LoginUserModel user, string fid)
|
|
{
|
|
DataTable dt = new DataTable();
|
|
try
|
|
{
|
|
|
|
if (user != null)
|
|
{
|
|
string baseRoleId = ",''";
|
|
var org = bll_org.GetModel(user.OrgID);//所在单位
|
|
if (org != null)
|
|
{
|
|
//0:支队；1:特勤站；2:大队；3:总队
|
|
switch (org.EXTENDCODE1)
|
|
{
|
|
case "0":
|
|
baseRoleId = ",'d7f83a97208f4e049fe2e980095a7a65'";
|
|
break;
|
|
case "1":
|
|
baseRoleId = ",'03c85152f80a49f0ad3cfea202af00b4'";
|
|
break;
|
|
case "2":
|
|
baseRoleId = ",'5805857f2fae4daf9482996dbed726b7'";
|
|
break;
|
|
case "3":
|
|
baseRoleId = ",'ca8b271020d047db816cf6b18a6852ad'";
|
|
break;
|
|
}
|
|
}
|
|
|
|
string sqlwhere = " find_in_set(id,cids) and id in(select menu_id from TBL_SYS_ROLEMENU t where role_id in ('" + user.roles.Replace(",", "','") + "'" + baseRoleId + ")) " +
|
|
" and id not in (SELECT id from tbl_sys_menu WHERE id in(select menu_id from tbl_sys_rolemenu_not t where role_id in ('" + user.roles.Replace(",", "','") + "'" + baseRoleId + ")) ) " + //and MENU_LEVEL = 3
|
|
" order by MENU_TYPE ,menu_level,menu_order ";
|
|
if (user.OrgID == "1" || user.UserCode == "iamasuperman")
|
|
{
|
|
sqlwhere = " 1=1 order by MENU_TYPE ,menu_level,menu_order ";
|
|
}
|
|
dt = new FangYar.BLL.CommomBLL().GetTableList("*", " tbl_sys_menu ,(select get_Menu_child_list('C85E05CA017A4ACF95916C45A264727E') cids) s ", sqlwhere);
|
|
}
|
|
else
|
|
{
|
|
|
|
}
|
|
}
|
|
catch (Exception e)
|
|
{
|
|
}
|
|
return dt;
|
|
}
|
|
|
|
//private DataTable getmenu(FangYar.Model.LoginUserModel user, string fid)
|
|
//{
|
|
// DataTable dt = new DataTable();
|
|
// try
|
|
// {
|
|
|
|
// if (user != null)
|
|
// {
|
|
// string baseRoleId = ",''";
|
|
// var org = bll_org.GetModel(user.OrgID);//所在单位
|
|
// if (org != null)
|
|
// {
|
|
// //0:支队；1:特勤站；2:大队；3:总队
|
|
// switch (org.EXTENDCODE1)
|
|
// {
|
|
// case "0":
|
|
// baseRoleId = ",'d7f83a97208f4e049fe2e980095a7a65'";
|
|
// break;
|
|
// case "1":
|
|
// baseRoleId = ",'03c85152f80a49f0ad3cfea202af00b4'";
|
|
// break;
|
|
// case "2":
|
|
// baseRoleId = ",'5805857f2fae4daf9482996dbed726b7'";
|
|
// break;
|
|
// case "3":
|
|
// baseRoleId = ",'ca8b271020d047db816cf6b18a6852ad'";
|
|
// break;
|
|
// }
|
|
// }
|
|
|
|
// string sqlwhere = " find_in_set(id,cids) and id in(select menu_id from TBL_SYS_ROLEMENU t where role_id in ('" + user.roles.Replace(",", "','") + "'" + baseRoleId + ")) and MENU_FLAG=0 order by MENU_TYPE ,menu_level,menu_order";
|
|
// if (user.OrgID == "1" || user.UserCode == "iamasuperman")
|
|
// {
|
|
// sqlwhere = " 1=1 order by MENU_TYPE ,menu_level,menu_order ";
|
|
// }
|
|
// dt = new FangYar.BLL.CommomBLL().GetTableList("*", " tbl_sys_menu ,(select get_Menu_child_list('C85E05CA017A4ACF95916C45A264727E') cids) s ", sqlwhere);
|
|
// }
|
|
// else
|
|
// {
|
|
|
|
// }
|
|
// }
|
|
// catch
|
|
// {
|
|
|
|
// }
|
|
// return dt;
|
|
|
|
//}
|
|
|
|
|
|
//private DataTable getmenu(FangYar.Model.LoginUserModel user, string fid)
|
|
//{
|
|
// DataTable dt = new DataTable();
|
|
// try
|
|
// {
|
|
|
|
// if (user != null)
|
|
// {
|
|
// string sqlwhere = "";
|
|
// if (string.IsNullOrEmpty(fid))
|
|
// {
|
|
// sqlwhere = " menu_parent ='C85E05CA017A4ACF95916C45A264727E' ";
|
|
// }
|
|
// else
|
|
// {
|
|
// sqlwhere = " menu_parent ='" + fid + "' ";
|
|
// }
|
|
// sqlwhere += " and id in(select menu_id from TBL_SYS_ROLEMENU t where role_id in ('" + user.roles.Replace(",", "','") + "'))";
|
|
// sqlwhere += "order by menu_order ";
|
|
// dt = new FangYar.BLL.CommomBLL().GetTableList("*", "tbl_sys_menu", sqlwhere);
|
|
|
|
// }
|
|
// else
|
|
// {
|
|
|
|
// }
|
|
// }
|
|
// catch
|
|
// {
|
|
|
|
// }
|
|
// return dt;
|
|
//}
|
|
|
|
private string typegetmenu(HttpContext context)
|
|
{
|
|
string returnstr = "";
|
|
FangYar.BLL.TBL.SysMenuBLL mbll = new FangYar.BLL.TBL.SysMenuBLL();
|
|
try
|
|
{
|
|
string type = context.Request.Params["type"].ToString();
|
|
//if (type.IndexOf("-")>-1)
|
|
//{
|
|
// type = type.Replace("-","");
|
|
//}
|
|
returnstr = "{\"code\":1,\"msg\":\"\",";
|
|
List<FangYar.Model.TBL.TBL_SYS_MENU_Model> list = mbll.typegetmenu(type);
|
|
returnstr += "\"count\":" + list.Count + ",\"data\":";
|
|
if (list.Count == 0)
|
|
{
|
|
returnstr += "[]";
|
|
}
|
|
else
|
|
{
|
|
returnstr += FangYar.Common.JsonHelper.ToJson(list);
|
|
}
|
|
returnstr += "}";
|
|
}
|
|
catch (Exception e)
|
|
{
|
|
returnstr = "{\"code\":-1,\"msg\":\"" + e.Message + "\",\"count\":0,\"data\":[]";
|
|
}
|
|
return returnstr;
|
|
}
|
|
public bool IsReusable
|
|
{
|
|
get
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
}
|
|
}
|