public void CalculationsFooter(C1TrueDBGrid grid)
{
txtActualStock.Text = "0.00";
txtActualBonus.Text = "0.00";
txtActualValue.Text = ".00";
txtNewStock.Text = "0.00";
txtNewBonus.Text = "0.00";
txtNewValue.Text = "0.00";
for (int i = 0; i < grid.Splits[0].Rows.Count - 1; i++)
{
if (grid[i, "Type"].ToString() != "Bonus")
{
txtActualStock.Text = (Convert.ToDouble(txtActualStock.Text) + Convert.ToDouble(grid[i, "Old Qty"].ToString())).ToString();
txtNewStock.Text = (Convert.ToDouble(txtNewStock.Text) + Convert.ToDouble(grid[i, "Balance Qty"].ToString())).ToString();
}
else if (grid[i, "Type"].ToString() == "Bonus")
{
txtActualBonus.Text = (Convert.ToDouble(txtActualBonus.Text) + Convert.ToDouble(grid[i, "Old Qty"].ToString())).ToString();
txtNewBonus.Text = (Convert.ToDouble(txtNewBonus.Text) + Convert.ToDouble(grid[i, "Balance Qty"].ToString())).ToString();
}
txtActualValue.Text = Convert.ToDouble(txtActualValue.Text) + (Convert.ToDouble(grid[i, "Old Qty"].ToString()) * Convert.ToDouble(grid[i, "Cost Rate"].ToString())).ToString();
txtNewValue.Text = Convert.ToDouble(txtNewValue.Text) + (Convert.ToDouble(grid[i, "Balance Qty"].ToString()) * Convert.ToDouble(grid[i, "Cost Rate"].ToString())).ToString();
}
//txtNewValue.Text = string.Format("{0:00.00}", txtNewValue.Text);
//txtActualValue.Text = string.Format("{#,00.00}",txtActualValue.Text);
}
private void FormatGridHeader(C1TrueDBGrid grid)
{
for (int i = 0; i <= grid.Splits[0].DisplayColumns.Count - 1; i++)
{
grid.Splits[0].DisplayColumns[i].HeadingStyle.VerticalAlignment = AlignVertEnum.Center;
grid.Splits[0].DisplayColumns[i].HeadingStyle.HorizontalAlignment = AlignHorzEnum.Center;
grid.Splits[0].DisplayColumns[i].HeadingStyle.Font = new Font("Segoe UI", 10, FontStyle.Regular, GraphicsUnit.Point);
}
}
public static void BindGrid(
C1TrueDBGrid Grid
, String GridName
, DataTable Dt_Source
, ClsBindGrid GridDef
, Boolean IsDefault = false
, Boolean IsSelect = false)
{
ClsBindGrid GridDef_Cfg = Layer01_Config.pGridCfg_Get(GridName);
if (((GridDef.pColumns.Count != GridDef_Cfg.pColumns.Count) || IsDefault))
{
GridDef_Cfg.pColumns = GridDef.pColumns;
Layer01_Config.pGridCfg_Set(GridName, GridDef_Cfg);
}
if (IsSelect)
{
if (!Dt_Source.Columns.Contains("IsSelect"))
{ Dt_Source.Columns.Add("IsSelect", typeof(Boolean)); }
foreach (DataRow Dr in Dt_Source.Rows)
{ Dr["IsSelect"] = false; }
foreach (var Item in GridDef_Cfg.pColumns)
{ Item.pOrderIndex++; }
ClsBindGridColumn Gc_New = new ClsBindGridColumn();
GridDef_Cfg.pColumns.Add(Gc_New);
Gc_New.pFieldName = "IsSelect";
Gc_New.pFieldDesc = "Is Select?";
Gc_New.pWidth = 80;
Gc_New.pHorizontalAlign = Layer01_Constants.eSystem_Lookup_HorizontalAlign.Grid_HorizontalAlign_Center;
Gc_New.pOrderIndex = 0;
}
InitializeGrid(Grid);
Grid.DataSource = Dt_Source;
Grid.Splits[0].CaptionHeight = 45;
BindGrid_SetColumns(Grid, GridDef_Cfg);
}
private void FormatGridHeader(C1TrueDBGrid grid)
{
for (int i = 0; i <= grid.Splits[0].DisplayColumns.Count - 1; i++)
{
grid.Splits[0].DisplayColumns[i].HeadingStyle.VerticalAlignment = AlignVertEnum.Center;
grid.Splits[0].DisplayColumns[i].HeadingStyle.HorizontalAlignment = AlignHorzEnum.Center;
grid.Splits[0].DisplayColumns[i].HeadingStyle.Font = new Font("Segoe UI", 8, FontStyle.Regular, GraphicsUnit.Point);
grid.VisualStyle = VisualStyle.Office2010Blue;
grid.RowHeight = 20;
grid.RecordSelectors = false;
}
}
private void DeleteSelectedRow(C1TrueDBGrid grd)
{
if (grd.RowCount > 0)
{
grd.Delete();
grd.Refresh();
}
}
public static void BindGrid_SetColumns(
C1TrueDBGrid Grid
, ClsBindGrid GridDef)
{
List<ClsBindGridColumn> GridDef_Columns = GridDef.pColumns;
List<String> List_Columns = (from O in GridDef_Columns orderby O.pOrderIndex select O.pFieldName).ToList();
SetGridColumnArrangement(Grid, List_Columns);
foreach (Split Sp in Grid.Splits)
{
foreach (C1DisplayColumn Dc in Sp.DisplayColumns)
{
var Inner_ItemColumn = GridDef_Columns.FirstOrDefault(O => O.pFieldName == Dc.DataColumn.DataField);
if (Inner_ItemColumn != null)
{
Dc.Width = Inner_ItemColumn.pWidth;
Dc.DataColumn.Caption = Inner_ItemColumn.pFieldDesc;
Dc.Locked = !Inner_ItemColumn.pIsEnabled;
Dc.FetchStyle = true;
switch (Inner_ItemColumn.pHorizontalAlign)
{
case Layer01_Constants.eSystem_Lookup_HorizontalAlign.Grid_HorizontalAlign_Center:
Dc.Style.HorizontalAlignment = AlignHorzEnum.Center;
break;
case Layer01_Constants.eSystem_Lookup_HorizontalAlign.Grid_HorizontalAlign_Far:
Dc.Style.HorizontalAlignment = AlignHorzEnum.Far;
break;
case Layer01_Constants.eSystem_Lookup_HorizontalAlign.Grid_HorizontalAlign_General:
Dc.Style.HorizontalAlignment = AlignHorzEnum.General;
break;
case Layer01_Constants.eSystem_Lookup_HorizontalAlign.Grid_HorizontalAlign_Justify:
Dc.Style.HorizontalAlignment = AlignHorzEnum.Justify;
break;
case Layer01_Constants.eSystem_Lookup_HorizontalAlign.Grid_HorizontalAlign_Near:
Dc.Style.HorizontalAlignment = AlignHorzEnum.Near;
break;
default:
Dc.Style.HorizontalAlignment = AlignHorzEnum.Justify;
break;
}
switch (Inner_ItemColumn.pFieldType)
{
case Layer01_Constants.eSystem_Lookup_FieldType.FieldType_Button:
Dc.ButtonAlways = true;
Dc.ButtonText = true;
Dc.Locked = true;
Dc.Frozen = true;
break;
}
}
else
{
Dc.Visible = false;
Dc.AllowSizing = false;
}
Dc.HeadingStyle.HorizontalAlignment = AlignHorzEnum.Justify;
}
}
}
public static void SetGridColumnArrangement(C1TrueDBGrid Grid, List<String> List_ColumnName)
{
Int32 Ct = 0;
foreach (String ColumnName in List_ColumnName)
{
C1DisplayColumn Dc = null;
foreach (C1DisplayColumn Inner_Dc in Grid.Splits[0].DisplayColumns)
{
if (ColumnName == Inner_Dc.DataColumn.DataField)
{
Dc = Inner_Dc;
break;
}
}
if (Dc != null)
{
foreach (Split S in Grid.Splits)
{
S.DisplayColumns.RemoveAt(S.DisplayColumns.IndexOf(Dc));
S.DisplayColumns.Insert(Ct, Dc);
}
}
Ct++;
}
}
public static void InitializeGrid(C1TrueDBGrid Grid)
{
Grid.GroupByAreaVisible = false;
Grid.DataView = DataViewEnum.GroupBy;
Grid.AllowFilter = false;
Grid.FilterBar = true;
Grid.AllowSort = true;
Grid.ExtendRightColumn = false;
Grid.MaintainRowCurrency = false;
Grid.AllowHorizontalSplit = true;
Grid.AllowVerticalSplit = true;
Grid.MarqueeStyle = MarqueeEnum.HighlightCell;
Grid.DirectionAfterEnter = DirectionAfterEnterEnum.MoveNone;
Grid.TabAction = TabActionEnum.ControlNavigation;
Grid.HighLightRowStyle.BackColor = Color.DarkGray;
Grid.HighLightRowStyle.ForeColor = Color.White;
Grid.AlternatingRows = true;
//Grid.EvenRowStyle.BackColor = Color.White;
//Grid.OddRowStyle.BackColor = Color.LightGray;
Grid.EvenRowStyle.BackColor = Color.White;
Grid.OddRowStyle.BackColor = Color.LightGray;
Grid.AllowUpdate = false;
Grid.AllowUpdateOnBlur = true;
Grid.AllowDelete = false;
Grid.AllowAddNew = false;
Grid.ColumnFooters = false;
}
public static void FilterGrid(C1TrueDBGrid Grid)
{
try
{
StringBuilder Filter = new StringBuilder();
Filter.Append(@"1 = 1");
foreach (C1DataColumn Col in Grid.Columns)
{
if (Col.FilterText.Trim() != "")
{
Type DataType = (Grid.DataSource as DataTable).Columns[Col.DataField].DataType;
if (DataType.Name == typeof(String).Name)
{ Filter.Append(@" And [" + Col.DataField + @"] Like '" + Col.FilterText + @"%'"); }
else
{
String TmpFilter = Col.FilterText;
if (Do_Methods.ParseFilterText(ref TmpFilter, DataType))
{ Filter.Append(@" And [" + Col.DataField + @"] " + TmpFilter + @""); }
}
}
}
(Grid.DataSource as DataTable).DefaultView.RowFilter = Filter.ToString();
}
catch { }
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(frmSearch));
this._grid = new C1.Win.C1TrueDBGrid.C1TrueDBGrid();
this.gbBottomSearch = new System.Windows.Forms.GroupBox();
this.label1 = new System.Windows.Forms.Label();
this.btCloseSearch = new C1.Win.C1Input.C1Button();
this.panel1 = new System.Windows.Forms.Panel();
((System.ComponentModel.ISupportInitialize)(this._grid)).BeginInit();
this.gbBottomSearch.SuspendLayout();
this.panel1.SuspendLayout();
this.SuspendLayout();
//
// _grid
//
this._grid.AllowRowSizing = C1.Win.C1TrueDBGrid.RowSizingEnum.None;
this._grid.AllowUpdate = false;
this._grid.AllowUpdateOnBlur = false;
this._grid.AlternatingRows = true;
this._grid.BackColor = System.Drawing.SystemColors.AppWorkspace;
this._grid.BorderStyle = System.Windows.Forms.BorderStyle.None;
this._grid.Caption = "Daftar XXXXXX";
this._grid.CaptionHeight = 17;
this._grid.Dock = System.Windows.Forms.DockStyle.Fill;
this._grid.ExpandColor = System.Drawing.Color.MediumBlue;
this._grid.ExtendRightColumn = true;
this._grid.FilterBar = true;
this._grid.GroupByCaption = "Drag a column header here to group by that column";
this._grid.Images.Add(((System.Drawing.Image)(resources.GetObject("_grid.Images"))));
this._grid.Location = new System.Drawing.Point(0, 0);
this._grid.MarqueeStyle = C1.Win.C1TrueDBGrid.MarqueeEnum.HighlightRow;
this._grid.MultiSelect = C1.Win.C1TrueDBGrid.MultiSelectEnum.None;
this._grid.Name = "_grid";
this._grid.PreviewInfo.Location = new System.Drawing.Point(0, 0);
this._grid.PreviewInfo.Size = new System.Drawing.Size(0, 0);
this._grid.PreviewInfo.ZoomFactor = 75;
this._grid.RecordSelectors = false;
this._grid.RowHeight = 15;
this._grid.Size = new System.Drawing.Size(590, 402);
this._grid.TabIndex = 0;
this._grid.Text = "c1TrueDBGrid1";
this._grid.VisualStyle = C1.Win.C1TrueDBGrid.VisualStyle.Office2007Blue;
this._grid.DoubleClick += new System.EventHandler(this._grid_DoubleClick);
this._grid.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this._grid_KeyPress);
this._grid.PropBag = resources.GetString("_grid.PropBag");
//
// gbBottomSearch
//
this.gbBottomSearch.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(242)))), ((int)(((byte)(251)))));
this.gbBottomSearch.Controls.Add(this.label1);
this.gbBottomSearch.Controls.Add(this.btCloseSearch);
this.gbBottomSearch.Dock = System.Windows.Forms.DockStyle.Bottom;
this.gbBottomSearch.Location = new System.Drawing.Point(0, 402);
this.gbBottomSearch.Name = "gbBottomSearch";
this.gbBottomSearch.Size = new System.Drawing.Size(590, 42);
this.gbBottomSearch.TabIndex = 1;
this.gbBottomSearch.TabStop = false;
//
// label1
//
this.label1.AutoSize = true;
this.label1.Location = new System.Drawing.Point(20, 18);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(221, 13);
this.label1.TabIndex = 3;
this.label1.Text = "*) Double click an itemto make your selection";
//
// btCloseSearch
//
this.btCloseSearch.Location = new System.Drawing.Point(496, 12);
this.btCloseSearch.Name = "btCloseSearch";
this.btCloseSearch.Size = new System.Drawing.Size(80, 24);
this.btCloseSearch.TabIndex = 2;
this.btCloseSearch.Text = "&Close";
this.btCloseSearch.UseVisualStyleBackColor = true;
this.btCloseSearch.Click += new System.EventHandler(this.btCloseSearch_Click);
//
// panel1
//
this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
this.panel1.Controls.Add(this._grid);
this.panel1.Controls.Add(this.gbBottomSearch);
this.panel1.Dock = System.Windows.Forms.DockStyle.Fill;
this.panel1.Location = new System.Drawing.Point(0, 0);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(592, 446);
this.panel1.TabIndex = 0;
//
// frmSearch
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(592, 446);
this.Controls.Add(this.panel1);
this.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
this.MaximizeBox = false;
this.MinimizeBox = false;
this.Name = "frmSearch";
this.ShowInTaskbar = false;
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "Template Search";
((System.ComponentModel.ISupportInitialize)(this._grid)).EndInit();
this.gbBottomSearch.ResumeLayout(false);
this.gbBottomSearch.PerformLayout();
this.panel1.ResumeLayout(false);
this.ResumeLayout(false);
}
public override void ZoomBounds(Control control, ZoomBoundsInfo infos)
{
C1TrueDBGrid trueDBGrid = control as C1TrueDBGrid;
if (trueDBGrid.CellTipsWidth > 0)
{
trueDBGrid.CellTipsWidth = infos.Zoom(trueDBGrid.CellTipsWidth);
}
if (trueDBGrid.DefColWidth > 0)
{
trueDBGrid.DefColWidth = infos.Zoom(trueDBGrid.DefColWidth);
}
if (trueDBGrid.RecordSelectorWidth > 0)
{
trueDBGrid.RecordSelectorWidth = infos.Zoom(trueDBGrid.RecordSelectorWidth);
}
if (trueDBGrid.ViewCaptionWidth > 0)
{
trueDBGrid.ViewCaptionWidth = infos.Zoom(trueDBGrid.ViewCaptionWidth);
}
if (trueDBGrid.ViewColumnWidth > 0)
{
trueDBGrid.ViewColumnWidth = infos.Zoom(trueDBGrid.ViewColumnWidth);
}
if (trueDBGrid.CaptionHeight > 0)
{
trueDBGrid.CaptionHeight = infos.Zoom(trueDBGrid.CaptionHeight);
}
if (trueDBGrid.RowHeight > 0)
{
trueDBGrid.RowHeight = infos.Zoom(trueDBGrid.RowHeight);
}
if (!trueDBGrid.SplitDividerSize.IsEmpty)
{
trueDBGrid.SplitDividerSize = infos.Zoom(trueDBGrid.SplitDividerSize);
}
foreach (Split split in trueDBGrid.Splits)
{
if (split.CaptionHeight > 0)
{
split.CaptionHeight = infos.Zoom(split.CaptionHeight);
}
if (split.ColumnCaptionHeight > 0)
{
split.ColumnCaptionHeight = infos.Zoom(split.ColumnCaptionHeight);
}
if (split.ColumnFooterHeight > 0)
{
split.ColumnFooterHeight = infos.Zoom(split.ColumnFooterHeight);
}
if (split.Height > 0)
{
split.Height = infos.Zoom(split.Height);
}
if (split.MinHeight > 0)
{
split.MinHeight = infos.Zoom(split.MinHeight);
}
if (split.MinWidth > 0)
{
split.MinWidth = infos.Zoom(split.MinWidth);
}
if (split.SplitSize > 0)
{
split.SplitSize = infos.Zoom(split.SplitSize);
}
foreach (C1DisplayColumn column in split.DisplayColumns)
{
if (column.Width > 0)
{
column.Width = infos.Zoom(column.Width);
}
if (column.Height > 0)
{
column.Height = infos.Zoom(column.Height);
}
}
foreach (ViewRow row in split.Rows)
{
if (row.Width > 0)
{
row.Width = infos.Zoom(row.Width);
}
if (row.Height > 0)
{
row.Height = infos.Zoom(row.Height);
}
}
}
foreach (C1DataColumn column in trueDBGrid.Columns)
{
if (column.DataWidth > 0)
{
column.DataWidth = infos.Zoom(column.DataWidth);
}
}
base.ZoomBounds(control, infos);
}
