/// <summary> /// 获取分页集合(有条件无排序) /// </summary> /// <returns></returns> public List <T> GetListPaged <T, Tkey>(int pageIndex, int pageSize, Expression <Func <T, bool> > seleWhere, out int totalcount) where T : class { using (SysDb <T> db = new SysDb <T>(strConn)) { totalcount = db.Set <T>().AsExpandable().Where(seleWhere).Count();//获取总数 //需要增加AsExpandable(),否则查询的是所有数据到内存,然后再排序 AsExpandable是linqkit.dll中的方法 return(db.Set <T>().AsExpandable().Where(seleWhere).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList()); } }
/// <summary> /// 获取分页集合(无条件多字段排序) /// </summary> /// <returns></returns> public List <T> GetListPaged <T>(int pageIndex, int pageSize, out int totalcount, params OrderModelField[] orderByExpression) where T : class { using (SysDb <T> db = new SysDb <T>(strConn)) { totalcount = db.Set <T>().AsExpandable().Count();//获取总数 //需要增加AsExpandable(),否则查询的是所有数据到内存,然后再排序 AsExpandable是linqkit.dll中的方法 return(CommonSort(db.Set <T>().AsExpandable(), orderByExpression).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList()); } }
/// <summary> /// 查找单个 /// </summary> /// <param name="seleWhere">查询条件</param> /// <returns></returns> public T GetSingle <T>(Expression <Func <T, bool> > seleWhere) where T : class { using (SysDb <T> db = new SysDb <T>(strConn)) { return(db.Set <T>().AsExpandable().FirstOrDefault(seleWhere)); } }
/// <summary> /// 查找单个 /// </summary> /// <param name="id">主键</param> /// <returns></returns> public T GetSingleById <T>(int id) where T : class { using (SysDb <T> db = new SysDb <T>(strConn)) { return(db.Set <T>().Find(id)); } }
/// <summary> /// 根据条件查询实体集合(多个字段排序) /// </summary> /// <param name="seleWhere">查询条件 lambel表达式</param> /// <returns></returns> public List <T> GetList <T>(Expression <Func <T, bool> > seleWhere, params OrderModelField[] orderByExpression) where T : class { using (SysDb <T> db = new SysDb <T>(strConn)) { return(CommonSort(db.Set <T>().AsExpandable().Where(seleWhere), orderByExpression).ToList()); } }
/// <summary> /// 根据条件查询实体集合(单个字段排序) /// </summary> /// <param name="seleWhere">查询条件 lambel表达式</param> /// <returns></returns> public List <T> GetList <T, Tkey>(Expression <Func <T, bool> > seleWhere, Expression <Func <T, Tkey> > orderWhere, bool isDesc) where T : class { using (SysDb <T> db = new SysDb <T>(strConn)) { return(CommonSort(db.Set <T>().AsExpandable().Where(seleWhere), orderWhere, isDesc).ToList()); } }
/// <summary> /// 根据条件查询实体集合 /// </summary> /// <param name="seleWhere">查询条件 lambel表达式</param> /// <returns></returns> public List <T> GetList <T, TValue>(Expression <Func <T, TValue> > seleWhere, IEnumerable <TValue> conditions) where T : class { using (SysDb <T> db = new SysDb <T>(strConn)) { return(db.Set <T>().AsExpandable().WhereIn <T, TValue>(seleWhere, conditions).ToList()); } }
/// <summary> /// 根据条件查询实体集合 /// </summary> /// <param name="seleWhere">查询条件 lambel表达式</param> /// <returns></returns> public List <T> GetList <T>(Expression <Func <T, bool> > seleWhere) where T : class { using (SysDb <T> db = new SysDb <T>(strConn)) { return(db.Set <T>().AsExpandable().Where(seleWhere).ToList()); } }
/// <summary> /// 获取所有实体集合(多个排序) /// </summary> /// <returns></returns> public List <T> GetAll <T>(params OrderModelField[] orderByExpression) where T : class { using (SysDb <T> db = new SysDb <T>(strConn)) { return(CommonSort(db.Set <T>().AsExpandable(), orderByExpression).ToList()); } }
/// <summary> /// 获取所有实体集合 /// </summary> /// <returns></returns> public List <T> GetAll <T>() where T : class { using (SysDb <T> db = new SysDb <T>(strConn)) { return(db.Set <T>().AsExpandable().ToList <T>()); } }
/// <summary> /// 根据条件删除 /// </summary> /// <param name="deleWhere">删除条件</param> /// <returns>返回受影响行数</returns> public bool DeleteByConditon <T>(Expression <Func <T, bool> > deleWhere) where T : class { using (SysDb <T> db = new SysDb <T>(strConn)) { List <T> entitys = db.Set <T>().Where(deleWhere).ToList(); entitys.ForEach(m => db.Entry <T>(m).State = EntityState.Deleted); return(db.SaveChanges() > 0); } }
/// <summary> /// 删除 /// </summary> /// <param name="entity">实体</param> /// <returns>返回受影响行数</returns> public bool Delete <T>(T entity) where T : class { using (SysDb <T> db = new SysDb <T>(strConn)) { db.Set <T>().Attach(entity); db.Entry <T>(entity).State = EntityState.Deleted; return(db.SaveChanges() > 0); } }