Exemplo n.º 1
0
    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();
        }
    }
Exemplo n.º 2
0
        /// <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));
            }
        }
Exemplo n.º 3
0
        //将购买信息,存入购物车
        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);
        }
Exemplo n.º 4
0
        //根据传参将商品加入购物车后跳转(支持按商品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);
        }
Exemplo n.º 5
0
        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();
            }
        }
Exemplo n.º 6
0
        /*----------------------------------------------------------------------------------------------------*/
        #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);
        }
Exemplo n.º 7
0
        //根据传参将商品加入购物车后跳转(支持按商品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);
        }
Exemplo n.º 8
0
        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);
        }
Exemplo n.º 9
0
        //更新购物车中的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);
        }
Exemplo n.º 10
0
        //更新购物车中的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);
        }
Exemplo n.º 11
0
        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);
        }
Exemplo n.º 12
0
        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) + ");");
            }
        }
Exemplo n.º 13
0
 //根据传参将商品加入购物车后跳转(支持按商品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);
 }
Exemplo n.º 14
0
    /*----------------------------------------------------------------------------------------------------*/
    #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);
    }
Exemplo n.º 15
0
        /// <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));
            }
        }
Exemplo n.º 16
0
        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");
        }
Exemplo n.º 17
0
        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) + ");");
            }
        }
Exemplo n.º 18
0
 public bool Update(M_Cart model)
 {
     return(DBCenter.UpdateByID(model, model.ID));
 }
Exemplo n.º 19
0
 public int insert(M_Cart model)
 {
     return(DBCenter.Insert(model));
 }
Exemplo n.º 20
0
 public static string GetPriceStr(M_Cart model)
 {
     return(GetPriceStr(model.AllMoney, model.AllMoney_Json));
 }
Exemplo n.º 21
0
 public int insert(M_Cart model)
 {
     return(Sql.insertID(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
 }
Exemplo n.º 22
0
 public bool Add(M_Cart model)
 {
     insert(model);
     return(true);
 }
Exemplo n.º 23
0
 public bool UpdateByID(M_Cart model)
 {
     return(Sql.UpdateByIDs(TbName, PK, model.ID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters()));
 }
Exemplo n.º 24
0
 //购物车初始化
 public W_Filter(DataRow dr)
 {
     cartMod = new M_Cart().GetModelFromReader(dr);
 }