public OperateResult Update(AssessmentInfo model)
{
using (SystemDB db = new SystemDB())
{
try
{
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(new OperateResult
{
status = OperateStatus.Success,
content = "更新成功"
});
}
catch (Exception ex)
{
return(new OperateResult
{
content = ex.Message,
});
}
}
}
public static OperateResult Update(AssessmentInfo model)
{
try
{
using (SystemDB db = new SystemDB())
{
model.inputDate = DateTime.Now;
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
LogManager.Add(new LogRecord
{
userId = SessionHelper.GetUserId(),
time = DateTime.Now,
type = "Info",
content = "修改考核:" + model.billSerial
});
return(new OperateResult
{
status = OperateStatus.Success,
content = "更新成功"
});
}
}
catch (Exception ex)
{
return(new OperateResult
{
content = Model.Utility.Utility.GetExceptionMsg(ex),
});
}
}
public static OperateResult ModifyPasswd(long id, string pwdOld, string pwd)
{
try
{
using (SystemDB db = new SystemDB())
{
var element = (from m in db.userList
where id == m.id
select m
).FirstOrDefault();
if (element == null)
{
return(new OperateResult
{
content = "访问错误",
});
}
if (element.passwd != MD5Encode.Encode16(pwdOld))
{
return(new OperateResult
{
content = "原密码错误",
});
}
element.passwd = MD5Encode.Encode16(pwd);
db.Entry(element).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
LogManager.Add(new LogRecord
{
userId = SessionHelper.GetUserId(),
time = DateTime.Now,
type = "Info",
content = "重置密码:" + element.name
});
return(new OperateResult
{
status = OperateStatus.Success,
content = "更新成功"
});
}
}
catch (Exception ex)
{
return(new OperateResult
{
content = Model.Utility.Utility.GetExceptionMsg(ex),
});
}
}
public static OperateResult Update(Department model)
{
try
{
using (SystemDB db = new SystemDB())
{
var elements = (from e in db.departmentList
where e.id != model.id && e.name == model.name
select e
).ToList();
if (elements.Count() >= 1)
{
return(new OperateResult
{
content = "已经存在同名的部门",
});
}
var matchs = (from e in db.departmentList
where e.id == model.parentId && e.parentId == model.id
select e
).ToList();
if (matchs.Count() >= 1)
{
return(new OperateResult
{
content = "该部门与其上级部门互为上下部门",
});
}
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
LogManager.Add(new LogRecord
{
userId = SessionHelper.GetUserId(),
time = DateTime.Now,
type = "Info",
content = "修改部门：" + model.name
});
return(new OperateResult
{
status = OperateStatus.Success,
content = "更新成功"
});
}
}
catch (Exception ex)
{
return(new OperateResult
{
content = Model.Utility.Utility.GetExceptionMsg(ex),
});
}
}
/// <summary>
/// 先移除role所有的权限，然后重新加入
/// </summary>
/// <param name="roleId"></param>
/// <param name="idList"></param>
/// <returns></returns>
public static OperateResult AssignRight(long roleId, List <long> idList)
{
try
{
using (SystemDB db = new SystemDB())
{
var role = (from e in db.roleList.Include("rightList")
where e.id == roleId
select e).FirstOrDefault();
if (role == null)
{
return(new OperateResult
{
content = "找不到角色"
});
}
role.rightList.Clear();
foreach (var rid in idList)
{
var model = db.rightList.Find(rid);
role.rightList.Add(model);
}
db.Entry(role).State = EntityState.Modified;
//db.Configuration.ValidateOnSaveEnabled = false;
db.SaveChanges();
//db.Configuration.ValidateOnSaveEnabled = true;
LogManager.Add(new LogRecord
{
userId = SessionHelper.GetUserId(),
time = DateTime.Now,
type = "Info",
content = "分配权限：" + role.name
});
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 (SystemDB db = new SystemDB())
{
try
{
var element = db.departmentList.Find(id);
var elements = db.departmentList.ToList();
if (element == null)
{
return(new OperateResult
{
content = "不存在该部门",
});
}
var query = from e in elements
where e.parentId == element.id
select e;
if (query.Count() > 0)
{
return(new OperateResult
{
content = "该部门存在下级部门，不能删除",
});
}
db.departmentList.Remove(element);
db.Entry(element).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
LogManager.Add(new LogRecord
{
userId = SessionHelper.GetUserId(),
time = DateTime.Now,
type = "Info",
content = "删除用户:" + element.name
});
return(new OperateResult
{
status = OperateStatus.Success,
content = "删除成功"
});
}
catch (Exception ex)
{
return(new OperateResult
{
content = ex.Message,
});
}
}
}
public OperateResult Update(User model)
{
using (SystemDB db = new SystemDB())
{
try
{
var element = (from e in db.userList
where e.id != model.id && e.name == model.name
select e
).FirstOrDefault();
if (element != null)
{
return(new OperateResult
{
content = "已经存在同名",
});
}
element = (from e in db.userList
where e.id == model.id
select e
).AsNoTracking().FirstOrDefault();
model.passwd = element.passwd;
db.Configuration.ValidateOnSaveEnabled = false;
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
LogManager.Add(new LogRecord
{
userId = SessionHelper.GetUserId(),
time = DateTime.Now,
type = "Info",
content = "修改用户:" + model.name
});
return(new OperateResult
{
status = OperateStatus.Success,
content = "更新成功"
});
}
catch (Exception ex)
{
return(new OperateResult
{
content = ex.Message,
});
}
}
}
public OperateResult Lock(long id)
{
using (SystemDB db = new SystemDB())
{
try
{
var element = (from m in db.userList
where id == m.id
select m
).FirstOrDefault();
if (element == null)
{
return(new OperateResult
{
content = "访问错误",
});
}
element.status = "锁定";
db.Entry(element).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
LogManager.Add(new LogRecord
{
userId = SessionHelper.GetUserId(),
time = DateTime.Now,
type = "Info",
content = "锁定用户:" + element.name
});
return(new OperateResult
{
status = OperateStatus.Success,
content = "更新成功"
});
}
catch (Exception ex)
{
return(new OperateResult
{
content = ex.Message,
});
}
}
}
public static OperateResult Update(Company model)
{
try
{
using (SystemDB db = new SystemDB())
{
var element = (from e in db.companyList
where e.id == model.id
select e
).AsNoTracking().FirstOrDefault();
if (element == null)
{
return(new OperateResult
{
content = "访问错误",
});
}
var elements = (from e in db.companyList
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 Update(Module model)
{
using (SystemDB db = new SystemDB())
{
try
{
var elements = (from e in db.moduleList
where e.id != model.id && e.name == model.name
select e
).ToList();
if (elements.Count() >= 1)
{
return(new OperateResult
{
content = "已经存在同名的模块",
});
}
var matchs = (from e in db.moduleList
where e.id == model.parentId && e.parentId == model.id
select e
).ToList();
if (matchs.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 OperateResult AssignRight(long roleId, List <long> idList)
{
using (SystemDB db = new SystemDB())
{
try
{
var role = (from e in db.roleList.Include("rightList")
where e.id == roleId
select e).FirstOrDefault();
if (role != null)
{
foreach (var rid in idList)
{
var model = db.rightList.Find(rid);
var query = (from e in role.rightList
where e.id == rid
select e).FirstOrDefault();
if (model != null && query == null)
{
role.rightList.Add(model);
}
}
}
db.Entry(role).State = EntityState.Modified;
//db.Configuration.ValidateOnSaveEnabled = false;
db.SaveChanges();
//db.Configuration.ValidateOnSaveEnabled = true;
return(new OperateResult
{
status = OperateStatus.Success,
content = "更新成功"
});
}
catch (Exception ex)
{
return(new OperateResult
{
content = ex.Message,
});
}
}
}
public OperateResult Remove(long id)
{
using (SystemDB db = new SystemDB())
{
try
{
var element = db.moduleList.Find(id);
var elements = db.moduleList.ToList();
if (element == null)
{
return(new OperateResult
{
content = "不存在该模块",
});
}
var query = from e in elements
where e.parentId == element.id
select e;
if (query.Count() > 0)
{
return(new OperateResult
{
content = "该模块存在下级模块，不能删除",
});
}
db.moduleList.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,
});
}
}
}
public static OperateResult Update(PerformanceInfo model)
{
try
{
using (SystemDB db = new SystemDB())
{
var elements = (from e in db.performanceInfoList
where e.id != model.id && e.code == model.code
select e
).ToList();
if (elements.Count() >= 1)
{
return(new OperateResult
{
content = "已经存在同名的绩效代码",
});
}
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
LogManager.Add(new LogRecord
{
userId = SessionHelper.GetUserId(),
time = DateTime.Now,
type = "Info",
content = "修改绩效：" + model.code
});
return(new OperateResult
{
status = OperateStatus.Success,
content = "更新成功"
});
}
}
catch (Exception ex)
{
return(new OperateResult
{
content = Model.Utility.Utility.GetExceptionMsg(ex),
});
}
}
public static OperateResult Remove(long id)
{
try
{
using (SystemDB db = new SystemDB())
{
var element = db.roleList.Find(id);
if (element == null)
{
return(new OperateResult
{
content = "不存在该记录",
});
}
db.roleList.Remove(element);
db.Entry(element).State = EntityState.Deleted;
db.SaveChanges();
LogManager.Add(new LogRecord
{
userId = SessionHelper.GetUserId(),
time = DateTime.Now,
type = "Info",
content = "删除角色：" + element.name
});
return(new OperateResult
{
status = OperateStatus.Success,
content = "删除成功"
});
}
}
catch (Exception ex)
{
return(new OperateResult
{
content = Model.Utility.Utility.GetExceptionMsg(ex),
});
}
}
public OperateResult Update(PerformanceInfo model)
{
using (SystemDB db = new SystemDB())
{
try
{
var elements = (from e in db.performanceInfoList
where e.id != model.id && e.code == model.code
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 Remove(long id)
{
try
{
using (SystemDB db = new SystemDB())
{
var element = db.companyList.Find(id);
var elements = db.companyList.ToList();
if (element == null)
{
return(new OperateResult
{
content = "不存在该公司",
});
}
db.companyList.Remove(element);
db.Entry(element).State = EntityState.Deleted;
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 (SystemDB db = new SystemDB())
{
try
{
var element = db.benefitInfoList.Find(id);
if (element == null)
{
return(new OperateResult
{
content = "不存在该绩效",
});
}
db.benefitInfoList.Remove(element);
db.Entry(element).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
return(new OperateResult
{
status = OperateStatus.Success,
content = "删除成功"
});
}
catch (Exception ex)
{
return(new OperateResult
{
content = ex.Message,
});
}
}
}
public OperateResult Login(User model)
{
using (SystemDB db = new SystemDB())
{
try
{
var passwd = MD5Encode.Encode16(model.passwd);
var element = (from e in db.userList.Include("role")
where e.passwd == passwd && e.name == model.name
select e
).FirstOrDefault();
if (element != null)
{
if (element.status == "锁定")
{
return(new OperateResult
{
content = "用户被锁定",
});
}
//更新最后一次登录
element.lastLogin = DateTime.Now;
if (element.status == "未激活")
{
element.status = "激活";
}
db.Entry(element).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
LogManager.Add(new LogRecord
{
userId = element.id,
time = DateTime.Now,
type = "Info",
content = "登录系统"
});
return(new OperateResult
{
status = OperateStatus.Success,
content = "登录成功",
data = element
});
}
return(new OperateResult
{
content = "用户名或密码不正确"
});
}
catch (Exception ex)
{
return(new OperateResult
{
content = ex.Message,
});
}
}
}
public static OperateResult UpdateStatus(long id, string status)
{
if (status != "未审核" && status != "已审核")
{
return(new OperateResult
{
content = "数据错误",
});
}
try
{
using (SystemDB db = new SystemDB())
{
//如果工资记录已经锁定，则不能再修改状态
var salary = (from s in db.salaryRecordList
where s.assessmentInfoId == id && s.status == "已审核"
select s).FirstOrDefault();
if (salary != null)
{
return(new OperateResult
{
content = "已经存在审核通过的工资记录，不能修改",
});
}
var element = (from m in db.assessmentInfoList
where id == m.id
select m
).AsNoTracking().FirstOrDefault();
if (element == null)
{
return(new OperateResult
{
content = "访问错误",
});
}
element.status = status;
db.Entry(element).State = EntityState.Modified;
db.SaveChanges();
LogManager.Add(new LogRecord
{
userId = SessionHelper.GetUserId(),
time = DateTime.Now,
type = "Info",
content = "修改状态:" + element.billSerial + ", " + element.status
});
return(new OperateResult
{
status = OperateStatus.Success,
});
}
}
catch (Exception ex)
{
return(new OperateResult
{
content = Model.Utility.Utility.GetExceptionMsg(ex),
});
}
}
