public enum LoginResult
{
NoUser=1,
NoPassword=2,
UserError=3,
Password=4,
Success=5,
NoDept=6,
IsLock=7,
IsOverDate=8,
UserOrPasswordError=9
}
********************************************************
namespace BLLevel
{
public class UserLogin
{
public static LoginResult ValidatedLogin(string username,string password)
{
if (username.Trim() == "")
{
return LoginResult.NoUser;
}
if (password.Trim() == "")
{
return LoginResult.NoPassword;
}
DataTable table = new DataTable();
StringBuilder sqlText = new StringBuilder();
sqlText.Append("select * from BSC_AccountShade where username=@username and password=@password");
IList<DbParameter> parameters = new List<DbParameter>();
parameters.Add(SqlHelper.Instance.CreateParameter("@username", username));
parameters.Add(SqlHelper.Instance.CreateParameter("@password", password));
try
{
table = SqlHelper.Instance.GetDataTable(sqlText.ToString(), parameters);
if ((table == null) || (table.Rows.Count <= 0))
{
return LoginResult.UserOrPasswordError;
}
LoginInfo.UserName = table.Rows[0]["username"].ToString();
LoginInfo.Password = table.Rows[0]["password"].ToString();
LoginInfo.UserGroup = table.Rows[0]["AuthorityGroup"].ToString();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return LoginResult.Success;
}
public enum LoginResult
{
NoUser=1,
NoPassword=2,
UserError=3,
Password=4,
Success=5,
NoDept=6,
IsLock=7,
IsOverDate=8,
UserOrPasswordError=9
}
}
}
++++++++++++++++UI层++++++++++++++++++++++++++++++++++++
private void btnOK_Click(object sender, EventArgs e)
{
bool isSuccess = false;
switch(UserLogin.ValidatedLogin(this.textBox_UserName.Text,this.textBox_Password.Text))
{
case UserLogin.LoginResult.NoUser:
MessageBox.Show("User Login Name Is Space .");
this.textBox_UserName.Focus();
this.textBox_UserName.SelectAll();
break;
case UserLogin.LoginResult.NoPassword:
MessageBox.Show("User Login Password Is Space .");
this.textBox_Password.Focus();
this.textBox_Password.SelectAll();
break;
case UserLogin.LoginResult.UserOrPasswordError:
MessageBox.Show("User Name or Password is Error .");
this.textBox_UserName.Text="";
this.textBox_Password.Text="";
this.textBox_UserName.Focus();
this.textBox_UserName.SelectAll();
break;
case UserLogin.LoginResult.Success:
isSuccess = true;
break;
}
if (isSuccess)
{
this.DialogResult = DialogResult.OK;
}
}