mes-client/UAS_MES_WEIP/FunctionCode/Make/Make_SMTBind.cs

using System;
using System.Data;
using System.Text;
using System.Windows.Forms;
using UAS_MES_NEW.CustomControl.TextBoxWithIcon;
using UAS_MES_NEW.DataOperate;
using UAS_MES_NEW.Entity;
using UAS_MES_NEW.PublicMethod;
using System.Drawing;
using System.Text.RegularExpressions;
using System.Collections.Generic;

namespace UAS_MES_NEW.Make
{
    public partial class Make_SMTBind : Form
    {
        string ErrorMessage = "";

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

        Dictionary<string, string> CheckBarcode = new Dictionary<string, string>();

        DataHelper dh;
        LogStringBuilder sql = new LogStringBuilder();
        DataTable DBFind;
        //保存ListB中的数据
        DataTable dt1;

        AutoSizeFormClass asc = new AutoSizeFormClass();

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

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

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

        public Make_SMTBind()
        {
            InitializeComponent();
        }

        private void Make_FeedingCollection_Load(object sender, EventArgs e)
        {
            asc.controllInitializeSize(this);
            LockMakeCode.GetMakeCodeCtl(ma_code);
            ma_code.SetLockCheckBox(LockMakeCode);
            //工单号放大镜配置
            ma_code.TableName = "make left join product on ma_prodcode=pr_code";
            ma_code.SelectField = "ma_code # 工单号,ma_prodcode # 产品编号,ma_qty # 工单数量,ma_craftcode # 途程编号,pr_spec # 产品名称,ma_bomversion # Bom版本,ma_softversion # 软件版本,ma_ecncode # ECN号,pr_pcbacount # 拼版数";
            ma_code.FormName = Name;
            ma_code.DBTitle = "工单查询";
            ma_code.SetValueField = new string[] { "ma_code", "ma_prodcode", "ma_qty", "pr_spec", "ma_craftcode", "ma_bomversion", "ma_softversion", "ma_ecncode", "pr_pcbacount" };
            ma_code.Condition = "ma_statuscode='STARTED'";
            ma_code.DbChange += Ma_code_DBChange;
            code.GotFocus+= text_getfocus;
            code.Focus();
            dh = SystemInf.dh;
            StepCount.StepCode = User.CurrentStepCode;
            StepCount.Source = User.UserSourceCode;
            StepCount.LineCode = User.UserLineCode;
            StepCount.Dh = dh;
            StepCount.Start();
        }

        private void text_getfocus(object sender, EventArgs e)
        {
            code.ImeMode = ImeMode.Close;
        }

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

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

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

        private void Confirm_Click(object sender, EventArgs e)
        {
            KeyEventArgs e2 = new KeyEventArgs(Keys.Enter);
            code_KeyDown(sender, e2);
        }

        private void code_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out ErrorMessage))
                {
                    if (Loading.Checked)
                    {
                        if (code.Text.Replace(" ", "") == ""||pr_pcbacount.Value == 0 || pr_pcbacount.Value == 1)
                        {
                            OperateResult.AppendText(">>采集数据与拼版数不可为空\n", Color.Red);
                            return;
                        }
                        else
                        {
                            if (sn_code.Text == "")
                            {
                                if (ma_code.Text != "" && !LogicHandler.CheckSnRule(ma_code.Text, ma_prodcode.Text, code.Text, out ErrorMessage))
                                {
                                    OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code);
                                    return;
                                }
                                sql.Clear();
                                sql.Append("select rownum,sb_maincode,sb_makecode,sb_barcode,sb_prodcode,sb_indate from SMTBIND where sb_maincode=(select sb_maincode from SMTBIND ");
                                sql.Append("where sb_barcode='" + code.Text + "')");
                                dt1 = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                                if (dt1.Rows.Count > 0)
                                {
                                    string sb_makecode = dt1.Rows[0]["sb_makecode"].ToString();
                                    if (ma_code.Text != "" && ma_code.Text != sb_makecode)
                                    {
                                        OperateResult.AppendText(">>条码已绑定至工单" + sb_makecode + "\n", Color.Red, code);
                                        return;
                                    }
                                    ma_code.Text = dt1.Rows[0]["sb_makecode"].ToString();
                                    LockMakeCode.Checked = true;
                                    ma_code_UserControlTextChanged(sender, e);
                                    BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt1);
                                    if (dt1.Rows.Count < pr_pcbacount.Value)
                                    {
                                        sn_code.Text = dt1.Rows[0]["sb_maincode"].ToString();
                                    }
                                    code.Text = "";
                                }
                                else
                                {
                                    if (ma_code.Text == "")
                                    {
                                        OperateResult.AppendText(">>请先选择工单号\n", Color.Red, code);
                                        return;
                                    }
                                    if (!LogicHandler.CheckSnRule(ma_code.Text, ma_prodcode.Text, code.Text, out ErrorMessage))
                                    {
                                        OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code);
                                        return;
                                    }
                                    sn_code.Text = code.Text;
                                    sql.Clear();
                                    sql.Append("insert into smtbind(sb_id,sb_maincode,sb_barcode,sb_makecode,sb_prodcode,sb_inman,sb_indate,sb_status)");
                                    sql.Append("values(smtbind_seq.nextval,'" + sn_code.Text + "','" + code.Text + "','" + ma_code.Text + "','" + ma_prodcode.Text + "',");
                                    sql.Append("'" + User.UserCode + "',sysdate,0)");
                                    dh.ExecuteSql(sql.GetString(), "insert");

                                    RefreshData();

                                    sql.Clear();
                                    sql.Append("select rownum,sb_maincode,sb_barcode,sb_prodcode,sb_indate from SMTBIND where sb_maincode=(select sb_maincode from SMTBIND ");
                                    sql.Append("where sb_barcode='" + code.Text + "')");
                                    dt1 = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                                    BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt1);
                                    code.Text = "";
                                }
                            }
                            else
                            {
                                if (ma_code.Text == "")
                                {
                                    OperateResult.AppendText(">>请先选择工单号\n", Color.Red, code);
                                    return;
                                }
                                if (!LogicHandler.CheckSnRule(ma_code.Text, ma_prodcode.Text, code.Text, out ErrorMessage))
                                {
                                    OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code);
                                    return;
                                }
                                if (dh.CheckExist("smtbind", "sb_barcode='" + code.Text + "'"))
                                {
                                    OperateResult.AppendText(">>条码" + code.Text + "已绑定\n", Color.Red, code);
                                    return;
                                }
                                sql.Clear();
                                sql.Append("insert into smtbind(sb_id,sb_maincode,sb_barcode,sb_makecode,sb_prodcode,sb_inman,sb_indate,sb_status)");
                                sql.Append("values(smtbind_seq.nextval,'" + sn_code.Text + "','" + code.Text + "','" + ma_code.Text + "','" + ma_prodcode.Text + "',");
                                sql.Append("'" + User.UserCode + "',sysdate,0)");
                                dh.ExecuteSql(sql.GetString(), "insert");

                                RefreshData();

                                sql.Clear();
                                sql.Append("select rownum,sb_maincode,sb_barcode,sb_prodcode,sb_indate from SMTBIND where sb_maincode=(select sb_maincode from SMTBIND ");
                                sql.Append("where sb_barcode='" + code.Text + "')");
                                dt1 = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                                BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt1);
                                if (LabelDataGridView.Rows.Count == pr_pcbacount.Value)
                                {
                                    sn_code.Text = "";
                                }
                                code.Text = "";
                            }
                        }
                    }
                    //勾选了下料的时候
                    else if (UnLoading.Checked)
                    {
                        sql.Clear();
                        sql.Append("select rownum,sb_maincode,sb_makecode,sb_barcode,sb_prodcode,sb_indate from SMTBIND where sb_maincode=(select sb_maincode from SMTBIND ");
                        sql.Append("where sb_barcode='" + code.Text + "')");
                        dt1 = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                        if (dt1.Rows.Count > 0)
                        {
                            string sb_makecode = dt1.Rows[0]["sb_makecode"].ToString();
                            if (ma_code.Text != "" && ma_code.Text != sb_makecode)
                            {
                                OperateResult.AppendText(">>条码已绑定至工单" + sb_makecode + "\n", Color.Red, code);
                                return;
                            }
                            ma_code.Text = dt1.Rows[0]["sb_makecode"].ToString();
                            LockMakeCode.Checked = true;
                            ma_code_UserControlTextChanged(sender, e);
                            BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt1);
                            string sb_maincode = dt1.Rows[0]["sb_maincode"].ToString();
                            //如果采集的是主条码则拆分所有的条码
                            if (sb_maincode == code.Text)
                            {
                                string closetab_confirm = MessageBox.Show(this.ParentForm, "确认拆解所有条码", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
                                if (closetab_confirm == "Yes")
                                {
                                    dh.ExecuteSql("delete from smtbind where sb_maincode='" + code.Text + "'", "delete");
                                }
                            }
                            else
                            {
                                dh.ExecuteSql("delete from smtbind where sb_barcode='" + code.Text + "'", "delete");
                            }
                            sql.Clear();
                            sql.Append("select rownum,sb_maincode,sb_barcode,sb_prodcode,sb_indate from SMTBIND where sb_maincode='" + sb_maincode + "'");
                            dt1 = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                            BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt1);
                            sn_code.Text = "";
                            code.Text = "";
                            RefreshData();
                        }
                    }
                }
                else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code);
            }
        }

        private void ClearSn_code_Click(object sender, EventArgs e)
        {
            sn_code.Clear();
            SPID.Clear();
            TSN.Clear();
            CheckBarcode.Clear();
            CollectData.Clear();
            CollectDataSonCode.Clear();
            if (dt1 != null)
                BaseUtil.CleanDataTableData(dt1);
            BaseUtil.CleanDGVData(LabelDataGridView);
            OperateResult.AppendText(">>请采集序列号\n", Color.Black);
        }

        private void ma_code_UserControlTextChanged(object sender, EventArgs e)
        {
            if (ma_code.Text.Length > 5)
            {
                string ErrMessage = "";
                if (LogicHandler.CheckMakeStatus(ma_code.Text, out ErrMessage))
                {
                    mcd_inqty.Text = "";
                    mcd_remainqty.Text = "";
                    sql.Clear();
                    sql.Append("select ma_qty,ma_prodcode,pr_detail,pr_pcbacount ");
                    sql.Append("from make left join makecraftdetail on mcd_macode=ma_code left join product on ma_prodcode=pr_code where ");
                    sql.Append("ma_code='" + ma_code.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
                    DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                    if (dt.Rows.Count > 0)
                        BaseUtil.SetFormValue(Controls, dt);

                    RefreshData();

                    sql.Clear();
                    sql.Append("select rownum,sb_maincode,sb_barcode,sb_prodcode,sb_makecode,sb_indate from SMTBIND where sb_maincode=(select sb_maincode from SMTBIND ");
                    sql.Append("where sb_barcode='" + code.Text + "')");
                    dt1 = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                    BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt1);
                }
            }
        }

        /// <summary>
        /// 刷新采集数据
        /// </summary>
        private void RefreshData()
        {
            sql.Clear();
            sql.Append("select count(1) mcd_inqty,max(ma_qty)-count(1) mcd_remainqty from smtbind left join make on ma_code= sb_makecode where sb_makecode='" + ma_code.Text + "' ");
            DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            if (dt.Rows.Count > 0)
                BaseUtil.SetFormValue(Controls, dt);
        }
    }
}