private void login_Click(object sender, RoutedEventArgs e) { Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet"))); // 将数据加载到表 employees 中。可以根据需要修改此代码。 Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter fixedDataSetemployeesTableAdapter = new Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter(); fixedDataSetemployeesTableAdapter.Fill(fixedDataSet.employees); System.Windows.Data.CollectionViewSource employeesViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("employeesViewSource"))); employeesViewSource.View.MoveCurrentToFirst(); int s = (from c in fixedDataSet.employees where c.number == numberTextBox.Text && c.password == passwordTextBox.Password select c).Count(); var id = from c in fixedDataSet.employees where c.number == numberTextBox.Text && c.password == passwordTextBox.Password select c; //user_id foreach (var t in id) { Public.user_id = t.employees_ID; } if (s > 0) { MainWindow newmain = new MainWindow(); Application.Current.MainWindow = newmain; this.Close(); newmain.Show(); } else { MessageBox.Show( "用户名或密码有误!","提示"); } }
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.employeesTableAdapter fixedDataSetemployeesTableAdapter = new Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter(); fixedDataSetemployeesTableAdapter.Fill(fixedDataSet.employees); //System.Windows.Data.CollectionViewSource employeesViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("employeesViewSource"))); //employeesViewSource.View.MoveCurrentToFirst(); employeesDataGrid.CanUserAddRows = false; var s = from c in fixedDataSet.employees select c; foreach (var i in s) { if (i.number == "001") { } } }
private void login_Click(object sender, RoutedEventArgs e) { Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet"))); // 将数据加载到表 employees 中。可以根据需要修改此代码。 Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter fixedDataSetemployeesTableAdapter = new Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter(); fixedDataSetemployeesTableAdapter.Fill(fixedDataSet.employees); System.Windows.Data.CollectionViewSource employeesViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("employeesViewSource"))); employeesViewSource.View.MoveCurrentToFirst(); int s = (from c in fixedDataSet.employees where c.number == numberTextBox.Text && c.password == passwordTextBox.Password select c).Count(); var id = from c in fixedDataSet.employees where c.number == numberTextBox.Text && c.password == passwordTextBox.Password select c; //user_id foreach (var t in id) { Public.user_id = t.employees_ID; } if (s > 0) { MainWindow newmain = new MainWindow(); Application.Current.MainWindow = newmain; this.Close(); newmain.Show(); } else { MessageBox.Show("用户名或密码有误!", "提示"); } }
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.employeesTableAdapter fixedDataSetemployeesTableAdapter = new Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter(); fixedDataSetemployeesTableAdapter.Fill(fixedDataSet.employees); //System.Windows.Data.CollectionViewSource employeesViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("employeesViewSource"))); //employeesViewSource.View.MoveCurrentToFirst(); employeesDataGrid.CanUserAddRows = false; var s = from c in fixedDataSet.employees select c; foreach (var i in s) { if (i.number == "001") { } } }
private void add_employess_Click(object sender, RoutedEventArgs e) { Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet"))); Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter fixedDataSetemoyeesTableAdapter = new Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter(); if (checknull()) { if (passwordTextBox.Text == confirm_passwordTextBox.Text) { if (sexTextBox.Text == "") { sexTextBox.Text = ""; } if (birthdayDatePicker.Text == "") { birthdayDatePicker.SelectedDate = DateTime.Now; } if (id_numberTextBox.Text == "") { id_numberTextBox.Text = ""; } if (phoneTextBox.Text == "") { phoneTextBox.Text = ""; } if (addressTextBox.Text == "") { addressTextBox.Text = ""; } if (contentTextBox.Text == "") { contentTextBox.Text = ""; } fixedDataSet.employees.AddemployeesRow(numberTextBox.Text, em_nameTextBox.Text, passwordTextBox.Text,sexTextBox.Text, DateTime.Parse(birthdayDatePicker.Text), id_numberTextBox.Text, phoneTextBox.Text, addressTextBox.Text, contentTextBox.Text,""); fixedDataSetemoyeesTableAdapter.Update(fixedDataSet.employees); fixedDataSet.employees.AcceptChanges(); fixedDataSetemoyeesTableAdapter.Fill(fixedDataSet.employees); } else { MessageBox.Show("密码不一致!"); } } }
private void add_employess_Click(object sender, RoutedEventArgs e) { Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet"))); Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter fixedDataSetemoyeesTableAdapter = new Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter(); if (checknull()) { if (passwordTextBox.Text == confirm_passwordTextBox.Text) { if (sexTextBox.Text == "") { sexTextBox.Text = ""; } if (birthdayDatePicker.Text == "") { birthdayDatePicker.SelectedDate = DateTime.Now; } if (id_numberTextBox.Text == "") { id_numberTextBox.Text = ""; } if (phoneTextBox.Text == "") { phoneTextBox.Text = ""; } if (addressTextBox.Text == "") { addressTextBox.Text = ""; } if (contentTextBox.Text == "") { contentTextBox.Text = ""; } fixedDataSet.employees.AddemployeesRow(numberTextBox.Text, em_nameTextBox.Text, passwordTextBox.Text, sexTextBox.Text, DateTime.Parse(birthdayDatePicker.Text), id_numberTextBox.Text, phoneTextBox.Text, addressTextBox.Text, contentTextBox.Text, ""); fixedDataSetemoyeesTableAdapter.Update(fixedDataSet.employees); fixedDataSet.employees.AcceptChanges(); fixedDataSetemoyeesTableAdapter.Fill(fixedDataSet.employees); } else { MessageBox.Show("密码不一致!"); } } }
private void Window_Loaded(object sender, RoutedEventArgs e) { Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet"))); // 将数据加载到表 nature 中。可以根据需要修改此代码。 Fixed_management.FixedDataSetTableAdapters.natureTableAdapter fixedDataSetnatureTableAdapter = new Fixed_management.FixedDataSetTableAdapters.natureTableAdapter(); fixedDataSetnatureTableAdapter.Fill(fixedDataSet.nature); System.Windows.Data.CollectionViewSource natureViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("natureViewSource"))); natureViewSource.View.MoveCurrentToFirst(); Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter fixedDataSetemployeesTableAdapter = new Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter(); fixedDataSetemployeesTableAdapter.Fill(fixedDataSet.employees); dockingManager.Height = SystemParameters.PrimaryScreenHeight - 150; string user = fixedDataSet.employees.FindByemployees_ID(Public.user_id).em_name; StackPanel newstack = new StackPanel(); newstack.Opacity = 0.65; newstack.Height = 28; // newstack.Background = Brushes.Red; newstack.VerticalAlignment = VerticalAlignment.Bottom; TextBlock newtextblock = new TextBlock(); newtextblock.VerticalAlignment = VerticalAlignment.Center; newtextblock.Height = 28; newtextblock.FontSize = 20; newtextblock.Margin = new Thickness(200, 0, 0, 0); newtextblock.Text = "当前登录 :" + user; newstack.Children.Add(newtextblock); mainwindow.Children.Add(newstack); permissions(); }
private void delete_Click(object sender, RoutedEventArgs e) { var t = employeesDataGrid.SelectedItem; var b = t as DataRowView; int s = int.Parse(b.Row[0].ToString()); string num = b.Row[1].ToString(); Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet"))); // 将数据加载到表 nature 中。可以根据需要修改此代码。 Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter fixedDataSetemployeesTableAdapter = new Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter(); if (num == "admin") { MessageBox.Show("无法删除管理员", "提示"); } else { fixedDataSet.employees.FindByemployees_ID(s).Delete(); fixedDataSetemployeesTableAdapter.Update(fixedDataSet.employees); fixedDataSetemployeesTableAdapter.Fill(fixedDataSet.employees); fixedDataSet.employees.AcceptChanges(); } }
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 // } int i = u_id; Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet"))); // 将数据加载到表 nature 中。可以根据需要修改此代码。 Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter fixedDataSetemployeesTableAdapter = new Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter(); fixedDataSetemployeesTableAdapter.Fill(fixedDataSet.employees); radioButton1.IsChecked = true; if (u_id > 0) { numberTextBox.Text = fixedDataSet.employees.FindByemployees_ID(u_id).number.ToString(); em_nameTextBox.Text = fixedDataSet.employees.FindByemployees_ID(u_id).em_name; passwordTextBox.Text = fixedDataSet.employees.FindByemployees_ID(u_id).password; confirm_passwordTextBox.Text = fixedDataSet.employees.FindByemployees_ID(u_id).password; if (fixedDataSet.employees.FindByemployees_ID(u_id).sex == "男") { radioButton1.IsChecked = true; } else { radioButton2.IsChecked = true; } phoneTextBox.Text = fixedDataSet.employees.FindByemployees_ID(u_id).phone; addressTextBox.Text = fixedDataSet.employees.FindByemployees_ID(u_id).address; contentTextBox.Text = fixedDataSet.employees.FindByemployees_ID(u_id).content; load_check(); } }
private void confirm_Click(object sender, RoutedEventArgs e) { Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet"))); // 将数据加载到表 nature 中。可以根据需要修改此代码。 Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter fixedDataSetemployeesTableAdapter = new Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter(); fixedDataSetemployeesTableAdapter.Fill(fixedDataSet.employees); System.Windows.Data.CollectionViewSource employeesViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("employeesViewSource"))); //employeesViewSource.View.MoveCurrentToFirst(); if (isnull()) { ischeck(); if (u_id < 1) { var s = from c in fixedDataSet.employees where c.number == numberTextBox.Text select c; if (s.Count() > 0) { MessageBox.Show("员工编号已存在", "提示"); } else { if (confirm_passwordTextBox.Text != passwordTextBox.Text) { MessageBox.Show("密码前后不一致", "提示"); } else { string sex = ""; if ((bool)radioButton1.IsChecked) { sex = "男"; } else { sex = "女"; } fixedDataSet.employees.AddemployeesRow(numberTextBox.Text, em_nameTextBox.Text, passwordTextBox.Text, sex, DateTime.Now, "123456789", phoneTextBox.Text, addressTextBox.Text, contentTextBox.Text, permsis); fixedDataSetemployeesTableAdapter.Update(fixedDataSet.employees); fixedDataSet.AcceptChanges(); fixedDataSetemployeesTableAdapter.Fill(fixedDataSet.employees); MessageBox.Show("添加成功!", "提示"); C1.WPF.C1Window findfixed = MainWindow.FindChild <C1.WPF.C1Window>(Application.Current.MainWindow, "employeeswindow1"); if (findfixed != null) { findfixed.Close(); } } } } else { //employeesViewSource.View.MoveCurrentToNext(); //fixedDataSetemployeesTableAdapter.Update(fixedDataSet.employees); var q = from c in fixedDataSet.employees where c.employees_ID == u_id select c; foreach (var t in q) { t.number = numberTextBox.Text; t.em_name = em_nameTextBox.Text; t.password = passwordTextBox.Text; if ((bool)radioButton1.IsChecked) { t.sex = "男"; } else { t.sex = "女"; } t.phone = phoneTextBox.Text; t.address = addressTextBox.Text; t.content = contentTextBox.Text; t.pemissions = permsis; } //confirm_passwordTextBox.Text = passwordTextBox.Text; if (confirm_passwordTextBox.Text != passwordTextBox.Text) { MessageBox.Show("密码前后不一致", "提示"); } else { fixedDataSetemployeesTableAdapter.Update(fixedDataSet.employees); C1.WPF.C1Window findfixed = MainWindow.FindChild <C1.WPF.C1Window>(Application.Current.MainWindow, "employeeswindow2"); if (findfixed != null) { findfixed.Close(); } } } //Expander ed = sender as Expander; //C1.WPF.C1Window findfixed = ed.Parent as C1.WPF.C1Window; //if (findfixed != null) //{ // findfixed.Close(); //} //Userlist list = MainWindow.FindChild<Userlist>(Application.Current.MainWindow, "newuserlist"); //var a = from c in fixedDataSet.employees select c; //if (list != null) //{ // list.employeesDataGrid.ItemsSource = a; // //list.UpdateLayout(); // list.employeesDataGrid.UpdateLayout(); //} //RoutedPropertyChangedEventArgs<object> args = new RoutedPropertyChangedEventArgs<object>(this, e); //args.RoutedEvent = userdetail.C1WindowEvent; //this.RaiseEvent(args); } }
private void load_check() { Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet"))); // 将数据加载到表 nature 中。可以根据需要修改此代码。 Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter fixedDataSetemployeesTableAdapter = new Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter(); fixedDataSetemployeesTableAdapter.Fill(fixedDataSet.employees); string em_p = fixedDataSet.employees.FindByemployees_ID(u_id).pemissions; per_list = em_p.Split('f'); foreach (string s in per_list) { if (s == "3") { radioButton3.IsChecked = true; } if (s == "4") { radioButton4.IsChecked = true; } if (s == "5") { radioButton5.IsChecked = true; } if (s == "6") { radioButton6.IsChecked = true; } if (s == "7") { radioButton7.IsChecked = true; } if (s == "8") { radioButton8.IsChecked = true; } if (s == "9") { radioButton9.IsChecked = true; } if (s == "10") { radioButton10.IsChecked = true; } if (s == "11") { radioButton11.IsChecked = true; } if (s == "12") { radioButton12.IsChecked = true; } if (s == "13") { radioButton13.IsChecked = true; } if (s == "14") { radioButton14.IsChecked = true; } if (s == "15") { radioButton15.IsChecked = true; } if (s == "16") { radioButton16.IsChecked = true; } if (s == "17") { radioButton17.IsChecked = true; } if (s == "18") { radioButton18.IsChecked = true; } if (s == "19") { radioButton19.IsChecked = true; } if (s == "20") { radioButton20.IsChecked = true; } if (s == "21") { radioButton21.IsChecked = true; } } }
private void delete_Click(object sender, RoutedEventArgs e) { var t = employeesDataGrid.SelectedItem; var b = t as DataRowView; int s = int.Parse(b.Row[0].ToString()); string num = b.Row[1].ToString(); Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet"))); // 将数据加载到表 nature 中。可以根据需要修改此代码。 Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter fixedDataSetemployeesTableAdapter = new Fixed_management.FixedDataSetTableAdapters.employeesTableAdapter(); if (num == "admin") { MessageBox.Show("无法删除管理员", "提示"); } else { fixedDataSet.employees.FindByemployees_ID(s).Delete(); fixedDataSetemployeesTableAdapter.Update(fixedDataSet.employees); fixedDataSetemployeesTableAdapter.Fill(fixedDataSet.employees); fixedDataSet.employees.AcceptChanges(); } }