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