mes-client/UAS-MES/FunctionCode/OQC/OQC_BatchResultJudge.cs

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

namespace UAS_MES.OQC
{
    public partial class OQC_BatchResultJudge : Form
    {
        AutoSizeFormClass asc = new AutoSizeFormClass();
        DataHelper dh;
        LogStringBuilder sql = new LogStringBuilder();
        DataTable dt;
        string ErrorMessage = "";
        /// <summary>
        /// 是否通过资源验证
        /// </summary>
        bool PassCheckStep = false;
        public OQC_BatchResultJudge()
        {
            InitializeComponent();
        }

        private void 抽检批维护_Load(object sender, EventArgs e)
        {
            dh = new DataHelper();
            ob_checkno.Focus();
            asc.controllInitializeSize(this);
        }

        private void GetBatch_Click(object sender, EventArgs e)
        {
            if (CheckStep())
            {
                PassCheckStep = true;
                string ErrorMessage = "";
                DataTable[] dt = LogicHandler.GetOQCBatch(ms_sncode.Text, obd_outboxcode.Text, ob_checkno.Text, "OQCResultDetermine", out ErrorMessage);
                if (ErrorMessage == "")
                {
                    BaseUtil.SetFormValue(Controls, dt[0]);
                    switch (ob_result.Text)
                    {
                        case "OK":
                            BatchPass.Enabled = false;
                            BatchRejection.Enabled = false;
                            ForcePass.Enabled = false;
                            ForceRejection.Enabled = false;
                            WithdrawPass.Enabled = true;
                            WithdrawRejection.Enabled = false;
                            break;
                        case "FOK":
                            BatchPass.Enabled = false;
                            BatchRejection.Enabled = false;
                            ForcePass.Enabled = false;
                            ForceRejection.Enabled = false;
                            WithdrawPass.Enabled = true;
                            WithdrawRejection.Enabled = false;
                            break;
                        case "NG":
                            BatchPass.Enabled = false;
                            BatchRejection.Enabled = false;
                            ForcePass.Enabled = false;
                            ForceRejection.Enabled = false;
                            WithdrawPass.Enabled = false;
                            WithdrawRejection.Enabled = true;
                            break;
                        case "FNG":
                            BatchPass.Enabled = false;
                            BatchRejection.Enabled = false;
                            ForcePass.Enabled = false;
                            ForceRejection.Enabled = false;
                            WithdrawPass.Enabled = false;
                            WithdrawRejection.Enabled = true;
                            break;
                        case "":
                            if (ob_checkno.Text != "")
                            {
                                BatchPass.Enabled = true;
                                BatchRejection.Enabled = true;
                                ForcePass.Enabled = true;
                                ForceRejection.Enabled = true;
                                WithdrawPass.Enabled = true;
                                WithdrawRejection.Enabled = true;
                            }
                            break;
                        default:
                            break;
                    }
                }
                else
                {
                    BaseUtil.CleanForm(this);
                    BatchPass.Enabled = false;
                    BatchRejection.Enabled = false;
                    ForcePass.Enabled = false;
                    ForceRejection.Enabled = false;
                    WithdrawPass.Enabled = false;
                    WithdrawRejection.Enabled = false;
                    OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
                }
            }
            else
            {
                PassCheckStep = false;
            }
        }

        private void BatchPass_Click(object sender, EventArgs e)
        {
            if (CheckBefore() && PassCheckStep)
            {
                if (int.Parse(ob_ngqty.Text == "" ? "0" : ob_ngqty.Text) <= int.Parse(ob_maxngacceptqty.Text == "" ? ob_maxngacceptqty.Text : ob_maxngacceptqty.Text))
                {
                    dh.ExecuteSql("update OQCBatch set ob_status='OK',ob_result='OK' where ob_checkno='" + ob_checkno.Text + "'", "select");
                    DoLog("批次通过", "批次通过成功", "通过");
                    GetBatch.PerformClick();
                    OperateResult.AppendText(">>通过批成功\n", Color.Green);
                }
                else
                    OperateResult.AppendText(">>当前批次不合格数为" + ob_ngqty.Text + ",大于最大不合格允通过数" + ob_maxngacceptqty.Text + "\n", Color.Red);
            }
        }

        private void BatchRejection_Click(object sender, EventArgs e)
        {
            if (CheckBefore() && PassCheckStep)
            {
                sql.Clear();
                sql.Append("select max(nvl(ad_maxngacceptqty,0)) maxngacceptqty from QUA_Aql,QUA_AqlDetail where al_id=ad_alid ");
                sql.Append("and al_statuscode='AUDITED'  and al_code ='" + ob_aqlcode.Text + "' and " + (ob_nowcheckqty.Text != "" ? ob_nowcheckqty.Text : "0") + " >= ad_minqty ");
                sql.Append("and " + (ob_nowcheckqty.Text != "" ? ob_nowcheckqty.Text : "0") + "<=ad_maxqty ");
                dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                dh.ExecuteSql("update OQCBatch set ob_status='NG',ob_result='NG' where ob_checkno='" + ob_checkno.Text + "'", "select");
                //如果勾选了发起反攻需求则新增记录
                if (ReworkRequire.Checked)
                {
                    string re_id = dh.GetSEQ("rework_seq");
                    string re_code = dh.GetSerialNumberByCaller("Rework");
                    sql.Clear();
                    sql.Append("insert into rework (re_id ,re_code,re_indate,re_inman,re_status,re_statuscode,");
                    sql.Append("re_rwstatus,re_prodcode,re_qty, re_description,re_source,re_sourcemo,re_checkno) ");
                    sql.Append(" select " + re_id + ",'" + re_code + "',sysdate,'" + User.UserName + "','在录入','ENTERING','未返工',");
                    sql.Append("OQCBatch.ob_prodcode,OQCBatch.ob_batchqty,OQCBatch.ob_description,'批判退发起返工',OQCBatch.ob_makecode,OQCBatch.ob_checkno from oqcbatch where ob_checkno='" + ob_checkno.Text + "'");
                    dh.ExecuteSql(sql.GetString(), "insert");
                    sql.Clear();
                    sql.Append("insert into ReworkDetail (rd_id,rd_reid,rd_detno,rd_sncode,rd_prodcode,rd_checkno,rd_indate,rd_inman,rd_rwstatus) ");
                    sql.Append("select ReworkDetail_seq.nextval," + re_id + ",rownum,OQCBatchDetail.obd_sncode,ob_prodcode,ob_checkno,sysdate,'" + User.UserName + "','未返工' ");
                    sql.Append("from OQCBatch  left join OQCBatchDetail on obd_obid=ob_id where ob_checkno='" + ob_checkno.Text + "'");
                    dh.ExecuteSql(sql.GetString(), "insert");
                    //将工单信息写回到OQC主表
                    dh.ExecuteSql("update oqcbatch set ob_rmcode='"+re_code+"' where ob_checkno='"+ob_checkno.Text+"'", "update");
                }
                DoLog("判退通过", "批次判退成功", "通过");
                OperateResult.AppendText(">>判退批成功\n", Color.Green);
                GetBatch.PerformClick();
            }
        }

        private void ForcePass_Click(object sender, EventArgs e)
        {
            if (PassCheckStep)
            {
                dh.ExecuteSql("update OQCBatch set ob_status='OK' ,ob_result='FOK' where ob_checkno='" + ob_checkno.Text + "'", "select");
                DoLog("强制通过", "强制通过成功", "通过");
                GetBatch.PerformClick();
                OperateResult.AppendText(">>强制通过批" + ob_checkno.Text + "成功\n", Color.Green);
            }
        }

        private void ForceRejection_Click(object sender, EventArgs e)
        {
            if (PassCheckStep)
            {
                dh.ExecuteSql("update OQCBatch set ob_status='NG' ,ob_result='FNG' where ob_checkno='" + ob_checkno.Text + "'", "select");
                DoLog("强制判退通过", "强制判退通过成功", "判退");
                GetBatch.PerformClick();
                OperateResult.AppendText(">>强制撤销批" + ob_checkno.Text + "成功\n", Color.Green);
            }
        }

        private void WithdrawPass_Click(object sender, EventArgs e)
        {
            if (PassCheckStep)
            {
                if (ob_result.Text == "OK" || ob_result.Text == "FOK")
                {
                    dh.ExecuteSql("update OQCBatch set ob_status='CHECKING' ,ob_result='' where ob_checkno='" + ob_checkno.Text + "'", "select");
                    ob_result.Text = "";
                    DoLog("撤销通过", "撤销通过成功", "撤销");
                    OperateResult.AppendText(">>撤销通过批" + ob_checkno.Text + "成功\n", Color.Green);
                    GetBatch.PerformClick();
                }
                else
                {
                    OperateResult.AppendText(">>该抽检批次未通过,无需撤销通过\n", Color.Red);
                }
            }
        }

        private void WithdrawRejection_Click(object sender, EventArgs e)
        {
            if (PassCheckStep)
            {
                if (ob_result.Text == "NG" || ob_result.Text == "FNG")
                {
                    dt = (DataTable)dh.ExecuteSql("select re_statuscode from rework where re_checkno='" + ob_checkno.Text + "'", "select");
                    if (dt.Rows.Count > 0)
                    {
                        if (dt.Rows[0]["re_statuscode"].ToString() == "AUDITED")
                        {
                            OperateResult.AppendText(">>该批次存在已审核的返修工单，不允许撤销\n", Color.Red);
                            return;
                        }
                        else
                        {
                            string logout_confirm = MessageBox.Show("已存在返修工单,撤销会删除该工单，是否继续", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
                            if (logout_confirm == "Yes")
                            {
                                dh.ExecuteSql("delete from reworkdetail where rd_checkno='" + ob_checkno.Text + "' ", "delete");
                                dh.ExecuteSql("delete from rework where re_checkno='" + ob_checkno.Text + "' ", "delete");
                            }
                            else return;
                        }
                    }
                    dh.ExecuteSql("update OQCBatch set ob_status='CHECKING' ,ob_result='' where ob_checkno='" + ob_checkno.Text + "'", "select");
                    ob_result.Text = "";
                    DoLog("撤销判退", "撤销判退成功", "撤销");
                    OperateResult.AppendText(">>撤销判退成功\n", Color.Green);
                    GetBatch.PerformClick();
                }
                else OperateResult.AppendText(">>该抽检批次未判退,无需撤销判退\n", Color.Red);
            }
        }

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

        /// <summary>
        /// 操作之前通用的验证逻辑
        /// </summary>
        /// <returns></returns>
        private bool CheckBefore()
        {
            if (ob_status.Text == "检验中")
            {
                if (ob_maxngacceptqty.Text == "" || ob_maxngacceptqty.Text == "0")
                {
                    if (ob_aqlcode.Text == "")
                        OperateResult.AppendText(">>最大不合格允许通过数为空的时候必须填写维护AQL标准\n", Color.Red);
                    else
                    {
                        dt = (DataTable)dh.ExecuteSql("select nvl(ad_minqty,0)ad_minqty,nvl(ad_maxqty,0)ad_maxqty,nvl(ad_maxngacceptqty,0)ad_maxngacceptqty from QUA_Aql left join qua_aqldetail on ad_alid=al_id where al_code='" + ob_aqlcode.Text + "'", "select");
                        if (dt.Rows.Count > 0)
                        {
                            for (int i = 0; i < dt.Rows.Count; i++)
                            {
                                int batchqty = int.Parse(ob_nowcheckqty.Text == "" ? "0" : ob_nowcheckqty.Text);
                                int minqty = int.Parse(dt.Rows[i]["ad_minqty"].ToString());
                                int maxqty = int.Parse(dt.Rows[i]["ad_maxqty"].ToString());
                                if (batchqty > minqty && batchqty <= maxqty)
                                {
                                    ob_maxngacceptqty.Text = dt.Rows[i]["ad_maxngacceptqty"].ToString();
                                    return true;
                                }
                            }
                        }
                    }
                }
                else
                {
                    sql.Clear();
                    sql.Append("select wm_concat(oi_itemcode) codes from OQCitems where ");
                    sql.Append("nvl(oi_checkqty,0)<oi_sampleqty  and oi_sampleqty>0 and rownum<30 and oi_checkno='" + ob_checkno.Text + "'");
                    dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                    if (dt.Rows.Count > 0)
                    {
                        if (dt.Rows[0]["codes"].ToString() != "")
                        {
                            OperateResult.AppendText(">>项目编号抽检数未达到样本数,项目编号[" + dt.Rows[0]["codes"].ToString() + "]\n", Color.Red);
                            return false;
                        }
                        else
                            return true;
                    }
                }
            }
            else OperateResult.AppendText(">>状态未在检验中的批次不允许进行判断\n", Color.Red);

            return false;
        }

        private bool CheckStep()
        {
            if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out ErrorMessage))
            {
                return true;
            }
            else
            {
                OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
                return false;
            }
        }

        //记录操作日志
        private void DoLog(string Kind, string Result, string Type)
        {
            LogicHandler.InsertMessageLog(User.UserName, Kind, Result, "OQCBATCH|ob_id=" + ob_id.Text + "", ob_checkno.Text);
            if (ob_source.Text == "工序")
            {
                //如果是撤销操作则更新回上一工序
                if (Type == "撤销")
                {
                    List<string> sql = new List<string>();
                    //该序列号的批次数量
                    int batchqty = dh.getRowCount("makeserial", "ms_checkno='" + ob_checkno.Text + "'");
                    //撤销时如果没有下一工序表示工单已经完工了,此时撤销需要将完工数减掉一个批次
                    if (dh.getFieldDataByCondition("makeserial", "ms_nextstepcode", "ms_sncode='" + ms_sncode.Text + "'").ToString() == "")
                    {
                        sql.Add("update make set ma_madeqty=ma_madeqty-" + batchqty + " where ma_code='" + ob_makecode.Text + "'");
                    }
                    //获取上一步执行的工序
                    string PastCode = dh.getFieldDataByCondition("makeserial", "SUBSTR(ms_paststep,0,INSTR(ms_paststep,',', -1, 1)-1) ms_paststep", "ms_checkno='" + ob_checkno.Text + "'").ToString();
                    string[] LastStepCode = PastCode.Split(',');
                    sql.Add("update makeserial set ms_paststep=(select distinct SUBSTR(ms_paststep,0,INSTR(ms_paststep,',', -1, 1)-1)  from makeserial where ms_checkno='" + ob_checkno.Text + "') where ms_checkno='" + ob_checkno.Text + "'");
                    sql.Add("update makeserial set ms_stepcode='" + LastStepCode[LastStepCode.Length - 1] + "',ms_nextstepcode='" + User.CurrentStepCode + "',ms_status=1 where ms_checkno='" + ob_checkno.Text + "'");
                    sql.Add("update makecraftdetail set mcd_inqty=mcd_inqty-" + batchqty + ",mcd_outqty = mcd_outqty - " + batchqty + ",mcd_okqty = mcd_okqty -" + batchqty + " where mcd_macode='" + ob_makecode.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
                    dh.ExecuteSQLTran(sql.ToArray());
                }
                else if (Type == "通过")
                {
                    //更新下一工序

                    LogicHandler.UpdateOQCMessage(ms_sncode.Text, ob_checkno.Text, ob_makecode.Text, Kind, User.UserSourceCode, User.UserName, Result, out ErrorMessage);
                    sql.Clear();
                    sql.Append("insert into MakeProcess(mp_id,mp_makecode,mp_maid, mp_mscode,mp_sncode,mp_stepcode,mp_stepname,");
                    sql.Append("mp_craftcode,mp_craftname,mp_kind,mp_result,mp_indate,mp_inman,mp_wccode,mp_linecode,mp_sourcecode,mp_snstatus,mp_sncheckno,mp_snoutboxcode)");
                    sql.Append("select MakeProcess_seq.nextval, ma_code,ma_id,ms_code,ms_sncode,st_code,st_name,");
                    sql.Append("ma_craftcode,ma_craftname,'" + Kind + "','" + Result + "',sysdate,'" + User.UserCode + "',ma_wccode,'" + User.UserLineCode + "','" + User.UserSourceCode + "',");
                    sql.Append("ms_status,ms_checkno,ms_outboxcode from make left join makeserial on ms_makecode=ma_code left join step on st_code=ms_stepcode ");
                    sql.Append("where  ms_checkno='" + ob_checkno.Text + "' and st_code='" + User.CurrentStepCode + "'");
                    dh.ExecuteSql(sql.GetString(), "insert");
                }
            }
        }

        private void 抽检批维护_SizeChanged(object sender, EventArgs e)
        {
            asc.controlAutoSize(this);
        }

        private void ob_checkno_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
                GetBatch.PerformClick();
        }

        private void ms_sncode_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                //因为通过序列号获取的时候会带出送检批次，获取数据的方法根据送检批次为主
                //所以在通过序列号获取的时候要清除界面数据
                string sncode = ms_sncode.Text;
                BaseUtil.CleanForm(this);
                ms_sncode.Text = sncode;
                GetBatch.PerformClick();
            }
        }

        private void obd_outboxcode_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
                GetBatch.PerformClick();
        }
    }
}