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

using LabelManager2;
using System;
using System.Data;
using System.Text;
using System.Windows.Forms;
using UAS_MES.DataOperate;
using UAS_MES.Entity;
using UAS_MES.PublicMethod;
using System.Drawing;
using System.Threading;
using UAS_MES.PublicForm;

namespace UAS_MES.Make
{
    public partial class Make_PackageCollection : Form
    {
        DataHelper dh;
        DataTable dt;
        LogStringBuilder sql = new LogStringBuilder();
        AutoSizeFormClass asc = new AutoSizeFormClass();
        ApplicationClass lbl;
        Thread thread;
        DataTable Dbfind;
        string ErrorMessage = "";
        string oMakeCode = "";
        string oMsID = "";

        System.DateTime[] indate;

        public Make_PackageCollection()
        {
            InitializeComponent();
        }

        //创建打印进程
        private void NewPrint()
        {
            try
            {
                lbl = new ApplicationClass();
            }
            catch (Exception ex)
            {
                MessageBox.Show("未正确安装codesoft");
            }
        }

        private void 包装采集_Load(object sender, EventArgs e)
        {
            AutoPrint.Checked = true;
            //设置DbFind的必须的数据
            ma_code.FormName = Name;
            ma_code.SetValueField = new string[] { "ma_code", "pr_code", "ma_prodname", "pr_outboxinnerqty" };
            ma_code.TableName = "Make left join product on  ma_prodcode=pr_code";
            ma_code.SelectField = "ma_code # 工单号,pr_code # 物料编号,pr_detail # 物料名称,pr_outboxinnerqty # 箱内容量";
            ma_code.Condition = "ma_statuscode='STARTED'";
            ma_code.DbChange += Ma_code_DbChange;
            PrintNum.Value = 1;
            asc.controllInitializeSize(this);
            thread = new Thread(NewPrint);
            SetLoadingWindow stw = new SetLoadingWindow(thread, "初始化打印程序");
            BaseUtil.SetFormCenter(stw);
            stw.ShowDialog();
            dh = new DataHelper();
        }

        private void Ma_code_DbChange(object sender, EventArgs e)
        {
            Dbfind = ma_code.ReturnData;
            BaseUtil.SetFormValue(this.Controls, Dbfind);
        }

        private void 包装采集_SizeChanged(object sender, EventArgs e)
        {
            asc.controlAutoSize(this);
        }

        private void 包装采集_Activated(object sender, EventArgs e)
        {
            pa_outboxcode.Focus();
        }

        //刷新表单的数据的数据
        private void LoadData()
        {
            //加载表单数据
            sql.Clear();
            sql.Append("select pa_outboxcode,pr_id,pa_id,pr_outboxinnerqty,pa_packageqty,pa_totalqty-pa_packageqty pa_restqty,pr_code,pr_detail,");
            sql.Append("pr_colorboxmaxw,pr_colorboxminw,pr_code,pa_makecode as ma_code,pr_outboxinnerqty from package left join packagedetail on  ");
            sql.Append("pd_paid=pa_id left join product on pa_prodcode=pr_code where ");
            sql.Append("(pa_outboxcode='" + pa_outboxcode.Text + "' or pd_barcode='" + barcode.Text + "') and rownum=1 ");
            dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            if (dt.Rows.Count > 0)
            {
                if (pr_code.Text != "")
                {
                    dt.Columns.Remove(dt.Columns["pr_outboxinnerqty"]);
                }
                BaseUtil.SetFormValue(this.Controls, dt);
            }
            else OperateResult.AppendText(">>序列号不存在\n", Color.Red);
            //加载Grid数据
            dt = (DataTable)dh.ExecuteSql("select pa_outboxcode,pd_barcode,pd_innerqty,pa_indate from packageDetail left join package on pa_id=pd_paid where pa_outboxcode='" + pa_outboxcode.Text + "'", "select");
            BaseUtil.FillDgvWithDataTable(PackageDetail, dt);
            barcode.Clear();
            if (pr_outboxinnerqty.Text == pa_packageqty.Text)
            {
                pa_restqty.Text = "";
                pa_packageqty.Text = "";
                pa_outboxcode.Text = "";
                BaseUtil.CleanDGVData(PackageDetail);
                pa_outboxcode.GeneratePaCode_Click(new object(), new EventArgs());
            }
        }

        private void InsertDetail()
        {
            if (int.Parse(pa_restqty.Text == "" ? "1" : pa_restqty.Text) > 0)
            {
                sql.Clear();
                sql.Append("insert into packagedetail(pd_id,pd_paid,pd_outboxcode,pd_innerqty,pd_barcode) ");
                sql.Append("select packagedetail_seq.nextval,pa_id,pa_outboxcode,pa_totalqty,'" + barcode.Text + "' from package where pa_outboxcode='" + pa_outboxcode.Text + "'");
                dh.ExecuteSql(sql.GetString(), "insert");
                dh.UpdateByCondition("Package", "pa_packageqty=pa_packageqty+1", "pa_outboxcode='" + pa_outboxcode.Text + "'");
                dh.UpdateByCondition("makeserial", "ms_outboxcode='" + pa_outboxcode.Text + "'", "ms_sncode='" + barcode.Text + "'");
                if (LogicHandler.UpdateMakeMessage(barcode.Text, ma_code.Text, "包装采集", User.UserSourceCode, User.UserCode, "装箱成功", out ErrorMessage))
                {
                    OperateResult.AppendText(">>序列号" + barcode.Text + "采集成功！\n", Color.Green);
                    barcode.Clear();
                    LoadData();
                }
            }
            else OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "已采集满\n", Color.Red);
        }

        private void Print_Click(object sender, EventArgs e)
        {
            //未采集满的时候点击打印，进行提示
            if (pr_outboxinnerqty.Text != pa_packageqty.Text)
            {
                DialogResult result = MessageBox.Show("该箱未采集满,确定打印？", "提示", MessageBoxButtons.YesNo);
                if (result.ToString() == "Yes")
                {
                    OperateResult.AppendText(">>开始打印\n", Color.Green);
                    Print.CodeSoft(lbl, PrintLabel.Text.Split(':')[1], PrintLabel.SelectedValue.ToString(), PrintList.Text, pa_outboxcode.Text, int.Parse(PrintNum.Text), indate[PrintLabel.SelectedIndex]);
                }
            }
            else
            {
                if (PrintLabel.SelectedValue != null)
                {
                    OperateResult.AppendText(">>开始打印\n", Color.Green);
                    Print.CodeSoft(lbl, PrintLabel.Text.Split(':')[1], PrintLabel.SelectedValue.ToString(), PrintList.Text, pa_outboxcode.Text, int.Parse(PrintNum.Text), indate[PrintLabel.SelectedIndex]);
                }
            }
        }

        //输入箱号的回车事件
        private void pa_code_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                LoadData();
                //根据箱号查询信息，如果箱号存在焦点跳到输入序列号，不存在则跳到选择工单号
                if (dt.Rows.Count > 0)
                {
                    barcode.Focus();
                }
                else
                {
                    ma_code.Focus();
                }
            }
        }

        //输入序列号的回车事件
        private void barcode_KeyDown(object sender, KeyEventArgs e)
        {
            //当用户输入回车键的时候
            if (e.KeyCode == Keys.Enter)
            {
                //先判断箱号不为空
                if (pa_outboxcode.Text != "" && barcode.Text != "")
                {
                    //判断箱内总数必须大于0
                    if (pr_outboxinnerqty.Text == "" || pr_outboxinnerqty.Text == "0")
                    {
                        OperateResult.AppendText(">>箱内数量必须大于0\n", Color.Red);
                        return;
                    }
                    if (LogicHandler.CheckStepSNAndMacode(ma_code.Text, User.UserSourceCode, barcode.Text, User.UserCode, out oMakeCode, out oMsID, out ErrorMessage))
                    {
                        //如果未勾选了取消录入
                        if (!Cancel.Checked)
                        {
                            //判断序列号是否已经装箱
                            if (dh.CheckExist("packagedetail", "pd_barcode='" + barcode.Text + "'"))
                            {
                                OperateResult.AppendText(">>序列号" + barcode.Text + "已经装箱！\n", Color.Red);
                                barcode.Clear();
                            }
                            else
                            {
                                //箱号不存在的情况
                                if (!dh.CheckExist("package", "pa_outboxcode='" + pa_outboxcode.Text + "'"))
                                {
                                    //插入Package主表箱号信息
                                    sql.Clear();
                                    sql.Append("insert into package (pa_id,pa_outboxcode,pa_packageqty,pa_totalqty,pa_status,pa_indate,pa_makecode,pa_prodcode,pa_salecode,pa_custcode)");
                                    sql.Append("select package_seq.nextval,'" + pa_outboxcode.Text + "',0," + pr_outboxinnerqty.Text + ",0,");
                                    sql.Append("sysdate,'" + ma_code.Text + "', ma_prodcode,ma_salecode,ma_custcode from make where ma_code = '" + ma_code.Text + "'");
                                    dh.ExecuteSql(sql.GetString(), "insert");
                                    OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "采集成功！\n", Color.Green);
                                    //验证序列号插入明细表的数据
                                    InsertDetail();
                                }
                                else
                                {
                                    //判断序列号是否存在于制造工序表中
                                    if (dh.getRowCount("makeserial", "ms_sncode='" + barcode.Text + "'") > 0)
                                    {
                                        InsertDetail();
                                    }
                                }
                            }
                        }
                        //勾选了取消箱号先验证箱号存不存在，存在的话移除掉，重新加载一次数据
                        else
                        {
                            dt = (DataTable)dh.ExecuteSql("select pd_outboxcode from packagedetail where pd_outboxcode='" + pa_outboxcode.Text + "' and pd_barcode='" + barcode.Text + "'", "select");
                            if (dt.Rows.Count > 0)
                            {
                                //删除明细行的数据
                                dh.ExecuteSql("delete from packagedetail where pd_barcode='" + barcode.Text + "' and pd_paid=(select pa_id from package where pa_outboxcode='" + pa_outboxcode.Text + "')", "delete");
                                //更新已装数 
                                dh.UpdateByCondition("Package", "pa_packageqty=pa_packageqty-1", "pa_outboxcode='" + pa_outboxcode.Text + "'");
                                OperateResult.AppendText(">>已从该箱中移除序列号" + barcode.Text + "\n", Color.Green);
                                LoadData();
                            }
                            else OperateResult.AppendText(">>序列号" + barcode.Text + "不在该箱内，请输入正确的序列号\n", Color.Red);
                        }
                    }
                    else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
                }
                else LoadData();
            }
        }

        private void Clean_Click(object sender, EventArgs e)
        {
            OperateResult.Clear();
        }

        private void pa_packageqty_TextChanged(object sender, EventArgs e)
        {
            if (AutoPrint.Checked)
            {
                if (pr_outboxinnerqty.Text == pa_packageqty.Text)
                {
                    OperateResult.AppendText(">>打印箱号" + pa_outboxcode.Text + "\n", Color.Green);
                    Print.CodeSoft(lbl, PrintLabel.Text.Split(':')[1], PrintLabel.SelectedValue.ToString(), PrintList.Text, pa_outboxcode.Text, int.Parse(PrintNum.Text), indate[PrintLabel.SelectedIndex]);
                }
            }
        }

        private void pa_code_IconClick(object sender, EventArgs e)
        {
            if (ma_code.Text == "")
            {
                OperateResult.AppendText(">>请先选择工单号\n", Color.Red);
            }
        }

        private void pr_code_TextChanged(object sender, EventArgs e)
        {
            dt = (DataTable)dh.ExecuteSql("select pl_labelcode||':'||pl_labelname pl_laname,pl_labelname,pl_labelcode,pl_labelurl,pl_indate from productlabel where pl_prodcode='" + pr_code.Text + "' order by pl_isdefault desc ", "select");
            PrintLabel.DataSource = dt;
            PrintLabel.DisplayMember = "pl_laname";
            PrintLabel.ValueMember = "pl_labelcode";
            ftpOperater ftp = new ftpOperater();
            indate = new System.DateTime[dt.Rows.Count];
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                BaseUtil.GetPrintLabel(dt.Rows[i]["pl_labelname"].ToString(), dt.Rows[i]["pl_labelurl"].ToString(), dt.Rows[i]["pl_indate"].ToString());
                indate[i] = Convert.ToDateTime(dt.Rows[i]["pl_indate"].ToString());
            }
        }

        private void pr_id_TextChanged(object sender, EventArgs e)
        {
            pa_outboxcode.Pr_id = pr_id.Text;
        }

        private void 包装采集_FormClosing(object sender, FormClosingEventArgs e)
        {
            lbl.Quit();
            dh.Dispose();
        }

        private void ma_code_UserControlTextChanged(object sender, EventArgs e)
        {
            if (ma_code.Text.Length > 5)
            {
                //加载表单数据
                sql.Clear();
                sql.Append("select ma_prodcode,pr_detail,pr_id,ma_code from product left join make on ma_prodcode=pr_code where ma_code='" + ma_code.Text + "'");
                dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                if (dt.Rows.Count > 0)
                {
                    BaseUtil.SetFormValue(this.Controls, dt);
                }
            }
        }

        private void pa_outboxcode_IconClick(object sender, EventArgs e)
        {
            pa_restqty.Text = "";
            pa_packageqty.Text = "";
            BaseUtil.CleanDGVData(PackageDetail);
        }
    }
}