public int add(OrderAmountHistory history) { using (CrazyBuyDbContext dbContext = ContextInit()) { dbContext.OrderAmountHistory.Add(history); dbContext.SaveChanges(); return(history.id); } }
public static ReturnMessage addOrder(OrderMaster orderMaster, UserInfo userInfo) { ReturnMessage rm = new ReturnMessage(); int orderResult = MessageCode.ERROR; try { DateTime now = DateTime.Now; orderMaster.tenantId = userInfo.tnenatId; orderMaster.memberId = userInfo.memberId; orderMaster.dtOrder = now; orderMaster.dtInStock = now; orderMaster.createTime = now; orderMaster.updateTime = now; int total = 0; int taxAmount = 0; DataManager.shopCartDao.deleteTimeOutItem(userInfo.memberId); //防止購入超時商品 List <ShopCartPrd> shopCartPrds = DataManager.shopCartDao.getItemsByMember(userInfo.memberId); List <OrderDetail> detailList = new List <OrderDetail>(); Dictionary <int, TenantPrd> prdMap = new Dictionary <int, TenantPrd>(); TenantMemLevel tenantMemLevel = DataManager.tenantMemberDao.getMemberLevel(userInfo.memberId); //是否有高級會員折扣 double dis = 1; int memberLevelId = MessageCode.ERROR; if (tenantMemLevel != null) { memberLevelId = tenantMemLevel.id; dis = tenantMemLevel.discount * 0.01; } //結算購物車價錢及規格數量 foreach (ShopCartPrd item in shopCartPrds) { TenantPrd prdItem = DataManager.tenantPrdDao.getTenandPrd(item.productId); prdItem = isPrdSPecEnought(prdItem, item.prdSepc, item.count); if (prdItem != null) { OrderDetail detail = new OrderDetail(); detail.prdId = item.productId; detail.qty = item.count; detail.amount = item.amount; if (item.SpecialRule == null || !item.SpecialRule.Contains(UserDisType.NO_DIS)) { detail.amount = (int)(detail.amount * dis); } detail.unitPrice = detail.amount / detail.qty; detail.status = "正常"; detail.createTime = now; detail.updateTime = now; detail.prdSpec = item.prdSepc; detail.prdCustPriceId = item.prdCustPriceId; detail.priceGradeType = item.priceGradeType; total += detail.amount; detailList.Add(detail); if (!prdMap.ContainsKey(prdItem.id)) { prdMap.Add(prdItem.id, prdItem); } } } //檢查是否數量足夠 foreach (OrderDetail item in detailList) { TenantPrd prdItem = prdMap.GetValueOrDefault(item.prdId); prdItem.stockNum = prdItem.stockNum - item.qty; if (!string.IsNullOrEmpty(prdItem.zeroStockMessage) && prdItem.dtSellEnd > DateTime.Now) { if (prdItem.stockNum < 0) { Debug.WriteLine(prdItem.name); rm.code = MessageCode.PRD_NOT_ENOUGHT; return(rm); } } } //開始寫入價格 if (total != 0) { orderMaster.orderAmount = total; if (orderMaster.isNeedInvoice || orderMaster.invoiceType.Equals("捐贈")) { taxAmount = Convert.ToInt32(total * 0.05); } total += taxAmount; total += orderMaster.shippingAmount; orderMaster.totalAmount = total; // 5/14有需求說先將等待貨款拿掉 //orderMaster.payStatus = "等待貨款"; orderMaster.shippingStatus = "未出貨"; orderMaster.status = "新訂單"; orderMaster.taxAmount = taxAmount; if (MessageCode.ERROR != memberLevelId) { orderMaster.levelId = memberLevelId; } OrderMaster master = DataManager.orderDao.addOrderMaster(orderMaster); orderResult = master.id; rm.data = master; foreach (OrderDetail item in detailList) { TenantPrd prdItem = prdMap.GetValueOrDefault(item.prdId); DataManager.tenantPrdDao.updateTenandPrd(prdItem); item.orderId = master.id; DataManager.orderDao.addOrderDetail(item); } DataManager.shopCartDao.removeItemsByMember(userInfo.memberId); OrderAmountHistory histroy = new OrderAmountHistory(); histroy.orderId = master.id; histroy.changeDesc = "購物完成"; histroy.changeAmount = total; histroy.cumulativeAmount = 0; histroy.status = "正常"; histroy.createTime = DateTime.Now; histroy.creator = userInfo.memberId; DataManager.orderAmountHistoryDao.add(histroy); } } catch (Exception e) { MDebugLog.error("[COrderManager-addOrder] error: " + e); } rm.code = orderResult; return(rm); }