private void barcode_LostKeyboardFocus(object sender, KeyboardFocusChangedEventArgs e)
{
Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet")));
Fixed_management.FixedDataSetTableAdapters.fixedTableAdapter fixedDataSetfixedTableAdapter = new Fixed_management.FixedDataSetTableAdapters.fixedTableAdapter();
if (barcode.Text != "")
{
string s = barcode.Text.Substring(barcode.Text.Length - 1, 1);
Regex regNum = new Regex("^[0-9]");
//string f="";
if (regNum.IsMatch(s))
{
var barco = (from c in fixedDataSet._fixed where c.barcode == barcode.Text select c).Count();
if (barco > 0)
{
MessageBox.Show("该编号已经存在！");
}
}
else
{
MessageBox.Show("最后一个字符必须为数字！");
barcode.Focus();
}
}
}
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);
}
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();
}
}
void newemployees_C1Window(object sender, RoutedPropertyChangedEventArgs <object> e)
{
Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet")));
var a = from c in fixedDataSet.employees select c;
employeesDataGrid.ItemsSource = a;
}
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 del_assets_Click(object sender, RoutedEventArgs e)
{
Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet")));
Fixed_management.FixedDataSetTableAdapters.fixedTableAdapter fixedTableAdapter = new Fixed_management.FixedDataSetTableAdapters.fixedTableAdapter();
fixedTableAdapter.Fill(fixedDataSet._fixed);
for (int i = 0; i < fixed_delDataGrid.Items.Count; i++)
{
DataGridTemplateColumn templeColumn = fixed_delDataGrid.Columns[0] as DataGridTemplateColumn;
FrameworkElement s = fixed_delDataGrid.Columns[0].GetCellContent(fixed_delDataGrid.Items[i]);
CheckBox tbOper = templeColumn.CellTemplate.FindName("checkbox", s) as CheckBox;
DataRowView mySelectedElement = (DataRowView)fixed_delDataGrid.Items[i];
int fixed_del_id = int.Parse(mySelectedElement.Row[31].ToString());
if ((bool)tbOper.IsChecked)
{
var Vdel_status = from c in fixedDataSet._fixed where c.fixed_ID == fixed_del_id select c;
foreach (var a in Vdel_status)
{
a.del_status = "2";
}
}
}
fixedTableAdapter.Update(fixedDataSet._fixed);
fixedDataSet._fixed.AcceptChanges();
fixedTableAdapter.Fill(fixedDataSet._fixed);
Fixed_management.FixedDataSetTableAdapters.fixed_delTableAdapter fixed_delTableAdapter = new Fixed_management.FixedDataSetTableAdapters.fixed_delTableAdapter();
fixedDataSet.fixedname.AcceptChanges();
fixed_delTableAdapter.Fill(fixedDataSet.fixed_del);
}
private void delete_fixed_Click(object sender, RoutedEventArgs e)
{
Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet")));
// 将数据加载到表 nature 中。可以根据需要修改此代码。
Fixed_management.FixedDataSetTableAdapters.fixed_del_queryTableAdapter fixed_del_queryTableAdapter = new Fixed_management.FixedDataSetTableAdapters.fixed_del_queryTableAdapter();
//fixed_del_queryTableAdapter.Fill(fixedDataSet.fixed_del_query);
Fixed_management.FixedDataSetTableAdapters.fixedTableAdapter fixedTableAdapter = new Fixed_management.FixedDataSetTableAdapters.fixedTableAdapter();
fixedTableAdapter.Fill(fixedDataSet._fixed);
for (int i = 0; i < fixed_del_queryDataGrid.Items.Count; i++)
{
DataGridTemplateColumn templeColumn = fixed_del_queryDataGrid.Columns[0] as DataGridTemplateColumn;
FrameworkElement s = fixed_del_queryDataGrid.Columns[0].GetCellContent(fixed_del_queryDataGrid.Items[i]);
CheckBox tbOper = templeColumn.CellTemplate.FindName("checkbox", s) as CheckBox;
DataRowView mySelectedElement = (DataRowView)fixed_del_queryDataGrid.Items[i];
int fixed_del_id = int.Parse(mySelectedElement.Row[32].ToString());
if ((bool)tbOper.IsChecked)
{
fixedDataSet._fixed.FindByfixed_ID(fixed_del_id).Delete();
}
fixedTableAdapter.Update(fixedDataSet._fixed);
fixedDataSet._fixed.AcceptChanges();
}
fixedDataSet.fixed_del_query.AcceptChanges();
fixed_del_queryTableAdapter.Fill(fixedDataSet.fixed_del_query);
}
private void select_Click(object sender, RoutedEventArgs e)
{
//C1.WPF.C1Window newselect = new C1.WPF.C1Window();
//newselect.Name = "selecteff";
//newselect.Width = 400;
//newselect.Height = 500;
//newselect.IsResizable = false;
//newselect.ShowMaximizeButton = false;
//newselect.ShowMinimizeButton = false;
//newselect.Margin = new Thickness(SystemParameters.PrimaryScreenWidth / 2d - 250, SystemParameters.PrimaryScreenHeight / 2d - 250, 0, 0);
//newselect.Show();
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")));
if (textBox1.Text != "")
{
var s = from c in fixedDataSet.fixedname where c.storage_place == textBox1.Text || c.barcode == textBox1.Text || c.limit == int.Parse(textBox1.Text) || c.fixed_number == int.Parse(textBox1.Text) || c.fixed_vale == textBox1.Text || c.factory_number == textBox1.Text || c.fixed_encoding == textBox1.Text || c.warranty == int.Parse(textBox1.Text) || c.account_number == textBox1.Text || c.fixed_asset == textBox1.Text || c.card_number == textBox1.Text || c.nature == textBox1.Text || c.category == textBox1.Text || c.specifications == textBox1.Text || c.designation == textBox1.Text || c.model == textBox1.Text || c.unit == textBox1.Text || c.purchase_way == textBox1.Text || c.keeper == textBox1.Text || c.supplier == textBox1.Text || c.position == textBox1.Text || c.fixed_status == textBox1.Text || c.user == textBox1.Text || c._operator == textBox1.Text || c.affiliated == textBox1.Text || c.department == textBox1.Text || c.content == textBox1.Text select c;
fixednameDataGrid.ItemsSource = s;
}
else
{
var s = from c in fixedDataSet.fixedname select c;
fixednameDataGrid.ItemsSource = s;
}
}
private bool check_repat(int i)
{
Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet")));
Fixed_management.FixedDataSetTableAdapters.fixedTableAdapter fixedTableAdapter = new Fixed_management.FixedDataSetTableAdapters.fixedTableAdapter();
fixedTableAdapter.Fill(fixedDataSet._fixed);
var Vaffiliated = from c in fixedDataSet.affiliated where c.affiliated == affiliated_IDC1ComboBox.Text select c;
int Iaffiliated = 0;
foreach (var a in Vaffiliated)
{
Iaffiliated = a.affiliated_ID;
break;
}
var Vdepartment = from c in fixedDataSet.department where c.department == department_IDC1ComboBox.Text select c;
int Idepartment = 0;
foreach (var a in Vdepartment)
{
Idepartment = a.department_ID;
break;
}
var Vstorage_place = from c in fixedDataSet.storage_place where c.storage_place == storage_place_IDC1ComboBox.Text select c;
int Istorage_place = 0;
foreach (var a in Vstorage_place)
{
Istorage_place = a.storage_place_ID;
break;
}
var Vkeeper = from c in fixedDataSet.keeper where c.keeper == keeper_IDC1ComboBox.Text select c;
int Ikeeper = 0;
foreach (var a in Vkeeper)
{
Ikeeper = a.keeper_ID;
break;
}
int s = (from c in fixedDataSet._fixed where c.affiliated_ID == Iaffiliated && c.department_ID == Idepartment && c.keeper_ID == Ikeeper && c.storage_place_ID == Istorage_place && c.fixed_ID == i select c).Count();
if (s > 0)
{
return(false);
}
else
{
return(true);
}
}
private void fix_outtool_Click(object sender, RoutedEventArgs e)
{
Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet")));
Fixed_management.FixedDataSetTableAdapters.fixedTableAdapter fixedTableAdapter = new Fixed_management.FixedDataSetTableAdapters.fixedTableAdapter();
fixedTableAdapter.Fill(fixedDataSet._fixed);
if (checknull())
{
checkmultitable();
for (int i = 0; i < fixednameDataGrid.Items.Count; i++)
{
DataGridTemplateColumn templeColumn = fixednameDataGrid.Columns[0] as DataGridTemplateColumn;
FrameworkElement s = fixednameDataGrid.Columns[0].GetCellContent(fixednameDataGrid.Items[i]);
CheckBox tbOper = templeColumn.CellTemplate.FindName("checkbox", s) as CheckBox;
DataRowView mySelectedElement = (DataRowView)fixednameDataGrid.Items[i];
int fixedname_id = int.Parse(mySelectedElement.Row[32].ToString());
if ((bool)tbOper.IsChecked)
{
var Voperator = from c in fixedDataSet._operator where c._operator == operator_IDC1ComboBox.Text select c;
int Ioperator = 0;
foreach (var a in Voperator)
{
Ioperator = a.operator_ID;
break;
}
var Vexit_way = from c in fixedDataSet.exit_way where c.way == exit_way_IDC1ComboBox.Text select c;
int Iexit_way = 0;
foreach (var a in Vexit_way)
{
Iexit_way = a.exit_way_ID;
break;
}
var select_count = from c in fixedDataSet._fixed where c.fixed_ID == fixedname_id select c;
foreach (var enable in select_count)
{
enable.enable_status = "2";
enable.exit_date = DateTime.Parse(exit_dateDatePicker.Text);
enable.operator_ID = Ioperator;
enable.exit_way_ID = Iexit_way;
}
}
}
fixedTableAdapter.Update(fixedDataSet._fixed);
fixedDataSet._fixed.AcceptChanges();
fixedTableAdapter.Fill(fixedDataSet._fixed);
}
Fixed_management.FixedDataSetTableAdapters.fixednameTableAdapter fixednameTableAdapter = new Fixed_management.FixedDataSetTableAdapters.fixednameTableAdapter();
fixedDataSet.fixedname.AcceptChanges();
fixednameTableAdapter.Fill(fixedDataSet.fixedname);
}
private void transfer_detail()
{
Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet")));
Fixed_management.FixedDataSetTableAdapters.transfer_detailTableAdapter transfer_detailTableAdapter = new Fixed_management.FixedDataSetTableAdapters.transfer_detailTableAdapter();
//DateTime s = DateTime.Parse(transfer_dateDatePicker.Text);
fixedDataSet.transfer_detail.Addtransfer_detailRow(DateTime.Parse(transfer_dateDatePicker.Text), barcode, old_affiliated, old_department, old_keeper, old_storage_place, affiliated_IDC1ComboBox.Text, department_IDC1ComboBox.Text, keeper_IDC1ComboBox.Text, storage_place_IDC1ComboBox.Text);
transfer_detailTableAdapter.Update(fixedDataSet.transfer_detail);
fixedDataSet.transfer_detail.AcceptChanges();
transfer_detailTableAdapter.Fill(fixedDataSet.transfer_detail);
}
private void gather_select_Click(object sender, RoutedEventArgs e)
{
Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet")));
if (textBox1.Text != "")
{
var s = from c in fixedDataSet.fixed_gather where c.category == textBox1.Text || c.fixed_status == textBox1.Text || c.fixed_vale == textBox1.Text || c.nature == textBox1.Text select c;
fixed_gatherDataGrid.ItemsSource = s;
}
else
{
var s = from c in fixedDataSet.fixed_gather select c;
fixed_gatherDataGrid.ItemsSource = s;
}
}
private void select_detal_Click(object sender, RoutedEventArgs e)
{
Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet")));
if (textBox1.Text != "")
{
var s = from c in fixedDataSet.fixed_detal where c.category == textBox1.Text || c.designation == textBox1.Text || c.fixed_number == int.Parse(textBox1.Text) || c.fixed_status == textBox1.Text || c.fixed_vale == textBox1.Text || c.nature == textBox1.Text || c.specifications == textBox1.Text select c;
fixed_detalDataGrid.ItemsSource = s;
}
else
{
var s = from c in fixedDataSet.fixed_detal select c;
fixed_detalDataGrid.ItemsSource = s;
}
}
private void select_Click(object sender, RoutedEventArgs e)
{
Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet")));
if (textBox1.Text != "")
{
var s = from c in fixedDataSet.fixed_exit where c.storage_place == textBox1.Text || c.barcode == textBox1.Text || c.limit == int.Parse(textBox1.Text) || c.fixed_number == int.Parse(textBox1.Text) || c.fixed_vale == textBox1.Text || c.factory_number == textBox1.Text || c.fixed_encoding == textBox1.Text || c.warranty == int.Parse(textBox1.Text) || c.account_number == textBox1.Text || c.fixed_asset == textBox1.Text || c.card_number == textBox1.Text || c.nature == textBox1.Text || c.category == textBox1.Text || c.specifications == textBox1.Text || c.designation == textBox1.Text || c.model == textBox1.Text || c.unit == textBox1.Text || c.purchase_way == textBox1.Text || c.keeper == textBox1.Text || c.supplier == textBox1.Text || c.position == textBox1.Text || c.fixed_status == textBox1.Text || c.user == textBox1.Text || c._operator == textBox1.Text || c.affiliated == textBox1.Text || c.department == textBox1.Text || c.content == textBox1.Text select c;
fixed_exitDataGrid.ItemsSource = s;
}
else
{
var s = from c in fixedDataSet.fixed_exit select c;
fixed_exitDataGrid.ItemsSource = s;
}
}
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.fixed_del_queryTableAdapter fixed_del_queryTableAdapter = new Fixed_management.FixedDataSetTableAdapters.fixed_del_queryTableAdapter();
fixed_del_queryTableAdapter.Fill(fixedDataSet.fixed_del_query);
fixed_del_queryDataGrid.CanUserAddRows = false;
}
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.fixed_delTableAdapter fixed_delTableAdapter = new Fixed_management.FixedDataSetTableAdapters.fixed_delTableAdapter();
fixed_delTableAdapter.Fill(fixedDataSet.fixed_del);
fixed_delDataGrid.CanUserAddRows = false;
del_select.Margin = new Thickness(SystemParameters.PrimaryScreenWidth - 100, 10, 0, 0);
textBox1.Margin = new Thickness(SystemParameters.PrimaryScreenWidth - 230, 10, 0, 0);
}
private void transfer_select_Click(object sender, RoutedEventArgs e)
{
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")));
if (textBox1.Text != "")
{
var s = from c in fixedDataSet.fixedname where c.storage_place == textBox1.Text || c.barcode == textBox1.Text || c.limit == int.Parse(textBox1.Text) || c.fixed_number == int.Parse(textBox1.Text) || c.fixed_vale == textBox1.Text || c.factory_number == textBox1.Text || c.fixed_encoding == textBox1.Text || c.warranty == int.Parse(textBox1.Text) || c.account_number == textBox1.Text || c.fixed_asset == textBox1.Text || c.card_number == textBox1.Text || c.nature == textBox1.Text || c.category == textBox1.Text || c.specifications == textBox1.Text || c.designation == textBox1.Text || c.model == textBox1.Text || c.unit == textBox1.Text || c.purchase_way == textBox1.Text || c.keeper == textBox1.Text || c.supplier == textBox1.Text || c.position == textBox1.Text || c.fixed_status == textBox1.Text || c.user == textBox1.Text || c._operator == textBox1.Text || c.affiliated == textBox1.Text || c.department == textBox1.Text || c.content == textBox1.Text select c;
fixednameDataGrid.ItemsSource = s;
}
else
{
var s = from c in fixedDataSet.fixedname select c;
fixednameDataGrid.ItemsSource = s;
}
}
private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
fixednameDataGrid.CanUserAddRows = false;
// 不要在设计时加载数据。
// 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.affiliatedTableAdapter fixedDataSetaffiliatedTableAdapter = new Fixed_management.FixedDataSetTableAdapters.affiliatedTableAdapter();
fixedDataSetaffiliatedTableAdapter.Fill(fixedDataSet.affiliated);
System.Windows.Data.CollectionViewSource affiliatedViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("affiliatedViewSource")));
affiliatedViewSource.View.MoveCurrentToFirst();
Fixed_management.FixedDataSetTableAdapters.departmentTableAdapter fixedDataSetdepartmentTableAdapter = new Fixed_management.FixedDataSetTableAdapters.departmentTableAdapter();
fixedDataSetdepartmentTableAdapter.Fill(fixedDataSet.department);
System.Windows.Data.CollectionViewSource departmentViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("departmentViewSource")));
departmentViewSource.View.MoveCurrentToFirst();
Fixed_management.FixedDataSetTableAdapters.keeperTableAdapter fixedDataSetkeeperTableAdapter = new Fixed_management.FixedDataSetTableAdapters.keeperTableAdapter();
fixedDataSetkeeperTableAdapter.Fill(fixedDataSet.keeper);
System.Windows.Data.CollectionViewSource keeperViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("keeperViewSource")));
keeperViewSource.View.MoveCurrentToFirst();
Fixed_management.FixedDataSetTableAdapters.storage_placeTableAdapter fixedDataSetstorage_placeTableAdapter = new Fixed_management.FixedDataSetTableAdapters.storage_placeTableAdapter();
fixedDataSetstorage_placeTableAdapter.Fill(fixedDataSet.storage_place);
System.Windows.Data.CollectionViewSource storage_placeViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("storage_placeViewSource")));
storage_placeViewSource.View.MoveCurrentToFirst();
transfer_dateDatePicker.SelectedDate = DateTime.Now;
transfer_select.Margin = new Thickness(SystemParameters.PrimaryScreenWidth - 100, 70, 0, 0);
textBox1.Margin = new Thickness(SystemParameters.PrimaryScreenWidth - 230, 70, 0, 0);
}
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 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.transfer_detailTableAdapter transfer_detailTableAdapter = new Fixed_management.FixedDataSetTableAdapters.transfer_detailTableAdapter();
transfer_detailTableAdapter.Fill(fixedDataSet.transfer_detail);
System.Windows.Data.CollectionViewSource transfer_detailViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("transfer_detailViewSource")));
transfer_detailViewSource.View.MoveCurrentToFirst();
Fixed_management.FixedDataSetTableAdapters.affiliatedTableAdapter fixedDataSetaffiliatedTableAdapter = new Fixed_management.FixedDataSetTableAdapters.affiliatedTableAdapter();
fixedDataSetaffiliatedTableAdapter.Fill(fixedDataSet.affiliated);
Fixed_management.FixedDataSetTableAdapters.departmentTableAdapter fixedDataSetdepartmentTableAdapter = new Fixed_management.FixedDataSetTableAdapters.departmentTableAdapter();
fixedDataSetdepartmentTableAdapter.Fill(fixedDataSet.department);
Fixed_management.FixedDataSetTableAdapters.keeperTableAdapter fixedDataSetkeeperTableAdapter = new Fixed_management.FixedDataSetTableAdapters.keeperTableAdapter();
fixedDataSetkeeperTableAdapter.Fill(fixedDataSet.keeper);
Fixed_management.FixedDataSetTableAdapters.storage_placeTableAdapter fixedDataSetstorage_placeTableAdapter = new Fixed_management.FixedDataSetTableAdapters.storage_placeTableAdapter();
fixedDataSetstorage_placeTableAdapter.Fill(fixedDataSet.storage_place);
Fixed_management.FixedDataSetTableAdapters.fixedTableAdapter fixedTableAdapter = new Fixed_management.FixedDataSetTableAdapters.fixedTableAdapter();
fixedTableAdapter.Fill(fixedDataSet._fixed);
transfer_detailDataGrid.CanUserAddRows = false;
}
private void bar_auto_Click(object sender, RoutedEventArgs e)
{
Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet")));
Fixed_management.FixedDataSetTableAdapters.fixedTableAdapter fixedDataSetfixedTableAdapter = new Fixed_management.FixedDataSetTableAdapters.fixedTableAdapter();
int cot = (from c in fixedDataSet._fixed select c.fixed_ID).Count();
string a;
if (cot > 0)
{
int q = (from c in fixedDataSet._fixed select c.fixed_ID).Max();
a = fixedDataSet._fixed.FindByfixed_ID(q).barcode;
}
else
{
a = "000";
}
auto_bar(a);
barcode.Text = bar_rul;
}
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 reductive_transfer_Click(object sender, RoutedEventArgs e)
{
Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet")));
Fixed_management.FixedDataSetTableAdapters.transfer_detailTableAdapter transfer_detailTableAdapter = new Fixed_management.FixedDataSetTableAdapters.transfer_detailTableAdapter();
Fixed_management.FixedDataSetTableAdapters.fixedTableAdapter fixedTableAdapter = new Fixed_management.FixedDataSetTableAdapters.fixedTableAdapter();
fixedTableAdapter.Fill(fixedDataSet._fixed);
string affiliated = "";
string department = "";
string keeper = "";
string storage_place = "";
string fixedname_bar = "";
List <int> trn_id = new List <int>();
for (int i = 0; i < transfer_detailDataGrid.Items.Count; i++)
{
DataGridTemplateColumn templeColumn = transfer_detailDataGrid.Columns[0] as DataGridTemplateColumn;
FrameworkElement s = transfer_detailDataGrid.Columns[0].GetCellContent(transfer_detailDataGrid.Items[i]);
CheckBox tbOper = templeColumn.CellTemplate.FindName("checkbox", s) as CheckBox;
DataRowView mySelectedElement = (DataRowView)transfer_detailDataGrid.Items[i];
fixedname_bar = mySelectedElement.Row[2].ToString();
if ((bool)tbOper.IsChecked)
{
var v = from c in fixedDataSet.transfer_detail where c.barcode == fixedname_bar select c;
foreach (var t in v)
{
// bar=t.barcode;
affiliated = t.old_affiliated;
department = t.old_department;
keeper = t.old_keeper;
storage_place = t.old_storage_place;
trn_id.Add(t.transfer_detail_ID);
}
var Vaffiliated = from c in fixedDataSet.affiliated where c.affiliated == affiliated select c;
int Iaffiliated = 0;
foreach (var a in Vaffiliated)
{
Iaffiliated = a.affiliated_ID;
break;
}
var Vdepartment = from c in fixedDataSet.department where c.department == department select c;
int Idepartment = 0;
foreach (var a in Vdepartment)
{
Idepartment = a.department_ID;
break;
}
var Vstorage_place = from c in fixedDataSet.storage_place where c.storage_place == storage_place select c;
int Istorage_place = 0;
foreach (var a in Vstorage_place)
{
Istorage_place = a.storage_place_ID;
break;
}
var Vkeeper = from c in fixedDataSet.keeper where c.keeper == keeper select c;
int Ikeeper = 0;
foreach (var a in Vkeeper)
{
Ikeeper = a.keeper_ID;
break;
}
var f = from c in fixedDataSet._fixed where c.barcode == fixedname_bar select c;
foreach (var id in f)
{
id.affiliated_ID = Iaffiliated;
id.department_ID = Idepartment;
id.storage_place_ID = Istorage_place;
id.keeper_ID = Ikeeper;
}
fixedTableAdapter.Update(fixedDataSet._fixed);
fixedDataSet._fixed.AcceptChanges();
//fixedTableAdapter.Fill(fixedDataSet._fixed);
}
}
Fixed_management.FixedDataSetTableAdapters.fixednameTableAdapter fixednameTableAdapter = new Fixed_management.FixedDataSetTableAdapters.fixednameTableAdapter();
fixedDataSet.fixedname.AcceptChanges();
fixednameTableAdapter.Fill(fixedDataSet.fixedname);
foreach (int a in trn_id)
{
fixedDataSet.transfer_detail.FindBytransfer_detail_ID(a).Delete();
}
transfer_detailTableAdapter.Update(fixedDataSet.transfer_detail);
fixedDataSet.transfer_detail.AcceptChanges();
}
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 permissions()
{
Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet")));
string pem = fixedDataSet.employees.FindByemployees_ID(Public.user_id).pemissions;
permsis = pem.Split('f');
foreach (string s in permsis)
{
if (s == "3")
{
fix_add.IsEnabled = true;
fix_addtool.IsEnabled = true;
}
if (s == "4")
{
fix_transfertool.IsEnabled = true;
fixed_transfers.IsEnabled = true;
}
if (s == "5")
{
fix_outtool.IsEnabled = true;
}
if (s == "6")
{
fix_deltool.IsEnabled = true;
del_fixtool.IsEnabled = true;
}
if (s == "7")
{
information_intool.IsEnabled = true;
}
if (s == "8")
{
fix_printool.IsEnabled = true;
fix_prin.IsEnabled = true;
}
if (s == "9")
{
}
if (s == "10")
{
enable_fixtool.IsEnabled = true;
effective_name.IsEnabled = true;
}
if (s == "11")
{
exit_fixtool.IsEnabled = true;
}
if (s == "12")
{
del_fixtool.IsEnabled = true;
}
if (s == "13")
{
transfer_information_tool.IsEnabled = true;
transfer_information.IsEnabled = true;
}
if (s == "14")
{
fixclass_detailtool.IsEnabled = true;
}
if (s == "15")
{
fixclass_tal.IsEnabled = true;
}
if (s == "16")
{
}
if (s == "17")
{
fix_inventorytool.IsEnabled = true;
fix_inventory.IsEnabled = true;
}
if (s == "18")
{
employees.IsEnabled = true;
}
if (s == "19")
{
register_tool.IsEnabled = true;
}
if (s == "20")
{
report_designtool.IsEnabled = true;
}
if (s == "21")
{
tag_titletool.IsEnabled = true;
}
}
}
private void checkmultitable()
{
Fixed_management.FixedDataSet fixedDataSet = ((Fixed_management.FixedDataSet)(this.FindResource("fixedDataSet")));
Fixed_management.FixedDataSetTableAdapters.affiliatedTableAdapter fixedDataSetaffiliatedTableAdapter = new Fixed_management.FixedDataSetTableAdapters.affiliatedTableAdapter();
fixedDataSetaffiliatedTableAdapter.Fill(fixedDataSet.affiliated);
System.Windows.Data.CollectionViewSource affiliatedViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("affiliatedViewSource")));
affiliatedViewSource.View.MoveCurrentToLast();
Fixed_management.FixedDataSetTableAdapters.departmentTableAdapter fixedDataSetdepartmentTableAdapter = new Fixed_management.FixedDataSetTableAdapters.departmentTableAdapter();
fixedDataSetdepartmentTableAdapter.Fill(fixedDataSet.department);
System.Windows.Data.CollectionViewSource departmentViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("departmentViewSource")));
departmentViewSource.View.MoveCurrentToLast();
Fixed_management.FixedDataSetTableAdapters.keeperTableAdapter fixedDataSetkeeperTableAdapter = new Fixed_management.FixedDataSetTableAdapters.keeperTableAdapter();
fixedDataSetkeeperTableAdapter.Fill(fixedDataSet.keeper);
System.Windows.Data.CollectionViewSource keeperViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("keeperViewSource")));
keeperViewSource.View.MoveCurrentToLast();
Fixed_management.FixedDataSetTableAdapters.storage_placeTableAdapter fixedDataSetstorage_placeTableAdapter = new Fixed_management.FixedDataSetTableAdapters.storage_placeTableAdapter();
fixedDataSetstorage_placeTableAdapter.Fill(fixedDataSet.storage_place);
System.Windows.Data.CollectionViewSource storage_placeViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("storage_placeViewSource")));
storage_placeViewSource.View.MoveCurrentToLast();
//Fixed_management.FixedDataSetTableAdapters.transfer_detailTableAdapter transfer_detailTableAdapter = new Fixed_management.FixedDataSetTableAdapters.transfer_detailTableAdapter();
//transfer_detailTableAdapter.Fill(fixedDataSet.transfer_detail);
//System.Windows.Data.CollectionViewSource transfer_detailViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("transfer_detailViewSource")));
//transfer_detailViewSource.View.MoveCurrentToLast();
var affiliated = (from c in fixedDataSet.affiliated where c.affiliated == affiliated_IDC1ComboBox.Text select c).Count();
var department = (from c in fixedDataSet.department where c.department == department_IDC1ComboBox.Text select c).Count();
var keeper = (from c in fixedDataSet.keeper where c.keeper == keeper_IDC1ComboBox.Text select c).Count();
var storage_place = (from c in fixedDataSet.storage_place where c.storage_place == storage_place_IDC1ComboBox.Text select c).Count();
if (affiliated == 0)
{
fixedDataSet.affiliated.AddaffiliatedRow(1, affiliated_IDC1ComboBox.Text);
fixedDataSetaffiliatedTableAdapter.Update(fixedDataSet.affiliated);
fixedDataSet.affiliated.AcceptChanges();
fixedDataSetaffiliatedTableAdapter.Fill(fixedDataSet.affiliated);
affiliatedViewSource.View.MoveCurrentToLast();
}
if (department == 0)
{
fixedDataSet.department.AdddepartmentRow(1, department_IDC1ComboBox.Text);
fixedDataSetdepartmentTableAdapter.Update(fixedDataSet.department);
fixedDataSet.department.AcceptChanges();
fixedDataSetdepartmentTableAdapter.Fill(fixedDataSet.department);
departmentViewSource.View.MoveCurrentToLast();
}
if (keeper == 0)
{
fixedDataSet.keeper.AddkeeperRow(keeper_IDC1ComboBox.Text);
fixedDataSetkeeperTableAdapter.Update(fixedDataSet.keeper);
fixedDataSet.keeper.AcceptChanges();
fixedDataSetkeeperTableAdapter.Fill(fixedDataSet.keeper);
keeperViewSource.View.MoveCurrentToLast();
}
if (storage_place == 0)
{
fixedDataSet.storage_place.Addstorage_placeRow(storage_place_IDC1ComboBox.Text);
fixedDataSetstorage_placeTableAdapter.Update(fixedDataSet.storage_place);
fixedDataSet.storage_place.AcceptChanges();
fixedDataSetstorage_placeTableAdapter.Fill(fixedDataSet.storage_place);
storage_placeViewSource.View.MoveCurrentToLast();
}
}
