# 每章的素材能不能发一下 #

# 1 #

# FlowerEntities1 db = new FlowerEntities1();

public ActionResult Index()
{
return View();
}
/// <summary>
/// 查询方法
/// </summary>
/// <param name="sort"></param>
/// <param name="order"></param>
/// <returns></returns>
public ActionResult Select(string sort="FlowerID",string order="desc")
{
var flower = db.Flower.AsQueryable();
if (order == "desc")
{
switch (sort)
{
case "FlowerID":
flower = flower.OrderByDescending(f => f.FlowerID);
break;
case "FlowerName":
flower = flower.OrderByDescending(f => f.FlowerName);
break;
case "Price":
flower = flower.OrderByDescending(f => f.Price);
break;
case "season":
flower = flower.OrderByDescending(f => f.season);
break;
case "color":
flower = flower.OrderByDescending(f => f.color);
break;
}
}
else
{
switch (sort)
{
case "FlowerID":
flower = flower.OrderBy(f => f.FlowerID);
break;
case "FlowerName":
flower = flower.OrderBy(f => f.FlowerName);
break;
case "Price":
flower = flower.OrderBy(f => f.Price);
break;
case "season":
flower = flower.OrderBy(f => f.season);
break;
case "color":
flower = flower.OrderBy(f => f.color);
break;
}
}



return Json(flower, JsonRequestBehavior.AllowGet);
}

/// <summary>
/// 删除方法
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Del(int id)
{
var f = db.Flower.Find(id);
db.Flower.Remove(f);

int a = db.SaveChanges();

if (a == 1)
{
return Content("true");
}
else
{
return Content("false");
}
}


/// <summary>
/// 修改方法
/// </summary>
/// <param name="f"></param>
/// <returns></returns>
public ActionResult Update(Flower f)
{
var hua = db.Flower.Find(f.FlowerID);
hua.FlowerName = f.FlowerName;
hua.Price = f.Price;
hua.season = f.season;
hua.color = f.color;

int a= db.SaveChanges();

if (a==1)
{
return Content("true");
}
else
{
return Content("false");
}

}
}
} #

# 求解决 #