水晶报表示例

• List item

		private void Form_PrintOrder_Load(object sender, EventArgs e)
        {
            CreateDataTable();
            ReportDocument doc = new ReportDocument();
            

            string str = Application.StartupPath.ToString();
            int strLenth = Application.StartupPath.Length;
            int strSite = Application.StartupPath.LastIndexOf("\\");
            string strSubstr = Application.StartupPath.Substring(0, Application.StartupPath.LastIndexOf("\\"));
            string strPath = Application.StartupPath.Substring(
                0,
                Application.StartupPath.Substring(0, Application.StartupPath.LastIndexOf("\\")).LastIndexOf("\\")
                ); //计算报表路径
            strPath += @"\CrystalReport1.rpt";  //添加报表名称

            doc.Load(strPath);

            doc.SetDataSource(table); // 设置数据源

            

            this.crystalReportViewer1.ShowCloseButton = false;
            this.crystalReportViewer1.ShowGroupTreeButton = false;
            this.crystalReportViewer1.ShowParameterPanelButton = false;
            this.crystalReportViewer1.ShowLogo = false;
            this.crystalReportViewer1.DisplayBackgroundEdge = false;
            this.crystalReportViewer1.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None;
            //TextObject to = (TextObject)doc.ReportDefinition.ReportObjects[0];
            //to.Text = "hahhahah";
            this.crystalReportViewer1.ReportSource = doc;  // 加载报表

            ((TabControl)crystalReportViewer1.Controls[0].Controls[0]).TabPages[0].Text = "OTP订单烧写记录表";
        }

        // 创建数据表资料,用于存放数据
        public void CreateDataTable()
        {
            table.Columns.Clear();
            //第一列QRCode
            DataColumn column = new DataColumn("OrderNumQRCode", Type.GetType("System.Byte[]"));
            column.Caption = column.ColumnName;
            table.Columns.Add(column);

            DataColumn column1 = new DataColumn("OrderNum", Type.GetType("System.String"));
            column1.Caption = column1.ColumnName;
            table.Columns.Add(column1);

            DataColumn column2 = new DataColumn("ProductDes", Type.GetType("System.String"));
            column2.Caption = column2.ColumnName;
            table.Columns.Add(column2);

            DataColumn column3 = new DataColumn("PrintingType", Type.GetType("System.String"));
            column3.Caption = column3.ColumnName;
            table.Columns.Add(column3);

            DataColumn column4 = new DataColumn("Project", Type.GetType("System.String"));
            column4.Caption = column4.ColumnName;
            table.Columns.Add(column4);

            DataColumn column5 = new DataColumn("PlanQuantity", Type.GetType("System.String"));
            column5.Caption = column5.ColumnName;
            table.Columns.Add(column5);

            DataColumn column6 = new DataColumn("SpareNum", Type.GetType("System.String"));
            column6.Caption = column6.ColumnName;
            table.Columns.Add(column6);

            DataColumn column7 = new DataColumn("CheckSum", Type.GetType("System.String"));
            column7.Caption = column7.ColumnName;
            table.Columns.Add(column7);

            DataColumn column8 = new DataColumn("ProgramVer", Type.GetType("System.String"));
            column8.Caption = column8.ColumnName;
            table.Columns.Add(column8);

            DataColumn column9 = new DataColumn("ProjectEng", Type.GetType("System.String"));
            column9.Caption = column9.ColumnName;
            table.Columns.Add(column9);

            DataColumn column10 = new DataColumn("Packing", Type.GetType("System.String"));
            column10.Caption = column10.ColumnName;
            table.Columns.Add(column10);

            DataColumn column11 = new DataColumn("Testing", Type.GetType("System.String"));
            column11.Caption = column11.ColumnName;
            table.Columns.Add(column11);

            DataColumn column12 = new DataColumn("OrderDate", Type.GetType("System.String"));
            column12.Caption = column12.ColumnName;
            table.Columns.Add(column12);

            DataColumn column13 = new DataColumn("SalesOrderNum", Type.GetType("System.String"));
            column13.Caption = column13.ColumnName;
            table.Columns.Add(column13);

            DataColumn column14 = new DataColumn("TubeLabel", Type.GetType("System.String"));
            column14.Caption = column14.ColumnName;
            table.Columns.Add(column14);

            DataColumn column15 = new DataColumn("Note2", Type.GetType("System.String"));
            column15.Caption = column15.ColumnName;
            table.Columns.Add(column15);

            table.Rows.Clear();

            // 将图片读到stream,并转换为byte[]
            // QRCode
            FileStream fs1 = new FileStream(@"./QRCode.png", FileMode.Open, FileAccess.Read);
            BinaryReader br1 = new BinaryReader(fs1);
            byte[] bt1 = br1.ReadBytes((int)fs1.Length);

            DataRow newRow = table.NewRow();
            newRow[0] = bt1;
            newRow[1] = OrderNum;
            newRow[2] = ProductDes;
            newRow[3] = PrintingType;
            newRow[4] = Project;
            newRow[5] = PlanQuantity;
            newRow[6] = SpareNum;
            newRow[7] = CheckSum;
            newRow[8] = ProgramVer;
            newRow[9] = ProjectEng;

            newRow[10] = Packing;
            newRow[11] = Testing;
            newRow[12] = OrderDate;
            newRow[13] = SalesOrderNum;
            newRow[14] = TubeLabel;
            newRow[15] = Note2;

            table.Rows.Add(newRow);

        }