public ActionResult Delete(int id, string returnURL)
{
if (Session["admin"] != null)
{
FurnitureStyle style = db.FurnitureStyle.Find(id);
db.FurnitureStyle.Remove(style);
db.SaveChanges();
List <T_StyleFurniturePics> styles = db.T_StyleFurniturePics.Where(o => o.IdentityId == style.IdentityId).ToList();
db.T_StyleFurniturePics.RemoveRange(styles);
string styleId = style.StyleId.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);
}
db.SaveChanges();
return(Redirect(returnURL));
}
else
{
return(RedirectToAction("Login", "Console"));
}
}
public ActionResult SavEdit(bool IsCreate, FurnitureStyle style)
{
if (Session["admin"] != null)
{
style.CreateTime = DateTime.Now.ToString("yyyy-MM-dd");
// style.IndexPic = ToSmall(style.IndexPic);
if (IsCreate)
{
db.Entry(style).State = EntityState.Modified;
style.CompanyId = getSession.CompanyId;
//style.CompanyId = getSession.CompanyId;
//style.CreateUserId = getSession.AdminId;
//if (style.IndexPic == "无")
//{
// style.IndexPic = ToSmall(style.FurniturePics);
//}
int ll = db.SaveChanges();
// SavePicDataByUpdate(style.FurniturePics, style.StyleId, style.IdentityId);
}
else
{
style.IdentityId = Guid.NewGuid().ToString();
style.IndexPic = ToSmall(style.FurniturePics);
style.CompanyId = getSession.CompanyId;
style.CreateUserId = getSession.AdminId;
style.FStyleState = 1; //默认显示
db.FurnitureStyle.Add(style);
int ll = db.SaveChanges();
//SavePicData(style.FurniturePics, style.StyleId, style.IdentityId);
}
string styleId = style.StyleId.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);
}
db.SaveChanges();
return(Redirect("List"));
}
else
{
return(RedirectToAction("Login", "Console"));
}
}
public ActionResult Edit(int id)
{
if (Session["admin"] != null)
{
FurnitureStyle style = db.FurnitureStyle.Find(id);
ViewBag.IsCreate = true;
return(View(style));
}
else
{
return(RedirectToAction("Login", "Console"));
}
}
public ActionResult GetFurnitureData(int styleId)
{
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();
//}
FurnitureStyleData furnitureStyleData = new FurnitureStyleData();
FurnitureStyle furniture = db.FurnitureStyle.Find(styleId);
furnitureStyleData.FurnitureId = furniture.Id;
furnitureStyleData.FurnitureIndexPic = ConfigurationManager.AppSettings["ResourceUrl"] + furniture.IndexPic;
furnitureStyleData.FurniturePic = ConfigurationManager.AppSettings["ResourceUrl"] + furniture.FurniturePics;
string[] args = furniture.StyleName.Split('&').ToArray();
furnitureStyleData.FurnitureBrand = args[0];
furnitureStyleData.FurnitureSize = args[1];
furnitureStyleData.FurniturePrize = args[2];
furnitureStyleData.FurnitureMaterial = args[3];
//furnitureStyleData.FurnitureUpdate = record.UpdateTime.ToString("yyyy-MM-dd HH:mm:ss");
int coverId = furniture.StyleId;
int companyId = furniture.CompanyId;
var notshowdata = db.FStyleID.Where(o => o.CompanyId == companyId).Select(o => o.FStyleId).ToList();
FurnitureStyle preStyle = db.FurnitureStyle.OrderByDescending(item => item.Id).Where(item => item.Id > styleId && (item.StyleId == coverId && (item.CompanyId == companyId || (item.CreateUserId == 1 && !notshowdata.Contains(item.Id))))).OrderBy(item => item.Id).FirstOrDefault();
int pre = 0;
if (preStyle != null)
{
pre = 1;
}
int next = 0;
FurnitureStyle nextStyle = db.FurnitureStyle.OrderByDescending(item => item.Id).Where(item => item.Id < styleId && (item.StyleId == coverId && (item.CompanyId == companyId || (item.CreateUserId == 1 && !notshowdata.Contains(item.Id))))).FirstOrDefault();
if (nextStyle != null)
{
next = 1;
}
return(Json(new { pre = pre, data = furnitureStyleData, next = next }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetFurnitureDetails(int furnitureId)
{
FurnitureStyle furnitureStyle = db.FurnitureStyle.Find(furnitureId);
FurnitureStyleDetails furnitureDetail = new FurnitureStyleDetails();
furnitureDetail.FurnitureId = furnitureStyle.Id;
string[] args = furnitureStyle.StyleName.Split('&').ToArray();
furnitureDetail.FurnitureBrand = args[0];
furnitureDetail.FurnitureSize = args[1];
furnitureDetail.FurniturePrize = args[2];
furnitureDetail.FurnitureMaterial = args[3];
furnitureDetail.FurniturePic = ConfigurationManager.AppSettings["ResourceUrl"] + furnitureStyle.FurniturePics;
return(Json(new { data = furnitureDetail }, JsonRequestBehavior.AllowGet));
}
public ActionResult ShowData(int styid, int state)
{
if (Session["admin"] != null)
{
if (state == 0)
{
FStyleID fstyleid = new FStyleID();
fstyleid.CompanyId = getSession.CompanyId;
fstyleid.FStyleId = styid;
db.FStyleID.Add(fstyleid);
db.SaveChanges();
}
else
{
FStyleID fstyleid = db.FStyleID.Where(o => o.FStyleId == styid && o.CompanyId == getSession.CompanyId).FirstOrDefault();
db.FStyleID.Remove(fstyleid);
db.SaveChanges();
}
FurnitureStyle furniture = db.FurnitureStyle.Find(styid);
string styleId = furniture.StyleId.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);
}
db.SaveChanges();
return(RedirectToAction("Shield", "Furniture"));
}
else
{
return(RedirectToAction("Login", "Console"));
}
}
public ActionResult GetScrollFurnitureDetail(int furnitureId, string action, int companyId)
{
FurnitureStyle furnitureStyle = db.FurnitureStyle.Find(furnitureId);
int coverId = furnitureStyle.StyleId;
var notshowdata = db.FStyleID.Where(o => o.CompanyId == companyId).Select(o => o.FStyleId).ToList();
if (action == "pre")
{
FurnitureStyle preStyle = db.FurnitureStyle.OrderByDescending(item => item.Id).Where(item => item.Id > furnitureId && (item.StyleId == coverId && (item.CompanyId == companyId || (item.CreateUserId == 1 && !notshowdata.Contains(item.Id))))).OrderBy(item => item.Id).FirstOrDefault();
if (preStyle != null)
{
FurnitureStyleDetails furnitureDetail = new FurnitureStyleDetails();
furnitureDetail.FurnitureId = preStyle.Id;
string[] args = preStyle.StyleName.Split('&').ToArray();
furnitureDetail.FurnitureBrand = args[0];
furnitureDetail.FurnitureSize = args[1];
furnitureDetail.FurniturePrize = args[2];
furnitureDetail.FurnitureMaterial = args[3];
furnitureDetail.FurniturePic = ConfigurationManager.AppSettings["ResourceUrl"] + preStyle.FurniturePics;
int preId = preStyle.Id;
FurnitureStyle prepreStyle = db.FurnitureStyle.OrderByDescending(item => item.Id).Where(item => item.Id > preId && (item.StyleId == coverId && (item.CompanyId == companyId || (item.CreateUserId == 1 && !notshowdata.Contains(item.Id))))).OrderBy(item => item.Id).FirstOrDefault();
int pre = 0;
if (prepreStyle != null)
{
pre = 1;
}
//FurnitureStyle nextStyle = db.FurnitureStyle.OrderByDescending(item => item.Id).Where(item => item.Id < preId && (item.StyleId == coverId && (item.CompanyId == companyId || (item.CreateUserId == 1 && !notshowdata.Contains(item.Id))))).OrderBy(item => item.Id).FirstOrDefault();
//int next = 0;
//if (nextStyle != null)
//{
// next = 1;
//}
return(Json(new { pre = pre, data = furnitureDetail, next = 1 }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { pre = 0, data = "", next = 1 }, JsonRequestBehavior.AllowGet));
}
}
else
{
FurnitureStyle nextStyle = db.FurnitureStyle.OrderByDescending(item => item.Id).Where(item => item.Id < furnitureId && (item.StyleId == coverId && (item.CompanyId == companyId || (item.CreateUserId == 1 && !notshowdata.Contains(item.Id))))).FirstOrDefault();
if (nextStyle != null)
{
FurnitureStyleDetails furnitureDetail = new FurnitureStyleDetails();
furnitureDetail.FurnitureId = nextStyle.Id;
string[] args = nextStyle.StyleName.Split('&').ToArray();
furnitureDetail.FurnitureBrand = args[0];
furnitureDetail.FurnitureSize = args[1];
furnitureDetail.FurniturePrize = args[2];
furnitureDetail.FurnitureMaterial = args[3];
furnitureDetail.FurniturePic = ConfigurationManager.AppSettings["ResourceUrl"] + nextStyle.FurniturePics;
int nextId = nextStyle.Id;
//FurnitureStyle preStyle = db.FurnitureStyle.OrderByDescending(item => item.Id).Where(item => item.Id > nextId && (item.StyleId == coverId && (item.CompanyId == companyId || (item.CreateUserId == 1 && !notshowdata.Contains(item.Id))))).OrderBy(item => item.Id).FirstOrDefault();
//int pre = 0;
//if (preStyle != null)
//{
// pre = 1;
//}
FurnitureStyle nextnextStyle = db.FurnitureStyle.OrderByDescending(item => item.Id).Where(item => item.Id < nextId && (item.StyleId == coverId && (item.CompanyId == companyId || (item.CreateUserId == 1 && !notshowdata.Contains(item.Id))))).OrderBy(item => item.Id).FirstOrDefault();
int next = 0;
if (nextnextStyle != null)
{
next = 1;
}
return(Json(new { pre = 1, data = furnitureDetail, next = next }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { pre = 1, data = "", next = 0 }, JsonRequestBehavior.AllowGet));
}
}
//FurnitureStyleDetails furnitureDetail = new FurnitureStyleDetails();
//furnitureDetail.FurnitureId = furnitureStyle.Id;
//string[] args = furnitureStyle.StyleName.Split('&').ToArray();
//furnitureDetail.FurnitureBrand = args[0];
//furnitureDetail.FurnitureSize = args[1];
//furnitureDetail.FurniturePrize = args[2];
//furnitureDetail.FurnitureMaterial = args[3];
//furnitureDetail.FurniturePic = ConfigurationManager.AppSettings["ResourceUrl"] + furnitureStyle.FurniturePics;
//int coverId = furnitureStyle.StyleId;
//var notshowdata = db.FStyleID.Where(o => o.CompanyId == companyId).Select(o => o.FStyleId).ToList();
//FurnitureStyle nextStyle = db.FurnitureStyle.OrderByDescending(item => item.Id).Where(item => item.Id < furnitureId && (item.StyleId == coverId && (item.CompanyId == companyId || (item.CreateUserId == 1 && !notshowdata.Contains(item.Id))))).FirstOrDefault();
}
