// Получить список всех домашних работ (включая студента и/или преподователя или нет)
public IEnumerable <Homework> GetAllHomeworks(bool includeStudents = false, bool includeTeachers = false)
{
if (includeStudents)
{
if (includeTeachers)
{
return(context.Set <Homework>().Include(x => x.HomeworkStudent).Include(x => x.HomeworkTeacher).AsNoTracking().ToList());
}
else
{
return(context.Set <Homework>().Include(x => x.HomeworkStudent).AsNoTracking().ToList());
}
}
else
{
if (includeTeachers)
{
return(context.Set <Homework>().Include(x => x.HomeworkTeacher).AsNoTracking().ToList());
}
else
{
return(context.Homework.ToList());
}
}
}
public List <TResult> Select <TEntity, TResult>(Expression <Func <TEntity, bool> > wherePredicate = null, Expression <Func <TEntity, TResult> > selectPredicate = null, Func <IQueryable <TEntity>, IQueryable <TEntity> > include = null)
where TEntity : class, IEntity
{
using (EFDbContext context = new EFDbContext())
{
IQueryable <TEntity> query = context.Set <TEntity>();
if (include != null)
{
query = include(query);
}
if (wherePredicate != null)
{
return(query.Where(wherePredicate).Select(selectPredicate).ToList());
}
else
{
return(query.Select(selectPredicate).ToList());
}
}
}
public void AttachModified <TEntity>(TEntity entity) where TEntity : class
{
EFDbContext.Set <TEntity>().Attach(entity);
}
public void Insert <TEntity>(TEntity entity) where TEntity : class
{
EFDbContext.Set <TEntity>().Add(entity);
}
public BaseRepository(EFDbContext context)
{
this.DbSet = context.Set <TEntity>();
}
public EFRepository(EFDbContext applicationDbContext)
{
_applicationDbContext = applicationDbContext;
_entities = applicationDbContext.Set <T>();
}
/// <summary> /// 件数取得 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="model"></param> /// <returns></returns> public int GetCount <T>() where T : class => _db.Set <T>().AsNoTracking().Count();
public GenericRepository()
{
this._context = new EFDbContext();
this._dbSet = _context.Set <TEntity>();
}
public GenericRepository(EFDbContext context)
{
this.context = context;
this.dbSet = context.Set <TEntity>();
}
public async Task Delete(TEntity entity)
{
_dbContext.Set <TEntity>().Remove(entity);
await _dbContext.SaveChangesAsync();
}
public GenericRepository(EFDbContext context)
{
_context = context;
_table = _context.Set <TEntity>();
}
public async Task <TEntity> AddAsync <TEntity>(TEntity entity) where TEntity : class
{
context.Set <TEntity>().Add(entity);
await context.SaveChangesAsync();
return(entity);
}
public IQueryable <TModel> GetAll()
{
return(_context.Set <TModel>());
}
public async virtual Task <IList <TEntity> > FindAllBy(System.Linq.Expressions.Expression <Func <TEntity, bool> > predicate)
{
return(await context.Set <TEntity>().Where(predicate).ToListAsync());
}
public void AttachModified <TEntity>(TEntity entity) where TEntity : class
{
EFDbContext.Set <TEntity>().Attach(entity);
EFDbContext.Entry(entity).State = EntityState.Modified;
}
public void Delete <TEntity>(TEntity entity) where TEntity : class
{
EFDbContext.Set <TEntity>().Remove(entity);
}
public DbSet <TEntity> Get <TEntity>() where TEntity : class
{
return(_dbContext.Set <TEntity>());
}
public TEntity Get(Guid id)
{
return(_dbContext.Set <TEntity>().Find(id));
}
//======================================= Async ================================
public async Task <ICollection <TEntity> > GetAllAsync()
{
return(await _context.Set <TEntity>().ToListAsync());
}
public IQueryable <TEntity> Select <TEntity>() where TEntity : class
{
context.Database.Log = (s => System.Diagnostics.Debug.WriteLine(s));
return(context.Set <TEntity>());
}
public /*async Task*/ void Create(TEntity entity)
{
/*await*/ context.Set <TEntity>().Add/*Async*/ (entity);
/*await*/ context.SaveChanges/*Async*/ ();
}
public GenericRepository(EFDbContext context)
{
Context = context;
DbSet = context.Set <TEntity>();
}
public DataRepository()
{
//this.dbContext = _dbContext;
dbSet = dbContext.Set <TEntity>();
}
public IQueryable <TEntity> Query <TEntity>() where TEntity : class
{
return(EFDbContext.Set <TEntity>());
}
public void Initialize(EFDbContext context)
{
// Module
List <Module> modules = new List <Module>()
{
new Module()
{
Id = "MU01", Name = "用户管理", Catalog = UserManagerDefination.ServiceId, IsDeleted = false, LastDate = DateTime.Now
},
new Module()
{
Id = "MU02", Name = "部门管理", Catalog = UserManagerDefination.ServiceId, IsDeleted = false, LastDate = DateTime.Now
},
new Module()
{
Id = "MU03", Name = "岗位管理", Catalog = UserManagerDefination.ServiceId, IsDeleted = false, LastDate = DateTime.Now
},
new Module()
{
Id = "MU04", Name = "权限管理", Catalog = UserManagerDefination.ServiceId, IsDeleted = false, LastDate = DateTime.Now
},
new Module()
{
Id = "MU05", Name = "模块管理", Catalog = UserManagerDefination.ServiceId, IsDeleted = false, LastDate = DateTime.Now
}
};
DbSet <Module> moduleSet = context.Set <Module>();
moduleSet.AddOrUpdate <Module>(m => new { m.Id }, modules.ToArray());
// Role
List <Role> roles = new List <Role>()
{
new Role()
{
Id = "R01", Name = "角色01", Authority = "MU01MU02MU03", Description = "用户管理角色", IsDeleted = false, LastDate = DateTime.Now
},
new Role()
{
Id = "R02", Name = "角色02", Authority = "MU01MU03MU04", Description = "", IsDeleted = false, LastDate = DateTime.Now
},
new Role()
{
Id = "R03", Name = "角色03", Authority = "MU01MU02", Description = "", IsDeleted = false, LastDate = DateTime.Now
},
new Role()
{
Id = "R04", Name = "角色04", Authority = "MU01MU02MU03MU04", Description = "", IsDeleted = false, LastDate = DateTime.Now
},
new Role()
{
Id = "R05", Name = "角色05", Authority = "MU01MU02MU03MU04MU05", Description = "", IsDeleted = false, LastDate = DateTime.Now
}
};
DbSet <Role> roleSet = context.Set <Role>();
roleSet.AddOrUpdate <Role>(r => new { r.Id }, roles.ToArray());
// Account
List <Account> accounts = new List <Account>()
{
new Account()
{
Id = "ACC000", Name = "Admin", ShortName = "Admin", Password = "******", LastDate = DateTime.Now
},
new Account()
{
Id = "ACC001", Name = "Acc001", ShortName = "A001", Password = "******", LastDate = DateTime.Now
}
};
DbSet <Account> accountSet = context.Set <Account>();
accountSet.AddOrUpdate <Account>(a => new { a.Id }, accounts.ToArray());
// Department
List <Department> departments = new List <Department>()
{
new Department()
{
Id = "DEPART001", Name = "生产部", Description = "生产部门", LastDate = DateTime.Now
},
new Department()
{
Id = "DEPART002", Name = "销售部", Description = "销售部门", LastDate = DateTime.Now
},
new Department()
{
Id = "DEPART003", Name = "行政部", Description = "行政部门", LastDate = DateTime.Now
},
new Department()
{
Id = "DEPART004", Name = "财务部", Description = "财务部门", LastDate = DateTime.Now
}
};
DbSet <Department> departmentSet = context.Set <Department>();
departmentSet.AddOrUpdate <Department>(d => new { d.Id }, departments.ToArray());
// Save changes
try
{
context.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 添加数据
/// </summary>
public T Add(T model)
{
ObjEntity.Set <T>().Add(model);
ObjEntity.SaveChanges();
return(model);
}
