public ActionResult EditGood(int id) //CaseID 修改的頁面 先讀取單筆 { CaseGood cg = new CaseGood(); var q = db.Cases.Find(id); cg.CaseID = q.CaseID; Session["CaseID"] = q.CaseID; cg.CaseTitle = q.CaseTitle; cg.CaseContent = q.CaseContent; cg.StartDateTime = q.StartDateTime; cg.Location = q.Location; //地址還不完整!!!!!!! cg.Contact = q.Contact; cg.StatusName = db.CaseStatus.Find(q.StatusID).StatusName; //狀態 var g = db.Goods.Where(m => m.CaseID == q.CaseID).First(); cg.GdsID = g.GdsID; cg.GdsName = g.GdsName; cg.GdsCount = g.GdsCount; cg.GdsPoint = g.GdsPoint; var sub = db.GdsSubClass.Find(g.GdsSubClassID); cg.GdsSubClass1 = sub.GdsSubClass1; //小分類 cg.GdsClass = db.GoodsClass.Find(sub.GdsClassID).GdsClass; //大分類 var re = db.Region.Find(q.RegionID); cg.RegionName = re.RegionName; //區 cg.CityName = db.City.Find(re.CityID).CityName; //縣市 int count = db.Picture.Where(o => o.CaseID == id).Count(); if (count > 0) { var pimg = db.Picture.Where(m => m.CaseID == id).FirstOrDefault(); cg.ImageID = pimg.ImageID; } Goods goods = db.Goods.Find(g.GdsID); GdsSubClass subclass = db.GdsSubClass.Find(g.GdsSubClassID); ViewBag.GdsSubClassID = new SelectList(db.GdsSubClass.Where(o => o.GdsClassID == subclass.GdsClassID), "GdsSubClassID", "GdsSubClass1", goods.GdsSubClassID); ViewBag.GdsClassID = new SelectList(db.GoodsClass, "GdsClassID", "GdsClass", subclass.GdsClassID); Cases _case = db.Cases.Find(id); Region region = db.Region.Find(q.RegionID); ViewBag.RegionID = new SelectList(db.Region.Where(o => o.CityID == region.CityID), "RegionID", "RegionName", _case.RegionID); ViewBag.CityID = new SelectList(db.City, "CityID", "CityName", region.CityID); ViewBag.count = count; return(View(cg)); }
public ActionResult GoodsCreate(IEnumerable <HttpPostedFileBase> files) { //int mid = Convert.ToInt32(Request.Cookies["MEMBERID"].Value); int mid = (int)Session["MEMBERID"]; #region List <GoodsClass> gc = new List <GoodsClass>(); GoodsClass first = new GoodsClass(); first.GdsClassID = 10000; first.GdsClass = "請選擇類別"; gc.Add(first); var q = db.GoodsClass; foreach (var a in q) { gc.Add(a); } List <GdsSubClass> gsc = new List <GdsSubClass>(); GdsSubClass sbfirst = new GdsSubClass(); sbfirst.GdsSubClassID = 10000; sbfirst.GdsSubClass1 = "請先選擇大類別"; gsc.Add(sbfirst); ViewBag.GdsClassID = new SelectList(gc, "GdsClassID", "GdsClass", first.GdsClassID); ViewBag.GdsSubClassID = new SelectList(gsc, "GdsSubClassID", "GdsSubClass1", sbfirst.GdsSubClassID); List <City> ct = new List <City>(); City ctfirst = new City(); ctfirst.CityID = 10000; ctfirst.CityName = "請選擇縣市"; ct.Add(ctfirst); var z = db.City; foreach (var a in z) { ct.Add(a); } List <Region> rg = new List <Region>(); Region rgfirst = new Region(); rgfirst.RegionID = 10000; rgfirst.RegionName = "請先選擇縣市"; rg.Add(rgfirst); ViewBag.CityID = new SelectList(ct, "CityID", "CityName", ctfirst.CityID); ViewBag.RegionID = new SelectList(rg, "RegionID", "RegionName", rgfirst.RegionID); #endregion if (Request.Form.Count > 0) { db.Cases.Add(new Cases { CaseTitle = Request.Form["CaseTitle"], CaseContent = Request.Form["CaseContent"], StartDateTime = DateTime.Now, MemberID = mid, Recommendation = 0, Location = Request.Form["Location"], RegionID = Convert.ToInt32(Request.Form["RegionID"]), Contact = Request.Form["Contact"], StatusID = Convert.ToInt32(Request.Form["StatusID"]), }); db.SaveChanges(); int cid = db.Cases.Where(c => c.MemberID == mid).OrderByDescending(c => c.CaseID).First().CaseID; db.Goods.Add(new Goods { CaseID = cid, GdsPoint = 0, GdsName = Request.Form["CaseContent"], GdsCount = Convert.ToInt32(Request.Form["GdsCount"]), GdsDeadline = Convert.ToDateTime(Request.Form["GdsDeadline"]), GdsSubClassID = Convert.ToInt32(Request.Form["GdsSubClassID"]), }); if (files != null) { foreach (var file in files) { if (file != null) { var imagesSize = file.ContentLength; byte[] imageByte = new byte[imagesSize]; file.InputStream.Read(imageByte, 0, imagesSize); db.Picture.Add(new Picture { CaseID = cid, Images = imageByte }); db.SaveChanges(); TempData["message"] = "上傳成功"; } else { TempData["message"] = "請先選檔案"; } } } db.SaveChanges(); return(RedirectToAction("BrowseGoodsAll")); } else { return(View()); } }