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