public List <CheckInfo> selectALL(User user)
{
List <CheckInfo> checks = new List <CheckInfo>();
string sql = string.Format("select CDate, CProvince, CCity, CBodyTemperture, CIsSuspected, CIsConfirmed from checkinfo where Username = @username");
List <MySqlParameter> parameters = new List <MySqlParameter>();
parameters.Add(new MySqlParameter("@username", user.GetUsername()));
MySqlDataReader reader = MySQLHelper.ExecuteReader(sql, parameters.ToArray());
//MySqlDataReader reader = MySQLHelper.ExecuteReader(sql);
while (reader.Read())
{
//循环读取每一条记录：循环中不建议拆箱与装箱
//objClass = new Class((int)reader["classid"], (string)reader["classname"], (string)reader["remark"]);
//此语句效率更高：无拆箱操作
CheckInfo objCheck = new CheckInfo(reader.GetDateTime("CDate"), reader.GetString("CProvince"), reader.GetString("CCity"),
reader.GetString("CBodyTemperture"), reader.GetString("CIsSuspected") == "1" ? "是" : "否", reader.GetString("CIsConfirmed") == "1" ? "是" : "否");
//CheckInfo objCheck = new CheckInfo(Convert.ToDateTime("2020-2-25"), "1", "2", "3", "4", "5");
checks.Add(objCheck);
}
reader.Close();
return(checks);
}
