public OperateResult Add(FunctionRight model) { using (DbContextRoot db = new DbContextRoot()) { try { var match = from m in db.rightList where m.name.Equals(model.name) || m.url.Equals(model.url) select m; if (match.Count() > 0) { return(new OperateResult { content = "已经存在", }); } db.rightList.Add(model); db.SaveChanges(); return(new OperateResult { status = OperateStatus.Success, }); } catch (Exception ex) { return(new OperateResult { content = ex.Message, }); } } }
public OperateResult RemoveRegister(long id) { using (DbContextRoot db = new DbContextRoot()) { try { var element = db.companyRegisterList.Find(id); if (element == null) { return(new OperateResult { content = "不存在该部门", }); } db.companyRegisterList.Remove(element); db.Entry(element).State = EntityState.Deleted; var company = (from c in db.companyList where c.name == element.name select c).FirstOrDefault(); db.companyList.Remove(company); db.Entry(company).State = EntityState.Deleted; db.SaveChanges(); return(new OperateResult { status = OperateStatus.Success, content = "删除成功" }); } catch (Exception ex) { return(new OperateResult { content = ex.Message, }); } } }
public OperateResult AddRegister(CompanyRegister model) { using (DbContextRoot db = new DbContextRoot()) { try { var match = from m in db.companyRegisterList where m.name.Equals(model.name) || m.code.Equals(model.code) select m; if (match.Count() > 0) { return(new OperateResult { content = "该公司已经存在", }); } db.companyRegisterList.Add(model); Company c = new Company { name = model.name, code = model.code }; db.companyList.Add(c); db.SaveChanges(); return(new OperateResult { status = OperateStatus.Success, }); } catch (Exception ex) { return(new OperateResult { content = ex.Message, }); } } }
public OperateResult Update(FunctionRight model) { using (DbContextRoot db = new DbContextRoot()) { try { var elements = (from e in db.rightList where e.id != model.id && e.name == model.name select e ).ToList(); if (elements.Count() >= 1) { return(new OperateResult { content = "已经存在同名的部门", }); } db.Entry(model).State = EntityState.Modified; db.SaveChanges(); return(new OperateResult { status = OperateStatus.Success, content = "更新成功" }); } catch (Exception ex) { return(new OperateResult { content = ex.Message, }); } } }
public static OperateResult Update(CompanyRegister model) { try { using (DbContextRoot db = new DbContextRoot()) { var elements = (from e in db.companyRegisterList where e.id != model.id && e.name == model.name select e ).ToList(); if (elements.Count() >= 1) { return(new OperateResult { content = "已经存在同名的部门", }); } db.Entry(model).State = EntityState.Modified; db.SaveChanges(); return(new OperateResult { status = OperateStatus.Success, content = "更新成功" }); } } catch (Exception ex) { return(new OperateResult { content = Model.Utility.Utility.GetExceptionMsg(ex), }); } }
public OperateResult Remove(long id) { using (DbContextRoot db = new DbContextRoot()) { try { var element = db.rightList.Find(id); var elements = db.rightList.ToList(); if (element == null) { return(new OperateResult { content = "不存在条数据", }); } db.rightList.Remove(element); db.Entry(element).State = EntityState.Deleted; db.SaveChanges(); return(new OperateResult { status = OperateStatus.Success, content = "删除成功" }); } catch (Exception ex) { return(new OperateResult { content = ex.Message, }); } } }