/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
Gscr.Column column1 = new Gscr.Column();
Gscr.Column column2 = new Gscr.Column();
Gscr.Column column3 = new Gscr.Column();
Gscr.Column column4 = new Gscr.Column();
Gscr.Column column5 = new Gscr.Column();
Gscr.Column column6 = new Gscr.Column();
Gscr.Column column7 = new Gscr.Column();
Gscr.Row row1 = new Gscr.Row();
Gscr.Cell cell1 = new Gscr.Cell();
Gscr.Cell cell2 = new Gscr.Cell();
Gscr.Cell cell3 = new Gscr.Cell();
Gscr.Cell cell4 = new Gscr.Cell();
Gscr.Cell cell5 = new Gscr.Cell();
Gscr.Cell cell6 = new Gscr.Cell();
Gscr.Cell cell7 = new Gscr.Cell();
Gscr.Row row2 = new Gscr.Row();
Gscr.Cell cell8 = new Gscr.Cell();
Gscr.Cell cell9 = new Gscr.Cell();
Gscr.Cell cell10 = new Gscr.Cell();
Gscr.Cell cell11 = new Gscr.Cell();
Gscr.Cell cell12 = new Gscr.Cell();
Gscr.Cell cell13 = new Gscr.Cell();
Gscr.Cell cell14 = new Gscr.Cell();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(frmExample11));
Gscr.Row row3 = new Gscr.Row();
Gscr.Cell cell15 = new Gscr.Cell();
Gscr.Cell cell16 = new Gscr.Cell();
Gscr.Cell cell17 = new Gscr.Cell();
Gscr.Cell cell18 = new Gscr.Cell();
Gscr.Cell cell19 = new Gscr.Cell();
Gscr.Cell cell20 = new Gscr.Cell();
Gscr.Cell cell21 = new Gscr.Cell();
Gscr.Print.AdditionalText additionalText1 = new Gscr.Print.AdditionalText();
Gscr.Arguments arguments1 = new Gscr.Arguments();
Gscr.SeriesHeaderStyle seriesHeaderStyle1 = new Gscr.SeriesHeaderStyle();
this.button1 = new System.Windows.Forms.Button();
this.button2 = new System.Windows.Forms.Button();
this.button3 = new System.Windows.Forms.Button();
this.button4 = new System.Windows.Forms.Button();
this.btnClose = new System.Windows.Forms.Button();
this.report1 = new Gscr.Report();
this.button5 = new System.Windows.Forms.Button();
this.radioButton1 = new System.Windows.Forms.RadioButton();
this.radioButton2 = new System.Windows.Forms.RadioButton();
((System.ComponentModel.ISupportInitialize)(this.report1)).BeginInit();
this.SuspendLayout();
//
// button1
//
this.button1.Location = new System.Drawing.Point(28, 26);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(90, 23);
this.button1.TabIndex = 50;
this.button1.Text = "检索";
this.button1.UseVisualStyleBackColor = true;
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// button2
//
this.button2.Location = new System.Drawing.Point(524, 26);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(75, 23);
this.button2.TabIndex = 51;
this.button2.Text = "打印预览";
this.button2.UseVisualStyleBackColor = true;
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// button3
//
this.button3.Location = new System.Drawing.Point(605, 26);
this.button3.Name = "button3";
this.button3.Size = new System.Drawing.Size(75, 23);
this.button3.TabIndex = 52;
this.button3.Text = "导出";
this.button3.UseVisualStyleBackColor = true;
this.button3.Click += new System.EventHandler(this.button3_Click);
//
// button4
//
this.button4.Location = new System.Drawing.Point(690, 26);
this.button4.Name = "button4";
this.button4.Size = new System.Drawing.Size(75, 23);
this.button4.TabIndex = 53;
this.button4.Text = "ReSet";
this.button4.UseVisualStyleBackColor = true;
this.button4.Click += new System.EventHandler(this.button4_Click);
//
// btnClose
//
this.btnClose.Location = new System.Drawing.Point(775, 26);
this.btnClose.Name = "btnClose";
this.btnClose.Size = new System.Drawing.Size(75, 23);
this.btnClose.TabIndex = 54;
this.btnClose.Text = "关闭";
this.btnClose.UseVisualStyleBackColor = true;
this.btnClose.Click += new System.EventHandler(this.btnClose_Click);
//
// report1
//
this.report1.AccountPrefix = "￥";
this.report1.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.report1.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Center;
column1.ColumnName = "column1";
column1.Width = 70;
column2.ColumnName = "column2";
column2.Width = 76;
column3.ColumnName = "column3";
column3.Width = 146;
column4.ColumnName = "column4";
column4.Width = 119;
column5.ColumnName = "column6";
column5.Width = 133;
column6.CellValueType = Gscr.ColumnValueType.Number;
column6.ColumnName = "column7";
column6.Width = 114;
column7.ColumnName = "column13";
column7.Width = 67;
this.report1.Columns.AddRange(new Gscr.Column[] {
column1,
column2,
column3,
column4,
column5,
column6,
column7
});
cell1.Alignment = System.Drawing.StringAlignment.Center;
cell1.DataField = "ID";
cell2.DataField = "姓名";
cell3.DataField = "证件号";
cell4.DataField = "部门";
cell4.DataSourceName = "T_Department";
cell5.Alignment = System.Drawing.StringAlignment.Center;
cell5.DataField = "出生日期";
cell5.FormatString = "yyyy-MM-dd";
cell6.Alignment = System.Drawing.StringAlignment.Far;
cell6.CellDrawMode = Gscr.CellDrawMode.Account;
cell6.DataField = "应发款";
cell7.CellDrawMode = Gscr.CellDrawMode.CheckBox;
cell7.DataField = "作废";
row1.Cells.AddRange(new Gscr.Cell[] {
cell1,
cell2,
cell3,
cell4,
cell5,
cell6,
cell7
});
this.report1.DetailRows.AddRange(new Gscr.Row[] {
row1
});
this.report1.DifferentRowColor = true;
this.report1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
cell8.Alignment = System.Drawing.StringAlignment.Center;
cell8.Value = "合计";
cell9.Alignment = System.Drawing.StringAlignment.Far;
cell9.FormulaExpression = "";
cell9.Value = "记录数";
cell10.FormulaExpression = "=Count([B])";
cell10.Value = 0;
cell11.Alignment = System.Drawing.StringAlignment.Far;
row2.Cells.AddRange(new Gscr.Cell[] {
cell8,
cell9,
cell10,
cell11,
cell12,
cell13,
cell14
});
this.report1.FooterRows.AddRange(new Gscr.Row[] {
row2
});
this.report1.GscrID = ((Gscr.GscrID)(resources.GetObject("report1.GscrID")));
cell15.Alignment = System.Drawing.StringAlignment.Center;
cell15.Value = "ID";
cell16.Alignment = System.Drawing.StringAlignment.Center;
cell16.Value = "姓名";
cell17.Alignment = System.Drawing.StringAlignment.Center;
cell17.Value = "证件号";
cell18.Alignment = System.Drawing.StringAlignment.Center;
cell18.Value = "部门";
cell19.Alignment = System.Drawing.StringAlignment.Center;
cell19.Value = "出生日期";
cell20.Alignment = System.Drawing.StringAlignment.Center;
cell20.Value = "应发款";
cell21.Alignment = System.Drawing.StringAlignment.Center;
cell21.Value = "是否作废";
row3.Cells.AddRange(new Gscr.Cell[] {
cell15,
cell16,
cell17,
cell18,
cell19,
cell20,
cell21
});
this.report1.HeaderRows.AddRange(new Gscr.Row[] {
row3
});
this.report1.Location = new System.Drawing.Point(12, 76);
this.report1.Name = "report1";
additionalText1.FontColor = System.Drawing.Color.Black;
additionalText1.Text = "xxx公司";
this.report1.PrintAdditionalText.Add(additionalText1);
this.report1.PrintMargins = new System.Drawing.Printing.Margins(50, 50, 50, 50);
arguments1.Name = "@ZF";
arguments1.Type = Gscr.ArgumentsType.String;
this.report1.RetrieveArguments.Add(arguments1);
this.report1.SelectSQL = "SELECT * FROM Member Where 作废=@ZF ";
this.report1.SeriesHeaderStyle = seriesHeaderStyle1;
this.report1.Size = new System.Drawing.Size(966, 564);
this.report1.TabIndex = 56;
this.report1.Text = "report1";
//
// button5
//
this.button5.Location = new System.Drawing.Point(139, 26);
this.button5.Name = "button5";
this.button5.Size = new System.Drawing.Size(90, 23);
this.button5.TabIndex = 57;
this.button5.Text = "无参数检索";
this.button5.UseVisualStyleBackColor = true;
this.button5.Click += new System.EventHandler(this.button5_Click);
//
// radioButton1
//
this.radioButton1.AutoSize = true;
this.radioButton1.Checked = true;
this.radioButton1.Location = new System.Drawing.Point(272, 26);
this.radioButton1.Name = "radioButton1";
this.radioButton1.Size = new System.Drawing.Size(47, 16);
this.radioButton1.TabIndex = 58;
this.radioButton1.TabStop = true;
this.radioButton1.Text = "作废";
this.radioButton1.UseVisualStyleBackColor = true;
//
// radioButton2
//
this.radioButton2.AutoSize = true;
this.radioButton2.Location = new System.Drawing.Point(344, 26);
this.radioButton2.Name = "radioButton2";
this.radioButton2.Size = new System.Drawing.Size(47, 16);
this.radioButton2.TabIndex = 59;
this.radioButton2.Text = "有效";
this.radioButton2.UseVisualStyleBackColor = true;
//
// frmExample11
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(990, 652);
this.Controls.Add(this.radioButton2);
this.Controls.Add(this.radioButton1);
this.Controls.Add(this.button5);
this.Controls.Add(this.report1);
this.Controls.Add(this.btnClose);
this.Controls.Add(this.button4);
this.Controls.Add(this.button3);
this.Controls.Add(this.button2);
this.Controls.Add(this.button1);
this.Name = "frmExample11";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "Example11(带参数检索)";
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
this.Load += new System.EventHandler(this.frmExample11_Load);
((System.ComponentModel.ISupportInitialize)(this.report1)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
Gscr.Column column1 = new Gscr.Column();
Gscr.Column column2 = new Gscr.Column();
Gscr.Column column3 = new Gscr.Column();
Gscr.Column column4 = new Gscr.Column();
Gscr.Column column5 = new Gscr.Column();
Gscr.Column column6 = new Gscr.Column();
Gscr.Column column7 = new Gscr.Column();
Gscr.Column column8 = new Gscr.Column();
Gscr.Column column9 = new Gscr.Column();
Gscr.Column column10 = new Gscr.Column();
Gscr.Column column11 = new Gscr.Column();
Gscr.Column column12 = new Gscr.Column();
Gscr.Row row1 = new Gscr.Row();
Gscr.Cell cell1 = new Gscr.Cell();
Gscr.Cell cell2 = new Gscr.Cell();
Gscr.Cell cell3 = new Gscr.Cell();
Gscr.Cell cell4 = new Gscr.Cell();
Gscr.Cell cell5 = new Gscr.Cell();
Gscr.Cell cell6 = new Gscr.Cell();
Gscr.Cell cell7 = new Gscr.Cell();
Gscr.Cell cell8 = new Gscr.Cell();
Gscr.Cell cell9 = new Gscr.Cell();
Gscr.Cell cell10 = new Gscr.Cell();
Gscr.Cell cell11 = new Gscr.Cell();
Gscr.Cell cell12 = new Gscr.Cell();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(frmExample2));
Gscr.Row row2 = new Gscr.Row();
Gscr.Cell cell13 = new Gscr.Cell();
Gscr.Cell cell14 = new Gscr.Cell();
Gscr.Cell cell15 = new Gscr.Cell();
Gscr.Cell cell16 = new Gscr.Cell();
Gscr.Cell cell17 = new Gscr.Cell();
Gscr.Cell cell18 = new Gscr.Cell();
Gscr.Cell cell19 = new Gscr.Cell();
Gscr.Cell cell20 = new Gscr.Cell();
Gscr.Cell cell21 = new Gscr.Cell();
Gscr.Cell cell22 = new Gscr.Cell();
Gscr.Cell cell23 = new Gscr.Cell();
Gscr.Cell cell24 = new Gscr.Cell();
Gscr.Row row3 = new Gscr.Row();
Gscr.Cell cell25 = new Gscr.Cell();
Gscr.Cell cell26 = new Gscr.Cell();
Gscr.Cell cell27 = new Gscr.Cell();
Gscr.Cell cell28 = new Gscr.Cell();
Gscr.Cell cell29 = new Gscr.Cell();
Gscr.Cell cell30 = new Gscr.Cell();
Gscr.Cell cell31 = new Gscr.Cell();
Gscr.Cell cell32 = new Gscr.Cell();
Gscr.Cell cell33 = new Gscr.Cell();
Gscr.Cell cell34 = new Gscr.Cell();
Gscr.Cell cell35 = new Gscr.Cell();
Gscr.Cell cell36 = new Gscr.Cell();
Gscr.Print.AdditionalText additionalText1 = new Gscr.Print.AdditionalText();
Gscr.SeriesHeaderStyle seriesHeaderStyle1 = new Gscr.SeriesHeaderStyle();
Gscr.Row row4 = new Gscr.Row();
Gscr.Cell cell37 = new Gscr.Cell();
Gscr.Cell cell38 = new Gscr.Cell();
Gscr.Cell cell39 = new Gscr.Cell();
Gscr.Cell cell40 = new Gscr.Cell();
Gscr.Cell cell41 = new Gscr.Cell();
Gscr.Cell cell42 = new Gscr.Cell();
Gscr.Cell cell43 = new Gscr.Cell();
Gscr.Cell cell44 = new Gscr.Cell();
Gscr.Cell cell45 = new Gscr.Cell();
Gscr.Cell cell46 = new Gscr.Cell();
Gscr.Cell cell47 = new Gscr.Cell();
Gscr.Cell cell48 = new Gscr.Cell();
Gscr.Row row5 = new Gscr.Row();
Gscr.Cell cell49 = new Gscr.Cell();
Gscr.Cell cell50 = new Gscr.Cell();
Gscr.Cell cell51 = new Gscr.Cell();
Gscr.Cell cell52 = new Gscr.Cell();
Gscr.Cell cell53 = new Gscr.Cell();
Gscr.Cell cell54 = new Gscr.Cell();
Gscr.Cell cell55 = new Gscr.Cell();
Gscr.Cell cell56 = new Gscr.Cell();
Gscr.Cell cell57 = new Gscr.Cell();
Gscr.Cell cell58 = new Gscr.Cell();
Gscr.Cell cell59 = new Gscr.Cell();
Gscr.Cell cell60 = new Gscr.Cell();
Gscr.Row row6 = new Gscr.Row();
Gscr.Cell cell61 = new Gscr.Cell();
Gscr.Cell cell62 = new Gscr.Cell();
Gscr.Cell cell63 = new Gscr.Cell();
Gscr.Cell cell64 = new Gscr.Cell();
Gscr.Cell cell65 = new Gscr.Cell();
Gscr.Cell cell66 = new Gscr.Cell();
Gscr.Cell cell67 = new Gscr.Cell();
Gscr.Cell cell68 = new Gscr.Cell();
Gscr.Cell cell69 = new Gscr.Cell();
Gscr.Cell cell70 = new Gscr.Cell();
Gscr.Cell cell71 = new Gscr.Cell();
Gscr.Cell cell72 = new Gscr.Cell();
Gscr.Row row7 = new Gscr.Row();
Gscr.Cell cell73 = new Gscr.Cell();
Gscr.Cell cell74 = new Gscr.Cell();
Gscr.Cell cell75 = new Gscr.Cell();
Gscr.Cell cell76 = new Gscr.Cell();
Gscr.Cell cell77 = new Gscr.Cell();
Gscr.Cell cell78 = new Gscr.Cell();
Gscr.Cell cell79 = new Gscr.Cell();
Gscr.Cell cell80 = new Gscr.Cell();
Gscr.Cell cell81 = new Gscr.Cell();
Gscr.Cell cell82 = new Gscr.Cell();
Gscr.Cell cell83 = new Gscr.Cell();
Gscr.Cell cell84 = new Gscr.Cell();
Gscr.Row row8 = new Gscr.Row();
Gscr.Cell cell85 = new Gscr.Cell();
Gscr.Cell cell86 = new Gscr.Cell();
Gscr.Cell cell87 = new Gscr.Cell();
Gscr.Cell cell88 = new Gscr.Cell();
Gscr.Cell cell89 = new Gscr.Cell();
Gscr.Cell cell90 = new Gscr.Cell();
Gscr.Cell cell91 = new Gscr.Cell();
Gscr.Cell cell92 = new Gscr.Cell();
Gscr.Cell cell93 = new Gscr.Cell();
Gscr.Cell cell94 = new Gscr.Cell();
Gscr.Cell cell95 = new Gscr.Cell();
Gscr.Cell cell96 = new Gscr.Cell();
this.report1 = new Gscr.Report();
this.button2 = new System.Windows.Forms.Button();
this.button3 = new System.Windows.Forms.Button();
this.btnClose = new System.Windows.Forms.Button();
this.button1 = new System.Windows.Forms.Button();
((System.ComponentModel.ISupportInitialize)(this.report1)).BeginInit();
this.SuspendLayout();
//
// report1
//
this.report1.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.report1.BackColor = System.Drawing.Color.LightSteelBlue;
this.report1.Barcode.EncodedType = Gscr.BarcodeLib.TYPE.UNSPECIFIED;
this.report1.Barcode.EncodingTime = 0;
this.report1.Barcode.Height = 150;
this.report1.Barcode.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg;
this.report1.Barcode.LabelFont = new System.Drawing.Font("Microsoft Sans Serif", 8F);
this.report1.Barcode.RawData = "";
this.report1.Barcode.Width = 300;
column1.ColumnName = "column1";
column1.Width = 82;
column2.ColumnName = "column2";
column2.Width = 131;
column3.ColumnName = "column3";
column3.Width = 59;
column4.CellValueType = Gscr.ColumnValueType.Number;
column4.ColumnName = "column4";
column4.Width = 75;
column5.CellValueType = Gscr.ColumnValueType.Number;
column5.ColumnName = "column5";
column5.Width = 75;
column6.CellValueType = Gscr.ColumnValueType.Number;
column6.ColumnName = "column6";
column6.Width = 75;
column7.CellValueType = Gscr.ColumnValueType.Number;
column7.ColumnName = "column7";
column7.Width = 75;
column8.CellValueType = Gscr.ColumnValueType.Number;
column8.ColumnName = "column8";
column8.Width = 75;
column9.CellValueType = Gscr.ColumnValueType.Number;
column9.ColumnName = "column9";
column9.Width = 75;
column10.CellValueType = Gscr.ColumnValueType.Number;
column10.ColumnName = "column10";
column10.Width = 75;
column11.CellValueType = Gscr.ColumnValueType.Number;
column11.ColumnName = "column11";
column11.Width = 113;
column12.ColumnName = "column12";
column12.Width = 91;
this.report1.Columns.AddRange(new Gscr.Column[] {
column1,
column2,
column3,
column4,
column5,
column6,
column7,
column8,
column9,
column10,
column11,
column12
});
cell1.BorderStyle = Gscr.CellBorderStyle.Right;
cell2.DataField = "Product";
cell3.Alignment = System.Drawing.StringAlignment.Center;
cell3.FormulaExpression = "=[RowNumber]";
cell4.Alignment = System.Drawing.StringAlignment.Far;
cell4.DataField = "M1";
cell4.FormatString = "0.00";
cell5.Alignment = System.Drawing.StringAlignment.Far;
cell5.DataField = "M2";
cell5.FormatString = "0.00";
cell6.Alignment = System.Drawing.StringAlignment.Far;
cell6.DataField = "M3";
cell6.FormatString = "0.00";
cell7.Alignment = System.Drawing.StringAlignment.Far;
cell7.FormatString = "0.00";
cell7.FormulaExpression = "=[D]+[E]+[F]";
cell8.Alignment = System.Drawing.StringAlignment.Far;
cell8.DataField = "M4";
cell8.FormatString = "0.00";
cell9.Alignment = System.Drawing.StringAlignment.Far;
cell9.DataField = "M5";
cell9.FormatString = "0.00";
cell10.Alignment = System.Drawing.StringAlignment.Far;
cell10.DataField = "M6";
cell10.FormatString = "0.00";
cell11.Alignment = System.Drawing.StringAlignment.Far;
cell11.FormatString = "0.00";
cell11.FormulaExpression = "=[H]+[I]+[J]";
cell12.BorderStyle = Gscr.CellBorderStyle.Left;
row1.Cells.AddRange(new Gscr.Cell[] {
cell1,
cell2,
cell3,
cell4,
cell5,
cell6,
cell7,
cell8,
cell9,
cell10,
cell11,
cell12
});
this.report1.DetailRows.AddRange(new Gscr.Row[] {
row1
});
this.report1.DifferentRowColor = true;
this.report1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.report1.GscrID = ((Gscr.GscrID)(resources.GetObject("report1.GscrID")));
cell13.BorderStyle = Gscr.CellBorderStyle.Right;
cell14.BorderStyle = ((Gscr.CellBorderStyle)(((((Gscr.CellBorderStyle.Top | Gscr.CellBorderStyle.Bottom)
| Gscr.CellBorderStyle.Left)
| Gscr.CellBorderStyle.Right)
| Gscr.CellBorderStyle.TwoDiagonal)));
cell14.IsMerge = true;
cell14.MergeEndColumnIndexDiffer = 0;
cell14.MergeEndRowIndexDiffer = 1;
cell14.MergeStartColumnIndexDiffer = 0;
cell14.MergeStartRowIndexDiffer = 0;
cell14.Value = "季度~|销售额~|产品";
cell15.Alignment = System.Drawing.StringAlignment.Center;
cell15.IsMerge = true;
cell15.MergeEndColumnIndexDiffer = 0;
cell15.MergeEndRowIndexDiffer = 1;
cell15.MergeStartColumnIndexDiffer = 0;
cell15.MergeStartRowIndexDiffer = 0;
cell15.Value = "行号";
cell16.Alignment = System.Drawing.StringAlignment.Center;
cell16.IsMerge = true;
cell16.MergeEndColumnIndexDiffer = 3;
cell16.MergeEndRowIndexDiffer = 0;
cell16.MergeStartColumnIndexDiffer = 0;
cell16.MergeStartRowIndexDiffer = 0;
cell16.Value = "一季度";
cell17.IsMerge = true;
cell17.MergeEndColumnIndexDiffer = 2;
cell17.MergeEndRowIndexDiffer = 0;
cell17.MergeStartRowIndexDiffer = 0;
cell18.IsMerge = true;
cell18.MergeEndColumnIndexDiffer = 1;
cell18.MergeEndRowIndexDiffer = 0;
cell18.MergeStartColumnIndexDiffer = -2;
cell18.MergeStartRowIndexDiffer = 0;
cell19.IsMerge = true;
cell19.MergeEndColumnIndexDiffer = 0;
cell19.MergeEndRowIndexDiffer = 0;
cell19.MergeStartColumnIndexDiffer = -3;
cell19.MergeStartRowIndexDiffer = 0;
cell20.Alignment = System.Drawing.StringAlignment.Center;
cell20.IsMerge = true;
cell20.MergeEndColumnIndexDiffer = 3;
cell20.MergeEndRowIndexDiffer = 0;
cell20.MergeStartColumnIndexDiffer = 0;
cell20.MergeStartRowIndexDiffer = 0;
cell20.Value = "二季度";
cell21.IsMerge = true;
cell21.MergeEndColumnIndexDiffer = 2;
cell21.MergeEndRowIndexDiffer = 0;
cell21.MergeStartRowIndexDiffer = 0;
cell22.IsMerge = true;
cell22.MergeEndColumnIndexDiffer = 1;
cell22.MergeEndRowIndexDiffer = 0;
cell22.MergeStartColumnIndexDiffer = -2;
cell22.MergeStartRowIndexDiffer = 0;
cell23.IsMerge = true;
cell23.MergeEndColumnIndexDiffer = 0;
cell23.MergeEndRowIndexDiffer = 0;
cell23.MergeStartColumnIndexDiffer = -3;
cell23.MergeStartRowIndexDiffer = 0;
cell24.BorderStyle = Gscr.CellBorderStyle.Left;
row2.Cells.AddRange(new Gscr.Cell[] {
cell13,
cell14,
cell15,
cell16,
cell17,
cell18,
cell19,
cell20,
cell21,
cell22,
cell23,
cell24
});
row2.Height = 27;
cell25.BorderStyle = Gscr.CellBorderStyle.Right;
cell26.BorderStyle = ((Gscr.CellBorderStyle)(((((Gscr.CellBorderStyle.Top | Gscr.CellBorderStyle.Bottom)
| Gscr.CellBorderStyle.Left)
| Gscr.CellBorderStyle.Right)
| Gscr.CellBorderStyle.TwoDiagonal)));
cell26.IsMerge = true;
cell26.MergeEndColumnIndexDiffer = 0;
cell26.MergeEndRowIndexDiffer = 0;
cell26.MergeStartColumnIndexDiffer = 0;
cell27.IsMerge = true;
cell27.MergeEndColumnIndexDiffer = 0;
cell27.MergeEndRowIndexDiffer = 0;
cell27.MergeStartColumnIndexDiffer = 0;
cell28.Alignment = System.Drawing.StringAlignment.Center;
cell28.Value = "1月";
cell29.Alignment = System.Drawing.StringAlignment.Center;
cell29.Value = "2月";
cell30.Alignment = System.Drawing.StringAlignment.Center;
cell30.Value = "3月";
cell31.Alignment = System.Drawing.StringAlignment.Center;
cell31.Value = "小计";
cell32.Alignment = System.Drawing.StringAlignment.Center;
cell32.Value = "4月";
cell33.Alignment = System.Drawing.StringAlignment.Center;
cell33.Value = "5月";
cell34.Alignment = System.Drawing.StringAlignment.Center;
cell34.Value = "6月";
cell35.Alignment = System.Drawing.StringAlignment.Center;
cell35.Value = "小计";
cell36.BorderStyle = Gscr.CellBorderStyle.Left;
row3.Cells.AddRange(new Gscr.Cell[] {
cell25,
cell26,
cell27,
cell28,
cell29,
cell30,
cell31,
cell32,
cell33,
cell34,
cell35,
cell36
});
row3.Height = 27;
this.report1.HeaderRows.AddRange(new Gscr.Row[] {
row2,
row3
});
this.report1.Location = new System.Drawing.Point(5, 75);
this.report1.Name = "report1";
additionalText1.FontColor = System.Drawing.Color.Black;
additionalText1.Position = Gscr.Print.TextPosition.HTopLeft;
additionalText1.Text = "第[PageNumber]页，共[TotalPages]页";
this.report1.PrintAdditionalText.Add(additionalText1);
this.report1.PrintLandscape = true;
this.report1.PrintMargins = new System.Drawing.Printing.Margins(50, 50, 50, 50);
this.report1.SeriesHeaderStyle = seriesHeaderStyle1;
this.report1.Size = new System.Drawing.Size(948, 571);
cell37.BorderStyle = Gscr.CellBorderStyle.Right;
cell38.Alignment = System.Drawing.StringAlignment.Center;
cell38.Value = "合计";
cell40.Alignment = System.Drawing.StringAlignment.Far;
cell40.FormatString = "0.00";
cell40.FormulaExpression = "=Sum([D])";
cell40.Value = 0;
cell41.Alignment = System.Drawing.StringAlignment.Far;
cell41.FormatString = "0.00";
cell41.FormulaExpression = "=Sum([E])";
cell41.Value = 0;
cell42.Alignment = System.Drawing.StringAlignment.Far;
cell42.FormatString = "0.00";
cell42.FormulaExpression = "=Sum([F])";
cell42.Value = 0;
cell43.Alignment = System.Drawing.StringAlignment.Far;
cell43.FormatString = "0.00";
cell43.FormulaExpression = "=Sum([G])";
cell43.Value = 0;
cell44.Alignment = System.Drawing.StringAlignment.Far;
cell44.FormatString = "0.00";
cell44.FormulaExpression = "=Sum([H])";
cell44.Value = 0;
cell45.Alignment = System.Drawing.StringAlignment.Far;
cell45.FormatString = "0.00";
cell45.FormulaExpression = "=Sum([I])";
cell45.Value = 0;
cell46.Alignment = System.Drawing.StringAlignment.Far;
cell46.FormatString = "0.00";
cell46.FormulaExpression = "=Sum([J])";
cell46.Value = 0;
cell47.Alignment = System.Drawing.StringAlignment.Far;
cell47.FormatString = "0.00";
cell47.FormulaExpression = "=Sum([K])";
cell47.Value = 0;
cell48.BorderStyle = Gscr.CellBorderStyle.Left;
row4.Cells.AddRange(new Gscr.Cell[] {
cell37,
cell38,
cell39,
cell40,
cell41,
cell42,
cell43,
cell44,
cell45,
cell46,
cell47,
cell48
});
cell49.BorderStyle = Gscr.CellBorderStyle.None;
cell50.BorderStyle = Gscr.CellBorderStyle.Top;
cell51.BorderStyle = Gscr.CellBorderStyle.Top;
cell52.BorderStyle = Gscr.CellBorderStyle.Top;
cell53.BorderStyle = Gscr.CellBorderStyle.Top;
cell54.BorderStyle = Gscr.CellBorderStyle.Top;
cell55.BorderStyle = Gscr.CellBorderStyle.Top;
cell56.BorderStyle = Gscr.CellBorderStyle.Top;
cell57.BorderStyle = Gscr.CellBorderStyle.Top;
cell58.BorderStyle = Gscr.CellBorderStyle.Top;
cell59.BorderStyle = Gscr.CellBorderStyle.Top;
cell60.BorderStyle = Gscr.CellBorderStyle.None;
row5.Cells.AddRange(new Gscr.Cell[] {
cell49,
cell50,
cell51,
cell52,
cell53,
cell54,
cell55,
cell56,
cell57,
cell58,
cell59,
cell60
});
row5.Height = 12;
cell61.BorderStyle = Gscr.CellBorderStyle.None;
cell62.BorderStyle = Gscr.CellBorderStyle.None;
cell63.BorderStyle = Gscr.CellBorderStyle.None;
cell64.BorderStyle = Gscr.CellBorderStyle.None;
cell65.BorderStyle = Gscr.CellBorderStyle.None;
cell66.BorderStyle = Gscr.CellBorderStyle.None;
cell66.IsMerge = true;
cell66.MergeEndColumnIndexDiffer = 1;
cell66.MergeEndRowIndexDiffer = 0;
cell66.MergeStartColumnIndexDiffer = 0;
cell66.MergeStartRowIndexDiffer = 0;
cell66.Value = "审核：";
cell67.IsMerge = true;
cell67.MergeEndColumnIndexDiffer = 0;
cell67.MergeEndRowIndexDiffer = 0;
cell67.MergeStartRowIndexDiffer = 0;
cell68.BorderStyle = Gscr.CellBorderStyle.None;
cell69.BorderStyle = Gscr.CellBorderStyle.None;
cell70.BorderStyle = Gscr.CellBorderStyle.None;
cell70.IsMerge = true;
cell70.MergeEndColumnIndexDiffer = 1;
cell70.MergeEndRowIndexDiffer = 0;
cell70.MergeStartColumnIndexDiffer = 0;
cell70.MergeStartRowIndexDiffer = 0;
cell70.Value = "制表：";
cell71.IsMerge = true;
cell71.MergeEndColumnIndexDiffer = 0;
cell71.MergeEndRowIndexDiffer = 0;
cell71.MergeStartRowIndexDiffer = 0;
cell72.BorderStyle = Gscr.CellBorderStyle.None;
row6.Cells.AddRange(new Gscr.Cell[] {
cell61,
cell62,
cell63,
cell64,
cell65,
cell66,
cell67,
cell68,
cell69,
cell70,
cell71,
cell72
});
this.report1.SummaryRows.AddRange(new Gscr.Row[] {
row4,
row5,
row6
});
this.report1.TabIndex = 0;
this.report1.Text = "report1";
cell73.BorderStyle = Gscr.CellBorderStyle.None;
cell74.Alignment = System.Drawing.StringAlignment.Center;
cell74.BorderStyle = Gscr.CellBorderStyle.None;
cell74.Font = new System.Drawing.Font("仿宋_GB2312", 20F);
cell74.ForeColor = System.Drawing.Color.Red;
cell74.IsMerge = true;
cell74.MergeEndColumnIndexDiffer = 9;
cell74.MergeEndRowIndexDiffer = 0;
cell74.MergeStartColumnIndexDiffer = 0;
cell74.MergeStartRowIndexDiffer = 0;
cell74.Value = "产品销售半年报";
cell75.BorderStyle = Gscr.CellBorderStyle.None;
cell75.IsMerge = true;
cell75.MergeEndColumnIndexDiffer = 8;
cell75.MergeEndRowIndexDiffer = 0;
cell75.MergeStartRowIndexDiffer = 0;
cell76.BorderStyle = Gscr.CellBorderStyle.None;
cell76.IsMerge = true;
cell76.MergeEndColumnIndexDiffer = 7;
cell76.MergeEndRowIndexDiffer = 0;
cell76.MergeStartColumnIndexDiffer = -2;
cell76.MergeStartRowIndexDiffer = 0;
cell77.BorderStyle = Gscr.CellBorderStyle.None;
cell77.IsMerge = true;
cell77.MergeEndColumnIndexDiffer = 6;
cell77.MergeEndRowIndexDiffer = 0;
cell77.MergeStartColumnIndexDiffer = -3;
cell77.MergeStartRowIndexDiffer = 0;
cell78.BorderStyle = Gscr.CellBorderStyle.None;
cell78.IsMerge = true;
cell78.MergeEndColumnIndexDiffer = 5;
cell78.MergeEndRowIndexDiffer = 0;
cell78.MergeStartColumnIndexDiffer = -4;
cell78.MergeStartRowIndexDiffer = 0;
cell79.BorderStyle = Gscr.CellBorderStyle.None;
cell79.IsMerge = true;
cell79.MergeEndColumnIndexDiffer = 4;
cell79.MergeEndRowIndexDiffer = 0;
cell79.MergeStartColumnIndexDiffer = -5;
cell79.MergeStartRowIndexDiffer = 0;
cell80.BorderStyle = Gscr.CellBorderStyle.None;
cell80.IsMerge = true;
cell80.MergeEndColumnIndexDiffer = 3;
cell80.MergeEndRowIndexDiffer = 0;
cell80.MergeStartColumnIndexDiffer = -6;
cell80.MergeStartRowIndexDiffer = 0;
cell81.BorderStyle = Gscr.CellBorderStyle.None;
cell81.IsMerge = true;
cell81.MergeEndColumnIndexDiffer = 2;
cell81.MergeEndRowIndexDiffer = 0;
cell81.MergeStartColumnIndexDiffer = -7;
cell81.MergeStartRowIndexDiffer = 0;
cell82.BorderStyle = Gscr.CellBorderStyle.None;
cell82.IsMerge = true;
cell82.MergeEndColumnIndexDiffer = 1;
cell82.MergeEndRowIndexDiffer = 0;
cell82.MergeStartColumnIndexDiffer = -8;
cell82.MergeStartRowIndexDiffer = 0;
cell83.BorderStyle = Gscr.CellBorderStyle.None;
cell83.IsMerge = true;
cell83.MergeEndColumnIndexDiffer = 0;
cell83.MergeEndRowIndexDiffer = 0;
cell83.MergeStartColumnIndexDiffer = -9;
cell83.MergeStartRowIndexDiffer = 0;
cell84.BorderStyle = Gscr.CellBorderStyle.None;
row7.Cells.AddRange(new Gscr.Cell[] {
cell73,
cell74,
cell75,
cell76,
cell77,
cell78,
cell79,
cell80,
cell81,
cell82,
cell83,
cell84
});
row7.Height = 86;
cell85.BorderStyle = Gscr.CellBorderStyle.None;
cell86.BorderStyle = Gscr.CellBorderStyle.Bottom;
cell86.FormulaExpression = "=\"第\"+CString([PageNumber])+\"页，共\"+CString([TotalPages])+\"页\"";
cell86.Value = "第1页，共1页";
cell87.BorderStyle = Gscr.CellBorderStyle.None;
cell88.BorderStyle = Gscr.CellBorderStyle.None;
cell89.BorderStyle = Gscr.CellBorderStyle.None;
cell90.BorderStyle = Gscr.CellBorderStyle.None;
cell91.BorderStyle = Gscr.CellBorderStyle.None;
cell92.BorderStyle = Gscr.CellBorderStyle.None;
cell93.BorderStyle = Gscr.CellBorderStyle.None;
cell94.Alignment = System.Drawing.StringAlignment.Far;
cell94.BorderStyle = Gscr.CellBorderStyle.None;
cell94.Value = "制表日期：";
cell95.BorderStyle = Gscr.CellBorderStyle.None;
cell95.FormulaExpression = "=Format(\"yyyy-MM-dd\",Now())";
cell95.Value = "2013-08-04";
cell96.BorderStyle = Gscr.CellBorderStyle.None;
row8.Cells.AddRange(new Gscr.Cell[] {
cell85,
cell86,
cell87,
cell88,
cell89,
cell90,
cell91,
cell92,
cell93,
cell94,
cell95,
cell96
});
this.report1.TitleRows.AddRange(new Gscr.Row[] {
row7,
row8
});
//
// button2
//
this.button2.Location = new System.Drawing.Point(173, 35);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(75, 23);
this.button2.TabIndex = 51;
this.button2.Text = "打印预览";
this.button2.UseVisualStyleBackColor = true;
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// button3
//
this.button3.Location = new System.Drawing.Point(266, 35);
this.button3.Name = "button3";
this.button3.Size = new System.Drawing.Size(75, 23);
this.button3.TabIndex = 52;
this.button3.Text = "导出";
this.button3.UseVisualStyleBackColor = true;
this.button3.Click += new System.EventHandler(this.button3_Click);
//
// btnClose
//
this.btnClose.Location = new System.Drawing.Point(359, 35);
this.btnClose.Name = "btnClose";
this.btnClose.Size = new System.Drawing.Size(75, 23);
this.btnClose.TabIndex = 55;
this.btnClose.Text = "关闭";
this.btnClose.UseVisualStyleBackColor = true;
this.btnClose.Click += new System.EventHandler(this.btnClose_Click);
//
// button1
//
this.button1.Location = new System.Drawing.Point(36, 35);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(121, 23);
this.button1.TabIndex = 56;
this.button1.Text = "绑定数据(Access)";
this.button1.UseVisualStyleBackColor = true;
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// frmExample2
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(957, 652);
this.Controls.Add(this.button1);
this.Controls.Add(this.btnClose);
this.Controls.Add(this.button3);
this.Controls.Add(this.button2);
this.Controls.Add(this.report1);
this.Name = "frmExample2";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "Example2(常见样式2)";
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
this.Load += new System.EventHandler(this.frmExample2_Load);
((System.ComponentModel.ISupportInitialize)(this.report1)).EndInit();
this.ResumeLayout(false);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
Gscr.Column column1 = new Gscr.Column();
Gscr.Column column2 = new Gscr.Column();
Gscr.Column column3 = new Gscr.Column();
Gscr.Column column4 = new Gscr.Column();
Gscr.Column column5 = new Gscr.Column();
Gscr.Column column6 = new Gscr.Column();
Gscr.Column column7 = new Gscr.Column();
Gscr.Column column8 = new Gscr.Column();
Gscr.Column column9 = new Gscr.Column();
Gscr.Column column10 = new Gscr.Column();
Gscr.Column column11 = new Gscr.Column();
Gscr.Column column12 = new Gscr.Column();
Gscr.Column column13 = new Gscr.Column();
Gscr.Row row1 = new Gscr.Row();
Gscr.Cell cell1 = new Gscr.Cell();
Gscr.Cell cell2 = new Gscr.Cell();
Gscr.Cell cell3 = new Gscr.Cell();
Gscr.Cell cell4 = new Gscr.Cell();
Gscr.Cell cell5 = new Gscr.Cell();
Gscr.Cell cell6 = new Gscr.Cell();
Gscr.Cell cell7 = new Gscr.Cell();
Gscr.Cell cell8 = new Gscr.Cell();
Gscr.Cell cell9 = new Gscr.Cell();
Gscr.Cell cell10 = new Gscr.Cell();
Gscr.Cell cell11 = new Gscr.Cell();
Gscr.Cell cell12 = new Gscr.Cell();
Gscr.Cell cell13 = new Gscr.Cell();
Gscr.Row row2 = new Gscr.Row();
Gscr.Cell cell14 = new Gscr.Cell();
Gscr.Cell cell15 = new Gscr.Cell();
Gscr.Cell cell16 = new Gscr.Cell();
Gscr.Cell cell17 = new Gscr.Cell();
Gscr.Cell cell18 = new Gscr.Cell();
Gscr.Cell cell19 = new Gscr.Cell();
Gscr.Cell cell20 = new Gscr.Cell();
Gscr.Cell cell21 = new Gscr.Cell();
Gscr.Cell cell22 = new Gscr.Cell();
Gscr.Cell cell23 = new Gscr.Cell();
Gscr.Cell cell24 = new Gscr.Cell();
Gscr.Cell cell25 = new Gscr.Cell();
Gscr.Cell cell26 = new Gscr.Cell();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(frmExample6));
Gscr.Row row3 = new Gscr.Row();
Gscr.Cell cell27 = new Gscr.Cell();
Gscr.Cell cell28 = new Gscr.Cell();
Gscr.Cell cell29 = new Gscr.Cell();
Gscr.Cell cell30 = new Gscr.Cell();
Gscr.Cell cell31 = new Gscr.Cell();
Gscr.Cell cell32 = new Gscr.Cell();
Gscr.Cell cell33 = new Gscr.Cell();
Gscr.Cell cell34 = new Gscr.Cell();
Gscr.Cell cell35 = new Gscr.Cell();
Gscr.Cell cell36 = new Gscr.Cell();
Gscr.Cell cell37 = new Gscr.Cell();
Gscr.Cell cell38 = new Gscr.Cell();
Gscr.Cell cell39 = new Gscr.Cell();
Gscr.Print.AdditionalText additionalText1 = new Gscr.Print.AdditionalText();
Gscr.SeriesHeaderStyle seriesHeaderStyle1 = new Gscr.SeriesHeaderStyle();
this.report1 = new Gscr.Report();
this.button1 = new System.Windows.Forms.Button();
this.button2 = new System.Windows.Forms.Button();
this.button3 = new System.Windows.Forms.Button();
this.button4 = new System.Windows.Forms.Button();
this.btnClose = new System.Windows.Forms.Button();
((System.ComponentModel.ISupportInitialize)(this.report1)).BeginInit();
this.SuspendLayout();
//
// report1
//
this.report1.AccountPrefix = "￥";
this.report1.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.report1.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Center;
this.report1.Barcode.EncodedType = Gscr.BarcodeLib.TYPE.UNSPECIFIED;
this.report1.Barcode.EncodingTime = 0;
this.report1.Barcode.Height = 150;
this.report1.Barcode.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg;
this.report1.Barcode.LabelFont = new System.Drawing.Font("Microsoft Sans Serif", 8F);
this.report1.Barcode.RawData = "";
this.report1.Barcode.Width = 300;
column1.ColumnName = "column1";
column1.Width = 70;
column2.ColumnName = "column2";
column2.Width = 76;
column3.ColumnName = "column3";
column3.Width = 193;
column4.ColumnName = "column4";
column4.Width = 98;
column5.ColumnName = "column5";
column5.Width = 70;
column6.ColumnName = "column6";
column6.Width = 107;
column7.CellValueType = Gscr.ColumnValueType.Number;
column7.ColumnName = "column7";
column7.Width = 114;
column8.ColumnName = "column8";
column8.Width = 132;
column9.ColumnName = "column9";
column9.Width = 149;
column10.CellValueType = Gscr.ColumnValueType.Number;
column10.ColumnName = "column10";
column10.Width = 81;
column11.CellValueType = Gscr.ColumnValueType.Number;
column11.ColumnName = "column11";
column11.Width = 81;
column12.ColumnName = "column12";
column12.Width = 107;
column13.ColumnName = "column13";
column13.Width = 67;
this.report1.Columns.AddRange(new Gscr.Column[] {
column1,
column2,
column3,
column4,
column5,
column6,
column7,
column8,
column9,
column10,
column11,
column12,
column13
});
cell1.Alignment = System.Drawing.StringAlignment.Center;
cell1.BorderColor = System.Drawing.Color.RoyalBlue;
cell1.DataField = "ID";
cell2.BorderColor = System.Drawing.Color.RoyalBlue;
cell2.DataField = "姓名";
cell3.BorderColor = System.Drawing.Color.RoyalBlue;
cell3.CellDrawMode = Gscr.CellDrawMode.Barcode;
cell3.DataField = "证件号";
cell4.BorderColor = System.Drawing.Color.RoyalBlue;
cell4.DataField = "部门";
cell4.DataSourceName = "T_Department";
cell5.Alignment = System.Drawing.StringAlignment.Center;
cell5.BorderColor = System.Drawing.Color.RoyalBlue;
cell5.DataField = "性别";
cell5.DataSourceName = "T_Sex";
cell6.Alignment = System.Drawing.StringAlignment.Center;
cell6.BorderColor = System.Drawing.Color.RoyalBlue;
cell6.DataField = "出生日期";
cell6.FormatString = "yyyy-MM-dd";
cell7.Alignment = System.Drawing.StringAlignment.Far;
cell7.BorderColor = System.Drawing.Color.RoyalBlue;
cell7.CellDrawMode = Gscr.CellDrawMode.Account;
cell7.DataField = "应发款";
cell8.BorderColor = System.Drawing.Color.RoyalBlue;
cell8.CellDrawMode = Gscr.CellDrawMode.Image;
cell8.DataField = "照片";
cell9.BorderColor = System.Drawing.Color.RoyalBlue;
cell9.CellDrawMode = Gscr.CellDrawMode.Link;
cell9.DataField = "主页";
cell10.Alignment = System.Drawing.StringAlignment.Far;
cell10.BorderColor = System.Drawing.Color.RoyalBlue;
cell10.DataField = "工作完成量";
cell11.Alignment = System.Drawing.StringAlignment.Center;
cell11.BorderColor = System.Drawing.Color.RoyalBlue;
cell11.CellDrawMode = Gscr.CellDrawMode.ProgressBar;
cell11.DataField = "工作进度";
cell12.BorderColor = System.Drawing.Color.RoyalBlue;
cell12.CellDrawMode = Gscr.CellDrawMode.Password;
cell12.DataField = "登陆密码";
cell13.BorderColor = System.Drawing.Color.RoyalBlue;
cell13.CellDrawMode = Gscr.CellDrawMode.CheckBox;
cell13.DataField = "作废";
row1.Cells.AddRange(new Gscr.Cell[] {
cell1,
cell2,
cell3,
cell4,
cell5,
cell6,
cell7,
cell8,
cell9,
cell10,
cell11,
cell12,
cell13
});
row1.Height = 56;
this.report1.DetailRows.AddRange(new Gscr.Row[] {
row1
});
this.report1.DifferentRowColor = true;
this.report1.FixedColumnCount = 1;
this.report1.Font = new System.Drawing.Font("宋体", 9F);
cell14.Alignment = System.Drawing.StringAlignment.Center;
cell14.BorderColor = System.Drawing.Color.RoyalBlue;
cell14.Value = "合计";
cell15.Alignment = System.Drawing.StringAlignment.Far;
cell15.BorderColor = System.Drawing.Color.RoyalBlue;
cell15.FormulaExpression = "";
cell15.Value = "记录数";
cell16.BorderColor = System.Drawing.Color.RoyalBlue;
cell16.FormulaExpression = "=Count([B])";
cell16.Value = 0;
cell17.Alignment = System.Drawing.StringAlignment.Far;
cell17.BorderColor = System.Drawing.Color.RoyalBlue;
cell17.Value = "工作量合计";
cell18.BorderColor = System.Drawing.Color.RoyalBlue;
cell18.FormulaExpression = "=Sum([J])";
cell18.Value = 0;
cell19.BorderColor = System.Drawing.Color.RoyalBlue;
cell20.BorderColor = System.Drawing.Color.RoyalBlue;
cell21.BorderColor = System.Drawing.Color.RoyalBlue;
cell22.BorderColor = System.Drawing.Color.RoyalBlue;
cell23.BorderColor = System.Drawing.Color.RoyalBlue;
cell24.BorderColor = System.Drawing.Color.RoyalBlue;
cell25.BorderColor = System.Drawing.Color.RoyalBlue;
cell26.BorderColor = System.Drawing.Color.RoyalBlue;
row2.Cells.AddRange(new Gscr.Cell[] {
cell14,
cell15,
cell16,
cell17,
cell18,
cell19,
cell20,
cell21,
cell22,
cell23,
cell24,
cell25,
cell26
});
this.report1.FooterRows.AddRange(new Gscr.Row[] {
row2
});
this.report1.GscrID = ((Gscr.GscrID)(resources.GetObject("report1.GscrID")));
cell27.Alignment = System.Drawing.StringAlignment.Center;
cell27.BorderColor = System.Drawing.Color.RoyalBlue;
cell27.Value = "ID";
cell28.Alignment = System.Drawing.StringAlignment.Center;
cell28.BorderColor = System.Drawing.Color.RoyalBlue;
cell28.Value = "姓名";
cell29.Alignment = System.Drawing.StringAlignment.Center;
cell29.BorderColor = System.Drawing.Color.RoyalBlue;
cell29.Value = "证件号";
cell30.Alignment = System.Drawing.StringAlignment.Center;
cell30.BorderColor = System.Drawing.Color.RoyalBlue;
cell30.Value = "部门";
cell31.Alignment = System.Drawing.StringAlignment.Center;
cell31.BorderColor = System.Drawing.Color.RoyalBlue;
cell31.Value = "性别";
cell32.Alignment = System.Drawing.StringAlignment.Center;
cell32.BorderColor = System.Drawing.Color.RoyalBlue;
cell32.Value = "出生日期";
cell33.Alignment = System.Drawing.StringAlignment.Center;
cell33.BorderColor = System.Drawing.Color.RoyalBlue;
cell33.Value = "应发款";
cell34.Alignment = System.Drawing.StringAlignment.Center;
cell34.BorderColor = System.Drawing.Color.RoyalBlue;
cell34.Value = "照片";
cell35.Alignment = System.Drawing.StringAlignment.Center;
cell35.BorderColor = System.Drawing.Color.RoyalBlue;
cell35.Value = "主页";
cell36.Alignment = System.Drawing.StringAlignment.Center;
cell36.BorderColor = System.Drawing.Color.RoyalBlue;
cell36.Value = "工作完成量";
cell37.Alignment = System.Drawing.StringAlignment.Center;
cell37.BorderColor = System.Drawing.Color.RoyalBlue;
cell37.Value = "工作进度";
cell38.Alignment = System.Drawing.StringAlignment.Center;
cell38.BorderColor = System.Drawing.Color.RoyalBlue;
cell38.Value = "登陆密码";
cell39.Alignment = System.Drawing.StringAlignment.Center;
cell39.BorderColor = System.Drawing.Color.RoyalBlue;
cell39.Value = "是否作废";
row3.Cells.AddRange(new Gscr.Cell[] {
cell27,
cell28,
cell29,
cell30,
cell31,
cell32,
cell33,
cell34,
cell35,
cell36,
cell37,
cell38,
cell39
});
this.report1.HeaderRows.AddRange(new Gscr.Row[] {
row3
});
this.report1.Location = new System.Drawing.Point(5, 75);
this.report1.Name = "report1";
additionalText1.FontColor = System.Drawing.Color.Black;
additionalText1.Text = "xxx公司";
this.report1.PrintAdditionalText.Add(additionalText1);
this.report1.PrintMargins = new System.Drawing.Printing.Margins(50, 50, 50, 50);
this.report1.SelectSQL = "SELECT * FROM Member";
this.report1.SeriesHeaderStyle = seriesHeaderStyle1;
this.report1.Size = new System.Drawing.Size(945, 571);
this.report1.TabIndex = 0;
this.report1.Text = "report1";
this.report1.CellClick += new System.EventHandler <Gscr.CellEventArgs>(this.report1_CellClick);
//
// button1
//
this.button1.Location = new System.Drawing.Point(37, 35);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(75, 23);
this.button1.TabIndex = 50;
this.button1.Text = "绑定数据";
this.button1.UseVisualStyleBackColor = true;
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// button2
//
this.button2.Location = new System.Drawing.Point(130, 35);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(75, 23);
this.button2.TabIndex = 51;
this.button2.Text = "打印预览";
this.button2.UseVisualStyleBackColor = true;
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// button3
//
this.button3.Location = new System.Drawing.Point(223, 35);
this.button3.Name = "button3";
this.button3.Size = new System.Drawing.Size(75, 23);
this.button3.TabIndex = 52;
this.button3.Text = "导出";
this.button3.UseVisualStyleBackColor = true;
this.button3.Click += new System.EventHandler(this.button3_Click);
//
// button4
//
this.button4.Location = new System.Drawing.Point(316, 35);
this.button4.Name = "button4";
this.button4.Size = new System.Drawing.Size(75, 23);
this.button4.TabIndex = 53;
this.button4.Text = "ReSet";
this.button4.UseVisualStyleBackColor = true;
this.button4.Click += new System.EventHandler(this.button4_Click);
//
// btnClose
//
this.btnClose.Location = new System.Drawing.Point(409, 35);
this.btnClose.Name = "btnClose";
this.btnClose.Size = new System.Drawing.Size(75, 23);
this.btnClose.TabIndex = 55;
this.btnClose.Text = "关闭";
this.btnClose.UseVisualStyleBackColor = true;
this.btnClose.Click += new System.EventHandler(this.btnClose_Click);
//
// frmExample6
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(957, 652);
this.Controls.Add(this.btnClose);
this.Controls.Add(this.button4);
this.Controls.Add(this.button3);
this.Controls.Add(this.button2);
this.Controls.Add(this.button1);
this.Controls.Add(this.report1);
this.Name = "frmExample6";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "Example6(多种显示形式)";
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
this.Load += new System.EventHandler(this.frmExample6_Load);
((System.ComponentModel.ISupportInitialize)(this.report1)).EndInit();
this.ResumeLayout(false);
}
