private void button_del_Click(object sender, EventArgs e)
{
rowNum = getRow();//获取datagriadview行号
string nodeName = dataGridView1.Rows[rowNum].Cells["Device_Name"].Value.ToString();
if (dataGridView1.CurrentCell.RowIndex >= 0)
{
if (MessageBox.Show("你确定要删除吗？", "确定", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
string sql = "DELETE FROM device WHERE Device_ID = ";
sql += "'" + dataGridView1.Rows[rowNum].Cells[0].Value.ToString() + "'";
dbMySql.Open(databaseName);
dbMySql.ExcuteNonQuery(databaseName, sql);
dbMySql.Close(databaseName);
deleteRow(rowNum);
dataGridView1.Update();
TreeExXML.TreeExXMLCls xt2 = new TreeExXML.TreeExXMLCls();
xt2.DeleteXmlNodeByXPath("D:\\MyVidio\\myxml.xml", null, nodeName);
fath.ReloadTreeView();
}
else
{
MessageBox.Show("没有选中的记录，请选择!");
}
}
}
private void button_Update_Click(object sender, EventArgs e)
{
AlarmParameter temp = new AlarmParameter();
temp.fuc = "update";
temp.Title = "update";
temp.selectIndex = dataGridView1.CurrentCell.RowIndex;
string nodeName = dataGridView1.Rows[temp.selectIndex].Cells["Device_Name"].Value.ToString();
AddCollection add = new AddCollection(temp, this);
add.Owner = this;
if (add.ShowDialog() == DialogResult.OK)
{
if (add.newDeviceName != nodeName)
{
TreeExXML.TreeExXMLCls xt2 = new TreeExXML.TreeExXMLCls();
xt2.UpdateXmlNodeByXPath("D:\\MyVidio\\myxml.xml", add.newDeviceName, nodeName);
fath.ReloadTreeView();
}
}
}
