/// <summary>
/// 报表统计
/// </summary>
/// <param name="reportName"> 对应的名称 </param>
/// <param name="systemID"> 系统ID</param>
/// <param name="where"> 查询条件 </param>
/// <param name="type"> 报表路径 </param>
/// <param name="Totalstartsql"> Sql头(select order ,count(*) as total from ) </param>
/// <param name="Totalendsql"> Sql(group by order)</param>
/// <returns></returns>
public static DataSet GetReportTotal(string reportName, List <KeyValue> where, int systemID, bool optimize = false)
{
if (where != null)
{
foreach (var item in where)
{
item.Value = item.Value.Trim();
}
}
return(MSSqlHelper.GetReportTotal(reportName, where, systemID));
}
/// <summary>
/// 前台需要点击排序的时候调用
/// </summary>
/// <param name="reportName"> XML对?应?|的??名?称? </param>
/// <param name="where"> 查??询??条??件t </param>
/// <param name="pageSize"> 页?3面?打???小? </param>
/// <param name="pageIndex"> 页?3面?索??引?y </param>
/// <param name="order"></param>
/// <param name="systemID"> 系??统?3ID</param>
/// <param name="totalCount"></param>
/// <returns></returns>
public static DataSet GetReportData(string reportName, GetReportDataParams param,
int systemID, out int totalCount, bool optimize = false)
{
if (param.Where != null)
{
foreach (var item in param.Where)
{
item.Value = item.Value.Trim();
}
}
DataSet ds;
ds = MSSqlHelper.GetReportData(reportName, param, systemID, out totalCount);
return(ds);
}