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"));
     }
 }
Example #3
0
        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));
        }
Example #4
0
        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"));
            }
        }