public PageDataResultView QueryPageDataResultView(JqGridPostData jqGridPostData)
{
Pageable pageable = AnalysisPostData(jqGridPostData);
//queryOption.Where = AnalysisWhere(queryOption.Where);
PageDataResultView result = QueryPagedDynamicData();
return(result);
PageDataResultView QueryPagedDynamicData()
{
try
{
IEnumerable <FapColumn> fapColumns = _dbContext.Columns(jqGridPostData.QuerySet.TableName);
PageInfo <dynamic> pi = _dbContext.QueryPage(pageable);
//组装成DataResultView对象
PageDataResultView dataResultView = new PageDataResultView();
dataResultView.Data = pi.Items.ToFapDynamicObjectList(fapColumns);
//当未获取数据的时候才获取默认值
//if (!dataObject.Data.Any())
//{
//wyf表单应用，表格暂时不用取默认值
//dataResultView.DefaultData = queryOption.Wraper.GetDefaultData();
//}
dataResultView.DataJson = JsonConvert.SerializeObject(pi.Items);
dataResultView.TotalCount = pi.TotalCount;
dataResultView.CurrentPage = pi.CurrentPage;
dataResultView.OrginData = pi.Items;
dataResultView.DataListForJqGrid = pi.Items;// as IEnumerable<IDictionary<string, object>>;
dataResultView.PageSize = pi.PageSize;
//统计字段
dataResultView.StatFieldData = pi.StatFieldData;
dataResultView.StatFieldDataJson = JsonConvert.SerializeObject(pi.StatFieldData);
return(dataResultView);
}
catch (Exception)
{
throw;
}
}
}
public PageDataResultView QueryPageDataResultView(JqGridPostData jqGridPostData)
{
Pageable pageable = AnalysisPostData(jqGridPostData);
//queryOption.Where = AnalysisWhere(queryOption.Where);
PageDataResultView result = QueryPagedDynamicData();
return(result);
PageDataResultView QueryPagedDynamicData()
{
try
{
IEnumerable <FapColumn> fapColumns = _dbContext.Columns(jqGridPostData.QuerySet.TableName);
PageInfo <dynamic> pi = _dbContext.QueryPage(pageable);
//组装成DataResultView对象
PageDataResultView dataResultView = new PageDataResultView();
dataResultView.Data = pi.Items.ToFapDynamicObjectList(fapColumns);
dataResultView.DataJson = JsonConvert.SerializeObject(pi.Items);
dataResultView.TotalCount = pi.TotalCount;
dataResultView.CurrentPage = pi.CurrentPage;
dataResultView.OrginData = pi.Items;
dataResultView.DataListForJqGrid = pi.Items;//暂不启用加密设置 GetEncryptData(jqGridPostData.QuerySet.TableName, pi.Items as IEnumerable<IDictionary<string, object>>);
dataResultView.PageSize = pi.PageSize;
//统计字段
dataResultView.StatFieldData = pi.StatFieldData;
dataResultView.StatFieldDataJson = JsonConvert.SerializeObject(pi.StatFieldData);
return(dataResultView);
}
catch (Exception)
{
throw;
}
}
}
