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