Пример #1
0
 /// <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;
     }
 }
Пример #2
0
 /// <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&lt;T&gt; 属性的 .Add 方法。
 /// </summary>
 public void AddTotb_User(tb_User tb_User)
 {
     base.AddObject("tb_User", tb_User);
 }
Пример #4
0
 /// <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;
 }