修改车间记录列表数据显示异常问题

wxw

1 天以前 4aa0b9c9c2c56ec1af1dc3ee8ef12c9374b3d1ff

 Wms/WMS.BLL/DataServer/StockServer.cs

@@ -38,6 +38,7 @@
        }



        /// <summary>
        /// 获取库存物料类型分布
        /// </summary>
@@ -432,7 +433,10 @@
        /// <returns></returns>
        public List<MateDataStockDto> GetInventoryWarning(string skuNo, string skuName, string lotNo, string type)
        {
            string str = "select mate.Id,mate.SkuNo,mate.SkuName,mate.Standard,mate.Type,stock.Qty,stock.LockQty,stock.FrozenQty,stock.Qty - stock.LockQty - Stock.FrozenQty ResidueQty,stock.LotNo from SysMaterials mate right join DataStock stock on mate.SkuNo = stock.SkuNo Where stock.IsDel = @isdel and stock.Qty - stock.LockQty - Stock.FrozenQty <= mate.LowInventory";
            string str = $@"select mate.Id,mate.SkuNo,mate.SkuName,mate.Standard,mate.Type,stock.Qty,stock.LockQty,stock.FrozenQty,stock.Qty-stock.LockQty-Stock.FrozenQty ResidueQty,stock.LotNo 
from SysMaterials mate 
right join DataStock stock on mate.SkuNo=stock.SkuNo 
Where stock.IsDel=@isdel and stock.Qty-stock.LockQty-Stock.FrozenQty<mate.LowInventory";
            //判断物料号是否为空
            if (!string.IsNullOrEmpty(skuNo))
            {