/// <summary> /// 加载按钮 (返回树Json) /// </summary> /// <param name="ModuleId">模块ID</param> /// <param name="Category">分类:1-工具栏,2:右击栏</param> /// <returns></returns> public ActionResult ButtonTreeJson(string ModuleId, string Category) { List <Base_Button> list = _baseButtonbll.GetList(ModuleId, Category); List <TreeJsonEntity> TreeList = new List <TreeJsonEntity>(); foreach (Base_Button item in list) { string ButtonId = item.ButtonId; bool hasChildren = false; List <Base_Button> childnode = list.FindAll(t => t.ParentId == ButtonId); if (childnode.Count > 0) { hasChildren = true; } TreeJsonEntity tree = new TreeJsonEntity(); tree.id = ButtonId; tree.text = item.FullName; tree.value = item.Code; tree.isexpand = true; tree.complete = true; tree.hasChildren = hasChildren; tree.parentId = item.ParentId; tree.img = item.Icon != null ? "/Content/Images/Icon16/" + item.Icon : item.Icon; TreeList.Add(tree); } return(Content(TreeList.TreeToJson())); }
/// <summary> /// 加载模块 返回树JSON /// </summary> /// <param name="ObjectId">对象主键</param> /// <param name="Category">对象分类:1-部门2-角色3-岗位4-群组</param> /// <returns></returns> public ActionResult ModuleTree(string ObjectId, string Category) { DataTable dt = base_modulepermissionbll.GetList(ObjectId, Category); List <TreeJsonEntity> TreeList = new List <TreeJsonEntity>(); if (!DataHelper.IsExistRows(dt)) { foreach (DataRow item in dt.Rows) { string ModuleId = item["moduleid"].ToString(); bool hasChildren = false; DataTable childnode = DataHelper.GetNewDataTable(dt, "ParentId = '" + ModuleId + "'"); if (childnode.Rows.Count > 0) { hasChildren = true; } TreeJsonEntity tree = new TreeJsonEntity(); tree.id = item["moduleid"].ToString(); tree.text = item["fullname"].ToString(); tree.value = item["moduleid"].ToString(); tree.checkstate = item["objectid"].ToString() != "" ? 1 : 0; tree.showcheck = true; tree.isexpand = true; tree.complete = true; tree.hasChildren = hasChildren; tree.parentId = item["parentid"].ToString(); tree.img = item["icon"].ToString() != null ? "/Content/Images/Icon16/" + item["icon"].ToString() : item["icon"].ToString(); TreeList.Add(tree); } } return(Content(TreeList.TreeToJson())); }
/// <summary> /// 左边分类列表(返回树JSON) /// </summary> /// <returns></returns> public ActionResult TreeJson() { List <Base_DataDictionary> list = DataFactory.Database().FindList <Base_DataDictionary>("ORDER BY SortCode ASC"); List <TreeJsonEntity> TreeList = new List <TreeJsonEntity>(); foreach (Base_DataDictionary item in list) { string DataDictionaryId = item.DataDictionaryId; bool hasChildren = false; List <Base_DataDictionary> childnode = list.FindAll(t => t.ParentId == DataDictionaryId); if (childnode.Count > 0) { hasChildren = true; } TreeJsonEntity tree = new TreeJsonEntity(); tree.id = DataDictionaryId; tree.text = item.FullName; tree.value = item.Code; tree.Attribute = "IsTree"; tree.AttributeValue = item.IsTree.ToString(); tree.isexpand = true; tree.complete = true; tree.hasChildren = hasChildren; tree.parentId = item.ParentId; TreeList.Add(tree); } return(Content(TreeList.TreeToJson())); }
/// <summary> /// 【公司管理】返回树JONS /// </summary> /// <returns></returns> public ActionResult TreeJson() { List <Base_Company> list = base_companybll.GetList(); List <TreeJsonEntity> TreeList = new List <TreeJsonEntity>(); foreach (Base_Company item in list) { bool hasChildren = false; IList childnode = list.FindAll(t => t.ParentId == item.CompanyId); if (childnode.Count > 0) { hasChildren = true; } TreeJsonEntity tree = new TreeJsonEntity(); tree.id = item.CompanyId; tree.text = item.FullName; tree.value = item.CompanyId; tree.Attribute = "Category"; tree.AttributeValue = item.Category; tree.isexpand = true; tree.complete = true; tree.hasChildren = hasChildren; tree.parentId = item.ParentId; if (item.ParentId == "0") { tree.img = "/Content/Images/Icon16/molecule.png"; } else { tree.img = "/Content/Images/Icon16/hostname.png"; } TreeList.Add(tree); } return(Content(TreeList.TreeToJson())); }
/// <summary> /// 快捷方式 返回菜单模块树JSON /// </summary> /// <returns></returns> public ActionResult ShortcutsModuleTreeJson() { BaseShortcutsBll base_shortcutsbll = new BaseShortcutsBll(); string UserId = ManageProvider.Provider.Current().UserId; List <Base_Module> ShortcutList = base_shortcutsbll.GetShortcutList(UserId); string ObjectId = ManageProvider.Provider.Current().ObjectId; List <Base_Module> list = base_modulepermissionbll.GetModuleList(ObjectId).FindAll(t => t.Enabled == 1); List <TreeJsonEntity> TreeList = new List <TreeJsonEntity>(); foreach (Base_Module item in list) { TreeJsonEntity tree = new TreeJsonEntity(); tree.id = item.ModuleId; tree.text = item.FullName; tree.value = item.ModuleId; if (item.Category == "页面") { tree.checkstate = ShortcutList.FindAll(t => t.ModuleId == item.ModuleId).Count == 0 ? 0 : 1; //tree.checkstate = item["objectid"].ToString() != "" ? 1 : 0; tree.showcheck = true; } tree.isexpand = true; tree.complete = true; tree.hasChildren = list.FindAll(t => t.ParentId == item.ModuleId).Count > 0 ? true : false; tree.parentId = item.ParentId; tree.img = item.Icon != null ? "/Content/Images/Icon16/" + item.Icon : item.Icon; TreeList.Add(tree); } return(Content(TreeList.TreeToJson())); }
/// <summary> /// 【模块管理】返回树JONS /// </summary> /// <returns></returns> public ActionResult TreeJson() { List <Base_Module> list = base_modulebll.GetList(); List <TreeJsonEntity> TreeList = new List <TreeJsonEntity>(); foreach (Base_Module item in list) { TreeJsonEntity tree = new TreeJsonEntity(); bool hasChildren = false; List <Base_Module> childnode = list.FindAll(t => t.ParentId == item.ModuleId); if (childnode.Count > 0) { hasChildren = true; } tree.id = item.ModuleId; tree.text = item.FullName; tree.value = item.ModuleId; tree.isexpand = item.Isexpand == 1 ? true : false; tree.complete = true; tree.hasChildren = hasChildren; tree.parentId = item.ParentId; tree.img = item.Icon != null ? "/Content/Images/Icon16/" + item.Icon : item.Icon; TreeList.Add(tree); } return(Content(TreeList.TreeToJson())); }
/// <summary> /// 加载无限树菜单 /// </summary> /// <returns></returns> public ActionResult LoadTreeMenu(string ModuleId) { string ObjectId = ManageProvider.Provider.Current().ObjectId; List <Base_Module> list = base_modulepermissionbll.GetModuleList(ObjectId).FindAll(t => t.Enabled == 1); List <TreeJsonEntity> TreeList = new List <TreeJsonEntity>(); foreach (Base_Module item in list) { TreeJsonEntity tree = new TreeJsonEntity(); bool hasChildren = false; List <Base_Module> childnode = list.FindAll(t => t.ParentId == item.ModuleId); if (childnode.Count > 0) { hasChildren = true; } if (item.Category == "页面") { tree.Attribute = "Location"; tree.AttributeValue = item.Location; } tree.id = item.ModuleId; tree.text = item.FullName; tree.value = item.ModuleId; tree.isexpand = false; tree.complete = true; tree.hasChildren = hasChildren; tree.parentId = item.ParentId; tree.img = item.Icon != null ? "/Content/Images/Icon16/" + item.Icon : item.Icon; TreeList.Add(tree); } return(Content(TreeList.TreeToJson(ModuleId))); }
/// <summary> /// 返回 物流方式Json树 /// </summary> /// <returns></returns> public ActionResult TreeJson() { List <ShipTypeEntity> list = _shipTypeBLL.GetList(); List <TreeJsonEntity> treeList = new List <TreeJsonEntity>(); TreeJsonEntity tree = new TreeJsonEntity(); tree.id = "1"; tree.text = "全部"; tree.value = ""; tree.parentId = "0"; tree.isexpand = true; tree.complete = true; tree.hasChildren = true; tree.img = "/Content/Images/Icon16/basket_shopping.png"; treeList.Add(tree); foreach (ShipTypeEntity entity in list) { TreeJsonEntity node = new TreeJsonEntity(); node.id = entity.ShipTypeId; node.text = entity.ShipTypeName; node.value = entity.ShipTypeId; node.parentId = "1"; node.isexpand = true; node.complete = true; node.hasChildren = false; node.img = "/Content/Images/Icon16/basket_shopping.png"; treeList.Add(node); } return(Content(treeList.TreeToJson())); }
/// <summary> /// 查看拥有视图权限 返回树JSON /// </summary> /// <param name="ObjectId">对象主键</param> /// <returns></returns> public ActionResult LookViewPermission(string ObjectId) { //如果ObjectId为空。自动获取当前登录用户拥有权限 if (string.IsNullOrEmpty(ObjectId)) { ObjectId = ManageProvider.Provider.Current().ObjectId; } DataTable dt = base_viewpermissionbll.GetViewPermission(ObjectId); List <TreeJsonEntity> TreeList = new List <TreeJsonEntity>(); if (!DataHelper.IsExistRows(dt)) { foreach (DataRow item in dt.Rows) { string id = item["id"].ToString(); bool hasChildren = false; DataTable childnode = DataHelper.GetNewDataTable(dt, "ParentId = '" + id + "'"); if (childnode.Rows.Count > 0) { hasChildren = true; } TreeJsonEntity tree = new TreeJsonEntity(); tree.id = item["id"].ToString(); tree.text = item["fullname"].ToString(); tree.value = item["id"].ToString(); tree.isexpand = true; tree.complete = true; tree.hasChildren = hasChildren; tree.parentId = item["parentid"].ToString(); tree.img = item["icon"].ToString() != "" ? "/Content/Images/Icon16/" + item["icon"].ToString() : "/Content/Images/Icon16/tag_blue.png"; TreeList.Add(tree); } } return(Content(TreeList.TreeToJson())); }
/// <summary> /// 加载岗位 /// <param name="ObjectId">对象主键</param> /// <param name="Category">对象分类:1-部门2-角色3-岗位4-群组</param> /// </summary> /// <returns></returns> public ActionResult ScopeUserGroupList(string ObjectId, string Category) { string ModuleId = "b863d076-37bb-45aa-8318-37942026921e"; DataTable DataList = base_datascopepermissionbll.GetScopeUserGroupList(ModuleId, ObjectId, Category); List <TreeJsonEntity> TreeList = new List <TreeJsonEntity>(); if (!DataHelper.IsExistRows(DataList)) { foreach (DataRow row in DataList.Rows) { TreeJsonEntity tree = new TreeJsonEntity(); string PostId = row["id"].ToString(); bool hasChildren = false; DataTable childnode = DataHelper.GetNewDataTable(DataList, "parentid='" + PostId + "'"); if (childnode.Rows.Count > 0) { hasChildren = true; } else { if (row["sort"].ToString() == "Company" || row["sort"].ToString() == "Department") { continue; } } if (row["parentid"].ToString() != "0") { tree.checkstate = row["objectid"].ToString() != "" ? 1 : 0; tree.showcheck = true; } tree.id = PostId; tree.text = row["fullname"].ToString(); tree.value = row["code"].ToString(); tree.parentId = row["parentid"].ToString(); tree.isexpand = true; tree.complete = true; tree.hasChildren = hasChildren; if (row["parentid"].ToString() == "0") { tree.img = "/Content/Images/Icon16/molecule.png"; } else if (row["sort"].ToString() == "Company") { tree.img = "/Content/Images/Icon16/hostname.png"; } else if (row["sort"].ToString() == "Department") { tree.img = "/Content/Images/Icon16/chart_organisation.png"; } else if (row["sort"].ToString() == "UserGroup") { tree.img = "/Content/Images/Icon16/group_gear.png"; } TreeList.Add(tree); } } return(Content(TreeList.TreeToJson())); }
/// <summary> /// 加载角色 /// <param name="objectId">对象主键</param> /// <param name="category">对象分类:1-部门2-角色</param> /// </summary> /// <returns></returns> public ActionResult ScopeRoleList(string objectId, string category) { string moduleId = "cef74b80-24a5-4d77-9ede-bbbc75cdb431"; DataTable dataList = _baseDatascopepermissionbll.GetScopeRoleList(moduleId, objectId, category); List <TreeJsonEntity> treeList = new List <TreeJsonEntity>(); if (!DataHelper.IsExistRows(dataList)) { foreach (DataRow row in dataList.Rows) { TreeJsonEntity tree = new TreeJsonEntity(); string roleId = row["roleid"].ToString(); bool hasChildren = false; DataTable childnode = DataHelper.GetNewDataTable(dataList, "parentid='" + roleId + "'"); if (childnode.Rows.Count > 0) { hasChildren = true; } else { if (row["sort"].ToString() == "Company") { continue; } } if (row["parentid"].ToString() != "0") { tree.checkstate = row["objectid"].ToString() != "" ? 1 : 0; tree.showcheck = true; } tree.id = roleId; tree.text = row["fullname"].ToString(); tree.value = row["code"].ToString(); tree.parentId = row["parentid"].ToString(); tree.Attribute = "Type"; tree.AttributeValue = row["sort"].ToString(); tree.isexpand = true; tree.complete = true; tree.hasChildren = hasChildren; if (row["parentid"].ToString() == "0") { tree.img = "/Content/Images/Icon16/molecule.png"; } else if (row["sort"].ToString() == "Company") { tree.img = "/Content/Images/Icon16/hostname.png"; } else if (row["sort"].ToString() == "Roles") { tree.img = "/Content/Images/Icon16/role.png"; } treeList.Add(tree); } } return(Content(treeList.TreeToJson())); }
/// <summary> /// 加载部门 /// <param name="objectId">对象主键</param> /// <param name="category">对象分类:1-部门2-角色</param> /// </summary> /// <returns></returns> public ActionResult ScopeWarehouseList(string objectId, string category) { string moduleId = "f19b29b4-3edc-4d17-adc9-165c03020fa9"; DataTable dataList = _baseDatascopepermissionbll.GetScopeWarehouseList(moduleId, objectId, category); List <TreeJsonEntity> treeList = new List <TreeJsonEntity>(); if (!DataHelper.IsExistRows(dataList)) { foreach (DataRow row in dataList.Rows) { TreeJsonEntity tree = new TreeJsonEntity(); string warehouseId = row["WarehouseId"].ToString(); bool hasChildren = false; DataTable childnode = DataHelper.GetNewDataTable(dataList, "parentid='" + warehouseId + "'"); if (childnode.Rows.Count > 0) { hasChildren = true; } else { if (row["sort"].ToString() == "Company") { continue; } } if (row["parentid"].ToString() != "0") { tree.checkstate = row["objectid"].ToString() != "" ? 1 : 0; tree.showcheck = true; } tree.id = warehouseId; tree.text = row["fullname"].ToString(); tree.value = row["code"].ToString(); tree.parentId = row["parentid"].ToString(); tree.isexpand = true; tree.complete = true; tree.hasChildren = hasChildren; if (row["parentid"].ToString() == "0") { tree.img = "/Content/Images/Icon16/molecule.png"; } else if (row["sort"].ToString() == "Company") { tree.img = "/Content/Images/Icon16/hostname.png"; } else if (row["sort"].ToString() == "Department") { tree.img = "/Content/Images/Icon16/chart_organisation.png"; } treeList.Add(tree); } } return(Content(treeList.TreeToJson())); }
/// <summary> /// 返回 树JONS /// </summary> /// <returns></returns> public ActionResult TreeJson(string Number) { IDatabase database = DataFactory.Database(); string sql = "select Number,Name from Ho_HouseInfo where 1=1"; if (!StringHelper.IsNullOrEmpty(Number)) { sql += " and Number = '" + Number + "'"; } var houseList = database.FindListBySql <Ho_HouseInfo>(sql); List <TreeJsonEntity> TreeList = new List <TreeJsonEntity>(); foreach (var houseModel in houseList) { if (houseModel != null) { TreeJsonEntity tree = new TreeJsonEntity(); tree.id = houseModel.Number; tree.text = houseModel.Name; tree.parentId = "0"; tree.Attribute = "Type"; tree.AttributeValue = "House"; tree.isexpand = true; tree.complete = true; tree.hasChildren = true; tree.img = "/Content/Images/Icon16/house_one.png"; TreeList.Add(tree); //剩余四个图册 var dicList = database.FindList <Base_DataDictionaryDetail>(" and DataDictionaryId = '9ff7250d-bb28-44ac-a721-04bf33325a85'"); if (dicList != null) { foreach (var item in dicList) { var treeModel = new TreeJsonEntity() { id = item.DataDictionaryDetailId, text = item.FullName, parentId = houseModel.Number, value = houseModel.Number, Attribute = "Type", AttributeValue = "Group", isexpand = true, complete = true, hasChildren = false, img = "/Content/Images/Icon16/image.png" }; TreeList.Add(treeModel); } } } } return(Content(TreeList.TreeToJson())); }
/// <summary> /// 加载部门 /// <param name="ObjectId">对象主键</param> /// <param name="Category">对象分类:1-部门2-角色</param> /// </summary> /// <returns></returns> public ActionResult ScopeDepartmentList(string ObjectId, string Category) { string ModuleId = "e84c0fca-d912-4f5c-a25e-d5765e33b0d2"; DataTable dataList = _baseDatascopepermissionbll.GetScopeDepartmentList(ModuleId, ObjectId, Category); List <TreeJsonEntity> treeList = new List <TreeJsonEntity>(); if (!DataHelper.IsExistRows(dataList)) { foreach (DataRow row in dataList.Rows) { TreeJsonEntity tree = new TreeJsonEntity(); string departmentId = row["departmentid"].ToString(); bool hasChildren = false; DataTable childnode = DataHelper.GetNewDataTable(dataList, "parentid='" + departmentId + "'"); if (childnode.Rows.Count > 0) { hasChildren = true; } else { if (row["sort"].ToString() == "Company") { continue; } } if (row["parentid"].ToString() != "0") { tree.checkstate = row["objectid"].ToString() != "" ? 1 : 0; tree.showcheck = true; } tree.id = departmentId; tree.text = row["fullname"].ToString(); tree.value = row["code"].ToString(); tree.parentId = row["parentid"].ToString(); tree.isexpand = true; tree.complete = true; tree.hasChildren = hasChildren; if (row["parentid"].ToString() == "0") { tree.img = "/Content/Images/Icon16/molecule.png"; } else if (row["sort"].ToString() == "Company") { tree.img = "/Content/Images/Icon16/hostname.png"; } else if (row["sort"].ToString() == "Department") { tree.img = "/Content/Images/Icon16/chart_organisation.png"; } treeList.Add(tree); } } return(Content(treeList.TreeToJson())); }
/// <summary> /// 加载公司 /// <param name="objectId">对象主键</param> /// <param name="category">对象分类:1-部门2-角色</param> /// </summary> /// <returns></returns> public ActionResult ScopeCompanyList(string objectId, string category) { string ModuleId = "b29cabd8-ffb6-4d34-9d08-ee1dba2b5b6b"; DataTable dataList = _baseDatascopepermissionbll.GetScopeCompanyList(ModuleId, objectId, category); List <TreeJsonEntity> treeList = new List <TreeJsonEntity>(); if (!DataHelper.IsExistRows(dataList)) { foreach (DataRow item in dataList.Rows) { bool hasChildren = false; DataTable childnode = DataHelper.GetNewDataTable(dataList, "parentid = '" + item["companyid"].ToString() + "'"); if (childnode.Rows.Count > 0) { hasChildren = true; } TreeJsonEntity tree = new TreeJsonEntity(); tree.id = item["companyid"].ToString(); tree.text = item["fullname"].ToString(); tree.value = item["code"].ToString(); tree.checkstate = item["objectid"].ToString() != "" ? 1 : 0; tree.showcheck = true; tree.isexpand = true; tree.complete = true; tree.hasChildren = hasChildren; tree.parentId = item["parentid"].ToString(); if (item["parentid"].ToString() == "0") { tree.img = "/Content/Images/Icon16/molecule.png"; } else { tree.img = "/Content/Images/Icon16/hostname.png"; } treeList.Add(tree); } } else { TreeJsonEntity tree = new TreeJsonEntity(); tree.id = ""; tree.text = "<span style='color:red'>没有找到您要的相关数据...</span>"; tree.value = ""; tree.isexpand = true; tree.complete = true; tree.hasChildren = false; tree.parentId = "0"; tree.img = "/Content/Images/Icon32/database_red.png"; treeList.Add(tree); } return(Content(treeList.TreeToJson())); }
/// <summary> /// 查看拥有按钮权限 返回树JSON /// </summary> /// <param name="ObjectId">对象主键</param> /// <returns></returns> public ActionResult LookButtonePermission(string ObjectId) { //如果ObjectId为空。自动获取当前登录用户拥有权限 if (string.IsNullOrEmpty(ObjectId)) { ObjectId = ManageProvider.Provider.Current().ObjectId; } DataTable dt = _baseButtonpermissionbll.GetButtonePermission(ObjectId); List <TreeJsonEntity> TreeList = new List <TreeJsonEntity>(); if (!DataHelper.IsExistRows(dt)) { foreach (DataRow item in dt.Rows) { string text = ""; if (item["Sort"].ToString() == "按钮") { if (item["Category"].ToString() == "1") { text = item["fullname"].ToString() + "(工具栏)"; } else if (item["Category"].ToString() == "2") { text = item["fullname"].ToString() + "(右击栏)"; } } else { text = item["fullname"].ToString(); } string id = item["id"].ToString(); bool hasChildren = false; DataTable childnode = DataHelper.GetNewDataTable(dt, "ParentId = '" + id + "'"); if (childnode.Rows.Count > 0) { hasChildren = true; } TreeJsonEntity tree = new TreeJsonEntity(); tree.id = item["id"].ToString(); tree.text = text; tree.value = item["id"].ToString(); tree.isexpand = true; tree.complete = true; tree.hasChildren = hasChildren; tree.parentId = item["parentid"].ToString(); tree.img = item["icon"].ToString() != string.Empty ? "/Content/Images/Icon16/" + item["icon"].ToString() : item["icon"].ToString(); TreeList.Add(tree); } } return(Content(TreeList.TreeToJson())); }
/// <summary> /// 加载文件夹目录 /// </summary> /// <param name="FolderId">文件夹Id</param> /// <returns></returns> public ActionResult TreeJson(string FolderId) { List <Base_NetworkFolder> list = new List <Base_NetworkFolder>(); if (!string.IsNullOrEmpty(FolderId)) { //查询所有子文件夹(递归) list = base_networkfilebll.GetChildrenNodeList(FolderId); } else { list = repositoryfactory.Repository().FindList(); } List <TreeJsonEntity> TreeList = new List <TreeJsonEntity>(); int ParentId_index = 0; foreach (Base_NetworkFolder item in list) { TreeJsonEntity tree = new TreeJsonEntity(); bool hasChildren = false; List <Base_NetworkFolder> childnode = list.FindAll(t => t.ParentId == item.FolderId); if (childnode.Count > 0) { hasChildren = true; } tree.id = item.FolderId; tree.text = item.FolderName; tree.value = item.FolderId; if (item.ParentId == "0") { if (ParentId_index == 0) { tree.isexpand = true; } else { tree.isexpand = false; } ParentId_index++; } else { tree.isexpand = false; } tree.complete = true; tree.hasChildren = hasChildren; tree.Attribute = "IsPublic"; tree.AttributeValue = item.IsPublic.ToString(); tree.parentId = item.ParentId; TreeList.Add(tree); } return(Content(TreeList.TreeToJson())); }
public ActionResult TreeJson() { DataTable dt = departmentbll.GetTree(DepartmentRe); List <TreeJsonEntity> TreeList = new List <TreeJsonEntity>(); if (!DataHelper.IsExistRows(dt)) { foreach (DataRow row in dt.Rows) { string DepartmentId = row["departmentid"].ToString(); bool hasChildren = false; DataTable childnode = DataHelper.GetNewDataTable(dt, "parentid='" + DepartmentId + "'"); if (childnode.Rows.Count > 0) { hasChildren = true; } TreeJsonEntity tree = new TreeJsonEntity(); tree.id = DepartmentId; tree.text = row["DepartmentName"].ToString(); tree.value = row["departmentid"].ToString(); tree.parentId = row["parentid"].ToString(); tree.isexpand = true; tree.complete = true; tree.hasChildren = hasChildren; if (row["parentid"].ToString() == "0") { //tree.img = "/Content/Images/Icon16/molecule.png"; tree.img = "/Scripts/tree/images/icons/hostname.png"; } else if (row["parentid"].ToString() == "-1") { tree.img = "/Scripts/tree/images/icons/molecule.png"; } else { tree.img = "/Scripts/tree/images/icons/chart_organisation.png"; } //else if (row["sort"].ToString() == "Company") //{ // tree.img = "/Content/Images/Icon16/hostname.png"; //} //else if (row["sort"].ToString() == "Department") //{ // tree.img = "/Content/Images/Icon16/chart_organisation.png"; //} TreeList.Add(tree); } } return(Content(TreeList.TreeToJson())); }
/// <summary> /// 返回 树JONS /// </summary> /// <returns></returns> public ActionResult TreeJson(string Number) { IDatabase database = DataFactory.Database(); string sql = "select Number,CollectorCode from Am_Collector where 1=1"; //用户限定 if (ManageProvider.Provider.Current().DepartmentId == "运营商") { sql += " and UNumber = '" + ManageProvider.Provider.Current().CompanyId + "'"; } if (!StringHelper.IsNullOrEmpty(Number)) { sql += " and Collector_Number = '" + Number + "'"; } var list = database.FindListBySql <Am_Collector>(sql); List <TreeJsonEntity> TreeList = new List <TreeJsonEntity>(); TreeJsonEntity tree = new TreeJsonEntity(); tree.id = ""; tree.text = "所有采集器"; tree.parentId = "0"; tree.Attribute = "Type"; tree.AttributeValue = "Parent"; tree.isexpand = true; tree.complete = true; tree.hasChildren = true; tree.img = "/Content/Images/Icon16/folder.png"; TreeList.Add(tree); foreach (var item in list) { if (item != null) { TreeJsonEntity tree1 = new TreeJsonEntity(); tree1.id = item.Number; tree1.text = item.CollectorCode; tree1.parentId = ""; tree1.Attribute = "Type"; tree1.AttributeValue = "Collector"; tree1.isexpand = true; tree1.complete = true; tree1.hasChildren = false; tree1.img = "/Content/Images/Icon16/report.png"; TreeList.Add(tree1); } } return(Content(TreeList.TreeToJson())); }
/// <summary> /// 返回 商户、店铺Json树 /// </summary> /// <returns></returns> public ActionResult TreeJson() { DataTable dt = _mallBll.GetTree(); List <TreeJsonEntity> TreeList = new List <TreeJsonEntity>(); if (!DataHelper.IsExistRows(dt)) { foreach (DataRow row in dt.Rows) { string MallId = row["MallId"].ToString(); bool hasChildren = false; DataTable childnode = DataHelper.GetNewDataTable(dt, "MallId='" + MallId + "'"); if (childnode.Rows.Count > 0) { hasChildren = true; } TreeJsonEntity tree = new TreeJsonEntity(); tree.id = MallId; tree.text = row["MallName"].ToString(); tree.value = row["Code"].ToString(); tree.parentId = row["ParentId"].ToString(); tree.Attribute = "Type"; tree.AttributeValue = row["Sort"].ToString(); tree.AttributeA = "MerchantId"; tree.AttributeValueA = row["MerchantId"].ToString(); tree.isexpand = true; tree.complete = true; tree.hasChildren = hasChildren; if (row["ParentId"].ToString() == "0") { tree.img = "/Content/Images/Icon16/basket_shopping.png"; } else if (row["sort"].ToString() == "Merchant") { tree.img = "/Content/Images/Icon16/basket_shopping.png"; } else if (row["sort"].ToString() == "Mall") { tree.img = "/Content/Images/Icon16/chart_organisation.png"; } TreeList.Add(tree); } } return(Content(TreeList.TreeToJson())); }
/// <summary> /// 返回 商户、分类Json树 /// </summary> /// <returns></returns> public ActionResult TreeJson() { DataTable dt = _productCategoryBLL.GetTree(); List <TreeJsonEntity> treeList = new List <TreeJsonEntity>(); TreeJsonEntity rootNode = new TreeJsonEntity(); rootNode.id = "0"; rootNode.text = "全部"; rootNode.value = "0"; rootNode.parentId = "-1"; rootNode.isexpand = true; rootNode.complete = true; rootNode.hasChildren = true; rootNode.img = "/Content/Images/Icon16/chart_organisation.png"; treeList.Add(rootNode); if (!DataHelper.IsExistRows(dt)) { foreach (DataRow row in dt.Rows) { string categoryId = row["CategoryId"].ToString(); bool hasChildren = false; DataTable childnode = DataHelper.GetNewDataTable(dt, "ParentId='" + categoryId + "'"); if (childnode.Rows.Count > 0) { hasChildren = true; } TreeJsonEntity tree = new TreeJsonEntity(); tree.id = categoryId; tree.text = row["CategoryName"].ToString(); tree.value = row["Code"].ToString(); tree.parentId = row["ParentId"].ToString(); tree.isexpand = true; tree.complete = true; tree.hasChildren = hasChildren; tree.img = "/Content/Images/Icon16/chart_organisation.png"; treeList.Add(tree); } } return(Content(treeList.TreeToJson("-1"))); }
/// <summary> /// 根据分类Id》获取数据字典明显列表(返回树JSON) /// </summary> /// <param name="DataDictionaryId">分类主键</param> /// <returns></returns> public ActionResult DataDictionaryDetailJson(string DataDictionaryId) { List <Base_DataDictionaryDetail> list = base_datadictionarybll.GetDataDictionaryDetailList(DataDictionaryId); List <TreeJsonEntity> TreeList = new List <TreeJsonEntity>(); foreach (Base_DataDictionaryDetail item in list) { TreeJsonEntity tree = new TreeJsonEntity(); tree.id = item.DataDictionaryDetailId; tree.text = item.FullName; tree.value = item.Code; tree.isexpand = true; tree.complete = true; tree.hasChildren = false; tree.parentId = item.ParentId; TreeList.Add(tree); } return(Content(TreeList.TreeToJson())); }
/// <summary> /// 返回 树JONS /// </summary> /// <returns></returns> public ActionResult TreeJson(string Number) { IDatabase database = DataFactory.Database(); string sql = "select Number,Name,ClassPic,ParenNumber,ParenName,ClassOrder,ClassUrl,StatusStr,Status,Remark from Fx_NewsClass where 1=1"; if (!StringHelper.IsNullOrEmpty(Number)) { sql += " and ParenNumber = '" + Number + "'"; } var list = database.FindListBySql <Fx_NewsClass>(sql); List <TreeJsonEntity> TreeList = new List <TreeJsonEntity>(); TreeJsonEntity tree = new TreeJsonEntity(); tree.id = "x999"; tree.text = "根栏目"; tree.parentId = "0"; tree.Attribute = "Type"; tree.AttributeValue = "Parent"; tree.isexpand = true; tree.complete = true; tree.hasChildren = true; tree.img = "/Content/Images/Icon16/folder.png"; TreeList.Add(tree); foreach (var item in list) { if (item != null) { TreeJsonEntity tree1 = new TreeJsonEntity(); tree1.id = item.Number; tree1.text = item.Name; tree1.parentId = item.ParenNumber == "0"? "x999" : item.ParenNumber; tree1.Attribute = "Type"; tree1.AttributeValue = "NewsClass"; tree1.isexpand = true; tree1.complete = true; tree1.hasChildren = item.IsHasChild == 0 ? false : true; //0为没有,其他则有 tree1.img = "/Content/Images/Icon16/report.png"; TreeList.Add(tree1); } } return(Content(TreeList.TreeToJson())); }
/// <summary> /// 加载模块目录 /// </summary> /// <returns></returns> public ActionResult TreeJson() { List <Base_Module> list = _baseModulebll.GetList(); List <TreeJsonEntity> TreeList = new List <TreeJsonEntity>(); foreach (Base_Module item in list) { string ModuleId = item.ModuleId; bool hasChildren = false; List <Base_Module> childnode = list.FindAll(t => t.ParentId == ModuleId); if (childnode.Count > 0) { hasChildren = true; } else { if (item.Category == "目录") { continue; } } if (item.Category == "页面") { if (item.AllowButton != 1) { continue; } } TreeJsonEntity tree = new TreeJsonEntity(); tree.id = ModuleId; tree.text = item.FullName; tree.value = ModuleId; tree.isexpand = true; tree.complete = true; tree.hasChildren = hasChildren; tree.parentId = item.ParentId; tree.img = item.Icon != null ? "/Content/Images/Icon16/" + item.Icon : item.Icon; TreeList.Add(tree); } return(Content(TreeList.TreeToJson())); }
/// <summary> /// 配送商管理返回树Json /// </summary> /// <returns></returns> public ActionResult TreeJson() { List <ShipVendorEntity> list = _shipVendorBll.GetList(); List <TreeJsonEntity> treeList = new List <TreeJsonEntity>(); foreach (ShipVendorEntity item in list) { TreeJsonEntity tree = new TreeJsonEntity(); tree.id = item.ShipVendorId; tree.text = item.FullName; tree.value = item.ShipVendorId; tree.Attribute = "Code"; tree.AttributeValue = item.Code; tree.isexpand = true; tree.complete = true; tree.hasChildren = false; tree.parentId = "0"; tree.img = "/Content/Images/Icon16/account_balances.png"; treeList.Add(tree); } return(Content(treeList.TreeToJson())); }
/// <summary> /// 加载模块 返回树JSON /// </summary> /// <param name="objectId">对象主键</param> /// <param name="category">对象分类:1-部门2-角色</param> /// <returns></returns> public ActionResult ModuleTree(string objectId, string category) { DataTable dt = _baseModulepermissionbll.GetList(objectId, category); List <TreeJsonEntity> treeList = new List <TreeJsonEntity>(); if (!DataHelper.IsExistRows(dt)) { foreach (DataRow item in dt.Rows) { string moduleId = item["moduleid"].ToString(); bool hasChildren = false; DataTable childnode = DataHelper.GetNewDataTable(dt, "ParentId = '" + moduleId + "'"); if (childnode.Rows.Count > 0) { hasChildren = true; } var tree = new TreeJsonEntity { id = item["moduleid"].ToString(), text = item["fullname"].ToString(), value = item["moduleid"].ToString(), checkstate = item["objectid"].ToString() != "" ? 1 : 0, showcheck = true, isexpand = true, complete = true, hasChildren = hasChildren, parentId = item["parentid"].ToString(), img = item["icon"].ToString() != string.Empty ? "/Content/Images/Icon16/" + item["icon"].ToString() : item["icon"].ToString() }; treeList.Add(tree); } } return(Content(treeList.TreeToJson())); }
/// <summary> /// 返回仓库列表树 /// </summary> /// <returns></returns> public ActionResult TreeJson() { var list = _warehouseBLL.GetList(); var treeList = new List <TreeJsonEntity>(); var tree = new TreeJsonEntity(); tree.id = "1"; tree.text = "全部"; tree.value = ""; tree.parentId = "0"; tree.isexpand = true; tree.complete = true; tree.hasChildren = true; tree.img = "/Content/Images/Icon16/basket_shopping.png"; treeList.Add(tree); foreach (WarehouseEntity entity in list) { var node = new TreeJsonEntity { id = entity.WarehouseId, text = entity.WarehouseName, value = entity.WarehouseId, parentId = "1", isexpand = true, complete = true, hasChildren = false, img = "/Content/Images/Icon16/basket_shopping.png" }; treeList.Add(node); } return(Content(treeList.TreeToJson())); }
/// <summary> /// 单据打印项 /// </summary> /// <returns></returns> public ActionResult PrintItemTree(string templateId) { var senderItems = new Dictionary <string, string> { { "$SenderName", "发件人姓名" }, { "$SenderPhone", "发件人电话" }, { "$SenderCellPhone", "发件人手机号" }, { "$MallName", "店铺名称" }, { "$SenderProvince", "发件人-省" }, { "$SenderCity", "发件人-市" }, { "$SenderContry", "发件人-区" }, { "$SenderAddress", "发件人地址" }, { "$SenderZipCode", "发件人邮编" } }; var receiverItems = new Dictionary <string, string> { { "$ReceiverName", "收件人姓名" }, { "$ReceiverPhone", "收件人电话" }, { "$ReceiverCellPhone", "收件人手机号" }, { "$ReceiverProvince", "收件人-省" }, { "$ReceiverCity", "收件人-市" }, { "$ReceiverContry", "收件人-区" }, { "$ReceiverAddress", "收件人地址" }, { "$ReceiverZipCode", "收件人邮编" } }; var orderItems = new Dictionary <string, string> { { "$OrderNo", "订单编号" }, { "$OrderItmes", "物品数量" }, { "$Remark", "派件备注" }, { "$Select", "√" }, { "$CustomContent", "自定义内容" } }; List <TreeJsonEntity> treeList = new List <TreeJsonEntity>(); TreeJsonEntity senderNode = new TreeJsonEntity { id = "Sender", text = "发件人信息", value = "", parentId = "0", isexpand = true, complete = true, hasChildren = true, showcheck = false, img = "/Content/Images/Icon16/basket_shopping.png" }; treeList.Add(senderNode); treeList.AddRange(senderItems.Select(entity => new TreeJsonEntity { id = entity.Key, text = entity.Value, value = entity.Value, parentId = "Sender", isexpand = true, showcheck = true, complete = true, hasChildren = false, img = "/Content/Images/Icon16/basket_shopping.png" })); TreeJsonEntity receiverNode = new TreeJsonEntity { id = "Receiver", text = "收件人信息", value = "", parentId = "0", isexpand = true, complete = true, hasChildren = true, showcheck = false, img = "/Content/Images/Icon16/basket_shopping.png" }; treeList.Add(receiverNode); treeList.AddRange(receiverItems.Select(entity => new TreeJsonEntity { id = entity.Key, text = entity.Value, value = entity.Value, parentId = "Receiver", isexpand = true, showcheck = true, complete = true, hasChildren = false, img = "/Content/Images/Icon16/basket_shopping.png" })); var orderNode = new TreeJsonEntity { id = "Order", text = "订单信息", value = "", parentId = "0", isexpand = true, complete = true, hasChildren = true, showcheck = false, img = "/Content/Images/Icon16/basket_shopping.png" }; treeList.Add(orderNode); treeList.AddRange(orderItems.Select(entity => new TreeJsonEntity { id = entity.Key, text = entity.Value, value = entity.Value, parentId = "Order", isexpand = true, showcheck = true, complete = true, hasChildren = false, img = "/Content/Images/Icon16/basket_shopping.png" })); ShipTypeTemplateEntity template = _templateBLL.GetTemplate(templateId); if (template != null) { foreach (TreeJsonEntity treeJsonEntity in treeList) { if (template.TemplateContent.IndexOf(treeJsonEntity.id, StringComparison.InvariantCultureIgnoreCase) != -1) { treeJsonEntity.checkstate = 1; } } } return(Content(treeList.TreeToJson())); }
public void LoadAction() { Response.Buffer = true; Response.ExpiresAbsolute = System.DateTime.Now.AddSeconds(-1); Response.Expires = 0; Response.CacheControl = "no-cache"; Response.AddHeader("Pragma", "No-Cache"); string active = HttpContext.Current.Request["action"]; //提交类型 string ModuleId = HttpContext.Current.Request["ModuleId"]; MenuModel model = new MenuDal(); string strWhere = ""; switch (active) { case "LoadAccordionMenu": //加载手风琴菜单 StringBuilder sb_html = new StringBuilder(); try { if (this.Session["User"] != null) { string power = ((UserModel)this.Session["User"]).Power; if (power != "") { if (((UserModel)this.Session["User"]).UserName != "admin") { strWhere = "patindex('%|'||rtrim(PowerCode)||'|%','|" + power + "|')>0 or ISCHECKPOWER='0'"; } } } this.dbo = new DB_OPT(); this.dbo.Open(); DataTable dt = model.GetList(strWhere, dbo).Tables[0]; DataRow[] rows = dt.Select("Grade='0' and IsShow='1'"); foreach (DataRow dr in rows) { sb_html.Append("<li title=" + dr["MENUNAME"] + ">"); sb_html.Append("<div class=\"link\">"); sb_html.Append("<img src=" + dr["IMGURL"] + "> <span>" + dr["MENUNAME"] + "</span><i class=\"chevron-down\"></i>"); sb_html.Append("</div>"); sb_html.Append("<div id=\"" + dr["MEMUPK"].ToString().Trim() + "\" class=\"submenu bottomline\"></div>"); sb_html.Append("</li>"); } } catch (Exception exception) { this.el = new ExceptionLog.ExceptionLog(); this.el.ErrClassName = base.GetType().ToString(); this.el.ErrMessage = exception.Message.ToString(); this.el.ErrMethod = "Page_Load()"; this.el.WriteExceptionLog(true); PageShowText.OpenErrorPage("获取数据失败,请联系管理员!", this.Page); } finally { if (this.dbo != null) { this.dbo.Close(); } } Response.Write(sb_html.ToString()); Response.End(); break; case "LoadTreeMenu": //加载子树菜单 if (this.Session["User"] != null) { string power = ((UserModel)this.Session["User"]).Power; if (power != "") { if (((UserModel)this.Session["User"]).UserName != "admin") { strWhere = "patindex('%|'||rtrim(PowerCode)||'|%','|" + power + "|')>0 or ISCHECKPOWER='0'"; } } } this.dbo = new DB_OPT(); this.dbo.Open(); DataTable submenu_dt = model.GetList(strWhere, dbo).Tables[0]; DataRow[] submenu_rows = submenu_dt.Select("IsShow='1'"); List<TreeJsonEntity> TreeList = new List<TreeJsonEntity>(); foreach (DataRow dr in submenu_rows) { TreeJsonEntity tree = new TreeJsonEntity(); bool hasChildren = false; DataRow[] childnode = submenu_dt.Select("FatherPK='" + dr["MEMUPK"].ToString() + "'"); if (childnode.Length > 0) { hasChildren = true; } tree.id = dr["MEMUPK"].ToString().Trim(); tree.text = dr["MENUNAME"].ToString(); tree.value = dr["MEMUPK"].ToString().Trim(); tree.title = dr["PAGEURL"].ToString().Trim(); tree.img = dr["IMGURL"].ToString().Trim(); tree.isexpand = false; tree.complete = true; tree.hasChildren = hasChildren; tree.parentId = dr["FATHERPK"].ToString(); TreeList.Add(tree); } string str = TreeList.TreeToJson(ModuleId).Trim(); Response.Write(TreeList.TreeToJson(ModuleId).Trim()); Response.End(); break; default: break; } }
/// <summary> /// 加载岗位 /// <param name="ObjectId">对象主键</param> /// <param name="Category">对象分类:1-部门2-角色</param> /// </summary> /// <returns></returns> public ActionResult ScopeUserList(string ObjectId, string Category) { string moduleId = "58e86c4c-8022-4d30-95d5-b3d0eedcc878"; DataTable dataList = _baseDatascopepermissionbll.GetScopeUserList(moduleId, ObjectId, Category); List <TreeJsonEntity> treeList = new List <TreeJsonEntity>(); if (!DataHelper.IsExistRows(dataList)) { foreach (DataRow row in dataList.Rows) { TreeJsonEntity tree = new TreeJsonEntity(); string postId = row["id"].ToString(); bool hasChildren = false; DataTable childnode = DataHelper.GetNewDataTable(dataList, "parentid='" + postId + "'"); if (childnode.Rows.Count > 0) { hasChildren = true; } else { if (row["sort"].ToString() == "Company" || row["sort"].ToString() == "Department") { continue; } } if (row["parentid"].ToString() != "0") { tree.checkstate = row["objectid"].ToString() != "" ? 1 : 0; tree.showcheck = true; } tree.id = postId; tree.text = row["fullname"].ToString(); tree.value = row["code"].ToString(); tree.parentId = row["parentid"].ToString(); tree.isexpand = true; tree.complete = true; tree.hasChildren = hasChildren; if (row["parentid"].ToString() == "0") { tree.img = "/Content/Images/Icon16/molecule.png"; } else if (row["sort"].ToString() == "Company") { tree.img = "/Content/Images/Icon16/hostname.png"; } else if (row["sort"].ToString() == "Department") { tree.img = "/Content/Images/Icon16/chart_organisation.png"; } else if (row["sort"].ToString() == "User") { if (row["gender"].ToString() == "男") { tree.img = "/Content/Images/Icon16/user_green.png"; } else if (row["gender"].ToString() == "女") { tree.img = "/Content/Images/Icon16/user_female.png"; } } treeList.Add(tree); } } return(Content(treeList.TreeToJson())); }