public virtual Page1ReturnInfo <DataDictionaryItemExpandInfo> PageExpandList(int page, int rows) { IDictionary <string, string> dicParams = HttpContext.Current.Request.Url.AbsoluteUri.ToDictionaryFromUrlParams(); dicParams.RemoveKey("page"); dicParams.RemoveKey("rows"); DataDictionaryItemExpandFilterInfo filter = null; if (!dicParams.IsNullOrCount0()) { filter = dicParams.ToObject <DataDictionaryItemExpandFilterInfo, string>(); if (dicParams.ContainsKey("sidx") && !string.IsNullOrWhiteSpace(dicParams["sidx"])) { filter.SortName = dicParams["sidx"]; } if (dicParams.ContainsKey("sord") && !string.IsNullOrWhiteSpace(dicParams["sord"])) { if ("desc".Equals(dicParams["sord"])) { filter.Sort = SortEnum.DESC; } } } return(Page1ReturnInfo <DataDictionaryItemExpandInfo> .From(DataDictionaryItemExpandService.QueryPage(page - 1, rows, filter))); }
public virtual Page1ReturnInfo <DataDictionaryItemExpandInfo> PageExpandList(int page, int rows) { var comData = HttpContext.CreateCommonUseData(ComUseDataFactory, menuCode: MenuCode(), functionCodes: FunCodeDefine.QUERY_CODE); IDictionary <string, string> dicParams = Request.QueryString.Value.ToDictionaryFromUrlParams(); dicParams.RemoveKey("page"); dicParams.RemoveKey("rows"); DataDictionaryItemExpandFilterInfo filter = null; if (!dicParams.IsNullOrCount0()) { filter = dicParams.ToObject <DataDictionaryItemExpandFilterInfo, string>(); if (dicParams.ContainsKey("sidx") && !string.IsNullOrWhiteSpace(dicParams["sidx"])) { filter.SortName = dicParams["sidx"]; } if (dicParams.ContainsKey("sord") && !string.IsNullOrWhiteSpace(dicParams["sord"])) { if ("desc".Equals(dicParams["sord"])) { filter.Sort = SortType.DESC; } } } return(Page1ReturnInfo <DataDictionaryItemExpandInfo> .From(DataDictionaryItemExpandService.QueryPage(page - 1, rows, filter, comData))); }
/// <summary> /// 追加查询分页SQL /// </summary> /// <param name="whereSql">where语句</param> /// <param name="parameters">参数</param> /// <param name="filter">筛选</param> protected override void AppendSelectPageWhereSql(StringBuilder whereSql, DynamicParameters parameters, FilterInfo filter = null) { if (filter is DataDictionaryItemExpandFilterInfo) { DataDictionaryItemExpandFilterInfo dataFilter = filter as DataDictionaryItemExpandFilterInfo; whereSql.AppendFormat(" AND `{0}`=@DataDictionaryItemId", GetFieldByProp("DataDictionaryItemId")); parameters.Add("@DataDictionaryItemId", dataFilter.DataDictionaryItemId); } }