//NATdatagrid绑定 public void SNATDB_Gridbinding() { try { conn.Open(); string sqlstr = "select * from snat where fwmac='" + StaticGlobal.firewallmac + "'"; StaticGlobal.FireWalldevices[StaticGlobal.firewallindex].getSNATRule_list().Clear(); StaticGlobal.SNAToldrules.Clear(); MySqlCommand cm = new MySqlCommand(sqlstr, conn); MySqlDataReader dr = cm.ExecuteReader(); //绑定 while (dr.Read()) { SNATRuleDataTable datatable = new SNATRuleDataTable(); datatable.origin_devIP = dr[1].ToString(); datatable.EthName = dr[2].ToString(); datatable.EthIP = dr[3].ToString(); datatable.NATIP = dr[4].ToString(); StaticGlobal.FireWalldevices[StaticGlobal.firewallindex].getSNATRule_list().Add(datatable); StaticGlobal.SNAToldrules.Add(datatable); } dr.Close(); } catch (Exception e) { Console.WriteLine("exceptionInfo {0}", e); } finally { conn.Close(); } }
public void addSNATRule(SNATRuleDataTable fwrdt) { SNATRuleLists.Add(fwrdt); }