| | |
|---|
| | | /// <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)) |
|---|
| | | { |
|---|
