private void btnLogIn_Click(object sender, EventArgs e)
{
AccNum accNum = new AccNum();
accNum.accNumber = txtAccNum.Text.ToString();
accNum.password = txtPassword.Text.ToString();
LogInBLL logInBLL = new LogInBLL();
switch (logInBLL.GetIfAccNum(accNum))
{
case 0:
MessageBox.Show("登录成功");
CustomersList customers = new CustomersList();
this.Hide();
customers.ShowDialog();
this.Dispose();
break;
case 1:
MessageBox.Show("账号错误");
break;
case 2:
MessageBox.Show("密码错误");
break;
}
}
private void btnRegister_Click(object sender, EventArgs e)
{
AccNum accNum = new AccNum();
accNum.accNumber = txtAccNum.Text.ToString();
accNum.password = txtPassword.Text.ToString();
accNum.passwordAgain = txtPasswordAgain.Text.ToString();
int r = RegisterBLL.UIPassword(accNum);
if (r == 1)
{
int temp = RegisterBLL.GetAcc(accNum);
if (temp == 1)
{
MessageBox.Show("成功");
}
else
{
MessageBox.Show("失败");
}
}
else if (r == 0)
{
MessageBox.Show("对不起，两次密码输入的不一致");
}
else
{
MessageBox.Show("请呼叫专业人员，本系统不干活了");
}
}
public static int UIPassword(AccNum accNum)
{
if (accNum.password == accNum.passwordAgain)
{
return(1);
}
else
{
return(0);
}
}
public static int GetAcc(AccNum accNum)
{
int r = RegisterDAL.CustomerRegister(accNum);
if (r == 1)
{
return(1);
}
else
{
return(0);
}
}
public int LogInCustomerFirst(AccNum accNum)//首先验证是否有此账号
{
string SQLStr = "select * from accNum where accNumber = @accNumber";
SqlParameter[] SQLps =
{
new SqlParameter("@accNumber", accNum.accNumber)
};
object r = SQLHelper.SQLExcuteScalar(SQLStr, SQLps);
if (r != null)
{
return(1);//成功
}
else
{
return(0);//失败
}
}
public static int CustomerRegister(AccNum accNum)
{
string SQLStr = "insert into accNum values (@accNumber,@password)";
SqlParameter[] SQLps =
{
new SqlParameter("@accNumber", accNum.accNumber),
new SqlParameter("@password", MD5Helper.GetMd5(accNum.password))
};
int r = SQLHelper.SQLExcuteNoQuery(SQLStr, SQLps);
if (r > 0)
{
return(1);
}
else
{
return(0);
}
}
public int GetIfAccNum(AccNum accNum)
{
LogInDAL logInDAL = new LogInDAL();
if (logInDAL.LogInCustomerFirst(accNum) == 1)
{
if (logInDAL.LogInCustomerSecond(accNum) == 1)
{
return(0);//正确
}
else
{
return(2);//密码错误
}
}
else
{
return(1);//账号错误
}
}
public int LogInCustomerSecond(AccNum accNum)//比较密码
{
string SQLStr = "select * from accNum where accNumber = @accNumber and password = @password ";
SqlParameter[] SQLps =
{
new SqlParameter("@accNumber", accNum.accNumber),
new SqlParameter("@password", MD5Helper.GetMd5(accNum.password))
};
object r = SQLHelper.SQLExcuteScalar(SQLStr, SQLps);
if (r != null)
{
return(1);//成功
}
else
{
return(0);//失败
}
}
