public void GetByPlanStatonZJTS(string CompanyCode, string PlanCode, string PlineCode, string StationCode, string Sn, string fdjxl, string so, string stationcode1)
{
try
{
//大线生成计划对应的站点bom是根据当前登录的站点StationCode，返修点是根据选择的站点，这两个变量统一，但生成snbomtemp时，返修点要根据返修站点当前登录站点生成
//调用存储过程 获取替换后的站点BOM 插入data_sn_bom_temp和rstbomqd、rstbomts
StationEntity ent_st = StationFactory.GetBySTATIONCODE(StationCode);
string station_name = ent_st.STATION_NAME;
ProductDataFactory.PL_QUERY_ZJTS(so, StationCode, PlineCode, fdjxl, PlanCode, Sn);
}
catch (Exception e1)
{
return;
}
}
public void GetByPlanStatonDcecLQ(string CompanyCode, string PlanCode, string PlineCode, string StationCode, string Sn, string fdjxl, string so, string stationcode1, ProductInfoEntity productnew)
{
try
{
//大线生成计划对应的站点bom是根据当前登录的站点StationCode，返修点是根据选择的站点，这两个变量统一，但生成snbomtemp时，返修点要根据返修站点当前登录站点生成
//调用存储过程 获取替换后的站点BOM 插入data_sn_bom_temp和rstbomqd、rstbomts
StationEntity ent_st = StationFactory.GetBySTATIONCODE(StationCode);
string station_name = ent_st.STATION_NAME;
ProductDataFactory.PL_QUERY_BOMZJTS(so, StationCode, PlineCode, fdjxl, PlanCode, Sn);
ProductDataFactory.PL_UPDATE_BOMZJTS(so, StationCode, PlanCode, PlineCode, Sn);
ProductDataFactory.PL_UPDATE_BOMLSHTS(Sn, StationCode);
ProductDataFactory.PL_UPDATE_BOMSOTHTS(so, PlanCode, StationCode, Sn, LoginInfo.UserInfo.USER_CODE, stationcode1);
ProductDataFactory.PL_UPDATE_BOMSOTHTS_BOMLQ(productnew.PLAN_SO, productnew.PLAN_CODE, StationCode, Sn, LoginInfo.UserInfo.USER_CODE, stationcode1, PlineCode);
}
catch (Exception e1)
{
return;
}
}
void ctrQualityCheck_RMesDataChanged(object obj, Rmes.WinForm.Base.RMESEventArgs e)
{
string stationID = LoginInfo.StationInfo.RMES_ID;
RMESEventArgs arg = new RMESEventArgs();
arg.MessageHead = "";
arg.MessageBody = "";
if (e.MessageHead == null)
{
return;
}
//if (e.MessageHead == "WORK" || e.MessageHead=="MESLL")
// this.Visible = false;
//else if (e.MessageHead == "QUA")
// this.Visible = true;
//else
if (e.MessageHead.ToString() == "SN")
{
SN = e.MessageBody.ToString();
ProductInfoEntity product = ProductInfoFactory.GetByCompanyCodeSNSingle(LoginInfo.CompanyInfo.COMPANY_CODE, SN);
if (product == null)
{
return;
}
PlanCode = product.PLAN_CODE;
PlanSo = product.PLAN_SO;
Fdjxl = product.PRODUCT_SERIES;
Gylx = product.ROUNTING_REMARK;
//this.GridQuality.DataSource = SNDetectTempFactory.GetBySNStation(SN, StationCode);
//StationEntity station = StationFactory.GetByKey(StationID);
//List<SNDetectTempEntity> temp = SNDetectTempFactory.GetBySNStation(SN, StationID);
//foreach (var t in temp)
//{
// int i=GridQuality.Rows.Add();
// GridQuality.Rows[i].Cells["colRmesID"].Value = t.RMES_ID;
// GridQuality.Rows[i].Cells["colDetectCode"].Value = t.DETECT_ITEM_CODE;
// GridQuality.Rows[i].Cells["colDetectDesc"].Value = t.DETECT_ITEM_DESC;
// GridQuality.Rows[i].Cells["colQuanVal"].Value = t.DETECT_QUAN_VALUE;
// //GridQuality.Rows[i].Cells["colDetectRequire"].Value = t.QUAN_VALUE_REQUIRE;
// //GridQuality.Rows[i].Cells["colImage"].Value = t.IMAGE_FILE;
// GridQuality.Rows[i].Cells["colRemark"].Value = t.REMARK;
// GridQuality.Rows[i].Cells["colDataUp"].Value = t.MAX_VALUE;
// GridQuality.Rows[i].Cells["colDataDown"].Value = t.MIN_VALUE;
// GridQuality.Rows[i].Cells["colDetectFlag"].Value = t.DETECT_FLAG;
// ////DataGridViewComboBoxCell c = (DataGridViewComboBoxCell)(GridQuality.Rows[i].Cells["colFaultCode"]);
// ////List<DetectErrorItemEntity> errors = DetectErrorItemFactory.GetByDetectItemCode(station.WORKUNIT_CODE,t.DETECT_ITEM_CODE);
// ////c.DataSource = errors;
// ////c.DisplayMember = "ERROR_ITEM_NAME";
// ////c.ValueMember = "RMES_ID";
//}
//if (GridQuality.Rows.Count > 0)
//{
// RMESEventArgs args = new RMESEventArgs();
// args.MessageHead = "QUACTRL";
// args.MessageBody = "";
// SendDataChangeMessage(args);
// ShowQualityList();
//}
}
else if (e.MessageHead.ToString() == "PLAN")
{
//PlanCode = e.MessageBody.ToString();
//SNDetectTempFactory.InitQualitDetectList(CompanyCode, PlineID, StationID, PlanCode, SN, UserID);
////this.GridQuality.DataSource = SNDetectTempFactory.GetBySNStation(SN, StationID);
//StationEntity station = StationFactory.GetByKey(StationID);
//List<SNDetectTempEntity> temp = SNDetectTempFactory.GetBySNStation(SN, StationID);
//foreach (var t in temp)
//{
// int i = GridQuality.Rows.Add();
// GridQuality.Rows[i].Cells["colRmesID"].Value = t.RMES_ID;
// GridQuality.Rows[i].Cells["colDetectCode"].Value = t.DETECT_ITEM_CODE;
// GridQuality.Rows[i].Cells["colDetectDesc"].Value = t.DETECT_ITEM_DESC;
// GridQuality.Rows[i].Cells["colQuanVal"].Value = t.DETECT_QUAN_VALUE;
// //GridQuality.Rows[i].Cells["colDetectRequire"].Value = t.QUAN_VALUE_REQUIRE;
// //GridQuality.Rows[i].Cells["colImage"].Value = t.IMAGE_FILE;
// GridQuality.Rows[i].Cells["colRemark"].Value = t.REMARK;
// GridQuality.Rows[i].Cells["colDataUp"].Value = t.MAX_VALUE;
// GridQuality.Rows[i].Cells["colDataDown"].Value = t.MIN_VALUE;
// GridQuality.Rows[i].Cells["colDetectFlag"].Value = t.DETECT_FLAG;
// //DataGridViewComboBoxCell c = (DataGridViewComboBoxCell)(GridQuality.Rows[i].Cells["colFaultCode"]);
// //List<DetectErrorItemEntity> errors = DetectErrorItemFactory.GetByDetectItemCode(station.WORKUNIT_CODE, t.DETECT_ITEM_CODE);
// //c.DataSource = errors;
// //c.DisplayMember = "ERROR_ITEM_NAME";
// //c.ValueMember = "RMES_ID";
//}
//if (GridQuality.Rows.Count > 0)
//{
// RMESEventArgs args = new RMESEventArgs();
// args.MessageHead = "QUACTRL";
// args.MessageBody = "";
// SendDataChangeMessage(args);
// ShowQualityList();
//}
}
else if (e.MessageHead.ToString() == "FOCUSDETECT")
{
//指定站点先防错 后采集数据
if (GridQuality.Rows.Count > 0)
{
if (StationName == "Z100" || StationName == "Z110" || StationName == "Z120")
{
GetFocus(0);
}
}
}
else if (e.MessageHead == "SCP" || e.MessageHead == "OFFLINE")//下线处理data_sn_detect
{
//this.GridQuality.DataSource = null;
//ProductDataFactory.QualityControlComplete(CompanyCode, PlineCode, StationCode, PlanCode, SN);
}
else if (e.MessageHead == "SHOWDETECT")
{
SN = e.MessageBody.ToString();
ProductInfoEntity product = ProductInfoFactory.GetByCompanyCodeSNSingle(LoginInfo.CompanyInfo.COMPANY_CODE, SN);
if (product == null)
{
return;
}
PlanCode = product.PLAN_CODE;
PlanSo = product.PLAN_SO;
Fdjxl = product.PRODUCT_SERIES;
Gylx = product.ROUNTING_REMARK;
stationcode_fx = StationCode;
stationname_fx = StationName;
//check中 显示BOM信息和检测数据
SNDetectTempFactory.InitQualitDetectList(CompanyCode, PlineID, StationID, PlanCode, SN, UserCode, StationID);
string sql = "select * from data_sn_detect_data_TEMP where station_code='" + StationCode + "' and sn='" + SN + "' and plan_code='" + PlanCode + "' and detect_name!='LJTM' order by location_code,detect_seq ";
DataTable dt = dataConn.GetTable(sql);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.NewRow();
dt.Rows.Add(dr);
}
this.GridQuality.DataSource = dt;
ShowQualityList();
if (GridQuality.Rows.Count > 0)
{
PlanSnFactory.InitStationControl(CompanyCode, PlineID, StationID, product.PLAN_CODE, product.SN, "Rmes.WinForm.Controls.ctrlQualityDetect");
if (StationName == "Z100" || StationName == "Z110" || StationName == "Z120")
{
//指定站点先防错后采集数据
}
else
{
GetFocus(0);
}
}
else
{
arg.MessageHead = "INIT";
arg.MessageBody = "";
SendDataChangeMessage(arg);
}
SendBomConfirm2SN();
}
else if (e.MessageHead == "SHOWDETECTFX1")
{
SN = e.MessageBody.ToString();
ProductInfoEntity product = ProductInfoFactory.GetByCompanyCodeSNSingle(LoginInfo.CompanyInfo.COMPANY_CODE, SN);
if (product == null)
{
return;
}
PlanCode = product.PLAN_CODE;
PlanSo = product.PLAN_SO;
Fdjxl = product.PRODUCT_SERIES;
Gylx = product.ROUNTING_REMARK;
stationcode_fx = StationCode;
stationname_fx = StationName;
//check中 显示BOM信息和检测数据
//返修站点无需在往temp表中更新数据，在返修发动机上线时已经获取了历史记录，20161106
//如果需要实时检测数据，则要对检测数据进行删除和新增，在选择对应站点是进行处理
//SNDetectTempFactory.InitQualitDetectList(CompanyCode, PlineID, StationID, PlanCode, SN, UserCode, StationID);
string sql = "select * from data_sn_detect_data_TEMP where sn='" + SN + "' and plan_code='" + PlanCode + "' and detect_name!='LJTM' order by location_code,detect_seq ";
DataTable dt = dataConn.GetTable(sql);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.NewRow();
dt.Rows.Add(dr);
}
this.GridQuality.DataSource = dt;
ShowQualityList();
if (GridQuality.Rows.Count > 0)
{
//PlanSnFactory.InitStationControl(CompanyCode, PlineID, StationID, product.PLAN_CODE, product.SN, "Rmes.WinForm.Controls.ctrlQualityDetect");
if (StationName == "Z100" || StationName == "Z110" || StationName == "Z120")
{
//指定站点先防错后采集数据
}
else
{
GetFocus(0);
}
}
else
{
arg.MessageHead = "INIT";
arg.MessageBody = "";
SendDataChangeMessage(arg);
}
//SendBomConfirm2SN();
}
else if (e.MessageHead == "SHOWDETECT_FX")
{
try
{
//SN = e.MessageBody.ToString();
string item_info = e.MessageBody.ToString();//消息体是sn^stationcode^stationname
string[] cmd_info = item_info.Split('^');
SN = cmd_info[0];
stationcode_fx = cmd_info[1];
stationname_fx = cmd_info[2];
StationEntity ent_st = StationFactory.GetBySTATIONCODE(stationcode_fx);
string station_id1 = ent_st.RMES_ID;
ProductInfoEntity product = ProductInfoFactory.GetByCompanyCodeSNSingle(LoginInfo.CompanyInfo.COMPANY_CODE, SN);
if (product == null)
{
return;
}
PlanCode = product.PLAN_CODE;
PlanSo = product.PLAN_SO;
Fdjxl = product.PRODUCT_SERIES;
Gylx = product.ROUNTING_REMARK;
//check中 显示BOM信息和检测数据
SNDetectTempFactory.InitQualitDetectList(CompanyCode, PlineID, station_id1, PlanCode, SN, UserCode, StationID);
string sql = "select * from data_sn_detect_data_TEMP where station_code='" + stationcode_fx + "' and sn='" + SN + "' and plan_code='" + PlanCode + "' and detect_name!='LJTM' order by location_code,detect_seq ";
DataTable dt = dataConn.GetTable(sql);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.NewRow();
dt.Rows.Add(dr);
}
this.GridQuality.DataSource = dt;
ShowQualityList();
if (GridQuality.Rows.Count > 0)
{
GetFocus(0);
}
else
{
arg.MessageHead = "INIT";
arg.MessageBody = "";
SendDataChangeMessage(arg);
}
SendBomConfirm2SN();
}
catch
{ }
}
}
