public IActionResult GetOrderInfo_Submit() { //1,生成订单,2,关联购物车中商品为已绑定订单 string ids = GetParam("ids"); M_UserInfo mu = buser.GetLogin(false); DataTable cartDT = cartBll.SelByCartID(B_Cart.GetCartID(HttpContext), mu.UserID, ProClass, ids);//需要购买的商品 if (cartDT.Rows.Count < 1) { return(WriteErr("你尚未选择商品,<a href='/User/Order/OrderList'>查看我的订单</a>")); } VM_CartOrder vmMod = new VM_CartOrder(); vmMod.IsShowAddress(DataConvert.CLng(cartDT.Rows[0]["ProClass"])); //------------------------------ #region 检测缓存中的值与数据库中是否匹配 //string refreshTip = ",请点击<a href='" + Request.RawUrl() + "'>刷新页面</a>"; //if (VerifyDT == null || VerifyDT.Rows.Count < 1 || VerifyDT.Rows.Count != cartDT.Rows.Count) //{ return WriteErr("验证失效" + refreshTip, Request.RawUrl()); } //for (int i = 0; i < VerifyDT.Rows.Count; i++) //{ // //检测每一个商品,是否发生了ID/金额/数量/价格/总金额上面的差异或缺少 // DataRow verifyDR = VerifyDT.Rows[i]; // DataRow cartDR = GetDRFromDT(cartDT, Convert.ToInt32(verifyDR["ID"])); // if (cartDR == null) { return WriteErr("购物车信息不匹配" + refreshTip, Request.RawUrl()); } // foreach (string field in verifyFields) // { // double verifyVal = DataConvert.CDouble(verifyDR[field]); // double cartVal = DataConvert.CDouble(cartDR[field]); // if (verifyVal != cartVal) { return WriteErr("购物车的[" + field + "]不匹配" + refreshTip, Request.RawUrl()); } // } //} #endregion //------生成订单前检测区 foreach (DataRow dr in cartDT.Rows) { if (!HasStock(dr["Allowed"], DataConvert.CLng(dr["stock"]), Convert.ToInt32(dr["Pronum"]))) { return(WriteErr("购买失败," + dr["proname"] + "的库存数量不足")); } } //------检测End //按店铺生成订单 DataTable storeDT = cartDT.DefaultView.ToTable(true, "StoreID"); List <M_OrderList> orderList = new List <M_OrderList>();//用于生成临时订单,统计计算(Disuse) foreach (DataRow dr in storeDT.Rows) { #region 暂不使用字段 //Odata.province = this.DropDownList1.SelectedValue; //Odata.city = this.DropDownList2.SelectedValue;//将地址省份与市ID存入,XML数据源 //Odata.Guojia = "";//国家 //Odata.Chengshi = DropDownList2.SelectedItem.Text;//城市 //Odata.Diqu = DropDownList3.SelectedItem.Text;//地区 //Odata.Delivery = DataConverter.CLng(Request.Form["Delivery"]); //Odata.Deliverytime = DataConverter.CLng(this.Deliverytime.Text); //Odata.Mobile = receMod.MobileNum; #endregion M_OrderList Odata = new M_OrderList(); Odata.Ordertype = OrderHelper.GetOrderType(ProClass); Odata.OrderNo = B_OrderList.CreateOrderNo((M_OrderList.OrderEnum)Odata.Ordertype); Odata.StoreID = Convert.ToInt32(dr["StoreID"]); cartDT.DefaultView.RowFilter = "StoreID=" + Odata.StoreID; DataTable storeCartDT = cartDT.DefaultView.ToTable(); switch (vmMod.ProClass)//旅游机票等,以联系人信息为地址 { case 7: case 8: M_Cart_Travel model = JsonConvert.DeserializeObject <M_Cart_Travel>(storeCartDT.Rows[0]["Additional"].ToString()); M_Cart_Contract user = model.Contract[0]; Odata.Receiver = user.Name; Odata.Phone = user.Mobile; Odata.MobileNum = user.Mobile; Odata.Email = user.Email; break; default: if (vmMod.ShowAddress) { int arsID = DataConvert.CLng(GetParam("address_rad")); string arsChk = GetParam("ars_chk"); if (!string.IsNullOrEmpty(arsChk)) { #region 自提或微信共享地址 switch (arsChk) { case "self": { Odata.Receiver = "[用户自提]" + GetParam("arsInfo_name"); //用户上门购买,然后自提取商品 Odata.MobileNum = GetParam("arsInfo_mobile"); } break; case "wechat": { Odata.Receiver = GetParam("wxad_name"); Odata.MobileNum = GetParam("wxad_mobile"); Odata.Shengfen = GetParam("wxad_city"); Odata.Jiedao = GetParam("address"); } break; } #endregion } else { M_UserRecei receMod = receBll.GetSelect(arsID, mu.UserID); if (receMod == null) { return(WriteErr("用户尚未选择送货地址,或地址不存在")); } Odata.Receiver = receMod.ReceivName; Odata.Phone = receMod.phone; Odata.MobileNum = receMod.MobileNum; Odata.Email = receMod.Email; Odata.Shengfen = receMod.Provinces; Odata.Jiedao = receMod.Street; Odata.ZipCode = receMod.Zipcode; } } break; } Odata.Invoiceneeds = DataConverter.CLng(GetParam("invoice_rad"));//是否需开发票 Odata.Rename = mu.UserName; Odata.AddUser = mu.UserName;; Odata.Userid = mu.UserID; Odata.Ordermessage = GetParam("ORemind_T");//订货留言 //-----金额计算 Odata.Balance_price = GetTotalMoney(storeCartDT); Odata.Freight = GetFarePrice(storeCartDT, Odata.StoreID); //运费计算 Odata.Ordersamount = Odata.Balance_price + Odata.Freight; //订单金额 Odata.AllMoney_Json = orderCom.GetTotalJson(storeCartDT); //附加需要的虚拟币 Odata.Specifiedprice = Odata.Ordersamount; //订单金额; Odata.OrderStatus = (int)M_OrderList.StatusEnum.Normal; //订单状态 Odata.Paymentstatus = (int)M_OrderList.PayEnum.NoPay; //付款状态 //Odata.Integral = DataConverter.CLng(Request.QueryString["jifen"]); Odata.ExpTime = GetParam("exptime_hid"); Odata.id = orderBll.insert(Odata); //是否需要开发票 if (Odata.Invoiceneeds == 1) { M_Order_Invoice invMod = new M_Order_Invoice(); invMod.OrderID = Odata.id; invMod.InvHead = GetParam("InvoTitle_T").Trim(','); invMod.UserCode = GetParam("InvoUserCode_T").Trim(','); invMod.InvClass = GetParam("invUseType_rad"); invMod.InvContent = GetParam("Invoice_T").Trim(','); invMod.UserID = Odata.Userid; invBll.Insert(invMod); new B_Order_InvTlp().Sync(invMod); } cpBll.CopyToCartPro(mu, storeCartDT, Odata.id); orderList.Add(Odata); orderCom.SendMessage(Odata, null, "ordered"); } cartBll.DelByids(ids); //-----------------订单生成后处理 //进行减库存等操作 foreach (DataRow dr in cartDT.Rows) { M_Product model = proBll.GetproductByid(Convert.ToInt32(dr["Proid"])); model.Stock = model.Stock - DataConvert.CLng(dr["Pronum"]); SqlHelper.ExecuteSql("Update ZL_Commodities Set Stock=" + model.Stock + " Where ID=" + model.ID); } //生成支付单,处理优惠券,并进入付款步骤 M_Payment payMod = payBll.CreateByOrder(orderList); //优惠券 if (!string.IsNullOrEmpty(GetParam("Arrive_Hid"))) { M_Arrive avMod = avBll.SelModelByFlow(GetParam("Arrive_Hid"), mu.UserID); double money = payMod.MoneyPay; string remind = "支付单抵扣[" + payMod.PayNo + "]"; M_Arrive_Result retMod = avBll.U_UseArrive(avMod, mu.UserID, cartDT, money, remind); if (retMod.enabled) { payMod.MoneyPay = retMod.money; payMod.ArriveMoney = retMod.amount; payMod.ArriveDetail = avMod.ID.ToString(); } else { payMod.ArriveDetail = "优惠券[" + avMod.ID + "]异常 :" + retMod.err; } } //积分处理 int maxPoint = Point_CanBeUse(payMod.MoneyPay + payMod.ArriveMoney); if (maxPoint > 0 && DataConvert.CLng(GetParam("Point_T")) > 0) { int point = DataConvert.CLng(GetParam("Point_T")); //此处需咨询,上限额度是否要扣减掉优惠券 //if (point <= 0) { return WriteErr("积分数值不正确"); } if (point > mu.UserExp) { return(WriteErr("您的积分不足!")); } if (point > maxPoint) { return(WriteErr("积分不能大于可兑换金额[" + maxPoint + "]!")); } //生成支付单时扣除用户积分 buser.ChangeVirtualMoney(mu.UserID, new M_UserExpHis() { ScoreType = (int)M_UserExpHis.SType.Point, score = -point, detail = "积分抵扣,支付单号:" + payMod.PayNo }); payMod.UsePoint = point; payMod.UsePointArrive = Point_ToMoney(point); payMod.MoneyPay = payMod.MoneyPay - payMod.UsePointArrive; } payMod.MoneyReal = payMod.MoneyPay; payMod.Remark = cartDT.Rows.Count > 1 ? "[" + cartDT.Rows[0]["ProName"] as string + "]等" : cartDT.Rows[0]["ProName"] as string; payMod.PaymentID = payBll.Add(payMod); { string notify_url = CustomerPageAction.customPath2 + "Shop/Orderlistinfo?ID=" + orderList[0].id; ZoomLa.BLL.User.M_User_Notify notify = new ZoomLa.BLL.User.M_User_Notify(); notify.Title = "有新的订单了"; notify.Content = "<a href='" + notify_url + "' target='main_right' style='font-size:12px;' title='查看详情'>新订单:" + orderList[0].OrderNo + "</a>"; notify.NType = 1; notify.Gid = orderList[0].id.ToString(); notify.AppendReceUser("admin"); ZoomLa.BLL.User.B_User_Notify.Add(notify); } return(Redirect("/PayOnline/Orderpay?PayNo=" + payMod.PayNo)); }
public IActionResult GetOrderInfo() { M_UserInfo mu = buser.GetLogin(false); if (mu.Status != 0) { return(WriteErr("你的帐户未通过验证或被锁定")); } if (string.IsNullOrEmpty(ids)) { return(WriteErr("请先选定需要购买的商品")); } //--------------------MyBind //StringWriter sw = new StringWriter(); VM_CartOrder vmMod = new VM_CartOrder(); DataTable CartDT = vmMod.CartDT = cartBll.SelByCartID(CartCookID, mu.UserID, ProClass, ids); if (vmMod.CartDT.Rows.Count < 1) { return(WriteErr("你尚未选择商品,<a href='/User/Order/OrderList'>查看我的订单</a>")); } #region 旅游,酒店等不需要检测地址栏 switch (DataConvert.CLng(vmMod.CartDT.Rows[0]["ProClass"])) { case (int)M_Product.ClassType.LY: { M_Cart_Travel model = JsonConvert.DeserializeObject <M_Cart_Travel>(CartDT.Rows[0]["Additional"].ToString()); model.Guest.AddRange(model.Contract); vmMod.Guest = model.Guest; } break; case (int)M_Product.ClassType.JD: { M_Cart_Hotel model = JsonConvert.DeserializeObject <M_Cart_Hotel>(CartDT.Rows[0]["Additional"].ToString()); model.Guest.AddRange(model.Contract); vmMod.Guest = model.Guest; } break; default: //------地址 break; } #endregion //------核算费用 vmMod.StoreDT = orderCom.SelStoreDT(CartDT); vmMod.ProClass = DataConvert.CLng(vmMod.CartDT.Rows[0]["ProClass"]); vmMod.mu = mu; vmMod.allmoney = UpdateCartAllMoney(vmMod.CartDT); vmMod.usepoint = Point_CanBeUse(vmMod.allmoney); vmMod.IsShowAddress(vmMod.ProClass); vmMod.StoreDT.Columns.Add(new DataColumn("fareHtml", typeof(string))); for (int i = 0; i < vmMod.StoreDT.Rows.Count; i++) { CartDT.DefaultView.RowFilter = "StoreID=" + vmMod.StoreDT.Rows[i]["ID"]; DataTable dt = CartDT.DefaultView.ToTable(); if (dt.Rows.Count < 1) { continue; } DataTable fareDT = GetFareDT(dt); vmMod.StoreDT.Rows[i]["fareHtml"] = CreateFareHtml(fareDT); } //VerifyDT = CartDT.DefaultView.ToTable(false, verifyFields); return(View(vmMod)); }