| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | /// <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 " + |
|---|
