private void gridinvoice_CellValueChanged(object sender, DevComponents.DotNetBar.SuperGrid.GridCellValueChangedEventArgs e) { if (e.GridCell.ColumnIndex == gridinvoice.PrimaryGrid.Columns["gridcolno"].ColumnIndex) { String search = String.Format("{0}-{1}", gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolsdrrno"].ColumnIndex).Value.ToString(), gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolinv"].ColumnIndex).Value.ToString()); if (Convert.ToBoolean(e.NewValue)) { if (!_invoice.ContainsKey(search)) { List <String> details = new List <string>(); details.Add(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolsdrrno"].ColumnIndex).Value.ToString()); details.Add(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolinv"].ColumnIndex).Value.ToString()); details.Add("0"); details.Add(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolinvdate"].ColumnIndex).Value.ToString()); details.Add(""); details.Add(""); details.Add(""); details.Add(""); details.Add(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolzone"].ColumnIndex).Value.ToString()); details.Add("0"); _invoice.Add(search, details); } } else { if (_invoice.ContainsKey(search)) { _invoice.Remove(search); } } } }
private void gridinvoice_CellValueChanged(object sender, DevComponents.DotNetBar.SuperGrid.GridCellValueChangedEventArgs e) { if (e.GridCell.ColumnIndex == gridinvoice.PrimaryGrid.Columns["gridcolno"].ColumnIndex) { if (Convert.ToBoolean(e.NewValue)) { if (!_invoice.ContainsKey(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolinvno"].ColumnIndex).Value.ToString())) { List <String> details = new List <string>(); details.Add(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolinvno"].ColumnIndex).Value.ToString()); details.Add(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["invoice_date"].ColumnIndex).Value.ToString()); details.Add("0"); details.Add(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolcust"].ColumnIndex).Value.ToString()); details.Add(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolamt"].ColumnIndex).Value.ToString()); details.Add("0"); details.Add("0"); details.Add(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolamt"].ColumnIndex).Value.ToString()); details.Add(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolindex"].ColumnIndex).Value.ToString()); details.Add(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolzone"].ColumnIndex).Value.ToString()); details.Add("C"); _invoice.Add(details[0], details); } } else { if (_invoice.ContainsKey(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolinvno"].ColumnIndex).Value.ToString())) { _invoice.Remove(gridinvoice.PrimaryGrid.GetCell(e.GridCell.RowIndex, gridinvoice.PrimaryGrid.Columns["gridcolinvno"].ColumnIndex).Value.ToString()); } } } }
/// <summary> /// Handles invocation of CellValueChanged events /// </summary> internal void DoCellValueChangedEvent( GridCell gridCell, object oldValue, object newValue, DataContext context) { if (CellValueChanged != null) { GridCellValueChangedEventArgs ev = new GridCellValueChangedEventArgs(gridCell.GridPanel, gridCell, oldValue, newValue, context); CellValueChanged(this, ev); } }
private void gItems_CellValueChanged(object sender, GridCellValueChangedEventArgs e) { }
private void gInspectionFaults_CellValueChanged(object sender, GridCellValueChangedEventArgs e) { Program.SQL.AddParameter("id", Convert.ToInt32(grInspectionAnswer.Tag)); Program.SQL.AddParameter("fault", grInspectionAnswer.Cells[1].Value.ToString()); Program.SQL.AddParameter("priority", grInspectionAnswer.Cells[2].Value.ToString()); Program.SQL.AddParameter("resolved", grInspectionAnswer.Cells[3].Value.ToString()); string sResDate = ""; if (grInspectionAnswer.Cells[3].Value.ToString().ToLower() == "y") { sResDate = " AND resolveddate=@resolveddate"; Program.SQL.AddParameter("resolveddate", DateTime.Now); } Program.SQL.AddParameter("mod", DateTime.Now); int iRes = Program.SQL.Update("UPDATE inspections_faults SET fault=@fault,priority=@priority,resolved=@resolved" + sResDate + " WHERE id=@id"); if (iRes < 1) { MessageBox.Show("The fault update failed. Please try again.", "Failed", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } }
private void gInspectionAnswers_CellValueChanged(object sender, GridCellValueChangedEventArgs e) { if (!bInspectionScheduleChanged && grInspectionAnswer != null && grInspectionAnswer.Tag.ToString().All(char.IsDigit)) { Program.SQL.AddParameter("id", Convert.ToInt32(grInspectionAnswer.Tag)); Program.SQL.AddParameter("answer", grInspectionAnswer.Cells[3].Value.ToString()); Program.SQL.AddParameter("mod", DateTime.Now); int iRes = Program.SQL.Update("UPDATE inspections_answers SET answer=@answer,modified=@mod WHERE id=@id"); if (iRes < 1) { MessageBox.Show("The answer update failed. Please try again.", "Failed", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } }