mes-client/UAS-MES/FunctionCode/Make/Make_Repair.cs

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

namespace UAS_MES.Make
{
    public partial class Make_Repair : Form
    {

        string caller = "Make!Repair";
        //记录维修结果的代码值
        string Repair_Result;
        //记录不良状态码
        string badcode;
        //记录不良组别
        string groupcode;
        //判断是否获取了下拉框的值 
        string mb_id1;
        //记录插入操作日志表的sql
        string cm_makecode;
        //执行插入日志的SQL
        string insert_makeprocess = "insert into makeprocess(mp_id,mp_makecode,mp_maid, mp_mscode,mp_sncode,mp_stepcode,mp_stepname,mp_craftcode,mp_craftname,mp_kind,mp_result,mp_indate,mp_inman,mp_wccode,mp_linecode,mp_sourcecode) select MakeProcess_seq.nextval, ma_code,ma_id,ms_code,ms_sncode,mcd_stepcode,mcd_stepname,ma_craftcode,'','维修作业','#',sysdate,'" + User.UserName + "',ma_wccode,ma_linecode,'' from make left join makecraftdetail on mcd_macode=ma_code left join makeserial on ms_makecode=ma_code where ms_sncode=:ms_sncode and ma_code=:ma_code";
        //是否获取过下拉框数据
        bool GetSelectData = false;

        string mb_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 macode;   

        string msid = "";

        string dbtable1 = "(select distinct nvl(dsl_prodcode,msl_prodcode)prodcode from ReduceStepRecord left join devsmtlocation on dsl_linecode=rsd_linecode and dsl_makecode=rsd_macode left join makesmtlocation on msl_linecode=rsd_linecode and msl_makecode=rsd_macode where rsd_macode=':macode'  and rsd_sncode=':sncode') left join product on pr_code=prodcode";

        string dbtable2 = "(select distinct nvl(dsl_prodcode,msl_prodcode)prodcode from ReduceStepRecord left join devsmtlocation on dsl_linecode=rsd_linecode and dsl_makecode=rsd_macode left join makesmtlocation on msl_linecode=rsd_linecode and msl_makecode=rsd_macode where rsd_macode=':macode'  and rsd_sncode=':sncode' and ((dsl_location=':msl_location' and dsl_validtime<sysdate and sysdate<dsl_invalidtime) ) or (msl_location=':msl_location' and msl_validtime<sysdate and sysdate<msl_invalidtime)) left join product on pr_code=prodcode";

        public Make_Repair()
        {
            InitializeComponent();
        }

        private void 维修作业_Load(object sender, EventArgs e)
        {
            dh = new DataHelper();
            //为DBFind配置Call和Form的名称
            cr_code.FormName = Name;
            cr_code.TableName = "craft";
            cr_code.SelectField = "cr_name # 工艺名称 ,cr_code # 工艺编号,cr_prodcode # 物料编号";
            cr_code.SetValueField = new string[] { "cr_code" };

            cd_stepcode.FormName = Name;
            cd_stepcode.TableName = "craftdetail left join step on st_code=cd_stepcode left join craft on cd_crid=cr_id";
            cd_stepcode.SetValueField = new string[] { "cd_stepcode" };
            cd_stepcode.SelectField = "cd_stepname # 工序名称 ,cd_stepcode # 工序编号,cd_stepno # 执行顺序";
            cd_stepcode.Condition = "ST_STATUSCODE='AUDITED' and cr_code='" + cr_code.Text + "'";

            prodcode.FormName = Name;
            prodcode.TableName = dbtable1.Replace(":macode", macode).Replace(":sncode", GetSNCode.Text);
            prodcode.SetValueField = new string[] { "prodcode" };
            prodcode.SelectField = "prodcode # 不良零件编号,pr_detail # 零件名称";

            asc.controllInitializeSize(this);
            GetSNCode.Focus();
        }

        private void GetSNCode_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                if (GetSNCode.Text == "")
                {
                    MessageBox.Show("序列号不允许为空!");
                    return;
                }
                string ErrorMessage = "";
                //验证工序是否正确
                if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out ErrorMessage))
                {
                    BadInf_1.Clear();
                    if (LogicHandler.GetMakeInfo(GetSNCode.Text, out macode, out ErrorMessage))
                    {
                        //验证makeserial或者ms_firstsn表序列号是否存在
                        sql.Clear();
                        sql.Append("select max(ms_id) ms_id from makeserial where ms_makecode ='" + macode + "' and(ms_sncode");
                        sql.Append("='" + GetSNCode.Text + "' or ms_firstsn in (select firstsn from makesnrelation ");
                        sql.Append("where sn='" + GetSNCode.Text + "'))");
                        dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                        if (dt.Rows.Count > 0)
                        {
                            msid = dt.Rows[0]["ms_id"].ToString();
                            LoadBadInfTree(sender, e);
                        }
                        else
                            OperatResult.AppendText(">>序列号" + GetSNCode.Text + "不存在\n", Color.Red);
                    }
                    else
                        OperatResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
                }
                else
                    OperatResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
            }
        }

        private void Make_Repair_SizeChanged(object sender, EventArgs e)
        {
            asc.controlAutoSize(this);
        }

        private void BadCodeTree_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
        {
            if (e.Node.Level == 0)
            {
                mb_id = e.Node.Tag.ToString();
                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"];
            }
            if (e.Node.Level == 1)
            {
                string mbr_id = e.Node.Tag.ToString();
                nrg_name.Text = BadInf_2[mbr_id]["nrg_name"];
                nr_name.Text = BadInf_2[mbr_id]["nr_name"];
                mbr_solutioncode.Text = BadInf_2[mbr_id]["mbr_solutioncode"];
                mbr_dutycode.Text = BadInf_2[mbr_id]["mbr_dutycode"];
                mbc_component.Text = dh.getFieldDataByCondition("makebadrscom", "mbc_component", "mbc_mbrid=" + mbr_id).ToString();
                //加载两个Grid的数据源
                ComponentSource.DataSource = (DataTable)dh.ExecuteSql("select mbp_part from makebadrspart where mbp_mbrid=" + mbr_id, "select");
                LocationSource.DataSource = (DataTable)dh.ExecuteSql("select mbl_loc from makebadrsloc where mbl_mbrid=" + mbr_id, "select");
                mbl_locdgv.DataSource = LocationSource;
                mbp_partdgv.DataSource = ComponentSource;
            }
        }

        private void LoadBadInfTree(object sender, EventArgs e)
        {
            BadCodeTree.Nodes.Clear();
            sql.Clear();
            sql.Append("select mb_id,mb_sncode,mb_badcode,mb_bgcode,bc_name,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 + "' and mb_makecode='" + macode + "'");
            dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                //添加根节点
                TreeNode tnode_0 = new TreeNode();
                tnode_0.Text = dt.Rows[i]["mb_bgcode"].ToString();
                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_name,mbr_dutycode,nd_name,");
                sql.Append("nrg_name,nr_name from makebadreason left join QUA_NGReason left join QUA_NGREASONGROUP on ");
                sql.Append("nrg_code=nr_group on nr_code=mbr_brcode left join solution ");
                sql.Append("on so_code=mbr_solutioncode left join ngduty on nd_code=mbr_dutycode 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("nd_name", dt1.Rows[j]["nd_name"].ToString());
                    dic1.Add("so_name", dt1.Rows[j]["so_name"].ToString());
                    dic1.Add("nrg_name", dt1.Rows[j]["nrg_name"].ToString());
                    dic1.Add("nr_name", dt1.Rows[j]["nr_name"].ToString());
                    tnode_1.Text = dt1.Rows[j]["mbr_brgcode"].ToString();
                    if (!BadInf_2.ContainsKey(mbr_id))
                        BadInf_2.Add(mbr_id, dic1);
                    tnode_0.Nodes.Add(tnode_1);
                }
            }
            if (bg_code.Text != "")
            {
                BadCodeTree.Nodes[bg_code.Text].Expand();
            }
        }

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

        private void RepairComplete_Click(object sender, EventArgs e)
        {

        }

        private void Scrap_Click(object sender, EventArgs e)
        {

        }

        private void NewBadCode_Click(object sender, EventArgs e)
        {
            Make_NewBadCode badcode = new Make_NewBadCode(GetSNCode.Text, macode);
            badcode.FormClosed += LoadBadInfTree;
            BaseUtil.SetFormCenter(badcode);
            badcode.ShowDialog();
        }

        private void NewRepairInf_Click(object sender, EventArgs e)
        {
            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)
        {

        }

        private void DeleteRepairInf_Click(object sender, EventArgs e)
        {

        }

        private void mbl_loc_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                sql.Clear();
                sql.Append("select prodcode,pr_detail from (select distinct nvl(dsl_prodcode,msl_prodcode)");
                sql.Append("prodcode from ReduceStepRecord left join devsmtlocation on dsl_linecode=rsd_linecode ");
                sql.Append("and dsl_makecode=rsd_macode left join makesmtlocation on msl_linecode=rsd_linecode  ");
                sql.Append("and msl_makecode=rsd_macode where rsd_macode='" + macode + "'  and rsd_sncode='" + GetSNCode.Text + "'");
                sql.Append("and ((dsl_location='" + mbl_loc.Text + "' and dsl_validtime<sysdate and sysdate<dsl_invalidtime) ) or ");
                sql.Append("(msl_location='" + mbl_loc.Text + "' and msl_validtime<sysdate and sysdate<msl_invalidtime)) left join ");
                sql.Append("product on pr_code=prodcode");
                DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            }
        }

        private void SaveBadLocation_Click(object sender, EventArgs e)
        {

        }

        private void mbl_loc_TextChanged(object sender, EventArgs e)
        {
            if (mbl_loc.Text != "")
            {
                Console.WriteLine("TextChange");
                prodcode.TableName = dbtable2.Replace(":macode", macode).Replace(":sncode", GetSNCode.Text).Replace(":msl_location", mbl_loc.Text);
            }
        }
    }
}