コード例 #1
0
        private void setGrdViewHM20()
        {
            FarPoint.Win.Spread.CellType.CurrencyCellType ctest       = new FarPoint.Win.Spread.CellType.CurrencyCellType();
            FarPoint.Win.Spread.CellType.TextCellType     objTextCell = new FarPoint.Win.Spread.CellType.TextCellType();
            FarPoint.Win.Spread.CellType.ButtonCellType   buttencell  = new FarPoint.Win.Spread.CellType.ButtonCellType();
            FarPoint.Win.Spread.CellType.ComboBoxCellType combocell   = new FarPoint.Win.Spread.CellType.ComboBoxCellType();
            combocell.Items = sC.mHisDB.fm20;

            grdView.Sheets[2].ColumnCount   = colBMCnt;
            grdView.Sheets[2].OperationMode = FarPoint.Win.Spread.OperationMode.RowMode;

            grdView.Sheets[2].ColumnHeader.Cells[0, colBMedit].Text = "edit";
            grdView.Sheets[2].ColumnHeader.Cells[0, colBMsave].Text = "save";
            grdView.Sheets[2].ColumnHeader.Cells[0, colBMCode].Text = "code";
            grdView.Sheets[2].ColumnHeader.Cells[0, colBMDesc].Text = "Description";
            //grdView.Sheets[1].ColumnHeader.Cells[0, colM06Grpss2].Text = "edit";

            grdView.Sheets[2].Columns[colBMedit].Width = 50;
            grdView.Sheets[2].Columns[colBMsave].Width = 50;
            grdView.Sheets[2].Columns[colBMCode].Width = 80;
            grdView.Sheets[2].Columns[colBMDesc].Width = 200;
            //grdView.Sheets[1].Columns[colM06Grpss2].Width = 50;
            //grdView.Sheets[0].Columns[colE].Width = 50;

            grdView.Sheets[2].Columns[colBMedit].CellType = buttencell;
            grdView.Sheets[2].Columns[colBMsave].CellType = buttencell;
            grdView.Sheets[2].Columns[colBMCode].CellType = objTextCell;
            grdView.Sheets[2].Columns[colBMDesc].CellType = objTextCell;
            //grdView.Sheets[1].Columns[colM06Grpss2].CellType = objTextCell;
        }
コード例 #2
0
        private void setGrdViewH()
        {
            FarPoint.Win.Spread.EnhancedInterfaceRenderer outlinelook = new FarPoint.Win.Spread.EnhancedInterfaceRenderer();
            outlinelook.RangeGroupBackgroundColor   = Color.LightGreen;
            outlinelook.RangeGroupButtonBorderColor = Color.Red;
            outlinelook.RangeGroupLineColor         = Color.Blue;
            grdView.InterfaceRenderer = outlinelook;

            grdView.BorderStyle = BorderStyle.None;
            grdView.Sheets[0].Columns[2, colgrd].AllowAutoFilter = true;
            grdView.Sheets[0].Columns[2, colgrd].AllowAutoSort   = true;
            grdView.Sheets[0].AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.EnhancedContextMenu;

            FarPoint.Win.Spread.CellType.NumberCellType objNumCell = new FarPoint.Win.Spread.CellType.NumberCellType();
            objNumCell.DecimalPlaces = 0;
            objNumCell.MinimumValue  = 1;
            objNumCell.MaximumValue  = 9999;
            objNumCell.ShowSeparator = false;

            FarPoint.Win.Spread.CellType.DateTimeCellType datecell = new FarPoint.Win.Spread.CellType.DateTimeCellType();
            datecell.DateSeparator  = " | ";
            datecell.TimeSeparator  = ".";
            datecell.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDateWithTime;

            FarPoint.Win.Spread.CellType.CurrencyCellType ctest       = new FarPoint.Win.Spread.CellType.CurrencyCellType();
            FarPoint.Win.Spread.CellType.TextCellType     objTextCell = new FarPoint.Win.Spread.CellType.TextCellType();
            FarPoint.Win.Spread.CellType.ButtonCellType   buttencell  = new FarPoint.Win.Spread.CellType.ButtonCellType();
            FarPoint.Win.Spread.CellType.ComboBoxCellType combocell   = new FarPoint.Win.Spread.CellType.ComboBoxCellType();
            combocell.Items = sC.mHisDB.fm20;

            //grdView.Sheets.Count = 1;
            grdView.Sheets[0].ColumnCount   = colCnt;
            grdView.Sheets[0].OperationMode = FarPoint.Win.Spread.OperationMode.RowMode;

            grdView.Sheets[0].ColumnHeader.Cells[0, colE].Text      = "edit";
            grdView.Sheets[0].ColumnHeader.Cells[0, colS].Text      = "save";
            grdView.Sheets[0].ColumnHeader.Cells[0, colCode].Text   = "FN_CD";
            grdView.Sheets[0].ColumnHeader.Cells[0, colDesc].Text   = "Description";
            grdView.Sheets[0].ColumnHeader.Cells[0, colGrpss2].Text = "grd_ss_2";
            grdView.Sheets[0].ColumnHeader.Cells[0, colgrd].Text    = "GRD_CD";

            grdView.Sheets[0].Columns[colE].Width      = 50;
            grdView.Sheets[0].Columns[colS].Width      = 50;
            grdView.Sheets[0].Columns[colCode].Width   = 80;
            grdView.Sheets[0].Columns[colDesc].Width   = 250;
            grdView.Sheets[0].Columns[colGrpss2].Width = 250;
            grdView.Sheets[0].Columns[colgrd].Width    = 300;

            grdView.Sheets[0].Columns[colE].CellType      = buttencell;
            grdView.Sheets[0].Columns[colS].CellType      = buttencell;
            grdView.Sheets[0].Columns[colCode].CellType   = objTextCell;
            grdView.Sheets[0].Columns[colDesc].CellType   = objTextCell;
            grdView.Sheets[0].Columns[colgrd].CellType    = objTextCell;
            grdView.Sheets[0].Columns[colGrpss2].CellType = combocell;

            grdView.Sheets[0].Columns[coledit].Visible = false;
        }
コード例 #3
0
        private void setGrdViewH()
        {
            FarPoint.Win.Spread.EnhancedInterfaceRenderer outlinelook = new FarPoint.Win.Spread.EnhancedInterfaceRenderer();
            outlinelook.RangeGroupBackgroundColor   = Color.LightGreen;
            outlinelook.RangeGroupButtonBorderColor = Color.Red;
            outlinelook.RangeGroupLineColor         = Color.Blue;
            grdView.InterfaceRenderer       = outlinelook;
            grdView.Sheets[0].OperationMode = FarPoint.Win.Spread.OperationMode.RowMode;

            grdView.BorderStyle = BorderStyle.None;
            grdView.Sheets[0].Columns[0, 2].AllowAutoFilter = true;
            grdView.Sheets[0].Columns[0, 2].AllowAutoSort   = true;
            grdView.Sheets[0].AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.EnhancedContextMenu;

            FarPoint.Win.Spread.CellType.NumberCellType objNumCell = new FarPoint.Win.Spread.CellType.NumberCellType();
            objNumCell.DecimalPlaces = 0;
            objNumCell.MinimumValue  = 1;
            objNumCell.MaximumValue  = 9999;
            objNumCell.ShowSeparator = false;

            FarPoint.Win.Spread.CellType.DateTimeCellType datecell = new FarPoint.Win.Spread.CellType.DateTimeCellType();
            datecell.DateSeparator  = " | ";
            datecell.TimeSeparator  = ".";
            datecell.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDateWithTime;

            FarPoint.Win.Spread.CellType.CurrencyCellType ctest = new FarPoint.Win.Spread.CellType.CurrencyCellType();
            ctest.SetCalculatorText("Accept", "Cancel");
            FarPoint.Win.Spread.CellType.TextCellType objTextCell = new FarPoint.Win.Spread.CellType.TextCellType();

            //grdView.sheet
            //grdView.Height = 330;
            //grdView.Width = 765;
            grdView.Sheets[0].ColumnCount = colCnt;
            grdView.Sheets[0].RowCount    = 1;


            //grdView.Sheets[0].ColumnHeader.Cells[0, 0].Text = "Check #";
            grdView.Sheets[0].Columns[colId].CellType          = objTextCell;
            grdView.Sheets[0].Columns[colbtid].CellType        = objTextCell;
            grdView.Sheets[0].Columns[colinvno].CellType       = objTextCell;
            grdView.Sheets[0].Columns[colsvdate].CellType      = objTextCell;
            grdView.Sheets[0].Columns[colbillmuad].CellType    = objTextCell;
            grdView.Sheets[0].Columns[collccode].CellType      = objTextCell;
            grdView.Sheets[0].Columns[colstdcode].CellType     = objTextCell;
            grdView.Sheets[0].Columns[coldesc1].CellType       = objTextCell;
            grdView.Sheets[0].Columns[colqty].CellType         = objTextCell;
            grdView.Sheets[0].Columns[colup].CellType          = objTextCell;
            grdView.Sheets[0].Columns[colchargeamt].CellType   = objTextCell;
            grdView.Sheets[0].Columns[colclaimup].CellType     = objTextCell;
            grdView.Sheets[0].Columns[colsvrefid].CellType     = objTextCell;
            grdView.Sheets[0].Columns[colclaimcat].CellType    = objTextCell;
            grdView.Sheets[0].Columns[colEdit].CellType        = objTextCell;
            grdView.Sheets[0].Columns[colClaimamount].CellType = objTextCell;

            grdView.Sheets[0].Columns[colId].Visible   = false;
            grdView.Sheets[0].Columns[colbtid].Visible = false;
            grdView.Sheets[0].Columns[colEdit].Visible = false;

            grdView.Sheets[0].SheetName = "BillTran Items";

            grdView.Sheets[0].Columns[colinvno].Width       = 100;
            grdView.Sheets[0].Columns[colsvdate].Width      = 120;
            grdView.Sheets[0].Columns[colbillmuad].Width    = 50;
            grdView.Sheets[0].Columns[collccode].Width      = 50;
            grdView.Sheets[0].Columns[colstdcode].Width     = 50;
            grdView.Sheets[0].Columns[coldesc1].Width       = 250;
            grdView.Sheets[0].Columns[colqty].Width         = 50;
            grdView.Sheets[0].Columns[colup].Width          = 80;
            grdView.Sheets[0].Columns[colchargeamt].Width   = 60;
            grdView.Sheets[0].Columns[colclaimup].Width     = 50;
            grdView.Sheets[0].Columns[colsvrefid].Width     = 80;
            grdView.Sheets[0].Columns[colclaimcat].Width    = 50;
            grdView.Sheets[0].Columns[colClaimamount].Width = 50;

            grdView.Sheets[0].ColumnHeader.Cells[0, colinvno].Text       = "invno";
            grdView.Sheets[0].ColumnHeader.Cells[0, colsvdate].Text      = "svdate";
            grdView.Sheets[0].ColumnHeader.Cells[0, colbillmuad].Text    = "billmuad";
            grdView.Sheets[0].ColumnHeader.Cells[0, collccode].Text      = "lccode";
            grdView.Sheets[0].ColumnHeader.Cells[0, colstdcode].Text     = "stdcode";
            grdView.Sheets[0].ColumnHeader.Cells[0, coldesc1].Text       = "description";
            grdView.Sheets[0].ColumnHeader.Cells[0, colqty].Text         = "qty";
            grdView.Sheets[0].ColumnHeader.Cells[0, colup].Text          = "up";
            grdView.Sheets[0].ColumnHeader.Cells[0, colchargeamt].Text   = "chargeamt";
            grdView.Sheets[0].ColumnHeader.Cells[0, colclaimup].Text     = "claimup";
            grdView.Sheets[0].ColumnHeader.Cells[0, colsvrefid].Text     = "svrefid";
            grdView.Sheets[0].ColumnHeader.Cells[0, colclaimcat].Text    = "claimcat";
            grdView.Sheets[0].ColumnHeader.Cells[0, colClaimamount].Text = "claimamount";

            grdView.Sheets[0].RestrictRows = true;
        }
コード例 #4
0
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     this.components = new System.ComponentModel.Container();
     System.ComponentModel.ComponentResourceManager resources         = new System.ComponentModel.ComponentResourceManager(typeof(MAS050_BOMSetup));
     FarPoint.Win.Spread.CellType.TextCellType      textCellType1     = new FarPoint.Win.Spread.CellType.TextCellType();
     FarPoint.Win.Spread.CellType.TextCellType      textCellType2     = new FarPoint.Win.Spread.CellType.TextCellType();
     FarPoint.Win.Spread.CellType.TextCellType      textCellType3     = new FarPoint.Win.Spread.CellType.TextCellType();
     FarPoint.Win.Spread.CellType.CheckBoxCellType  checkBoxCellType1 = new FarPoint.Win.Spread.CellType.CheckBoxCellType();
     FarPoint.Win.Spread.CellType.NumberCellType    numberCellType1   = new FarPoint.Win.Spread.CellType.NumberCellType();
     FarPoint.Win.Spread.CellType.CurrencyCellType  currencyCellType1 = new FarPoint.Win.Spread.CellType.CurrencyCellType();
     FarPoint.Win.Spread.CellType.CurrencyCellType  currencyCellType2 = new FarPoint.Win.Spread.CellType.CurrencyCellType();
     this.pnlContainerNew   = new EVOFramework.Windows.Forms.EVOPanel();
     this.tableLayoutPanel1 = new System.Windows.Forms.TableLayoutPanel();
     this.tlpHeader2        = new System.Windows.Forms.TableLayoutPanel();
     this.stcBOMInformation = new EVOFramework.Windows.Forms.EVOLabel();
     this.stcBOMSetup       = new EVOFramework.Windows.Forms.EVOLabel();
     this.tableLayoutPanel2 = new System.Windows.Forms.TableLayoutPanel();
     this.stcItemDesc       = new EVOFramework.Windows.Forms.EVOLabel();
     this.stcItemCD         = new EVOFramework.Windows.Forms.EVOLabel();
     this.label4            = new EVOFramework.Windows.Forms.EVOLabel();
     this.txtItemCD         = new Rubik.Forms.UserControl.ItemTextBox();
     this.txtItemDesc       = new EVOFramework.Windows.Forms.EVOTextBox();
     this.btnItemCD         = new EVOFramework.Windows.Forms.EVOButton();
     this.panel1            = new System.Windows.Forms.Panel();
     this.fpView            = new FarPoint.Win.Spread.FpSpread();
     this.ctxMenu           = new System.Windows.Forms.ContextMenuStrip(this.components);
     this.miAddChildItem    = new System.Windows.Forms.ToolStripMenuItem();
     this.miEditItem        = new System.Windows.Forms.ToolStripMenuItem();
     this.miDeleteItem      = new System.Windows.Forms.ToolStripMenuItem();
     this.miDeleteTree      = new System.Windows.Forms.ToolStripMenuItem();
     this.shtView           = new FarPoint.Win.Spread.SheetView();
     this.panel2            = new System.Windows.Forms.Panel();
     this.btnMoveUp         = new EVOFramework.Windows.Forms.EVOButton();
     this.btnMoveDown       = new EVOFramework.Windows.Forms.EVOButton();
     this.imgListStateNode  = new System.Windows.Forms.ImageList(this.components);
     this.tslControl        = new System.Windows.Forms.ToolStrip();
     this.tsbSave           = new System.Windows.Forms.ToolStripButton();
     this.tlsSeperator1     = new System.Windows.Forms.ToolStripSeparator();
     this.tsbCancel         = new System.Windows.Forms.ToolStripButton();
     this.tlsSeperator2     = new System.Windows.Forms.ToolStripSeparator();
     this.pnlContainerNew.SuspendLayout();
     this.tableLayoutPanel1.SuspendLayout();
     this.tlpHeader2.SuspendLayout();
     this.tableLayoutPanel2.SuspendLayout();
     this.panel1.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.fpView)).BeginInit();
     this.ctxMenu.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.shtView)).BeginInit();
     this.panel2.SuspendLayout();
     this.tslControl.SuspendLayout();
     this.SuspendLayout();
     //
     // pnlContainerNew
     //
     this.pnlContainerNew.AppearanceName = "FormBGColor";
     this.pnlContainerNew.AutoScroll     = true;
     this.pnlContainerNew.Controls.Add(this.tableLayoutPanel1);
     this.pnlContainerNew.Dock     = System.Windows.Forms.DockStyle.Fill;
     this.pnlContainerNew.Font     = new System.Drawing.Font("Tahoma", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222)));
     this.pnlContainerNew.Location = new System.Drawing.Point(0, 28);
     this.pnlContainerNew.Name     = "pnlContainerNew";
     this.pnlContainerNew.Size     = new System.Drawing.Size(792, 461);
     this.pnlContainerNew.TabIndex = 0;
     //
     // tableLayoutPanel1
     //
     this.tableLayoutPanel1.ColumnCount = 1;
     this.tableLayoutPanel1.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 100F));
     this.tableLayoutPanel1.Controls.Add(this.tlpHeader2, 0, 2);
     this.tableLayoutPanel1.Controls.Add(this.stcBOMSetup, 0, 0);
     this.tableLayoutPanel1.Controls.Add(this.tableLayoutPanel2, 0, 1);
     this.tableLayoutPanel1.Controls.Add(this.panel1, 0, 3);
     this.tableLayoutPanel1.Dock     = System.Windows.Forms.DockStyle.Fill;
     this.tableLayoutPanel1.Location = new System.Drawing.Point(0, 0);
     this.tableLayoutPanel1.Margin   = new System.Windows.Forms.Padding(0);
     this.tableLayoutPanel1.Name     = "tableLayoutPanel1";
     this.tableLayoutPanel1.RowCount = 4;
     this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle());
     this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle());
     this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle());
     this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 100F));
     this.tableLayoutPanel1.Size     = new System.Drawing.Size(792, 461);
     this.tableLayoutPanel1.TabIndex = 0;
     //
     // tlpHeader2
     //
     this.tlpHeader2.AutoSize        = true;
     this.tlpHeader2.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("tlpHeader2.BackgroundImage")));
     this.tlpHeader2.ColumnCount     = 1;
     this.tlpHeader2.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 100F));
     this.tlpHeader2.Controls.Add(this.stcBOMInformation, 0, 0);
     this.tlpHeader2.Dock     = System.Windows.Forms.DockStyle.Fill;
     this.tlpHeader2.Location = new System.Drawing.Point(0, 51);
     this.tlpHeader2.Margin   = new System.Windows.Forms.Padding(0);
     this.tlpHeader2.Name     = "tlpHeader2";
     this.tlpHeader2.RowCount = 1;
     this.tlpHeader2.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 100F));
     this.tlpHeader2.Size     = new System.Drawing.Size(792, 24);
     this.tlpHeader2.TabIndex = 38;
     //
     // stcBOMInformation
     //
     this.stcBOMInformation.AppearanceName = "Header";
     this.stcBOMInformation.AutoSize       = true;
     this.stcBOMInformation.ControlID      = "";
     this.stcBOMInformation.Font           = new System.Drawing.Font("Microsoft Sans Serif", 14.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222)));
     this.stcBOMInformation.ForeColor      = System.Drawing.Color.Navy;
     this.stcBOMInformation.Location       = new System.Drawing.Point(0, 0);
     this.stcBOMInformation.Margin         = new System.Windows.Forms.Padding(0, 0, 3, 0);
     this.stcBOMInformation.Name           = "stcBOMInformation";
     this.stcBOMInformation.PathString     = null;
     this.stcBOMInformation.PathValue      = "BOM Structure Information";
     this.stcBOMInformation.Size           = new System.Drawing.Size(230, 24);
     this.stcBOMInformation.TabIndex       = 0;
     this.stcBOMInformation.Text           = "BOM Structure Information";
     //
     // stcBOMSetup
     //
     this.stcBOMSetup.AppearanceName = "Title";
     this.stcBOMSetup.AutoSize       = true;
     this.stcBOMSetup.ControlID      = "";
     this.stcBOMSetup.Dock           = System.Windows.Forms.DockStyle.Top;
     this.stcBOMSetup.ForeColor      = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(192)))));
     this.stcBOMSetup.Location       = new System.Drawing.Point(3, 0);
     this.stcBOMSetup.Name           = "stcBOMSetup";
     this.stcBOMSetup.PathString     = null;
     this.stcBOMSetup.PathValue      = "BOM Setup";
     this.stcBOMSetup.Size           = new System.Drawing.Size(786, 19);
     this.stcBOMSetup.TabIndex       = 36;
     this.stcBOMSetup.Text           = "BOM Setup";
     this.stcBOMSetup.UseMnemonic    = false;
     //
     // tableLayoutPanel2
     //
     this.tableLayoutPanel2.AutoSize    = true;
     this.tableLayoutPanel2.ColumnCount = 6;
     this.tableLayoutPanel2.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Absolute, 20F));
     this.tableLayoutPanel2.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Absolute, 88F));
     this.tableLayoutPanel2.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 30F));
     this.tableLayoutPanel2.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle());
     this.tableLayoutPanel2.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Absolute, 106F));
     this.tableLayoutPanel2.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 70F));
     this.tableLayoutPanel2.Controls.Add(this.stcItemDesc, 4, 0);
     this.tableLayoutPanel2.Controls.Add(this.stcItemCD, 1, 0);
     this.tableLayoutPanel2.Controls.Add(this.label4, 0, 0);
     this.tableLayoutPanel2.Controls.Add(this.txtItemCD, 2, 0);
     this.tableLayoutPanel2.Controls.Add(this.btnItemCD, 3, 0);
     this.tableLayoutPanel2.Controls.Add(this.txtItemDesc, 5, 0);
     this.tableLayoutPanel2.Dock     = System.Windows.Forms.DockStyle.Top;
     this.tableLayoutPanel2.Location = new System.Drawing.Point(0, 19);
     this.tableLayoutPanel2.Margin   = new System.Windows.Forms.Padding(0);
     this.tableLayoutPanel2.Name     = "tableLayoutPanel2";
     this.tableLayoutPanel2.RowCount = 1;
     this.tableLayoutPanel2.RowStyles.Add(new System.Windows.Forms.RowStyle());
     this.tableLayoutPanel2.Size     = new System.Drawing.Size(792, 32);
     this.tableLayoutPanel2.TabIndex = 37;
     //
     // stcItemDesc
     //
     this.stcItemDesc.AppearanceName = "";
     this.stcItemDesc.ControlID      = "";
     this.stcItemDesc.Dock           = System.Windows.Forms.DockStyle.Top;
     this.stcItemDesc.Location       = new System.Drawing.Point(306, 3);
     this.stcItemDesc.Margin         = new System.Windows.Forms.Padding(3);
     this.stcItemDesc.Name           = "stcItemDesc";
     this.stcItemDesc.PathString     = null;
     this.stcItemDesc.PathValue      = "Part Name";
     this.stcItemDesc.Size           = new System.Drawing.Size(100, 21);
     this.stcItemDesc.TabIndex       = 14;
     this.stcItemDesc.Text           = "Part Name";
     //
     // stcItemCD
     //
     this.stcItemCD.AppearanceName = "";
     this.stcItemCD.ControlID      = "";
     this.stcItemCD.Dock           = System.Windows.Forms.DockStyle.Top;
     this.stcItemCD.Location       = new System.Drawing.Point(23, 3);
     this.stcItemCD.Margin         = new System.Windows.Forms.Padding(3);
     this.stcItemCD.Name           = "stcItemCD";
     this.stcItemCD.PathString     = null;
     this.stcItemCD.PathValue      = "Part No";
     this.stcItemCD.Size           = new System.Drawing.Size(82, 21);
     this.stcItemCD.TabIndex       = 11;
     this.stcItemCD.Text           = "Part No";
     //
     // label4
     //
     this.label4.AppearanceName = "RequireText";
     this.label4.AutoSize       = true;
     this.label4.ControlID      = "";
     this.label4.Dock           = System.Windows.Forms.DockStyle.Right;
     this.label4.Font           = new System.Drawing.Font("Microsoft Sans Serif", 14F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222)));
     this.label4.ForeColor      = System.Drawing.Color.Green;
     this.label4.Location       = new System.Drawing.Point(3, 0);
     this.label4.Name           = "label4";
     this.label4.PathString     = null;
     this.label4.PathValue      = "*";
     this.label4.Size           = new System.Drawing.Size(14, 32);
     this.label4.TabIndex       = 10;
     this.label4.Text           = "*";
     //
     // txtItemCD
     //
     this.txtItemCD.AllowNegative          = true;
     this.txtItemCD.AppearanceName         = "";
     this.txtItemCD.AppearanceReadOnlyName = "";
     this.txtItemCD.CharacterCasing        = System.Windows.Forms.CharacterCasing.Upper;
     this.txtItemCD.CheckEmpty             = true;
     this.txtItemCD.CheckExist             = false;
     this.txtItemCD.CheckNotExist          = true;
     this.txtItemCD.ControlID           = "";
     this.txtItemCD.CustomerCode        = null;
     this.txtItemCD.CustomerNameTextBox = null;
     this.txtItemCD.Decimal             = new decimal(new int[] {
         0,
         0,
         0,
         0
     });
     this.txtItemCD.DecimalPoint       = '.';
     this.txtItemCD.DescriptionTextBox = this.txtItemDesc;
     this.txtItemCD.DigitsInGroup      = 0;
     this.txtItemCD.Dock               = System.Windows.Forms.DockStyle.Top;
     this.txtItemCD.Double             = 0D;
     this.txtItemCD.FixDecimalPosition = true;
     this.txtItemCD.Flags              = 0;
     this.txtItemCD.Font               = new System.Drawing.Font("Microsoft Sans Serif", 12F);
     this.txtItemCD.GroupSeparator     = ',';
     this.txtItemCD.HelpButton         = this.btnItemCD;
     this.txtItemCD.Int                     = 0;
     this.txtItemCD.ItemType                = null;
     this.txtItemCD.Location                = new System.Drawing.Point(111, 3);
     this.txtItemCD.Long                    = ((long)(0));
     this.txtItemCD.MaxDecimalPlaces        = 0;
     this.txtItemCD.MaxLength               = 50;
     this.txtItemCD.MaxWholeDigits          = 10;
     this.txtItemCD.Name                    = "txtItemCD";
     this.txtItemCD.NegativeSign            = '-';
     this.txtItemCD.PathString              = null;
     this.txtItemCD.PathValue               = "";
     this.txtItemCD.Prefix                  = "";
     this.txtItemCD.RangeMax                = 9999999999D;
     this.txtItemCD.RangeMin                = 0D;
     this.txtItemCD.SelectedCustomerData    = null;
     this.txtItemCD.SelectedItemData        = null;
     this.txtItemCD.SelectedItemProcessData = null;
     this.txtItemCD.Size                    = new System.Drawing.Size(157, 26);
     this.txtItemCD.SqlOperator             = Rubik.eSqlOperator.In;
     this.txtItemCD.TabIndex                = 12;
     this.txtItemCD.TextAlign               = System.Windows.Forms.HorizontalAlignment.Right;
     this.txtItemCD.KeyPressResult         += new Rubik.Forms.UserControl.ItemFoundHandler(this.txtItem_KeyPressResult);
     //
     // txtItemDesc
     //
     this.txtItemDesc.AppearanceName         = "";
     this.txtItemDesc.AppearanceReadOnlyName = "";
     this.txtItemDesc.ControlID           = "";
     this.txtItemDesc.DisableRestrictChar = false;
     this.txtItemDesc.Dock       = System.Windows.Forms.DockStyle.Top;
     this.txtItemDesc.Font       = new System.Drawing.Font("Microsoft Sans Serif", 12F);
     this.txtItemDesc.HelpButton = null;
     this.txtItemDesc.Location   = new System.Drawing.Point(412, 3);
     this.txtItemDesc.MaxLength  = 100;
     this.txtItemDesc.Name       = "txtItemDesc";
     this.txtItemDesc.PathString = null;
     this.txtItemDesc.PathValue  = "";
     this.txtItemDesc.Size       = new System.Drawing.Size(377, 26);
     this.txtItemDesc.TabIndex   = 15;
     //
     // btnItemCD
     //
     this.btnItemCD.AppearanceName        = "";
     this.btnItemCD.AutoSize              = true;
     this.btnItemCD.BackgroundImage       = global::Rubik.Forms.Properties.Resources.VIEW;
     this.btnItemCD.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch;
     this.btnItemCD.ControlID             = null;
     this.btnItemCD.Dock     = System.Windows.Forms.DockStyle.Fill;
     this.btnItemCD.Location = new System.Drawing.Point(274, 3);
     this.btnItemCD.Name     = "btnItemCD";
     this.btnItemCD.Size     = new System.Drawing.Size(26, 26);
     this.btnItemCD.TabIndex = 13;
     this.btnItemCD.TabStop  = false;
     this.btnItemCD.UseVisualStyleBackColor = true;
     this.btnItemCD.Click += new System.EventHandler(this.btnItemCD_Click);
     //
     // panel1
     //
     this.panel1.Controls.Add(this.fpView);
     this.panel1.Controls.Add(this.panel2);
     this.panel1.Dock     = System.Windows.Forms.DockStyle.Fill;
     this.panel1.Location = new System.Drawing.Point(0, 78);
     this.panel1.Margin   = new System.Windows.Forms.Padding(0, 3, 3, 3);
     this.panel1.Name     = "panel1";
     this.panel1.Size     = new System.Drawing.Size(789, 380);
     this.panel1.TabIndex = 39;
     //
     // fpView
     //
     this.fpView.About = "2.5.2015.2005";
     this.fpView.AccessibleDescription = "fpView, Sheet1";
     this.fpView.BackColor             = System.Drawing.SystemColors.Control;
     this.fpView.BorderStyle           = System.Windows.Forms.BorderStyle.FixedSingle;
     this.fpView.ColumnSplitBoxPolicy  = FarPoint.Win.Spread.SplitBoxPolicy.Never;
     this.fpView.ContextMenuStrip      = this.ctxMenu;
     this.fpView.Dock = System.Windows.Forms.DockStyle.Fill;
     this.fpView.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
     this.fpView.Location             = new System.Drawing.Point(44, 0);
     this.fpView.Margin               = new System.Windows.Forms.Padding(5);
     this.fpView.Name                 = "fpView";
     this.fpView.RightToLeft          = System.Windows.Forms.RightToLeft.No;
     this.fpView.RowSplitBoxPolicy    = FarPoint.Win.Spread.SplitBoxPolicy.Never;
     this.fpView.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Both;
     this.fpView.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] {
         this.shtView
     });
     this.fpView.Size     = new System.Drawing.Size(745, 380);
     this.fpView.TabIndex = 40;
     this.fpView.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
     this.fpView.SelectionChanged       += new FarPoint.Win.Spread.SelectionChangedEventHandler(this.fpView_SelectionChanged);
     this.fpView.CellDoubleClick        += new FarPoint.Win.Spread.CellClickEventHandler(this.fpView_CellDoubleClick);
     this.fpView.Paint     += new System.Windows.Forms.PaintEventHandler(this.fpView_Paint);
     this.fpView.KeyDown   += new System.Windows.Forms.KeyEventHandler(this.fpView_KeyDown);
     this.fpView.MouseDown += new System.Windows.Forms.MouseEventHandler(this.fpView_MouseDown);
     //
     // ctxMenu
     //
     this.ctxMenu.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
         this.miAddChildItem,
         this.miEditItem,
         this.miDeleteItem,
         this.miDeleteTree
     });
     this.ctxMenu.Name     = "ctxMenu";
     this.ctxMenu.Size     = new System.Drawing.Size(145, 92);
     this.ctxMenu.Opening += new System.ComponentModel.CancelEventHandler(this.ctxMenu_Opening);
     //
     // miAddChildItem
     //
     this.miAddChildItem.Name   = "miAddChildItem";
     this.miAddChildItem.Size   = new System.Drawing.Size(144, 22);
     this.miAddChildItem.Text   = "Add Child Item";
     this.miAddChildItem.Click += new System.EventHandler(this.miAddChildItem_Click);
     //
     // miEditItem
     //
     this.miEditItem.Name   = "miEditItem";
     this.miEditItem.Size   = new System.Drawing.Size(144, 22);
     this.miEditItem.Text   = "Edit Item";
     this.miEditItem.Click += new System.EventHandler(this.miEditItem_Click);
     //
     // miDeleteItem
     //
     this.miDeleteItem.Name   = "miDeleteItem";
     this.miDeleteItem.Size   = new System.Drawing.Size(144, 22);
     this.miDeleteItem.Text   = "Delete Item";
     this.miDeleteItem.Click += new System.EventHandler(this.miDeleteItem_Click);
     //
     // miDeleteTree
     //
     this.miDeleteTree.Name   = "miDeleteTree";
     this.miDeleteTree.Size   = new System.Drawing.Size(144, 22);
     this.miDeleteTree.Text   = "Delete Tree";
     this.miDeleteTree.Click += new System.EventHandler(this.miDeleteTree_Click);
     //
     // shtView
     //
     this.shtView.Reset();
     this.shtView.SheetName = "Sheet1";
     // Formulas and custom names must be loaded with R1C1 reference style
     this.shtView.ReferenceStyle      = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
     this.shtView.ColumnCount         = 10;
     this.shtView.RowCount            = 0;
     this.shtView.AutoCalculation     = false;
     this.shtView.AutoGenerateColumns = false;
     this.shtView.ColumnHeader.Cells.Get(0, 0).Value = "Part No";
     this.shtView.ColumnHeader.Cells.Get(0, 1).Value = "Part Name";
     this.shtView.ColumnHeader.Cells.Get(0, 2).Value = "Part Class";
     this.shtView.ColumnHeader.Cells.Get(0, 3).Value = "Lot Control";
     this.shtView.ColumnHeader.Cells.Get(0, 4).Value = "Consumption";
     this.shtView.ColumnHeader.Cells.Get(0, 5).Value = "Seq";
     this.shtView.ColumnHeader.Cells.Get(0, 6).Value = "Parent Rate";
     this.shtView.ColumnHeader.Cells.Get(0, 7).Value = "Child Rate";
     this.shtView.ColumnHeader.Cells.Get(0, 8).Value = "Child Loc.";
     this.shtView.ColumnHeader.Cells.Get(0, 9).Value = "MRP Flag";
     this.shtView.ColumnHeader.Rows.Get(0).Height    = 40F;
     this.shtView.Columns.Get(0).CellType            = textCellType1;
     this.shtView.Columns.Get(0).Label    = "Part No";
     this.shtView.Columns.Get(0).Tag      = "Part No";
     this.shtView.Columns.Get(0).Width    = 240F;
     this.shtView.Columns.Get(1).CellType = textCellType2;
     this.shtView.Columns.Get(1).Label    = "Part Name";
     this.shtView.Columns.Get(1).Tag      = "Part Name";
     this.shtView.Columns.Get(1).Width    = 180F;
     this.shtView.Columns.Get(2).CellType = textCellType3;
     this.shtView.Columns.Get(2).Label    = "Part Class";
     this.shtView.Columns.Get(2).Tag      = "Part Class";
     this.shtView.Columns.Get(2).Width    = 120F;
     this.shtView.Columns.Get(3).CellType = checkBoxCellType1;
     this.shtView.Columns.Get(3).Label    = "Lot Control";
     this.shtView.Columns.Get(3).Tag      = "Lot Control";
     this.shtView.Columns.Get(3).Width    = 110F;
     this.shtView.Columns.Get(4).Label    = "Consumption";
     this.shtView.Columns.Get(4).Tag      = "Consumption";
     this.shtView.Columns.Get(4).Width    = 110F;
     numberCellType1.DecimalPlaces        = 0;
     this.shtView.Columns.Get(5).CellType = numberCellType1;
     this.shtView.Columns.Get(5).Label    = "Seq";
     this.shtView.Columns.Get(5).Tag      = "Seq";
     this.shtView.Columns.Get(5).Width    = 75F;
     currencyCellType1.DecimalPlaces      = 6;
     currencyCellType1.DecimalSeparator   = ".";
     currencyCellType1.FixedPoint         = false;
     currencyCellType1.MaximumValue       = new decimal(new int[] {
         1874919423,
         2328306,
         0,
         393216
     });
     currencyCellType1.MinimumValue = new decimal(new int[] {
         0,
         0,
         0,
         0
     });
     currencyCellType1.ShowCurrencySymbol = false;
     currencyCellType1.ShowSeparator      = true;
     this.shtView.Columns.Get(6).CellType = currencyCellType1;
     this.shtView.Columns.Get(6).Label    = "Parent Rate";
     this.shtView.Columns.Get(6).Tag      = "Parent Rate";
     this.shtView.Columns.Get(6).Width    = 75F;
     currencyCellType2.DecimalPlaces      = 6;
     currencyCellType2.DecimalSeparator   = ".";
     currencyCellType2.FixedPoint         = false;
     currencyCellType2.MaximumValue       = new decimal(new int[] {
         1874919423,
         2328306,
         0,
         393216
     });
     currencyCellType2.MinimumValue = new decimal(new int[] {
         0,
         0,
         0,
         0
     });
     currencyCellType2.ShowCurrencySymbol            = false;
     currencyCellType2.ShowSeparator                 = true;
     this.shtView.Columns.Get(7).CellType            = currencyCellType2;
     this.shtView.Columns.Get(7).Label               = "Child Rate";
     this.shtView.Columns.Get(7).Tag                 = "Child Rate";
     this.shtView.Columns.Get(7).Width               = 75F;
     this.shtView.Columns.Get(8).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left;
     this.shtView.Columns.Get(8).Label               = "Child Loc.";
     this.shtView.Columns.Get(8).Locked              = false;
     this.shtView.Columns.Get(8).Tag                 = "Child Loc.";
     this.shtView.Columns.Get(8).Width               = 120F;
     this.shtView.Columns.Get(9).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left;
     this.shtView.Columns.Get(9).Label               = "MRP Flag";
     this.shtView.Columns.Get(9).Tag                 = "MRP Flag";
     this.shtView.Columns.Get(9).Width               = 142F;
     this.shtView.DataAutoCellTypes   = false;
     this.shtView.DataAutoHeadings    = false;
     this.shtView.DataAutoSizeColumns = false;
     this.shtView.OperationMode       = FarPoint.Win.Spread.OperationMode.SingleSelect;
     this.shtView.RowHeader.Columns.Default.Resizable = true;
     this.shtView.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Single;
     this.shtView.SelectionUnit   = FarPoint.Win.Spread.Model.SelectionUnit.Row;
     this.shtView.ReferenceStyle  = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
     this.fpView.SetActiveViewport(0, 1, 0);
     //
     // panel2
     //
     this.panel2.BackColor = System.Drawing.Color.SkyBlue;
     this.panel2.Controls.Add(this.btnMoveUp);
     this.panel2.Controls.Add(this.btnMoveDown);
     this.panel2.Dock     = System.Windows.Forms.DockStyle.Left;
     this.panel2.Location = new System.Drawing.Point(0, 0);
     this.panel2.Margin   = new System.Windows.Forms.Padding(0, 3, 3, 3);
     this.panel2.Name     = "panel2";
     this.panel2.Size     = new System.Drawing.Size(44, 380);
     this.panel2.TabIndex = 43;
     //
     // btnMoveUp
     //
     this.btnMoveUp.Anchor                  = System.Windows.Forms.AnchorStyles.None;
     this.btnMoveUp.AppearanceName          = "";
     this.btnMoveUp.ControlID               = null;
     this.btnMoveUp.Image                   = global::Rubik.Forms.Properties.Resources.UP_BTN;
     this.btnMoveUp.Location                = new System.Drawing.Point(7, 137);
     this.btnMoveUp.Name                    = "btnMoveUp";
     this.btnMoveUp.Size                    = new System.Drawing.Size(31, 31);
     this.btnMoveUp.TabIndex                = 41;
     this.btnMoveUp.UseVisualStyleBackColor = true;
     this.btnMoveUp.Click                  += new System.EventHandler(this.btnMoveUp_Click);
     //
     // btnMoveDown
     //
     this.btnMoveDown.Anchor                  = System.Windows.Forms.AnchorStyles.None;
     this.btnMoveDown.AppearanceName          = "";
     this.btnMoveDown.ControlID               = null;
     this.btnMoveDown.Image                   = global::Rubik.Forms.Properties.Resources.DOWN_BTN;
     this.btnMoveDown.Location                = new System.Drawing.Point(7, 174);
     this.btnMoveDown.Name                    = "btnMoveDown";
     this.btnMoveDown.Size                    = new System.Drawing.Size(31, 31);
     this.btnMoveDown.TabIndex                = 42;
     this.btnMoveDown.UseVisualStyleBackColor = true;
     this.btnMoveDown.Click                  += new System.EventHandler(this.btnMoveDown_Click);
     //
     // imgListStateNode
     //
     this.imgListStateNode.ImageStream      = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imgListStateNode.ImageStream")));
     this.imgListStateNode.TransparentColor = System.Drawing.Color.Transparent;
     this.imgListStateNode.Images.SetKeyName(0, "BLANK");
     this.imgListStateNode.Images.SetKeyName(1, "PLUS");
     this.imgListStateNode.Images.SetKeyName(2, "MINUS");
     //
     // tslControl
     //
     this.tslControl.GripMargin = new System.Windows.Forms.Padding(0);
     this.tslControl.GripStyle  = System.Windows.Forms.ToolStripGripStyle.Hidden;
     this.tslControl.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
         this.tsbSave,
         this.tlsSeperator1,
         this.tsbCancel,
         this.tlsSeperator2
     });
     this.tslControl.Location = new System.Drawing.Point(0, 0);
     this.tslControl.Name     = "tslControl";
     this.tslControl.Padding  = new System.Windows.Forms.Padding(0);
     this.tslControl.Size     = new System.Drawing.Size(792, 28);
     this.tslControl.TabIndex = 2;
     this.tslControl.TabStop  = true;
     //
     // tsbSave
     //
     this.tsbSave.Image = global::Rubik.Forms.Properties.Resources.SAVE;
     this.tsbSave.ImageTransparentColor = System.Drawing.Color.Magenta;
     this.tsbSave.Margin      = new System.Windows.Forms.Padding(4, 2, 0, 2);
     this.tsbSave.Name        = "tsbSave";
     this.tsbSave.Padding     = new System.Windows.Forms.Padding(2);
     this.tsbSave.Size        = new System.Drawing.Size(55, 24);
     this.tsbSave.Text        = "Save";
     this.tsbSave.ToolTipText = "Save";
     this.tsbSave.Click      += new System.EventHandler(this.tsbSave_Click);
     //
     // tlsSeperator1
     //
     this.tlsSeperator1.Name = "tlsSeperator1";
     this.tlsSeperator1.Size = new System.Drawing.Size(6, 28);
     //
     // tsbCancel
     //
     this.tsbCancel.Image = global::Rubik.Forms.Properties.Resources.CANCEL_ICON;
     this.tsbCancel.ImageTransparentColor = System.Drawing.Color.Magenta;
     this.tsbCancel.Margin      = new System.Windows.Forms.Padding(4, 2, 0, 2);
     this.tsbCancel.Name        = "tsbCancel";
     this.tsbCancel.Padding     = new System.Windows.Forms.Padding(2);
     this.tsbCancel.Size        = new System.Drawing.Size(63, 24);
     this.tsbCancel.Text        = "Cancel";
     this.tsbCancel.ToolTipText = "Cancel";
     this.tsbCancel.Click      += new System.EventHandler(this.tsbCancel_Click);
     //
     // tlsSeperator2
     //
     this.tlsSeperator2.Name = "tlsSeperator2";
     this.tlsSeperator2.Size = new System.Drawing.Size(6, 28);
     //
     // MAS050_BOMSetup
     //
     this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
     this.AutoScaleMode       = System.Windows.Forms.AutoScaleMode.Font;
     this.ClientSize          = new System.Drawing.Size(792, 489);
     this.Controls.Add(this.pnlContainerNew);
     this.Controls.Add(this.tslControl);
     this.Icon        = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
     this.MinimumSize = new System.Drawing.Size(690, 523);
     this.Name        = "MAS050_BOMSetup";
     this.Text        = "BOM Setup";
     this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
     this.Load       += new System.EventHandler(this.MAS050_BOMSetup_Load);
     this.Shown      += new System.EventHandler(this.MAS050_BOMSetup_Shown);
     this.pnlContainerNew.ResumeLayout(false);
     this.tableLayoutPanel1.ResumeLayout(false);
     this.tableLayoutPanel1.PerformLayout();
     this.tlpHeader2.ResumeLayout(false);
     this.tlpHeader2.PerformLayout();
     this.tableLayoutPanel2.ResumeLayout(false);
     this.tableLayoutPanel2.PerformLayout();
     this.panel1.ResumeLayout(false);
     ((System.ComponentModel.ISupportInitialize)(this.fpView)).EndInit();
     this.ctxMenu.ResumeLayout(false);
     ((System.ComponentModel.ISupportInitialize)(this.shtView)).EndInit();
     this.panel2.ResumeLayout(false);
     this.tslControl.ResumeLayout(false);
     this.tslControl.PerformLayout();
     this.ResumeLayout(false);
     this.PerformLayout();
 }
コード例 #5
0
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     this.components = new System.ComponentModel.Container();
     System.ComponentModel.ComponentResourceManager resources         = new System.ComponentModel.ComponentResourceManager(typeof(TRN270_ReturnProductEntry));
     FarPoint.Win.Spread.CellType.TextCellType      textCellType1     = new FarPoint.Win.Spread.CellType.TextCellType();
     FarPoint.Win.Spread.CellType.CurrencyCellType  currencyCellType1 = new FarPoint.Win.Spread.CellType.CurrencyCellType();
     this.stcHead              = new EVOFramework.Windows.Forms.EVOLabel();
     this.tlpHeader2           = new System.Windows.Forms.TableLayoutPanel();
     this.stcReceiveInfo       = new EVOFramework.Windows.Forms.EVOLabel();
     this.stcReqStoreLoc       = new EVOFramework.Windows.Forms.EVOLabel();
     this.stcRemark            = new EVOFramework.Windows.Forms.EVOLabel();
     this.tableReceiveListInfo = new System.Windows.Forms.TableLayoutPanel();
     this.stcReceiveListInfo   = new EVOFramework.Windows.Forms.EVOLabel();
     this.fpReturnProductList  = new FarPoint.Win.Spread.FpSpread();
     this.ctxMenu              = new System.Windows.Forms.ContextMenuStrip(this.components);
     this.miAdd                = new System.Windows.Forms.ToolStripMenuItem();
     this.miDelete             = new System.Windows.Forms.ToolStripMenuItem();
     this.shtReturnProductList = new FarPoint.Win.Spread.SheetView();
     this.txtRemark            = new EVOFramework.Windows.Forms.EVOTextBox();
     this.stcReceiveNo         = new EVOFramework.Windows.Forms.EVOLabel();
     this.stdReceiveDate       = new EVOFramework.Windows.Forms.EVOLabel();
     this.lblReturnNo          = new EVOFramework.Windows.Forms.EVOLabel();
     this.dtReturnDate         = new EVOFramework.Windows.Forms.EVODateTextBoxWithCalendar();
     this.stcReqReceiveDate    = new EVOFramework.Windows.Forms.EVOLabel();
     this.stcStoredLoc         = new EVOFramework.Windows.Forms.EVOLabel();
     this.cboReturnLoc         = new EVOFramework.Windows.Forms.EVOComboBox();
     this.lbCustomerCode       = new EVOFramework.Windows.Forms.EVOLabel();
     this.cboCustomerCode      = new EVOFramework.Windows.Forms.EVOComboBox();
     this.stcReqSupplier       = new EVOFramework.Windows.Forms.EVOLabel();
     this.dmcReturn            = new EVOFramework.Data.UIDataModelController(this.components);
     this.btnAddReturn         = new EVOFramework.Windows.Forms.EVOButton();
     this.pnlContainer.SuspendLayout();
     this.tlpHeader2.SuspendLayout();
     this.tableReceiveListInfo.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.fpReturnProductList)).BeginInit();
     this.ctxMenu.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.shtReturnProductList)).BeginInit();
     this.SuspendLayout();
     //
     // pnlContainer
     //
     this.pnlContainer.Controls.Add(this.btnAddReturn);
     this.pnlContainer.Controls.Add(this.tableReceiveListInfo);
     this.pnlContainer.Controls.Add(this.lblReturnNo);
     this.pnlContainer.Controls.Add(this.stdReceiveDate);
     this.pnlContainer.Controls.Add(this.dtReturnDate);
     this.pnlContainer.Controls.Add(this.stcReceiveNo);
     this.pnlContainer.Controls.Add(this.stcReqReceiveDate);
     this.pnlContainer.Controls.Add(this.tlpHeader2);
     this.pnlContainer.Controls.Add(this.fpReturnProductList);
     this.pnlContainer.Controls.Add(this.stcRemark);
     this.pnlContainer.Controls.Add(this.stcHead);
     this.pnlContainer.Controls.Add(this.stcReqStoreLoc);
     this.pnlContainer.Controls.Add(this.txtRemark);
     this.pnlContainer.Controls.Add(this.cboCustomerCode);
     this.pnlContainer.Controls.Add(this.stcReqSupplier);
     this.pnlContainer.Controls.Add(this.stcStoredLoc);
     this.pnlContainer.Controls.Add(this.cboReturnLoc);
     this.pnlContainer.Controls.Add(this.lbCustomerCode);
     this.pnlContainer.Font      = new System.Drawing.Font("Tahoma", 12F);
     this.pnlContainer.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))));
     this.pnlContainer.Size      = new System.Drawing.Size(898, 587);
     //
     // stcHead
     //
     this.stcHead.AppearanceName = "Title";
     this.stcHead.AutoSize       = true;
     this.stcHead.ControlID      = "";
     this.stcHead.Font           = new System.Drawing.Font("Tahoma", 24F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))), System.Drawing.GraphicsUnit.Point, ((byte)(222)));
     this.stcHead.ForeColor      = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(192)))));
     this.stcHead.Location       = new System.Drawing.Point(13, 12);
     this.stcHead.Margin         = new System.Windows.Forms.Padding(0, 0, 3, 0);
     this.stcHead.Name           = "stcHead";
     this.stcHead.PathString     = null;
     this.stcHead.PathValue      = "Return Product Entry";
     this.stcHead.Size           = new System.Drawing.Size(354, 39);
     this.stcHead.TabIndex       = 36;
     this.stcHead.Text           = "Return Product Entry";
     //
     // tlpHeader2
     //
     this.tlpHeader2.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
                                                                    | System.Windows.Forms.AnchorStyles.Right)));
     this.tlpHeader2.AutoSize        = true;
     this.tlpHeader2.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("tlpHeader2.BackgroundImage")));
     this.tlpHeader2.ColumnCount     = 1;
     this.tlpHeader2.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle());
     this.tlpHeader2.Controls.Add(this.stcReceiveInfo, 0, 0);
     this.tlpHeader2.Location = new System.Drawing.Point(14, 75);
     this.tlpHeader2.Margin   = new System.Windows.Forms.Padding(0);
     this.tlpHeader2.Name     = "tlpHeader2";
     this.tlpHeader2.RowCount = 1;
     this.tlpHeader2.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 100F));
     this.tlpHeader2.Size     = new System.Drawing.Size(872, 24);
     this.tlpHeader2.TabIndex = 9;
     //
     // stcReceiveInfo
     //
     this.stcReceiveInfo.AppearanceName = "Header";
     this.stcReceiveInfo.AutoSize       = true;
     this.stcReceiveInfo.ControlID      = "";
     this.stcReceiveInfo.Font           = new System.Drawing.Font("Microsoft Sans Serif", 14.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222)));
     this.stcReceiveInfo.ForeColor      = System.Drawing.Color.Navy;
     this.stcReceiveInfo.Location       = new System.Drawing.Point(0, 0);
     this.stcReceiveInfo.Margin         = new System.Windows.Forms.Padding(0, 0, 3, 0);
     this.stcReceiveInfo.Name           = "stcReceiveInfo";
     this.stcReceiveInfo.PathString     = null;
     this.stcReceiveInfo.PathValue      = "Return Product Information";
     this.stcReceiveInfo.Size           = new System.Drawing.Size(233, 24);
     this.stcReceiveInfo.TabIndex       = 0;
     this.stcReceiveInfo.Text           = "Return Product Information";
     //
     // stcReqStoreLoc
     //
     this.stcReqStoreLoc.AppearanceName = "RequireText";
     this.stcReqStoreLoc.AutoSize       = true;
     this.stcReqStoreLoc.ControlID      = "";
     this.stcReqStoreLoc.Location       = new System.Drawing.Point(19, 149);
     this.stcReqStoreLoc.Name           = "stcReqStoreLoc";
     this.stcReqStoreLoc.PathString     = null;
     this.stcReqStoreLoc.PathValue      = "*";
     this.stcReqStoreLoc.Size           = new System.Drawing.Size(18, 19);
     this.stcReqStoreLoc.TabIndex       = 3;
     this.stcReqStoreLoc.Text           = "*";
     this.stcReqStoreLoc.TextAlign      = System.Drawing.ContentAlignment.MiddleLeft;
     //
     // stcRemark
     //
     this.stcRemark.AppearanceName = "";
     this.stcRemark.AutoSize       = true;
     this.stcRemark.ControlID      = "";
     this.stcRemark.Location       = new System.Drawing.Point(49, 182);
     this.stcRemark.Name           = "stcRemark";
     this.stcRemark.PathString     = null;
     this.stcRemark.PathValue      = "Remark";
     this.stcRemark.Size           = new System.Drawing.Size(63, 19);
     this.stcRemark.TabIndex       = 8;
     this.stcRemark.Text           = "Remark";
     this.stcRemark.TextAlign      = System.Drawing.ContentAlignment.MiddleLeft;
     //
     // tableReceiveListInfo
     //
     this.tableReceiveListInfo.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
                                                                              | System.Windows.Forms.AnchorStyles.Right)));
     this.tableReceiveListInfo.AutoSize        = true;
     this.tableReceiveListInfo.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("tableReceiveListInfo.BackgroundImage")));
     this.tableReceiveListInfo.ColumnCount     = 1;
     this.tableReceiveListInfo.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle());
     this.tableReceiveListInfo.Controls.Add(this.stcReceiveListInfo, 0, 0);
     this.tableReceiveListInfo.Location = new System.Drawing.Point(20, 259);
     this.tableReceiveListInfo.Margin   = new System.Windows.Forms.Padding(0);
     this.tableReceiveListInfo.Name     = "tableReceiveListInfo";
     this.tableReceiveListInfo.RowCount = 1;
     this.tableReceiveListInfo.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 100F));
     this.tableReceiveListInfo.Size     = new System.Drawing.Size(866, 24);
     this.tableReceiveListInfo.TabIndex = 9;
     //
     // stcReceiveListInfo
     //
     this.stcReceiveListInfo.AppearanceName = "Header";
     this.stcReceiveListInfo.AutoSize       = true;
     this.stcReceiveListInfo.ControlID      = "";
     this.stcReceiveListInfo.Font           = new System.Drawing.Font("Microsoft Sans Serif", 14.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222)));
     this.stcReceiveListInfo.ForeColor      = System.Drawing.Color.Navy;
     this.stcReceiveListInfo.Location       = new System.Drawing.Point(0, 0);
     this.stcReceiveListInfo.Margin         = new System.Windows.Forms.Padding(0, 0, 3, 0);
     this.stcReceiveListInfo.Name           = "stcReceiveListInfo";
     this.stcReceiveListInfo.PathString     = null;
     this.stcReceiveListInfo.PathValue      = "Return Product List Information";
     this.stcReceiveListInfo.Size           = new System.Drawing.Size(265, 24);
     this.stcReceiveListInfo.TabIndex       = 0;
     this.stcReceiveListInfo.Text           = "Return Product List Information";
     //
     // fpReturnProductList
     //
     this.fpReturnProductList.About = "2.5.2015.2005";
     this.fpReturnProductList.AccessibleDescription = "fpReturnProductList, Sheet1";
     this.fpReturnProductList.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
                                                                              | System.Windows.Forms.AnchorStyles.Left)
                                                                             | System.Windows.Forms.AnchorStyles.Right)));
     this.fpReturnProductList.BackColor                 = System.Drawing.Color.AliceBlue;
     this.fpReturnProductList.ContextMenuStrip          = this.ctxMenu;
     this.fpReturnProductList.EditModeReplace           = true;
     this.fpReturnProductList.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
     this.fpReturnProductList.Location             = new System.Drawing.Point(16, 286);
     this.fpReturnProductList.Name                 = "fpReturnProductList";
     this.fpReturnProductList.RightToLeft          = System.Windows.Forms.RightToLeft.No;
     this.fpReturnProductList.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Both;
     this.fpReturnProductList.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] {
         this.shtReturnProductList
     });
     this.fpReturnProductList.Size     = new System.Drawing.Size(870, 289);
     this.fpReturnProductList.TabIndex = 5;
     this.fpReturnProductList.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
     this.fpReturnProductList.EditModeOn  += new System.EventHandler(this.fpView_EditModeOn);
     this.fpReturnProductList.EditModeOff += new System.EventHandler(this.fpView_EditModeOff);
     this.fpReturnProductList.LeaveCell   += new FarPoint.Win.Spread.LeaveCellEventHandler(this.fpView_LeaveCell);
     this.fpReturnProductList.KeyDown     += new System.Windows.Forms.KeyEventHandler(this.fpReturnProductList_KeyDown);
     //
     // ctxMenu
     //
     this.ctxMenu.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
         this.miAdd,
         this.miDelete
     });
     this.ctxMenu.Name = "ctxMenu";
     this.ctxMenu.Size = new System.Drawing.Size(106, 48);
     //
     // miAdd
     //
     this.miAdd.Name   = "miAdd";
     this.miAdd.Size   = new System.Drawing.Size(105, 22);
     this.miAdd.Text   = "Add";
     this.miAdd.Click += new System.EventHandler(this.miAdd_Click);
     //
     // miDelete
     //
     this.miDelete.Name   = "miDelete";
     this.miDelete.Size   = new System.Drawing.Size(105, 22);
     this.miDelete.Text   = "Delete";
     this.miDelete.Click += new System.EventHandler(this.miDelete_Click);
     //
     // shtReturnProductList
     //
     this.shtReturnProductList.Reset();
     this.shtReturnProductList.SheetName = "Sheet1";
     // Formulas and custom names must be loaded with R1C1 reference style
     this.shtReturnProductList.ReferenceStyle        = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
     this.shtReturnProductList.ColumnCount           = 17;
     this.shtReturnProductList.RowCount              = 0;
     this.shtReturnProductList.AutoCalculation       = false;
     this.shtReturnProductList.AutoGenerateColumns   = false;
     this.shtReturnProductList.ColumnHeader.AutoText = FarPoint.Win.Spread.HeaderAutoText.Blank;
     this.shtReturnProductList.ColumnHeader.Cells.Get(0, 0).Value  = "PO No.";
     this.shtReturnProductList.ColumnHeader.Cells.Get(0, 1).Value  = "Slip No.";
     this.shtReturnProductList.ColumnHeader.Cells.Get(0, 2).Value  = "Trans ID.";
     this.shtReturnProductList.ColumnHeader.Cells.Get(0, 3).Value  = "Trans Group ID.";
     this.shtReturnProductList.ColumnHeader.Cells.Get(0, 4).Value  = "Ref No";
     this.shtReturnProductList.ColumnHeader.Cells.Get(0, 5).Value  = "Order No.";
     this.shtReturnProductList.ColumnHeader.Cells.Get(0, 6).Value  = "Order Detail No.";
     this.shtReturnProductList.ColumnHeader.Cells.Get(0, 7).Value  = "M/N";
     this.shtReturnProductList.ColumnHeader.Cells.Get(0, 8).Value  = "Part No.";
     this.shtReturnProductList.ColumnHeader.Cells.Get(0, 9).Value  = "Delivery Date";
     this.shtReturnProductList.ColumnHeader.Cells.Get(0, 10).Value = "Pack No.";
     this.shtReturnProductList.ColumnHeader.Cells.Get(0, 11).Value = "FG No.";
     this.shtReturnProductList.ColumnHeader.Cells.Get(0, 12).Value = "Lot No.";
     this.shtReturnProductList.ColumnHeader.Cells.Get(0, 13).Value = "Customer Lot No.";
     this.shtReturnProductList.ColumnHeader.Cells.Get(0, 14).Value = "Delivery Qty";
     this.shtReturnProductList.ColumnHeader.Cells.Get(0, 15).Value = "Returnable Qty";
     this.shtReturnProductList.ColumnHeader.Cells.Get(0, 16).Value = "Return Qty";
     this.shtReturnProductList.ColumnHeader.Rows.Get(0).Height     = 40F;
     textCellType1.CharacterCasing = System.Windows.Forms.CharacterCasing.Upper;
     this.shtReturnProductList.Columns.Get(0).CellType             = textCellType1;
     this.shtReturnProductList.Columns.Get(0).Label                = "PO No.";
     this.shtReturnProductList.Columns.Get(0).Locked               = true;
     this.shtReturnProductList.Columns.Get(0).Tag                  = "PO No.";
     this.shtReturnProductList.Columns.Get(0).Width                = 100F;
     this.shtReturnProductList.Columns.Get(1).Label                = "Slip No.";
     this.shtReturnProductList.Columns.Get(1).Visible              = false;
     this.shtReturnProductList.Columns.Get(1).Width                = 100F;
     this.shtReturnProductList.Columns.Get(2).Label                = "Trans ID.";
     this.shtReturnProductList.Columns.Get(2).Visible              = false;
     this.shtReturnProductList.Columns.Get(2).Width                = 100F;
     this.shtReturnProductList.Columns.Get(3).Label                = "Trans Group ID.";
     this.shtReturnProductList.Columns.Get(3).Visible              = false;
     this.shtReturnProductList.Columns.Get(3).Width                = 150F;
     this.shtReturnProductList.Columns.Get(4).Label                = "Ref No";
     this.shtReturnProductList.Columns.Get(4).Visible              = false;
     this.shtReturnProductList.Columns.Get(4).Width                = 100F;
     this.shtReturnProductList.Columns.Get(5).Label                = "Order No.";
     this.shtReturnProductList.Columns.Get(5).Tag                  = "Order No.";
     this.shtReturnProductList.Columns.Get(5).Width                = 120F;
     this.shtReturnProductList.Columns.Get(6).Label                = "Order Detail No.";
     this.shtReturnProductList.Columns.Get(6).Visible              = false;
     this.shtReturnProductList.Columns.Get(6).Width                = 140F;
     this.shtReturnProductList.Columns.Get(7).Label                = "M/N";
     this.shtReturnProductList.Columns.Get(7).Tag                  = "Master No.";
     this.shtReturnProductList.Columns.Get(7).Width                = 120F;
     this.shtReturnProductList.Columns.Get(8).Label                = "Part No.";
     this.shtReturnProductList.Columns.Get(8).Tag                  = "Part No";
     this.shtReturnProductList.Columns.Get(8).Width                = 120F;
     this.shtReturnProductList.Columns.Get(9).Label                = "Delivery Date";
     this.shtReturnProductList.Columns.Get(9).Tag                  = "Delivery Date";
     this.shtReturnProductList.Columns.Get(9).Width                = 150F;
     this.shtReturnProductList.Columns.Get(10).Label               = "Pack No.";
     this.shtReturnProductList.Columns.Get(10).Locked              = false;
     this.shtReturnProductList.Columns.Get(10).Tag                 = "Pack No.";
     this.shtReturnProductList.Columns.Get(10).Visible             = false;
     this.shtReturnProductList.Columns.Get(10).Width               = 110F;
     this.shtReturnProductList.Columns.Get(11).Label               = "FG No.";
     this.shtReturnProductList.Columns.Get(11).Tag                 = "FG No.";
     this.shtReturnProductList.Columns.Get(11).Visible             = false;
     this.shtReturnProductList.Columns.Get(11).Width               = 104F;
     this.shtReturnProductList.Columns.Get(12).Label               = "Lot No.";
     this.shtReturnProductList.Columns.Get(12).Tag                 = "Lot No.";
     this.shtReturnProductList.Columns.Get(12).Width               = 97F;
     this.shtReturnProductList.Columns.Get(13).Label               = "Customer Lot No.";
     this.shtReturnProductList.Columns.Get(13).Tag                 = "Customer Lot No.";
     this.shtReturnProductList.Columns.Get(13).Width               = 120F;
     this.shtReturnProductList.Columns.Get(14).Label               = "Delivery Qty";
     this.shtReturnProductList.Columns.Get(14).Tag                 = "Delivery Qty";
     this.shtReturnProductList.Columns.Get(14).Width               = 97F;
     this.shtReturnProductList.Columns.Get(15).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.General;
     this.shtReturnProductList.Columns.Get(15).Label               = "Returnable Qty";
     this.shtReturnProductList.Columns.Get(15).Tag                 = "Returnable Qty";
     this.shtReturnProductList.Columns.Get(15).Width               = 97F;
     currencyCellType1.DecimalPlaces    = 6;
     currencyCellType1.DecimalSeparator = ".";
     currencyCellType1.FixedPoint       = false;
     currencyCellType1.MaximumValue     = new decimal(new int[] {
         1874919423,
         2328306,
         0,
         393216
     });
     currencyCellType1.MinimumValue = new decimal(new int[] {
         0,
         0,
         0,
         0
     });
     currencyCellType1.Separator          = ",";
     currencyCellType1.ShowCurrencySymbol = false;
     currencyCellType1.ShowSeparator      = true;
     this.shtReturnProductList.Columns.Get(16).CellType            = currencyCellType1;
     this.shtReturnProductList.Columns.Get(16).Label               = "Return Qty";
     this.shtReturnProductList.Columns.Get(16).Locked              = false;
     this.shtReturnProductList.Columns.Get(16).Tag                 = "Return Qty";
     this.shtReturnProductList.Columns.Get(16).Width               = 97F;
     this.shtReturnProductList.DataAutoCellTypes                   = false;
     this.shtReturnProductList.DataAutoHeadings                    = false;
     this.shtReturnProductList.DataAutoSizeColumns                 = false;
     this.shtReturnProductList.DefaultStyle.ForeColor              = System.Drawing.Color.Blue;
     this.shtReturnProductList.DefaultStyle.Locked                 = true;
     this.shtReturnProductList.DefaultStyle.Parent                 = "DataAreaDefault";
     this.shtReturnProductList.LockForeColor                       = System.Drawing.Color.Black;
     this.shtReturnProductList.RowHeader.Columns.Default.Resizable = true;
     this.shtReturnProductList.SelectionPolicy                     = FarPoint.Win.Spread.Model.SelectionPolicy.Single;
     this.shtReturnProductList.ReferenceStyle                      = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
     this.fpReturnProductList.SetActiveViewport(0, 1, 0);
     //
     // txtRemark
     //
     this.txtRemark.AppearanceName         = "";
     this.txtRemark.AppearanceReadOnlyName = "";
     this.txtRemark.ControlID           = "";
     this.txtRemark.DisableRestrictChar = false;
     this.txtRemark.HelpButton          = null;
     this.txtRemark.Location            = new System.Drawing.Point(195, 178);
     this.txtRemark.MaxLength           = 255;
     this.txtRemark.Name       = "txtRemark";
     this.txtRemark.PathString = "REMARK.Value";
     this.txtRemark.PathValue  = "";
     this.txtRemark.Size       = new System.Drawing.Size(691, 27);
     this.txtRemark.TabIndex   = 3;
     this.txtRemark.KeyPress  += new System.Windows.Forms.KeyPressEventHandler(this.txtRemark_KeyPress);
     //
     // stcReceiveNo
     //
     this.stcReceiveNo.AppearanceName = "";
     this.stcReceiveNo.AutoSize       = true;
     this.stcReceiveNo.ControlID      = "";
     this.stcReceiveNo.Location       = new System.Drawing.Point(542, 16);
     this.stcReceiveNo.Name           = "stcReceiveNo";
     this.stcReceiveNo.PathString     = null;
     this.stcReceiveNo.PathValue      = "Transaction No.";
     this.stcReceiveNo.Size           = new System.Drawing.Size(121, 19);
     this.stcReceiveNo.TabIndex       = 0;
     this.stcReceiveNo.Text           = "Transaction No.";
     this.stcReceiveNo.TextAlign      = System.Drawing.ContentAlignment.MiddleLeft;
     //
     // stdReceiveDate
     //
     this.stdReceiveDate.AppearanceName = "";
     this.stdReceiveDate.AutoSize       = true;
     this.stdReceiveDate.ControlID      = "";
     this.stdReceiveDate.Location       = new System.Drawing.Point(544, 47);
     this.stdReceiveDate.Name           = "stdReceiveDate";
     this.stdReceiveDate.PathString     = null;
     this.stdReceiveDate.PathValue      = "Return Date";
     this.stdReceiveDate.Size           = new System.Drawing.Size(93, 19);
     this.stdReceiveDate.TabIndex       = 1;
     this.stdReceiveDate.Text           = "Return Date";
     this.stdReceiveDate.TextAlign      = System.Drawing.ContentAlignment.MiddleLeft;
     //
     // lblReturnNo
     //
     this.lblReturnNo.AppearanceName = "";
     this.lblReturnNo.ControlID      = "";
     this.lblReturnNo.Location       = new System.Drawing.Point(664, 13);
     this.lblReturnNo.Name           = "lblReturnNo";
     this.lblReturnNo.PathString     = "SLIP_NO.Value";
     this.lblReturnNo.PathValue      = "";
     this.lblReturnNo.Size           = new System.Drawing.Size(222, 25);
     this.lblReturnNo.TabIndex       = 0;
     //
     // dtReturnDate
     //
     this.dtReturnDate.AppearanceName         = "";
     this.dtReturnDate.AppearanceReadOnlyName = "";
     this.dtReturnDate.BackColor     = System.Drawing.Color.Transparent;
     this.dtReturnDate.ControlID     = "";
     this.dtReturnDate.Format        = "dd/MM/yyyy";
     this.dtReturnDate.Location      = new System.Drawing.Point(664, 43);
     this.dtReturnDate.MinimumSize   = new System.Drawing.Size(100, 0);
     this.dtReturnDate.Name          = "dtReturnDate";
     this.dtReturnDate.NZValue       = ((EVOFramework.NZDateTime)(resources.GetObject("dtReturnDate.NZValue")));
     this.dtReturnDate.PathString    = "TRANS_DATE.Value";
     this.dtReturnDate.PathValue     = ((object)(resources.GetObject("dtReturnDate.PathValue")));
     this.dtReturnDate.ReadOnly      = false;
     this.dtReturnDate.ShowButton    = true;
     this.dtReturnDate.Size          = new System.Drawing.Size(222, 20);
     this.dtReturnDate.TabIndex      = 0;
     this.dtReturnDate.Value         = null;
     this.dtReturnDate.ValueChanged += new System.EventHandler(this.dtReceiveDate_ValueChanged);
     //
     // stcReqReceiveDate
     //
     this.stcReqReceiveDate.AppearanceName = "RequireText";
     this.stcReqReceiveDate.AutoSize       = true;
     this.stcReqReceiveDate.ControlID      = "";
     this.stcReqReceiveDate.Location       = new System.Drawing.Point(521, 47);
     this.stcReqReceiveDate.Name           = "stcReqReceiveDate";
     this.stcReqReceiveDate.PathString     = null;
     this.stcReqReceiveDate.PathValue      = "*";
     this.stcReqReceiveDate.Size           = new System.Drawing.Size(18, 19);
     this.stcReqReceiveDate.TabIndex       = 3;
     this.stcReqReceiveDate.Text           = "*";
     //
     // stcStoredLoc
     //
     this.stcStoredLoc.AppearanceName = "";
     this.stcStoredLoc.ControlID      = "";
     this.stcStoredLoc.Location       = new System.Drawing.Point(49, 142);
     this.stcStoredLoc.Name           = "stcStoredLoc";
     this.stcStoredLoc.PathString     = null;
     this.stcStoredLoc.PathValue      = "Return Location";
     this.stcStoredLoc.Size           = new System.Drawing.Size(140, 33);
     this.stcStoredLoc.TabIndex       = 39;
     this.stcStoredLoc.Text           = "Return Location";
     this.stcStoredLoc.TextAlign      = System.Drawing.ContentAlignment.MiddleLeft;
     //
     // cboReturnLoc
     //
     this.cboReturnLoc.AppearanceName         = "";
     this.cboReturnLoc.AppearanceReadOnlyName = "";
     this.cboReturnLoc.BackColor         = System.Drawing.SystemColors.Control;
     this.cboReturnLoc.ControlID         = null;
     this.cboReturnLoc.DropDownHeight    = 180;
     this.cboReturnLoc.FormattingEnabled = true;
     this.cboReturnLoc.IntegralHeight    = false;
     this.cboReturnLoc.Location          = new System.Drawing.Point(195, 145);
     this.cboReturnLoc.Name       = "cboReturnLoc";
     this.cboReturnLoc.PathString = "LOC_CD.Value";
     this.cboReturnLoc.PathValue  = null;
     this.cboReturnLoc.ReadOnly   = true;
     this.cboReturnLoc.Size       = new System.Drawing.Size(691, 27);
     this.cboReturnLoc.TabIndex   = 2;
     //
     // lbCustomerCode
     //
     this.lbCustomerCode.AppearanceName = "";
     this.lbCustomerCode.ControlID      = "";
     this.lbCustomerCode.Location       = new System.Drawing.Point(49, 109);
     this.lbCustomerCode.Name           = "lbCustomerCode";
     this.lbCustomerCode.PathString     = null;
     this.lbCustomerCode.PathValue      = "Customer";
     this.lbCustomerCode.Size           = new System.Drawing.Size(140, 33);
     this.lbCustomerCode.TabIndex       = 6;
     this.lbCustomerCode.Text           = "Customer";
     this.lbCustomerCode.TextAlign      = System.Drawing.ContentAlignment.MiddleLeft;
     //
     // cboCustomerCode
     //
     this.cboCustomerCode.AppearanceName         = "";
     this.cboCustomerCode.AppearanceReadOnlyName = "";
     this.cboCustomerCode.ControlID         = null;
     this.cboCustomerCode.DropDownHeight    = 180;
     this.cboCustomerCode.FormattingEnabled = true;
     this.cboCustomerCode.IntegralHeight    = false;
     this.cboCustomerCode.Location          = new System.Drawing.Point(195, 112);
     this.cboCustomerCode.Name                  = "cboCustomerCode";
     this.cboCustomerCode.PathString            = "DEALING_NO.Value";
     this.cboCustomerCode.PathValue             = null;
     this.cboCustomerCode.Size                  = new System.Drawing.Size(691, 27);
     this.cboCustomerCode.TabIndex              = 1;
     this.cboCustomerCode.SelectedIndexChanged += new System.EventHandler(this.cboCustomerCode_SelectedIndexChanged);
     //
     // stcReqSupplier
     //
     this.stcReqSupplier.AppearanceName = "RequireText";
     this.stcReqSupplier.AutoSize       = true;
     this.stcReqSupplier.ControlID      = "";
     this.stcReqSupplier.Location       = new System.Drawing.Point(19, 116);
     this.stcReqSupplier.Name           = "stcReqSupplier";
     this.stcReqSupplier.PathString     = null;
     this.stcReqSupplier.PathValue      = "*";
     this.stcReqSupplier.Size           = new System.Drawing.Size(18, 19);
     this.stcReqSupplier.TabIndex       = 3;
     this.stcReqSupplier.Text           = "*";
     this.stcReqSupplier.TextAlign      = System.Drawing.ContentAlignment.MiddleLeft;
     //
     // btnAddReturn
     //
     this.btnAddReturn.AppearanceName          = "";
     this.btnAddReturn.ControlID               = null;
     this.btnAddReturn.Location                = new System.Drawing.Point(23, 216);
     this.btnAddReturn.Name                    = "btnAddReturn";
     this.btnAddReturn.Size                    = new System.Drawing.Size(126, 27);
     this.btnAddReturn.TabIndex                = 4;
     this.btnAddReturn.Text                    = "Add Return";
     this.btnAddReturn.UseVisualStyleBackColor = true;
     this.btnAddReturn.Click                  += new System.EventHandler(this.btnAddReturn_Click);
     //
     // TRN270_ReturnProductEntry
     //
     this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
     this.ClientSize          = new System.Drawing.Size(898, 637);
     this.Icon        = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
     this.MinimumSize = new System.Drawing.Size(600, 390);
     this.Name        = "TRN270_ReturnProductEntry";
     this.Text        = "Return Product Entry";
     this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
     this.FormClosed += new System.Windows.Forms.FormClosedEventHandler(this.TRN020_FormClosed);
     this.Load       += new System.EventHandler(this.TRN270_Load);
     this.Shown      += new System.EventHandler(this.TRN270_Shown);
     this.Controls.SetChildIndex(this.pnlContainer, 0);
     this.pnlContainer.ResumeLayout(false);
     this.pnlContainer.PerformLayout();
     this.tlpHeader2.ResumeLayout(false);
     this.tlpHeader2.PerformLayout();
     this.tableReceiveListInfo.ResumeLayout(false);
     this.tableReceiveListInfo.PerformLayout();
     ((System.ComponentModel.ISupportInitialize)(this.fpReturnProductList)).EndInit();
     this.ctxMenu.ResumeLayout(false);
     ((System.ComponentModel.ISupportInitialize)(this.shtReturnProductList)).EndInit();
     this.ResumeLayout(false);
     this.PerformLayout();
 }
コード例 #6
0
 /// <summary>
 /// デザイナー サポートに必要なメソッドです。このメソッドの内容を
 /// コード エディターで変更しないでください。
 /// </summary>
 private void InitializeComponent()
 {
     FarPoint.Win.Spread.CellType.ButtonCellType                        buttonCellType1       = new FarPoint.Win.Spread.CellType.ButtonCellType();
     FarPoint.Win.Spread.CellType.CheckBoxCellType                      checkBoxCellType1     = new FarPoint.Win.Spread.CellType.CheckBoxCellType();
     FarPoint.Win.Spread.CellType.ComboBoxCellType                      comboBoxCellType1     = new FarPoint.Win.Spread.CellType.ComboBoxCellType();
     FarPoint.Win.Spread.CellType.CurrencyCellType                      currencyCellType1     = new FarPoint.Win.Spread.CellType.CurrencyCellType();
     FarPoint.Win.Spread.CellType.DateTimeCellType                      dateTimeCellType1     = new FarPoint.Win.Spread.CellType.DateTimeCellType();
     System.ComponentModel.ComponentResourceManager                     resources             = new System.ComponentModel.ComponentResourceManager(typeof(MainForm));
     FarPoint.Win.Spread.CellType.EmptyCellType                         emptyCellType1        = new FarPoint.Win.Spread.CellType.EmptyCellType();
     FarPoint.Win.Spread.CellType.FilterBarCellType                     filterBarCellType1    = new FarPoint.Win.Spread.CellType.FilterBarCellType();
     GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType          gcDateTimeCellType1   = new GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType();
     GrapeCity.Win.Spread.InputMan.CellType.Fields.DateYearFieldInfo    dateYearFieldInfo1    = new GrapeCity.Win.Spread.InputMan.CellType.Fields.DateYearFieldInfo();
     GrapeCity.Win.Spread.InputMan.CellType.Fields.DateLiteralFieldInfo dateLiteralFieldInfo1 = new GrapeCity.Win.Spread.InputMan.CellType.Fields.DateLiteralFieldInfo();
     GrapeCity.Win.Spread.InputMan.CellType.Fields.DateMonthFieldInfo   dateMonthFieldInfo1   = new GrapeCity.Win.Spread.InputMan.CellType.Fields.DateMonthFieldInfo();
     GrapeCity.Win.Spread.InputMan.CellType.Fields.DateLiteralFieldInfo dateLiteralFieldInfo2 = new GrapeCity.Win.Spread.InputMan.CellType.Fields.DateLiteralFieldInfo();
     GrapeCity.Win.Spread.InputMan.CellType.Fields.DateDayFieldInfo     dateDayFieldInfo1     = new GrapeCity.Win.Spread.InputMan.CellType.Fields.DateDayFieldInfo();
     GrapeCity.Win.Spread.InputMan.CellType.Fields.DateLiteralFieldInfo dateLiteralFieldInfo3 = new GrapeCity.Win.Spread.InputMan.CellType.Fields.DateLiteralFieldInfo();
     GrapeCity.Win.Spread.InputMan.CellType.Fields.DateHourFieldInfo    dateHourFieldInfo1    = new GrapeCity.Win.Spread.InputMan.CellType.Fields.DateHourFieldInfo();
     GrapeCity.Win.Spread.InputMan.CellType.Fields.DateLiteralFieldInfo dateLiteralFieldInfo4 = new GrapeCity.Win.Spread.InputMan.CellType.Fields.DateLiteralFieldInfo();
     GrapeCity.Win.Spread.InputMan.CellType.Fields.DateMinuteFieldInfo  dateMinuteFieldInfo1  = new GrapeCity.Win.Spread.InputMan.CellType.Fields.DateMinuteFieldInfo();
     GrapeCity.Win.Spread.InputMan.CellType.Fields.DateLiteralFieldInfo dateLiteralFieldInfo5 = new GrapeCity.Win.Spread.InputMan.CellType.Fields.DateLiteralFieldInfo();
     GrapeCity.Win.Spread.InputMan.CellType.Fields.DateSecondFieldInfo  dateSecondFieldInfo1  = new GrapeCity.Win.Spread.InputMan.CellType.Fields.DateSecondFieldInfo();
     GrapeCity.Win.Spread.InputMan.CellType.DropDownButtonInfo          dropDownButtonInfo1   = new GrapeCity.Win.Spread.InputMan.CellType.DropDownButtonInfo();
     GrapeCity.Win.Spread.InputMan.CellType.GcTextBoxCellType           gcTextBoxCellType1    = new GrapeCity.Win.Spread.InputMan.CellType.GcTextBoxCellType();
     FarPoint.Win.Spread.CellType.GeneralCellType                       generalCellType1      = new FarPoint.Win.Spread.CellType.GeneralCellType();
     FarPoint.Win.Spread.CellType.HyperLinkCellType                     hyperLinkCellType1    = new FarPoint.Win.Spread.CellType.HyperLinkCellType();
     FarPoint.Win.Spread.CellType.ImageCellType                         imageCellType1        = new FarPoint.Win.Spread.CellType.ImageCellType();
     FarPoint.Win.Spread.CellType.ListBoxCellType                       listBoxCellType1      = new FarPoint.Win.Spread.CellType.ListBoxCellType();
     FarPoint.Win.Spread.CellType.MaskCellType maskCellType1 = new FarPoint.Win.Spread.CellType.MaskCellType();
     FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType multiColumnComboBoxCellType1 = new FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType();
     FarPoint.Win.Spread.CellType.MultiOptionCellType         multiOptionCellType1         = new FarPoint.Win.Spread.CellType.MultiOptionCellType();
     FarPoint.Win.Spread.CellType.NumberCellType            numberCellType1            = new FarPoint.Win.Spread.CellType.NumberCellType();
     FarPoint.Win.Spread.CellType.PercentCellType           percentCellType1           = new FarPoint.Win.Spread.CellType.PercentCellType();
     FarPoint.Win.Spread.CellType.ProgressCellType          progressCellType1          = new FarPoint.Win.Spread.CellType.ProgressCellType();
     FarPoint.Win.Spread.CellType.RegularExpressionCellType regularExpressionCellType1 = new FarPoint.Win.Spread.CellType.RegularExpressionCellType();
     FarPoint.Win.Spread.CellType.RichTextCellType          richTextCellType1          = new FarPoint.Win.Spread.CellType.RichTextCellType();
     FarPoint.Win.Spread.CellType.SliderCellType            sliderCellType1            = new FarPoint.Win.Spread.CellType.SliderCellType();
     FarPoint.Win.Spread.CellType.TextCellType textCellType1 = new FarPoint.Win.Spread.CellType.TextCellType();
     this._spread        = new FarPoint.Win.Spread.FpSpread();
     this._spread_Sheet1 = new FarPoint.Win.Spread.SheetView();
     this._spread_Sheet2 = new FarPoint.Win.Spread.SheetView();
     ((System.ComponentModel.ISupportInitialize)(this._spread)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this._spread_Sheet1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this._spread_Sheet2)).BeginInit();
     this.SuspendLayout();
     //
     // _spread
     //
     this._spread.AccessibleDescription = "_spread, Sheet2, Row 0, Column 16, ";
     this._spread.Dock     = System.Windows.Forms.DockStyle.Fill;
     this._spread.Location = new System.Drawing.Point(0, 0);
     this._spread.Name     = "_spread";
     this._spread.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] {
         this._spread_Sheet1,
         this._spread_Sheet2
     });
     this._spread.Size             = new System.Drawing.Size(1554, 261);
     this._spread.TabIndex         = 0;
     this._spread.ActiveSheetIndex = 1;
     //
     // _spread_Sheet1
     //
     this._spread_Sheet1.Reset();
     this._spread_Sheet1.SheetName = "Sheet1";
     //
     // _spread_Sheet2
     //
     this._spread_Sheet2.Reset();
     this._spread_Sheet2.SheetName = "Sheet2";
     // Formulas and custom names must be loaded with R1C1 reference style
     this._spread_Sheet2.ReferenceStyle           = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
     this._spread_Sheet2.ActiveColumnIndex        = 16;
     buttonCellType1.ButtonColor2                 = System.Drawing.SystemColors.ButtonFace;
     this._spread_Sheet2.Cells.Get(0, 1).CellType = buttonCellType1;
     this._spread_Sheet2.Cells.Get(0, 2).CellType = checkBoxCellType1;
     comboBoxCellType1.ButtonAlign                = FarPoint.Win.ButtonAlign.Right;
     this._spread_Sheet2.Cells.Get(0, 3).CellType = comboBoxCellType1;
     this._spread_Sheet2.Cells.Get(0, 4).CellType = currencyCellType1;
     dateTimeCellType1.Calendar = new System.Globalization.GregorianCalendar(System.Globalization.GregorianCalendarTypes.Localized);
     dateTimeCellType1.CalendarSurroundingDaysColor = System.Drawing.SystemColors.GrayText;
     dateTimeCellType1.MaximumTime = System.TimeSpan.Parse("23:59:59.9999999");
     dateTimeCellType1.TimeDefault = new System.DateTime(2015, 5, 9, 14, 30, 28, 566);
     this._spread_Sheet2.Cells.Get(0, 5).CellType = dateTimeCellType1;
     this._spread_Sheet2.Cells.Get(0, 6).CellType = emptyCellType1;
     filterBarCellType1.FormatString = "";
     this._spread_Sheet2.Cells.Get(0, 7).CellType    = filterBarCellType1;
     gcDateTimeCellType1.ClearCollection             = true;
     gcDateTimeCellType1.DropDownCalendar.TodayImage = ((System.Drawing.Image)(resources.GetObject("resource.TodayImage")));
     dateLiteralFieldInfo1.Text = "/";
     dateLiteralFieldInfo2.Text = "/";
     dateLiteralFieldInfo4.Text = ":";
     dateLiteralFieldInfo5.Text = ":";
     gcDateTimeCellType1.Fields.AddRange(new GrapeCity.Win.Spread.InputMan.CellType.Fields.DateFieldInfo[] {
         dateYearFieldInfo1,
         dateLiteralFieldInfo1,
         dateMonthFieldInfo1,
         dateLiteralFieldInfo2,
         dateDayFieldInfo1,
         dateLiteralFieldInfo3,
         dateHourFieldInfo1,
         dateLiteralFieldInfo4,
         dateMinuteFieldInfo1,
         dateLiteralFieldInfo5,
         dateSecondFieldInfo1
     });
     gcDateTimeCellType1.RecommendedValue = null;
     gcDateTimeCellType1.ShortcutKeys.AddRange(new GrapeCity.Win.Spread.InputMan.CellType.ShortcutDictionaryEntry[] {
         new GrapeCity.Win.Spread.InputMan.CellType.ShortcutDictionaryEntry(System.Windows.Forms.Keys.F2, "ShortcutClear"),
         new GrapeCity.Win.Spread.InputMan.CellType.ShortcutDictionaryEntry(System.Windows.Forms.Keys.F5, "SetNow"),
         new GrapeCity.Win.Spread.InputMan.CellType.ShortcutDictionaryEntry(((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.Return))), "ApplyRecommendedValue")
     });
     gcDateTimeCellType1.SideButtons.AddRange(new GrapeCity.Win.Spread.InputMan.CellType.SideButtonBaseInfo[] {
         dropDownButtonInfo1
     });
     this._spread_Sheet2.Cells.Get(0, 8).CellType = gcDateTimeCellType1;
     gcTextBoxCellType1.ClearCollection           = true;
     gcTextBoxCellType1.RecommendedValue          = null;
     gcTextBoxCellType1.ShortcutKeys.AddRange(new GrapeCity.Win.Spread.InputMan.CellType.ShortcutDictionaryEntry[] {
         new GrapeCity.Win.Spread.InputMan.CellType.ShortcutDictionaryEntry(System.Windows.Forms.Keys.F2, "ShortcutClear")
     });
     this._spread_Sheet2.Cells.Get(0, 9).CellType  = gcTextBoxCellType1;
     this._spread_Sheet2.Cells.Get(0, 10).CellType = generalCellType1;
     hyperLinkCellType1.Text = "http://www.codeer.co.jp/";
     this._spread_Sheet2.Cells.Get(0, 11).CellType = hyperLinkCellType1;
     imageCellType1.Style                          = FarPoint.Win.RenderStyle.Normal;
     imageCellType1.TransparencyColor              = System.Drawing.Color.Empty;
     imageCellType1.TransparencyTolerance          = 0;
     this._spread_Sheet2.Cells.Get(0, 12).CellType = imageCellType1;
     listBoxCellType1.Items                        = new string[] {
         "a",
         "b",
         "c",
         "d",
         "e"
     };
     this._spread_Sheet2.Cells.Get(0, 13).CellType = listBoxCellType1;
     maskCellType1.Mask = "9999";
     this._spread_Sheet2.Cells.Get(0, 14).CellType = maskCellType1;
     multiColumnComboBoxCellType1.ColumnEditName   = null;
     multiColumnComboBoxCellType1.DataColumnName   = null;
     this._spread_Sheet2.Cells.Get(0, 15).CellType = multiColumnComboBoxCellType1;
     multiOptionCellType1.Items = new string[] {
         "1",
         "2",
         "3",
         "4",
         "5",
         "6"
     };
     this._spread_Sheet2.Cells.Get(0, 16).CellType = multiOptionCellType1;
     this._spread_Sheet2.Cells.Get(0, 17).CellType = numberCellType1;
     this._spread_Sheet2.Cells.Get(0, 18).CellType = percentCellType1;
     this._spread_Sheet2.Cells.Get(0, 19).CellType = progressCellType1;
     regularExpressionCellType1.RegularExpression  = "^\\d*$";
     this._spread_Sheet2.Cells.Get(0, 20).CellType = regularExpressionCellType1;
     this._spread_Sheet2.Cells.Get(0, 21).CellType = richTextCellType1;
     sliderCellType1.TickColor = System.Drawing.Color.Black;
     this._spread_Sheet2.Cells.Get(0, 22).CellType = sliderCellType1;
     this._spread_Sheet2.Cells.Get(0, 23).CellType = textCellType1;
     this._spread_Sheet2.ReferenceStyle            = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
     //
     // MainForm
     //
     this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F);
     this.AutoScaleMode       = System.Windows.Forms.AutoScaleMode.Font;
     this.ClientSize          = new System.Drawing.Size(1554, 261);
     this.Controls.Add(this._spread);
     this.Name = "MainForm";
     this.Text = "Target";
     ((System.ComponentModel.ISupportInitialize)(this._spread)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this._spread_Sheet1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this._spread_Sheet2)).EndInit();
     this.ResumeLayout(false);
 }
コード例 #7
0
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     FarPoint.Win.Spread.CellType.DateTimeCellType  dateTimeCellType1 = new FarPoint.Win.Spread.CellType.DateTimeCellType();
     System.ComponentModel.ComponentResourceManager resources         = new System.ComponentModel.ComponentResourceManager(typeof(INV020_InventoryMovementInquiry));
     FarPoint.Win.Spread.CellType.TextCellType      textCellType1     = new FarPoint.Win.Spread.CellType.TextCellType();
     FarPoint.Win.Spread.CellType.TextCellType      textCellType2     = new FarPoint.Win.Spread.CellType.TextCellType();
     FarPoint.Win.Spread.CellType.CurrencyCellType  currencyCellType1 = new FarPoint.Win.Spread.CellType.CurrencyCellType();
     FarPoint.Win.Spread.CellType.CurrencyCellType  currencyCellType2 = new FarPoint.Win.Spread.CellType.CurrencyCellType();
     FarPoint.Win.Spread.CellType.CurrencyCellType  currencyCellType3 = new FarPoint.Win.Spread.CellType.CurrencyCellType();
     this.tableLayoutPanel1 = new System.Windows.Forms.TableLayoutPanel();
     this.txtInvPeriod      = new EVOFramework.Windows.Forms.EVOTextBox();
     this.stcInvPeriod      = new EVOFramework.Windows.Forms.EVOLabel();
     this.stcLotNo          = new EVOFramework.Windows.Forms.EVOLabel();
     this.stcItem           = new EVOFramework.Windows.Forms.EVOLabel();
     this.stcLocation       = new EVOFramework.Windows.Forms.EVOLabel();
     this.txtLocation       = new EVOFramework.Windows.Forms.EVOTextBox();
     this.txtItem           = new EVOFramework.Windows.Forms.EVOTextBox();
     this.txtLotNo          = new EVOFramework.Windows.Forms.EVOTextBox();
     this.lblHeader         = new EVOFramework.Windows.Forms.EVOLabel();
     this.stcOnHandQty      = new EVOFramework.Windows.Forms.EVOLabel();
     this.txtOnHandQty      = new EVOFramework.Windows.Forms.EVONumericTextBox();
     this.lblItemType       = new EVOFramework.Windows.Forms.EVOLabel();
     this.cboItemType       = new EVOFramework.Windows.Forms.EVOComboBox();
     this.stcUnitMeasure    = new EVOFramework.Windows.Forms.EVOLabel();
     this.txtUnitMeasure    = new EVOFramework.Windows.Forms.EVOTextBox();
     this.lblPackNo         = new EVOFramework.Windows.Forms.EVOLabel();
     this.txtPackNo         = new EVOFramework.Windows.Forms.EVOTextBox();
     this.fpView            = new FarPoint.Win.Spread.FpSpread();
     this.shtView           = new FarPoint.Win.Spread.SheetView();
     this.pnlContainer.SuspendLayout();
     this.tableLayoutPanel1.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.fpView)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.shtView)).BeginInit();
     this.SuspendLayout();
     //
     // pnlContainer
     //
     this.pnlContainer.BackColor = System.Drawing.Color.AliceBlue;
     this.pnlContainer.Controls.Add(this.fpView);
     this.pnlContainer.Controls.Add(this.tableLayoutPanel1);
     this.pnlContainer.Font      = new System.Drawing.Font("Tahoma", 12F);
     this.pnlContainer.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))));
     this.pnlContainer.Padding   = new System.Windows.Forms.Padding(3);
     this.pnlContainer.Size      = new System.Drawing.Size(892, 532);
     //
     // tableLayoutPanel1
     //
     this.tableLayoutPanel1.ColumnCount = 5;
     this.tableLayoutPanel1.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Absolute, 101F));
     this.tableLayoutPanel1.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 100F));
     this.tableLayoutPanel1.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Absolute, 9F));
     this.tableLayoutPanel1.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Absolute, 134F));
     this.tableLayoutPanel1.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Absolute, 215F));
     this.tableLayoutPanel1.Controls.Add(this.txtInvPeriod, 4, 1);
     this.tableLayoutPanel1.Controls.Add(this.stcInvPeriod, 3, 1);
     this.tableLayoutPanel1.Controls.Add(this.stcLotNo, 0, 4);
     this.tableLayoutPanel1.Controls.Add(this.stcItem, 0, 2);
     this.tableLayoutPanel1.Controls.Add(this.stcLocation, 0, 1);
     this.tableLayoutPanel1.Controls.Add(this.txtLocation, 1, 1);
     this.tableLayoutPanel1.Controls.Add(this.txtItem, 1, 2);
     this.tableLayoutPanel1.Controls.Add(this.txtLotNo, 1, 4);
     this.tableLayoutPanel1.Controls.Add(this.lblHeader, 0, 0);
     this.tableLayoutPanel1.Controls.Add(this.stcOnHandQty, 3, 2);
     this.tableLayoutPanel1.Controls.Add(this.txtOnHandQty, 4, 2);
     this.tableLayoutPanel1.Controls.Add(this.lblItemType, 0, 3);
     this.tableLayoutPanel1.Controls.Add(this.cboItemType, 1, 3);
     this.tableLayoutPanel1.Controls.Add(this.stcUnitMeasure, 3, 3);
     this.tableLayoutPanel1.Controls.Add(this.txtUnitMeasure, 4, 3);
     this.tableLayoutPanel1.Controls.Add(this.lblPackNo, 3, 4);
     this.tableLayoutPanel1.Controls.Add(this.txtPackNo, 4, 4);
     this.tableLayoutPanel1.Dock     = System.Windows.Forms.DockStyle.Top;
     this.tableLayoutPanel1.Location = new System.Drawing.Point(3, 3);
     this.tableLayoutPanel1.Name     = "tableLayoutPanel1";
     this.tableLayoutPanel1.Padding  = new System.Windows.Forms.Padding(3);
     this.tableLayoutPanel1.RowCount = 5;
     this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle());
     this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle());
     this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle());
     this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle());
     this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle());
     this.tableLayoutPanel1.Size     = new System.Drawing.Size(886, 186);
     this.tableLayoutPanel1.TabIndex = 0;
     //
     // txtInvPeriod
     //
     this.txtInvPeriod.AppearanceName         = "";
     this.txtInvPeriod.AppearanceReadOnlyName = "";
     this.txtInvPeriod.ControlID           = "";
     this.txtInvPeriod.DisableRestrictChar = false;
     this.txtInvPeriod.Dock       = System.Windows.Forms.DockStyle.Top;
     this.txtInvPeriod.Font       = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222)));
     this.txtInvPeriod.HelpButton = null;
     this.txtInvPeriod.Location   = new System.Drawing.Point(671, 51);
     this.txtInvPeriod.MaxLength  = 30;
     this.txtInvPeriod.Name       = "txtInvPeriod";
     this.txtInvPeriod.PathString = null;
     this.txtInvPeriod.PathValue  = "";
     this.txtInvPeriod.Size       = new System.Drawing.Size(209, 26);
     this.txtInvPeriod.TabIndex   = 4;
     //
     // stcInvPeriod
     //
     this.stcInvPeriod.AppearanceName = "";
     this.stcInvPeriod.ControlID      = "";
     this.stcInvPeriod.Dock           = System.Windows.Forms.DockStyle.Fill;
     this.stcInvPeriod.Font           = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222)));
     this.stcInvPeriod.Location       = new System.Drawing.Point(537, 48);
     this.stcInvPeriod.Name           = "stcInvPeriod";
     this.stcInvPeriod.PathString     = null;
     this.stcInvPeriod.PathValue      = "Inventory Period:";
     this.stcInvPeriod.Size           = new System.Drawing.Size(128, 32);
     this.stcInvPeriod.TabIndex       = 6;
     this.stcInvPeriod.Text           = "Inventory Period:";
     this.stcInvPeriod.TextAlign      = System.Drawing.ContentAlignment.MiddleLeft;
     //
     // stcLotNo
     //
     this.stcLotNo.AppearanceName = "";
     this.stcLotNo.ControlID      = "";
     this.stcLotNo.Dock           = System.Windows.Forms.DockStyle.Fill;
     this.stcLotNo.Font           = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222)));
     this.stcLotNo.Location       = new System.Drawing.Point(6, 145);
     this.stcLotNo.Name           = "stcLotNo";
     this.stcLotNo.PathString     = null;
     this.stcLotNo.PathValue      = "LOT No:";
     this.stcLotNo.Size           = new System.Drawing.Size(95, 38);
     this.stcLotNo.TabIndex       = 2;
     this.stcLotNo.Text           = "LOT No:";
     this.stcLotNo.TextAlign      = System.Drawing.ContentAlignment.MiddleLeft;
     //
     // stcItem
     //
     this.stcItem.AppearanceName = "";
     this.stcItem.ControlID      = "";
     this.stcItem.Dock           = System.Windows.Forms.DockStyle.Fill;
     this.stcItem.Font           = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222)));
     this.stcItem.Location       = new System.Drawing.Point(6, 80);
     this.stcItem.Name           = "stcItem";
     this.stcItem.PathString     = null;
     this.stcItem.PathValue      = "Item:";
     this.stcItem.Size           = new System.Drawing.Size(95, 32);
     this.stcItem.TabIndex       = 1;
     this.stcItem.Text           = "Item:";
     this.stcItem.TextAlign      = System.Drawing.ContentAlignment.MiddleLeft;
     //
     // stcLocation
     //
     this.stcLocation.AppearanceName = "";
     this.stcLocation.ControlID      = "";
     this.stcLocation.Dock           = System.Windows.Forms.DockStyle.Fill;
     this.stcLocation.Font           = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222)));
     this.stcLocation.Location       = new System.Drawing.Point(6, 48);
     this.stcLocation.Name           = "stcLocation";
     this.stcLocation.PathString     = null;
     this.stcLocation.PathValue      = "Location:";
     this.stcLocation.Size           = new System.Drawing.Size(95, 32);
     this.stcLocation.TabIndex       = 0;
     this.stcLocation.Text           = "Location:";
     this.stcLocation.TextAlign      = System.Drawing.ContentAlignment.MiddleLeft;
     //
     // txtLocation
     //
     this.txtLocation.AppearanceName         = "";
     this.txtLocation.AppearanceReadOnlyName = "";
     this.txtLocation.ControlID           = "";
     this.txtLocation.DisableRestrictChar = false;
     this.txtLocation.Dock       = System.Windows.Forms.DockStyle.Top;
     this.txtLocation.Font       = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222)));
     this.txtLocation.HelpButton = null;
     this.txtLocation.Location   = new System.Drawing.Point(107, 51);
     this.txtLocation.MaxLength  = 20;
     this.txtLocation.Name       = "txtLocation";
     this.txtLocation.PathString = null;
     this.txtLocation.PathValue  = "";
     this.txtLocation.Size       = new System.Drawing.Size(415, 26);
     this.txtLocation.TabIndex   = 0;
     //
     // txtItem
     //
     this.txtItem.AppearanceName         = "";
     this.txtItem.AppearanceReadOnlyName = "";
     this.txtItem.ControlID           = "";
     this.txtItem.DisableRestrictChar = false;
     this.txtItem.Dock       = System.Windows.Forms.DockStyle.Top;
     this.txtItem.Font       = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222)));
     this.txtItem.HelpButton = null;
     this.txtItem.Location   = new System.Drawing.Point(107, 83);
     this.txtItem.MaxLength  = 35;
     this.txtItem.Name       = "txtItem";
     this.txtItem.PathString = null;
     this.txtItem.PathValue  = "";
     this.txtItem.Size       = new System.Drawing.Size(415, 26);
     this.txtItem.TabIndex   = 1;
     //
     // txtLotNo
     //
     this.txtLotNo.AppearanceName         = "";
     this.txtLotNo.AppearanceReadOnlyName = "";
     this.txtLotNo.ControlID           = "";
     this.txtLotNo.DisableRestrictChar = false;
     this.txtLotNo.Dock       = System.Windows.Forms.DockStyle.Top;
     this.txtLotNo.Font       = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222)));
     this.txtLotNo.HelpButton = null;
     this.txtLotNo.Location   = new System.Drawing.Point(107, 148);
     this.txtLotNo.MaxLength  = 10;
     this.txtLotNo.Name       = "txtLotNo";
     this.txtLotNo.PathString = null;
     this.txtLotNo.PathValue  = "";
     this.txtLotNo.Size       = new System.Drawing.Size(415, 26);
     this.txtLotNo.TabIndex   = 3;
     //
     // lblHeader
     //
     this.lblHeader.AppearanceName = "Title";
     this.lblHeader.AutoSize       = true;
     this.tableLayoutPanel1.SetColumnSpan(this.lblHeader, 5);
     this.lblHeader.ControlID  = "";
     this.lblHeader.Dock       = System.Windows.Forms.DockStyle.Top;
     this.lblHeader.Font       = new System.Drawing.Font("Tahoma", 24F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))), System.Drawing.GraphicsUnit.Point, ((byte)(222)));
     this.lblHeader.ForeColor  = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(192)))));
     this.lblHeader.Location   = new System.Drawing.Point(6, 3);
     this.lblHeader.Name       = "lblHeader";
     this.lblHeader.Padding    = new System.Windows.Forms.Padding(3);
     this.lblHeader.PathString = null;
     this.lblHeader.PathValue  = "Inventory Movement Information";
     this.lblHeader.Size       = new System.Drawing.Size(874, 45);
     this.lblHeader.TabIndex   = 35;
     this.lblHeader.Text       = "Inventory Movement Information";
     //
     // stcOnHandQty
     //
     this.stcOnHandQty.AppearanceName = "";
     this.stcOnHandQty.ControlID      = "";
     this.stcOnHandQty.Dock           = System.Windows.Forms.DockStyle.Fill;
     this.stcOnHandQty.Font           = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222)));
     this.stcOnHandQty.Location       = new System.Drawing.Point(537, 80);
     this.stcOnHandQty.Name           = "stcOnHandQty";
     this.stcOnHandQty.PathString     = null;
     this.stcOnHandQty.PathValue      = "On Hand Qty:";
     this.stcOnHandQty.Size           = new System.Drawing.Size(128, 32);
     this.stcOnHandQty.TabIndex       = 7;
     this.stcOnHandQty.Text           = "On Hand Qty:";
     this.stcOnHandQty.TextAlign      = System.Drawing.ContentAlignment.MiddleLeft;
     //
     // txtOnHandQty
     //
     this.txtOnHandQty.AllowNegative          = true;
     this.txtOnHandQty.AppearanceName         = "";
     this.txtOnHandQty.AppearanceReadOnlyName = "";
     this.txtOnHandQty.ControlID = "";
     this.txtOnHandQty.Decimal   = new decimal(new int[] {
         0,
         0,
         0,
         0
     });
     this.txtOnHandQty.DecimalPoint       = '.';
     this.txtOnHandQty.DigitsInGroup      = 3;
     this.txtOnHandQty.Dock               = System.Windows.Forms.DockStyle.Top;
     this.txtOnHandQty.Double             = 0D;
     this.txtOnHandQty.FixDecimalPosition = false;
     this.txtOnHandQty.Flags              = 0;
     this.txtOnHandQty.Font               = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222)));
     this.txtOnHandQty.GroupSeparator     = ',';
     this.txtOnHandQty.Int              = 0;
     this.txtOnHandQty.Location         = new System.Drawing.Point(671, 83);
     this.txtOnHandQty.Long             = ((long)(0));
     this.txtOnHandQty.MaxDecimalPlaces = 6;
     this.txtOnHandQty.MaxWholeDigits   = 10;
     this.txtOnHandQty.Name             = "txtOnHandQty";
     this.txtOnHandQty.NegativeSign     = '-';
     this.txtOnHandQty.PathString       = null;
     this.txtOnHandQty.PathValue        = new decimal(new int[] {
         0,
         0,
         0,
         0
     });
     this.txtOnHandQty.Prefix    = "";
     this.txtOnHandQty.RangeMax  = 1.7976931348623157E+308D;
     this.txtOnHandQty.RangeMin  = -1.7976931348623157E+308D;
     this.txtOnHandQty.Size      = new System.Drawing.Size(209, 26);
     this.txtOnHandQty.TabIndex  = 5;
     this.txtOnHandQty.Text      = "0";
     this.txtOnHandQty.TextAlign = System.Windows.Forms.HorizontalAlignment.Right;
     //
     // lblItemType
     //
     this.lblItemType.AppearanceName = "";
     this.lblItemType.ControlID      = "";
     this.lblItemType.Dock           = System.Windows.Forms.DockStyle.Fill;
     this.lblItemType.Font           = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222)));
     this.lblItemType.Location       = new System.Drawing.Point(6, 112);
     this.lblItemType.Name           = "lblItemType";
     this.lblItemType.PathString     = null;
     this.lblItemType.PathValue      = "Part Type:";
     this.lblItemType.Size           = new System.Drawing.Size(95, 33);
     this.lblItemType.TabIndex       = 2;
     this.lblItemType.Text           = "Part Type:";
     this.lblItemType.TextAlign      = System.Drawing.ContentAlignment.MiddleLeft;
     //
     // cboItemType
     //
     this.cboItemType.AppearanceName         = "";
     this.cboItemType.AppearanceReadOnlyName = "";
     this.cboItemType.ControlID         = null;
     this.cboItemType.Dock              = System.Windows.Forms.DockStyle.Top;
     this.cboItemType.DropDownHeight    = 180;
     this.cboItemType.FormattingEnabled = true;
     this.cboItemType.IntegralHeight    = false;
     this.cboItemType.Location          = new System.Drawing.Point(107, 115);
     this.cboItemType.Name              = "cboItemType";
     this.cboItemType.PathString        = null;
     this.cboItemType.PathValue         = null;
     this.cboItemType.Size              = new System.Drawing.Size(415, 27);
     this.cboItemType.TabIndex          = 2;
     //
     // stcUnitMeasure
     //
     this.stcUnitMeasure.AppearanceName = "";
     this.stcUnitMeasure.ControlID      = "";
     this.stcUnitMeasure.Dock           = System.Windows.Forms.DockStyle.Fill;
     this.stcUnitMeasure.Font           = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222)));
     this.stcUnitMeasure.Location       = new System.Drawing.Point(537, 112);
     this.stcUnitMeasure.Name           = "stcUnitMeasure";
     this.stcUnitMeasure.PathString     = null;
     this.stcUnitMeasure.PathValue      = "Unit Measure:";
     this.stcUnitMeasure.Size           = new System.Drawing.Size(128, 33);
     this.stcUnitMeasure.TabIndex       = 7;
     this.stcUnitMeasure.Text           = "Unit Measure:";
     this.stcUnitMeasure.TextAlign      = System.Drawing.ContentAlignment.MiddleLeft;
     //
     // txtUnitMeasure
     //
     this.txtUnitMeasure.AppearanceName         = "";
     this.txtUnitMeasure.AppearanceReadOnlyName = "";
     this.txtUnitMeasure.ControlID           = "";
     this.txtUnitMeasure.DisableRestrictChar = false;
     this.txtUnitMeasure.Dock       = System.Windows.Forms.DockStyle.Top;
     this.txtUnitMeasure.HelpButton = null;
     this.txtUnitMeasure.Location   = new System.Drawing.Point(671, 115);
     this.txtUnitMeasure.MaxLength  = 30;
     this.txtUnitMeasure.Name       = "txtUnitMeasure";
     this.txtUnitMeasure.PathString = null;
     this.txtUnitMeasure.PathValue  = "";
     this.txtUnitMeasure.Size       = new System.Drawing.Size(209, 27);
     this.txtUnitMeasure.TabIndex   = 6;
     //
     // lblPackNo
     //
     this.lblPackNo.AppearanceName = "";
     this.lblPackNo.ControlID      = "";
     this.lblPackNo.Dock           = System.Windows.Forms.DockStyle.Fill;
     this.lblPackNo.Font           = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222)));
     this.lblPackNo.Location       = new System.Drawing.Point(537, 145);
     this.lblPackNo.Name           = "lblPackNo";
     this.lblPackNo.PathString     = null;
     this.lblPackNo.PathValue      = "Pack No:";
     this.lblPackNo.Size           = new System.Drawing.Size(128, 38);
     this.lblPackNo.TabIndex       = 36;
     this.lblPackNo.Text           = "Pack No:";
     this.lblPackNo.TextAlign      = System.Drawing.ContentAlignment.MiddleLeft;
     //
     // txtPackNo
     //
     this.txtPackNo.AppearanceName         = "";
     this.txtPackNo.AppearanceReadOnlyName = "";
     this.txtPackNo.ControlID           = "";
     this.txtPackNo.DisableRestrictChar = false;
     this.txtPackNo.Dock       = System.Windows.Forms.DockStyle.Top;
     this.txtPackNo.Font       = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222)));
     this.txtPackNo.HelpButton = null;
     this.txtPackNo.Location   = new System.Drawing.Point(671, 148);
     this.txtPackNo.MaxLength  = 10;
     this.txtPackNo.Name       = "txtPackNo";
     this.txtPackNo.PathString = null;
     this.txtPackNo.PathValue  = "";
     this.txtPackNo.Size       = new System.Drawing.Size(209, 26);
     this.txtPackNo.TabIndex   = 37;
     //
     // fpView
     //
     this.fpView.About = "2.5.2015.2005";
     this.fpView.AccessibleDescription = "fpView, Sheet1";
     this.fpView.BackColor             = System.Drawing.Color.AliceBlue;
     this.fpView.ColumnSplitBoxPolicy  = FarPoint.Win.Spread.SplitBoxPolicy.AsNeeded;
     this.fpView.Dock = System.Windows.Forms.DockStyle.Fill;
     this.fpView.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
     this.fpView.Location             = new System.Drawing.Point(3, 189);
     this.fpView.Name                 = "fpView";
     this.fpView.RightToLeft          = System.Windows.Forms.RightToLeft.No;
     this.fpView.RowSplitBoxPolicy    = FarPoint.Win.Spread.SplitBoxPolicy.AsNeeded;
     this.fpView.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Both;
     this.fpView.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] {
         this.shtView
     });
     this.fpView.Size     = new System.Drawing.Size(886, 340);
     this.fpView.TabIndex = 0;
     this.fpView.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
     this.fpView.KeyDown += new System.Windows.Forms.KeyEventHandler(this.fpView_KeyDown);
     //
     // shtView
     //
     this.shtView.Reset();
     this.shtView.SheetName = "Sheet1";
     // Formulas and custom names must be loaded with R1C1 reference style
     this.shtView.ReferenceStyle      = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
     this.shtView.ColumnCount         = 15;
     this.shtView.RowCount            = 0;
     this.shtView.AutoCalculation     = false;
     this.shtView.AutoGenerateColumns = false;
     this.shtView.ColumnHeader.Cells.Get(0, 0).Value  = "Date";
     this.shtView.ColumnHeader.Cells.Get(0, 1).Value  = "Trans ID";
     this.shtView.ColumnHeader.Cells.Get(0, 2).Value  = "Trans Info";
     this.shtView.ColumnHeader.Cells.Get(0, 3).Value  = "Lot No.";
     this.shtView.ColumnHeader.Cells.Get(0, 4).Value  = "In Qty";
     this.shtView.ColumnHeader.Cells.Get(0, 5).Value  = "Out Qty";
     this.shtView.ColumnHeader.Cells.Get(0, 6).Value  = "Balance";
     this.shtView.ColumnHeader.Cells.Get(0, 7).Value  = "NG Criteria";
     this.shtView.ColumnHeader.Cells.Get(0, 8).Value  = "NG Qty";
     this.shtView.ColumnHeader.Cells.Get(0, 9).Value  = "Price";
     this.shtView.ColumnHeader.Cells.Get(0, 10).Value = "Ref Type";
     this.shtView.ColumnHeader.Cells.Get(0, 11).Value = "Ref Slip No";
     this.shtView.ColumnHeader.Cells.Get(0, 12).Value = "Ref No";
     this.shtView.ColumnHeader.Cells.Get(0, 13).Value = "For Customer";
     this.shtView.ColumnHeader.Cells.Get(0, 14).Value = "Remark";
     this.shtView.ColumnHeader.Rows.Get(0).Height     = 40F;
     dateTimeCellType1.Calendar           = ((System.Globalization.Calendar)(resources.GetObject("dateTimeCellType1.Calendar")));
     dateTimeCellType1.DateDefault        = new System.DateTime(2009, 9, 22, 11, 2, 49, 0);
     dateTimeCellType1.TimeDefault        = new System.DateTime(2009, 9, 22, 11, 2, 49, 0);
     dateTimeCellType1.TwoDigitYearMax    = 2029;
     this.shtView.Columns.Get(0).CellType = dateTimeCellType1;
     this.shtView.Columns.Get(0).Label    = "Date";
     this.shtView.Columns.Get(0).Tag      = "TRANS_DATE";
     this.shtView.Columns.Get(0).Width    = 100F;
     this.shtView.Columns.Get(1).CellType = textCellType1;
     this.shtView.Columns.Get(1).Label    = "Trans ID";
     this.shtView.Columns.Get(1).Tag      = "TRANS_ID";
     this.shtView.Columns.Get(1).Width    = 123F;
     this.shtView.Columns.Get(2).CellType = textCellType2;
     this.shtView.Columns.Get(2).Label    = "Trans Info";
     this.shtView.Columns.Get(2).Tag      = "TRANS_INFO";
     this.shtView.Columns.Get(2).Width    = 152F;
     this.shtView.Columns.Get(3).Label    = "Lot No.";
     this.shtView.Columns.Get(3).Tag      = "LOT_NO";
     this.shtView.Columns.Get(3).Width    = 100F;
     currencyCellType1.DecimalPlaces      = 6;
     currencyCellType1.DecimalSeparator   = ".";
     currencyCellType1.FixedPoint         = false;
     currencyCellType1.MaximumValue       = new decimal(new int[] {
         1874919423,
         2328306,
         0,
         393216
     });
     currencyCellType1.MinimumValue = new decimal(new int[] {
         1874919423,
         2328306,
         0,
         -2147090432
     });
     currencyCellType1.Separator          = ",";
     currencyCellType1.ShowCurrencySymbol = false;
     currencyCellType1.ShowSeparator      = true;
     this.shtView.Columns.Get(4).CellType = currencyCellType1;
     this.shtView.Columns.Get(4).Label    = "In Qty";
     this.shtView.Columns.Get(4).Tag      = "IN_QTY";
     this.shtView.Columns.Get(4).Width    = 110F;
     currencyCellType2.DecimalPlaces      = 6;
     currencyCellType2.DecimalSeparator   = ".";
     currencyCellType2.FixedPoint         = false;
     currencyCellType2.MaximumValue       = new decimal(new int[] {
         1874919423,
         2328306,
         0,
         393216
     });
     currencyCellType2.MinimumValue = new decimal(new int[] {
         1874919423,
         2328306,
         0,
         -2147090432
     });
     currencyCellType2.ShowCurrencySymbol = false;
     currencyCellType2.ShowSeparator      = true;
     this.shtView.Columns.Get(5).CellType = currencyCellType2;
     this.shtView.Columns.Get(5).Label    = "Out Qty";
     this.shtView.Columns.Get(5).Tag      = "OUT_QTY";
     this.shtView.Columns.Get(5).Width    = 101F;
     currencyCellType3.DecimalPlaces      = 6;
     currencyCellType3.DecimalSeparator   = ".";
     currencyCellType3.FixedPoint         = false;
     currencyCellType3.MaximumValue       = new decimal(new int[] {
         1874919423,
         2328306,
         0,
         393216
     });
     currencyCellType3.MinimumValue = new decimal(new int[] {
         1874919423,
         2328306,
         0,
         -2147090432
     });
     currencyCellType3.NegativeFormat                 = FarPoint.Win.Spread.CellType.CurrencyNegativeFormat.SignSymbolBefore;
     currencyCellType3.Separator                      = ",";
     currencyCellType3.ShowCurrencySymbol             = false;
     currencyCellType3.ShowSeparator                  = true;
     this.shtView.Columns.Get(6).CellType             = currencyCellType3;
     this.shtView.Columns.Get(6).Label                = "Balance";
     this.shtView.Columns.Get(6).Tag                  = "BALANCE";
     this.shtView.Columns.Get(6).Width                = 118F;
     this.shtView.Columns.Get(7).Label                = "NG Criteria";
     this.shtView.Columns.Get(7).Width                = 100F;
     this.shtView.Columns.Get(8).Label                = "NG Qty";
     this.shtView.Columns.Get(8).Width                = 100F;
     this.shtView.Columns.Get(9).Label                = "Price";
     this.shtView.Columns.Get(9).Tag                  = "Price";
     this.shtView.Columns.Get(9).Width                = 89F;
     this.shtView.Columns.Get(10).Label               = "Ref Type";
     this.shtView.Columns.Get(10).Tag                 = "REF_TYPE";
     this.shtView.Columns.Get(10).Width               = 150F;
     this.shtView.Columns.Get(11).Label               = "Ref Slip No";
     this.shtView.Columns.Get(11).Tag                 = "REF_SLIP_NO";
     this.shtView.Columns.Get(11).Width               = 158F;
     this.shtView.Columns.Get(12).Label               = "Ref No";
     this.shtView.Columns.Get(12).Tag                 = "Ref No";
     this.shtView.Columns.Get(12).Width               = 153F;
     this.shtView.Columns.Get(13).Label               = "For Customer";
     this.shtView.Columns.Get(13).Tag                 = "For Customer";
     this.shtView.Columns.Get(13).Width               = 133F;
     this.shtView.Columns.Get(14).Label               = "Remark";
     this.shtView.Columns.Get(14).Tag                 = "Remark";
     this.shtView.Columns.Get(14).Width               = 250F;
     this.shtView.DataAutoCellTypes                   = false;
     this.shtView.DataAutoHeadings                    = false;
     this.shtView.DataAutoSizeColumns                 = false;
     this.shtView.OperationMode                       = FarPoint.Win.Spread.OperationMode.SingleSelect;
     this.shtView.RowHeader.Columns.Default.Resizable = true;
     this.shtView.RowHeader.Columns.Get(0).Width      = 56F;
     this.shtView.SelectionPolicy                     = FarPoint.Win.Spread.Model.SelectionPolicy.Single;
     this.shtView.SelectionUnit                       = FarPoint.Win.Spread.Model.SelectionUnit.Row;
     this.shtView.ReferenceStyle                      = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
     this.fpView.SetActiveViewport(0, 1, 0);
     //
     // INV020_InventoryMovementInquiry
     //
     this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
     this.AutoScaleMode       = System.Windows.Forms.AutoScaleMode.Font;
     this.ClientSize          = new System.Drawing.Size(892, 590);
     this.Icon        = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
     this.Name        = "INV020_InventoryMovementInquiry";
     this.Text        = "Inventory Movement Inquiry";
     this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
     this.Load       += new System.EventHandler(this.INV020_InventoryMovementInquiry_Load);
     this.Shown      += new System.EventHandler(this.INV020_InventoryMovementInquiry_Shown);
     this.pnlContainer.ResumeLayout(false);
     this.tableLayoutPanel1.ResumeLayout(false);
     this.tableLayoutPanel1.PerformLayout();
     ((System.ComponentModel.ISupportInitialize)(this.fpView)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.shtView)).EndInit();
     this.ResumeLayout(false);
     this.PerformLayout();
 }
コード例 #8
0
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     this.components = new System.ComponentModel.Container();
     System.ComponentModel.ComponentResourceManager resources         = new System.ComponentModel.ComponentResourceManager(typeof(TRN010));
     FarPoint.Win.Spread.CellType.CurrencyCellType  currencyCellType1 = new FarPoint.Win.Spread.CellType.CurrencyCellType();
     FarPoint.Win.Spread.CellType.NumberCellType    numberCellType1   = new FarPoint.Win.Spread.CellType.NumberCellType();
     FarPoint.Win.Spread.CellType.NumberCellType    numberCellType2   = new FarPoint.Win.Spread.CellType.NumberCellType();
     FarPoint.Win.Spread.CellType.CurrencyCellType  currencyCellType2 = new FarPoint.Win.Spread.CellType.CurrencyCellType();
     this.tableContainer = new System.Windows.Forms.TableLayoutPanel();
     this.pnlHeader      = new EVOFramework.Windows.Forms.EVOPanel();
     this.stcHead        = new EVOFramework.Windows.Forms.EVOLabel();
     this.tableSearch    = new System.Windows.Forms.TableLayoutPanel();
     this.stcDash        = new EVOFramework.Windows.Forms.EVOLabel();
     this.stcPeriod      = new EVOFramework.Windows.Forms.EVOLabel();
     this.dtPeriodBegin  = new EVOFramework.Windows.Forms.EVODateTextBoxWithCalendar();
     this.dtPeriodEnd    = new EVOFramework.Windows.Forms.EVODateTextBoxWithCalendar();
     this.fpView         = new FarPoint.Win.Spread.FpSpread();
     this.shtView        = new FarPoint.Win.Spread.SheetView();
     this.panSearch      = new EVOFramework.Windows.Forms.EVOPanel();
     this.tblSearch      = new System.Windows.Forms.TableLayoutPanel();
     this.pictureBox1    = new System.Windows.Forms.PictureBox();
     this.txtSearch      = new EVOFramework.Windows.Forms.EVOTextBox();
     this.ctxMenu        = new System.Windows.Forms.ContextMenuStrip(this.components);
     this.miEdit         = new System.Windows.Forms.ToolStripMenuItem();
     this.miDelete       = new System.Windows.Forms.ToolStripMenuItem();
     this.miDeleteGroup  = new System.Windows.Forms.ToolStripMenuItem();
     this.pnlContainer.SuspendLayout();
     this.tableContainer.SuspendLayout();
     this.pnlHeader.SuspendLayout();
     this.tableSearch.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.fpView)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.shtView)).BeginInit();
     this.panSearch.SuspendLayout();
     this.tblSearch.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).BeginInit();
     this.ctxMenu.SuspendLayout();
     this.SuspendLayout();
     //
     // pnlContainer
     //
     this.pnlContainer.Controls.Add(this.tableContainer);
     this.pnlContainer.Font      = new System.Drawing.Font("Tahoma", 12F);
     this.pnlContainer.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))));
     this.pnlContainer.Size      = new System.Drawing.Size(892, 327);
     //
     // tableContainer
     //
     this.tableContainer.ColumnCount = 2;
     this.tableContainer.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 100F));
     this.tableContainer.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Absolute, 548F));
     this.tableContainer.Controls.Add(this.pnlHeader, 0, 0);
     this.tableContainer.Controls.Add(this.tableSearch, 1, 0);
     this.tableContainer.Controls.Add(this.fpView, 0, 2);
     this.tableContainer.Controls.Add(this.panSearch, 0, 1);
     this.tableContainer.Dock     = System.Windows.Forms.DockStyle.Fill;
     this.tableContainer.Location = new System.Drawing.Point(0, 0);
     this.tableContainer.Name     = "tableContainer";
     this.tableContainer.RowCount = 3;
     this.tableContainer.RowStyles.Add(new System.Windows.Forms.RowStyle());
     this.tableContainer.RowStyles.Add(new System.Windows.Forms.RowStyle());
     this.tableContainer.RowStyles.Add(new System.Windows.Forms.RowStyle());
     this.tableContainer.Size     = new System.Drawing.Size(892, 327);
     this.tableContainer.TabIndex = 0;
     //
     // pnlHeader
     //
     this.pnlHeader.AppearanceName = "";
     this.pnlHeader.AutoSize       = true;
     this.pnlHeader.Controls.Add(this.stcHead);
     this.pnlHeader.Dock     = System.Windows.Forms.DockStyle.Fill;
     this.pnlHeader.Location = new System.Drawing.Point(0, 0);
     this.pnlHeader.Margin   = new System.Windows.Forms.Padding(0);
     this.pnlHeader.Name     = "pnlHeader";
     this.pnlHeader.Size     = new System.Drawing.Size(344, 33);
     this.pnlHeader.TabIndex = 1;
     //
     // stcHead
     //
     this.stcHead.AccessibleName = "";
     this.stcHead.AppearanceName = "Title";
     this.stcHead.AutoSize       = true;
     this.stcHead.ControlID      = "";
     this.stcHead.Dock           = System.Windows.Forms.DockStyle.Top;
     this.stcHead.ForeColor      = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(192)))));
     this.stcHead.Location       = new System.Drawing.Point(0, 0);
     this.stcHead.Margin         = new System.Windows.Forms.Padding(0, 0, 3, 0);
     this.stcHead.Name           = "stcHead";
     this.stcHead.Padding        = new System.Windows.Forms.Padding(3);
     this.stcHead.PathString     = null;
     this.stcHead.PathValue      = "Receiving List";
     this.stcHead.Size           = new System.Drawing.Size(111, 25);
     this.stcHead.TabIndex       = 37;
     this.stcHead.Text           = "Receiving List";
     //
     // tableSearch
     //
     this.tableSearch.AutoSize    = true;
     this.tableSearch.ColumnCount = 4;
     this.tableSearch.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Absolute, 145F));
     this.tableSearch.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 50F));
     this.tableSearch.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle());
     this.tableSearch.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 50F));
     this.tableSearch.Controls.Add(this.stcDash, 2, 0);
     this.tableSearch.Controls.Add(this.stcPeriod, 0, 0);
     this.tableSearch.Controls.Add(this.dtPeriodBegin, 1, 0);
     this.tableSearch.Controls.Add(this.dtPeriodEnd, 3, 0);
     this.tableSearch.Dock     = System.Windows.Forms.DockStyle.Bottom;
     this.tableSearch.Location = new System.Drawing.Point(344, 0);
     this.tableSearch.Margin   = new System.Windows.Forms.Padding(0);
     this.tableSearch.Name     = "tableSearch";
     this.tableSearch.RowCount = 1;
     this.tableSearch.RowStyles.Add(new System.Windows.Forms.RowStyle());
     this.tableSearch.Size     = new System.Drawing.Size(548, 33);
     this.tableSearch.TabIndex = 0;
     //
     // stcDash
     //
     this.stcDash.AppearanceName = "";
     this.stcDash.AutoSize       = true;
     this.stcDash.ControlID      = "";
     this.stcDash.Dock           = System.Windows.Forms.DockStyle.Fill;
     this.stcDash.Location       = new System.Drawing.Point(339, 0);
     this.stcDash.Name           = "stcDash";
     this.stcDash.PathString     = null;
     this.stcDash.PathValue      = "-";
     this.stcDash.Size           = new System.Drawing.Size(15, 33);
     this.stcDash.TabIndex       = 1;
     this.stcDash.Text           = "-";
     this.stcDash.TextAlign      = System.Drawing.ContentAlignment.MiddleCenter;
     //
     // stcPeriod
     //
     this.stcPeriod.AppearanceName = "";
     this.stcPeriod.AutoSize       = true;
     this.stcPeriod.ControlID      = "";
     this.stcPeriod.Dock           = System.Windows.Forms.DockStyle.Fill;
     this.stcPeriod.Location       = new System.Drawing.Point(3, 0);
     this.stcPeriod.Name           = "stcPeriod";
     this.stcPeriod.PathString     = null;
     this.stcPeriod.PathValue      = "Inventory Period";
     this.stcPeriod.Size           = new System.Drawing.Size(139, 33);
     this.stcPeriod.TabIndex       = 0;
     this.stcPeriod.Text           = "Inventory Period";
     this.stcPeriod.TextAlign      = System.Drawing.ContentAlignment.MiddleLeft;
     //
     // dtPeriodBegin
     //
     this.dtPeriodBegin.AppearanceName         = "";
     this.dtPeriodBegin.AppearanceReadOnlyName = "";
     this.dtPeriodBegin.BackColor   = System.Drawing.Color.Transparent;
     this.dtPeriodBegin.ControlID   = "";
     this.dtPeriodBegin.Dock        = System.Windows.Forms.DockStyle.Top;
     this.dtPeriodBegin.Format      = "dd/MM/yyyy";
     this.dtPeriodBegin.Location    = new System.Drawing.Point(148, 3);
     this.dtPeriodBegin.MinimumSize = new System.Drawing.Size(100, 0);
     this.dtPeriodBegin.Name        = "dtPeriodBegin";
     this.dtPeriodBegin.NZValue     = ((EVOFramework.NZDateTime)(resources.GetObject("dtPeriodBegin.NZValue")));
     this.dtPeriodBegin.PathString  = null;
     this.dtPeriodBegin.PathValue   = ((object)(resources.GetObject("dtPeriodBegin.PathValue")));
     this.dtPeriodBegin.ReadOnly    = false;
     this.dtPeriodBegin.ShowButton  = true;
     this.dtPeriodBegin.Size        = new System.Drawing.Size(185, 27);
     this.dtPeriodBegin.TabIndex    = 2;
     this.dtPeriodBegin.Value       = null;
     //
     // dtPeriodEnd
     //
     this.dtPeriodEnd.AppearanceName         = "";
     this.dtPeriodEnd.AppearanceReadOnlyName = "";
     this.dtPeriodEnd.BackColor   = System.Drawing.Color.Transparent;
     this.dtPeriodEnd.ControlID   = "";
     this.dtPeriodEnd.Dock        = System.Windows.Forms.DockStyle.Top;
     this.dtPeriodEnd.Format      = "dd/MM/yyyy";
     this.dtPeriodEnd.Location    = new System.Drawing.Point(360, 3);
     this.dtPeriodEnd.MinimumSize = new System.Drawing.Size(100, 0);
     this.dtPeriodEnd.Name        = "dtPeriodEnd";
     this.dtPeriodEnd.NZValue     = ((EVOFramework.NZDateTime)(resources.GetObject("dtPeriodEnd.NZValue")));
     this.dtPeriodEnd.PathString  = null;
     this.dtPeriodEnd.PathValue   = ((object)(resources.GetObject("dtPeriodEnd.PathValue")));
     this.dtPeriodEnd.ReadOnly    = false;
     this.dtPeriodEnd.ShowButton  = true;
     this.dtPeriodEnd.Size        = new System.Drawing.Size(185, 27);
     this.dtPeriodEnd.TabIndex    = 3;
     this.dtPeriodEnd.Value       = null;
     //
     // fpView
     //
     this.fpView.About = "2.5.2015.2005";
     this.fpView.AccessibleDescription = "fpView, Sheet1, Row 0, Column 0, ";
     this.fpView.BackColor             = System.Drawing.Color.AliceBlue;
     this.tableContainer.SetColumnSpan(this.fpView, 2);
     this.fpView.Dock = System.Windows.Forms.DockStyle.Fill;
     this.fpView.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
     this.fpView.Location             = new System.Drawing.Point(3, 71);
     this.fpView.Name                 = "fpView";
     this.fpView.RightToLeft          = System.Windows.Forms.RightToLeft.No;
     this.fpView.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Both;
     this.fpView.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] {
         this.shtView
     });
     this.fpView.Size     = new System.Drawing.Size(886, 253);
     this.fpView.TabIndex = 2;
     this.fpView.TabStop  = false;
     this.fpView.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
     this.fpView.CellDoubleClick        += new FarPoint.Win.Spread.CellClickEventHandler(this.fpView_CellDoubleClick);
     this.fpView.KeyDown   += new System.Windows.Forms.KeyEventHandler(this.fpView_KeyDown);
     this.fpView.KeyPress  += new System.Windows.Forms.KeyPressEventHandler(this.fpView_KeyPress);
     this.fpView.MouseDown += new System.Windows.Forms.MouseEventHandler(this.fpView_MouseDown);
     //
     // shtView
     //
     this.shtView.Reset();
     this.shtView.SheetName = "Sheet1";
     // Formulas and custom names must be loaded with R1C1 reference style
     this.shtView.ReferenceStyle      = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
     this.shtView.ColumnCount         = 20;
     this.shtView.RowCount            = 0;
     this.shtView.AutoGenerateColumns = false;
     this.shtView.ColumnHeader.Cells.Get(0, 0).Value  = "Receiving Date";
     this.shtView.ColumnHeader.Cells.Get(0, 1).Value  = "Receive No";
     this.shtView.ColumnHeader.Cells.Get(0, 2).Value  = "Receiving Type";
     this.shtView.ColumnHeader.Cells.Get(0, 3).Value  = "Supplier Code";
     this.shtView.ColumnHeader.Cells.Get(0, 4).Value  = "Part No";
     this.shtView.ColumnHeader.Cells.Get(0, 5).Value  = "Part Name";
     this.shtView.ColumnHeader.Cells.Get(0, 6).Value  = "Lot No";
     this.shtView.ColumnHeader.Cells.Get(0, 7).Value  = "Supp Lot No";
     this.shtView.ColumnHeader.Cells.Get(0, 8).Value  = "Receive Qty";
     this.shtView.ColumnHeader.Cells.Get(0, 9).Value  = "Price";
     this.shtView.ColumnHeader.Cells.Get(0, 10).Value = "Amount";
     this.shtView.ColumnHeader.Cells.Get(0, 11).Value = "Order U/M";
     this.shtView.ColumnHeader.Cells.Get(0, 12).Value = "Stock Qty";
     this.shtView.ColumnHeader.Cells.Get(0, 13).Value = "Stock U/M";
     this.shtView.ColumnHeader.Cells.Get(0, 14).Value = "Store Loc";
     this.shtView.ColumnHeader.Cells.Get(0, 15).Value = "Vendor Invoice";
     this.shtView.ColumnHeader.Cells.Get(0, 16).Value = "PO No";
     this.shtView.ColumnHeader.Cells.Get(0, 17).Value = "PO No";
     this.shtView.ColumnHeader.Cells.Get(0, 18).Value = "Transaction ID";
     this.shtView.ColumnHeader.Cells.Get(0, 19).Value = "Remark";
     this.shtView.ColumnHeader.Rows.Get(0).Height     = 40F;
     this.shtView.Columns.Get(0).AllowAutoFilter      = true;
     this.shtView.Columns.Get(0).AllowAutoSort        = true;
     this.shtView.Columns.Get(0).Label           = "Receiving Date";
     this.shtView.Columns.Get(0).Locked          = true;
     this.shtView.Columns.Get(0).Tag             = "ReceivingDate";
     this.shtView.Columns.Get(0).Width           = 137F;
     this.shtView.Columns.Get(1).AllowAutoFilter = true;
     this.shtView.Columns.Get(1).AllowAutoSort   = true;
     this.shtView.Columns.Get(1).Label           = "Receive No";
     this.shtView.Columns.Get(1).Locked          = true;
     this.shtView.Columns.Get(1).Tag             = "ReceiveNo";
     this.shtView.Columns.Get(1).Width           = 144F;
     this.shtView.Columns.Get(2).AllowAutoFilter = true;
     this.shtView.Columns.Get(2).AllowAutoSort   = true;
     this.shtView.Columns.Get(2).Label           = "Receiving Type";
     this.shtView.Columns.Get(2).Locked          = true;
     this.shtView.Columns.Get(2).Tag             = "ReceivingType";
     this.shtView.Columns.Get(2).Width           = 165F;
     this.shtView.Columns.Get(3).AllowAutoFilter = true;
     this.shtView.Columns.Get(3).AllowAutoSort   = true;
     this.shtView.Columns.Get(3).Label           = "Supplier Code";
     this.shtView.Columns.Get(3).Tag             = "SUPP_CODE";
     this.shtView.Columns.Get(3).Width           = 151F;
     this.shtView.Columns.Get(4).AllowAutoFilter = true;
     this.shtView.Columns.Get(4).AllowAutoSort   = true;
     this.shtView.Columns.Get(4).Label           = "Part No";
     this.shtView.Columns.Get(4).Locked          = true;
     this.shtView.Columns.Get(4).Tag             = "PartNo";
     this.shtView.Columns.Get(4).Width           = 144F;
     this.shtView.Columns.Get(5).AllowAutoFilter = true;
     this.shtView.Columns.Get(5).AllowAutoSort   = true;
     this.shtView.Columns.Get(5).Label           = "Part Name";
     this.shtView.Columns.Get(5).Locked          = true;
     this.shtView.Columns.Get(5).Tag             = "PartName";
     this.shtView.Columns.Get(5).Width           = 144F;
     this.shtView.Columns.Get(6).AllowAutoFilter = true;
     this.shtView.Columns.Get(6).AllowAutoSort   = true;
     this.shtView.Columns.Get(6).Label           = "Lot No";
     this.shtView.Columns.Get(6).Tag             = "Lot No";
     this.shtView.Columns.Get(6).Width           = 126F;
     this.shtView.Columns.Get(7).AllowAutoFilter = true;
     this.shtView.Columns.Get(7).AllowAutoSort   = true;
     this.shtView.Columns.Get(7).Label           = "Supp Lot No";
     this.shtView.Columns.Get(7).Tag             = "SUPP_LOT_NO";
     this.shtView.Columns.Get(7).Width           = 103F;
     this.shtView.Columns.Get(8).AllowAutoFilter = true;
     this.shtView.Columns.Get(8).AllowAutoSort   = true;
     currencyCellType1.DecimalPlaces             = 6;
     currencyCellType1.DecimalSeparator          = ".";
     currencyCellType1.FixedPoint   = false;
     currencyCellType1.MaximumValue = new decimal(new int[] {
         1874919423,
         2328306,
         0,
         393216
     });
     currencyCellType1.MinimumValue = new decimal(new int[] {
         0,
         0,
         0,
         0
     });
     currencyCellType1.Separator                  = ",";
     currencyCellType1.ShowCurrencySymbol         = false;
     currencyCellType1.ShowSeparator              = true;
     this.shtView.Columns.Get(8).CellType         = currencyCellType1;
     this.shtView.Columns.Get(8).Label            = "Receive Qty";
     this.shtView.Columns.Get(8).Locked           = true;
     this.shtView.Columns.Get(8).Tag              = "ReceiveQty";
     this.shtView.Columns.Get(8).Width            = 97F;
     this.shtView.Columns.Get(9).AllowAutoFilter  = true;
     this.shtView.Columns.Get(9).AllowAutoSort    = true;
     numberCellType1.ShowSeparator                = true;
     this.shtView.Columns.Get(9).CellType         = numberCellType1;
     this.shtView.Columns.Get(9).Label            = "Price";
     this.shtView.Columns.Get(9).Tag              = "PRICE";
     this.shtView.Columns.Get(9).Width            = 95F;
     this.shtView.Columns.Get(10).AllowAutoFilter = true;
     this.shtView.Columns.Get(10).AllowAutoSort   = true;
     numberCellType2.ShowSeparator                = true;
     this.shtView.Columns.Get(10).CellType        = numberCellType2;
     this.shtView.Columns.Get(10).Label           = "Amount";
     this.shtView.Columns.Get(10).Tag             = "AMOUNT";
     this.shtView.Columns.Get(10).Width           = 100F;
     this.shtView.Columns.Get(11).AllowAutoFilter = true;
     this.shtView.Columns.Get(11).AllowAutoSort   = true;
     this.shtView.Columns.Get(11).Label           = "Order U/M";
     this.shtView.Columns.Get(11).Locked          = true;
     this.shtView.Columns.Get(11).Tag             = "OrderUM";
     this.shtView.Columns.Get(11).Width           = 123F;
     this.shtView.Columns.Get(12).AllowAutoFilter = true;
     this.shtView.Columns.Get(12).AllowAutoSort   = true;
     currencyCellType2.DecimalPlaces              = 6;
     currencyCellType2.DecimalSeparator           = ".";
     currencyCellType2.FixedPoint                 = false;
     currencyCellType2.MaximumValue               = new decimal(new int[] {
         1874919423,
         2328306,
         0,
         393216
     });
     currencyCellType2.MinimumValue = new decimal(new int[] {
         0,
         0,
         0,
         0
     });
     currencyCellType2.Separator                  = ",";
     currencyCellType2.ShowCurrencySymbol         = false;
     currencyCellType2.ShowSeparator              = true;
     this.shtView.Columns.Get(12).CellType        = currencyCellType2;
     this.shtView.Columns.Get(12).Label           = "Stock Qty";
     this.shtView.Columns.Get(12).Locked          = true;
     this.shtView.Columns.Get(12).Tag             = "StockQty";
     this.shtView.Columns.Get(12).Width           = 91F;
     this.shtView.Columns.Get(13).AllowAutoFilter = true;
     this.shtView.Columns.Get(13).AllowAutoSort   = true;
     this.shtView.Columns.Get(13).Label           = "Stock U/M";
     this.shtView.Columns.Get(13).Locked          = true;
     this.shtView.Columns.Get(13).Tag             = "StockUM";
     this.shtView.Columns.Get(13).Width           = 118F;
     this.shtView.Columns.Get(14).AllowAutoFilter = true;
     this.shtView.Columns.Get(14).AllowAutoSort   = true;
     this.shtView.Columns.Get(14).Label           = "Store Loc";
     this.shtView.Columns.Get(14).Locked          = true;
     this.shtView.Columns.Get(14).Tag             = "StoredLoc";
     this.shtView.Columns.Get(14).Width           = 144F;
     this.shtView.Columns.Get(15).AllowAutoFilter = true;
     this.shtView.Columns.Get(15).AllowAutoSort   = true;
     this.shtView.Columns.Get(15).Label           = "Vendor Invoice";
     this.shtView.Columns.Get(15).Locked          = true;
     this.shtView.Columns.Get(15).Tag             = "VendorInvoice";
     this.shtView.Columns.Get(15).Width           = 122F;
     this.shtView.Columns.Get(16).AllowAutoFilter = true;
     this.shtView.Columns.Get(16).AllowAutoSort   = true;
     this.shtView.Columns.Get(16).Label           = "PO No";
     this.shtView.Columns.Get(16).Locked          = true;
     this.shtView.Columns.Get(16).Tag             = "RefSlipNo";
     this.shtView.Columns.Get(16).Width           = 93F;
     this.shtView.Columns.Get(17).AllowAutoFilter = true;
     this.shtView.Columns.Get(17).AllowAutoSort   = true;
     this.shtView.Columns.Get(17).Label           = "PO No";
     this.shtView.Columns.Get(17).Tag             = "RefType";
     this.shtView.Columns.Get(17).Visible         = false;
     this.shtView.Columns.Get(17).Width           = 157F;
     this.shtView.Columns.Get(18).AllowAutoFilter = true;
     this.shtView.Columns.Get(18).AllowAutoSort   = true;
     this.shtView.Columns.Get(18).Label           = "Transaction ID";
     this.shtView.Columns.Get(18).Locked          = true;
     this.shtView.Columns.Get(18).Tag             = "TransactionID";
     this.shtView.Columns.Get(18).Width           = 202F;
     this.shtView.Columns.Get(19).AllowAutoFilter = true;
     this.shtView.Columns.Get(19).AllowAutoSort   = true;
     this.shtView.Columns.Get(19).Label           = "Remark";
     this.shtView.Columns.Get(19).Locked          = true;
     this.shtView.Columns.Get(19).Tag             = "Remark";
     this.shtView.Columns.Get(19).Width           = 106F;
     this.shtView.DataAutoCellTypes               = false;
     this.shtView.DataAutoHeadings                = false;
     this.shtView.DataAutoSizeColumns             = false;
     this.shtView.OperationMode = FarPoint.Win.Spread.OperationMode.SingleSelect;
     this.shtView.RowHeader.Columns.Default.Resizable = true;
     this.shtView.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Single;
     this.shtView.SelectionUnit   = FarPoint.Win.Spread.Model.SelectionUnit.Row;
     this.shtView.ReferenceStyle  = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
     this.fpView.SetActiveViewport(0, 1, 0);
     //
     // panSearch
     //
     this.panSearch.AppearanceName = "";
     this.tableContainer.SetColumnSpan(this.panSearch, 2);
     this.panSearch.Controls.Add(this.tblSearch);
     this.panSearch.Dock     = System.Windows.Forms.DockStyle.Fill;
     this.panSearch.Location = new System.Drawing.Point(0, 33);
     this.panSearch.Margin   = new System.Windows.Forms.Padding(0);
     this.panSearch.Name     = "panSearch";
     this.panSearch.Size     = new System.Drawing.Size(892, 35);
     this.panSearch.TabIndex = 3;
     //
     // tblSearch
     //
     this.tblSearch.ColumnCount = 3;
     this.tblSearch.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Absolute, 20F));
     this.tblSearch.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle());
     this.tblSearch.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle());
     this.tblSearch.Controls.Add(this.pictureBox1, 1, 0);
     this.tblSearch.Controls.Add(this.txtSearch, 2, 0);
     this.tblSearch.Dock     = System.Windows.Forms.DockStyle.Top;
     this.tblSearch.Location = new System.Drawing.Point(0, 0);
     this.tblSearch.Margin   = new System.Windows.Forms.Padding(0);
     this.tblSearch.Name     = "tblSearch";
     this.tblSearch.RowCount = 1;
     this.tblSearch.RowStyles.Add(new System.Windows.Forms.RowStyle());
     this.tblSearch.Size     = new System.Drawing.Size(892, 33);
     this.tblSearch.TabIndex = 4;
     //
     // pictureBox1
     //
     this.pictureBox1.Image    = global::Rubik.Forms.Properties.Resources.FIND_TEXT;
     this.pictureBox1.Location = new System.Drawing.Point(20, 0);
     this.pictureBox1.Margin   = new System.Windows.Forms.Padding(0);
     this.pictureBox1.Name     = "pictureBox1";
     this.pictureBox1.Size     = new System.Drawing.Size(35, 29);
     this.pictureBox1.SizeMode = System.Windows.Forms.PictureBoxSizeMode.StretchImage;
     this.pictureBox1.TabIndex = 6;
     this.pictureBox1.TabStop  = false;
     //
     // txtSearch
     //
     this.txtSearch.AppearanceName         = "";
     this.txtSearch.AppearanceReadOnlyName = "";
     this.txtSearch.BackColor           = System.Drawing.Color.White;
     this.txtSearch.ControlID           = "";
     this.txtSearch.DisableRestrictChar = true;
     this.txtSearch.Dock         = System.Windows.Forms.DockStyle.Fill;
     this.txtSearch.Font         = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222)));
     this.txtSearch.ForeColor    = System.Drawing.Color.Black;
     this.txtSearch.HelpButton   = null;
     this.txtSearch.Location     = new System.Drawing.Point(58, 3);
     this.txtSearch.Name         = "txtSearch";
     this.txtSearch.PathString   = null;
     this.txtSearch.PathValue    = "";
     this.txtSearch.Size         = new System.Drawing.Size(831, 26);
     this.txtSearch.TabIndex     = 7;
     this.txtSearch.TabStop      = false;
     this.txtSearch.TextChanged += new System.EventHandler(this.txtSearch_TextChanged);
     this.txtSearch.KeyDown     += new System.Windows.Forms.KeyEventHandler(this.txtSearch_KeyDown);
     //
     // ctxMenu
     //
     this.ctxMenu.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
         this.miEdit,
         this.miDelete,
         this.miDeleteGroup
     });
     this.ctxMenu.Name = "ctxMenu";
     this.ctxMenu.Size = new System.Drawing.Size(138, 70);
     //
     // miEdit
     //
     this.miEdit.Name   = "miEdit";
     this.miEdit.Size   = new System.Drawing.Size(137, 22);
     this.miEdit.Text   = "Edit";
     this.miEdit.Click += new System.EventHandler(this.miEdit_Click);
     //
     // miDelete
     //
     this.miDelete.Name   = "miDelete";
     this.miDelete.Size   = new System.Drawing.Size(137, 22);
     this.miDelete.Text   = "Delete";
     this.miDelete.Click += new System.EventHandler(this.miDelete_Click);
     //
     // miDeleteGroup
     //
     this.miDeleteGroup.Name   = "miDeleteGroup";
     this.miDeleteGroup.Size   = new System.Drawing.Size(137, 22);
     this.miDeleteGroup.Text   = "Delete Group";
     this.miDeleteGroup.Click += new System.EventHandler(this.miDeleteGroup_Click);
     //
     // TRN010
     //
     this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
     this.ClientSize          = new System.Drawing.Size(892, 352);
     this.ExportObject        = this.fpView;
     this.Icon   = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
     this.Name   = "TRN010";
     this.Text   = "Receiving List";
     this.Load  += new System.EventHandler(this.TRN010_Load);
     this.Shown += new System.EventHandler(this.TRN010_Shown);
     this.Controls.SetChildIndex(this.pnlContainer, 0);
     this.pnlContainer.ResumeLayout(false);
     this.tableContainer.ResumeLayout(false);
     this.tableContainer.PerformLayout();
     this.pnlHeader.ResumeLayout(false);
     this.pnlHeader.PerformLayout();
     this.tableSearch.ResumeLayout(false);
     this.tableSearch.PerformLayout();
     ((System.ComponentModel.ISupportInitialize)(this.fpView)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.shtView)).EndInit();
     this.panSearch.ResumeLayout(false);
     this.tblSearch.ResumeLayout(false);
     this.tblSearch.PerformLayout();
     ((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).EndInit();
     this.ctxMenu.ResumeLayout(false);
     this.ResumeLayout(false);
     this.PerformLayout();
 }
コード例 #9
0
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     this.components = new System.ComponentModel.Container();
     System.ComponentModel.ComponentResourceManager resources         = new System.ComponentModel.ComponentResourceManager(typeof(TRN110));
     FarPoint.Win.Spread.CellType.CurrencyCellType  currencyCellType1 = new FarPoint.Win.Spread.CellType.CurrencyCellType();
     this.tsbExit       = new System.Windows.Forms.ToolStripButton();
     this.tsbNew        = new System.Windows.Forms.ToolStripButton();
     this.pictureBox1   = new System.Windows.Forms.PictureBox();
     this.txtSearch     = new EVOFramework.Windows.Forms.EVOTextBox();
     this.stcDash       = new EVOFramework.Windows.Forms.EVOLabel();
     this.stcPeriod     = new EVOFramework.Windows.Forms.EVOLabel();
     this.dtPeriodBegin = new EVOFramework.Windows.Forms.EVODateTextBoxWithCalendar();
     this.dtPeriodEnd   = new EVOFramework.Windows.Forms.EVODateTextBoxWithCalendar();
     this.stcHead       = new EVOFramework.Windows.Forms.EVOLabel();
     this.fpView        = new FarPoint.Win.Spread.FpSpread();
     this.shtView       = new FarPoint.Win.Spread.SheetView();
     this.dmcSearch     = new EVOFramework.Data.UIDataModelController(this.components);
     this.ctxMenu       = new System.Windows.Forms.ContextMenuStrip(this.components);
     this.miEdit        = new System.Windows.Forms.ToolStripMenuItem();
     this.miDelete      = new System.Windows.Forms.ToolStripMenuItem();
     this.tsbShowAll    = new System.Windows.Forms.ToolStripButton();
     this.tsbExport     = new System.Windows.Forms.ToolStripButton();
     this.pnlContainer.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.fpView)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.shtView)).BeginInit();
     this.ctxMenu.SuspendLayout();
     this.SuspendLayout();
     //
     // pnlContainer
     //
     this.pnlContainer.Controls.Add(this.txtSearch);
     this.pnlContainer.Controls.Add(this.pictureBox1);
     this.pnlContainer.Controls.Add(this.dtPeriodEnd);
     this.pnlContainer.Controls.Add(this.fpView);
     this.pnlContainer.Controls.Add(this.stcDash);
     this.pnlContainer.Controls.Add(this.stcHead);
     this.pnlContainer.Controls.Add(this.dtPeriodBegin);
     this.pnlContainer.Controls.Add(this.stcPeriod);
     this.pnlContainer.Font      = new System.Drawing.Font("Tahoma", 12F);
     this.pnlContainer.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))));
     this.pnlContainer.Size      = new System.Drawing.Size(857, 372);
     //
     // tsbExit
     //
     this.tsbExit.Alignment             = System.Windows.Forms.ToolStripItemAlignment.Right;
     this.tsbExit.Image                 = global::Rubik.Forms.Properties.Resources.CLOSE;
     this.tsbExit.ImageTransparentColor = System.Drawing.Color.Magenta;
     this.tsbExit.Margin                = new System.Windows.Forms.Padding(4, 2, 0, 2);
     this.tsbExit.Name    = "tsbExit";
     this.tsbExit.Padding = new System.Windows.Forms.Padding(2);
     this.tsbExit.Size    = new System.Drawing.Size(60, 24);
     this.tsbExit.Text    = "Close";
     //
     // tsbNew
     //
     this.tsbNew.Image = ((System.Drawing.Image)(resources.GetObject("tsbNew.Image")));
     this.tsbNew.ImageTransparentColor = System.Drawing.Color.Magenta;
     this.tsbNew.Margin  = new System.Windows.Forms.Padding(4, 2, 0, 2);
     this.tsbNew.Name    = "tsbNew";
     this.tsbNew.Padding = new System.Windows.Forms.Padding(2);
     this.tsbNew.Size    = new System.Drawing.Size(80, 24);
     this.tsbNew.Text    = "Add New";
     //
     // pictureBox1
     //
     this.pictureBox1.Image    = global::Rubik.Forms.Properties.Resources.FIND_TEXT;
     this.pictureBox1.Location = new System.Drawing.Point(20, 49);
     this.pictureBox1.Margin   = new System.Windows.Forms.Padding(0);
     this.pictureBox1.Name     = "pictureBox1";
     this.pictureBox1.Size     = new System.Drawing.Size(35, 29);
     this.pictureBox1.SizeMode = System.Windows.Forms.PictureBoxSizeMode.StretchImage;
     this.pictureBox1.TabIndex = 6;
     this.pictureBox1.TabStop  = false;
     //
     // txtSearch
     //
     this.txtSearch.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
                                                                   | System.Windows.Forms.AnchorStyles.Right)));
     this.txtSearch.AppearanceName         = "";
     this.txtSearch.AppearanceReadOnlyName = "";
     this.txtSearch.BackColor           = System.Drawing.Color.White;
     this.txtSearch.ControlID           = "";
     this.txtSearch.DisableRestrictChar = true;
     this.txtSearch.Font         = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222)));
     this.txtSearch.ForeColor    = System.Drawing.Color.Black;
     this.txtSearch.HelpButton   = null;
     this.txtSearch.Location     = new System.Drawing.Point(58, 52);
     this.txtSearch.Name         = "txtSearch";
     this.txtSearch.PathString   = null;
     this.txtSearch.PathValue    = "";
     this.txtSearch.Size         = new System.Drawing.Size(785, 26);
     this.txtSearch.TabIndex     = 7;
     this.txtSearch.TextChanged += new System.EventHandler(this.txtSearch_TextChanged);
     this.txtSearch.KeyDown     += new System.Windows.Forms.KeyEventHandler(this.txtSearch_KeyDown);
     //
     // stcDash
     //
     this.stcDash.Anchor         = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
     this.stcDash.AppearanceName = "";
     this.stcDash.AutoSize       = true;
     this.stcDash.ControlID      = "";
     this.stcDash.Location       = new System.Drawing.Point(643, 16);
     this.stcDash.Name           = "stcDash";
     this.stcDash.PathString     = null;
     this.stcDash.PathValue      = "-";
     this.stcDash.Size           = new System.Drawing.Size(15, 19);
     this.stcDash.TabIndex       = 1;
     this.stcDash.Text           = "-";
     this.stcDash.TextAlign      = System.Drawing.ContentAlignment.TopCenter;
     //
     // stcPeriod
     //
     this.stcPeriod.Anchor         = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
     this.stcPeriod.AppearanceName = "";
     this.stcPeriod.ControlID      = "";
     this.stcPeriod.Location       = new System.Drawing.Point(352, 16);
     this.stcPeriod.Name           = "stcPeriod";
     this.stcPeriod.PathString     = null;
     this.stcPeriod.PathValue      = "Adjust Date";
     this.stcPeriod.Size           = new System.Drawing.Size(100, 19);
     this.stcPeriod.TabIndex       = 0;
     this.stcPeriod.Text           = "Adjust Date";
     //
     // dtPeriodBegin
     //
     this.dtPeriodBegin.Anchor                 = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
     this.dtPeriodBegin.AppearanceName         = "";
     this.dtPeriodBegin.AppearanceReadOnlyName = "";
     this.dtPeriodBegin.BackColor              = System.Drawing.Color.Transparent;
     this.dtPeriodBegin.ControlID              = "";
     this.dtPeriodBegin.Format                 = "dd/MM/yyyy";
     this.dtPeriodBegin.Location               = new System.Drawing.Point(458, 15);
     this.dtPeriodBegin.MinimumSize            = new System.Drawing.Size(100, 0);
     this.dtPeriodBegin.Name       = "dtPeriodBegin";
     this.dtPeriodBegin.NZValue    = ((EVOFramework.NZDateTime)(resources.GetObject("dtPeriodBegin.NZValue")));
     this.dtPeriodBegin.PathString = null;
     this.dtPeriodBegin.PathValue  = ((object)(resources.GetObject("dtPeriodBegin.PathValue")));
     this.dtPeriodBegin.ReadOnly   = false;
     this.dtPeriodBegin.ShowButton = true;
     this.dtPeriodBegin.Size       = new System.Drawing.Size(179, 20);
     this.dtPeriodBegin.TabIndex   = 0;
     this.dtPeriodBegin.Value      = null;
     //
     // dtPeriodEnd
     //
     this.dtPeriodEnd.Anchor                 = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
     this.dtPeriodEnd.AppearanceName         = "";
     this.dtPeriodEnd.AppearanceReadOnlyName = "";
     this.dtPeriodEnd.BackColor              = System.Drawing.Color.Transparent;
     this.dtPeriodEnd.ControlID              = "";
     this.dtPeriodEnd.Format                 = "dd/MM/yyyy";
     this.dtPeriodEnd.Location               = new System.Drawing.Point(664, 15);
     this.dtPeriodEnd.MinimumSize            = new System.Drawing.Size(100, 0);
     this.dtPeriodEnd.Name       = "dtPeriodEnd";
     this.dtPeriodEnd.NZValue    = ((EVOFramework.NZDateTime)(resources.GetObject("dtPeriodEnd.NZValue")));
     this.dtPeriodEnd.PathString = null;
     this.dtPeriodEnd.PathValue  = ((object)(resources.GetObject("dtPeriodEnd.PathValue")));
     this.dtPeriodEnd.ReadOnly   = false;
     this.dtPeriodEnd.ShowButton = true;
     this.dtPeriodEnd.Size       = new System.Drawing.Size(179, 20);
     this.dtPeriodEnd.TabIndex   = 1;
     this.dtPeriodEnd.Value      = null;
     //
     // stcHead
     //
     this.stcHead.AppearanceName = "Title";
     this.stcHead.AutoSize       = true;
     this.stcHead.ControlID      = "";
     this.stcHead.Font           = new System.Drawing.Font("Tahoma", 20F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
     this.stcHead.Location       = new System.Drawing.Point(13, 9);
     this.stcHead.Margin         = new System.Windows.Forms.Padding(0, 0, 3, 0);
     this.stcHead.Name           = "stcHead";
     this.stcHead.PathString     = null;
     this.stcHead.PathValue      = "Adjust List";
     this.stcHead.Size           = new System.Drawing.Size(158, 33);
     this.stcHead.TabIndex       = 37;
     this.stcHead.Text           = "Adjust List";
     //
     // fpView
     //
     this.fpView.About = "2.5.2015.2005";
     this.fpView.AccessibleDescription = "fpView, Sheet1, Row 0, Column 0, ";
     this.fpView.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
                                                                 | System.Windows.Forms.AnchorStyles.Left)
                                                                | System.Windows.Forms.AnchorStyles.Right)));
     this.fpView.BackColor                 = System.Drawing.Color.AliceBlue;
     this.fpView.BorderStyle               = System.Windows.Forms.BorderStyle.FixedSingle;
     this.fpView.ColumnSplitBoxPolicy      = FarPoint.Win.Spread.SplitBoxPolicy.AsNeeded;
     this.fpView.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
     this.fpView.Location             = new System.Drawing.Point(12, 84);
     this.fpView.Name                 = "fpView";
     this.fpView.RightToLeft          = System.Windows.Forms.RightToLeft.No;
     this.fpView.RowSplitBoxPolicy    = FarPoint.Win.Spread.SplitBoxPolicy.AsNeeded;
     this.fpView.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Both;
     this.fpView.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] {
         this.shtView
     });
     this.fpView.Size                    = new System.Drawing.Size(831, 276);
     this.fpView.TabIndex                = 3;
     this.fpView.TabStop                 = false;
     this.fpView.TextTipDelay            = 1000;
     this.fpView.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
     this.fpView.CellDoubleClick        += new FarPoint.Win.Spread.CellClickEventHandler(this.fpView_CellDoubleClick);
     this.fpView.KeyDown                += new System.Windows.Forms.KeyEventHandler(this.fpView_KeyDown);
     this.fpView.KeyPress               += new System.Windows.Forms.KeyPressEventHandler(this.fpView_KeyPress);
     this.fpView.MouseDown              += new System.Windows.Forms.MouseEventHandler(this.fpView_MouseDown);
     //
     // shtView
     //
     this.shtView.Reset();
     this.shtView.SheetName = "Sheet1";
     // Formulas and custom names must be loaded with R1C1 reference style
     this.shtView.ReferenceStyle      = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
     this.shtView.ColumnCount         = 17;
     this.shtView.RowCount            = 0;
     this.shtView.AutoCalculation     = false;
     this.shtView.AutoGenerateColumns = false;
     this.shtView.ColumnHeader.Cells.Get(0, 0).Value  = "Adjust Date";
     this.shtView.ColumnHeader.Cells.Get(0, 1).Value  = "Trans ID";
     this.shtView.ColumnHeader.Cells.Get(0, 2).Value  = "Transaction No.";
     this.shtView.ColumnHeader.Cells.Get(0, 3).Value  = "Adjust Type";
     this.shtView.ColumnHeader.Cells.Get(0, 4).Value  = "Adjust Type Name";
     this.shtView.ColumnHeader.Cells.Get(0, 5).Value  = "M/N";
     this.shtView.ColumnHeader.Cells.Get(0, 6).Value  = "Part No.";
     this.shtView.ColumnHeader.Cells.Get(0, 7).Value  = "Customer Name";
     this.shtView.ColumnHeader.Cells.Get(0, 8).Value  = "Reason";
     this.shtView.ColumnHeader.Cells.Get(0, 9).Value  = "Reson Name";
     this.shtView.ColumnHeader.Cells.Get(0, 10).Value = "Qty";
     this.shtView.ColumnHeader.Cells.Get(0, 11).Value = "Pack No.";
     this.shtView.ColumnHeader.Cells.Get(0, 12).Value = "FG No.";
     this.shtView.ColumnHeader.Cells.Get(0, 13).Value = "Lot No.";
     this.shtView.ColumnHeader.Cells.Get(0, 14).Value = "Store Location";
     this.shtView.ColumnHeader.Cells.Get(0, 15).Value = "Store Location Name";
     this.shtView.ColumnHeader.Cells.Get(0, 16).Value = "Remark";
     this.shtView.ColumnHeader.Rows.Get(0).Height     = 40F;
     this.shtView.Columns.Get(0).AllowAutoFilter      = true;
     this.shtView.Columns.Get(0).AllowAutoSort        = true;
     this.shtView.Columns.Get(0).Label            = "Adjust Date";
     this.shtView.Columns.Get(0).Tag              = "Adjust Date";
     this.shtView.Columns.Get(0).Width            = 120F;
     this.shtView.Columns.Get(1).AllowAutoFilter  = true;
     this.shtView.Columns.Get(1).AllowAutoSort    = true;
     this.shtView.Columns.Get(1).Label            = "Trans ID";
     this.shtView.Columns.Get(1).Width            = 127F;
     this.shtView.Columns.Get(2).AllowAutoFilter  = true;
     this.shtView.Columns.Get(2).AllowAutoSort    = true;
     this.shtView.Columns.Get(2).Label            = "Transaction No.";
     this.shtView.Columns.Get(2).Locked           = true;
     this.shtView.Columns.Get(2).Tag              = "Transaction No.";
     this.shtView.Columns.Get(2).Width            = 149F;
     this.shtView.Columns.Get(3).AllowAutoFilter  = true;
     this.shtView.Columns.Get(3).AllowAutoSort    = true;
     this.shtView.Columns.Get(3).Label            = "Adjust Type";
     this.shtView.Columns.Get(3).Locked           = true;
     this.shtView.Columns.Get(3).Tag              = "Adjust Type";
     this.shtView.Columns.Get(3).Width            = 153F;
     this.shtView.Columns.Get(4).AllowAutoFilter  = true;
     this.shtView.Columns.Get(4).AllowAutoSort    = true;
     this.shtView.Columns.Get(4).Label            = "Adjust Type Name";
     this.shtView.Columns.Get(4).Width            = 157F;
     this.shtView.Columns.Get(5).AllowAutoFilter  = true;
     this.shtView.Columns.Get(5).AllowAutoSort    = true;
     this.shtView.Columns.Get(5).Label            = "M/N";
     this.shtView.Columns.Get(5).Tag              = "Master No.";
     this.shtView.Columns.Get(5).Width            = 151F;
     this.shtView.Columns.Get(6).AllowAutoFilter  = true;
     this.shtView.Columns.Get(6).AllowAutoSort    = true;
     this.shtView.Columns.Get(6).Label            = "Part No.";
     this.shtView.Columns.Get(6).Locked           = true;
     this.shtView.Columns.Get(6).Tag              = "Part No.";
     this.shtView.Columns.Get(6).Width            = 192F;
     this.shtView.Columns.Get(7).AllowAutoFilter  = true;
     this.shtView.Columns.Get(7).AllowAutoSort    = true;
     this.shtView.Columns.Get(7).Label            = "Customer Name";
     this.shtView.Columns.Get(7).Locked           = false;
     this.shtView.Columns.Get(7).Tag              = "Customer Name";
     this.shtView.Columns.Get(7).Width            = 201F;
     this.shtView.Columns.Get(8).AllowAutoFilter  = true;
     this.shtView.Columns.Get(8).AllowAutoSort    = true;
     this.shtView.Columns.Get(8).Label            = "Reason";
     this.shtView.Columns.Get(8).Tag              = "Reason";
     this.shtView.Columns.Get(8).Width            = 100F;
     this.shtView.Columns.Get(9).AllowAutoFilter  = true;
     this.shtView.Columns.Get(9).AllowAutoSort    = true;
     this.shtView.Columns.Get(9).Label            = "Reson Name";
     this.shtView.Columns.Get(9).Width            = 161F;
     this.shtView.Columns.Get(10).AllowAutoFilter = true;
     this.shtView.Columns.Get(10).AllowAutoSort   = true;
     currencyCellType1.DecimalPlaces              = 6;
     currencyCellType1.DecimalSeparator           = ".";
     currencyCellType1.FixedPoint   = false;
     currencyCellType1.MaximumValue = new decimal(new int[] {
         1874919423,
         2328306,
         0,
         393216
     });
     currencyCellType1.MinimumValue = new decimal(new int[] {
         0,
         0,
         0,
         0
     });
     currencyCellType1.ShowCurrencySymbol         = false;
     currencyCellType1.ShowSeparator              = true;
     this.shtView.Columns.Get(10).CellType        = currencyCellType1;
     this.shtView.Columns.Get(10).Label           = "Qty";
     this.shtView.Columns.Get(10).Locked          = true;
     this.shtView.Columns.Get(10).Tag             = "Qty";
     this.shtView.Columns.Get(10).Width           = 80F;
     this.shtView.Columns.Get(11).AllowAutoFilter = true;
     this.shtView.Columns.Get(11).AllowAutoSort   = true;
     this.shtView.Columns.Get(11).Label           = "Pack No.";
     this.shtView.Columns.Get(11).Tag             = "Pack No.";
     this.shtView.Columns.Get(11).Width           = 115F;
     this.shtView.Columns.Get(12).AllowAutoFilter = true;
     this.shtView.Columns.Get(12).AllowAutoSort   = true;
     this.shtView.Columns.Get(12).Label           = "FG No.";
     this.shtView.Columns.Get(12).Tag             = "FG No.";
     this.shtView.Columns.Get(12).Width           = 115F;
     this.shtView.Columns.Get(13).AllowAutoFilter = true;
     this.shtView.Columns.Get(13).AllowAutoSort   = true;
     this.shtView.Columns.Get(13).Label           = "Lot No.";
     this.shtView.Columns.Get(13).Locked          = true;
     this.shtView.Columns.Get(13).Tag             = "Lot No.";
     this.shtView.Columns.Get(13).Width           = 115F;
     this.shtView.Columns.Get(14).AllowAutoFilter = true;
     this.shtView.Columns.Get(14).AllowAutoSort   = true;
     this.shtView.Columns.Get(14).Label           = "Store Location";
     this.shtView.Columns.Get(14).Locked          = true;
     this.shtView.Columns.Get(14).Tag             = "StoreLoc";
     this.shtView.Columns.Get(14).Width           = 194F;
     this.shtView.Columns.Get(15).AllowAutoFilter = true;
     this.shtView.Columns.Get(15).AllowAutoSort   = true;
     this.shtView.Columns.Get(15).Label           = "Store Location Name";
     this.shtView.Columns.Get(15).Width           = 162F;
     this.shtView.Columns.Get(16).AllowAutoFilter = true;
     this.shtView.Columns.Get(16).AllowAutoSort   = true;
     this.shtView.Columns.Get(16).Label           = "Remark";
     this.shtView.Columns.Get(16).Locked          = true;
     this.shtView.Columns.Get(16).Tag             = "Remark";
     this.shtView.Columns.Get(16).Width           = 141F;
     this.shtView.DataAutoCellTypes   = false;
     this.shtView.DataAutoHeadings    = false;
     this.shtView.DataAutoSizeColumns = false;
     this.shtView.OperationMode       = FarPoint.Win.Spread.OperationMode.SingleSelect;
     this.shtView.RowHeader.Columns.Default.Resizable = true;
     this.shtView.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Single;
     this.shtView.SelectionUnit   = FarPoint.Win.Spread.Model.SelectionUnit.Row;
     this.shtView.ReferenceStyle  = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
     this.fpView.SetActiveViewport(0, 1, 0);
     //
     // ctxMenu
     //
     this.ctxMenu.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
         this.miEdit,
         this.miDelete
     });
     this.ctxMenu.Name = "ctxMenu";
     this.ctxMenu.Size = new System.Drawing.Size(106, 48);
     //
     // miEdit
     //
     this.miEdit.Name   = "miEdit";
     this.miEdit.Size   = new System.Drawing.Size(105, 22);
     this.miEdit.Text   = "Edit";
     this.miEdit.Click += new System.EventHandler(this.miEdit_Click);
     //
     // miDelete
     //
     this.miDelete.Name   = "miDelete";
     this.miDelete.Size   = new System.Drawing.Size(105, 22);
     this.miDelete.Text   = "Delete";
     this.miDelete.Click += new System.EventHandler(this.miDelete_Click);
     //
     // tsbShowAll
     //
     this.tsbShowAll.Image = ((System.Drawing.Image)(resources.GetObject("tsbShowAll.Image")));
     this.tsbShowAll.ImageTransparentColor = System.Drawing.Color.Magenta;
     this.tsbShowAll.Name = "tsbShowAll";
     this.tsbShowAll.Size = new System.Drawing.Size(73, 25);
     this.tsbShowAll.Text = "Show All";
     //
     // tsbExport
     //
     this.tsbExport.Image = ((System.Drawing.Image)(resources.GetObject("tsbExport.Image")));
     this.tsbExport.ImageTransparentColor = System.Drawing.Color.Magenta;
     this.tsbExport.Name = "tsbExport";
     this.tsbExport.Size = new System.Drawing.Size(60, 25);
     this.tsbExport.Text = "Export";
     //
     // TRN110
     //
     this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.None;
     this.AutoSize      = true;
     this.ClientSize    = new System.Drawing.Size(857, 397);
     this.ExportObject  = this.fpView;
     this.Icon          = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
     this.MinimumSize   = new System.Drawing.Size(700, 350);
     this.Name          = "TRN110";
     this.Text          = "Adjust List";
     this.Load         += new System.EventHandler(this.TRN110_Load);
     this.Shown        += new System.EventHandler(this.TRN110_Shown);
     this.Controls.SetChildIndex(this.pnlContainer, 0);
     this.pnlContainer.ResumeLayout(false);
     this.pnlContainer.PerformLayout();
     ((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.fpView)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.shtView)).EndInit();
     this.ctxMenu.ResumeLayout(false);
     this.ResumeLayout(false);
     this.PerformLayout();
 }
コード例 #10
0
        private void setGrdViewH()
        {
            FarPoint.Win.Spread.EnhancedInterfaceRenderer outlinelook = new FarPoint.Win.Spread.EnhancedInterfaceRenderer();
            outlinelook.RangeGroupBackgroundColor   = Color.LightGreen;
            outlinelook.RangeGroupButtonBorderColor = Color.Red;
            outlinelook.RangeGroupLineColor         = Color.Blue;
            grdView.InterfaceRenderer = outlinelook;

            grdView.BorderStyle = BorderStyle.None;
            grdView.Sheets[0].Columns[0, 2].AllowAutoFilter = true;
            grdView.Sheets[0].Columns[0, 2].AllowAutoSort   = true;
            grdView.Sheets[0].AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.EnhancedContextMenu;

            FarPoint.Win.Spread.CellType.NumberCellType objNumCell = new FarPoint.Win.Spread.CellType.NumberCellType();
            objNumCell.DecimalPlaces = 0;
            objNumCell.MinimumValue  = 1;
            objNumCell.MaximumValue  = 9999;
            objNumCell.ShowSeparator = false;

            FarPoint.Win.Spread.CellType.DateTimeCellType datecell = new FarPoint.Win.Spread.CellType.DateTimeCellType();
            datecell.DateSeparator  = " | ";
            datecell.TimeSeparator  = ".";
            datecell.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDateWithTime;

            FarPoint.Win.Spread.CellType.CurrencyCellType ctest       = new FarPoint.Win.Spread.CellType.CurrencyCellType();
            FarPoint.Win.Spread.CellType.TextCellType     objTextCell = new FarPoint.Win.Spread.CellType.TextCellType();

            ctest.SetCalculatorText("Accept", "Cancel");

            //grdView.sheet
            grdView.Sheets.Count          = 2;
            grdView.Height                = 330;
            grdView.Width                 = 765;
            grdView.Sheets[0].SheetName   = "Drug Catalogue";
            grdView.Sheets[1].SheetName   = "นำเข้า";
            grdView.Sheets[0].ColumnCount = 21;
            grdView.Sheets[0].RowCount    = 1;
            grdView.Sheets[1].RowCount    = 1;

            grdView.Sheets[0].ColumnHeader.Cells[0, colCode].Text = "hospdrugcode";
            grdView.Sheets[0].ColumnHeader.Cells[0, colProd].Text = "productcat";
            grdView.Sheets[0].ColumnHeader.Cells[0, colTmt].Text  = "tmtid";
            grdView.Sheets[0].ColumnHeader.Cells[0, colSpec].Text = "specprep";
            grdView.Sheets[0].ColumnHeader.Cells[0, colGene].Text = "genericname";
            grdView.Sheets[0].ColumnHeader.Cells[0, colTrad].Text = "tradename";
            grdView.Sheets[0].ColumnHeader.Cells[0, colDfs].Text  = "dfscode";
            grdView.Sheets[0].ColumnHeader.Cells[0, colDos].Text  = "dosageform";
            grdView.Sheets[0].ColumnHeader.Cells[0, colStr].Text  = "strength";
            grdView.Sheets[0].ColumnHeader.Cells[0, colCont].Text = "content1";

            grdView.Sheets[0].ColumnHeader.Cells[0, colDist].Text  = "distributor";
            grdView.Sheets[0].ColumnHeader.Cells[0, colManu].Text  = "manufactrer";
            grdView.Sheets[0].ColumnHeader.Cells[0, colIsed].Text  = "ised";
            grdView.Sheets[0].ColumnHeader.Cells[0, colNdc].Text   = "ndc24";
            grdView.Sheets[0].ColumnHeader.Cells[0, colUnitS].Text = "unitsize";
            grdView.Sheets[0].ColumnHeader.Cells[0, colUnitP].Text = "unitprice";
            grdView.Sheets[0].ColumnHeader.Cells[0, colUpF].Text   = "updateflag";
            grdView.Sheets[0].ColumnHeader.Cells[0, colDatC].Text  = "datechange";
            grdView.Sheets[0].ColumnHeader.Cells[0, colDatU].Text  = "dateupdate";
            grdView.Sheets[0].ColumnHeader.Cells[0, colDatE].Text  = "dateeffect";

            grdView.Sheets[0].ColumnHeader.Cells[0, colID].Text = "drugcat_id";
            //grdView.Sheets[0].ColumnHeader.Cells[0, 0].Text = "hospdrugcode";

            grdView.Sheets[0].Columns[colID].Visible = false;

            grdView.Sheets[0].Columns[colCode].Width = 120;
            grdView.Sheets[0].Columns[colProd].Width = 120;
            grdView.Sheets[0].Columns[colTmt].Width  = 80;
            grdView.Sheets[0].Columns[colSpec].Width = 80;
            grdView.Sheets[0].Columns[colGene].Width = 250;
            grdView.Sheets[0].Columns[colTrad].Width = 250;
            grdView.Sheets[0].Columns[colDfs].Width  = 80;
            grdView.Sheets[0].Columns[colDos].Width  = 250;
            grdView.Sheets[0].Columns[colStr].Width  = 250;
            grdView.Sheets[0].Columns[colCont].Width = 250;

            grdView.Sheets[0].Columns[colDist].Width  = 80;
            grdView.Sheets[0].Columns[colManu].Width  = 250;
            grdView.Sheets[0].Columns[colIsed].Width  = 80;
            grdView.Sheets[0].Columns[colNdc].Width   = 80;
            grdView.Sheets[0].Columns[colUnitS].Width = 80;
            grdView.Sheets[0].Columns[colUnitP].Width = 80;
            grdView.Sheets[0].Columns[colUpF].Width   = 80;
            grdView.Sheets[0].Columns[colDatC].Width  = 140;
            grdView.Sheets[0].Columns[colDatU].Width  = 140;
            grdView.Sheets[0].Columns[colDatE].Width  = 140;


            grdView.Sheets[0].Columns[colCode].CellType = objTextCell;
            grdView.Sheets[0].Columns[colProd].CellType = objTextCell;
            grdView.Sheets[0].Columns[colTmt].CellType  = objTextCell;
            grdView.Sheets[0].Columns[colSpec].CellType = objTextCell;
            grdView.Sheets[0].Columns[colGene].CellType = objTextCell;
            grdView.Sheets[0].Columns[colTrad].CellType = objTextCell;
            grdView.Sheets[0].Columns[colDfs].CellType  = objTextCell;
            grdView.Sheets[0].Columns[colDos].CellType  = objTextCell;
            grdView.Sheets[0].Columns[colStr].CellType  = objTextCell;
            grdView.Sheets[0].Columns[colCont].CellType = objTextCell;

            grdView.Sheets[0].Columns[colDist].CellType  = objTextCell;
            grdView.Sheets[0].Columns[colManu].CellType  = objTextCell;
            grdView.Sheets[0].Columns[colIsed].CellType  = objTextCell;
            grdView.Sheets[0].Columns[colNdc].CellType   = objTextCell;
            grdView.Sheets[0].Columns[colUnitS].CellType = objTextCell;
            grdView.Sheets[0].Columns[colUnitP].CellType = objTextCell;
            grdView.Sheets[0].Columns[colUpF].CellType   = objTextCell;
            grdView.Sheets[0].Columns[colDatC].CellType  = objTextCell;
            grdView.Sheets[0].Columns[colDatU].CellType  = objTextCell;
            grdView.Sheets[0].Columns[colDatE].CellType  = objTextCell;
        }