private string Query(HttpContext context) { StringBuilder sbWhere = new StringBuilder(); int pageIndex = Convert.ToInt32(context.Request["page"]); int pageSize = Convert.ToInt32(context.Request["rows"]); string keyWord = context.Request["searchReq"]; string permissionKey = context.Request["key"]; string type = context.Request["type"]; string cateID = context.Request["cateID"]; sbWhere.AppendFormat(" 1=1 "); if (!string.IsNullOrWhiteSpace(type)) { sbWhere.AppendFormat(" AND PermissionType={0}", type); } if (!string.IsNullOrWhiteSpace(cateID) && cateID != "0") { sbWhere.AppendFormat(" AND PermissionCateId ={0}", cateID); } if (!string.IsNullOrWhiteSpace(permissionKey)) { sbWhere.AppendFormat(" AND PermissionKey like '%{0}%'", permissionKey); } if (!string.IsNullOrWhiteSpace(keyWord)) { sbWhere.AppendFormat(" AND PermissionName like '%{0}%' Or Url like '%{0}%'", keyWord); } List <PermissionInfo> list = bllPer.GetLit <PermissionInfo>(pageSize, pageIndex, sbWhere.ToString(), "PermissionName"); int totalCount = bllPer.GetCount <PermissionInfo>(sbWhere.ToString()); if (list.Count > 0) { BLLArticleCategory bllArticleCategory = new BLLArticleCategory(); List <ZentCloud.BLLJIMP.Model.ArticleCategory> cateList = new BLLJIMP.BLLArticleCategory().GetList <ZentCloud.BLLJIMP.Model.ArticleCategory>(string.Format("WebsiteOwner='{0}' And CategoryType='{1}' Order by Sort", "Common", "Permission")); for (int i = 0; i < list.Count; i++) { if (list[i].PermissionCateId == 0) { continue; } ZentCloud.BLLJIMP.Model.ArticleCategory nowType = cateList.FirstOrDefault(p => p.AutoID == list[i].PermissionCateId); if (nowType != null) { list[i].PermissionCate = nowType.CategoryName; } } } return(Common.JSONHelper.ObjectToJson( new { total = totalCount, rows = list })); }
private string Query(HttpContext context) { StringBuilder sbWhere = new StringBuilder(); int pageIndex = Convert.ToInt32(context.Request["page"]); int pageSize = Convert.ToInt32(context.Request["rows"]); string keyWord = context.Request["searchReq"]; string group_type = context.Request["group_type"]; string thisSite = context.Request["this_site"]; sbWhere.AppendFormat(" 1=1 "); if (!string.IsNullOrWhiteSpace(keyWord)) { sbWhere.AppendFormat(" AND GroupName like '%{0}%' ", keyWord); } if (!string.IsNullOrWhiteSpace(group_type)) { if (group_type == "0") { sbWhere.AppendFormat(" AND (GroupType ={0} OR GroupType Is Null) ", group_type); } else { sbWhere.AppendFormat(" AND GroupType ={0} ", group_type); } } if (thisSite == "1") { sbWhere.AppendFormat(" AND (WebsiteOwner Is Null Or WebsiteOwner='common')"); } else if (thisSite == "2") { sbWhere.AppendFormat(" AND WebsiteOwner ='{0}' ", bllPer.WebsiteOwner); } List <PermissionGroupInfo> List = bllPer.GetLit <PermissionGroupInfo>(pageSize, pageIndex, sbWhere.ToString()) .OrderByDescending(p => p.GroupType).ToList(); List <PermissionGroupInfo> dataList = new List <PermissionGroupInfo>(); foreach (var item in List.Where(p => p.GroupType == 1)) { item.has_column = bllPms.ExistsRelation(item.GroupID.ToString().ToString(), 3); item.PmsIdsStr = bllPms.GetPmsStrByRelationID(item.GroupID.ToString(), 0); item.MenuIdsStr = bllMenu.GetMenuStrByRelationID(item.GroupID.ToString(), 0); item.PmsColumnIdsStr = bllPms.GetPmsStrByRelationID(item.GroupID.ToString(), 3); dataList.Add(item); } foreach (var item in List.Where(p => p.GroupType == 2)) { item.has_column = bllPms.ExistsRelation(item.GroupID.ToString().ToString(), 3); item.PmsIdsStr = bllPms.GetPmsStrByRelationID(item.GroupID.ToString(), 0); item.MenuIdsStr = bllMenu.GetMenuStrByRelationID(item.GroupID.ToString(), 0); item.PmsColumnIdsStr = bllPms.GetPmsStrByRelationID(item.GroupID.ToString(), 3); dataList.Add(item); } foreach (var item in List.Where(p => p.GroupType == 0)) { item.has_column = bllPms.ExistsRelation(item.GroupID.ToString().ToString(), 3); item.PmsIdsStr = bllPms.GetPmsStrByRelationID(item.GroupID.ToString(), 0); item.MenuIdsStr = bllMenu.GetMenuStrByRelationID(item.GroupID.ToString(), 0); item.PmsColumnIdsStr = bllPms.GetPmsStrByRelationID(item.GroupID.ToString(), 3); dataList.Add(item); } foreach (var item in List.Where(p => p.GroupType == 3)) { item.has_column = bllPms.ExistsRelation(item.GroupID.ToString().ToString(), 3); item.PmsIdsStr = bllPms.GetPmsStrByRelationID(item.GroupID.ToString(), 0); item.MenuIdsStr = bllMenu.GetMenuStrByRelationID(item.GroupID.ToString(), 0); item.PmsColumnIdsStr = bllPms.GetPmsStrByRelationID(item.GroupID.ToString(), 3); dataList.Add(item); } foreach (var item in List.Where(p => p.GroupType == 4)) { item.has_column = bllPms.ExistsRelation(item.GroupID.ToString().ToString(), 3); item.PmsIdsStr = bllPms.GetPmsStrByRelationID(item.GroupID.ToString(), 0); item.MenuIdsStr = bllMenu.GetMenuStrByRelationID(item.GroupID.ToString(), 0); item.PmsColumnIdsStr = bllPms.GetPmsStrByRelationID(item.GroupID.ToString(), 3); dataList.Add(item); } int totalCount = bllPer.GetCount <PermissionGroupInfo>(sbWhere.ToString()); return(Common.JSONHelper.ObjectToJson( new { total = totalCount, rows = dataList })); }