private void typeComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
fcb_public.publicDataSet publicDataSet = ((fcb_public.publicDataSet)(this.FindResource("publicDataSet")));
fcb_public.publicDataSetTableAdapters.el_elsetTableAdapter publicDataSetel_elsetTableAdapter = new fcb_public.publicDataSetTableAdapters.el_elsetTableAdapter();
if (iDTextBox.Text != "")
{
if (typeComboBox.SelectedIndex == 0)
{
type = "文档";
add_el_elset(int.Parse(iDTextBox.Text));
}
else if (typeComboBox.SelectedIndex == 1)
{
type = "图片";
add_el_elset(int.Parse(iDTextBox.Text));
}
else if (typeComboBox.SelectedIndex == 2)
{
type = "视频";
add_el_elset(int.Parse(iDTextBox.Text));
}
var select_id = from c in publicDataSet.el_elset where int.Parse(iDTextBox.Text) == c.element_set_ID select c;
foreach (var s in select_id)
{
publicDataSet.el_elset.FindByID(s.ID).Delete();
}
publicDataSetel_elsetTableAdapter.Update(publicDataSet.el_elset);
publicDataSet.el_elset.AcceptChanges();
publicDataSetel_elsetTableAdapter.Fill(publicDataSet.el_elset);
dlist.Items.Clear();
}
}
private void move_to_s_Click(object sender, RoutedEventArgs e)
{
fcb_public.publicDataSet publicDataSet = ((fcb_public.publicDataSet)(this.FindResource("publicDataSet")));
fcb_public.publicDataSetTableAdapters.el_elsetTableAdapter publicDataSetel_elsetTableAdapter = new fcb_public.publicDataSetTableAdapters.el_elsetTableAdapter();
StackPanel newstack = (StackPanel)dlist.SelectedItem;
if (newstack != null)
{
foreach (var t in newstack.Children)
{
TextBlock newtxt = t as TextBlock;
if (newtxt.Name == "idtxt")
{
int element_id = int.Parse(newtxt.Text);
//publicDataSet.el_elset.Addel_elsetRow(element_id, int.Parse(iDTextBox.Text));
//publicDataSet.el_elsetRow del_row = (publicDataSet.el_elsetRow)from c in publicDataSet.el_elset where c.element_ID == int.Parse(newtxt.Text) && c.element_set_ID == int.Parse(iDTextBox.Text) select c;
List <int> el_elset_id = (from c in publicDataSet.el_elset where c.element_ID == int.Parse(newtxt.Text) && c.element_set_ID == int.Parse(iDTextBox.Text) select c.ID).ToList();
//publicDataSet.el_elset.Rows[el_elset_id[0]].Delete();
publicDataSet.el_elset.FindByID(el_elset_id[0]).Delete();
publicDataSetel_elsetTableAdapter.Update(publicDataSet.el_elset);
publicDataSet.el_elset.AcceptChanges();
publicDataSetel_elsetTableAdapter.Fill(publicDataSet.el_elset);
add_el_elset(int.Parse(iDTextBox.Text));
break;
}
}
//TextBlock newblock = newstack.FindName("idtxt") as TextBlock;
}
}
private void move_to_d_Click(object sender, RoutedEventArgs e)
{
fcb_public.publicDataSet publicDataSet = ((fcb_public.publicDataSet)(this.FindResource("publicDataSet")));
fcb_public.publicDataSetTableAdapters.el_elsetTableAdapter publicDataSetel_elsetTableAdapter = new fcb_public.publicDataSetTableAdapters.el_elsetTableAdapter();
StackPanel newstack = (StackPanel)slist.SelectedItem;
if (newstack != null)
{
foreach (var t in newstack.Children)
{
TextBlock newtxt = t as TextBlock;
if (newtxt.Name == "idtxt")
{
int element_id = int.Parse(newtxt.Text);
int a = int.Parse(iDTextBox.Text);
publicDataSet.el_elset.Addel_elsetRow(element_id, a);
publicDataSetel_elsetTableAdapter.Update(publicDataSet.el_elset);
publicDataSet.el_elset.AcceptChanges();
publicDataSetel_elsetTableAdapter.Fill(publicDataSet.el_elset);
add_el_elset(int.Parse(iDTextBox.Text));
break;
}
}
//TextBlock newblock = newstack.FindName("idtxt") as TextBlock;
}
}
private void del_elset_Click(object sender, RoutedEventArgs e)
{
fcb_public.publicDataSet publicDataSet = ((fcb_public.publicDataSet)(this.FindResource("publicDataSet")));
fcb_public.publicDataSetTableAdapters.element_setTableAdapter publicDataSetelement_setTableAdapter = new fcb_public.publicDataSetTableAdapters.element_setTableAdapter();
// fcb_public.publicDataSet publicDataSet = ((fcb_public.publicDataSet)(this.FindResource("publicDataSet")));
fcb_public.publicDataSetTableAdapters.el_elsetTableAdapter publicDataSetel_elsetTableAdapter = new fcb_public.publicDataSetTableAdapters.el_elsetTableAdapter();
if (iDTextBox.Text != "")
{
int index = int.Parse(iDTextBox.Text);
publicDataSet.element_set.FindByID(index).Delete();
publicDataSetelement_setTableAdapter.Update(publicDataSet.element_set);
publicDataSet.element_set.AcceptChanges();
publicDataSetelement_setTableAdapter.Fill(publicDataSet.element_set);
var select_id = from c in publicDataSet.el_elset where index == c.element_set_ID select c;
foreach (var s in select_id)
{
publicDataSet.el_elset.FindByID(s.ID).Delete();
}
publicDataSetel_elsetTableAdapter.Update(publicDataSet.el_elset);
publicDataSet.el_elset.AcceptChanges();
publicDataSetel_elsetTableAdapter.Fill(publicDataSet.el_elset);
}
}
private void typeComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
fcb_public.publicDataSet publicDataSet = ((fcb_public.publicDataSet)(this.FindResource("publicDataSet")));
fcb_public.publicDataSetTableAdapters.el_elsetTableAdapter publicDataSetel_elsetTableAdapter = new fcb_public.publicDataSetTableAdapters.el_elsetTableAdapter();
if (iDTextBox.Text != "")
{
if (typeComboBox.SelectedIndex == 0)
{
type = "文档";
add_el_elset(int.Parse(iDTextBox.Text));
}
else if (typeComboBox.SelectedIndex == 1)
{
type = "图片";
add_el_elset(int.Parse(iDTextBox.Text));
}
else if (typeComboBox.SelectedIndex == 2)
{
type = "视频";
add_el_elset(int.Parse(iDTextBox.Text));
}
var select_id = from c in publicDataSet.el_elset where int.Parse(iDTextBox.Text) == c.element_set_ID select c;
foreach (var s in select_id)
{
publicDataSet.el_elset.FindByID(s.ID).Delete();
}
publicDataSetel_elsetTableAdapter.Update(publicDataSet.el_elset);
publicDataSet.el_elset.AcceptChanges();
publicDataSetel_elsetTableAdapter.Fill(publicDataSet.el_elset);
dlist.Items.Clear();
}
}
private void move_to_s_Click(object sender, RoutedEventArgs e)
{
fcb_public.publicDataSet publicDataSet = ((fcb_public.publicDataSet)(this.FindResource("publicDataSet")));
fcb_public.publicDataSetTableAdapters.el_elsetTableAdapter publicDataSetel_elsetTableAdapter = new fcb_public.publicDataSetTableAdapters.el_elsetTableAdapter();
StackPanel newstack = (StackPanel)dlist.SelectedItem;
if (newstack != null)
{
foreach (var t in newstack.Children)
{
TextBlock newtxt = t as TextBlock;
if (newtxt.Name == "idtxt")
{
int element_id = int.Parse(newtxt.Text);
//publicDataSet.el_elset.Addel_elsetRow(element_id, int.Parse(iDTextBox.Text));
//publicDataSet.el_elsetRow del_row = (publicDataSet.el_elsetRow)from c in publicDataSet.el_elset where c.element_ID == int.Parse(newtxt.Text) && c.element_set_ID == int.Parse(iDTextBox.Text) select c;
List<int> el_elset_id = (from c in publicDataSet.el_elset where c.element_ID == int.Parse(newtxt.Text) && c.element_set_ID == int.Parse(iDTextBox.Text) select c.ID).ToList();
//publicDataSet.el_elset.Rows[el_elset_id[0]].Delete();
publicDataSet.el_elset.FindByID(el_elset_id[0]).Delete();
publicDataSetel_elsetTableAdapter.Update(publicDataSet.el_elset);
publicDataSet.el_elset.AcceptChanges();
publicDataSetel_elsetTableAdapter.Fill(publicDataSet.el_elset);
add_el_elset(int.Parse(iDTextBox.Text));
break;
}
}
//TextBlock newblock = newstack.FindName("idtxt") as TextBlock;
}
}
private void move_to_d_Click(object sender, RoutedEventArgs e)
{
fcb_public.publicDataSet publicDataSet = ((fcb_public.publicDataSet)(this.FindResource("publicDataSet")));
fcb_public.publicDataSetTableAdapters.el_elsetTableAdapter publicDataSetel_elsetTableAdapter = new fcb_public.publicDataSetTableAdapters.el_elsetTableAdapter();
StackPanel newstack = (StackPanel)slist.SelectedItem;
if (newstack != null)
{
foreach (var t in newstack.Children)
{
TextBlock newtxt = t as TextBlock;
if (newtxt.Name == "idtxt")
{
int element_id = int.Parse(newtxt.Text);
int a=int.Parse(iDTextBox.Text);
publicDataSet.el_elset.Addel_elsetRow(element_id,a );
publicDataSetel_elsetTableAdapter.Update(publicDataSet.el_elset);
publicDataSet.el_elset.AcceptChanges();
publicDataSetel_elsetTableAdapter.Fill(publicDataSet.el_elset);
add_el_elset(int.Parse(iDTextBox.Text));
break;
}
}
//TextBlock newblock = newstack.FindName("idtxt") as TextBlock;
}
}
private void del_elset_Click(object sender, RoutedEventArgs e)
{
fcb_public.publicDataSet publicDataSet = ((fcb_public.publicDataSet)(this.FindResource("publicDataSet")));
fcb_public.publicDataSetTableAdapters.element_setTableAdapter publicDataSetelement_setTableAdapter = new fcb_public.publicDataSetTableAdapters.element_setTableAdapter();
// fcb_public.publicDataSet publicDataSet = ((fcb_public.publicDataSet)(this.FindResource("publicDataSet")));
fcb_public.publicDataSetTableAdapters.el_elsetTableAdapter publicDataSetel_elsetTableAdapter = new fcb_public.publicDataSetTableAdapters.el_elsetTableAdapter();
if (iDTextBox.Text != "")
{
int index=int.Parse(iDTextBox.Text);
publicDataSet.element_set.FindByID(index).Delete();
publicDataSetelement_setTableAdapter.Update(publicDataSet.element_set);
publicDataSet.element_set.AcceptChanges();
publicDataSetelement_setTableAdapter.Fill(publicDataSet.element_set);
var select_id = from c in publicDataSet.el_elset where index == c.element_set_ID select c;
foreach (var s in select_id)
{
publicDataSet.el_elset.FindByID(s.ID).Delete();
}
publicDataSetel_elsetTableAdapter.Update(publicDataSet.el_elset);
publicDataSet.el_elset.AcceptChanges();
publicDataSetel_elsetTableAdapter.Fill(publicDataSet.el_elset);
}
}
