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.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 mb_id = ""; string mbr_id = ""; /// /// 存放父节点信息 /// Dictionary> BadInf_1 = new Dictionary>(); /// /// 存放子节点信息 /// Dictionary> BadInf_2 = new Dictionary>(); DataHelper dh = null; LogStringBuilder sql = new LogStringBuilder(); List sqls = new List(); 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>序列号不允许为空\n", Color.Red); BaseUtil.CleanForm(this); BadCodeTree.Nodes.Clear(); return; } string ms_status = dh.getFieldDataByCondition("Makeserial", "ms_status", "ms_sncode='" + GetSNCode.Text + "'").ToString(); if (ms_status == "4") { OperatResult.AppendText(">>序列号:" + GetSNCode.Text + "已处于报废状态\n", Color.Red); BaseUtil.CleanForm(this); BadCodeTree.Nodes.Clear(); return; } if (ms_status != "3") { OperatResult.AppendText(">>序列号:" + GetSNCode.Text + "不处于维修状态\n", Color.Red); BaseUtil.CleanForm(this); BadCodeTree.Nodes.Clear(); 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,ms_makecode,ms_prodcode,ms_sncode,pr_detail,ms_stepcode,ms_craftcode "); sql.Append("from makeserial left join product on pr_code=ms_prodcode where ms_makecode ='" + macode + "' and(ms_sncode"); sql.Append("='" + GetSNCode.Text + "' or ms_firstsn in (select firstsn from makesnrelation where "); sql.Append("sn='" + GetSNCode.Text + "')) group by ms_makecode,ms_prodcode,ms_sncode,pr_detail,ms_stepcode,ms_craftcode"); dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select"); if (dt.Rows.Count > 0) { msid = dt.Rows[0]["ms_id"].ToString(); BaseUtil.SetFormValue(this.Controls, dt); LoadBadInfTree(sender, e); } else OperatResult.AppendText(">>" + ErrorMessage + "\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(); BaseUtil.CleanControlsText(bc_name, bc_code, bg_name, bg_code, mb_badremark, nrg_name, nr_name, nr_code, mbr_solutioncode, mbr_dutycode, mbc_component); 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) { //展示父节点信息 mb_id = e.Node.Parent.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"]; //展示子节点信息 mbr_id = e.Node.Tag.ToString(); nrg_name.Text = BadInf_2[mbr_id]["nrg_name"]; nr_name.Text = BadInf_2[mbr_id]["nr_name"]; nr_code.Text = BadInf_2[mbr_id]["nr_code"]; mbr_solutioncode.Text = BadInf_2[mbr_id]["so_name"]; mbr_dutycode.Text = BadInf_2[mbr_id]["mbr_dutycode"]; 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); } } 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='" + macode + "' 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 dic = new Dictionary(); 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,nrg_name"); sql.Append(",nr_name,nr_code 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 on so_code=mbr_solutioncode "); sql.Append("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 dic1 = new Dictionary(); 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()); 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); } } try { if (bg_code.Text != "") BadCodeTree.Nodes[bg_code.Text].Expand(); } catch (Exception) { } } 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; } //判断是否所有的不良信息都有维护不良原因 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 + "'", "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; } dt = (DataTable)dh.ExecuteSql("select cr_id from craft where cr_statuscode='AUDITED' and cr_code='" + cr_code.Text + "'", "select"); if (dt.Rows.Count == 0) OperatResult.AppendText(">>回流工序不存在\n", Color.Red); else { string cr_id = dt.Rows[0]["cr_id"].ToString(); dt = (DataTable)dh.ExecuteSql("select cd_ifinput from craftdetail left join step on st_code=cd_stepcode where cd_crid='" + cr_id + "' and cd_stepcode='" + cd_stepcode.Text + "' and st_statuscode='AUDITED'", "select"); if (dt.Rows.Count == 0) OperatResult.AppendText(">>回流工序不在回流工艺中\n", Color.Red); else { dh.UpdateByCondition("makeserial", "ms_nextstepcode='" + cd_stepcode.Text + "',ms_craftcode='" + cr_code.Text + "',ms_stepcode='" + User.CurrentStepCode + "',ms_status=1", "ms_sncode='" + ms_sncode.Text + "'"); dh.UpdateByCondition("makebad", "mb_status=-1", "mb_sncode='" + ms_sncode.Text + "'"); LogicHandler.InsertMakeProcess(ms_sncode.Text, ms_makecode.Text, User.UserSourceCode, "回流工序", "完成维修回流", User.UserCode); OperatResult.AppendText(">>" + ms_sncode.Text + " 序列号回流成功\n", Color.Green); BaseUtil.CleanForm(this); BadCodeTree.Nodes.Clear(); GetSNCode.Clear(); } } } 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 + "'").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") { dh.UpdateByCondition("makeserial", "ms_status=4,ms_nextstepcode='',ms_stepcode='" + User.CurrentStepCode + "'", "ms_sncode='" + ms_sncode.Text + "' and ms_makecode='" + macode + "'"); dh.UpdateByCondition("make", "MA_NGMADEQTY=nvl(MA_NGMADEQTY,0)+1", "ma_code='" + macode + "'"); LogicHandler.InsertMakeProcess(ms_sncode.Text,ms_makecode.Text,User.UserSourceCode,"报废","序列号报废",User.UserCode); 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 == "" || macode == null || macode == "") { OperatResult.AppendText(">>序列号和工单号不允许为空\n", Color.Red); } else { 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) { 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) { //保存不良零件 DataTable dt = (DataTable)mbp_partdgv.DataSource; if (dt != null && dt.Rows.Count > 0) { List prodcode = new List(); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["mbp_id"].ToString() == "") prodcode.Add(dt.Rows[i]["mbp_part"].ToString()); } if (prodcode.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 + ",:prodcode,"); sql.Append("'" + bc_code.Text + "','" + nr_code.Text + "','" + GetSNCode.Text + "','" + macode + "',"); sql.Append("sysdate,'" + User.UserCode + "' from dual"); dh.BatchInsert(sql.GetString(), new string[] { "prodcode" }, prodcode.ToArray()); } OperatResult.AppendText(">>不良零件保存成功\n", Color.Green); } else OperatResult.AppendText(">>不良零件未维护数据\n", Color.Red); //保存不良位置 dt = (DataTable)mbl_locdgv.DataSource; if (dt != null && dt.Rows.Count > 0) { List location = new List(); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["mbl_id"].ToString() == "") location.Add(dt.Rows[i]["mbl_loc"].ToString()); } if (location.Count > 0) { 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(",:location,'" + bc_code.Text + "','" + nr_code.Text + "','" + GetSNCode.Text + "','" + macode + "',"); sql.Append("sysdate,'" + User.UserCode + "' from dual"); dh.BatchInsert(sql.GetString(), new string[] { "location" }, location.ToArray()); } OperatResult.AppendText(">>不良位置保存成功\n", Color.Green); } else OperatResult.AppendText(">>不良位置未维护数据\n", Color.Red); } private void DeleteRepairInf_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 (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, nr_name, nr_code, mbr_solutioncode, mbr_dutycode, mbc_component); mbp_partdgv.DataSource = null; mbl_locdgv.DataSource = null; mbr_id = ""; //删除后重新加载Tree的信息 LoadBadInfTree(sender, e); } else OperatResult.AppendText(">>必须选择不良原因\n", Color.Red); } else OperatResult.AppendText(">>" + GetSNCode.Text + "序列号错误,不存在或者不处于维修状态\n", Color.Red); } private void SaveBadLocation_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 (mbl_loc.Text != "") { if (mbr_id != "") { dt = (DataTable)mbl_locdgv.DataSource; for (int i = 0; i < dt.Rows.Count; i++) { } DataRow dr = dt.NewRow(); dr["mbl_loc"] = mbl_loc.Text; dt.Rows.Add(dr); } else OperatResult.AppendText(">>请先选择不良原因\n", Color.Red); } else OperatResult.AppendText(">>不良位置不能为空\n", Color.Red); } else OperatResult.AppendText(">>" + GetSNCode.Text + "序列号错误,不存在或者不处于维修状态\n", Color.Red); } private void mbl_loc_TextChanged(object sender, EventArgs e) { if (mbl_loc.Text != "") prodcode.TableName = dbtable2.Replace(":macode", macode).Replace(":sncode", GetSNCode.Text).Replace(":msl_location", mbl_loc.Text); } 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 (prodcode.Text != "") { if (mbr_id != "") { DataTable dt = (DataTable)mbp_partdgv.DataSource; DataRow dr = dt.NewRow(); dr["mbp_part"] = prodcode.Text; dt.Rows.Add(dr); } else OperatResult.AppendText(">>请先选择不良原因\n", Color.Red); } else OperatResult.AppendText(">>不良零件不能为空\n", Color.Red); } } private void cr_code_UserControlTextChanged(object sender, EventArgs e) { cd_stepcode.Condition = "ST_STATUSCODE='AUDITED' and cr_code='" + cr_code.Text + "'"; } private void Clean_Click(object sender, EventArgs e) { OperatResult.Clear(); } } }