/// <summary>
/// 把Goods转换为数据库对象
/// </summary>
/// <param name="goods"></param>
/// <returns></returns>
private NewShop ConvertGoodsToEntity(Goods goods)
{
NewShop newShop = new NewShop();
newShop.ShopName = goods.Name;
newShop.ShopLei = goods.Category;
newShop.ShopMoney = goods.Price;
newShop.ShopPreMoney = goods.PrePrice;
newShop.IsSpecial = goods.isSpecial;
return(newShop);
}
/// <summary>
/// 把数据库对象转换为Goods
/// </summary>
/// <param name="newShop"></param>
/// <returns></returns>
private Goods ConvertEntityToGoods(NewShop newShop)
{
Goods goods = new Goods();
goods.Id = newShop.ShopID;
goods.Name = newShop.ShopName;
goods.Category = newShop.ShopLei;
goods.Price = newShop.ShopMoney;
goods.PrePrice = newShop.ShopPreMoney;
goods.isSpecial = newShop.IsSpecial;
return(goods);
}
public bool DeleteGoods(int id)
{
try
{
using (ShopPingEntities en = new ShopPingEntities())
{
NewShop newShop = en.NewShops.First(x => x.ShopID == id);
en.NewShops.Remove(newShop);
en.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool EditGoods(int id, Goods newGoods)
{
try
{
using (ShopPingEntities en = new ShopPingEntities())
{
NewShop newShop = en.NewShops.First(x => x.ShopID == id);
newShop.ShopName = newGoods.Name;
newShop.ShopLei = newGoods.Category;
newShop.ShopMoney = newGoods.Price;
newShop.ShopPreMoney = newGoods.PrePrice;
newShop.IsSpecial = newGoods.isSpecial;
en.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool AddGoods(Goods goods)
{
NewShop newShop = this.ConvertGoodsToEntity(goods);
try
{
using (ShopPingEntities en = new ShopPingEntities())
{
en.NewShops.Add(newShop);
en.SaveChanges();
}
return(true);
}
//数据库操作如果失败，
//可以想办法获取ex.Message并传到外部，
//这里简单屏蔽掉了
//下同
catch (Exception ex)
{
return(false);
}
}
