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) { }