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); } }