public DataTable GetLotStatusSummary(Models.XuTaoInput input)
{
string filter = string.Empty;
if (input.ProductName != null && input.ProductName.Length > 0)
{
filter = string.Format("AND ProductName IN ('{0}') ", input.ProductName);
}
string sql = string.Format(summaySQL, filter);
return(base.QueryDataTable(sql, "Summary"));
}
public PagedResults GetLotInfoList(Models.XuTaoInput input)
{
string filter = string.Empty;
if (input.ProductName != null && input.ProductName.Length > 0)
{
filter = string.Format("AND ProductName IN ('{0}') ", input.ProductName);
}
string sql = string.Format(listSQL, filter);
return(base.PagingQueryDataTable(sql, input));
}
public PagedResults QueryLotInfo(Models.XuTaoInput input)
{
if (input.ProductName.IsNullOrEmpty())
{
throw new ParameterRequiredException("ProductName");
}
var pageResults = _XuTaoRepository.GetLotInfoList(input);
var summaryData = _XuTaoRepository.GetLotStatusSummary(input);
ChartOption option = summaryData.ToChartOption(ChartType.Bar, "", "", "Status", "Series", "CNT", "asd", ChartDirection.Vertical);
pageResults.ExtraDatas.Add("Summary", option);
option = summaryData.ToChartOption(ChartType.Line, "", "", "Status", "Series", "CNT", "asd", ChartDirection.Vertical);
pageResults.ExtraDatas.Add("Summary1", option);
return(pageResults);
}
