public List <luminance> GetAllLuminance()
{
var luminanceList = new List <luminance>();
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlDependency.Start(connectionString);
string cmdText = "select TOP (10)[name],[time],[sensor_number],[sensor_type],[value] from dbo.luminance where [sensor_number] ='E110-sensortag-01' UNION " +
"select TOP (10)[name],[time],[sensor_number],[sensor_type],[value] from dbo.luminance where [sensor_number] ='E110-sensortag-02' UNION " +
"select TOP(10)[name],[time],[sensor_number],[sensor_type],[value] from dbo.luminance where[sensor_number] = 'E110-sensortag-03' UNION " +
"select TOP (10)[name],[time],[sensor_number],[sensor_type],[value] from dbo.luminance where [sensor_number] ='E110-sensortag-04'UNION " +
"select TOP (10)[name],[time],[sensor_number],[sensor_type],[value] from dbo.luminance where [sensor_number] ='E110-sensortag-05'";
SqlCommand cmd = new SqlCommand(cmdText, conn);
SqlDependency dependency = new SqlDependency(cmd);
dependency.OnChange += dbChangeNotification;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var luminanceInfo = new luminance
{
name = reader["name"].ToString(),
time = Convert.ToInt64(reader["time"]),
sensor_number = reader["sensor_number"].ToString(),
sensor_type = reader["sensor_type"].ToString(),
value = (float)Convert.ToDouble(reader["value"])
};
luminanceList.Add(luminanceInfo);
}
}
return(luminanceList);
}
=> HSLAColorToRGBAFColor1(hue, saturation, luminance, alpha);
