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

using System;
using System.Data;
using System.Security.Cryptography;
using System.Text;
using System.Windows.Forms;
using UAS_MES_NEW.DataOperate;
using UAS_MES_NEW.Entity;

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

        DataHelper dh = SystemInf.dh;

        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("备注");
                string prefix = BeginMac.Text.Substring(0, 8);
                string suffix = BeginMac.Text.Substring(8, 4);
                int Number = Int32.Parse(suffix, System.Globalization.NumberStyles.HexNumber);
                for (int i = 0; i < int.Parse(num.Text); i++)
                {
                    DataRow dr = dt.NewRow();

                    dr["工单号"] = ma_code.Text;
                    dr["MAC"] = prefix + Number.ToString("X");
                    Number = Number + 1;
                    dr["BT"] = prefix + Number.ToString("X");
                    Number = Number + 1;

                    string serial = pr_code.Text
                        + color.Text
                        + GetDate(date.Value.ToString("yyyy"), date.Value.ToString("MM"), date.Value.ToString("dd"))
                        + factory.Text
                        + status.Text
                        + lpad(int.Parse(seriallength.Text), (i + 1).ToString());
                    string encode = MD5Encoding(serial + ")G$d");
                    dr["序列号"] = serial+ encode.Substring(encode.Length-2);
                    dt.Rows.Add(dr);
                }
                eh.ExportExcel(dt, FolderPath);
            }
        }

        private void Query_SpecialReport_Load(object sender, EventArgs e)
        {
           
        }

        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;
        }
    }
}