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 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 = "";
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)
{
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 + "'");
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]["mbr_brgcode"].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.ExecuteSql(insert_makeprocess.Replace("#", "完成维修"), "insert", ms_sncode.Text, User.CurrentStepCode);
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("makebad", "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 + "'");
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)
{
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)
{
//保存不良零件
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();
}
}
}