public async Task <ActionResult> GetTempList()
{
PageResponse reponse = new PageResponse();
List <zTree> list_ztree = new List <zTree>();
var list = _sqliteFreeSql.Select <TemplateConfig>().ToList();
_sqliteFreeSql.Dispose();
//根节点
zTree ztree = new zTree()
{
id = "temp0",
pId = "#",
name = "模板配置",
noEditBtn = true,
noRemoveBtn = true,
open = true
};
list_ztree.Add(ztree);
foreach (var temp in list)
{
ztree = new zTree()
{
id = temp.Id,
pId = "temp0",
name = temp.Name,
open = true
};
list_ztree.Add(ztree);
}
return(Response(list_ztree, list_ztree.Count()));
}
public JsonResult ListTree(NavigationDto dto)
{
var response = _NavigationService.GetList(dto);
List <zTree> list_ztree = new List <zTree>();
zTree ztree = new zTree()
{
id = "0",
pId = "#",
name = "系统",
noEditBtn = true,
noRemoveBtn = true,
open = true
};
list_ztree.Add(ztree);
foreach (var item in (List <Navigation>)response.data)
{
ztree = new zTree()
{
id = item.Id,
pId = item.ParentId ?? "0",
name = item.Name,
open = true
};
if (item.IsSys == 1)
{
ztree.noEditBtn = true;
ztree.noRemoveBtn = true;
}
list_ztree.Add(ztree);
}
response.data = list_ztree;
return(Json(response));
}
/// <summary>
/// 封装成ztree类
/// </summary>
/// <param name="listAll">全部数据list</param>
/// <param name="parentid">根节点的id</param>
/// <returns></returns>
public static List <zTree> GetJsonTreeData(List <TreeNode> listAll, int parentid)
{
List <zTree> listTree = new List <zTree>();
IEnumerable <TreeNode> list = listAll.Where(p => p.parentId == parentid);//使用linq查询，必须重复查询数据库，数据量小时适用
if (list.Count() > 0)
{
zTree ztree = null;
foreach (TreeNode item in list)
{
ztree = new zTree();
ztree.id = item.nodeId;
ztree.pId = item.parentId;
ztree.name = item.nodeName;
ztree.level = item.level;
List <zTree> listChildren = GetJsonTreeData(listAll, item.nodeId);
if (listChildren.Count > 0)
{
ztree.isParent = true;
ztree.children = listChildren;
}
else
{
ztree.isParent = false;
ztree.children = null;
}
listTree.Add(ztree);
}
}
return(listTree);
}
public JsonResult ListTree(DictTypeDto dto)
{
PageResponse reponse = new PageResponse();
reponse = _DictTypeService.GetList(dto);
List <zTree> list_ztree = new List <zTree>();
zTree ztree = new zTree()
{
id = "0",
pId = "#",
name = "字典",
noEditBtn = true,
noRemoveBtn = true,
open = true
};
list_ztree.Add(ztree);
foreach (var item in (List <DictType>)reponse.data)
{
ztree = new zTree()
{
id = item.Id,
pId = "0",
name = item.Name,
open = true
};
list_ztree.Add(ztree);
}
reponse.data = list_ztree;
return(Json(reponse));
}
private async Task <List <zTree> > GetTreeList(List <SqlConnect> list_SqlConnect)
{
List <zTree> list_ztree = new List <zTree>();
//根节点
zTree ztree = new zTree()
{
id = "0",
pId = "#",
name = "服务器",
noEditBtn = true,
noRemoveBtn = true,
open = true
};
list_ztree.Add(ztree);
foreach (var SqlConnect in list_SqlConnect)
{
ztree = new zTree()
{
id = SqlConnect.Id,
pId = "0",
name = SqlConnect.FullName,
open = true
};
list_ztree.Add(ztree);
}
return(list_ztree);
}
public JsonResult Edit(NavigationDto request)
{
PageResponse response = new PageResponse();
Navigation model = new Navigation()
{
Areas = request.Areas,
ControllerName = request.ControllerName,
Icon = request.Icon,
Id = request.Id,
IsSys = request.IsSys,
Link = request.Link,
Name = request.Name,
ParentId = request.ParentId,
Sort = request.Sort,
Level = request.Level
};
////删除该菜单下,所有的权限按钮
//var list_role = _NavigationRoleService.GetList(m => m.NId == model.Id).ToList();
//foreach (var item in list_role)
//{
// _NavigationRoleService.Delete(item.Id);
//}
////新增菜单权限
//foreach (var item in request.DictList)
//{
// NavigationRole m_nr = new NavigationRole()
// {
// Id = Guid.NewGuid().GuidTo16String(),
// DId = item.Id,
// NId = model.Id,
// Status = item.Status
// };
// _NavigationRoleService.Add(m_nr);
//}
_NavigationService.Update(model);
zTree ztree = new zTree()
{
id = model.Id,
pId = model.ParentId ?? "0",
name = model.Name,
open = true
};
if (model.IsSys == 1)
{
ztree.noEditBtn = true;
ztree.noRemoveBtn = true;
}
//获取菜单权限字典
response.code = StatusCodeDefine.Success;
response.status = 0;
response.data = ztree;
return(Json(response));
}
public JsonResult Edit(NavigationDto request)
{
Json reponse = new Json();
Navigation model = new Navigation()
{
Areas = request.Areas,
ControllerName = request.ControllerName,
Icon = request.Icon,
Id = request.Id,
IsSys = request.IsSys,
Link = request.Link,
Name = request.Name,
ParentId = request.ParentId,
Sort = request.Sort,
Level = request.Level
};
//删除该菜单下,所有的权限按钮
var list_role = _NavigationRoleIService.GetList(m => m.NId == model.Id, null, null).ToList();
foreach (var item in list_role)
{
_NavigationRoleIService.Delete(item.Id);
}
//新增菜单权限
foreach (var item in request.DictList)
{
NavigationRole m_nr = new NavigationRole()
{
Id = Guid.NewGuid().GuidTo16String(),
DId = item.Id,
NId = model.Id,
Status = item.Status
};
_NavigationRoleIService.Save(m_nr);
}
_NavigationIService.Update(model);
zTree ztree = new zTree()
{
id = model.Id,
pId = model.ParentId ?? "0",
name = model.Name,
open = true
};
if (model.IsSys == 1)
{
ztree.noEditBtn = true;
ztree.noRemoveBtn = true;
}
//获取菜单权限字典
reponse.code = 200;
reponse.status = 0;
reponse.data = ztree;
return(Json(reponse));
}
public JsonResult Create(NavigationDto request)
{
Navigation model = new Navigation()
{
Areas = request.Areas,
ControllerName = request.ControllerName,
Icon = request.Icon,
Id = Guid.NewGuid().GuidTo16String(),
IsSys = request.IsSys,
Link = request.Link,
Name = request.Name,
ParentId = request.ParentId,
Sort = request.Sort,
Level = request.Level
};
model.Level = string.IsNullOrEmpty(model.ParentId) ? 1 : 2;
var id = _NavigationService.Add(model);
//新增菜单权限
//foreach (var item in request.DictList)
//{
// NavigationRole m_nr = new NavigationRole()
// {
// Id = Guid.NewGuid().GuidTo16String(),
// DId = item.Id,
// NId = model.Id,
// Status = item.Status
// };
// _NavigationRoleService.Add(m_nr);
//}
zTree ztree = new zTree()
{
id = model.Id,
pId = model.ParentId ?? "0",
name = model.Name,
open = true
};
if (model.IsSys == 1)
{
ztree.noEditBtn = true;
ztree.noRemoveBtn = true;
}
PageResponse response = new PageResponse();
response.code = StatusCodeDefine.Success;
response.status = 0;
response.data = ztree;
return(Json(response));
}
public JsonResult Create(NavigationDto request)
{
Navigation model = new Navigation()
{
Areas = request.Areas,
ControllerName = request.ControllerName,
Icon = request.Icon,
Id = Guid.NewGuid().GuidTo16String(),
IsSys = request.IsSys,
Link = request.Link,
Name = request.Name,
ParentId = request.ParentId,
Sort = request.Sort,
Level = request.Level
};
var id = _NavigationIService.Save(model);
//新增菜单权限
foreach (var item in request.DictList)
{
NavigationRole m_nr = new NavigationRole()
{
Id = Guid.NewGuid().GuidTo16String(),
DId = item.Id,
NId = model.Id,
Status = item.Status
};
_NavigationRoleIService.Save(m_nr);
}
zTree ztree = new zTree()
{
id = model.Id,
pId = model.ParentId ?? "0",
name = model.Name,
open = true
};
if (model.IsSys == 1)
{
ztree.noEditBtn = true;
ztree.noRemoveBtn = true;
}
Json reponse = new Json();
reponse.code = 200;
reponse.status = 0;
reponse.data = ztree;
return(Json(reponse));
}
public JsonResult Edit(DictType request)
{
PageResponse reponse = new PageResponse();
_DictTypeService.Update(request);
zTree ztree = new zTree()
{
id = request.Id,
pId = "0",
name = request.Name,
open = true
};
reponse.code = StatusCodeDefine.Success;
reponse.status = 0;
reponse.data = ztree;
return(Json(reponse));
}
public JsonResult Create(DictType request)
{
request.Id = Guid.NewGuid().GuidTo16String();
var id = _DictTypeIService.Save(request);
zTree ztree = new zTree()
{
id = request.Id,
pId = "0",
name = request.Name,
open = true
};
Json reponse = new Json();
reponse.code = 200;
reponse.status = 0;
reponse.data = ztree;
return(Json(reponse));
}
public JsonResult Create(DictType request)
{
request.Id = Guid.NewGuid().GuidTo16String();
var id = _DictTypeService.Add(request);
zTree ztree = new zTree()
{
id = request.Id,
pId = "0",
name = request.Name,
open = true
};
PageResponse reponse = new PageResponse();
reponse.code = StatusCodeDefine.Success;
reponse.status = 0;
reponse.data = ztree;
return(Json(reponse));
}
public JsonResult Edit(DictType request)
{
Json reponse = new Json();
_DictTypeIService.Update(request);
zTree ztree = new zTree()
{
id = request.Id,
pId = "0",
name = request.Name,
open = true
};
reponse.code = 200;
reponse.status = 0;
reponse.data = ztree;
return(Json(reponse));
}
public JsonResult ListTree(NavigationRequest request)
{
request.sortKey = "Sort";
request.sortType = 0;
var list = _NavigationIService.GetList(request);
var count = _NavigationIService.GetCount(request);
List <zTree> list_ztree = new List <zTree>();
zTree ztree = new zTree()
{
id = "0",
pId = "#",
name = "系统",
noEditBtn = true,
noRemoveBtn = true,
open = true
};
list_ztree.Add(ztree);
foreach (var item in list)
{
ztree = new zTree()
{
id = item.Id,
pId = item.ParentId ?? "0",
name = item.Name,
open = true
};
if (item.IsSys == 1)
{
ztree.noEditBtn = true;
ztree.noRemoveBtn = true;
}
list_ztree.Add(ztree);
}
Json reponse = new Json();
reponse.code = 200;
reponse.total = count;
reponse.data = list_ztree;
return(Json(reponse));
}
public JsonResult Edit(NavigationRequest request)
{
Json reponse = new Json();
Navigation model = new Navigation()
{
Areas = request.Areas,
ControllerName = request.ControllerName,
Icon = request.Icon,
Id = request.Id,
IsSys = request.IsSys,
Link = request.Link,
Name = request.Name,
ParentId = request.ParentId,
Sort = request.Sort,
Level = request.Level
};
_NavigationIService.Update(model);
zTree ztree = new zTree()
{
id = model.Id,
pId = model.ParentId ?? "0",
name = model.Name,
open = true
};
if (model.IsSys == 1)
{
ztree.noEditBtn = true;
ztree.noRemoveBtn = true;
}
reponse.code = 200;
reponse.status = 0;
reponse.data = ztree;
return(Json(reponse));
}
public JsonResult GetTempList()
{
PageResponse reponse = new PageResponse();
List <zTree> list_ztree = new List <zTree>();
var list = _sqliteFreeSql.Select <TemplateConfig>().ToList();
_sqliteFreeSql.Dispose();
//根节点
zTree ztree = new zTree()
{
id = "temp0",
pId = "#",
name = "模板配置",
noEditBtn = true,
noRemoveBtn = true,
open = true
};
list_ztree.Add(ztree);
foreach (var temp in list)
{
ztree = new zTree()
{
id = temp.Id,
pId = "temp0",
name = temp.Name,
open = true
};
list_ztree.Add(ztree);
}
reponse.code = "200";
reponse.data = list_ztree;
reponse.status = 0;
reponse.total = list_ztree.Count();
return(Json(reponse));
}
public async Task <JsonResult> GetServerByID(string id)
{
PageResponse reponse = new PageResponse();
var list_ztree = new List <zTree>();
var sqlconnect = _sqliteFreeSql.Select <SqlConnect>().Where(p => p.Id == id).ToOne();
_sqliteFreeSql.Dispose();
try
{
IFreeSql fsql = new FreeSql.FreeSqlBuilder()
.UseConnectionString(sqlconnect.SqlType, sqlconnect.Address)
.Build();
var dbs = fsql.DbFirst.GetDatabases();
if (!string.IsNullOrEmpty(sqlconnect.DbName))
{
dbs = dbs.Where(p => p == sqlconnect.DbName).ToList();
}
foreach (var db in dbs)//数据库
{
var dbId = Guid.NewGuid().ToString();
var ztree = new zTree()
{
id = dbId,
pId = id,
name = db,
noEditBtn = true,
noRemoveBtn = true
};
list_ztree.Add(ztree);
var tables = fsql.DbFirst.GetTablesByDatabase(db);
foreach (var table in tables)//表
{
var tableid = Guid.NewGuid().ToString();
ztree = new zTree()
{
id = tableid,
pId = dbId,
name = table.Name,
noEditBtn = true,
noRemoveBtn = true
};
list_ztree.Add(ztree);
//将table信息缓存
TableConfig tableConfig = new TableConfig()
{
Id = tableid,
TableName = table.Name,
DbName = db,
ColumnConfig = new List <ColumnConfig>()
};
foreach (var column in table.Columns)
{
tableConfig.ColumnConfig.Add(new ColumnConfig()
{
ColumnName = column.Name,
CsType = column.CsType.FullName,
Remark = column.Coment
});
}
_Cache.Set(tableid, tableConfig);
}
}
reponse.code = "200";
reponse.data = list_ztree;
reponse.status = 0;
reponse.total = list_ztree.Count();
}
catch (Exception ex)
{
reponse.code = "500";
reponse.status = -1;
return(Json(reponse));
}
return(Json(reponse));
}
public JsonResult StaffIndexTree()
{
//查找到所有的部门。让他们变为zTree格式。
var rootsall = (from p in db.Departments
select new zTree
{
id = p.DepartmentId,
pid = p.ParentDepartmentId,
name = p.Name + "(" + p.StaffSize + ")",
url = "/StaffForChoose/List?id=" + p.DepartmentId,
//url = "/Staff/List?id=" + p.DepartmentId,
target = "_self",
isParent = false,
open = false
}).ToList();
//查找到所有的员工。让他们变为zTree格式。
var staffs = (from p in db.Staffs
select new zTree
{
id = p.Number.ToString(),
pid = p.Department,
name = p.Name,
url = "/StaffForChoose/Details?id=" + p.Number,
target = "_self",
isParent = false,
open = false
}).ToList();
//把员工给部门。
foreach (var itemstaff in staffs)
{
foreach (var item in rootsall)
{
if (itemstaff.pid == item.id)
{
item.isParent = true;
item.children.Add(itemstaff);
}
}
}
//初始化result。是所有部门结果。
List <zTree> result = new List <zTree>();
//所有的部门节点成为result的孩子
foreach (var item in rootsall)
{
result.Add(item);
}
//两层循环。result孩子只剩下父部门，其他部门都变成了它们的孩子。
foreach (var item in rootsall)
{
foreach (var a in rootsall)
{
if (item.id == a.pid)
{
item.isParent = true;
item.children.Add(a);
result.Remove(a);
}
}
}
//初始化根节点。没有放孩子节点进去。
zTree root = new zTree
{
name = this.CompanyFullName,
isParent = false,
url = "/StaffForChoose/Index",
target = "_self",
open = false
};
//把根节点加入result。
// result.Add(root);
// foreach()
List <zTree> cdresult = new List <zTree>();
cdresult.Add(root);
foreach (var item in result)
{
root.children.Add(item);
}
return(Json(cdresult));
}
public JsonResult SpaceTree()
{
var departments = (from p in db.Departments orderby p.DepartmentOrder select p).ToList();
foreach (var department in departments)
{
var staffCounts = (from p in db.Staffs where p.Department == department.DepartmentId select p).ToList();
department.RealSize = staffCounts.Count();
}
//查找到所有的部门。让他们变为zTree格式。
var rootsall = (from p in departments
orderby p.DepartmentOrder
select new zTree
{
id = p.DepartmentId,
pid = p.ParentDepartmentId,
name = p.Name + "(" + p.RealSize + "/" + p.StaffSize + ")",
isParent = false,
}).ToList();
//初始化result。是所有部门结果。
List <zTree> result = new List <zTree>();
//把所有的部门节点成为result的孩子
foreach (var item in rootsall)
{
result.Add(item);
}
//两层循环。resul孩子只剩下父部门，其他部门都变成了它们的孩子。
foreach (var item in rootsall)
{
foreach (var a in rootsall)
{
if (item.id == a.pid)
{
item.isParent = true;
item.children.Add(a);
result.Remove(a);
}
}
}
//初始化根节点。没有放孩子节点进去。
zTree root = new zTree
{
id = "0",
name = this.CompanyFullName,
isParent = true,
};
//把根节点加入result。
// result.Add(root);
// foreach()
List <zTree> cdresult = new List <zTree>();
foreach (var item in result)
{
root.children.Add(item);
}
// cdresult.Add(root);
//List<STree> stree = (from p in cdresult
// select new STree
// {
// id = p.id,
// name = p.name,
// data = "",
// }).ToList();
return(Json(root));
}
public JsonResult CDSTree()
{
var departments = (from p in db.Departments orderby p.DepartmentOrder select p).ToList();
foreach (var department in departments)
{
var staffCounts = (from p in db.Staffs where p.Department == department.DepartmentId select p).ToList();
department.RealSize = staffCounts.Count();
}
//查找到所有的部门。让他们变为zTree格式。
var rootsall = (from p in departments //db.Departments
//from q in db.Staffs where q.Department == p.DepartmentId
select new zTree
{
id = p.DepartmentId,
pid = p.ParentDepartmentId,
name = p.Name + "(" + p.RealSize + "/" + p.StaffSize + ")",
url = "/Staff/List?id=" + p.DepartmentId,
//url = "/Staff/List?id=" + p.DepartmentId,
target = "_self",
isParent = false,
open = false
}).ToList();
//查找到所有的员工。让他们变为zTree格式。
var staffs = (from p in db.Staffs
select new zTree
{
id = p.Number.ToString(),
pid = p.Department,
name = p.Name,
url = "/Staff/Details?id=" + p.Number,
target = "_self",
isParent = false,
open = false
}).ToList();
//把员工给部门。
foreach (var itemstaff in staffs)
{
foreach (var item in rootsall)
{
var a = 0;
if (itemstaff.pid == item.id)
{
a++;
//
//item.name =
item.isParent = true;
item.children.Add(itemstaff);
}
}
}
//初始化result。是所有部门结果。
List <zTree> result = new List <zTree>();
//所有的部门节点成为result的孩子
foreach (var item in rootsall)
{
//要统计每个部门下面有多少人。shit。
// List<zTree> result = new List<zTree>();
// foreach (var department in departments) {
// foreach(var staffCount in staffCounts)
// {
// var a = 0;
// if (staffCount.Department == department.DepartmentId) {
// a++;
// }
// item.url = "/Staff/List?id=" + a + "/" + department.DepartmentId;
// }
//}
result.Add(item);
}
//两层循环。result孩子只剩下父部门，其他部门都变成了它们的孩子。
foreach (var item in rootsall)
{
foreach (var a in rootsall)
{
if (item.id == a.pid)
{
item.isParent = true;
item.children.Add(a);
result.Remove(a);
}
}
}
//初始化根节点。没有放孩子节点进去。
zTree root = new zTree
{
name = this.CompanyFullName,
isParent = false,
url = "/Staff/Index",
target = "_self",
open = true
};
//把根节点加入result。
// result.Add(root);
// foreach()
List <zTree> cdresult = new List <zTree>();
cdresult.Add(root);
foreach (var item in result)
{
root.children.Add(item);
}
return(Json(cdresult));
}
