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