/// <summary>
/// 增加一条汽车记录
/// </summary>
/// <param name="car">汽车实体</param>
/// <returns></returns>
public bool Add(DAO.PartsCategory car)
{
db.PartsCategory.Add(car);
int i = db.SaveChanges();
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
private List <PartCateModel> getChilder(DAO.PartsCategory p)
{
List <PartCateModel> Allcurr = new List <PartCateModel>();
string sql = "select * from PartsCategory where ParentID=" + p.ID;
List <DAO.PartsCategory> alllist = db.Database.SqlQuery <DAO.PartsCategory>(sql).ToList();
foreach (var item in alllist)
{
PartCateModel curr = new PartCateModel();
curr.currItem = item;
curr.Children = getChilder(item);
Allcurr.Add(curr);
}
return(Allcurr);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="car"></param>
/// <returns></returns>
public bool Update(DAO.PartsCategory car)
{
DAO.PartsCategory c = db.PartsCategory.Where(m => m.ID == car.ID).FirstOrDefault();
c.CategoryName = car.CategoryName;
c.ParentID = car.ParentID;
c.OrderBy = car.OrderBy;
c.IsShow = car.IsShow;
c.ICOPath = car.ICOPath;
db.Entry(c).State = System.Data.EntityState.Modified;
int result = db.SaveChanges();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
