private bool CreateAsnDetail(long id, TInAsnD[] details)
{
var o = wms.TInAsns.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 details)
{
var n = new TInAsnD
{
HId = id,
Sku = d.Sku,
Barcode = d.Barcode,
Qty = d.Qty,
IsDeleted = false,
CreatedBy = DefaultUser.UserName,
CreatedTime = DateTime.UtcNow,
};
wms.TInAsnDs.Add(n);
}
return(wms.SaveChanges() > 0);
}
private bool DoCheckList(int whId, int custId, int brandId, TInAsnD asnDetail, TProdSku sku)
{
//校验asn里面的内容和sku信息是否一致.
var list = strategyService.CheckList(whId, custId, brandId);
var p1 = Enum.GetName(typeof(EnumCheckSku), EnumCheckSku.Product);
if (list.Contains(p1))
{
if (asnDetail.ProductCode != sku.ProductCode)
{
throw new Exception("product code is not eqals.");
}
}
return(true);
}
public bool CreateAsnDetailList(long id, VAsnDetailAddForm[] detailList)
{
var details = new List <TInAsnD>();
foreach (var detail in detailList)
{
TInAsnD d = new TInAsnD();
d.HId = id;
d.Carton = detail.Carton;
d.Sku = detail.Sku;
d.Barcode = detail.Barcode;
d.Qty = detail.Qty;
d.CreatedBy = DefaultUser.UserName;
d.CreatedTime = DateTime.UtcNow;
details.Add(d);
}
return(this.CreateAsnDetail(id, details.ToArray()));
}
public bool CreateFull(VAsnDetails vAsn)
{
var o = new TInAsn
{
Code = DateTime.Now.ToString(FormatString.DefaultFormat),
RefCode = DateTime.Now.ToString(FormatString.DefaultFormat),
WhId = vAsn.Asn.WhId,
CustId = vAsn.Asn.CustId,
BrandId = vAsn.Asn.BrandId,
BatchNo = vAsn.Asn.BatchNo ?? DateTime.Now.ToString("yyyyMMdd"),
BizCode = vAsn.Asn.BizCode,
GoodsType = vAsn.Asn.GoodsType,
TypeCode = "Asn",
TransCode = "Inbound",
SrcCode = "Interface",
IsCiq = false,
Status = "None",
CheckStatus = "None",
IsDeleted = false,
CreatedBy = "rickli",
CreatedTime = DateTime.UtcNow
};
var ds = new List <TInAsnD>();
foreach (var d in vAsn.AsnDs)
{
var n = new TInAsnD
{
Sku = d.Sku,
Barcode = d.Barcode,
Qty = d.Qty,
IsDeleted = false,
CreatedBy = "rickli",
CreatedTime = DateTime.UtcNow,
};
ds.Add(n);
o.DetailList.Add(n);
}
wms.TInAsns.Add(o);
return(wms.SaveChanges() > 0);
}
public bool Upload(IFormFile file, long id, string code)
{
ioService.basePath = this.Root;
//保存文件
DataTable dataTable = ioService.Import(file, "ASN", code);
var details = new List <TInAsnD>();
//写入到数据库
for (int i = 0; i < dataTable.Rows.Count; i++)
{
TInAsnD d = new TInAsnD();
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 = "rickli";
d.CreatedTime = DateTime.UtcNow;
details.Add(d);
}
return(CreateAsnDetail(id, details.ToArray()));
}
