public ActionResult StatisticsListView(int? RegionId, int? OrganId, int? IsTest, string SearchTxt) { int PageIndex = 1; ViewBag.GroupId = Code.SiteCache.Instance.GroupId;//当前登录人的权限 ViewBag.ManageOrganId = Code.SiteCache.Instance.ManageOrganId;//当前登录人的权限 ViewBag.DetailUrl = Code.SiteCache.Instance.GetSysValue("NLPCView");//评测统计详细页链接 IsTest = (IsTest == null) ? -1 : IsTest; ViewBag.IsTest = (IsTest == null) ? -1 : IsTest; ViewBag.SearchTxt = SearchTxt; //加载区县信息 var List_Regin = this.GetReginListItem(); var accBll = new accountBLL(); var List_accountOther = new List<accountOther>(); var stbSqlWhere = new StringBuilder(); stbSqlWhere.Append(" 1 = 1 "); switch ((int)ViewBag.GroupId) { case (int)XXW.Enum.PlatformGroupEnum.ManagerCity: { ViewBag.RegionId = (RegionId == null) ? -1 : RegionId; ViewBag.OrganId = (OrganId == null) ? -1 : OrganId; if (ViewBag.RegionId > 0) stbSqlWhere.Append(" and RegionId=" + ViewBag.RegionId); if (ViewBag.OrganId > 0) stbSqlWhere.Append(" and OrganId=" + ViewBag.OrganId); break; } case (int)XXW.Enum.PlatformGroupEnum.ManagerArea: { ViewBag.RegionId = (RegionId == null) ? (Code.SiteCache.Instance.RegionId): RegionId; ViewBag.OrganId = (OrganId == null) ? -1: OrganId; stbSqlWhere.Append(" and RegionId=" + ViewBag.RegionId); if (ViewBag.OrganId > 0) stbSqlWhere.Append(" and OrganId=" + ViewBag.OrganId); break; } case (int)XXW.Enum.PlatformGroupEnum.ManagerTraining: { ViewBag.RegionId = (RegionId == null) ? -1 : RegionId; ViewBag.OrganId = (OrganId == null) ? (Code.SiteCache.Instance.ManageOrganId) : OrganId; stbSqlWhere.Append(" and OrganId=" + ViewBag.OrganId); break; } case (int)XXW.Enum.PlatformGroupEnum.ManagerSchool: { ViewBag.RegionId = (RegionId == null) ? -1 : RegionId; ViewBag.OrganId = (OrganId == null) ? (Code.SiteCache.Instance.ManageOrganId) : OrganId; stbSqlWhere.Append(" and OrganId=" + ViewBag.OrganId); break; } default: { stbSqlWhere.Append(" and 1 != 1 "); break; } } if (IsTest != -1) { if (IsTest > 0) { stbSqlWhere.Append(" and DiscussCnt > 0 "); } else { stbSqlWhere.Append(" and DiscussCnt = 0 "); } } if (!string.IsNullOrEmpty(SearchTxt)) stbSqlWhere.AppendFormat(" and (RealName like '%{0}%' or TeacherNo like '%{0}%')", SearchTxt); int iRecordCount = accBll.GetListOtherCount(stbSqlWhere.ToString()); int iPageSize = 10, iPageIndex; int iPageCount = (int)Math.Ceiling((double)iRecordCount / iPageSize); int.TryParse(Request["PageIndex"], out PageIndex); int.TryParse(Convert.ToString(PageIndex), out iPageIndex); if (iPageIndex < 1) iPageIndex = 1; else if (iPageIndex > iPageCount) iPageIndex = iPageCount; //获取分页数据集合 List_accountOther = accBll.GetListOther(iPageSize, iPageIndex, stbSqlWhere.ToString(), out iRecordCount); ViewBag.List_Regin = List_Regin; ViewBag.RecordCount = iRecordCount; ViewBag.PageCount = iPageCount; ViewBag.PageIndex = iPageIndex; ViewBag.PageSize = iPageSize; return View(List_accountOther); }