点击按钮后取销售订单上一个的值

棉球小哥

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 ALBB.BOS.ProJectName.BillTest2.Plugln
{
    //继承AbstractBillPlugIn
    public class ClassName2 : AbstractBillPlugIn
    {

        //重写override 函数
        public override void BarItemClick(Kingdee.BOS.Core.DynamicForm.PlugIn.Args.BarItemClickEventArgs e)
        {
            base.BarItemClick(e);


            //if条件判断
            if (e.BarItemKey.Equals("YDIE_tbTest2"))
            {
                var index_0 = this.View.Model.GetEntryRowCount("FSaleOrderEntry");
                // this.View.Model.SetValue("FNote", this.View.Model.GetEntryRowCount("FSaleOrderEntry"));
                for (int index_1 = 0; index_1 <= index_0; index_1 = index_1 + 1)
                {
                    var KHLH_1 = this.View.Model.GetValue("F_WKYC_Text1", index_1) as string; // 获取 "F_WKYC_Text1" 的值并将其作为字符串存储

                    //if (string.IsNullOrEmpty(KHLH_1))
                    //{
                    //    this.View.ShowErrMessage("第" + index_1 + "行没有获取到物料信息！" + KHLH_1);
                    //    return;
                    //}

                    //获取客户ID
                    var FCUSTobject = this.View.Model.GetValue("FCUSTID") as DynamicObject;

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

                    var sql = string.Format(@"/*dialect*/SELECT TOP 1 FMATERIALID,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_Text6
                        FROM T_SAL_ORDERENTRY as Tsaloe
                        inner join T_SAL_ORDER as Tsalo on Tsaloe.FID = Tsalo.FID
                        WHERE Tsaloe.F_WKYC_Text1 = '{0}' and Tsalo.FCUSTID = {1} and FDOCUMENTSTATUS = 'C' ORDER BY FENTRYID DESC", KHLH_1, FCUSTID);

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

                    var SALORDERObject = SALORDERObjects.FirstOrDefault();

                    if (SALORDERObject != null)
                    {
                        var FMATERIALID = 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");

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

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

                    this.View.UpdateView("FSaleOrderEntry");
                }
            }
        }
    }
}

棉球小哥

python:

import clr
clr.AddReference('System')
clr.AddReference('System.Data')
clr.AddReference('Kingdee.BOS')
clr.AddReference('Kingdee.BOS.Core')
clr.AddReference('Kingdee.BOS.App')
from Kingdee.BOS.App.Data import *

# 菜单按钮
def BarItemClick(e):
    if e.BarItemKey == "YDIE_tbTest2":
        index_0 = this.View.Model.GetEntryRowCount("FSaleOrderEntry")
        for index_1 in range(index_0):
            KHLH_1 = this.View.Model.GetValue("F_WKYC_Text1", index_1)  # 获取 "F_WKYC_Text1" 的值
            FCUSTobject = this.View.Model.GetValue("FCUSTID")  # 获取客户ID
            if FCUSTobject is None:
                this.View.ShowErrMessage("第{index_1}没有获取到客户信息！")
                return
            FCUSTID = FCUSTobject.Id
            sql = ("""/*dialect*/SELECT TOP 1 FMATERIALID,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_Text6
                        FROM T_SAL_ORDERENTRY as Tsaloe
                        inner join T_SAL_ORDER as Tsalo on Tsaloe.FID = Tsalo.FID
                        WHERE Tsaloe.F_WKYC_Text1 = '{0}' and Tsalo.FCUSTID = {1} and FDOCUMENTSTATUS = 'C' ORDER BY FENTRYID DESC""").format(KHLH_1,FCUSTID);
            # 根据条件获取销售订单明细数据信息
            SALORDERObjects = DBUtils.ExecuteDataSet(this.Context,sql);
            SALORDERObject = SALORDERObjects.Tables[0];
            for dr in SALORDERObject.Rows:
                FMATERIALID=dr["FMATERIALID"];
                this.View.Model.SetValue("FMATERIALID", FMATERIALID, index_1)

                F_WKYC_Text2=dr["F_WKYC_Text2"];
                this.View.Model.SetValue("F_WKYC_Text2", F_WKYC_Text2, index_1)

                F_WKYC_Text3=dr["F_WKYC_Text3"];
                this.View.Model.SetValue("F_WKYC_Text3", F_WKYC_Text3, index_1)

                F_WKYC_Text4=dr["F_WKYC_Text4"];
                this.View.Model.SetValue("F_WKYC_Text4", F_WKYC_Text4, index_1)

                F_WKYC_Combo1=dr["F_WKYC_Combo1"];
                this.View.Model.SetValue("F_WKYC_Combo1", F_WKYC_Combo1, index_1)

                F_WKYC_Combo2=dr["F_WKYC_Combo2"];
                this.View.Model.SetValue("F_WKYC_Combo2", F_WKYC_Combo2, index_1)

                F_WKYC_Combo3=dr["F_WKYC_Combo3"];
                this.View.Model.SetValue("F_WKYC_Combo3", F_WKYC_Combo3, index_1)

                F_WKYC_Combo=dr["F_WKYC_Combo"];
                this.View.Model.SetValue("F_WKYC_Combo", F_WKYC_Combo, index_1)

                F_WKYC_Text6=dr["F_WKYC_Text6"];
                this.View.Model.SetValue("F_WKYC_Text6", F_WKYC_Text6, index_1)

棉球小哥

python-值触发：

import clr
clr.AddReference('System')
clr.AddReference('System.Data')
clr.AddReference('Kingdee.BOS')
clr.AddReference('Kingdee.BOS.Core')
clr.AddReference('Kingdee.BOS.App')
from Kingdee.BOS.App.Data import *

# 菜单按钮
def DataChanged(e):
    fldKey=e.Field.Key.ToUpperInvariant();#字段标识大写
    if(fldKey=="F_WKYC_TEXT1"):#注意:示例代码是不等于，实际应使用等于进行判断
        row=e.Row;#字段所在的行号,从0开始，单据头字段为0
        oldValue=e.OldValue;#更新前字段值
        newValue=e.NewValue;#更新后的字段值
        msg=("第[{0}]行字段[{1}]从[{2}]更新成了[{3}]").format(row,fldKey,oldValue,newValue);
        index_0 = this.View.Model.GetEntryRowCount("FSaleOrderEntry")
        FID = this.View.BillBusinessInfo.GetForm().Id;
        for index_1 in range(index_0):
            KHLH_1 = this.View.Model.GetValue("F_WKYC_Text1", index_1)  # 获取 "F_WKYC_Text1" 的值
            FCUSTobject = this.View.Model.GetValue("FCUSTID")  # 获取客户ID
            if FCUSTobject is None:
                this.View.ShowErrMessage("没有获取到客户信息！")
                return
            FCUSTID = FCUSTobject.Id
            sql = ("""/*dialect*/SELECT TOP 1 FMATERIALID,Tsaloe.F_WKYC_Text1,F_WKYC_Text2, F_WKYC_Text3, F_WKYC_Text4, F_WKYC_Combo1, F_WKYC_Combo, F_XJKM_Combo3, F_WKYC_Combo2, F_WKYC_Text6
                        FROM T_SAL_ORDERENTRY as Tsaloe
                        inner join T_SAL_ORDER as Tsalo on Tsaloe.FID = Tsalo.FID
                        WHERE Tsaloe.F_WKYC_Text1 = '{0}' and Tsalo.FCUSTID = {1} and FDOCUMENTSTATUS = 'C' ORDER BY FENTRYID DESC""").format(KHLH_1,FCUSTID);
            # 根据条件获取销售订单明细数据信息
            SALORDERObjects = DBUtils.ExecuteDataSet(this.Context,sql);
            SALORDERObject = SALORDERObjects.Tables[0];
            for dr in SALORDERObject.Rows:
                FMATERIALID=dr["FMATERIALID"];
                this.View.Model.SetValue("FMATERIALID", FMATERIALID, index_1)
                

                F_WKYC_Text2=dr["F_WKYC_Text2"];
                this.View.Model.SetValue("F_WKYC_Text2", F_WKYC_Text2, index_1)

                F_WKYC_Text3=dr["F_WKYC_Text3"];
                this.View.Model.SetValue("F_WKYC_Text3", F_WKYC_Text3, index_1)

                F_WKYC_Text4=dr["F_WKYC_Text4"];
                this.View.Model.SetValue("F_WKYC_Text4", F_WKYC_Text4, index_1)

                F_WKYC_Combo1=dr["F_WKYC_Combo1"];
                this.View.Model.SetValue("F_WKYC_Combo1", F_WKYC_Combo1, index_1)

                F_WKYC_Combo2=dr["F_WKYC_Combo2"];
                this.View.Model.SetValue("F_WKYC_Combo2", F_WKYC_Combo2, index_1)

                F_XJKM_Combo3=dr["F_XJKM_Combo3"];
                this.View.Model.SetValue("F_XJKM_Combo3", F_XJKM_Combo3, index_1)

                F_WKYC_Combo=dr["F_WKYC_Combo"];
                this.View.Model.SetValue("F_WKYC_Combo", F_WKYC_Combo, index_1)

                F_WKYC_Text6=dr["F_WKYC_Text6"];
                this.View.Model.SetValue("F_WKYC_Text6", F_WKYC_Text6, index_1)