mes-client/UAS_MES_PNE/FunctionCode/Query/Query_SN.cs

using LabelManager2;
using System;
using System.Data;
using System.Security.Cryptography;
using System.Text;
using System.Threading;
using System.Windows.Forms;
using UAS_MES_NEW.DataOperate;
using UAS_MES_NEW.Entity;
using UAS_MES_NEW.PublicForm;
using UAS_MES_NEW.PublicMethod;

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

        DataHelper dh = SystemInf.dh;

        ApplicationClass lbl;

        Thread InitPrint;

        Document doc;

        public Query_SN()
        {
            InitializeComponent();
        }

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

        //选择导出Excel时是选择导出数据的还是模板
        private void ExcelExport(string DataOrTemplet)
        {
            //Data表示导出数据
            //Templet表示导出模板
            MD5 md5 = MD5.Create();
            folderBrowserDialog1.Description = "选择导出的路径";
            DialogResult result = folderBrowserDialog1.ShowDialog();
            if (result == DialogResult.OK)
            {
                string FolderPath = folderBrowserDialog1.SelectedPath;
                ExcelHandler eh = new ExcelHandler();
                DataTable dt = new DataTable();
                dt.Columns.Add("工单号");
                dt.Columns.Add("序列号");
                dt.Columns.Add("MAC");
                dt.Columns.Add("BT");
                dt.Columns.Add("拓展栏位1");
                dt.Columns.Add("拓展栏位2");
                dt.Columns.Add("拓展栏位3");
                dt.Columns.Add("备注");
                for (decimal i = currentSerial.Value; i < currentSerial.Value + int.Parse(num.Text); i++)
                {
                    DataRow dr = dt.NewRow();

                    dr["工单号"] = ma_code.Text;

                    string serial = pr_code.Text
                        + GetDate(date.Value.ToString("yyyy"), date.Value.ToString("MM"), date.Value.ToString("dd"))
                        + lpad(int.Parse(seriallength.Text), (i + 1).ToString());
                    dr["序列号"] = serial;
                    dt.Rows.Add(dr);
                }
                eh.ExportExcel(dt, FolderPath);
            }
        }

        private void Query_SpecialReport_Load(object sender, EventArgs e)
        {
            InitPrint = new Thread(InPrint);
            SetLoadingWindow stw = new SetLoadingWindow(InitPrint, "初始化打印程序");
            BaseUtil.SetFormCenter(stw);
            stw.ShowDialog();
            doc = lbl.Documents.Open(System.Windows.Forms.Application.StartupPath + @"\SN.lab");
        }

        private void InPrint()
        {
            try
            {
                lbl = new ApplicationClass();
                BaseUtil.WriteLbl();
            }
            catch (Exception)
            {
                MessageBox.Show("未正确安装CodeSoft软件");
            }
        }

        private static string MD5Encoding(string rawPass)
        {
            // 创建MD5类的默认实例：MD5CryptoServiceProvider
            MD5 md5 = MD5.Create();
            byte[] bs = Encoding.UTF8.GetBytes(rawPass);
            byte[] hs = md5.ComputeHash(bs);
            StringBuilder stb = new StringBuilder();
            foreach (byte b in hs)
            {
                // 以十六进制格式格式化
                stb.Append(b.ToString("x2"));
            }
            return stb.ToString().ToUpper();
        }

        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 string GetDate(string year, string month, string day)
        {
            string returndate = "";
            switch (year)
            {
                case "2020":
                    returndate = "C";
                    break;
                case "2021":
                    returndate = "D";
                    break;
                case "2022":
                    returndate = "E";
                    break;
                case "2023":
                    returndate = "F";
                    break;
                case "2024":
                    returndate = "G";
                    break;
                case "2025":
                    returndate = "H";
                    break;
                case "2026":
                    returndate = "I";
                    break;
                case "2027":
                    returndate = "J";
                    break;
                case "2028":
                    returndate = "K";
                    break;
                case "2029":
                    returndate = "L";
                    break;
                case "2030":
                    returndate = "M";
                    break;
                case "2031":
                    returndate = "N";
                    break;
                case "2032":
                    returndate = "O";
                    break;
                case "2033":
                    returndate = "P";
                    break;
                case "2034":
                    returndate = "Q";
                    break;
                default:
                    break;
            }
            switch (month)
            {
                case "01":
                    returndate += "1";
                    break;
                case "02":
                    returndate += "2";
                    break;
                case "03":
                    returndate += "3";
                    break;
                case "04":
                    returndate += "4";
                    break;
                case "05":
                    returndate += "5";
                    break;
                case "06":
                    returndate += "6";
                    break;
                case "07":
                    returndate += "7";
                    break;
                case "08":
                    returndate += "8";
                    break;
                case "09":
                    returndate += "9";
                    break;
                case "10":
                    returndate += "A";
                    break;
                case "11":
                    returndate += "B";
                    break;
                case "12":
                    returndate += "C";
                    break;
                default:
                    break;
            }
            switch (day)
            {
                case "01":
                    returndate += "1";
                    break;
                case "02":
                    returndate += "2";
                    break;
                case "03":
                    returndate += "3";
                    break;
                case "04":
                    returndate += "4";
                    break;
                case "05":
                    returndate += "5";
                    break;
                case "06":
                    returndate += "6";
                    break;
                case "07":
                    returndate += "7";
                    break;
                case "08":
                    returndate += "8";
                    break;
                case "09":
                    returndate += "9";
                    break;
                case "10":
                    returndate += "A";
                    break;
                case "11":
                    returndate += "B";
                    break;
                case "12":
                    returndate += "C";
                    break;
                case "13":
                    returndate += "D";
                    break;
                case "14":
                    returndate += "E";
                    break;
                case "15":
                    returndate += "F";
                    break;
                case "16":
                    returndate += "G";
                    break;
                case "17":
                    returndate += "H";
                    break;
                case "18":
                    returndate += "I";
                    break;
                case "19":
                    returndate += "J";
                    break;
                case "20":
                    returndate += "K";
                    break;
                case "21":
                    returndate += "L";
                    break;
                case "22":
                    returndate += "M";
                    break;
                case "23":
                    returndate += "N";
                    break;
                case "24":
                    returndate += "O";
                    break;
                case "25":
                    returndate += "P";
                    break;
                case "26":
                    returndate += "Q";
                    break;
                case "27":
                    returndate += "R";
                    break;
                case "28":
                    returndate += "S";
                    break;
                case "29":
                    returndate += "T";
                    break;
                case "30":
                    returndate += "U";
                    break;
                case "31":
                    returndate += "V";
                    break;
                default:
                    break;
            }
            return returndate;
        }

        private void Print_Click(object sender, EventArgs e)
        {

            DataTable dt = new DataTable();
            dt.Columns.Add("工单号");
            dt.Columns.Add("序列号");
            dt.Columns.Add("MAC");
            dt.Columns.Add("BT");
            dt.Columns.Add("拓展栏位1");
            dt.Columns.Add("拓展栏位2");
            dt.Columns.Add("拓展栏位3");
            dt.Columns.Add("备注");
            for (decimal i = currentSerial.Value; i < currentSerial.Value + int.Parse(num.Text); i++)
            {
                DataRow dr = dt.NewRow();

                dr["工单号"] = ma_code.Text;

                string serial = pr_code.Text
                    + GetDate(date.Value.ToString("yyyy"), date.Value.ToString("MM"), date.Value.ToString("dd"))
                    + lpad(int.Parse(seriallength.Text), (i + 1).ToString());
                dr["序列号"] = serial;
                dt.Rows.Add(dr);
                for (int j = 0; j < doc.Variables.FormVariables.Count; j++)
                {
                    if (doc.Variables.FormVariables.Item(j + 1).Name.ToUpper() == "SN")
                    {
                        doc.Variables.FormVariables.Item(j + 1).Value = (serial);
                    }
                }
                doc.Printer.SwitchTo(Printer.Text);
                doc.PrintDocument(1);
            }
        }
    }
}