金蝶云星空二开-无源单批号拣货！！

9527号码农

已于 2024-07-06 16:43:11 修改

阅读量457

点赞数 4

于 2024-07-06 16:22:01 首次发布

本文链接：https://blog.csdn.net/heweilx/article/details/140231318

版权

一，其他出库单物料值更新里面配置无源单批号拣货，根据角色分配的发货仓库权限，比如用户只给A仓库权限，选择其他仓库的物料就不拣货出来！，代码实现如下，代码继承AbstractSinglePickPlugIn无源单批号拣货父类，重写RegexSinglePickFilterString干预过滤拣货数据

using Kingdee.BOS.Core.Permission.Objects;
using Kingdee.BOS.Orm.DataEntity;
using Kingdee.BOS.ServiceHelper;
using Kingdee.BOS.Util;
using Kingdee.K3.SCM.App.Core.ConvertBusinessService;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Linq;
namespace kingdee.caida.BusinessPlugIn
{
    [HotUpdate]
    [Description("无源单批号拣货")]
    public class LotPickStockFilter : AbstractSinglePickPlugIn
    {
        /// <summary>
        /// 无源单单条捡货库存筛选过滤条件
        /// </summary>
        public override string RegexSinglePickFilterString(Kingdee.K3.SCM.App.Core.ConvertBusinessService.LotPickArgs.RegexSinglePickFilterStringArgs e)
        {
            string formId = this.BillInfo.GetForm().Id;
            List<BaseDataTempTable> lstBaseTempTable = PermissionServiceHelper.GetBaseDataTempTable(this.Ctx, formId);
            string stockDataRuleTemp = (from p in lstBaseTempTable where p.BaseDataFormId.EqualsIgnoreCase("BD_STOCK") select p.TempTable).FirstOrDefault();
            string stockid = "";
            if (!stockDataRuleTemp.IsNullOrEmptyOrWhiteSpace())
            {
                //查询设置权限的仓库id
                string stockSql = string.Format(@"SELECT tmp.*, ST.FNUMBER, TL.FNAME FROM {0} tmp JOIN T_BD_STOCK ST
  ON tmp.fstockid = ST.FSTOCKID
  JOIN T_BD_STOCK_L TL ON ST.FSTOCKID = TL.FSTOCKID", stockDataRuleTemp);
                DynamicObjectCollection data = DBServiceHelper.ExecuteDynamicObject(this.Ctx, stockSql);
                foreach (var dd in data)
                {
                    stockid += dd["FSTOCKID"] + ",";
                }
            }
            string stockwher = stockid.IsNullOrEmptyOrWhiteSpace() ? "" : " and TI.FSTOCKID in(" + stockid.Remove(stockid.Length - 1, 1) + ")";
            string where = base.RegexSinglePickFilterString(e) + stockwher;
            return where;
        }
    }
}