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)
        {
            string ReworkCode = "";
            if (CheckBefore() && PassCheckStep)
            {
                if (int.Parse(ob_ngqty.Text == "" ? "0" : ob_ngqty.Text) <= int.Parse(ob_maxngacceptqty.Text == "" ? ob_maxngacceptqty.Text : ob_maxngacceptqty.Text))
                {
                    if (LogicHandler.OQCBatchJudge(ob_checkno.Text, User.UserSourceCode, "OK", "", User.UserCode, Remark.Text, out ReworkCode, out ErrorMessage))
                    {
                        OperateResult.AppendText(">>通过批成功\n", Color.Green);
                        GetBatch.PerformClick();
                    }
                    else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
                }
                else
                    OperateResult.AppendText(">>当前批次不合格数为" + ob_ngqty.Text + ",大于最大不合格允通过数" + ob_maxngacceptqty.Text + "\n", Color.Red);
            }
        }

        private void BatchRejection_Click(object sender, EventArgs e)
        {
            string ReworkCode = "";
            if (CheckBefore() && PassCheckStep)
            {
                if (LogicHandler.OQCBatchJudge(ob_checkno.Text, User.UserSourceCode, "NG", ReworkRequire.Checked ? "Y" : "N", User.UserCode, Remark.Text, out ReworkCode, out ErrorMessage))
                {
                    OperateResult.AppendText(">>判退批成功\n", Color.Green);
                    GetBatch.PerformClick();
                }
                else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
            }
        }

        private void ForcePass_Click(object sender, EventArgs e)
        {
            string ReworkCode = "";
            if (PassCheckStep)
            {
                if (LogicHandler.OQCBatchJudge(ob_checkno.Text, User.UserSourceCode, "FOK", "", User.UserCode, Remark.Text, out ReworkCode, out ErrorMessage))
                {
                    OperateResult.AppendText(">>强制通过批" + ob_checkno.Text + "成功\n", Color.Green);
                    GetBatch.PerformClick();
                }
                else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
            }
        }

        private void ForceRejection_Click(object sender, EventArgs e)
        {
            string ReworkCode = "";
            if (PassCheckStep)
            {
                if (LogicHandler.OQCBatchJudge(ob_checkno.Text, User.UserSourceCode, "FNG", ReworkRequire.Checked ? "Y" : "N", User.UserCode, Remark.Text, out ReworkCode, out ErrorMessage))
                {
                    OperateResult.AppendText(">>强制撤销批" + ob_checkno.Text + "成功\n", Color.Green);
                    GetBatch.PerformClick();
                }
                else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
            }
        }

        private void WithdrawPass_Click(object sender, EventArgs e)
        {
            string ReworkCode = "";
            if (PassCheckStep)
            {
                if (ob_result.Text == "OK" || ob_result.Text == "FOK")
                {
                    if (LogicHandler.OQCBatchJudge(ob_checkno.Text, User.UserSourceCode, "REOK", "", User.UserCode, Remark.Text, out ReworkCode, out ErrorMessage))
                    {
                        OperateResult.AppendText(">>撤销通过批" + ob_checkno.Text + "成功\n", Color.Green);
                        GetBatch.PerformClick();
                    }
                    else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
                }
                else OperateResult.AppendText(">>该抽检批次未通过,无需撤销通过\n", Color.Red);
            }
        }

        private void WithdrawRejection_Click(object sender, EventArgs e)
        {
            string ReworkCode = "";
            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")
                            {
                                if (LogicHandler.OQCBatchJudge(ob_checkno.Text, User.UserSourceCode, "RENG", "", User.UserCode, Remark.Text, out ReworkCode, out ErrorMessage))
                                {
                                    OperateResult.AppendText(">>撤销判退成功\n", Color.Green);
                                    ob_result.Text = "";
                                    GetBatch.PerformClick();
                                }
                                else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
                            }
                            else return;
                        }
                    }
                    else {
                        if (LogicHandler.OQCBatchJudge(ob_checkno.Text, User.UserSourceCode, "RENG", "", User.UserCode, Remark.Text, out ReworkCode, out ErrorMessage))
                        {
                            OperateResult.AppendText(">>撤销判退成功\n", Color.Green);
                            ob_result.Text = "";
                            GetBatch.PerformClick();
                        }
                        else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
                    }
                }
                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>();
        //            //该序列号的批次数量
        //            string batchqty = dh.getFieldDataByCondition("oqcbatch", "ob_nowcheckqty", "ob_checkno='" + ob_checkno.Text + "'").ToString();
        //            //撤销时如果没有下一工序表示工单已经完工了,此时撤销需要将完工数减掉一个批次
        //            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 + "' and ms_status<>3").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 + "' and ms_status<>3 and rownum=1) where ms_checkno='" + ob_checkno.Text + "' and ms_status<>3 ");
        //            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();
        }
    }
}