// GET: MyCaseCenter/MyGood public ActionResult Index() //我的物品瀏覽 { Session["CaseID"] = null; if (Session["MEMBERID"] == null) { Session["MEMBERID"] = 12;//先寫死 } int memberid = (int)Session["MEMBERID"]; List <CaseGood> cgs = new List <CaseGood>(); var q = (from o in db.Cases join c in db.Goods on o.CaseID equals c.CaseID where o.MemberID == memberid orderby o.StartDateTime select o).ToList(); List <OrderCount> oco = new List <OrderCount>(); foreach (var a in q) { OrderCount ocou = new OrderCount(); ocou.CaseID = a.CaseID; ocou.CaseTitle = a.CaseTitle; ocou.Cou = db.Orders.Where(o => o.CaseID == a.CaseID).Count(); oco.Add(ocou); CaseGood cg = new CaseGood(); cg.CaseID = a.CaseID; cg.CaseTitle = a.CaseTitle; cg.StartDateTime = a.StartDateTime; int caseid = a.CaseID; int stasid = a.StatusID; cg.StatusName = db.CaseStatus.Find(stasid).StatusName; var q2 = db.Goods.Where(m => m.CaseID == caseid).Select(m => m); foreach (var x in q2) { cg.GdsName = x.GdsName; cg.GdsPoint = x.GdsPoint; cg.GdsCount = x.GdsCount; } cgs.Add(cg); } //MemberCaseCount mcc = new MemberCaseCount(); //var t = mcc.casecount(memberid); int ccount = db.Cases.Where(o => o.MemberID == memberid).Count(); ViewBag.allcase = ccount; ViewBag.GDcase = q.Count(); ViewBag.Count = oco; return(View(cgs)); }
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 EditGood(CaseGood goodv, IEnumerable <HttpPostedFileBase> files) { 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 = goodv.CaseID, Images = imageByte }); db.SaveChanges(); TempData["message"] = "上傳成功"; } else { TempData["message"] = "請先選檔案"; } } } var c = db.Cases.Find(goodv.CaseID); c.CaseTitle = goodv.CaseTitle; c.CaseContent = goodv.CaseContent; c.Contact = goodv.Contact; c.Location = goodv.Location; c.RegionID = goodv.RegionID; var g = db.Goods.Find(goodv.GdsID); //g.GdsName = goodv.GdsName; g.GdsCount = goodv.GdsCount; g.GdsPoint = 0; g.GdsSubClassID = goodv.GdsSubClassID; db.SaveChanges(); return(RedirectToAction("LoadGood")); }
public ActionResult LoadGood(int id = 0)//CaseID 完整資訊 單筆 //還需要部份檢視 秀多張圖 { CaseGood cg = new CaseGood(); if (id == 0) { id = (int)Session["CaseID"]; } 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.StatusID = q.StatusID; cg.StatusName = db.CaseStatus.Find(q.StatusID).StatusName; //狀態 var g = db.Goods.Where(m => m.CaseID == q.CaseID).First(); 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; } List <ContentViewModel> che = new List <ContentViewModel>(); var q3 = db.Content.Where(o => o.CaseID == id).OrderByDescending(o => o.MessageDateTime).ToList(); foreach (var a in q3) { ContentViewModel _order = new ContentViewModel(); int mem = a.MemberID; var mb = db.Member.Find(mem); _order.MessageContent = a.MessageContent; _order.ContentID = a.ContentID; _order.MessageDateTime = a.MessageDateTime; _order.AuthorRepeat = a.AuthorRepeat; _order.NickName = mb.NickName; _order.MemberID = mem; _order.Birthday = mb.Birthday; _order.Phone = mb.Phone; _order.Address = mb.Address; var reg = db.Region.Find(mb.RegionID); _order.RegionName = reg.RegionName; _order.CityName = db.City.Where(o => o.CityID == reg.CityID).First().CityName; string mpclassname = ""; var mpl = db.MPSCList.Where(o => o.MemberID == mem).ToList(); //每個會員的多個小專長ID foreach (var b in mpl) { string MPSub = db.MPSubClass.Find(b.MPSubClassID).MPSubClass1; mpclassname = mpclassname + MPSub + " "; } _order.MPSubClass1 = mpclassname; che.Add(_order); } ViewBag.ContentMember = che; return(View(cg)); }