public void AddOrderProducts(HTJKEntities db, OrderProductsModels OPModels)
{
var PrTables = new OrderProductsInfo();
PrTables.Id = Guid.NewGuid();
PrTables.Ordernum = OPModels.Ordernum;
PrTables.ProductsId = OPModels.ProductsId;
PrTables.Amount = OPModels.Amount;
PrTables.SalePrice = OPModels.Saleprice;
PrTables.ProductsName = OPModels.ProductsName;
PrTables.ProductsConvertImg = OPModels.ProductsConvertImg;
db.OrderProductsInfo.Add(PrTables);
}
public void AddOrder(OrderModel models)
{
using (var db = new HTJKEntities())
{
if (models.Carts != null)
{
var tables = new OrderInfo();
tables.Ordernum = models.Ordernum;
tables.AddressId = models.AddressId;
tables.MemberId = models.MemberId;
tables.DKGold = models.DKGold;
tables.DKStock = models.DKStock;
tables.DKPrce = models.DKPrce;
tables.YunFei = models.YunFei;
tables.CreateTime = DateTime.Now;
tables.PayState = false;
tables.State = true;
tables.TotalPrice = models.TotalPrice;
tables.SubtractPrice = 0;
tables.Remarks = models.Remarks;
db.OrderInfo.Add(tables);
OrderProductsModels OPModels = new OrderProductsModels();
foreach (var item in models.Carts)
{
OPModels.Ordernum = models.Ordernum;
OPModels.ProductsId = item.Product.Id;
OPModels.Amount = item.Amount;
OPModels.Saleprice = Convert.ToDecimal(item.Product.SalePrice);
OPModels.ProductsName = item.Product.Name;
OPModels.ProductsConvertImg = item.Product.ConvertImg;
AddOrderProducts(db, OPModels);
using (var prdb = new HTJKEntities())
{
var proTab = prdb.A_News.Where(k => k.Id == item.Product.Id).SingleOrDefault();
if (proTab != null)
{
proTab.SaleCount = proTab.SaleCount ?? 0 + item.Amount;
}
prdb.SaveChanges();
}
}
db.SaveChanges();
}
}
}
