protected void Page_Load(object sender, EventArgs e) { M_UserInfo mu = GetLogin(); if (!IsPostBack) { ProModel model = new ProModel() { ProID = DataConvert.CLng(Request["ID"]), Pronum = DataConvert.CLng(Request["Pronum"]) }; model.Pronum = model.Pronum < 1 ? 1 : model.Pronum; if (model.ProID > 0)//将商品加入购物车 { M_Product proMod = proBll.GetproductByid(model.ProID); OrderCommon.ProductCheck(proMod); //-----------------检测完成加入购物车 M_Cart cartMod = new M_Cart(); cartMod.Cartid = CartCookID; cartMod.StoreID = proMod.UserShopID; cartMod.ProID = model.ProID; cartMod.Pronum = model.Pronum; cartMod.userid = mu.UserID; cartMod.Username = mu.UserName; cartMod.Getip = EnviorHelper.GetUserIP(); cartMod.Addtime = DateTime.Now; cartMod.FarePrice = proMod.LinPrice.ToString(); cartMod.Proname = proMod.Proname; int id = cartBll.AddModel(cartMod); ImportExtField(id, Request.Form["ext_hid"]);//模型字段 Response.Redirect(Request.Url.AbsolutePath + "?ProClass=" + proMod.ProClass); } MyBind(); } }
/// <summary> /// 购物车中有则增加数量,否则添加记录 /// </summary> public int AddModel(M_Cart model) { if (string.IsNullOrEmpty(model.Cartid) && model.userid < 1) { return(0); } List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter("cartid", model.Cartid) }; string where = "ProID=" + model.ProID; if (model.userid > 0) { where += " AND UserID=" + model.userid; } else { where += " AND CartID=@cartid"; } DataTable dt = DBCenter.SelWithField("ZL_Cart", "ID,Pronum", where, "", sp); if (dt.Rows.Count > 0) { int id = Convert.ToInt32(dt.Rows[0]["ID"]); DBCenter.UpdateSQL(TbName, "Pronum=" + (Convert.ToInt32(dt.Rows[0]["Pronum"]) + model.Pronum), "ID=" + id); return(id); } else { return(insert(model)); } }
//将购买信息,存入购物车 private int AddCart(ProModel pro, M_UserInfo mu, string addition) { int proid = pro.ProID; int pronum = pro.Pronum; if (proid < 1 || pronum < 1) { function.WriteErrMsg("商品ID或数量异常"); } M_Cart cartMod = new M_Cart(); cartMod.Cartid = CartCookID; cartMod.StoreID = pro.StoreID; cartMod.ProID = proid; cartMod.Pronum = pronum; cartMod.userid = mu.UserID; cartMod.Username = mu.UserName; cartMod.Getip = EnviorHelper.GetUserIP(); cartMod.Addtime = DateTime.Now; cartMod.Additional = addition; cartMod.code = pro.code; cartMod.Proname = pro.ProName; cartMod.ID = cartBll.insert(cartMod); return(cartMod.ID); }
//根据传参将商品加入购物车后跳转(支持按商品ID,套装ID购买) private void AddToCart(M_UserInfo mu, M_Product proMod, int pronum) { if (pronum < 1) { pronum = 1; } if (proMod == null || proMod.ID < 1) { } //商品不存在 if (proMod.ProClass == (int)M_Product.ClassType.IDC) { Response.Redirect("/Cart/FillIDCInfo?proid=" + proMod.ID); } OrderCommon.ProductCheck(proMod); //-----------------检测完成加入购物车 M_Cart cartMod = new M_Cart(); cartMod.Cartid = CartCookID; cartMod.StoreID = proMod.UserShopID; cartMod.ProID = proMod.ID; cartMod.Pronum = pronum; cartMod.userid = mu.UserID; cartMod.Username = mu.UserName; cartMod.FarePrice = proMod.LinPrice.ToString(); cartMod.ProAttr = GetParam("attr"); cartMod.Proname = proMod.Proname; int id = cartBll.AddModel(cartMod); }
protected void Page_Load(object sender, EventArgs e) { M_UserInfo mu = GetLogin(); if (!IsPostBack) { ProModel model = new ProModel() { ProID = DataConvert.CLng(Request["ID"]), Pronum = DataConvert.CLng(Request["Pronum"]) }; model.Pronum = model.Pronum < 1 ? 1 : model.Pronum; if (model.ProID > 0)//将商品加入购物车 { M_Product proMod = proBll.GetproductByid(model.ProID); if (proMod == null || proMod.ID < 1) { function.WriteErrMsg("商品不存在"); } if (proMod.ProClass == (int)M_Product.ClassType.IDC) { Response.Redirect("/Cart/FillIDCInfo.aspx?proid=" + proMod.ID); } OrderCommon.ProductCheck(proMod); #region 特选商品逻辑 [delete] if (proMod.Largess == 1) { B_User_BindPro ubpBll = new B_User_BindPro(); M_User_BindPro ubpMod = null; if (mu.IsNull) { return; } ubpMod = ubpBll.SelModelByUid(mu.UserID); if (ubpMod == null || !ubpMod.ProIDS.Contains("," + proMod.ID + ",")) { Response.Redirect(Request.Url.AbsolutePath + "?ProClass=" + proMod.ProClass); return; } } #endregion //-----------------检测完成加入购物车 M_Cart cartMod = new M_Cart(); cartMod.Cartid = CartCookID; cartMod.StoreID = proMod.UserShopID; cartMod.ProID = model.ProID; cartMod.Pronum = model.Pronum; cartMod.userid = mu.UserID; cartMod.Username = mu.UserName; cartMod.FarePrice = proMod.LinPrice.ToString(); cartMod.ProAttr = DataConvert.CStr(Request["attr"]); cartMod.Proname = proMod.Proname; int id = cartBll.AddModel(cartMod); //ImportExtField(id, Request.Form["ext_hid"]);//模型字段 Response.Redirect(Request.Url.AbsolutePath + "?ProClass=" + proMod.ProClass); } MyBind(); } }
/*----------------------------------------------------------------------------------------------------*/ #region 重算商品金额 //更新购物车中的AllMoney(实际购买总价),便于后期查看详情 private double UpdateCartAllMoney(DataTable dt) { //M_UserInfo mu = SnsHelper.GetLogin(); double allmoney = 0; for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; M_Cart cartMod = new M_Cart().GetModelFromReader(dr); //M_Product proMod = proBll.GetproductByid(Convert.ToInt32(dr["Proid"])); //--附加币值计价 //if (orderCom.HasPrice(proMod.LinPrice_Json)) //{ // M_LinPrice priceMod = JsonConvert.DeserializeObject<M_LinPrice>(proMod.LinPrice_Json); // priceMod.Purse = priceMod.Purse * cartMod.Pronum; // priceMod.Sicon = priceMod.Sicon * cartMod.Pronum; // priceMod.Point = priceMod.Point * cartMod.Pronum; // dr["AllMoney_Json"] = JsonConvert.SerializeObject(priceMod); // cartMod.AllMoney_Json = DataConvert.CStr(dr["AllMoney_Json"]); //} //根据商品价格类型,看使用 零售|批发|会员|会员组价格 //多区域价格 //if (string.IsNullOrEmpty(Region)) //{ // Region = buser.GetRegion(mu.UserID); //} //double price = regionBll.GetRegionPrice(proMod.ID, proMod.LinPrice, Region, mu.GroupID); ////如果多区域价格未匹配,则匹配会员价 //if (price == proMod.LinPrice) { price = proBll.P_GetByUserType(proMod, mu); } //double price = proBll.P_GetByUserType(proMod, mu); //--多价格编号,则使用多价格编号的价钱,ProName(已在购物车页面更新) //double price =proBll.GetPriceByCode(dr["code"], proMod.Wholesalesinfo, ref price); //cartMod.AllMoney = price * cartMod.Pronum; //cartMod.AllIntegral = cartMod.AllMoney; //cartMod.FarePrice = price.ToString("F2"); //----检查有无价格方面的促销活动,如果有,检免多少金额 //{ // W_Filter filter = new W_Filter(); // filter.cartMod = cartMod; // filter.TypeFilter = "money"; // ptBll.WhereLogical(filter); // cartMod.AllMoney = cartMod.AllMoney - filter.DiscountMoney; //} //----计算折扣 dr["AllMoney"] = cartMod.AllMoney; dr["AllIntegral"] = cartMod.AllIntegral; //if (proMod.Recommend > 0) //{ // dr["AllMoney"] = (cartMod.AllIntegral - (cartMod.AllIntegral * ((double)proMod.Recommend / 100))); // cartMod.AllMoney = Convert.ToDouble(dr["AllMoney"]); //} //cartBll.UpdateByID(cartMod); allmoney += cartMod.AllMoney; } return(allmoney); }
//根据传参将商品加入购物车后跳转(支持按商品ID,套装ID购买) private void AddToCart(M_UserInfo mu, M_Product proMod, int pronum) { if (pronum < 1) { pronum = 1; } if (proMod == null || proMod.ID < 1) { return; } //商品不存在 DataTable dt = DBCenter.Sel(proMod.TableName, "ID=" + proMod.ItemID); int tlpID = DataConvert.CLng(dt.Rows[0]["TlpID"]); //if (tlpID < 1) { function.WriteErrMsg("商品未绑定设计模板"); } //复制一份作为用户新建的记录 B_Logo_Design desBll = new B_Logo_Design(); M_Logo_Design desMod = desBll.SelReturnModel(tlpID); if (desMod == null) { desMod = new M_Logo_Design(); } M_Cart_Addition addMod = new M_Cart_Addition(); //if (desMod == null) { function.WriteErrMsg("商品未绑定模板"); } desMod.ID = 0; desMod.ZType = 0; desMod.CDate = DateTime.Now; desMod.UserID = mu.UserID; desMod.UserName = mu.UserName; //不经设计直接加入物车,则获取商品预览图片 string imgUrl = function.GetImgUrl(proMod.Thumbnails); //if (File.Exists(function.VToP(imgUrl))) //{ // desMod.PreviewImg = "data:image/png;base64," + ImgToBase64(imgUrl); //} desMod.PreviewImg = imgUrl; desMod.ID = desBll.Insert(desMod); //-----------------检测完成加入购物车 M_Cart cartMod = new M_Cart(); cartMod.Cartid = CartCookID; cartMod.StoreID = proMod.UserShopID; cartMod.ProID = proMod.ID; cartMod.Pronum = pronum; cartMod.userid = mu.UserID; cartMod.Username = mu.UserName; cartMod.FarePrice = proMod.LinPrice.ToString(); cartMod.AllMoney = (proMod.LinPrice * cartMod.Pronum); cartMod.ProAttr = desMod.ID.ToString(); cartMod.Proname = proMod.Proname; cartMod.Additional = JsonConvert.SerializeObject(addMod); int id = cartBll.insert(cartMod); }
public M_Cart NewCart(M_Product proMod) { M_Cart cartMod = new M_Cart(); cartMod.Addtime = DateTime.Now; cartMod.StoreID = proMod.UserShopID; cartMod.FarePrice = proMod.LinPrice.ToString(); cartMod.Proname = proMod.Proname; cartMod.ProID = proMod.ID; return(cartMod); }
//更新购物车中的AllMoney(实际购买总价),便于后期查看详情 private double UpdateCartAllMoney(DataTable dt) { M_UserInfo mu = buser.GetLogin(); double allmoney = 0; for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; M_Cart cartMod = new M_Cart().GetModelFromReader(dr); M_Product proMod = proBll.GetproductByid(Convert.ToInt32(dr["Proid"])); //根据商品价格类型,看使用 零售|批发|会员|会员组价格 //多区域价格 //if (string.IsNullOrEmpty(Region)) //{ // Region = buser.GetRegion(mu.UserID); //} //double price = regionBll.GetRegionPrice(proMod.ID, proMod.LinPrice, Region, mu.GroupID); ////如果多区域价格未匹配,则匹配会员价 //if (price == proMod.LinPrice) { price = proBll.P_GetByUserType(proMod, mu); } double price = proBll.P_GetByUserType(proMod, mu); //--多价格编号,则使用多价格编号的价钱,ProName(已在购物车页面更新) //double price =proBll.GetPriceByCode(dr["code"], proMod.Wholesalesinfo, ref price); cartMod.AllMoney_Init = cartMod.AllMoney = price * cartMod.Pronum; cartMod.FarePrice = price.ToString("F2"); cartMod.Shijia = price; //----检查有无价格方面的促销活动,如果有,检免多少金额 { W_Filter filter = new W_Filter(); filter.cartMod = cartMod; filter.TypeFilter = "money"; ptBll.WhereLogical(filter); cartMod.AllMoney_Arrive += filter.DiscountMoney; cartMod.ArriveRemark += "促销:" + filter.DiscountMoney.ToString("F2"); } //----计算折扣 cartMod.AllMoney = cartMod.AllMoney_Init - cartMod.AllMoney_Arrive; if (cartMod.AllMoney < 0) { cartMod.AllMoney = 0; } //------------------------------ dr["AllMoney"] = cartMod.AllMoney; cartBll.UpdateByID(cartMod); allmoney += cartMod.AllMoney; } //缓存数据,提交时验证 VerifyDT = CartDT.DefaultView.ToTable(false, verifyFields); return(allmoney); }
//更新购物车中的AllMoney(实际购买总价),便于后期查看详情 private double UpdateCartAllMoney(DataTable dt) { M_UserInfo mu = buser.GetLogin(); double allmoney = 0; for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; M_Cart cartMod = cartBll.GetCartByid(Convert.ToInt32(dr["ID"])); M_Product proMod = proBll.GetproductByid(Convert.ToInt32(dr["Proid"])); //--附加币值计价 //if (orderCom.HasPrice(proMod.LinPrice_Json)) //{ // M_LinPrice priceMod = JsonConvert.DeserializeObject<M_LinPrice>(proMod.LinPrice_Json); // priceMod.Purse = priceMod.Purse * cartMod.Pronum; // priceMod.Sicon = priceMod.Sicon * cartMod.Pronum; // priceMod.Point = priceMod.Point * cartMod.Pronum; // dr["AllMoney_Json"] = JsonConvert.SerializeObject(priceMod); // cartMod.AllMoney_Json = DataConvert.CStr(dr["AllMoney_Json"]); //} //根据商品价格类型,看使用 零售|批发|会员|会员组价格 //多区域价格 if (string.IsNullOrEmpty(Region)) { Region = buser.GetRegion(mu.UserID); } double price = regionBll.GetRegionPrice(proMod.ID, proMod.LinPrice, Region, mu.GroupID); //如果多区域价格未匹配,则匹配会员价 if (price == proMod.LinPrice) { price = proBll.P_GetByUserType(proMod, mu); } //--多价格编号,则使用多价格编号的价钱,ProName(已在购物车页面更新) //double price =proBll.GetPriceByCode(dr["code"], proMod.Wholesalesinfo, ref price); cartMod.AllMoney = price * cartMod.Pronum; cartMod.AllIntegral = cartMod.AllMoney; //----计算折扣 dr["AllMoney"] = cartMod.AllMoney; dr["AllIntegral"] = cartMod.AllIntegral; if (proMod.Recommend > 0) { dr["AllMoney"] = (cartMod.AllIntegral - (cartMod.AllIntegral * ((double)proMod.Recommend / 100))); cartMod.AllMoney = Convert.ToDouble(dr["AllMoney"]); } cartBll.UpdateByID(cartMod); allmoney += cartMod.AllMoney; } return(allmoney); }
private M_Cart NewCart(M_UserInfo mu, M_Product proMod) { M_Cart cart = new M_Cart(); cart.Cartid = CartCookID; cart.StoreID = proMod.UserShopID; cart.ProID = proMod.ID; cart.Pronum = 1; cart.userid = mu.UserID; cart.Username = mu.UserName; cart.FarePrice = proMod.LinPrice.ToString(); cart.AllMoney = proMod.LinPrice; cart.Proname = proMod.Proname; return(cart); }
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) + ");"); } }
//根据传参将商品加入购物车后跳转(支持按商品ID,套装ID购买) private void AddToCart(M_UserInfo mu, M_Product proMod, int pronum) { if (pronum < 1) { pronum = 1; } if (proMod == null || proMod.ID < 1) { return; } //商品不存在 if (proMod.ProClass == (int)M_Product.ClassType.IDC) { Response.Redirect("/Cart/FillIDCInfo.aspx?proid=" + proMod.ID); } OrderCommon.ProductCheck(proMod); #region 特选商品逻辑 [delete] if (proMod.Largess == 1) { B_User_BindPro ubpBll = new B_User_BindPro(); M_User_BindPro ubpMod = null; if (mu.IsNull) { return; } ubpMod = ubpBll.SelModelByUid(mu.UserID); if (ubpMod == null || !ubpMod.ProIDS.Contains("," + proMod.ID + ",")) { Response.Redirect(Request.Url.AbsolutePath + "?ProClass=" + proMod.ProClass); return; } } #endregion //-----------------检测完成加入购物车 M_Cart cartMod = new M_Cart(); cartMod.Cartid = CartCookID; cartMod.StoreID = proMod.UserShopID; cartMod.ProID = proMod.ID; cartMod.Pronum = pronum; cartMod.userid = mu.UserID; cartMod.Username = mu.UserName; cartMod.FarePrice = proMod.LinPrice.ToString(); cartMod.ProAttr = DataConvert.CStr(Request["attr"]); cartMod.Proname = proMod.Proname; int id = cartBll.AddModel(cartMod); }
/*----------------------------------------------------------------------------------------------------*/ #region 重算商品金额 //更新购物车中的AllMoney(实际购买总价),便于后期查看详情 private double UpdateCartAllMoney(DataTable dt) { M_UserInfo mu = buser.GetLogin(); double allmoney = 0; for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; M_Cart cartMod = new M_Cart().GetModelFromReader(dr); M_Product proMod = proBll.GetproductByid(Convert.ToInt32(dr["Proid"])); //if (price == proMod.LinPrice) { price = proBll.P_GetByUserType(proMod, mu); } //double price = proBll.P_GetByUserType(proMod, mu); double price = proMod.LinPrice; //--多价格编号,则使用多价格编号的价钱,ProName(已在购物车页面更新) //double price =proBll.GetPriceByCode(dr["code"], proMod.Wholesalesinfo, ref price); cartMod.AllMoney = price * cartMod.Pronum; cartMod.AllIntegral = cartMod.AllMoney; cartMod.FarePrice = price.ToString("F2"); //----检查有无价格方面的促销活动,如果有,检免多少金额 { W_Filter filter = new W_Filter(); filter.cartMod = cartMod; filter.TypeFilter = "money"; ptBll.WhereLogical(filter); cartMod.AllMoney = cartMod.AllMoney - filter.DiscountMoney; } //----计算折扣 dr["AllMoney"] = cartMod.AllMoney; dr["AllIntegral"] = cartMod.AllIntegral; //if (proMod.Recommend > 0) //{ // dr["AllMoney"] = (cartMod.AllIntegral - (cartMod.AllIntegral * ((double)proMod.Recommend / 100))); // cartMod.AllMoney = Convert.ToDouble(dr["AllMoney"]); //} cartBll.UpdateByID(cartMod); allmoney += cartMod.AllMoney; } return(allmoney); }
/// <summary> /// 购物车中有则增加数量,否则添加记录 /// </summary> public int AddModel(M_Cart model) { if (string.IsNullOrEmpty(model.Getip)) { model.Getip = IPScaner.GetUserIP(); } SqlParameter[] sp = new SqlParameter[] { new SqlParameter("cartid", model.Cartid) }; string sql = "Select * From ZL_Cart Where StoreID=" + model.StoreID + " And CartID=@cartid And ProID=" + model.ProID; DataTable dt = SqlHelper.ExecuteTable(CommandType.Text, sql, sp); if (dt.Rows.Count > 0) { int id = Convert.ToInt32(dt.Rows[0]["ID"]); string updatesql = "Update ZL_Cart Set Pronum=Pronum+" + model.Pronum + " Where ID=" + id; SqlHelper.ExecuteSql(updatesql); return(id); } else { return(insert(model)); } }
private void CreateCart(M_Logo_Design desMod) { M_UserInfo mu = SnsHelper.GetLogin(); M_Product mainProMod = proBll.GetproductByid(ProID); DataTable proInfo = DBCenter.Sel(mainProMod.TableName, "ID=" + mainProMod.ItemID); //-----购物车记录(按收前台各种传值) M_Cart cartMod = NewCart(mu, mainProMod); cartMod.ProAttr = desMod.ID.ToString();//存储设计好的信息ID M_Cart_Addition addMod = new M_Cart_Addition(); addMod.flash = DataConvert.CLng(Request.Form["Flash_DP"]); addMod.outdoor = DataConvert.CLng(Request.Form["OutdoorSign_DP"]); addMod.backing = DataConvert.CLng(Request.Form["Request"]); addMod.text = Request.QueryString["texts"]; addMod.size = proInfo.Rows[0]["size"].ToString(); cartMod.Additional = JsonConvert.SerializeObject(addMod); if (addMod.flash > 0) { M_Product proMod = proBll.GetproductByid(addMod.flash); cartMod.AllMoney += proMod.LinPrice; } if (addMod.outdoor > 0) { M_Product proMod = proBll.GetproductByid(addMod.outdoor); cartMod.AllMoney += proMod.LinPrice; } if (addMod.backing > 0) { M_Product proMod = proBll.GetproductByid(addMod.backing); cartMod.AllMoney += proMod.LinPrice; } cartMod.FarePrice = cartMod.AllMoney.ToString("F2"); cartBll.Add(cartMod); Response.Redirect("/Cart/Cart.aspx?ProClass=1"); }
private void MyBind() { int guestnum = 0, totalnum = 0; if (!string.IsNullOrEmpty(ids)) { M_Cart cartMod = cartBll.SelReturnModel(DataConvert.CLng(ids.Split(',')[0])); M_Cart_Travel traveMod = JsonConvert.DeserializeObject <M_Cart_Travel>(cartMod.Additional); Pros = JsonConvert.SerializeObject(traveMod.ProList); Guest_Hid2.Value = JsonConvert.SerializeObject(traveMod.Guest); Contract_Hid2.Value = JsonConvert.SerializeObject(traveMod.Contract); guestnum = traveMod.Guest.Count; } //绑定显示商品 if (!string.IsNullOrEmpty(Pros)) { JArray proArr = (JArray)JsonConvert.DeserializeObject(Pros); DataTable proDT = CreateProDT();//仅用于展示,不参与逻辑 double proAllMoney = 0; for (int i = 0; i < proArr.Count; i++) { DataRow proDR = proDT.NewRow(); M_Product proMod = proBll.GetproductByid(Convert.ToInt32(proArr[i]["ProID"].ToString())); switch ((M_Product.ClassType)proMod.ProClass) { case M_Product.ClassType.LY: case M_Product.ClassType.JD: break; default: function.WriteErrMsg("[" + proMod.Proname + "]商品类型不正确"); break; } if (proMod.ID > 0) { proDR["ID"] = proMod.ID; proDR["ProName"] = proMod.Proname; proDR["Pronum"] = proArr[i]["Pronum"].ToString(); //----如果传递了编号,则读取多价格信息 double price = proMod.LinPrice; DataRow priceDR = proBll.GetPriceByCode(proArr[i]["code"], proMod.Wholesalesinfo, ref price); proDR["Price"] = price; if (priceDR != null) { proDR["ProName"] += "(" + priceDR["Proname"] + ")"; } //---- proDR["AllMoney"] = Convert.ToInt32(proDR["Pronum"]) * Convert.ToDouble(proDR["Price"]); proDR["GoDate"] = DataConvert.CDate(proArr[i]["GoDate"]); proDR["Remind"] = HttpUtility.UrlDecode(proArr[i]["Remind"].ToString()); proDT.Rows.Add(proDR); proAllMoney += Convert.ToDouble(proDR["AllMoney"]); totalnum += Convert.ToInt32(proDR["Pronum"]); } } AllMoney_sp.InnerText = proAllMoney.ToString("0.00"); ProList_RPT.DataSource = proDT; ProList_RPT.DataBind(); function.Script(this, "AddGuests(" + (string.IsNullOrEmpty(ids) ? totalnum : guestnum) + ");"); } }
public bool Update(M_Cart model) { return(DBCenter.UpdateByID(model, model.ID)); }
public int insert(M_Cart model) { return(DBCenter.Insert(model)); }
public static string GetPriceStr(M_Cart model) { return(GetPriceStr(model.AllMoney, model.AllMoney_Json)); }
public int insert(M_Cart model) { return(Sql.insertID(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model))); }
public bool Add(M_Cart model) { insert(model); return(true); }
public bool UpdateByID(M_Cart model) { return(Sql.UpdateByIDs(TbName, PK, model.ID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters())); }
//购物车初始化 public W_Filter(DataRow dr) { cartMod = new M_Cart().GetModelFromReader(dr); }