public ActionResult EditUserInfoCallBack(Models.Admin.MSUserInfoModel InModel)
{
string msg = "OK";
long userId = Converter.TryToInt64(InModel.UserId);
// 查询用户信息
Model.Admin.MSUserInfo userInfo = BLL.Admin.MSUserInfoBll.GetSingleUserInfo(userId);
if (userInfo == null)
{
return(Json(new { Message = "资料不存在，修改失败！" }));
}
// 修改用户信息
userInfo.RealName = InModel.RealName;
userInfo.Gender = InModel.Gender;
userInfo.Telephone = InModel.Telephone;
userInfo.QQ = InModel.QQ;
userInfo.Email = InModel.Email;
userInfo.Remark = InModel.Remark;
userInfo.UpdateTime = DateTime.Now;
userInfo.UpdateUser = Identity.LoginUserInfo.UserID;
if (BLL.Admin.MSUserInfoBll.EditUserInfo(userInfo))
{
msg = "OK";
}
else
{
msg = "修改失败，请重试";
}
return(Json(new { Message = msg }));
}
public ActionResult GetMajorList(string pageIndex, string pageSize, string keyWords)
{
SqlParams sqlParams = new SqlParams();
sqlParams.PageIndex = Converter.TryToInt32(pageIndex, 1);
sqlParams.PageSize = Converter.TryToInt32(pageSize, sqlParams.PageSize);
sqlParams.addUsefulParam("keyWords", keyWords);
sqlParams.addUsefulParam("DepartmentLevel", (int)Model.DepartmentLevel.专业);
int allCount = 0;
List <Model.Admin.MSDepartmentInfo> departmentList = BLL.Admin.MSDepartmentInfoBll.GetAllMSDepartmentInfoPageList(sqlParams, out allCount);
return(Json(new
{
Rows = departmentList.Select(d =>
{
Model.Admin.MSUserInfo directiorUser = BLL.Admin.MSUserPositionRelationBll.GetUserByDepartmentIdAndPositionType(d.DepartmentID, (int)Model.PositionType.系主任);
return new
{
d.DepartmentID,
d.DepartmentName,
ParentName = BLL.Admin.MSDepartmentInfoBll.GetDepartmentNameById(d.ParentID).IfEmptyToString("--"),
DirectorName = directiorUser == null ? "--" : directiorUser.RealName, // 系主任
DirectorId = directiorUser == null ? 0 : directiorUser.UserID, // 系主任
};
}),
AllCount = allCount
}, JsonRequestBehavior.AllowGet));
}
public ActionResult TeacherEditPage(long userId)
{
// 查询用户信息
Model.Admin.MSUserInfo userInfo = BLL.Admin.MSUserInfoBll.GetSingleUserInfo(userId);
if (userInfo != null)
{
// 完善信息
userInfo.SchoolName = BLL.Admin.MSDepartmentInfoBll.GetDepartmentNameById(userInfo.SchoolID);
userInfo.MajorName = BLL.Admin.MSDepartmentInfoBll.GetDepartmentNameById(userInfo.MajorID);
}
return(View("~/Views/Admin/MSUserInfo/TeacherEdit.cshtml", userInfo));
}
public ActionResult DepartmentTree()
{
// 查询学院
List <Model.Admin.MSDepartmentInfo> schoolList = BLL.Admin.MSDepartmentInfoBll.GetAllDepartmentInfoParentId(0) ?? new List <Model.Admin.MSDepartmentInfo>();
if (schoolList != null && schoolList.Count > 0)
{
Models.Admin.DepartmentTreeModelOut schoolNode = new Models.Admin.DepartmentTreeModelOut();
schoolNode.name = schoolList[0].DepartmentName;
Model.Admin.MSUserInfo directorUserInfo = BLL.Admin.MSUserPositionRelationBll.GetUserByDepartmentIdAndPositionType(schoolList[0].DepartmentID, (int)Model.PositionType.院长);
schoolNode.directorName = "院长：" + (directorUserInfo == null ? "--" : directorUserInfo.RealName);
schoolNode.children = new List <Models.Admin.DepartmentTreeModelOut>();
// 查询专业
List <Model.Admin.MSDepartmentInfo> majorList = BLL.Admin.MSDepartmentInfoBll.GetAllDepartmentInfoParentId(schoolList[0].DepartmentID) ?? new List <Model.Admin.MSDepartmentInfo>();
if (majorList != null && majorList.Count > 0)
{
foreach (Model.Admin.MSDepartmentInfo majorItem in majorList)
{
Models.Admin.DepartmentTreeModelOut majorNode = new Models.Admin.DepartmentTreeModelOut();
majorNode.name = majorItem.DepartmentName;
directorUserInfo = BLL.Admin.MSUserPositionRelationBll.GetUserByDepartmentIdAndPositionType(majorItem.DepartmentID, (int)Model.PositionType.系主任);
majorNode.directorName = "系主任：" + (directorUserInfo == null ? "--" : directorUserInfo.RealName);
majorNode.children = new List <Models.Admin.DepartmentTreeModelOut>();
// 查询班级
List <Model.Admin.MSDepartmentInfo> classList = BLL.Admin.MSDepartmentInfoBll.GetAllDepartmentInfoParentId(majorItem.DepartmentID) ?? new List <Model.Admin.MSDepartmentInfo>();
if (classList != null && classList.Count > 0)
{
foreach (Model.Admin.MSDepartmentInfo classItem in classList)
{
Models.Admin.DepartmentTreeModelOut classNode = new Models.Admin.DepartmentTreeModelOut();
classNode.name = classItem.DepartmentName;
directorUserInfo = BLL.Admin.MSUserPositionRelationBll.GetUserByDepartmentIdAndPositionType(classItem.DepartmentID, (int)Model.PositionType.班主任);
classNode.directorName = "班主任：" + (directorUserInfo == null ? "--" : directorUserInfo.RealName);
majorNode.children.Add(classNode);
}
}
schoolNode.children.Add(majorNode);
}
}
// 将对象转化为json字符串传到前端
ViewBag.DepartmentTreeNode = JsonEntityExchange <object> .ConvertEntityToJson(schoolNode);
}
return(View("~/Views/Admin/MSDepartmentInfo/DepartmentTree.cshtml"));
}
public ActionResult Login(string UserName, string Pwd)
{
string result = "用户名或密码错误";
Model.Admin.MSUserInfo userInfo = BLL.Admin.MSUserInfoBll.Login(UserName, Pwd, Request.UserHostAddress);
if (userInfo != null)
{
// 写Cookies
Security.SetUserLoginCookies(userInfo.UserID.ToString(), this.Response);
result = "ok";
}
return(Content(result));;
}
public ActionResult AddTeacherCallBack(Models.Admin.MSUserInfoModel InModel)
{
string msg = "OK";
// 添加用户
Model.Admin.MSUserInfo userInfo = new Model.Admin.MSUserInfo()
{
UserName = InModel.UserName,
Password = Security.getMD5ByStr(InModel.Password),
RealName = InModel.RealName,
RoleID = (int)Model.RoleType.教职工,
SchoolID = 1, //默认学院
MajorID = Converter.TryToInt64(InModel.MajorId),
ClassID = 0,
Gender = InModel.Gender,
Telephone = InModel.Telephone,
QQ = InModel.QQ,
Email = InModel.Email,
Remark = InModel.Remark,
CreateTime = DateTime.Now,
CreateUser = Identity.LoginUserInfo.UserID,
};
userInfo.UserID = BLL.Admin.MSUserInfoBll.AddUserInfo(userInfo);
if (userInfo.UserID > 0)
{
// 添加默认岗位
Model.Admin.MSUserPositionRelation relation = new Model.Admin.MSUserPositionRelation()
{
UserID = userInfo.UserID,
CreateTime = DateTime.Now,
CreateUser = Identity.LoginUserInfo.UserID,
};
if (InModel.IsPresident == "1")
{
// 院长
relation.PositionID = userInfo.SchoolID;//院长岗位ID
}
else
{
// 讲师
relation.PositionID = MSPositionInfoBll.GetPositionIdByDepartmentIdAndPositionType(userInfo.MajorID, (int)Model.PositionType.讲师);
}
MSUserPositionRelationBll.AddUserPositionRelation(relation);
}
else
{
msg = "添加失败，请重试";
}
return(Json(new { Message = msg }));
}
public ActionResult GetTeacherDetails(long userId)
{
// 查询用户信息
Model.Admin.MSUserInfo userInfo = BLL.Admin.MSUserInfoBll.GetSingleUserInfo(userId);
if (userInfo != null)
{
// 完善信息
userInfo.SchoolName = BLL.Admin.MSDepartmentInfoBll.GetDepartmentNameById(userInfo.SchoolID);
userInfo.MajorName = BLL.Admin.MSDepartmentInfoBll.GetDepartmentNameById(userInfo.MajorID);
// 岗位信息
return(Json(new { Message = "OK", UserInfo = userInfo }, JsonRequestBehavior.AllowGet));
}
return(Json(new { Message = "未找到该教师资料，请刷新列表重新操作！" }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 登陆检测
/// </summary>
public static Model.Admin.MSUserInfo Login(string UseName, string password, string ipAddress)
{
password = Security.getMD5ByStr(password);
Model.Admin.MSUserInfo userInfo = DAL.Admin.MSUserInfoDal.GetInfoByUserNameAndPwd(UseName, password);
if (userInfo != null)
{
Model.Identity.LoginUserInfo = userInfo;
//登录成功，记录日志
BLL.Admin.MSSystemOperateLogBll.AddLoginLog("登录系统", ipAddress);
// 修改最近登录时间和IP
DAL.Admin.MSUserInfoDal.UpdateLastLoginTimeByID(DateTime.Now, ipAddress, userInfo.UserID);
}
return(userInfo);
}
public ActionResult DeleteUser(long userId)
{
// 查询用户信息
Model.Admin.MSUserInfo userInfo = BLL.Admin.MSUserInfoBll.GetSingleUserInfo(userId);
if (userInfo == null)
{
return(Json(new { Message = "该用户不存在或已被删除！！" }));
}
if (BLL.Admin.MSUserInfoBll.DeleteSingleUserInfo(userId))
{
return(Json(new { Message = "OK" }));
}
else
{
return(Json(new { Message = "删除失败！" }));
}
}
/// <summary>
/// 增加实体
/// </summary>
/// <param name="databaseConnectionString">数据库链接字符串</param>
/// <param name="entity">实体</param>
public static long Add(Model.Admin.MSUserInfo entity)
{
var sql = @"
INSERT INTO [MSUserInfo]
(
[UserName]
,[RealName]
,[Password]
,[RoleID]
,[SchoolID]
,[MajorID]
,[ClassID]
,[Gender]
,[Telephone]
,[QQ]
,[Email]
,[Remark]
,[CreateTime]
,[CreateUser]
,[Deleted]
)
VALUES
(
@UserName
,@RealName
,@Password
,@RoleID
,@SchoolID
,@MajorID
,@ClassID
,@Gender
,@Telephone
,@QQ
,@Email
,@Remark
,@CreateTime
,@CreateUser
,@Deleted
);SELECT SCOPE_IDENTITY();
";
var parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter()
{
ParameterName = "@UserID", Value = entity.UserID
});
parameters.Add(new SqlParameter()
{
ParameterName = "@UserName", Value = entity.UserName
});
parameters.Add(new SqlParameter()
{
ParameterName = "@RealName", Value = entity.RealName
});
parameters.Add(new SqlParameter()
{
ParameterName = "@Password", Value = entity.Password
});
parameters.Add(new SqlParameter()
{
ParameterName = "@RoleID", Value = entity.RoleID
});
parameters.Add(new SqlParameter()
{
ParameterName = "@SchoolID", Value = entity.SchoolID
});
parameters.Add(new SqlParameter()
{
ParameterName = "@MajorID", Value = entity.MajorID
});
parameters.Add(new SqlParameter()
{
ParameterName = "@ClassID", Value = entity.ClassID
});
parameters.Add(new SqlParameter()
{
ParameterName = "@Gender", Value = entity.Gender
});
parameters.Add(new SqlParameter()
{
ParameterName = "@Telephone", Value = entity.Telephone
});
parameters.Add(new SqlParameter()
{
ParameterName = "@QQ", Value = entity.QQ
});
parameters.Add(new SqlParameter()
{
ParameterName = "@Email", Value = entity.Email
});
parameters.Add(new SqlParameter()
{
ParameterName = "@Remark", Value = entity.Remark
});
parameters.Add(new SqlParameter()
{
ParameterName = "@CreateTime", Value = entity.CreateTime
});
parameters.Add(new SqlParameter()
{
ParameterName = "@CreateUser", Value = entity.CreateUser
});
parameters.Add(new SqlParameter()
{
ParameterName = "@Deleted", Value = entity.Deleted
});
return(Converter.TryToInt64(SqlHelper.ExecuteScalar(sql, parameters.ToArray())));
}
/// <summary>
/// 通过UserID更新实体
/// </summary>
public static bool UpdataUserInfoByID(Model.Admin.MSUserInfo entity)
{
var sql = @"
UPDATE [MSUserInfo]
SET
[RealName] = @RealName
,[SchoolID] = @SchoolID
,[MajorID] = @MajorID
,[ClassID] = @ClassID
,[Gender] = @Gender
,[Telephone] = @Telephone
,[IconUrl] = @IconUrl
,[QQ] = @QQ
,[Email] = @Email
,[Remark] = @Remark
,[UpdateTime] = @UpdateTime
,[UpdateUser] = @UpdateUser
WHERE
[UserID] = @UserID
";
var parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter()
{
ParameterName = "@UserID", Value = entity.UserID
});
parameters.Add(new SqlParameter()
{
ParameterName = "@RealName", Value = entity.RealName
});
parameters.Add(new SqlParameter()
{
ParameterName = "@SchoolID", Value = entity.SchoolID
});
parameters.Add(new SqlParameter()
{
ParameterName = "@MajorID", Value = entity.MajorID
});
parameters.Add(new SqlParameter()
{
ParameterName = "@ClassID", Value = entity.ClassID
});
parameters.Add(new SqlParameter()
{
ParameterName = "@Gender", Value = entity.Gender
});
parameters.Add(new SqlParameter()
{
ParameterName = "@Telephone", Value = entity.Telephone
});
parameters.Add(new SqlParameter()
{
ParameterName = "@IconUrl", Value = entity.IconUrl
});
parameters.Add(new SqlParameter()
{
ParameterName = "@QQ", Value = entity.QQ
});
parameters.Add(new SqlParameter()
{
ParameterName = "@Email", Value = entity.Email
});
parameters.Add(new SqlParameter()
{
ParameterName = "@Remark", Value = entity.Remark
});
parameters.Add(new SqlParameter()
{
ParameterName = "@UpdateTime", Value = entity.UpdateTime
});
parameters.Add(new SqlParameter()
{
ParameterName = "@UpdateUser", Value = entity.UpdateUser
});
int i = SqlHelper.ExecuteNonQuery(sql, parameters.ToArray());
return(i > 0 ? true : false);
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="userInfo"></param>
/// <returns></returns>
public static long AddUserInfo(Model.Admin.MSUserInfo userInfo)
{
return(DAL.Admin.MSUserInfoDal.Add(userInfo));
}
