public void DeleteStaff(List <int> ids)
{
using (var dbContext = new OADbContext())
{
dbContext.Staffs.Where(u => ids.Contains(u.ID)).Delete();
}
}
public Branch GetBranch(int id)
{
using (var dbContext = new OADbContext())
{
return(dbContext.Find <Branch>(id));
}
}
public Staff GetStaff(int id)
{
using (var dbContext = new OADbContext())
{
return(dbContext.Staffs.Include("Branch").FirstOrDefault(a => a.ID == id));
}
}
/// <summary>
/// 返回树形组织结构，根节点RootBranch(id=0, ParentId=0)，其下Staff和Branch为未分配的，根节点下的第一个节点为TopBranch(id=1, ParantId=0)，其他ParentId=0的归为RootBranch下
/// </summary>
/// <returns></returns>
public Branch GetOrg()
{
using (var dbContext = new OADbContext())
{
var branchs = dbContext.Branchs.ToList();
var staffs = dbContext.Staffs.ToList();
var branch = new Branch();
AppendBranch(branchs, staffs, branch);
return(branch);
}
}
public void SaveBranch(Branch branch)
{
using (var dbContext = new OADbContext())
{
if (branch.ID > 0)
{
dbContext.Update <Branch>(branch);
}
else
{
dbContext.Insert <Branch>(branch);
}
}
}
public void SaveStaff(Staff staff)
{
using (var dbContext = new OADbContext())
{
if (staff.ID > 0)
{
dbContext.Update <Staff>(staff);
}
else
{
dbContext.Insert <Staff>(staff);
}
}
}
public IEnumerable <Branch> GetBranchList(BranchRequest request = null)
{
request = request ?? new BranchRequest();
using (var dbContext = new OADbContext())
{
IQueryable <Branch> branchs = dbContext.Branchs;
if (!string.IsNullOrEmpty(request.Name))
{
branchs = branchs.Where(u => u.Name.Contains(request.Name));
}
return(branchs.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize));
}
}
/// <summary>
/// 保存树形组织结构（刷全表数据/BatchUpdate），先取出来所有的Branch,Staff的ParentId为0，然后在根据RootBranch的树形结构赋对应的值
/// </summary>
/// <param name="rootBranch"></param>
public void SaveOrg(Branch rootBranch)
{
using (var dbContext = new OADbContext())
{
var branchs = dbContext.Branchs.ToList();
branchs.ForEach(b => b.ParentId = 0);
var staffs = dbContext.Staffs.ToList();
staffs.ForEach(s => s.BranchId = 0);
UpdateOrg(branchs, staffs, rootBranch);
dbContext.SaveChanges();
}
}
public static void SeedHostDb(OADbContext db)
{
if (db.Database.EnsureCreated())
{
//create seed data
var user = db.SysUsers.Where(m => m.UserName == "admin").FirstOrDefault();
if (user == null)
{
var sysUser = new SysUser
{
Password = Md5Helper.Encrypt("123456"),
UserName = "******",
NickName = "leo"
};
db.SysUsers.Add(sysUser);
db.SaveChanges();
}
}
}
public IEnumerable <Staff> GetStaffList(StaffRequest request = null)
{
request = request ?? new StaffRequest();
using (var dbContext = new OADbContext())
{
IQueryable <Staff> staffs = dbContext.Staffs.Include("Branch");
if (!string.IsNullOrEmpty(request.Name))
{
staffs = staffs.Where(u => u.Name.Contains(request.Name));
}
if (request.BranchId > 0)
{
staffs = staffs.Where(u => u.BranchId == request.BranchId);
}
return(staffs.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize));
}
}
public SysModuleService(OADbContext _db) : base(_db)
{
db = _db;
}
protected BaseRepository(OADbContext _context)
{
this.Context = _context;
}
public SysDepartmentService(OADbContext _db) : base(_db)
{
db = _db;
}
public UnitOfWork(OADbContext _context)
{
Context = _context;
}
public SysUserRoleService(OADbContext _db) : base(_db)
{
db = _db;
}
public OmsBlogCategoryRepository(OADbContext DbContext)
: base(DbContext)
{
}
public OmsBlogRepository(OADbContext oADbContext)
: base(oADbContext)
{
}
