public PagedResults QueryEmployListSync(Models.QueryEmployInfoInput input)
{
var pageResults = iEmployInfoRepository.GetEmployListSync(input);
var summaryData = iEmployInfoRepository.GetEmploySummarySync(input);
var summaryDataList = iEmployInfoRepository.GetEmploySummaryListSync(input);
ChartOption optionPie = summaryData.ToChartOption(ChartType.Pie, "", "", "name", "Series", "value", "EmployEE", ChartDirection.Vertical);
pageResults.ExtraDatas.Add("SummaryPie", optionPie);
ChartOption optionBar = summaryDataList[0].ToChartOption(ChartType.Bar, "", "", "name", "Series", "value", "EmployEE", ChartDirection.Vertical);
ChartOption addtionOption;
for (int i = 1; i < summaryDataList.Length; ++i)
{
addtionOption = summaryDataList[i].AddToChartOption(optionBar, ChartType.Line, "name", "Series", "value", " ");
pageResults.ExtraDatas.Add("SummaryBar", addtionOption);
}
ChartOption optionLine = summaryData.ToChartOption(ChartType.Line, "", "", "name", "Series", "value", "EmployEE", ChartDirection.Vertical);
pageResults.ExtraDatas.Add("SummaryLine", optionLine);
return(pageResults);
}
public DataTable[] GetEmploySummaryListSync(Models.QueryEmployInfoInput input)
{
DataTable[] infoSummary = new DataTable[2];
infoSummary[0] = base.QueryDataTable(QueryEmploySummarySQL, "Summary", input.GetManualParams());
infoSummary[1] = base.QueryDataTable(QueryEmployPercentSQL, "Summary", input.GetManualParams());
return(infoSummary);
}
public async Task <PagedResults> QueryEmployListAsync(Models.QueryEmployInfoInput input)
{
var pageResults = await iEmployInfoRepository.GetEmployListAsync(input);
pageResults.ExtraDatas.Add("Summary", await iEmployInfoRepository.GetEmploySummaryAsync(input));
return(pageResults);
}
public DataTable GetEmploySummarySync(Models.QueryEmployInfoInput input)
{
return(base.QueryDataTable(QueryEmploySummarySQL, "Summary", input.GetManualParams()));
}
public PagedResults GetEmployListSync(Models.QueryEmployInfoInput input)
{
return(base.PagingQueryDataTable(QueryEmployListSQL, input));
}
public Task <PagedResults> GetEmployListAsync(Models.QueryEmployInfoInput input)
{
return(base.PagingQueryAsyncDataTable(QueryEmployListSQL, input));
}
