/// <summary>
/// 分页条件查询
/// </summary>
/// <typeparam name="T">类型</typeparam>
/// <param name="condition">表达式</param>
/// <param name="totalcount">总数</param>
/// <returns></returns>
public List <T> FindListByPage <T>(Expression <Func <T, bool> > condition, Pagination Pagination, out int totalcount) where T : class
{
var PageList = EfdDbContext.Set <T>().Where(condition);
totalcount = PageList.Count();
return(PageList.Skip((Pagination.Page - 1) * Pagination.PageSize).Take(Pagination.PageSize).ToList());
}
/// <summary>
/// 分页查询
/// </summary>
/// <typeparam name="T">类型</typeparam>
/// <param name="page">页数</param>
/// <param name="size">行数</param>
/// <param name="totalcount">总数</param>
/// <returns></returns>
public IQueryable <T> IQueryableByPage <T>(int page, int size, out int totalcount) where T : class
{
var PageData = EfdDbContext.Set <T>();
totalcount = PageData.Count();
return(PageData.Skip((page - 1) * size).Take(size));
}
/// <summary>
/// 分页查询
/// </summary>
/// <typeparam name="T">类型</typeparam>
/// <param name="page">页数</param>
/// <param name="size">行数</param>
/// <typeparam name="totalcount">总数</typeparam>
/// <returns></returns>
public List <T> FindListByPage <T>(int page, int size, out int totalcount) where T : class
{
var PageData = EfdDbContext.Set <T>();
totalcount = PageData.Count();
return(PageData.Skip((page - 1) * size).Take(size).ToList());
}
/// <summary>
/// 修改实体
/// </summary>
/// <typeparam name="T">类型</typeparam>
/// <param name="entity">实体</param>
/// <returns></returns>
public T UpdateEnetity <T>(T entity) where T : class
{
var EFEntity = EfdDbContext.Update(entity).Entity;
EfdDbContext.SaveChanges();
return(EFEntity);
}
/// <summary>
/// 分页条件查询
/// </summary>
/// <typeparam name="T">类型</typeparam>
/// <param name="condition">表达式</param>
/// <param name="Pagination">分页参数</param>
/// <param name="totalcount">总数</param>
/// <returns></returns>
public IQueryable <T> IQueryableByPage <T>(Expression <Func <T, bool> > condition, Pagination Pagination, out int totalcount) where T : class
{
var PageData = EfdDbContext.Set <T>();
totalcount = PageData.Count();
return(PageData.Where(condition).Skip((Pagination.Page - 1) * Pagination.PageSize).Take(Pagination.PageSize));
}
/// <summary>
/// 分页查询
/// </summary>
/// <typeparam name="T">类型</typeparam>
/// <typeparam name="totalcount">总数</typeparam>
/// <returns></returns>
public List <T> FindListByPage <T>(Pagination Pagination, out int totalcount) where T : class
{
var PageData = EfdDbContext.Set <T>();
totalcount = PageData.Count();
return(PageData.Skip((Pagination.Page - 1) * Pagination.PageSize).Take(Pagination.PageSize).ToList());
}
/// <summary>
/// 分页查询
/// </summary>
/// <typeparam name="T">类型</typeparam>
/// <param name="Pagination">分页参数</param>
/// <param name="totalcount">总数</param>
/// <returns></returns>
public IQueryable <T> IQueryableByPage <T>(Pagination Pagination, out int totalcount) where T : class
{
var PageData = EfdDbContext.Set <T>();
totalcount = PageData.Count();
return(PageData.Skip((Pagination.Page - 1) * Pagination.PageSize).Take(Pagination.PageSize));
}
/// <summary>
/// 异步批量增加
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="entity"></param>
/// <returns></returns>
public async Task <int> AddEntityListAsync <T>(List <T> entityList) where T : class
{
entityList.ForEach(async e =>
{
await EfdDbContext.Set <T>().AddAsync(e);
});
return(await EfdDbContext.SaveChangesAsync());
}
/// <summary>
/// 批量增加
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="entity"></param>
/// <returns></returns>
public int AddEntityList <T>(List <T> entityList) where T : class
{
entityList.ForEach(e =>
{
EfdDbContext.Set <T>().Add(e);
});
return(EfdDbContext.SaveChanges());
}
/// <summary>
/// 根据条件批量删除
/// </summary>
/// <typeparam name="T">实体</typeparam>
/// <param name="condition">条件</param>
/// <returns></returns>
public int DeleteEntityList <T>(Expression <Func <T, bool> > condition) where T : class
{
var entityList = EfdDbContext.Set <T>().Where(condition).ToList();
entityList.ForEach(e =>
{
EfdDbContext.Set <T>().Remove(e);
});
return(EfdDbContext.SaveChanges());
}
/// <summary>
/// 根据主键删除
/// </summary>
/// <typeparam name="T">类型</typeparam>
/// <param name="entity">实体</param>
/// <returns></returns>
public bool DeleteEntity <T>(T entity) where T : class
{
EfdDbContext.Set <T>().Attach(entity);
EfdDbContext.Set <T>().Remove(entity);
return(EfdDbContext.SaveChanges() > 0);
}
/// <summary>
/// 异步新增
/// </summary>
/// <typeparam name="T">类型</typeparam>
/// <param name="entity">实体</param>
/// <returns></returns>
public async Task <int> AddEntityAsync <T>(T entity) where T : class
{
await EfdDbContext.Set <T>().AddAsync(entity);
return(await EfdDbContext.SaveChangesAsync());
}
/// <summary> /// 条件查询 /// </summary> /// <typeparam name="T">类型</typeparam> /// <param name="condition">表达式</param> /// <returns></returns> public IQueryable <T> IQueryable <T>(Expression <Func <T, bool> > condition) where T : class => EfdDbContext.Set <T>().Where(condition);
/// <summary>
/// 释放上下文
/// </summary>
public void Dispose()
{
EfdDbContext.Dispose();
}
/// <summary> /// 条件查询 /// </summary> /// <typeparam name="T">类型</typeparam> /// <param name="condition">表达式</param> /// <returns></returns> public List <T> FindList <T>(Expression <Func <T, bool> > condition) where T : class => EfdDbContext.Set <T>().Where(condition).ToList();
/// <summary> /// 查询全部 /// </summary> /// <typeparam name="T">类型</typeparam> /// <returns></returns> public List <T> FindList <T>() where T : class => EfdDbContext.Set <T>().ToList();
/// <summary> /// 根据表达式查询单个 /// </summary> /// <typeparam name="condition">表达式</typeparam> /// <returns></returns> public T Find <T>(Expression <Func <T, bool> > condition) where T : class => EfdDbContext.Set <T>().Where(condition).FirstOrDefault();
/// <summary>
/// 批量修改
/// </summary>
/// <typeparam name="T">类型</typeparam>
/// <param name="entity">实体</param>
/// <returns></returns>
public List <T> UpdateEnetityList <T>(List <T> entity) where T : class
{
return(EfdDbContext.Update(entity).Entity);
}
/// <summary> /// 查询全部 /// </summary> /// <typeparam name="T">类型</typeparam> /// <returns></returns> public IQueryable <T> IQueryable <T>() where T : class => EfdDbContext.Set <T>();
/// <summary> /// 根据主键查询单个 /// </summary> /// <typeparam name="keyValue">主键</typeparam> /// <returns></returns> public T Find <T>(string keyValue) where T : class => EfdDbContext.Set <T>().Find(keyValue);
/// <summary> /// 获取总数 /// </summary> /// <typeparam name="T">类型</typeparam> /// <param name="condition">表达式</param> /// <returns></returns> public int GetListCount <T>(Expression <Func <T, bool> > condition) where T : class => EfdDbContext.Set <T>().Where(condition).Count();
/// <summary> /// 根据主键查询单个(异步) /// </summary> /// <typeparam name="keyValue">主键</typeparam> /// <returns></returns> public async Task <T> FindAsync <T>(string keyValue) where T : class => await EfdDbContext.Set <T>().FindAsync(keyValue);
/// <summary>
/// 新增
/// </summary>
/// <typeparam name="T">类型</typeparam>
/// <param name="entity">实体</param>
/// <returns></returns>
public bool AddEntity <T>(T entity) where T : class
{
EfdDbContext.Set <T>().Add(entity);
return(EfdDbContext.SaveChanges() > 0);
}
