/// <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();
}
}
