private void checkmultitable() { Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet"))); // 将数据加载到表 nature 中。可以根据需要修改此代码。 Fixed_management.FixedDataSetTableAdapters.exit_wayTableAdapter fixedDataSetexit_wayTableAdapter = new Fixed_management.FixedDataSetTableAdapters.exit_wayTableAdapter(); System.Windows.Data.CollectionViewSource exit_wayViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("exit_wayViewSource"))); Fixed_management.FixedDataSetTableAdapters.operatorTableAdapter fixedDataSetoperatorTableAdapter = new Fixed_management.FixedDataSetTableAdapters.operatorTableAdapter(); System.Windows.Data.CollectionViewSource operatorViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("operatorViewSource"))); var exit_way = (from c in fixedDataSet.exit_way where c.way == exit_way_IDC1ComboBox.Text select c).Count(); var _operator = (from c in fixedDataSet._operator where c._operator == operator_IDC1ComboBox.Text select c).Count(); if (exit_way == 0) { fixedDataSet.exit_way.Addexit_wayRow(exit_way_IDC1ComboBox.Text); fixedDataSetexit_wayTableAdapter.Update(fixedDataSet.exit_way); fixedDataSetexit_wayTableAdapter.Fill(fixedDataSet.exit_way); exit_wayViewSource.View.MoveCurrentToLast(); } if (_operator == 0) { fixedDataSet._operator.AddoperatorRow(operator_IDC1ComboBox.Text); fixedDataSetoperatorTableAdapter.Update(fixedDataSet._operator); fixedDataSetoperatorTableAdapter.Fill(fixedDataSet._operator); operatorViewSource.View.MoveCurrentToLast(); } }
private void UserControl_Loaded(object sender, RoutedEventArgs e) { // 不要在设计时加载数据。 // if (!System.ComponentModel.DesignerProperties.GetIsInDesignMode(this)) // { // //在此处加载数据并将结果指派给 CollectionViewSource。 // System.Windows.Data.CollectionViewSource myCollectionViewSource = (System.Windows.Data.CollectionViewSource)this.Resources["Resource Key for CollectionViewSource"]; // myCollectionViewSource.Source = your data // } Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet"))); // 将数据加载到表 nature 中。可以根据需要修改此代码。 Fixed_management.FixedDataSetTableAdapters.fixednameTableAdapter fixednameTableAdapter = new Fixed_management.FixedDataSetTableAdapters.fixednameTableAdapter(); fixednameTableAdapter.Fill(fixedDataSet.fixedname); System.Windows.Data.CollectionViewSource fixednameViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("fixednameViewSource"))); fixednameViewSource.View.MoveCurrentToFirst(); Fixed_management.FixedDataSetTableAdapters.exit_wayTableAdapter fixedDataSetexit_wayTableAdapter = new Fixed_management.FixedDataSetTableAdapters.exit_wayTableAdapter(); fixedDataSetexit_wayTableAdapter.Fill(fixedDataSet.exit_way); System.Windows.Data.CollectionViewSource exit_wayViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("exit_wayViewSource"))); exit_wayViewSource.View.MoveCurrentToFirst(); Fixed_management.FixedDataSetTableAdapters.operatorTableAdapter fixedDataSetoperatorableAdapter = new Fixed_management.FixedDataSetTableAdapters.operatorTableAdapter(); fixedDataSetoperatorableAdapter.Fill(fixedDataSet._operator); System.Windows.Data.CollectionViewSource operatorViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("operatorViewSource"))); operatorViewSource.View.MoveCurrentToFirst(); fixednameDataGrid.CanUserAddRows = false; exit_dateDatePicker.SelectedDate = DateTime.Now; exit_select.Margin = new Thickness(SystemParameters.PrimaryScreenWidth - 100, 10, 0, 0); textBox1.Margin = new Thickness(SystemParameters.PrimaryScreenWidth - 230, 10, 0, 0); }