protected void ButtonConfirm_Click(object sender, EventArgs e) { //删除所有购物车明细,创建订单,创建订单明细。 //一个字符串对象,保存用户名 String userName = ((Site1)Page.Master).CurrentUserName; if (userName.Equals("")) return; if (TextBox1.Text.Trim().Length == 0 || TextBox2.Text.Trim().Length == 0 || TextBox3.Text.Trim().Length == 0 || TextBox4.Text.Trim().Length == 0) { Response.Write("<script>alert('请输入所有资料');</script>"); } String ReciverName = TextBox1.Text.Trim(); String Address = TextBox2.Text.Trim(); String Phone = TextBox3.Text.Trim(); String PostCode = TextBox4.Text.Trim(); using (LiBoClothesShopEntities context = new LiBoClothesShopEntities()) { OrderInfo myOrder = new OrderInfo(); myOrder.Consignee = ReciverName; myOrder.Address = Address; myOrder.Phone = Phone; myOrder.Zip = PostCode; myOrder.CreateTime = DateTime.Now; myOrder.PaymentTime = DateTime.Now; myOrder.SendTime = null; myOrder.ReceiptTime = null; myOrder.UserName = ((Site1)Page.Master).CurrentUserName; context.AddToOrderInfoes(myOrder); context.SaveChanges(); var cartDetails = from p in context.CartDetails where p.CartInfo.UserName == ((Site1)Page.Master).CurrentUserName select p; foreach (CartDetail cartDetail in cartDetails) { OrderDetail orderDetail = new OrderDetail() { OrderId = myOrder.ID, ClothesId = cartDetail.ClothId.Value, QTY = cartDetail.QTY, UnitPrice = cartDetail.Cloth.Price, SizeId = cartDetail.SizeId.Value, ColorId = cartDetail.ColorId.Value }; myOrder.OrderDetails.Add(orderDetail); context.CartDetails.DeleteObject(cartDetail); } context.SaveChanges(); //新建一个OrderInfo类,即创建一个订单 Response.Redirect(String.Format("~/ViewOrderDetail.aspx?ID={0}", myOrder.ID)); } }
protected void Button1_Click(object sender, EventArgs e) { using (LiBoClothesShopEntities context = new LiBoClothesShopEntities()) { //对于表格中的每一行 foreach (GridViewRow row in GridView1.Rows) { int id = Convert.ToInt32(row.Cells[0].Text); ColthColor color = (from p in context.ColthColors where p.Id == id select p).FirstOrDefault(); FileUpload upload = (FileUpload)row.FindControl("imgupload"); if (upload.HasFile) { color.PicFileName = upload.FileName; //将文件上传到Upload目录下 upload.SaveAs(Server.MapPath(".\\Upload\\" + color.PicFileName)); } } context.SaveChanges(); Response.Redirect("~/ViewCloth.aspx?id=" + ProductId); } }
protected void Button1_Click(object sender, EventArgs e) { String name = TextBox1.Text.Trim(); decimal price = Convert.ToDecimal(TextBox2.Text.Trim()); decimal marketprice = Convert.ToDecimal(TextBox3.Text.Trim()); int qty = Convert.ToInt32(TextBox4.Text.Trim()); int brandId = Convert.ToInt32(DropDownList1.SelectedValue); int genderId = Convert.ToInt32(DropDownList2.SelectedValue); int id; using (LiBoClothesShopEntities context = new LiBoClothesShopEntities()) { Cloth cloth = new Cloth(); cloth.Name = name; cloth.Price = price; cloth.OriginalPrice = marketprice; cloth.Qty = qty; cloth.BrandId = brandId; cloth.GenderId = genderId; context.AddToClothes(cloth); context.SaveChanges(); id = cloth.Id; foreach (ListItem item in CheckBoxList1.Items) { if (item.Selected) { ClothSzie size = new ClothSzie(); size.Cloth = cloth; size.SizeId = Convert.ToInt32(item.Value); context.AddToClothSzies(size); } } context.SaveChanges(); foreach (ListItem item in CheckBoxList2.Items) { if (item.Selected) { ColthColor color = new ColthColor(); color.Cloth = cloth; color.ColorId = Convert.ToInt32(item.Value); context.AddToColthColors(color); } } context.SaveChanges(); } Response.Redirect(String.Format("~/AddClothStep2.aspx?id={0}", id)); }
protected void AddToCartButton_Click(object sender, EventArgs e) { using (LiBoClothesShopEntities context = new LiBoClothesShopEntities()) { String CurrentUserName = ((Site1)Page.Master).CurrentUserName; int colorId = Convert.ToInt32(DropDownListColor.SelectedItem.Value); int sizeId = Convert.ToInt32(DropDownListSize.SelectedValue); //查找用户是否有购物车 var query = from cart in context.CartInfoes where cart.UserName == CurrentUserName select cart; CartInfo myCart; if (query.Count() == 0) { myCart = new CartInfo() { UserName = CurrentUserName, TotalPrice = 0 }; context.AddToCartInfoes(myCart); context.SaveChanges(); } else { myCart = query.FirstOrDefault(); } //查找是否已有该购物车明细 var query1 = from p in context.CartDetails where p.CartInfo.UserName == CurrentUserName && p.ColorId == colorId && p.SizeId == sizeId && p.ClothId == CurrentProduct.Id select p; CartDetail myCartDetail; if (query1.Count() == 0) { //如果没有,新增 myCartDetail = new CartDetail(); myCartDetail.CartId = myCart.ID; myCartDetail.SizeId = sizeId; myCartDetail.ColorId = colorId; myCartDetail.ClothId = CurrentProduct.Id; myCartDetail.QTY = 1; context.AddToCartDetails(myCartDetail); } else { //如果有,修改数量 myCartDetail = query1.First(); myCartDetail.QTY += 1; } //修改总价 myCart.TotalPrice += CurrentProduct.Price; context.SaveChanges(); } }
protected void Button2_Click(object sender, EventArgs e) { using (LiBoClothesShopEntities context = new LiBoClothesShopEntities()) { //查询出该订单 var order = (from orderInfo in context.OrderInfoes where orderInfo.ID == CurrentOrder.ID select orderInfo).FirstOrDefault(); order.ReceiptTime = DateTime.Now; context.SaveChanges(); Response.Redirect("~/Default.aspx"); } }
protected void Button1_Click(object sender, EventArgs e) { String name = TextBox1.Text.Trim(); using (LiBoClothesShopEntities context = new LiBoClothesShopEntities()) { GenderInfo newObj = new GenderInfo() { Name = name }; context.AddToGenderInfoes(newObj); context.SaveChanges(); Response.Redirect("~/Default.aspx"); } }
protected void Button1_Click(object sender, EventArgs e) { if (TextBox1.Text.Length == 0 || TextBox2.Text.Length == 0 || TextBox3.Text.Length == 0 || TextBox4.Text.Length == 0 || TextBox2.Text != TextBox3.Text) { Response.Write("<script> alert( '注册失败') </script> "); return; } else { //检查用户名是否存在 using (LiBoClothesShopEntities context = new LiBoClothesShopEntities()) { var query = from userInfo in context.UserInfoes where userInfo.UserName == TextBox1.Text select userInfo; if (query.Count() != 0) { Response.Write("<script> alert( '注册失败') </script> "); return; } else { UserInfo newUser = new UserInfo(); newUser.UserName = TextBox1.Text; newUser.Password = TextBox2.Text; newUser.Phone = TextBox3.Text; if (Convert.ToInt32(Request.QueryString["Type"]) == 2) { newUser.IsAdmin = true; } else { newUser.IsAdmin = false; } context.AddToUserInfoes(newUser); context.SaveChanges(); Response.Write("<script> alert( '注册成功');window.location.href = 'Default.aspx';</script>"); } } } }
protected void DeleteButton_Click(object sender, EventArgs e) { using (LiBoClothesShopEntities context = new LiBoClothesShopEntities()) { var query = from p in context.Clothes where p.Id == CurrentProduct.Id select p; context.Clothes.DeleteObject(query.FirstOrDefault()); context.SaveChanges(); } Response.Redirect("~"); }
protected void ResetQuantity() { String userName = ((Site1)Page.Master).CurrentUserName; if (userName.Equals("")) return; using (LiBoClothesShopEntities context = new LiBoClothesShopEntities()) { decimal totalPrice = 0; //对于表格中的每一行 foreach (GridViewRow row in GridView1.Rows) { //获取表格中填的数量 int quantity = Convert.ToInt32(((TextBox)row.FindControl("QuantityTextbox")).Text); //获取软件名称 string productName = row.Cells[0].Text; string size = row.Cells[1].Text; string color = row.Cells[2].Text; //找到该购物车明细 var query = from cartDetail in context.CartDetails where cartDetail.Cloth.Name == productName && cartDetail.ColorInfo.Name == color && cartDetail.SizeInfo.Name == size select cartDetail; if (quantity <= 0) { //如果数量小于0,删除该购物车明细 context.CartDetails.DeleteObject(query.FirstOrDefault()); } else { //修改数量 query.FirstOrDefault().QTY = quantity; } totalPrice += query.FirstOrDefault().QTY * query.FirstOrDefault().Cloth.Price; } //修改购物车的总价 (from p in context.CartInfoes where p.UserName == userName select p).FirstOrDefault().TotalPrice = totalPrice; //保存数据库 context.SaveChanges(); } }