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

using NPOI.SS.Formula;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using UAS_MES_NEW.CustomControl.ButtonUtil;
using UAS_MES_NEW.DataOperate;
using UAS_MES_NEW.Entity;
using UAS_MES_NEW.PublicMethod;

namespace UAS_MES_NEW.Make
{
    public partial class Make_PcbCleanCheck : Form
    {
        public Make_PcbCleanCheck()
        {
            InitializeComponent();
        }

        LogStringBuilder sql = new LogStringBuilder();
        DataTable Dbfind;
        DataHelper dh;
        DataTable dt;

        private void Make_BurnInfo_Load(object sender, EventArgs e)
        {
            dh = SystemInf.dh;

            ms_makecode_Val.Enabled = false;
            LineVal.Enabled = false;
            SideVal.Enabled = false;
            EmployeeVal.Enabled = false;
            SpecVal.Enabled = false;

            SnVal.Focus();
            SnVal.SelectAll();
        }

        private void SnVal_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode != Keys.Enter) return;
            SnVal.Text = SnVal.Text.Trim();

            CheckEmployeeVal.Text = CheckEmployeeVal.Text.Trim();

            if (string.IsNullOrEmpty(CheckEmployeeVal.Text))
            {
                ShowMsg(0, $"请输入操作人员");
                return;
            }

            dt = (DataTable)dh.ExecuteSql($@"SELECT * FROM sn_clean WHERE sn = '{SnVal.Text}'", "select");
            if (dt.Rows.Count == 0)
            {
                ShowMsg(0, $"序列号:{SnVal.Text} 无清洗记录，无法核对");
                return;
            }

            LineVal.Items.Clear();
            SideVal.Items.Clear();

            dt = (DataTable)dh.ExecuteSql($@"SELECT * FROM sn_clean,make,product WHERE clean_id = (SELECT MAX(clean_id) 
                FROM sn_clean WHERE sn = '{SnVal.Text}') AND work_order = ma_code AND ma_prodcode = pr_code", "select");

            ms_makecode_Val.Text = dt.Rows[0]["WORK_ORDER"].ToString();
            LineVal.Items.Add(dt.Rows[0]["LINE"].ToString());
            SideVal.Items.Add(dt.Rows[0]["SIDE"].ToString());
            EmployeeVal.Text = dt.Rows[0]["UPDATE_NAME"].ToString();
            SpecVal.Text = dt.Rows[0]["PR_SPEC"].ToString();
            LineVal.SelectedIndex = 0;
            SideVal.SelectedIndex = 0;

            string singleSn;
            dt = (DataTable)dh.ExecuteSql($@"SELECT * FROM smtbind WHERE sb_maincode IN 
                (SELECT sb_maincode FROM smtbind WHERE sb_barcode = '{SnVal.Text}')", "select");
            if (dt.Rows.Count > 0)
            {
                foreach (DataRow item in dt.Rows)
                {
                    singleSn = item["sb_barcode"].ToString();

                    if (string.IsNullOrEmpty(singleSn))
                    {
                        continue;
                    }

                    dh.ExecuteSql($@"UPDATE sn_clean SET check_type = -1,check_time = sysdate,check_name = '{CheckEmployeeVal.Text}'
                        WHERE clean_id = (SELECT MAX(clean_id) FROM sn_clean WHERE sn = '{singleSn}')", "update");
                    ShowMsg(1, $"序列号:{singleSn} 核对清洗成功");
                }
            }
            SnVal.Text = "";

            dt = (DataTable)dh.ExecuteSql($@"SELECT sn,work_order,line,side,update_time,update_name,check_type FROM sn_clean WHERE work_order = '{ms_makecode_Val.Text}'", "select");
            if (dt.Rows.Count > 0)
            {
                DataBox.DataSource = dt;
            }
        }

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

        private void ShowMsg(int type, string msg)
        {
            string fullDateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            if (type == 0)
            {
                OperateResult.AppendText($"{fullDateTime}: {msg}\n", Color.Red);
            }
            else if (type == 1)
            {
                OperateResult.AppendText($"{fullDateTime}: {msg}\n", Color.Green);
            }
        }
    }
}