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