private void button1_Click(object sender, EventArgs e)
{
try
{
username = user_tb.Text.Trim();
string cha = "select * from contractUser where userName='******'";
DataSet ds = tools.ExceDS(cha);
if (user_tb.Text.Length <= 0 || pass_tb.Text.Length <= 0 || pass_tb2.Text.Length <= 0)//检查用户名密码是否为空
{
MessageBox.Show("用户名或密码不可为空，请重新输入", "用户名密码不可为空");
}
else if (user_tb.Text.Length < 6 || pass_tb.Text.Length < 6 || pass_tb2.Text.Length < 6)
{
MessageBox.Show("用户名密码需要大于六个字符，请重新输入用户名密码", "注册错误"); //检查用户名密码是否小于六个字符
}
else if (ds.Tables[0].Rows.Count >= 0) //验证用户名是否重复
{
MessageBox.Show("用户名已被注册，请更改用户名", "注册失败", MessageBoxButtons.OK);
}
else if (password1 != password2)//验证重复密码和密码是否相同
{
MessageBox.Show("两次密码不相同，请重新输入密码", "注册失败", MessageBoxButtons.OK);
pass_tb.Clear();
pass_tb2.Clear();
}
else//向数据库添加数据，即注册功能
{
string zc = "insert into contractUser (userName,userMiMa) values ('" + username + "','" + password1 + "')";
tools.ExecuteNonQuery(zc);
MessageBox.Show("恭喜你注册账号成功\n正在进行跳转，请稍后。。。。");
this.Hide();
frmLogin f = new frmLogin();
f.Show();
}
}
catch (SqlException ex)
{
MessageBox.Show("系统错误，请稍后再试", "系统错误");
}
finally
{
}
}//注册功能
public void pdModify()
{
string user = u_tb.Text.Trim();
string oldpass = old_pass.Text.Trim();
string newpass = new_pass.Text.Trim();
string lookintoUser = "******" + user + "'";
string lookintoPass = "******" + user + "' and userPd = '" + oldpass + "'";
DataSet lkuser = tools.ExceDS(lookintoUser);
DataSet lkpass = tools.ExceDS(lookintoPass);
if (lkuser.Tables[0].Rows.Count <= 0) //验证用户名是否存在
{
MessageBox.Show("您输入的账户有误，请输入正确的账户", "账号错误");
}
else if (lkpass.Tables[0].Rows.Count <= 0) //验证密码是否正确
{
MessageBox.Show("您输入的密码有误，请核对后重新输入密码", "密码错误");
old_pass.Clear();
}
else if (oldpass == newpass) //验证新旧密码不能相同
{
MessageBox.Show("新密码不能与旧密码相同", "密码错误");
new_pass.Clear();
new_pass2.Clear();
}
else if (new_pass.Text.Trim() != new_pass2.Text.Trim()) //验证重复密码与新密码相同
{
MessageBox.Show("重复密码与新密码不相同，请重新输入", "新密码出错");
}
else //修改密码功能
{
string revisePass = "******" + newpass + "' where userName='******'";
tools.ExecuteNonQuery(revisePass);
MessageBox.Show("恭喜你，密码更改成功\n正在跳转前往登录界面。。。。", "更改成功");
frmLogin f = new frmLogin();
f.Show();
this.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
string user = user_tb.Text.Trim();
string pass = pass_tb.Text.Trim();
string lookinto = "select * from contractUser where userName='******' and userMiMa = '" + pass + "'";
DataSet lkinto = tools.ExceDS(lookinto);
if (lkinto.Tables[0].Rows.Count <= 0)
{
MessageBox.Show("您的账号或密码有误，请查验后在试", "错误");
}
else
{
DialogResult TorF = MessageBox.Show("您真的要注销账户吗？？？(注销账户后，一切资料将丢失)", "请确认", MessageBoxButtons.OKCancel);
if (TorF == DialogResult.OK)
{
string del = "delete from contractUser where userName='******' and userMiMa = '" + pass + "'";
tools.ExecuteNonQuery(del);
MessageBox.Show("您的账号已注销", "注销成功");
}
}
}
