/// <summary>
/// 获取权限powertreetable
/// </summary>
/// <param name="context"></param>
private void GetPowerTreeJsonFortreeTable(HttpContext context)
{
var list = FGA_BLL.Cache.PowersCache.Powers;
// list = list.Where(i => i.bz == 0).ToList(); //不展示的菜单过滤掉
if (list != null && list.Count > 0)
{
ZlistJsonModel zjm = new ZlistJsonModel();
List <ZTreeItem> zList = new List <ZTreeItem>();
ZTreeItem zitem = new ZTreeItem();
foreach (var item in list)
{
zitem = new ZTreeItem();
zitem.id = item.pcode;
zitem.pId = "0";
if (item.pcode.Length > SysConst.CODE_STEP)
{
zitem.pId = item.pcode.Substring(0, item.pcode.Length - SysConst.CODE_STEP);
}
zitem.name = item.pname;
zitem.icon = string.Empty;
zitem.tag = string.Empty;
zitem.url = item.purl;
zitem.des = item.pdescription;
zitem.bz = item.bz;
zList.Add(zitem);
}
zjm.zlist = zList;
string res = Newtonsoft.Json.JsonConvert.SerializeObject(zjm);
context.Response.Write(res);
}
}
/// <summary>
/// 获取所有模块节点
/// </summary>
/// <param name="context"></param>
private void GetPowerTreeJson(HttpContext context)
{
var list = FGA_BLL.Cache.PowersCache.Powers;
//list = list.Where(i => i.bz == 0).ToList(); //不展示的菜单过滤掉
if (list != null && list.Count > 0)
{
List <ZTreeItem> zList = new List <ZTreeItem>();
ZTreeItem zitem = new ZTreeItem();
foreach (var item in list)
{
zitem = new ZTreeItem();
zitem.id = item.pcode;
zitem.pId = "0";
if (item.pcode.Length > SysConst.CODE_STEP)
{
zitem.pId = item.pcode.Substring(0, item.pcode.Length - SysConst.CODE_STEP);
}
zitem.name = item.pname;
if (item.bz == 0)
{
zitem.icon = SysConst.ICO_POWER;
}
else
{
zitem.icon = SysConst.ICO_POWER_DIS;
}
zitem.tag = string.Empty;
zList.Add(zitem);
}
string res = Newtonsoft.Json.JsonConvert.SerializeObject(zList);
context.Response.Write(res);
}
}
/// <summary>
/// 获取用户树
/// </summary>
/// <param name="context"></param>
private void GetUserTreeJson(HttpContext context)
{
List <UsersModel> uList = new List <UsersModel>();
Hashtable where = new Hashtable();
List <ZTreeItem> zList = new List <ZTreeItem>();
ZTreeItem zitem = new ZTreeItem();
//[逻辑]读取用户信息添加到输出数据,超级管理员不显示,已删除不显示
uList = FGA_BLL.Cache.UsersCache.Users.Where(u => (!u.IsSuperUser) && (u.STATUS != ((int)CommonState.disable).ToString()) && (u.STATUS != ((int)CommonState.delete).ToString())).ToList();
if (uList != null && uList.Count > 0)
{
foreach (var item in uList)
{
zitem = new ZTreeItem();
zitem.id = item.USERID.ToString();
zitem.pId = "";
zitem.name = item.USERNAME;
zitem.tag = "tag";
zitem.icon = SysConst.ICO_USER;
zList.Add(zitem);
}
}
//输出
string res = Newtonsoft.Json.JsonConvert.SerializeObject(zList);
context.Response.Write(res);
}
/// <summary>
/// 获取组织机构数据
/// </summary>
/// <returns></returns>
public List <ZTreeItem> GetOrganizationDataZtree()
{
var list = _organizationAppService.GetList();
List <ZTreeItem> treelist = new List <ZTreeItem>();
foreach (var item in list)
{
ZTreeItem tree = new ZTreeItem();
tree.Id = item.Id;
tree.pId = item.ParentId == null ? 0 : (long)item.ParentId;
tree.Name = item.DisplayName;
treelist.Add(tree);
}
return(treelist);
}
public ActionResult Index(int MediaType)
{
var reslist = grouplist.Where(q => q.MediaType == MediaType);
//将分组数据转为ztree无上下级结构数据
List <ZTreeItem> treelist = new List <ZTreeItem>();
foreach (var item in reslist)
{
ZTreeItem tree = new ZTreeItem();
tree.Id = item.Id;
tree.pId = 0;
tree.Name = item.Title;
treelist.Add(tree);
}
return(Json(new { status = "ok", zNodes = treelist }));
}
public IList <ZTreeItem> GetMapLayerTree(string mappingTypeId, string userId)
{
var result = new List <Common.ZTreeItem>();
if (string.IsNullOrEmpty(mappingTypeId))
{
return(result);
}
//首先获取图件
var maps = _dataManageAppService.GetAllList(mappingTypeId, userId);
//获取图层
if (maps != null && maps.Count > 0)
{
foreach (var map in maps)
{
var next = _layerContentAppService.GetLayers(map.Id, "").Select(p => new ZTreeItem
{
children = new List <ZTreeItem>(),
name = p.LayerName,
id = p.LayerAttrTable,
pId = map.Id,
isParent = false,
tag = p.Id,
tag1 = p.LayerDefaultStyle,
tag2 = p.MinX,
tag3 = p.MinY
}).ToList();
var item = new ZTreeItem
{
id = map.Id,
name = map.Name,
children = next,
pId = "",
isParent = next != null && next.Any()
};
result.Add(item);
}
}
return(result);
}
/// <summary>
/// 获取角色节点(不依附于部门)
/// </summary>
/// <param name="context"></param>
private void GetRoleTreeJson(HttpContext context)
{
var list = FGA_BLL.Cache.RolesCache.Roles;
if (list != null && list.Count > 0)
{
List <ZTreeItem> zList = new List <ZTreeItem>();
ZTreeItem zitem = new ZTreeItem();
//输出角色信息
foreach (var item in list)
{
zitem = new ZTreeItem();
zitem.id = item.rid.ToString();
zitem.pId = "0";
zitem.name = item.rname;
zitem.tag = item.state.ToString();
zitem.icon = item.state > 0 ? SysConst.ICO_USER : SysConst.ICO_USER_DIS;
zList.Add(zitem);
}
//输出
string res = Newtonsoft.Json.JsonConvert.SerializeObject(zList);
context.Response.Write(res);
}
}
public List <Common.ZTreeItem> GetChildServiceZTreeData(InfoEarthFrameDbContext db, string id, string userId)
{
var result = new List <Common.ZTreeItem>();
var children = new List <Tbl_LayerManager>();
if (userId.ToLower() == "admin")
{
children = db.LayerManagers.Where(p => p.PID == id).ToList();
}
else
{
children = db.Database.SqlQuery <Tbl_LayerManager>("SELECT" +
" r.*"+
"FROM" +
" \"TBL_LAYERMANAGER\" r"+
" JOIN (" +
" SELECT"+
" K .\"Id\","+
" K .\"MapId\""+
" FROM"+
" \"TBL_GROUP_RIGHT\" r"+
" LEFT JOIN ("+
" SELECT"+
" P .\"Id\","+
" l.\"Id\" AS \"MapId\""+
" FROM"+
" \"TBL_LAYERMANAGER\" l"+
" LEFT JOIN \"TBL_DATAMAIN\" M ON l.\"DataMainID\" = M .\"Id\""+
" LEFT JOIN \"TBL_GEOLOGYMAPPINGTYPE\" P ON P .\"Id\" = M .\"MappingTypeID\""+
" ) K ON K .\"Id\" = r.\"LayerId\""+
" WHERE"+
" r.\"GroupId\" IN ("+
" SELECT"+
" gu.\"GroupId\""+
" FROM"+
" \"TBL_GROUP_USER\" gu"+
" LEFT JOIN sdms_user u ON u.\"Id\" = gu.\"UserId\""+
" WHERE 1=1"+
" AND u.\"Id\" = \'"+ userId + "\'" +
" )"+
" AND K .\"Id\" IS NOT NULL"+
" AND \"IsBrowse\"=1" +
") T ON r.\"Id\" = T .\"MapId\"" +
"where (\"PID\"='" + id + "')").ToList();
}
//获取图层
if (children != null && children.Count > 0)
{
foreach (var p in children)
{
var nexts = GetChildServiceZTreeData(db, p.Id, userId);
var item = new ZTreeItem
{
id = p.Id,
name = p.TEXT,
children = nexts,
pId = id,
isParent = nexts != null && nexts.Any(),
tag = p.DATASERVERKEY,
tag1 = p.URL,
tag2 = p.ZEROLEVELSIZE,
tag3 = p.TILESIZE,
tag4 = p.SERVICETYPE
};
result.Add(item);
}
}
return(result);
}
