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