Ejemplo n.º 1
0
 /// <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);
 }
Ejemplo n.º 2
0
 /// <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);
 }
Ejemplo n.º 3
0
 /// <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();
 }
Ejemplo n.º 4
0
 /// <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);
 }
Ejemplo n.º 5
0
 /// <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);
 }
Ejemplo n.º 6
0
 /// <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);
 }
Ejemplo n.º 7
0
 /// <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);
 }
Ejemplo n.º 8
0
 /// <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);
 }
Ejemplo n.º 9
0
 /// <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();
 }
Ejemplo n.º 10
0
 /// <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();
 }
Ejemplo n.º 11
0
 /// <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);
 }
Ejemplo n.º 12
0
 /// <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);
 }
Ejemplo n.º 13
0
 /// <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);
 }
Ejemplo n.º 14
0
 /// <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();
 }
Ejemplo n.º 15
0
 /// <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();
 }