账表实现汇总表穿透到明细表

原创

牛魔王MrDing 2018-04-28 09:43:44 博主文章分类：K3cloud ©著作权

©著作权归作者所有：来自51CTO博客作者牛魔王MrDing的原创作品，请联系作者获取转载授权，否则将追究法律责任

** 汇总表的关键代码：** public override void Initialize() { base.Initialize(); this.ReportProperty.ReportType = ReportType.REPORTTYPE_NORMAL; this.ReportProperty.IsGroupSummary = true; this.ReportProperty.DetailReportId = "PBNI_StoreAgeDetail"; #region 精度控制 this.ReportProperty.DecimalControlFieldList = ReportCommon.GetDecimalControlList("FAMOUNTDIGITS", decimalControl); #endregion }

明细表的关键代码： public override void Initialize() { base.Initialize(); #region 精度控制 this.ReportProperty.DecimalControlFieldList = ReportCommon.GetDecimalControlList("FAMOUNTDIGITS", decimalControl); #endregion } public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName) { base.BuilderReportSqlAndTempTable(filter, tableName); tempTableName = tableName; tempTables.Add(tableName); using (new SessionScope()) { StringBuilder sSQL = new StringBuilder(); StringBuilder sql = new StringBuilder(); StringBuilder where = new StringBuilder(); sql.Append(@"/dialect/ "); bool srcFilter = false; Dictionary<string, object> dctCurrRow = new Dictionary<string, object>(); if (!filter.IsRefresh && filter.CustomParams.Count() > 1 && filter.CustomParams.ContainsKey("ParentReportFilter")) { dctCurrRow = (Dictionary<string, object>)filter.CustomParams["ParentReportCurrentRow"]; srcFilter = true; } if (srcFilter) { if (dctCurrRow.ContainsKey("FBEGINDATE") && dctCurrRow["FBEGINDATE"] != null && !string.IsNullOrEmpty(dctCurrRow["FBEGINDATE"].ToString())) { where.AppendFormat(" and cardMsg.FOPENDATE>='{0}' ", dctCurrRow["FBEGINDATE"].ToString()); } if (dctCurrRow.ContainsKey("FENDDATE") && dctCurrRow["FENDDATE"] != null && !string.IsNullOrEmpty(dctCurrRow["FENDDATE"].ToString())) { where.AppendFormat(" and cardMsg.FOPENDATE<'{0}' ", dctCurrRow["FENDDATE"].ToString()); } if (dctCurrRow.ContainsKey("FCARDCLASS") && dctCurrRow["FCARDCLASS"] != null && !string.IsNullOrEmpty(dctCurrRow["FCARDCLASS"].ToString())) { where.AppendFormat(" and kll.FNAME='{0}' ", dctCurrRow["FCARDCLASS"].ToString()); } if (dctCurrRow.ContainsKey("FCARDTYPE") && dctCurrRow["FCARDTYPE"] != null && !string.IsNullOrEmpty(dctCurrRow["FCARDTYPE"].ToString())) { where.AppendFormat(" and cypt.FDATAVALUE='{0}' ", dctCurrRow["FCARDTYPE"].ToString()); } } var baseObjs = DBUtils.ExecuteDynamicObject(this.Context, string.Format(sql.ToString(), where)); sSQL.AppendLine("select * ,2 FAMOUNTDIGITS,{0} into {1} from #temp "); sSQL.AppendLine("drop table #temp "); KSQL_SEQ = string.Format(KSQL_SEQ, " FCARDNUMBER asc "); string SQL = string.Format(sSQL.ToString(), this.KSQL_SEQ, tableName); DBUtils.Execute(this.Context, SQL.ToString()); } }