| | |
| | | { |
| | | var action = new ApiAction<PageAble<BIZ_U9_RECEIPT>>(); |
| | | var query = Biz.DataSource["YadaU9C"].Client.Queryable<mes_ReturnedDocInfo>().Where(q => q.Status == 3) |
| | | .WhereIF(!input.OrderNo.IsNullOrEmpty(), q => q.DocNo.Contains(input.OrderNo)) |
| | | .WhereIF(!input.OrderNo.IsNullOrEmpty(), q => q.DocNo.Contains(input.OrderNo) || SqlFunc.Subqueryable<mes_AsnDocInfo>().Where(a => a.AsnId == q.SrcASNDocId && q.DocNo.Contains(input.OrderNo)).Any()) |
| | | .OrderBy(q => q.DocNo).ToPage(input.pageIndex, input.pageSize); |
| | | |
| | | action.Data = await MainDB.Queryable<BIZ_U9_RECEIPT>().Where(q => query.data.Select(o => o.DocNo).Contains(q.ORDER_NO)).ToPageAsync(input.pageIndex, input.pageSize); |
| | |
| | | public async Task<ApiAction<BIZ_U9_RECEIPT>> GetCurOrder() |
| | | { |
| | | var action = new ApiAction<BIZ_U9_RECEIPT>(); |
| | | action.Data = MainDB.Queryable<BIZ_U9_RECEIPT>().Where(q => q.ORDER_NO == CurOrderNo).IncludesAllFirstLayer().First(); |
| | | action.Data = await MainDB.Queryable<BIZ_U9_RECEIPT>().Where(q => q.ORDER_NO == CurOrderNo).IncludesAllFirstLayer().FirstAsync(); |
| | | return action; |
| | | } |
| | | |