/// <summary> /// 获取地图区域列表基本信息 /// </summary> /// <param name="model"></param> /// <param name="searchPage"></param> /// <param name="pageSize"></param> /// <returns></returns> #region 查询 public static AsiatekPagedList <MapRegionsListModel> GetPagedMapRegions(MapRegionsSearchModel model, int searchPage, int pageSize) { List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@tableName", "MapRegionsList"), new SqlParameter("@pageSize", pageSize), new SqlParameter("@currentPage", searchPage), new SqlParameter("@orderBy", "ID DESC"), new SqlParameter("@showColumns", @"ID, RegionsType, RegionsName, CAST(StartDate AS CHAR(10)) AS StartDate, CAST(StartTime AS CHAR(8)) AS StartTime, CAST(EndDate AS CHAR(10)) AS EndDate, CAST(EndTime AS CHAR(8)) AS EndTime, Periodic, SpeedLimit, OverSpeedDuration "), }; #region 筛选条件 string conditionStr = "Status=0"; if (model.SearchRegionsType != 0) { conditionStr += " AND RegionsType =" + model.SearchRegionsType + ""; } if (!string.IsNullOrWhiteSpace(model.SearchRegionsName)) { conditionStr += " AND RegionsName LIKE '%" + model.SearchRegionsName + "%'"; } if (model.SearchSpeedLimit != 0.0) { conditionStr += " AND SpeedLimit=" + model.SearchSpeedLimit + ""; } if (!string.IsNullOrWhiteSpace(conditionStr)) { paras.Add(new SqlParameter("@conditionStr", conditionStr)); } #endregion paras.Add(new SqlParameter() { ParameterName = "@totalItemCount", Direction = ParameterDirection.Output, SqlDbType = SqlDbType.Int }); paras.Add(new SqlParameter() { ParameterName = "@newCurrentPage", Direction = ParameterDirection.Output, SqlDbType = SqlDbType.Int }); List <MapRegionsListModel> list = ConvertToList <MapRegionsListModel> .Convert(MSSQLHelper.ExecuteDataTable(CommandType.StoredProcedure, "Proc_GetPagedDatas", paras.ToArray())); int totalItemCount = Convert.ToInt32(paras[paras.Count - 2].Value); int newCurrentPage = Convert.ToInt32(paras[paras.Count - 1].Value); return(list.ToPagedList(newCurrentPage, pageSize, totalItemCount)); }
public ActionResult GetMapRegions(MapRegionsSearchModel model, int searchPage) { SearchDataWithPagedDatas <MapRegionsSearchModel, MapRegionsListModel> result = new SearchDataWithPagedDatas <MapRegionsSearchModel, MapRegionsListModel>(); result.SearchModel = model; result.PagedDatas = MapRegionsBLL.GetPagedMapRegions(result.SearchModel, searchPage, this.PageSize); return(PartialView("_MapRegionsPagedGrid", result)); }