//预警设置数据库 带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); } }