public PagedResults QueryYearTotalInfo(Models.QueryTotalInput InfoInput)
{
string filter = string.Empty;
if (InfoInput.YearDate != null && InfoInput.YearDate.Length > 0)
{
filter = string.Format("AND Year IN ('{0}') ", InfoInput.YearDate);
}
string sql = string.Format(sYearTotalInfo, filter);
return(base.PagingQueryDataTable(sql, InfoInput));
}
public PagedResults QueryToolInfo(Models.QueryTotalInput InfoInput)
{
string filter = string.Empty;
string filter1 = string.Empty;
string filter2 = string.Empty;
if (InfoInput.YearDate != null && InfoInput.YearDate.Length > 0)
{
filter1 = string.Format("AND Year IN ('{0}') ", InfoInput.YearDate);
}
if (InfoInput.EqpID != null && InfoInput.EqpID.Length > 0)
{
filter2 = string.Format("AND equipmentname IN ('{0}') ", InfoInput.EqpID);
}
filter = filter1 + filter2;
string sql = string.Format(sToolInfo, filter);
return(base.PagingQueryDataTable(sql, InfoInput));
}
public PagedResults QuerySingleInfo(Models.QueryTotalInput InfoInput)
{
string filter = string.Empty;
string filter1 = string.Empty;
string filter2 = string.Empty;
if (InfoInput.YearDate != null && InfoInput.YearDate.Length > 0)
{
filter1 = string.Format("AND Year IN ('{0}') ", InfoInput.YearDate);
}
if (InfoInput.StateGrp != null && InfoInput.StateGrp.Length > 0)
{
filter2 = string.Format("AND State IN ('{0}') ", InfoInput.StateGrp);
}
filter = filter1 + filter2;
string sql = string.Format(sSingleInfo, filter);
return(base.PagingQueryDataTable(sql, InfoInput));
}