private void clear_del_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]);
DataRowView mySelectedElement = (DataRowView)fixed_del_queryDataGrid.Items[i];
int fixed_del_id = int.Parse(mySelectedElement.Row[32].ToString());
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 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 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 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 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 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 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 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 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;
}
// public static T FindChild<T>(DependencyObject parent, string childName)//查找控件
//where T : DependencyObject
// {
// if (parent == null) return null;
// T foundChild = null;
// int childrenCount = VisualTreeHelper.GetChildrenCount(parent);
// for (int i = 0; i < childrenCount; i++)
// {
// var child = VisualTreeHelper.GetChild(parent, i);
// // 如果子控件不是需查找的控件类型
// T childType = child as T;
// if (childType == null)
// {
// // 在下一级控件中递归查找
// foundChild = FindChild<T>(child, childName);
// // 找到控件就可以中断递归操作
// if (foundChild != null) break;
// }
// else if (!string.IsNullOrEmpty(childName))
// {
// var frameworkElement = child as FrameworkElement;
// // 如果控件名称符合参数条件
// if (frameworkElement != null && frameworkElement.Name == childName)
// {
// foundChild = (T)child;
// break;
// }
// }
// else
// {
// // 查找到了控件
// foundChild = (T)child;
// break;
// }
// }
// return foundChild;
// }
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")));
Fixed_management.FixedDataSetTableAdapters.fixedTableAdapter fixedDataSetfixedTableAdapter = new Fixed_management.FixedDataSetTableAdapters.fixedTableAdapter();
fixedDataSetfixedTableAdapter.Fill(fixedDataSet._fixed);
System.Windows.Data.CollectionViewSource fixedViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("fixedViewSource")));
fixedViewSource.View.MoveCurrentToFirst();
// 将数据加载到表 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.categoryTableAdapter fixedDataSetcategoryTableAdapter = new Fixed_management.FixedDataSetTableAdapters.categoryTableAdapter();
fixedDataSetcategoryTableAdapter.Fill(fixedDataSet.category);
System.Windows.Data.CollectionViewSource categoryViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("categoryViewSource")));
categoryViewSource.View.MoveCurrentToLast();
Fixed_management.FixedDataSetTableAdapters.designationTableAdapter fixedDataSetdesignationTableAdapter = new Fixed_management.FixedDataSetTableAdapters.designationTableAdapter();
fixedDataSetdesignationTableAdapter.Fill(fixedDataSet.designation);
System.Windows.Data.CollectionViewSource designationViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("designationViewSource")));
designationViewSource.View.MoveCurrentToLast();
Fixed_management.FixedDataSetTableAdapters.specificationsTableAdapter fixedDataSetspecificationsTableAdapter = new Fixed_management.FixedDataSetTableAdapters.specificationsTableAdapter();
fixedDataSetspecificationsTableAdapter.Fill(fixedDataSet.specifications);
System.Windows.Data.CollectionViewSource specificationsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("specificationsViewSource")));
specificationsViewSource.View.MoveCurrentToLast();
Fixed_management.FixedDataSetTableAdapters.modelTableAdapter fixedDataSetmodelTableAdapter = new Fixed_management.FixedDataSetTableAdapters.modelTableAdapter();
fixedDataSetmodelTableAdapter.Fill(fixedDataSet.model);
System.Windows.Data.CollectionViewSource modelViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("modelViewSource")));
modelViewSource.View.MoveCurrentToLast();
Fixed_management.FixedDataSetTableAdapters.unitTableAdapter fixedDataSetunitTableAdapter = new Fixed_management.FixedDataSetTableAdapters.unitTableAdapter();
fixedDataSetunitTableAdapter.Fill(fixedDataSet.unit);
System.Windows.Data.CollectionViewSource unitViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("unitViewSource")));
unitViewSource.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.supplierTableAdapter fixedDataSetsupplierTableAdapter = new Fixed_management.FixedDataSetTableAdapters.supplierTableAdapter();
fixedDataSetsupplierTableAdapter.Fill(fixedDataSet.supplier);
System.Windows.Data.CollectionViewSource supplierViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("supplierViewSource")));
supplierViewSource.View.MoveCurrentToLast();
Fixed_management.FixedDataSetTableAdapters.positionTableAdapter fixedDataSetpositionTableAdapter = new Fixed_management.FixedDataSetTableAdapters.positionTableAdapter();
fixedDataSetpositionTableAdapter.Fill(fixedDataSet.position);
System.Windows.Data.CollectionViewSource positionViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("positionViewSource")));
positionViewSource.View.MoveCurrentToLast();
Fixed_management.FixedDataSetTableAdapters.fixed_statusTableAdapter fixedDataSetfixed_statusTableAdapter = new Fixed_management.FixedDataSetTableAdapters.fixed_statusTableAdapter();
fixedDataSetfixed_statusTableAdapter.Fill(fixedDataSet.fixed_status);
System.Windows.Data.CollectionViewSource fixed_statusViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("fixed_statusViewSource")));
fixed_statusViewSource.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.purchase_wayTableAdapter fixedDataSetpurchase_wayTableAdapter = new Fixed_management.FixedDataSetTableAdapters.purchase_wayTableAdapter();
fixedDataSetpurchase_wayTableAdapter.Fill(fixedDataSet.purchase_way);
System.Windows.Data.CollectionViewSource purchase_wayViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("purchase_wayViewSource")));
purchase_wayViewSource.View.MoveCurrentToLast();
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.userTableAdapter fixedDataSetuserTableAdapter = new Fixed_management.FixedDataSetTableAdapters.userTableAdapter();
fixedDataSetuserTableAdapter.Fill(fixedDataSet.user);
System.Windows.Data.CollectionViewSource userViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("userViewSource")));
userViewSource.View.MoveCurrentToLast();
}
private void transfer_btn_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 && check_repat(fixedname_id))
{
barcode = mySelectedElement.Row[0].ToString();
old_affiliated = mySelectedElement.Row[28].ToString();
old_department = mySelectedElement.Row[29].ToString();
old_keeper = mySelectedElement.Row[22].ToString();
old_storage_place = mySelectedElement.Row[31].ToString();
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;
}
var t = from c in fixedDataSet._fixed where c.fixed_ID == fixedname_id select c;
foreach (var n in t)
{
n.affiliated_ID = Iaffiliated;
n.department_ID = Idepartment;
n.keeper_ID = Ikeeper;
n.storage_place_ID = Istorage_place;
}
transfer_detail();
}
fixedTableAdapter.Update(fixedDataSet._fixed);
fixedDataSet._fixed.AcceptChanges();
}
Fixed_management.FixedDataSetTableAdapters.fixednameTableAdapter fixednameTableAdapter = new Fixed_management.FixedDataSetTableAdapters.fixednameTableAdapter();
fixedDataSet.fixedname.AcceptChanges();
fixednameTableAdapter.Fill(fixedDataSet.fixedname);
//transfer_detail();
}
}
private void transfer_btn_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 && check_repat(fixedname_id))
{
barcode = mySelectedElement.Row[0].ToString();
old_affiliated = mySelectedElement.Row[28].ToString();
old_department = mySelectedElement.Row[29].ToString();
old_keeper = mySelectedElement.Row[22].ToString();
old_storage_place = mySelectedElement.Row[31].ToString();
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;
}
var t = from c in fixedDataSet._fixed where c.fixed_ID == fixedname_id select c;
foreach (var n in t)
{
n.affiliated_ID = Iaffiliated;
n.department_ID = Idepartment;
n.keeper_ID = Ikeeper;
n.storage_place_ID = Istorage_place;
}
transfer_detail();
}
fixedTableAdapter.Update(fixedDataSet._fixed);
fixedDataSet._fixed.AcceptChanges();
}
Fixed_management.FixedDataSetTableAdapters.fixednameTableAdapter fixednameTableAdapter = new Fixed_management.FixedDataSetTableAdapters.fixednameTableAdapter();
fixedDataSet.fixedname.AcceptChanges();
fixednameTableAdapter.Fill(fixedDataSet.fixedname);
//transfer_detail();
}
}
// public static T FindChild<T>(DependencyObject parent, string childName)//查找控件
//where T : DependencyObject
// {
// if (parent == null) return null;
// T foundChild = null;
// int childrenCount = VisualTreeHelper.GetChildrenCount(parent);
// for (int i = 0; i < childrenCount; i++)
// {
// var child = VisualTreeHelper.GetChild(parent, i);
// // 如果子控件不是需查找的控件类型
// T childType = child as T;
// if (childType == null)
// {
// // 在下一级控件中递归查找
// foundChild = FindChild<T>(child, childName);
// // 找到控件就可以中断递归操作
// if (foundChild != null) break;
// }
// else if (!string.IsNullOrEmpty(childName))
// {
// var frameworkElement = child as FrameworkElement;
// // 如果控件名称符合参数条件
// if (frameworkElement != null && frameworkElement.Name == childName)
// {
// foundChild = (T)child;
// break;
// }
// }
// else
// {
// // 查找到了控件
// foundChild = (T)child;
// break;
// }
// }
// return foundChild;
// }
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")));
Fixed_management.FixedDataSetTableAdapters.fixedTableAdapter fixedDataSetfixedTableAdapter = new Fixed_management.FixedDataSetTableAdapters.fixedTableAdapter();
fixedDataSetfixedTableAdapter.Fill(fixedDataSet._fixed);
System.Windows.Data.CollectionViewSource fixedViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("fixedViewSource")));
fixedViewSource.View.MoveCurrentToFirst();
// 将数据加载到表 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.categoryTableAdapter fixedDataSetcategoryTableAdapter = new Fixed_management.FixedDataSetTableAdapters.categoryTableAdapter();
fixedDataSetcategoryTableAdapter.Fill(fixedDataSet.category);
System.Windows.Data.CollectionViewSource categoryViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("categoryViewSource")));
categoryViewSource.View.MoveCurrentToLast();
Fixed_management.FixedDataSetTableAdapters.designationTableAdapter fixedDataSetdesignationTableAdapter = new Fixed_management.FixedDataSetTableAdapters.designationTableAdapter();
fixedDataSetdesignationTableAdapter.Fill(fixedDataSet.designation);
System.Windows.Data.CollectionViewSource designationViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("designationViewSource")));
designationViewSource.View.MoveCurrentToLast();
Fixed_management.FixedDataSetTableAdapters.specificationsTableAdapter fixedDataSetspecificationsTableAdapter = new Fixed_management.FixedDataSetTableAdapters.specificationsTableAdapter();
fixedDataSetspecificationsTableAdapter.Fill(fixedDataSet.specifications);
System.Windows.Data.CollectionViewSource specificationsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("specificationsViewSource")));
specificationsViewSource.View.MoveCurrentToLast();
Fixed_management.FixedDataSetTableAdapters.modelTableAdapter fixedDataSetmodelTableAdapter = new Fixed_management.FixedDataSetTableAdapters.modelTableAdapter();
fixedDataSetmodelTableAdapter.Fill(fixedDataSet.model);
System.Windows.Data.CollectionViewSource modelViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("modelViewSource")));
modelViewSource.View.MoveCurrentToLast();
Fixed_management.FixedDataSetTableAdapters.unitTableAdapter fixedDataSetunitTableAdapter = new Fixed_management.FixedDataSetTableAdapters.unitTableAdapter();
fixedDataSetunitTableAdapter.Fill(fixedDataSet.unit);
System.Windows.Data.CollectionViewSource unitViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("unitViewSource")));
unitViewSource.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.supplierTableAdapter fixedDataSetsupplierTableAdapter = new Fixed_management.FixedDataSetTableAdapters.supplierTableAdapter();
fixedDataSetsupplierTableAdapter.Fill(fixedDataSet.supplier);
System.Windows.Data.CollectionViewSource supplierViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("supplierViewSource")));
supplierViewSource.View.MoveCurrentToLast();
Fixed_management.FixedDataSetTableAdapters.positionTableAdapter fixedDataSetpositionTableAdapter = new Fixed_management.FixedDataSetTableAdapters.positionTableAdapter();
fixedDataSetpositionTableAdapter.Fill(fixedDataSet.position);
System.Windows.Data.CollectionViewSource positionViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("positionViewSource")));
positionViewSource.View.MoveCurrentToLast();
Fixed_management.FixedDataSetTableAdapters.fixed_statusTableAdapter fixedDataSetfixed_statusTableAdapter = new Fixed_management.FixedDataSetTableAdapters.fixed_statusTableAdapter();
fixedDataSetfixed_statusTableAdapter.Fill(fixedDataSet.fixed_status);
System.Windows.Data.CollectionViewSource fixed_statusViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("fixed_statusViewSource")));
fixed_statusViewSource.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.purchase_wayTableAdapter fixedDataSetpurchase_wayTableAdapter = new Fixed_management.FixedDataSetTableAdapters.purchase_wayTableAdapter();
fixedDataSetpurchase_wayTableAdapter.Fill(fixedDataSet.purchase_way);
System.Windows.Data.CollectionViewSource purchase_wayViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("purchase_wayViewSource")));
purchase_wayViewSource.View.MoveCurrentToLast();
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.userTableAdapter fixedDataSetuserTableAdapter = new Fixed_management.FixedDataSetTableAdapters.userTableAdapter();
fixedDataSetuserTableAdapter.Fill(fixedDataSet.user);
System.Windows.Data.CollectionViewSource userViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("userViewSource")));
userViewSource.View.MoveCurrentToLast();
}
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 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 fixed_add_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();
if (checknull())
{
checkmultitable();
}
var Vnature = from c in fixedDataSet.nature where c.nature == natureC1ComboBox.Text select c;
int Inature=0;
foreach (var s in Vnature)
{
Inature = s.nature_ID;
break;
}
var Vcategory = from c in fixedDataSet.category where c.category == categoryC1ComboBox.Text select c;
int Icategory = 0;
foreach (var s in Vcategory)
{
Icategory = s.category_ID;
break;
}
var Vdesignation = from c in fixedDataSet.designation where c.designation == designationC1ComboBox.Text select c;
int Idesignation = 0;
foreach (var s in Vdesignation)
{
Idesignation = s.designation_ID;
break;
}
var Vspecifications = from c in fixedDataSet.specifications where c.specifications == specifications_IDC1ComboBox.Text select c;
int Ispecifications = 0;
foreach (var s in Vspecifications)
{
Ispecifications = s.specifications_ID;
break;
}
var Vmodel = from c in fixedDataSet.model where c.model == model_IDC1ComboBox.Text select c;
int Imodel = 0;
foreach (var s in Vmodel)
{
Imodel = s.model_ID;
break;
}
var Vpurchase_way = from c in fixedDataSet.purchase_way where c.purchase_way == purchase_way_IDC1ComboBox.Text select c;
int Ipurchase_way = 0;
foreach (var s in Vpurchase_way)
{
Ipurchase_way = s.purchase_way_ID;
break;
}
var Vunit = from c in fixedDataSet.unit where c.unit == unit_IDC1ComboBox.Text select c;
int Iunit = 0;
foreach (var s in Vunit)
{
Iunit = s.unit_ID;
break;
}
var Vaffiliated = from c in fixedDataSet.affiliated where c.affiliated == affiliated_IDC1ComboBox.Text select c;
int Iaffiliated = 0;
foreach (var s in Vaffiliated)
{
Iaffiliated = s.affiliated_ID;
break;
}
var Vdepartment = from c in fixedDataSet.department where c.department == department_IDC1ComboBox.Text select c;
int Idepartment = 0;
foreach (var s in Vdepartment)
{
Idepartment = s.department_ID;
break;
}
var Vkeeper = from c in fixedDataSet.keeper where c.keeper == keeper_IDC1ComboBox.Text select c;
int Ikeeper = 0;
foreach (var s in Vkeeper)
{
Ikeeper = s.keeper_ID;
break;
}
var Vsupplier = from c in fixedDataSet.supplier where c.supplier == supplier_IDC1ComboBox.Text select c;
int Isupplier = 0;
foreach (var s in Vsupplier)
{
Isupplier = s.supplier_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 s in Vstorage_place)
{
Istorage_place = s.storage_place_ID;
break;
}
var Vposition = from c in fixedDataSet.position where c.position == position_IDC1ComboBox.Text select c;
int Iposition = 0;
foreach (var s in Vposition)
{
Iposition = s.position_ID;
break;
}
var Vfixed_status = from c in fixedDataSet.fixed_status where c.fixed_status == fixed_status_IDC1ComboBox.Text select c;
int Ifixed_status = 0;
foreach (var s in Vfixed_status)
{
Ifixed_status = s.fixed_status_ID;
break;
}
var Vuser = from c in fixedDataSet.user where c.user == user_IDC1ComboBox.Text select c;
int Iuser = 0;
foreach (var s in Vuser)
{
Iuser = s.user_ID;
break;
}
fixedDataSet._fixed.AddfixedRow(barcode.Text, Inature, Icategory, Idesignation, Ispecifications, Imodel, DateTime.Now, int.Parse(limitTextBox.Text), Ipurchase_way, int.Parse(fixed_numberTextBox.Text), Iunit, fixed_valeTextBox.Text, Ikeeper, Isupplier, factory_numberTextBox.Text, fixed_encodingTextBox.Text, Istorage_place, Iposition, Ifixed_status, Iuser, DateTime.Now, int.Parse(warrantyTextBox.Text), account_numberTextBox.Text, fixed_assetTextBox.Text, card_numberTextBox.Text, "1", "1", "", contentTextBox.Text, 1, Iaffiliated, Idepartment, 1, 1,DateTime.Now);
fixedDataSetfixedTableAdapter.Update(fixedDataSet._fixed);
C1.WPF.C1Window findfixed = MainWindow.FindChild<C1.WPF.C1Window>(Application.Current.MainWindow, "newfixed");
if (findfixed != null)
{
findfixed.Close();
}
}
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 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 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 fixed_add_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();
if (checknull())
{
checkmultitable();
}
var Vnature = from c in fixedDataSet.nature where c.nature == natureC1ComboBox.Text select c;
int Inature = 0;
foreach (var s in Vnature)
{
Inature = s.nature_ID;
break;
}
var Vcategory = from c in fixedDataSet.category where c.category == categoryC1ComboBox.Text select c;
int Icategory = 0;
foreach (var s in Vcategory)
{
Icategory = s.category_ID;
break;
}
var Vdesignation = from c in fixedDataSet.designation where c.designation == designationC1ComboBox.Text select c;
int Idesignation = 0;
foreach (var s in Vdesignation)
{
Idesignation = s.designation_ID;
break;
}
var Vspecifications = from c in fixedDataSet.specifications where c.specifications == specifications_IDC1ComboBox.Text select c;
int Ispecifications = 0;
foreach (var s in Vspecifications)
{
Ispecifications = s.specifications_ID;
break;
}
var Vmodel = from c in fixedDataSet.model where c.model == model_IDC1ComboBox.Text select c;
int Imodel = 0;
foreach (var s in Vmodel)
{
Imodel = s.model_ID;
break;
}
var Vpurchase_way = from c in fixedDataSet.purchase_way where c.purchase_way == purchase_way_IDC1ComboBox.Text select c;
int Ipurchase_way = 0;
foreach (var s in Vpurchase_way)
{
Ipurchase_way = s.purchase_way_ID;
break;
}
var Vunit = from c in fixedDataSet.unit where c.unit == unit_IDC1ComboBox.Text select c;
int Iunit = 0;
foreach (var s in Vunit)
{
Iunit = s.unit_ID;
break;
}
var Vaffiliated = from c in fixedDataSet.affiliated where c.affiliated == affiliated_IDC1ComboBox.Text select c;
int Iaffiliated = 0;
foreach (var s in Vaffiliated)
{
Iaffiliated = s.affiliated_ID;
break;
}
var Vdepartment = from c in fixedDataSet.department where c.department == department_IDC1ComboBox.Text select c;
int Idepartment = 0;
foreach (var s in Vdepartment)
{
Idepartment = s.department_ID;
break;
}
var Vkeeper = from c in fixedDataSet.keeper where c.keeper == keeper_IDC1ComboBox.Text select c;
int Ikeeper = 0;
foreach (var s in Vkeeper)
{
Ikeeper = s.keeper_ID;
break;
}
var Vsupplier = from c in fixedDataSet.supplier where c.supplier == supplier_IDC1ComboBox.Text select c;
int Isupplier = 0;
foreach (var s in Vsupplier)
{
Isupplier = s.supplier_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 s in Vstorage_place)
{
Istorage_place = s.storage_place_ID;
break;
}
var Vposition = from c in fixedDataSet.position where c.position == position_IDC1ComboBox.Text select c;
int Iposition = 0;
foreach (var s in Vposition)
{
Iposition = s.position_ID;
break;
}
var Vfixed_status = from c in fixedDataSet.fixed_status where c.fixed_status == fixed_status_IDC1ComboBox.Text select c;
int Ifixed_status = 0;
foreach (var s in Vfixed_status)
{
Ifixed_status = s.fixed_status_ID;
break;
}
var Vuser = from c in fixedDataSet.user where c.user == user_IDC1ComboBox.Text select c;
int Iuser = 0;
foreach (var s in Vuser)
{
Iuser = s.user_ID;
break;
}
fixedDataSet._fixed.AddfixedRow(barcode.Text, Inature, Icategory, Idesignation, Ispecifications, Imodel, DateTime.Now, int.Parse(limitTextBox.Text), Ipurchase_way, int.Parse(fixed_numberTextBox.Text), Iunit, fixed_valeTextBox.Text, Ikeeper, Isupplier, factory_numberTextBox.Text, fixed_encodingTextBox.Text, Istorage_place, Iposition, Ifixed_status, Iuser, DateTime.Now, int.Parse(warrantyTextBox.Text), account_numberTextBox.Text, fixed_assetTextBox.Text, card_numberTextBox.Text, "1", "1", "", contentTextBox.Text, 1, Iaffiliated, Idepartment, 1, 1, DateTime.Now);
fixedDataSetfixedTableAdapter.Update(fixedDataSet._fixed);
C1.WPF.C1Window findfixed = MainWindow.FindChild <C1.WPF.C1Window>(Application.Current.MainWindow, "newfixed");
if (findfixed != null)
{
findfixed.Close();
}
}
