/// <summary> /// 修改用户信息(用户类型,密码) /// </summary> /// <param name="u">R_User的实例</param> /// <returns>是否修改成功</returns> public bool editUser(R_User u) { bool bl = false; if (d.editUser(u) == 1) { bl = true; } return bl; }
/// <summary> /// 添加用户信息 /// </summary> /// <param name="u">R_User的实例</param> /// <returns>是否添加成功</returns> public bool addUser(R_User u) { bool bl = false; if (d.addUser(u) == 1) { bl = true; } return bl; }
/// <summary> /// 修改用户信息(用户类型,密码) /// </summary> /// <param name="u">R_User的实例</param> /// <returns>受影响行数</returns> public int editUser(R_User u) { Database db = DatabaseFactory.CreateDatabase(); DbCommand cmd = db.GetSqlStringCommand(@"UPDATE R_User SET [Password] = @Password WHERE (ID = @ID)"); db.AddInParameter(cmd, "@Password", DbType.String, u.Password); db.AddInParameter(cmd, "@ID", DbType.Int32, u.ID); return db.ExecuteNonQuery(cmd); }
/// <summary> /// 添加用户信息 /// </summary> /// <param name="u">R_User的实例</param> /// <returns>受影响行数</returns> public int addUser(R_User u) { Database db = DatabaseFactory.CreateDatabase(); DbCommand cmd = db.GetSqlStringCommand(@"insert into R_User (User_Name,[Password],User_Type,LoginCount) values (@User_Name,@Password,@User_Type,@LoginCount)"); db.AddInParameter(cmd, "@User_Name", DbType.String, u.User_Name); db.AddInParameter(cmd, "@Password", DbType.String, u.Password); db.AddInParameter(cmd, "@User_Type", DbType.Int32, u.User_Type); db.AddInParameter(cmd, "@LoginCount", DbType.Int32, u.LoginCount); return db.ExecuteNonQuery(cmd); }
protected void but_user_Click(object sender, EventArgs e) { string name = UserName.Value.Trim(); string ut = User_Type.SelectedValue; string pwd = new Encrypt().Get_MD5_Method32(PassWord.Value); string pwd1 = PassWord1.Value; string pwd2 = PassWord2.Value; if (Convert.ToInt32(ut) > userType || userType == 0|| name.Equals(Request.Cookies["user"]["UserName"])) { if (!name.Equals(string.Empty) && pwd1.Equals(pwd2)) { _PassWord.Visible = true; B_User b = new B_User(); DataTable dt = b.getUserByID(id); if (pwd.Equals(dt.Rows[0]["Password"])) { _oldPwd.Visible = true; if (action.Equals("edit")) { R_User r = new R_User(); r.ID = id; r.Password = new Encrypt().Get_MD5_Method32(pwd1); if (b.editUser(r)) { Response.Redirect("User.aspx"); } else { Response.Write("<script>alert('修改失败')</script>"); } } } else { _oldPwd.Visible = false; } } else if (!pwd1.Equals(pwd2)) { _PassWord.Visible = false; } } else { Response.Write("<script>alert('用户权限不足,不能修改!')</script>"); } }
protected void but_user_Click(object sender, EventArgs e) { string name = UserName.Value.Trim(); string ut = User_Type.SelectedValue; string pwd1 = PassWord1.Value; string pwd2 = PassWord2.Value; if (Convert.ToInt32(ut) > userType||userType==0) { if (!name.Equals(string.Empty) && pwd1.Equals(pwd2)) { B_User b = new B_User(); _PassWord.Text = string.Empty; R_User r = new R_User(); r.User_Name = name; r.User_Type = Convert.ToInt32(ut); r.Password = new Encrypt().Get_MD5_Method32(pwd1); ; r.LoginCount = 0; if (b.searchUser(name)) { _UserName.Text = string.Empty; if (b.addUser(r)) { Response.Redirect("User.aspx"); } else { Response.Write("<script>alert('添加失败')</script>"); } } else { _UserName.Text = "用户名已存在"; } } else if (!pwd1.Equals(pwd2)) { _PassWord.Text = "两次输入密码不一致"; } } else { Response.Write("<script>alert('用户权限不足不能添加!')</script>"); } }