private bool CreateDetail(long id, TInRnD[] list) { var o = wms.TInRns.Where(x => x.Id == id).FirstOrDefault(); if (o == null) { return(false); } //o.PieceQty = details.Sum(x => x.Qty); //o.CartonQty = details.Where(x => !string.IsNullOrEmpty(x.Carton)).Distinct().Count(); foreach (var d in list) { var n = new TInRnD { HId = id, Sku = d.Sku, Barcode = d.Barcode, Qty = d.Qty, IsDeleted = false, CreatedBy = DefaultUser.UserName, CreatedTime = DateTime.UtcNow, }; wms.TInRnDs.Add(n); } return(wms.SaveChanges() > 0); }
public bool CreateDetail(long id, VRnDetailAddForm[] list) { var rnDetailList = new List <TInRnD>(); foreach (var detail in list) { var t = new TInRnD { Sku = detail.Sku, Barcode = detail.Barcode, Qty = detail.Qty }; rnDetailList.Add(t); } return(this.CreateDetail(id, rnDetailList.ToArray())); }
public bool Import(IFormFile file, long id, string code) { ioService.basePath = this.Root; //保存文件 DataTable dataTable = ioService.Import(file, "RN", code); var details = new List <TInRnD>(); //写入到数据库 for (int i = 0; i < dataTable.Rows.Count; i++) { TInRnD d = new TInRnD(); d.HId = id; d.Barcode = dataTable.Rows[i]["barcode"].ToString(); d.Sku = dataTable.Rows[i]["sku"].ToString(); d.Qty = Convert.ToInt32(dataTable.Rows[i]["qty"].ToString()); d.CreatedBy = DefaultUser.UserName; d.CreatedTime = DateTime.UtcNow; details.Add(d); } return(CreateDetail(id, details.ToArray())); }