mes-client/UAS_MES_YDCY/FunctionCode/OQC/OQC_QCRecheck.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using System.Windows.Forms;
using UAS_MES_NEW.DataOperate;
using UAS_MES_NEW.Entity;
using UAS_MES_NEW.PublicMethod;

namespace UAS_MES_NEW.OQC
{
    public partial class OQC_QCRecheck : Form
    {

        DataHelper dh = SystemInf.dh;

        LogStringBuilder sql = new LogStringBuilder();

        public OQC_QCRecheck()
        {
            InitializeComponent();
        }

        private void Confirm_Click(object sender, EventArgs e)
        {
            if (inputreson.Text == "")
            {
                OperateResult.AppendText(">>下地原因必填\n", Color.Red);
                return;
            }
            //获取序列号的途程
            DataTable dt = (DataTable)dh.ExecuteSql("select nvl(MS_IFQCCHECK,0)MS_IFQCCHECK,ms_makecode,ms_stepcode,ms_status,pr_detail,ms_outboxcode,ms_sncode,ms_firstsn,ms_id,ms_nextstepcode,ms_currentstepcode,ms_makecode,ms_status,ms_checkno,ms_craftcode,ms_prodcode,ms_stepcode,nvl(ms_qccheck,0)ms_qccheck from makeserial left join product on pr_code=ms_prodcode where (ms_sncode='" + sn_code.Text + "'  or ms_imei1='" + sn_code.Text + "' and ms_imei2='" + sn_code.Text + "')  order by ms_id desc", "select");
            if (dt.Rows.Count > 0)
            {
                pr_code.Text = dt.Rows[0]["ms_prodcode"].ToString();
                string ms_makecode = dt.Rows[0]["ms_makecode"].ToString();
                string ms_stepcode = dt.Rows[0]["ms_stepcode"].ToString();
                string ms_status = dt.Rows[0]["ms_status"].ToString();
                string ms_ifqccheck = dt.Rows[0]["MS_IFQCCHECK"].ToString();
                pr_detail.Text = dt.Rows[0]["pr_detail"].ToString();
                if (ms_ifqccheck == "-1" && ms_status == "3")
                {
                    OperateResult.AppendText(">>序列号" + sn_code.Text + "不处于QC判定状态\n", Color.Red, sn_code);
                    return;
                }
                string[] param = new string[] { "MakeDown", "0", ms_makecode };
                dh.CallProcedure("SP_GETMAXNUMBER", ref param);
                string mdcode = param[2];
                string sp_date = dh.getFieldDataByCondition("steppassed", "to_char(max(sp_date),'yyyy-mm-dd hh24:mi:ss')", "sp_stepcode='" + ms_stepcode + "' and sp_makecode='" + ms_makecode + "' and sp_sncode='" + sn_code.Text + "'").ToString();
                dh.ExecuteSql("update makeserial set ms_downcode='" + mdcode + "',ms_downstatus=-1 where ms_sncode in (select sp_sncode from steppassed where sp_date>to_date('" + sp_date + "','yyyy-mm-dd hh24:mi:ss')-30/1440 and " +
                    " sp_date<to_date('" + sp_date + "','yyyy-mm-dd hh24:mi:ss')+30/1440 and  sp_stepcode='" + ms_stepcode + "' and sp_makecode='" + ms_makecode + "') ", "update");

                sql.Clear();
                sql.Append("INSERT INTO MAKEDOWN (MD_ID,MD_LINECODE,MD_SCCODE,MD_STEPCODE,");
                sql.Append("MD_SNCODE,MD_PRODCODE,MD_MACODE, MD_DOWNREASON, MD_CODE,");
                sql.Append("MD_DOWNDATE,MD_DOWNMAN,MD_STATUS) select MAKEDOWN_seq.nextval,'" + User.UserLineCode + "','" + User.UserSourceCode + "',");
                sql.Append("'" + User.CurrentStepCode + "',ms_sncode,'" + pr_code.Text + "','" + ms_makecode + "','" + inputreson.Text + "','" + mdcode + "',sysdate,'" + User.UserCode + "','-1' from " +
                    "makeserial where  ms_sncode in (select sp_sncode from steppassed where sp_date>to_date('" + sp_date + "','yyyy-mm-dd hh24:mi:ss')-30/1440 and sp_date<to_date('" + sp_date + "','yyyy-mm-dd hh24:mi:ss')+30/1440 and  sp_stepcode='" + ms_stepcode + "' and sp_makecode='" + ms_makecode + "')");
                //执行
                dh.ExecuteSql(sql.GetString(), "insert");
                LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_makecode, User.UserLineCode, User.UserSourceCode, "锁定不良品", "锁定不良品", sn_code.Text, "");
                OperateResult.AppendText(">>序列号" + sn_code.Text + "锁定不良品\n", Color.Green, sn_code);
            }
            else OperateResult.AppendText(">>序列号" + sn_code.Text + "不存在\n", Color.Red, sn_code);
        }

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

        private void Special_CancelCollection_Load(object sender, EventArgs e)
        {

        }

        DataTable Dbfind;
        private void pr_code_DbChange(object sender, EventArgs e)
        {

        }

        private void sn_code_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                DataTable dt = (DataTable)dh.ExecuteSql("select pr_detail,ms_outboxcode,ms_sncode,ms_firstsn,ms_id,ms_nextstepcode,ms_currentstepcode,ms_makecode,ms_status,ms_checkno,ms_craftcode,ms_prodcode,ms_stepcode,nvl(ms_qccheck,0)ms_qccheck from makeserial left join product on pr_code=ms_prodcode where (ms_sncode='" + sn_code.Text + "'  or ms_imei1='" + sn_code.Text + "' and ms_imei2='" + sn_code.Text + "')  order by ms_id desc", "select");
                if (dt.Rows.Count > 0)
                {
                    pr_code.Text = dt.Rows[0]["ms_prodcode"].ToString();
                    string ms_makecode = dt.Rows[0]["ms_makecode"].ToString();
                    string ms_qccheck = dt.Rows[0]["ms_qccheck"].ToString();
                    pr_detail.Text = dt.Rows[0]["pr_detail"].ToString();
                }
                else OperateResult.AppendText(">>序列号" + sn_code.Text + "不存在\n", Color.Red, sn_code);
            }
        }
    }
}