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;
}
