[HttpPost] // 動作選取器 public ActionResult AddToCart() { string id = Request.Form["txtFid"]; if (string.IsNullOrEmpty(id)) { return(RedirectToAction("List")); } int fId = Convert.ToInt32(id); dbDemoEntities db = new dbDemoEntities(); tProduct product = db.tProduct.FirstOrDefault(p => p.fId == fId); if (product == null) { return(RedirectToAction("List")); } tShoppingCart item = new tShoppingCart(); item.fDate = DateTime.Now.ToString("yyyyMMddHHmmss"); item.fCustomerId = 1; item.fProductId = product.fId; item.fPrice = product.fPrice; item.fCount = Convert.ToInt32(Request.Form["txtCount"]); db.tShoppingCart.Add(item); db.SaveChanges(); return(RedirectToAction("List")); }
public ActionResult 購物車清單() { if (Session[CSession關鍵字.SK_LOGINED_CUSTOMER] != null) { MotaiDataEntities dbContext = new MotaiDataEntities(); tCustomer cust = Session[CSession關鍵字.SK_LOGINED_CUSTOMER] as tCustomer; int count = dbContext.tStatus.Where(c => c.sCustomerId == cust.CustomerId).ToList().Count; ViewBag.Count = count + "項"; List <tStatu> StateList = dbContext.tStatus.Where(c => c.sCustomerId == cust.CustomerId).ToList(); List <StatusCartViewModel> cartList = new List <StatusCartViewModel>(); StatusCartGoToPayViewModel Cart = new StatusCartGoToPayViewModel(); foreach (var items in StateList) { tProduct cartProd = dbContext.tProducts.Where(p => p.ProductId == items.sProductId).FirstOrDefault(); StatusCartViewModel cartC = new StatusCartViewModel(); cartC.StatusId = items.StatusId; cartC.ProductId = items.sProductId; cartC.pName = cartProd.pName; cartC.pPrice = cartProd.pPrice; cartC.sProductQty = items.sProductQty; cartList.Add(cartC); } Cart.Carts = cartList; var warehouseNames = commodityRespoitory.GetWarehouseAll(); List <SelectListItem> warehouselist = commodityRespoitory.GetSelectList(warehouseNames); Cart.warehouses = warehouselist; return(View(Cart)); } else { return(RedirectToAction("首頁")); } }
public ProductViewModel GetProductById(int ProductId) { List <tWarehouse> warehouse = dbContext.tWarehouses.Where(p => p.wProductId == ProductId).ToList(); tProduct product = dbContext.tProducts.FirstOrDefault(p => p.ProductId == ProductId); ProductViewModel Prod = new ProductViewModel(); Prod.ProductId = product.ProductId; Prod.pNumber = product.pNumber; Prod.pName = product.pName; Prod.psCategory = product.tProductCategory.Category; Prod.psMaterial = product.tProductMaterial.Material; Prod.psSize = product.tProductSize.Size; Prod.pLxWxH = product.pLxWxH; Prod.pWeight = product.pWeight; Prod.pIntroduction = product.pIntroduction; Prod.pPrice = product.pPrice; if (warehouse != null) { int warehouseQty = 0; foreach (var wareQty in warehouse) { warehouseQty += wareQty.wPQty; } Prod.pQty = warehouseQty; } else { Prod.pQty = 0; } Prod.psImage = GetProductShowImages(product); return(Prod); }
public JsonResult 收藏排名() { MotaiDataEntities dbContext = new MotaiDataEntities(); List <tFavorite> favordb = dbContext.tFavorites.ToList(); string func(int i) { tProduct p = new tProduct(); List <string> pimage = new List <string>(); p.ProductId = i; pimage = productRespotiory.GetProductShowImages(p); if (pimage.Count > 0) { return(Url.Content(pimage[0])); } else { return(""); } } var favorOrderby = (from i in favordb group i by i.fProductId into j select new { Pid = j.Key, Pimage = func(j.Key), Pcount = j.Count(), }).OrderByDescending(j => j.Pcount).Take(10).ToArray(); return(Json(new { favorOrderby })); }
public ActionResult 購物車清單() { if (Session[CSession關鍵字.SK_LOGINED_CUSTOMER] != null) { MotaiDataEntities dbContext = new MotaiDataEntities(); tCustomer cust = Session[CSession關鍵字.SK_LOGINED_CUSTOMER] as tCustomer; List <tStatu> StateList = dbContext.tStatus.Where(c => c.sCustomerId == cust.CustomerId).ToList(); List <StatusCartViewModel> cartList = new List <StatusCartViewModel>(); foreach (var items in StateList) { tPromotion discount = dbContext.tPromotions.Where(p => p.PromotionId == items.sProductId).FirstOrDefault(); tProduct cartProd = dbContext.tProducts.Where(p => p.ProductId == items.sProductId).FirstOrDefault(); StatusCartViewModel cartC = new StatusCartViewModel(); cartC.StatusId = items.StatusId; cartC.pName = cartProd.pName; cartC.pPrice = cartProd.pPrice; cartC.sProductQty = items.sProductQty; cartC.pDiscountCode = discount.pDiscountCode; cartList.Add(cartC); } return(View(cartList)); } else { return(RedirectToAction("首頁")); } }
public IHttpActionResult PuttProduct(int id, tProduct tProduct) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tProduct.ID) { return(BadRequest()); } db.Entry(tProduct).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tProductExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult Create(string fId, string fName, decimal fPrice, HttpPostedFileBase fImg) { //處理圖檔上傳 string fileName = ""; if (fImg != null) { if (fImg.ContentLength > 0) { fileName = System.IO.Path.GetFileName(fImg.FileName); fImg.SaveAs(Server.MapPath("~/images/" + fileName));//MapPath:把邏輯路徑,轉成實體路徑。//將檔案存到Images資料夾下 } } //新增至db //步驟1,先將東西丟至module tProduct product = new tProduct(); product.fId = fId; product.fName = fName; product.fPrice = fPrice; product.fImg = fileName; db.tProduct.Add(product); //步驟2,存至db //多出來的做新增 //不一樣的做修改 db.SaveChanges(); return(RedirectToAction("Index")); }
protected void Page_Load(object sender, EventArgs e) { using (eShopperDBEntities products = new eShopperDBEntities()) { var query = from p in products.tProducts select p; tProduct product = (query.FirstOrDefault <tProduct>()); GridView1.DataSource = query.ToList(); GridView1.DataBind(); } using (eShopperDBEntities categpry = new eShopperDBEntities()) { var query = (from c in categpry.tCategories select c); // tCategory categpryies = (query.FirstOrDefault<tCategory>()); // GridView1.DataSource = query.ToList(); // GridView1.DataBind(); DropDownList2.DataSource = query.ToList(); DropDownList2.DataTextField = "CategoryName"; DropDownList2.DataValueField = "CategoryID"; DropDownList2.DataBind(); } }
public JsonResult chooseShipWare(int OrderId) { MotaiDataEntities dbContext = new MotaiDataEntities(); List <tOrderDetail> orderDetailSearchs = dbContext.tOrderDetails.Where(od => od.oOrderId.Equals(OrderId)).ToList(); List <WareShipChooseViewModel> ChooseList = new List <WareShipChooseViewModel>(); foreach (var item in orderDetailSearchs) { List <tWarehouse> wareList = dbContext.tWarehouses.Where(w => w.wProductId.Equals(item.oProductId)).ToList(); foreach (var itemware in wareList) { tProduct product = dbContext.tProducts.Where(p => p.ProductId.Equals(item.oProductId)).FirstOrDefault(); WareShipChooseViewModel wareChoose = new WareShipChooseViewModel(); wareChoose.WareHouseName = dbContext.tWarehouseNames.Where(wn => wn.WarehouseNameId.Equals(itemware.WarehouseNameId)).FirstOrDefault().WarehouseName; wareChoose.WareHouseId = itemware.WarehouseNameId; wareChoose.OrderDetailId = item.oOrderDetailId; wareChoose.ProductId = product.ProductId; wareChoose.ProductNum = product.pNumber; wareChoose.ProductName = product.pName; wareChoose.ProductQty = itemware.wPQty; ChooseList.Add(wareChoose); } } return(Json(ChooseList)); }
[HttpPost] //將表單資料丟到伺服器端 //取得資料,當資料有檔案時,要使用HttpPostedFileBase public ActionResult Create(string fId, string fName, decimal fPrice, HttpPostedFileBase fImg) { string imgname = ""; if (fImg != null) { //處理表單上傳的圖片 if (fImg.ContentLength > 0) { imgname = System.IO.Path.GetFileName(fImg.FileName); //system.io為namespace;取得檔案檔名(副檔名也會取得) fImg.SaveAs(Server.MapPath("~/images/" + imgname)); //由於不知道伺服器實體路徑,使用server.mappath,程式會將邏輯路徑轉為伺服器端的實體路徑 Console.WriteLine(Server.MapPath("~/images/" + imgname)); } } //處理圖檔上傳(先丟到model,再丟到DB) tProduct product = new tProduct(); //將資料表鑄造為一個物件,欄位視為資料表的屬性 product.fId = fId; product.fName = fName; product.fPrice = fPrice; product.fImg = imgname; db.tProduct.Add(product); //將資料寫到model db.SaveChanges(); //將資料寫入資料庫 return(RedirectToAction("Index")); //新增完重新導向到首頁 }
public ActionResult Create(string fId, string fName, decimal fPrice, HttpPostedFileBase fImg) { try { //上傳圖檔 string fileName = ""; //檔案上傳 if (fImg != null) { if (fImg.ContentLength > 0) { //取得圖檔名稱 fileName = System.IO.Path.GetFileName(fImg.FileName); var path = System.IO.Path.Combine(Server.MapPath("~/Images"), fileName); fImg.SaveAs(path); //檔案儲存到Images資料夾下 } } //新增記錄 tProduct product = new tProduct(); product.fId = fId; product.fName = fName; product.fPrice = fPrice; product.fImg = fileName; db.tProduct.Add(product); db.SaveChanges(); return(RedirectToAction("Index")); //導向Index的Action方法 } catch (Exception ex) { ViewBag.Error = ex.Message; } return(View()); }
public ActionResult 修改產品(int id) { MotaiDataEntities db = new MotaiDataEntities(); tProduct product = db.tProducts.FirstOrDefault(p => p.ProductId == id); if (product == null) { return(RedirectToAction("員工看產品頁面")); } EmpProductViewModel Prod = new EmpProductViewModel(); Prod.ProductId = id; Prod.pNumber = product.pNumber; Prod.pName = product.pName; Prod.psCategory = product.tProductCategory.Category; Prod.psMaterial = product.tProductMaterial.Material; Prod.psSize = product.tProductSize.Size; Prod.pLxWxH = product.pLxWxH; Prod.pWeight = product.pWeight; Prod.pIntroduction = product.pIntroduction; Prod.pPrice = product.pPrice; var categories = new ProductRespoitory().GetCategoryAll(); List <SelectListItem> Cateitems = new ProductRespoitory().GetSelectList(categories); Prod.Categories = Cateitems; var materials = new ProductRespoitory().GetMaterialAll(); List <SelectListItem> Mateitems = new ProductRespoitory().GetSelectList(materials); Prod.Materials = Mateitems; var sizes = new ProductRespoitory().GetSizeAll(); List <SelectListItem> Sizeitems = new ProductRespoitory().GetSelectList(sizes); Prod.Sizes = Sizeitems; return(View(Prod)); }
public void pm(tProduct x) { if (x.fPayBy != null) { foreach (var i in x.fPayBy) { switch (i) { case 1: x.fPayByArrive = 1; break; case 2: x.fPayByLinePay = 1; break; case 3: x.fPayByJKO = 1; break; case 4: x.fPayByCard = 1; break; } } } }
protected void Btn_Create_Click(object sender, EventArgs e) { try { // 圖檔儲存 string fileName = ""; if (FileUpload1.HasFile) { FileUpload1.SaveAs(Server.MapPath("Images") + "/" + FileUpload1.FileName); fileName = FileUpload1.FileName; } // 新增紀錄 dbProductEntities db = new dbProductEntities(); tProduct product = new tProduct(); product.fId = txtId.Text; product.fName = txtName.Text; product.fPrice = decimal.Parse(txtPrice.Text); product.fImg = fileName; db.tProduct.Add(product); db.SaveChanges(); // 轉向 Index.aspx Response.Redirect("Index.aspx"); } catch (Exception ex) { lblError.Text = ex.Message; } }
public ActionResult Create(string fId, string fName, decimal fPrice, HttpPostedFileBase fImg) { //處理圖檔上傳 string fileName = ""; if (fImg != null) { if (fImg.ContentLength > 0) { fileName = System.IO.Path.GetFileName(fImg.FileName); //取得檔案的檔名 fImg.SaveAs(Server.MapPath("~/images/" + fileName)); //將檔案存到Images資料夾下 } } //處理圖檔上傳end tProduct product = new tProduct(); product.fId = fId; product.fName = fName; product.fPrice = fPrice; product.fImg = fileName; db.tProduct.Add(product); db.SaveChanges(); return(RedirectToAction("Index")); //導向Index的Action方法 }
public JsonResult 購買排名() { MotaiDataEntities dbContext = new MotaiDataEntities(); List <tOrderDetail> orderdb = dbContext.tOrderDetails.ToList(); //這樣才能在linq內使用函式 string func(int i) { tProduct p = new tProduct(); List <string> pimage = new List <string>(); p.ProductId = i; pimage = productRespotiory.GetProductShowImages(p); if (pimage.Count > 0) { return(Url.Content(pimage[0])); } else { return(""); } } var buyOrderby = (from i in orderdb group i by i.oProductId into j select new { Pid = j.Key, Pimage = func(j.Key), Pcount = j.Sum(p => p.oProductQty), }).OrderByDescending(j => j.Pcount).Take(10).ToArray(); return(Json(new { buyOrderby })); }
public JsonResult 實體店新增訂單(EmployeeOrderViewModel empOrder) { if (Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] != null) { tEmployee emp = Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] as tEmployee; if (Session[CSession關鍵字.SK_ORDERDETAIL] == null) { return(Json(new { result = false, msg = "訂單尚未完成!", url = Url.Action("實體店新增訂單", "Order") })); } else { List <EmployeeOrderDetailViewModel> orders = Session[CSession關鍵字.SK_ORDERDETAIL] as List <EmployeeOrderDetailViewModel>; MotaiDataEntities dbContext = new MotaiDataEntities(); tCustomer customer = dbContext.tCustomers.Where(c => c.cCellPhone == empOrder.cCellphone).FirstOrDefault(); tOrder list = new tOrder(); list.oEmployeeId = emp.EmployeeId; list.oCustomerId = customer.CustomerId; if (empOrder.oAddress == null) { list.oAddress = customer.cAddress; } else { list.oAddress = empOrder.oAddress; } list.oDate = empOrder.oDate; list.cNote = empOrder.cNote; list.oWarehouseName = empOrder.oWarehouseName; dbContext.tOrders.Add(list); dbContext.SaveChanges(); int orderId = dbContext.tOrders.OrderByDescending(i => i.OrderId).First().OrderId; int originalPrice = 0; foreach (var items in orders) { tOrderDetail detail = new tOrderDetail(); detail.oOrderId = orderId; detail.oProductId = items.oProductId; detail.oProductQty = items.oProductQty; detail.oNote = items.oNote; dbContext.tOrderDetails.Add(detail); tProduct product = dbContext.tProducts.Where(p => p.ProductId.Equals(items.oProductId)).FirstOrDefault(); originalPrice += items.oProductQty * Convert.ToInt32(product.pPrice); } tOrder order = dbContext.tOrders.Where(o => o.OrderId == orderId).FirstOrDefault(); int promotionId = orderRespoitory.SelectPromotionId(originalPrice, empOrder.oDate); if (promotionId != 0) { order.oPromotionId = promotionId; } dbContext.SaveChanges(); Session[CSession關鍵字.SK_ORDERDETAIL] = null; return(Json(new { result = true, msg = "新增成功", url = Url.Action("realCheckView", "Order"), OrderId = orderId })); } } else { return(Json(new { result = false, msg = "尚未登入!", url = Url.Action("員工登入", "Employee") })); } }
public JsonResult autoProductNumPrice(int ProductId) { MotaiDataEntities dbContext = new MotaiDataEntities(); tProduct product = dbContext.tProducts.Where(p => p.ProductId == ProductId).FirstOrDefault(); string Number = product.pNumber; string Price = product.pPrice.ToString("#0.######"); return(Json(new { num = Number, price = Price })); }
//客戶看訂單 public ActionResult 過往訂單() { if (Session[CSession關鍵字.SK_LOGINED_CUSTOMER] != null) { tCustomer cust = Session[CSession關鍵字.SK_LOGINED_CUSTOMER] as tCustomer; MotaiDataEntities db = new MotaiDataEntities(); List <tOrder> orders = db.tOrders.Where(o => o.oCustomerId == cust.CustomerId).ToList(); List <CustomerOrderViewModel> OrderList = new List <CustomerOrderViewModel>(); foreach (var items in orders) { CustomerOrderViewModel order = new CustomerOrderViewModel(); order.oDate = items.oDate; order.WarehouseName = db.tWarehouseNames.Where(w => w.WarehouseNameId.Equals(items.oWarehouseName)).FirstOrDefault().WarehouseName; tEmployee employee = db.tEmployees.Where(e => e.EmployeeId == items.oEmployeeId).FirstOrDefault(); if (employee != null) { order.EmployeeName = employee.eName; } order.cNote = items.cNote; List <tOrderDetail> orderdetails = db.tOrderDetails.Where(od => od.oOrderId == items.OrderId).ToList(); List <CustomerOrderDetailViewModel> OrderDetailList = new List <CustomerOrderDetailViewModel>(); int originPrice = 0; foreach (var itemDetail in orderdetails) { CustomerOrderDetailViewModel orderdetail = new CustomerOrderDetailViewModel(); tProduct product = db.tProducts.Where(p => p.ProductId == itemDetail.oProductId).FirstOrDefault(); orderdetail.ProductNum = product.pNumber; orderdetail.ProductName = product.pName; orderdetail.ProductPrice = product.pPrice; orderdetail.oProductQty = itemDetail.oProductQty; orderdetail.oNote = itemDetail.oNote; OrderDetailList.Add(orderdetail); originPrice += Convert.ToInt32(product.pPrice) * itemDetail.oProductQty; } if (items.oPromotionId != null) { tPromotion promotion = db.tPromotions.Where(p => p.PromotionId == items.oPromotionId).FirstOrDefault(); order.TotalAmount = originPrice - Convert.ToInt32(promotion.pDiscount); } else { order.TotalAmount = originPrice; } List <tOrderPay> paylists = db.tOrderPays.Where(op => op.oOrderId == items.OrderId).ToList(); foreach (var itemPay in paylists) { order.AlreadyPay += Convert.ToInt32(itemPay.oPayment); } order.Unpaid = order.TotalAmount - order.AlreadyPay; order.CustomerOrderDetails = OrderDetailList; OrderList.Add(order); } return(View(OrderList)); } return(RedirectToAction("首頁")); }
public ActionResult ProductEdit(tProduct prod) { ViewBag.PartDropDownList = DropDownList.GetPartDropDownList(); ViewBag.NoteDropList = DropDownList.GetNoteDropList(); ViewBag.CategoryDropList = DropDownList.GetCategoryDropList(); ViewBag.EfficacyDropLise = DropDownList.GetEfficacyDropLise(); ViewBag.featureDropList = DropDownList.GetfeatureDropList(); db.SaveChanges(); return(RedirectToAction("ProductPage")); }
public List <string> GetProductShowImages(tProduct product) { List <string> psImage = new List <string>(); List <tProductImage> images = dbContext.tProductImages.Where(i => i.ProductId.Equals(product.ProductId)).ToList(); foreach (var imageitem in images) { psImage.Add(imageitem.pImage); } return(psImage); }
public IHttpActionResult PosttProduct(tProduct tProduct) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tProducts.Add(tProduct); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = tProduct.ID }, tProduct)); }
public ActionResult Edit(int?id) { if (id == null) { return(RedirectToAction("List")); } dbDemoEntities db = new dbDemoEntities(); tProduct x = db.tProduct.FirstOrDefault(m => m.fId == id); return(View(x)); }
protected void btnSave_Click(object sender, EventArgs e) { if (cl.checkRole(Session["userid_hcc"].ToString(), codeModule, 1)) { if (txtName.Text.Trim().Equals("")) { Mess("Nhập tên sản phẩm", ""); } else { try { string filename = DateTime.Now.ToString("ddMMyyyyhhmmss"), file_ex = ""; HttpFileCollection hfc = Request.Files; for (int i = 0; i < hfc.Count; i++) { HttpPostedFile hpf = hfc[i]; if (hpf.ContentLength > 0) { tProduct p = new tProduct(); p.Name = txtName.Text.Trim(); p.CategoryId = int.Parse(dlCategory.SelectedValue.Trim()); p.IsActive = ckActive.Checked; p.CreateAt = DateTime.Now; file_ex = hpf.FileName.Trim(); file_ex = file_ex.Substring(file_ex.LastIndexOf('.')); p.Image = "/wp-content/uploads/gallery/" + filename + "_" + i.ToString() + file_ex; db.tProducts.InsertOnSubmit(p); hpf.SaveAs(Server.MapPath("/wp-content/uploads/gallery/" + filename + "_" + i.ToString() + file_ex)); } } db.SubmitChanges(); ResetControl(); LoadGrid(); Mess("Lưu thành công", ""); } catch (Exception ax) { Mess(ax.Message, ""); } } } else { Mess("Bạn không có quyền sử dụng chức năng này", "/adhome"); } }
public IHttpActionResult DeletetProduct(int id) { tProduct tProduct = db.tProducts.Find(id); if (tProduct == null) { return(NotFound()); } db.tProducts.Remove(tProduct); db.SaveChanges(); return(Ok(tProduct)); }
public ActionResult EditProduct(tProduct modify, HttpPostedFileBase fImgFile) { var prod = db.tProduct .Where(p => p.fId == modify.fId) .FirstOrDefault(); if (fImgFile != null) { string deleteresult = prod.fImg; if (System.IO.File.Exists(Server.MapPath(prod.fImg))) { try { System.IO.File.Delete(Server.MapPath(prod.fImg)); } catch { deleteresult = "修改失敗"; } } if (deleteresult != "修改失敗") { int point = fImgFile.FileName.IndexOf("."); string extention = fImgFile.FileName.Substring(point, fImgFile.FileName.Length - point); string photoName = modify.fPId + extention; fImgFile.SaveAs(Server.MapPath("../Content/" + photoName)); modify.fImg = "../Content/" + photoName; } } else { ViewBag.ImgFile = "請上傳產品圖片"; return View("EditProduct", "_LayoutAdmin", prod); } if (prod != null) { prod.fPId = modify.fPId; prod.fName = modify.fName; prod.fPrice = modify.fPrice; prod.fImg = modify.fImg; prod.fIsApproved = modify.fIsApproved; db.SaveChanges(); } return RedirectToAction("Index"); }
public ActionResult Delete(int?id) { if (id == null) { return(RedirectToAction("List")); } dbDemoEntities db = new dbDemoEntities(); tProduct p = db.tProduct.FirstOrDefault(m => m.fId == id); if (p != null) { db.tProduct.Remove(p); db.SaveChanges(); } return(RedirectToAction("List")); }
//public HttpPostedFileBase fImage { get; set; } public ActionResult Create(tProduct x) { payMethod pm = new payMethod(); pm.pm(x); if (x.fImage != null) { string name = Guid.NewGuid().ToString() + Path.GetExtension(x.fImage.FileName); var path = Path.Combine(Server.MapPath("~/Content"), name); x.fImage.SaveAs(path); x.fProductImage = "/Content/" + name; } db.tProduct.Add(x); db.SaveChanges(); return(RedirectToAction("productList")); }
public ActionResult Delete(int?id) { if (id == null) { return(RedirectToAction("productList")); } ; tProduct t = db.tProduct.FirstOrDefault(z => z.fProductId == id); if (t != null) { db.tProduct.Remove(t); db.SaveChanges(); } return(RedirectToAction("productList")); }
public ActionResult 新增產品(ProductViewModel n新增產品) { MotaiDataEntities db = new MotaiDataEntities(); tProduct prod = new tProduct(); prod.pNumber = n新增產品.pNumber; prod.pName = n新增產品.pName; prod.pCategory = n新增產品.pCategory; prod.pMaterial = n新增產品.pMaterial; prod.pSize = n新增產品.pSize; prod.pLxWxH = n新增產品.pLxWxH; prod.pPrice = n新增產品.pPrice; prod.pWeight = n新增產品.pWeight; db.tProducts.Add(prod); tProduct Product = db.tProducts.OrderByDescending(o => o.ProductId).FirstOrDefault(); int ProductId; if (Product == null) { ProductId = 1; } else { ProductId = Product.ProductId; ProductId++; } if (n新增產品.pImage.Count() > 0) { foreach (var uploagFile in n新增產品.pImage) { if (uploagFile.ContentLength > 0) { tProductImage image = new tProductImage(); FileInfo file = new FileInfo(uploagFile.FileName); string photoName = Guid.NewGuid().ToString() + file.Extension; uploagFile.SaveAs(Server.MapPath("~/images/" + photoName)); image.ProductId = ProductId; image.pImage = "~" + Url.Content("~/images/" + photoName); db.tProductImages.Add(image); } } } db.SaveChanges(); return(RedirectToAction("倉儲看產品頁面")); }