public BuildingIndexViewModel IndexInit(Guid parentID, int?pageIndex) { BuildingIndexViewModel viewModel = new BuildingIndexViewModel(); viewModel.SSJD = db.Dictionarys.Where(p => p.ParentID == parentID); //已建楼宇 var buildedID = db.Dictionarys.FirstOrDefault(p => p.Title == "已建成").ID; viewModel.BuildedID = buildedID; //在建楼宇 var buildingID = db.Dictionarys.FirstOrDefault(p => p.Title == "在建").ID; viewModel.BuildingID = buildingID; //重点楼宇 var importantID = db.Dictionarys.FirstOrDefault(p => p.Title == "重点楼宇").ID; viewModel.ImportantID = importantID; //其他楼宇 var otherID = db.Dictionarys.FirstOrDefault(p => p.Title == "其他楼宇").ID; viewModel.OtherID = otherID; //默认显示已建楼宇-重点楼宇 IQueryable <BuildingModel> list1 = db.BuildingsAndBuildingMonthInfo.Where(p => p.JSJD == buildedID && p.IsImportant == importantID && p.Status == Status.Normal); viewModel.Pager = RoadFlow.Utility.New.Tools.GetPagingHtml(list1.Count(), pageSize, pageIndex.Value); viewModel.Buildings = db.BuildingsAndBuildingMonthInfo.Where(p => p.JSJD == buildedID && p.IsImportant == importantID && p.Status == Status.Normal).OrderByDescending(p => p.CreateTime).Skip(pageSize * (pageIndex.Value - 1)).Take(pageSize); viewModel.BuildingCount = viewModel.Buildings.Count(); return(viewModel); }
/// <summary> /// 楼栋列表视图初始化(商务局,街道办,报送单位) /// </summary> /// <returns></returns> private BuildingIndexViewModel BuildingInit(int type) { BuildingIndexViewModel viewModel = new BuildingIndexViewModel(); string pager = string.Empty; Dictionary <KeyValuePair <string, RoadFlow.Data.Model.SQLFilterType>, object> where = IndexGetMoreWhere();//更多条件 #region 固定where if (!string.IsNullOrWhiteSpace(Request["Name"])) { viewModel.Name = Request["Name"]; where.Add(new KeyValuePair <string, RoadFlow.Data.Model.SQLFilterType>("Name", RoadFlow.Data.Model.SQLFilterType.CHARINDEX), viewModel.Name); } if (!string.IsNullOrWhiteSpace(Request["SSJD"])) { viewModel.SSJD = Request["SSJD"]; where.Add(new KeyValuePair <string, RoadFlow.Data.Model.SQLFilterType>("SSJD", RoadFlow.Data.Model.SQLFilterType.EQUAL), viewModel.SSJD); } #endregion if (type == 0) {//商务局 viewModel.List = BuildingsAndBuildingMonthInfoBLL.GetPagerData(out pager, PageSize, RoadFlow.Utility.Tools.GetPageNumber(), where); } else if (type == 1) { //街道办 var ssjd = new RoadFlow.Platform.DictionaryBLL().GetCurrentSSJD(); viewModel.SSJD = ssjd == null ? "" : ssjd.Value.ToString(); if (string.IsNullOrWhiteSpace(Request["SSJD"])) { where.Add(new KeyValuePair <string, RoadFlow.Data.Model.SQLFilterType>("SSJD", RoadFlow.Data.Model.SQLFilterType.EQUAL), viewModel.SSJD); } viewModel.List = BuildingsAndBuildingMonthInfoBLL.GetPagerData(out pager, PageSize, RoadFlow.Utility.Tools.GetPageNumber(), where); } else { //报送单位 viewModel.List = BuildingsAndBuildingMonthInfoBLL.GetCurrentUsersOrganizeList(out pager, PageSize, RoadFlow.Utility.Tools.GetPageNumber(), where); } viewModel.Pager = pager; viewModel.Display = GetColItemList();//读取显示字段配置信息 viewModel.Dictionarys = DictionaryBLL.GetListAll(); viewModel.SSJDList = new SelectList(DictionaryBLL.GetListByCode("SSJD").ToList <RoadFlow.Data.Model.DictionaryModel>(), "ID", "Title", viewModel.SSJD); return(viewModel); }