public void GetSensorInfo()
{
try
{
using (SQLiteConnection conn = new SQLiteConnection(DBConfigPath))
{
conn.Open();
SQLiteCommand cmd = new SQLiteCommand(DBConfigPath, conn);
cmd.CommandText = "select S_DAI_SET.MODULE_NO as M_NO,S_SENSOR_SET.CHANNEL_ID as CH_ID " +
",S_SENSOR_SET.SENSOR_SET_ID as S_ID " +
"from S_DAI_SET left join S_SENSOR_SET " +
"on S_DAI_SET.DAI_SET_ID = S_SENSOR_SET.DAI_SET_ID ";
SQLiteDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
sensorList.Add("模块号:" + reader["M_NO"] + " 通道号:" + reader["CH_ID"]);
MoChaSenId moChaSenId = new MoChaSenId()
{
MoudleId = reader["M_NO"].ToString(),
ChannelId = reader["CH_ID"].ToString(),
SensorId = reader["S_ID"].ToString()
};
sensorInfoList.Add(moChaSenId);
}
}
}
}
catch (Exception)
{
MessageBox.Show(@"传感器表读取异常");
}
}
private void safeTypeComboBox_SelectionChangeCommitted(object sender, EventArgs e)
{
string safeTyperName = safeTypeComboBox.Items[safeTypeComboBox.SelectedIndex].ToString();
try
{
foreach (var idname in IdName)
{
if (safeTyperName == idname.Name)
{
sensorList.Clear();
using (SQLiteConnection conn = new SQLiteConnection(DBConfigPath))
{
conn.Open();
SQLiteCommand cmd = new SQLiteCommand(DBConfigPath, conn);
cmd.CommandText = "select S_DAI_SET.MODULE_NO as M_NO,S_SENSOR_SET.CHANNEL_ID as CH_ID " +
",S_SENSOR_SET.SENSOR_SET_ID as S_ID " +
"from S_DAI_SET left join S_SENSOR_SET " +
"on S_DAI_SET.DAI_SET_ID = S_SENSOR_SET.DAI_SET_ID " +
"where S_SENSOR_SET.SafeTypeID=" + idname.ID.ToString();
SQLiteDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
//sensorListBox.Items.Clear();
moChaSenIdsList.Clear();
while (reader.Read())
{
sensorList.Add("模块号:" + reader["M_NO"] + " 通道号:" + reader["CH_ID"]);
MoChaSenId moChaSenId = new MoChaSenId()
{
MoudleId = reader["M_NO"].ToString(),
ChannelId = reader["CH_ID"].ToString(),
SensorId = reader["S_ID"].ToString()
};
if (!moChaSenIdsList.Contains(moChaSenId))
{
moChaSenIdsList.Add(moChaSenId);
}
}
}
}
break;
}
}
}
catch (Exception)
{
MessageBox.Show(@"传感器表读取异常");
}
sensorSource.DataSource = sensorList;
sensorListBox.DataSource = sensorSource;
sensorSource.ResetBindings(true);
}
