public ActionResult Delete(int id, string returnURL) { if (Session["admin"] != null) { T_FurnitureCover style = db.T_FurnitureCover.Find(id); db.T_FurnitureCover.Remove(style); db.SaveChanges(); List <FurnitureStyle> sftyle = db.FurnitureStyle.Where(o => o.CompanyId == getSession.CompanyId && o.StyleId == id).ToList(); db.FurnitureStyle.RemoveRange(sftyle); db.SaveChanges(); string styleId = style.Id.ToString(); UpdateRecord record = db.UpdateRecord.Where(item => item.FurnitureId == styleId).FirstOrDefault(); if (record != null) { record.UpdateTime = DateTime.Now; db.Entry(record).State = EntityState.Modified; } else { record = new UpdateRecord(); record.FurnitureId = styleId; record.UpdateTime = DateTime.Now; db.UpdateRecord.Add(record); } return(Redirect(returnURL)); } else { return(RedirectToAction("Login", "Console")); } }
public ActionResult Edit(int id) { if (Session["admin"] != null) { T_FurnitureCover style = db.T_FurnitureCover.Find(id); ViewBag.IsCreate = true; return(View(style)); } else { return(RedirectToAction("Login", "Console")); } }
public ActionResult GetFurnitureIndex(int companyId, int styleId) { var notshowdata = db.FStyleID.Where(o => o.CompanyId == companyId).Select(o => o.FStyleId).ToList(); //var fsmodelAll = db.FurnitureStyle.Where(item => item.StyleId == styleId && item.CompanyId == companyId || (item.CreateUserId == 1 && !notshowdata.Contains(item.Id))).OrderByDescending(item => item.Id).Take(12).ToList(); var fsmodelAll = db.FurnitureStyle.Where(item => item.StyleId == styleId && (item.CompanyId == companyId || (item.CreateUserId == 1 && !notshowdata.Contains(item.Id)))).OrderByDescending(item => item.Id).Take(12).ToList(); T_FurnitureCover cover = db.T_FurnitureCover.Find(styleId); List <FurnitureStyleList> furnitureStyleList = new List <FurnitureStyleList>(); foreach (FurnitureStyle furnitureStyle in fsmodelAll) { FurnitureStyleList furniturestyleList = new FurnitureStyleList(); furniturestyleList.FurnitureCoverName = cover.StyleName; furniturestyleList.FurnitureId = furnitureStyle.Id; furniturestyleList.FurniturePic = ConfigurationManager.AppSettings["ResourceUrl"] + furnitureStyle.IndexPic; furnitureStyleList.Add(furniturestyleList); } return(Json(new { data = furnitureStyleList }, JsonRequestBehavior.AllowGet)); }
public ActionResult GetFurnitureAll(int styleId, int companyId) { string id = styleId.ToString(); UpdateRecord record = db.UpdateRecord.Where(item => item.FurnitureId == id).FirstOrDefault(); if (record == null) { record = new UpdateRecord(); record.FurnitureId = id; record.UpdateTime = DateTime.Now; db.UpdateRecord.Add(record); db.SaveChanges(); } T_FurnitureCover furnitureCover = db.T_FurnitureCover.Find(styleId); var notshowdata = db.FStyleID.Where(o => o.CompanyId == companyId).Select(o => o.FStyleId).ToList(); var fsmodelAll = db.FurnitureStyle.Where(item => item.StyleId == styleId && (item.CompanyId == companyId || (item.CreateUserId == 1 && !notshowdata.Contains(item.Id)))).OrderByDescending(item => item.Id).ToList(); T_FurnitureCoverData furnitureCoverData = new T_FurnitureCoverData(); furnitureCoverData.FurnitureCoverId = furnitureCover.Id; furnitureCoverData.FurnitureCoverName = furnitureCover.StyleName; furnitureCoverData.FurnitureCoverIndex = ConfigurationManager.AppSettings["ResourceUrl"] + furnitureCover.StylePic; furnitureCoverData.FurnitureCoverUpdate = record.UpdateTime.ToString("yyyy-MM-dd HH:mm:ss"); List <FurnitureStyleData> furnitureStyleList = new List <FurnitureStyleData>(); foreach (FurnitureStyle furnitureStyle in fsmodelAll) { FurnitureStyleData furnitureStyleData = new FurnitureStyleData(); furnitureStyleData.FurnitureId = furnitureStyle.Id; furnitureStyleData.FurnitureIndexPic = ConfigurationManager.AppSettings["ResourceUrl"] + furnitureStyle.IndexPic; furnitureStyleData.FurniturePic = ConfigurationManager.AppSettings["ResourceUrl"] + furnitureStyle.FurniturePics; string[] args = furnitureStyle.StyleName.Split('&').ToArray(); furnitureStyleData.FurnitureBrand = args[0]; furnitureStyleData.FurnitureSize = args[1]; furnitureStyleData.FurniturePrize = args[2]; furnitureStyleData.FurnitureMaterial = args[3]; furnitureStyleList.Add(furnitureStyleData); } furnitureCoverData.FurnitureStyleData = furnitureStyleList; return(Json(new { data = furnitureCoverData }, JsonRequestBehavior.AllowGet)); }
public ActionResult SavEdit(bool IsCreate, T_FurnitureCover style) { if (Session["admin"] != null) { style.CreateTime = DateTime.Now; if (IsCreate) { db.Entry(style).State = EntityState.Modified; style.CompanyId = getSession.CompanyId; style.CreateUserId = getSession.AdminId; int ll = db.SaveChanges(); } else { style.CompanyId = getSession.CompanyId; style.CreateUserId = getSession.AdminId; style.FStyleState = 1; //默认显示 db.T_FurnitureCover.Add(style); int ll = db.SaveChanges(); } string styleId = style.Id.ToString(); UpdateRecord record = db.UpdateRecord.Where(item => item.FurnitureId == styleId).FirstOrDefault(); if (record != null) { record.UpdateTime = DateTime.Now; db.Entry(record).State = EntityState.Modified; } else { record = new UpdateRecord(); record.FurnitureId = styleId; record.UpdateTime = DateTime.Now; db.UpdateRecord.Add(record); } return(Redirect("List")); } else { return(RedirectToAction("Login", "Console")); } }