public override ReportTitles GetReportTitles(IRptParams filter) { var result = base.GetReportTitles(filter); DynamicObject customFilter = filter.FilterParameter.CustomFilter; if (customFilter != null) { if (result == null) { result = new ReportTitles(); } string dimension = string.Empty; string desc = string.Empty; if (customFilter["F_xy_Dimension"] != null) { dimension = customFilter["F_xy_Dimension"].ToString(); } desc = ElementGenerator.GetTitleByDimension(dimension); result.AddTitle("F_xy_Title", "年度公司商机登录数量" + desc); result.AddTitle("F_xy_Year", "年度: " + string.Format("{0:yyyy}", customFilter["F_xy_Year"]) + " "); } return(result); }
public override ReportHeader GetReportHeaders(IRptParams filter) { DynamicObject customFilter = filter.FilterParameter.CustomFilter; if (customFilter["F_xy_Dimension"] == null || customFilter["F_xy_Year"] == null) { throw new Exception("未选择维度或年份条件"); } string dimension = customFilter["F_xy_Dimension"].ToString(); ReportHeader header = ElementGenerator.GetHeaderByDimension(dimension); return(header); }
public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName) { base.BuilderReportSqlAndTempTable(filter, tableName); DynamicObject customFilter = filter.FilterParameter.CustomFilter; if (customFilter["F_xy_Dimension"] == null || customFilter["F_xy_Year"] == null) { throw new Exception("未选择维度或年份条件"); } string dimension = customFilter["F_xy_Dimension"].ToString(); string year = customFilter["F_xy_Year"].ToString(); string billStatus = customFilter["F_xy_BillStatus"].ToString(); string sql = ElementGenerator.GetSqlByDimension(dimension, year, billStatus, tableName); DBUtils.ExecuteDynamicObject(this.Context, sql); }