mes-client/UAS_MES_MAXMADE/FunctionCode/Query/Query_SpecialReport.cs

using Seagull.BarTender.Print;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using UAS_MES_NEW.DataOperate;
using UAS_MES_NEW.Entity;
using UAS_MES_NEW.PublicMethod;

namespace UAS_MES_NEW.Query
{
    public partial class Query_SpecialReport : Form
    {

        DataHelper dh = SystemInf.dh;

        Seagull.BarTender.Print.Engine engine = new Seagull.BarTender.Print.Engine();

        LabelFormatDocument format;

        public Query_SpecialReport()
        {
            InitializeComponent();
        }

        private void Export_Click(object sender, EventArgs e)
        {
            ExcelExport("");
        }

        //选择导出Excel时是选择导出数据的还是模板
        private void ExcelExport(string DataOrTemplet)
        {
            for (int i = int.Parse(Rn.Text); i < int.Parse(Num.Text); i = i + 4)
            {
                int temp = i;
                for (int j = 0; j < format.SubStrings.Count; j++)
                {
                    switch (format.SubStrings[j].Name)
                    {
                        case "RN1":
                            format.SubStrings[j].Value = (Prefix.Text + Date.Value.ToString("yymmdd") + lpad(4, (temp).ToString()));
                            break;
                        case "RN2":
                            format.SubStrings[j].Value = (Prefix.Text + Date.Value.ToString("yymmdd") + lpad(4, (temp + 1).ToString()));
                            break;
                        case "RN3":
                            format.SubStrings[j].Value = (Prefix.Text + Date.Value.ToString("yymmdd") + lpad(4, (temp + 2).ToString()));
                            break;
                        case "RN4":
                            format.SubStrings[j].Value = (Prefix.Text + Date.Value.ToString("yymmdd") + lpad(4, (temp + 3).ToString()));
                            break;
                        default:
                            break;
                    }
                }
            }
            format.PrintSetup.PrinterName = Printer.Text;
            format.PrintSetup.IdenticalCopiesOfLabel = 1;
            format.Print();
        }

        private void Query_SpecialReport_Load(object sender, EventArgs e)
        {
            format = engine.Documents.Open("Label.btw");
        }

        private static string lpad(int length, string number)
        {
            while (number.Length < length)
            {
                number = "0" + number;
            }
            number = number.Substring(number.Length - length, length);
            return number;
        }

        private void inoutno_TextChanged(object sender, EventArgs e)
        {

        }
    }
}