mes-client/UAS_MES_YDCY/FunctionCode/Make/Make_SNLabelCheckMidBox.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.Collections.Generic;
using UAS_MES_NEW.PublicForm;
using Seagull.BarTender.Print;
using System.Threading;
using System.Text.RegularExpressions;

namespace UAS_MES_NEW.Make
{
    public partial class Make_SNLabelCheckMidBox : Form
    {
        //MakeSerial表主键
        string ms_id;
        //制造单号                                                                             
        string make_code;
        //产品编号
        string make_prodcode;
        //工序编号
        string nextstepcode;
        //完工状态
        string ms_status;
        //工艺路线编号
        //Bom版本
        string mabomversion;
        string ErrorMessage = "";

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

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

        //用于提醒的序列B
        string[] RemainList = new string[0];
        //提醒序列的索引
        int RemainIndex = 0;

        string oMakeCode = "";
        string oMsid = "";

        string ms_firstsn = "";

        Thread InitPrint;

        Engine engine;

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

        AutoSizeFormClass asc = new AutoSizeFormClass();

        public Make_SNLabelCheckMidBox()
        {
            InitializeComponent();
        }

        private void InPrint()
        {
            try
            {
                engine = new Engine(true);
            }
            catch (Exception)
            {
                OperateResult.AppendText("未正确安装BarTender软件\n", Color.Red);
            }
        }

        private void Make_FeedingCollection_Load(object sender, EventArgs e)
        {
            asc.controllInitializeSize(this);
            InitPrint = new Thread(InPrint);
            SetLoadingWindow stw = new SetLoadingWindow(InitPrint, "初始化打印程序");
            BaseUtil.SetFormCenter(stw);
            stw.ShowDialog();
            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号";
            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" };
            ma_code.Condition = "ma_statuscode='STARTED'";
            ma_code.DbChange += Ma_code_DBChange;
            code.Focus();
            dh = SystemInf.dh;
            StepCount.StepCode = User.CurrentStepCode;
            StepCount.Source = User.UserSourceCode;
            StepCount.LineCode = User.UserLineCode;
            StepCount.Dh = dh;
            StepCount.Start();
        }

        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(" ", "") == "")
                        {
                            OperateResult.AppendText(">>采集数据不可为空\n", Color.Red);
                            return;
                        }
                        //如果录入框和工单号均有输入
                        if (code.Text != "" && ma_code.Text != "" && sn_code.Text == "")
                        {
                            GetCollectItem();
                            BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt1);
                        }
                        //输入框有值但未选择工单号
                        else if (code.Text != "" && ma_code.Text == "" && sn_code.Text == "")
                        {
                            GetCollectItem();
                            BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt1);
                        }
                        else if (sn_code.Text != "")
                        {
                            bool AllCheck = true;
                            //索引超出长度表示内容均已提醒
                            for (int i = 0; i < LabelDataGridView.Rows.Count; i++)
                            {
                                if (LabelDataGridView.Rows[i].Cells["lcd_content"].Value == null)
                                {
                                    string labeltype = LabelDataGridView.Rows[i].Cells["lcd_labeltype"].Value.ToString();
                                    string length = LabelDataGridView.Rows[i].Cells["lcd_length"].Value.ToString();
                                    string alllength = LabelDataGridView.Rows[i].Cells["lcd_alllength"].Value.ToString();
                                    string prefix = LabelDataGridView.Rows[i].Cells["lcd_prefix"].Value.ToString();
                                    string suffix = LabelDataGridView.Rows[i].Cells["lcd_suffix"].Value.ToString();
                                    string sql = LabelDataGridView.Rows[i].Cells["lcd_sql"].Value.ToString();
                                    if (sql != "")
                                    {
                                        Regex ConnoteA = new Regex("{\\w+}");
                                        foreach (Match mch in ConnoteA.Matches(sql))
                                        {
                                            string x = mch.Value.Trim();
                                            sql = sql.Replace(x, "'" + sn_code.Text + "'");
                                        }
                                        DataTable Param = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
                                        if (Param.Rows.Count == 0)
                                        {
                                            OperateResult.AppendText(">>" + sn_code.Text + "SQL语句未获取到内容\n", Color.Red, code);
                                            return;
                                        }
                                        else
                                        {
                                            if (code.Text == Param.Rows[0][0].ToString())
                                            {
                                                LabelDataGridView.Rows[i].Cells["lcd_content"].Value = code.Text;
                                            }
                                            else
                                            {
                                                OperateResult.AppendText(">>" + sn_code.Text + "SQL获取内容" + Param.Rows[0][0].ToString() + "" +
                                                    "和扫码内容" + code.Text + "不匹配\n", Color.Red, code);
                                                return;
                                            }
                                        }
                                    }
                                    else
                                    {
                                        if (!code.Text.StartsWith(prefix))
                                        {
                                            OperateResult.AppendText(">>" + labeltype + "前缀不匹配" + code.Text + "\n", Color.Red, code);
                                            return;
                                        }
                                        if (!code.Text.EndsWith(suffix))
                                        {
                                            OperateResult.AppendText(">>" + labeltype + "后缀不匹配" + code.Text + "\n", Color.Red, code);
                                            return;
                                        }
                                        if (int.Parse(alllength) > 0)
                                        {
                                            if (int.Parse(alllength) != code.Text.Length)
                                            {
                                                OperateResult.AppendText(">>" + labeltype + "总长度[" + alllength + "]" + code.Text + "不匹配\n", Color.Red, code);
                                                return;
                                            }
                                        }
                                        string tempstr = code.Text.Replace(prefix, "");
                                        if (!(tempstr.Length >= int.Parse(length) && code.Text.Replace(prefix, "").Substring(0, int.Parse(length)) == sn_code.Text))
                                        {
                                            OperateResult.AppendText(">>" + labeltype + "截取SN" + code.Text + "不匹配\n", Color.Red, code);
                                            return;
                                        }
                                        LabelDataGridView.Rows[i].Cells["lcd_content"].Value = code.Text;
                                    }
                                    break;
                                }
                            }
                            //循环所有行，判断是否所有的内容都有值
                            List<string> labeltype_list = new List<string>();
                            List<string> prefix_list = new List<string>();
                            List<string> length_list = new List<string>();
                            List<string> value = new List<string>();
                            int checkcount = 0;
                            for (int i = 0; i < LabelDataGridView.Rows.Count; i++)
                            {
                                if (LabelDataGridView.Rows[i].Cells["lcd_content"].Value != null)
                                {
                                    checkcount = checkcount + 1;
                                    labeltype_list.Add(LabelDataGridView.Rows[i].Cells["lcd_labeltype"].Value.ToString());
                                    prefix_list.Add(LabelDataGridView.Rows[i].Cells["lcd_labeltype"].Value.ToString());
                                    length_list.Add(LabelDataGridView.Rows[i].Cells["lcd_length"].Value.ToString());
                                    value.Add(LabelDataGridView.Rows[i].Cells["lcd_content"].Value.ToString());
                                }
                                else
                                {
                                    AllCheck = false;
                                }
                            }
                            ////如果达到了行数，则判定校验通过
                            //if (checkcount == LabelDataGridView.Rows.Count)
                            //{
                            //    AllCheck = true;
                            //}
                            if (AllCheck)
                            {
                                sql.Clear();
                                sql.Append("insert into labelchecklog(LCL_ID, LCL_SN, LCL_LABELTYPE, lcl_prefix,lcl_length, LCL_LABELVALUE, LCL_STEPCODE, LCL_SOURCECODE," +
                                    " LCL_INMAN, LCL_DATE)" +
                                    "select labelchecklog_seq.nextval,'" + sn_code.Text + "',:LCL_LABELTYPE,:lcl_prefix,:lcl_length,:LCL_LABELVALUE,'" + User.CurrentStepCode + "'" +
                                    ",'" + User.UserSourceCode + "','" + User.UserCode + "',sysdate from dual");
                                dh.BatchInsert(sql.GetString(), new string[] { "LCL_LABELTYPE", "lcl_prefix", "lcl_length", "LCL_LABELVALUE" },
                                    labeltype_list.ToArray(), prefix_list.ToArray(), length_list.ToArray(), value.ToArray());
                                LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, oMakeCode, User.UserLineCode, User.UserSourceCode, "上料采集", "上料成功", sn_code.Text, "");
                                if (!Print.BarTender(Tag.ToString(), ref engine, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), Printer.Text, sn_code.Text, int.Parse(PrintNum.Text == "" ? "1" : PrintNum.Text), ma_code.Text, ma_prodcode.Text, "中箱标", "0", out ErrorMessage))
                                {
                                    OperateResult.AppendText(ErrorMessage + "\n", Color.Red);
                                }
                                if (!LogicHandler.SetStepResult(ma_code.Text, User.UserSourceCode, sn_code.Text, "标签核对", "标签核对完成", User.UserCode, out ErrorMessage))
                                {
                                    OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code);
                                    return;
                                }
                                OperateResult.AppendText(">>校验完成\n", Color.Green, code);
                            }
                        }
                    }
                    //勾选了下料的时候
                    else if (UnLoading.Checked)
                    {
                        if (LogicHandler.CheckStepSNAndMacode(ma_code.Text, User.UserSourceCode, code.Text, User.UserCode, out oMakeCode, out oMsid, out ErrorMessage))
                        {
                            sql.Clear();
                            sql.Append("select ms_firstsn,cm_makecode,cm_craftcode,nvl(cm_status,0)cm_status,cm_id,cm_stepcode,");
                            sql.Append("ms_makecode,cm_mccode,cm_materialtype from craftmaterial left join makeserial on cm_makecode");
                            sql.Append("=ms_makecode and cm_sncode=ms_sncode where cm_sncode='" + code.Text + "' and cm_makecode='" + oMakeCode + "'");
                            sql.Append("and cm_materialtype=1 and cm_stepcode='" + User.CurrentStepCode + "' ");
                            dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                            if (dt.Rows.Count > 0)
                            {
                                string ms_macode = dt.Rows[0]["ms_makecode"].ToString();
                                string ms_firstsn = dt.Rows[0]["ms_firstsn"].ToString();
                                string cm_stepcode = dt.Rows[0]["cm_stepcode"].ToString();
                                string cm_mccode = dt.Rows[0]["cm_mccode"].ToString();
                                string cm_materialtype = dt.Rows[0]["cm_materialtype"].ToString();
                                string cm_status = dt.Rows[0]["cm_status"].ToString();
                                string cm_makecode = dt.Rows[0]["cm_makecode"].ToString();
                                string cm_craftcode = dt.Rows[0]["cm_craftcode"].ToString();
                                //清除已被使用的序列号
                                sql.Clear();
                                sql.Append("update makeserial set ms_nextmacode='' where ms_sncode in(select cm_barcode from craftmaterial where ");
                                sql.Append("cm_makecode='" + cm_makecode + "' and cm_sncode='" + code.Text + "' and cm_stepcode='" + cm_stepcode + "' and cm_craftcode='" + cm_craftcode + "' ");
                                sql.Append("and cm_materialtype=1 and nvl(cm_status,0) =0) and ms_nextmacode='" + oMakeCode + "'");
                                dh.ExecuteSql(sql.GetString(), "update");
                                sql.Clear();
                                sql.Append("update makeserial set ms_nextstepcode=ms_stepcode where ms_id='" + ms_id + "'");
                                dh.ExecuteSql(sql.GetString(), "update");
                                //进行下料
                                sql.Clear();
                                sql.Append("delete from craftmaterial where (cm_sncode in (select sn from makesnrelation where firstsn");
                                sql.Append("='" + ms_firstsn + "') or cm_sncode = '" + ms_firstsn + "') and cm_makecode = '" + oMakeCode + "' ");
                                sql.Append("and cm_status = 0 and cm_stepcode='" + User.CurrentStepCode + "' and cm_materialtype=1");
                                dh.ExecuteSql(sql.GetString(), "delete");
                                LogicHandler.InsertMakeProcess(ms_macode, code.Text, User.UserSourceCode, "上料采集操作", "下料成功", User.UserCode);
                                //刷新界面值
                                sql.Clear();
                                sql.Append("select mcd_inqty,ma_qty-mcd_inqty mcd_remainqty ");
                                sql.Append("from make left join makecraftdetail on mcd_macode=ma_code where ");
                                sql.Append("ma_code='" + oMakeCode + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
                                dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                                BaseUtil.SetFormValue(Controls, dt);
                                LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, oMakeCode, User.UserLineCode, User.UserSourceCode, "上料采集", "下料成功", code.Text, "");
                                OperateResult.AppendText(">>序列号" + code.Text + "下料成功\n", Color.Green, code);
                            }
                            else OperateResult.AppendText(">>序列号" + code.Text + "未上料，无需下料\n", Color.Red, code);
                        }
                        else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code);
                    }
                }
                else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code);
            }
        }

        //获取采集的项目
        private void GetCollectItem()
        {
            if (LogicHandler.CheckStepSNAndMacode(ma_code.Text, User.UserSourceCode, code.Text, User.UserCode, out oMakeCode, out oMsid, out ErrorMessage))
            {
                nextstepcode = dh.getFieldDataByCondition("makeserial", "ms_nextstepcode", "ms_id='" + oMsid + "'").ToString();
                if (nextstepcode != User.CurrentStepCode)
                {
                    string stname = dh.getFieldDataByCondition("step", "st_name", "st_code='" + nextstepcode + "'").ToString();
                    OperateResult.AppendText("<<序列号:" + code.Text + "下一工序是" + stname + ",不是当前岗位的工序\n", Color.Red, code);
                    return;
                }
                //将录入框的值给序列号
                sn_code.Text = code.Text;
                code.Str = "";
                sql.Clear();
                sql.Append("select ma_prodcode,ma_ecncode,ma_softversion,ms_firstsn,ma_bomversion,ma_qty,ma_code,pr_spec,ms_status,ms_id,ms_craftcode,ms_nextstepcode");
                sql.Append(",ms_prodcode,ms_makecode,ms_code,ms_stepname  from makeserial left join make on ma_code=ms_makecode ");
                sql.Append("left join product on ms_prodcode=pr_code where ms_sncode='" + code.Text + "' order by ms_id desc");
                dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                if (dt.Rows.Count > 0)
                {
                    ms_id = dt.Rows[0]["ms_id"].ToString();
                    make_code = dt.Rows[0]["ma_code"].ToString();
                    mabomversion = dt.Rows[0]["ma_bomversion"].ToString();
                    make_prodcode = dt.Rows[0]["ms_prodcode"].ToString();
                    nextstepcode = dt.Rows[0]["ms_nextstepcode"].ToString();
                    ms_status = dt.Rows[0]["ms_status"].ToString();
                    ms_firstsn = dt.Rows[0]["ms_firstsn"].ToString();
                    BaseUtil.SetFormValue(this.Controls, dt);
                    LockMakeCode.Checked = true;
                    //勾选了前一工单

                    dt = (DataTable)dh.ExecuteSql("select ms_status,ms_stepcode,ms_nextstepcode from makeserial where ms_sncode='" + code.Text + "' and ms_makecode='" + ma_code.Text + "' order by ms_id desc", "select");
                    nextstepcode = dt.Rows[0]["ms_nextstepcode"].ToString();
                    ms_status = dt.Rows[0]["ms_status"].ToString();
                    sn_code.Text = code.Text;
                    code.Str = "";
                    sql.Clear();
                    sql.Append("select ma_code,ma_softversion,ma_ecncode,ma_prodcode,pr_spec,ma_qty from makeserial left join product ");
                    sql.Append(" on ms_prodcode=pr_code left join make on ms_makecode=ma_code left join ");
                    sql.Append("makecraftdetail on mcd_macode=ms_makecode where ms_id='" + oMsid + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
                    dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                    BaseUtil.SetFormValue(this.Controls, dt);
                    OperateResult.AppendText(">>获取序列号" + code.Text + "成功\n", Color.Green);
                    GetItem();
                }
                else
                {
                    OperateResult.AppendText(">>序列号" + code.Text + "不存在\n", Color.Red, code);
                    code.Text = "";
                    sn_code.Text = "";
                    code.Str = ma_prodcode.Text;
                }
            }
            else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code);
        }

        private void GetItem()
        {
            dt1 = (DataTable)dh.ExecuteSql("select lcd_sql,lcd_detno,LCD_LABELTYPE, nvl(lcd_alllength,0)lcd_alllength,nvl(LCD_LENGTH,0)LCD_LENGTH,lcd_suffix, LCD_PREFIX from LABELCHECKdetail left join labelcheck " +
                   "on lcd_lcid=lc_id where lc_prodcode='" + ma_prodcode.Text + "' and lcd_stepcode='" + User.CurrentStepCode + "' and LCD_LABELTYPE not in (select LCL_LABELTYPE from labelchecklog where " +
                   "LCL_SN='" + sn_code.Text + "') order by lcd_detno", "select");
            if (dt1.Rows.Count == 0)
            {
                OperateResult.AppendText(">>序列号" + code.Text + "未设置核对类型，或者已核对完成\n", Color.Red, code);
                sn_code.Clear();
                code.Str = ma_prodcode.Text;
            }
            BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt1);
        }

        private void ClearSn_code_Click(object sender, EventArgs e)
        {
            sn_code.Clear();
            CheckBarcode.Clear();
            code.Str = ma_prodcode.Text;
            if (dt1 != null)
                BaseUtil.CleanDataTableData(dt1);
            RemainIndex = 0;
            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 mcd_inqty,ma_qty-mcd_inqty mcd_remainqty ");
                    sql.Append("from make left join makecraftdetail_view on mcd_macode=ma_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);
                }
            }
        }

        private void ma_prodcode_TextChanged(object sender, EventArgs e)
        {
            DataTable _dt = (DataTable)dh.ExecuteSql("select la_id,la_url,la_isdefault from label where la_prodcode='" + ma_prodcode.Text + "' and la_templatetype='中箱标' and la_statuscode='AUDITED' order by la_isdefault", "select");
            PrintLabel.DataSource = _dt;
            PrintLabel.DisplayMember = "la_url";
            PrintLabel.ValueMember = "la_id";
            code.Str = ma_prodcode.Text;
        }

        private void PrintLabel_SelectedIndexChanged(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);
            }
        }
    }
}