/// <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); } }