mes-client/UAS-MES/FunctionCode/Make/Make_CartonBoxWeigh.cs

using LabelManager2;
using Microsoft.Win32;
using System;
using System.Data;
using System.Drawing;
using System.IO;
using System.IO.Ports;
using System.Text;
using System.Text.RegularExpressions;
using System.Threading;
using System.Windows.Forms;
using UAS_MES.DataOperate;
using UAS_MES.Entity;
using UAS_MES.PublicMethod;

namespace UAS_MES.Make
{
    public partial class Make_CartonBoxWeigh : Form
    {
        AutoSizeFormClass asc = new AutoSizeFormClass();

        DataHelper dh;

        DataTable dt;

        LogStringBuilder sql = new LogStringBuilder();

        ApplicationClass lbl;

        Thread thread;
        //创建串口实例
        SerialPort serialPort1 = new SerialPort();

        //true的时候表示从串口读取数据
        bool GetData = true;
        //箱内总数
        int pa_totalqty;
        //称量的标准重量
        int Weight;
        //最大重量
        int MaxWeight;
        //最小重量
        int MinWeight;

        DataTable ListC = new DataTable();

        public Make_CartonBoxWeigh()
        {
            InitializeComponent();
        }

        private void 卡通箱称重_Load(object sender, EventArgs e)
        {
            CheckForIllegalCrossThreadCalls = false;
            asc.controllInitializeSize(this);
            dh = new DataHelper();
            lbl = new ApplicationClass();
            ComList.Text = Properties.Settings.Default.PortName;
            BaudRate.Text = Properties.Settings.Default.BaudRate;
        }

        private void 卡通箱称重_SizeChanged(object sender, EventArgs e)
        {
            asc.controlAutoSize(this);
        }

        private void sncode_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                //根据箱号查询表单数据
                pd_barcode.Text = dh.getFieldDataByCondition("makeserial left join package on ms_prodcode=pa_prodcode", "ms_sncode", "pa_outboxcode='" + outboxcode.Text + "'").ToString();
                sql.Clear();
                sql.Append("select pa_totalqty,pd_barcode,ma_code,mcd_okqty,ma_qty,ma_qty-mcd_okqty as mcd_waitqty,ma_salecode,pr_detail,pr_cartonunit,pr_code,pr_cartongw,");
                sql.Append("pr_cartonmaxw,pr_cartonminw from  package left join product on pr_code=pa_prodcode left join make on ma_prodcode=pr_code left join makecraftdetail ");
                sql.Append("on mcd_macode=ma_code left join  packagedetail on pd_outboxcode=pa_outboxcode where pa_outboxcode='" + outboxcode.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
                dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                //填充Form的值
                BaseUtil.SetFormValue(this.Controls, dt);
                //填充打印文件选项的DataGridView
                if (dt.Rows.Count > 0)
                {
                    string ErrorMessage;
                    //重量的临时变量
                    string _weight = dt.Rows[0]["pr_cartongw"].ToString();
                    string _maxweight = dt.Rows[0]["pr_cartonminw"].ToString();
                    string _minweight = dt.Rows[0]["pr_cartonmaxw"].ToString();

                    Weight = int.Parse(_weight == "" ? "0" : _weight);
                    MaxWeight = int.Parse(_maxweight == "" ? "0" : _maxweight);
                    MinWeight = int.Parse(_minweight == "" ? "0" : _minweight);
                    pa_totalqty = int.Parse(dt.Rows[0]["pa_totalqty"].ToString());
                    bool ifFirst;
                    if (LogicHandler.CheckCurrentStepAndIfFirst(pd_barcode.Text, ma_code.Text, User.UserSourceCode, Tag.ToString(), out ifFirst, out ErrorMessage))
                    {
                        sql.Clear();
                        sql.Append("select count(1) cn from MES_PACKAGE_VIEW  left join makeserial on v_prodcode=ms_prodcode where (ms_sncode=");
                        sql.Append("v_barcode or ms_psn=v_barcode)  and v_outboxcode='" + outboxcode.Text + "'");
                        int ActualWeight = int.Parse(weight.Text == "" ? "0" : weight.Text);
                        if (ActualWeight > MinWeight && ActualWeight < MaxWeight)
                        {
                            if (PriLabel.Checked)
                            {
                                Print.CodeSoft(lbl, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), Printer.Text, pd_barcode.Text);
                                AfterWeighPass();
                            }
                            else if (SupPriLabel.Checked)
                            {
                                Print.CodeSoft(lbl, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), Printer.Text, pd_barcode.Text);
                                dh.ExecuteSql("update package set pa_printcount= pa_printcount+1 where pa_outboxcode='" + outboxcode.Text + "'", "update");
                                AfterWeighPass();
                            }
                            OperateResult.AppendText(">>检测合格\n", Color.Green);
                        }
                        else
                        {
                            OperateResult.AppendText(">>检测未通过\n", Color.Red);
                        }
                    }
                    else
                    {
                        OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
                    }
                }
                else
                {
                    OperateResult.AppendText(">>箱号" + outboxcode.Text + "不存在\n", Color.Red);
                }
                outboxcode.Text = "";
            }
        }


        private void getSerialData()
        {
            if (serialPort1.IsOpen)
            {
                if (!SystemInf.OpenPort.Contains(serialPort1.PortName))
                {
                    SystemInf.OpenPort.Add(serialPort1.PortName);
                    try
                    {
                        while (GetData)
                        {
                            try
                            {
                                weight.Text = Regex.Replace(serialPort1.ReadLine(), "\\D+", "");
                            }
                            catch (Exception)
                            {
                                GetData = false;
                            }
                        }
                    }
                    catch (IOException ex) { MessageBox.Show(ex.Message); }
                }
                else
                    MessageBox.Show("端口已被占用，请关闭其他窗口");
            }
        }

        private void AfterWeighPass()
        {
            string ErrorMessage;
            dh.ExecuteSql("update package set pa_weight=" + weight.Text + ", pa_printcount= nvl(pa_printcount,0)+1 where pa_outboxcode='" + outboxcode.Text + "'", "update");
            if (!LogicHandler.UpdateMakeMessage(pd_barcode.Text, ma_code.Text, "卡通箱称重", User.UserSourceCode, User.UserName, "称量合格", out ErrorMessage))
                OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
        }

        //确认打印
        private void Confirm_Click(object sender, EventArgs e)
        {

        }

        //取消调整
        private void Cancel_Click(object sender, EventArgs e)
        {

        }

        //停止进程，关闭串口
        private void StopWeight_Click(object sender, EventArgs e)
        {
            GetData = false;
            SystemInf.OpenPort.Remove(serialPort1.PortName);
            serialPort1.Close();
        }

        //只能默认勾选一个复选框
        private void PrintLabel_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            //if (PrintLabel.Columns[e.ColumnIndex].Name == "pl_isdefault")
            //{
            //    for (int i = 0; i < PrintLabel.Rows.Count; i++)
            //    {
            //        if (i != e.RowIndex && PrintLabel.CurrentCell.ColumnIndex == 0)
            //        {
            //            DataGridViewCheckBoxCell cell = (DataGridViewCheckBoxCell)PrintLabel.Rows[i].Cells[0];
            //            cell.Value = false;
            //        }
            //    }
            //}
        }

        //关闭窗口的时候停止进程，不再读取串口数据
        private void 卡通箱称重_FormClosing(object sender, FormClosingEventArgs e)
        {
            lbl.Quit();
            if (serialPort1.IsOpen)
            {
                GetData = false;
                serialPort1.Close();
                SystemInf.OpenPort.Remove(serialPort1.PortName);
                thread.Interrupt();
            }
        }

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

        private void pr_code_TextChanged(object sender, EventArgs e)
        {
            PrintLabel.DataSource = dh.ExecuteSql("select pl_labelcode,pl_labelname from  productlabel  where pl_prodcode='" + pr_code.Text + "'", "select");
            PrintLabel.DisplayMember = "pl_labelname";
            PrintLabel.ValueMember = "pl_labelcode";
        }
    }
}