/// <summary>
/// 删除数据
/// </summary>
/// <param name="paraTb_Good"></param>
/// <returns>true：删除成功，false：不存在该记录</returns>
public bool deleteMode(tb_Good paraTb_Good)
{
if(paraTb_Good == null)
throw new ArgumentNullException("paraTb_Good");
try
{
var query = from p in _context.tb_Good
where p.GoodId == paraTb_Good.GoodId
select p;
if (query.ToList().Count<1)
{
return false;
}
else
{
foreach(var model in query.ToList())
{
if(!_context.IsAttached(model))
_context.tb_Good.Attach(model);
_context.tb_Good.DeleteObject(model);
_context.SaveChanges();
}
return true;
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="paraTb_Good"></param>
/// <returns>true：插入成功，false：已存在该记录</returns>
public bool addMode(tb_Good paraTb_Good)
{
if(paraTb_Good == null)
throw new ArgumentNullException("paraTb_Good");
try
{
var query = from p in _context.tb_Good
where p.GoodId == paraTb_Good.GoodId
select p;
if (query.ToList().Count() > 0)
{
return false;
}
else
{
_context.tb_Good.AddObject(paraTb_Good);
_context.SaveChanges();
return true;
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 用于向 tb_Good EntitySet 添加新对象的方法，已弃用。请考虑改用关联的 ObjectSet<T> 属性的 .Add 方法。
/// </summary>
public void AddTotb_Good(tb_Good tb_Good)
{
base.AddObject("tb_Good", tb_Good);
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="paraTb_Good"></param>
/// <returns>true：更新成功，false：更新数据失败，不存在该记录！</returns>
public bool updateMode(tb_Good paraTb_Good)
{
if(paraTb_Good == null)
throw new ArgumentNullException("paraTb_Good");
try
{
var oldEntity = (from p in _context.tb_Good
where p.GoodId == paraTb_Good.GoodId
select p).FirstOrDefault();
if (oldEntity == null)
{
return false;
}
else
{
_context.ApplyCurrentValues(oldEntity.GetType().Name, paraTb_Good);
_context.SaveChanges();
return true;
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 创建新的 tb_Good 对象。
/// </summary>
/// <param name="goodId">GoodId 属性的初始值。</param>
public static tb_Good Createtb_Good(global::System.Int32 goodId)
{
tb_Good tb_Good = new tb_Good();
tb_Good.GoodId = goodId;
return tb_Good;
}