| | |
|---|
| | | |
|---|
| | | return sugarQueryable.InnerJoin(sugarQueryable1, (a, b) => a.LocationCode == b.LocationCode).Select((a, b) => new StockViewDTO |
|---|
| | | { |
|---|
| | | WarehouseId = a.WarehouseId, |
|---|
| | | AreaId = a.AreaId, |
|---|
| | | LocationCode = b.LocationCode, |
|---|
| | | Column = a.Column, |
|---|
| | |
|---|
| | | } |
|---|
| | | public List<Dt_StockInfo> GetStockInfosByPalletCode(List<string> palletCodes) |
|---|
| | | { |
|---|
| | | return Db.Queryable<Dt_StockInfo>().Where(x => palletCodes.Contains(x.BatchNo)).Includes(x => x.Details).ToList(); |
|---|
| | | return Db.Queryable<Dt_StockInfo>().Where(x => palletCodes.Contains(x.PalletCode)).Includes(x => x.Details).ToList(); |
|---|
| | | } |
|---|
| | | public List<Dt_StockInfo> GetStockInfosExclude(string materielCode, List<string> palletCodes) |
|---|
| | | { |
|---|
