优化查询

schangxiang@126.com

2025-09-04 6f6f118881771a70feb186061ebb4ccd03a47e68

优化查询

 wcs/yunneiWCS/yunneiWCS/DataAccess/OutInStockRecord_V2_MesHandler.cs

@@ -172,7 +172,7 @@
            var stock = mod.productStock.Where(a => a.containerCode == _task.containerCode).FirstOrDefault();
            if (stock != null)
            {
                System.Collections.Generic.List<productStockList> productStocks = mod.productStockList.Where(a => a.stockId == stock.stockId).ToList();
                System.Collections.Generic.List<productStockList> productStocks = mod.productStockList.Where(a => a.stockId == stock.positionId).ToList();
                AddRecord(mod, _outInFlag, positionName, _task, remark,
                productStocks, currentTaskType);
            }

 wcs/yunneiWCS/yunneiWCS/ORM/productStockList.cs

@@ -12,6 +12,9 @@
        [Key]
        public long stockListId { get; set; }

        /// <summary>
        /// 表position的positionId
        /// </summary>
        public long? stockId { get; set; }

        [StringLength(50)]