| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 获取库存物料类型分布 |
|---|
| | | /// </summary> |
|---|
| | |
|---|
| | | /// <param name="wareHouseNo">所属仓库</param> |
|---|
| | | /// <param name="areaNo">所属区域</param> |
|---|
| | | /// <returns></returns> |
|---|
| | | public async Task<List<MateDataStockDto>> GetDataStockList(string selectType, string skuNo, string skuName, string ownerNo, |
|---|
| | | string ownerName, string lotNo, string status, string inspectStatus, string wareHouseNo, string areaNo) |
|---|
| | | public async Task<List<MateDataStockDto>> GetDataStockList(string selectType, string skuNo, string skuName, string ownerNo, string ownerName, string lotNo, string status, string inspectStatus, string wareHouseNo, string areaNo) |
|---|
| | | { |
|---|
| | | Expression<Func<DataStockDetail, bool>> item = Expressionable.Create<DataStockDetail>() |
|---|
| | | .AndIF(!string.IsNullOrEmpty(skuNo), a => a.SkuNo.Contains(skuNo)) |
|---|
| | |
|---|
| | | /// <param name="status">库存状态</param> |
|---|
| | | /// <param name="inspectStatus">质检状态</param> |
|---|
| | | /// <returns></returns> |
|---|
| | | public List<StockDetailDto> GetInventoryList1(string skuNo, string skuName, string lotNo, string locatNo, string palletNo, |
|---|
| | | string status, string inspectStatus, string ownerNo, string ownerName, string startTime, string endTime) |
|---|
| | | public List<StockDetailDto> GetInventoryList1(string skuNo, string skuName, string lotNo, string locatNo, string palletNo, string status, string inspectStatus, string ownerNo, string ownerName, string startTime, string endTime) |
|---|
| | | { |
|---|
| | | string str = "select detail.*,house.WareHouseNo + '-' + house.WareHouseName as WareHouseName," + |
|---|
| | | "roadway.RoadwayNo + '-' + roadway.RoadwayName as RoadwayName,area.AreaNo + '-' + area.AreaName as AreaName " + |
|---|
| | |
|---|
| | | /// <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)) |
|---|
| | | { |
|---|
