SQL 语句在 navicat for sql server 中测试没错，放进插件运行就报错

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using System.Data;
using System.Data.SqlClient;

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Kingdee.BOS;
using Kingdee.BOS.Core.Bill.PlugIn;
//添加引用后,缩写函数
using Kingdee.BOS.Core.DynamicForm.PlugIn.Args;
using System.ComponentModel;

using Kingdee.BOS;
using Kingdee.BOS.Core.Bill.PlugIn;
using System.ComponentModel;

//数据库
using Kingdee.BOS.App.Data;
using Kingdee.BOS.Orm.DataEntity;
using Kingdee.BOS.Core.DynamicForm;
using System.Data;



namespace Kingdee.Bos.Project.BillDataChanged.plugln
{
    [Description("DataChanged值更新后触发")]
    [Kingdee.BOS.Util.HotUpdate]


    public class ClassName : AbstractBillPlugIn
    {
        // DataChanged事件
        //public override void DataChanged(BOS.Core.DynamicForm.PlugIn.Args.DataChangedEventArgs e)
        //{
        //    base.DataChanged(e);
        //}
        //添加引用后,缩写函数


        public override void DataChanged(DataChangedEventArgs e)
        {
            base.DataChanged(e);
            

            string sql = "SELECT DISTINCT" +
                        "TOP 1 xt.FORDERNO as 订单编号," +
                        "xt.FBILLNO as 单据编号," +
                        "ma.FNUMBER as 产品物料编码," +
                        "xt.F_RBDZ_APPROVEDATE as 审核日期," +
                        "xte.FWIDTH as changdu_houdu," +
                        "xte.FREMARK as beizhu" +
                    "FROM" +
                        "T_RBDZ_CLPlanXT xt," +
                        "T_RBDZ_CLPlanXTEntity xte," +
                    "T_BD_MATERIAL ma" +
                    "WHERE" +
                        "xt.fid = xte.fid" +
                    "AND xte.FPRODUCT = ma.FMATERIALID" +
                    "AND ma.FNUMBER = '四通管道焊接件-2-2'" +
                    "ORDER BY" +
                        "F_RBDZ_APPROVEDATE DESC;";
            if (e.Field.Key == "FProduct")
            {
                this.View.ShowMessage("DataChanged  函数触发1");
                
                DataTable dt = DBUtils.ExecuteDataSet(this.Context, sql).Tables[0];

                 this.View.ShowMessage(dt.Rows.Count.ToString());
                 /*
                //循环,读取dt表有多少行
                for (int i = 0; i < dt.Rows.Count; i++)
                {

                    //给备注,赋值
                    this.View.Model.SetValue("FWIDTH", dt.Rows[i]["changdu_houdu"].ToString(), i);
                }

                //刷新
                this.View.UpdateView("FWIDTH");
                 */
                
            }


        }
    }
}

上传图片

上传图片

产品问题SQL 语句在 navicat for sql server 中测试没错，放进插件运行就报错

20 产品问题 SQL 语句在 navicat for sql server 中测试没错，放进插件运行就报错

恭喜您！

产品问题
SQL 语句在 navicat for sql server 中测试没错，放进插件运行就报错