private void DigHdrForm_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter && AdvBandedGridViewDigHdr.IsFilterRow(AdvBandedGridViewDigHdr.FocusedRowHandle)) { executeQuery(); } }
private void advBandedGridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (!AdvBandedGridViewDigHdr.IsFilterRow(e.RowHandle)) { modified = true; labelControl7.Text = DateTime.Today.ToShortDateString(); } }
private void executeQuery() { this.Cursor = Cursors.WaitCursor; string colName = AdvBandedGridViewDigHdr.FocusedColumn.FieldName; string value = String.Empty; if (!string.IsNullOrWhiteSpace(AdvBandedGridViewDigHdr.GetFocusedDisplayText())) { value = AdvBandedGridViewDigHdr.GetFocusedDisplayText(); } if (!string.IsNullOrWhiteSpace(value)) { string query = String.Format("it.AGY_NO like '{0}%'", AdvBandedGridViewDigHdr.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "AGY_NO")); var special = context.DIGHDR.Where(query); if (!string.IsNullOrWhiteSpace(AdvBandedGridViewDigHdr.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "COUP_RES"))) { query = String.Format("it.{0} like '{1}%'", "COUP_RES", AdvBandedGridViewDigHdr.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, "COUP_RES")); special = special.Where(query); } int count = special.Count(); if (count > 0) { DigHdrBindingSource.DataSource = special; AdvBandedGridViewDigHdr.SetRowCellValue(GridControl.AutoFilterRowHandle, colName, value); AdvBandedGridViewDigHdr.FocusedRowHandle = 0; AdvBandedGridViewDigHdr.FocusedColumn.FieldName = colName; AdvBandedGridViewDigHdr.ClearColumnsFilter(); } else { MessageBox.Show("No records in database."); AdvBandedGridViewDigHdr.ClearColumnsFilter(); } } this.Cursor = Cursors.Default; }