private void PaintGrdView() { //FarPoint.Win.Spread.Cell aCell; GrdView.Visible = false; Int16 liRow = 6; GrdView.ActiveSheet.RowCount = 0; GrdView.ActiveSheet.ColumnCount = 3; GrdView.Height = 682; GrdView.Width = 1017; GrdView.ActiveSheet.SetColumnWidth(0, 350); GrdView.ActiveSheet.SetColumnWidth(1, 605); FarPoint.Win.Spread.CellType.ImageCellType cellPic = new FarPoint.Win.Spread.CellType.ImageCellType(); cellPic.Style = FarPoint.Win.RenderStyle.Stretch; GrdView.Sheets[0].Columns[0].CellType = cellPic; FarPoint.Win.Spread.CellType.TextCellType cellText = new FarPoint.Win.Spread.CellType.TextCellType(); GrdView.Sheets[0].Columns[1].CellType = cellText; GrdView.ActiveSheet.SetColumnLabel(0, 0, "Hotel"); GrdView.ActiveSheet.SetColumnLabel(0, 1, "Description"); GrdView.ActiveSheet.SetColumnVisible(2, false); GrdView.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Off; GrdView.Sheets[0].RowHeader.Visible = false; GrdView.Sheets[0].ColumnHeader.Visible = false; GrdView.BorderStyle = BorderStyle.None; GrdView.Visible = true; }
/// <summary> /// 根据数据,给出对应的显示 /// </summary> /// <param name="cell"></param> /// <param name="value"></param> public static void setCellImg(FarPoint.Win.Spread.Cell cell, int value) { cell.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; cell.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; FarPoint.Win.Spread.CellType.ImageCellType imageCell = new FarPoint.Win.Spread.CellType.ImageCellType(); imageCell.Style = FarPoint.Win.RenderStyle.Normal; cell.CellType = imageCell; if (value == (int)WarningResult.YELLOW) { cell.Value = _pngOrange; } else if (value == (int)WarningResult.RED) { cell.Value = _pngRed; } else if (value == (int)WarningResult.GREEN) { cell.Value = _pngGreen; } else if (value == (int)WarningResult.NOT_AVAILABLE) { cell.Value = _pngGreen; } else { cell.Value = _pngGreen; } }
private void PaintGrdView() { //FarPoint.Win.Spread.Cell aCell; GrdView.Visible = false; PicView.Height = this.Height - 10; PicView.Width = this.Width - 220; PicView.Top = this.Top + 5; PicView.Left = this.Left + 5; GrdView.Left = this.Width - 190; GrdView.Top = PicView.Top; GrdView.Height = PicView.Height; GrdView.ActiveSheet.RowCount = 20; GrdView.ActiveSheet.ColumnCount = 2; FarPoint.Win.Spread.CellType.TextCellType cellText = new FarPoint.Win.Spread.CellType.TextCellType(); GrdView.Sheets[0].Columns[0].CellType = cellText; FarPoint.Win.Spread.CellType.ImageCellType cellPic = new FarPoint.Win.Spread.CellType.ImageCellType(); cellPic.Style = FarPoint.Win.RenderStyle.Stretch; GrdView.Sheets[0].Columns[1].CellType = cellPic; GrdView.ActiveSheet.SetColumnLabel(0, 0, " "); GrdView.ActiveSheet.SetColumnWidth(1, 185); GrdView.Sheets[0].SetRowHeight(1, 145); GrdView.Width = 185; GrdView.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Off; GrdView.BorderStyle = BorderStyle.None; GrdView.Sheets[0].RowHeader.Visible = false; GrdView.Sheets[0].ColumnHeader.Visible = false; GrdView.Sheets[0].Columns[0].Visible = false; //GrdView .setr GrdView.Visible = true; }
/// <summary> /// 엑셀로 출력 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void UiPb_SaveExcel_Click(object sender, EventArgs e) { string date = DateTime.Now.ToString("yyyyMMdd_HHmmss"); string fileName = $"BeomBeomJoJo_RTMS_{date}.xls"; string ext = ".xls"; string filter = "Microsoft Excel Workbook (*.xls)|*.xls"; using (SaveFileDialog saveFileDialog = Function.GetExcelSaveFileDialog(fileName, ext, filter)) { if (saveFileDialog.ShowDialog(this) == DialogResult.OK) { this.Cursor = Cursors.WaitCursor; FarPoint.Win.Spread.FpSpread fs = new FarPoint.Win.Spread.FpSpread(); fs.Sheets.Count = uiTab_Main.Controls.Count; FarPoint.Win.Spread.CellType.ImageCellType imgCell = new FarPoint.Win.Spread.CellType.ImageCellType(); imgCell.Style = FarPoint.Win.RenderStyle.Stretch; for (int row = 0; row < uiTab_Main.Controls.Count; ++row) { UI.MainUi ui = uiTab_Main.TabPages[row].Controls[0] as UI.MainUi; fs.Sheets[row].Columns.Count = 1; fs.Sheets[row].Columns[0].CellType = imgCell; fs.Sheets.Add(ui); if (ui == null) { continue; } using (Graphics g = ui.CreateGraphics()) { Bitmap memBitMap = new Bitmap(ui.Width, ui.Height); ui.DrawToBitmap(memBitMap, new Rectangle(0, 0, ui.Width, ui.Height)); g.DrawImageUnscaled(memBitMap, 0, 0); fs.Sheets[row].Rows.Count = 1; fs.Sheets[row].Columns[0].Width = 1500; fs.Sheets[row].Rows[0].Height = 800; fs.Sheets[row].Cells[0, 0].Value = memBitMap.Clone(); memBitMap.Dispose(); } fs.Sheets[row].SheetName = ui.RItem; } if (Function.ExportExcelFile(saveFileDialog.FileName, fs) == true) { JKMessageBox.ShowExcel(this, saveFileDialog.FileName); } this.Cursor = Cursors.Default; } } }
/// <summary> /// 设置列的类型 /// </summary> private void InitColumnsType() { FarPoint.Win.Spread.CellType.ImageCellType imageCellType = new FarPoint.Win.Spread.CellType.ImageCellType(); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType2 = new FarPoint.Win.Spread.CellType.DateTimeCellType(); this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 0).CellType = imageCellType; this.fpSpread1_Sheet1.Columns.Get(0).CellType = imageCellType; this.fpSpread1_Sheet1.Columns.Get(3).CellType = dateTimeCellType2; dateTimeCellType2.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDateWithTime; }
private void InitSheetProgram(FarPoint.Win.Spread.FpSpread spreadProgram) { FarPoint.Win.Spread.FpSpread spread = spreadProgram; spread.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; spread.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; spread.CellClick += SpreadProgram_CellClick; FarPoint.Win.Spread.SheetView sheet = spread.Sheets[0]; sheet.DefaultStyle.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; sheet.DefaultStyle.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; sheet.Rows.Count = 0; sheet.Columns.Count = Enum.GetNames(typeof(E_PROGRAM)).Length; sheet.ColumnHeader.Rows[0].Height = 35; sheet.ColumnHeader.Cells[0, (int)E_PROGRAM.PR_ID].Value = "ID"; sheet.ColumnHeader.Cells[0, (int)E_PROGRAM.PR_ICON].Value = "ICON"; sheet.ColumnHeader.Cells[0, (int)E_PROGRAM.PR_NAME].Value = "NAME"; sheet.ColumnHeader.Cells[0, (int)E_PROGRAM.CHECK].Value = "CHECK"; sheet.Columns[(int)E_PROGRAM.PR_ICON].Width = 80; sheet.Columns[(int)E_PROGRAM.CHECK].Width = 80; sheet.Columns[(int)E_PROGRAM.PR_ID].Visible = false; sheet.Columns.Default.Width = 160; FarPoint.Win.Spread.CellType.ImageCellType imagecell = new FarPoint.Win.Spread.CellType.ImageCellType() { Style = FarPoint.Win.RenderStyle.StretchAndScale, TransparencyColor = Color.Transparent }; sheet.Columns[(int)E_PROGRAM.PR_ICON].CellType = imagecell; FarPoint.Win.Spread.CellType.CheckBoxCellType cbCellType = new FarPoint.Win.Spread.CellType.CheckBoxCellType(); sheet.ColumnHeader.Cells[0, (int)E_PROGRAM.CHECK].CellType = cbCellType; sheet.Columns[(int)E_PROGRAM.CHECK].CellType = cbCellType; }
/// <summary> /// 设计器支持所需的方法 - 不要 /// 使用代码编辑器修改此方法的内容。 /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ucMessage)); FarPoint.Win.Spread.TipAppearance tipAppearance1 = new FarPoint.Win.Spread.TipAppearance(); FarPoint.Win.Spread.CellType.ImageCellType imageCellType1 = new FarPoint.Win.Spread.CellType.ImageCellType(); FarPoint.Win.Spread.CellType.ImageCellType imageCellType2 = new FarPoint.Win.Spread.CellType.ImageCellType(); FarPoint.Win.Spread.CellType.ImageCellType imageCellType3 = new FarPoint.Win.Spread.CellType.ImageCellType(); FarPoint.Win.Spread.CellType.ImageCellType imageCellType4 = new FarPoint.Win.Spread.CellType.ImageCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType1 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.DateTimeCellType dateTimeCellType1 = new FarPoint.Win.Spread.CellType.DateTimeCellType(); this.panel1 = new System.Windows.Forms.Panel(); this.neuComboBox1 = new Neusoft.FrameWork.WinForms.Controls.NeuComboBox(this.components); this.button4 = new System.Windows.Forms.Button(); this.button3 = new System.Windows.Forms.Button(); this.button2 = new System.Windows.Forms.Button(); this.button1 = new System.Windows.Forms.Button(); this.fpSpread1 = new FarPoint.Win.Spread.FpSpread(); this.fpSpread1_Sheet1 = new FarPoint.Win.Spread.SheetView(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).BeginInit(); this.SuspendLayout(); // // panel1 // this.panel1.BackColor = System.Drawing.SystemColors.GradientInactiveCaption; this.panel1.Controls.Add(this.neuComboBox1); this.panel1.Controls.Add(this.button4); this.panel1.Controls.Add(this.button3); this.panel1.Controls.Add(this.button2); this.panel1.Controls.Add(this.button1); this.panel1.Dock = System.Windows.Forms.DockStyle.Top; this.panel1.Location = new System.Drawing.Point(0, 0); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(519, 50); this.panel1.TabIndex = 0; // // neuComboBox1 // this.neuComboBox1.ArrowBackColor = System.Drawing.Color.Silver; this.neuComboBox1.FormattingEnabled = true; this.neuComboBox1.IsEnter2Tab = false; this.neuComboBox1.IsFlat = true; this.neuComboBox1.IsLike = true; this.neuComboBox1.Location = new System.Drawing.Point(202, 29); this.neuComboBox1.Name = "neuComboBox1"; this.neuComboBox1.PopForm = null; this.neuComboBox1.ShowCustomerList = false; this.neuComboBox1.ShowID = false; this.neuComboBox1.Size = new System.Drawing.Size(84, 20); this.neuComboBox1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Flat; this.neuComboBox1.TabIndex = 4; this.neuComboBox1.Tag = ""; this.neuComboBox1.ToolBarUse = false; this.neuComboBox1.SelectedIndexChanged += new System.EventHandler(this.neuComboBox1_SelectedIndexChanged); // // button4 // this.button4.Image = global::Neusoft.HISFC.Components.Message.Properties.Resources.delete; this.button4.Location = new System.Drawing.Point(151, 0); this.button4.Name = "button4"; this.button4.Size = new System.Drawing.Size(52, 52); this.button4.TabIndex = 3; this.button4.UseVisualStyleBackColor = true; this.button4.Click += new System.EventHandler(this.button4_Click); // // button3 // this.button3.BackColor = System.Drawing.SystemColors.ControlLightLight; this.button3.Image = ((System.Drawing.Image)(resources.GetObject("button3.Image"))); this.button3.Location = new System.Drawing.Point(101, 0); this.button3.Name = "button3"; this.button3.Size = new System.Drawing.Size(52, 52); this.button3.TabIndex = 2; this.button3.Text = " "; this.button3.UseVisualStyleBackColor = false; this.button3.Click += new System.EventHandler(this.button3_Click); // // button2 // this.button2.BackColor = System.Drawing.SystemColors.ControlLightLight; this.button2.Image = global::Neusoft.HISFC.Components.Message.Properties.Resources.receive; this.button2.Location = new System.Drawing.Point(51, 0); this.button2.Name = "button2"; this.button2.Size = new System.Drawing.Size(52, 52); this.button2.TabIndex = 1; this.button2.Text = " "; this.button2.UseVisualStyleBackColor = false; this.button2.Click += new System.EventHandler(this.button2_Click); // // button1 // this.button1.BackColor = System.Drawing.SystemColors.ControlLightLight; this.button1.Image = global::Neusoft.HISFC.Components.Message.Properties.Resources.write; this.button1.Location = new System.Drawing.Point(1, -1); this.button1.Name = "button1"; this.button1.Size = new System.Drawing.Size(52, 52); this.button1.TabIndex = 0; this.button1.Text = " "; this.button1.UseVisualStyleBackColor = false; this.button1.Click += new System.EventHandler(this.button1_Click); // // fpSpread1 // this.fpSpread1.About = "2.5.2007.2005"; this.fpSpread1.AccessibleDescription = "fpSpread1, Sheet1, Row 0, Column 0, "; this.fpSpread1.BackColor = System.Drawing.SystemColors.Control; this.fpSpread1.Dock = System.Windows.Forms.DockStyle.Fill; this.fpSpread1.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.fpSpread1.Location = new System.Drawing.Point(0, 50); this.fpSpread1.Name = "fpSpread1"; this.fpSpread1.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] { this.fpSpread1_Sheet1 }); this.fpSpread1.Size = new System.Drawing.Size(519, 283); this.fpSpread1.TabIndex = 1; tipAppearance1.BackColor = System.Drawing.SystemColors.Info; tipAppearance1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); tipAppearance1.ForeColor = System.Drawing.SystemColors.InfoText; this.fpSpread1.TextTipAppearance = tipAppearance1; this.fpSpread1.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.fpSpread1.CellDoubleClick += new FarPoint.Win.Spread.CellClickEventHandler(this.fpSpread1_CellDoubleClick); // // fpSpread1_Sheet1 // this.fpSpread1_Sheet1.Reset(); this.fpSpread1_Sheet1.SheetName = "Sheet1"; // Formulas and custom names must be loaded with R1C1 reference style this.fpSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.fpSpread1_Sheet1.ColumnCount = 7; this.fpSpread1_Sheet1.RowCount = 10; this.fpSpread1_Sheet1.ActiveSkin = new FarPoint.Win.Spread.SheetSkin("CustomSkin1", System.Drawing.SystemColors.HighlightText, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.LightGray, FarPoint.Win.Spread.GridLines.Both, System.Drawing.SystemColors.GradientInactiveCaption, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, System.Drawing.Color.Empty, false, false, false, true, true); imageCellType1.Style = FarPoint.Win.RenderStyle.Normal; imageCellType1.TransparencyColor = System.Drawing.Color.Empty; imageCellType1.TransparencyTolerance = 0; this.fpSpread1_Sheet1.Cells.Get(1, 0).CellType = imageCellType1; imageCellType2.Style = FarPoint.Win.RenderStyle.Normal; imageCellType2.TransparencyColor = System.Drawing.Color.Empty; imageCellType2.TransparencyTolerance = 0; this.fpSpread1_Sheet1.Cells.Get(2, 0).CellType = imageCellType2; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 0).BackColor = System.Drawing.SystemColors.GradientInactiveCaption; imageCellType3.Style = FarPoint.Win.RenderStyle.Normal; imageCellType3.TransparencyColor = System.Drawing.Color.Empty; imageCellType3.TransparencyTolerance = 0; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 0).CellType = imageCellType3; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 0).Value = " "; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 1).BackColor = System.Drawing.SystemColors.GradientInactiveCaption; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 2).BackColor = System.Drawing.SystemColors.GradientInactiveCaption; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 3).BackColor = System.Drawing.SystemColors.GradientInactiveCaption; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 4).BackColor = System.Drawing.SystemColors.GradientInactiveCaption; this.fpSpread1_Sheet1.ColumnHeader.DefaultStyle.BackColor = System.Drawing.SystemColors.GradientInactiveCaption; this.fpSpread1_Sheet1.ColumnHeader.DefaultStyle.Locked = false; this.fpSpread1_Sheet1.ColumnHeader.DefaultStyle.Parent = "HeaderDefault"; imageCellType4.Style = FarPoint.Win.RenderStyle.Stretch; imageCellType4.TransparencyColor = System.Drawing.Color.Empty; imageCellType4.TransparencyTolerance = 0; this.fpSpread1_Sheet1.Columns.Get(0).CellType = imageCellType4; this.fpSpread1_Sheet1.Columns.Get(0).Label = " "; this.fpSpread1_Sheet1.Columns.Get(0).Width = 17F; this.fpSpread1_Sheet1.Columns.Get(1).Width = 77F; this.fpSpread1_Sheet1.Columns.Get(2).CellType = textCellType1; this.fpSpread1_Sheet1.Columns.Get(2).Width = 164F; dateTimeCellType1.Calendar = ((System.Globalization.Calendar)(resources.GetObject("dateTimeCellType1.Calendar"))); dateTimeCellType1.DateDefault = new System.DateTime(2008, 4, 11, 12, 19, 23, 0); dateTimeCellType1.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.LongDateWithTime; dateTimeCellType1.TimeDefault = new System.DateTime(2008, 4, 11, 12, 19, 23, 0); this.fpSpread1_Sheet1.Columns.Get(3).CellType = dateTimeCellType1; this.fpSpread1_Sheet1.Columns.Get(3).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left; this.fpSpread1_Sheet1.Columns.Get(3).Width = 141F; this.fpSpread1_Sheet1.Columns.Get(4).Width = 59F; this.fpSpread1_Sheet1.Columns.Get(5).Visible = false; this.fpSpread1_Sheet1.Columns.Get(6).Visible = false; this.fpSpread1_Sheet1.OperationMode = FarPoint.Win.Spread.OperationMode.SingleSelect; this.fpSpread1_Sheet1.RowHeader.Columns.Default.Resizable = false; this.fpSpread1_Sheet1.RowHeader.DefaultStyle.BackColor = System.Drawing.SystemColors.GradientInactiveCaption; this.fpSpread1_Sheet1.RowHeader.DefaultStyle.Locked = false; this.fpSpread1_Sheet1.RowHeader.DefaultStyle.Parent = "HeaderDefault"; this.fpSpread1_Sheet1.Rows.Get(0).Height = 19F; this.fpSpread1_Sheet1.Rows.Get(2).Height = 21F; this.fpSpread1_Sheet1.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Single; this.fpSpread1_Sheet1.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Row; this.fpSpread1_Sheet1.SheetCornerStyle.BackColor = System.Drawing.SystemColors.GradientInactiveCaption; this.fpSpread1_Sheet1.SheetCornerStyle.Locked = false; this.fpSpread1_Sheet1.SheetCornerStyle.Parent = "HeaderDefault"; this.fpSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1; // // ucMessage // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.Controls.Add(this.fpSpread1); this.Controls.Add(this.panel1); this.Name = "ucMessage"; this.Size = new System.Drawing.Size(519, 333); this.Load += new System.EventHandler(this.ucMessage_Load); this.panel1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).EndInit(); this.ResumeLayout(false); }
/// <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); }
/// <summary> /// 设计器支持所需的方法 - 不要 /// 使用代码编辑器修改此方法的内容。 /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ucSysGroupMenuManager)); FarPoint.Win.Spread.TipAppearance tipAppearance1 = new FarPoint.Win.Spread.TipAppearance(); System.Windows.Forms.ListViewItem listViewItem1 = new System.Windows.Forms.ListViewItem("", 0); FarPoint.Win.Spread.TipAppearance tipAppearance2 = new FarPoint.Win.Spread.TipAppearance(); 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.TextCellType textCellType4 = new FarPoint.Win.Spread.CellType.TextCellType(); 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.TextCellType textCellType5 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.ImageCellType imageCellType1 = new FarPoint.Win.Spread.CellType.ImageCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType6 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType7 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType8 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.TextCellType textCellType9 = new FarPoint.Win.Spread.CellType.TextCellType(); FarPoint.Win.Spread.CellType.ComboBoxCellType comboBoxCellType2 = new FarPoint.Win.Spread.CellType.ComboBoxCellType(); this.panel1 = new Neusoft.FrameWork.WinForms.Controls.NeuPanel(); this.imageList = new System.Windows.Forms.ImageList(this.components); this.panelMain = new Neusoft.FrameWork.WinForms.Controls.NeuPanel(); this.tabControl1 = new Neusoft.FrameWork.WinForms.Controls.NeuTabControl(); this.tabPage1 = new System.Windows.Forms.TabPage(); this.lnkMenuDelete = new Neusoft.FrameWork.WinForms.Controls.NeuLinkLabel(); this.lnkMenuSave = new Neusoft.FrameWork.WinForms.Controls.NeuLinkLabel(); this.lnkMenuAdd = new Neusoft.FrameWork.WinForms.Controls.NeuLinkLabel(); this.lnkDown1 = new Neusoft.FrameWork.WinForms.Controls.NeuLinkLabel(); this.lnkUp1 = new Neusoft.FrameWork.WinForms.Controls.NeuLinkLabel(); this.fpSpread1 = new FarPoint.Win.Spread.FpSpread(); this.lnkDelete = new Neusoft.FrameWork.WinForms.Controls.NeuLinkLabel(); this.lblModify = new Neusoft.FrameWork.WinForms.Controls.NeuLinkLabel(); this.lnkAdd = new Neusoft.FrameWork.WinForms.Controls.NeuLinkLabel(); this.lnkDown = new Neusoft.FrameWork.WinForms.Controls.NeuLinkLabel(); this.lnkUp = new Neusoft.FrameWork.WinForms.Controls.NeuLinkLabel(); this.lsvMainMenu = new Neusoft.FrameWork.WinForms.Controls.NeuListView(); this.tabPage2 = new System.Windows.Forms.TabPage(); this.fpSpread2 = new FarPoint.Win.Spread.FpSpread(); this.neuPanel1 = new Neusoft.FrameWork.WinForms.Controls.NeuPanel(); this.lnkConstDel = new Neusoft.FrameWork.WinForms.Controls.NeuLinkLabel(); this.lnkConstSave = new Neusoft.FrameWork.WinForms.Controls.NeuLinkLabel(); this.lnkConstAdd = new Neusoft.FrameWork.WinForms.Controls.NeuLinkLabel(); this.tabPage3 = new System.Windows.Forms.TabPage(); this.tabPage4 = new System.Windows.Forms.TabPage(); this.lsvPerson = new Neusoft.FrameWork.WinForms.Controls.NeuListView(); this.neuSplitter1 = new Neusoft.FrameWork.WinForms.Controls.NeuSplitter(); this.neuContextMenuStrip1 = new Neusoft.FrameWork.WinForms.Controls.NeuContextMenuStrip(); this.sQL语句维护ToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); this.fpSpread1_Sheet1 = new FarPoint.Win.Spread.SheetView(); this.fpSpread2_Sheet1 = new FarPoint.Win.Spread.SheetView(); this.treeView1 = new Manager.Controls.tvGroup(); this.panel1.SuspendLayout(); this.panelMain.SuspendLayout(); this.tabControl1.SuspendLayout(); this.tabPage1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).BeginInit(); this.tabPage2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread2)).BeginInit(); this.neuPanel1.SuspendLayout(); this.tabPage4.SuspendLayout(); this.neuContextMenuStrip1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread2_Sheet1)).BeginInit(); this.SuspendLayout(); // // panel1 // this.panel1.Controls.Add(this.treeView1); this.panel1.Dock = System.Windows.Forms.DockStyle.Left; this.panel1.Location = new System.Drawing.Point(0, 0); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(200, 471); this.panel1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.panel1.TabIndex = 0; // // imageList // this.imageList.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imageList.ImageStream"))); this.imageList.TransparentColor = System.Drawing.Color.Transparent; this.imageList.Images.SetKeyName(0, "G2 Folder Blue.ico"); this.imageList.Images.SetKeyName(1, "G2 Folder Grey.ico"); this.imageList.Images.SetKeyName(2, "hourse.bmp"); this.imageList.Images.SetKeyName(3, "hourse1.bmp"); this.imageList.Images.SetKeyName(4, "36-3.bmp"); this.imageList.Images.SetKeyName(5, "36-2.bmp"); this.imageList.Images.SetKeyName(6, "47-1.gif"); this.imageList.Images.SetKeyName(7, "47-2.gif"); // // panelMain // this.panelMain.Controls.Add(this.tabControl1); this.panelMain.Dock = System.Windows.Forms.DockStyle.Fill; this.panelMain.Location = new System.Drawing.Point(200, 0); this.panelMain.Name = "panelMain"; this.panelMain.Size = new System.Drawing.Size(637, 471); this.panelMain.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.panelMain.TabIndex = 1; // // tabControl1 // this.tabControl1.Controls.Add(this.tabPage1); this.tabControl1.Controls.Add(this.tabPage2); this.tabControl1.Controls.Add(this.tabPage3); this.tabControl1.Controls.Add(this.tabPage4); this.tabControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.tabControl1.Location = new System.Drawing.Point(0, 0); this.tabControl1.Name = "tabControl1"; this.tabControl1.SelectedIndex = 0; this.tabControl1.Size = new System.Drawing.Size(637, 471); this.tabControl1.SizeMode = System.Windows.Forms.TabSizeMode.Fixed; this.tabControl1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.tabControl1.TabIndex = 0; // // tabPage1 // this.tabPage1.Controls.Add(this.lnkMenuDelete); this.tabPage1.Controls.Add(this.lnkMenuSave); this.tabPage1.Controls.Add(this.lnkMenuAdd); this.tabPage1.Controls.Add(this.lnkDown1); this.tabPage1.Controls.Add(this.lnkUp1); this.tabPage1.Controls.Add(this.fpSpread1); this.tabPage1.Controls.Add(this.lnkDelete); this.tabPage1.Controls.Add(this.lblModify); this.tabPage1.Controls.Add(this.lnkAdd); this.tabPage1.Controls.Add(this.lnkDown); this.tabPage1.Controls.Add(this.lnkUp); this.tabPage1.Controls.Add(this.lsvMainMenu); this.tabPage1.Location = new System.Drawing.Point(4, 21); this.tabPage1.Name = "tabPage1"; this.tabPage1.Padding = new System.Windows.Forms.Padding(3); this.tabPage1.Size = new System.Drawing.Size(629, 446); this.tabPage1.TabIndex = 0; this.tabPage1.Text = "菜单"; this.tabPage1.UseVisualStyleBackColor = true; // // lnkMenuDelete // this.lnkMenuDelete.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.lnkMenuDelete.AutoSize = true; this.lnkMenuDelete.Location = new System.Drawing.Point(533, 416); this.lnkMenuDelete.Name = "lnkMenuDelete"; this.lnkMenuDelete.Size = new System.Drawing.Size(29, 12); this.lnkMenuDelete.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.lnkMenuDelete.TabIndex = 11; this.lnkMenuDelete.TabStop = true; this.lnkMenuDelete.Text = "删除"; this.lnkMenuDelete.LinkClicked += new System.Windows.Forms.LinkLabelLinkClickedEventHandler(this.lnkMenuDelete_LinkClicked); // // lnkMenuSave // this.lnkMenuSave.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.lnkMenuSave.AutoSize = true; this.lnkMenuSave.Location = new System.Drawing.Point(568, 416); this.lnkMenuSave.Name = "lnkMenuSave"; this.lnkMenuSave.Size = new System.Drawing.Size(29, 12); this.lnkMenuSave.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.lnkMenuSave.TabIndex = 10; this.lnkMenuSave.TabStop = true; this.lnkMenuSave.Text = "保存"; this.lnkMenuSave.LinkClicked += new System.Windows.Forms.LinkLabelLinkClickedEventHandler(this.lnkMenuSave_LinkClicked); // // lnkMenuAdd // this.lnkMenuAdd.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.lnkMenuAdd.AutoSize = true; this.lnkMenuAdd.Location = new System.Drawing.Point(498, 416); this.lnkMenuAdd.Name = "lnkMenuAdd"; this.lnkMenuAdd.Size = new System.Drawing.Size(29, 12); this.lnkMenuAdd.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.lnkMenuAdd.TabIndex = 9; this.lnkMenuAdd.TabStop = true; this.lnkMenuAdd.Text = "增加"; this.lnkMenuAdd.LinkClicked += new System.Windows.Forms.LinkLabelLinkClickedEventHandler(this.lnkMenuAdd_LinkClicked); // // lnkDown1 // this.lnkDown1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left))); this.lnkDown1.AutoSize = true; this.lnkDown1.Location = new System.Drawing.Point(68, 416); this.lnkDown1.Name = "lnkDown1"; this.lnkDown1.Size = new System.Drawing.Size(17, 12); this.lnkDown1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.lnkDown1.TabIndex = 8; this.lnkDown1.TabStop = true; this.lnkDown1.Text = ">>"; this.lnkDown1.LinkClicked += new System.Windows.Forms.LinkLabelLinkClickedEventHandler(this.lnkSubItemDown_LinkClicked); // // lnkUp1 // this.lnkUp1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left))); this.lnkUp1.AutoSize = true; this.lnkUp1.Location = new System.Drawing.Point(35, 416); this.lnkUp1.Name = "lnkUp1"; this.lnkUp1.Size = new System.Drawing.Size(17, 12); this.lnkUp1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.lnkUp1.TabIndex = 7; this.lnkUp1.TabStop = true; this.lnkUp1.Text = "<<"; this.lnkUp1.LinkClicked += new System.Windows.Forms.LinkLabelLinkClickedEventHandler(this.lnkSubItemUp_LinkClicked); // // fpSpread1 // this.fpSpread1.About = "2.5.2007.2005"; this.fpSpread1.AccessibleDescription = "fpSpread1"; this.fpSpread1.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.fpSpread1.BackColor = System.Drawing.Color.Transparent; this.fpSpread1.Location = new System.Drawing.Point(3, 84); this.fpSpread1.Name = "fpSpread1"; this.fpSpread1.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] { this.fpSpread1_Sheet1 }); this.fpSpread1.Size = new System.Drawing.Size(623, 314); this.fpSpread1.TabIndex = 6; tipAppearance1.BackColor = System.Drawing.SystemColors.Info; tipAppearance1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); tipAppearance1.ForeColor = System.Drawing.SystemColors.InfoText; this.fpSpread1.TextTipAppearance = tipAppearance1; this.fpSpread1.ComboSelChange += new FarPoint.Win.Spread.EditorNotifyEventHandler(this.fpSpread1_ComboSelChanged); // // lnkDelete // this.lnkDelete.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); this.lnkDelete.AutoSize = true; this.lnkDelete.Location = new System.Drawing.Point(568, 55); this.lnkDelete.Name = "lnkDelete"; this.lnkDelete.Size = new System.Drawing.Size(29, 12); this.lnkDelete.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.lnkDelete.TabIndex = 5; this.lnkDelete.TabStop = true; this.lnkDelete.Text = "删除"; this.lnkDelete.LinkClicked += new System.Windows.Forms.LinkLabelLinkClickedEventHandler(this.lnkMainDel_LinkClicked); // // lblModify // this.lblModify.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); this.lblModify.AutoSize = true; this.lblModify.Location = new System.Drawing.Point(533, 55); this.lblModify.Name = "lblModify"; this.lblModify.Size = new System.Drawing.Size(29, 12); this.lblModify.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.lblModify.TabIndex = 4; this.lblModify.TabStop = true; this.lblModify.Text = "改名"; this.lblModify.LinkClicked += new System.Windows.Forms.LinkLabelLinkClickedEventHandler(this.lnkMainModify_LinkClicked); // // lnkAdd // this.lnkAdd.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); this.lnkAdd.AutoSize = true; this.lnkAdd.Location = new System.Drawing.Point(498, 55); this.lnkAdd.Name = "lnkAdd"; this.lnkAdd.Size = new System.Drawing.Size(29, 12); this.lnkAdd.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.lnkAdd.TabIndex = 3; this.lnkAdd.TabStop = true; this.lnkAdd.Text = "增加"; this.lnkAdd.LinkClicked += new System.Windows.Forms.LinkLabelLinkClickedEventHandler(this.lnkMainAdd_LinkClicked); // // lnkDown // this.lnkDown.AutoSize = true; this.lnkDown.Location = new System.Drawing.Point(68, 55); this.lnkDown.Name = "lnkDown"; this.lnkDown.Size = new System.Drawing.Size(17, 12); this.lnkDown.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.lnkDown.TabIndex = 2; this.lnkDown.TabStop = true; this.lnkDown.Text = ">>"; this.lnkDown.LinkClicked += new System.Windows.Forms.LinkLabelLinkClickedEventHandler(this.lnkMainDown_LinkClicked); // // lnkUp // this.lnkUp.AutoSize = true; this.lnkUp.Location = new System.Drawing.Point(35, 55); this.lnkUp.Name = "lnkUp"; this.lnkUp.Size = new System.Drawing.Size(17, 12); this.lnkUp.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.lnkUp.TabIndex = 1; this.lnkUp.TabStop = true; this.lnkUp.Text = "<<"; this.lnkUp.LinkClicked += new System.Windows.Forms.LinkLabelLinkClickedEventHandler(this.lnkMainUp_LinkClicked); // // lsvMainMenu // this.lsvMainMenu.Dock = System.Windows.Forms.DockStyle.Top; this.lsvMainMenu.HideSelection = false; this.lsvMainMenu.Items.AddRange(new System.Windows.Forms.ListViewItem[] { listViewItem1 }); this.lsvMainMenu.LabelEdit = true; this.lsvMainMenu.LargeImageList = this.imageList; this.lsvMainMenu.Location = new System.Drawing.Point(3, 3); this.lsvMainMenu.MultiSelect = false; this.lsvMainMenu.Name = "lsvMainMenu"; this.lsvMainMenu.Size = new System.Drawing.Size(623, 75); this.lsvMainMenu.SmallImageList = this.imageList; this.lsvMainMenu.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.lsvMainMenu.TabIndex = 0; this.lsvMainMenu.UseCompatibleStateImageBehavior = false; this.lsvMainMenu.SelectedIndexChanged += new System.EventHandler(this.subMenuListView_SelectedIndexChanged); this.lsvMainMenu.AfterLabelEdit += new System.Windows.Forms.LabelEditEventHandler(this.MainMenuListView_AfterLabelEdit); this.lsvMainMenu.BeforeLabelEdit += new System.Windows.Forms.LabelEditEventHandler(lsvMainMenu_BeforeLabelEdit); // // tabPage2 // this.tabPage2.Controls.Add(this.fpSpread2); this.tabPage2.Controls.Add(this.neuPanel1); this.tabPage2.Location = new System.Drawing.Point(4, 21); this.tabPage2.Name = "tabPage2"; this.tabPage2.Padding = new System.Windows.Forms.Padding(3); this.tabPage2.Size = new System.Drawing.Size(629, 446); this.tabPage2.TabIndex = 1; this.tabPage2.Text = "常数"; this.tabPage2.UseVisualStyleBackColor = true; // // fpSpread2 // this.fpSpread2.About = "2.5.2007.2005"; this.fpSpread2.AccessibleDescription = "fpSpread2"; this.fpSpread2.BackColor = System.Drawing.Color.Transparent; this.fpSpread2.ContextMenuStrip = this.neuContextMenuStrip1; this.fpSpread2.Dock = System.Windows.Forms.DockStyle.Fill; this.fpSpread2.Location = new System.Drawing.Point(3, 3); this.fpSpread2.Name = "fpSpread2"; this.fpSpread2.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] { this.fpSpread2_Sheet1 }); this.fpSpread2.Size = new System.Drawing.Size(623, 386); this.fpSpread2.TabIndex = 7; tipAppearance2.BackColor = System.Drawing.SystemColors.Info; tipAppearance2.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); tipAppearance2.ForeColor = System.Drawing.SystemColors.InfoText; this.fpSpread2.TextTipAppearance = tipAppearance2; this.fpSpread2.CellClick += new FarPoint.Win.Spread.CellClickEventHandler(this.fpSpread2_CellClick); // // neuPanel1 // this.neuPanel1.Controls.Add(this.lnkConstDel); this.neuPanel1.Controls.Add(this.lnkConstSave); this.neuPanel1.Controls.Add(this.lnkConstAdd); this.neuPanel1.Dock = System.Windows.Forms.DockStyle.Bottom; this.neuPanel1.Location = new System.Drawing.Point(3, 389); this.neuPanel1.Name = "neuPanel1"; this.neuPanel1.Size = new System.Drawing.Size(623, 54); this.neuPanel1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuPanel1.TabIndex = 8; // // lnkConstDel // this.lnkConstDel.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.lnkConstDel.AutoSize = true; this.lnkConstDel.Location = new System.Drawing.Point(533, 24); this.lnkConstDel.Name = "lnkConstDel"; this.lnkConstDel.Size = new System.Drawing.Size(29, 12); this.lnkConstDel.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.lnkConstDel.TabIndex = 14; this.lnkConstDel.TabStop = true; this.lnkConstDel.Text = "删除"; this.lnkConstDel.LinkClicked += new System.Windows.Forms.LinkLabelLinkClickedEventHandler(this.lnkConstDel_LinkClicked); // // lnkConstSave // this.lnkConstSave.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.lnkConstSave.AutoSize = true; this.lnkConstSave.Location = new System.Drawing.Point(568, 24); this.lnkConstSave.Name = "lnkConstSave"; this.lnkConstSave.Size = new System.Drawing.Size(29, 12); this.lnkConstSave.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.lnkConstSave.TabIndex = 13; this.lnkConstSave.TabStop = true; this.lnkConstSave.Text = "保存"; this.lnkConstSave.LinkClicked += new System.Windows.Forms.LinkLabelLinkClickedEventHandler(this.lnkConstSave_LinkClicked); // // lnkConstAdd // this.lnkConstAdd.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.lnkConstAdd.AutoSize = true; this.lnkConstAdd.Location = new System.Drawing.Point(498, 24); this.lnkConstAdd.Name = "lnkConstAdd"; this.lnkConstAdd.Size = new System.Drawing.Size(29, 12); this.lnkConstAdd.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.lnkConstAdd.TabIndex = 12; this.lnkConstAdd.TabStop = true; this.lnkConstAdd.Text = "增加"; this.lnkConstAdd.LinkClicked += new System.Windows.Forms.LinkLabelLinkClickedEventHandler(this.lnkConstAdd_LinkClicked); // // tabPage3 // this.tabPage3.Location = new System.Drawing.Point(4, 21); this.tabPage3.Name = "tabPage3"; this.tabPage3.Size = new System.Drawing.Size(629, 446); this.tabPage3.TabIndex = 2; this.tabPage3.Text = "报表"; this.tabPage3.UseVisualStyleBackColor = true; // // tabPage4 // this.tabPage4.Controls.Add(this.lsvPerson); this.tabPage4.Location = new System.Drawing.Point(4, 21); this.tabPage4.Name = "tabPage4"; this.tabPage4.Size = new System.Drawing.Size(629, 446); this.tabPage4.TabIndex = 3; this.tabPage4.Text = "人员"; this.tabPage4.UseVisualStyleBackColor = true; // // lsvPerson // this.lsvPerson.Dock = System.Windows.Forms.DockStyle.Fill; this.lsvPerson.LargeImageList = this.imageList; this.lsvPerson.Location = new System.Drawing.Point(0, 0); this.lsvPerson.Name = "lsvPerson"; this.lsvPerson.Size = new System.Drawing.Size(629, 446); this.lsvPerson.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.lsvPerson.TabIndex = 0; this.lsvPerson.UseCompatibleStateImageBehavior = false; // // neuSplitter1 // this.neuSplitter1.Location = new System.Drawing.Point(200, 0); this.neuSplitter1.Name = "neuSplitter1"; this.neuSplitter1.Size = new System.Drawing.Size(3, 471); this.neuSplitter1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.neuSplitter1.TabIndex = 2; this.neuSplitter1.TabStop = false; // // neuContextMenuStrip1 // this.neuContextMenuStrip1.Items.AddRange(new System.Windows.Forms.ToolStripItem[] { this.sQL语句维护ToolStripMenuItem }); this.neuContextMenuStrip1.Name = "neuContextMenuStrip1"; this.neuContextMenuStrip1.Size = new System.Drawing.Size(137, 26); this.neuContextMenuStrip1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; // // sQL语句维护ToolStripMenuItem // this.sQL语句维护ToolStripMenuItem.Name = "sQL语句维护ToolStripMenuItem"; this.sQL语句维护ToolStripMenuItem.Size = new System.Drawing.Size(136, 22); this.sQL语句维护ToolStripMenuItem.Text = "SQL语句维护"; this.sQL语句维护ToolStripMenuItem.Click += new System.EventHandler(this.ToolStripMenuItem_Click); // // fpSpread1_Sheet1 // this.fpSpread1_Sheet1.Reset(); this.fpSpread1_Sheet1.SheetName = "Sheet1"; // Formulas and custom names must be loaded with R1C1 reference style this.fpSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.fpSpread1_Sheet1.ColumnCount = 9; this.fpSpread1_Sheet1.RowCount = 1; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 0).Value = "菜单名称"; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 1).Value = "调用模块"; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 2).Value = "模块编码"; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 3).Value = "调用窗口"; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 4).Value = "是否可用"; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 5).Value = "图标"; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 6).Value = "ID"; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 7).Value = "图像"; this.fpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 8).Value = "ICONID"; this.fpSpread1_Sheet1.Columns.Get(0).CellType = textCellType1; this.fpSpread1_Sheet1.Columns.Get(0).Label = "菜单名称"; this.fpSpread1_Sheet1.Columns.Get(1).CellType = textCellType2; this.fpSpread1_Sheet1.Columns.Get(1).Label = "调用模块"; this.fpSpread1_Sheet1.Columns.Get(1).Width = 177F; this.fpSpread1_Sheet1.Columns.Get(2).CellType = textCellType3; this.fpSpread1_Sheet1.Columns.Get(2).Label = "模块编码"; this.fpSpread1_Sheet1.Columns.Get(3).CellType = textCellType4; this.fpSpread1_Sheet1.Columns.Get(3).Label = "调用窗口"; this.fpSpread1_Sheet1.Columns.Get(4).CellType = checkBoxCellType1; this.fpSpread1_Sheet1.Columns.Get(4).Label = "是否可用"; comboBoxCellType1.ButtonAlign = FarPoint.Win.ButtonAlign.Right; this.fpSpread1_Sheet1.Columns.Get(5).CellType = comboBoxCellType1; this.fpSpread1_Sheet1.Columns.Get(5).Label = "图标"; this.fpSpread1_Sheet1.Columns.Get(5).Width = 67F; this.fpSpread1_Sheet1.Columns.Get(6).CellType = textCellType5; this.fpSpread1_Sheet1.Columns.Get(6).Label = "ID"; this.fpSpread1_Sheet1.Columns.Get(6).Width = 73F; imageCellType1.Style = FarPoint.Win.RenderStyle.Normal; imageCellType1.TransparencyColor = System.Drawing.Color.Empty; imageCellType1.TransparencyTolerance = 0; this.fpSpread1_Sheet1.Columns.Get(7).CellType = imageCellType1; this.fpSpread1_Sheet1.Columns.Get(7).Label = "图像"; this.fpSpread1_Sheet1.Columns.Get(7).Width = 84F; this.fpSpread1_Sheet1.RowHeader.Columns.Default.Resizable = false; this.fpSpread1_Sheet1.CellChanged += new FarPoint.Win.Spread.SheetViewEventHandler(this.fpSpread1_Sheet1_CellChanged_1); this.fpSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1; // // fpSpread2_Sheet1 // this.fpSpread2_Sheet1.Reset(); this.fpSpread2_Sheet1.SheetName = "Sheet1"; // Formulas and custom names must be loaded with R1C1 reference style this.fpSpread2_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1; this.fpSpread2_Sheet1.ColumnCount = 6; this.fpSpread2_Sheet1.RowCount = 1; this.fpSpread2_Sheet1.ColumnHeader.Cells.Get(0, 0).Value = "常数类别"; this.fpSpread2_Sheet1.ColumnHeader.Cells.Get(0, 1).Value = "常数名称"; this.fpSpread2_Sheet1.ColumnHeader.Cells.Get(0, 2).Value = "控件名称"; this.fpSpread2_Sheet1.ColumnHeader.Cells.Get(0, 3).Value = "程序集名称"; this.fpSpread2_Sheet1.ColumnHeader.Cells.Get(0, 4).Value = "参数"; this.fpSpread2_Sheet1.ColumnHeader.Cells.Get(0, 5).Value = "备注"; this.fpSpread2_Sheet1.Columns.Get(0).CellType = textCellType6; this.fpSpread2_Sheet1.Columns.Get(0).Label = "常数类别"; this.fpSpread2_Sheet1.Columns.Get(0).Width = 102F; this.fpSpread2_Sheet1.Columns.Get(1).CellType = textCellType7; this.fpSpread2_Sheet1.Columns.Get(1).Label = "常数名称"; this.fpSpread2_Sheet1.Columns.Get(1).Width = 138F; this.fpSpread2_Sheet1.Columns.Get(2).CellType = textCellType8; this.fpSpread2_Sheet1.Columns.Get(2).Label = "控件名称"; this.fpSpread2_Sheet1.Columns.Get(2).Width = 198F; this.fpSpread2_Sheet1.Columns.Get(3).CellType = textCellType9; this.fpSpread2_Sheet1.Columns.Get(3).Label = "程序集名称"; this.fpSpread2_Sheet1.Columns.Get(3).Width = 176F; this.fpSpread2_Sheet1.Columns.Get(4).Label = "参数"; this.fpSpread2_Sheet1.Columns.Get(4).Width = 87F; comboBoxCellType2.ButtonAlign = FarPoint.Win.ButtonAlign.Right; this.fpSpread2_Sheet1.Columns.Get(5).CellType = comboBoxCellType2; this.fpSpread2_Sheet1.Columns.Get(5).Label = "备注"; this.fpSpread2_Sheet1.Columns.Get(5).Width = 102F; this.fpSpread2_Sheet1.RowHeader.Columns.Default.Resizable = false; this.fpSpread2_Sheet1.CellChanged += new FarPoint.Win.Spread.SheetViewEventHandler(this.fpSpread2_Sheet1_CellChanged); this.fpSpread2_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1; // // treeView1 // this.treeView1.Dock = System.Windows.Forms.DockStyle.Fill; this.treeView1.HideSelection = false; this.treeView1.ImageIndex = 0; this.treeView1.ImageList = this.imageList; this.treeView1.Location = new System.Drawing.Point(0, 0); this.treeView1.Name = "treeView1"; this.treeView1.SelectedImageIndex = 0; this.treeView1.Size = new System.Drawing.Size(200, 471); this.treeView1.Style = Neusoft.FrameWork.WinForms.Controls.StyleType.Fixed3D; this.treeView1.TabIndex = 0; this.treeView1.AfterSelect += new System.Windows.Forms.TreeViewEventHandler(this.treeView_AfterSelect); // // ucSysGroupMenuManager // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.Controls.Add(this.neuSplitter1); this.Controls.Add(this.panelMain); this.Controls.Add(this.panel1); this.Name = "ucSysGroupMenuManager"; this.Size = new System.Drawing.Size(837, 471); this.panel1.ResumeLayout(false); this.panelMain.ResumeLayout(false); this.tabControl1.ResumeLayout(false); this.tabPage1.ResumeLayout(false); this.tabPage1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).EndInit(); this.tabPage2.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.fpSpread2)).EndInit(); this.neuPanel1.ResumeLayout(false); this.neuPanel1.PerformLayout(); this.tabPage4.ResumeLayout(false); this.neuContextMenuStrip1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.fpSpread2_Sheet1)).EndInit(); this.ResumeLayout(false); }
private void PaintGrdView() { //FarPoint.Win.Spread.Cell aCell; GrdView.Visible = false; GrdView.Reset(); GrdView.ActiveSheet.RowCount = 1; GrdView.ActiveSheet.ColumnCount = 9; GrdView.Height = this.Height - GrdFilter.Height - 60; GrdView.Width = this.Width - 30; GrdView.Top = 35; GrdView.Left = 12; FarPoint.Win.Spread.Column col; FarPoint.Win.Spread.CellType.TextCellType cell = new FarPoint.Win.Spread.CellType.TextCellType(); col = GrdView.ActiveSheet.Columns[liColMemID, liColContactNameSkk9]; col.CellType = cell; FarPoint.Win.Spread.CellType.NumberCellType cellNum = new FarPoint.Win.Spread.CellType.NumberCellType(); col = GrdView.ActiveSheet.Columns[liColRoom]; cellNum.DecimalPlaces = 0; col.CellType = cellNum; FarPoint.Win.Spread.CellType.ImageCellType cellImg = new FarPoint.Win.Spread.CellType.ImageCellType(); col = GrdView.ActiveSheet.Columns[liColStar1]; cellImg.Style = FarPoint.Win.RenderStyle.StretchAndScale; col.CellType = cellImg; GrdView.ActiveSheet.SetColumnWidth(liColMemID, 72); GrdView.ActiveSheet.SetColumnWidth(liColMemNameE, 300); GrdView.ActiveSheet.SetColumnWidth(liColRoom, 65); GrdView.ActiveSheet.SetColumnWidth(liColRegion, 150); GrdView.ActiveSheet.SetColumnWidth(liColTMem, 110); GrdView.ActiveSheet.SetColumnWidth(liColHotelChain, 150); GrdView.ActiveSheet.SetColumnWidth(liColStar1, 100); GrdView.ActiveSheet.SetColumnWidth(liColProvNameT, 110); GrdView.ActiveSheet.SetColumnLabel(0, liColMemID, "memid"); GrdView.ActiveSheet.SetColumnLabel(0, liColMemNameE, "Member Name"); GrdView.ActiveSheet.SetColumnLabel(0, liColRoom, "room"); GrdView.ActiveSheet.SetColumnLabel(0, liColRegion, "Region"); GrdView.ActiveSheet.SetColumnLabel(0, liColTMem, "Type Member"); GrdView.ActiveSheet.SetColumnLabel(0, liColHotelChain, "Hotel Chain"); GrdView.ActiveSheet.SetColumnLabel(0, liColStar1, "star"); GrdView.ActiveSheet.SetColumnLabel(0, liColProvNameT, "province"); GrdView.ActiveSheet.SetColumnLabel(0, liColContactNameSkk9, "ª×èͼÙéá·¹"); GrdView.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Off; GrdView.BorderStyle = BorderStyle.None; GrdView.ActiveSheet.OperationMode = FarPoint.Win.Spread.OperationMode.RowMode; GrdView.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; GrdView.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; GrdView.Visible = true; //GrdView.Width = this.Width - 10; GrdFilter.ActiveSheet.RowCount = 0; GrdFilter.ActiveSheet.ColumnCount = 27; GrdFilter.Width = 1111; GrdFilter.Top = this.Height - 80; GrdFilter.Left = 18; //GrdFilter.ActiveSheet.SetRowVisible(0, false); GrdFilter.ActiveSheet.RowHeaderVisible = false; //GrdFilter.h GrdFilter.Sheets[0].SetColumnLabel(0, 26, "ALL"); GrdView.ActiveSheet.Columns[liColMemID, liColContactNameSkk9].AllowAutoSort = true; GrdView.ActiveSheet.Columns[liColMemID, liColContactNameSkk9].AllowAutoFilter = true; for (Int32 i = 0; i <= 26; i++) { GrdFilter.ActiveSheet.SetColumnWidth(i + 1, 38); } GrdView.AllowColumnMove = true; }