/// <summary>
/// 综合报表查询
/// </summary>
/// <param name="filter">查询条件结合</param>
/// <param name="totalCount">总记录数</param>
/// <returns>DataTable数据集合</returns>
public DataTable ComprehensiveQuery(EIMSComprehensiveQueryFilter filter, out int totalCount)
{
CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("ExternalSYS_Query_Comprehensive");
using (DynamicQuerySqlBuilder sb = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, HelpDA.ToPagingInfo(filter.PagingInfo), "ruleRebate.EndDate ASC"))
{
AddComprehensive(filter, cmd, sb);
DataTable dt = cmd.ExecuteDataTable();
EnumColumnList enumColList = new EnumColumnList();
CodeNamePairColumnList codeNameColList = new CodeNamePairColumnList();
codeNameColList.Add("EIMSType", "ExternalSYS", "EIMSType");
codeNameColList.Add("RuleStatus", "ExternalSYS", "RuleStatus");
codeNameColList.Add("InvoiceStatus", "ExternalSYS", "InvoiceStatus");
codeNameColList.Add("RebateBaseType", "ExternalSYS", "RebateBaseType");
cmd.ConvertColumn(dt, enumColList, codeNameColList);
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(dt);
}
}
