| | |
|---|
| | | |
|---|
| | | ISugarQueryable<Dt_StockInfo> sugarQueryable1 = _dbBase.Queryable<Dt_StockInfo>(); |
|---|
| | | ISugarQueryable<Dt_LocationInfo> sugarQueryable = _dbBase.Queryable<Dt_LocationInfo>(); |
|---|
| | | ISugarQueryable<Dt_StockInfoDetail> sugarQueryable2 = _dbBase.Queryable<Dt_StockInfoDetail>(); |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | List<StockViewDTO> list = sugarQueryable1.InnerJoin(sugarQueryable, (b, a) => a.LocationCode == b.LocationCode).WhereIF(!string.IsNullOrEmpty(where), where).Select((b, a) => new StockViewDTO |
|---|
| | | { |
|---|
| | | AreaId = a.AreaId, |
|---|
| | | LocationCode = b.LocationCode, |
|---|
| | | Column = a.Column, |
|---|
| | | CreateDate = b.CreateDate, |
|---|
| | | Creater = b.Creater, |
|---|
| | | Depth = a.Depth, |
|---|
| | | EnalbeStatus = a.EnableStatus, |
|---|
| | | IsFull = b.IsFull, |
|---|
| | | Layer = a.Layer, |
|---|
| | | LocationName = a.LocationName, |
|---|
| | | LocationStatus = a.LocationStatus, |
|---|
