/// <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(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(frmExample4)); Gscr.Cell cell14 = new Gscr.Cell(); 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.Row row4 = new Gscr.Row(); 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(); Gscr.Cell cell27 = new Gscr.Cell(); Gscr.Cell cell28 = new Gscr.Cell(); Gscr.Row row5 = new Gscr.Row(); 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.Row row6 = new Gscr.Row(); 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.Cell cell40 = new Gscr.Cell(); Gscr.Cell cell41 = new Gscr.Cell(); Gscr.Cell cell42 = new Gscr.Cell(); Gscr.Row row7 = new Gscr.Row(); 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.Cell cell49 = new Gscr.Cell(); Gscr.Row row8 = new Gscr.Row(); 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.Row row9 = new Gscr.Row(); 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.Cell cell61 = new Gscr.Cell(); Gscr.Cell cell62 = new Gscr.Cell(); Gscr.Cell cell63 = new Gscr.Cell(); Gscr.Row row10 = new Gscr.Row(); 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.Row row11 = new Gscr.Row(); Gscr.Cell cell71 = new Gscr.Cell(); Gscr.Cell cell72 = new Gscr.Cell(); 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.Row row12 = new Gscr.Row(); 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 row13 = 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.Row row14 = new Gscr.Row(); 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(); Gscr.Cell cell97 = new Gscr.Cell(); Gscr.Cell cell98 = new Gscr.Cell(); Gscr.Row row15 = new Gscr.Row(); Gscr.Cell cell99 = new Gscr.Cell(); Gscr.Cell cell100 = new Gscr.Cell(); Gscr.Cell cell101 = new Gscr.Cell(); Gscr.Cell cell102 = new Gscr.Cell(); Gscr.Cell cell103 = new Gscr.Cell(); Gscr.Cell cell104 = new Gscr.Cell(); Gscr.Cell cell105 = new Gscr.Cell(); Gscr.Row row16 = new Gscr.Row(); Gscr.Cell cell106 = new Gscr.Cell(); Gscr.Cell cell107 = new Gscr.Cell(); Gscr.Cell cell108 = new Gscr.Cell(); Gscr.Cell cell109 = new Gscr.Cell(); Gscr.Cell cell110 = new Gscr.Cell(); Gscr.Cell cell111 = new Gscr.Cell(); Gscr.Cell cell112 = new Gscr.Cell(); Gscr.Row row17 = new Gscr.Row(); Gscr.Cell cell113 = new Gscr.Cell(); Gscr.Cell cell114 = new Gscr.Cell(); Gscr.Cell cell115 = new Gscr.Cell(); Gscr.Cell cell116 = new Gscr.Cell(); Gscr.Cell cell117 = new Gscr.Cell(); Gscr.Cell cell118 = new Gscr.Cell(); Gscr.Cell cell119 = new Gscr.Cell(); Gscr.SeriesHeaderStyle seriesHeaderStyle1 = new Gscr.SeriesHeaderStyle(); this.report1 = new Gscr.Report(); this.button2 = new System.Windows.Forms.Button(); this.button3 = new System.Windows.Forms.Button(); this.button1 = new System.Windows.Forms.Button(); this.btnClose = new System.Windows.Forms.Button(); this.button4 = new System.Windows.Forms.Button(); ((System.ComponentModel.ISupportInitialize)(this.report1)).BeginInit(); this.SuspendLayout(); // // report1 // this.report1.AllowOrder = false; 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.White; 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 = 53; column2.ColumnName = "column2"; column2.Width = 102; column3.ColumnName = "column3"; column3.Width = 120; column4.ColumnName = "column4"; column5.ColumnName = "column5"; column5.Width = 120; column6.ColumnName = "column6"; column6.Width = 121; column7.ColumnName = "column7"; column7.Width = 57; this.report1.Columns.AddRange(new Gscr.Column[] { column1, column2, column3, column4, column5, column6, column7 }); cell1.BorderStyle = Gscr.CellBorderStyle.None; cell1.IsPrint = false; cell2.Alignment = System.Drawing.StringAlignment.Center; cell2.BorderStyle = Gscr.CellBorderStyle.None; cell2.Font = new System.Drawing.Font("仿宋_GB2312", 20F); cell2.IsMerge = true; cell2.IsPrint = false; cell2.MergeEndColumnIndexDiffer = 4; cell2.MergeEndRowIndexDiffer = 0; cell2.MergeStartColumnIndexDiffer = 0; cell2.MergeStartRowIndexDiffer = 0; cell2.Value = "成员信息"; cell3.IsMerge = true; cell3.MergeEndColumnIndexDiffer = 3; cell3.MergeEndRowIndexDiffer = 0; cell3.MergeStartRowIndexDiffer = 0; cell4.IsMerge = true; cell4.MergeEndColumnIndexDiffer = 2; cell4.MergeEndRowIndexDiffer = 0; cell4.MergeStartColumnIndexDiffer = -2; cell4.MergeStartRowIndexDiffer = 0; cell5.IsMerge = true; cell5.MergeEndColumnIndexDiffer = 1; cell5.MergeEndRowIndexDiffer = 0; cell5.MergeStartColumnIndexDiffer = -3; cell5.MergeStartRowIndexDiffer = 0; cell6.IsMerge = true; cell6.MergeEndColumnIndexDiffer = 0; cell6.MergeEndRowIndexDiffer = 0; cell6.MergeStartColumnIndexDiffer = -4; cell6.MergeStartRowIndexDiffer = 0; cell7.BorderStyle = Gscr.CellBorderStyle.None; cell7.IsPrint = false; row1.Cells.AddRange(new Gscr.Cell[] { cell1, cell2, cell3, cell4, cell5, cell6, cell7 }); row1.Height = 72; cell8.BorderStyle = Gscr.CellBorderStyle.None; cell8.IsPrint = false; cell9.BorderStyle = Gscr.CellBorderStyle.Bottom; cell9.IsPrint = false; cell10.BorderStyle = Gscr.CellBorderStyle.Bottom; cell10.IsPrint = false; cell11.BorderStyle = Gscr.CellBorderStyle.Bottom; cell11.IsPrint = false; cell12.BorderStyle = Gscr.CellBorderStyle.Bottom; cell12.FormulaExpression = ""; cell12.IsPrint = false; cell13.BorderStyle = Gscr.CellBorderStyle.Bottom; cell13.CellDrawMode = Gscr.CellDrawMode.ButtonLeftImageAndText; cell13.IsPrint = false; cell13.Tag = "带图片按钮"; cell13.Value = ((object)(resources.GetObject("cell13.Value"))); cell14.BorderStyle = Gscr.CellBorderStyle.None; cell14.IsPrint = false; row2.Cells.AddRange(new Gscr.Cell[] { cell8, cell9, cell10, cell11, cell12, cell13, cell14 }); row2.Height = 46; cell15.BorderStyle = Gscr.CellBorderStyle.Right; cell15.IsPrint = false; cell16.BackColor = System.Drawing.SystemColors.InactiveCaptionText; cell16.IsMerge = true; cell16.IsPrint = false; cell16.MergeEndColumnIndexDiffer = 4; cell16.MergeEndRowIndexDiffer = 0; cell16.MergeStartColumnIndexDiffer = 0; cell16.MergeStartRowIndexDiffer = 0; cell16.Value = "个人基本简信息"; cell17.IsMerge = true; cell17.MergeEndColumnIndexDiffer = 3; cell17.MergeEndRowIndexDiffer = 0; cell17.MergeStartRowIndexDiffer = 0; cell18.IsMerge = true; cell18.MergeEndColumnIndexDiffer = 2; cell18.MergeEndRowIndexDiffer = 0; cell18.MergeStartColumnIndexDiffer = -2; cell18.MergeStartRowIndexDiffer = 0; cell19.IsMerge = true; cell19.MergeEndColumnIndexDiffer = 1; cell19.MergeEndRowIndexDiffer = 0; cell19.MergeStartColumnIndexDiffer = -3; cell19.MergeStartRowIndexDiffer = 0; cell20.IsMerge = true; cell20.MergeEndColumnIndexDiffer = 0; cell20.MergeEndRowIndexDiffer = 0; cell20.MergeStartColumnIndexDiffer = -4; cell20.MergeStartRowIndexDiffer = 0; cell21.BorderStyle = Gscr.CellBorderStyle.Left; cell21.IsPrint = false; row3.Cells.AddRange(new Gscr.Cell[] { cell15, cell16, cell17, cell18, cell19, cell20, cell21 }); cell22.BorderStyle = Gscr.CellBorderStyle.Right; cell22.IsPrint = false; cell23.Alignment = System.Drawing.StringAlignment.Far; cell23.BackColor = System.Drawing.Color.WhiteSmoke; cell23.IsPrint = false; cell23.Value = "姓名:"; cell24.DataField = "XM"; cell25.Alignment = System.Drawing.StringAlignment.Far; cell25.BackColor = System.Drawing.Color.WhiteSmoke; cell25.IsPrint = false; cell25.Value = "国籍:"; cell26.DataField = "GJ"; cell27.CellDrawMode = Gscr.CellDrawMode.Image; cell27.DataField = "PHOTO"; cell27.IsMerge = true; cell27.MergeEndColumnIndexDiffer = 0; cell27.MergeEndRowIndexDiffer = 4; cell27.MergeStartColumnIndexDiffer = 0; cell27.MergeStartRowIndexDiffer = 0; cell28.BorderStyle = Gscr.CellBorderStyle.Left; cell28.IsPrint = false; row4.Cells.AddRange(new Gscr.Cell[] { cell22, cell23, cell24, cell25, cell26, cell27, cell28 }); cell29.BorderStyle = Gscr.CellBorderStyle.Right; cell29.IsPrint = false; cell30.Alignment = System.Drawing.StringAlignment.Far; cell30.BackColor = System.Drawing.Color.WhiteSmoke; cell30.IsPrint = false; cell30.Value = "目前所在地:"; cell31.DataField = "MQSZD"; cell32.Alignment = System.Drawing.StringAlignment.Far; cell32.BackColor = System.Drawing.Color.WhiteSmoke; cell32.IsPrint = false; cell32.Value = "民族:"; cell33.DataField = "MZ"; cell34.IsMerge = true; cell34.MergeEndColumnIndexDiffer = 0; cell34.MergeEndRowIndexDiffer = 3; cell34.MergeStartColumnIndexDiffer = 0; cell35.BorderStyle = Gscr.CellBorderStyle.Left; cell35.IsPrint = false; row5.Cells.AddRange(new Gscr.Cell[] { cell29, cell30, cell31, cell32, cell33, cell34, cell35 }); cell36.BorderStyle = Gscr.CellBorderStyle.Right; cell36.IsPrint = false; cell37.Alignment = System.Drawing.StringAlignment.Far; cell37.BackColor = System.Drawing.Color.WhiteSmoke; cell37.IsPrint = false; cell37.Value = "户口所在地:"; cell38.DataField = "HKSZD"; cell39.Alignment = System.Drawing.StringAlignment.Far; cell39.BackColor = System.Drawing.Color.WhiteSmoke; cell39.IsPrint = false; cell39.Value = "身高:"; cell40.DataField = "SG"; cell41.IsMerge = true; cell41.MergeEndColumnIndexDiffer = 0; cell41.MergeEndRowIndexDiffer = 2; cell41.MergeStartColumnIndexDiffer = 0; cell41.MergeStartRowIndexDiffer = -2; cell42.BorderStyle = Gscr.CellBorderStyle.Left; cell42.IsPrint = false; row6.Cells.AddRange(new Gscr.Cell[] { cell36, cell37, cell38, cell39, cell40, cell41, cell42 }); cell43.BorderStyle = Gscr.CellBorderStyle.Right; cell43.IsPrint = false; cell44.Alignment = System.Drawing.StringAlignment.Far; cell44.BackColor = System.Drawing.Color.WhiteSmoke; cell44.IsPrint = false; cell44.Value = "婚姻状况:"; cell45.DataField = "HYZK"; cell46.Alignment = System.Drawing.StringAlignment.Far; cell46.BackColor = System.Drawing.Color.WhiteSmoke; cell46.IsPrint = false; cell46.Value = "年龄:"; cell47.DataField = "NL"; cell48.IsMerge = true; cell48.MergeEndColumnIndexDiffer = 0; cell48.MergeEndRowIndexDiffer = 1; cell48.MergeStartColumnIndexDiffer = 0; cell48.MergeStartRowIndexDiffer = -3; cell49.BorderStyle = Gscr.CellBorderStyle.Left; cell49.IsPrint = false; row7.Cells.AddRange(new Gscr.Cell[] { cell43, cell44, cell45, cell46, cell47, cell48, cell49 }); cell50.BorderStyle = Gscr.CellBorderStyle.Right; cell50.IsPrint = false; cell51.Alignment = System.Drawing.StringAlignment.Far; cell51.BackColor = System.Drawing.Color.WhiteSmoke; cell51.IsPrint = false; cell51.Value = "培训认证:"; cell52.DataField = "PXRZ"; cell53.Alignment = System.Drawing.StringAlignment.Far; cell53.BackColor = System.Drawing.Color.WhiteSmoke; cell53.IsPrint = false; cell55.IsMerge = true; cell55.MergeEndColumnIndexDiffer = 0; cell55.MergeEndRowIndexDiffer = 0; cell55.MergeStartColumnIndexDiffer = 0; cell55.MergeStartRowIndexDiffer = -4; cell56.BorderStyle = Gscr.CellBorderStyle.Left; cell56.IsPrint = false; row8.Cells.AddRange(new Gscr.Cell[] { cell50, cell51, cell52, cell53, cell54, cell55, cell56 }); cell57.BorderStyle = Gscr.CellBorderStyle.Right; cell57.IsPrint = false; cell58.BackColor = System.Drawing.SystemColors.InactiveCaptionText; cell58.IsMerge = true; cell58.IsPrint = false; cell58.MergeEndColumnIndexDiffer = 4; cell58.MergeEndRowIndexDiffer = 0; cell58.MergeStartColumnIndexDiffer = 0; cell58.MergeStartRowIndexDiffer = 0; cell58.Value = "教育背景"; cell59.IsMerge = true; cell59.MergeEndColumnIndexDiffer = 3; cell59.MergeEndRowIndexDiffer = 0; cell59.MergeStartRowIndexDiffer = 0; cell60.IsMerge = true; cell60.MergeEndColumnIndexDiffer = 2; cell60.MergeEndRowIndexDiffer = 0; cell60.MergeStartColumnIndexDiffer = -2; cell60.MergeStartRowIndexDiffer = 0; cell61.IsMerge = true; cell61.MergeEndColumnIndexDiffer = 1; cell61.MergeEndRowIndexDiffer = 0; cell61.MergeStartColumnIndexDiffer = -3; cell61.MergeStartRowIndexDiffer = 0; cell62.IsMerge = true; cell62.MergeEndColumnIndexDiffer = 0; cell62.MergeEndRowIndexDiffer = 0; cell62.MergeStartColumnIndexDiffer = -4; cell62.MergeStartRowIndexDiffer = 0; cell63.BorderStyle = Gscr.CellBorderStyle.Left; cell63.IsPrint = false; row9.Cells.AddRange(new Gscr.Cell[] { cell57, cell58, cell59, cell60, cell61, cell62, cell63 }); cell64.BorderStyle = Gscr.CellBorderStyle.Right; cell64.IsPrint = false; cell65.Alignment = System.Drawing.StringAlignment.Far; cell65.BackColor = System.Drawing.Color.WhiteSmoke; cell65.IsPrint = false; cell65.Value = "毕业院校:"; cell66.DataField = "BYYX"; cell67.BackColor = System.Drawing.Color.WhiteSmoke; cell67.IsPrint = false; cell69.CellDrawMode = Gscr.CellDrawMode.Button; cell69.IsMerge = true; cell69.IsPrint = false; cell69.MergeEndColumnIndexDiffer = 0; cell69.MergeEndRowIndexDiffer = 1; cell69.MergeStartColumnIndexDiffer = 0; cell69.MergeStartRowIndexDiffer = 0; cell69.Value = "按钮"; cell70.BorderStyle = Gscr.CellBorderStyle.Left; cell70.IsPrint = false; row10.Cells.AddRange(new Gscr.Cell[] { cell64, cell65, cell66, cell67, cell68, cell69, cell70 }); cell71.BorderStyle = Gscr.CellBorderStyle.Right; cell71.IsPrint = false; cell72.Alignment = System.Drawing.StringAlignment.Far; cell72.BackColor = System.Drawing.Color.WhiteSmoke; cell72.IsPrint = false; cell72.Value = "最高学历:"; cell73.DataField = "ZGXL"; cell74.BackColor = System.Drawing.Color.WhiteSmoke; cell74.IsPrint = false; cell76.CellDrawMode = Gscr.CellDrawMode.Button; cell76.IsMerge = true; cell76.MergeEndColumnIndexDiffer = 0; cell76.MergeEndRowIndexDiffer = 0; cell76.MergeStartColumnIndexDiffer = 0; cell77.BorderStyle = Gscr.CellBorderStyle.Left; cell77.IsPrint = false; row11.Cells.AddRange(new Gscr.Cell[] { cell71, cell72, cell73, cell74, cell75, cell76, cell77 }); cell78.BorderStyle = Gscr.CellBorderStyle.Right; cell78.IsPrint = false; cell79.Alignment = System.Drawing.StringAlignment.Far; cell79.BackColor = System.Drawing.Color.WhiteSmoke; cell79.IsPrint = false; cell79.Value = "所学专业一:"; cell80.DataField = "SXZY1"; cell81.Alignment = System.Drawing.StringAlignment.Far; cell81.BackColor = System.Drawing.Color.WhiteSmoke; cell81.IsPrint = false; cell81.Value = "所学专业二:"; cell82.DataField = "SXZY2"; cell82.IsMerge = true; cell82.MergeEndColumnIndexDiffer = 1; cell82.MergeEndRowIndexDiffer = 0; cell82.MergeStartColumnIndexDiffer = 0; cell82.MergeStartRowIndexDiffer = 0; cell83.IsMerge = true; cell83.MergeEndColumnIndexDiffer = 0; cell83.MergeEndRowIndexDiffer = 0; cell83.MergeStartRowIndexDiffer = 0; cell84.BorderStyle = Gscr.CellBorderStyle.Left; cell84.IsPrint = false; row12.Cells.AddRange(new Gscr.Cell[] { cell78, cell79, cell80, cell81, cell82, cell83, cell84 }); cell85.BorderStyle = Gscr.CellBorderStyle.Right; cell85.IsPrint = false; cell86.Alignment = System.Drawing.StringAlignment.Center; cell86.BackColor = System.Drawing.Color.WhiteSmoke; cell86.IsPrint = false; cell86.Value = "受教育培训经历:"; cell87.DataField = "SJYPXJL"; cell87.IsMerge = true; cell87.IsPrint = false; cell87.MergeEndColumnIndexDiffer = 3; cell87.MergeEndRowIndexDiffer = 0; cell87.MergeStartColumnIndexDiffer = 0; cell87.MergeStartRowIndexDiffer = 0; cell88.BackColor = System.Drawing.Color.WhiteSmoke; cell88.IsMerge = true; cell88.MergeEndColumnIndexDiffer = 2; cell88.MergeEndRowIndexDiffer = 0; cell88.MergeStartRowIndexDiffer = 0; cell89.IsMerge = true; cell89.MergeEndColumnIndexDiffer = 1; cell89.MergeEndRowIndexDiffer = 0; cell89.MergeStartColumnIndexDiffer = -2; cell89.MergeStartRowIndexDiffer = 0; cell90.IsMerge = true; cell90.MergeEndColumnIndexDiffer = 0; cell90.MergeEndRowIndexDiffer = 0; cell90.MergeStartColumnIndexDiffer = -3; cell90.MergeStartRowIndexDiffer = 0; cell91.BorderStyle = Gscr.CellBorderStyle.Left; cell91.IsPrint = false; row13.Cells.AddRange(new Gscr.Cell[] { cell85, cell86, cell87, cell88, cell89, cell90, cell91 }); row13.Height = 79; cell92.BorderStyle = Gscr.CellBorderStyle.Right; cell92.IsPrint = false; cell93.BackColor = System.Drawing.SystemColors.InactiveCaptionText; cell93.IsMerge = true; cell93.IsPrint = false; cell93.MergeEndColumnIndexDiffer = 4; cell93.MergeEndRowIndexDiffer = 0; cell93.MergeStartColumnIndexDiffer = 0; cell93.MergeStartRowIndexDiffer = 0; cell93.Value = "语言能力"; cell94.IsMerge = true; cell94.MergeEndColumnIndexDiffer = 3; cell94.MergeEndRowIndexDiffer = 0; cell94.MergeStartRowIndexDiffer = 0; cell95.IsMerge = true; cell95.MergeEndColumnIndexDiffer = 2; cell95.MergeEndRowIndexDiffer = 0; cell95.MergeStartColumnIndexDiffer = -2; cell95.MergeStartRowIndexDiffer = 0; cell96.IsMerge = true; cell96.MergeEndColumnIndexDiffer = 1; cell96.MergeEndRowIndexDiffer = 0; cell96.MergeStartColumnIndexDiffer = -3; cell96.MergeStartRowIndexDiffer = 0; cell97.IsMerge = true; cell97.MergeEndColumnIndexDiffer = 0; cell97.MergeEndRowIndexDiffer = 0; cell97.MergeStartColumnIndexDiffer = -4; cell97.MergeStartRowIndexDiffer = 0; cell98.BorderStyle = Gscr.CellBorderStyle.Left; cell98.IsPrint = false; row14.Cells.AddRange(new Gscr.Cell[] { cell92, cell93, cell94, cell95, cell96, cell97, cell98 }); cell99.BorderStyle = Gscr.CellBorderStyle.Right; cell99.IsPrint = false; cell100.Alignment = System.Drawing.StringAlignment.Far; cell100.BackColor = System.Drawing.Color.WhiteSmoke; cell100.IsPrint = false; cell100.Value = "外语:"; cell101.DataField = "WY"; cell102.BackColor = System.Drawing.Color.WhiteSmoke; cell102.IsPrint = false; cell103.IsMerge = true; cell103.MergeEndColumnIndexDiffer = 1; cell103.MergeEndRowIndexDiffer = 0; cell103.MergeStartColumnIndexDiffer = 0; cell103.MergeStartRowIndexDiffer = 0; cell104.IsMerge = true; cell104.MergeEndColumnIndexDiffer = 0; cell104.MergeEndRowIndexDiffer = 0; cell104.MergeStartRowIndexDiffer = 0; cell105.BorderStyle = Gscr.CellBorderStyle.Left; cell105.IsPrint = false; row15.Cells.AddRange(new Gscr.Cell[] { cell99, cell100, cell101, cell102, cell103, cell104, cell105 }); cell106.BorderStyle = Gscr.CellBorderStyle.Right; cell106.IsPrint = false; cell107.Alignment = System.Drawing.StringAlignment.Far; cell107.BackColor = System.Drawing.Color.WhiteSmoke; cell107.IsPrint = false; cell107.Value = "国语水平:"; cell108.DataField = "GYSP"; cell109.Alignment = System.Drawing.StringAlignment.Far; cell109.BackColor = System.Drawing.Color.WhiteSmoke; cell109.IsPrint = false; cell109.Value = "粤语水平:"; cell110.DataField = "YYSP"; cell110.IsMerge = true; cell110.MergeEndColumnIndexDiffer = 1; cell110.MergeEndRowIndexDiffer = 0; cell110.MergeStartColumnIndexDiffer = 0; cell110.MergeStartRowIndexDiffer = 0; cell111.IsMerge = true; cell111.MergeEndColumnIndexDiffer = 0; cell111.MergeEndRowIndexDiffer = 0; cell111.MergeStartRowIndexDiffer = 0; cell112.BorderStyle = Gscr.CellBorderStyle.Left; cell112.IsPrint = false; row16.Cells.AddRange(new Gscr.Cell[] { cell106, cell107, cell108, cell109, cell110, cell111, cell112 }); cell113.BorderStyle = Gscr.CellBorderStyle.None; cell113.IsPrint = false; cell114.BorderStyle = Gscr.CellBorderStyle.Top; cell114.IsPrint = false; cell115.BorderStyle = Gscr.CellBorderStyle.Top; cell115.IsPrint = false; cell116.BorderStyle = Gscr.CellBorderStyle.Top; cell116.IsPrint = false; cell117.BorderStyle = Gscr.CellBorderStyle.Top; cell117.IsPrint = false; cell118.BorderStyle = Gscr.CellBorderStyle.Top; cell118.IsPrint = false; cell119.BorderStyle = Gscr.CellBorderStyle.None; cell119.IsPrint = false; row17.Cells.AddRange(new Gscr.Cell[] { cell113, cell114, cell115, cell116, cell117, cell118, cell119 }); this.report1.DetailRows.AddRange(new Gscr.Row[] { row1, row2, row3, row4, row5, row6, row7, row8, row9, row10, row11, row12, row13, row14, row15, row16, row17 }); this.report1.FixedHeaderRows = false; this.report1.Font = new System.Drawing.Font("宋体", 9F); this.report1.GscrID = ((Gscr.GscrID)(resources.GetObject("report1.GscrID"))); this.report1.IsLoadDetailRowsInitialize = true; this.report1.Location = new System.Drawing.Point(5, 75); this.report1.Name = "report1"; this.report1.PrintCellBorder = false; this.report1.PrintMargins = new System.Drawing.Printing.Margins(50, 50, 50, 50); this.report1.SeriesHeaderStyle = seriesHeaderStyle1; this.report1.ShowSeriesHeader = false; this.report1.Size = new System.Drawing.Size(948, 571); this.report1.TabIndex = 0; this.report1.Text = "report1"; this.report1.Click += new System.EventHandler(this.report1_Click); this.report1.CellClick += new System.EventHandler <Gscr.CellEventArgs>(this.report1_CellClick); // // button2 // this.button2.Location = new System.Drawing.Point(167, 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(344, 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); // // button1 // this.button1.Location = new System.Drawing.Point(35, 35); this.button1.Name = "button1"; this.button1.Size = new System.Drawing.Size(113, 23); this.button1.TabIndex = 53; this.button1.Text = "绑定数据(Access)"; this.button1.UseVisualStyleBackColor = true; this.button1.Click += new System.EventHandler(this.button1_Click); // // btnClose // this.btnClose.Location = new System.Drawing.Point(437, 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); // // button4 // this.button4.Location = new System.Drawing.Point(256, 35); this.button4.Name = "button4"; this.button4.Size = new System.Drawing.Size(75, 23); this.button4.TabIndex = 56; this.button4.Text = "打印"; this.button4.UseVisualStyleBackColor = true; this.button4.Click += new System.EventHandler(this.button4_Click); // // frmExample4 // 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.button4); this.Controls.Add(this.btnClose); this.Controls.Add(this.button1); this.Controls.Add(this.button3); this.Controls.Add(this.button2); this.Controls.Add(this.report1); this.Name = "frmExample4"; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; this.Text = "Example4(自由格式之套打)"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; ((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.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(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(frmExample17)); Gscr.Row row2 = new Gscr.Row(); 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.SeriesHeaderStyle seriesHeaderStyle1 = new Gscr.SeriesHeaderStyle(); 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.AllowOrder = false; 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.White; 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.CellValueType = Gscr.ColumnValueType.Number; column1.ColumnName = "本期收入"; column1.Width = 150; column2.CellValueType = Gscr.ColumnValueType.Number; column2.ColumnName = "本期支出"; column2.Width = 150; column3.CellValueType = Gscr.ColumnValueType.Number; column3.ColumnName = "收支差"; column3.Width = 150; column4.CellValueType = Gscr.ColumnValueType.Number; column4.ColumnName = "本期余额"; column4.Width = 150; this.report1.Columns.AddRange(new Gscr.Column[] { column1, column2, column3, column4 }); cell1.Alignment = System.Drawing.StringAlignment.Far; cell1.DataField = "SR"; cell1.FormatString = "0.00"; cell2.Alignment = System.Drawing.StringAlignment.Far; cell2.DataField = "ZC"; cell2.FormatString = "0.00"; cell3.Alignment = System.Drawing.StringAlignment.Far; cell3.FormatString = "0.00"; cell3.FormulaExpression = "=[本期收入] - [本期支出]"; cell4.Alignment = System.Drawing.StringAlignment.Far; cell4.ForeColor = System.Drawing.Color.Blue; cell4.FormatString = "0.00"; cell4.FormulaExpression = "=[本期收入] - [本期支出] + GetDetailUpRowValue([本期余额])"; row1.Cells.AddRange(new Gscr.Cell[] { cell1, cell2, cell3, cell4 }); this.report1.DetailRows.AddRange(new Gscr.Row[] { row1 }); this.report1.Font = new System.Drawing.Font("宋体", 9F); this.report1.GscrID = ((Gscr.GscrID)(resources.GetObject("report1.GscrID"))); cell5.Alignment = System.Drawing.StringAlignment.Center; cell5.Value = "本期收入"; cell6.Alignment = System.Drawing.StringAlignment.Center; cell6.Value = "本期支出"; cell7.Alignment = System.Drawing.StringAlignment.Center; cell7.Value = "收支差"; cell8.Alignment = System.Drawing.StringAlignment.Center; cell8.Value = "本期余额"; row2.Cells.AddRange(new Gscr.Cell[] { cell5, cell6, cell7, cell8 }); this.report1.HeaderRows.AddRange(new Gscr.Row[] { row2 }); this.report1.Location = new System.Drawing.Point(5, 75); this.report1.Name = "report1"; this.report1.PrintCellBackColor = true; this.report1.PrintMargins = new System.Drawing.Printing.Margins(50, 50, 50, 50); this.report1.SelectSQL = "SELECT \n\tAccount.SR,\n\tAccount.ZC\nFROM\n\tAccount "; this.report1.SeriesHeaderStyle = seriesHeaderStyle1; this.report1.Size = new System.Drawing.Size(948, 571); this.report1.TabIndex = 0; this.report1.Text = "report1"; // // 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); // // frmExample17 // 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 = "frmExample17"; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; this.Text = "示例17(余额计算)"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.frmExample17_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 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.Column column14 = new Gscr.Column(); Gscr.Column column15 = new Gscr.Column(); Gscr.Column column16 = new Gscr.Column(); Gscr.Row row4 = 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.Row row5 = new Gscr.Row(); 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.Cell cell40 = new Gscr.Cell(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(frmExample15)); Gscr.Row row6 = new Gscr.Row(); 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.SeriesHeaderStyle seriesHeaderStyle2 = new Gscr.SeriesHeaderStyle(); 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.button7 = new System.Windows.Forms.Button(); this.checkBox1 = new System.Windows.Forms.CheckBox(); ((System.ComponentModel.ISupportInitialize)(this.report1)).BeginInit(); this.SuspendLayout(); // // button2 // this.button2.Location = new System.Drawing.Point(531, 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(612, 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(697, 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(782, 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.AllowOrder = false; 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; column9.ColumnName = "column1"; column9.Width = 70; column10.ColumnName = "column2"; column10.Width = 95; column11.ColumnName = "column3"; column11.Width = 146; column12.CellValueType = Gscr.ColumnValueType.Number; column12.ColumnName = "column4"; column12.Width = 119; column13.ColumnName = "column8"; column13.Width = 73; column14.ColumnName = "column6"; column14.Width = 133; column15.ColumnName = "column7"; column15.Width = 114; column16.CellValueType = Gscr.ColumnValueType.Number; column16.ColumnName = "column5"; this.report1.Columns.AddRange(new Gscr.Column[] { column9, column10, column11, column12, column13, column14, column15, column16 }); cell25.Alignment = System.Drawing.StringAlignment.Center; cell25.DataField = "单据号"; cell26.DataField = "仓库"; cell27.DataField = "供应商"; cell28.Alignment = System.Drawing.StringAlignment.Center; cell28.DataField = "金额"; cell28.DataSourceName = ""; cell28.FormatString = "0.00"; cell29.Alignment = System.Drawing.StringAlignment.Center; cell29.DataField = "单位"; cell29.DataSourceName = "T_Unit"; cell30.Alignment = System.Drawing.StringAlignment.Center; cell30.DataField = "商品编码"; cell30.FormatString = ""; cell31.Alignment = System.Drawing.StringAlignment.Center; cell31.DataField = "商品名称"; cell32.Alignment = System.Drawing.StringAlignment.Center; cell32.DataField = "数量"; row4.Cells.AddRange(new Gscr.Cell[] { cell25, cell26, cell27, cell28, cell29, cell30, cell31, cell32 }); this.report1.DetailRows.AddRange(new Gscr.Row[] { row4 }); this.report1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); cell33.Alignment = System.Drawing.StringAlignment.Center; cell33.Value = "合计"; cell34.Alignment = System.Drawing.StringAlignment.Far; cell34.FormulaExpression = ""; cell34.Value = "记录数"; cell35.FormulaExpression = "=Count([B])"; cell35.Value = 0; cell36.Alignment = System.Drawing.StringAlignment.Far; row5.Cells.AddRange(new Gscr.Cell[] { cell33, cell34, cell35, cell36, cell37, cell38, cell39, cell40 }); this.report1.FooterRows.AddRange(new Gscr.Row[] { row5 }); this.report1.GscrID = ((Gscr.GscrID)(resources.GetObject("report1.GscrID"))); cell41.Alignment = System.Drawing.StringAlignment.Center; cell41.DataField = ""; cell41.Value = "单据号"; cell42.Alignment = System.Drawing.StringAlignment.Center; cell42.Value = "仓库"; cell43.Alignment = System.Drawing.StringAlignment.Center; cell43.Value = "供应商"; cell44.Alignment = System.Drawing.StringAlignment.Center; cell44.Value = "金额"; cell45.Alignment = System.Drawing.StringAlignment.Center; cell45.Value = "单位"; cell46.Alignment = System.Drawing.StringAlignment.Center; cell46.Value = "商品编码"; cell47.Alignment = System.Drawing.StringAlignment.Center; cell47.Value = "商品名称"; cell48.Alignment = System.Drawing.StringAlignment.Center; cell48.Value = "数量"; row6.Cells.AddRange(new Gscr.Cell[] { cell41, cell42, cell43, cell44, cell45, cell46, cell47, cell48 }); this.report1.HeaderRows.AddRange(new Gscr.Row[] { row6 }); this.report1.Location = new System.Drawing.Point(12, 106); this.report1.Name = "report1"; this.report1.PrintMargins = new System.Drawing.Printing.Margins(50, 50, 50, 50); this.report1.SelectSQL = ""; this.report1.SeriesHeaderStyle = seriesHeaderStyle2; this.report1.Size = new System.Drawing.Size(966, 534); this.report1.TabIndex = 56; this.report1.Text = "report1"; // // button7 // this.button7.Location = new System.Drawing.Point(41, 26); this.button7.Name = "button7"; this.button7.Size = new System.Drawing.Size(222, 23); this.button7.TabIndex = 58; this.button7.Text = "绑定List"; this.button7.UseVisualStyleBackColor = true; this.button7.Click += new System.EventHandler(this.button7_Click); // // checkBox1 // this.checkBox1.AutoSize = true; this.checkBox1.Checked = true; this.checkBox1.CheckState = System.Windows.Forms.CheckState.Checked; this.checkBox1.Location = new System.Drawing.Point(321, 32); this.checkBox1.Name = "checkBox1"; this.checkBox1.Size = new System.Drawing.Size(132, 16); this.checkBox1.TabIndex = 59; this.checkBox1.Text = "单据号等隐藏重复值"; this.checkBox1.UseVisualStyleBackColor = true; // // frmExample15 // 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.checkBox1); this.Controls.Add(this.button7); 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.Name = "frmExample15"; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; this.Text = "Example15(List数据源)"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.frmExample15_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> /// 设计器支持所需的方法 - 不要 /// 使用代码编辑器修改此方法的内容。 /// </summary> private void InitializeComponent() { System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(frmExample14)); Gscr.SeriesHeaderStyle seriesHeaderStyle1 = new Gscr.SeriesHeaderStyle(); this.report1 = new Gscr.Report(); this.button1 = new System.Windows.Forms.Button(); this.btnClose = new System.Windows.Forms.Button(); this.btnClear = 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.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; 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"))); this.report1.Location = new System.Drawing.Point(12, 70); this.report1.Name = "report1"; this.report1.PrintMargins = new System.Drawing.Printing.Margins(50, 50, 50, 50); this.report1.ReadOnly = false; this.report1.SeriesHeaderStyle = seriesHeaderStyle1; this.report1.Size = new System.Drawing.Size(772, 345); this.report1.TabIndex = 0; this.report1.Text = "report1"; // // button1 // this.button1.Location = new System.Drawing.Point(12, 28); this.button1.Name = "button1"; this.button1.Size = new System.Drawing.Size(148, 23); this.button1.TabIndex = 1; this.button1.Text = "开始读取Excel文件"; this.button1.UseVisualStyleBackColor = true; this.button1.Click += new System.EventHandler(this.button13_Click); // // btnClose // this.btnClose.Location = new System.Drawing.Point(282, 28); 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); // // btnClear // this.btnClear.Location = new System.Drawing.Point(184, 28); this.btnClear.Name = "btnClear"; this.btnClear.Size = new System.Drawing.Size(75, 23); this.btnClear.TabIndex = 56; this.btnClear.Text = "清空"; this.btnClear.UseVisualStyleBackColor = true; this.btnClear.Click += new System.EventHandler(this.btnClear_Click); // // frmExample14 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(796, 427); this.Controls.Add(this.btnClear); this.Controls.Add(this.btnClose); this.Controls.Add(this.button1); this.Controls.Add(this.report1); this.Name = "frmExample14"; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; this.Text = "Example14(读取Excel文件)"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.frmExample14_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.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.Row row2 = new Gscr.Row(); 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(); Gscr.Cell cell15 = new Gscr.Cell(); Gscr.Cell cell16 = new Gscr.Cell(); Gscr.Row row3 = new Gscr.Row(); 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 row4 = 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.GroupInfo groupInfo1 = new Gscr.GroupInfo(); Gscr.GroupInfo groupInfo2 = new Gscr.GroupInfo(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(frmExample9)); Gscr.Row row5 = new Gscr.Row(); 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.Cell cell40 = new Gscr.Cell(); Gscr.SeriesHeaderStyle seriesHeaderStyle1 = new Gscr.SeriesHeaderStyle(); Gscr.Row row6 = new Gscr.Row(); 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 row7 = 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(); 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(); ((System.ComponentModel.ISupportInitialize)(this.report1)).BeginInit(); this.SuspendLayout(); // // 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); // // 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 = 95; column2.ColumnName = "column2"; column2.Width = 101; column3.ColumnName = "column3"; column3.Width = 168; column4.ColumnName = "column4"; column4.Width = 131; column5.ColumnName = "column5"; column5.Width = 70; column6.ColumnName = "column6"; column6.Width = 107; column7.CellValueType = Gscr.ColumnValueType.Number; column7.ColumnName = "column7"; column7.Width = 114; column8.CellValueType = Gscr.ColumnValueType.Number; column8.ColumnName = "column10"; column8.Width = 119; this.report1.Columns.AddRange(new Gscr.Column[] { column1, column2, column3, column4, column5, column6, column7, column8 }); 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.DataSourceName = "T_Sex"; cell6.Alignment = System.Drawing.StringAlignment.Center; cell6.DataField = "出生日期"; cell6.FormatString = "yyyy-MM-dd"; cell7.Alignment = System.Drawing.StringAlignment.Far; cell7.DataField = "应发款"; cell8.Alignment = System.Drawing.StringAlignment.Far; cell8.DataField = "工作完成量"; row1.Cells.AddRange(new Gscr.Cell[] { cell1, cell2, cell3, cell4, cell5, cell6, cell7, cell8 }); this.report1.DetailRows.AddRange(new Gscr.Row[] { row1 }); this.report1.DifferentRowColor = true; this.report1.Font = new System.Drawing.Font("宋体", 9F); cell9.Alignment = System.Drawing.StringAlignment.Far; cell9.BackColor = System.Drawing.Color.AntiqueWhite; cell9.Value = "---部门小计---"; cell10.BackColor = System.Drawing.Color.AntiqueWhite; cell10.DataSourceName = ""; cell10.FormulaExpression = ""; cell11.BackColor = System.Drawing.Color.AntiqueWhite; cell11.FormulaExpression = "=\"记录数:\" + CString(Count([column3]))"; cell12.BackColor = System.Drawing.Color.AntiqueWhite; cell13.BackColor = System.Drawing.Color.AntiqueWhite; cell14.BackColor = System.Drawing.Color.AntiqueWhite; cell15.Alignment = System.Drawing.StringAlignment.Far; cell15.BackColor = System.Drawing.Color.AntiqueWhite; cell15.FormulaExpression = "=Sum([column7])"; cell16.Alignment = System.Drawing.StringAlignment.Far; cell16.BackColor = System.Drawing.Color.AntiqueWhite; cell16.FormulaExpression = "=Sum([column10])"; row2.Cells.AddRange(new Gscr.Cell[] { cell9, cell10, cell11, cell12, cell13, cell14, cell15, cell16 }); row2.GroupName = "部门"; this.report1.GroupFooterRows.AddRange(new Gscr.Row[] { row2 }); cell17.Alignment = System.Drawing.StringAlignment.Far; cell17.BackColor = System.Drawing.Color.AntiqueWhite; cell17.FormulaExpression = ""; cell17.Value = "部门:"; cell18.BackColor = System.Drawing.Color.AntiqueWhite; cell18.BorderStyle = ((Gscr.CellBorderStyle)(((Gscr.CellBorderStyle.Top | Gscr.CellBorderStyle.Bottom) | Gscr.CellBorderStyle.Left))); cell18.DataSourceName = "T_Department"; cell18.FormulaExpression = "=[GroupValue]"; cell19.BackColor = System.Drawing.Color.AntiqueWhite; cell19.BorderStyle = ((Gscr.CellBorderStyle)((Gscr.CellBorderStyle.Top | Gscr.CellBorderStyle.Bottom))); cell19.FormulaExpression = "=\"部门代码:\" + [GroupValue]"; cell20.BackColor = System.Drawing.Color.AntiqueWhite; cell20.BorderStyle = ((Gscr.CellBorderStyle)((Gscr.CellBorderStyle.Top | Gscr.CellBorderStyle.Bottom))); cell21.BackColor = System.Drawing.Color.AntiqueWhite; cell21.BorderStyle = ((Gscr.CellBorderStyle)((Gscr.CellBorderStyle.Top | Gscr.CellBorderStyle.Bottom))); cell22.BackColor = System.Drawing.Color.AntiqueWhite; cell22.BorderStyle = ((Gscr.CellBorderStyle)((Gscr.CellBorderStyle.Top | Gscr.CellBorderStyle.Bottom))); cell23.BackColor = System.Drawing.Color.AntiqueWhite; cell23.BorderStyle = ((Gscr.CellBorderStyle)((Gscr.CellBorderStyle.Top | Gscr.CellBorderStyle.Bottom))); cell24.BackColor = System.Drawing.Color.AntiqueWhite; cell24.BorderStyle = ((Gscr.CellBorderStyle)(((Gscr.CellBorderStyle.Top | Gscr.CellBorderStyle.Bottom) | Gscr.CellBorderStyle.Right))); row3.Cells.AddRange(new Gscr.Cell[] { cell17, cell18, cell19, cell20, cell21, cell22, cell23, cell24 }); row3.GroupName = "部门"; cell25.Alignment = System.Drawing.StringAlignment.Far; cell25.BackColor = System.Drawing.Color.Azure; cell25.Value = "性别:"; cell26.BackColor = System.Drawing.Color.Azure; cell26.DataSourceName = "T_Sex"; cell26.FormulaExpression = "=[GroupValue]"; cell27.BackColor = System.Drawing.Color.Azure; cell27.FormulaExpression = "=\"记录数:\" + CString(Count([column3]))"; cell28.BackColor = System.Drawing.Color.Azure; cell29.BackColor = System.Drawing.Color.Azure; cell30.BackColor = System.Drawing.Color.Azure; cell31.Alignment = System.Drawing.StringAlignment.Far; cell31.BackColor = System.Drawing.Color.Azure; cell31.FormulaExpression = "=Sum([column7])"; cell32.Alignment = System.Drawing.StringAlignment.Far; cell32.BackColor = System.Drawing.Color.Azure; cell32.FormulaExpression = "=Sum([column10])"; row4.Cells.AddRange(new Gscr.Cell[] { cell25, cell26, cell27, cell28, cell29, cell30, cell31, cell32 }); row4.GroupName = "性别"; this.report1.GroupHeaderRows.AddRange(new Gscr.Row[] { row3, row4 }); groupInfo1.GroupExpression = "=[column4]"; groupInfo1.IncludeGroupFooter = true; groupInfo1.IncludeGroupHeader = true; groupInfo1.Name = "部门"; groupInfo2.GroupExpression = "=[column5]"; groupInfo2.IncludeGroupHeader = true; groupInfo2.Name = "性别"; this.report1.GroupInfos.Add(groupInfo1); this.report1.GroupInfos.Add(groupInfo2); this.report1.GscrID = ((Gscr.GscrID)(resources.GetObject("report1.GscrID"))); cell33.Alignment = System.Drawing.StringAlignment.Center; cell33.Value = "ID"; cell34.Alignment = System.Drawing.StringAlignment.Center; cell34.Value = "姓名"; cell35.Alignment = System.Drawing.StringAlignment.Center; cell35.Value = "证件号"; cell36.Alignment = System.Drawing.StringAlignment.Center; cell36.Value = "部门"; cell37.Alignment = System.Drawing.StringAlignment.Center; cell37.Value = "性别"; cell38.Alignment = System.Drawing.StringAlignment.Center; cell38.Value = "出生日期"; cell39.Alignment = System.Drawing.StringAlignment.Center; cell39.Value = "应发款"; cell40.Alignment = System.Drawing.StringAlignment.Center; cell40.Value = "工作完成量"; row5.Cells.AddRange(new Gscr.Cell[] { cell33, cell34, cell35, cell36, cell37, cell38, cell39, cell40 }); this.report1.HeaderRows.AddRange(new Gscr.Row[] { row5 }); this.report1.Location = new System.Drawing.Point(5, 75); this.report1.Name = "report1"; this.report1.PrintLandscape = true; this.report1.PrintMargins = new System.Drawing.Printing.Margins(50, 50, 50, 50); this.report1.SelectSQL = "SELECT * FROM Member "; this.report1.SeriesHeaderStyle = seriesHeaderStyle1; this.report1.ShowGroupExpand = true; this.report1.Size = new System.Drawing.Size(945, 571); cell41.Alignment = System.Drawing.StringAlignment.Center; cell41.IsMerge = true; cell41.MergeEndColumnIndexDiffer = 1; cell41.MergeEndRowIndexDiffer = 0; cell41.MergeStartColumnIndexDiffer = 0; cell41.MergeStartRowIndexDiffer = 0; cell41.Value = "总计"; cell42.IsMerge = true; cell42.MergeEndColumnIndexDiffer = 0; cell42.MergeEndRowIndexDiffer = 0; cell42.MergeStartRowIndexDiffer = 0; cell43.FormulaExpression = "=\"记录数:\" + CString(Count([column3]))"; cell43.Value = "记录数:0"; cell47.Alignment = System.Drawing.StringAlignment.Far; cell47.FormulaExpression = "=Sum([column7])"; cell47.Value = 0; cell48.Alignment = System.Drawing.StringAlignment.Far; cell48.FormulaExpression = "=Sum([column10])"; cell48.Value = 0; row6.Cells.AddRange(new Gscr.Cell[] { cell41, cell42, cell43, cell44, cell45, cell46, cell47, cell48 }); this.report1.SummaryRows.AddRange(new Gscr.Row[] { row6 }); this.report1.TabIndex = 0; this.report1.Text = "report1"; cell49.Alignment = System.Drawing.StringAlignment.Center; cell49.BorderStyle = Gscr.CellBorderStyle.Bottom; cell49.Font = new System.Drawing.Font("华文仿宋", 22F); cell49.IsMerge = true; cell49.MergeEndColumnIndexDiffer = 7; cell49.MergeEndRowIndexDiffer = 0; cell49.MergeStartColumnIndexDiffer = 0; cell49.MergeStartRowIndexDiffer = 0; cell49.Value = "分组报表示例"; cell50.BorderStyle = Gscr.CellBorderStyle.Bottom; cell50.IsMerge = true; cell50.MergeEndColumnIndexDiffer = 6; cell50.MergeEndRowIndexDiffer = 0; cell50.MergeStartRowIndexDiffer = 0; cell51.BorderStyle = Gscr.CellBorderStyle.Bottom; cell51.IsMerge = true; cell51.MergeEndColumnIndexDiffer = 5; cell51.MergeEndRowIndexDiffer = 0; cell51.MergeStartColumnIndexDiffer = -2; cell51.MergeStartRowIndexDiffer = 0; cell52.BorderStyle = Gscr.CellBorderStyle.Bottom; cell52.IsMerge = true; cell52.MergeEndColumnIndexDiffer = 4; cell52.MergeEndRowIndexDiffer = 0; cell52.MergeStartColumnIndexDiffer = -3; cell52.MergeStartRowIndexDiffer = 0; cell53.BorderStyle = Gscr.CellBorderStyle.Bottom; cell53.IsMerge = true; cell53.MergeEndColumnIndexDiffer = 3; cell53.MergeEndRowIndexDiffer = 0; cell53.MergeStartColumnIndexDiffer = -4; cell53.MergeStartRowIndexDiffer = 0; cell54.BorderStyle = Gscr.CellBorderStyle.Bottom; cell54.IsMerge = true; cell54.MergeEndColumnIndexDiffer = 2; cell54.MergeEndRowIndexDiffer = 0; cell54.MergeStartColumnIndexDiffer = -5; cell54.MergeStartRowIndexDiffer = 0; cell55.BorderStyle = Gscr.CellBorderStyle.Bottom; cell55.IsMerge = true; cell55.MergeEndColumnIndexDiffer = 1; cell55.MergeEndRowIndexDiffer = 0; cell55.MergeStartColumnIndexDiffer = -6; cell55.MergeStartRowIndexDiffer = 0; cell56.BorderStyle = Gscr.CellBorderStyle.Bottom; cell56.IsMerge = true; cell56.MergeEndColumnIndexDiffer = 0; cell56.MergeEndRowIndexDiffer = 0; cell56.MergeStartColumnIndexDiffer = -7; cell56.MergeStartRowIndexDiffer = 0; row7.Cells.AddRange(new Gscr.Cell[] { cell49, cell50, cell51, cell52, cell53, cell54, cell55, cell56 }); row7.Height = 58; this.report1.TitleRows.AddRange(new Gscr.Row[] { row7 }); // // frmExample9 // 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 = "frmExample9"; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; this.Text = "Example9(分组)"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.frmExample8_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.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(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(frmExample18)); Gscr.Row row2 = new Gscr.Row(); 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(); 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.SeriesHeaderStyle seriesHeaderStyle1 = new Gscr.SeriesHeaderStyle(); this.btnSaveUseTran = new System.Windows.Forms.Button(); this.btnAddRow = new System.Windows.Forms.Button(); this.btnDeleteRow = new System.Windows.Forms.Button(); this.btnSaveNoTran = new System.Windows.Forms.Button(); this.btnClose = new System.Windows.Forms.Button(); this.report1 = new Gscr.Report(); ((System.ComponentModel.ISupportInitialize)(this.report1)).BeginInit(); this.SuspendLayout(); // // btnSaveUseTran // this.btnSaveUseTran.Location = new System.Drawing.Point(310, 28); this.btnSaveUseTran.Name = "btnSaveUseTran"; this.btnSaveUseTran.Size = new System.Drawing.Size(94, 23); this.btnSaveUseTran.TabIndex = 6; this.btnSaveUseTran.Text = "保存(带事务)"; this.btnSaveUseTran.UseVisualStyleBackColor = true; this.btnSaveUseTran.Click += new System.EventHandler(this.btnSaveUseTran_Click); // // btnAddRow // this.btnAddRow.Location = new System.Drawing.Point(31, 28); this.btnAddRow.Name = "btnAddRow"; this.btnAddRow.Size = new System.Drawing.Size(94, 23); this.btnAddRow.TabIndex = 8; this.btnAddRow.Text = "增加行"; this.btnAddRow.UseVisualStyleBackColor = true; this.btnAddRow.Click += new System.EventHandler(this.btnAddRow_Click); // // btnDeleteRow // this.btnDeleteRow.Location = new System.Drawing.Point(137, 28); this.btnDeleteRow.Name = "btnDeleteRow"; this.btnDeleteRow.Size = new System.Drawing.Size(94, 23); this.btnDeleteRow.TabIndex = 9; this.btnDeleteRow.Text = "删除当前行"; this.btnDeleteRow.UseVisualStyleBackColor = true; this.btnDeleteRow.Click += new System.EventHandler(this.btnDeleteRow_Click); // // btnSaveNoTran // this.btnSaveNoTran.Location = new System.Drawing.Point(416, 28); this.btnSaveNoTran.Name = "btnSaveNoTran"; this.btnSaveNoTran.Size = new System.Drawing.Size(94, 23); this.btnSaveNoTran.TabIndex = 10; this.btnSaveNoTran.Text = "保存(无事务)"; this.btnSaveNoTran.UseVisualStyleBackColor = true; this.btnSaveNoTran.Click += new System.EventHandler(this.btnSaveNoTran_Click); // // btnClose // this.btnClose.Location = new System.Drawing.Point(619, 28); this.btnClose.Name = "btnClose"; this.btnClose.Size = new System.Drawing.Size(94, 23); this.btnClose.TabIndex = 14; this.btnClose.Text = "关闭"; this.btnClose.UseVisualStyleBackColor = true; this.btnClose.Click += new System.EventHandler(this.btnClose_Click); // // 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.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 = "ID"; column2.ColumnName = "单据号"; column3.ColumnName = "商品名称"; column4.ColumnName = "颜色"; column5.ColumnName = "规格"; column6.ColumnName = "单位"; column7.ColumnName = "数量"; column8.ColumnName = "单价"; column9.ColumnName = "金额"; this.report1.Columns.AddRange(new Gscr.Column[] { column1, column2, column3, column4, column5, column6, column7, column8, column9 }); cell1.Alignment = System.Drawing.StringAlignment.Center; cell1.DataField = "ID"; cell2.DataField = "单据号"; cell3.DataField = "商品名称"; cell3.ReadOnly = false; cell4.Alignment = System.Drawing.StringAlignment.Center; cell4.DataField = "颜色"; cell4.ReadOnly = false; cell5.Alignment = System.Drawing.StringAlignment.Center; cell5.DataField = "规格"; cell5.ReadOnly = false; cell6.Alignment = System.Drawing.StringAlignment.Center; cell6.DataField = "单位"; cell6.ReadOnly = false; cell7.Alignment = System.Drawing.StringAlignment.Far; cell7.DataField = "数量"; cell7.EditType = typeof(Gscr.Editer.ReportNumberTextBoxEditer); cell7.FormatString = "0.00"; cell7.ReadOnly = false; cell8.Alignment = System.Drawing.StringAlignment.Far; cell8.DataField = "单价"; cell8.EditType = typeof(Gscr.Editer.ReportNumberTextBoxEditer); cell8.FormatString = "0.00"; cell8.ReadOnly = false; cell9.Alignment = System.Drawing.StringAlignment.Far; cell9.DataField = "金额"; cell9.EditType = typeof(Gscr.Editer.ReportNumberTextBoxEditer); cell9.FormatString = "0.00"; row1.Cells.AddRange(new Gscr.Cell[] { cell1, cell2, cell3, cell4, cell5, cell6, cell7, cell8, cell9 }); this.report1.DetailRows.AddRange(new Gscr.Row[] { row1 }); this.report1.Font = new System.Drawing.Font("宋体", 9F); this.report1.GscrID = ((Gscr.GscrID)(resources.GetObject("report1.GscrID"))); cell10.Alignment = System.Drawing.StringAlignment.Center; cell10.Value = "ID"; cell11.Alignment = System.Drawing.StringAlignment.Center; cell11.Value = "单据号"; cell12.Alignment = System.Drawing.StringAlignment.Center; cell12.Value = "商品名称"; cell13.Alignment = System.Drawing.StringAlignment.Center; cell13.Value = "颜色"; cell14.Alignment = System.Drawing.StringAlignment.Center; cell14.Value = "规格"; cell15.Alignment = System.Drawing.StringAlignment.Center; cell15.Value = "单位"; cell16.Alignment = System.Drawing.StringAlignment.Center; cell16.Value = "数量"; cell17.Alignment = System.Drawing.StringAlignment.Center; cell17.Value = "单价"; cell18.Alignment = System.Drawing.StringAlignment.Center; cell18.Value = "金额"; row2.Cells.AddRange(new Gscr.Cell[] { cell10, cell11, cell12, cell13, cell14, cell15, cell16, cell17, cell18 }); this.report1.HeaderRows.AddRange(new Gscr.Row[] { row2 }); this.report1.HighlightDisplayMouserOver = false; this.report1.IsExpandBackground = false; this.report1.Location = new System.Drawing.Point(13, 68); this.report1.Name = "report1"; this.report1.PrintMargins = new System.Drawing.Printing.Margins(50, 50, 50, 50); this.report1.ReadOnly = false; this.report1.SelectionMode = Gscr.ReportSelectionMode.FullRowSelect; this.report1.SelectSQL = "Select BillDetail.* \nFrom BillMaster,BillDetail \nWhere BillMaster.单据号=BillDetail." + "单据号"; this.report1.SeriesHeaderStyle = seriesHeaderStyle1; this.report1.Size = new System.Drawing.Size(923, 512); this.report1.TabIndex = 15; this.report1.Text = "report1"; this.report1.UpdateTable = "BillDetail"; this.report1.CellEndEdit += new System.EventHandler <Gscr.CellEventArgs>(this.report1_CellEndEdit); // // frmExample18 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(948, 592); this.Controls.Add(this.report1); this.Controls.Add(this.btnClose); this.Controls.Add(this.btnSaveNoTran); this.Controls.Add(this.btnDeleteRow); this.Controls.Add(this.btnAddRow); this.Controls.Add(this.btnSaveUseTran); this.Name = "frmExample18"; this.Text = "示例18(把报表保存到数据库)"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.Form1_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.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(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(frmExample19)); Gscr.Row row2 = new Gscr.Row(); 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.SeriesHeaderStyle seriesHeaderStyle1 = new Gscr.SeriesHeaderStyle(); this.report1 = new Gscr.Report(); this.btnClose = new System.Windows.Forms.Button(); this.btnAddRow = 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.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 = 200; column2.ColumnName = "column2"; column2.Width = 160; column3.ColumnName = "column3"; column3.Width = 160; column4.ColumnName = "column4"; column4.Width = 160; this.report1.Columns.AddRange(new Gscr.Column[] { column1, column2, column3, column4 }); cell1.Alignment = System.Drawing.StringAlignment.Center; cell1.DataField = "姓名"; cell1.ReadOnly = false; cell2.DataField = "学校"; cell2.EditType = typeof(Gscr.Editer.ReportTextBoxEditer); cell2.ReadOnly = false; cell3.Alignment = System.Drawing.StringAlignment.Center; cell3.DataField = "选修课"; cell3.EditType = typeof(Gscr.Editer.ReportTextBoxEditer); cell3.ReadOnly = false; cell4.Alignment = System.Drawing.StringAlignment.Center; cell4.DataField = "备注"; cell4.ReadOnly = false; row1.Cells.AddRange(new Gscr.Cell[] { cell1, cell2, cell3, cell4 }); row1.Height = 60; this.report1.DetailRows.AddRange(new Gscr.Row[] { row1 }); this.report1.DifferentRowColor = true; this.report1.FixedFooterRowsToBottom = true; this.report1.Font = new System.Drawing.Font("宋体", 9F); this.report1.GscrID = ((Gscr.GscrID)(resources.GetObject("report1.GscrID"))); cell5.Alignment = System.Drawing.StringAlignment.Center; cell5.Value = "姓名"; cell6.Alignment = System.Drawing.StringAlignment.Center; cell6.Value = "学校"; cell7.Alignment = System.Drawing.StringAlignment.Center; cell7.Value = "选修课"; cell8.Alignment = System.Drawing.StringAlignment.Center; cell8.Value = "备注"; row2.Cells.AddRange(new Gscr.Cell[] { cell5, cell6, cell7, cell8 }); row2.Height = 40; this.report1.HeaderRows.AddRange(new Gscr.Row[] { row2 }); this.report1.HighlightDisplayMouserOver = false; this.report1.Location = new System.Drawing.Point(5, 77); this.report1.Name = "report1"; this.report1.PrintMargins = new System.Drawing.Printing.Margins(50, 50, 50, 50); this.report1.ReadOnly = false; this.report1.SelectionMode = Gscr.ReportSelectionMode.FullRowSelect; this.report1.SelectSQL = "SELECT * FROM Member"; this.report1.SeriesHeaderStyle = seriesHeaderStyle1; this.report1.Size = new System.Drawing.Size(945, 569); this.report1.TabIndex = 0; this.report1.Text = "report1"; this.report1.CellBeginEdit += new System.EventHandler <Gscr.CellCancelEventArgs>(this.report1_CellBeginEdit); // // btnClose // this.btnClose.Location = new System.Drawing.Point(330, 29); 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); // // btnAddRow // this.btnAddRow.Location = new System.Drawing.Point(224, 29); this.btnAddRow.Name = "btnAddRow"; this.btnAddRow.Size = new System.Drawing.Size(75, 23); this.btnAddRow.TabIndex = 56; this.btnAddRow.Text = "增加行"; this.btnAddRow.UseVisualStyleBackColor = true; this.btnAddRow.Click += new System.EventHandler(this.btnAddRow_Click); // // frmExample19 // 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.btnAddRow); this.Controls.Add(this.btnClose); this.Controls.Add(this.report1); this.Name = "frmExample19"; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; this.Text = "Example19(自定义编辑控件)"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.frmExample19_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.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(); 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(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(frmExample7)); 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.SeriesHeaderStyle seriesHeaderStyle1 = new Gscr.SeriesHeaderStyle(); Gscr.Column column13 = new Gscr.Column(); Gscr.Column column14 = new Gscr.Column(); Gscr.Row row4 = new Gscr.Row(); Gscr.Cell cell37 = new Gscr.Cell(); Gscr.Cell cell38 = new Gscr.Cell(); Gscr.Row row5 = new Gscr.Row(); Gscr.Cell cell39 = new Gscr.Cell(); Gscr.Cell cell40 = new Gscr.Cell(); Gscr.SeriesHeaderStyle seriesHeaderStyle2 = 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(); this.button5 = new System.Windows.Forms.Button(); this.button6 = new System.Windows.Forms.Button(); this.label1 = new System.Windows.Forms.Label(); this.button7 = new System.Windows.Forms.Button(); this.button8 = new System.Windows.Forms.Button(); this.button9 = new System.Windows.Forms.Button(); this.report2 = new Gscr.Report(); ((System.ComponentModel.ISupportInitialize)(this.report1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.report2)).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.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 = 89; column2.ColumnName = "column2"; column3.ColumnName = "column3"; column3.Width = 146; column4.ColumnName = "column4"; column5.ColumnName = "column5"; column6.ColumnName = "column6"; column6.Width = 67; column7.ColumnName = "出生日期"; column7.Width = 212; column8.CellValueType = Gscr.ColumnValueType.Number; column8.ColumnName = "column8"; column8.Width = 97; column9.ColumnName = "column9"; column9.Width = 203; column10.CellValueType = Gscr.ColumnValueType.Number; column10.ColumnName = "column10"; column11.CellValueType = Gscr.ColumnValueType.Number; column11.ColumnName = "column11"; column12.ColumnName = "column12"; column12.Width = 71; this.report1.Columns.AddRange(new Gscr.Column[] { column1, column2, column3, column4, column5, column6, column7, column8, column9, column10, column11, column12 }); cell1.Alignment = System.Drawing.StringAlignment.Center; cell1.DataField = "ID"; cell2.DataField = "姓名"; cell2.ReadOnly = false; cell3.DataField = "证件号"; cell3.ReadOnly = false; cell4.DataField = "职务"; cell4.DataSourceName = "T_Post"; cell4.EditType = typeof(Gscr.Editer.ReportComboBoxEditer); cell4.ReadOnly = false; cell5.DataField = "部门"; cell5.DataSourceName = "T_Department"; cell5.EditType = typeof(Gscr.Editer.ReportFindEditer); cell5.ReadOnly = false; cell6.Alignment = System.Drawing.StringAlignment.Center; cell6.DataField = "性别"; cell6.DataSourceName = "T_Sex"; cell6.EditType = typeof(Gscr.Editer.ReportCustomDlgOnlyReadEditer); cell6.ReadOnly = false; cell7.Alignment = System.Drawing.StringAlignment.Center; cell7.DataField = "出生日期"; cell7.EditType = typeof(Gscr.Editer.ReportDateTimePickerEditer); cell7.FormatString = "yyyy-MM-dd hh:mm:ss"; cell7.ReadOnly = false; cell8.Alignment = System.Drawing.StringAlignment.Far; cell8.DataField = "应发款"; cell8.EditType = typeof(Gscr.Editer.ReportNumberTextBoxEditer); cell8.FormatString = "0.0000"; cell8.ReadOnly = false; cell9.DataField = "主页"; cell9.ReadOnly = false; cell10.Alignment = System.Drawing.StringAlignment.Far; cell10.DataField = "工作完成量"; cell10.EditType = typeof(Gscr.Editer.ReportNumberTextBoxEditer); cell10.ReadOnly = false; cell11.Alignment = System.Drawing.StringAlignment.Center; cell11.DataField = "工作进度"; cell11.EditType = typeof(Gscr.Editer.ReportNumberTextBoxEditer); cell11.ReadOnly = false; cell12.Alignment = System.Drawing.StringAlignment.Center; cell12.CellDrawMode = Gscr.CellDrawMode.CheckBox; cell12.DataField = "作废"; cell12.ReadOnly = false; 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.FixedFooterRowsToBottom = true; this.report1.Font = new System.Drawing.Font("宋体", 9F); cell13.Alignment = System.Drawing.StringAlignment.Center; cell13.Value = "合计"; cell14.Alignment = System.Drawing.StringAlignment.Far; cell14.FormulaExpression = ""; cell14.Value = "记录数"; cell15.FormulaExpression = "=Count([B])"; cell15.Value = 0; cell17.Alignment = System.Drawing.StringAlignment.Far; cell17.Value = "工作量合计"; cell18.FormulaExpression = "=Sum([J])"; cell18.Value = 0; row2.Cells.AddRange(new Gscr.Cell[] { cell13, cell14, cell15, cell16, cell17, cell18, cell19, cell20, cell21, cell22, cell23, cell24 }); this.report1.FooterRows.AddRange(new Gscr.Row[] { row2 }); this.report1.GscrID = ((Gscr.GscrID)(resources.GetObject("report1.GscrID"))); cell25.Alignment = System.Drawing.StringAlignment.Center; cell25.Value = "ID"; cell26.Alignment = System.Drawing.StringAlignment.Center; cell26.Value = "姓名"; cell27.Alignment = System.Drawing.StringAlignment.Center; cell27.Value = "证件号"; cell28.Alignment = System.Drawing.StringAlignment.Center; cell28.Value = "职务"; cell29.Alignment = System.Drawing.StringAlignment.Center; cell29.Value = "部门"; cell30.Alignment = System.Drawing.StringAlignment.Center; cell30.Value = "性别"; cell31.Alignment = System.Drawing.StringAlignment.Center; cell31.Value = "出生日期"; cell32.Alignment = System.Drawing.StringAlignment.Center; cell32.Value = "应发款"; cell33.Alignment = System.Drawing.StringAlignment.Center; cell33.Value = "主页"; cell34.Alignment = System.Drawing.StringAlignment.Center; cell34.Value = "工作完成量"; cell35.Alignment = System.Drawing.StringAlignment.Center; cell35.Value = "工作进度"; cell36.Alignment = System.Drawing.StringAlignment.Center; cell36.Value = "作废"; row3.Cells.AddRange(new Gscr.Cell[] { cell25, cell26, cell27, cell28, cell29, cell30, cell31, cell32, cell33, cell34, cell35, cell36 }); this.report1.HeaderRows.AddRange(new Gscr.Row[] { row3 }); this.report1.HighlightDisplayMouserOver = false; this.report1.Location = new System.Drawing.Point(5, 101); this.report1.Name = "report1"; this.report1.PrintMargins = new System.Drawing.Printing.Margins(50, 50, 50, 50); this.report1.ReadOnly = false; this.report1.SelectionMode = Gscr.ReportSelectionMode.FullRowSelect; this.report1.SelectSQL = "SELECT * FROM Member"; this.report1.SeriesHeaderStyle = seriesHeaderStyle1; this.report1.Size = new System.Drawing.Size(945, 545); this.report1.TabIndex = 0; this.report1.Text = "report1"; this.report1.OpenCustomDlgEdier += new System.EventHandler <Gscr.CustomDlgEditerEventArgs>(this.report1_OpenCustomDlgEdier); this.report1.KeyDown += new System.Windows.Forms.KeyEventHandler(this.report1_KeyDown); this.report1.CellBeginEdit += new System.EventHandler <Gscr.CellCancelEventArgs>(this.report1_CellBeginEdit); // // button1 // this.button1.Location = new System.Drawing.Point(21, 34); this.button1.Name = "button1"; this.button1.Size = new System.Drawing.Size(113, 23); this.button1.TabIndex = 50; this.button1.Text = "绑定数据(Access)"; this.button1.UseVisualStyleBackColor = true; this.button1.Click += new System.EventHandler(this.button1_Click); // // button2 // this.button2.Location = new System.Drawing.Point(151, 34); 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(243, 34); 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(335, 34); 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(887, 34); 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); // // button5 // this.button5.Location = new System.Drawing.Point(427, 34); this.button5.Name = "button5"; this.button5.Size = new System.Drawing.Size(75, 23); this.button5.TabIndex = 56; this.button5.Text = "增加行"; this.button5.UseVisualStyleBackColor = true; this.button5.Click += new System.EventHandler(this.button5_Click); // // button6 // this.button6.Location = new System.Drawing.Point(519, 34); this.button6.Name = "button6"; this.button6.Size = new System.Drawing.Size(75, 23); this.button6.TabIndex = 57; this.button6.Text = "删除当前行"; this.button6.UseVisualStyleBackColor = true; this.button6.Click += new System.EventHandler(this.button6_Click); // // label1 // this.label1.AutoSize = true; this.label1.Location = new System.Drawing.Point(19, 71); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(557, 12); this.label1.TabIndex = 58; this.label1.Text = "按下F2键或双击单元格进入编辑模式,按下ESC键退出编辑模式。 [E]列的编辑模式,请使用键盘输入。"; // // button7 // this.button7.Location = new System.Drawing.Point(611, 34); this.button7.Name = "button7"; this.button7.Size = new System.Drawing.Size(75, 23); this.button7.TabIndex = 59; this.button7.Text = "修改过的行"; this.button7.UseVisualStyleBackColor = true; this.button7.Click += new System.EventHandler(this.button7_Click); // // button8 // this.button8.Location = new System.Drawing.Point(703, 34); this.button8.Name = "button8"; this.button8.Size = new System.Drawing.Size(75, 23); this.button8.TabIndex = 60; this.button8.Text = "单元格选择"; this.button8.UseVisualStyleBackColor = true; this.button8.Click += new System.EventHandler(this.button8_Click); // // button9 // this.button9.Location = new System.Drawing.Point(795, 34); this.button9.Name = "button9"; this.button9.Size = new System.Drawing.Size(75, 23); this.button9.TabIndex = 61; this.button9.Text = "设计"; this.button9.UseVisualStyleBackColor = true; this.button9.Click += new System.EventHandler(this.button9_Click); // // report2 // this.report2.Barcode.EncodedType = Gscr.BarcodeLib.TYPE.UNSPECIFIED; this.report2.Barcode.EncodingTime = 0; this.report2.Barcode.Height = 150; this.report2.Barcode.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg; this.report2.Barcode.LabelFont = new System.Drawing.Font("Microsoft Sans Serif", 8F); this.report2.Barcode.RawData = ""; this.report2.Barcode.Width = 300; column13.ColumnName = "Code"; column14.ColumnName = "Name"; this.report2.Columns.AddRange(new Gscr.Column[] { column13, column14 }); cell37.Alignment = System.Drawing.StringAlignment.Center; cell37.DataField = "Code"; cell38.Alignment = System.Drawing.StringAlignment.Center; cell38.DataField = "Name"; row4.Cells.AddRange(new Gscr.Cell[] { cell37, cell38 }); this.report2.DetailRows.AddRange(new Gscr.Row[] { row4 }); this.report2.Font = new System.Drawing.Font("宋体", 9F); this.report2.GscrID = ((Gscr.GscrID)(resources.GetObject("report2.GscrID"))); cell39.Alignment = System.Drawing.StringAlignment.Center; cell39.Value = "代码"; cell40.Alignment = System.Drawing.StringAlignment.Center; cell40.DataField = ""; cell40.Value = "名称"; row5.Cells.AddRange(new Gscr.Cell[] { cell39, cell40 }); this.report2.HeaderRows.AddRange(new Gscr.Row[] { row5 }); this.report2.IsExpandBackground = false; this.report2.Location = new System.Drawing.Point(561, 205); this.report2.Name = "report2"; this.report2.PrintMargins = new System.Drawing.Printing.Margins(50, 50, 50, 50); this.report2.SelectionMode = Gscr.ReportSelectionMode.FullRowSelect; this.report2.SelectSQL = "SELECT * FROM Department"; this.report2.SeriesHeaderStyle = seriesHeaderStyle2; this.report2.Size = new System.Drawing.Size(309, 207); this.report2.TabIndex = 62; this.report2.Text = "report2"; this.report2.Visible = false; // // frmExample7 // 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.report2); this.Controls.Add(this.button9); this.Controls.Add(this.button8); this.Controls.Add(this.button7); this.Controls.Add(this.label1); this.Controls.Add(this.button6); this.Controls.Add(this.button5); 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 = "frmExample7"; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; this.Text = "Example7(编辑)"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.frmExample7_Load); ((System.ComponentModel.ISupportInitialize)(this.report1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.report2)).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.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); }
/// <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.Row row1 = new Gscr.Row(); Gscr.Cell cell1 = new Gscr.Cell(); Gscr.Cell cell2 = new Gscr.Cell(); Gscr.Cell cell3 = new Gscr.Cell(); Gscr.Row row2 = new Gscr.Row(); Gscr.Cell cell4 = new Gscr.Cell(); Gscr.Cell cell5 = new Gscr.Cell(); Gscr.Cell cell6 = new Gscr.Cell(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(frmExample20)); Gscr.Row row3 = new Gscr.Row(); Gscr.Cell cell7 = new Gscr.Cell(); Gscr.Cell cell8 = new Gscr.Cell(); Gscr.Cell cell9 = new Gscr.Cell(); Gscr.SeriesHeaderStyle seriesHeaderStyle1 = new Gscr.SeriesHeaderStyle(); Gscr.Row row4 = new Gscr.Row(); Gscr.Cell cell10 = new Gscr.Cell(); Gscr.Cell cell11 = new Gscr.Cell(); Gscr.Cell cell12 = new Gscr.Cell(); Gscr.Row row5 = new Gscr.Row(); Gscr.Cell cell13 = new Gscr.Cell(); Gscr.Cell cell14 = new Gscr.Cell(); Gscr.Cell cell15 = new Gscr.Cell(); System.Windows.Forms.DataVisualization.Charting.ChartArea chartArea1 = new System.Windows.Forms.DataVisualization.Charting.ChartArea(); System.Windows.Forms.DataVisualization.Charting.Legend legend1 = new System.Windows.Forms.DataVisualization.Charting.Legend(); System.Windows.Forms.DataVisualization.Charting.Series series1 = new System.Windows.Forms.DataVisualization.Charting.Series(); 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.chart1 = new System.Windows.Forms.DataVisualization.Charting.Chart(); ((System.ComponentModel.ISupportInitialize)(this.report1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.chart1)).BeginInit(); this.SuspendLayout(); // // button1 // this.button1.Location = new System.Drawing.Point(37, 31); 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, 31); 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, 31); 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, 31); 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, 31); 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); // // 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.BackColor = System.Drawing.Color.White; 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 = "column4"; column1.Width = 150; column2.CellValueType = Gscr.ColumnValueType.Number; column2.ColumnName = "column10"; column2.Width = 150; column3.ColumnName = "column1"; column3.Width = 600; this.report1.Columns.AddRange(new Gscr.Column[] { column1, column2, column3 }); cell1.Alignment = System.Drawing.StringAlignment.Center; cell1.DataField = "部门"; cell1.DataSourceName = ""; cell2.Alignment = System.Drawing.StringAlignment.Center; cell2.DataField = "工作完成量"; cell3.BorderStyle = Gscr.CellBorderStyle.Left; row1.Cells.AddRange(new Gscr.Cell[] { cell1, cell2, cell3 }); row1.Height = 40; this.report1.DetailRows.AddRange(new Gscr.Row[] { row1 }); this.report1.FixedHeaderRows = false; this.report1.Font = new System.Drawing.Font("宋体", 9F); cell4.Alignment = System.Drawing.StringAlignment.Center; cell4.Value = "工作量合计"; cell5.Alignment = System.Drawing.StringAlignment.Center; cell5.FormulaExpression = "=Sum([B])"; cell5.Value = 0; cell6.BorderStyle = Gscr.CellBorderStyle.Left; row2.Cells.AddRange(new Gscr.Cell[] { cell4, cell5, cell6 }); row2.Height = 40; this.report1.FooterRows.AddRange(new Gscr.Row[] { row2 }); this.report1.GscrID = ((Gscr.GscrID)(resources.GetObject("report1.GscrID"))); cell7.Alignment = System.Drawing.StringAlignment.Center; cell7.Value = "部门"; cell8.Alignment = System.Drawing.StringAlignment.Center; cell8.Value = "工作完成量"; cell9.BorderStyle = Gscr.CellBorderStyle.Left; row3.Cells.AddRange(new Gscr.Cell[] { cell7, cell8, cell9 }); row3.Height = 40; this.report1.HeaderRows.AddRange(new Gscr.Row[] { row3 }); this.report1.Location = new System.Drawing.Point(12, 80); this.report1.Name = "report1"; this.report1.PrintLandscape = true; this.report1.PrintMargins = new System.Drawing.Printing.Margins(50, 50, 50, 50); this.report1.SelectSQL = ""; this.report1.SeriesHeaderStyle = seriesHeaderStyle1; this.report1.Size = new System.Drawing.Size(933, 560); this.report1.TabIndex = 57; this.report1.Text = "report1"; cell10.Alignment = System.Drawing.StringAlignment.Center; cell10.BorderStyle = Gscr.CellBorderStyle.None; cell10.Font = new System.Drawing.Font("宋体", 20F); cell10.IsMerge = true; cell10.MergeEndColumnIndexDiffer = 2; cell10.MergeEndRowIndexDiffer = 0; cell10.MergeStartColumnIndexDiffer = 0; cell10.MergeStartRowIndexDiffer = 0; cell10.Value = "MSChart嵌入图表示例"; cell11.BorderStyle = Gscr.CellBorderStyle.None; cell11.IsMerge = true; cell11.MergeEndColumnIndexDiffer = 1; cell11.MergeEndRowIndexDiffer = 0; cell11.MergeStartRowIndexDiffer = 0; cell12.BorderStyle = Gscr.CellBorderStyle.None; cell12.IsMerge = true; cell12.MergeEndColumnIndexDiffer = 0; cell12.MergeEndRowIndexDiffer = 0; cell12.MergeStartColumnIndexDiffer = -2; cell12.MergeStartRowIndexDiffer = 0; row4.Cells.AddRange(new Gscr.Cell[] { cell10, cell11, cell12 }); row4.Height = 60; cell13.BorderStyle = Gscr.CellBorderStyle.Bottom; cell14.BorderStyle = Gscr.CellBorderStyle.Bottom; cell15.Alignment = System.Drawing.StringAlignment.Center; cell15.BorderStyle = Gscr.CellBorderStyle.None; cell15.CellDrawMode = Gscr.CellDrawMode.Link; cell15.Value = "MSChart下载地址"; row5.Cells.AddRange(new Gscr.Cell[] { cell13, cell14, cell15 }); row5.Height = 30; this.report1.TitleRows.AddRange(new Gscr.Row[] { row4, row5 }); this.report1.CellClick += new System.EventHandler <Gscr.CellEventArgs>(this.report1_CellClick); // // chart1 // chartArea1.Name = "ChartArea1"; this.chart1.ChartAreas.Add(chartArea1); legend1.Name = "Legend1"; this.chart1.Legends.Add(legend1); this.chart1.Location = new System.Drawing.Point(435, 240); this.chart1.Name = "chart1"; series1.ChartArea = "ChartArea1"; series1.Legend = "Legend1"; series1.Name = "Series1"; this.chart1.Series.Add(series1); this.chart1.Size = new System.Drawing.Size(400, 300); this.chart1.TabIndex = 58; this.chart1.Text = "chart1"; this.chart1.Visible = false; // // frmExample20 // 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.chart1); 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 = "frmExample20"; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; this.Text = "Example20(显示MsChart图表)"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.frmExample20_Load); ((System.ComponentModel.ISupportInitialize)(this.report1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.chart1)).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.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.Row row2 = new Gscr.Row(); 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.Row row3 = new Gscr.Row(); Gscr.Cell cell11 = new Gscr.Cell(); Gscr.Cell cell12 = new Gscr.Cell(); Gscr.Cell cell13 = new Gscr.Cell(); Gscr.Cell cell14 = new Gscr.Cell(); Gscr.Cell cell15 = new Gscr.Cell(); Gscr.Row row4 = new Gscr.Row(); 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(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(frmExample5)); Gscr.Row row5 = new Gscr.Row(); 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.Row row6 = new Gscr.Row(); 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.SeriesHeaderStyle seriesHeaderStyle1 = new Gscr.SeriesHeaderStyle(); 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(); this.button4 = new System.Windows.Forms.Button(); this.button5 = new System.Windows.Forms.Button(); ((System.ComponentModel.ISupportInitialize)(this.report1)).BeginInit(); this.SuspendLayout(); // // report1 // this.report1.AllowOrder = false; 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.White; 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 = 54; column2.ColumnName = "column2"; column2.Width = 143; column3.ColumnName = "column3"; column3.Width = 82; column4.ColumnName = "column4"; column4.Width = 486; column5.ColumnName = "column5"; this.report1.Columns.AddRange(new Gscr.Column[] { column1, column2, column3, column4, column5 }); cell1.BorderStyle = Gscr.CellBorderStyle.None; cell1.FormulaExpression = ""; cell2.BorderStyle = Gscr.CellBorderStyle.None; cell2.CellDrawMode = Gscr.CellDrawMode.Image; cell2.IsMerge = true; cell2.MergeEndColumnIndexDiffer = 0; cell2.MergeEndRowIndexDiffer = 3; cell2.MergeStartColumnIndexDiffer = 0; cell2.MergeStartRowIndexDiffer = 0; cell3.BorderStyle = Gscr.CellBorderStyle.None; cell3.Value = "产品名称:"; cell4.BorderStyle = Gscr.CellBorderStyle.None; cell4.DataField = "ProductName"; cell4.ForeColor = System.Drawing.Color.Blue; cell5.BorderStyle = Gscr.CellBorderStyle.None; row1.Cells.AddRange(new Gscr.Cell[] { cell1, cell2, cell3, cell4, cell5 }); cell6.BorderStyle = Gscr.CellBorderStyle.None; cell7.BorderStyle = Gscr.CellBorderStyle.None; cell7.IsMerge = true; cell7.MergeEndColumnIndexDiffer = 0; cell7.MergeEndRowIndexDiffer = 2; cell7.MergeStartColumnIndexDiffer = 0; cell8.BorderStyle = Gscr.CellBorderStyle.None; cell8.Value = "产品制造商:"; cell9.BorderStyle = Gscr.CellBorderStyle.None; cell9.DataField = "Manufacturer"; cell10.BorderStyle = Gscr.CellBorderStyle.None; row2.Cells.AddRange(new Gscr.Cell[] { cell6, cell7, cell8, cell9, cell10 }); cell11.BorderStyle = Gscr.CellBorderStyle.None; cell12.BorderStyle = Gscr.CellBorderStyle.None; cell12.IsMerge = true; cell12.MergeEndColumnIndexDiffer = 0; cell12.MergeEndRowIndexDiffer = 1; cell12.MergeStartColumnIndexDiffer = 0; cell12.MergeStartRowIndexDiffer = -2; cell13.BorderStyle = Gscr.CellBorderStyle.None; cell13.Value = "产品简介:"; cell14.BorderStyle = Gscr.CellBorderStyle.None; cell14.DataField = "Note"; cell15.BorderStyle = Gscr.CellBorderStyle.None; row3.Cells.AddRange(new Gscr.Cell[] { cell11, cell12, cell13, cell14, cell15 }); cell16.BorderStyle = Gscr.CellBorderStyle.None; cell17.BorderStyle = Gscr.CellBorderStyle.None; cell17.IsMerge = true; cell17.MergeEndColumnIndexDiffer = 0; cell17.MergeEndRowIndexDiffer = 0; cell17.MergeStartColumnIndexDiffer = 0; cell17.MergeStartRowIndexDiffer = -3; cell18.BorderStyle = Gscr.CellBorderStyle.None; cell18.Value = "报价:"; cell19.BorderStyle = Gscr.CellBorderStyle.None; cell19.DataField = "Price"; cell19.FormatString = "0.00"; cell20.BorderStyle = Gscr.CellBorderStyle.None; cell20.CellDrawMode = Gscr.CellDrawMode.Link; cell20.Value = "详细>>"; row4.Cells.AddRange(new Gscr.Cell[] { cell16, cell17, cell18, cell19, cell20 }); this.report1.DetailRows.AddRange(new Gscr.Row[] { row1, row2, row3, row4 }); 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"))); cell21.BorderStyle = Gscr.CellBorderStyle.None; cell22.Alignment = System.Drawing.StringAlignment.Center; cell22.BorderStyle = Gscr.CellBorderStyle.None; cell22.Font = new System.Drawing.Font("仿宋_GB2312", 20F); cell22.IsMerge = true; cell22.MergeEndColumnIndexDiffer = 3; cell22.MergeEndRowIndexDiffer = 0; cell22.MergeStartColumnIndexDiffer = 0; cell22.MergeStartRowIndexDiffer = 0; cell22.Value = "产品报价表"; cell23.IsMerge = true; cell23.MergeEndColumnIndexDiffer = 2; cell23.MergeEndRowIndexDiffer = 0; cell23.MergeStartRowIndexDiffer = 0; cell24.IsMerge = true; cell24.MergeEndColumnIndexDiffer = 1; cell24.MergeEndRowIndexDiffer = 0; cell24.MergeStartColumnIndexDiffer = -2; cell24.MergeStartRowIndexDiffer = 0; cell25.IsMerge = true; cell25.MergeEndColumnIndexDiffer = 0; cell25.MergeEndRowIndexDiffer = 0; cell25.MergeStartColumnIndexDiffer = -3; cell25.MergeStartRowIndexDiffer = 0; row5.Cells.AddRange(new Gscr.Cell[] { cell21, cell22, cell23, cell24, cell25 }); row5.Height = 61; cell26.BorderStyle = Gscr.CellBorderStyle.None; cell27.BorderStyle = Gscr.CellBorderStyle.None; cell28.BorderStyle = Gscr.CellBorderStyle.None; cell29.BorderStyle = Gscr.CellBorderStyle.None; cell30.BorderStyle = Gscr.CellBorderStyle.None; row6.Cells.AddRange(new Gscr.Cell[] { cell26, cell27, cell28, cell29, cell30 }); this.report1.HeaderRows.AddRange(new Gscr.Row[] { row5, row6 }); this.report1.Location = new System.Drawing.Point(5, 75); this.report1.Name = "report1"; this.report1.PrintLandscape = true; this.report1.PrintMargins = new System.Drawing.Printing.Margins(50, 50, 50, 50); this.report1.ReadOnly = false; this.report1.SeriesHeaderStyle = seriesHeaderStyle1; this.report1.Size = new System.Drawing.Size(948, 571); this.report1.TabIndex = 0; this.report1.Text = "report1"; // // button2 // this.button2.Location = new System.Drawing.Point(360, 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(449, 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(538, 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(170, 35); this.button1.Name = "button1"; this.button1.Size = new System.Drawing.Size(75, 23); this.button1.TabIndex = 56; this.button1.Text = "增加行"; this.button1.UseVisualStyleBackColor = true; this.button1.Click += new System.EventHandler(this.button1_Click); // // button4 // this.button4.Location = new System.Drawing.Point(29, 35); this.button4.Name = "button4"; this.button4.Size = new System.Drawing.Size(121, 23); this.button4.TabIndex = 57; this.button4.Text = "绑定数据(Access)"; this.button4.UseVisualStyleBackColor = true; this.button4.Click += new System.EventHandler(this.button4_Click); // // button5 // this.button5.Location = new System.Drawing.Point(266, 35); this.button5.Name = "button5"; this.button5.Size = new System.Drawing.Size(75, 23); this.button5.TabIndex = 58; this.button5.Text = "删除行"; this.button5.UseVisualStyleBackColor = true; this.button5.Click += new System.EventHandler(this.button5_Click); // // frmExample5 // 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.button5); this.Controls.Add(this.button4); 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 = "frmExample5"; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; this.Text = "Example5(多行明细行)"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.frmExample5_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() { System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(frmExample1)); 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(); this.textBox1 = new System.Windows.Forms.TextBox(); this.richTextBox1 = new System.Windows.Forms.RichTextBox(); this.label1 = new System.Windows.Forms.Label(); this.label2 = new System.Windows.Forms.Label(); this.richTextBox2 = new System.Windows.Forms.RichTextBox(); this.label3 = new System.Windows.Forms.Label(); this.label4 = new System.Windows.Forms.Label(); ((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.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"))); this.report1.Location = new System.Drawing.Point(5, 143); this.report1.Name = "report1"; this.report1.PrintMargins = new System.Drawing.Printing.Margins(50, 50, 50, 50); this.report1.SeriesHeaderStyle = seriesHeaderStyle1; this.report1.Size = new System.Drawing.Size(980, 503); this.report1.TabIndex = 0; this.report1.Text = "report1"; this.report1.SelectionChanged += new System.EventHandler(this.report1_SelectionChanged); // // button1 // this.button1.Location = new System.Drawing.Point(28, 60); this.button1.Name = "button1"; this.button1.Size = new System.Drawing.Size(145, 23); this.button1.TabIndex = 50; this.button1.Text = "绑定数据(Access)"; this.button1.UseVisualStyleBackColor = true; this.button1.Click += new System.EventHandler(this.button1_Click); // // button2 // this.button2.Location = new System.Drawing.Point(183, 60); 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(268, 60); 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(353, 60); 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(438, 60); 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); // // textBox1 // this.textBox1.Location = new System.Drawing.Point(667, 12); this.textBox1.Name = "textBox1"; this.textBox1.Size = new System.Drawing.Size(318, 21); this.textBox1.TabIndex = 55; // // richTextBox1 // this.richTextBox1.Location = new System.Drawing.Point(667, 35); this.richTextBox1.Name = "richTextBox1"; this.richTextBox1.Size = new System.Drawing.Size(318, 48); this.richTextBox1.TabIndex = 56; this.richTextBox1.Text = ""; // // label1 // this.label1.AutoSize = true; this.label1.Location = new System.Drawing.Point(560, 12); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(77, 12); this.label1.TabIndex = 57; this.label1.Text = "ProviderName"; // // label2 // this.label2.AutoSize = true; this.label2.Location = new System.Drawing.Point(560, 35); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(101, 12); this.label2.TabIndex = 58; this.label2.Text = "ConnectionString"; // // richTextBox2 // this.richTextBox2.Location = new System.Drawing.Point(667, 85); this.richTextBox2.Name = "richTextBox2"; this.richTextBox2.Size = new System.Drawing.Size(318, 48); this.richTextBox2.TabIndex = 59; this.richTextBox2.Text = ""; // // label3 // this.label3.AutoSize = true; this.label3.Location = new System.Drawing.Point(560, 92); this.label3.Name = "label3"; this.label3.Size = new System.Drawing.Size(23, 12); this.label3.TabIndex = 60; this.label3.Text = "SQL"; // // label4 // this.label4.AutoSize = true; this.label4.Location = new System.Drawing.Point(28, 120); this.label4.Name = "label4"; this.label4.Size = new System.Drawing.Size(0, 12); this.label4.TabIndex = 61; // // frmExample1 // 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.label4); this.Controls.Add(this.label3); this.Controls.Add(this.richTextBox2); this.Controls.Add(this.label2); this.Controls.Add(this.label1); this.Controls.Add(this.richTextBox1); this.Controls.Add(this.textBox1); 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 = "frmExample1"; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; this.Text = "Example1(常见样式1)"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.frmExample1_Load); ((System.ComponentModel.ISupportInitialize)(this.report1)).EndInit(); this.ResumeLayout(false); this.PerformLayout(); }
/// <summary> /// 设计器支持所需的方法 - 不要 /// 使用代码编辑器修改此方法的内容。 /// </summary> private void InitializeComponent() { Gscr.Column column1 = new Gscr.Column(); Gscr.Column column2 = new Gscr.Column(); Gscr.Column column3 = 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.Row row2 = new Gscr.Row(); Gscr.Cell cell4 = new Gscr.Cell(); Gscr.Cell cell5 = new Gscr.Cell(); Gscr.Cell cell6 = new Gscr.Cell(); Gscr.Row row3 = new Gscr.Row(); Gscr.Cell cell7 = new Gscr.Cell(); Gscr.Cell cell8 = new Gscr.Cell(); Gscr.Cell cell9 = new Gscr.Cell(); Gscr.Row row4 = new Gscr.Row(); Gscr.Cell cell10 = new Gscr.Cell(); Gscr.Cell cell11 = new Gscr.Cell(); Gscr.Cell cell12 = new Gscr.Cell(); Gscr.Row row5 = new Gscr.Row(); Gscr.Cell cell13 = new Gscr.Cell(); Gscr.Cell cell14 = new Gscr.Cell(); Gscr.Cell cell15 = new Gscr.Cell(); Gscr.Row row6 = new Gscr.Row(); Gscr.Cell cell16 = new Gscr.Cell(); Gscr.Cell cell17 = new Gscr.Cell(); Gscr.Cell cell18 = new Gscr.Cell(); Gscr.Row row7 = new Gscr.Row(); Gscr.Cell cell19 = new Gscr.Cell(); Gscr.Cell cell20 = new Gscr.Cell(); Gscr.Cell cell21 = new Gscr.Cell(); Gscr.Row row8 = new Gscr.Row(); Gscr.Cell cell22 = new Gscr.Cell(); Gscr.Cell cell23 = new Gscr.Cell(); Gscr.Cell cell24 = new Gscr.Cell(); Gscr.Row row9 = new Gscr.Row(); Gscr.Cell cell25 = new Gscr.Cell(); Gscr.Cell cell26 = new Gscr.Cell(); Gscr.Cell cell27 = new Gscr.Cell(); Gscr.Row row10 = new Gscr.Row(); Gscr.Cell cell28 = new Gscr.Cell(); Gscr.Cell cell29 = new Gscr.Cell(); Gscr.Cell cell30 = new Gscr.Cell(); Gscr.Row row11 = new Gscr.Row(); Gscr.Cell cell31 = new Gscr.Cell(); Gscr.Cell cell32 = new Gscr.Cell(); Gscr.Cell cell33 = new Gscr.Cell(); Gscr.Row row12 = new Gscr.Row(); Gscr.Cell cell34 = new Gscr.Cell(); Gscr.Cell cell35 = new Gscr.Cell(); Gscr.Cell cell36 = new Gscr.Cell(); Gscr.Row row13 = new Gscr.Row(); Gscr.Cell cell37 = new Gscr.Cell(); Gscr.Cell cell38 = new Gscr.Cell(); Gscr.Cell cell39 = new Gscr.Cell(); Gscr.Row row14 = new Gscr.Row(); Gscr.Cell cell40 = new Gscr.Cell(); Gscr.Cell cell41 = new Gscr.Cell(); Gscr.Cell cell42 = new Gscr.Cell(); Gscr.Row row15 = new Gscr.Row(); Gscr.Cell cell43 = new Gscr.Cell(); Gscr.Cell cell44 = new Gscr.Cell(); Gscr.Cell cell45 = new Gscr.Cell(); Gscr.Row row16 = new Gscr.Row(); Gscr.Cell cell46 = new Gscr.Cell(); Gscr.Cell cell47 = new Gscr.Cell(); Gscr.Cell cell48 = new Gscr.Cell(); Gscr.Row row17 = new Gscr.Row(); Gscr.Cell cell49 = new Gscr.Cell(); Gscr.Cell cell50 = new Gscr.Cell(); Gscr.Cell cell51 = new Gscr.Cell(); Gscr.Row row18 = new Gscr.Row(); Gscr.Cell cell52 = new Gscr.Cell(); Gscr.Cell cell53 = new Gscr.Cell(); Gscr.Cell cell54 = new Gscr.Cell(); Gscr.Row row19 = new Gscr.Row(); Gscr.Cell cell55 = new Gscr.Cell(); Gscr.Cell cell56 = new Gscr.Cell(); Gscr.Cell cell57 = new Gscr.Cell(); Gscr.Row row20 = new Gscr.Row(); Gscr.Cell cell58 = new Gscr.Cell(); Gscr.Cell cell59 = new Gscr.Cell(); Gscr.Cell cell60 = new Gscr.Cell(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1)); Gscr.Row row21 = new Gscr.Row(); Gscr.Cell cell61 = new Gscr.Cell(); Gscr.Cell cell62 = new Gscr.Cell(); Gscr.Cell cell63 = new Gscr.Cell(); Gscr.SeriesHeaderStyle seriesHeaderStyle1 = new Gscr.SeriesHeaderStyle(); this.report1 = new Gscr.Report(); this.linkLabel1 = new System.Windows.Forms.LinkLabel(); ((System.ComponentModel.ISupportInitialize)(this.report1)).BeginInit(); this.SuspendLayout(); // // report1 // this.report1.AllowOrder = false; this.report1.BackColor = System.Drawing.Color.White; 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"; column2.ColumnName = "column2"; column2.Width = 391; column3.ColumnName = "column3"; this.report1.Columns.AddRange(new Gscr.Column[] { column1, column2, column3 }); cell2.CellDrawMode = Gscr.CellDrawMode.Link; cell2.ForeColor = System.Drawing.Color.Blue; cell2.Value = "示例1(常见样式1)"; row1.Cells.AddRange(new Gscr.Cell[] { cell1, cell2, cell3 }); cell5.CellDrawMode = Gscr.CellDrawMode.Link; cell5.ForeColor = System.Drawing.Color.Blue; cell5.Value = "示例2(常见样式2)"; row2.Cells.AddRange(new Gscr.Cell[] { cell4, cell5, cell6 }); cell8.CellDrawMode = Gscr.CellDrawMode.Link; cell8.ForeColor = System.Drawing.Color.Blue; cell8.Value = "示例3(自由格式)"; row3.Cells.AddRange(new Gscr.Cell[] { cell7, cell8, cell9 }); cell11.CellDrawMode = Gscr.CellDrawMode.Link; cell11.ForeColor = System.Drawing.Color.Blue; cell11.Value = "示例4(自由格式之套打)"; row4.Cells.AddRange(new Gscr.Cell[] { cell10, cell11, cell12 }); cell14.CellDrawMode = Gscr.CellDrawMode.Link; cell14.ForeColor = System.Drawing.Color.Blue; cell14.Value = "示例5(多行明细行)"; row5.Cells.AddRange(new Gscr.Cell[] { cell13, cell14, cell15 }); cell17.CellDrawMode = Gscr.CellDrawMode.Link; cell17.ForeColor = System.Drawing.Color.Blue; cell17.Value = "示例6(多种显示形式)"; row6.Cells.AddRange(new Gscr.Cell[] { cell16, cell17, cell18 }); cell20.CellDrawMode = Gscr.CellDrawMode.Link; cell20.ForeColor = System.Drawing.Color.Blue; cell20.Value = "示例7(编辑)"; row7.Cells.AddRange(new Gscr.Cell[] { cell19, cell20, cell21 }); cell23.CellDrawMode = Gscr.CellDrawMode.Link; cell23.ForeColor = System.Drawing.Color.Blue; cell23.Value = "示例8(设计)"; row8.Cells.AddRange(new Gscr.Cell[] { cell22, cell23, cell24 }); cell25.Alignment = System.Drawing.StringAlignment.Center; cell25.ForeColor = System.Drawing.Color.Red; cell25.Value = "最新V3.6"; cell26.CellDrawMode = Gscr.CellDrawMode.Link; cell26.ForeColor = System.Drawing.Color.Blue; cell26.Value = "示例9(分组)"; row9.Cells.AddRange(new Gscr.Cell[] { cell25, cell26, cell27 }); cell29.CellDrawMode = Gscr.CellDrawMode.Link; cell29.ForeColor = System.Drawing.Color.Blue; cell29.Value = "示例10(检索数据)"; row10.Cells.AddRange(new Gscr.Cell[] { cell28, cell29, cell30 }); cell32.CellDrawMode = Gscr.CellDrawMode.Link; cell32.ForeColor = System.Drawing.Color.Blue; cell32.Value = "示例11(带参数检索)"; row11.Cells.AddRange(new Gscr.Cell[] { cell31, cell32, cell33 }); cell35.CellDrawMode = Gscr.CellDrawMode.Link; cell35.ForeColor = System.Drawing.Color.Blue; cell35.Value = "示例12(把报表样式保存到数据库)"; row12.Cells.AddRange(new Gscr.Cell[] { cell34, cell35, cell36 }); cell38.CellDrawMode = Gscr.CellDrawMode.Link; cell38.ForeColor = System.Drawing.Color.Blue; cell38.Value = "示例13(动态创建报表)"; row13.Cells.AddRange(new Gscr.Cell[] { cell37, cell38, cell39 }); cell41.CellDrawMode = Gscr.CellDrawMode.Link; cell41.ForeColor = System.Drawing.Color.Blue; cell41.Value = "示例14(读取Excel)"; row14.Cells.AddRange(new Gscr.Cell[] { cell40, cell41, cell42 }); cell43.Alignment = System.Drawing.StringAlignment.Center; cell43.ForeColor = System.Drawing.Color.Red; cell43.Value = "最新V4.1"; cell44.CellDrawMode = Gscr.CellDrawMode.Link; cell44.ForeColor = System.Drawing.Color.Blue; cell44.Value = "示例15(List数据源)"; cell45.Value = "2010-08-04"; row15.Cells.AddRange(new Gscr.Cell[] { cell43, cell44, cell45 }); cell47.CellDrawMode = Gscr.CellDrawMode.Link; cell47.ForeColor = System.Drawing.Color.Blue; cell47.Value = "示例16(单据固定行打印)"; cell48.Value = "2010-11-06"; row16.Cells.AddRange(new Gscr.Cell[] { cell46, cell47, cell48 }); cell50.CellDrawMode = Gscr.CellDrawMode.Link; cell50.ForeColor = System.Drawing.Color.Blue; cell50.Value = "示例17(财务余额)"; cell51.Value = "2010-11-11"; row17.Cells.AddRange(new Gscr.Cell[] { cell49, cell50, cell51 }); cell53.CellDrawMode = Gscr.CellDrawMode.Link; cell53.ForeColor = System.Drawing.Color.Blue; cell53.Value = "示例18(把报表保存到数据库)"; cell54.Value = "2010-11-15"; row18.Cells.AddRange(new Gscr.Cell[] { cell52, cell53, cell54 }); cell56.CellDrawMode = Gscr.CellDrawMode.Link; cell56.ForeColor = System.Drawing.Color.Blue; cell56.Value = "示例19(自定义编辑控件)"; row19.Cells.AddRange(new Gscr.Cell[] { cell55, cell56, cell57 }); cell59.CellDrawMode = Gscr.CellDrawMode.Link; cell59.ForeColor = System.Drawing.Color.Blue; cell59.Value = "示例20(显示MsChart图表)"; row20.Cells.AddRange(new Gscr.Cell[] { cell58, cell59, cell60 }); this.report1.DetailRows.AddRange(new Gscr.Row[] { row1, row2, row3, row4, row5, row6, row7, row8, row9, row10, row11, row12, row13, row14, row15, row16, row17, row18, row19, row20 }); this.report1.Font = new System.Drawing.Font("宋体", 9F); this.report1.GscrID = ((Gscr.GscrID)(resources.GetObject("report1.GscrID"))); cell61.Alignment = System.Drawing.StringAlignment.Center; cell61.Font = new System.Drawing.Font("仿宋_GB2312", 24F); cell61.IsMerge = true; cell61.MergeEndColumnIndexDiffer = 2; cell61.MergeEndRowIndexDiffer = 0; cell61.MergeStartColumnIndexDiffer = 0; cell61.MergeStartRowIndexDiffer = 0; cell61.Value = "Gscr.ReportV4.1.0.0示例"; cell62.IsMerge = true; cell62.MergeEndColumnIndexDiffer = 1; cell62.MergeEndRowIndexDiffer = 0; cell62.MergeStartRowIndexDiffer = 0; cell63.IsMerge = true; cell63.MergeEndColumnIndexDiffer = 0; cell63.MergeEndRowIndexDiffer = 0; cell63.MergeStartColumnIndexDiffer = -2; cell63.MergeStartRowIndexDiffer = 0; row21.Cells.AddRange(new Gscr.Cell[] { cell61, cell62, cell63 }); row21.Height = 53; this.report1.HeaderRows.AddRange(new Gscr.Row[] { row21 }); this.report1.IsExpandBackground = false; this.report1.IsLoadDetailRowsInitialize = true; this.report1.Location = new System.Drawing.Point(21, 14); this.report1.Name = "report1"; this.report1.PrintMargins = new System.Drawing.Printing.Margins(50, 50, 50, 50); seriesHeaderStyle1.BottomBegin = System.Drawing.Color.YellowGreen; seriesHeaderStyle1.RibbonBackGroundScale = 0.5F; seriesHeaderStyle1.TopEnd = System.Drawing.Color.YellowGreen; this.report1.SeriesHeaderStyle = seriesHeaderStyle1; this.report1.ShowFixedLine = false; this.report1.Size = new System.Drawing.Size(740, 537); this.report1.TabIndex = 0; this.report1.Text = "report1"; this.report1.CellClick += new System.EventHandler <Gscr.CellEventArgs>(this.report1_CellClick); // // linkLabel1 // this.linkLabel1.AutoSize = true; this.linkLabel1.Location = new System.Drawing.Point(450, 567); this.linkLabel1.Name = "linkLabel1"; this.linkLabel1.Size = new System.Drawing.Size(311, 12); this.linkLabel1.TabIndex = 2; this.linkLabel1.TabStop = true; this.linkLabel1.Text = "http://user.qzone.qq.com/1271180210/blog/1378729349"; this.linkLabel1.LinkClicked += new System.Windows.Forms.LinkLabelLinkClickedEventHandler(this.linkLabel1_LinkClicked); // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(788, 610); this.Controls.Add(this.linkLabel1); this.Controls.Add(this.report1); this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle; this.MaximizeBox = false; this.Name = "Form1"; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; this.Text = "Form1(CSharp)"; ((System.ComponentModel.ISupportInitialize)(this.report1)).EndInit(); this.ResumeLayout(false); this.PerformLayout(); }