public DataTable SelectByDateTime(DateTime dateTime)
{
String sql = "SELECT * FROM tb_plane_kingdata where `DateTime`=\"" + dateTime.ToString("yyyy-MM-dd HH:mm:ss") + "\";";
DataTable dataTable = MySqlDatabaseUtil.ExecuteQuery(sql);
return(dataTable);
}
public DataTable SelectByID(long id)
{
String sql = "SELECT * FROM tb_plane_kingdata where `id`=" + id;
DataTable dataTable = MySqlDatabaseUtil.ExecuteQuery(sql);
return(dataTable);
}
//不建议使用
public DataTable SelectAll()
{
String sql = "SELECT * FROM tb_plane_kingdata;";
DataTable dataTable = MySqlDatabaseUtil.ExecuteQuery(sql);
return(dataTable);
}
public DataTable SelectByLimit(int start, int count)
{
String sql = String.Format("SELECT * FROM tb_plane_kingdata LIMIT {0},{1}", start, count);
DataTable dataTable = MySqlDatabaseUtil.ExecuteQuery(sql);
return(dataTable);
}
public DataTable CustomQuery(string sql)
{
DataTable dataTable = MySqlDatabaseUtil.ExecuteQuery(sql);
return(dataTable);
}