mes-client/UAS_RFW/FunctionCode/Packing/Packing_PackageCollection.cs

using LabelManager2;
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 System.Runtime.InteropServices;
using DevExpress.Printing.Core.PdfExport.Metafile;
//using Seagull.BarTender.Print;

namespace UAS_MES_NEW.Packing
{
    public partial class Packing_PackageCollection : Form
    {
        DataHelper dh;
        DataTable dt;
        LogStringBuilder sql = new LogStringBuilder();
        AutoSizeFormClass asc = new AutoSizeFormClass();
        ApplicationClass lbl;
        BarTender.Application engine;
        Thread thread;

        DataTable Dbfind;
        string ErrorMessage = "";
        string oMakeCode = "";
        string oMsID = "";
        string oMsStatus = "";
        string oOutBoxCode = "";
        decimal StandardQTY = 0;
        string LastSncode;
        Document doc;
        string PR_CHECKCARTONW = "0";

        ModeBusTCPServer md;

        public Packing_PackageCollection()
        {

            InitializeComponent();
        }

        //创建打印进程
        private void NewPrint()
        {
            try
            {
                engine = new BarTender.Application();
                //lbl = new ApplicationClass();
                //BaseUtil.WriteLbl();
            }
            catch (Exception ex)
            {
                OperateResult.AppendText("未正确安装打印软件\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();
            }
            //设置DbFind的必须的数据
            PrintNum.Text = "1";
            asc.controllInitializeSize(this);
            thread = new Thread(NewPrint);
            thread.Start();
            md = new ModeBusTCPServer();
            dh = SystemInf.dh;
        }

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

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

        //刷新表单的数据的数据
        private void LoadData()
        {
            
            LoadCollectedNum();
        }

        private void LoadGridData()
        {
            //加载Grid数据
            dt = (DataTable)dh.ExecuteSql(" select max(pd_id)pd_id,pd_pocode,pd_ordercode,pd_prodcode,pr_brand,pr_orispeccode,sum(pd_outqty)pd_outqty,pr_detail,pd_description,'' onlynumber ,'' datecode,'' youxiaoqi  " +
                " from prodinout left join prodiodetail on pi_inoutno = pd_inoutno left join product on pd_prodcode = pr_code where pd_inoutno = '" + pi_inoutno.Text + "' group by pd_pocode," +
                " pd_ordercode, pd_prodcode, pr_brand, pr_orispeccode, pr_detail,pd_description order by pd_id asc ", "select");
            BaseUtil.FillDgvWithDataTable(PackageDetail, dt);
 
        }

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

        //加载工单信息和装箱明细信息
        private void pa_code_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                if (!dh.CheckExist("prodinout", "pi_inoutno = '" + pi_inoutno.Text + "' and  pi_class = '出货单'"))
                {
                    OperateResult.AppendText(">>出货单" + pi_inoutno.Text + "不存在\n", Color.Red, pi_inoutno);
                    return;
                }
                dt = (DataTable)dh.ExecuteSql(" select * from prodinout where pi_inoutno = '" + pi_inoutno.Text + "' ", "select");
                BaseUtil.SetFormValue(this.Controls, dt);
                LoadGridData();
            }
        }

        //输入序列号的回车事件
        private void barcode_KeyDown(object sender, KeyEventArgs e)
        {
           
        }

        private void Clean_Click(object sender, EventArgs e)
        {
            OperateResult.Clear();
        }
        DataTable _dt;
        private void pr_code_TextChanged(object sender, EventArgs e)
        {
            _dt = (DataTable)dh.ExecuteSql("select la_id,la_sql from label where la_name='" + pi_title.Text + "'", "select");
            PrintLabel.DataSource = _dt;
            PrintLabel.DisplayMember = "la_sql";
            PrintLabel.ValueMember = "la_id";

        }

        private void PackCollection_FormClosing(object sender, FormClosingEventArgs e)
        {
            BaseUtil.ClosePrint(lbl);
            if (engine != null)
                engine.Quit(BarTender.BtSaveOptions.btDoNotSaveChanges);
            dh.Dispose();
        }

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

      

        bool AutoCut;

      

      

        //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)
        {

        }

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

     

        private void LoadCollectedNum()
        {

        }

        private void pa_remark_KeyDown(object sender, KeyEventArgs e)
        {
        
        }

        private void PreFix_KeyDown(object sender, KeyEventArgs e)
        {
           
        }

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

        private void CloseServer_Click(object sender, EventArgs e)
        {
            if (md.IsOpen)
            {
                md.Close();
                OperateResult.AppendText(">>服务关闭成功\n");
            }
            else
                OperateResult.AppendText(">>服务尚未开启\n");
        }

        private void Remark_PreFix_KeyDown(object sender, KeyEventArgs e)
        {
        }

        private void PackageDetail_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            if (PackageDetail.Columns[e.ColumnIndex].Name == "print" && e.RowIndex >= 0)
            {
                Console.WriteLine(PackageDetail.Rows[e.RowIndex].Cells["pd_id"].Value.ToString());
                int printnum;
                int fenshu;
                try
                {
                     printnum = int.Parse(PackageDetail.Rows[e.RowIndex].Cells["codenum"].Value.ToString());
                     fenshu = int.Parse(PrintNum.Text.ToString());
                }
                catch (Exception ex)
                {
                    OperateResult.AppendText(">>打印数量以及打印张数不符合要求\n",Color.Red);
                    return;
                }
                if (printnum > 0 && fenshu > 0)
                {
                    if (!Print.SinglePrint(Tag.ToString(), engine, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), PrintList.Text, PackageDetail.Rows[e.RowIndex].Cells["pd_id"].Value.ToString(), int.Parse(PrintNum.Text), PackageDetail.Rows[e.RowIndex].Cells["onlynumber"].Value.ToString(), PackageDetail.Rows[e.RowIndex].Cells["datecode"].Value.ToString(), PackageDetail.Rows[e.RowIndex].Cells["pd_description"].Value.ToString(), printnum.ToString(), PackageDetail.Rows[e.RowIndex].Cells["youxiaoqi"].Value.ToString(), out ErrorMessage))
                    {
                        OperateResult.AppendText(ErrorMessage + "\n", Color.Red);
                    }
                }
                else
                {
                    OperateResult.AppendText(">>打印数量以及打印张数不符合要求\n", Color.Red);
                    return;
                }
            }
        }
    }
}