public string AddDept()
{
try
{
var infoList =
JsonConvert.DeserializeObject <Dictionary <String, Object> >(HttpUtility.UrlDecode(Request.Form.ToString()));
var deptName = infoList["deptName"].ToString();
var deptFatherID = 0;
int.TryParse(infoList["detpFatherID"].ToString(), out deptFatherID);
var userID = Commen.GetUserFromSession().UserID;
Models.DeptInfo dept = new Models.DeptInfo();
dept.DeptFatherID = deptFatherID;
dept.DeptName = deptName;
dept.DeptOrder = 0;
dept.DeptState = 0;
dept.Open = 0;
dept.DeptCreateDate = DateTime.Now;
db.DeptInfo.Add(dept);
db.SaveChanges();
//添加单位的用户，默认拥有该单位的管理权限。
Models.UserDept userDept = new Models.UserDept();
userDept.DeptID = dept.DeptID;
userDept.UserID = userID;
db.UserDept.Add(userDept);
db.SaveChanges();
return("ok");
}
catch (Exception e)
{
return(e.Message);
}
}
public string Insert()
{
try
{
var infoList =
JsonConvert.DeserializeObject <Dictionary <String, Object> >(HttpUtility.UrlDecode(Request.Form.ToString()));
var userNum = infoList["userNum"].ToString();//员工编号
var userName = infoList["userName"].ToString();
var userEmail = infoList["userEmail"].ToString();
var deptID = 0;
int.TryParse(infoList["deptID"].ToString(), out deptID); //用户所在单位
var userDuty = infoList["userDuty"].ToString(); //职务
var userPhone = infoList["userPhone"].ToString(); //办公电话
var userMobile = infoList["userMobile"].ToString(); //手机
var userRemark = infoList["userRemark"].ToString();
//按员工编号userNum检查数据库中用户信息是否存在
Models.UserInfo userInfo = db.UserInfo.Where(w => w.UserNum == userNum).FirstOrDefault();
if (userInfo == null)//如果用户不存在，直接插入用户信息
{
#region 插入用户基本信息
userInfo = new Models.UserInfo();
userInfo.UserName = userName;
userInfo.UserNum = userNum;
userInfo.UserDuty = userDuty;
userInfo.UserState = 0;
userInfo.UserDeptID = deptID;
userInfo.UserEmail = userEmail == string.Empty ? null : userEmail;
userInfo.UserPhone = userPhone;
userInfo.UserRemark = userRemark;
userInfo.UserMobile = userMobile;
db.UserInfo.Add(userInfo);
db.SaveChanges();
#endregion
}
else//如果不存在用户信息，进一步判断用户是否删除。
{
var isDelUser = userInfo.UserState;
if (isDelUser == 0)//如果未删除，不能修改用户信息，返回用户已存在，不能修改。
{
return("用户信息已存在！");
}
else//如果已删除，更新用户信息，将用户状态更改为未删除状态，更新用户所在部门
{
#region 更新已标记删除用户的信息，将用户状态更改为未删除
userInfo.UserName = userName;
userInfo.UserDuty = userDuty;
userInfo.UserState = 0; //将用户状态更改为未删除
userInfo.UserDeptID = deptID; //将用户部门更改为选择的部门
userInfo.UserEmail = userEmail == string.Empty ? null : userEmail;
userInfo.UserPhone = userPhone;
userInfo.UserRemark = userRemark;
userInfo.UserMobile = userMobile;
db.SaveChanges();
#endregion
}
}
#region 除用户已经存在的权限和管理部门
var userDeptExist = db.UserDept.Where(w => w.UserID == userInfo.UserID).ToList();
if (userDeptExist.Count != 0)
{
db.UserDept.RemoveRange(userDeptExist);
}
var userRoleExist = db.UserRole.Where(w => w.UserID == userInfo.UserID).ToList();
if (userRoleExist != null)
{
db.UserRole.RemoveRange(userRoleExist);
}
db.SaveChanges();
#endregion
#region 添加用户所拥有的角色
Dictionary <string, object> roleList =
JsonConvert.DeserializeObject <Dictionary <String, Object> >(infoList["roleList"].ToString());
foreach (var item in roleList)
{
Models.UserRole userRole = new Models.UserRole();
var roleID = 0;
int.TryParse(item.Value.ToString(), out roleID);
userRole.RoleID = roleID;
userRole.UserID = userInfo.UserID;
db.UserRole.Add(userRole);
db.SaveChanges();
}
#endregion
#region 添加用户管理的部门
Dictionary <string, object> deptList =
JsonConvert.DeserializeObject <Dictionary <String, Object> >(infoList["deptList"].ToString());
foreach (var item in deptList)
{
Models.UserDept userDept = new Models.UserDept();
var deptIDManagerment = 0;
int.TryParse(item.Value.ToString(), out deptIDManagerment);
userDept.DeptID = deptIDManagerment;
userDept.UserID = userInfo.UserID;
db.UserDept.Add(userDept);
db.SaveChanges();
}
#endregion
return("ok");
}
catch (Exception e)
{
return(e.Message);
}
}
public string Update()
{
try
{
var infoList =
JsonConvert.DeserializeObject <Dictionary <String, Object> >(HttpUtility.UrlDecode(Request.Form.ToString()));
#region 修改用户基本信息,不修改用户的员工编号和用户所在的部门
var userID = 0;
int.TryParse(infoList["userID"].ToString(), out userID);
var userName = infoList["userName"].ToString();
var userEmail = infoList["userEmail"].ToString();
var userDuty = infoList["userDuty"].ToString();
var userPhone = infoList["userPhone"].ToString();
var userMobile = infoList["userMobile"].ToString();
var userRemark = infoList["userRemark"].ToString();
var userInfo = db.UserInfo.Find(userID);
userInfo.UserName = userName;
userInfo.UserEmail = userEmail;
userInfo.UserDuty = userDuty;
userInfo.UserPhone = userPhone;
userInfo.UserMobile = userMobile;
userInfo.UserRemark = userRemark;
db.SaveChanges();
#endregion
#region 除用户已经存在的权限和管理部门
var userDeptExist = db.UserDept.Where(w => w.UserID == userInfo.UserID).ToList();
if (userDeptExist.Count != 0)
{
db.UserDept.RemoveRange(userDeptExist);
}
var userRoleExist = db.UserRole.Where(w => w.UserID == userInfo.UserID).ToList();
if (userRoleExist != null)
{
db.UserRole.RemoveRange(userRoleExist);
}
db.SaveChanges();
#endregion
#region 添加用户所拥有的角色
Dictionary <string, object> roleList =
JsonConvert.DeserializeObject <Dictionary <String, Object> >(infoList["roleList"].ToString());
foreach (var item in roleList)
{
Models.UserRole userRole = new Models.UserRole();
var roleID = 0;
int.TryParse(item.Value.ToString(), out roleID);
userRole.RoleID = roleID;
userRole.UserID = userInfo.UserID;
db.UserRole.Add(userRole);
db.SaveChanges();
}
#endregion
#region 添加用户管理的部门
Dictionary <string, object> deptList =
JsonConvert.DeserializeObject <Dictionary <String, Object> >(infoList["deptList"].ToString());
foreach (var item in deptList)
{
Models.UserDept userDept = new Models.UserDept();
var deptIDManagerment = 0;
int.TryParse(item.Value.ToString(), out deptIDManagerment);
userDept.DeptID = deptIDManagerment;
userDept.UserID = userInfo.UserID;
db.UserDept.Add(userDept);
db.SaveChanges();
}
#endregion
return("ok");
}
catch (Exception ex)
{
return(ex.Message);
}
}
