private void HyperLinkSettingDialog_Load(object sender, EventArgs e)
{
if (ActiveCell.CellType is FarPoint.Win.Spread.CellType.HyperLinkCellType)
{
FarPoint.Win.Spread.CellType.HyperLinkCellType hlnkCell = ActiveCell.CellType as FarPoint.Win.Spread.CellType.HyperLinkCellType;
var tag = ActiveCell.Value as string;
var model = "超链接";
if (!string.IsNullOrEmpty(tag))
{
model = tag;
}
var text = hlnkCell.Text;
var link = hlnkCell.Link;
switch (model)
{
case "超链接":
txtLinkUrl.Text = link;
break;
case "附件":
Img = new Bitmap(JZCommonHelper.StringToBitmap(Convert.ToString(link)));
break;
}
if (Img == null)
{
var bitmap = new Bitmap(Preview.Width, Preview.Height);
var graphics = Graphics.FromImage(bitmap);
var brush = new SolidBrush(Color.Gray);
var format = new StringFormat();
format.Alignment = StringAlignment.Center;
format.LineAlignment = StringAlignment.Center;
graphics.DrawString("当前无预览", this.Font, brush, Preview.ClientRectangle, format); //这里文字以0,0为中心居中
graphics.Dispose();
Preview.Image = bitmap;
}
else
{
Preview.Image = Img;
}
txtShowText.Text = text;
RadioAttach.Checked = model == "附件";
RadioLink.Checked = model == "超链接";
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtShowText.Text))
{
MessageBox.Show("请输入显示文字", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtLinkUrl.Focus();
return;
}
if (ActiveCell.CellType is FarPoint.Win.Spread.CellType.HyperLinkCellType)
{
FarPoint.Win.Spread.CellType.HyperLinkCellType hlnkCell = ActiveCell.CellType as FarPoint.Win.Spread.CellType.HyperLinkCellType;
if (RadioAttach.Checked)
{
if (Img == null)
{
MessageBox.Show("请选择附件文件", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
ActiveCell.Value = "附件";
hlnkCell.Link = JZCommonHelper.BitmapToString(Img);
}
if (RadioLink.Checked)
{
ActiveCell.Value = "超链接";
hlnkCell.Link = txtLinkUrl.Text;
}
hlnkCell.Text = txtShowText.Text;
ActiveCell.CellType = hlnkCell;
MessageBox.Show("设置成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
}
}
/// <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.HyperLinkCellType hyperLinkCellType1 = new FarPoint.Win.Spread.CellType.HyperLinkCellType();
FarPoint.Win.Spread.CellType.GeneralCellType generalCellType1 = new FarPoint.Win.Spread.CellType.GeneralCellType();
FarPoint.Win.Spread.CellType.ComboBoxCellType comboBoxCellType1 = new FarPoint.Win.Spread.CellType.ComboBoxCellType();
FarPoint.Win.Spread.CellType.GeneralCellType generalCellType2 = new FarPoint.Win.Spread.CellType.GeneralCellType();
FarPoint.Win.Spread.CellType.ButtonCellType buttonCellType1 = new FarPoint.Win.Spread.CellType.ButtonCellType();
FarPoint.Win.Spread.CellType.HyperLinkCellType hyperLinkCellType2 = new FarPoint.Win.Spread.CellType.HyperLinkCellType();
FarPoint.Win.Spread.CellType.HyperLinkCellType hyperLinkCellType3 = new FarPoint.Win.Spread.CellType.HyperLinkCellType();
this.ComboModules = new System.Windows.Forms.ComboBox();
this.TextModuleName = new System.Windows.Forms.TextBox();
this.label2 = new System.Windows.Forms.Label();
this.label1 = new System.Windows.Forms.Label();
this.TableModules = new FarPoint.Win.Spread.FpSpread();
this.TableModules_Sheet1 = new FarPoint.Win.Spread.SheetView();
this.TableStatistics = new FarPoint.Win.Spread.FpSpread();
this.TableStatistics_Sheet1 = new FarPoint.Win.Spread.SheetView();
this.ButtonCancel = new System.Windows.Forms.Button();
this.ButtonOk = new System.Windows.Forms.Button();
this.ButtonNew = new System.Windows.Forms.Button();
this.ButtonModify = new System.Windows.Forms.Button();
this.ButtonDelete = new System.Windows.Forms.Button();
this.LinkNewStatistics = new System.Windows.Forms.LinkLabel();
this.LinkModifyStatistics = new System.Windows.Forms.LinkLabel();
this.LinkDeleteStatistics = new System.Windows.Forms.LinkLabel();
((System.ComponentModel.ISupportInitialize)(this.TableModules)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.TableModules_Sheet1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.TableStatistics)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.TableStatistics_Sheet1)).BeginInit();
this.SuspendLayout();
//
// ComboModules
//
this.ComboModules.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.ComboModules.DisplayMember = "ItemName";
this.ComboModules.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.ComboModules.FormattingEnabled = true;
this.ComboModules.Location = new System.Drawing.Point(355, 13);
this.ComboModules.Name = "ComboModules";
this.ComboModules.Size = new System.Drawing.Size(392, 20);
this.ComboModules.TabIndex = 20;
this.ComboModules.ValueMember = "ItemID";
this.ComboModules.SelectedIndexChanged += new System.EventHandler(this.ComboModules_SelectedIndexChanged);
//
// TextModuleName
//
this.TextModuleName.Location = new System.Drawing.Point(81, 12);
this.TextModuleName.Name = "TextModuleName";
this.TextModuleName.ReadOnly = true;
this.TextModuleName.Size = new System.Drawing.Size(221, 21);
this.TextModuleName.TabIndex = 19;
//
// label2
//
this.label2.AutoSize = true;
this.label2.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Underline, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.label2.Location = new System.Drawing.Point(308, 15);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(41, 12);
this.label2.TabIndex = 17;
this.label2.Text = "分类：";
//
// label1
//
this.label1.AutoSize = true;
this.label1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Underline, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.label1.Location = new System.Drawing.Point(10, 14);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(65, 12);
this.label1.TabIndex = 18;
this.label1.Text = "当前模板：";
//
// TableModules
//
this.TableModules.AccessibleDescription = "TableModules, Sheet1, Row 0, Column 0, ";
this.TableModules.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.TableModules.BackColor = System.Drawing.SystemColors.Control;
this.TableModules.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
this.TableModules.ColumnSplitBoxPolicy = FarPoint.Win.Spread.SplitBoxPolicy.Never;
this.TableModules.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
this.TableModules.Location = new System.Drawing.Point(12, 51);
this.TableModules.Name = "TableModules";
this.TableModules.RightToLeft = System.Windows.Forms.RightToLeft.No;
this.TableModules.RowSplitBoxPolicy = FarPoint.Win.Spread.SplitBoxPolicy.Never;
this.TableModules.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] {
this.TableModules_Sheet1
});
this.TableModules.Size = new System.Drawing.Size(735, 195);
this.TableModules.TabIndex = 21;
this.TableModules.TabStripInsertTab = false;
this.TableModules.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Never;
this.TableModules.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
this.TableModules.CellClick += new FarPoint.Win.Spread.CellClickEventHandler(this.TableModules_CellClick);
this.TableModules.SelectionChanged += new FarPoint.Win.Spread.SelectionChangedEventHandler(this.TableModules_SelectionChanged);
this.TableModules.ButtonClicked += new FarPoint.Win.Spread.EditorNotifyEventHandler(this.TableModules_ButtonClicked);
//
// TableModules_Sheet1
//
this.TableModules_Sheet1.Reset();
this.TableModules_Sheet1.SheetName = "Sheet1";
// Formulas and custom names must be loaded with R1C1 reference style
this.TableModules_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
this.TableModules_Sheet1.ColumnCount = 2;
this.TableModules_Sheet1.RowCount = 1;
this.TableModules_Sheet1.ColumnHeader.Cells.Get(0, 0).Value = "该分类下关联的模板";
this.TableModules_Sheet1.ColumnHeader.Cells.Get(0, 1).Value = "删除";
this.TableModules_Sheet1.Columns.Get(0).Label = "该分类下关联的模板";
this.TableModules_Sheet1.Columns.Get(0).Width = 415F;
hyperLinkCellType1.LinkArea = new System.Windows.Forms.LinkArea(0, 2);
hyperLinkCellType1.LinkAreas = new System.Windows.Forms.LinkArea[] {
new System.Windows.Forms.LinkArea(0, 2)
};
hyperLinkCellType1.LinkColor = System.Drawing.Color.Red;
hyperLinkCellType1.Text = "删除";
hyperLinkCellType1.VisitedLinkColor = System.Drawing.Color.DarkRed;
this.TableModules_Sheet1.Columns.Get(1).CellType = hyperLinkCellType1;
this.TableModules_Sheet1.Columns.Get(1).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center;
this.TableModules_Sheet1.Columns.Get(1).Label = "删除";
this.TableModules_Sheet1.Columns.Get(1).Locked = true;
this.TableModules_Sheet1.Columns.Get(1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center;
this.TableModules_Sheet1.Columns.Get(1).Width = 102F;
this.TableModules_Sheet1.DefaultStyle.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center;
this.TableModules_Sheet1.DefaultStyle.Parent = "DataAreaDefault";
this.TableModules_Sheet1.DefaultStyle.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center;
this.TableModules_Sheet1.OperationMode = FarPoint.Win.Spread.OperationMode.SingleSelect;
this.TableModules_Sheet1.RowHeader.Columns.Default.Resizable = false;
this.TableModules_Sheet1.RowHeader.Visible = false;
this.TableModules_Sheet1.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Single;
this.TableModules_Sheet1.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Row;
this.TableModules_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
//
// TableStatistics
//
this.TableStatistics.AccessibleDescription = "TableStatistics, Sheet1";
this.TableStatistics.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.TableStatistics.BackColor = System.Drawing.SystemColors.Control;
this.TableStatistics.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
this.TableStatistics.ColumnSplitBoxPolicy = FarPoint.Win.Spread.SplitBoxPolicy.Never;
this.TableStatistics.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
this.TableStatistics.Location = new System.Drawing.Point(12, 252);
this.TableStatistics.Name = "TableStatistics";
this.TableStatistics.RightToLeft = System.Windows.Forms.RightToLeft.No;
this.TableStatistics.RowSplitBoxPolicy = FarPoint.Win.Spread.SplitBoxPolicy.Never;
this.TableStatistics.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] {
this.TableStatistics_Sheet1
});
this.TableStatistics.Size = new System.Drawing.Size(734, 363);
this.TableStatistics.TabIndex = 21;
this.TableStatistics.TabStripInsertTab = false;
this.TableStatistics.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Never;
this.TableStatistics.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
this.TableStatistics.CellClick += new FarPoint.Win.Spread.CellClickEventHandler(this.TableStatistics_CellClick);
this.TableStatistics.Change += new FarPoint.Win.Spread.ChangeEventHandler(this.TableStatistics_Change);
this.TableStatistics.ButtonClicked += new FarPoint.Win.Spread.EditorNotifyEventHandler(this.TableStatistics_ButtonClicked);
//
// TableStatistics_Sheet1
//
this.TableStatistics_Sheet1.Reset();
this.TableStatistics_Sheet1.SheetName = "Sheet1";
// Formulas and custom names must be loaded with R1C1 reference style
this.TableStatistics_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
this.TableStatistics_Sheet1.ColumnCount = 7;
this.TableStatistics_Sheet1.RowCount = 0;
this.TableStatistics_Sheet1.ColumnHeader.Cells.Get(0, 0).Value = "统计项/标准值";
this.TableStatistics_Sheet1.ColumnHeader.Cells.Get(0, 1).Value = "数据类型";
this.TableStatistics_Sheet1.ColumnHeader.Cells.Get(0, 2).Value = "表单";
this.TableStatistics_Sheet1.ColumnHeader.Cells.Get(0, 3).Value = "单元格";
this.TableStatistics_Sheet1.ColumnHeader.Cells.Get(0, 4).Value = "设置";
this.TableStatistics_Sheet1.ColumnHeader.Cells.Get(0, 5).Value = "添加";
this.TableStatistics_Sheet1.ColumnHeader.Cells.Get(0, 6).Value = "删除/清除";
this.TableStatistics_Sheet1.Columns.Get(0).CellType = generalCellType1;
this.TableStatistics_Sheet1.Columns.Get(0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center;
this.TableStatistics_Sheet1.Columns.Get(0).Label = "统计项/标准值";
this.TableStatistics_Sheet1.Columns.Get(0).Locked = false;
this.TableStatistics_Sheet1.Columns.Get(0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center;
this.TableStatistics_Sheet1.Columns.Get(0).Width = 112F;
comboBoxCellType1.ButtonAlign = FarPoint.Win.ButtonAlign.Right;
comboBoxCellType1.Items = new string[] {
"项目类型",
"厂家名称",
"报告编号",
"报告日期",
"强度等级",
"品种等级",
"施工部位",
"数量",
"组值",
"小数点1",
"小数点2",
"小数点3",
"小数点4",
"小数点5",
"小数点6",
"小数点7",
"小数点8",
"小数点9",
"小数点10",
"小数点11",
"小数点12",
"小数点13",
"小数点14",
"小数点15",
"小数点16",
"小数点17",
"小数点18",
"小数点19",
"时间1",
"时间2",
"时间3",
"时间4",
"时间5",
"文本1",
"文本2",
"文本3",
"文本4",
"文本5",
"文本6",
"文本7",
"文本8",
"文本9",
"文本10",
"文本11",
"文本12",
"文本13",
"文本14",
"文本15",
"文本16"
};
this.TableStatistics_Sheet1.Columns.Get(1).CellType = comboBoxCellType1;
this.TableStatistics_Sheet1.Columns.Get(1).Label = "数据类型";
this.TableStatistics_Sheet1.Columns.Get(1).Width = 121F;
this.TableStatistics_Sheet1.Columns.Get(2).Label = "表单";
this.TableStatistics_Sheet1.Columns.Get(2).Locked = true;
this.TableStatistics_Sheet1.Columns.Get(2).Width = 126F;
this.TableStatistics_Sheet1.Columns.Get(3).CellType = generalCellType2;
this.TableStatistics_Sheet1.Columns.Get(3).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center;
this.TableStatistics_Sheet1.Columns.Get(3).Label = "单元格";
this.TableStatistics_Sheet1.Columns.Get(3).Locked = true;
this.TableStatistics_Sheet1.Columns.Get(3).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center;
this.TableStatistics_Sheet1.Columns.Get(3).Width = 97F;
buttonCellType1.ButtonColor2 = System.Drawing.SystemColors.ButtonFace;
buttonCellType1.Text = "设置";
this.TableStatistics_Sheet1.Columns.Get(4).CellType = buttonCellType1;
this.TableStatistics_Sheet1.Columns.Get(4).Label = "设置";
this.TableStatistics_Sheet1.Columns.Get(4).Resizable = false;
this.TableStatistics_Sheet1.Columns.Get(4).Width = 72F;
hyperLinkCellType2.LinkArea = new System.Windows.Forms.LinkArea(0, 2);
hyperLinkCellType2.LinkAreas = new System.Windows.Forms.LinkArea[] {
new System.Windows.Forms.LinkArea(0, 2)
};
hyperLinkCellType2.Text = "添加";
this.TableStatistics_Sheet1.Columns.Get(5).CellType = hyperLinkCellType2;
this.TableStatistics_Sheet1.Columns.Get(5).Label = "添加";
this.TableStatistics_Sheet1.Columns.Get(5).Resizable = false;
this.TableStatistics_Sheet1.Columns.Get(5).Width = 66F;
hyperLinkCellType3.LinkArea = new System.Windows.Forms.LinkArea(0, 2);
hyperLinkCellType3.LinkAreas = new System.Windows.Forms.LinkArea[] {
new System.Windows.Forms.LinkArea(0, 2)
};
hyperLinkCellType3.Text = "删除";
this.TableStatistics_Sheet1.Columns.Get(6).CellType = hyperLinkCellType3;
this.TableStatistics_Sheet1.Columns.Get(6).Label = "删除/清除";
this.TableStatistics_Sheet1.Columns.Get(6).Resizable = false;
this.TableStatistics_Sheet1.Columns.Get(6).Width = 102F;
this.TableStatistics_Sheet1.DefaultStyle.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center;
this.TableStatistics_Sheet1.DefaultStyle.Parent = "DataAreaDefault";
this.TableStatistics_Sheet1.DefaultStyle.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center;
this.TableStatistics_Sheet1.RowHeader.Columns.Default.Resizable = false;
this.TableStatistics_Sheet1.RowHeader.Visible = false;
this.TableStatistics_Sheet1.CellChanged += new FarPoint.Win.Spread.SheetViewEventHandler(this.TableStatistics_Sheet1_CellChanged);
this.TableStatistics_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
this.TableStatistics.SetActiveViewport(0, 1, 0);
//
// ButtonCancel
//
this.ButtonCancel.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right)));
this.ButtonCancel.Location = new System.Drawing.Point(678, 621);
this.ButtonCancel.Name = "ButtonCancel";
this.ButtonCancel.Size = new System.Drawing.Size(75, 23);
this.ButtonCancel.TabIndex = 23;
this.ButtonCancel.Text = "关闭";
this.ButtonCancel.UseVisualStyleBackColor = true;
this.ButtonCancel.Click += new System.EventHandler(this.ButtonCancel_Click);
//
// ButtonOk
//
this.ButtonOk.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right)));
this.ButtonOk.Location = new System.Drawing.Point(597, 621);
this.ButtonOk.Name = "ButtonOk";
this.ButtonOk.Size = new System.Drawing.Size(75, 23);
this.ButtonOk.TabIndex = 22;
this.ButtonOk.Text = "保存";
this.ButtonOk.UseVisualStyleBackColor = true;
this.ButtonOk.Click += new System.EventHandler(this.ButtonOk_Click);
//
// ButtonNew
//
this.ButtonNew.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)));
this.ButtonNew.Location = new System.Drawing.Point(12, 621);
this.ButtonNew.Name = "ButtonNew";
this.ButtonNew.Size = new System.Drawing.Size(75, 23);
this.ButtonNew.TabIndex = 22;
this.ButtonNew.Text = "新增";
this.ButtonNew.UseVisualStyleBackColor = true;
this.ButtonNew.Visible = false;
this.ButtonNew.Click += new System.EventHandler(this.ButtonNew_Click);
//
// ButtonModify
//
this.ButtonModify.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)));
this.ButtonModify.Location = new System.Drawing.Point(93, 621);
this.ButtonModify.Name = "ButtonModify";
this.ButtonModify.Size = new System.Drawing.Size(75, 23);
this.ButtonModify.TabIndex = 22;
this.ButtonModify.Text = "修改";
this.ButtonModify.UseVisualStyleBackColor = true;
this.ButtonModify.Visible = false;
this.ButtonModify.Click += new System.EventHandler(this.ButtonModify_Click);
//
// ButtonDelete
//
this.ButtonDelete.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)));
this.ButtonDelete.Location = new System.Drawing.Point(174, 621);
this.ButtonDelete.Name = "ButtonDelete";
this.ButtonDelete.Size = new System.Drawing.Size(75, 23);
this.ButtonDelete.TabIndex = 22;
this.ButtonDelete.Text = "删除";
this.ButtonDelete.UseVisualStyleBackColor = true;
this.ButtonDelete.Visible = false;
this.ButtonDelete.Click += new System.EventHandler(this.ButtonDelete_Click);
//
// LinkNewStatistics
//
this.LinkNewStatistics.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.LinkNewStatistics.AutoSize = true;
this.LinkNewStatistics.Location = new System.Drawing.Point(575, 36);
this.LinkNewStatistics.Name = "LinkNewStatistics";
this.LinkNewStatistics.Size = new System.Drawing.Size(53, 12);
this.LinkNewStatistics.TabIndex = 24;
this.LinkNewStatistics.TabStop = true;
this.LinkNewStatistics.Text = "添加分类";
this.LinkNewStatistics.LinkClicked += new System.Windows.Forms.LinkLabelLinkClickedEventHandler(this.LinkNewStatistics_LinkClicked);
//
// LinkModifyStatistics
//
this.LinkModifyStatistics.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.LinkModifyStatistics.AutoSize = true;
this.LinkModifyStatistics.Location = new System.Drawing.Point(634, 36);
this.LinkModifyStatistics.Name = "LinkModifyStatistics";
this.LinkModifyStatistics.Size = new System.Drawing.Size(53, 12);
this.LinkModifyStatistics.TabIndex = 24;
this.LinkModifyStatistics.TabStop = true;
this.LinkModifyStatistics.Text = "修改分类";
this.LinkModifyStatistics.LinkClicked += new System.Windows.Forms.LinkLabelLinkClickedEventHandler(this.LinkModifyStatistics_LinkClicked);
//
// LinkDeleteStatistics
//
this.LinkDeleteStatistics.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.LinkDeleteStatistics.AutoSize = true;
this.LinkDeleteStatistics.Location = new System.Drawing.Point(693, 36);
this.LinkDeleteStatistics.Name = "LinkDeleteStatistics";
this.LinkDeleteStatistics.Size = new System.Drawing.Size(53, 12);
this.LinkDeleteStatistics.TabIndex = 24;
this.LinkDeleteStatistics.TabStop = true;
this.LinkDeleteStatistics.Text = "删除分类";
this.LinkDeleteStatistics.LinkClicked += new System.Windows.Forms.LinkLabelLinkClickedEventHandler(this.LinkDeleteStatistics_LinkClicked);
//
// StatisticsManagement
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(759, 656);
this.Controls.Add(this.LinkDeleteStatistics);
this.Controls.Add(this.LinkModifyStatistics);
this.Controls.Add(this.LinkNewStatistics);
this.Controls.Add(this.ButtonCancel);
this.Controls.Add(this.ButtonDelete);
this.Controls.Add(this.ButtonModify);
this.Controls.Add(this.ButtonNew);
this.Controls.Add(this.ButtonOk);
this.Controls.Add(this.TableStatistics);
this.Controls.Add(this.TableModules);
this.Controls.Add(this.ComboModules);
this.Controls.Add(this.TextModuleName);
this.Controls.Add(this.label2);
this.Controls.Add(this.label1);
this.Name = "StatisticsManagement";
this.Text = "统计项模板设置";
this.Load += new System.EventHandler(this.StatisticsManagement_Load);
((System.ComponentModel.ISupportInitialize)(this.TableModules)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.TableModules_Sheet1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.TableStatistics)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.TableStatistics_Sheet1)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
/// <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);
}