protected override string GetRptTempTableName(Context ctx, DetailReportCondition filterCondition) { base.Context = ctx; if (this.SubSystemID == "AR") { this.FDebitARAP = "2"; } else { this.FDebitARAP = "1"; } string tempTableName = CommonFunction.GetTempTableName(ctx); if (filterCondition.GroupbyFields == null || string.IsNullOrWhiteSpace(filterCondition.GroupbyFields)) { filterCondition.GroupbyFields = "FCONTACTUNITNUMBER,FCURRENCYFORNAME,FBUSINESSDEPTNAME"; } if (!filterCondition.GroupbyFields.Contains("FCURRENCYFORNAME")) { filterCondition.GroupbyFields += ",FCURRENCYFORNAME"; } if (!filterCondition.GroupbyFields.Contains("FCONTACTUNITNUMBER") && (string.IsNullOrWhiteSpace(filterCondition.FormId) || filterCondition.FormId == null)) { filterCondition.GroupbyFields += ",FCONTACTUNITNUMBER"; } filterCondition.OrderbyFields = this.SetOrderByString(filterCondition.GroupbyFields, filterCondition.OrderbyFields); this.BuildTableData(tempTableName, filterCondition); return(tempTableName); }
// Token: 0x06000190 RID: 400 RVA: 0x0000F908 File Offset: 0x0000DB08 private void BuildTableData(string tableName, DetailReportCondition filterCondition) { this.FilterCondition = filterCondition; this.ContactList = this.GetLinkSupOrVend(); using (new SessionScope()) { this.CreateTempTableAndIndex(); this.BuildData(tableName); //this.DeleteTempTable(); } }
// Token: 0x0600018F RID: 399 RVA: 0x0000F8B0 File Offset: 0x0000DAB0 protected override string GetRptTempTableNameByHook(Context ctx, DetailReportCondition filterCondition, string strCheckReportID) { base.Context = ctx; this._checkReportID = strCheckReportID; if (filterCondition.GroupbyFields == null || string.IsNullOrWhiteSpace(filterCondition.GroupbyFields)) { filterCondition.GroupbyFields = "FCONTACTUNITNUMBER,FCURRENCYNAME"; } filterCondition.OrderbyFields = "FCONTACTUNITNUMBER,FCURRENCYNAME,FDetailType,FDATE,FBUSINESSRANK,FBILLNO"; string tempTableName = CommonFunction.GetTempTableName(ctx); this.BuildTableData(tempTableName, filterCondition); return(tempTableName); }