mes-client/UAS_MES_ZT/FunctionCode/OQC/OQC_SamplingDataCollection.cs

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

namespace UAS_MES_NEW.OQC
{
    public partial class OQC_SamplingDataCollection : Form
    {
        AutoSizeFormClass asc = new AutoSizeFormClass();
        DataHelper dh;
        DataTable dt;
        DataTable BadCode;

        List<DataGridViewRow> dgvr = new List<DataGridViewRow>();
        LogStringBuilder sql = new LogStringBuilder();
        string[] LevelDefect = new string[] { "CR#CR", "MI#MI", "MA#MA" };

        string ifrework = "";

        DataTable TempForCheckType = new DataTable();

        string ErrorMessage = "";

        public OQC_SamplingDataCollection()
        {
            InitializeComponent();
        }

        private void 抽样数据采集_Load(object sender, EventArgs e)
        {
            asc.controllInitializeSize(this);
            BaseUtil.SetDgvColumnComboxData((DataGridViewComboBoxColumn)CheckTypeDGV.Columns["oi_leveldefect"], "oi_leveldefect", "display", "value", LevelDefect);
            dh = SystemInf.dh;
        }

        private void 抽样数据采集_SizeChanged(object sender, EventArgs e)
        {
            asc.controlAutoSize(this);
        }

        private void GetBatch_Click(object sender, EventArgs e)
        {
            if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out ErrorMessage))
            {
                DataTable temp = dh.getFieldsDatasByCondition("makeserial", new string[] { "nvl(ms_ifrework,0)ms_ifrework", "ms_reworkcheckno", "ms_reworkstatus" }, "(ms_sncode)='" + sncode.Text + "' order by ms_id desc");
                if (temp.Rows.Count > 0)
                {
                    if (temp.Rows[0]["ms_reworkstatus"].ToString() == "3")
                    {
                        OperateResult.AppendText(">>返修的不良序列号必须先进行维修\n", Color.Red);
                        return;
                    }
                    ifrework = temp.Rows[0]["ms_ifrework"].ToString();
                    if (ifrework != "0")
                    {
                        ob_checkno.Text = temp.Rows[0]["ms_reworkcheckno"].ToString();
                    }
                }
                DataTable[] dt = LogicHandler.GetOQCBatch(ms_sncode.Text == "" ? sncode.Text : ms_sncode.Text, obd_outboxcode.Text, ob_checkno.Text, "OQCDataCollection", out ErrorMessage);
                if (ErrorMessage == "")
                {
                    BaseUtil.SetFormValue(Controls, dt[0]);
                    //如果已经判定过则不可再编辑
                    if (ob_status.Text == "OK" || ob_status.Text == "NG" || ob_status.Text == "FOK" || ob_status.Text == "FNG")
                    {
                        BatchPass.Enabled = false;
                    }
                    else
                    {
                        BatchPass.Enabled = true;
                    }
                    oi_checkqty1.Text = dh.getFieldDataByCondition("oqcitems", "max(oi_sampleqty)", "oi_checkno='" + ob_checkno.Text + "'").ToString();
                    dgvr.Clear();
                }
                else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
            }
            else
            {
                OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
            }
        }

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

        private void sncode_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                GetBatch.PerformClick();
                if (CheckSnCode())
                {
                    dt = (DataTable)dh.ExecuteSql("select or_id,or_badcode bc_code,or_description bc_name,or_bgcode bg_code,bg_name from OQCNGReason left join badgroup on or_bgcode=bg_code where or_checkno='" + ob_checkno.Text + "' and or_sncode='" + sncode.Text + "'", "select");
                    BaseUtil.FillDgvWithDataTable(ChoosedDGV, dt);
                    GetBatchTypeGridData();
                }
                if (!checkBox1.Checked)
                {
                    Confirm_Click(sender, e);
                }


            }
        }

        private bool CheckSnCode()
        {
            //输入的序列号不能为空
            if (sncode.Text != "")
            {
                //判断当前的检验状态
                if (ob_status.Text == "待检验" || ob_status.Text == "检验中")
                {
                    DataTable temp = dh.getFieldsDatasByCondition("makeserial", new string[] { "nvl(ms_ifrework,0)ms_ifrework", "ms_reworkcheckno", "ms_reworkstatus" }, "(ms_sncode)='" + sncode.Text + "' order by ms_id desc");
                    if (temp.Rows.Count > 0)
                    {
                        if (temp.Rows[0]["ms_reworkstatus"].ToString() == "3")
                        {
                            OperateResult.AppendText(">>返修的不良序列号必须先进行维修\n", Color.Red);
                            return false;
                        }
                    }
                    dt = (DataTable)dh.ExecuteSql("select obd_sncode,ob_source,obd_makecode from OQCBatchDetail left join OQCBatch  on ob_id=obd_obid where obd_sncode='" + sncode.Text + "' and ob_checkno='" + ob_checkno.Text + "'", "select");
                    if (dt.Rows.Count > 0)
                    {
                        if (dt.Rows[0]["ob_source"].ToString() != "工序")
                        {
                            return true;
                        }
                        else
                        {
                            string ErrorMessage = "";
                            string oMakeCode = "";
                            string oMsID = "";
                            if (LogicHandler.CheckStepSNAndMacode(dt.Rows[0]["obd_makecode"].ToString(), User.UserSourceCode, sncode.Text, User.UserCode, out oMakeCode, out oMsID, out ErrorMessage))
                            {
                                return true;
                            }
                            else
                            {
                                OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
                                return false;
                            }
                        }
                    }
                    else
                    {
                        string nowcheck = dh.getFieldDataByCondition("makeserial", "ms_checkno", "ms_sncode = '"+ sncode.Text + "' order by ms_id desc").ToString();
                        OperateResult.AppendText(">>序列号" + sncode.Text + "所属批次:"+ nowcheck + ",不属于当前抽检批次\n", Color.Red);
                        return false;
                    }
                }
                else
                {
                    OperateResult.AppendText(">>送检批次必须是待检验或者检验中\n", Color.Red);
                    return false;
                }
            }
            else
            {
                OperateResult.AppendText(">>序列号不能为空\n", Color.Red);
                return false;
            }
        }

        private void GetBatchTypeGridData()
        {
            dt = (DataTable)dh.ExecuteSql("select oi_checkkind,max(oi_sampleqty) oi_count,nvl(max(oi_checkqty),0) oi_checkedcount from OQCBatch  left join OQCItems on ob_checkno=oi_checkno  where oi_checkno='" + ob_checkno.Text + "' group by oi_checkkind ", "select");
            if (dt.Rows.Count == 0)
            {
                OperateResult.AppendText(">>请先维护抽样计划\n", Color.Red);
                return;
            }
            string checkkind = "";
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                checkkind += ("'" + dt.Rows[i]["oi_checkkind"].ToString() + "',");
            }
            sql.Clear();
            sql.Append("select 1 choose,ci_name,oi_itemcode,oi_checkkind,oi_sampleqty,nvl((oi_checkqty),0) oi_checkqty, ");
            sql.Append("nvl(ois_id,0) ois_id,nvl(ois_ifng,0) oi_ng,nvl(ois_defectlevel,'-1') oi_leveldefect, ");
            sql.Append("ois_remark,case nvl(ois_id,0) when 0 then '未检验' else '已检验' end ois_status ");
            sql.Append("from OQCItems left join  QUA_CHECKITEM on oi_itemcode=ci_code left join OQCItemSamples on  ois_sncode='" + sncode.Text + "' and ois_checkno=oi_checkno and ");
            sql.Append("ois_itemcode=oi_itemcode and ois_projectcode = oi_projectcode where oi_checkno ='" + ob_checkno.Text + "' ");
            sql.Append("and oi_checkkind in (" + checkkind.Substring(0, checkkind.Length - 1) + ")");
            dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            BaseUtil.FillDgvWithDataTable(CheckTypeDGV, dt);
            sql.Clear();
            sql.Append("select bg_code,bg_code||':'||bg_name bg_name from PRODUCTBADGROUP left join productkind on ");
            sql.Append("pk_code= pb_kindcode left join product on pr_kind=pk_name left join ");
            sql.Append("badgroup on  bg_code=pb_badgroup where pr_code='" + ob_prodcode.Text + "'");
            BadCode = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            if (BadCode.Rows.Count > 0)
            {
                BadGroupCode.DisplayMember = "bg_name";
                BadGroupCode.ValueMember = "bg_code";
                BadGroupCode.DataSource = BadCode;
            }
            else
            {
                BadCode = (DataTable)dh.ExecuteSql("select bg_code,bg_name from badgroup where bg_statuscode='AUDITED'", "select");
                BadGroupCode.DisplayMember = "bg_name";
                BadGroupCode.ValueMember = "bg_code";
                BadGroupCode.DataSource = BadCode;
            }
        }

        private void Confirm_Click(object sender, EventArgs e)
        {
            //只能操作检验中或者待检验的批次
            if (ob_status.Text == "待检验" || ob_status.Text == "检验中")
            {
                if (!CheckSnCode())
                    return;
                //判断检验项是否勾选，如勾选取出明细数据
                DataTable dt = (DataTable)CheckTypeDGV.DataSource;
                //判断是否有勾选的明
                DataTable Savedt = BaseUtil.filterDataTable(dt, "choose<>0");
                if (Savedt.Rows.Count > 0)
                {
                    bool IfContainNG = false;
                    for (int i = 0; i < Savedt.Rows.Count; i++)
                    {
                        string if_ng = Savedt.Rows[i]["oi_ng"].ToString();
                        if (if_ng != "0" && if_ng != "")
                        {
                            IfContainNG = true;
                        }
                    }
                    if (!IfContainNG && ChoosedDGV.Rows.Count > 0)
                    {
                        OperateResult.AppendText(">>全部通过不允许勾选不良代码\n", Color.Red);
                        return;
                    }
                    if ((IfContainNG && ChoosedDGV.RowCount > 0) || !IfContainNG)
                    {
                        //用于存放更新的数据
                        List<string> ois_ifng_update = new List<string>();
                        List<string> ois_defectlevel_update = new List<string>();
                        List<string> ois_remark_update = new List<string>();
                        List<string> ois_id_update = new List<string>();
                        //用于存放插入的数据
                        List<string> ois_ifng_insert = new List<string>();
                        List<string> ois_defectlevel_insert = new List<string>();
                        List<string> ois_remark_insert = new List<string>();
                        List<string> oi_itemcode_insert = new List<string>();
                        for (int i = 0; i < Savedt.Rows.Count; i++)
                        {
                            //将布尔值转换为0,-1
                            if (Savedt.Rows[i]["ois_id"].ToString() != "" && Savedt.Rows[i]["ois_id"].ToString() != "0")
                            {
                                ois_ifng_update.Add(Savedt.Rows[i]["oi_ng"].ToString());
                                ois_defectlevel_update.Add(Savedt.Rows[i]["oi_leveldefect"].ToString());
                                ois_remark_update.Add(Savedt.Rows[i]["ois_remark"].ToString());
                                ois_id_update.Add(Savedt.Rows[i]["ois_id"].ToString());
                            }
                            else
                            {
                                oi_itemcode_insert.Add(Savedt.Rows[i]["oi_itemcode"].ToString());
                                ois_ifng_insert.Add(Savedt.Rows[i]["oi_ng"].ToString());
                                ois_defectlevel_insert.Add(Savedt.Rows[i]["oi_leveldefect"].ToString());
                                ois_remark_insert.Add(Savedt.Rows[i]["ois_remark"].ToString());
                            }
                        }
                        //执行批量更新的SQL
                        if (ois_id_update.Count > 0)
                        {
                            dh.BatchInsert("update OQCItemSamples set ois_ifng=:ois_ifng,ois_defectlevel=:ois_defectlevel,ois_remark=:ois_remark,ois_indate=sysdate where ois_id=:ois_id",
                         new string[] { "ois_ifng", "ois_defectlevel", "ois_remark", "ois_id" }, ois_ifng_update.ToArray(), ois_defectlevel_update.ToArray(), ois_remark_update.ToArray(), ois_id_update.ToArray());
                        }
                        //如果主键为空,并且存在需要插入的数据则执行插入操作 
                        if (oi_itemcode_insert.Count > 0)
                        {
                            string[] id = new string[oi_itemcode_insert.Count];
                            id = dh.GetSEQ("OQCItemSamples_SEQ", id.Length);
                            sql.Clear();
                            //when () then 
                            sql.Append("insert into OQCItemSamples (ois_id,ois_checkno,ois_makecode, ois_sncode,ois_projectcode,ois_itemcode,");
                            sql.Append("ois_ifng,ois_defectlevel,ois_remark,ois_indate)select :id,'" + ob_checkno.Text + "','" + ob_makecode.Text + "'");
                            sql.Append(",'" + sncode.Text + "','" + ob_projectcode.Text + "',:ois_itemcode,:ois_ifng,:ois_defectlevel,:ois_remark,sysdate from dual ");
                            sql.Append("where not exists (select ois_id from OQCItemSamples where ois_checkno='" + ob_checkno.Text + "' and ois_sncode='" + sncode.Text + "' and ois_itemcode =:ois_itemcode)");
                            dh.BatchInsert(sql.GetString(), new string[] { "id", "ois_itemcode", "ois_ifng", "ois_defectlevel", "ois_remark", "ois_itemcode" },
                                id, oi_itemcode_insert.ToArray(), ois_ifng_insert.ToArray(), ois_defectlevel_insert.ToArray(), ois_remark_insert.ToArray(), oi_itemcode_insert.ToArray());
                        }
                        //采集不良信息
                        List<string> bc_code = new List<string>();
                        List<string> bc_name = new List<string>();
                        List<string> bg_code = new List<string>();
                        List<string> bg_name = new List<string>();
                        for (int i = 0; i < ChoosedDGV.RowCount; i++)
                        {
                            bc_code.Add(ChoosedDGV.Rows[i].Cells["bc_code1"].Value.ToString());
                            bc_name.Add(ChoosedDGV.Rows[i].Cells["bc_name1"].Value.ToString());
                            bg_code.Add(ChoosedDGV.Rows[i].Cells["bg_code1"].Value.ToString());
                            bg_name.Add(ChoosedDGV.Rows[i].Cells["bg_name1"].Value.ToString());
                        }
                        dh.ExecuteSql("delete from OQCNGReason where or_sncode='" + sncode.Text + "' and or_checkno='" + ob_checkno.Text + "'", "delete");
                        if (bc_name.Count > 0)
                        {
                            //dh.UpdateByCondition("makeserial", "ms_badtimes=ms_badtimes+1", "ms_sncode='" + sncode.Text + "'");
                            sql.Clear();
                            sql.Append("insert into OQCNGReason(or_id, or_checkno, or_makecode, or_sncode, or_badcode, or_description, or_remark,or_bgcode)");
                            sql.Append("values (OQCNGReason_seq.nextval,'" + ob_checkno.Text + "','" + ob_makecode.Text + "','" + sncode.Text + "',:a,:b,'" + ob_remark.Text + "',:c)");
                            dh.BatchInsert(sql.GetString(), new string[] { "a", "b", "c" }, bc_code.ToArray(), bc_name.ToArray(), bg_code.ToArray());
                            string ms_code = dh.getFieldDataByCondition("makeserial", "ms_code", "ms_sncode  = '" + sncode.Text + "'   order by ms_id desc").ToString();
                            string asemcode = dh.getFieldDataByCondition("steppassed", "sp_inman", "sp_sncode  = '" + ms_code + "' and  sp_stepcode = 'Assing'  order by sp_id desc").ToString();
                            string MB_ASSING = dh.getFieldDataByCondition("steppassed left join employee on sp_inman = em_code", "em_name", "sp_sncode  = '" + ms_code + "' and  sp_stepcode = 'Assing'  order by sp_id desc").ToString();
                            string MB_LOT = dh.getFieldDataByCondition("steppassed left join employee on sp_inman = em_code", "em_name", "sp_sncode  = '" + ms_code + "' and  sp_stepcode = 'LOT'  order by sp_id desc").ToString();
                            string MB_FOBFV = dh.getFieldDataByCondition("steppassed left join employee on sp_inman = em_code", "em_name", "sp_sncode  = '" + ms_code + "' and  sp_stepcode = 'FOB-FV'  order by sp_id desc").ToString();
                            string MB_T1 = dh.getFieldDataByCondition("steppassed left join employee on sp_inman = em_code", "em_name", "sp_sncode  = '" + ms_code + "' and  sp_stepcode = 'Test1'  order by sp_id desc").ToString();
                            string MB_T2 = dh.getFieldDataByCondition("steppassed left join employee on sp_inman = em_code", "em_name", "sp_sncode  = '" + ms_code + "' and  sp_stepcode = 'Test2'  order by sp_id desc").ToString();
                            string MB_FOFV = dh.getFieldDataByCondition("steppassed left join employee on sp_inman = em_code", "em_name", "sp_sncode  = '" + ms_code + "' and  sp_stepcode = 'MO-FV'  order by sp_id desc").ToString();
                            string MB_OQC = User.CurrentStepCode=="OQC"?User.UserName:"";
                            string MB_QA = dh.getFieldDataByCondition("steppassed left join employee on sp_inman = em_code", "em_name", "sp_sncode  = '" + ms_code + "' and  sp_stepcode = 'QA'  order by sp_id desc").ToString();
                            string MB_CGMTEST = dh.getFieldDataByCondition("steppassed left join employee on sp_inman = em_code", "em_name", "sp_sncode  = '" + ms_code + "' and  sp_stepcode = 'CGM-TEST'  order by sp_id desc").ToString();
                            string MB_CGMFV = dh.getFieldDataByCondition("steppassed left join employee on sp_inman = em_code", "em_name", "sp_sncode  = '" + ms_code + "' and  sp_stepcode = 'CGM-FV'  order by sp_id desc").ToString();
                            string MB_CGMOQC = User.CurrentStepCode == "CGM-OQC" ? User.UserName : "";
                            //插入MakeBad表
                            sql.Clear();
                            sql.Append("insert into makebad(mb_id,mb_makecode,mb_mscode,mb_sncode,mb_inman,mb_indate,mb_stepcode");
                            sql.Append(",mb_sourcecode,mb_badcode,mb_bgcode,mb_badtable,mb_soncode,mb_badname,mb_status,mb_bgname,mb_type,MB_DUTYSTEPCODE,MB_DUTYEMCODE,MB_ASEMCODE,MB_LOT,MB_FOBFV,MB_T1,MB_T2,MB_FOFV,MB_OQC,MB_QA,MB_CGMTEST,MB_CGMFV,MB_CGMOQC,MB_ASSING)");
                            sql.Append("select makebad_seq.nextval,ma_code,ms_code,ms_sncode,'" + User.UserCode + "',sysdate,'" + User.CurrentStepCode + "','"+User.UserSourceCode+"',:bc_code,:bg_code,'',");
                            sql.Append("'',:bc_name,'0',:bg_name,'Client','"+User.CurrentStepCode+"','"+User.UserCode+"','"+asemcode+"','"+ MB_LOT + "','"+ MB_FOBFV + "','"+ MB_T1 + "','"+ MB_T2 + "','"+ MB_FOFV + "','"+ MB_OQC + "','"+ MB_QA + "','"+ MB_CGMTEST + "','"+ MB_CGMFV + "','"+ MB_CGMOQC + "','"+ MB_ASSING + "' from make left join makeSerial on ms_makecode=ma_code  ");
                            sql.Append(" where ms_sncode='" + sncode.Text + "' and ms_checkno='" + ob_checkno.Text + "'");
                            dh.BatchInsert(sql.GetString(), new string[] { "bc_code", "bg_code", "bc_name", "bg_name" }, bc_code.ToArray(), bg_code.ToArray(), bc_name.ToArray(), bg_name.ToArray());
                            string makecode = dh.getFieldDataByCondition("makeserial", "ms_makecode", "ms_sncode='" + sncode.Text + "' and ms_checkno='" + ob_checkno.Text + "'").ToString();
                            for (int i = 0; i < bc_code.Count; i++)
                            {
                                if (dh.CheckExist("badgroupdetail left join badgroup on bgd_bgid = bg_id", "bgd_badcode = '" + bc_code[i] + "' and bg_code = '" + bg_code[i] + "' and  bgd_brcode is not null and  bgd_dutycode is not null and bgd_solutioncode is not null "))
                                {
                                    string makebadid = dh.getFieldDataByCondition("makebad", "mb_id", "mb_sncode = '" + sncode.Text + "' and mb_makecode = '" + makecode + "' and mb_badcode = '" + bc_code[i] + "' order by mb_id desc").ToString();
                                    DataTable temp = dh.getFieldsDatasByCondition(" badgroupdetail left join badgroup on bgd_bgid = bg_id  left join QUA_NGReason on nr_code = bgd_brcode left join QUA_NGReasonGroup on nrg_code = bgd_brgcode left join NGDuty on nd_code = bgd_dutycode left join solution on so_code = bgd_solutioncode", new string[] { "bgd_brgcode", "bgd_dutycode", "bgd_solutioncode", "bgd_brcode", "nrg_name", "nr_name", "nd_name", "so_name" }, "bgd_badcode= '" + bc_code[i] + "' and bg_code = '" + bg_code[i] + "'");
                                    string bgd_brgcode = temp.Rows[0]["bgd_brgcode"].ToString();
                                    string bgd_brcode = temp.Rows[0]["bgd_brcode"].ToString();
                                    string bgd_dutycode = temp.Rows[0]["bgd_dutycode"].ToString();
                                    string bgd_solutioncode = temp.Rows[0]["bgd_solutioncode"].ToString();

                                    string mbr_id = dh.GetSEQ("makebadreason_seq");

                                    string bgd_brgname = temp.Rows[0]["nrg_name"].ToString();
                                    string bgd_brname = temp.Rows[0]["nr_name"].ToString();
                                    string bgd_dutyname = temp.Rows[0]["nd_name"].ToString();
                                    string bgd_solutionname = temp.Rows[0]["so_name"].ToString();

                                    sql.Clear();
                                    sql.Append("insert into makebadreason (mbr_mbid,mbr_id,mbr_brcode,mbr_solutioncode,");
                                    sql.Append("mbr_dutycode,mbr_brgcode,mbr_badcode,mbr_sncode,mbr_makecode,mbr_indate,");
                                    sql.Append("mbr_inman,mbr_brname,mbr_solutionname,mbr_badname,mbr_brgname,mbr_dutyname) select '" + makebadid + "','" + mbr_id + "','" + bgd_brcode + "',");
                                    sql.Append("'" + bgd_solutioncode + "','" + bgd_dutycode + "','" + bgd_brgcode + "','" + bc_code[i] + "',");
                                    sql.Append("'" + sncode.Text + "','" + makecode + "',sysdate,'" + User.UserCode + "','" + bgd_brname + "','" + bgd_solutionname + "','" + bc_name[i] + "','" + bgd_brgname + "','" + bgd_dutyname + "' from dual");
                                    dh.ExecuteSql(sql.GetString(), "insert");
                                }
                            }

                            dh.ExecuteSql("update oqcbatchdetail set obd_ifng = -1,obd_checkdate = sysdate where obd_checkno='" + ob_checkno.Text + "' and obd_sncode='" + sncode.Text + "'", "update");
                        }
                        //更新项目编号中的抽检数、不合格数，根据采样项目记录
                        sql.Clear();
                        sql.Append("UPDATE OQCItems SET (oi_ngqty,oi_checkqty)=(select nvl(sum(case when ");
                        sql.Append("nvl(ois_ifng,0)=0 then 0 else 1 end),0) ,count(1) from OQCItemSamples where ois_checkno=oi_checkno ");
                        sql.Append("and ois_itemcode=oi_itemcode)where oi_checkno ='" + ob_checkno.Text + "' and oi_projectcode ='" + ob_projectcode.Text + "'");
                        dh.ExecuteSql(sql.GetString(), "update");
                        //更新检验状态，如果是待检验的更新为检验中
                        if (ob_status.Text == "待检验")
                        {
                            dh.ExecuteSql("update OQCBatch set ob_status='CHECKING' where ob_checkno='" + ob_checkno.Text + "' and ob_status='UNCHECK'", "update");
                            //如果返工的不需要更新数量
                            if (!(ifrework != "0" && ifrework != ""))
                            {
                                sql.Clear();
                                sql.Append("update makecraftdetail set mcd_inqty=nvl(mcd_inqty,0)+ nvl((select count(1) from oqcbatchdetail ");
                                sql.Append("where obd_checkno='" + ob_checkno.Text + "' and obd_makecode=mcd_macode),0) ");
                                sql.Append("where mcd_macode in(select distinct obd_makecode from oqcbatchdetail ");
                                sql.Append("where obd_checkno='" + ob_checkno.Text + "') and mcd_stepcode='" + User.CurrentStepCode + "'");
                                dh.ExecuteSql(sql.GetString(), "select");
                            }
                        }
                        //更新批次中的合格数不合格数：用抽检批检验项目表获取最大的抽检数和不合格数
                        sql.Clear();
                        sql.Append("select count(1)from (select ois_sncode from OQCITEMSAMPLES where ");
                        sql.Append("ois_checkno = '" + ob_checkno.Text + "' and ois_ifng = 1 group by ois_sncode)");
                        string ngqty = (dh.ExecuteSql(sql.GetString(), "select") as DataTable).Rows[0][0].ToString();
                        string checkqty = dh.getFieldDataByCondition("OQCItems", "max(oi_checkqty)", "oi_checkno ='" + ob_checkno.Text + "'").ToString();
                        dh.ExecuteSql("update OQCBATCH set ob_ngqty='" + ngqty + "',ob_actsampleqty='" + checkqty + "',ob_okqty=('" + checkqty + "'-'" + ngqty + "') where ob_checkno ='" + ob_checkno.Text + "'", "update");
                        string endremark = dh.getFieldDataByCondition("makeserial", "ms_endremark", "ms_sncode = '"+sncode.Text+"' and ms_checkno = '"+ob_checkno.Text+"' ").ToString();
                        if (!IfContainNG)
                        {
                            OperateResult.AppendText(">>序列号" + sncode.Text + ",客户代码:"+endremark+",抽样良品\n", Color.Green);
                        }
                        else {
                            OperateResult.AppendText(">>序列号" + sncode.Text + ",客户代码:"+endremark+"抽样不良\n", Color.OrangeRed);
                        }
                        LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, "", User.UserLineCode, User.UserSourceCode, "抽样数据采集", "检验项目采集成功", sncode.Text, ob_checkno.Text);
                        dh.ExecuteSql("update oqcbatchdetail set obd_ifcheck = '-1',obd_checkdate = sysdate where obd_checkno='" + ob_checkno.Text + "' and obd_sncode='" + sncode.Text + "'", "update");
                        ChoosedDGV.DataSource = null;
                        BaseUtil.CleanDGVData(CheckTypeDGV);
                        BaseUtil.CleanDGVData(WaitChooseDGV);
                        sncode.Text = "";
                        sncode.Focus();
                        GetBatch.PerformClick();
                    }
                    else OperateResult.AppendText(">>含有未通过项请勾选不良明细\n", Color.Red);
                }
                else OperateResult.AppendText(">>请勾选送检明细\n", Color.Red);
            }
            else OperateResult.AppendText(">>必须是待检验或者检测中的送检批才能进行此操作\n", Color.Red);
        }

        private void BatchPass_Click(object sender, EventArgs e)
        {
            if (CheckBefore())
            {
                if (int.Parse(ob_ngqty.Text == "" ? "0" : ob_ngqty.Text) <= int.Parse(ob_maxngacceptqty.Text == "" ? "0" : ob_maxngacceptqty.Text))
                {
                    string ReworkCode = "";
                    if (LogicHandler.OQCBatchJudge(ob_checkno.Text, User.UserSourceCode, "OK", "", User.UserCode, ob_remark.Text, out ReworkCode, out ErrorMessage))
                    {
                        if (checkBox2.Checked)
                        {
                            dh.ExecuteSql("update makeserial set ms_status = 2,ms_laststep = ms_nextstepcode,ms_nextstepcode = '' where ms_checkno = " + ob_checkno.Text + " and ms_status = 1 ", "update");
                        }
                        GetBatch.PerformClick();
                        BatchPass.Enabled = false;
                        OperateResult.AppendText(">>批次号" + ob_checkno.Text + "通过批成功\n", Color.Aquamarine);
                        ob_checkno.Text = "";
                        //记录操作日志
                    }
                    else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
                }
                else OperateResult.AppendText(">>当前批次不合格数为" + ob_ngqty.Text + ",大于最大不合格允通过数" + ob_maxngacceptqty.Text + "\n", Color.Red);
            }
        }

        private bool CheckBefore()
        {
            if (ob_maxngacceptqty.Text == "")
            {
                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
            {
                return true;
            }
            return false;
        }

        private void WaitReject_Click(object sender, EventArgs e)
        {
            for (int i = ChoosedDGV.Rows.Count - 1; i >= 0; i--)
            {
                if (ChoosedDGV.Rows[i].Cells["choose1"].FormattedValue.ToString() == "True")
                {
                    ChoosedDGV.Rows.RemoveAt(i);
                }
            }
            (ChoosedDGV.DataSource as DataTable).AcceptChanges();
        }

        private void ChooseedReject_Click(object sender, EventArgs e)
        {
            DataTable wait = BaseUtil.filterDataTable((DataTable)WaitChooseDGV.DataSource, "ChooseAll<>0");
            DataTable choose = (ChoosedDGV.DataSource as DataTable);
            List<string> Chooseed = new List<string>();
            for (int i = 0; i < choose.Rows.Count; i++)
            {
                Chooseed.Add(choose.Rows[i]["bc_code"].ToString());
            }
            if (wait.Rows.Count > 0)
            {
                for (int i = 0; i < wait.Rows.Count; i++)
                {
                    if (!Chooseed.Contains(wait.Rows[i]["bc_code"].ToString()))
                    {
                        DataRow dr1 = choose.NewRow();
                        dr1["bc_code"] = wait.Rows[i]["bc_code"];
                        dr1["bc_name"] = wait.Rows[i]["bc_name"];
                        dr1["bg_code"] = wait.Rows[i]["bg_code"];
                        dr1["bg_name"] = wait.Rows[i]["bg_name"];
                        choose.Rows.Add(dr1);
                    }
                }
                for (int i = 0; i < WaitChooseDGV.Rows.Count; i++)
                {
                    ((DataTable)WaitChooseDGV.DataSource).Rows[i]["ChooseAll"] = 0;
                }
            }
            else OperateResult.AppendText(">>请勾选不良明细\n", Color.Red);
        }

        private void CheckTypeDGV_DataError(object sender, DataGridViewDataErrorEventArgs e) { }

        //如果当前行的Cell有修改过就将CheckBox勾选上
        private void CheckTypeDGV_CellValueChanged(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex > 0 && e.ColumnIndex > 0)
                CheckTypeDGV.Rows[e.RowIndex].Cells[0].Value = true;
        }

        private void WaitChooseDGV_DataError(object sender, DataGridViewDataErrorEventArgs e) { }

        private void bccode_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                dt = (DataTable)dh.ExecuteSql("select bc_code bg_code,bc_name bg_name from badcode where bc_code='" + bccode.Text + "'", "select");
                if (dt.Rows.Count > 0)
                {
                    try
                    {
                        for (int i = 0; i < ChoosedDGV.Rows.Count; i++)
                        {
                            if (ChoosedDGV.Rows[i].Cells[1].Value.ToString() == dt.Rows[0][0].ToString())
                            {
                                OperateResult.AppendText(">>已添加过不良代码" + bccode.Text + "\n", Color.Red);
                                bccode.Clear();
                                return;
                            }
                        }
                        dt.Merge(ChoosedDGV.DataSource as DataTable);
                        BaseUtil.FillDgvWithDataTable(ChoosedDGV, dt);
                        bccode.Clear();
                    }
                    catch (Exception) { }
                }
                else OperateResult.AppendText(">>不良代码不存在\n", Color.Red);
            }
        }

        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)
                GetBatch.PerformClick();
        }

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

        private void BadGroupCode_SelectedIndexChanged(object sender, EventArgs e)
        {
            string bg_code = BadGroupCode.SelectedValue.ToString();
            sql.Clear();
            sql.Append("select 0 ChooseAll,bc_code,bc_name,bg_name,bg_code from badgroupdetail left join badgroup on bg_id=bgd_bgid ");
            sql.Append("left join badcode on bgd_badcode=bc_code where bg_code='" + ((bg_code != "" && bg_code != "System.Data.DataRowView") ? bg_code.ToString() : "") + "' and bg_code is not null ");
            sql.Append(" order by bc_code");
            DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            BadInfoSource.DataSource = dt;
            BaseUtil.FillDgvWithDataTable(WaitChooseDGV, dt);
        }

        private void OQC_SamplingDataCollection_FormClosing(object sender, FormClosingEventArgs e)
        {
            dh.Dispose();
        }

        private void Filter_UserControlTextChanged(object sender, EventArgs e)
        {
            try
            {
                DataRow[] dr = (BadInfoSource.DataSource as DataTable).Select("bc_code like '%" + Filter.Text + "%' or bc_name like '%" + Filter.Text + "%'");
                DataTable dt = (BadInfoSource.DataSource as DataTable).Clone();
                for (int i = 0; i < dr.Length; i++)
                {
                    dt.Rows.Add(dr[i].ItemArray);
                }
                BaseUtil.FillDgvWithDataTable(WaitChooseDGV, dt);
            }
            catch (Exception)
            {

            }
        }

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