/// <summary> /// 根据ID获取一个实体 /// </summary> /// <param name="id"></param> /// <returns></returns> public SysLog GetById(string id) { using (DBContainer db = new DBContainer()) { return db.SysLog.SingleOrDefault(a => a.Id == id); } }
/// <summary> /// 创建菜单组 /// </summary> /// <param name="entity">菜单组</param> /// <returns></returns> public int CreateMenuGroup(MenuGroup entity) { using (DBContainer db = new DBContainer()) { db.MenuGroup.AddObject(entity); return db.SaveChanges(); } }
/// <summary> /// 创建一个实体 /// </summary> /// <param name="entity">实体</param> /// <returns></returns> public int Create(Entity.SysSample entity) { using (DBContainer db = new DBContainer()) { db.SysSample.AddObject(entity); return db.SaveChanges(); } }
/// <summary> /// 新增系统功能 /// </summary> /// <param name="entity">系统功能</param> /// <returns></returns> public int CreateSysFunction(Entity.SysFunction entity) { using (DBContainer db = new DBContainer()) { db.SysFunction.AddObject(entity); return db.SaveChanges(); } }
/// <summary> /// 创建一个对象 /// </summary> /// <param name="db">数据库</param> /// <param name="entity">实体</param> public int Create(SysLog entity) { using (DBContainer db = new DBContainer()) { db.SysLog.AddObject(entity); return db.SaveChanges(); } }
/// <summary> /// 更新一个实体 /// </summary> /// <param name="entity">实体</param> /// <returns></returns> public int Edit(Entity.SysSample entity) { using (DBContainer db = new DBContainer()) { db.SysSample.Attach(entity); db.ObjectStateManager.ChangeObjectState(entity, EntityState.Modified); return db.SaveChanges(); } }
/// <summary> /// 删除对象集合 /// </summary> /// <param name="db">数据库</param> /// <param name="deleteCollection">集合</param> public void Delete(DBContainer db, string[] deleteCollection) { IQueryable<SysLog> collection = from f in db.SysLog where deleteCollection.Contains(f.Id) select f; foreach (var deleteItem in collection) { db.SysLog.DeleteObject(deleteItem); } }
/// <summary> /// 删除一个实体 /// </summary> /// <param name="id">id</param> /// <returns></returns> public int Delete(string id) { using (DBContainer db = new DBContainer()) { var entity = db.SysSample.SingleOrDefault(p => p.Id.Equals(id)); if (entity != null) { db.SysSample.DeleteObject(entity); } return db.SaveChanges(); } }
/// <summary> /// 删除菜单 /// </summary> /// <param name="id">菜单Id</param> /// <returns></returns> public int DeleteMenu(string id) { using (DBContainer db = new DBContainer()) { var entity = db.Menu.SingleOrDefault(p => p.Menu_Id.Equals(id, StringComparison.CurrentCultureIgnoreCase)); if (entity != null) db.Menu.DeleteObject(entity); return db.SaveChanges(); } }
/// <summary> /// 获取菜单组列表 /// </summary> /// <param name="db">数据上下文</param> /// <returns></returns> public IQueryable<MenuGroup> GetMenuGroupList(DBContainer db) { return db.MenuGroup.AsQueryable<MenuGroup>(); }
/// <summary> /// 获取数据列表 /// </summary> /// <returns>数据列表</returns> public IQueryable<Entity.SysSample> GetList(DBContainer db) { IQueryable<SysSample> list = db.SysSample.AsQueryable(); return list; }
/// <summary> /// 实体是否存在 /// </summary> /// <param name="id">id</param> /// <returns></returns> public bool IsExist(string id) { using (DBContainer db = new DBContainer()) { return db.SysSample.Count(p => p.Id.Equals(id)) > 0; } }
/// <summary> /// 获取集合 /// </summary> /// <param name="db">数据库</param> /// <returns>集合</returns> public IQueryable<SysLog> GetList(DBContainer db) { IQueryable<SysLog> list = db.SysLog.AsQueryable(); return list; }
/// <summary> /// 获取菜单列表 /// </summary> /// <param name="db">数据上下文</param> /// <returns></returns> public IQueryable<Menu> GetMenuList(DBContainer db) { return db.Menu.AsQueryable<Menu>(); }
/// <summary> /// 获取系统功能 /// </summary> /// <param name="id">系统功能Id</param> /// <returns></returns> public Entity.SysFunction GetSysFunctionById(string id) { using (DBContainer db = new DBContainer()) { return db.SysFunction.SingleOrDefault(p => p.SysFunction_Id.Equals(id, StringComparison.CurrentCultureIgnoreCase)); } }
/// <summary> /// 获取菜单组 /// </summary> /// <param name="id">菜单组Id</param> /// <returns></returns> public MenuGroup GetMenuGroupById(string id) { using (DBContainer db = new DBContainer()) { return db.MenuGroup.SingleOrDefault(p => p.MenuGroup_Id.Equals(id, StringComparison.CurrentCultureIgnoreCase)); } }
/// <summary> /// 获取系统功能列表 /// </summary> /// <param name="db">数据上下文</param> /// <returns>系统功能</returns> public IQueryable<Entity.SysFunction> GetSysFunctionList(DBContainer db) { return db.SysFunction.AsQueryable<Entity.SysFunction>(); }
/// <summary> /// 获取一个实体 /// </summary> /// <param name="id">id</param> /// <returns></returns> public Entity.SysSample GetById(string id) { using (DBContainer db = new DBContainer()) { return db.SysSample.FirstOrDefault(p => p.Id.Equals(id)); } }
/// <summary> /// 更新菜单组 /// </summary> /// <param name="entity">菜单组</param> /// <returns></returns> public int EditMenuGroup(MenuGroup entity) { using (DBContainer db = new DBContainer()) { db.MenuGroup.Attach(entity); db.ObjectStateManager.ChangeObjectState(entity, EntityState.Modified); return db.SaveChanges(); } }