public LoginState GetLoginState(string strUserName, string strUserPwd)
{
if (string.IsNullOrEmpty(strUserName) || string.IsNullOrEmpty(strUserPwd))
{
return(LoginState.NoneUser);
}
//1判断用户名strUserName是否已经存在
bool bExist = false;
MySQLExtend sqlExtend = new MySQLExtend();
bExist = sqlExtend.IsExistID("Member", "UserName", strUserName);
if (!bExist)
{
return(LoginState.NoneUser);
}
else
{
//2判断密码是否正确
MySQLBase sqlBase = new MySQLBase();
try
{
string strSQL = "select* from Member where UserName='******' and UserPwd='" + strUserPwd + "'";
sqlBase.Connect();
SqlDataReader reader = sqlBase.GetDataReader(strSQL, null);
if (reader != null)
{
if (reader.HasRows)
{
return(LoginState.LoginSuccess);
}
else
{
return(LoginState.ErrowPwd);
}
}
else
{
return(LoginState.ErrowPwd);
}
}
catch (System.Exception ex)
{
return(LoginState.ErrowPwd);
}
finally
{
if (sqlBase.HasConnected())
{
sqlBase.DisConnect();
}
}
}
}
public LoginState GetLoginState(string strUserName, string strUserPwd)
{
if (string.IsNullOrEmpty(strUserName) || string.IsNullOrEmpty(strUserPwd))
return LoginState.NoneUser;
//1判断用户名strUserName是否已经存在
bool bExist = false;
MySQLExtend sqlExtend = new MySQLExtend();
bExist = sqlExtend.IsExistID("Member", "UserName", strUserName);
if (!bExist)
{
return LoginState.NoneUser;
}
else
{
//2判断密码是否正确
MySQLBase sqlBase = new MySQLBase();
try
{
string strSQL = "select* from Member where UserName='******' and UserPwd='" + strUserPwd + "'";
sqlBase.Connect();
SqlDataReader reader = sqlBase.GetDataReader(strSQL, null);
if (reader != null)
{
if (reader.HasRows)
{
return LoginState.LoginSuccess;
}
else
{
return LoginState.ErrowPwd;
}
}
else
{
return LoginState.ErrowPwd;
}
}
catch (System.Exception ex)
{
return LoginState.ErrowPwd;
}
finally
{
if (sqlBase.HasConnected())
sqlBase.DisConnect();
}
}
}
