开发案例分享-资产实物清单添加资产卡片的自定义字段

在固定资产卡片新增原资产编码字段，需要在资产实物清单进行显示

实现代码

using System;

using System.ComponentModel;

using System.Text;

using Kingdee.BOS;

using Kingdee.BOS.App;

using Kingdee.BOS.App.Data;

using Kingdee.BOS.Contracts;

using Kingdee.BOS.Core.Report;

using Kingdee.BOS.Util;

using Kingdee.K3.FIN.FA.App.Report;

namespace AssetListService.ServicePlugIn

{

    [Kingdee.BOS.Util.HotUpdate]

    [Description("资产卡片添加原资产编号")]

    public class AssetListService : AssetObjectListService

    {

        public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName)

        {

            IDBService service = ServiceHelper.GetService<IDBService>();

            this.customRptTempTableNames = service.CreateTemporaryTableName(base.Context, 1);

            string text = this.customRptTempTableNames[0];

            base.BuilderReportSqlAndTempTable(filter, text);

            StringBuilder stringBuilder = new StringBuilder();

            string format = "/*dialect*/SELECT t1.*,a3.F_PAEZ_HX_zichan into {0} FROM {1} t1 left join t_fa_card a3 on t1.FALTERID = a3.FALTERID";

            stringBuilder.AppendFormat(format, tableName, text);

            DBUtils.Execute(base.Context, stringBuilder.ToString());

        }

        public override ReportHeader GetReportHead