/// <summary> /// 插入作者信息 /// </summary> /// <param name="userExpert"></param> /// <returns></returns> public static int InsertUserExpert(UserAuthor userAuthor) { string sql = "proc_InserIntoAuthor"; //连接数据库,执行SQL语句 DBVisit.ObjDBAccess.CmdParas.Clear(); DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_RoleID", SqlDbType.Int).Value = userAuthor.RoleInfo.Id; DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_Name", SqlDbType.VarChar, 100).Value = userAuthor.Name; DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_Pwd", SqlDbType.VarChar).Value = userAuthor.Pwd; DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_CreateTime", SqlDbType.DateTime).Value = userAuthor.CreateTime; DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_RealName", SqlDbType.VarChar, 100).Value = userAuthor.RealName; DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_Sex", SqlDbType.Bit).Value = userAuthor.Sex; DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_Birthday", SqlDbType.DateTime).Value = userAuthor.Birthday; DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_Tel", SqlDbType.VarChar, 20).Value = userAuthor.Tel; DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_Email", SqlDbType.VarChar, 50).Value = userAuthor.Email; DBVisit.ObjDBAccess.CmdParas.Add("@Author_TypeName", SqlDbType.VarChar, 50).Value = userAuthor.TypeName; DBVisit.ObjDBAccess.CmdParas.Add("@IsSuccess", SqlDbType.Bit).Direction = ParameterDirection.Output; DBVisit.ObjDBAccess.ExcuteProcReturnInt(sql); bool result = bool.Parse(DBVisit.ObjDBAccess.CmdParas["@IsSuccess"].Value.ToString()); if (result) { return(1); } else { return(0); } }
/// <summary> /// 用户点击提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { //设置用户信息 UserAuthor user = new UserAuthor(); user.Id = -1; user.Name = txtUserName.Text; //用户名称 user.Pwd = txtPassword.Text; //密码 user.RealName = txtRealName.Text; //真实姓名 user.RoleInfo.Id = 6; //权限(作者) //用户性别 if (ddlSex.SelectedValue == "1") { user.Sex = true; } else { user.Sex = false; } if (txtBirthday.Text == "") { ClientScript.RegisterStartupScript(GetType(), "", "alert('生日必填')", true); return; } user.CreateTime = DateTime.Now; //创建时间 user.Birthday = Convert.ToDateTime(txtBirthday.Text); //生日 user.Email = txtEMail.Text; //邮箱 user.Tel = txtTel.Text; //联系电话 user.TypeName = "一般作者"; //作者类别 if (UserManager.IsUserExist(user.Name)) { ClientScript.RegisterStartupScript(GetType(), "UserIsExist", "alert('用户名已存在!')", true); return; } if (UserManager.AddNewAuthor(user) == 1) { //添加成功 ClientScript.RegisterStartupScript(GetType(), "UserIsExist", "alert('注册成功!');location.href='UserLogin.aspx'", true); } else {//添加失败 ClientScript.RegisterStartupScript(GetType(), "UserIsExist", "alert('注册失败!')", true); } }
/// <summary> /// 查询所有作者id /// </summary> /// <returns></returns> public static List <UserAuthor> GetUserAuthorAll() { string sql = "proc_GetUserAuthorAll"; //连接数据库,执行SQL语句 DataTable dt = DBVisit.ObjDBAccess.ExecuteProc(sql).Tables[0]; //作者信息列表 List <UserAuthor> userAuthorList = new List <UserAuthor>(dt.Rows.Count); UserAuthor userAuthor = null; //创建作者信息对象并添加到作者信息列表中 foreach (DataRow dr in dt.Rows) { userAuthor = CreateUserAuthor(dr); userAuthorList.Add(userAuthor); } return(userAuthorList); }
/// <summary> /// 修改用户密码 /// </summary> /// <param name="user">要修改的用户信息</param> /// <returns>操作结果</returns> public static int UpdateUserPassword(GeneralUser user) { int result = -1; //修改用户编号 switch (user.RoleInfo.Id) { case UserRoleConst.Administrator: //系统管理员 result = GeneralUserService.UpdateGeneralUser(user); break; //更新一般用户信息 case UserRoleConst.ChiefEditor: //主编 result = GeneralUserService.UpdateGeneralUser(user); break; case UserRoleConst.LayoutEditor: //排版编辑 result = GeneralUserService.UpdateGeneralUser(user); break; case UserRoleConst.ResponsibleEditor: //责任编辑 result = GeneralUserService.UpdateGeneralUser(user); break; case UserRoleConst.SubEditor: //副主编 result = GeneralUserService.UpdateGeneralUser(user); break; //更新特殊用户信息 case UserRoleConst.Author: //作者 UserAuthor auther = user as UserAuthor; result = UserAuthorService.UpdateUserAuthor(auther); break; case UserRoleConst.Expert: //专家 UserExpert expert = user as UserExpert; result = UserExpertService.UpdateUserExpert(expert); break; } return(result); }
/// <summary> /// 创建作者信息对象 /// </summary> /// <param name="dr"></param> /// <returns></returns> public static UserAuthor CreateUserAuthor(DataRow dr) { UserAuthor userAuthor = new UserAuthor(); userAuthor.Id = int.Parse(dr["Author_ID"].ToString()); userAuthor.TypeName = dr["Author_TypeName"].ToString(); userAuthor.Name = dr["UserInfo_Name"].ToString(); userAuthor.Pwd = dr["UserInfo_Pwd"].ToString(); userAuthor.CreateTime = DateTime.Parse(dr["UserInfo_CreateTime"].ToString()); userAuthor.RealName = dr["UserInfo_RealName"].ToString(); userAuthor.Sex = bool.Parse(dr["UserInfo_Sex"].ToString()); userAuthor.Birthday = DateTime.Parse(dr["UserInfo_Birthday"].ToString()); userAuthor.Tel = dr["UserInfo_Tel"].ToString(); userAuthor.Email = dr["UserInfo_Email"].ToString(); //角色信息 userAuthor.RoleInfo.Id = int.Parse(dr["Role_ID"].ToString()); userAuthor.RoleInfo.Name = dr["Role_Name"].ToString(); userAuthor.RoleInfo.NavTreeNodeID = int.Parse(dr["Role_NavTreeNodeID"].ToString()); return(userAuthor); }
/// <summary> /// 创建作者信息 /// </summary> /// <param name="user"></param> /// <returns></returns> public static int AddNewAuthor(UserAuthor user) { return(UserAuthorService.InsertUserExpert(user)); }