/// <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); }