//预警设置数据库 带BindingNavigator
public static void FillDataGridView_WarningManage(DataGridView dataGridView, MyBindingNavigator myBindingNavigator, BindingNavigator bindingNavigator)
{
String sql = "SELECT * FROM warningSetup;";
DataSet ds = MainWindow.connection.Select(sql);
if (ds.Tables.Count > 0)
{
BindingSource dataSource = new BindingSource(ds.Tables[0], null);
dataGridView.DataSource = dataSource;
myBindingNavigator.InitDataTable(bindingNavigator, dataGridView, ds);
}
}
//记录数据库 根据所给的数据刷新，带BindingNavigator
public static void FillDataGridView_Records(DataGridView dataGridView, MyBindingNavigator myBindingNavigator, BindingNavigator bindingNavigator, DataSet dataSet)
{
//数据表ds通过传参获得
DataSet ds = dataSet;
//重新绑定数据
if (ds.Tables.Count > 0)
{
BindingSource dataSource = new BindingSource(ds.Tables[0], null);
dataGridView.DataSource = dataSource;
myBindingNavigator.InitDataTable(bindingNavigator, dataGridView, ds);
}
}
//工装数据库 根据工装编码刷新，带BindingNavigator
public static void FillDataGridView_Tools(DataGridView dataGridView, MyBindingNavigator myBindingNavigator, BindingNavigator bindingNavigator, String code)
{
//重新获取数据
String sql = "SELECT * FROM tools WHERE code LIKE '%" + code + "%' ORDER BY idTools;";
DataSet ds = MainWindow.connection.Select(sql);
//重新绑定数据
if (ds.Tables.Count > 0)
{
MainWindow.public_dsToolsData = ds;
BindingSource dataSource = new BindingSource(ds.Tables[0], null);
dataGridView.DataSource = dataSource;
myBindingNavigator.InitDataTable(bindingNavigator, dataGridView, ds);
}
}
//记录数据库 根据操作刷新，带BindingNavigator
public static DataSet FillDataGridView_Records(DataGridView dataGridView, MyBindingNavigator myBindingNavigator, BindingNavigator bindingNavigator, String operation)
{
//重新获取数据
String sql = "SELECT * FROM records WHERE operationType LIKE '%" + operation + "%' ORDER BY idRecords DESC;";
DataSet ds = MainWindow.connection.Select(sql);
//重新绑定数据
if (ds.Tables.Count > 0)
{
BindingSource dataSource = new BindingSource(ds.Tables[0], null);
dataGridView.DataSource = dataSource;
myBindingNavigator.InitDataTable(bindingNavigator, dataGridView, ds);
}
return(ds);
}
//人员数据库 根据员工编号刷新，带BindingNavigator
public static void FillDataGridView_Persons(DataGridView dataGridView, MyBindingNavigator myBindingNavigator, BindingNavigator bindingNavigator, String employeeID)
{
//重新获取数据
String sql = "SELECT * FROM personal WHERE employeeID LIKE '%" + employeeID + "%' ORDER BY idPersonal;";
DataSet ds = MainWindow.connection.Select(sql);
//重新绑定数据
if (ds.Tables.Count > 0)
{
MainWindow.public_dsPersonData = ds;
BindingSource dataSource = new BindingSource(ds.Tables[0], null);
dataGridView.DataSource = dataSource;
myBindingNavigator.InitDataTable(bindingNavigator, dataGridView, ds);
}
}
