public void ReadDeviceInfoForNode(string nodeID1)
{
device_info_list.Clear();//Resetting list
//string deviceTableName = "tbl_"+
string tableNameDevice = "tbl_" + selectedBuildingList[0].BuildingName + "_device_info_for_node";//currentNodeTableFromDB;
//lets get the id values...
string databasePath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
string databaseFile = databasePath + @"\db_psychrometric_project.s3db";
string connString1 = @"Data Source=" + databaseFile + ";Version=3;";
string sql1 = "SELECT * From " + tableNameDevice + " where nodeID='" + nodeID1 + "'";
// MessageBox.Show("sql1=" + sql1);
//(nodeID,device_instanceID,IP,param1ID_X,param2ID_Y) VALUES(@id,@instanceID,@IP,@param1,@param2)";
using (SQLiteConnection thisConnection = new SQLiteConnection(connString1))
{
SQLiteCommand cmd = new SQLiteCommand(sql1, thisConnection);
thisConnection.Open();
SQLiteDataReader reader = cmd.ExecuteReader();
// MessageBox.Show("cmd error= " + cmd.CommandText);
while (reader.Read())
{
// AL_nodeId.Add(reader["nodeID"].ToString());
device_info_list.Add(new device_info_class
{
nodeID = nodeID1,
device_instance_id_for_param1 = reader["device_instanceID_for_param1"].ToString(),
device_IP_for_param1 = reader["IP_for_param1"].ToString(),
device_instance_id_for_param2 = reader["device_instanceID_for_param2"].ToString(),
device_IP_for_param2 = reader["IP_for_param2"].ToString(),
param1_id = reader["param1ID"].ToString(),
param2_id = reader["param2ID"].ToString(),
param1_info = reader["param1_info"].ToString(),
param2_info = reader["param2_info"].ToString(),
param1_identifier_type = reader["param1_identifier_type"].ToString(),
param2_identifier_type = reader["param2_identifier_type"].ToString()
});
}
}
}