コード例 #1
0
        /// <summary>
        /// 添加到购物车-首页添加
        /// </summary>
        /// <param name="cvm"></param>
        /// <returns></returns>
        public ActionResult AddWithDefaultProduct(int productId)
        {
            try
            {
                using (LsBuyEntities db = new LsBuyEntities())
                {
                    string defaultColor = "red", defaultImage = "img1", defaultText = "";
                    //获取当前登录用户信息
                    User            user       = db.Users.Where(t => t.UserName == User.Identity.Name).FirstOrDefault();
                    CustomerProduct cutomerPro =
                        db.CustomerProducts.Where(t =>
                                                  t.Color == defaultColor &&
                                                  t.Text == defaultText &&
                                                  t.Image == defaultImage &&
                                                  t.ProductId == productId).FirstOrDefault();
                    if (cutomerPro == null)
                    {
                        CustomerProduct customerPro = new CustomerProduct
                        {
                            Color     = defaultColor,
                            Image     = defaultImage,
                            Text      = defaultText,
                            ProductId = productId,
                        };
                        //添加定制产品
                        db.CustomerProducts.Add(customerPro);
                        db.SaveChanges();
                        //查询定制产品
                        cutomerPro =
                            db.CustomerProducts.Where(t =>
                                                      t.Color == defaultColor &&
                                                      t.Text == defaultText &&
                                                      t.Image == defaultImage &&
                                                      t.ProductId == productId).FirstOrDefault();
                    }

                    //加入购物车
                    ShoppingChart shoppingChart = new ShoppingChart
                    {
                        ProductId   = cutomerPro.Id,
                        UserId      = user.Id,
                        CreatedTime = DateTime.Now
                    };
                    //加入购物车
                    db.ShoppingCharts.Add(shoppingChart);
                    //保存到数据库
                    db.SaveChanges();

                    return(Redirect("AddSuccess"));
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #2
0
        public ActionResult Create([Bind(Include = "Id,UserName,Password,Email,UserType,Phone,Sex")] User user)
        {
            if (ModelState.IsValid)
            {
                //默认密码 123456
                user.Password = "******";
                db.Users.Add(user);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(user));
        }
コード例 #3
0
        public ActionResult Create([Bind(Include = "Id,ProductName,Price,UserId,CreatedTime,UpdatedTime,ModelNumber,Description,ImageUrl")] Product product)
        {
            if (ModelState.IsValid)
            {
                product.ImageUrl    = SaveFile();
                product.CreatedTime = DateTime.Now;
                product.UpdatedTime = DateTime.Now;
                product.UserId      = User.Identity.Name;
                db.Products.Add(product);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(product));
        }
コード例 #4
0
ファイル: HomeController.cs プロジェクト: yhu0304/chairbuy
 /// <summary>
 /// 注册页面
 /// </summary>
 /// <returns></returns>
 public ActionResult Register(RegistVModel registVModel)
 {
     if (ModelState.IsValid)
     {
         using (LsBuyEntities db = new LsBuyEntities())
         {
             if (db.Users.Where(t => t.Email == registVModel.Email).Count() > 0)
             {
                 ModelState.AddModelError("Email", "邮箱已注册!");
                 return(View("Regist", registVModel));
             }
             else
             {
                 Db.User user = new Db.User
                 {
                     Email    = registVModel.Email,
                     Phone    = registVModel.Phone,
                     UserType = 0,
                     Password = registVModel.Password,
                     UserName = registVModel.Email,
                     Sex      = registVModel.Sex
                 };
                 db.Users.Add(user);
                 db.SaveChanges();
             }
             return(Redirect("Index"));
         }
     }
     else
     {
         return(View("Regist", registVModel));
     }
 }
コード例 #5
0
 /// <summary>
 /// 添加收货地址
 /// </summary>
 /// <param name="vModel"></param>
 /// <returns></returns>
 public ActionResult ConfirmAddAddress(AddressVModel vModel)
 {
     if (ModelState.IsValid)
     {
         using (LsBuyEntities db = new LsBuyEntities())
         {
             User    user    = db.Users.Where(t => t.UserName == User.Identity.Name).FirstOrDefault();
             Address address = new Address()
             {
                 Content     = vModel.Content,
                 Phone       = vModel.Phone,
                 Receiver    = vModel.Reveiver,
                 UserId      = user.Id,
                 CreatedTime = DateTime.Now,
                 UpdatedTime = DateTime.Now
             };
             db.Addresses.Add(address);
             db.SaveChanges();
         }
         return(Redirect("Addresses"));
     }
     else
     {
         return(View("AddAddress", vModel));
     }
 }
コード例 #6
0
 /// <summary>
 /// 删除
 /// </summary>
 /// <param name="id"></param>
 /// <returns></returns>
 public ActionResult Remove(int id)
 {
     using (LsBuyEntities db = new LsBuyEntities())
     {
         var shopchart = db.ShoppingCharts.Where(t => t.Id == id).FirstOrDefault();
         db.ShoppingCharts.Remove(shopchart);
         db.SaveChanges();
         return(RedirectToAction("ShoppingCharts", "PersonalCenter"));
     }
 }
コード例 #7
0
 /// <summary>
 /// 删除收货地址
 /// </summary>
 /// <param name="id">收货地址Id</param>
 /// <returns></returns>
 public ActionResult DeleteAddress(int id)
 {
     using (LsBuyEntities db = new LsBuyEntities())
     {
         var address = db.Addresses.Where(t => t.Id == id).FirstOrDefault();
         db.Addresses.Remove(address);
         db.SaveChanges();
     }
     return(Redirect("Addresses"));
 }
コード例 #8
0
        /// <summary>
        /// 提交订单
        /// </summary>
        /// <returns></returns>
        public ActionResult ConfirmOrder(int[] id, string AddressId)
        {
            if (id == null || id.Length < 1 || string.IsNullOrEmpty(AddressId))
            {
                using (LsBuyEntities db = new LsBuyEntities())
                {
                    User user = db.Users.Where(t => t.UserName == User.Identity.Name).FirstOrDefault();
                    List <ShoppingChartVModel> spcharts  = db.Database.SqlQuery <ShoppingChartVModel>(@"select t1.Id,t1.ProductId CustomerProductId,t2.Image,
t2.Color,t2.Text,t2.ProductId,
t3.Price,t3.ProductName,t3.ModelNumber,t3.ImageUrl
from ShoppingCharts t1
left join CustomerProducts t2 on t1.ProductId= t2.Id
left join Products t3 on t2.ProductId = t3.Id
where t1.UserId = @userId", new SqlParameter("userId", user.Id)).ToList();
                    List <AddressVModel>       addresses = db.Database.SqlQuery <AddressVModel>(@"select * from Addresses where UserId=@userId", new SqlParameter("userId", user.Id)).ToList();
                    ModelState.AddModelError("ValidMessage", "请选择收货地址或商品!");
                    return(View("ShoppingCharts", new ShoppingChartsVModel
                    {
                        Addresses = addresses,
                        ShoppingCharts = spcharts
                    }));
                }
            }
            using (LsBuyEntities db = new LsBuyEntities())
            {
                User user = db.Users.Where(t => t.UserName == User.Identity.Name).FirstOrDefault();
                #region 生成订单
                string orderNo = DateTime.Now.ToString("yyyyMMddHHmmss") + user.Id.ToString().PadLeft(5, '0');
                Order  order   = new Order
                {
                    AddressId   = AddressId,
                    OrderStatus = 0,
                    UserId      = user.Id,
                    CreatedTime = DateTime.Now,
                    OrderNo     = orderNo
                };
                db.Orders.Add(order);
                //订单详情
                db.ShoppingCharts.Where(t => id.Contains(t.Id)).ToList()
                .ForEach(t =>
                {
                    OrderDetail detail = new OrderDetail
                    {
                        OrderNo   = orderNo,
                        ProductId = t.ProductId.ToString()
                    };
                    db.OrderDetails.Add(detail);
                });
                //保存
                db.SaveChanges();
                #endregion
                return(RedirectToAction("ConfirmOrderSuccess"));
            }
        }
コード例 #9
0
 /// <summary>
 /// 添加收货地址
 /// </summary>
 /// <param name="vModel"></param>
 /// <returns></returns>
 public ActionResult ConfirmModifyAddress(AddressVModel vModel)
 {
     if (ModelState.IsValid)
     {
         using (LsBuyEntities db = new LsBuyEntities())
         {
             Address address = db.Addresses.Where(t => t.Id == vModel.Id).FirstOrDefault();
             address.Content     = vModel.Content;
             address.Phone       = vModel.Phone;
             address.Receiver    = vModel.Reveiver;
             address.UpdatedTime = DateTime.Now;
             db.SaveChanges();
         }
         return(Redirect("Addresses"));
     }
     else
     {
         return(View("ModifyAddress", vModel));
     }
 }