private SubmitEnterpriseModifyViewModel EnterpriseModifyInit(int?pageIndex) { pageIndex = pageIndex ?? 1; string pager = string.Empty; int pageSize = 14; SubmitEnterpriseModifyViewModel viewModel = new SubmitEnterpriseModifyViewModel(); DataTable houses = ElementOrganizeBLL.GetCurrentBuildingModify(); if (houses.Rows.Count == 0) { viewModel.Message = "该用户还没有分配权限,可以联系商务局相关人员询问具体情况。"; return(viewModel); } DataTable buildings = null;//用于根据楼栋列表查询对应的企业列表 #region where Dictionary <KeyValuePair <string, RoadFlow.Data.Model.SQLFilterType>, object> where = new Dictionary <KeyValuePair <string, SQLFilterType>, object>(); if (!string.IsNullOrWhiteSpace(Request["buildingID"])) { viewModel.ParaBuildingID = Request["buildingID"]; buildings = BuildingsDataBLL.GetByStringID(Request["buildingID"]); } else { buildings = BuildingsDataBLL.GetCurrentUsersOrganizeList(); } if (!string.IsNullOrWhiteSpace(Request["name"])) { where.Add(new KeyValuePair <string, RoadFlow.Data.Model.SQLFilterType>("Name", RoadFlow.Data.Model.SQLFilterType.CHARINDEX), Request["name"]); viewModel.ParaName = Request["name"]; } #endregion #region 用于view中的显示楼栋名称和所属楼栋列表 viewModel.BuildingsName = BuildingsDataBLL.GetCurrentUsersOrganizeList(); viewModel.BuildingsName.PrimaryKey = new DataColumn[] { viewModel.BuildingsName.Columns["ID"] }; #endregion //获取企业列表(带翻页) if (buildings == null || buildings.Rows.Count == 0) { viewModel.Message = "需要先新增楼栋信息。"; return(viewModel); } DataTable list = new EnterpriseAndEnterpriseTaxBLL().GetAllByBuildings(buildings, pageIndex.Value, pageSize, where, out pager); viewModel.List = list; viewModel.Pager = pager; WorkFlowBLL workFlowBLL = new WorkFlowBLL(); viewModel.EditFlowID = workFlowBLL.GetByName("企业更新").ID; viewModel.DeleteFlowID = workFlowBLL.GetByName("企业搬出").ID; viewModel.ToStreetID = GetToStreetID(houses); return(viewModel); }
private SubmitBuildingModifyViewModel BuildingModifyInit(int?pageIndex) { pageIndex = pageIndex ?? 1; string pager = string.Empty; int pageSize = 14; SubmitBuildingModifyViewModel viewModel = new SubmitBuildingModifyViewModel(); DataTable houses = ElementOrganizeBLL.GetCurrentBuildingModify(); if (houses.Rows.Count == 0) { viewModel.Message = "该用户还没有分配权限,可以联系商务局相关人员询问具体情况。"; return(viewModel); } #region where Dictionary <KeyValuePair <string, RoadFlow.Data.Model.SQLFilterType>, object> where = new Dictionary <KeyValuePair <string, SQLFilterType>, object>(); if (!string.IsNullOrWhiteSpace(Request["name"])) { where.Add(new KeyValuePair <string, RoadFlow.Data.Model.SQLFilterType>("Name", RoadFlow.Data.Model.SQLFilterType.CHARINDEX), Request["name"]); viewModel.ParaName = Request["name"]; } #endregion DataTable dt = BuildingsDataBLL.GetCurrentUsersOrganizeList(pageIndex.Value, pageSize, where, out pager); viewModel.List = dt; viewModel.Pager = pager; DictionaryBLL dictionaryBLL = new DictionaryBLL(); viewModel.HouseName = dictionaryBLL.GetListByCode("LPMC"); viewModel.HouseName.PrimaryKey = new DataColumn[] { viewModel.HouseName.Columns["ID"] }; WorkFlowBLL workFlowBLL = new WorkFlowBLL(); viewModel.EditFlowID = workFlowBLL.GetByName("楼栋更新").ID; viewModel.ToStreetID = GetToStreetID(houses); return(viewModel); }
private SubmitEnterpriseViewModel EnterpriseInit(int?pageIndex) { pageIndex = pageIndex ?? 1; string pager = string.Empty; int pageSize = 14; SubmitEnterpriseViewModel viewModel = new SubmitEnterpriseViewModel(); #region where Dictionary <KeyValuePair <string, RoadFlow.Data.Model.SQLFilterType>, object> where = new Dictionary <KeyValuePair <string, SQLFilterType>, object>(); if (!string.IsNullOrWhiteSpace(Request["name"])) { where.Add(new KeyValuePair <string, RoadFlow.Data.Model.SQLFilterType>("Name", RoadFlow.Data.Model.SQLFilterType.IN), Request["name"]); viewModel.ParaName = Request["name"]; } #endregion DataTable buildings = BuildingsDataBLL.GetCurrentUsersOrganizeList(pageIndex.Value, pageSize, where, out pager); viewModel.List = buildings; viewModel.Pager = pager; WorkFlowBLL workFlowBLL = new WorkFlowBLL(); viewModel.CreateFlowID = workFlowBLL.GetByName("企业入驻").ID; DataTable houses = ElementOrganizeBLL.GetCurrentBuildingModify(); viewModel.ToStreetID = GetToStreetID(houses); return(viewModel); }
private SubmitIndexViewModel IndexInit() { SubmitIndexViewModel viewModel = new SubmitIndexViewModel(); //获取当前用户所属组织有的楼盘权限 DataTable dt = ElementOrganizeBLL.GetCurrentBuildingModify(); viewModel.List = dt; DictionaryBLL dictionaryBLL = new DictionaryBLL(); viewModel.HouseName = dictionaryBLL.GetListByCode("LPMC"); viewModel.HouseName.PrimaryKey = new DataColumn[] { viewModel.HouseName.Columns["ID"] }; WorkFlowBLL workFlowBLL = new WorkFlowBLL(); viewModel.CreateFlowID = workFlowBLL.GetByName("楼栋报送").ID; viewModel.ToStreetID = GetToStreetID(dt); return(viewModel); }
private SubmitMonthModifyViewModel MonthInfoModifyInit(int?pageIndex) { pageIndex = pageIndex ?? 1; string pager = string.Empty; int pageSize = 14; SubmitMonthModifyViewModel viewModel = new SubmitMonthModifyViewModel(); #region where Dictionary <KeyValuePair <string, RoadFlow.Data.Model.SQLFilterType>, object> where = new Dictionary <KeyValuePair <string, SQLFilterType>, object>(); if (!string.IsNullOrWhiteSpace(Request["name"])) { where.Add(new KeyValuePair <string, RoadFlow.Data.Model.SQLFilterType>("Name", RoadFlow.Data.Model.SQLFilterType.CHARINDEX), Request["name"]); viewModel.ParaName = Request["name"]; } if (!string.IsNullOrWhiteSpace(Request["timeArea"])) { where.Add(new KeyValuePair <string, RoadFlow.Data.Model.SQLFilterType>("TimeArea", RoadFlow.Data.Model.SQLFilterType.EQUAL), Request["timeArea"].Replace("-", "")); viewModel.ParaTimeArea = Request["timeArea"]; } #endregion BuildingMonthInfoDataBLL buildingMonthInfoDataBLL = new BuildingMonthInfoDataBLL(); DataTable dt = buildingMonthInfoDataBLL.GetPagerData(out pager, pageSize, pageIndex.Value, where); viewModel.List = dt; viewModel.Pager = pager; WorkFlowBLL workFlowBLL = new WorkFlowBLL(); viewModel.EditFlowID = workFlowBLL.GetByName("每月更新").ID; //通过BuildingID获取关联的街道ID Dictionary <string, object> dictionary = new Dictionary <string, object>(); foreach (DataRow dr in dt.Rows) { DataTable streets = ElementOrganizeBLL.GetToStreetByBuildingID(dr["BuildingID"]); if (streets.Rows.Count != 0) { dictionary.Add(dr["BuildingID"].ToString(), streets.Rows[0]["OrganizeID"]); } } viewModel.ToStreetID = dictionary; return(viewModel); }