mes-client/UAS_MES_YTDZ/FunctionCode/Make/Make_RepairoffLine.cs

using System;
using System.Collections;
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.CustomControl.TextBoxWithIcon;
using UAS_MES_NEW.DataOperate;
using UAS_MES_NEW.Entity;
using UAS_MES_NEW.Properties;
using UAS_MES_NEW.PublicMethod;

namespace UAS_MES_NEW.Make
{
    public partial class Make_RepairoffLine : Form
    {
        string mb_id = "";
        string mbr_id = "";
        /// <summary>
        /// 存放父节点信息
        /// </summary>
        Dictionary<string, Dictionary<string, string>> BadInf_1 = new Dictionary<string, Dictionary<string, string>>();
        /// <summary>
        /// 存放子节点信息
        /// </summary>
        Dictionary<string, Dictionary<string, string>> BadInf_2 = new Dictionary<string, Dictionary<string, string>>();

        DataHelper dh = null;

        LogStringBuilder sql = new LogStringBuilder();

        List<string> sqls = new List<string>();

        DataTable dt = null;

        AutoSizeFormClass asc = new AutoSizeFormClass();

        string msid = "";

        string ifrework = "";

        string reworkstatus = "";

        string firstsn = "";

        string ms_stepcode = "";

        DataTable Dbfind;

        public Make_RepairoffLine()
        {
            InitializeComponent();
        }

        private void Make_Repair_Load(object sender, EventArgs e)
        {
            bd_soncode.FormName = Name;
            bd_soncode.TableName = "bom left join bomdetail on bd_bomid=bo_id left join product on bd_soncode=pr_code";
            bd_soncode.SetValueField = new string[] { "bd_soncode" };
            bd_soncode.SelectField = "bd_soncode # 子件编号,pr_detail # 物料名称,pr_spec # 物料规格,bd_location # 位号";
            bd_soncode.DBTitle = "不良零件";
            bd_soncode.DbChange += Prodcode_DbChange;

            ma_code.TableName = "make left join product on ma_prodcode=pr_code";
            ma_code.SelectField = "ma_code # 工单号,pr_code # 产品编号,ma_qty # 工单数量,pr_spec # 产品规格,pr_detail # 产品名称,ma_salecode # 销售单号,pr_sendchecktype # 产品送检方式,pr_pcbacount # 拼版数";
            ma_code.FormName = Name;
            ma_code.SetValueField = new string[] { "ma_code", "pr_code", "ma_qty", "pr_spec", "pr_detail", "ma_salecode", "nvl(pr_sendchecktype,'LineCode')pr_sendchecktype", "pr_pcbacount" };
            ma_code.Condition = "ma_statuscode='STARTED'";
            ma_code.DbChange += Prodcode_DbChange;

            //nrg_name.BringToFront();
            nrg_name.TableName = "QUA_NGREASONGROUP";
            nrg_name.Field = "nrg_name";
            nrg_name.ValueField = "nrg_code";

            nr_name.TableName = "QUA_NGREASONGROUPDET left join QUA_NGREASONGROUP on nrgd_nrgid=nrg_id left join QUA_NGReason on nrgd_nrcode=nr_code ";
            nr_name.Field = "nr_name";
            nr_name.ValueField = "nr_code";

            mbr_dutyname.TableName = "ngduty";
            mbr_dutyname.Field = "nd_name";
            mbr_dutyname.ValueField = "nd_code";

            so_name.TableName = "solution";
            so_name.Field = "so_name";
            so_name.ValueField = "so_code";

            asc.controllInitializeSize(this);
            mbc_component.SendToBack();
            so_name.SendToBack();
            mbl_loc.SendToBack();
            bd_soncode.SendToBack();
            mbp_partdgv.SendToBack();
            mbp_part_label.SendToBack();
            dh = SystemInf.dh;
            GetSNCode.Focus();
        }

        private void Prodcode_DbChange(object sender, EventArgs e)
        {
            Dbfind = bd_soncode.ReturnData;
            BaseUtil.SetFormValue(this.Controls, Dbfind);
            if (bd_soncode.Text != "")
            {
                if (mbr_id != "")
                {
                    if (!dh.CheckExist("makebadrspart", "mbp_sncode='" + GetSNCode.Text + "' and mbp_part='" + bd_soncode.Text + "' and mbp_badcode='" + bc_code.Text + "'"))
                    {
                        sql.Clear();
                        sql.Append("insert into makebadrspart(mbp_id,mbp_mbrid,mbp_part,mbp_badcode,");
                        sql.Append("mbp_brcode,mbp_sncode,mbp_makecode,mbp_indate,mbp_inman)");
                        sql.Append("select makebadrspart_seq.nextval," + mbr_id + ",'" + bd_soncode.Text + "',");
                        sql.Append("'" + bc_code.Text + "','" + nr_code.Text + "','" + GetSNCode.Text + "','" + ma_code.Text + "',");
                        sql.Append("sysdate,'" + User.UserCode + "' from dual");
                        dh.ExecuteSql(sql.GetString(), "insert");
                        DataTable dt = (DataTable)dh.ExecuteSql("select mbp_id,mbp_part from makebadrspart where mbp_mbrid=" + mbr_id, "select");
                        BaseUtil.FillDgvWithDataTable(mbp_partdgv, dt);
                    }
                }
                else OperatResult.AppendText(">>请先选择不良原因\n", Color.Red);
            }
            else OperatResult.AppendText(">>不良零件不能为空\n", Color.Red);
        }

        private void GetSNCode_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                if (GetSNCode.Text == "")
                {
                    OperatResult.AppendText(">>序列号不允许为空\n", Color.Red);
                    BaseUtil.CleanForm(this);
                    BadCodeTree.Nodes.Clear();
                    return;
                }
                LoadBadInfTree(sender, e);
                dt = (DataTable)dh.ExecuteSql("select mb_makecode,ma_code,pr_detail,pr_code from makebad left join make on mb_makecode=ma_code left join product on  ma_prodcode=pr_code where mb_sncode='" + GetSNCode.Text + "' and mb_status=0", "select");
                if (dt.Rows.Count > 0)
                {
                    BaseUtil.SetFormValue(this.Controls, dt);
                }
                ms_sncode.Text = GetSNCode.Text;
            }
        }

        private void Make_Repair_SizeChanged(object sender, EventArgs e)
        {
            mbc_component.BringToFront();
            so_name.BringToFront();
            mbl_loc.BringToFront();
            bd_soncode.BringToFront();
            mbp_partdgv.BringToFront();
            mbp_part_label.BringToFront();
            asc.controlAutoSize(this);
            mbc_component.SendToBack();
            so_name.SendToBack();
            mbl_loc.SendToBack();
            bd_soncode.SendToBack();
            mbp_partdgv.SendToBack();
            mbp_part_label.SendToBack();
        }

        private void BadCodeTree_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
        {
            if (e.Node.Level == 0)
            {
                mb_id = e.Node.Tag.ToString();
                BaseUtil.CleanControlsText(bc_name, bc_code, bg_name, bg_code, mb_badremark, nrg_name, nrg_code, nr_name, nr_code, so_name, so_code, mbr_dutyname, mbr_dutycode, mbc_component);
                mbl_locdgv.DataSource = null;
                mbp_partdgv.DataSource = null;
                bc_name.Text = BadInf_1[mb_id]["bc_name"];
                bc_code.Text = BadInf_1[mb_id]["mb_badcode"];
                bg_name.Text = BadInf_1[mb_id]["bg_name"];
                bg_code.Text = BadInf_1[mb_id]["mb_bgcode"];
                mb_badremark.Text = BadInf_1[mb_id]["mb_badremark"];
                mbr_id = "";
                SaveRepairInf.Enabled = true;
            }
            if (e.Node.Level == 1)
            {
                //展示父节点信息
                mb_id = e.Node.Parent.Tag.ToString();
                bc_code.Text = BadInf_1[mb_id]["mb_badcode"];
                bc_name.Text = BadInf_1[mb_id]["bc_name"];
                bg_code.Text = BadInf_1[mb_id]["mb_bgcode"];
                bg_name.Text = BadInf_1[mb_id]["bg_name"];
                //展示子节点信息
                mbr_id = e.Node.Tag.ToString();
                nrg_code.Text = BadInf_2[mbr_id]["nrg_code"];
                nrg_name.Text = BadInf_2[mbr_id]["nrg_name"];
                nr_code.Text = BadInf_2[mbr_id]["nr_code"];
                nr_name.Text = BadInf_2[mbr_id]["nr_name"];
                so_code.Text = BadInf_2[mbr_id]["so_code"];
                so_name.Text = BadInf_2[mbr_id]["so_name"];
                mbr_dutycode.Text = BadInf_2[mbr_id]["mbr_dutycode"];
                mbr_dutyname.Text = BadInf_2[mbr_id]["mbr_dutyname"];
                mbc_component.Text = dh.getFieldDataByCondition("makebadrscom", "mbc_component", "mbc_mbrid=" + mbr_id).ToString();
                //加载两个Grid的数据源
                DataTable dt = (DataTable)dh.ExecuteSql("select mbp_id,mbp_part from makebadrspart where mbp_mbrid=" + mbr_id, "select");
                BaseUtil.FillDgvWithDataTable(mbp_partdgv, dt);
                dt = (DataTable)dh.ExecuteSql("select mbl_id,mbl_loc from makebadrsloc where mbl_mbrid=" + mbr_id, "select");
                BaseUtil.FillDgvWithDataTable(mbl_locdgv, dt);
                SaveRepairInf.Enabled = false;
            }
        }

        private void LoadBadInfTree(object sender, EventArgs e)
        {
            BadCodeTree.Nodes.Clear();
            sql.Clear();
            //不是返工工单时的取当前工单
            sql.Append("select mb_id,mb_sncode,mb_badcode,mb_bgcode,nvl(bc_name,mb_badcode) bc_name,nvl(bg_name,mb_bgcode) bg_name,");
            sql.Append("mb_badremark from makebad left join badcode on bc_code=mb_badcode left join badgroup ");
            sql.Append("on bg_code=mb_bgcode where mb_sncode='" + (GetSNCode.Text == "" ? ms_sncode.Text : GetSNCode.Text) + "' and mb_makecode='" + ma_code.Text + "' and mb_status=0");
            dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            if (dt.Rows.Count == 0)
            {
                sql.Clear();
                sql.Append("select mb_id,mb_sncode,mb_badcode,mb_bgcode,nvl(bc_name,mb_badcode) bc_name,nvl(bg_name,mb_bgcode) bg_name, ");
                sql.Append("mb_badremark from makebad left join badcode on bc_code=mb_badcode left join badgroup on bg_code=mb_bgcode  ");
                sql.Append("left join make on ma_code=mb_makecode where mb_sncode='" + (GetSNCode.Text == "" ? ms_sncode.Text : GetSNCode.Text) + "' and mb_makecode<>'" + ma_code.Text + "' and mb_status=0");
                dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            }
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                //添加根节点
                TreeNode tnode_0 = new TreeNode();
                string bg_name = dt.Rows[i]["bg_name"].ToString();
                string bc_name = dt.Rows[i]["bc_name"].ToString();
                string mb_badcode = dt.Rows[i]["mb_badcode"].ToString();
                string mb_bgcode = dt.Rows[i]["mb_bgcode"].ToString();
                tnode_0.Text = (bg_name == "" ? mb_bgcode : bg_name) + ":" + (bc_name == "" ? mb_bgcode : bc_name);
                tnode_0.Name = dt.Rows[i]["mb_bgcode"].ToString();
                //作为Dictionary的主标识
                string mb_id = dt.Rows[i]["mb_id"].ToString();
                tnode_0.Tag = mb_id;
                Dictionary<string, string> dic = new Dictionary<string, string>();
                dic.Add("mb_id", mb_id);
                dic.Add("mb_sncode", dt.Rows[i]["mb_sncode"].ToString());
                dic.Add("mb_badcode", dt.Rows[i]["mb_badcode"].ToString());
                dic.Add("mb_bgcode", dt.Rows[i]["mb_bgcode"].ToString());
                dic.Add("bc_name", dt.Rows[i]["bc_name"].ToString());
                dic.Add("bg_name", dt.Rows[i]["bg_name"].ToString());
                dic.Add("mb_badremark", dt.Rows[i]["mb_badremark"].ToString());
                if (!BadInf_1.ContainsKey(tnode_0.Tag.ToString()))
                    BadInf_1.Add(tnode_0.Tag.ToString(), dic);
                BadCodeTree.Nodes.Add(tnode_0);
                //添加子节点
                sql.Clear();
                sql.Append("select mbr_id,mbr_brcode,mbr_brgcode,mbr_solutioncode,so_code,so_name,mbr_dutycode,mbr_dutyname,nd_name,nrg_name");
                sql.Append(",nr_name,nr_code,nrg_code from makebadreason left join QUA_NGReason on nr_code=mbr_brcode left join ");
                sql.Append("QUA_NGREASONGROUPdet on nrgd_nrcode=nr_code left join QUA_NGREASONGROUP on nrg_id=nrgd_nrgid and ");
                sql.Append("mbr_brgcode=nrg_code left join solution on so_code=mbr_solutioncode left join ngduty on nd_code=mbr_dutycode ");
                sql.Append("where mbr_mbid=" + mb_id);
                DataTable dt1 = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                for (int j = 0; j < dt1.Rows.Count; j++)
                {
                    TreeNode tnode_1 = new TreeNode();
                    //存放子节点的信息
                    Dictionary<string, string> dic1 = new Dictionary<string, string>();
                    string mbr_id = dt1.Rows[j]["mbr_id"].ToString();
                    tnode_1.Tag = mbr_id;
                    dic1.Add("mbr_id", mbr_id);
                    dic1.Add("mbr_brcode", dt1.Rows[j]["mbr_id"].ToString());
                    dic1.Add("mbr_brgcode", dt1.Rows[j]["mbr_brcode"].ToString());
                    dic1.Add("mbr_solutioncode", dt1.Rows[j]["mbr_solutioncode"].ToString());
                    dic1.Add("mbr_dutycode", dt1.Rows[j]["mbr_dutycode"].ToString());
                    dic1.Add("mbr_dutyname", dt1.Rows[j]["mbr_dutyname"].ToString());
                    dic1.Add("nd_name", dt1.Rows[j]["nd_name"].ToString());
                    dic1.Add("so_name", dt1.Rows[j]["so_name"].ToString());
                    dic1.Add("so_code", dt1.Rows[j]["so_code"].ToString());
                    dic1.Add("nrg_name", dt1.Rows[j]["nrg_name"].ToString());
                    dic1.Add("nrg_code", dt1.Rows[j]["nrg_code"].ToString());
                    dic1.Add("nr_name", dt1.Rows[j]["nr_name"].ToString());
                    dic1.Add("nr_code", dt1.Rows[j]["nr_code"].ToString());
                    tnode_1.Text = dt1.Rows[j]["nr_name"].ToString();
                    if (!BadInf_2.ContainsKey(mbr_id))
                        BadInf_2.Add(mbr_id, dic1);
                    tnode_0.Nodes.Add(tnode_1);
                }

            }
            if (BadCodeTree.Nodes.Count > 0)
            {
                BadCodeTree.SelectedNode = BadCodeTree.Nodes[0];
                BadCodeTree_NodeMouseClick(this, new TreeNodeMouseClickEventArgs(BadCodeTree.SelectedNode, MouseButtons.Left, 1, 0, 0));
            }

            try
            {
                if (bg_code.Text != "")
                    BadCodeTree.Nodes[bg_code.Text].Expand();
            }
            catch (Exception) { }

            LoadBadcodeGroup();

        }

        private void RefreshTreeView_Click(object sender, EventArgs e)
        {
            LoadBadInfTree(sender, e);
        }

        private void RepairComplete_Click(object sender, EventArgs e)
        {
            if (ms_sncode.Text == "")
            {
                OperatResult.AppendText(">>序列号不允许为空\n", Color.Red);
                return;
            }
            if (ifrework != "0" && reworkstatus == "0")
            {
                if (dh.getRowCount("Makebad", "mb_sncode='" + ms_sncode.Text + "' and mb_makecode='" + ma_code.Text + "' and mb_status=0") == 0)
                {
                    OperatResult.AppendText(">>维修必须维护不良代码\n", Color.Red);
                    return;
                }
            }
            //判断是否所有的不良信息都有维护不良原因
            DataTable dt = (DataTable)dh.ExecuteSql("select mb_id,bc_name,mbr_mbid from makebad left join makebadreason on mbr_mbid=mb_id left join badcode on mb_badcode=bc_code where mb_sncode='" + ms_sncode.Text + "'  and mb_makecode='" + ma_code.Text + "' and mb_status=0", "select");
            string ErrorMessage = "";
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (dt.Rows[i]["mb_id"].ToString() != dt.Rows[i]["mbr_mbid"].ToString())
                    ErrorMessage += "【" + dt.Rows[i]["bc_name"].ToString() + "】";
            }
            if (ErrorMessage != "")
            {
                OperatResult.AppendText(">>" + ErrorMessage + "未维护不良原因\n", Color.Red);
                return;
            }

            List<string> SQLS = new List<string>();
            //取消最近拆解部件
            SQLS.Add("update makebad set mb_status=-1 where mb_sncode='" + ms_sncode.Text + "' and mb_makecode='" + ma_code.Text + "'");
            dh.ExecuteSQLTran(SQLS.ToArray());
            LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "回流工序", "完成维修回流", ms_sncode.Text, ms_checkno.Text);
            OperatResult.AppendText(">>序列号" + ms_sncode.Text + "回流成功\n", Color.Green);
            BaseUtil.CleanForm(this);
            BadCodeTree.Nodes.Clear();
            GetSNCode.Clear();
            GetSNCode.Focus();
        }

        private void Scrap_Click(object sender, EventArgs e)
        {
            if (ms_sncode.Text != "")
            {
                //判断是否有无法维修的记录
                int ScrapNum = int.Parse(dh.getFieldDataByCondition("makebadreason left join makebad on mb_id=mbr_mbid", "count(0) cn", "mb_sncode='" + ms_sncode.Text + "' and mb_status=0").ToString());
                if (ScrapNum == 0)
                    OperatResult.AppendText(">>" + ms_sncode.Text + "报废必须维护不良原因\n", Color.Red);
                else
                {
                    string confirm = MessageBox.Show(this.ParentForm, "此操作不可撤销，是否确认报废", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk).ToString();
                    if (confirm == "Yes")
                    {
                        DataTable dt = dh.getFieldsDataByCondition("makeserial", new string[] { "nvl(ms_ifrework,0)ms_ifrework", "ms_reworkcode" }, "ms_sncode='" + ms_sncode.Text + "' and ms_makecode='" + ma_code.Text + "'");
                        if (dt.Rows.Count > 0)
                        {
                            string ms_ifrework = dt.Rows[0]["ms_ifrework"].ToString();
                            string reworkcode = dt.Rows[0]["ms_reworkcode"].ToString();
                            if (ms_ifrework == "0")
                            {
                                dh.UpdateByCondition("makeserial", "ms_paststep = ms_paststep ||'," + User.CurrentStepCode + "',ms_status=4,ms_nextstepcode='',ms_stepcode='" + User.CurrentStepCode + "'", "ms_sncode='" + ms_sncode.Text + "' and ms_makecode='" + ma_code.Text + "'");
                            }
                            else
                            {
                                sqls.Clear();
                                sqls.Add("update makeserial set ms_paststep = ms_paststep ||'," + User.CurrentStepCode + "',ms_status=4,ms_reworkstatus= 4,ms_nextstepcode='',ms_stepcode='" + User.CurrentStepCode + "' where ms_sncode='" + ms_sncode.Text + "' and ms_makecode='" + ma_code.Text + "'");
                                sqls.Add("update oqcbatch set ob_nowcheckqty=ob_nowcheckqty-1 where ob_checkno='" + ms_reworkcheckno.Text + "'");
                                sqls.Add("delete from oqcbatchdetail where obd_sncode='" + ms_sncode.Text + "' and obd_checkno='" + ms_reworkcheckno.Text + "'");
                                sqls.Add("update ReworkDetail set rd_rwstatus='报废' where rd_reid=(select re_id from rework where re_code='" + reworkcode + "') and rd_sncode='" + reworkcode + "'");
                                dh.ExecuteSQLTran(sqls.ToArray());
                            }
                        }
                        dh.UpdateByCondition("makecraftdetail", "mcd_inqty=mcd_inqty-1,mcd_outqty=mcd_outqty-1", "mcd_macode='" + ma_code.Text + "' and mcd_stepcode='" + ms_stepcode + "'");
                        dh.UpdateByCondition("make", "MA_NGMADEQTY=nvl(MA_NGMADEQTY,0)+1", "ma_code='" + ma_code.Text + "'");
                        LogicHandler.InsertMakeProcess(ms_sncode.Text, ma_code.Text, User.UserSourceCode, "报废", "序列号报废", User.UserCode);
                        LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "报废", "序列号报废", ms_sncode.Text, ms_checkno.Text);
                        OperatResult.AppendText(">>报废成功\n", Color.Green);
                        GetSNCode.Clear();
                        BaseUtil.CleanForm(this);
                        BadCodeTree.Nodes.Clear();
                    }
                }
            }
            else OperatResult.AppendText(">>序列号不允许为空\n", Color.Red);
        }

        private void NewBadCode_Click(object sender, EventArgs e)
        {
            if (GetSNCode.Text == "" || ma_code.Text == "")
            {
                OperatResult.AppendText(">>序列号和工单号不允许为空\n", Color.Red);
            }
            else
            {
                Make_NewBadCode badcode = new Make_NewBadCode(GetSNCode.Text, ma_code.Text);
                badcode.FormClosed += LoadBadInfTree;
                BaseUtil.SetFormCenter(badcode);
                badcode.ShowDialog();
            }
        }

        private void NewRepairInf_Click(object sender, EventArgs e)
        {
            if (bg_name.Text == "" && bc_name.Text == "")
            {
                OperatResult.AppendText(">>不良代码组和不良代码不能为空\n", Color.Red);
            }
            else
            {
                Make_NewMatainInf mataininf = new Make_NewMatainInf(bg_name.Text, bg_code.Text, bc_name.Text, bc_code.Text, GetSNCode.Text, msid, mb_id);
                mataininf.FormClosed += LoadBadInfTree;
                BaseUtil.SetFormCenter(mataininf);
                mataininf.ShowDialog();
            }
        }

        private void SaveRepairInf_Click(object sender, EventArgs e)
        {
            string ErrorMessage = "";
            if (bg_name.Text == "" || bc_name.Text == "")
            {
                OperatResult.AppendText(">>不良代码组和不良代码不能为空\n", Color.Red);
                return;
            }
            if (nrg_name.Text == "")
                ErrorMessage += " 不良原因组 ";
            if (nr_name.Text == "")
                ErrorMessage += " 不良原因 ";
            if (mbr_dutyname.Text == "")
                ErrorMessage += " 责任别 ";
            if (ErrorMessage != "")
            {
                ErrorMessage += "不能为空";
                OperatResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
                return;
            }
            string mbr_id = dh.GetSEQ("makebadreason_seq");
            //存在不良组件进行提示
            if (dh.CheckExist("makebadreason left join makebad on mbr_mbid=mb_id and mbr_sncode=mb_sncode", "mbr_badcode='" + bc_code.Text + "' and mbr_sncode='" + ms_sncode.Text + "' and mbr_brcode='" + nr_code.Text + "' and mb_status=0"))
            {
                OperatResult.AppendText(">>不良代码【" + bc_name.Text + "】已存在不良原因【" + nr_name.Text + "】\n", Color.Red);
                return;
            }
            if (!dh.CheckExist("QUA_NGREASONGROUP", "nrg_name='" + nrg_name.Text + "'"))
            {
                OperatResult.AppendText(">>不良原因组不存在\n", Color.Red);
                return;
            }
            if (!dh.CheckExist("QUA_NGReason", "nr_name='" + nr_name.Text + "'"))
            {
                OperatResult.AppendText(">>不良原因不存在\n", Color.Red);
                return;
            }
            if (!dh.CheckExist("ngduty", "nd_name='" + mbr_dutyname.Text + "'"))
            {
                OperatResult.AppendText(">>责任别不存在\n", Color.Red);
                return;
            }
            if (!dh.CheckExist("solution", "so_name='" + so_name.Text + "'"))
            {
                OperatResult.AppendText(">>解决方案不存在\n", Color.Red);
                return;
            }
            //保存不良原因
            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 '" + mb_id + "','" + mbr_id + "','" + nr_code.Text + "',");
            sql.Append("'" + so_code.Text + "','" + mbr_dutyname.Text + "','" + nrg_code.Text + "','" + bc_code.Text + "',");
            sql.Append("'" + ms_sncode.Text + "','" + ma_code.Text + "',sysdate,'" + User.UserCode + "','" + nr_name.Text + "','" + so_name.Text + "','" + bc_name.Text + "','" + nrg_name.Text + "','" + mbr_dutyname.Text + "' from dual");
            dh.ExecuteSql(sql.GetString(), "insert");
            if (mbc_component.Text != "")
            {
                sql.Clear();
                sql.Append("insert into makebadrscom (mbc_id,mbc_mbrid,mbc_component,mbc_badcode,");
                sql.Append("mbc_brcode,mbc_sncode,mbc_makecode,mbc_indate,mbc_inman ) values ");
                sql.Append("(makebadrscom_seq.nextval,'" + mbr_id + "' ,'" + mbc_component.Text + "',");
                sql.Append("'" + bc_code.Text + "','" + nr_code.Text + "','" + ms_sncode.Text + "','" + ma_code.Text + "',sysdate,'" + User.UserCode + "')");
                dh.ExecuteSql(sql.GetString(), "insert");
            }
            OperatResult.AppendText(">>不良原因保存成功\n", Color.Green);
            SaveRepairInf.Enabled = false;
            LoadBadInfTree(sender, e);
        }

        private void DeleteRepairInf_Click(object sender, EventArgs e)
        {
            if (mbr_id != "")
            {
                string delete1 = "delete from makebadrsloc where mbl_mbrid='" + mbr_id + "'";
                string delete2 = "delete from makebadrspart where mbp_mbrid='" + mbr_id + "'";
                string delete3 = "delete from makebadrscom where mbc_mbrid='" + mbr_id + "'";
                string delete4 = "delete from makebadreason where mbr_id='" + mbr_id + "'";
                dh.ExecuteSQLTran(delete1, delete2, delete3, delete4);
                OperatResult.AppendText(">>删除成功\n", Color.Green);
                BaseUtil.CleanControlsText(bc_name, bc_code, bg_name, bg_code, mb_badremark, nrg_name, nrg_code, nr_name, nr_code, so_name, so_code, mbr_dutyname, mbr_dutycode, mbc_component);
                mbp_partdgv.DataSource = null;
                mbl_locdgv.DataSource = null;
                mbr_id = "";
                //删除后重新加载Tree的信息
                LoadBadInfTree(sender, e);
            }
            else OperatResult.AppendText(">>必须选择不良原因\n", Color.Red);
        }

        private void SaveBadLocation_Click(object sender, EventArgs e)
        {
            if (mbl_loc.Text != "")
            {
                if (mbr_id != "")
                {
                    if (!dh.CheckExist("makebadrsloc", "mbl_mbrid='" + mbr_id + "' and mbl_sncode='" + GetSNCode.Text + "' and mbl_loc='" + mbl_loc.Text.ToUpper() + "'"))
                    {
                        sql.Clear();
                        sql.Append("insert into makebadrsloc(mbl_id,mbl_mbrid,mbl_loc,mbl_badcode,mbl_brcode,");
                        sql.Append("mbl_sncode,mbl_makecode,mbl_indate ,mbl_inman) select makebadrsloc_seq.nextval," + mbr_id);
                        sql.Append(",'" + mbl_loc.Text.ToUpper() + "','" + bc_code.Text + "','" + nr_code.Text + "','" + GetSNCode.Text + "','" + ma_code.Text + "',");
                        sql.Append("sysdate,'" + User.UserCode + "' from dual");
                        dh.ExecuteSql(sql.GetString(), "insert");
                        dt = (DataTable)dh.ExecuteSql("select mbl_id,mbl_loc from makebadrsloc where mbl_mbrid=" + mbr_id, "select");
                        BaseUtil.FillDgvWithDataTable(mbl_locdgv, dt);
                        sql.Clear();
                        sql.Append("with temp1 as (select bd_soncode,bd_location from bomdetail,bom where bo_id=bd_bomid ");
                        sql.Append(" start with bo_mothercode='" + pr_code.Text + "' connect by bo_mothercode= prior bd_soncode) ");
                        sql.Append("select bd_soncode from temp1 where instr(','||bd_location||',','," + mbl_loc.Text.ToUpper() + ",')>0");
                        dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                        if (dt.Rows.Count > 0)
                        {
                            sql.Clear();
                            sql.Append("insert into makebadrspart(mbp_id,mbp_mbrid,mbp_part,mbp_badcode,");
                            sql.Append("mbp_brcode,mbp_sncode,mbp_makecode,mbp_indate,mbp_inman)");
                            sql.Append("select makebadrspart_seq.nextval," + mbr_id + ",'" + dt.Rows[0][0].ToString() + "',");
                            sql.Append("'" + bc_code.Text + "','" + nr_code.Text + "','" + GetSNCode.Text + "','" + ma_code.Text + "',");
                            sql.Append("sysdate,'" + User.UserCode + "' from dual");
                            dh.ExecuteSql(sql.GetString(), "insert");
                            dt = (DataTable)dh.ExecuteSql("select mbp_id,mbp_part from makebadrspart where mbp_mbrid=" + mbr_id, "select");
                            BaseUtil.FillDgvWithDataTable(mbp_partdgv, dt);
                            mbl_loc.Clear();
                        }
                    }
                    else OperatResult.AppendText(">>已存在该不良位置\n", Color.Red);
                }
                else OperatResult.AppendText(">>请先选择不良原因\n", Color.Red);
            }
            else OperatResult.AppendText(">>不良位置不能为空\n", Color.Red);
        }

        private void nr_name_TextChanged(object sender, EventArgs e)
        {
            if (nr_name.Text == "")
                SaveBadLocation.Enabled = false;
            else
                SaveBadLocation.Enabled = true;
        }

        private void mbl_loc_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
                SaveBadLocation_Click(sender, e);
        }

        private void prodcode_TextKeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                if (bd_soncode.Text != "")
                {
                    if (mbr_id != "")
                    {
                        sql.Clear();
                        sql.Append("insert into makebadrspart(mbp_id,mbp_mbrid,mbp_part,mbp_badcode,");
                        sql.Append("mbp_brcode,mbp_sncode,mbp_makecode,mbp_indate,mbp_inman)");
                        sql.Append("select makebadrspart_seq.nextval," + mbr_id + ",'" + bd_soncode.Text + "',");
                        sql.Append("'" + bc_code.Text + "','" + nr_code.Text + "','" + GetSNCode.Text + "','" + ma_code.Text + "',");
                        sql.Append("sysdate,'" + User.UserCode + "' from dual");
                        dh.ExecuteSql(sql.GetString(), "insert");
                        DataTable dt = (DataTable)dh.ExecuteSql("select mbp_id,mbp_part from makebadrspart where mbp_mbrid=" + mbr_id, "select");
                        BaseUtil.FillDgvWithDataTable(mbp_partdgv, dt);
                    }
                    else OperatResult.AppendText(">>请先选择不良原因\n", Color.Red);
                }
                else OperatResult.AppendText(">>不良零件不能为空\n", Color.Red);
            }
        }

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

        private void mbl_locdgv_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex >= 0)
            {
                if (mbl_locdgv.Columns[e.ColumnIndex].Name == "DeletePos")
                {
                    dh.ExecuteSql("delete from makebadrsloc where mbl_id='" + mbl_locdgv.Rows[e.RowIndex].Cells["mbl_id"].Value.ToString() + "'", "insert");
                    dt = (DataTable)dh.ExecuteSql("select mbl_id,mbl_loc from makebadrsloc where mbl_mbrid=" + mbr_id, "select");
                    BaseUtil.FillDgvWithDataTable(mbl_locdgv, dt);
                }
            }
        }

        private void mbp_partdgv_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex >= 0)
            {
                if (mbp_partdgv.Columns[e.ColumnIndex].Name == "DeleteCom")
                {
                    dh.ExecuteSql("delete from makebadrspart where mbp_id='" + mbp_partdgv.Rows[e.RowIndex].Cells["mbp_id"].Value.ToString() + "'", "insert");
                    DataTable dt = (DataTable)dh.ExecuteSql("select mbp_id,mbp_part from makebadrspart where mbp_mbrid=" + mbr_id, "select");
                    BaseUtil.FillDgvWithDataTable(mbp_partdgv, dt);
                }
            }
        }

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

        private void ms_prodcode_TextChanged(object sender, EventArgs e)
        {

        }

        public void RefreshData()
        {
            GetSNCode_KeyDown(new object(), new KeyEventArgs(Keys.Enter));
        }

        private void nr_name_UserControlTextChanged(object sender, EventArgs e)
        {
            if (nr_name.Text != "")
            {
                SaveBadLocation.Enabled = true;
                if (nrg_name.Text == "")
                {
                    OperatResult.AppendText(">>请先填写不良代码组\n", Color.Red);
                    nr_name.Text = "";
                }
                else
                {
                    if (nr_code.Text == "" || (nr_code.Text != "" && nr_code.Text != nr_name.Value))
                        nr_code.Text = nr_name.Value;
                }
            }
            else SaveBadLocation.Enabled = false;
        }

        private void nrg_name_UserControlTextChanged(object sender, EventArgs e)
        {
            if (nrg_code.Text == "" || (nrg_code.Text != "" && nrg_code.Text != nrg_name.Value))
                nrg_code.Text = nrg_name.Value;
            nr_name.Condition = "nrg_code in('" + (nrg_code.Text == "" ? "''" : nrg_code.Text) + "')";
        }

        private void mbr_dutyname_UserControlTextChanged(object sender, EventArgs e)
        {
            if (mbr_dutycode.Text == "" || (mbr_dutycode.Text != "" && mbr_dutycode.Text != mbr_dutyname.Value))
                mbr_dutycode.Text = mbr_dutyname.Value;
        }

        private void mbc_component_UserControlTextChanged(object sender, EventArgs e)
        {

        }

        private void so_name_UserControlTextChanged(object sender, EventArgs e)
        {
            if (so_code.Text == "" || (so_code.Text != "" && so_code.Text != so_name.Value))
                so_code.Text = so_name.Value;
        }

        private void normalButton1_Click(object sender, EventArgs e)
        {
            DataTable dt = (DataTable)dh.ExecuteSql("select ms_makecode from makeserial where ms_id='" + msid + "' and ms_sncode='" + GetSNCode.Text + "' and ms_status=3", "select");
            if (dt.Rows.Count > 0)
            {
                if (mb_id != "")
                {

                    string delete1 = "delete from makebadrsloc where mbl_mbrid in (select mbr_id from makebadreason where mbr_mbid = '" + mb_id + "' )";
                    string delete2 = "delete from makebadrspart where mbp_mbrid in (select mbr_id from makebadreason where mbr_mbid = '" + mb_id + "' )";
                    string delete3 = "delete from makebadrscom where mbc_mbrid in (select mbr_id from makebadreason where mbr_mbid = '" + mb_id + "' )";
                    string delete4 = "delete from makebadreason where mbr_mbid='" + mb_id + "'";
                    string delete = "delete from makebad where mb_id = '" + mb_id + "'";
                    dh.ExecuteSQLTran(delete1, delete2, delete3, delete4, delete);
                    OperatResult.AppendText(">>删除成功\n", Color.Green);
                    BaseUtil.CleanControlsText(bc_name, bc_code, bg_name, bg_code, mb_badremark, nrg_name, nrg_code, nr_name, nr_code, so_name, so_code, mbr_dutyname, mbr_dutycode, mbc_component);
                    mbp_partdgv.DataSource = null;
                    mbl_locdgv.DataSource = null;
                    mb_id = "";
                    //删除后重新加载Tree的信息
                    LoadBadInfTree(sender, e);
                }
                else OperatResult.AppendText(">>必须选择不良现象\n", Color.Red);
            }
            else OperatResult.AppendText(">>" + GetSNCode.Text + "序列号错误，不存在或者不处于维修状态\n", Color.Red);
        }


        private void LoadBadcodeGroup()
        {
            string pr_code = dh.getFieldDataByCondition("makeserial", "ms_prodcode", "ms_sncode='" + ms_sncode.Text + "' and ms_makecode='" + ma_code.Text + "'").ToString();
            sql.Clear();
            sql.Append("select bg_code,bg_name from product left join productkind  on pr_kind =pk_name ");
            sql.Append("left join productbadgroup on pb_kindcode= pk_code left join badgroup on ");
            sql.Append("bg_code=pb_badgroup  where pr_code='" + pr_code + "' and nvl(pb_kindcode,'')<>'' and bg_statuscode='AUDITED' order by case when bg_code='" + Settings.Default.DefaultBadGroup + "' then 0 else 1 end");
            dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            //如果未查询到数据则获取全部的不良组别
            if (dt.Rows.Count == 0)
            {
                sql.Clear();
                sql.Append("select bg_code,bg_name from badgroup where bg_statuscode='AUDITED' order by case when bg_code='" + Settings.Default.DefaultBadGroup + "' then 0 else 1 end");
                dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                badgroup.DataSource = dt;
                badgroup.DisplayMember = "bg_name";
                badgroup.ValueMember = "bg_code";
                LoadBadCodeListView();
            }
            else
            {
                badgroup.DataSource = dt;
                badgroup.DisplayMember = "bg_name";
                badgroup.ValueMember = "bg_code";
                LoadBadCodeListView();
            }
        }

        /// <summary>
        /// 加载不良代码的ListView的信息
        /// </summary>
        private void LoadBadCodeListView()
        {
            string bg_id = badgroup.SelectedValue.ToString();
            sql.Clear();
            sql.Append("select bg_code,bg_name,bc_code,bc_name,bc_note from badgroupdetail left join badgroup on bgd_bgid=bg_id ");
            sql.Append("left join badcode on bgd_badcode=bc_code where bg_code='" + ((bg_id != "" && bg_id != "System.Data.DataRowView") ? bg_id.ToString() : "") + "' and bg_code is not null ");
            dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            BadInfo.DataSource = dt;
            //往listview中添加数据
            WaitRejectList.Items.Clear();
            WaitRejectList.BeginUpdate();
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                ListViewItem lvi = new ListViewItem();
                //第一列是勾选列，设置列头文本为空
                lvi.Text = "";
                for (int j = 0; j < dt.Columns.Count; j++)
                    lvi.SubItems.Add(dt.Rows[i][j].ToString());
                WaitRejectList.Items.Add(lvi);
            }
            WaitRejectList.EndUpdate();
        }

        private void badgroup_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (badgroup.SelectedValue.ToString() != "System.Data.DataRowView")
            {
                Settings.Default.DefaultBadGroup = badgroup.SelectedValue.ToString();
                Settings.Default.Save();
            }
            LoadBadCodeListView();
        }

        private void Filter_UserControlTextChanged(object sender, EventArgs e)
        {
            try
            {
                DataRow[] dr = (BadInfo.DataSource as DataTable).Select(" bc_code like '%" + Filter.Text + "%'");
                DataTable dt = (BadInfo.DataSource as DataTable).Clone();
                for (int i = 0; i < dr.Length; i++)
                {
                    dt.Rows.Add(dr[i].ItemArray);
                }
                WaitRejectList.Items.Clear();
                WaitRejectList.BeginUpdate();
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    ListViewItem lvi = new ListViewItem();
                    //第一列是勾选列，设置列头文本为空
                    lvi.Text = "";

                    for (int j = 0; j < dt.Columns.Count; j++)
                        lvi.SubItems.Add(dt.Rows[i][j].ToString());
                    WaitRejectList.Items.Add(lvi);
                }
                WaitRejectList.EndUpdate();
            }
            catch (Exception)
            {

            }
        }


        private void Filter_UserControlOnKeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                if (WaitRejectList.Items.Count == 1)
                {
                    int RejectCount = WaitRejectList.Items.Count;
                    string[] bccode = new string[RejectCount];
                    string[] bgcode = new string[RejectCount];
                    string[] id = new string[RejectCount];
                    string ErrorMessage = "";
                    if (WaitRejectList.Items.Count == 0)
                    {
                        MessageBox.Show("不良品必须选择不良原因和不良代码!");
                        return;
                    }
                    else
                    {
                        //用户未填写不良代码一切按照正常逻辑，填写了从index=1开始执行
                        for (int i = 0; i < RejectCount; i++)
                        {
                            bgcode[i] = WaitRejectList.Items[i].SubItems[1].Text;
                            //获取所有的不良代码
                            bccode[i] = WaitRejectList.Items[i].SubItems[3].Text;
                            //获取所有的不良备注
                            id[i] = dh.GetSEQ("MakeBad_seq");
                        }
                    }
                    sql.Clear();
                    sql.Append("insert into makebad(mb_id,mb_makecode,mb_mscode,mb_sncode,mb_inman,");
                    sql.Append("mb_indate,mb_stepcode,mb_sourcecode,mb_badcode,mb_bgcode,mb_badtable,mb_status)");
                    sql.Append("select :id,'" + ma_code.Text + "','" + GetSNCode.Text + "','" + GetSNCode.Text + "','" + User.UserCode + "',sysdate,'" + User.CurrentStepCode + "','" + User.UserSourceCode + "',:bc_code,:bg_code,'',");
                    sql.Append("'0' from dual ");
                    dh.BatchInsert(sql.GetString(), new string[] { "id", "bc_code", "bg_code" }, id, bccode, bgcode);
                    OperatResult.AppendText(">>不良插入成功\n", Color.Green);
                    LoadBadInfTree(sender, e);
                }
                else
                {
                    OperatResult.AppendText(">>不良代码不存在或存在多个\n", Color.Red);
                }
            }
        }

        private void WaitRejectList_DoubleClick(object sender, EventArgs e)
        {
            for (int i = WaitRejectList.Items.Count - 1; i >= 0; i--)
            {
                if (WaitRejectList.Items[i].Checked)
                {
                    //双击右移
                    Filter.Text = WaitRejectList.Items[i].SubItems[3].Text;
                    Filter_UserControlOnKeyDown(sender, new KeyEventArgs(Keys.Enter));
                }
            }
        }
    }
}