//DPIdatagrid绑定
public void DPIDB_Gridbinding()
{
try
{
conn.Open();
string sqlstring = "select * from modbustcp where fw_mac = '" + StaticGlobal.firewallmac + "'";
StaticGlobal.FireWalldevices[StaticGlobal.firewallindex].getFireWallRule_list().Clear();
StaticGlobal.oldrules.Clear();
MySqlCommand cm = new MySqlCommand(sqlstring, conn);
MySqlDataReader dr = cm.ExecuteReader();
//绑定
while (dr.Read())
{
FireWallRuleDataTable datatable = new FireWallRuleDataTable();
datatable.protocol = dr[1].ToString();
datatable.source = dr[2].ToString();
datatable.destination = dr[3].ToString();
datatable.coiladdressstart = dr[4].ToString();
datatable.coiladdressend = dr[5].ToString();
datatable.mindata = Convert.ToInt32(dr[6]);
datatable.maxdata = Convert.ToInt32(dr[7]);
datatable.func = dr[8].ToString();
datatable.log = Convert.ToBoolean(dr[9]);
StaticGlobal.FireWalldevices[StaticGlobal.firewallindex].getFireWallRule_list().Add(datatable);
StaticGlobal.oldrules.Add(datatable);
}
dr.Close();
}
catch (Exception e)
{
Console.WriteLine("exceptionInfo {0}", e);
}
finally
{
conn.Close();
}
}
public void addFireWallRule(FireWallRuleDataTable fwrdt)
{
FireWallRuleLists.Add(fwrdt);
}
