mes-client/UAS-出货标签管理(泽天)/UAS_出货标签管理.cs

using System;
using System.Data;
using System.Drawing;
using System.Windows.Forms;
using System.Text.RegularExpressions;
using System.Text;
using System.Collections.Generic;
using System.Linq;
using System.Diagnostics;
using LabelManager2;
using UAS_LabelMachine.PublicMethod;
using UAS_LabelMachine.Entity;
using UAS_特殊解析规则;
using UAS_LabelMachine.PublicForm;
using System.Threading;
using System.IO;
using System.Globalization;
using System.Threading.Tasks;

namespace UAS_LabelMachine
{
    public partial class UAS_出货标签打印 : Form
    {
        //自适应屏幕
        AutoSizeFormClass asc = new AutoSizeFormClass();

        DataHelper dh;

        DataTable dt;

        StringBuilder sql = new StringBuilder();
        /// <summary>
        /// CodeSoft新建打印机引擎
        /// </summary>
        ApplicationClass lbl;
        /// <summary>
        /// 单盘打印文件
        /// </summary>
        Document SingleDoc;
        /// <summary>
        /// 中盒打印文件
        /// </summary>
        Document MidDoc;
        /// <summary>
        /// 外箱打印文件
        /// </summary>
        Document OutBoxDoc;
        /// <summary>
        /// Loading窗口
        /// </summary>
        SetLoadingWindow stw;
        /// <summary>
        /// 弹窗线程
        /// </summary>
        Thread thread;
        /// <summary>
        /// 当前品牌
        /// </summary>
        string PI_ID;
        /// <summary>
        /// 当前扫描的所在行
        /// </summary>
        int CurrentRowIndex = 0;

        bool logout = false;

        DataTable SingleLabelParam;
        DataTable MidLabelParam;
        DataTable OutLabelParam;

        //主表数据源
        DataTable LabelInfDataTable;

        //缓存单盘数据数据的DataTable
        DataTable SingleBoxCacheData;
        /// <summary>
        /// 存放单盘的ID
        /// </summary>
        List<string> SingleID = new List<string>();
        /// <summary>
        /// 单盘的打印参数
        /// </summary>
        List<string> SingleBoxArgument = new List<string>();
        /// <summary>
        /// 中盒缓存数据
        /// </summary>
        DataTable MidBoxCacheData;
        /// <summary>
        /// 存放中盒的ID和盒号
        /// </summary>
        Dictionary<string, string> MidIDAndOutboxcode = new Dictionary<string, string>();
        /// <summary>
        /// 中盒的打印参数
        /// </summary>
        List<string> MidBoxArgument = new List<string>();
        /// <summary>
        /// 是否全选
        /// </summary>
        bool AllChecked = false;

        /// <summary>
        /// 是否通过选择Combox来改变打开的文件
        /// </summary>
        bool ComBoxClickChangeLabelDoc = false;

        List<string> SingleParam = new List<string>();

        List<string> MidParam = new List<string>();

        List<string> OutParam = new List<string>();
        //当前采集的物料编号
        string CurrentPrCode = "";
        //当前采集的最小包装
        string CurrentZXBZ = "";
        //当前采集的单位
        string CurrentUnit = "";
        //当前采集的总数
        string CurrentPrCount = "";
        //当前明细序号
        string CurrentPDNO = "";
        //当前的物料品牌
        string CurrentBrand = "";

        string SinglePrefix = "";
        string SingleSuffix = "";
        int SingleMaxNum = 0;
        int SingleNumLength = 0;
        int SingleRadix = 0;

        string OutPrefix = "";
        string OutSuffix = "";
        int OutMaxNum = 0;
        int OutNumLength = 0;
        int OutRadix = 0;

        public UAS_出货标签打印(string Master)
        {
            InitializeComponent();
            Text = Text + "-" + Master;
        }

        protected override void WndProc(ref Message m)
        {
            //拦截双击标题栏、移动窗体的系统消息
            if (m.Msg != 0xA3)
            {
                base.WndProc(ref m);
            }
        }

        private void 贴标机条码打印_Load(object sender, EventArgs e)
        {
            //杀死之前全部未关闭的进程
            Process[] processes = System.Diagnostics.Process.GetProcessesByName("lppa");
            for (int i = 0; i < processes.Length; i++)
            {
                processes[i].Kill();
            }
            //用计时器重置数据库链接
            LogManager.DoLog("程序启动,登陆人员【" + User.UserName + "】");
            dh = SystemInf.dh;
            CheckForIllegalCrossThreadCalls = false;
            pi_inoutno.Focus();
            //将本地读取的打印机设置进Combox，并选中默认打印机
            MidBoxCacheData = new DataTable();
            SingleBoxCacheData = new DataTable();

            Point pt = new Point();
            //禁止所有列的排序
            foreach (DataGridViewColumn dgv in LabelInf.Columns)
            {
                dgv.SortMode = DataGridViewColumnSortMode.NotSortable;
            }
            int ScreenWidth = Screen.GetWorkingArea(pt).Width;
            //设置获取当前屏幕大小自动全屏但是保留任务栏
            Rectangle ScreenArea = Screen.GetWorkingArea(this);
            Top = 0;
            Left = 0;
            Width = ScreenArea.Width;
            Height = ScreenArea.Height;
            OutboxCapacity.Value = Properties.Settings.Default.OutboxCapacity;

            asc.controllInitializeSize(this);
            asc.controlAutoSize(this);
            //实例化打印进程
            try
            {
                lbl = new ApplicationClass();
            }
            catch (Exception)
            {
                MessageBox.Show("未安装CodeSoft软件或者版本不正确", "提示");
            }
            RefreshDBConnect.Interval = 60000;
            RefreshDBConnect.Start();
        }

        //只执行一次窗体自适应
        bool AutoSized = false;
        private void 贴标机条码打印_SizeChanged(object sender, EventArgs e)
        {
            if (!AutoSized)
            {
                asc.controlAutoSize(this);
                AutoSized = true;
            }
        }

        private void LabelMaintain_Click(object sender, EventArgs e)
        {
            客户标签维护 form = new 客户标签维护();
            BaseUtil.SetFormCenter(form);
            if (SingleDoc != null)
                SingleDoc.Close();
            if (MidDoc != null)
                MidDoc.Close();
            if (OutBoxDoc != null)
                OutBoxDoc.Close();
            form.FormClosed += LabelFormClose;
            form.ShowDialog();
        }

        private void LabelFormClose(object sender, EventArgs e)
        {
            if (GetGridOnly.Checked)
                GetInOutInfAndLabelFile();
            else
            {
                GetGridOnly.Checked = true;
                GetInOutInfAndLabelFile();
                GetGridOnly.Checked = false;
            }
        }

        //输入框Enter事件
        private void Input_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                if (Input.Text == "")
                {
                    MessageBox.Show("采集的数据不能为空");
                    return;
                }
                CollectInputData();
                Input.Text = "";
            }
        }

        /// <summary>
        /// 采集数据
        /// </summary>
        private void CollectInputData()
        {
            Dictionary<string, string> Data = new Dictionary<string, string>();
            string[] SplitData = Input.Text.Split('*');
            if (SplitData.Length < 6)
            {
                MessageBox.Show("数据格式错误,无法解析", "提示");
                return;
            }
            for (int i = 0; i < SplitData.Length; i++)
            {
                switch (i.ToString())
                {
                    case "0":
                        Data.Add("PRCODE", SplitData[i]);
                        break;
                    case "1":
                        Data.Add("QTY", SplitData[i]);
                        break;
                    case "2":
                        Data.Add("DATECODE", SplitData[i]);
                        break;
                    case "3":
                        Data.Add("BRAND", SplitData[i]);
                        break;
                    case "4":
                        Data.Add("LOTNO", SplitData[i]);
                        break;
                    case "5":
                        Data.Add("PO", SplitData[i]);
                        break;
                    case "6":
                        Data.Add("SERIAL", SplitData[i]);
                        break;
                    default:
                        break;
                }
            }
            if (Data["PRCODE"] != CurrentPrCode)
            {
                MessageBox.Show("当前采集物料编号不对应，请重新采集", "提示");
                return;
            }
            if (Data["BRAND"] != CurrentBrand)
            {
                MessageBox.Show("当前采集品牌不对应，请重新采集", "提示");
                return;
            }
            int CodeCount = 0;
            //如果单位是KPCS则需要除1000
            int CollectNum = 0;
            if (CurrentUnit == "KPCS")
            {
                if (int.Parse(Data["QTY"]) / 1000 % int.Parse(CurrentZXBZ) != 0)
                {
                    MessageBox.Show("采集数量无法按照最小包装数拆分");
                    return;
                }
                CodeCount = int.Parse(Data["QTY"]) / 1000 / int.Parse(CurrentZXBZ);
                CollectNum = int.Parse(Data["QTY"]) / 1000;
            }
            else
            {
                if (int.Parse(Data["QTY"]) % int.Parse(CurrentZXBZ) != 0)
                {
                    MessageBox.Show("采集数量无法按照最小包装数拆分", "提示");
                    return;
                }
                CodeCount = int.Parse(Data["QTY"]) / int.Parse(CurrentZXBZ);
                CollectNum = int.Parse(Data["QTY"]);
            }
            string pib_barcode = Data.ContainsKey("SERIAL") ? Data["SERIAL"] : "";
            //获取ID
            string[] PIBID = dh.GetSEQ("prodiobarcode_seq", CodeCount);
            string pib_outboxcode2 = "";
            if (OutBoxNum.Text == "新增")
            {
                string maxoutbox = dh.getFieldDataByCondition("prodiobarcode", "max(pib_outboxcode2)", "pib_inoutno='" + pi_inoutno.Text + "'").ToString();
                //如果没有则从开始插入
                if (maxoutbox == "")
                {
                    pib_outboxcode2 = "1";
                }
                else
                {
                    pib_outboxcode2 = (int.Parse(maxoutbox) + 1).ToString();
                }
            }
            else
            {
                pib_outboxcode2 = OutBoxNum.Text;
            }
            //计算当前采集数量
            string collectqty = (LabelInfDataTable.Compute("sum(pib_qty)", "pib_prodcode='" + CurrentPrCode + "' and pib_pdno='" + CurrentPDNO + "'").ToString());
            int CollectQty = (collectqty == "" ? 0 : int.Parse(collectqty));
            if (CollectQty + CollectNum > int.Parse(CurrentPrCount))
            {
                MessageBox.Show("采集后超出数量", "提示");
                return;
            }
            List<string> CustBarCode = new List<string>();
            List<string> CustOutBarCode = new List<string>();
            for (int i = 0; i < CodeCount; i++)
            {
                string serialcode = BaseUtil.DToAny(SingleMaxNum, SingleRadix);
                for (int j = serialcode.ToString().Length; j < SingleNumLength; j++)
                {
                    serialcode = "0" + serialcode;
                }
                CustBarCode.Add(SinglePrefix + serialcode + SingleSuffix);
                if (OutPrefix != "")
                {
                    serialcode = BaseUtil.DToAny(OutMaxNum, OutRadix);
                    for (int j = serialcode.ToString().Length; j < OutNumLength; j++)
                    {
                        serialcode = "0" + serialcode;
                    }
                    CustOutBarCode.Add(OutPrefix + serialcode + OutSuffix);
                    SingleMaxNum = SingleMaxNum + 1;
                    OutMaxNum = OutMaxNum + 1;
                }
                else
                {
                    CustOutBarCode.Add("");
                }
            }
            sql.Clear();
            sql.Append("insert into prodiobarcode(PIB_ID,PIB_PRODCODE,PIB_INDATE,PIB_INOUTNO,PIB_PIID,PIB_PDNO, PIB_PDID,PIB_PICLASS,");
            sql.Append("PIB_BARCODE,PIB_CUSTBARCODE,PIB_QTY,PIB_OUTBOXCODE1,pib_datecode,pib_lotno,PIB_OUTBOXCODE2,pib_custoutboxcode,PIB_IFPRINT,PIB_ORDERCODE,PIB_CUSTPO) ");
            sql.Append("select :PIB_ID,pd_prodcode,sysdate,pi_inoutno,pi_id,pd_pdno,pd_id,pi_class,");
            sql.Append("'" + pib_barcode + "',:PIB_CUSTBARCODE,'" + CurrentZXBZ + "','','" + Data["LOTNO"] + "','" + Data["DATECODE"] + "','" + pib_outboxcode2 + "',:pib_custoutboxcode,0,pd_ordercode,pd_pocode ");
            sql.Append("from prodinout left join prodiodetail on pi_id=pd_piid where pi_id='" + PI_ID + "' and pd_prodcode='" + CurrentPrCode + "'");
            dh.BatchInsert(sql.ToString(), new string[] { "PIB_ID", "PIB_CUSTBARCODE", "pib_custoutboxcode" }, PIBID, CustBarCode.ToArray(), CustOutBarCode.ToArray());
            //更新流水号
            dh.UpdateByCondition("RULEMAXNUM", "rmn_maxnumber='" + (SingleMaxNum + CodeCount) + "'", "rmn_nrcode='" + pi_cardcode.Text + "' and rmn_type='Single' and rmn_prefix='" + SinglePrefix + "'");
            dh.UpdateByCondition("RULEMAXNUM", "rmn_maxnumber='" + (OutMaxNum + CodeCount) + "'", "rmn_nrcode='" + pi_cardcode.Text + "' and rmn_type='Out' and rmn_prefix='" + OutPrefix + "'");
            LoadGridData(new object(), new EventArgs());
            //加载完数据之后进行容量的判断
            if (LabelInfDataTable.Select("pib_outboxcode2='" + OutBoxNum.Text + "'").Length > OutboxCapacity.Value)
            {
                MessageBox.Show("箱号" + OutBoxNum.Text + "超出容量", "提示");
            }
            if (SingleLabelAutoPrint.Checked)
            {

            }
            //采集后重新计数，自动跳到下一行
            collectqty = (LabelInfDataTable.Compute("sum(pib_qty)", "pib_prodcode='" + CurrentPrCode + "' and pib_pdno='" + CurrentPDNO + "'").ToString());
            CollectQty = (collectqty == "" ? 0 : int.Parse(collectqty));
            if (CollectQty == int.Parse(CurrentPrCount))
            {
                DataGridViewSelectedRowCollection dsc = GridPrcode.SelectedRows;
                if (dsc[0].Index + 1 < GridPrcode.Rows.Count)
                {
                    GridPrcode.Rows[dsc[0].Index + 1].Selected = true;
                    for (int i = 0; i < dsc.Count; i++)
                    {
                        dsc[i].Selected = false;
                    }
                }
            }
        }

        private void AutoPrintSingleLabel(string la_id, string LabelUrl)
        {
            //用标签本身的变量作为最外层的循环条件去匹配;
            string[] arg = SingleBoxArgument.ToArray();
            StringBuilder ParamLog = new StringBuilder();
            for (int j = 0; j < SingleDoc.Variables.FreeVariables.Count; j++)
            {
                //将维护的模板参数和模板本身的参数名称进行比对
                for (int k = 0; k < SingleLabelParam.Rows.Count; k++)
                {
                    //名称相等的时候，取SQL进行值的查询
                    if (SingleDoc.Variables.FreeVariables.Item(j + 1).Name == SingleLabelParam.Rows[k]["lp_name"].ToString().ToLower())
                    {
                        string pib_id = LabelInf.Rows[CurrentRowIndex].Cells["pib_id1"].Value.ToString();
                        DataRow[] dr = SingleBoxCacheData.Select("pib_id=" + pib_id);
                        if (arg.Contains(SingleDoc.Variables.FreeVariables.Item(j + 1).Name))
                            SingleDoc.Variables.FreeVariables.Item(j + 1).Value = dr[0][SingleDoc.Variables.FreeVariables.Item(j + 1).Name].ToString();
                        if (SingleDoc.Variables.FreeVariables.Item(j + 1).Value == "")
                        {
                            DataRow[] drow = SingleLabelParam.Select("lp_name='" + SingleDoc.Variables.FreeVariables.Item(j + 1).Name + "'");
                            if (drow.Length > 0)
                                SingleDoc.Variables.FreeVariables.Item(j + 1).Value = drow[0]["lp_sql"].ToString();
                        }
                        ParamLog.AppendLine("pib_id:" + LabelInf.Rows[CurrentRowIndex].Cells["pib_id1"].Value.ToString() + ",SingleDoc打印参数【" + SingleDoc.Variables.FreeVariables.Item(j + 1).Name + "】赋值，" + "取到值" + SingleDoc.Variables.FreeVariables.Item(j + 1).Value);
                    }
                }
            }
            LogManager.DoLog(ParamLog.ToString());
            //保存参数打印
            if (EnablePrint)
            {
                SingleDoc.Printer.SwitchTo(SingleLabelPrinter.Text);
                SingleDoc.PrintDocument();
            }
        }

        //关闭窗口前提示用户确认
        private void 贴标机条码打印_FormClosing(object sender, FormClosingEventArgs e)
        {
            //如果不是注销的话
            if (!logout)
            {
                string close = MessageBox.Show(this.ParentForm, "是否关闭", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
                if (close.ToString() != "Yes")
                    e.Cancel = true;
                else
                {
                    lbl.Quit();
                    LogManager.DoLog("关闭程序");
                }
            }
        }

        /// <summary>
        /// 获取打印标签
        /// </summary>
        private void GetInOutInfAndLabelFile()
        {
            ComBoxClickChangeLabelDoc = false;
            DataTable Attach = (DataTable)dh.ExecuteSql("select lap_param lp_name,lap_value lp_sql  from LabelAttachPARAMETER where lap_custcode='" + pi_cardcode.Text + "'", "select");
            sql.Clear();
            sql.Append("select to_char(nvl(cl_date,sysdate),'YYYY-MM-DD HH24:Mi:SS') cl_date,cl_labelname,cl_isdefault,la_id||'#'||cl_labelurl||'#'||to_char(cl_date,'YYYY-MM-DD HH24:Mi:SS')  la_id,cl_custcode from customerlabel left join prodinout on pi_cardcode=cl_custcode ");
            sql.Append("left join customer on cu_code=cl_custcode left join label on la_code=CL_LABELCODE where ((pi_cardcode='" + pi_cardcode.Text + "' ");
            sql.Append("and  pi_inoutno='" + pi_inoutno.Text + "') or( cl_custcode is null)) and cl_labeltype='单盘' order by cl_custcode");
            dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
            SingleLabelCombox.DisplayMember = "cl_labelname";
            SingleLabelCombox.ValueMember = "la_id";
            SingleLabelCombox.DataSource = dt;
            if (SingleDoc != null)
                SingleDoc.Close();
            if (!GetGridOnly.Checked)
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    string LabelUrl = dt.Rows[i]["la_id"].ToString().Split('#')[1];
                    string LabelName = dt.Rows[i]["cl_labelname"].ToString();
                    System.DateTime time = Convert.ToDateTime(dt.Rows[i]["cl_date"].ToString());
                    FileInfo file = new FileInfo(ftpOperater.DownLoadTo + LabelName);
                    if (time.ToString() != file.LastWriteTime.ToString())
                        BaseUtil.GetLabelUrl(LabelUrl, LabelName, time);
                }
            if (SingleLabelCombox.Text != "")
            {
                SingleDoc = lbl.Documents.Open(ftpOperater.DownLoadTo + SingleLabelCombox.Text);
                SingleLabelParam = (DataTable)dh.ExecuteSql("select lp_name,lp_sql from label left join LABELPARAMETER on la_id= lp_laid where la_id=" + SingleLabelCombox.SelectedValue.ToString().Split('#')[0], "select");
                SingleLabelParam.Merge(Attach);
                for (int i = 0; i < SingleDoc.Variables.FreeVariables.Count; i++)
                {
                    SingleParam.Add(SingleDoc.Variables.FreeVariables.Item(i + 1).Name);
                }
            }
            sql.Clear();
            sql.Append("select to_char(nvl(cl_date,sysdate),'YYYY-MM-DD HH24:Mi:SS') cl_date,cl_labelname,cl_isdefault,la_id||'#'||cl_labelurl||'#'||to_char(cl_date,'YYYY-MM-DD HH24:Mi:SS')  la_id,cl_custcode from customerlabel left join prodinout on pi_cardcode=cl_custcode ");
            sql.Append("left join customer on cu_code=cl_custcode left join label on la_code=CL_LABELCODE where ((pi_cardcode='" + pi_cardcode.Text + "' ");
            sql.Append("and  pi_inoutno='" + pi_inoutno.Text + "') or( cl_custcode is null)) and cl_labeltype='中盒' order by cl_custcode");
            dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
            MidLabelCombox.DisplayMember = "cl_labelname";
            MidLabelCombox.ValueMember = "la_id";
            MidLabelCombox.DataSource = dt;
            if (MidDoc != null)
                MidDoc.Close();
            if (!GetGridOnly.Checked)
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    string LabelUrl = dt.Rows[i]["la_id"].ToString().Split('#')[1];
                    string LabelName = dt.Rows[i]["cl_labelname"].ToString();
                    System.DateTime time = Convert.ToDateTime(dt.Rows[i]["cl_date"].ToString());
                    FileInfo file = new FileInfo(ftpOperater.DownLoadTo + LabelName);
                    if (time.ToString() != file.LastWriteTime.ToString())
                        BaseUtil.GetLabelUrl(LabelUrl, LabelName, time);
                }
            if (MidLabelCombox.Text != "")
            {
                MidDoc = lbl.Documents.Open(ftpOperater.DownLoadTo + MidLabelCombox.Text);
                MidLabelParam = (DataTable)dh.ExecuteSql("select lp_name,lp_sql from label left join LABELPARAMETER on la_id= lp_laid where la_id=" + MidLabelCombox.SelectedValue.ToString().Split('#')[0], "select");
                MidLabelParam.Merge(Attach);
            }
            //缓存中盒参数
            sql.Clear();
            sql.Append("select to_char(nvl(cl_date,sysdate),'YYYY-MM-DD HH24:Mi:SS') cl_date,cl_labelname,cl_isdefault,la_id||'#'||cl_labelurl||'#'||to_char(cl_date,'YYYY-MM-DD HH24:Mi:SS')  la_id,cl_custcode from customerlabel left join prodinout on pi_cardcode=cl_custcode ");
            sql.Append("left join customer on cu_code=cl_custcode left join label on la_code=CL_LABELCODE where ((pi_cardcode='" + pi_cardcode.Text + "' ");
            sql.Append("and  pi_inoutno='" + pi_inoutno.Text + "') or( cl_custcode is null)) and cl_labeltype='外箱' order by cl_custcode");
            dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
            OutBoxCombox.DisplayMember = "cl_labelname";
            OutBoxCombox.ValueMember = "la_id";
            OutBoxCombox.DataSource = dt;
            if (OutBoxDoc != null)
                OutBoxDoc.Close();
            if (!GetGridOnly.Checked)
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    string LabelUrl = dt.Rows[i]["la_id"].ToString().Split('#')[1];
                    string LabelName = dt.Rows[i]["cl_labelname"].ToString();
                    System.DateTime time = Convert.ToDateTime(dt.Rows[i]["cl_date"].ToString());
                    FileInfo file = new FileInfo(ftpOperater.DownLoadTo + LabelName);
                    if (time.ToString() != file.LastWriteTime.ToString())
                        BaseUtil.GetLabelUrl(LabelUrl, LabelName, time);
                }
            if (OutBoxCombox.Text != "")
            {
                OutBoxDoc = lbl.Documents.Open(ftpOperater.DownLoadTo + OutBoxCombox.Text);
                OutLabelParam = (DataTable)dh.ExecuteSql("select lp_name,lp_sql from label left join LABELPARAMETER on la_id= lp_laid where la_id=" + OutBoxCombox.SelectedValue.ToString().Split('#')[0], "select");
                OutLabelParam.Merge(Attach);
            }
            Input.Focus();
            //缓存外箱参数
            ComBoxClickChangeLabelDoc = true;
            Parallel.Invoke(GetSingleBoxData, GetMidBoxData);
        }

        /// <summary>
        /// 出入库单录入框的回车事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void pi_inoutno_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                sql.Clear();
                sql.Append("select pi_id,pi_cardcode,to_char(pi_date,'yyyymmdd')pi_date from prodinout where pi_inoutno='" + pi_inoutno.Text + "'");
                dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
                if (dt.Rows.Count > 0)
                {
                    pi_cardcode.Text = dt.Rows[0]["pi_cardcode"].ToString();
                    pi_date.Text = dt.Rows[0]["pi_date"].ToString();
                    PI_ID = dt.Rows[0]["pi_id"].ToString();
                    LoadPrcodeData();
                    LoadGridData(sender, e);
                    //获取条码规则
                    GetBarCodeRule("Single", out SinglePrefix, out SingleSuffix, out SingleMaxNum, out SingleNumLength, out SingleRadix);
                    GetBarCodeRule("Out", out OutPrefix, out OutSuffix, out OutMaxNum, out OutNumLength, out OutRadix);
                    //重新输入单号后清除缓存
                    MidBoxArgument.Clear();
                    MidBoxCacheData.Clear();
                    BaseUtil.CleanDataTable(MidBoxCacheData);
                    SingleBoxArgument.Clear();
                    SingleBoxCacheData.Clear();
                    BaseUtil.CleanDataTable(SingleBoxCacheData);
                    MidIDAndOutboxcode.Clear();
                    SingleID.Clear();
                    Input.Focus();
                    //获取外箱数据
                    OutBoxNum_Click(sender, new EventArgs());
                    thread = new Thread(GetInOutInfAndLabelFile);
                    stw = new SetLoadingWindow(thread, "正在获取打印标签");
                    BaseUtil.SetFormCenter(stw);
                    stw.ShowDialog();
                    LogManager.DoLog("输入单号【" + pi_inoutno.Text + "】");
                }
                else
                    MessageBox.Show("当前出入库单号不存在！", "提示");
            }
        }

        private void SingleBoxPrint()
        {
            try
            {
                if (SingleDoc.Variables.FreeVariables.Count == 0) { }
            }
            catch (Exception)
            {
                MessageBox.Show("单盘标签未维护参数", "提示");
            }
            if (MidLabelAutoPrint.Checked)
            {
                try
                {
                    if (MidDoc.Variables.FreeVariables.Count == 0) { }
                }
                catch (Exception)
                {
                    MessageBox.Show("中盘标签未维护参数", "提示");
                }
            }
            string la_id = SingleLabelCombox.SelectedValue.ToString().Split('#')[0];
            string cl_labelname = SingleLabelCombox.Text;
            string LabelUrl = dh.getFieldDataByCondition("label left join customerlabel on la_code=cl_labelcode", "cl_labelurl", "la_id='" + la_id + "' and cl_labelname='" + cl_labelname + "'").ToString();
            //查询该模板维护的所有参数
            dt = (DataTable)dh.ExecuteSql("select lp_name,lp_sql from label left join LABELPARAMETER on la_id= lp_laid where la_id=" + la_id, "select");
            if (SingleLabelParam.Rows.Count > 0 && LabelInf.Rows.Count > 0)
            {
                //每次打印清除之前缓存的行号和ID，后面会判断需要打印的数据重新加载
                MidIDAndOutboxcode.Clear();
                SingleID.Clear();
                //获取全部的中盒号
                Dictionary<string, bool> outboxcode1 = new Dictionary<string, bool>();
                //判断所有盒号为该盒的是否勾选已采集
                outboxcode1.Add(LabelInf.Rows[0].Cells["pib_outboxcode1"].Value.ToString(), true);
                for (int i = 0; i < LabelInf.Rows.Count; i++)
                {
                    if (!SingleID.Contains(LabelInf.Rows[i].Cells["pib_id1"].Value.ToString()))
                        SingleID.Add(LabelInf.Rows[i].Cells["pib_id1"].Value.ToString());
                    if (LabelInf.Rows[i].Cells["Choose"].FormattedValue.ToString() == "True" && LabelInf.Rows[i].Cells["pib_ifprint"].FormattedValue.ToString() != "True")
                    {
                        //如果不存在中盒号则进行添加
                        if (!MidIDAndOutboxcode.ContainsValue(LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString()))
                        {
                            MidIDAndOutboxcode.Add(LabelInf.Rows[i].Cells["pib_id1"].Value.ToString(), LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString());
                        }
                    }
                }
                if (SingleID.ToArray().Length == 0)
                {
                    MessageBox.Show("选择的行未勾选采集或者已打印", "提示");
                    return;
                }
                //打印的时候如果不存在数据开始缓存
                if (SingleBoxCacheData.Rows.Count == 0)
                    GetSingleBoxData();
                if (MidBoxCacheData.Rows.Count == 0)
                    GetMidBoxData();
                for (int i = 0; i < LabelInf.RowCount; i++)
                {
                    if (i + 1 < LabelInf.RowCount)
                    {
                        //如果本行的中盒号和下一行不相等的话
                        if (LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString() != LabelInf.Rows[i + 1].Cells["pib_outboxcode1"].Value.ToString())
                        {
                            if (!outboxcode1.ContainsKey(LabelInf.Rows[i + 1].Cells["pib_outboxcode1"].Value.ToString()))
                                outboxcode1.Add(LabelInf.Rows[i + 1].Cells["pib_outboxcode1"].Value.ToString(), true);
                        }
                    }
                }
                //用于判断用户是否勾选了行
                int CheckedRowCount = 0;
                string[] arg = SingleBoxArgument.ToArray();
                for (int i = 0; i < LabelInf.RowCount; i++)
                {
                    //勾选了并且未打印
                    if (LabelInf.Rows[i].Cells["Choose"].FormattedValue.ToString() == "True" && LabelInf.Rows[i].Cells["pib_ifprint"].FormattedValue.ToString() != "True")
                    {
                        CheckedRowCount = CheckedRowCount + 1;
                        CurrentRowIndex = i;
                        //以标签模板的参数为基准，循环取数
                        //try
                        //{
                        string pib_id = LabelInf.Rows[i].Cells["pib_id1"].Value.ToString();
                        DataRow[] dr = SingleBoxCacheData.Select("pib_id=" + pib_id);
                        StringBuilder ParamLog = new StringBuilder();
                        for (int j = 0; j < SingleDoc.Variables.FreeVariables.Count; j++)
                        {
                            if (arg.Contains(SingleDoc.Variables.FreeVariables.Item(j + 1).Name))
                                SingleDoc.Variables.FreeVariables.Item(j + 1).Value = dr[0][SingleDoc.Variables.FreeVariables.Item(j + 1).Name].ToString();
                            if (SingleDoc.Variables.FreeVariables.Item(j + 1).Value == "")
                            {
                                DataRow[] drow = SingleLabelParam.Select("lp_name='" + SingleDoc.Variables.FreeVariables.Item(j + 1).Name + "'");
                                if (drow.Length > 0)
                                    SingleDoc.Variables.FreeVariables.Item(j + 1).Value = drow[0]["lp_sql"].ToString();
                            }
                            ParamLog.AppendLine("pib_id:" + LabelInf.Rows[i].Cells["pib_id1"].Value.ToString() + ",SingleDoc打印参数【" + SingleDoc.Variables.FreeVariables.Item(j + 1).Name + "】赋值，" + "取到值" + SingleDoc.Variables.FreeVariables.Item(j + 1).Value);
                        }
                        LogManager.DoLog(ParamLog.ToString());
                        //保存参数打印
                        if (EnablePrint)
                        {
                            SingleDoc.Printer.SwitchTo(SingleLabelPrinter.Text);
                            SingleDoc.PrintDocument();
                        }
                        if (MidLabelAutoPrint.Checked)
                        {
                            //判断当前行的盒号和下一行不相等或者已经是最后一行了
                            if (i + 1 == LabelInf.RowCount || LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString() != LabelInf.Rows[i + 1 == LabelInf.RowCount ? i : i + 1].Cells["pib_outboxcode1"].Value.ToString())
                            {
                                if (outboxcode1[LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString()])
                                {
                                    if (MidLabelCombox.SelectedValue != null)
                                    {
                                        string la_id_mid = MidLabelCombox.SelectedValue.ToString().Split('#')[0];
                                        MidBoxCodePrint(la_id_mid, CurrentRowIndex);
                                    }
                                }
                            }
                        }
                        //勾选为已打印
                        LabelInf.Rows[i].Cells["pib_ifprint"].Value = true;
                        //}
                        //catch (Exception ex) { LogManager.DoLog(ex.StackTrace); }
                    }
                }
                dh.BatchInsert("update prodiobarcode set pib_printdate=sysdate where pib_id=:pib_id", new string[] { "pib_id" }, SingleID.ToArray());
                MidBoxCacheData.Clear();
                BaseUtil.CleanDataTable(MidBoxCacheData);
                if (CheckedRowCount == 0)
                    MessageBox.Show("未勾选打印明细!", "提示");
                else if (CurrentRowIndex + 1 < LabelInf.Rows.Count)
                    CurrentRowIndex = CurrentRowIndex + 1;
                outboxcode1.Clear();
            }
            else
            {
                MessageBox.Show("此模板尚未维护参数或不存在打印明细", "提示");
                return;
            }
        }

        /// <summary>
        /// 缓存单盘的数据
        /// </summary>
        private void GetSingleBoxData()
        {
            if (SingleDoc == null)
                return;
            for (int i = 0; i < LabelInf.Rows.Count; i++)
            {
                if (!SingleID.Contains(LabelInf.Rows[i].Cells["pib_id1"].Value.ToString()))
                    SingleID.Add(LabelInf.Rows[i].Cells["pib_id1"].Value.ToString());
                //如果不存在中盒号则进行添加
                if (!MidIDAndOutboxcode.ContainsValue(LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString()))
                    MidIDAndOutboxcode.Add(LabelInf.Rows[i].Cells["pib_id1"].Value.ToString(), LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString());
            }
            //id数组
            string[] pib_id_arr = SingleID.ToArray();
            //将所有的列存在在这里
            List<DataTable> AllSingleBoxCacheData = new List<DataTable>();
            //每五百条拼接一次条件
            //手动添加ID列
            DataColumn datacolumn = new DataColumn("pib_id");
            if (!SingleBoxCacheData.Columns.Contains("pib_id"))
                SingleBoxCacheData.Columns.Add(datacolumn);
            //获取打印的SQL
            for (int j = 0; j < SingleDoc.Variables.FreeVariables.Count; j++)
            {
                //将维护的模板参数和模板本身的参数名称进行比对
                for (int k = 0; k < SingleLabelParam.Rows.Count; k++)
                {
                    if (SingleDoc.Variables.FreeVariables.Item(j + 1).Name == SingleLabelParam.Rows[k]["lp_name"].ToString())
                    {
                        DataColumn dc = new DataColumn(SingleDoc.Variables.FreeVariables.Item(j + 1).Name);
                        SingleBoxCacheData.Columns.Add(dc);
                        SingleBoxArgument.Add(SingleDoc.Variables.FreeVariables.Item(j + 1).Name);
                        string sql = SingleLabelParam.Rows[k]["lp_sql"].ToString();
                        sql = sql.Substring(0, sql.IndexOf("{"));
                        sql = sql.Substring(0, sql.LastIndexOf("="));
                        DataTable temp = dh.getFieldsDatasByCondition(sql.Replace(" from ", " ,pib_id PIBID from ") + " in (select pib_id from PRODIOBARCODE where pib_inoutno='" + pi_inoutno.Text + "') ORDER by pib_id");
                        temp.Columns[0].ColumnName = SingleDoc.Variables.FreeVariables.Item(j + 1).Name;
                        AllSingleBoxCacheData.Add(temp);
                    }
                }
            }
            DataTable[] Temp = AllSingleBoxCacheData.ToArray();
            //将所有数据写入到CacheData中
            if (Temp.Length > 0)
                for (int i = 0; i < Temp[0].Rows.Count; i++)
                {
                    DataRow dr = SingleBoxCacheData.NewRow();
                    dr["pib_id"] = pib_id_arr[i];
                    //由于之前加了一个ID列，导致j从1开始
                    for (int j = 1; j < SingleBoxCacheData.Columns.Count; j++)
                    {
                        dr[Temp[j - 1].Columns[0].ColumnName] = (Temp[j - 1].Select("PIBID=" + pib_id_arr[i]))[0][0];
                    }
                    SingleBoxCacheData.Rows.Add(dr);
                }
        }

        /// <summary>
        /// 缓存中盒的数据
        /// </summary>
        private void GetMidBoxData()
        {
            if (MidDoc == null)
                return;
            StringBuilder pib_condition_string = new StringBuilder();
            StringBuilder pib_qtycondition_string = new StringBuilder();
            for (int i = 0; i < LabelInf.Rows.Count; i++)
            {
                //如果不存在中盒号则进行添加
                if (!MidIDAndOutboxcode.ContainsValue(LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString()))
                {
                    MidIDAndOutboxcode.Add(LabelInf.Rows[i].Cells["pib_id1"].Value.ToString(), LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString());
                }
            }
            //id数组
            string[] pib_id_arr = MidIDAndOutboxcode.Keys.ToArray();
            string[] pib_outbox_arr = MidIDAndOutboxcode.Values.ToArray();
            if (pib_id_arr.Length == 0)
            {
                MessageBox.Show("未勾选打印明细", "提示");
                return;
            }
            //记录一个ID用来取中盒的数量
            string pib_id = pib_id_arr[0];
            //id个数
            //将所有的列存在在这里
            List<DataTable> AllMidBoxCacheData = new List<DataTable>();
            //每五百条拼接一次条件
            //手动添加ID列
            DataColumn IDColumn = new DataColumn("pib_id");
            DataColumn OutBoxColumn = new DataColumn("pib_outboxcode1");
            if (!MidBoxCacheData.Columns.Contains("pib_id"))
                MidBoxCacheData.Columns.Add(IDColumn);
            if (!MidBoxCacheData.Columns.Contains("pib_outboxcode1"))
                MidBoxCacheData.Columns.Add(OutBoxColumn);
            if (MidLabelCombox.SelectedValue == null)
            {
                return;
            }
            string la_id = MidLabelCombox.SelectedValue.ToString().Split('#')[0];
            for (int j = 0; j < MidDoc.Variables.FreeVariables.Count; j++)
            {
                //将维护的模板参数和模板本身的参数名称进行比对
                for (int k = 0; k < MidLabelParam.Rows.Count; k++)
                {
                    if (MidDoc.Variables.FreeVariables.Item(j + 1).Name == MidLabelParam.Rows[k]["lp_name"].ToString())
                    {
                        DataColumn dc = new DataColumn(MidDoc.Variables.FreeVariables.Item(j + 1).Name);
                        MidBoxCacheData.Columns.Add(dc);
                        MidBoxArgument.Add(MidDoc.Variables.FreeVariables.Item(j + 1).Name);
                        string sql = MidLabelParam.Rows[k]["lp_sql"].ToString();
                        //如果打印的含有数量
                        if (sql.ToLower().Contains("pib_qty"))
                        {
                            sql = sql.Substring(0, sql.IndexOf("{")) + pib_id + sql.Substring(sql.IndexOf("}") + 1);
                            sql = sql.Substring(0, sql.LastIndexOf("=")) + " in (select distinct pib_outboxcode1 from PRODIOBARCODE where pib_inoutno='" + pi_inoutno.Text + "')" + sql.Substring(sql.LastIndexOf("}") + 1);
                        }
                        else
                        {
                            sql = sql.Substring(0, sql.IndexOf("{"));
                            sql = sql.Substring(0, sql.LastIndexOf("="));
                            sql = sql + " in (select distinct pib_outboxcode1 from PRODIOBARCODE where pib_inoutno='" + pi_inoutno.Text + "')" + " and pib_inoutno='" + pi_inoutno.Text + "' order by to_number(pib_outboxcode1)";
                        }
                        DataTable temp = dh.getFieldsDatasByCondition(sql);
                        temp.Columns[0].ColumnName = MidDoc.Variables.FreeVariables.Item(j + 1).Name;
                        AllMidBoxCacheData.Add(temp);
                    }
                }
            }
            DataTable[] Temp = AllMidBoxCacheData.ToArray();
            //将所有数据写入到CacheData中
            if (Temp.Length > 0)
            {
                for (int i = 0; i < pib_id_arr.Length; i++)
                {
                    DataRow dr = MidBoxCacheData.NewRow();
                    dr["pib_id"] = pib_id_arr[i];
                    dr["pib_outboxcode1"] = pib_outbox_arr[i];
                    //由于之前加了一个ID列和箱号，导致j从2开始
                    for (int j = 2; j < MidBoxCacheData.Columns.Count; j++)
                    {
                        //选出勾选的中盒号
                        dr[Temp[j - 2].Columns[0].ColumnName] = Temp[j - 2].Select("PIB_OUTBOXCODE1='" + pib_outbox_arr[i] + "'")[0][0];
                    }
                    MidBoxCacheData.Rows.Add(dr);
                }
            }
        }

        private void SingleLabelPrint_Click(object sender, EventArgs e)
        {
            if (SingleLabelCombox.Text != "")
            {
                if (SingleBoxBegin.Text != "" || SingleBoxEnd.Text != "")
                {
                    try
                    {
                        int begin = int.Parse(SingleBoxBegin.Text == "" ? "1" : SingleBoxBegin.Text);
                        int end = int.Parse(SingleBoxEnd.Text == "" ? LabelInf.Rows.Count.ToString() : SingleBoxEnd.Text);
                        if (begin > 0 && end <= LabelInf.Rows.Count && begin <= end)
                        {
                            for (int i = begin - 1; i < end; i++)
                            {
                                LabelInf.Rows[i].Cells["Choose"].Value = true;
                                LabelInf.Rows[i].Cells["pib_ifprint"].Value = false;
                            }
                        }
                        else
                        {
                            MessageBox.Show("单盘打印范围错误", "提示");
                            return;
                        }
                    }
                    catch (Exception)
                    {
                        MessageBox.Show("单盘打印范围错误", "提示");
                        return;
                    }
                }
                thread = new Thread(SingleBoxPrint);
                stw = new SetLoadingWindow(thread, "正在打印单盘");
                BaseUtil.SetFormCenter(stw);
                stw.ShowDialog();
            }
            else
                MessageBox.Show("未维护单盘标签", "提示");
        }

        private void MidBoxLabelPrint()
        {
            //未输入内容打印全部中盒
            if (MidLabelNum.Text == "")
            {
                int begin = 0;
                int end = 0;
                if (MidBoxBegin.Text != "" || MidBoxEnd.Text != "")
                {
                    try
                    {
                        begin = int.Parse(MidBoxBegin.Text == "" ? "1" : MidBoxBegin.Text);
                        end = int.Parse(MidBoxEnd.Text == "" ? LabelInf.Rows[LabelInf.Rows.Count - 1].Cells["pib_outboxcode1"].Value.ToString() : MidBoxEnd.Text);
                        int minmidbox = int.Parse(LabelInf.Rows[0].Cells["pib_outboxcode1"].Value.ToString());
                        int maxmidbox = int.Parse(LabelInf.Rows[LabelInf.Rows.Count - 1].Cells["pib_outboxcode1"].Value.ToString());
                        if (begin >= minmidbox && end <= maxmidbox && begin <= end)
                        {
                            //设置中盒打印范围的行号
                            for (int i = 0; i < LabelInf.Rows.Count; i++)
                            {
                                if (int.Parse(LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString()) == begin)
                                {
                                    begin = i;
                                }
                                if (int.Parse(LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString()) == end)
                                {
                                    end = i;
                                }
                            }
                        }
                        else
                        {
                            MessageBox.Show("中盒打印范围错误", "提示");
                            return;
                        }
                    }
                    catch (Exception)
                    {
                        MessageBox.Show("中盒打印范围错误", "提示");
                        return;
                    }
                }
                MidBoxArgument.Clear();
                MidBoxCacheData.Clear();
                BaseUtil.CleanDataTable(MidBoxCacheData);
                List<int> MidOutBoxCode = new List<int>();
                List<int> MidOutBoxCodeIndex = new List<int>();
                string la_id = MidLabelCombox.SelectedValue.ToString().Split('#')[0];
                for (int i = (begin == 0 ? 0 : begin); i <= (end == 0 ? LabelInf.Rows.Count - 1 : end); i++)
                {
                    if (!MidIDAndOutboxcode.ContainsValue(LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString()))
                        MidIDAndOutboxcode.Add(LabelInf.Rows[i].Cells["pib_id1"].Value.ToString(), LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString());
                    if (!MidOutBoxCode.Contains(int.Parse(LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString())))
                    {
                        MidOutBoxCode.Add(int.Parse(LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString()));
                        MidOutBoxCodeIndex.Add(i);
                    }
                }
                GetMidBoxData();
                for (int i = 0; i < MidOutBoxCodeIndex.Count; i++)
                {
                    MidBoxCodePrint(la_id, MidOutBoxCodeIndex[i]);
                }
                MidBoxArgument.Clear();
                MidBoxCacheData.Clear();
                BaseUtil.CleanDataTable(MidBoxCacheData);
                return;
            }
            bool FindMidLabel = false;
            if (MidLabelCombox.SelectedValue != null)
            {
                string la_id = MidLabelCombox.SelectedValue.ToString().Split('#')[0];
                string cl_labelname = MidLabelCombox.Text;
                string LabelUrl = dh.getFieldDataByCondition("label left join customerlabel on la_code=cl_labelcode", "cl_labelurl", "la_id='" + la_id + "' and cl_labelname='" + cl_labelname + "'").ToString();
                //中盒号所在的行
                int MidLabelRowIndex = 0;
                //查找是否存在该中盒号
                List<int> MidRowIndex = new List<int>();
                //缓存中盒数据
                for (int i = 0; i < LabelInf.RowCount; i++)
                {
                    if (MidLabelNum.Text == LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString())
                    {
                        //找到了输入的中盒号停止循环
                        FindMidLabel = true;
                        MidLabelRowIndex = i;
                        MidRowIndex.Add(i);
                    }
                }
                //找到了指定的盒号
                if (FindMidLabel)
                    MidBoxCodePrint(la_id, MidLabelRowIndex, MidRowIndex.ToArray());
                else
                    MessageBox.Show("该出入库单未找到该中盒号！", "提示");
            }
            else
                MessageBox.Show("未维护中盒模板", "提示");
        }

        private void MidLabelPrint_Click(object sender, EventArgs e)
        {
            if (MidLabelCombox.Text != "")
            {
                thread = new Thread(MidBoxLabelPrint);
                stw = new SetLoadingWindow(thread, "正在打印中盒");
                BaseUtil.SetFormCenter(stw);
                stw.ShowDialog();
            }
            else
                MessageBox.Show("未维护中盒标签", "提示");
        }

        private void OutBoxPrint()
        {
            List<string> Outboxcode = new List<string>();
            //如果未勾选箱号则对勾选的数据的箱号进行整合
            string la_id = OutBoxCombox.SelectedValue.ToString().Split('#')[0];
            string cl_labelname = OutBoxCombox.Text;
            string LabelUrl = dh.getFieldDataByCondition("label left join customerlabel on la_code=cl_labelcode", "cl_labelurl", "la_id='" + la_id + "' and cl_labelname='" + cl_labelname + "'").ToString();
            if (OutBoxNum.Text == "")
            {
                for (int i = 0; i < LabelInf.RowCount; i++)
                {
                    if (LabelInf.Rows[i].Cells["Choose"].FormattedValue.ToString() == "True")
                    {
                        string outboxcode2 = LabelInf.Rows[i].Cells["pib_outboxcode2"].Value.ToString();
                        //富为使用包装单的逻辑
                        //如果不包含该箱号则进行添加
                        if (!Outboxcode.Contains(outboxcode2))
                            Outboxcode.Add(outboxcode2);
                    }
                }
                //按获取到的箱号列表进行打印
                if (Outboxcode.ToArray().Length > 0)
                {
                    try
                    {
                        // 循环打印外箱号
                        for (int i = 0; i < Outboxcode.ToArray().Length; i++)
                        {
                            for (int h = 0; h < LabelInf.RowCount; h++)
                            {
                                if (LabelInf.Rows[h].Cells["pib_outboxcode2"].Value.ToString() == Outboxcode.ToArray()[i])
                                {
                                    OutBoxCodePrint(la_id, h);
                                    break;
                                }
                            }
                        }
                    }
                    catch { }
                }
                else
                {
                    MessageBox.Show("请勾选需要打印的外箱", "提示");
                }
            }
            else
            {
                bool FindMidLabel = false;
                try
                {
                    int OutBoxLabelRowIndex = 0;
                    //查找是否存在该中盒号
                    for (int i = 0; i < LabelInf.RowCount; i++)
                    {
                        if (OutBoxNum.Text == LabelInf.Rows[i].Cells["pib_outboxcode2"].Value.ToString())
                        {
                            //找到了输入的中盒号停止循环
                            FindMidLabel = true;
                            OutBoxLabelRowIndex = i;
                            break;
                        }
                    }
                    //找到了指定的盒号
                    if (FindMidLabel)
                        OutBoxCodePrint(la_id, OutBoxLabelRowIndex);
                    else
                        MessageBox.Show("该出入库单未找到该外箱号！", "提示");
                }
                catch (Exception) { }
            }
            Outboxcode.Clear();
        }

        private void MidBoxCodePrint(string la_id, int rowindex)
        {
            if (MidBoxCacheData.Rows.Count == 0)
            {
                MidIDAndOutboxcode.Add(LabelInf.Rows[rowindex].Cells["pib_id1"].Value.ToString(), LabelInf.Rows[rowindex].Cells["pib_outboxcode1"].Value.ToString());
                GetMidBoxData();
            }
            DataTable dt = (DataTable)dh.ExecuteSql("select lp_name,lp_sql from label left join LABELPARAMETER on la_id= lp_laid where la_id=" + la_id, "select");
            DataTable Attach = (DataTable)dh.ExecuteSql("select lap_param lp_name,lap_value lp_sql from LabelAttachPARAMETER where lap_custcode='" + pi_cardcode.Text + "'", "select");
            //用标签本身的变量作为最外层的循环条件去匹配;
            dt.Merge(Attach);
            string[] arg = MidBoxArgument.ToArray();
            for (int j = 0; j < MidDoc.Variables.FreeVariables.Count; j++)
            {
                //将维护的模板参数和模板本身的参数名称进行比对
                for (int k = 0; k < MidLabelParam.Rows.Count; k++)
                {
                    //名称相等的时候，取SQL进行值的查询
                    if (MidDoc.Variables.FreeVariables.Item(j + 1).Name == MidLabelParam.Rows[k]["lp_name"].ToString())
                    {
                        //获取对应行的pib_id
                        string pib_id = LabelInf.Rows[rowindex].Cells["pib_id1"].Value.ToString();
                        string pib_outboxcode1 = LabelInf.Rows[rowindex].Cells["pib_outboxcode1"].Value.ToString();
                        //获取打印执行的SQL
                        string sql = MidLabelParam.Rows[k]["lp_sql"].ToString();
                        try
                        {
                            //获取打印执行的SQL
                            if (sql.IndexOf("{") == 0)
                            {
                                MidDoc.Variables.FreeVariables.Item(j + 1).Value = dh.GetLabelParam(sql).ToString();
                                LogManager.DoLog("打印参数【" + MidDoc.Variables.FreeVariables.Item(j + 1).Name + "】赋值，" + "取值SQL:" + dt.Rows[k]["lp_sql"].ToString() + "，取到值" + MidDoc.Variables.FreeVariables.Item(j + 1).Value);
                            }
                            else
                            {
                                DataRow[] dr = MidBoxCacheData.Select("pib_outboxcode1='" + pib_outboxcode1 + "'");
                                if (arg.Contains(MidDoc.Variables.FreeVariables.Item(j + 1).Name))
                                {
                                    if (dr.Length > 0)
                                    {
                                        MidDoc.Variables.FreeVariables.Item(j + 1).Value = dr[0][MidDoc.Variables.FreeVariables.Item(j + 1).Name].ToString();
                                    }
                                }
                                if (MidDoc.Variables.FreeVariables.Item(j + 1).Value == "")
                                {
                                    DataRow[] drow = MidLabelParam.Select("lp_name='" + MidDoc.Variables.FreeVariables.Item(j + 1).Name + "'");
                                    if (drow.Length > 0)
                                        MidDoc.Variables.FreeVariables.Item(j + 1).Value = drow[0]["lp_sql"].ToString();
                                }
                                LogManager.DoLog("打印参数【" + MidDoc.Variables.FreeVariables.Item(j + 1).Name + "】赋值，" + "取值SQL:" + sql + "，取到值" + MidDoc.Variables.FreeVariables.Item(j + 1).Value);
                            }
                        }
                        catch (Exception)
                        {
                            LogManager.DoLog("SQL维护不正确，请检查SQL语句\n" + sql);
                            return;
                        }
                    }
                }
            }
            //保存参数打印
            if (EnablePrint)
            {
                MidDoc.Printer.SwitchTo(MidLabelPrinter.Text);
                MidDoc.PrintDocument();
            }
        }

        private void MidBoxCodePrint(string la_id, int rowindex, int[] midindex)
        {
            for (int j = 0; j < MidDoc.Variables.FreeVariables.Count; j++)
            {
                //将维护的模板参数和模板本身的参数名称进行比对
                for (int k = 0; k < MidLabelParam.Rows.Count; k++)
                {
                    //名称相等的时候，取SQL进行值的查询
                    if (MidDoc.Variables.FreeVariables.Item(j + 1).Name == MidLabelParam.Rows[k]["lp_name"].ToString())
                    {
                        //获取对应行的pib_id
                        string pib_id = LabelInf.Rows[rowindex].Cells["pib_id1"].Value.ToString();
                        string pib_outboxcode1 = LabelInf.Rows[rowindex].Cells["pib_outboxcode1"].Value.ToString();
                        //获取打印执行的SQL
                        string sql = MidLabelParam.Rows[k]["lp_sql"].ToString();
                        try
                        {
                            //获取打印执行的SQL
                            if (sql.IndexOf("{") == 0)
                            {
                                MidDoc.Variables.FreeVariables.Item(j + 1).Value = dh.GetLabelParam(sql).ToString();
                                LogManager.DoLog("打印参数【" + MidDoc.Variables.FreeVariables.Item(j + 1).Name + "】赋值，" + "取值SQL:" + dt.Rows[k]["lp_sql"].ToString() + "，取到值" + MidDoc.Variables.FreeVariables.Item(j + 1).Value);
                            }
                            else
                            {
                                if (MidDoc.Variables.FreeVariables.Item(j + 1).Name.ToLower().Contains("datecode1"))
                                {
                                    if (LabelInf.Rows[rowindex].Cells["pib_datecode1"].Value != null)
                                        MidDoc.Variables.FreeVariables.Item(j + 1).Value = LabelInf.Rows[rowindex].Cells["pib_datecode1"].Value.ToString();
                                }
                                else if (MidDoc.Variables.FreeVariables.Item(j + 1).Name.ToLower().Contains("lotno"))
                                {
                                    if (LabelInf.Rows[rowindex].Cells["pib_lotno"].Value != null)
                                        MidDoc.Variables.FreeVariables.Item(j + 1).Value = LabelInf.Rows[rowindex].Cells["pib_lotno"].Value.ToString();
                                }
                                else if (MidDoc.Variables.FreeVariables.Item(j + 1).Name.ToLower().Contains("datecode"))
                                {
                                    if (LabelInf.Rows[rowindex].Cells["pib_datecode"].Value != null)
                                        MidDoc.Variables.FreeVariables.Item(j + 1).Value = LabelInf.Rows[rowindex].Cells["pib_datecode"].Value.ToString();
                                }
                                else
                                {
                                    if (sql.ToLower().Contains("pib_qty"))
                                    {
                                        sql = sql.Substring(0, sql.IndexOf("{")) + pib_id + sql.Substring(sql.IndexOf("}") + 1);
                                        sql = sql.Substring(0, sql.LastIndexOf("=")) + "='" + pib_outboxcode1 + "' group by pib_outboxcode1";
                                    }
                                    else
                                    {
                                        sql = sql.Substring(0, sql.IndexOf("{"));
                                        sql = sql.Substring(0, sql.LastIndexOf("="));
                                        sql = sql + " in (select distinct pib_outboxcode1 from PRODIOBARCODE where pib_inoutno='" + pi_inoutno.Text + "')" + " and pib_inoutno='" + pi_inoutno.Text + "' and pib_outboxcode1='" + pib_outboxcode1 + "'";
                                    }
                                    MidDoc.Variables.FreeVariables.Item(j + 1).Value = dh.GetLabelParam(sql).ToString();
                                }
                                if (MidDoc.Variables.FreeVariables.Item(j + 1).Value == "")
                                {
                                    DataRow[] drow = MidLabelParam.Select("lp_name='" + MidDoc.Variables.FreeVariables.Item(j + 1).Name + "'");
                                    if (drow.Length > 0)
                                        MidDoc.Variables.FreeVariables.Item(j + 1).Value = drow[0]["lp_sql"].ToString();
                                }
                                LogManager.DoLog("打印参数【" + MidDoc.Variables.FreeVariables.Item(j + 1).Name + "】赋值，" + "取值SQL:" + sql + "，取到值" + MidDoc.Variables.FreeVariables.Item(j + 1).Value);
                            }
                        }
                        catch (Exception)
                        {
                            LogManager.DoLog("SQL维护不正确，请检查SQL语句\n" + sql);
                            return;
                        }
                    }
                }
            }
            //保存参数打印
            if (EnablePrint)
            {
                MidDoc.Printer.SwitchTo(MidLabelPrinter.Text);
                MidDoc.PrintDocument();
            }
        }

        /// <summary>
        /// 执行打印外箱号
        /// </summary>
        private void OutBoxCodePrint(string la_id, int rowindex)
        {
            DataTable dt = (DataTable)dh.ExecuteSql("select lp_name,lp_sql,lp_valuetype from label left join LABELPARAMETER on la_id= lp_laid where la_id=" + la_id, "select");
            DataTable Attach = (DataTable)dh.ExecuteSql("select lap_param lp_name,lap_value lp_sql  from LabelAttachPARAMETER where lap_custcode='" + pi_cardcode.Text + "'", "select");
            //用标签本身的变量作为最外层的循环条件去匹配;
            dt.Merge(Attach);
            try
            {
                for (int j = 0; j < OutBoxDoc.Variables.FreeVariables.Count; j++)
                {
                    //将维护的模板参数和模板本身的参数名称进行比对
                    for (int k = 0; k < OutLabelParam.Rows.Count; k++)
                    {
                        //名称相等的时候，取SQL进行值的查询
                        if (OutBoxDoc.Variables.FreeVariables.Item(j + 1).Name == OutLabelParam.Rows[k]["lp_name"].ToString())
                        {
                            //获取对应行的pib_id
                            string pib_id = LabelInf.Rows[rowindex].Cells["pib_id1"].Value.ToString();
                            string pib_outboxcode2 = LabelInf.Rows[rowindex].Cells["pib_outboxcode2"].Value.ToString();
                            //获取打印执行的SQL
                            string sql = OutLabelParam.Rows[k]["lp_sql"].ToString();
                            try
                            {
                                string ExeSQL = "";
                                ExeSQL = sql.ToLower().Replace("{pib_id}", "'" + pib_id + "'");
                                ExeSQL = ExeSQL.Replace("{pib_outboxcode2}", "'" + pib_outboxcode2 + "'");
                                OutBoxDoc.Variables.FreeVariables.Item(j + 1).Value = dh.GetLabelParam(ExeSQL).ToString();
                                if (OutBoxDoc.Variables.FreeVariables.Item(j + 1).Value == "")
                                {
                                    DataRow[] drow = OutLabelParam.Select("lp_name='" + OutBoxDoc.Variables.FreeVariables.Item(j + 1).Name + "'");
                                    if (drow.Length > 0)
                                        OutBoxDoc.Variables.FreeVariables.Item(j + 1).Value = drow[0]["lp_sql"].ToString();
                                }
                                LogManager.DoLog("打印参数【" + OutBoxDoc.Variables.FreeVariables.Item(j + 1).Name + "】赋值，" + "取值SQL:" + ExeSQL + "，取到值" + OutBoxDoc.Variables.FreeVariables.Item(j + 1).Value);
                            }
                            catch (Exception)
                            {
                                LogManager.DoLog("SQL维护不正确，请检查SQL语句" + sql);
                                MessageBox.Show("SQL维护不正确，请检查SQL语句\n" + sql, "提示");
                                return;
                            }
                        }
                        else if (OutBoxDoc.Variables.FreeVariables.Item(j + 1).Name == "DateCode1")
                        {
                            if (LabelInf.Rows[rowindex].Cells["pib_datecode1"].Value != null)
                            {
                                OutBoxDoc.Variables.FreeVariables.Item(j + 1).Value = LabelInf.Rows[rowindex].Cells["pib_datecode1"].Value.ToString();
                            }
                        }
                    }
                }
                //保存参数打印
                if (EnablePrint)
                {
                    OutBoxDoc.Printer.SwitchTo(OutBoxPrinter.Text);
                    OutBoxDoc.PrintDocument();
                }
                LogManager.DoLog("执行打印外箱,pib_id:" + LabelInf.Rows[rowindex].Cells["pib_id1"].Value.ToString());
            }
            catch (Exception ex) { MessageBox.Show(ex.Message, "提示"); }
        }

        private void CleanDetail_Click(object sender, EventArgs e)
        {
            ArrayList<string> DeleteID = new ArrayList<string>();
            for (int i = 0; i < LabelInf.RowCount; i++)
            {
                if (LabelInf.Rows[i].Cells["Choose"].FormattedValue.ToString() == "True")
                    DeleteID.Add(LabelInf.Rows[i].Cells["pib_id1"].Value.ToString());
            }
            //勾选了删除的明细之后
            if (DeleteID.ToArray().Length > 0)
            {
                string close = MessageBox.Show(this.ParentForm, "删除后不可恢复，是否确认删除", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
                if (close.ToString() == "Yes")
                {
                    dh.BatchInsert("delete from prodiobarcode where pib_id=:pib_id", new string[] { "pib_id" }, DeleteID.ToArray());
                    MessageBox.Show("删除成功", "提示");
                    LoadGridData(sender, e);
                }
            }
            else
                MessageBox.Show("尚未勾选需要删除的明细", "提示");
        }

        private void OutBoxLabelPrint_Click(object sender, EventArgs e)
        {
            if (OutBoxCombox.Text != "")
            {
                thread = new Thread(OutBoxPrint);
                stw = new SetLoadingWindow(thread, "正在打印外箱");
                BaseUtil.SetFormCenter(stw);
                stw.ShowDialog();
            }
            else
                MessageBox.Show("未维护外箱标签", "提示");
        }

        private void LoadGridData()
        {
            LoadGridData(new object(), new EventArgs());
        }

        /// <summary>
        /// 自定义函数  加载明细行的数据，多处使用添加进函数
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void LoadGridData(object sender, EventArgs e)
        {
            sql.Clear();
            sql.Append("select pd_custprodcode,pd_custprodspec,pd_pocode,pib_madein,pib_custbarcode,pib_custoutboxcode,pib_id,pib_datecode1,pib_pdid,pib_piid,pib_pdno,pib_prodcode,nvl(nvl(pd_brand,pib_brand),pr_brand)pib_brand, pr_vendprodcode,");
            sql.Append("pib_lotno,pib_datecode,pib_qty,pr_spec,pr_zxbzs,pr_unit,pib_barcode,pib_outboxcode1,pib_outboxcode2,nvl(pib_ifprint,0)pib_ifprint");
            sql.Append(" from prodiobarcode left join prodiodetail on pib_piid=pd_piid and pd_pdno=pib_pdno and ");
            sql.Append(" pd_prodcode=pib_prodcode left join product on pr_code=pib_prodcode left join sale on sa_code=pib_ordercode ");
            sql.Append("where pib_piid='" + PI_ID + "' order by to_number(pib_outboxcode2),pib_id,pd_prodcode");
            LabelInfDataTable = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
            BaseUtil.FillDgvWithDataTable(LabelInf, LabelInfDataTable);
            //有数据的话默认取第一条的品牌去取采集策略
            TotalCount.Text = LabelInf.RowCount.ToString();
            if (LabelInf.Rows.Count > 0)
                LabelInf.FirstDisplayedScrollingRowIndex = LabelInf.Rows.Count - 1;

            for (int i = 0; i < GridPrcode.Rows.Count; i++)
            {
                string CurrentPrCode = GridPrcode.Rows[i].Cells["pd_prodcode"].Value.ToString();
                string CurrentPDNO = GridPrcode.Rows[i].Cells["pd_pdno"].Value.ToString();
                string collectqty = (LabelInfDataTable.Compute("sum(pib_qty)", "pib_prodcode='" + CurrentPrCode + "' and pib_pdno='" + CurrentPDNO + "'").ToString());
                GridPrcode.Rows[i].Cells["CollectedNum"].Value = collectqty;
            }
        }

        private void Refresh_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            KeyEventArgs e2 = new KeyEventArgs(Keys.Enter);
            pi_inoutno_KeyDown(sender, e2);
        }

        /// <summary>
        /// 采集明细切换
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void griddetno_KeyDown(object sender, KeyEventArgs e)
        {
            if (Keys.Enter == e.KeyData)
            {
                bool FindDetno = false;
                for (int i = 0; i < LabelInf.RowCount; i++)
                {
                    if (LabelInf.Rows[i].Cells["pib_pdno"].Value.ToString() == griddetno.Text)
                    {
                        FindDetno = true;
                        CurrentRowIndex = i;
                        break;
                    }
                }
                if (!FindDetno)
                {
                    MessageBox.Show("不存在未采集的明细序号" + griddetno.Text, "提示");
                    return;
                }
            }
        }

        private void AutoPrintMidLabel()
        {
            bool FullBox = true;
            //判断所有盒号未该盒的是否勾选已采集
            for (int i = 0; i < LabelInf.RowCount; i++)
            {
                //if (LabelInf.Rows[i].Cells["pib_outboxcode1"].Value.ToString() == LabelInf.Rows[CurrentRowIndex].Cells["pib_outboxcode1"].Value.ToString())
                //{
                //    if (LabelInf.Rows[i].Cells["pib_ifpick"].FormattedValue.ToString() != "True")
                //        FullBox = false;
                //}
            }
            //如果当前箱号已经装满了
            if (FullBox)
            {
                if (MidLabelCombox.SelectedValue != null)
                {
                    string la_id = MidLabelCombox.SelectedValue.ToString().Split('#')[0];
                    MidBoxCodePrint(la_id, CurrentRowIndex);
                }
                else
                    MessageBox.Show("未维护中盒模板", "提示");
            }
        }

        /// <summary>
        /// 勾选的时候自动打印
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void LabelInf_CellValueChanged(object sender, DataGridViewCellEventArgs e)
        {
            if (LabelInf.Columns[e.ColumnIndex].Name == "pib_datecode")
            {
                string datecode = LabelInf.Rows[e.RowIndex].Cells["pib_datecode"].Value.ToString();
                try
                {
                    System.DateTime dt = System.DateTime.ParseExact(datecode, "yyyyMMdd", CultureInfo.CurrentCulture);
                    GregorianCalendar gc = new GregorianCalendar();
                    int weekOfYear = gc.GetWeekOfYear(dt, CalendarWeekRule.FirstDay, DayOfWeek.Monday);
                    if (weekOfYear < 10)
                        LabelInf.Rows[e.RowIndex].Cells["pib_datecode1"].Value = dt.Year.ToString().Substring(2, 2) + "0" + weekOfYear;
                    else
                        LabelInf.Rows[e.RowIndex].Cells["pib_datecode1"].Value = dt.Year.ToString().Substring(2, 2) + weekOfYear;
                }
                catch (Exception) { }
            }
        }

        private void LogingOut_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            string close = MessageBox.Show(this.ParentForm, "是否注销", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
            if (close.ToString() == "Yes")
            {
                Login login = new Login();
                //注销的时候需要将拼接的连接字符串置空
                DataHelper.DBConnectionString = null;
                logout = true;
                lbl.Quit();
                this.Hide();
                login.ShowDialog();
                this.Close();
            }
        }

        private void LabelInf_DataError(object sender, DataGridViewDataErrorEventArgs e) { }

        /// <summary>
        /// 切换打开的单盘文件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void SingleLabelCombox_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                if (ComBoxClickChangeLabelDoc)
                {
                    if (SingleDoc != null)
                        SingleDoc.Close();
                    if (SingleLabelCombox.Text != "" && SingleLabelCombox.SelectedValue != null && !GetGridOnly.Checked)
                    {
                        System.DateTime time = Convert.ToDateTime(SingleLabelCombox.SelectedValue.ToString().Split('#')[2]);
                        SingleDoc = lbl.Documents.Open(BaseUtil.GetLabelUrl(SingleLabelCombox.SelectedValue.ToString().Split('#')[1], SingleLabelCombox.Text, time));
                    }
                }
            }
            catch (Exception) { }
        }

        /// <summary>
        /// 切换打开的中盒文件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void MidLabelCombox_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                if (ComBoxClickChangeLabelDoc)
                {
                    if (MidDoc != null)
                        MidDoc.Close();
                    if (MidLabelCombox.Text != "" && MidLabelCombox.SelectedValue != null && !GetGridOnly.Checked)
                    {
                        System.DateTime time = Convert.ToDateTime(MidLabelCombox.SelectedValue.ToString().Split('#')[2]);
                        MidDoc = lbl.Documents.Open(BaseUtil.GetLabelUrl(MidLabelCombox.SelectedValue.ToString().Split('#')[1], MidLabelCombox.Text, time));
                    }
                }
            }
            catch (Exception) { }
        }

        /// <summary>
        /// 切换打开的外箱文件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void OutBoxCombox_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                if (ComBoxClickChangeLabelDoc)
                {
                    if (OutBoxDoc != null)
                        OutBoxDoc.Close();
                    if (OutBoxCombox.Text != "" && OutBoxCombox.SelectedValue != null && !GetGridOnly.Checked)
                    {
                        System.DateTime time = Convert.ToDateTime(OutBoxCombox.SelectedValue.ToString().Split('#')[2]);
                        OutBoxDoc = lbl.Documents.Open(BaseUtil.GetLabelUrl(OutBoxCombox.SelectedValue.ToString().Split('#')[1], OutBoxCombox.Text, time));
                    }
                }
            }
            catch (Exception) { }
        }

        private void ChooseAll_Click(object sender, EventArgs e)
        {
            if (AllChecked)
            {
                foreach (DataGridViewRow dr in LabelInf.Rows)
                    dr.Cells[0].Value = false;
                AllChecked = false;
            }
            else
            {
                foreach (DataGridViewRow dr in LabelInf.Rows)
                    dr.Cells[0].Value = true;
                AllChecked = true;
            }
        }

        private void ExportData_Click(object sender, EventArgs e)
        {
            ExportFileDialog.Description = "选择导出的路径";
            DialogResult result = ExportFileDialog.ShowDialog();
            if (result == DialogResult.OK)
            {
                ExcelHandler eh = new ExcelHandler();
                DataTable dt = LabelInfDataTable.Copy();
                for (int i = dt.Columns.Count - 1; i >= 0; i--)
                {
                    for (int j = 0; j < LabelInf.Columns.Count; j++)
                    {
                        //去除ID列
                        if (dt.Columns[i].ColumnName.ToLower().Contains("id") || dt.Columns[i].ColumnName.ToLower() == "pib_barcode" || dt.Columns[i].ColumnName.ToLower() == "pib_pdno" || dt.Columns[i].ColumnName.ToLower() == "pib_ifprint" || dt.Columns[i].ColumnName.ToLower() == "pib_datecode1" || dt.Columns[i].ColumnName.ToLower() == "pr_vendprodcode")
                        {
                            dt.Columns.RemoveAt(i);
                            break;
                        }
                        switch (dt.Columns[i].ColumnName.ToLower())
                        {
                            case "pib_lotno":
                                dt.Columns[i].ColumnName = "批次号";
                                break;
                            case "pib_datecode":
                                dt.Columns[i].ColumnName = "生产日期";
                                break;
                            case "pib_custbarcode":
                                dt.Columns[i].ColumnName = "最小产品包装条码";
                                break;
                            default:
                                break;
                        }
                        if (dt.Columns[i].ColumnName.ToLower() == LabelInf.Columns[j].DataPropertyName.ToLower())
                        {
                            dt.Columns[i].ColumnName = LabelInf.Columns[j].HeaderText;
                            break;
                        }
                    }
                }
                eh.ExportExcel(dt, ExportFileDialog.SelectedPath, pi_date.Text + "-" + pi_inoutno.Text);
                string close = MessageBox.Show(this.ParentForm, "导出成功，是否打开文件", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
                if (close.ToString() == "Yes")
                    System.Diagnostics.Process.Start(ExportFileDialog.SelectedPath + "\\" + pi_date.Text + "-" + pi_inoutno.Text + ".xls");
            }
        }

        private void AttachInfo_Click(object sender, EventArgs e)
        {
            if (pi_cardcode.Text != "")
            {
                附件内容打印 att = new 附件内容打印(pi_cardcode.Text);
                att.ShowDialog();
            }
            else MessageBox.Show("请先获取出库单信息", "提示");
        }

        private void MidBoxCapacity_Leave(object sender, EventArgs e)
        {
            NumericUpDown nup = (NumericUpDown)sender;
            switch (nup.Name)
            {
                case "MidBoxCapacity":
                    Properties.Settings.Default.MidBoxCapacity = nup.Value;
                    Properties.Settings.Default.Save();
                    break;
                case "OutboxCapacity":
                    Properties.Settings.Default.OutboxCapacity = nup.Value;
                    Properties.Settings.Default.Save();
                    break;
                default:
                    break;
            }
        }

        private void RefreshDBConnect_Tick(object sender, EventArgs e)
        {
            dh.ExecuteSql("select count(1) from employee", "select");
        }

        private void LoadPrcodeData()
        {
            GridPrcode.DataSource = (DataTable)dh.ExecuteSql("select pd_prodcode,pd_brand,pjd_zxbzs_user,pd_outqty,pd_pdno,pr_unit,pjd_id from prodiodetail left join prodinout on pi_id=pd_piid left join PRODJOINVENDDETAIL on pjd_brand =pd_brand and pjd_prodcode=pd_prodcode left join product on pd_prodcode=pr_code where pi_id='" + PI_ID + "' order by pd_pdno", "select");
            if (GridPrcode.Rows.Count > 0)
            {
                CurrentPrCode = GridPrcode.Rows[0].Cells["pd_prodcode"].Value.ToString();
                CurrentZXBZ = GridPrcode.Rows[0].Cells["pjd_zxbzs_user"].Value.ToString();
                CurrentUnit = GridPrcode.Rows[0].Cells["pr_unit"].Value.ToString();
                CurrentPDNO = GridPrcode.Rows[0].Cells["pd_pdno"].Value.ToString();
                CurrentPrCount = GridPrcode.Rows[0].Cells["pd_outqty"].Value.ToString();
                CurrentBrand = GridPrcode.Rows[0].Cells["pd_brand"].Value.ToString();
                GridPrcode.Rows[0].Selected = true;
            }
        }

        private void GridPrcode_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            //用户在重新勾选后重置采集项目的索引
            if (e.ColumnIndex >= 0 && e.RowIndex >= 0)
            {
                CurrentPrCode = GridPrcode.Rows[e.RowIndex].Cells["pd_prodcode"].Value.ToString();
                CurrentZXBZ = GridPrcode.Rows[e.RowIndex].Cells["pjd_zxbzs_user"].Value.ToString();
                CurrentUnit = GridPrcode.Rows[e.RowIndex].Cells["pr_unit"].Value.ToString();
                CurrentPDNO = GridPrcode.Rows[e.RowIndex].Cells["pd_pdno"].Value.ToString();
                CurrentPrCount = GridPrcode.Rows[e.RowIndex].Cells["pd_outqty"].Value.ToString();
                CurrentBrand = GridPrcode.Rows[e.RowIndex].Cells["pd_brand"].Value.ToString();
                GridPrcode.Rows[e.RowIndex].Selected = true;
            }
        }

        private bool EnablePrint = true;

        private void SetPrintStatus_Click(object sender, EventArgs e)
        {
            EnablePrint = !EnablePrint;
            if (EnablePrint)
            {
                SetPrintStatus_label.ForeColor = Color.Green;
                SetPrintStatus_label.Text = "可打印";
            }
            else
            {
                SetPrintStatus_label.ForeColor = Color.Red;
                SetPrintStatus_label.Text = "暂停打印";
            }
        }

        private void OutBoxNum_Click(object sender, EventArgs e)
        {
            OutBoxNum.Items.Clear();
            DataTable dt = (DataTable)dh.ExecuteSql("select distinct pib_outboxcode2 from prodiobarcode where pib_inoutno='" + pi_inoutno.Text + "' order by pib_outboxcode2", "select");
            ItemObject io = new ItemObject("新增", "新增");
            OutBoxNum.Items.Add(io);
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                string pib_outboxcode2 = dt.Rows[i]["pib_outboxcode2"].ToString();
                io = new ItemObject(pib_outboxcode2, pib_outboxcode2);
                OutBoxNum.Items.Add(io);
            }
            OutBoxNum.SelectedIndex = OutBoxNum.Items.Count - 1;
        }

        /// <summary>
        /// 获取条码规则
        /// </summary>
        /// <param name="Type"></param>
        /// <param name="Prefix"></param>
        /// <param name="Suffix"></param>
        /// <param name="CurrentMaxNum"></param>
        /// <param name="SerialNumLength"></param>
        /// <param name="Radix"></param>
        private void GetBarCodeRule(string Type, out string Prefix, out string Suffix, out int CurrentMaxNum, out int SerialNumLength, out int Radix)
        {
            //获取编码规则
            Prefix = "";
            Suffix = "";
            CurrentMaxNum = 0;
            SerialNumLength = 0;
            Radix = 0;
            DataTable Nr = (DataTable)dh.ExecuteSql("select nrd_detno,nrd_name,nrd_type,nrd_radix,nrd_sql,nrd_length from NoRuleDetail left join norule on nrd_nrid=nr_id where nr_custcode='" + pi_cardcode.Text + "' and nr_type='" + Type + "' 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 from NoRuleDetail left join norule on nrd_nrid=nr_id where nr_custcode is null and nr_type='" + Type + "' and nr_isdefault <> 0 order by nrd_detno", "select");
            //用于过滤参数的正则表达式
            Regex match = new Regex("{\\w+}");
            //用于存放每一项的明细的数据
            string[] NrData = new string[Nr.Rows.Count];
            //流水长度
            Dictionary<int, string> NrDic = new Dictionary<int, string>();
            Prefix = "";
            for (int m = 0; m < Nr.Rows.Count; m++)
            {
                switch (Nr.Rows[m]["nrd_type"].ToString())
                {
                    //常量直接进行拼接
                    case "常量":
                        Prefix += Nr.Rows[m]["nrd_sql"].ToString();
                        Suffix += Nr.Rows[m]["nrd_sql"].ToString();
                        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(), "'" + pi_inoutno.Text + "'");
                            }
                            Temp = (DataTable)dh.ExecuteSql(SQL, "select");
                        }
                        if (Temp.Rows.Count > 0)
                        {
                            Prefix += Temp.Rows[0][0].ToString();
                            Suffix += Temp.Rows[0][0].ToString();
                        }
                        break;
                    //流水需要通过MaxNumber去取
                    case "流水":
                        string maxnum = dh.getFieldDataByCondition("RuleMaxNum", "rmn_maxnumber", "rmn_nrcode='" + pi_cardcode.Text + "' and rmn_prefix='" + Prefix + "'  and rmn_type='" + Type + "'").ToString();
                        //设置当前流水
                        if (maxnum == "")
                        {
                            dh.ExecuteSql("insert into RuleMaxNum(rmn_id,rmn_nrcode,rmn_prefix,rmn_maxnumber,rmn_type) values(RuleMaxNum_seq.nextval,'" + pi_cardcode.Text + "','" + Prefix + "','1','" + Type + "')", "insert");
                            CurrentMaxNum = 1;
                        }
                        else
                        {
                            CurrentMaxNum = int.Parse(maxnum);
                        }
                        SerialNumLength = int.Parse(Nr.Rows[m]["nrd_length"].ToString());
                        Radix = int.Parse(Nr.Rows[m]["nrd_radix"].ToString());
                        Suffix = "";
                        break;
                    default:
                        break;
                }
            }
        }

        private void GridPrcode_CellEndEdit(object sender, DataGridViewCellEventArgs e)
        {
            string Value = GridPrcode.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
            string ID = GridPrcode.Rows[e.RowIndex].Cells["pjd_id"].Value.ToString();
            dh.UpdateByCondition("PRODJOINVENDDETAIL", "pjd_zxbzs_user='" + Value + "'", "pjd_id='" + ID + "'");
            //删除对应物料的明细
            string CurrentPrCode = GridPrcode.Rows[e.RowIndex].Cells["pd_prodcode"].Value.ToString();
            string CurrentPDNO = GridPrcode.Rows[e.RowIndex].Cells["pd_pdno"].Value.ToString();
            dh.ExecuteSql("delete from prodiobarcode where pib_inoutno='" + pi_inoutno.Text + "' and pib_pdno='" + CurrentPDNO + "' and pib_prodcode='" + CurrentPrCode + "'", "delete");
            LoadGridData(sender, new EventArgs());
        }
    }
}