二次开发的帐表在oracle中报错 table or view does not exit

lindsey

1人赞赏了该文章 1,447次浏览编辑于2018年12月02日 16:25:47

完整代码：
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Kingdee.BOS.Contracts.Report;
using Kingdee.BOS.Core.Report;
using Kingdee.BOS;
using Kingdee.BOS.Core.List;
using Kingdee.BOS.Orm.DataEntity;
using Kingdee.BOS.Contracts;
using Kingdee.K3.SCM.Sal.Report.PlugIn;
using Kingdee.K3.CRM.App.Core;
using System.Collections;
using Kingdee.BOS.App.Data;
using Kingdee.BOS.Core.SqlBuilder;
using Kingdee.BOS.Core;
using Kingdee.BOS.Core.Util;
using Kingdee.BOS.Resource;
using Kingdee.BOS.Util;
using Kingdee.BOS.Core.Metadata;
using Kingdee.BOS.Core.Permission;
using Kingdee.BOS.App.Core.BusinessFlow;
using Kingdee.K3.Core;
using Kingdee.BOS.Core.BusinessFlow.ServiceArgs;
using Kingdee.BOS.BusinessEntity.BusinessFlow;
using System.Data;
using Kingdee.BOS.Core.Permission.Objects;
using Kingdee.BOS.Core.CommonFilter;
using Kingdee.BOS.App;
using System.Transactions;

namespace ZhongtongRpt
{
public class MarketCostSumRpt : SysReportBaseService
{
      public string filterOrgList;
      public string strTempTable = string.Empty;
      public string finalTempTable = string.Empty;
      //填充数据执行的SQL语句 List
      List<SqlObject> listDataSqlObj = new List<SqlObject>();
      //自己创建的临时表的SQL语句 List
      List<SqlObject> listTableSqlObj = new List<SqlObject>();
      //待删除的自己创建的临时表
      List<string> listDelTempTable = new List<string>();

      #region 初始化
      //初始化
      public override void Initialize()
      {
         base.Initialize();
         base.ReportProperty.IdentityFieldName = "F_xxq_ranking";
         this.ReportProperty.ReportType = ReportType.REPORTTYPE_NORMAL;
         base.ReportProperty.ReportName = new LocaleValue("营销费用汇总表", this.Context.UserLocale.LCID);
         //this.ReportProperty.PrimaryKeyFieldName = "FID";
         this.ReportProperty.IsGroupSummary = true;
         base.ReportProperty.IsUIDesignerColumns = true;//列头是否BOSIDE设置
         base.ReportProperty.SimpleAllCols = false;//是否锁定帐表表格列
         //初始化报表使用到的临时表。过程中truncate掉，重复使用，关闭报表后删除
         InitCreateTempTables();
         //this.SetAllocationSQL();
      }
      #endregion

      #region 主方法
      //主方法
      public override void BuilderReportSqlAndTempTable(Kingdee.BOS.Core.Report.IRptParams filter, string tableName)
      {
         //base.BuilderReportSqlAndTempTable(filter, tableName);
         //string where = this.GetWhere(filter.FilterParameter.CustomFilter);
         //填充临时表
         FillTempTable(filter);
         //填充最终数据临时表
         FillfinalTempTable();
         //填充最终数据到平台需要展示的表（TableName）
         this.FillFinalDataToShowTable(tableName);
         //清空临时表数据And执行填充数据的SQL
         TruncateForClearTempTableData();
      }
      #endregion

      #region 初始化创建报表使用的临时表
      /// <summary>
     &nb

1人点赞

还没有人点赞，快来当第一个点赞的人吧！

打赏

0人打赏

还没有人打赏，快来当第一个打赏的人吧！

赞 1 评论收藏 1

二次开发的帐表在oracle中报错 table or view does not exit

恭喜您！