| | |
| | | }); |
| | | const searchFormOptions = ref([ |
| | | [ |
| | | { title: "鍗曟嵁缂栧彿", field: "orderNo", type: "like" }, |
| | | { title: "璇锋壂鎻忓崟鎹垨鏉$爜", field: "orderNo", type: "like" }, |
| | | { title: "涓婃父鍗曟嵁缂栧彿", field: "upperOrderNo", type: "like" }, |
| | | { |
| | | title: "鍗曟嵁绫诲瀷", |
| | |
| | | required: true, |
| | | }, |
| | | { |
| | | field: "outBoxbarcodes", |
| | | title: "澶栫鏉$爜", |
| | | type: "decimal", |
| | | width: 90, |
| | | align: "left", |
| | | required: true, |
| | | }, |
| | | { |
| | | field: "orderQuantity", |
| | | title: "鍗曟嵁鏁伴噺", |
| | | type: "decimal", |
| | |
| | | required: true, |
| | | }, |
| | | { |
| | | field: "outBoxbarcodes", |
| | | title: "澶栫鏉$爜", |
| | | type: "decimal", |
| | | width: 90, |
| | | align: "left", |
| | | required: true, |
| | | }, |
| | | { |
| | | field: "orderQuantity", |
| | | title: "鍗曟嵁鏁伴噺", |
| | | type: "decimal", |
| | |
| | | 锘縰sing Microsoft.Extensions.Logging; |
| | | using SqlSugar; |
| | | using System.Text.RegularExpressions; |
| | | using WIDESEA_Common.AllocateEnum; |
| | | using WIDESEA_Common.OrderEnum; |
| | | using WIDESEA_Core; |
| | |
| | | public override PageGridData<Dt_AllocateOrder> GetPageData(PageDataOptions options) |
| | | { |
| | | string wheres = ValidatePageOptions(options); |
| | | |
| | | string pattern = @"orderNo like '[^']+'\s*and\s*"; |
| | | wheres = Regex.Replace(wheres, pattern, "", RegexOptions.IgnoreCase); |
| | | //鑾峰彇鎺掑簭瀛楁 |
| | | Dictionary<string, SqlSugar.OrderByType> orderbyDic = GetPageDataSort(options, TProperties); |
| | | List<OrderByModel> orderByModels = new List<OrderByModel>(); |
| | |
| | | }; |
| | | orderByModels.Add(orderByModel); |
| | | } |
| | | |
| | | ISugarQueryable<Dt_AllocateOrder> sugarQueryable1 = BaseDal.Db.Queryable<Dt_AllocateOrder>(); |
| | | |
| | | int totalCount = 0; |
| | | List<SearchParameters> searchParametersList = new List<SearchParameters>(); |
| | |
| | | try |
| | | { |
| | | searchParametersList = options.Wheres.DeserializeObject<List<SearchParameters>>(); |
| | | if (searchParametersList.Count > 0) |
| | | { |
| | | |
| | | SearchParameters? searchParameters = searchParametersList.FirstOrDefault(x => x.Name == nameof(Dt_AllocateOrder.OrderNo).FirstLetterToLower()); |
| | | if (searchParameters != null) |
| | | { |
| | | sugarQueryable1 = sugarQueryable1.Where(x => x.OrderNo.Contains(searchParameters.Value.ToString()) |
| | | || x.UpperOrderNo.Contains(searchParameters.Value.ToString()) || |
| | | x.Details.Any(d => d.Barcode == searchParameters.Value.ToString()) || |
| | | x.Details.Any(d => d.BoxSN == searchParameters.Value.ToString())); |
| | | } |
| | | searchParameters = searchParametersList.FirstOrDefault(x => x.Name == nameof(Dt_AllocateOrder.OrderType).FirstLetterToLower()); |
| | | if (searchParameters != null) |
| | | { |
| | | sugarQueryable1 = sugarQueryable1.Where(x => x.OrderType.Equals(searchParameters.Value.ToString())); |
| | | } |
| | | //var dataList = sugarQueryable1.ToPageList(options.Page, options.Rows, ref totalCount); |
| | | //return new PageGridData<Dt_InboundOrder>(totalCount, dataList); |
| | | } |
| | | options.Filter = searchParametersList; |
| | | } |
| | | catch { } |
| | | } |
| | | var data = BaseDal.Db.Queryable<Dt_AllocateOrder>() |
| | | var data = sugarQueryable1 |
| | | .WhereIF(!wheres.IsNullOrEmpty(), wheres) |
| | | .OrderBy(orderByModels) |
| | | .OrderBy(orderByModels).Includes(x=>x.Details) |
| | | .ToPageList(options.Page, options.Rows, ref totalCount); |
| | | |
| | | foreach (var item in data) |
| | |
| | | { |
| | | sugarQueryable1 = sugarQueryable1.Where(x => x.InboundOrderNo.Contains(searchParameters.Value.ToString()) |
| | | || x.UpperOrderNo.Contains(searchParameters.Value.ToString()) || |
| | | x.Details.Any(d => d.Barcode == searchParameters.Value.ToString())); |
| | | x.Details.Any(d => d.Barcode == searchParameters.Value.ToString()) || |
| | | x.Details.Any(d => d.OutBoxbarcodes == searchParameters.Value.ToString())); |
| | | } |
| | | searchParameters = searchParametersList.FirstOrDefault(x => x.Name == nameof(Dt_InboundOrder.OrderType).FirstLetterToLower()); |
| | | if (searchParameters != null) |