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