📄 main.cs
字号:
SqlDataAdapter custDA1 = new SqlDataAdapter();
custDA1.SelectCommand = selectCMD1;
//填充数据集
custDA1.Fill(custDS, "结点表");
//使用数据显示控件显示数据集中的表
//定义查询变量并初始化
SqlCommand selectCMD2 = new SqlCommand("SELECT * FROM 子系统表", connection);
//定义数据适配器,并用查询变量初始化
SqlDataAdapter custDA2 = new SqlDataAdapter();
custDA2.SelectCommand = selectCMD2;
//填充数据集
custDA2.Fill(custDS, "子系统表");
//定义查询变量并初始化
SqlCommand selectCMD3 = new SqlCommand("SELECT * FROM 传感器表", connection);
//定义数据适配器,并用查询变量初始化
SqlDataAdapter custDA3 = new SqlDataAdapter();
custDA3.SelectCommand = selectCMD3;
//填充数据集
custDA3.Fill(custDS, "传感器表");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
connection.Close();
// Suppress repainting the TreeView until all the objects have been created.
treeView1.BeginUpdate();
// Clear the TreeView each time the method is called.
treeView1.Nodes.Clear();
foreach(DataRow myRow1 in custDS.Tables[0].Rows)
{
TreeNode node1 = treeView1.Nodes.Add(myRow1[1].ToString().Trim() );
foreach(DataRow myRow2 in custDS.Tables[1].Rows) //遍历子系统中的每条记录
{
if(myRow1[0].GetHashCode() == myRow2[3].GetHashCode())
{
TreeNode node2=node1.Nodes.Add(myRow2[4].ToString().Trim());
foreach(DataRow myRow3 in custDS.Tables[2].Rows) //遍历子系统中的每条记录
{
if(myRow2[0].GetHashCode() == myRow3[3].GetHashCode())
{
//
TreeNode node3 = node2.Nodes.Add(myRow3[1].ToString().Trim());
}
}
}
}
}
// Begin repainting the TreeView.
treeView1.EndUpdate();
}
private void button1_Click(object sender, System.EventArgs e)
{
string a="cccccccc";
string b="tttttttt";
Sensor temp_sen = new Sensor(a);
temp_sen.Se_Add(79,a,b,89);
}
private void menuItem1_Click(object sender, System.EventArgs e)
{
}
private void menuItem2_Click(object sender, System.EventArgs e)
{
}
private void menuItem3_Click(object sender, System.EventArgs e)
{
}
private void menuItem4_Click(object sender, System.EventArgs e)
{
}
private void menuItem5_Click(object sender, System.EventArgs e)
{
}
private void menuItem6_Click(object sender, System.EventArgs e)
{
}
private void menuItem7_Click(object sender, System.EventArgs e)
{
}
private void menuItem8_Click(object sender, System.EventArgs e)
{
MetaData frm = new MetaData();
frm.Show();
}
private void menuItem9_Click(object sender, System.EventArgs e)
{
}
private void menuItem10_Click(object sender, System.EventArgs e)
{
}
private void menuItem11_Click(object sender, System.EventArgs e)
{
}
private void menuItem12_Click(object sender, System.EventArgs e)
{
}
private void menuItem27_Click(object sender, System.EventArgs e)
{
}
private void menuItem28_Click(object sender, System.EventArgs e)
{
SqlTable=0;
NetManage frm = new NetManage();
frm.Show();
}
private void menuItem29_Click(object sender, System.EventArgs e)
{
}
private void menuItem30_Click(object sender, System.EventArgs e)
{
}
private void menuItem31_Click(object sender, System.EventArgs e)
{
SqlTable=1;
NetManage frm = new NetManage();
frm.Show();
}
private void menuItem34_Click(object sender, System.EventArgs e)
{
}
private void menuItem32_Click(object sender, System.EventArgs e)
{
}
private void menuItem33_Click(object sender, System.EventArgs e)
{
SqlTable=2;
NetManage frm = new NetManage();
frm.Show();
}
private void menuItem35_Click(object sender, System.EventArgs e)
{
}
private void menuItem14_Click(object sender, System.EventArgs e)
{
}
private void menuItem15_Click(object sender, System.EventArgs e)
{
}
private void menuItem16_Click(object sender, System.EventArgs e)
{
}
private void menuItem13_Click(object sender, System.EventArgs e)
{
}
private void menuItem17_Click(object sender, System.EventArgs e)
{
}
private void menuItem18_Click(object sender, System.EventArgs e)
{
}
private void menuItem19_Click(object sender, System.EventArgs e)
{
}
private void menuItem20_Click(object sender, System.EventArgs e)
{
}
private void menuItem21_Click(object sender, System.EventArgs e)
{
}
private void menuItem22_Click(object sender, System.EventArgs e)
{
}
private void menuItem23_Click(object sender, System.EventArgs e)
{
}
private void menuItem24_Click(object sender, System.EventArgs e)
{
}
private void menuItem25_Click(object sender, System.EventArgs e)
{
}
private void menuItem26_Click(object sender, System.EventArgs e)
{
}
private void treeView1_DoubleClick(object sender, System.EventArgs e)
{
if(treeView1.SelectedNode.Nodes.Count ==0)
{
string File_Name=treeView1.SelectedNode.Text;
string Archive_Name=File_Name+"_"+DateTime.Now.Year.ToString()+"_"+DateTime.Now.Month.ToString()+"_"+DateTime.Now.Day.ToString();
SqlConnection conn = new System.Data.SqlClient.SqlConnection ();
conn.ConnectionString = "workstation id=local;integrated security=SSPI;" + "persist security info=False;initial catalog=Marine_network";
//打开数据连接
conn.Open();
DataSet custDS1 = new DataSet();
try
{
//定义查询变量并初始化
SqlCommand selectCMD = new SqlCommand("SELECT * FROM " + Archive_Name, conn);
//定义数据适配器,并用查询变量初始化
SqlDataAdapter custDA = new SqlDataAdapter();
custDA.SelectCommand = selectCMD;
//填充数据集
custDA.Fill(custDS1, "日志文件");
//使用数据显示控件显示数据集中的表
dataGrid1.DataSource = custDS1.Tables[0];
dataGrid1.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
conn.Close();
}
}
private void main_Closing(object sender, System.ComponentModel.CancelEventArgs e)
{
frm.Close();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -