| | |
|---|
| | | |
|---|
| | | 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 |
|---|
| | | { |
|---|
| | |
|---|
| | | StockStatus = b.StockStatus, |
|---|
| | | Details = b.Details, |
|---|
| | | }).ToPageList(options.Page, options.Rows, ref totalCount); |
|---|
| | | |
|---|
| | | |
|---|
| | | return new PageGridData<StockViewDTO>(totalCount, list); |
|---|
| | | |
|---|
| | | } |
|---|
