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