/// <summary>
/// Handles the Click event of the SearchButton control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param>
private void SearchButton_Click(object sender, EventArgs e)
{
try
{
////if (SearchMenu.Pressed)
////{
//// this.SearchTextBox.Focus();
//// this.SearchTextBox.SelectAll();
////}
this.hitCount = 0;
this.SearchResultGrid.DataSource = null;
this.RecordsCountLabel.Text = this.SearchResultGrid.Rows.Count.ToString(this.textFormat) + " Rows";
if (!string.IsNullOrEmpty(this.SearchTextBox.Text.Trim()))
{
////this.searchData = this.F9600Controll.WorkItem.F9600_ListSearchResult(this.SearchTextBox.Text.Trim(), 1);
this.FillData(false, false);
if (this.searchData.Rows.Count > 0)
{
this.groupSearchIndicator = SortIndicator.Ascending;
this.searchSearchIndicator = SortIndicator.Ascending;
////this.SearchResultGrid.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.True;
this.SearchResultGrid.Focus();
this.SearchResultGrid.DisplayLayout.Override.TipStyleCell = TipStyle.Show;
this.SearchResultGrid.Rows[0].Cells[this.searchData.GroupColumn.ColumnName].Selected = true;
this.SearchResultGrid.Rows[0].Cells[this.searchData.GroupColumn.ColumnName].Activate();
}
else
{
this.SearchResultGrid.DataSource = null;
this.RecordsCountLabel.Text = "0 Rows";
this.SearchDataSource.Rows.Clear();
this.PreviewButton.Enabled = false;
this.ExportExcelButton.Enabled = false;
this.SearchResultGrid.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
}
}
else if (this.SearchResultGrid.Rows.Count.Equals(0))
{
this.SearchResultGrid.DataSource = null;
this.RecordsCountLabel.Text = "0 Rows";
this.PreviewButton.Enabled = false;
this.ExportExcelButton.Enabled = false;
this.SearchResultGrid.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
MessageBox.Show(SharedFunctions.GetResourceString("F9600SearchTextValidation"), ConfigurationWrapper.ApplicationName, MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.SearchTextBox.Focus();
}
}
catch (SoapException ex)
{
ExceptionManager.ManageException(ex, ExceptionManager.ActionType.CloseCurrentForm, this.ParentForm);
}
catch (Exception ex)
{
ExceptionManager.ManageException(ex, ExceptionManager.ActionType.CloseCurrentForm, this.ParentForm);
}
}
/// <summary>
/// 设置是否可以排序
/// </summary>
/// <param name="startCol"></param>
/// <param name="endCol"></param>
public static void SetColumnSort(UltraWebGrid grid,SortIndicator sort)
{
for (int i = 0; i < grid.Bands[0].Columns.Count; i++)
{
grid.Bands[0].Columns[i].SortIndicator = sort;//禁用排序
}
}
/// <summary>
/// Sets the column sort indicator
/// </summary>
/// <param name="col"></param>
/// <param name="sort"></param>
public void SetColUserSortIndicator(int col, SortIndicator sort)
{
this.ActiveSheet.Columns[col].SortIndicator = sort;
}
public void SetColumnSort(int Position, SortIndicator SortDirection, bool IsGroupByColumn)
{
sortPosition = Position;
sortDirection = SortDirection;
isGroupByColumn = IsGroupByColumn;
}
/// <summary>
/// Handles the Click event of the SearchResultGrid control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param>
private void SearchResultGrid_Click(object sender, EventArgs e)
{
try
{
MouseEventArgs e1 = (MouseEventArgs)e;
Infragistics.Win.UIElement elementUi;
Point mousePoint = new Point(e1.X, e1.Y);
// Cast the sender into an UltraGrid
// Get the Mouse Point
UIElement element = ((UltraGrid)sender).DisplayLayout.UIElement.ElementFromPoint(mousePoint);
elementUi = this.SearchResultGrid.DisplayLayout.UIElement.ElementFromPoint(new Point(e1.X, e1.Y));
if (element == null)
{
return;
}
// Try to get a Column from the element
UltraGridColumn col = elementUi.GetContext(typeof(UltraGridColumn)) as UltraGridColumn;
// Gets the Header Element
HeaderUIElement headerElement = element.GetAncestor(typeof(HeaderUIElement)) as HeaderUIElement;
if (headerElement != null)
{
this.hitCount++;
this.columnIndex = col.Index;
if (this.hitCount > 1)
{
if (this.columnIndex.Equals(2))
{
if (this.groupSearchIndicator.Equals(SortIndicator.Ascending))
{
if (this.searchSearchIndicator.Equals(SortIndicator.Ascending))
{
this.groupSearchIndicator = SortIndicator.Descending;
this.searchSearchIndicator = SortIndicator.Ascending;
}
else
{
this.groupSearchIndicator = SortIndicator.Descending;
this.searchSearchIndicator = SortIndicator.Descending;
}
}
else
{
if (this.searchSearchIndicator.Equals(SortIndicator.Ascending))
{
this.groupSearchIndicator = SortIndicator.Ascending;
this.searchSearchIndicator = SortIndicator.Ascending;
}
else
{
this.groupSearchIndicator = SortIndicator.Ascending;
this.searchSearchIndicator = SortIndicator.Descending;
}
}
}
else if (this.columnIndex.Equals(4) || this.columnIndex.Equals(5))
{
if (this.groupSearchIndicator.Equals(SortIndicator.Ascending))
{
if (this.searchSearchIndicator.Equals(SortIndicator.Ascending))
{
this.groupSearchIndicator = SortIndicator.Ascending;
this.searchSearchIndicator = SortIndicator.Descending;
}
else
{
this.groupSearchIndicator = SortIndicator.Ascending;
this.searchSearchIndicator = SortIndicator.Ascending;
}
}
else
{
if (this.searchSearchIndicator.Equals(SortIndicator.Ascending))
{
this.groupSearchIndicator = SortIndicator.Descending;
this.searchSearchIndicator = SortIndicator.Descending;
}
else
{
this.groupSearchIndicator = SortIndicator.Descending;
this.searchSearchIndicator = SortIndicator.Ascending;
}
}
}
}
if (this.SearchResultGrid.ActiveCell != null)
{
this.SearchResultGrid.ActiveCell.Selected = false;
}
}
}
catch (Exception ex)
{
ExceptionManager.ManageException(ex, ExceptionManager.ActionType.CloseCurrentForm, this.ParentForm);
}
}
private void setLayout()
{
//Set grid column layout
try {
#region A Hack
this.Controls.Clear();
Infragistics.Win.Appearance appearance1 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance2 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance3 = new Infragistics.Win.Appearance();
Infragistics.Win.Appearance appearance4 = new Infragistics.Win.Appearance();
this.grdSchedule = new Infragistics.Win.UltraWinGrid.UltraGrid();
((System.ComponentModel.ISupportInitialize)(this.grdSchedule)).BeginInit();
this.SuspendLayout();
this.grdSchedule.ContextMenu = this.ctxSchedule;
appearance1.BackColor = System.Drawing.SystemColors.Window;
appearance1.FontData.Name = "Verdana";
appearance1.FontData.SizeInPoints = 8F;
appearance1.ForeColor = System.Drawing.SystemColors.WindowText;
appearance1.TextHAlign = Infragistics.Win.HAlign.Left;
this.grdSchedule.DisplayLayout.Appearance = appearance1;
appearance2.BackColor = System.Drawing.SystemColors.InactiveCaption;
appearance2.FontData.BoldAsString = "True";
appearance2.FontData.Name = "Verdana";
appearance2.FontData.SizeInPoints = 8F;
appearance2.ForeColor = System.Drawing.SystemColors.InactiveCaptionText;
appearance2.TextHAlign = Infragistics.Win.HAlign.Left;
this.grdSchedule.DisplayLayout.CaptionAppearance = appearance2;
this.grdSchedule.DisplayLayout.Override.AllowAddNew = Infragistics.Win.UltraWinGrid.AllowAddNew.No;
this.grdSchedule.DisplayLayout.Override.AllowDelete = Infragistics.Win.DefaultableBoolean.False;
this.grdSchedule.DisplayLayout.Override.AllowUpdate = Infragistics.Win.DefaultableBoolean.False;
this.grdSchedule.DisplayLayout.Override.CellClickAction = Infragistics.Win.UltraWinGrid.CellClickAction.RowSelect;
appearance3.BackColor = System.Drawing.SystemColors.Control;
appearance3.FontData.BoldAsString = "True";
appearance3.FontData.Name = "Verdana";
appearance3.FontData.SizeInPoints = 8F;
appearance3.TextHAlign = Infragistics.Win.HAlign.Left;
this.grdSchedule.DisplayLayout.Override.HeaderAppearance = appearance3;
this.grdSchedule.DisplayLayout.Override.HeaderClickAction = Infragistics.Win.UltraWinGrid.HeaderClickAction.SortSingle;
this.grdSchedule.DisplayLayout.Override.MaxSelectedRows = 1;
appearance4.BorderColor = System.Drawing.SystemColors.ControlLight;
this.grdSchedule.DisplayLayout.Override.RowAppearance = appearance4;
this.grdSchedule.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
this.grdSchedule.DisplayLayout.Override.SelectTypeRow = Infragistics.Win.UltraWinGrid.SelectType.Single;
this.grdSchedule.DisplayLayout.ScrollBounds = Infragistics.Win.UltraWinGrid.ScrollBounds.ScrollToFill;
this.grdSchedule.DisplayLayout.ScrollStyle = Infragistics.Win.UltraWinGrid.ScrollStyle.Immediate;
this.grdSchedule.DisplayLayout.TabNavigation = Infragistics.Win.UltraWinGrid.TabNavigation.NextControl;
this.grdSchedule.DisplayLayout.ViewStyle = Infragistics.Win.UltraWinGrid.ViewStyle.SingleBand;
this.grdSchedule.Dock = System.Windows.Forms.DockStyle.Fill;
this.grdSchedule.Location = new System.Drawing.Point(0, 0);
this.grdSchedule.Name = "grdSchedule";
this.grdSchedule.Size = new System.Drawing.Size(448, 269);
this.grdSchedule.SupportThemes = false;
this.grdSchedule.TabIndex = 1;
this.grdSchedule.Text = "Schedule";
this.grdSchedule.DragDrop += new System.Windows.Forms.DragEventHandler(this.OnDragDrop);
this.grdSchedule.QueryContinueDrag += new System.Windows.Forms.QueryContinueDragEventHandler(this.OnQueryContinueDrag);
this.grdSchedule.DragOver += new System.Windows.Forms.DragEventHandler(this.OnDragOver);
this.grdSchedule.MouseMove += new System.Windows.Forms.MouseEventHandler(this.OnDragDropMouseMove);
this.grdSchedule.DoubleClick += new System.EventHandler(this.OnGridDoubleClicked);
this.grdSchedule.DragLeave += new System.EventHandler(this.OnDragLeave);
this.grdSchedule.DragEnter += new System.Windows.Forms.DragEventHandler(this.OnDragEnter);
this.grdSchedule.AfterSelectChange += new Infragistics.Win.UltraWinGrid.AfterSelectChangeEventHandler(this.OnGridSelectionChanged);
this.grdSchedule.MouseDown += new System.Windows.Forms.MouseEventHandler(this.OnGridMouseDown);
this.grdSchedule.SelectionDrag += new System.ComponentModel.CancelEventHandler(this.OnSelectionDrag);
this.grdSchedule.MouseUp += new System.Windows.Forms.MouseEventHandler(this.OnDragDropMouseUp);
this.Controls.Add(this.grdSchedule);
((System.ComponentModel.ISupportInitialize)(this.grdSchedule)).EndInit();
this.ResumeLayout(false);
#endregion
((System.ComponentModel.ISupportInitialize)(this.grdSchedule)).BeginInit();
this.grdSchedule.DataMember = this.mSchedule.ScheduleTableName;
this.grdSchedule.DataSource = this.mSchedule.Schedule;
UltraGridBand band = new UltraGridBand(this.mSchedule.ScheduleTableName, -1);
object[] o = new object[this.mViews.ActiveView.Count];
int i = 0;
foreach (LayoutEntry entry in this.mViews.ActiveView)
{
//Layout grid columns
UltraGridColumn col = null;
HAlign align = HAlign.Default;
switch (entry.Alignment)
{
case "L": align = HAlign.Left; break;
case "C": align = HAlign.Center; break;
case "R": align = HAlign.Right; break;
}
SortIndicator sortDir = SortIndicator.None;
if (entry.Sort != "")
{
sortDir = (entry.Sort == "A") ? SortIndicator.Ascending : SortIndicator.Descending;
}
col = (entry.GroupBy || sortDir != SortIndicator.None) ? new UltraGridColumn(entry.Key, -1, null, entry.SortOrder, sortDir, entry.GroupBy) : new UltraGridColumn(entry.Key);
col.Header.VisiblePosition = entry.VisiblePosition;
col.Hidden = !entry.Visible;
col.HiddenWhenGroupBy = entry.Visible ? DefaultableBoolean.False : DefaultableBoolean.True;
col.Header.Caption = entry.Caption;
col.Width = entry.Width;
if (entry.Format != "")
{
col.Format = entry.Format;
}
Infragistics.Win.Appearance a = new Infragistics.Win.Appearance();
a.TextHAlign = align;
col.Header.Appearance = col.CellAppearance = a;
col.NullText = entry.NullText;
o[i++] = col;
}
band.Columns.AddRange(o);
this.grdSchedule.AllowDrop = true;
this.grdSchedule.DisplayLayout.Override.SelectTypeRow = SelectType.ExtendedAutoDrag;
this.grdSchedule.DisplayLayout.Override.MaxSelectedRows = -1;
this.grdSchedule.DisplayLayout.BandsSerializer.Add(band);
this.grdSchedule.DisplayLayout.Override.HeaderClickAction = HeaderClickAction.SortMulti;
this.grdSchedule.DisplayLayout.ViewStyle = ViewStyle.SingleBand;
this.grdSchedule.DisplayLayout.ViewStyleBand = ViewStyleBand.OutlookGroupBy;
this.grdSchedule.Text = this.mSchedule.ScheduleName;
((System.ComponentModel.ISupportInitialize)(this.grdSchedule)).EndInit();
this.grdSchedule.Size = this.ClientSize;
//this.grdSchedule.Dock = DockStyle.Fill;
this.grdSchedule.Refresh();
this.Refresh();
}
catch (Exception ex) { reportError(ex); }
}
