示例#1
0
 /// <summary>
 /// 查询(按条件)
 /// </summary>
 /// <param name="predicate"></param>
 /// <returns></returns>
 public IList <TEntity> Get(Expression <Func <TEntity, bool> > predicate)
 {
     using (var ctx = new OpsManageDbContext(true))
     {
         return(ctx.Set <TEntity>().Where(predicate).ToList());
     }
 }
示例#2
0
 /// <summary>
 /// 查询(按条件)
 /// </summary>
 /// <param name="predicate"></param>
 /// <returns></returns>
 public async Task <IList <TEntity> > GetAsync(Expression <Func <TEntity, bool> > predicate)
 {
     using (var ctx = new OpsManageDbContext(true))
     {
         return(await ctx.Set <TEntity>().Where(predicate).ToListAsync());
     }
 }
示例#3
0
 /// <summary>
 /// 查询(按主键)
 /// </summary>
 /// <param name="keys"></param>
 /// <returns></returns>
 public async Task <TEntity> GetAsync(params object[] keys)
 {
     using (var ctx = new OpsManageDbContext(true))
     {
         return(await ctx.Set <TEntity>().FindAsync(keys));
     }
 }
示例#4
0
 /// <summary>
 /// 查询(按主键)
 /// </summary>
 /// <param name="keys"></param>
 /// <returns></returns>
 public TEntity Get(params object[] keys)
 {
     using (var ctx = new OpsManageDbContext(true))
     {
         return(ctx.Set <TEntity>().Find(keys));
     }
 }
示例#5
0
        /// <summary>
        /// 删除(按条件)
        /// </summary>
        /// <param name="predicate"></param>
        /// <returns></returns>
        public bool Remove(Expression <Func <TEntity, bool> > predicate)
        {
            var result = false;

            using (var ctx = new OpsManageDbContext())
            {
                var items = ctx.Set <TEntity>().Where(predicate).ToList();
                ctx.Set <TEntity>().RemoveRange(items);
                var effectedRows = ctx.SaveChanges();
                if (effectedRows > 0)
                {
                    result = true;
                }
            }

            return(result);
        }
示例#6
0
 /// <summary>
 /// 更新
 /// </summary>
 /// <param name="entity"></param>
 /// <returns></returns>
 public async Task <bool> UpdateAsync(TEntity entity)
 {
     using (var ctx = new OpsManageDbContext())
     {
         ctx.Set <TEntity>().Update(entity);
         return(await ctx.SaveChangesAsync() > 0);
     }
 }
示例#7
0
        /// <summary>
        /// 删除(按条件)
        /// </summary>
        /// <param name="predicate"></param>
        /// <returns></returns>
        public async Task <bool> RemoveAsync(Expression <Func <TEntity, bool> > predicate)
        {
            using (var ctx = new OpsManageDbContext())
            {
                var entity = ctx.Set <TEntity>();
                var items  = await entity.Where(predicate).ToListAsync();

                entity.RemoveRange(items);
                return(await ctx.SaveChangesAsync() > 0);
            }
        }
示例#8
0
        public bool UpdateSpecificProperty(TEntity entity, params Expression <Func <TEntity, object> >[] propertyExpression)
        {
            using (var ctx = new OpsManageDbContext())
            {
                ctx.Set <TEntity>().Attach(entity);
                foreach (Expression <Func <TEntity, Object> > expression in propertyExpression)
                {
                    ctx.Entry(entity).Property(expression).IsModified = true;
                }

                return(ctx.SaveChanges() > 0);
            }
        }
示例#9
0
        /// <summary>
        /// 更新
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        public bool Update(TEntity entity)
        {
            var result = false;

            using (var ctx = new OpsManageDbContext())
            {
                ctx.Set <TEntity>().Update(entity);
                var effectedRows = ctx.SaveChanges();
                if (effectedRows > 0)
                {
                    result = true;
                }
            }

            return(result);
        }
示例#10
0
        /// <summary>
        /// 批量新增
        /// </summary>
        /// <param name="entities"></param>
        /// <returns></returns>
        public bool Add(IList <TEntity> entities)
        {
            var result = false;

            using (var ctx = new OpsManageDbContext())
            {
                ctx.Set <TEntity>().AddRange(entities);
                var effectedRows = ctx.SaveChanges();
                if (effectedRows > 0)
                {
                    result = true;
                }
            }

            return(result);
        }
示例#11
0
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public virtual IPagingResult <TEntity> PagingGet(PagingParameter <TEntity> param)
        {
            using (var ctx = new OpsManageDbContext(true))
            {
                var query = ctx.Set <TEntity>().Where(param.WherePredicate);
                if (param.OrderByPredicate != null)
                {
                    if (param.OrderByType == Enums.OrderByType.DESC)
                    {
                        query = query.OrderByDescending(param.OrderByPredicate);
                    }
                    else
                    {
                        query = query.OrderBy(param.OrderByPredicate);
                    }
                }

                return(query.Paging(param.PageIndex, param.PageSize));
            }
        }