ASP.NET使用RDLC打印条形码和二维码

小牛升大牛

于 2021-12-17 19:59:03 发布

阅读量1.8k

点赞数 2

分类专栏： C# RDLC 条形码文章标签： c# asp.net

本文链接：https://blog.csdn.net/sanqianheijia/article/details/122003973

版权

C# 同时被 3 个专栏收录

23 篇文章 0 订阅

订阅专栏

RDLC

8 篇文章 0 订阅

订阅专栏

条形码

1 篇文章 0 订阅

订阅专栏

最近碰到了需求，需要在打印报表上增加条形码和二维码。由于系统是由asp.net框架开发的，遇到了不少问题，rdlc显然更适合winform，解决后特此记录如下。先说环境，VS2015开发。

首先在rdlc页面工具箱中先拖动一个矩阵控件，再拖一个图像控件到矩阵的单元格内。

拖进单元格后退弹出图像属性弹窗，选择图像源选择数据库，使用此字段选择数据源字段，类型选择图像格式,bmp/jpeg/png等均可

后台方法，其中条形码可以引用CodeLib.dll或者直接使用Code39.cs类，二维码需要引用ThoughtWorks.dll。

        /// <summary>
        /// 打印
        /// </summary>
        public void PrintDelivery()
        {
            DataTable dt = new DataTable();
            //客户名称
            dt.Columns.Add("cCusName", System.Type.GetType("System.Object"));
            //业务员名称
            dt.Columns.Add("cPersonName", System.Type.GetType("System.Object"));
            //单号，即二维码条码内容
            dt.Columns.Add("ID", System.Type.GetType("System.Object"));
            DataRow row = dt.NewRow();
            dt.Rows.Add(row);
            dt.Rows[0]["cCusName"] = "111";
            dt.Rows[0]["cPersonName"] = "222";
            dt.Rows[0]["ID"] = "FH-0001";

            //加载条形码,引用CodeLib.dll或者直接使用Code39.cs
            if (dt.Rows.Count == 1)
            {
                //生成条形码图像，保存至本地，然后将路径填充到dtSource中
                //byte[] by = PublicUtils.CreateImage(dt.Rows[0]["ID"].ToString(), false, 340, 40);

                Code39 _Code39 = new Code39();
                _Code39.Height = 120; //高度
                _Code39.Magnify = 3;  //放大倍数
                _Code39.ViewFont = new Font("宋体", 20);  // 设置字体
                Bitmap bitMap = _Code39.GetCodeImage("1234", Code39.Code39Model.Code39Normal, true);  // 根据传入的参数，生成对应的“位图”；


                //新增ImagePathBarcode列为条形码列
                dt.Columns.Add("ImagePathBarcode", System.Type.GetType("System.Object"));
                //dt.Rows[0]["ImagePathBarcode"] = by;
                dt.Rows[0]["ImagePathBarcode"] = _Code39.ImageToBytes(bitMap);
                dt.AcceptChanges();
            }
            //加载二维码,引用ThoughtWorks.dll
            if (dt != null && dt.Rows.Count > 0)
            {
                //生成二维码图像，保存至本地，然后将路径填充到dtSource中
                byte[] _ByteDatas = PublicUtils.EncoderQRCode(dt.Rows[0]["ID"].ToString(), 100, 5);
                //新增ImagePathQRcode列为二维码列
                dt.Columns.Add("ImagePathQRcode", System.Type.GetType("System.Object"));
                dt.Rows[0]["ImagePathQRcode"] = _ByteDatas;
                dt.AcceptChanges();
            }


            //创建子表
            DataTable dtChild = new DataTable();
            //编码
            dtChild.Columns.Add("Code", System.Type.GetType("System.Object"));
            //产品
            dtChild.Columns.Add("Name", System.Type.GetType("System.Object"));
            //数量
            dtChild.Columns.Add("Quantity", System.Type.GetType("System.Object"));
            //单价
            dtChild.Columns.Add("Price", System.Type.GetType("System.Object"));
            //金额
            dtChild.Columns.Add("Money", System.Type.GetType("System.Object"));
            DataRow rowChild = dtChild.NewRow();
            rowChild["Code"] = "001";
            rowChild["Name"] = "钢笔";
            rowChild["Quantity"] = "10";
            rowChild["Price"] = "200";
            rowChild["Money"] = "2000";
            dtChild.Rows.Add(rowChild);
            DataRow rowChild2 = dtChild.NewRow();
            rowChild2["Code"] = "002";
            rowChild2["Name"] = "铅笔";
            rowChild2["Quantity"] = "10";
            rowChild2["Price"] = "2";
            rowChild2["Money"] = "20";
            dtChild.Rows.Add(rowChild2);



            this.ReportViewer1.LocalReport.DataSources.Clear();
            this.ReportViewer1.LocalReport.ReportPath = "ReportModel\\ReportDelivery.rdlc";
            ReportDataSource rds = new ReportDataSource("DataSet1", dt);
            this.ReportViewer1.LocalReport.DataSources.Add(rds);
            ReportDataSource rdsChild = new ReportDataSource("DataSet2", dtChild);
            this.ReportViewer1.LocalReport.DataSources.Add(rdsChild);
            this.ReportViewer1.LocalReport.Refresh();

        }

条形码辅助类Code39.cs

using System;
using System.Collections;
using System.Collections.Generic;
using System.Drawing;
using System.Linq;
using System.Web;

namespace RDLC的使用
{
    public class Code39
    {
        private Hashtable m_Code39 = new Hashtable();
        private byte m_Magnify = 0;
        /// <summary>
        /// 放大倍数
        /// </summary>
        public byte Magnify { get { return m_Magnify; } set { m_Magnify = value; } }

        private int m_Height = 40;
        /// <summary>
        /// 图形高
        /// </summary>
        public int Height { get { return m_Height; } set { m_Height = value; } }

        private Font m_ViewFont = null;
        /// <summary>
        /// 字体大小
        /// </summary>
        public Font ViewFont { get { return m_ViewFont; } set { m_ViewFont = value; } }

        public Code39()
        {

            m_Code39.Add("A", "1101010010110");
            m_Code39.Add("B", "1011010010110");
            m_Code39.Add("C", "1101101001010");
            m_Code39.Add("D", "1010110010110");
            m_Code39.Add("E", "1101011001010");
            m_Code39.Add("F", "1011011001010");
            m_Code39.Add("G", "1010100110110");
            m_Code39.Add("H", "1101010011010");
            m_Code39.Add("I", "1011010011010");
            m_Code39.Add("J", "1010110011010");
            m_Code39.Add("K", "1101010100110");
            m_Code39.Add("L", "1011010100110");
            m_Code39.Add("M", "1101101010010");
            m_Code39.Add("N", "1010110100110");
            m_Code39.Add("O", "1101011010010");
            m_Code39.Add("P", "1011011010010");
            m_Code39.Add("Q", "1010101100110");
            m_Code39.Add("R", "1101010110010");
            m_Code39.Add("S", "1011010110010");
            m_Code39.Add("T", "1010110110010");
            m_Code39.Add("U", "1100101010110");
            m_Code39.Add("V", "1001101010110");
            m_Code39.Add("W", "1100110101010");
            m_Code39.Add("X", "1001011010110");
            m_Code39.Add("Y", "1100101101010");
            m_Code39.Add("Z", "1001101101010");
            m_Code39.Add("0", "1010011011010");
            m_Code39.Add("1", "1101001010110");
            m_Code39.Add("2", "1011001010110");
            m_Code39.Add("3", "1101100101010");
            m_Code39.Add("4", "1010011010110");
            m_Code39.Add("5", "1101001101010");
            m_Code39.Add("6", "1011001101010");
            m_Code39.Add("7", "1010010110110");
            m_Code39.Add("8", "1101001011010");
            m_Code39.Add("9", "1011001011010");
            m_Code39.Add("+", "1001010010010");
            m_Code39.Add("-", "1001010110110");
            m_Code39.Add("*", "1001011011010");
            m_Code39.Add("/", "1001001010010");
            m_Code39.Add("%", "1010010010010");
            m_Code39.Add("$", "1001001001010");
            m_Code39.Add(".", "1100101011010");
            m_Code39.Add(" ", "1001101011010");
        }

        public enum Code39Model
        {
            /// <summary>
            /// 基本类别 1234567890ABC
            /// </summary>
            Code39Normal,
            /// <summary>
            /// 全ASCII方式 +A+B 来表示小写
            /// </summary>
            Code39FullAscII
        }
        /// <summary>
        /// 获得条码图形
        /// </summary>
        /// <param name="p_Text">文字信息</param>
        /// <param name="p_Model">类别</param>
        /// <param name="p_StarChar">是否增加前后*号</param>
        /// <returns>图形</returns>
        public Bitmap GetCodeImage(string p_Text, Code39Model p_Model, bool p_StarChar)
        {
            string _ValueText = "";
            string _CodeText = "";
            char[] _ValueChar = null;
            switch (p_Model)
            {
                case Code39Model.Code39Normal:
                    _ValueText = p_Text.ToUpper();
                    break;
                default:
                    _ValueChar = p_Text.ToCharArray();
                    for (int i = 0; i != _ValueChar.Length; i++)
                    {
                        if ((int)_ValueChar[i] >= 97 && (int)_ValueChar[i] <= 122)
                        {
                            _ValueText += "+" + _ValueChar[i].ToString().ToUpper();

                        }
                        else
                        {
                            _ValueText += _ValueChar[i].ToString();
                        }
                    }
                    break;
            }
            _ValueChar = _ValueText.ToCharArray();
            if (p_StarChar == true) _CodeText += m_Code39["*"];
            for (int i = 0; i != _ValueChar.Length; i++)
            {
                if (p_StarChar == true && _ValueChar[i] == '*') throw new Exception("带有起始符号不能出现*");
                object _CharCode = m_Code39[_ValueChar[i].ToString()];
                if (_CharCode == null) throw new Exception("不可用的字符" + _ValueChar[i].ToString());
                _CodeText += _CharCode.ToString();
            }
            if (p_StarChar == true) _CodeText += m_Code39["*"];

            Bitmap _CodeBmp = GetImage(_CodeText);
            GetViewImage(_CodeBmp, p_Text);
            return _CodeBmp;
        }

        /// <summary>
        /// 绘制编码图形
        /// </summary>
        /// <param name="p_Text">编码</param>
        /// <returns>图形</returns>
        private Bitmap GetImage(string p_Text)
        {
            char[] _Value = p_Text.ToCharArray();

            //宽 == 需要绘制的数量*放大倍数 + 两个字的宽   
            Bitmap _CodeImage = new Bitmap(_Value.Length * ((int)m_Magnify + 1), (int)m_Height);
            Graphics _Garphics = Graphics.FromImage(_CodeImage);
            _Garphics.FillRectangle(Brushes.White, new Rectangle(0, 0, _CodeImage.Width, _CodeImage.Height));

            int _LenEx = 0;
            for (int i = 0; i != _Value.Length; i++)
            {
                int _DrawWidth = m_Magnify + 1;
                if (_Value[i] == '1')
                {
                    _Garphics.FillRectangle(Brushes.Black, new Rectangle(_LenEx, 0, _DrawWidth, m_Height));
                }
                else
                {
                    _Garphics.FillRectangle(Brushes.White, new Rectangle(_LenEx, 0, _DrawWidth, m_Height));
                }
                _LenEx += _DrawWidth;
            }

            _Garphics.Dispose();
            return _CodeImage;
        }
        /// <summary>
        /// 绘制文字
        /// </summary>
        /// <param name="p_CodeImage">图形</param>
        /// <param name="p_Text">文字</param>
        private void GetViewImage(Bitmap p_CodeImage, string p_Text)
        {
            if (m_ViewFont == null) return;
            Graphics _Graphics = Graphics.FromImage(p_CodeImage);
            SizeF _FontSize = _Graphics.MeasureString(p_Text, m_ViewFont);
            if (_FontSize.Width > p_CodeImage.Width || _FontSize.Height > p_CodeImage.Height - 20)
            {
                _Graphics.Dispose();
                return;
            }
            int _StarHeight = p_CodeImage.Height - (int)_FontSize.Height;
            _Graphics.FillRectangle(Brushes.White, new Rectangle(0, _StarHeight, p_CodeImage.Width, (int)_FontSize.Height));
            int _StarWidth = (p_CodeImage.Width - (int)_FontSize.Width) / 2;
            _Graphics.DrawString(p_Text, m_ViewFont, Brushes.Black, _StarWidth, _StarHeight);
            _Graphics.Dispose();
        }


        public byte[] ImageToBytes(Image img)
        {
            ImageConverter imgconv = new ImageConverter();
            byte[] b = (byte[])imgconv.ConvertTo(img, typeof(byte[]));
            return b;
        }

    }
}

二维码辅助类PublicUtils.cs

using CodeLib;
using System;
using System.Collections.Generic;
using System.Drawing;
using System.Drawing.Imaging;
using System.IO;
using System.Linq;
using System.Text;
using System.Web;
using ThoughtWorks.QRCode.Codec;

namespace RDLC的使用
{
    public static class PublicUtils
    {

        /// <summary>
        /// 生成一维码
        /// </summary>
        /// <param name="carRecordNo">数据源</param>
        /// <param name="ShowText">是否条形码下面显示编号</param>
        /// <param name="Width">长度</param>
        /// <param name="Height">宽度</param>
        /// <returns></returns>
        public static byte[] CreateImage(string carRecordNo, bool ShowText, int Width, int Height)
        {
            Barcode b = new Barcode();
            var W = Width;
            var H = Height;
            var Align = AlignmentPositions.CENTER;

            //barcode alignment                   
            Align = AlignmentPositions.CENTER;

            //设置编码
            var type = TYPE.UNSPECIFIED;
            type = TYPE.CODE128B;

            try
            {
                if (type != TYPE.UNSPECIFIED)
                {
                    b.IncludeLabel = ShowText; //条形码下面显示编号
                    b.Alignment = Align;

                    //label alignment and position 显示对齐位置
                    b.LabelPosition = LabelPositions.BOTTOMCENTER;
                    b.LabelFont = new Font("宋体", 40);

                    Image img = b.Encode(type, carRecordNo, W, H);
                    MemoryStream _MemoryStream = new MemoryStream();
                    img.Save(_MemoryStream, System.Drawing.Imaging.ImageFormat.Bmp);
                    byte[] _Bytes = new Byte[_MemoryStream.Length];
                    _MemoryStream.Position = 0;
                    _MemoryStream.Read(_Bytes, 0, _Bytes.Length);
                    _MemoryStream.Close();
                    return _Bytes;
                }
                else
                {
                    return new byte[1];
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }


        /// <summary>
        /// 生成二维码（图片尺寸）
        /// </summary>
        /// <param name="Content">内容文本</param>
        /// <param name="size">图片尺寸（像素）</param>
        /// <param name="margin">图片白边（像素）</param>
        /// <returns></returns>
        public static byte[] EncoderQRCode(string Content, int size, int margin = 5)
        {
            QRCodeEncoder qrCodeEncoder = new QRCodeEncoder();
            qrCodeEncoder.QRCodeEncodeMode = QRCodeEncoder.ENCODE_MODE.BYTE;
            qrCodeEncoder.QRCodeErrorCorrect = QRCodeEncoder.ERROR_CORRECTION.M;
            qrCodeEncoder.QRCodeScale = 5;
            qrCodeEncoder.QRCodeVersion = 0;
            try
            {
                System.Drawing.Image image = qrCodeEncoder.Encode(Content, Encoding.UTF8);
                int resWidth = size + 2 * margin;
                int resHeight = size + 2 * margin;
                // 核心就是这里新建一个bitmap对象然后将image在这里渲染
                Bitmap newBit = new Bitmap(resWidth, resHeight, PixelFormat.Format32bppRgb);
                Graphics gg = Graphics.FromImage(newBit);
                // 设置背景白色
                for (int y = 0; y < resWidth; y++)
                {
                    for (int x = 0; x < resHeight; x++)
                    {
                        newBit.SetPixel(x, y, Color.White);
                    }
                }

                // 设置黑色边框
                for (int i = 0; i < resWidth; i++)
                {
                    //newBit.SetPixel(i, 0, Color.Black);
                    //newBit.SetPixel(i, resWidth - 1, Color.Black);

                }
                for (int j = 0; j < resHeight; j++)
                {
                    //newBit.SetPixel(0, j, Color.Black);
                    //newBit.SetPixel(resHeight - 1, j, Color.Black);

                }
                gg.DrawImage(image, margin, margin, size, size);
                //newBit.Save(size.ToString() + ".png");
                //return newBit;

                MemoryStream _MemoryStream = new MemoryStream();
                newBit.Save(_MemoryStream, System.Drawing.Imaging.ImageFormat.Bmp);
                byte[] _Bytes = new Byte[_MemoryStream.Length];
                _MemoryStream.Position = 0;
                _MemoryStream.Read(_Bytes, 0, _Bytes.Length);
                _MemoryStream.Close();
                return _Bytes;

            }
            catch (Exception ex)
            {
                throw ex;
            }
        }


    }
}

注意，Code39条形码的是一种编码格式，也有其他的编码格式。内容如果变长条形码的长度也会随着变长，所以要测试RDLC存放图像的单元格多长合适，太短生成的二维码会无法识别。二维码大小固定且可以存储各种格式，所以推荐使用二维码。

完整代码如下：

https://download.csdn.net/download/sanqianheijia/71925276