private void MyBind() { int guestnum = 0, totalnum = 0; if (!string.IsNullOrEmpty(ids)) { M_Cart cartMod = cartBll.SelReturnModel(DataConvert.CLng(ids.Split(',')[0])); M_Cart_Hotel hotelMod = JsonConvert.DeserializeObject <M_Cart_Hotel>(cartMod.Additional); Pros = JsonConvert.SerializeObject(hotelMod.ProList); Guest_Hid2.Value = JsonConvert.SerializeObject(hotelMod.Guest); Contract_Hid2.Value = JsonConvert.SerializeObject(hotelMod.Contract); guestnum = hotelMod.Guest.Count; } //绑定显示商品 if (!string.IsNullOrEmpty(Pros)) { JArray proArr = (JArray)JsonConvert.DeserializeObject(Pros);//将其转化为DataTable? DataTable proDT = CreateProDT(); double proAllMoney = 0; for (int i = 0; i < proArr.Count; i++) { M_Product proMod = proBll.GetproductByid(Convert.ToInt32(proArr[i]["ProID"].ToString())); if (proMod.ID > 0) { for (int j = 0; j < DataConvert.CLng(proArr[i]["Pronum"].ToString()); j++) { DataRow proDR = proDT.NewRow(); proDR["ProID"] = proMod.ID; proDR["ProName"] = proMod.Proname; proDR["Pronum"] = GetDiffDay(DataConvert.CDate(proArr[i]["GoDate"].ToString()), DataConvert.CDate(proArr[i]["OutDate"].ToString())); proDR["Price"] = proMod.LinPrice; proDR["AllMoney"] = GetDiffDay(DataConvert.CDate(proArr[i]["GoDate"].ToString()), DataConvert.CDate(proArr[i]["OutDate"].ToString())) * Convert.ToDouble(proDR["Price"]); proDR["GoDate"] = DataConvert.CDate(proArr[i]["GoDate"]); proDR["OutDate"] = proArr[i]["OutDate"].ToString(); proDR["Remind"] = HttpUtility.UrlDecode(proArr[i]["Remind"].ToString()); proDT.Rows.Add(proDR); proAllMoney += Convert.ToDouble(proDR["AllMoney"]); totalnum += 2; } } } AllMoney_sp.InnerText = proAllMoney.ToString("0.00"); ProList_RPT.DataSource = proDT; ProList_RPT.DataBind(); Pros = JsonHelper.JsonSerialDataTable(proDT); function.Script(this, "AddGuests(" + (string.IsNullOrEmpty(ids) ? totalnum : guestnum) + ");"); } }
//用于酒店订单等 public string GetAddition() { string additional = Eval("Additional").ToString(), result = "", contract = ""; if (string.IsNullOrEmpty(additional)) { return(""); } switch (ProClass) { case 7: //旅游,酒店,机票 { string tlp = "入住时间:{0}<br/>联系人:{1}"; M_Cart_Travel model = JsonConvert.DeserializeObject <M_Cart_Travel>(additional); foreach (M_Cart_Contract m in model.Contract) { contract += m.Name + "," + m.Mobile + "|"; } contract = contract.TrimEnd('|'); string another = string.IsNullOrEmpty(model.ProList[0].Remind) ? "" : DataConvert.CDate(model.ProList[0].Remind).ToString("MM-dd HH:mm"); result = string.Format(tlp, model.ProList[0].GoDate.ToString("MM-dd HH:mm --") + another, contract); } break; case 8: { string tlp = "订单信息:{0},{1}人,时间:{2}--{3}<br/>入住人:{4}<br/>联系人:{5}"; M_Cart_Hotel model = JsonConvert.DeserializeObject <M_Cart_Hotel>(additional); foreach (M_Cart_Contract m in model.Contract) { contract += m.Name + "," + m.Mobile + "|"; } contract = contract.TrimEnd('|'); result = string.Format(tlp, model.HotelName, model.PeopleNum, model.ProList[0].GoDate, model.ProList[0].OutDate, model.Guest[0].Name, contract); } break; case 9: break; default: break; } return(result); }
public void MyBind() { CartDT = cartBll.SelByCookID(CartCookID, ProClass, ids); if (CartDT.Rows.Count < 1) { function.WriteErrMsg("你尚未选择商品,<a href='/User/Order/OrderList.aspx'>查看我的订单</a>"); } //旅游,酒店等不需要检测地址栏 switch (DataConvert.CLng(CartDT.Rows[0]["ProClass"])) { case (int)M_Product.ClassType.LY: { userli.Visible = true; M_Cart_Travel model = JsonConvert.DeserializeObject <M_Cart_Travel>(CartDT.Rows[0]["Additional"].ToString()); model.Guest.AddRange(model.Contract); UserRPT.DataSource = model.Guest; UserRPT.DataBind(); } break; case (int)M_Product.ClassType.JD: { userli.Visible = true; M_Cart_Hotel model = JsonConvert.DeserializeObject <M_Cart_Hotel>(CartDT.Rows[0]["Additional"].ToString()); model.Guest.AddRange(model.Contract); UserRPT.DataSource = model.Guest; UserRPT.DataBind(); } break; default: //------地址 DataTable addressDT = receBll.SelByUID(buser.GetLogin().UserID); AddressRPT.DataSource = addressDT; AddressRPT.DataBind(); EmptyDiv.Visible = addressDT.Rows.Count < 1; //地址为空提醒 break; } //------核算费用 double allmoney = UpdateCartAllMoney(CartDT); //------费用统计 itemnum_span.InnerText = CartDT.Rows.Count.ToString(); totalmoney_span1.InnerText = allmoney.ToString("f2"); //------店铺 Store_RPT.DataSource = orderCom.SelStoreDT(CartDT); Store_RPT.DataBind(); //------发票绑定 DataTable invoceDT = new DataTable();//orderBll.SelInvoByUser(buser.GetLogin().UserID); if (invoceDT.Rows.Count > 0) { Invoice_RPT.DataSource = invoceDT; Invoice_RPT.DataBind(); } else { Invoice_RPT.Visible = false; } //------积分抵扣 if (SiteConfig.ShopConfig.PointRatiot > 0 && SiteConfig.ShopConfig.PointRatiot < 100 && SiteConfig.ShopConfig.PointRate > 0) { point_body.Visible = true; M_UserInfo usermod = buser.GetLogin(); Point_L.Text = usermod.UserExp.ToString(); int usepoint = (int)(allmoney * (SiteConfig.ShopConfig.PointRatiot * 0.01) / SiteConfig.ShopConfig.PointRate); function.Script(this, "SumByPoint(" + usepoint + ");"); PointRate_Hid.Value = SiteConfig.ShopConfig.PointRate.ToString(); } else { point_tips.Visible = true; } }
public void MyBind() { M_UserInfo mu = buser.GetLogin(); CartDT = cartBll.SelByCartID(B_Cart.GetCartID(), mu.UserID, ProClass, ids); if (CartDT.Rows.Count < 1) { function.WriteErrMsg("你尚未选择商品,<a href='/User/Order/OrderList'>查看我的订单</a>"); } //旅游,酒店等不需要检测地址栏 switch (DataConvert.CLng(CartDT.Rows[0]["ProClass"])) { case (int)M_Product.ClassType.LY: { userli.Visible = true; M_Cart_Travel model = JsonConvert.DeserializeObject <M_Cart_Travel>(CartDT.Rows[0]["Additional"].ToString()); model.Guest.AddRange(model.Contract); UserRPT.DataSource = model.Guest; UserRPT.DataBind(); } break; case (int)M_Product.ClassType.JD: { userli.Visible = true; M_Cart_Hotel model = JsonConvert.DeserializeObject <M_Cart_Hotel>(CartDT.Rows[0]["Additional"].ToString()); model.Guest.AddRange(model.Contract); UserRPT.DataSource = model.Guest; UserRPT.DataBind(); } break; default: //------地址 DataTable addressDT = receBll.SelByUID(buser.GetLogin().UserID); AddressRPT.DataSource = addressDT; AddressRPT.DataBind(); EmptyDiv.Visible = addressDT.Rows.Count < 1; //地址为空提醒 break; } //------核算费用 allmoney = UpdateCartAllMoney(CartDT); //------费用统计 itemnum_span.InnerText = CartDT.Rows.Count.ToString(); totalmoney_span1.InnerText = allmoney.ToString("f2"); //------店铺 Store_RPT.DataSource = orderCom.SelStoreDT(CartDT); Store_RPT.DataBind(); //------发票绑定 DataTable invoceDT = new DataTable();//orderBll.SelInvoByUser(buser.GetLogin().UserID); if (invoceDT.Rows.Count > 0) { Invoice_RPT.DataSource = invoceDT; Invoice_RPT.DataBind(); } else { Invoice_RPT.Visible = false; } //------积分抵扣 if (SiteConfig.ShopConfig.PointRatiot > 0 && SiteConfig.ShopConfig.PointRatiot < 100 && SiteConfig.ShopConfig.PointRate > 0) { point_body.Visible = true; M_UserInfo usermod = buser.GetLogin(); Point_L.Text = usermod.UserExp.ToString(); int usepoint = (int)(allmoney * (SiteConfig.ShopConfig.PointRatiot * 0.01) / SiteConfig.ShopConfig.PointRate); function.Script(this, "SumByPoint(" + usepoint + ");"); PointRate_Hid.Value = SiteConfig.ShopConfig.PointRate.ToString(); } else { point_tips.Visible = true; } //------用户有哪些优惠券 DataTable avdt = avBll.U_Sel(mu.UserID, -100, 1); if (avdt.Rows.Count > 0) { arrive_div.Style.Add("display", "block"); arrive_data_div.Visible = true; avdt.Columns.Add("enable", typeof(int)); avdt.Columns.Add("err", typeof(string)); for (int i = 0; i < avdt.Rows.Count; i++) { DataRow dr = avdt.Rows[i]; double money = allmoney; string err = ""; dr["enable"] = avBll.U_CheckArrive(new M_Arrive().GetModelFromReader(dr), mu.UserID, ref money, ref err) ? 1 : 0; dr["err"] = err; } avdt.DefaultView.RowFilter = "enable='1'"; //function.WriteErrMsg(avdt.DefaultView.ToTable().Rows.Count.ToString()); Arrive_Active_RPT.DataSource = avdt.DefaultView.ToTable(); Arrive_Active_RPT.DataBind(); avdt.DefaultView.RowFilter = "enable='0'"; Arrive_Disable_RPT.DataSource = avdt.DefaultView.ToTable(); Arrive_Disable_RPT.DataBind(); } else { arrive_empty_div.Visible = true; } }
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)); }
public void MyBind() { StringWriter sw = new StringWriter(); M_UserInfo mu = buser.GetLogin(false); CartDT = cartBll.SelByCartID(B_Cart.GetCartID(), mu.UserID, ProClass, ids); if (CartDT.Rows.Count < 1) { function.WriteErrMsg("你尚未选择商品,<a href='/User/Order/OrderList'>查看我的订单</a>"); } #region 旅游,酒店等不需要检测地址栏 switch (DataConvert.CLng(CartDT.Rows[0]["ProClass"])) { case (int)M_Product.ClassType.LY: { userli.Visible = true; M_Cart_Travel model = JsonConvert.DeserializeObject <M_Cart_Travel>(CartDT.Rows[0]["Additional"].ToString()); model.Guest.AddRange(model.Contract); UserRPT.DataSource = model.Guest; UserRPT.DataBind(); } break; case (int)M_Product.ClassType.JD: { userli.Visible = true; M_Cart_Hotel model = JsonConvert.DeserializeObject <M_Cart_Hotel>(CartDT.Rows[0]["Additional"].ToString()); model.Guest.AddRange(model.Contract); UserRPT.DataSource = model.Guest; UserRPT.DataBind(); } break; default: //------地址 break; } #endregion //------核算费用 allmoney = UpdateCartAllMoney(CartDT); //------费用统计 itemnum_span.InnerText = CartDT.Rows.Count.ToString(); totalmoney_span1.InnerText = allmoney.ToString("f2"); //------店铺 Store_RPT.DataSource = orderCom.SelStoreDT(CartDT); Store_RPT.DataBind(); //------发票绑定 Server.Execute("/Cart/Comp/Invoice.aspx", sw); Invoice_Lit.Text = sw.ToString(); sw = new StringWriter(); //------积分抵扣 { int usepoint = Point_CanBeUse(allmoney); if (usepoint > 0) { point_body.Visible = true; Point_L.Text = mu.UserExp.ToString(); //int usepoint = (int)(allmoney * (SiteConfig.ShopConfig.PointRatiot * 0.01)); function.Script(this, "SumByPoint(" + usepoint + ");"); PointRate_Hid.Value = SiteConfig.ShopConfig.PointRate.ToString("F2"); } else { point_tips.Visible = true; } } //------优惠券 Server.Execute("/Cart/Comp/ArriveList.aspx?allmoney=" + allmoney + "&ids=" + ids, sw); Arrive_Lit.Text = sw.ToString(); }