mes-client/UAS_MES_JWS/FunctionCode/SystemSetting/SystemSetting_PrinterTest.cs

using Seagull.BarTender.Print;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Drawing.Printing;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using System.Windows.Forms;
using UAS_MES_NEW.DataOperate;
using UAS_MES_NEW.Entity;
using UAS_MES_NEW.PublicMethod;
using UAS_MES_NEW.Query;
using static System.Runtime.CompilerServices.RuntimeHelpers;

namespace UAS_MES_NEW.SystemSetting
{
    public partial class SystemSetting_PrinterTest : Form
    {

        Engine engine = new Engine();

        LabelFormatDocument format;

        DataHelper dh = SystemInf.dh;

        DataTable Dbfind;
        public SystemSetting_PrinterTest()
        {
            InitializeComponent();
        }

        private void PrintTest_Click(object sender, EventArgs e)
        {
            PrintDocument print = new PrintDocument();
            print.PrinterSettings.PrinterName = PrinterList.Text;
            print.PrintPage += Print_PrintPage;
            print.Print();
        }

        private void Print_PrintPage(object sender, PrintPageEventArgs e)
        {
            Graphics g = e.Graphics;
            float leftMargin = 10f; //左边距
            SolidBrush myBrush = new SolidBrush(System.Drawing.Color.Black);//刷子
            float yPosition = 5f;//行定位
            Font printFont = new Font("微软雅黑", 20f, FontStyle.Bold);//设置字体
            yPosition += printFont.GetHeight(g);//另起一行
            g.DrawString("成功连接此打印机", printFont, myBrush, leftMargin, yPosition, new StringFormat());
        }

        private void Setting_Click(object sender, EventArgs e)
        {
            PrintDialog printd = new PrintDialog();
            printd.PrinterSettings.PrinterName = PrinterList.Text;
            printd.ShowDialog();
        }

        private void Export_Click(object sender, EventArgs e)
        {
            if (!dh.CheckExist("make", "ma_code='" + ma_code.Text + "'"))
            {
                MessageBox.Show("工单号不存在");
                return;
            }
            /*DataTable dt = (DataTable)dh.ExecuteSql("select pr_machinetype from make left join  product on ma_prodcode=pr_code where ma_code='" + ma_code.Text + "'", "select");
            if (dt.Rows.Count > 0)
            {
                string pr_machinetype = dt.Rows[0]["pr_machinetype"].ToString();
                if (pr_machinetype != Prefix.Text)
                {
                    MessageBox.Show("前缀和产品机型" + pr_machinetype + "不匹配");
                    return;
                }
            }*/
            if (dh.getRowCount("makesnlist", "msl_makecode='" + ma_code.Text + "' and msl_type='转号前'") + int.Parse(Num.Text) > int.Parse(ma_qty.Text))
            {
                MessageBox.Show("工单号" + ma_code.Text + "生产序列号超出工单数");
                return;
            }
            string pr_exbarcode = dh.getFieldDataByCondition("make left join product on pr_code=ma_prodcode", "pr_exbarcode", "ma_code='" + ma_code.Text + "'").ToString();
            if (pr_exbarcode == "")
            {
                if (OneColumn.Checked)
                {
                    format = engine.Documents.Open(Application.StartupPath + "/单排.btw");
                    for (int i = int.Parse(Rn.Text); i < (int.Parse(Num.Text) + int.Parse(Rn.Text)); i = i + 1)
                    {
                        int temp = i;
                        for (int j = 0; j < format.SubStrings.Count; j++)
                        {
                            switch (format.SubStrings[j].Name)
                            {
                                case "SN":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp).ToString()));
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "COLOR":
                                    format.SubStrings[j].Value = Color.Text;
                                    break;
                                case "MACHINE":
                                    format.SubStrings[j].Value = MachineType.Text;
                                    break;
                                case "RAM":
                                    format.SubStrings[j].Value = Ram.Text;
                                    break;
                                default:
                                    break;
                            }
                        }
                        format.PrintSetup.PrinterName = PrinterList.Text;
                        format.PrintSetup.IdenticalCopiesOfLabel = 1;
                        format.Print();

                        DataTable dt = (DataTable)dh.ExecuteSql("select ma_qty,ma_prodcode,pr_detail,ma_printnum from make left join product on ma_prodcode=pr_code left join (select count(1)ma_printnum,msl_makecode from makesnlist where msl_printstatus=-1 group by msl_makecode) on msl_makecode=ma_code where ma_code='" + ma_code.Text + "'", "select");
                        if (dt.Rows.Count > 0)
                        {
                            pr_code.Text = dt.Rows[0]["ma_prodcode"].ToString();
                            ma_qty.Text = dt.Rows[0]["ma_qty"].ToString();
                            ma_printcount.Text = dt.Rows[0]["ma_printnum"].ToString();
                            pr_detail.Text = dt.Rows[0]["pr_detail"].ToString();
                        }
                    }
                }
                if (TwoColumn.Checked)
                {
                    format = engine.Documents.Open(Application.StartupPath + "/双排.btw");
                    for (int i = int.Parse(Rn.Text); i < (int.Parse(Num.Text) + int.Parse(Rn.Text)); i = i + 2)
                    {
                        int temp = i;
                        for (int j = 0; j < format.SubStrings.Count; j++)
                        {
                            switch (format.SubStrings[j].Name)
                            {
                                case "SN":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp).ToString()));
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN2":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 1).ToString()));
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                default:
                                    break;
                            }
                        }
                        format.PrintSetup.PrinterName = PrinterList.Text;
                        format.PrintSetup.IdenticalCopiesOfLabel = 1;
                        format.Print();

                        DataTable dt = (DataTable)dh.ExecuteSql("select ma_qty,ma_prodcode,pr_detail,ma_printnum from make left join product on ma_prodcode=pr_code left join (select count(1)ma_printnum,msl_makecode from makesnlist where msl_printstatus=-1 group by msl_makecode) on msl_makecode=ma_code where ma_code='" + ma_code.Text + "'", "select");
                        if (dt.Rows.Count > 0)
                        {
                            pr_code.Text = dt.Rows[0]["ma_prodcode"].ToString();
                            ma_qty.Text = dt.Rows[0]["ma_qty"].ToString();
                            ma_printcount.Text = dt.Rows[0]["ma_printnum"].ToString();
                            pr_detail.Text = dt.Rows[0]["pr_detail"].ToString();
                        }
                    }
                }
                if (ThreeColumn.Checked)
                {
                    format = engine.Documents.Open(Application.StartupPath + "/Label.btw");
                    for (int i = int.Parse(Rn.Text); i < (int.Parse(Num.Text) + int.Parse(Rn.Text)); i = i + 3)
                    {
                        int temp = i;
                        for (int j = 0; j < format.SubStrings.Count; j++)
                        {
                            switch (format.SubStrings[j].Name)
                            {
                                case "SN":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp).ToString()));
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN2":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 1).ToString()));
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN3":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 2).ToString()));
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                default:
                                    break;
                            }
                        }
                        format.PrintSetup.PrinterName = PrinterList.Text;
                        format.PrintSetup.IdenticalCopiesOfLabel = 1;
                        format.Print();

                        DataTable dt = (DataTable)dh.ExecuteSql("select ma_qty,ma_prodcode,pr_detail,ma_printnum from make left join product on ma_prodcode=pr_code left join (select count(1)ma_printnum,msl_makecode from makesnlist where msl_printstatus=-1 group by msl_makecode) on msl_makecode=ma_code where ma_code='" + ma_code.Text + "'", "select");
                        if (dt.Rows.Count > 0)
                        {
                            pr_code.Text = dt.Rows[0]["ma_prodcode"].ToString();
                            ma_qty.Text = dt.Rows[0]["ma_qty"].ToString();
                            ma_printcount.Text = dt.Rows[0]["ma_printnum"].ToString();
                            pr_detail.Text = dt.Rows[0]["pr_detail"].ToString();
                        }
                    }
                }
                if (FourColumn.Checked)
                {
                    format = engine.Documents.Open(Application.StartupPath + "/四排.btw");
                    for (int i = int.Parse(Rn.Text); i < (int.Parse(Num.Text) + int.Parse(Rn.Text)); i = i + 4)
                    {
                        int temp = i;
                        for (int j = 0; j < format.SubStrings.Count; j++)
                        {
                            switch (format.SubStrings[j].Name)
                            {
                                case "SN":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp).ToString()));
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN2":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 1).ToString()));
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN3":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 2).ToString()));
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN4":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 3).ToString()));
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                default:
                                    break;
                            }
                        }
                        format.PrintSetup.PrinterName = PrinterList.Text;
                        format.PrintSetup.IdenticalCopiesOfLabel = 1;
                        format.Print();

                        DataTable dt = (DataTable)dh.ExecuteSql("select ma_qty,ma_prodcode,pr_detail,ma_printnum from make left join product on ma_prodcode=pr_code left join (select count(1)ma_printnum,msl_makecode from makesnlist where msl_printstatus=-1 group by msl_makecode) on msl_makecode=ma_code where ma_code='" + ma_code.Text + "'", "select");
                        if (dt.Rows.Count > 0)
                        {
                            pr_code.Text = dt.Rows[0]["ma_prodcode"].ToString();
                            ma_qty.Text = dt.Rows[0]["ma_qty"].ToString();
                            ma_printcount.Text = dt.Rows[0]["ma_printnum"].ToString();
                            pr_detail.Text = dt.Rows[0]["pr_detail"].ToString();
                        }
                    }
                }
                if (FiveColumn2.Checked)
                {
                    format = engine.Documents.Open(Application.StartupPath + "/五排13_13.btw");
                    for (int i = int.Parse(Rn.Text); i < (int.Parse(Num.Text) + int.Parse(Rn.Text)); i = i + 5)
                    {
                        int temp = i;
                        for (int j = 0; j < format.SubStrings.Count; j++)
                        {
                            switch (format.SubStrings[j].Name)
                            {
                                case "SN":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp).ToString()));
                                    if (dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_printstatus='-1'"))
                                    {
                                        return;
                                    }
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN2":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 1).ToString()));
                                    if (dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_printstatus='-1'"))
                                    {
                                        return;
                                    }
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN3":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 2).ToString()));
                                    if (dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_printstatus='-1'"))
                                    {
                                        return;
                                    }
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN4":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 3).ToString()));
                                    if (dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_printstatus='-1'"))
                                    {
                                        return;
                                    }
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN5":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 4).ToString()));
                                    if (dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_printstatus='-1'"))
                                    {
                                        return;
                                    }
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                default:
                                    break;
                            }
                        }
                        format.PrintSetup.PrinterName = PrinterList.Text;
                        format.PrintSetup.IdenticalCopiesOfLabel = 1;
                        format.Print();

                        DataTable dt = (DataTable)dh.ExecuteSql("select ma_qty,ma_prodcode,pr_detail,ma_printnum from make left join product on ma_prodcode=pr_code left join (select count(1)ma_printnum,msl_makecode from makesnlist where msl_printstatus=-1 group by msl_makecode) on msl_makecode=ma_code where ma_code='" + ma_code.Text + "'", "select");
                        if (dt.Rows.Count > 0)
                        {
                            pr_code.Text = dt.Rows[0]["ma_prodcode"].ToString();
                            ma_qty.Text = dt.Rows[0]["ma_qty"].ToString();
                            ma_printcount.Text = dt.Rows[0]["ma_printnum"].ToString();
                            pr_detail.Text = dt.Rows[0]["pr_detail"].ToString();
                        }
                    }
                }
                if (FiveColumn1.Checked)
                {
                    format = engine.Documents.Open(Application.StartupPath + "/五排15_15.btw");
                    for (int i = int.Parse(Rn.Text); i < (int.Parse(Num.Text) + int.Parse(Rn.Text)); i = i + 5)
                    {
                        int temp = i;
                        for (int j = 0; j < format.SubStrings.Count; j++)
                        {
                            switch (format.SubStrings[j].Name)
                            {
                                case "SN":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp).ToString()));
                                    if (dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_printstatus='-1'"))
                                    {
                                        return;
                                    }
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN2":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 1).ToString()));
                                    if (dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_printstatus='-1'"))
                                    {
                                        return;
                                    }
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN3":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 2).ToString()));
                                    if (dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_printstatus='-1'"))
                                    {
                                        return;
                                    }
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN4":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 3).ToString()));
                                    if (dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_printstatus='-1'"))
                                    {
                                        return;
                                    }
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN5":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 4).ToString()));
                                    if (dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_printstatus='-1'"))
                                    {
                                        return;
                                    }
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                default:
                                    break;
                            }
                        }
                        format.PrintSetup.PrinterName = PrinterList.Text;
                        format.PrintSetup.IdenticalCopiesOfLabel = 1;
                        format.Print();

                        DataTable dt = (DataTable)dh.ExecuteSql("select ma_qty,ma_prodcode,pr_detail,ma_printnum from make left join product on ma_prodcode=pr_code left join (select count(1)ma_printnum,msl_makecode from makesnlist where msl_printstatus=-1 group by msl_makecode) on msl_makecode=ma_code where ma_code='" + ma_code.Text + "'", "select");
                        if (dt.Rows.Count > 0)
                        {
                            pr_code.Text = dt.Rows[0]["ma_prodcode"].ToString();
                            ma_qty.Text = dt.Rows[0]["ma_qty"].ToString();
                            ma_printcount.Text = dt.Rows[0]["ma_printnum"].ToString();
                            pr_detail.Text = dt.Rows[0]["pr_detail"].ToString();
                        }
                    }
                }
                if (FiveColumn.Checked)
                {
                    format = engine.Documents.Open(Application.StartupPath + "/五排15_10.btw");
                    for (int i = int.Parse(Rn.Text); i < (int.Parse(Num.Text) + int.Parse(Rn.Text)); i = i + 5)
                    {
                        int temp = i;
                        for (int j = 0; j < format.SubStrings.Count; j++)
                        {
                            switch (format.SubStrings[j].Name)
                            {
                                case "SN":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp).ToString()));
                                    if (dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_printstatus='-1'"))
                                    {
                                        return;
                                    }
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN2":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 1).ToString()));
                                    if (dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_printstatus='-1'"))
                                    {
                                        return;
                                    }
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN3":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 2).ToString()));
                                    if (dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_printstatus='-1'"))
                                    {
                                        return;
                                    }
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN4":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 3).ToString()));
                                    if (dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_printstatus='-1'"))
                                    {
                                        return;
                                    }
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN5":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 4).ToString()));
                                    if (dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_printstatus='-1'"))
                                    {
                                        return;
                                    }
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                default:
                                    break;
                            }
                        }
                        format.PrintSetup.PrinterName = PrinterList.Text;
                        format.PrintSetup.IdenticalCopiesOfLabel = 1;
                        format.Print();

                        DataTable dt = (DataTable)dh.ExecuteSql("select ma_qty,ma_prodcode,pr_detail,ma_printnum from make left join product on ma_prodcode=pr_code left join (select count(1)ma_printnum,msl_makecode from makesnlist where msl_printstatus=-1 group by msl_makecode) on msl_makecode=ma_code where ma_code='" + ma_code.Text + "'", "select");
                        if (dt.Rows.Count > 0)
                        {
                            pr_code.Text = dt.Rows[0]["ma_prodcode"].ToString();
                            ma_qty.Text = dt.Rows[0]["ma_qty"].ToString();
                            ma_printcount.Text = dt.Rows[0]["ma_printnum"].ToString();
                            pr_detail.Text = dt.Rows[0]["pr_detail"].ToString();
                        }
                    }
                }
                if (EightColumn.Checked)
                {
                    format = engine.Documents.Open(Application.StartupPath + "/八排.btw");
                    for (int i = int.Parse(Rn.Text); i < (int.Parse(Num.Text) + int.Parse(Rn.Text)); i = i + 8)
                    {
                        int temp = i;
                        for (int j = 0; j < format.SubStrings.Count; j++)
                        {
                            switch (format.SubStrings[j].Name)
                            {
                                case "SN":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp).ToString()));
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN2":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 1).ToString()));
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN3":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 2).ToString()));
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN4":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 3).ToString()));
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN5":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 4).ToString()));
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN6":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 5).ToString()));
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN7":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 6).ToString()));
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                case "SN8":
                                    format.SubStrings[j].Value = (ma_code.Text + Date.Value.ToString("yyMMdd") + lpad(int.Parse(numericUpDown1.Value.ToString()), (temp + 7).ToString()));
                                    if (!dh.CheckExist("makesnlist", "msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'"))
                                        dh.ExecuteSql("insert into makesnlist(msl_id,msl_indate,msl_makecode,msl_sncode,msl_type,msl_printstatus)values(makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "','" + format.SubStrings[j].Value + "','before',-1)", "insert");
                                    break;
                                default:
                                    break;
                            }
                        }
                        format.PrintSetup.PrinterName = PrinterList.Text;
                        format.PrintSetup.IdenticalCopiesOfLabel = 1;
                        format.Print();
                        DataTable dt = (DataTable)dh.ExecuteSql("select ma_qty,ma_prodcode,pr_detail,ma_printnum from make left join product on ma_prodcode=pr_code left join (select count(1)ma_printnum,msl_makecode from makesnlist where msl_printstatus=-1 group by msl_makecode) on msl_makecode=ma_code where ma_code='" + ma_code.Text + "'", "select");
                        if (dt.Rows.Count > 0)
                        {
                            pr_code.Text = dt.Rows[0]["ma_prodcode"].ToString();
                            ma_qty.Text = dt.Rows[0]["ma_qty"].ToString();
                            ma_printcount.Text = dt.Rows[0]["ma_printnum"].ToString();
                            pr_detail.Text = dt.Rows[0]["pr_detail"].ToString();
                        }
                    }
                }
            }
            else
            {
                DataTable dt1 = (DataTable)dh.ExecuteSql("select msl_sncode from makesnlist where msl_makecode='" + ma_code.Text + "' and nvl(MSL_PRINTSTATUS,0)=0", "select");
                if (OneColumn.Checked)
                {
                    format = engine.Documents.Open(Application.StartupPath + "/单排.btw");
                    for (int i = 0; i < dt1.Rows.Count; i = i + 1)
                    {
                        int temp = i;
                        for (int j = 0; j < format.SubStrings.Count; j++)
                        {
                            switch (format.SubStrings[j].Name)
                            {
                                case "SN":
                                    format.SubStrings[j].Value = dt1.Rows[i]["msl_sncode"].ToString();
                                    dh.ExecuteSql("update makesnlist set msl_printstatus=-1 where msl_sncode='" + format.SubStrings[j].Value + "' and msl_makecode='" + ma_code.Text + "'", "insert");
                                    break;
                                default:
                                    break;
                            }
                        }
                        format.PrintSetup.PrinterName = PrinterList.Text;
                        format.PrintSetup.IdenticalCopiesOfLabel = 1;
                        format.Print();

                        DataTable dt = (DataTable)dh.ExecuteSql("select ma_qty,ma_prodcode,pr_detail,ma_printnum from make left join product on ma_prodcode=pr_code left join (select count(1)ma_printnum,msl_makecode from makesnlist where msl_printstatus=-1 group by msl_makecode) on msl_makecode=ma_code where ma_code='" + ma_code.Text + "'", "select");
                        if (dt.Rows.Count > 0)
                        {
                            pr_code.Text = dt.Rows[0]["ma_prodcode"].ToString();
                            ma_qty.Text = dt.Rows[0]["ma_qty"].ToString();
                            ma_printcount.Text = dt.Rows[0]["ma_printnum"].ToString();
                            pr_detail.Text = dt.Rows[0]["pr_detail"].ToString();
                        }
                    }
                }
            }
        }

        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 SystemSetting_PrinterTest_Load(object sender, EventArgs e)
        {
            engine.Start();


            ma_code.TableName = " make left join product on ma_prodcode=pr_code";
            ma_code.SelectField = "ma_code # 工单编号,pr_code # 产品编号,pr_spec # 型号";
            ma_code.FormName = Name;
            ma_code.SetValueField = new string[] { "ma_code" };
            ma_code.Condition = "ma_statuscode='STARTED'";
            ma_code.DbChange += pr_code_DbChange;
        }

        private void pr_code_DbChange(object sender, EventArgs e)
        {
            Dbfind = ma_code.ReturnData;
            BaseUtil.SetFormValue(this.Controls, Dbfind);
            DataTable dt = (DataTable)dh.ExecuteSql("select ma_submodel,ma_color,ma_qty,ma_prodcode,pr_detail,ma_printnum from make left join product on ma_prodcode=pr_code left join (select count(1)ma_printnum,mil_makecode from makeimeilist where mil_printstatus=-1 group by mil_makecode) on mil_makecode=ma_code where ma_code='" + ma_code.Text + "'", "select");
            if (dt.Rows.Count > 0)
            {
                Color.Text = dt.Rows[0]["ma_color"].ToString();
                MachineType.Text = dt.Rows[0]["ma_submodel"].ToString();
                pr_code.Text = dt.Rows[0]["ma_prodcode"].ToString();
                ma_qty.Text = dt.Rows[0]["ma_qty"].ToString();
                ma_printcount.Text = dt.Rows[0]["ma_printnum"].ToString();
                pr_detail.Text = dt.Rows[0]["pr_detail"].ToString();
            }
        }

        private void OneColumn_CheckedChanged(object sender, EventArgs e)
        {

        }

        int custserialnum = 0;

        private void Gen_SN_Click(object sender, EventArgs e)
        {
            string Prefix = "";

            string Suffix = "";
            //获取编码规则
            if (!dh.CheckExist("make", "ma_code='" + ma_code.Text + "'"))
            {
                MessageBox.Show("工单号不存在");
                return;
            }
            DataTable dt = (DataTable)dh.ExecuteSql("select pr_exbarcode,ma_qty from make left join product on ma_prodcode=pr_code where ma_code='" + ma_code.Text + "'", "select");
            string pr_exbarcode = "";
            string ma_qty = "";
            if (dt.Rows.Count > 0)
            {
                pr_exbarcode = dt.Rows[0]["pr_exbarcode"].ToString();
                ma_qty = dt.Rows[0]["ma_qty"].ToString();
            }
            if (dh.getRowCount("makesnlist", "msl_makecode='" + ma_code.Text + "' and msl_type='转号前'") + int.Parse(Num.Text) > int.Parse(ma_qty))
            {
                MessageBox.Show("工单号" + ma_code.Text + "生产序列号超出工单数");
                return;
            }
            DataTable Nr = (DataTable)dh.ExecuteSql("select nrd_detno,nrd_name,nrd_type,nrd_radix,nrd_sql,nrd_length,nrd_content,nvl(nr_changenum,0)nr_changenum from NoRuleDetail left join norule on nrd_nrid=nr_id where nr_code='" + pr_exbarcode + "' order by nrd_detno", "select");
            //如果没有则取公共规则
            if (Nr.Rows.Count == 0)
                Nr = (DataTable)dh.ExecuteSql("select nrd_detno,nrd_name,nrd_radix,nrd_type,nrd_sql,nrd_length,nrd_content,nvl(nr_changenum,0)nr_changenum from NoRuleDetail left join norule on nrd_nrid=nr_id where nr_custcode is null and nr_isdefault <> 0 order by nrd_detno", "select");
            //用于过滤参数的正则表达式
            Regex match = new Regex("{\\w+}");
            //用于存放每一项的明细的数据
            string[] NrData = new string[Nr.Rows.Count];
            //流水号的索引
            int SerialNumIndex = 0;
            //流水长度
            int SerialNumLength = 0;
            //存放键值对
            int Radix = 10;
            string PrefixFixed = "";
            string char_out = "";
            string nr_changenum = Nr.Rows[0]["nr_changenum"].ToString();
            //如果是
            if (nr_changenum != "-1")
            {
                for (int m = 0; m < Nr.Rows.Count; m++)
                {
                    switch (Nr.Rows[m]["nrd_type"].ToString())
                    {
                        //常量直接进行拼接
                        case "常量":
                            NrData[m] = Nr.Rows[m]["nrd_sql"].ToString();
                            Prefix += NrData[m];
                            Suffix += NrData[m];
                            break;
                        case "SQL":
                            string SQL = Nr.Rows[m]["nrd_sql"].ToString();
                            DataTable Temp;
                            //如果不包含参数替换
                            if (SQL.IndexOf("{") == 0)
                            {
                                Temp = (DataTable)dh.ExecuteSql(SQL, "select");
                            }
                            else
                            {
                                //替换参数后重新执行SQL
                                foreach (Match mch in match.Matches(SQL))
                                {
                                    SQL = SQL.Replace(mch.Value.Trim(), "'" + ma_code.Text + "'");
                                }
                                Temp = (DataTable)dh.ExecuteSql(SQL, "select");
                            }
                            if (Temp.Rows.Count > 0)
                            {
                                NrData[m] = Temp.Rows[0][0].ToString();
                                Prefix += NrData[m];
                                Suffix += NrData[m];
                            }
                            else
                            {
                                NrData[m] = "";
                                Prefix += NrData[m];
                                Suffix += NrData[m];
                            }
                            break;
                        //流水需要通过MaxNumber去取
                        case "流水":
                            NrData[m] = dh.getFieldDataByCondition("RuleMaxNum", "rmn_maxnumber", "rmn_nrcode='" + pr_exbarcode + "'").ToString();
                            Suffix = "";
                            PrefixFixed = Prefix;
                            //设置当前流水
                            custserialnum = int.Parse(NrData[m] == "" ? "0" : NrData[m]);
                            SerialNumIndex = m;
                            SerialNumLength = int.Parse(Nr.Rows[m]["nrd_length"].ToString());
                            Radix = int.Parse(Nr.Rows[m]["nrd_radix"].ToString());
                            char_out = Nr.Rows[m]["nrd_content"].ToString();
                            break;
                        default:
                            break;
                    }
                }
                //获取最大的流水号
                string maxnum = dh.getFieldDataByCondition("RuleMaxNum", "rmn_maxnumber", "rmn_nrcode='" + pr_exbarcode + "' and rmn_prefix='" + Prefix + "'").ToString();
                //如果流水号为空则插入一条新记录,从1开始取
                if (maxnum == "")
                {
                    dh.ExecuteSql("insert into RuleMaxNum(rmn_id,rmn_nrcode,rmn_prefix,rmn_maxnumber) values(RuleMaxNum_seq.nextval,'" + pr_exbarcode + "','" + Prefix + "','1')", "insert");
                    custserialnum = 1;
                }
                //如果流水号不为空则取当前流水
                else
                {
                    custserialnum = int.Parse(maxnum);
                }
                //遍历整个Grid，勾选的项目全部进行条码生成
                ArrayList<string> custbarcode = new ArrayList<string>();
                for (int i = 0; i < int.Parse(Num.Text); i++)
                {
                    string data = BarcodeMethod1(PrefixFixed, Suffix, SerialNumIndex, SerialNumLength, Radix);
                    if (!custbarcode.Contains(data))
                        custbarcode.Add(data);
                }
                //插入条码
                string sql = "insert into makesnlist(MSL_ID, MSL_INDATE, MSL_MAKECODE, MSL_SNCODE,msl_status,MSL_TYPE)" +
                    "select makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "',:custbarcode,0,'before' from dual where :custbarcode not in " +
                  "(select msl_sncode from makesnlist)";
                dh.BatchInsert(sql, new string[] { "custbarcode", "custbarcode" }, custbarcode.ToArray(), custbarcode.ToArray());
                //更新最大流水号
                dh.UpdateByCondition("RuleMaxNum", "rmn_maxnumber='" + custserialnum + "'", "rmn_nrcode='" + pr_exbarcode + "' and rmn_prefix='" + Prefix + "'");
            }
            else
            {
                for (int m = 0; m < Nr.Rows.Count; m++)
                {
                    switch (Nr.Rows[m]["nrd_type"].ToString())
                    {
                        //常量直接进行拼接
                        case "常量":
                            NrData[m] = Nr.Rows[m]["nrd_sql"].ToString();
                            Prefix += NrData[m];
                            Suffix += NrData[m];
                            break;
                        case "SQL":
                            string SQL = Nr.Rows[m]["nrd_sql"].ToString();
                            DataTable Temp;
                            //如果不包含参数替换
                            if (SQL.IndexOf("{") == 0)
                            {
                                Temp = (DataTable)dh.ExecuteSql(SQL, "select");
                            }
                            else
                            {
                                //替换参数后重新执行SQL
                                foreach (Match mch in match.Matches(SQL))
                                {
                                    SQL = SQL.Replace(mch.Value.Trim(), "'" + ma_code.Text + "'");
                                }
                                Temp = (DataTable)dh.ExecuteSql(SQL, "select");
                            }
                            if (Temp.Rows.Count > 0)
                            {
                                NrData[m] = Temp.Rows[0][0].ToString();
                                Prefix += NrData[m];
                                Suffix += NrData[m];
                            }
                            else
                            {
                                NrData[m] = "";
                                Prefix += NrData[m];
                                Suffix += NrData[m];
                            }
                            break;
                        //流水需要通过MaxNumber去取
                        case "流水":
                            NrData[m] = dh.getFieldDataByCondition("RuleMaxNum", "rmn_maxnumber", "rmn_nrcode='" + pr_exbarcode + "'").ToString();
                            Suffix = "";
                            PrefixFixed = Prefix;
                            //设置当前流水
                            custserialnum = int.Parse(NrData[m] == "" ? "0" : NrData[m]);
                            SerialNumIndex = m;
                            SerialNumLength = int.Parse(Nr.Rows[m]["nrd_length"].ToString());
                            Radix = int.Parse(Nr.Rows[m]["nrd_radix"].ToString());
                            char_out = Nr.Rows[m]["nrd_content"].ToString();
                            break;
                        default:
                            break;
                    }
                }
                //获取最大的流水号
                string maxnum = dh.getFieldDataByCondition("RuleMaxNum", "rmn_maxnumber", "rmn_nrcode='" + pr_exbarcode + "'").ToString();
                //如果流水号为空则插入一条新记录,从1开始取
                if (maxnum == "")
                {
                    dh.ExecuteSql("insert into RuleMaxNum(rmn_id,rmn_nrcode,rmn_maxnumber) values(RuleMaxNum_seq.nextval,'" + pr_exbarcode + "','1')", "insert");
                    custserialnum = 1;
                }
                //如果流水号不为空则取当前流水
                else
                {
                    custserialnum = int.Parse(maxnum);
                }
                //遍历整个Grid，勾选的项目全部进行条码生成
                ArrayList<string> custbarcode = new ArrayList<string>();
                for (int i = 0; i < int.Parse(Num.Text); i++)
                {
                    string data = BarcodeMethod1(PrefixFixed, Suffix, SerialNumIndex, SerialNumLength, Radix);
                    if (!custbarcode.Contains(data))
                        custbarcode.Add(data);
                }
                string sql = "insert into makesnlist(MSL_ID, MSL_INDATE, MSL_MAKECODE, MSL_SNCODE, MSL_TYPE,msl_status)" +
              "select makesnlist_seq.nextval,sysdate,'" + ma_code.Text + "',:custbarcode,'before',0 from dual where :custbarcode not in " +
              "(select msl_sncode from makesnlist)";
                dh.BatchInsert(sql, new string[] { "custbarcode", "custbarcode" }, custbarcode.ToArray(), custbarcode.ToArray());
                //更新最大流水号
                dh.UpdateByCondition("RuleMaxNum", "rmn_maxnumber='" + custserialnum + "'", "rmn_nrcode='" + pr_exbarcode + "'");
            }
            //插入条码
            MessageBox.Show("工单" + ma_code.Text + "生成SN清单成功");
        }

        public string BarcodeMethod1(string Prefix, string Suffix, int Index, int Length, int radix)
        {
            string str = Prefix;
            //如果是流水则需要在前面加0
            string serialcode = BaseUtil.DToAny(custserialnum, radix);
            for (int j = serialcode.ToString().Length; j < Length; j++)
            {
                serialcode = "0" + serialcode;
            }
            str += serialcode;
            str += Suffix;
            custserialnum = custserialnum + 1;
            return str;
        }
    }
}