mes-client/UAS_MES_YDCY/FunctionCode/Make/Make_SNLabelCheckPallet.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_SNLabelCheckPallet : 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_SNLabelCheckPallet()
        {
            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 (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, "");
                                OperateResult.AppendText(">>校验完成\n", Color.Green, code);
                                sn_code.Text = "";
                            }
                        }
                    }
                }
                else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code);
            }
        }

        //获取采集的项目
        private void GetCollectItem()
        {
            //将录入框的值给序列号
            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_outboxcode='" + 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;
                //勾选了前一工单
                sn_code.Text = code.Text;
                code.Str = "";
                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;
            }
        }

        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,lcd_stepcode) not in (select LCL_LABELTYPE,LCL_STEPCODE 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))
                {
                    sql.Clear();
                    sql.Append("select ma_prodcode,pr_detail,mcd_inqty,ma_qty-mcd_inqty mcd_remainqty ");
                    sql.Append("from make left join product on pr_code=ma_prodcode left join makecraftdetail_view on mcd_macode=ma_code where ");
                    sql.Append("ma_code='" + ma_code.Text + "'");
                    DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                    if (dt.Rows.Count > 0)
                        BaseUtil.SetFormValue(Controls, dt);
                }
            }
        }
    }
}