private bool CheckUserLogonStatus(Logon user)
{
List <Logon> users = new List <Logon>();
SqlConnection sqlconn = commonContext.connectonToMSSQL();
string sqlCommand = string.Format(@"use {0}; select UserName,Password from QT_USER where UserName='******' and Password='******'", DBName, user.UserName, Sha256(user.Password));
sqlconn.Open();
SqlCommand cmd = new SqlCommand(sqlCommand, sqlconn);
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
Logon personal = new Logon();
for (int i = 0; i < reader.FieldCount; i++)
{
PropertyInfo property = personal.GetType().GetProperty(reader.GetName(i));
property.SetValue(personal, reader.IsDBNull(i) ? "[null]" : reader.GetValue(i), null);
}
users.Add(personal);
}
reader.Close();
if (users.Count == 0)
{
return(false);
}
else
{
return(true);
}
}
