//PRTdatagrid绑定
public void PRTDB_Gridbinding()
{
try
{
conn.Open();
string sqlstr = "select * from prt where fwmac='" + StaticGlobal.firewallmac + "'";
StaticGlobal.FireWalldevices[StaticGlobal.firewallindex].getFireWallPRTRule_list().Clear();
StaticGlobal.PRToldrules.Clear();
MySqlCommand cm = new MySqlCommand(sqlstr, conn);
MySqlDataReader dr = cm.ExecuteReader();
//绑定
while (dr.Read())
{
PRTRuleDataTable datatable = new PRTRuleDataTable();
datatable.route_type = dr[1].ToString();
datatable.host_IP = dr[2].ToString();
datatable.dstIP = dr[3].ToString();
datatable.netmask = dr[4].ToString();
datatable.ETH = dr[5].ToString();
datatable.log = Convert.ToBoolean(dr[6]);
datatable.Gateway = dr[7].ToString();
StaticGlobal.FireWalldevices[StaticGlobal.firewallindex].getFireWallPRTRule_list().Add(datatable);
StaticGlobal.PRToldrules.Add(datatable);
}
dr.Close();
}
catch (Exception e)
{
Console.WriteLine("exceptionInfo {0}", e);
}
finally
{
conn.Close();
}
}
public void addFireWallPRTRule(PRTRuleDataTable fwrdt)
{
FireWallPRTLists.Add(fwrdt);
}
