| | |
| | | using System.Web; |
| | | using System.Text; |
| | | using Furion.DatabaseAccessor; |
| | | using Mapster; |
| | | using Admin.NET.Application.Service.WmsOrder.Mes_BatchOrderUPI_New.Dto; |
| | | |
| | | namespace Admin.NET.Application; |
| | | /// <summary> |
| | |
| | | return await _rep.GetFirstAsync(u => u.Id == input.Id); |
| | | } |
| | | |
| | | [HttpPost] |
| | | [ApiDescriptionSettings(Name = "GetBatchOrderUPIList")] |
| | | [UnitOfWork] |
| | | [AllowAnonymous] |
| | | public async Task GetBatchOrderUPIList(List<GetBatchOrderUPIInput> input) |
| | | { |
| | | List<Mes_BatchOrderUPI_New> list = new List<Mes_BatchOrderUPI_New>(); |
| | | foreach (var item in input) |
| | | { |
| | | Mes_BatchOrderUPI_New task = new Mes_BatchOrderUPI_New(); |
| | | task = item.Adapt<Mes_BatchOrderUPI_New>(); |
| | | task.AreaCode = AreaCodeEnum.无区域; |
| | | task.UpiStatus = UpiStatusEnum.初始; |
| | | list.Add(task); |
| | | } |
| | | await _rep.InsertRangeAsync(list); |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | |
| | | var _Info1 = "";//纸箱长 |
| | | var _Info2 = "";//纸箱宽 |
| | | var _Info3 = "";//纸箱高 |
| | | var _Info4 = "";//销售合同单号 |
| | | var _Info5 = "";//生产单号 |
| | | var _Info6 = "";//第几包 |
| | | var _Info7 = "";//经销店名称 |
| | | var _Info8 = "";//产品名称 |
| | | var _Info10 = "";//客户名称 |
| | | var _Info9 = "";//包装编码 |
| | | var _Info11 = "";//自提or发货 |
| | | var _Info12 = "";//包装部件总数量 |
| | | var _Info13 = "";//包装面积 |
| | | var _Info14 = "";//部件名称 |
| | | var _Info15 = "";//部件数量 |
| | | var _Info16 = "";//部件尺寸 |
| | | #endregion |
| | | |
| | | |
| | |
| | | _Info1 = row["纸箱长"]?.ToString(); |
| | | _Info2 = row["纸箱宽"]?.ToString(); |
| | | _Info3 = row["纸箱高"]?.ToString(); |
| | | _Info4 = row["销售合同单号"]?.ToString() ; |
| | | _Info5 = row["生产单号"]?.ToString() ; |
| | | _Info6 = row["第几包"]?.ToString() ; |
| | | _Info7 = row["经销店名称"]?.ToString() ; |
| | | _Info8 = row["产品名称"]?.ToString() ; |
| | | _Info10 = row["客户名称"]?.ToString() ; |
| | | _Info9 = row["包装编码"]?.ToString() ; |
| | | _Info11 = row["自提or发货"]?.ToString() ; |
| | | _Info12 = row["包装部件总数量"]?.ToString() ; |
| | | _Info13 = row["包装面积"]?.ToString() ; |
| | | _Info14 = row["部件名称"]?.ToString() ; |
| | | _Info15 = row["部件数量"]?.ToString() ; |
| | | _Info16 = row["部件尺寸"]?.ToString() ; |
| | | #endregion |
| | | |
| | | |
| | |
| | | { |
| | | addItem.PackageCode = (string)(_PackageCode.Trim()); |
| | | } |
| | | //if(!string.IsNullOrEmpty(_MachineXCenter)) |
| | | //{ |
| | | // addItem.MachineXCenter = (float)(_MachineXCenter.Trim()); |
| | | // } |
| | | //if(!string.IsNullOrEmpty(_MachineYCenter)) |
| | | //{ |
| | | // addItem.MachineYCenter = (float)(_MachineYCenter.Trim()); |
| | | // } |
| | | //if(!string.IsNullOrEmpty(_MachineZCenter)) |
| | | //{ |
| | | // addItem.MachineZCenter = (float)(_MachineZCenter.Trim()); |
| | | // } |
| | | |
| | | if (!string.IsNullOrEmpty(_Sequence)) |
| | | { |
| | | if (!int.TryParse(_Sequence, out int outSequence) && !string.IsNullOrEmpty(_Sequence)) |
| | |
| | | } |
| | | |
| | | } |
| | | //if(!string.IsNullOrEmpty(_Rotation)) |
| | | //{ |
| | | // addItem.Rotation = (float)(_Rotation.Trim()); |
| | | // } |
| | | //if(!string.IsNullOrEmpty(_Info1)) |
| | | //{ |
| | | // addItem.Info1 = (float)(_Info1.Trim()); |
| | | // } |
| | | //if(!string.IsNullOrEmpty(_Info2)) |
| | | //{ |
| | | // addItem.Info2 = (float)(_Info2.Trim()); |
| | | // } |
| | | //if(!string.IsNullOrEmpty(_Info3)) |
| | | //{ |
| | | // addItem.Info3 = (float)(_Info3.Trim()); |
| | | // } |
| | | |
| | | if(!string.IsNullOrEmpty(_Info4)) |
| | | { |
| | | addItem.Info4 = (string)(_Info4.Trim()); |
| | | } |
| | | if(!string.IsNullOrEmpty(_Info5)) |
| | | { |
| | | addItem.Info5 = (string)(_Info5.Trim()); |
| | | } |
| | | if(!string.IsNullOrEmpty(_Info6)) |
| | | { |
| | | addItem.Info6 = (string)(_Info6.Trim()); |
| | | } |
| | | if(!string.IsNullOrEmpty(_Info7)) |
| | | { |
| | | addItem.Info7 = (string)(_Info7.Trim()); |
| | | } |
| | | if(!string.IsNullOrEmpty(_Info8)) |
| | | { |
| | | addItem.Info8 = (string)(_Info8.Trim()); |
| | | } |
| | | if(!string.IsNullOrEmpty(_Info10)) |
| | | { |
| | | addItem.Info10 = (string)(_Info10.Trim()); |
| | | } |
| | | if(!string.IsNullOrEmpty(_Info9)) |
| | | { |
| | | addItem.Info9 = (string)(_Info9.Trim()); |
| | | } |
| | | if(!string.IsNullOrEmpty(_Info11)) |
| | | { |
| | | addItem.Info11 = (string)(_Info11.Trim()); |
| | | } |
| | | if(!string.IsNullOrEmpty(_Info12)) |
| | | { |
| | | addItem.Info12 = (string)(_Info12.Trim()); |
| | | } |
| | | if(!string.IsNullOrEmpty(_Info13)) |
| | | { |
| | | addItem.Info13 = (string)(_Info13.Trim()); |
| | | } |
| | | if(!string.IsNullOrEmpty(_Info14)) |
| | | { |
| | | addItem.Info14 = (string)(_Info14.Trim()); |
| | | } |
| | | if(!string.IsNullOrEmpty(_Info15)) |
| | | { |
| | | if (!int.TryParse(_Info15, out int outInfo15)&&!string.IsNullOrEmpty(_Info15)) |
| | | { |
| | | throw Oops.Oh($"第{index}行[部件数量]{_Info15}值不正确!"); |
| | | } |
| | | if (outInfo15 <= 0&&!string.IsNullOrEmpty(_Info15)) |
| | | { |
| | | throw Oops.Oh($"第{index}行[部件数量]{_Info15}值不能小于等于0!"); |
| | | } |
| | | else |
| | | { |
| | | addItem.Info15 = outInfo15; |
| | | } |
| | | |
| | | } |
| | | if(!string.IsNullOrEmpty(_Info16)) |
| | | { |
| | | addItem.Info16 = (string)(_Info16.Trim()); |
| | | } |
| | | #endregion |
| | | |
| | | |
| | |
| | | || u.DetailName.Contains(input.SearchKey.Trim()) |
| | | || u.Matgrid.Contains(input.SearchKey.Trim()) |
| | | || u.PackageCode.Contains(input.SearchKey.Trim()) |
| | | || u.Info4.Contains(input.SearchKey.Trim()) |
| | | || u.Info5.Contains(input.SearchKey.Trim()) |
| | | || u.Info6.Contains(input.SearchKey.Trim()) |
| | | || u.Info7.Contains(input.SearchKey.Trim()) |
| | | || u.Info8.Contains(input.SearchKey.Trim()) |
| | | || u.Info10.Contains(input.SearchKey.Trim()) |
| | | || u.Info9.Contains(input.SearchKey.Trim()) |
| | | || u.Info11.Contains(input.SearchKey.Trim()) |
| | | || u.Info12.Contains(input.SearchKey.Trim()) |
| | | || u.Info13.Contains(input.SearchKey.Trim()) |
| | | || u.Info14.Contains(input.SearchKey.Trim()) |
| | | || u.Info16.Contains(input.SearchKey.Trim()) |
| | | || u.CreateUserName.Contains(input.SearchKey.Trim()) |
| | | || u.UpdateUserName.Contains(input.SearchKey.Trim()) |
| | | ) |
| | |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.PackageCode), u => u.PackageCode.Contains(input.PackageCode.Trim())) |
| | | .WhereIF(input.Sequence > 0, u => u.Sequence == input.Sequence) |
| | | .WhereIF(input.Shelf > 0, u => u.Shelf == input.Shelf) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.Info4), u => u.Info4.Contains(input.Info4.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.Info5), u => u.Info5.Contains(input.Info5.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.Info6), u => u.Info6.Contains(input.Info6.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.Info7), u => u.Info7.Contains(input.Info7.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.Info8), u => u.Info8.Contains(input.Info8.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.Info10), u => u.Info10.Contains(input.Info10.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.Info9), u => u.Info9.Contains(input.Info9.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.Info11), u => u.Info11.Contains(input.Info11.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.Info12), u => u.Info12.Contains(input.Info12.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.Info13), u => u.Info13.Contains(input.Info13.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.Info14), u => u.Info14.Contains(input.Info14.Trim())) |
| | | .WhereIF(input.Info15>0, u => u.Info15 == input.Info15) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.Info16), u => u.Info16.Contains(input.Info16.Trim())) |
| | | .Select<Mes_BatchOrderUPI_NewOutput>(); |
| | | return query; |
| | | } |
| | |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | [HttpPost] |
| | | [ApiDescriptionSettings(Name = "GetBatchOrderUPIList")] |
| | | [UnitOfWork] |
| | | [AllowAnonymous] |
| | | public async Task GetBatchOrderUPIList(List<GetBatchOrderUPIInput> input) |
| | | { |
| | | List<Mes_BatchOrderUPI_New> list = new List<Mes_BatchOrderUPI_New>(); |
| | | foreach (var item in input) |
| | | { |
| | | Mes_BatchOrderUPI_New task = new Mes_BatchOrderUPI_New(); |
| | | task = item.Adapt<Mes_BatchOrderUPI_New>(); |
| | | task.AreaCode = AreaCodeEnum.无区域; |
| | | task.UpiStatus = UpiStatusEnum.初始; |
| | | list.Add(task); |
| | | } |
| | | await _rep.InsertRangeAsync(list); |
| | | } |
| | | |
| | | } |
| | | |