private void Button_Click_4(object sender, RoutedEventArgs e)
{
SelectableViewModel sv = DG_his.SelectedItem as SelectableViewModel;
if (sv == null)
{
return;
}
Sql_Service.DeletIP(sv.ID);
DG_his.ItemsSource = CreateData();
}
private List <string> GetHisIP()
{
List <string> list = new List <string>();
DataTable dt = Sql_Service.GetHis_IP();
if (dt != null && dt.Rows.Count != 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
dic[i] = dt.Rows[i];
list.Add(dt.Rows[i]["IP"].ToString());
}
}
return(list);
}
private static ObservableCollection <SelectableViewModel> CreateData()
{
DataTable dt = Sql_Service.GetHis_IP();
ObservableCollection <SelectableViewModel> lsos = new ObservableCollection <SelectableViewModel>();
foreach (DataRow dr in dt.Rows)
{
SelectableViewModel aa = new SelectableViewModel();
aa.ID = dr["ID"].ToString();
aa.IP = dr["IP"].ToString();
aa.默认网关 = dr["gateway"].ToString();
aa.子网掩码 = dr["subnet"].ToString();
aa.DNS服务器 = dr["dns"].ToString();
lsos.Add(aa);
}
return(lsos);
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
Sql_Service.InsertIP(tb_IP.Text, tb_zym.Text, tb_mrwg.Text, tb_dns.Text);
}
