【Wonder原创】栈板标签列印

一、画面效果如下：

二、打印效果

三、后台代码：

1、全局变量

　　public static int _Cur_index;   //当前页码
　　public static string[] _BoardList; //需要打印的栈板号数组

2、自定义方法

 

//重置全局变量
        private void ClearVar()
        {
            _Cur_index = 0;
            _BoardList = null;
        }

核心打印方法：

 

private void BarcodePrint(PrintPageEventArgs e, DataTable dt)
        {
            string CodeNo="", PN="", qty="0", Sdate="",Bindex="";

            foreach (DataRow dr in dt.Rows)
            {
                CodeNo = dr["CodeNo"].ToString();
                PN = dr["PN"].ToString();
                Sdate = dr["DDate"].ToString();
                Bindex = dr["bindex"].ToString();
                qty = (Convert.ToInt32(qty) + Convert.ToInt32(dr["qty"].ToString())).ToString();
            }
            Graphics g = e.Graphics;
            Font fnt = new Font("Arial", 22);

            float xWidth = 1000F, yWidth = 700F;
            float xStart = 60F, yStart = 60F;
            float y = yStart;
            float space = 25F;

            #region 文本
            g.DrawLine(System.Drawing.Pens.Black, xStart, y, xStart + xWidth, y);//line (0,0) 横线            
            g.DrawLine(System.Drawing.Pens.Black, xStart, y, xStart, y + yWidth);//line (0,0) 竖线
            g.DrawLine(System.Drawing.Pens.Black, xStart + 230, y, xStart + 230, y + yWidth);//line (1,0) 竖线
            g.DrawLine(System.Drawing.Pens.Black, xStart + xWidth, y, xStart + xWidth, y + yWidth);//line (3,0) 竖线

            y += space;
            y += fnt.Height / 2;
            g.DrawString("Car Number", fnt, System.Drawing.Brushes.Black, xStart, y);//"Car Number"
            y += space;
            y += fnt.Height + fnt.Height / 2;
            g.DrawLine(System.Drawing.Pens.Black, xStart, y, xStart + xWidth, y);//line (0,1) 横线
            g.DrawLine(System.Drawing.Pens.Black, xStart + 500, y, xStart + 500, yWidth + yStart);//line (2,1) 竖线
            y += space;

            g.DrawString("Company", fnt, System.Drawing.Brushes.Black, xStart, y);//"Company"
            g.DrawString("Xxxx Xxxxxxxxx", fnt, System.Drawing.Brushes.Black, xStart + 250, y);//"Xxxx Xxxxxxxxx"
            y += fnt.Height;
            g.DrawString("Name", fnt, System.Drawing.Brushes.Black, xStart, y);//"Name"
            g.DrawString("Corp.", fnt, System.Drawing.Brushes.Black, xStart + 320, y);//"Corp."
            y += fnt.Height;
            y += space;
            g.DrawLine(System.Drawing.Pens.Black, xStart, y, xStart + 500, y);//line (0,2) 横线
            y += space;

            y += fnt.Height / 2;
            g.DrawString("Material Code", fnt, System.Drawing.Brushes.Black, xStart, y);//"Material Code"
            g.DrawString(CodeNo, fnt, System.Drawing.Brushes.Black, xStart + 230, y);//CodeNo:"LJ01-07716A"
            y += fnt.Height + fnt.Height / 2;
            y += space;
            g.DrawLine(System.Drawing.Pens.Black, xStart, y, xStart + 500, y);//line (0,3) 横线            
            y += space;

            y += fnt.Height / 2;
            g.DrawString("Recipe", fnt, System.Drawing.Brushes.Black, xStart, y);//"Recipe"
            g.DrawString(PN, fnt, System.Drawing.Brushes.Black, xStart + 230, y);//PN:"PL-15-324"
            y += fnt.Height + fnt.Height / 2;
            y += space;
            g.DrawLine(System.Drawing.Pens.Black, xStart, y, xStart + 500, y);//line (0,4) 横线            
            y += space;

            y += fnt.Height / 2;
            g.DrawString("Q'ty", fnt, System.Drawing.Brushes.Black, xStart, y);//"Q'ty"
            g.DrawString(qty, fnt, System.Drawing.Brushes.Black, xStart + 230, y);//QTY:"9000"
            y += fnt.Height + fnt.Height / 2;
            y += space;
            g.DrawLine(System.Drawing.Pens.Black, xStart, y, xStart + 500, y);//line (0,5) 横线            
            y += space;

            y += fnt.Height / 2;            
            g.DrawString("Production Date", fnt, System.Drawing.Brushes.Black, xStart, y);//"Production Date"
            g.DrawString(Sdate, fnt, System.Drawing.Brushes.Black, xStart + 230, y);//Date:"2010-08-27"
            y += fnt.Height + fnt.Height / 2;            

            g.DrawLine(System.Drawing.Pens.Black, xStart, yStart + yWidth, xStart + xWidth, yStart + yWidth);//line (0,6) 横线
            g.DrawString(Bindex, new Font("Arial", 10), System.Drawing.Brushes.Black, xWidth + xStart + 10, yStart + yWidth + 10);//Bindex
            #endregion

            #region Barcode
            float x = xStart+ 500F+10F;
            y = yStart + fnt.Height * 2 + space * 2 + 10F;

            BarcodeLib.Barcode barcode = new BarcodeLib.Barcode();
            barcode.IncludeLabel = true;
            barcode.Height = 35;
            barcode.Width = 200;
            barcode.LabelFont = new Font("Arial", 12, FontStyle.Regular);
            barcode.LabelPosition = BarcodeLib.LabelPositions.BOTTOMCENTER;
            barcode.Alignment = BarcodeLib.AlignmentPositions.CENTER;

            for (int i = 1; i <= 18 && i<=dt.Rows.Count; i++)
            {
                string barcodeStr = dt.Rows[i-1][0].ToString()+i.ToString("D3");
            
                Image image = barcode.Encode(BarcodeLib.TYPE.CODE39Extended, barcodeStr);
                g.DrawImage(image, x+240*((i-1)/(dt.Rows.Count/2)), y+((i-1)%(dt.Rows.Count/2))*65);//Barcode
            }
            #endregion

        }

 

3、“查询”按钮事件，查询需要打印的数据

 

private void btnQuery_Click(object sender, EventArgs e)
        {
            if (drpCUS.SelectedIndex == -1 || drpDept.SelectedIndex == -1)
            {
                MessageBox.Show("请先选择客户及部门.");
                return;
            }
            lblBSum.Text = "0";
            lblQSum.Text = "0";            
            try
            {
                DataSet ds = CDataSet.GetSTList(drpCUS.SelectedItem.ToString(), drpDept.SelectedItem.ToString(), dDate.Value.ToShortDateString(), "%");
                if (ds != null)
                {
                    CDataSet.BindToCombox(drpSTNO, ds.Tables[0], "STNO");
                    if (drpSTNO.Items.Count > 0)
                    {
                        ds = CDataSet.GetSTList(drpCUS.SelectedItem.ToString(), drpDept.SelectedItem.ToString(), dDate.Value.ToShortDateString(), drpSTNO.SelectedItem.ToString());
                        gvData.DataSource = ds.Tables[0];

                        int i = 0;
                        double qty = 0;
                        for (; i < ds.Tables[0].Rows.Count; i++)
                        {
                            qty += Convert.ToDouble(ds.Tables[0].Rows[i]["数量"].ToString());                            
                        }
                        lblBSum.Text = i.ToString();
                        lblQSum.Text = qty.ToString();
                    }
                    else
                    {
                        gvData.DataSource = null;
                        drpSTNO.Text = "";
                        drpSTNO.Items.Clear();
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

4、“列印全部”按钮事件

 

private void btnPrint_Click(object sender, EventArgs e)
        {
            try
            {
                StringBuilder sbStr = new StringBuilder();
                ClearVar();
                foreach (DataGridViewRow gr in gvData.Rows)
                {
                    sbStr.Append(gr.Cells[7].Value.ToString());
                    sbStr.Append(",");
                }
                _BoardList = sbStr.ToString().TrimEnd(',').Split(',');
                if (_BoardList != null && _BoardList.Length > 0)
                {
                    printDoc.PrintController = new System.Drawing.Printing.StandardPrintController();//隐藏“正在打印。。。”小窗口
                    printDoc.DefaultPageSettings.Landscape = true;//横向打印
                    printDoc.Print();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

5、PrintDocument 响应PrintPage事件

打印每一页都会触发这个事件，注意 HasMorePages 达到分页列印效果。

 

 

private void printDoc_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
        {
            try
            {

                DataSet ds = CDataSet.GetBoard_SEC(_BoardList[_Cur_index].ToString());
                if (ds != null && ds.Tables.Count > 0)
                {
                    //BarcodePrint(e, "LJ01-07716A1", "PL-15-324", "9000", "2010-8-27");
                    BarcodePrint(e, ds.Tables[0]);
                }
                _Cur_index++;
                if (_Cur_index < _BoardList.Length)
                    e.HasMorePages = true;

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }