/// <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));
}
