// 保存修改的用户信息
private void save_Click(object sender, RoutedEventArgs e)
{
if (modify) // 如果更改了用户信息
{
User user = new User();
if (passwd.Text != changepwd.Text)
{
MessageBox.Show("输入的密码有错，请检查！！！");
return;
}
user.UserName = username.Text;
user.Password = passwd.Text;
user.RealName = realname.Text;
user.Job = job.Text;
user.Group = Convert.ToInt32(group.SelectedValue); // 这一项还有待改变
if (helper.changeUserInfo(user) == 1)
{
MessageBox.Show("修改成功！！！");
}
else
{
MessageBox.Show("修改失败！！！");
}
}
return;
}
public User getSingleUserInfo(string name)
{
string cmdText = "select * from Users where user_name = '" + name + "'";
SqlCommand cmd = new SqlCommand(cmdText, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
User user = new User(Convert.ToString(reader["user_name"]), Convert.ToString(reader["passwd"]),
Convert.ToString(reader["real_name"]), Convert.ToString(reader["job"]),
Convert.ToInt32(reader["user_group"]));
conn.Close();
return user;
}
// 获取所有的用户信息
public List<User> getAllUsers()
{
List<User> users = new List<User>();
string cmdText = "select * from Users";
SqlCommand cmd = new SqlCommand(cmdText, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
User user = new User(Convert.ToString(reader["user_name"]), Convert.ToString(reader["passwd"]),
Convert.ToString(reader["real_name"]),Convert.ToString(reader["job"]),
Convert.ToInt32(reader["user_group"]));
users.Add(user);
}
conn.Close();
return users; // 返回用户的信息
}
// 写入修改的用户的信息
public int changeUserInfo(User user)
{
int temp = 0;
string cmdText = "update Users set passwd = '" + user.Password + "',real_name = '" +
user.RealName + "', job = '" + user.Job + "', user_group =" + user.Group +
"where user_name = '" + user.UserName + "'";
SqlCommand cmd = new SqlCommand(cmdText, conn);
conn.Open();
temp = cmd.ExecuteNonQuery(); // 返回更改的行数
conn.Close();
return temp;
}