客户值更新提示备注

棉球小哥

using Kingdee.BOS.Core.Bill.PlugIn;
using Kingdee.BOS.Core.DynamicForm.PlugIn.Args;
using System.ComponentModel;
using System.Data;
using Kingdee.BOS.App.Data;

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

    public class YourClassName : AbstractBillPlugIn //继承函数
    {
        // 初始化 sql 变量，用于存储查询语句
        string sql = "";
        // DataChanged事件，当数据发生变化时会触发此事件
        public override void DataChanged(DataChangedEventArgs e)
        {
            base.DataChanged(e);  // 调用基类的DataChanged方法
            // 如果变化的字段是"FCustId"
            if (e.Field.Key == "FCustId")
            {
                // 构建查询语句，根据新值查询客户描述 如果要更改导出的客户表内字段
                // 需要先数据库内查询后再更改[FDESCRIPTION]
                sql = @"/*dialect*/select FDESCRIPTION from T_BD_CUSTOMER_L where FCUSTID = '" + e.NewValue + "'";
                // 使用DBUtils执行查询
                var result = DBUtils.ExecuteDataSet(this.Context, sql);  // 在当前上下文中执行查询
                DataTable dt = result.Tables[0];  // 获取查询结果的第一个表格
                // 处理查询结果，如果有匹配的数据
                if (dt.Rows.Count > 0)
                {
                    string description = dt.Rows[0]["FDESCRIPTION"].ToString();  // 获取描述字段的值
                    this.View.ShowMessage(description);  // 在界面上显示描述信息
                    //this.View.Model.SetValue("FNote", description);  // 将描述信息赋值给名为"FNote"的字段 测试用
                    //this.View.UpdateView("FNote");  // 更新"FNote"字段的显示 测试用
                }
            }
        }
    }
}

棉球小哥


                    //获取客户ID
                    var FCUSTobject = this.View.Model.GetValue("FCustId").ToString();


                    var sql = string.Format(@"/*dialect*/SELECT TOP 1 FMATERIALID,F_WKYC_TEXT1, F_WKYC_Text2, F_WKYC_Text3,
                                            F_WKYC_Text4, F_WKYC_Combo1, F_WKYC_Combo, F_WKYC_Combo3, F_WKYC_Combo2, F_WKYC_Text5
                                            FROM T_SAL_ORDERENTRY WHERE F_WKYC_TEXT1 = " + KHLH +"ORDER BY FENTRYID DESC");

                    //根据条件获取到需要的销售订单明细数据信息
                    var SALORDERObjects = DBUtils.ExecuteDynamicObject(this.Context, sql);


                    var SALORDERObject = SALORDERObjects.FirstOrDefault();


                    if (SALORDERObject != null)
                    {
                        //客户料号
                        var FMaterialId_1 = SALORDERObject.GetDynamicObjectItemValue<string>("FMaterialId");
                        //客户牌号
                        var F_WKYC_Text2 = SALORDERObject.GetDynamicObjectItemValue<string>("F_WKYC_Text2");
                        //实际牌号
                        var F_WKYC_Text3 = SALORDERObject.GetDynamicObjectItemValue<string>("F_WKYC_Text3");
                        //公差
                        var F_WKYC_Text4 = SALORDERObject.GetDynamicObjectItemValue<string>("F_WKYC_Text4");
                        //是否充磁
                        var F_WKYC_Combo1 = SALORDERObject.GetDynamicObjectItemValue<string>("F_WKYC_Combo1");
                        //充磁方法
                        var F_WKYC_Combo = SALORDERObject.GetDynamicObjectItemValue<string>("F_WKYC_Combo");
                        //镀层
                        var F_WKYC_Combo3 = SALORDERObject.GetDynamicObjectItemValue<string>("F_WKYC_Combo3");
                        //级别
                        var F_WKYC_Combo2 = SALORDERObject.GetDynamicObjectItemValue<string>("F_WKYC_Combo2");
                        //客户生产编号
                        var F_WKYC_Text5 = SALORDERObject.GetDynamicObjectItemValue<string>("F_WKYC_Text5");

                        // 将查询的值赋给物料ID字段
                        this.View.Model.SetValue("FMaterialId", FMaterialId_1, index);
                        // 将查询的值赋给客户牌号字段
                        this.View.Model.SetValue("F_WKYC_Text2", F_WKYC_Text2, index);
                        // 将查询的值赋给实际牌号字段
                        this.View.Model.SetValue("F_WKYC_Text3", F_WKYC_Text3, index);
                        // 将查询的值赋给公差字段
                        this.View.Model.SetValue("F_WKYC_Text4", F_WKYC_Text4, index);
                        // 将查询的值赋给是否充磁字段
                        this.View.Model.SetValue("F_WKYC_Combo1", F_WKYC_Combo1, index);
                        // 将查询的值赋给充磁方法字段
                        this.View.Model.SetValue("F_WKYC_Combo", F_WKYC_Combo, index);

                        // 将查询的值赋给镀层字段
                        this.View.Model.SetValue("F_WKYC_Combo3", F_WKYC_Combo3, index);
                        // 将查询的值赋给级别字段
                        this.View.Model.SetValue("F_WKYC_Combo2", F_WKYC_Combo2, index);
                        // 将查询的值赋给客户生产编号字段
                        this.View.Model.SetValue("F_WKYC_Text5", F_WKYC_Text5, index);
                    }

                    this.View.UpdateView("FSaleOrderEntry");

棉球小哥

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 Kingdee.BOS.Orm.DataEntity;
using Kingdee.BOS.Core.SqlBuilder;
using Kingdee.BOS.Core.Metadata;
using System.ComponentModel;
using System.Data;
using Kingdee.BOS.App.Data;
using Kingdee.K3.Core.MFG.EntityHelper;

namespace ZY.ZZ.XX.BusinessPlugIn
{
    //[Kingdee.BOS.Util.HotUpdate]
    [Description("销售订单根据客户带出历史纪录")]
    public class T_SALE_BringOutFields : AbstractBillPlugIn
    {
        public override void DataChanged(DataChangedEventArgs e)
        {
            switch (e.Field.Key.ToUpperInvariant())
            {
                case "F_WKYC_Text1": // 修改为要匹配的字段名 "F_WKYC_Text1"
                    var index = e.Row;
                    var KHLH_1 = this.View.Model.GetValue("F_WKYC_Text1", index) as string; // 获取 "F_WKYC_Text1" 的值并将其作为字符串存储

                    if (string.IsNullOrEmpty(KHLH_1))
                    {
                        this.View.ShowErrMessage("没有获取到物料信息！"+ KHLH_1);
                        return;
                    }
                    this.View.UpdateView("FSaleOrderEntry");
                    //获取客户ID
                    var FCUSTobject = this.View.Model.GetValue("FCUSTID") as DynamicObject;

                    if (FCUSTobject == null)
                    {
                        this.View.ShowErrMessage("没有获取到客户信息！" + FCUSTobject);
                        return;
                    }
                    var FCUSTID = FCUSTobject.GetDynamicObjectItemValue<long>("Id");

                    var sql = string.Format(@"/*dialect*/SELECT TOP 1 Tsaloe.F_WKYC_Text1,F_WKYC_Text2, F_WKYC_Text3, F_WKYC_Text4, F_WKYC_Combo1, F_WKYC_Combo, F_WKYC_Combo3, F_WKYC_Combo2, F_WKYC_Text5
                                    FROM T_SAL_ORDERENTRY as Tsaloe
                                    inner join T_SAL_ORDER as Tsalo on Tsaloe.FID = Tsalo.FID
                                    WHERE Tsaloe.F_WKYC_Text1 = " + KHLH_1 + " and Tsalo.FCUSTID = "+ FCUSTID + " and FDOCUMENTSTATUS = 'C' ORDER BY FENTRYID DESC");

                    //根据条件获取到需要的销售订单明细数据信息
                    var SALORDERObjects = DBUtils.ExecuteDynamicObject(this.Context, sql);

                    var SALORDERObject = SALORDERObjects.FirstOrDefault();

                    if (SALORDERObject != null)
                    {
                        //客户料号
                        var F_WKYC_Text2 = SALORDERObject.GetDynamicObjectItemValue<string>("F_WKYC_Text2");
                        //实际牌号
                        var F_WKYC_Text3 = SALORDERObject.GetDynamicObjectItemValue<string>("F_WKYC_Text3");
                        //公差
                        var F_WKYC_Text4 = SALORDERObject.GetDynamicObjectItemValue<string>("F_WKYC_Text4");
                        //是否充磁
                        var F_WKYC_Combo1 = SALORDERObject.GetDynamicObjectItemValue<string>("F_WKYC_Combo1");
                        //充磁方法
                        var F_WKYC_Combo = SALORDERObject.GetDynamicObjectItemValue<string>("F_WKYC_Combo");
                        //镀层
                        var F_WKYC_Combo3 = SALORDERObject.GetDynamicObjectItemValue<string>("F_WKYC_Combo3");
                        //级别
                        var F_WKYC_Combo2 = SALORDERObject.GetDynamicObjectItemValue<string>("F_WKYC_Combo2");
                        //客户生产编号
                        var F_WKYC_Text5 = SALORDERObject.GetDynamicObjectItemValue<string>("F_WKYC_Text5");

                        // 将查询的值赋给客户料号字段
                        // this.View.Model.SetValue("F_WKYC_Text1", F_WKYC_Text1, index);
                        // 将查询的值赋给客户牌号字段
                        this.View.Model.SetValue("F_WKYC_Text2", F_WKYC_Text2, index);
                        this.View.UpdateView("F_WKYC_Text2");
                        // 将查询的值赋给实际牌号字段
                        this.View.Model.SetValue("F_WKYC_Text3", F_WKYC_Text3, index);
                        this.View.UpdateView("F_WKYC_Text3");
                        // 将查询的值赋给公差字段
                        this.View.Model.SetValue("F_WKYC_Text4", F_WKYC_Text4, index);
                        this.View.UpdateView("F_WKYC_Text4");
                        // 将查询的值赋给是否充磁字段
                        this.View.Model.SetValue("F_WKYC_Combo1", F_WKYC_Combo1, index);
                        // 将查询的值赋给充磁方法字段
                        this.View.Model.SetValue("F_WKYC_Combo", F_WKYC_Combo, index);

                        // 将查询的值赋给镀层字段
                        this.View.Model.SetValue("F_WKYC_Combo3", F_WKYC_Combo3, index);
                        // 将查询的值赋给级别字段
                        this.View.Model.SetValue("F_WKYC_Combo2", F_WKYC_Combo2, index);
                        // 将查询的值赋给客户生产编号字段
                        this.View.Model.SetValue("F_WKYC_Text5", F_WKYC_Text5, index);
                        this.View.UpdateView("F_WKYC_Text5");
                    }

                    this.View.UpdateView("FSaleOrderEntry");
                    break;
                default:
                    break;
            }
        }
    }
}