mes-client/UAS_MES_YDCY/FunctionCode/Packing/Packing_PackageCollectionPallet.cs

using System;
using System.Data;
using System.Windows.Forms;
using UAS_MES_NEW.DataOperate;
using UAS_MES_NEW.Entity;
using UAS_MES_NEW.PublicMethod;
using System.Drawing;
using System.Threading;
using UAS_MES_NEW.PublicForm;
using System.Collections.Generic;
using System.Diagnostics;
using Seagull.BarTender.Print;
using System.IO.Ports;
using System.IO;
using System.Text;
using System.Text.RegularExpressions;

namespace UAS_MES_NEW.Packing
{
    public partial class Packing_PackageCollectionPallet : Form
    {
        DataHelper dh;
        DataTable dt;
        LogStringBuilder sql = new LogStringBuilder();
        AutoSizeFormClass asc = new AutoSizeFormClass();
        Thread thread;
        Engine engine;
        SerialPort serialPort1 = new SerialPort();

        Regex re = new Regex("\\d+.\\d+");

        DataTable Dbfind;
        string ErrorMessage = "";
        string oMakeCode = "";
        string oMsID = "";
        string oMsStatus = "";
        string oOutBoxCode = "";
        decimal StandardQTY = 0;
        string LastSncode;
        string PR_CHECKCARTONW = "0";
        string pr_Singlelevelqty = "";
        public Packing_PackageCollectionPallet()
        {

            InitializeComponent();
        }

        //创建打印进程
        private void NewPrint()
        {
            try
            {
                engine = new Engine(true);
            }
            catch (Exception ex)
            {
                OperateResult.AppendText("未正确安装BarTender软件\n" + ex.Message, Color.Red);
            }
        }

        private void PackCollection_Load(object sender, EventArgs e)
        {
            // 杀死之前全部未关闭的进程
            //Process[] processes = System.Diagnostics.Process.GetProcessesByName("lppa");
            //Process[] processes1 = System.Diagnostics.Process.GetProcessesByName("bartend");
            //for (int i = 0; i < processes1.Length; i++)
            //{
            //    processes1[i].Kill();
            //}
            //for (int i = 0; i < processes.Length; i++)
            //{
            //    processes[i].Kill();
            //}
            pa_outboxcode.Enabled = false;
            //设置DbFind的必须的数据
            PrintNum.Text = "1";
            asc.controllInitializeSize(this);
            thread = new Thread(NewPrint);
            SetLoadingWindow stw = new SetLoadingWindow(thread, "初始化打印程序");
            BaseUtil.SetFormCenter(stw);
            stw.ShowDialog();
            try
            {
                OutBoxLength.Text = BaseUtil.GetCacheData("OutBoxLength").ToString();
                PreFix.Text = BaseUtil.GetCacheData("PreFix").ToString();
                ComList.Text = BaseUtil.GetCacheData("PortName").ToString();
                BaudRate.Text = BaseUtil.GetCacheData("BaudRate").ToString();
            }
            catch (Exception) { }
            if (!LogicHandler.CheckPower(User.UserCode, Tag.ToString()))
            {
                AutoGenBoxCode.Enabled = false;
            }
            StartWeight.PerformClick();
            sn_code.Focus();
            dh = SystemInf.dh;
            StepCount.StepCode = User.CurrentStepCode;
            StepCount.Source = User.UserSourceCode;
            StepCount.LineCode = User.UserLineCode;
            StepCount.Dh = dh;
            StepCount.Start();
        }

        private void PackCollection_SizeChanged(object sender, EventArgs e)
        {
            asc.controlAutoSize(this);
        }

        private void PackCollection_Activated(object sender, EventArgs e)
        {
            pa_outboxcode.Focus();
        }

        //刷新表单的数据的数据
        private void LoadData()
        {
            //加载表单数据
            sql.Clear();
            sql.Append("select pr_code,nvl(pr_sendchecktype,'LineCode')pr_sendchecktype,pa_remark,pa_outboxcode,pa_prodcode,pa_salecode,pa_makecode,pa_sccode,nvl(pa_downstatus,0) pa_downstatus,pa_checkno,pa_status,pr_packrule,nvl(PR_CHECKCARTONW,'0') PR_CHECKCARTONW,pr_detail,pa_packageqty,nvl(pa_standardqty,0) pa_standardqty,nvl(pr_outboxinnerqty,0)pr_outboxinnerqty,pa_currentqty from package left join product on pa_prodcode=");
            sql.Append("pr_code where pa_outboxcode='" + pa_outboxcode.Text + "'");
            dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            if (dt.Rows.Count > 0)
            {
                //记录该数据保证在修改不被允许的前提下能偶回复之前的值
                StandardQTY = decimal.Parse(dt.Rows[0]["pr_outboxinnerqty"].ToString());
                if (dt.Rows[0]["pa_salecode"].ToString() != "")
                {
                    ms_salecode.Text = dt.Rows[0]["pa_salecode"].ToString();
                }
                BaseUtil.SetFormValue(this.Controls, dt);
                if (pa_standardqty.Text != "0")
                {
                    pr_outboxinnerqty.Text = pa_standardqty.Text;
                }
            }
            else
            {
                pa_makecode.Text = "";
            }
            LoadCollectedNum();
            LoadCheckQTY();
        }

        private void LoadGridData()
        {
            //加载Grid数据
            dt = (DataTable)dh.ExecuteSql("select pa_outboxcode,pa_prodcode,pd_barcode,pd_innerqty,pd_makecode,pa_indate from packageDetail left join package on pa_id=pd_paid where pa_outboxcode='" + pa_outboxcode.Text + "'", "select");
            BaseUtil.FillDgvWithDataTable(PackageDetail, dt);
            if (dt.Rows.Count > 0)
            {
                string choose_pd_barcode = dt.Rows[0]["pd_barcode"].ToString();
                string choose_pd_makecode = dt.Rows[0]["pd_makecode"].ToString();
                PR_CHECKCARTONW = dh.getFieldDataByCondition("craftdetail left join craft on cr_id=cd_crid left join makeserial on ms_craftcode =cr_code and cr_prodcode = ms_prodcode", "nvl(cd_ifweigh,'0') cd_ifweigh", "ms_sncode='" + choose_pd_barcode + "' and ms_makecode='" + choose_pd_makecode + "' and cd_stepcode = '" + User.CurrentStepCode + "'").ToString();
            }
            //更新界面的采集数量
            pa_currentqty.Text = dh.getFieldDataByCondition("package", "pa_currentqty", "pa_outboxcode='" + pa_outboxcode.Text + "'").ToString();
        }

        private void Print_Click(object sender, EventArgs e)
        {
            if (PrintLabel.Items.Count != 0)
            {
                if (dh.getFieldDataByCondition("package", "pa_status", "pa_outboxcode='" + pa_outboxcode.Text + "'").ToString() == "1")
                {
                    double ActualWeight = double.Parse(weight.Text == "" ? "0" : weight.Text.Replace("kg", "").Replace("g", "").Trim());
                    double palletWeightErrorValue = double.Parse(dh.GetConfig("palletWeightErrorValue", "MESSetting").ToString());
                    double totalweight = double.Parse(sumpalletweight.Text);
                    if (weight.Text == "" || pa_width.Text == "" || pa_height.Text == "")
                    {
                        OperateResult.AppendText(">>长宽高不允许为空" + pa_outboxcode.Text + "\n", Color.Black);
                        return;
                    }
                    if ((ActualWeight >= totalweight - palletWeightErrorValue) && (ActualWeight <= totalweight + palletWeightErrorValue))
                    {
                        dh.ExecuteSql("update package set PA_WEIGHT='" + weight.Text + "',PA_WIDTH='" + pa_width.Text + "', PA_HEIGTH='" + pa_height.Text + "', PA_LENGTH='" + pa_long.Text + "',pa_printcount=pa_printcount+1,pa_remark='" + PrintLabel.Text + "' where pa_outboxcode='" + pa_outboxcode.Text + "'", "update");
                    }
                    else
                    {
                        OperateResult.AppendText(">>重量不符合" + pa_outboxcode.Text + "\n", Color.Black);
                        return;
                    }
                    if (Print.BarTender(Tag.ToString(), ref engine, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), PrintList.Text, pa_outboxcode.Text, int.Parse(PrintNum.Text), oMakeCode == "" ? pa_makecode.Text : oMakeCode, pr_code.Text, "栈板标", "0", out ErrorMessage))
                    {
                        OperateResult.AppendText(">>开始打印箱号" + pa_outboxcode.Text + "\n", Color.Black);
                    }
                    else
                    {
                        OperateResult.AppendText(ErrorMessage + "\n", Color.Red);
                    }
                    if (PrintSecond.Checked)
                    {
                        if (Print.BarTender(Tag.ToString(), ref engine, PrintLabel1.Text, PrintLabel1.SelectedValue.ToString(), PrintList1.Text, pa_outboxcode.Text, int.Parse(PrintNum1.Text), oMakeCode, pr_code.Text, "栈板标", "0", out ErrorMessage))
                        {
                            OperateResult.AppendText(">>序列号:" + sn_code.Text + "打印结束\n", Color.Green);
                        }
                        else
                        {
                            OperateResult.AppendText(ErrorMessage + "\n", Color.Red);
                        }
                    }
                    if (PrintThird.Checked)
                    {
                        if (Print.BarTender(Tag.ToString(), ref engine, PrintLabel2.Text, PrintLabel1.SelectedValue.ToString(), PrintList2.Text, pa_outboxcode.Text, int.Parse(PrintNum1.Text), oMakeCode, pr_code.Text, "栈板标", "0", out ErrorMessage))
                        {
                            OperateResult.AppendText(">>序列号:" + sn_code.Text + "打印结束\n", Color.Green);
                        }
                        else
                        {
                            OperateResult.AppendText(ErrorMessage + "\n", Color.Red);
                        }
                    }
                    if (!AutoGenBoxCode.Checked)
                    {
                        pa_outboxcode.SelectAll();
                        pa_outboxcode.Focus();
                    }
                    else
                    {
                        sn_code.Focus();
                        sn_code.SelectAll();
                    }
                }
                else OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "尚未封箱，请封箱后执行打印\n", Color.Red);
            }
            else OperateResult.AppendText(">>产品" + pr_code.Text + "未维护打印标签\n", Color.Red);
        }

        //加载工单信息和装箱明细信息
        private void pa_code_KeyDown(object sender, KeyEventArgs e)
        {
            //try
            //{
            if (e.KeyCode == Keys.Enter)
            {
                LoadData();
                LoadGridData();
                if (CheckOutBoxLength())
                {
                    sn_code.Focus();
                }
            }
            //}
            //catch (Exception ex)
            //{
            //    MessageBox.Show(ex.Message);
            //}
        }

        //输入序列号的回车事件
        private void barcode_KeyDown(object sender, KeyEventArgs e)
        {
            //当用户输入回车键的时候
            if (e.KeyCode == Keys.Enter)
            {
                if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out ErrorMessage))
                {
                    dt = (DataTable)dh.ExecuteSql("select ms_sncode from makeserial where ms_imei1='" + sn_code.Text + "' order by ms_id desc", "select");
                    if (dt.Rows.Count > 0)
                    {
                        sn_code.Text = dt.Rows[0]["ms_sncode"].ToString();
                    }
                    else
                    {
                        dt = (DataTable)dh.ExecuteSql("select ms_sncode from makeserial where ms_imei2='" + sn_code.Text + "' order by ms_id desc", "select");
                        if (dt.Rows.Count > 0)
                        {
                            sn_code.Text = dt.Rows[0]["ms_sncode"].ToString();
                        }
                        else
                        {
                            dt = (DataTable)dh.ExecuteSql("select mil_sncode from makeimeilist where mil_imei1='" + sn_code.Text + "' order by mil_id desc", "select");
                            if (dt.Rows.Count > 0)
                            {
                                sn_code.Text = dt.Rows[0]["mil_sncode"].ToString();
                            }
                            else
                            {
                                dt = (DataTable)dh.ExecuteSql("select mil_sncode from makeimeilist where mil_imei2='" + sn_code.Text + "' order by mil_id desc", "select");
                                if (dt.Rows.Count > 0)
                                {
                                    sn_code.Text = dt.Rows[0]["mil_sncode"].ToString();
                                }
                            }
                        }
                    }
                    dt = (DataTable)dh.ExecuteSql("select ms_status,ms_id,ms_makecode,ms_nextstepcode,ms_craftcode,ms_prodcode from makeserial where ms_sncode ='" + sn_code.Text + "' order by ms_id desc", "select");
                    if (LogicHandler.CheckStepSNAndMacode("", User.UserSourceCode, sn_code.Text, User.UserCode, out oMakeCode, out oMsID, out ErrorMessage) || (dt.Rows.Count > 0 && dt.Rows[0]["ms_status"].ToString() == "2"))
                    {
                        if (oMsID == "" || oMsID == "null" || oMsID == "0")
                        {
                            oMsID = dt.Rows[0]["ms_id"].ToString();
                            oMsStatus = dt.Rows[0]["ms_status"].ToString();
                            oMakeCode = dt.Rows[0]["ms_makecode"].ToString();
                        }
                        //如果是已完工序列号验证装箱工序是否存在于途程中
                        if (oMsStatus == "2")
                        {
                            string prodcode = dt.Rows[0]["ms_prodcode"].ToString();
                            string craftcode = dt.Rows[0]["ms_craftcode"].ToString();
                            string craftstepcode = dh.getFieldDataByCondition("craft left join craftdetail on cr_id =cd_crid", "(cd_stepcode)", "cr_prodcode='" + prodcode + "' and cr_code='" + craftcode + "' and cd_stepcode='" + User.CurrentStepCode + "'").ToString();
                            if (craftstepcode == "")
                            {
                                OperateResult.AppendText("工序" + User.CurrentStepCode + "不在途程" + craftcode + "内,不允许采集\n", Color.Red);
                                return;
                            }
                        }
                        string nextstepcode = dh.getFieldDataByCondition("makeserial", "ms_nextstepcode", "ms_id='" + oMsID + "'").ToString();
                        if (nextstepcode != "" && nextstepcode != User.CurrentStepCode)
                        {
                            OperateResult.AppendText("当前序列号下一道工序" + nextstepcode + ",当前资源不允许采集\n", Color.Red);
                            return;
                        }
                        PR_CHECKCARTONW = dh.getFieldDataByCondition("craftdetail left join craft on cr_id=cd_crid left join makeserial on ms_craftcode =cr_code and cr_prodcode = ms_prodcode", "nvl(cd_ifweigh,'0') cd_ifweigh", "ms_sncode='" + sn_code.Text + "' and ms_makecode='" + oMakeCode + "' and cd_stepcode = '" + User.CurrentStepCode + "'").ToString();
                        //获取序列号信息
                        sql.Clear();
                        sql.Append("select nvl(pr_Singlelevelqty,1)pr_Singlelevelqty,nvl(ms_iostatus,0) ms_iostatus,pr_code,pa_salecode,ms_salecode,ms_outno,ms_makecode,ms_prodcode,nvl(pa_downstatus,0) pa_downstatus,pa_sccode,pa_checkno,pr_packrule,");
                        sql.Append("nvl(pr_outboxinnerqty,0)pr_outboxinnerqty,nvl(pr_sendchecktype,'LineCode')pr_sendchecktype from makeserial left join product on ms_prodcode=pr_code left join packagedetail ");
                        sql.Append("on pd_barcode=ms_sncode left join package on pa_id =pd_paid where ms_id='" + oMsID + "'");
                        dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                        string ms_makecode = "";
                        string ms_prodcode = "";
                        string ms_iostatus = "";
                        string ms_outno = "";
                        string ms_salecode_text = "";
                        if (dt.Rows.Count > 0)
                        {
                            pr_code.Text = dt.Rows[0]["pr_code"].ToString();
                            pr_Singlelevelqty = dt.Rows[0]["pr_Singlelevelqty"].ToString();
                            StandardQTY = decimal.Parse(dt.Rows[0]["pr_outboxinnerqty"].ToString());
                            ms_makecode = dt.Rows[0]["ms_makecode"].ToString();
                            ms_prodcode = dt.Rows[0]["ms_prodcode"].ToString();
                            ms_iostatus = dt.Rows[0]["ms_iostatus"].ToString();
                            ms_outno = dt.Rows[0]["ms_outno"].ToString();
                            ms_salecode_text = dt.Rows[0]["ms_salecode"].ToString();
                            if (locksalecode.Checked && ms_salecode.Text != "" && ms_salecode.Text != ms_salecode_text)
                            {
                                OperateResult.AppendText(">>序列号" + sn_code.Text + "所属订单号" + ms_salecode_text + "与界面订单号" + ms_salecode.Text + "不同,无法采集\n", Color.Red, sn_code);
                                return;
                            }
                            BaseUtil.SetFormValue(this.Controls, dt);
                        }
                        if (dt.Rows[0]["ms_outno"].ToString() != "")
                        {
                            OperateResult.AppendText(">>序列号" + sn_code.Text + "已被出货单" + dt.Rows[0]["ms_outno"].ToString() + "采集，不允许操作\n", Color.Red, sn_code);
                            return;
                        }
                        if (dt.Rows[0]["ms_iostatus"].ToString() != "0")
                        {
                            OperateResult.AppendText(">>序列号" + sn_code.Text + "已入库不允许采集\n", Color.Red, sn_code);
                            return;
                        }
                        //保证箱内容量不会被重置
                        if (pa_standardqty.Text != "0" && pa_standardqty.Text != "")
                        {
                            pr_outboxinnerqty.Text = pa_standardqty.Text;
                        }
                        if (pa_outboxcode.Text == "")
                        {
                            string boxcode = dh.getFieldDataByCondition("makeserial", "ms_outboxcode", "ms_id='" + oMsID + "'").ToString();
                            //序列号存在箱号的情况下获取所有的装箱数据
                            if (boxcode != "")
                            {
                                pa_outboxcode.Text = boxcode;
                                pa_makecode.Text = "";
                                LoadGridData();
                            }
                            else
                            {
                                //如果勾选了自动生成箱号，在封箱或者首次
                                if (AutoGenBoxCode.Checked && (pa_status.Text == "1" || pa_status.Text == "" || pa_status.Text == "0"))
                                {
                                    pa_outboxcode.Text = LogicHandler.GetOutBoxCode("PACKAGE", ms_makecode, pr_code.Text, User.UserCode);
                                    LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, oMakeCode, User.UserLineCode, User.UserSourceCode, "卡通箱采集", "卡通箱" + pa_outboxcode.Text + "自动生成", sn_code.Text, PreFix.Text + ":" + OutBoxLength.Text);
                                }
                            }
                        }
                        if (pa_outboxcode.Text == "")
                        {
                            OperateResult.AppendText(">>箱号不能为空\n", Color.Red, sn_code);
                            return;
                        }
                        //判断箱内总数必须大于0
                        if (pr_outboxinnerqty.Text == "" || pr_outboxinnerqty.Text == "0")
                        {
                            OperateResult.AppendText(">>箱内容量必须大于0\n", Color.Red);
                            return;
                        }
                        sql.Clear();
                        sql.Append("select nvl(pa_iostatus,0)pa_iostatus,pa_outno,pa_mothercode,pa_type from package where pa_outboxcode='" + pa_outboxcode.Text + "'");
                        dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                        string MotherBoxCode = "";
                        if (dt.Rows.Count > 0)
                        {
                            if (dt.Rows[0]["pa_mothercode"].ToString() != "")
                            {
                                MotherBoxCode = dt.Rows[0]["pa_mothercode"].ToString();
                            }
                            if (dt.Rows[0]["pa_outno"].ToString() != "")
                            {
                                OperateResult.AppendText(">>卡通箱" + pa_outboxcode.Text + "已被出货单" + dt.Rows[0]["pa_outno"].ToString() + "采集，不允许操作\n", Color.Red, sn_code);
                                return;
                            }
                            if (dt.Rows[0]["pa_iostatus"].ToString() != "0")
                            {
                                OperateResult.AppendText(">>卡通箱" + pa_outboxcode.Text + "处于入库状态，不允许操作\n", Color.Red, sn_code);
                                return;
                            }
                        }
                        //如果未勾选了取消录入
                        if (!Cancel.Checked)
                        {
                            //判断序列号是否已经装箱
                            string ms_outboxcode = dh.getFieldDataByCondition("makeserial", "ms_outboxcode", "ms_id='" + oMsID + "'").ToString();
                            if (ms_outboxcode != "")
                            {
                                if (ms_outboxcode == pa_outboxcode.Text)
                                {
                                    OperateResult.AppendText(">>序列号" + sn_code.Text + "已在本箱内\n", Color.Red, sn_code);
                                }
                                else
                                {
                                    OperateResult.AppendText(">>序列号" + sn_code.Text + "已采集至箱" + ms_outboxcode + "\n", Color.Red, sn_code);
                                }
                                LoadData();
                            }
                            else
                            {
                                //满箱之后采集下一个之前自动清除内容，生成新的箱号
                                if ((AutoGenBoxCode.Checked && pa_currentqty.Text != "" && pr_outboxinnerqty.Text == pa_currentqty.Text) || (AutoGenBoxCode.Checked && pa_status.Text == "1"))
                                {
                                    pa_currentqty.Text = "";
                                    pa_outboxcode.Text = "";
                                    pa_status.Text = "0";
                                    BaseUtil.CleanDGVData(PackageDetail);
                                    pa_outboxcode.Text = LogicHandler.GetOutBoxCode("PACKAGE", ms_makecode, pr_code.Text, User.UserCode);
                                    LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, oMakeCode, User.UserLineCode, User.UserSourceCode, "卡通箱采集", "卡通箱" + pa_outboxcode.Text + "自动生成", sn_code.Text, PreFix.Text + ":" + OutBoxLength.Text);
                                }
                                if (!CheckOutBoxLength(ms_salecode_text))
                                {
                                    return;
                                }
                                ////箱号不存在的情况
                                if (!CheckRow())
                                {
                                    OperateResult.AppendText(">>采集后层数超出，不允许采集\n", Color.Red);
                                    return;
                                }
                                if (LogicHandler.Packing_Pallet(sn_code.Text, pa_outboxcode.Text, AutoGenBoxCode.Checked, "标准", User.UserSourceCode, User.UserCode, pr_outboxinnerqty.Text, Cancel.Checked, out oOutBoxCode, out ErrorMessage))
                                {
                                    //提示正确返回时传递的信息
                                    if (ErrorMessage.Contains("AFTERSUCCESS"))
                                        OperateResult.AppendText(">>" + ErrorMessage + "\n");
                                    LastSncode = sn_code.Text;
                                    OperateResult.AppendText(">>序列号" + sn_code.Text + "采集成功！\n", Color.Green);

                                    RefreshWeight();
                                    LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, oMakeCode, User.UserLineCode, User.UserSourceCode, "卡通箱采集", "卡通箱" + pa_outboxcode.Text + "采集成功", sn_code.Text, "");
                                    //满箱更新状态为1
                                    LoadData();
                                    LoadGridData();
                                    LoadCheckQTY();
                                    dh.ExecuteSql("update packagedetail set pd_innerqty=(select pa_packageqty from package where pa_outboxcode='" + pa_outboxcode.Text + "') where pd_innerboxcode='" + pa_outboxcode.Text + "'", "update");
                                    if (MotherBoxCode != "")
                                    {
                                        dt = (DataTable)dh.ExecuteSql("select pa_mothercode,pa_type from package where pa_outboxcode='" + MotherBoxCode + "'", "select");
                                        //如果母箱号不为空，需要更新总数
                                        if (dt.Rows.Count > 0)
                                        {
                                            if (dt.Rows[0]["pa_type"].ToString() == "2")
                                            {
                                                string MotherCode2 = dt.Rows[0]["pa_mothercode"].ToString();
                                                //更新大箱数量
                                                dh.ExecuteSql("update package set PA_TOTALQTY=(select sum(pd_innerqty) from packagedetail left join package on pa_id=pd_paid where pa_outboxcode='" + MotherBoxCode + "') where pa_outboxcode='" + MotherBoxCode + "'", "update");
                                                //外层有栈板则更新栈板数量
                                                if (MotherCode2 != "")
                                                {
                                                    dh.ExecuteSql("update packagedetail set pd_innerqty=(select sum(pd_innerqty) from packagedetail where pd_outboxcode='" + MotherBoxCode + "') where pd_innerboxcode='" + MotherBoxCode + "'", "update");
                                                    dh.ExecuteSql("update package set PA_TOTALQTY=(select sum(pd_innerqty) from packagedetail left join package on pa_id=pd_paid where pa_outboxcode='" + MotherCode2 + "') where pa_outboxcode='" + MotherCode2 + "'", "update");
                                                }
                                            }
                                            if (dt.Rows[0]["pa_type"].ToString() == "3")
                                            {
                                                dh.ExecuteSql("update package set PA_TOTALQTY=(select sum(pd_innerqty) from packagedetail left join package on pa_id=pd_paid where pa_outboxcode='" + MotherBoxCode + "') where pa_outboxcode='" + MotherBoxCode + "'", "update");
                                            }
                                        }
                                    }
                                    //采集完后如果是第一个装的序列号，把序列号的NextStepCode赋值给箱号
                                    if (pa_currentqty.Text == "1")
                                    {
                                        dh.UpdateByCondition("package", "pa_nextstep='" + User.CurrentStepCode + "', PA_CURRENTSTEP = '" + User.CurrentStepCode + "'", "pa_outboxcode='" + pa_outboxcode.Text + "'");
                                    }
                                    if (int.Parse(pa_currentqty.Text == "" ? "0" : pa_currentqty.Text) == int.Parse(pr_outboxinnerqty.Text))
                                    {
                                        double ActualWeight = double.Parse(weight.Text == "" ? "0" : weight.Text.Replace("kg", "").Replace("g", "").Trim());
                                        double palletWeightErrorValue = double.Parse(dh.GetConfig("palletWeightErrorValue", "MESSetting").ToString());
                                        double totalweight = double.Parse(sumpalletweight.Text);

                                        if (palletWeightErrorValue == 0)
                                        {
                                            OperateResult.AppendText(">>产品" + pr_code.Text + "未维护栈板偏差值\n", Color.Red);
                                            return;
                                        }
                                        if ((ActualWeight >= totalweight - palletWeightErrorValue) && (ActualWeight <= totalweight + palletWeightErrorValue))
                                        {
                                            OperateResult.AppendText(">>栈板" + pa_outboxcode.Text + "重量检测检测合格\n", Color.Green);
                                            LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_makecode, User.UserLineCode, User.UserSourceCode, "栈板称重:" + weight.Text, "称量合格", pa_outboxcode.Text, "");
                                            LogicHandler.RecordProdWeight(pa_outboxcode.Text, "SN", float.Parse(ActualWeight.ToString()), "kg", User.UserLineCode, pr_code.Text, User.UserSourceCode, User.UserName);
                                            dh.ExecuteSql("update package set PA_WEIGHT='" + ActualWeight + "',pa_roundweight=round('" + ActualWeight + "') where pa_outboxcode='" + pa_outboxcode.Text + "'", "update");
                                        }
                                        else
                                        {
                                            OperateResult.AppendText(">>栈板" + pa_outboxcode.Text + "重量检测未通过\n", Color.Red);
                                            LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_makecode, User.UserLineCode, User.UserSourceCode, "栈板称重:" + weight.Text, "称量不合格", pa_outboxcode.Text, "");
                                            LogicHandler.RecordProdWeight(pa_outboxcode.Text, "SN", float.Parse(ActualWeight.ToString()), "kg", User.UserLineCode, pr_code.Text, User.UserSourceCode, User.UserName);
                                            return;
                                        }

                                        if (dh.getFieldDataByCondition("package", "PA_PALLETNO", "pa_outboxcode='" + pa_outboxcode.Text + "'").ToString() == "")
                                        {
                                            OperateResult.AppendText(">>卡通箱" + pa_outboxcode.Text + "未绑定卡板号，不允许封箱\n", Color.Black, sn_code);
                                            return;
                                        }
                                        dh.UpdateByCondition("package", "pa_status=1,pa_packageqty=pa_currentqty,pa_totalqty=pa_currentqty", "pa_outboxcode='" + pa_outboxcode.Text + "'");
                                        OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "满箱采集完成，封箱成功\n", Color.Green);
                                        pa_status.Text = "1";
                                        pa_standardqty.Text = "";
                                        if (AutoPrint.Checked)
                                            Print_Click(new object(), new EventArgs());
                                        pa_remark.SelectAll();
                                        pa_remark.Focus();
                                        if (LogicHandler.OutBoxStepPass(pa_outboxcode.Text, ms_makecode, User.UserSourceCode, User.UserCode, "卡通箱:" + pa_outboxcode.Text + "整箱过站", "卡通箱整箱过站", out ErrorMessage))
                                        {
                                            dh.UpdateByCondition("package", "pa_nextstep='" + dh.getFieldDataByCondition("packagedetail left join makeserial on ms_sncode=pd_barcode and ms_makecode=pd_makecode", "max(ms_nextstepcode)", "pd_outboxcode='" + pa_outboxcode.Text + "'").ToString() + "', PA_CURRENTSTEP = '' ", "pa_outboxcode='" + pa_outboxcode.Text + "'");
                                        }
                                        else
                                        {
                                            OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
                                        }
                                        LoadCollectedNum();
                                        LoadCheckQTY();
                                    }
                                    sn_code.Clear();
                                }
                                else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, sn_code);
                            }
                        }
                        //勾选了取消箱号先验证箱号存不存在，存在的话移除掉，重新加载一次数据
                        else
                        {
                            if (LogicHandler.Packing_Pallet(sn_code.Text, pa_outboxcode.Text, AutoGenBoxCode.Checked, "标准", User.UserSourceCode, User.UserCode, pr_outboxinnerqty.Text, Cancel.Checked, out oOutBoxCode, out ErrorMessage))
                            {
                                RefreshWeight();
                                dh.UpdateByCondition("makeserial", "ms_outboxcode=''", "ms_id='" + oMsID + "'");
                                dh.ExecuteSql("update packagedetail set pd_innerqty=(select pa_packageqty from package where pa_outboxcode='" + pa_outboxcode.Text + "') where pd_innerboxcode='" + pa_outboxcode.Text + "'", "update");
                                //如果母箱号不为空，需要更新总数
                                if (MotherBoxCode != "")
                                {
                                    DataTable dt = (DataTable)dh.ExecuteSql("select pa_mothercode,pa_type from package where pa_outboxcode='" + MotherBoxCode + "'", "select");
                                    if (dt.Rows.Count > 0)
                                    {
                                        if (dt.Rows[0]["pa_type"].ToString() == "2")
                                        {
                                            string MotherCode2 = dt.Rows[0]["pa_mothercode"].ToString();
                                            //更新大箱数量
                                            dh.ExecuteSql("update package set PA_TOTALQTY=(select sum(pd_innerqty) from packagedetail left join package on pa_id=pd_paid where pa_outboxcode='" + MotherBoxCode + "') where pa_outboxcode='" + MotherBoxCode + "'", "update");
                                            //外层有栈板则更新栈板数量
                                            if (MotherCode2 != "")
                                            {
                                                dh.ExecuteSql("update packagedetail set pd_innerqty=(select sum(pd_innerqty) from packagedetail where pd_outboxcode='" + MotherBoxCode + "') where pd_innerboxcode='" + MotherBoxCode + "'", "update");
                                                dh.ExecuteSql("update package set PA_TOTALQTY=(select sum(pd_innerqty) from packagedetail left join package on pa_id=pd_paid where pa_outboxcode='" + MotherCode2 + "') where pa_outboxcode='" + MotherCode2 + "'", "update");
                                            }
                                        }
                                        if (dt.Rows[0]["pa_type"].ToString() == "3")
                                        {
                                            dh.ExecuteSql("update package set PA_TOTALQTY=(select sum(pd_innerqty) from packagedetail left join package on pa_id=pd_paid where pa_outboxcode='" + MotherBoxCode + "') where pa_outboxcode='" + MotherBoxCode + "'", "update");
                                        }
                                    }
                                }
                                LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, oMakeCode, User.UserLineCode, User.UserSourceCode, "卡通箱采集", "卡通箱" + pa_outboxcode.Text + "取消采集成功", sn_code.Text, "");
                                LoadGridData();
                                pa_status.Text = "0";
                                OperateResult.AppendText(">>已从该箱中移除序列号" + sn_code.Text + "\n", Color.Green, sn_code);
                            }
                            else
                            {
                                OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, sn_code);
                            }
                        }
                    }
                    else
                    {
                        OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, sn_code);
                    }
                }
                else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, sn_code);
            }
        }

        private void Clean_Click(object sender, EventArgs e)
        {
            OperateResult.Clear();
        }
        DataTable _dt;
        private void pr_code_TextChanged(object sender, EventArgs e)
        {
            LoadCheckQTY();
            _dt = (DataTable)dh.ExecuteSql("select la_id,la_url,la_isdefault from label where la_prodcode='" + pr_code.Text + "' and la_templatetype='栈板标' and la_statuscode='AUDITED' order by la_isdefault", "select");
            if (_dt.Rows.Count == 0)
            {
                _dt = (DataTable)dh.ExecuteSql("select la_id,la_url,la_isdefault from label where la_prodcode is null and la_templatetype='栈板标' and la_statuscode='AUDITED' order by la_isdefault", "select");
            }
            PrintLabel.DataSource = _dt;
            PrintLabel.DisplayMember = "la_url";
            PrintLabel.ValueMember = "la_id";

            PrintLabel1.DataSource = _dt.Copy();
            PrintLabel1.DisplayMember = "la_url";
            PrintLabel1.ValueMember = "la_id";

            PrintLabel2.DataSource = _dt.Copy();
            PrintLabel2.DisplayMember = "la_url";
            PrintLabel2.ValueMember = "la_id";
        }

        private void PackCollection_FormClosing(object sender, FormClosingEventArgs e)
        {
            //BaseUtil.ClosePrint(lbl);
            if (serialPort1.IsOpen)
            {
                GetData = false;
                serialPort1.Close();
                SystemInf.OpenPort.Remove(serialPort1.PortName);
                thread.Abort();
            }
            dh.Dispose();
        }

        private void Packing_Click(object sender, EventArgs e)
        {
            if (dh.CheckExist("package", "pa_outboxcode='" + pa_outboxcode.Text + "' and nvl(pa_status,0)=0"))
            {
                if (dh.getFieldDataByCondition("package", "PA_PALLETNO", "pa_outboxcode='" + pa_outboxcode.Text + "'").ToString() == "")
                {
                    OperateResult.AppendText(">>卡通箱" + pa_outboxcode.Text + "未绑定卡板号，不允许封箱\n", Color.Black, sn_code);
                    return;
                }
                string Seal = MessageBox.Show(this.ParentForm, "是否确认封箱？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
                if (Seal == "Yes")
                {
                    OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "采集完成，手动封箱成功\n", Color.Green);
                    dh.UpdateByCondition("package", "pa_status=1,pa_totalqty=pa_currentqty,pa_packageqty=pa_currentqty", "pa_outboxcode='" + pa_outboxcode.Text + "'");
                    pa_status.Text = "1";
                    pa_standardqty.Text = "";
                    LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, pa_makecode.Text, User.UserLineCode, User.UserSourceCode, "装箱采集", "卡通箱" + pa_outboxcode.Text + "封箱成功", pa_outboxcode.Text, "");
                    pa_remark.SelectAll();
                    pa_remark.Focus();
                    if (PR_CHECKCARTONW != "0")
                    {
                        OperateResult.AppendText(">>卡通箱" + pa_outboxcode.Text + "处于称重工序，请在卡通箱称重界面进行操作\n", Color.Black, sn_code);
                        return;
                    }
                    string ms_makecode = dh.getFieldDataByCondition("packagedetail", "pd_makecode", "pd_outboxcode = '" + pa_outboxcode.Text + "'").ToString();
                    if (LogicHandler.OutBoxStepPass(pa_outboxcode.Text, ms_makecode, User.UserSourceCode, User.UserCode, "卡通箱:" + pa_outboxcode.Text + "整箱过站", "卡通箱整箱过站", out ErrorMessage))
                    {
                        dh.UpdateByCondition("package", "pa_nextstep='" + dh.getFieldDataByCondition("packagedetail left join makeserial on ms_sncode=pd_barcode and ms_makecode=pd_makecode", "max(ms_nextstepcode)", "pd_outboxcode='" + pa_outboxcode.Text + "'").ToString() + "', PA_CURRENTSTEP = '' ", "pa_outboxcode='" + pa_outboxcode.Text + "'");
                    }
                    else
                    {
                        OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
                    }
                    LoadCheckQTY();
                }
            }
            else OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "错误或者已封箱\n", Color.Red);
        }

        private void SendCheck_Click(object sender, EventArgs e)
        {
            if (dh.getFieldDataByCondition("package", "pa_status", "pa_outboxcode='" + pa_outboxcode.Text + "'").ToString() == "1")
            {
                DataTable dt = (DataTable)dh.ExecuteSql("select wm_concat(pa_outboxcode) pa_outboxcode from package where pa_checkno='" + ob_checkno.Text + "' and pa_status=0 ", "select");
                if (dt.Rows[0][0].ToString() != "")
                {
                    OperateResult.AppendText(">>批次" + ob_checkno.Text + "存在箱号" + dt.Rows[0][0].ToString() + "未封箱，请先进行封箱\n", Color.Red);
                    return;
                }
                sql.Clear();
                sql.Append("update oqcbatch set ob_status='UNCHECK',ob_breakingdate=sysdate where ob_checkno ='" + ob_checkno.Text + "'");
                dh.ExecuteSql(sql.GetString(), "select");
                ob_nowcheckqty.Text = "";
                ob_batchqty.Text = "";
                ob_nowcheckqty.ForeColor = Color.Black;
                SendCheck.Enabled = false;
                OperateResult.AppendText(">>批次" + ob_checkno.Text + "送检成功\n", Color.Green);
                LogicHandler.InsertMakeProcess(LastSncode, oMakeCode, User.UserSourceCode, "手动送检", "手动送检成功", User.UserCode);
                //记录操作日志
                LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, pa_makecode.Text, User.UserLineCode, User.UserSourceCode, "手动送检", "手动送检成功", "", ob_checkno.Text);
                ob_checkno.Text = "";
            }
            else OperateResult.AppendText(">>必须封箱才能送检\n", Color.Red);
        }

        bool AutoCut;

        private void LoadCheckQTY()
        {
            sql.Clear();
            string condition = "";
            int nowcheckqty = int.Parse(ob_nowcheckqty.Text == "" ? "0" : ob_nowcheckqty.Text);
            int batchqty = int.Parse(ob_batchqty.Text == "" ? "0" : ob_batchqty.Text);
            if (nowcheckqty + 1 == batchqty && AutoCut)
            {
                condition = "and ob_status='UNCHECK' and ob_checkno='" + ob_checkno.Text + "'";
            }
            else
            {
                condition = "and ob_status='ENTERING' ";
            }
            if (pr_sendchecktype.Text == "SaleCode")
            {
                condition += " and ob_salecode='" + ms_salecode.Text + "'";
            }
            sql.Append("select ob_batchqty,ob_nowcheckqty,ob_checkno from oqcbatch where ");
            sql.Append("ob_linecode='" + User.UserLineCode + "' and ob_prodcode='" + pr_code.Text + "' and ");
            sql.Append("ob_stepcode='" + User.CurrentStepCode + "' " + condition);
            DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            if (dt.Rows.Count > 0)
            {
                ob_batchqty.Text = dt.Rows[0]["ob_batchqty"].ToString();
                ob_nowcheckqty.Text = dt.Rows[0]["ob_nowcheckqty"].ToString();
                ob_checkno.Text = dt.Rows[0]["ob_checkno"].ToString();
                nowcheckqty = int.Parse(ob_nowcheckqty.Text == "" ? "0" : ob_nowcheckqty.Text);
                batchqty = int.Parse(ob_batchqty.Text == "" ? "0" : ob_batchqty.Text);
                if (nowcheckqty >= batchqty)
                {
                    ob_nowcheckqty.ForeColor = Color.Red;
                    OperateResult.AppendText(">>当前采集数量已达到送检数量\n", Color.Red);
                    if (AutoCut)
                    {
                        OperateResult.AppendText(">>批次" + ob_checkno.Text + "自动断批\n", Color.Green);
                    }
                }
            }
            else
            {
                ob_batchqty.Text = "";
                ob_nowcheckqty.Text = "";
                ob_checkno.Text = "";
                SendCheck.Enabled = false;
            }
            if (ob_batchqty.Text != "" && PR_CHECKCARTONW == "0")
            {
                SendCheck.Enabled = true;
            }
            else
            {
                SendCheck.Enabled = false;
            }
        }

        private void ob_checkno_TextChanged(object sender, EventArgs e)
        {
            if (ob_checkno.Text != "")
            {
                string Cut = dh.getFieldDataByCondition("product left join oqcbatch on ob_prodcode=pr_code", "pr_ifautocutcheckno", "ob_checkno='" + ob_checkno.Text + "'").ToString();
                if (Cut == "" || Cut == "0")
                    AutoCut = false;
                else
                    AutoCut = true;
                SendCheck.Enabled = true;
            }
        }

        //private void pr_outboxinnerqty_KeyDown(object sender, KeyEventArgs e)
        //{
        //    if (e.KeyCode == Keys.Enter)
        //        ResetPackQTY();
        //}

        //private void pr_outboxinnerqty_Leave(object sender, EventArgs e)
        //{
        //    ResetPackQTY();
        //}

        //private void ResetPackQTY()
        //{
        //    //数据不符合限制的时候保持原有值
        //    int curretnqty = int.Parse(pa_currentqty.Text == "" ? "0" : pa_currentqty.Text);
        //    if (!(int.Parse(pr_outboxinnerqty.Text) >= curretnqty))
        //    {
        //        pr_outboxinnerqty.Text = StandardQTY.ToString();
        //    }
        //    else
        //    {
        //        if (dh.CheckExist("package", "pa_outboxcode='" + pa_outboxcode.Text + "'"))
        //        {
        //            string checknostatus = dh.getFieldDataByCondition("oqcbatch", "ob_status", "ob_checkno='" + pa_checkno.Text + "'").ToString();
        //            if (checknostatus == "" || checknostatus == "ENTERING")
        //            {
        //                if (pa_downstatus.Text == "0")
        //                {
        //                    if (dh.CheckExist("source", "sc_code='" + pa_sccode.Text + "' and  sc_stepcode='" + User.CurrentStepCode + "'"))
        //                    {
        //                        dh.UpdateByCondition("package", "pa_standardqty='" + pr_outboxinnerqty.Text + "'", "pa_outboxcode='" + pa_outboxcode.Text + "'");
        //                        LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, "", User.UserLineCode, User.UserSourceCode, "修改箱内容量", "原容量" + StandardQTY + ",修改为" + pr_outboxinnerqty.Text + "'", pa_outboxcode.Text, pa_checkno.Text);
        //                        return;
        //                    }
        //                    else
        //                        OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "当前所在工序不是登录岗位资源所在工序，不允许修改数量\n", Color.Red);
        //                }
        //                else
        //                    OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "处于下地状态，不允许修改标准容量\n", Color.Red);
        //            }
        //            else
        //                OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "处于送检中，不允许修改标准容量\n", Color.Red);
        //        }
        //        else
        //            OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "不存在,修改容量无效\n", Color.Red);
        //        pr_outboxinnerqty.Text = StandardQTY.ToString();
        //    }
        //}

        private void PrintLabel_SelectedValueChanged(object sender, EventArgs e)
        {
            if (PrintLabel.SelectedValue != null && PrintLabel.SelectedValue.ToString() != "System.Data.DataRowView")
            {
                string PrintNums = dh.getFieldDataByCondition("label", "la_printnos", "la_id='" + PrintLabel.SelectedValue.ToString() + "'").ToString();
                PrintNum.Text = (PrintNums == "" ? "1" : PrintNums);
            }
        }

        private void DeleteAll_Click(object sender, EventArgs e)
        {
            if (pa_outboxcode.Text == "")
            {
                OperateResult.AppendText(">>箱号不能为空\n", Color.Red);
                return;
            }
            string Delete = MessageBox.Show(this.ParentForm, "是否确认拆箱？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
            if (Delete == "Yes")
            {
                DataTable dt = (DataTable)dh.ExecuteSql("select nvl(pa_iostatus,0)pa_iostatus,pa_type,pa_outno,pa_checkno,ob_status,pa_mothercode,nvl(pa_downstatus,0)pa_downstatus from package left join oqcbatch on pa_checkno=ob_checkno where pa_outboxcode='" + pa_outboxcode.Text + "'", "select");
                if (dt.Rows.Count > 0)
                {
                    if (dt.Rows[0]["pa_outno"].ToString() != "")
                    {
                        OperateResult.AppendText(">>栈板" + pa_outboxcode.Text + "已被出货单" + dt.Rows[0]["pa_outno"].ToString() + "采集，不允许操作\n", Color.Red);
                        return;
                    }
                    if (dt.Rows[0]["pa_iostatus"].ToString() != "0")
                    {
                        OperateResult.AppendText(">>栈板" + pa_outboxcode.Text + "处于入库状态，不允许操作\n", Color.Red);
                        return;
                    }
                    if (dt.Rows[0]["pa_type"].ToString() != "3")
                    {
                        OperateResult.AppendText(">>非栈板类型不允许操作\n", Color.Red);
                        return;
                    }
                    if (dt.Rows[0]["pa_mothercode"].ToString() == "")
                    {
                        if (dt.Rows[0]["pa_downstatus"].ToString() == "0")
                        {
                            string ob_status = dt.Rows[0]["ob_status"].ToString();
                            string pa_checkno = dt.Rows[0]["pa_checkno"].ToString();
                            //不存在抽检批次或者还未检验可以拆解
                            if (ob_status == "" || ob_status == "ENTERING" || ob_status == "UNCHECK")
                            {
                                sql.Clear();
                                sql.Append("select pd_makecode,count(1) num from packagedetail left join makeserial  ");
                                sql.Append("on ms_sncode=pd_barcode and ms_makecode=pd_makecode where pd_outboxcode='" + pa_outboxcode.Text + "' group by pd_makecode");
                                dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                                List<string> SQLS1 = new List<string>();
                                for (int i = 0; i < dt.Rows.Count; i++)
                                {
                                    string ma_code = dt.Rows[i]["pd_makecode"].ToString();
                                    string num = dt.Rows[i]["num"].ToString();
                                    SQLS1.Add("delete from makeprocess where mp_sncode in (select ms_sncode from makeserial where ms_outboxcode='" + pa_outboxcode.Text + "' and ms_makecode='" + ma_code + "') and mp_makecode='" + ma_code + "' and mp_stepcode='" + User.CurrentStepCode + "'");
                                    SQLS1.Add("delete from steppassed where sp_sncode in (select ms_sncode from makeserial where ms_outboxcode='" + pa_outboxcode.Text + "' and ms_makecode='" + ma_code + "') and sp_makecode='" + ma_code + "' and sp_stepcode='" + User.CurrentStepCode + "'");
                                    SQLS1.Add("update makecraftdetail set mcd_inqty=mcd_inqty-" + num + ",mcd_outqty=mcd_outqty-" + num + ",mcd_okqty=mcd_okqty-" + num + " where mcd_macode='" + ma_code + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
                                    //扣减已完工数
                                    SQLS1.Add("update make set ma_endqty=ma_endqty-(select count(1) from makeserial where  ms_outboxcode='" + pa_outboxcode.Text + "' and ms_makecode='" + ma_code + "' and ms_status=2) where ma_code='" + ma_code + "'");
                                }
                                if (pa_checkno != "")
                                {
                                    SQLS1.Add("update makeserial set ms_checkno='' where ms_outboxcode='" + pa_outboxcode.Text + "'");
                                    SQLS1.Add("update oqcbatch set ob_nowcheckqty=ob_nowcheckqty-(select count(1) from oqcbatchdetail where obd_outboxcode='" + pa_outboxcode.Text + "') where ob_checkno='" + pa_checkno + "'");
                                    SQLS1.Add("delete from oqcbatchdetail where obd_outboxcode='" + pa_outboxcode.Text + "'");
                                }
                                //更新序列号状态
                                SQLS1.Add("update makeserial set ms_status=1,ms_outboxcode='',ms_nextstepcode= (case when ms_nextstepcode='" + User.CurrentStepCode + "' then ms_nextstepcode else ms_stepcode end ),ms_paststep=replace(ms_paststep,'," + User.CurrentStepCode + "','') where ms_outboxcode='" + pa_outboxcode.Text + "'");
                                //抽检批次不为空的时候进行移除
                                dh.ExecuteSQLTran(SQLS1.ToArray());
                                string prcode = dh.getFieldDataByCondition("packagedetail", "pd_prodcode", "pd_outboxcode = '" + pa_outboxcode.Text + "'").ToString();
                                string standqty = dh.getFieldDataByCondition("product", "pr_outboxinnerqty", "pr_code = '" + prcode + "'").ToString();
                                if (standqty != "")
                                {
                                    //置空原箱
                                    dh.ExecuteSql("update package set pa_checkno='',pa_prodcode='',pa_packtype='',pa_salecode='',pa_packageqty=0,pa_totalqty=0,pa_currentqty=0,pa_status=0,PA_STANDARDQTY = '" + standqty + "' where pa_outboxcode='" + pa_outboxcode.Text + "'", "update");
                                }
                                else
                                    //置空原箱
                                    dh.ExecuteSql("update package set pa_checkno='',pa_prodcode='',pa_packtype='',pa_salecode='',pa_packageqty=0,pa_totalqty=0,pa_currentqty=0,pa_status=0 where pa_outboxcode='" + pa_outboxcode.Text + "'", "update");
                                pa_status.Text = "0";
                                //删除箱的明细
                                dh.ExecuteSql("delete from packagedetail where pd_outboxcode='" + pa_outboxcode.Text + "'", "delete");
                                LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, pa_makecode.Text, User.UserLineCode, User.UserSourceCode, "栈板拆解", "成功", pa_outboxcode.Text, ob_checkno.Text);
                                OperateResult.AppendText(">>栈板" + pa_outboxcode.Text + "成功拆解!\n", Color.Green);
                                LoadGridData();
                                LoadCheckQTY();
                            }
                            else OperateResult.AppendText(">>栈板" + pa_outboxcode.Text + "已送检,不允许解除\n", Color.Red);
                        }
                        else OperateResult.AppendText(">>栈板" + pa_outboxcode.Text + "已下地,不允许解除\n", Color.Red);
                    }
                    else OperateResult.AppendText(">>栈板" + pa_outboxcode.Text + "已装箱" + dt.Rows[0]["pa_mothercode"].ToString() + ",不允许解除\n", Color.Red);
                }
                else OperateResult.AppendText(">>栈板" + pa_outboxcode.Text + "不存在\n", Color.Red);
            }
        }

        private void OutBoxLength_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                try
                {
                    if (OutBoxLength.Text != "")
                    {
                        int.Parse(OutBoxLength.Text);
                    }
                    BaseUtil.SetCacheData("OutBoxLength", OutBoxLength.Text);
                    if (!AutoGenBoxCode.Checked)
                    {
                        pa_outboxcode.SelectAll();
                        pa_outboxcode.Focus();
                    }
                    else
                    {
                        sn_code.Focus();
                    }
                }
                catch (Exception)
                {
                    OutBoxLength.Clear();
                    MessageBox.Show("请输入正确的长度");
                }
            }
        }

        private bool CheckOutBoxLength()
        {
            //勾选了检验长度进行校验
            if (OutBoxLength.Text != "")
            {
                try
                {
                    int.Parse(OutBoxLength.Text);
                }
                catch (Exception)
                {
                    MessageBox.Show("请填写正确的箱号长度");
                    return false;
                }
                if (pa_outboxcode.Text.Length != int.Parse(OutBoxLength.Text))
                {
                    OperateResult.AppendText(">>箱号长度错误，请重新输入箱号\n", Color.Red);
                    return false;
                }
            }
            if (PreFix.Text != "")
            {
                try
                {
                    if (pa_outboxcode.Text.Substring(0, PreFix.Text.Length) != PreFix.Text)
                    {
                        OperateResult.AppendText(">>箱号前缀不匹配，请重新输入箱号\n", Color.Red);
                        return false;
                    }
                }
                catch (Exception)
                {
                    OperateResult.AppendText(">>箱号前缀不匹配，请重新输入箱号\n", Color.Red);
                    return false;
                }
            }
            return true;
        }

        private void LoadCollectedNum()
        {
            dt = (DataTable)dh.ExecuteSql("select mcd_inqty,ma_qty-mcd_inqty mcd_remainqty from make left join makecraftdetail on mcd_macode=ma_code where ma_code='" + ms_makecode.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'", "select");
            BaseUtil.SetFormValue(Controls, dt);
        }

        private void pa_remark_KeyDown(object sender, KeyEventArgs e)
        {
            if (Keys.Enter == e.KeyCode)
            {
                if (dh.CheckExist("package", "pa_outboxcode='" + pa_outboxcode.Text + "'"))
                {
                    dh.UpdateByCondition("package", "pa_remark='" + pa_remark.Text.ToUpper() + "'", "pa_outboxcode='" + pa_outboxcode.Text + "'");
                    OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "关联信息" + pa_remark.Text + "采集成功\n", Color.Green);
                    pa_remark.Text = "";
                    if (!AutoGenBoxCode.Checked)
                    {
                        pa_outboxcode.SelectAll();
                        pa_outboxcode.Focus();
                    }
                    else
                    {
                        sn_code.Focus();
                    }
                }
                else OperateResult.AppendText(">>请先采集箱内数据\n", Color.Red);
            }
        }

        private void PreFix_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                BaseUtil.SetCacheData("PreFix", PreFix.Text);
                if (!AutoGenBoxCode.Checked)
                {
                    pa_outboxcode.SelectAll();
                    pa_outboxcode.Focus();
                }
                else
                {
                    sn_code.Focus();
                    sn_code.SelectAll();
                }
            }
        }

        private bool CheckRow()
        {
            int packageqty = dh.getRowCount("makeserial", "ms_outboxcode='" + pa_outboxcode.Text + "'") + 1;
            string pc_level = dh.getFieldDataByCondition("product left join PRODUCTCONSUMABLES on pc_prid=pr_id", "nvl(max(pc_level),0)", "pr_code='" + pr_code.Text + "'").ToString();
            int rowcount = 0;
            if (packageqty % int.Parse(pr_Singlelevelqty) == 0)
            {
                rowcount = packageqty / int.Parse(pr_Singlelevelqty);
            }
            else
            {
                rowcount = packageqty / int.Parse(pr_Singlelevelqty) + 1;
            }
            if (int.Parse(pc_level) < rowcount)
            {
                return false;
            }
            return true;
        }

        private string RefreshWeight()
        {
            string boxweight = dh.getFieldDataByCondition("makeserial", "nvl(sum(MS_MIDBOXWEIGHT),0)", "ms_outboxcode='" + pa_outboxcode.Text + "'").ToString();
            string pr_Singlelevelqty = dh.getFieldDataByCondition("makeserial left join product on ms_prodcode=pr_code", "nvl(pr_Singlelevelqty,1)", "ms_outboxcode='" + pa_outboxcode.Text + "'").ToString();
            string palletweight = dh.getFieldDataByCondition("pallet", "nvl(PL_WEIGHT,0)", "PL_CODE=(select PA_PALLETNO from package where pa_outboxcode='" + pa_outboxcode.Text + "')").ToString();
            sumpalletweight.Text = (double.Parse(boxweight)).ToString();
            int packageqty = dh.getRowCount("makeserial", "ms_outboxcode='" + pa_outboxcode.Text + "'");
            pr_Singlelevelqty = pr_Singlelevelqty == "" ? "1" : pr_Singlelevelqty;
            //根据单层装的数量，自动计算栈板装的层数
            int rowcount = 0;
            if (packageqty % int.Parse(pr_Singlelevelqty) == 0)
            {
                rowcount = packageqty / int.Parse(pr_Singlelevelqty);
            }
            else
            {
                rowcount = packageqty / int.Parse(pr_Singlelevelqty) + 1;
            }
            //获取维护的层数信息
            DataTable dt = (DataTable)dh.ExecuteSql("select nvl(pc_level,0)pc_level,nvl(pc_weight,0)pc_weight from product left join PRODUCTCONSUMABLES on pc_prid=pr_id where pr_code='" + pr_code.Text + "' order by pc_level ", "select");
            if (dt.Rows.Count > 0)
            {
                string pc_level = dt.Rows[dt.Rows.Count - 1]["pc_level"].ToString();
                if (int.Parse(pc_level) < rowcount)
                {
                    return "栈板维护最大层数" + pc_level + ",超出层数不允许采集";
                }
                double attach_weight = 0;
                for (int i = 0; i < rowcount; i++)
                {
                    if (rowcount == i + 1)
                    {
                        //如果当前层满层了
                        if (packageqty % int.Parse(pr_Singlelevelqty) == 0)
                        {
                            attach_weight += (int.Parse(pr_Singlelevelqty)) * double.Parse(dt.Rows[i]["pc_weight"].ToString());
                        }
                        //没满层的话
                        else
                        {
                            attach_weight += (packageqty % int.Parse(pr_Singlelevelqty)) * double.Parse(dt.Rows[i]["pc_weight"].ToString());
                        }
                    }
                    else
                    {
                        attach_weight += (int.Parse(pr_Singlelevelqty)) * double.Parse(dt.Rows[i]["pc_weight"].ToString());
                    }
                }
                sumpalletweight.Text = (double.Parse(boxweight) + attach_weight).ToString();
                if (palletweight != "")
                {
                    sumpalletweight.Text = (double.Parse(boxweight) + attach_weight + double.Parse(palletweight)).ToString();
                }
            }
            return "";
        }


        private void Remark_PreFix_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {

            }
        }

        private bool CheckOutBoxLength(string ms_salecode_text)
        {
            if (AutoGenBoxCode.Checked)
            {
                if (ms_salecode_text != "")
                {
                    DataTable dt = (DataTable)dh.ExecuteSql(" select pn_number,pn_id,pn_caller,pn_numberlength,pn_leadcode  from PACKAGENUMBER where pn_caller='" + pr_code.Text + "'", "select");
                    if (dt.Rows.Count > 0)
                    {
                        string pn_leadcode = dt.Rows[0]["pn_leadcode"].ToString();
                        int pn_numberlength = int.Parse(dt.Rows[0]["pn_numberlength"].ToString());
                        if (OutBoxLength.Text != (pn_leadcode.Length + pn_numberlength).ToString())
                        {
                            OutBoxLength.Text = (pn_leadcode.Length + pn_numberlength).ToString();
                            BaseUtil.SetCacheData("OutBoxLength", OutBoxLength.Text);
                        }
                        if (PreFix.Text != pn_leadcode)
                        {
                            PreFix.Text = pn_leadcode;
                            BaseUtil.SetCacheData("PreFix", PreFix.Text);
                        }
                    }
                    else
                    {
                        //OperateResult.AppendText(">>产品" + pr_code.Text + "未维护箱号规则\n", Color.Black);
                    }
                }
                return true;
            }
            return CheckOutBoxLength();
        }


        private void AutoGenBoxCode_CheckedChanged(object sender, EventArgs e)
        {
            if (AutoGenBoxCode.Checked)
            {
                OutBoxLength.Enabled = false;
                PreFix.Enabled = false;
                pa_outboxcode.Enabled = false;
            }
            else
            {
                OutBoxLength.Enabled = true;
                PreFix.Enabled = true;
                pa_outboxcode.Enabled = true;
            }
        }

        private void PalletCode_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                if (pa_outboxcode.Text == "")
                {
                    OperateResult.AppendText(">>请先输入箱号\n", Color.Red);
                    return;
                }
                DataTable dt = (DataTable)dh.ExecuteSql("select pl_code from pallet where pl_code='" + PalletCode.Text + "'", "select");
                if (dt.Rows.Count == 0)
                {
                    OperateResult.AppendText(">>卡板号" + PalletCode.Text + "不存在\n", Color.Red);
                    return;
                }
                string boxcode = dh.getFieldDataByCondition("package", "pa_outboxcode", "PA_PALLETNO='" + PalletCode.Text + "'").ToString();
                if (boxcode != "")
                {
                    OperateResult.AppendText(">>卡板号" + PalletCode.Text + "已绑定栈板" + boxcode + "\n", Color.Red);
                    return;
                }
                dh.ExecuteSql("update package set PA_PALLETNO='" + PalletCode.Text + "' where pa_outboxcode='" + pa_outboxcode.Text + "'", "update");
                OperateResult.AppendText(">>卡板号" + PalletCode.Text + "绑定栈板号" + pa_outboxcode.Text + "成功\n", Color.Green);
                RefreshWeight();
            }
        }

        bool GetData = true;

        private void StartWeight_Click(object sender, EventArgs e)
        {
            thread = new Thread(getSerialData);
            try
            {
                serialPort1.PortName = ComList.Text;
                serialPort1.BaudRate = int.Parse(BaudRate.Text);
                serialPort1.Open();
                GetData = true;
                thread.Start();
            }
            catch (Exception mes)
            {
                if (BaudRate.Text == "" || ComList.Text == "")
                    OperateResult.AppendText(">>请先在电子秤调试界面维护波特率和串口\n", Color.Red);
                else
                    OperateResult.AppendText(">>" + mes.Message + "\n", Color.Red);
            }
        }

        private void getSerialData()
        {
            if (serialPort1.IsOpen)
            {
                if (!SystemInf.OpenPort.Contains(serialPort1.PortName))
                {
                    SystemInf.OpenPort.Add(serialPort1.PortName);
                    try
                    {
                        while (GetData)
                        {
                            try
                            {
                                //int len = serialPort1.BytesToRead;
                                //Byte[] readBuffer = new Byte[len];
                                //serialPort1.Read(readBuffer, 0, len); //将数据读入缓存
                                //string weigh = Encoding.Default.GetString(readBuffer);
                                //if (weigh != "")
                                //{
                                //    weight.Text = re.Match(weigh).Value;
                                //}
                                weight.Text = re.Match(serialPort1.ReadLine()).Groups[0].Value;
                            }
                            catch (Exception)
                            {
                                GetData = false;
                            }
                        }
                    }
                    catch (IOException ex) { MessageBox.Show(ex.Message); }
                }
                else OperateResult.AppendText(">>端口已被占用，请关闭其他窗口\n", Color.Red);
            }
        }
    }
}