//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); }