mes-client/UAS_MES_PW/FunctionCode/Make/Make_CollectElec.cs

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.DataOperate;
using UAS_MES_NEW.Entity;
using UAS_MES_NEW.PublicMethod;

namespace UAS_MES_NEW.Make
{
    public partial class Make_CollectElec : Form
    {
        DataHelper dh;
        AutoSizeFormClass asc = new AutoSizeFormClass();
        LogStringBuilder sql = new LogStringBuilder();
        DataTable dt;
        //当前序列号记录
        string sn_code;
        //制造单号
        string macode;
        //采集网标号
        float net_code;
        //网标查询条件ms_id
        string oMsID;
        //判断是否输入网标
        Boolean isnetcode = false;
        //打印计数
        int printcount = 0;
        int ma_unlimitin;

        public Make_CollectElec()
        {
            InitializeComponent();
        }

        private void Make_CollectNetCode_Load(object sender, EventArgs e)
        {
            asc.controllInitializeSize(this);
            sncode.Focus();
            dh = SystemInf.dh;
            StepCount.StepCode = User.CurrentStepCode;
            StepCount.Source = User.UserSourceCode;
            StepCount.LineCode = User.UserLineCode;
            StepCount.Dh = dh;
            StepCount.Start();
        }

        private void sncode_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                string ErrorMessage2;
                string oMakeCode;
                //采集序列号
                if (!isnetcode)
                {
                    string[] arr = sncode.Text.Split(',');
                    if (arr.Length != 6)
                    {
                        OperateResult.AppendText(">>数据长度错误，无法解析\n", Color.Red);
                        return;
                    }
                    TSN.Text = arr[0];
                    PSN.Text = arr[1];
                    PKID.Text = arr[2];
                    KEY.Text = arr[3];
                    MAC.Text = arr[4];
                    IMEI.Text = arr[5];
                    if (CheckPSN.Checked&& dh.CheckExist("wincheck", "WC_SNCODE<>'" + TSN.Text + "' and (WC_PSN='" + PSN.Text + "')"))
                    {
                        OperateResult.AppendText(">>PSN重复信息\n", Color.Red);
                        return;
                    }
                    if (CheckMac.Checked&& dh.CheckExist("wincheck", "WC_SNCODE<>'" + TSN.Text + "' and (WC_MAC='" + MAC.Text + "' )"))
                    {
                        OperateResult.AppendText(">>MAC重复信息\n", Color.Red);
                        return;
                    }
                    if (CheckPKID.Checked&& dh.CheckExist("wincheck", "WC_SNCODE<>'" + TSN.Text + "' and (WC_PKID='" + PKID.Text + "')") && PKID.Text != "NONE")
                    {
                        OperateResult.AppendText(">>PKID重复信息\n", Color.Red);
                        return;
                    }
                    if (CheckKey.Checked&& dh.CheckExist("wincheck", "WC_SNCODE<>'" + TSN.Text + "' and (WC_KEY='" + KEY.Text + "')") && KEY.Text != "NONE")
                    {
                        OperateResult.AppendText(">>KEY重复信息\n", Color.Red);
                        return;
                    }
                    if (CheckImei.Checked&&dh.CheckExist("wincheck", "WC_SNCODE<>'" + TSN.Text + "' and (WC_IMEI='" + IMEI.Text + "')"))
                    {
                        OperateResult.AppendText(">>IMEI重复信息\n", Color.Red);
                        return;
                    }

                    sncode.Text = TSN.Text;
                    if (sncode.Text == "")
                    {
                        OperateResult.AppendText(">>序列号不能为空\n", Color.Red);
                        return;
                    }
                    if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out ErrorMessage2))
                    {
                        //判断界面工单是否为空时的序列号是否自动归属工单
                        string oStatus = "";
                        string sn_code = "";
                        dt = (DataTable)dh.ExecuteSql("select ms_sncode from makeserial where ms_sncode ='" + TSN.Text + "' or ms_firstsn='" + TSN.Text + "' order by ms_id desc", "select");
                        if (dt.Rows.Count > 0)
                        {
                            sn_code = dt.Rows[0]["ms_sncode"].ToString();
                        }
                        if (!LogicHandler.GetMakeInfo(sn_code, out oMakeCode, out oStatus, out ErrorMessage2))
                        {
                            if (ms_makecode.Text == "")
                            {
                                OperateResult.AppendText(">>" + ErrorMessage2 + "\n", Color.Red, sncode);
                                return;
                            }
                        }
                        OperateResult.AppendText("<<" + sn_code + "\n", Color.Black);
                        // 获取工单归属工单下一工序是否正确
                        if (LogicHandler.CheckStepSNAndMacode(ms_makecode.Text == "" ? oMakeCode : ms_makecode.Text, User.UserSourceCode, sn_code, User.UserCode, out oMakeCode, out oMsID, out ErrorMessage2))
                        {
                            sql.Clear();
                            sql.Append("select ms_makecode,ms_prodcode,pr_detail,nvl(pr_electricmax,0)pr_electricmax,nvl(pr_electricmin,0)pr_electricmin from makeserial left join product on ");
                            sql.Append(" ms_prodcode = pr_code where ms_id  = '" + oMsID + "'");
                            dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                            BaseUtil.SetFormValue(this.Controls, dt);
                            OperateResult.AppendText(">>请输入核对参数\n", Color.Black);
                            sn_code = sncode.Text;
                            sncode.Text = "";
                            isnetcode = true;
                            return;
                        }
                        else OperateResult.AppendText(">>" + ErrorMessage2 + "\n", Color.Red, sncode);
                    }
                    else OperateResult.AppendText(">>" + ErrorMessage2 + "\n", Color.Red, sncode);
                }
                //采集netcode
                else
                {
                    if (CheckTSN.Checked)
                    {
                        if (TSN_CHECK.Text == "")
                        {
                            if (TSN.Text == sncode.Text)
                            {
                                TSN_CHECK.Text = sncode.Text;
                                {
                                    OperateResult.AppendText(">>TSN核对成功\n", Color.Green);
                                    if (CheckInfoPass())
                                    {
                                        dh.ExecuteSql("insert into wincheck(WC_ID, WC_SNCODE, WC_PSN, WC_PKID, WC_KEY, WC_MAC, WC_IMEI) values(wincheck_seq.nextval,'" + TSN.Text + "','" + PSN.Text + "','" + PKID.Text + "','" + KEY.Text + "','" + MAC.Text + "','" + IMEI.Text + "')", "insert");
                                        isnetcode = false;
                                        sncode.Text = "";
                                        sncode.Focus();
                                        CleanData();
                                        return;
                                    }
                                    return;
                                }
                            }
                            else
                            {
                                OperateResult.AppendText(">>TSN核对错误，请重新输入\n", Color.Red);
                                return;
                            }
                        }
                    }
                    if (CheckPSN.Checked)
                    {
                        if ((!CheckTSN.Checked || TSN_CHECK.Text != "") && PSN_CHECK.Text == "")
                        {
                            if (PSN.Text == sncode.Text)
                            {
                                PSN_CHECK.Text = sncode.Text;
                                {
                                    OperateResult.AppendText(">>PSN核对成功\n", Color.Green);
                                    if (CheckInfoPass())
                                    {
                                        dh.ExecuteSql("insert into wincheck(WC_ID, WC_SNCODE, WC_PSN, WC_PKID, WC_KEY, WC_MAC, WC_IMEI) values(wincheck_seq.nextval,'" + TSN.Text + "','" + PSN.Text + "','" + PKID.Text + "','" + KEY.Text + "','" + MAC.Text + "','" + IMEI.Text + "')", "insert");
                                        isnetcode = false;
                                        sncode.Text = "";
                                        sncode.Focus();
                                        CleanData();
                                        return;
                                    }
                                    return;
                                }
                            }
                            else
                            {
                                OperateResult.AppendText(">>PSN核对错误，请重新输入\n", Color.Red);
                                return;
                            }
                        }
                    }
                    if (CheckPKID.Checked)
                    {
                        if ((!CheckTSN.Checked || TSN_CHECK.Text != "" || !CheckPSN.Checked || PSN_CHECK.Text != "") && PKID_CHECK.Text == "")
                        {
                            if (PKID.Text == sncode.Text)
                            {
                                PKID_CHECK.Text = sncode.Text;
                                {
                                    OperateResult.AppendText(">>PKID核对成功\n", Color.Green);
                                    if (CheckInfoPass())
                                    {
                                        dh.ExecuteSql("insert into wincheck(WC_ID, WC_SNCODE, WC_PSN, WC_PKID, WC_KEY, WC_MAC, WC_IMEI) values(wincheck_seq.nextval,'" + TSN.Text + "','" + PSN.Text + "','" + PKID.Text + "','" + KEY.Text + "','" + MAC.Text + "','" + IMEI.Text + "')", "insert");
                                        isnetcode = false;
                                        sncode.Text = "";
                                        sncode.Focus();
                                        CleanData();
                                        return;
                                    }
                                    return;
                                }
                            }
                            else
                            {
                                OperateResult.AppendText(">>PKID核对错误，请重新输入\n", Color.Red);
                                return;
                            }
                        }
                    }
                    if (CheckKey.Checked)
                    {
                        if ((!CheckTSN.Checked || TSN_CHECK.Text != "" || !CheckPSN.Checked || PSN_CHECK.Text != "" || !CheckPKID.Checked || PKID_CHECK.Text != "") && KEY_CHECK.Text == "")
                        {
                            if (KEY.Text == sncode.Text)
                            {
                                KEY_CHECK.Text = sncode.Text;
                                {
                                    OperateResult.AppendText(">>KEY核对成功\n", Color.Green);
                                    if (CheckInfoPass())
                                    {
                                        dh.ExecuteSql("insert into wincheck(WC_ID, WC_SNCODE, WC_PSN, WC_PKID, WC_KEY, WC_MAC, WC_IMEI) values(wincheck_seq.nextval,'" + TSN.Text + "','" + PSN.Text + "','" + PKID.Text + "','" + KEY.Text + "','" + MAC.Text + "','" + IMEI.Text + "')", "insert");
                                        isnetcode = false;
                                        sncode.Text = "";
                                        sncode.Focus();
                                        CleanData();
                                        return;
                                    }
                                    return;
                                }
                            }
                            else
                            {
                                OperateResult.AppendText(">>KEY核对错误，请重新输入\n", Color.Red);
                                return;
                            }
                        }
                    }
                    if (CheckMac.Checked)
                    {
                        if ((!CheckTSN.Checked || TSN_CHECK.Text != "" || !CheckPSN.Checked || PSN_CHECK.Text != "" || !CheckPKID.Checked || PKID_CHECK.Text != "" || !CheckKey.Checked || KEY_CHECK.Text != "") && MAC_CHECK.Text == "")
                        {
                            if (MAC.Text == sncode.Text)
                            {
                                MAC_CHECK.Text = sncode.Text;
                                {
                                    OperateResult.AppendText(">>MAC核对成功\n", Color.Green);
                                    if (CheckInfoPass())
                                    {
                                        dh.ExecuteSql("insert into wincheck(WC_ID, WC_SNCODE, WC_PSN, WC_PKID, WC_KEY, WC_MAC, WC_IMEI) values(wincheck_seq.nextval,'" + TSN.Text + "','" + PSN.Text + "','" + PKID.Text + "','" + KEY.Text + "','" + MAC.Text + "','" + IMEI.Text + "')", "insert");
                                        isnetcode = false;
                                        sncode.Text = "";
                                        sncode.Focus();
                                        CleanData();
                                        return;
                                    }
                                    return;
                                }
                            }
                            else
                            {
                                OperateResult.AppendText(">>MAC核对错误，请重新输入\n", Color.Red);
                                return;
                            }
                        }
                    }
                    if (CheckImei.Checked)
                    {
                        if ((!CheckTSN.Checked || TSN_CHECK.Text != "" || !CheckPSN.Checked || PSN_CHECK.Text != "" || !CheckPKID.Checked || PKID_CHECK.Text != "" || !CheckKey.Checked || KEY_CHECK.Text != "" || !CheckMac.Checked || MAC_CHECK.Text != "") && IMEI_CHECK.Text == "")
                        {
                            if (IMEI.Text == sncode.Text)
                            {
                                IMEI_CHECK.Text = sncode.Text;
                                {
                                    OperateResult.AppendText(">>IMEI核对成功\n", Color.Green);
                                    if (CheckInfoPass())
                                    {
                                        dh.ExecuteSql("insert into wincheck(WC_ID, WC_SNCODE, WC_PSN, WC_PKID, WC_KEY, WC_MAC, WC_IMEI) values(wincheck_seq.nextval,'" + TSN.Text + "','" + PSN.Text + "','" + PKID.Text + "','" + KEY.Text + "','" + MAC.Text + "','" + IMEI.Text + "')", "insert");
                                        isnetcode = false;
                                        sncode.Text = "";
                                        sncode.Focus();
                                        CleanData();
                                        return;
                                    }
                                    return;
                                }
                            }
                            else
                            {
                                OperateResult.AppendText(">>IMEI核对错误，请重新输入\n", Color.Red);
                                return;
                            }
                        }
                    }
                }
            }
        }

        private void CleanData()
        {

            TSN.Clear();
            PSN.Clear();
            PKID.Clear();
            IMEI.Clear();
            MAC.Clear();
            KEY.Clear();
            TSN_CHECK.Clear();
            PSN_CHECK.Clear();
            PKID.Clear();
            IMEI.Clear();
            MAC.Clear();
            KEY.Clear();
            OperateResult.AppendText(">>核对完成，请重新输入SN号\n", Color.Green);
        }

        private bool CheckInfoPass()
        {
            if (CheckTSN.Checked)
            {
                if (TSN.Text != TSN_CHECK.Text)
                {
                    return false;
                }
            }
            if (CheckPSN.Checked)
            {
                if (PSN.Text != PSN_CHECK.Text)
                    return false;
            }
            if (CheckPKID.Checked)
            {
                if (PKID.Text != PKID_CHECK.Text)
                    return false;
            }
            if (CheckKey.Checked)
            {
                if (KEY.Text != KEY_CHECK.Text)
                    return false;
            }
            if (CheckMac.Checked)
            {
                if (MAC.Text != MAC_CHECK.Text)
                    return false;
            }
            if (CheckImei.Checked)
            {
                if (IMEI.Text != IMEI_CHECK.Text)
                    return false;
            }
            string ErrorMessage2;

            string sn_code = "";
            dt = (DataTable)dh.ExecuteSql("select ms_sncode from makeserial where ms_sncode ='" + TSN.Text + "' or ms_firstsn='" + TSN.Text + "' order by ms_id desc", "select");
            if (dt.Rows.Count > 0)
            {
                sn_code = dt.Rows[0]["ms_sncode"].ToString();
            }
            if (!LogicHandler.SetStepResult(ms_makecode.Text, User.UserSourceCode, sn_code, "核对标签信息", "核对成功", User.UserCode, out ErrorMessage2))
            {
                OperateResult.AppendText(">>" + ErrorMessage2 + "\n", Color.Red);
            }
            else
            {

            }
            return true;
        }

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

        private void Make_CollectNetCode_Activated(object sender, EventArgs e)
        {
            sncode.Focus();
        }

        private void deleteButton1_Click(object sender, EventArgs e)
        {
            CleanData();
        }

        private void StepCount_Load(object sender, EventArgs e)
        {

        }
    }
}