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