private void cancellaRecordSelezionatiToolStripMenuItem1_Click(object sender, EventArgs e) { try { int EventKey = 0; using (TransactionScope scp = new TransactionScope()) { foreach (DataGridViewRow r in dbDataGridView_righe.SelectedRows) { DataSet.dsEvents.EventiRigheRow row = (r.DataBoundItem as DataRowView).Row as DataSet.dsEvents.EventiRigheRow; EventKey = row.EventKey; eventiRigheTableAdapter.DeleteQuery(row.EventRowKey); } scp.Complete(); } if (EventKey != 0) { RefreshDatagridRighe(EventKey); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void button_modifica_righe_Click(object sender, EventArgs e) { if (dbDataGridView_righe.SelectedRows.Count > 0) { DataRowView drv = dbDataGridView_righe.SelectedRows[0].DataBoundItem as DataRowView; if (drv != null) { try { DataSet.dsEvents.EventiRigheRow row = drv.Row as DataSet.dsEvents.EventiRigheRow; eventiRigheTableAdapter.UpdateQuery( (int)ctrlPlantSelector.SelectedImpianto(), (int)ctrlPlantSelector.SelectedMacchina(), ctrlPlantSelector.SelectedComponente(), ctrlPlantSelector.SelectedSCM_1(), ctrlPlantSelector.SelectedSCM_2(), ctrlPlantSelector.SelectedSCM_3(), int.Parse(textBox_driver.Text), row.EventRowKey); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } } }
private void RefreshDatagridRighe(int EventKey) { eventiRigheTableAdapter.Fill(dsEvents.EventiRighe, EventKey, Program.language_); textBox_remaining.Text = string.Empty; int count = 0; for (int i = 0; i < dbDataGridView_righe.Rows.Count; i++) { DataRowView drv = dbDataGridView_righe.Rows[i].DataBoundItem as DataRowView; DataSet.dsEvents.EventiRigheRow row = drv.Row as DataSet.dsEvents.EventiRigheRow; count += row.DriverPerc; } textBox_remaining.Text = (100 - count).ToString(); }
private void dbDataGridView_righe_SelectionChanged(object sender, EventArgs e) { if (dbDataGridView_righe.SelectedRows.Count > 0) { DataRowView drv = dbDataGridView_righe.SelectedRows[0].DataBoundItem as DataRowView; if (drv != null) { DataSet.dsEvents.EventiRigheRow row = drv.Row as DataSet.dsEvents.EventiRigheRow; textBox_driver.Text = row.DriverPerc.ToString(); int?null_value = null; ctrlPlantSelector.PerformSelection( row.IMPKey, row.MACKey, row.IsCOMKeyNull() ? null_value : row.COMKey, row.IsSCM_1KeyNull() ? null_value : row.SCM_1Key, row.IsSCM_2KeyNull() ? null_value : row.SCM_2Key, row.IsSCM_3KeyNull() ? null_value : row.SCM_3Key); } } }