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()));
}
