protected void ctrlStationOffline_RmesDataChanged(object obj, Rmes.WinForm.Base.RMESEventArgs e)
{
if (e.MessageHead == "OFFLINE")
{
//string[] txt = e.MessageBody.ToString().Split('^');
//string sn = txt[0];
//string quality_status = txt[1];
string sn = e.MessageBody.ToString();
ProductInfoEntity product = ProductInfoFactory.GetByCompanyCodeSNSingle(CompanyCode, sn); //获取sn信息
//PlanSnEntity plansn1 = PlanSnFactory.GetBySn(sn);
string plan_code = product.PLAN_CODE;
//modify by thl 20161212 下线点对应的操作改到发动机第一次入库处执行
if (dataConn.GetValue("select count(1) from data_complete where sn='" + sn + "' and plan_code='" + plan_code + "' and station_code='" + LoginInfo.StationInfo.STATION_CODE + "' ") == "1")
{
dataConn.ExeSql("UPDATE DATA_PLAN SET OFFLINE_QTY=OFFLINE_QTY+1 WHERE plan_code='" + plan_code + "' ");
}
if (LoginInfo.ProductLineInfo.PLINE_CODE == "CL")
{
ProductDataFactory.Station_OffLine(product.PLAN_CODE, sn, "Y");
}
}
//else if (e.MessageHead == "SN")
//{
// RMESEventArgs args = new RMESEventArgs();
// args.MessageHead = "OFFCTRL";
// args.MessageBody = "";
// SendDataChangeMessage(args);
//}
}
protected void ctrlProductScan_RmesDataChanged(object obj, Rmes.WinForm.Base.RMESEventArgs e)
{
string sn, quality_status = "A";
if (e.MessageHead == null)
{
return;
}
if (e.MessageHead == "SN")
{
//上线后打印条码
sn = e.MessageBody.ToString();
product = ProductInfoFactory.GetByCompanyCodeSNSingle(CompanyCode, sn);//获取sn信息
ThePlancode = product.PLAN_CODE;
TheSo = product.PLAN_SO;
PublicClass.PrintTmISDE(product.PLAN_CODE, ThisSmTm);
txtGTH.Text = "";
arg.MessageHead = "CLEAR1";
arg.MessageBody = "";
SendDataChangeMessage(arg);
timer1.Enabled = true;
}
if (e.MessageHead == "ONLINEONLINE")
{
DataTable dt = dataConn.GetTable("select plan_code from data_plan where plan_qty<=online_qty and plan_code='" + ThePlancode + "'");
if (dt.Rows.Count > 0)
{
ProductDataFactory.ISDE_CREATE_JK_SJJHB(PlineCode1);
}
timer1.Enabled = true;
}
}
private void 报废处理ToolStripMenuItem_Click(object sender, EventArgs e)
{
//分装CL报废处理
DialogResult drt = MessageBox.Show("执行该功能将对缸盖进行报废处理，要继续吗？", "提示", MessageBoxButtons.YesNo);
if (drt == DialogResult.No)
{
return;
}
string ghtm = Microsoft.VisualBasic.Interaction.InputBox("请输入缸盖流水号", "输入");
if (ghtm.Trim() == "")
{
return;
}
string outstr = "";
ProductDataFactory.WGG_MODIFY_JHB(ghtm, LoginInfo.ProductLineInfo.PLINE_CODE, out outstr);
if (outstr != "GOOD")
{
MessageBox.Show(outstr, "提示");
}
//刷新计划
RMESEventArgs arg = new RMESEventArgs();
arg.MessageHead = "REFRESHCLPLAN";
arg.MessageBody = "";
SendDataChangeMessage(arg);
}
public PagedResult <IProductView> AllProducts()
{
var resultSet = new PagedResult <IProductView>();
resultSet.Rows = ProductDataFactory.AllProducts().ToList();
resultSet.Total = resultSet.Rows.Count;
return(resultSet);
}
public PagedResult <IProductView> GetProducts(int Prdcat, int Anzahl, int Start)
{
PagedResult <IProductView> resultSet = new PagedResult <IProductView>();
resultSet.Rows = ProductDataFactory.GetProducts(Prdcat, Anzahl, Start);
resultSet.Total = resultSet.Rows.Count;
return(resultSet);
}
protected void ctrlProcessComplete_RmesDataChanged(object obj, Rmes.WinForm.Base.RMESEventArgs e)
{
if (e.MessageHead == "SN")
{
//gridProcessList.Enabled = true;
//sn = e.MessageBody as string;
//PlanSnEntity ent_sn = PlanSnFactory.GetBySn(sn);
//ordercode=ent_sn.ORDER_CODE;
//if (ent_sn.PLAN_CODE != null) plancode = ent_sn.PLAN_CODE;
//else plancode = PlanFactory.GetByOrder(ent_sn.ORDER_CODE).PLAN_CODE;
InitProcessList();
ShowProcessList();
return;
}
if (e.MessageHead == "PLAN")
{
gridProcessList.Enabled = true;
plancode = e.MessageBody as string;
PlanEntity plan = PlanFactory.GetByKey(plancode);
if (plan != null)
{
ordercode = plan.ORDER_CODE;
InitProcessList();
ShowProcessList();
}
}
else if (e.MessageHead == "PRCS")
{
//string[] msgbdy = (e.MessageBody as string).Split('^');
//string process_code = msgbdy[0];
//string complete_flag = msgbdy[1];
//DealProcessComplete(process_code, complete_flag);
}
else if (e.MessageHead == "PAUSE")
{
this.gridProcessList.DataSource = null;
return;
}
else if (e.MessageHead == "SCP" || e.MessageHead == "OFFLINE")
{
this.gridProcessList.DataSource = null;
ProductDataFactory.ProcessControlComplete(company_code, pline_code, station_code, plancode, sn);
}
else if (e.MessageHead == "MESLL")
{
this.Visible = false;
return;
}
if (e.MessageHead.ToString() == "WORK" || e.MessageHead.ToString() == "QUA")
{
this.Visible = true;
return;
}
}
public PagedResult <IPrdcatView> AllProductCategorys()
{
var resultSet = new PagedResult <IPrdcatView>
{
Rows = ProductDataFactory.AllProductsCategorys().ToList(),
};
resultSet.Total = resultSet.Rows.Count;
return(resultSet);
}
private void timer1_Tick(object sender, EventArgs e)
{
try
{
timer1.Enabled = false;
string sql = "select jhmc from isde_jk_sjjhb ";
DataTable dt = dataConn.GetTable(sql);
if (dt.Rows.Count == 0)
{
ProductDataFactory.ISDE_CREATE_JK_SJJHB(PlineCode1);
}
sql = " select ewghtm,jhdm,jhso,ggxhmc from isde_jk_sjsxb where czzt='0' and rownum=1 ";
dt = dataConn.GetTable(sql);
if (dt.Rows.Count == 0)
{
timer1.Enabled = true;
return;
}
TheEwm = dt.Rows[0][0].ToString();
ThePlancode = dt.Rows[0][1].ToString();
TheSo = dt.Rows[0][2].ToString();
ThePmodel = dt.Rows[0][3].ToString();
if (ThePlancode == "")
{
timer1.Enabled = true;
return;
}
//初始化sn框
TheEwm = TheEwm.Replace("\r\n", "").Trim();
txtGTH.Text = TheEwm;
string sn = TheEwm;
TheSn = sn;
ThisSmTm = TheSo + "^DCEC^" + sn;
arg.MessageHead = "FILLSN";
arg.MessageBody = sn + "^" + TheSo + "^" + ThePmodel + "^" + ThePlancode;
SendDataChangeMessage(arg);
arg.MessageHead = "FILLSN1";
arg.MessageBody = ThisSmTm;
SendDataChangeMessage(arg);
arg.MessageHead = "PRINTISDE";
arg.MessageBody = ThisSmTm + "|" + ThePlancode;
SendDataChangeMessage(arg);
//arg.MessageHead = "FILLSN2";
//arg.MessageBody = TheSo + "^" + ThePmodel + "^" + ThePlancode;
//SendDataChangeMessage(arg);
}
catch
{
timer1.Enabled = true;
}
}
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 ASPxGridView1_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
string ThisSO = "", PlineCode = "", StationCode = "";
string Chsql2 = "SELECT PLAN_SO,PLINE_CODE FROM DATA_PLAN WHERE PLAN_CODE='" + ASPxTextPlanCode.Text.Trim() + "'";
DataTable Chdt2 = dc.GetTable(Chsql2);
if (Chdt2.Rows.Count <= 0)
{
ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail");
ASPxGridView1.JSProperties.Add("cpCallbackRet", "计划号不存在！");
return;
}
else
{
ThisSO = Chdt2.Rows[0][0].ToString();
PlineCode = Chdt2.Rows[0][1].ToString();
}
string Chsql3 = "SELECT STATION_CODE FROM CODE_STATION WHERE STATION_NAME='" + ASPxTextSation.Text.ToUpper().Trim() + "'";
DataTable Chdt3 = dc.GetTable(Chsql3);
if (Chdt3.Rows.Count <= 0)
{
ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail");
ASPxGridView1.JSProperties.Add("cpCallbackRet", "站点名称不存在！");
return;
}
else
{
StationCode = Chdt3.Rows[0][0].ToString();
}
ProductDataFactory.PL_QUERY_BOMZJTS(ThisSO, StationCode, PlineCode, "", ASPxTextPlanCode.Text.Trim(), "");
ProductDataFactory.PL_UPDATE_BOMZJTS(ThisSO, StationCode, ASPxTextPlanCode.Text.Trim(), PlineCode, "");
string Delsql = "delete from RSTBOMQD_XC ";
dc.ExeSql(Delsql);
string Insql = "INSERT INTO RSTBOMQD_XC (SELECT '" + ASPxTextPlanCode.Text.Trim() + "',GWMC,COMP,UDESC,QTY,GXMC,ZDMC,ZDDM,GYSMC from RSTBOMQD)";
dc.ExeSql(Insql);
string sql = "SELECT GWMC,GXMC,COMP,QTY,GYSMC FROM rstbomqd_xc where zddm='" + StationCode + "' and jhmc='" + ASPxTextPlanCode.Text.Trim() + "' order by gwmc,gxmc";
DataTable dt = dc.GetTable(sql);
Session["inv9500sql"] = sql;
ASPxGridView1.DataSource = dt;
ASPxGridView1.DataBind();
}
public ctrl_quality(string type, string sn, string stationcode1)
{
InitializeComponent();
CompanyCode = LoginInfo.CompanyInfo.COMPANY_CODE;
PlineID = LoginInfo.ProductLineInfo.RMES_ID;
PlineCode = LoginInfo.ProductLineInfo.PLINE_CODE;
StationCode = LoginInfo.StationInfo.STATION_CODE;
stationname = LoginInfo.StationInfo.STATION_NAME;
GridQuality.AutoGenerateColumns = false;
GridQuality.RowHeadersVisible = false;
GridQuality.DataSource = null;
Thetype = type;
TheSn = sn;
product = ProductInfoFactory.GetByCompanyCodeSNSingle(CompanyCode, TheSn);//获取sn信息
if (product == null)
{
return;
}
//执行存储过程 获取RSTBOMQATS
ProductDataFactory.PL_QUERY_QAZJTS(product.PLAN_SO, StationCode, PlineCode, "", product.PLAN_CODE, sn);
string sql = "select count(1) from data_sn_qa where company_code='" + CompanyCode + "' and plan_code='" + product.PLAN_CODE + "' and sn='" + TheSn + "' and station_code='" + StationCode + "' and pline_code='" + PlineCode + "' ";
if (dataConn.GetValue(sql) == "0")
{
//插入data_sn_qa
sql = " insert into data_sn_qa(rmes_id,sn,company_code,plan_code,pline_code,location_code,station_code,question,standard_answer,station_name) "
+ " select seq_rmes_id.nextval,'" + TheSn + "','" + CompanyCode + "','" + product.PLAN_CODE + "','" + PlineCode + "',gwdm,'" + StationCode + "',question,answer,'" + stationname + "' from RSTBOMQATS where zddm='" + StationCode + "' ";
dataConn.ExeSql(sql);
}
ThePlancode = product.PLAN_CODE;
GridQuality.Focus();
IsABC = false;
ShowData(type, TheSn, stationcode1);//A显示前道站点质量信息 B 显示当前站点质量信息
try
{
if (GridQuality.Rows.Count > 0 && IsABC)
{
PlanSnFactory.InitStationControl(CompanyCode, PlineID, LoginInfo.StationInfo.RMES_ID, product.PLAN_CODE, product.SN, "Rmes.WinForm.Controls.ctrl_quality");
dataConn.ExeSql("update data_sn_controls_complete set complete_flag='A' where station_code='" + LoginInfo.StationInfo.RMES_ID + "' and control_name='Rmes.WinForm.Controls.ctrl_quality' and sn='" + product.SN + "' and plan_code='" + product.PLAN_CODE + "' ");
}
}
catch
{ }
//this.RMesDataChanged += new RMesEventHandler(ctrl_Tj_RMesDataChanged);
}
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;
}
}
protected void ctrlStationOnline_RmesDataChanged(object obj, Rmes.WinForm.Base.RMESEventArgs e)
{
string plan_code, sn, order_code, sn_flag;
if (e.MessageHead == null)
{
return;
}
if (e.MessageHead == "ONLINE")
{
//DialogResult dlg=MessageBox.Show("是否上线", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Question) ;
//if (dlg == DialogResult.No) return;
sn = e.MessageBody.ToString();
//获取当前第一条计划的未上线流水号，打印流水号
//流水号做上线
PlanSnEntity ent_sn = PlanSnFactory.GetBySn(sn);
if (ent_sn == null)//如果没有sn，则msgbd为plancode
{
plan_code = "";
sn = "";
MessageBox.Show("流水号非法！", "提示");
//sn = PlanFactory.GetByKey(plan_code).PLAN_BATCH;
}
else
{
//order_code = PlanSnFactory.GetBySn(sn).ORDER_CODE;
//plan_code = PlanFactory.GetByOrder(order_code).PLAN_CODE;
plan_code = ent_sn.PLAN_CODE;
}
ProductDataFactory.Station_OnLine(plan_code, sn, DateTime.Now.ToString("yyyy-MM-dd"), LoginInfo.StationInfo.STATION_CODE, LoginInfo.ShiftInfo.SHIFT_CODE, LoginInfo.TeamInfo.TEAM_CODE, LoginInfo.UserInfo.USER_CODE);
RMESEventArgs arg = new RMESEventArgs();
arg.MessageHead = "SN";
arg.MessageBody = sn;
SendDataChangeMessage(arg);
}
}
private bool DealSn(string pSn)
{
string sn = pSn;
RMESEventArgs arg = new RMESEventArgs();
PlanSnEntity plansn1 = PlanSnFactory.GetBySn(sn);
if (plansn1 == null)
{
return(false);
}
arg.MessageHead = plansn1.SN_FLAG == "N" ? "ONLINE" : "SN";
string plan_code = plansn1.PLAN_CODE;
string quality_status = "A", complete_flag = "0";
List <ProductCompleteEntity> prc = ProductCompleteFactory.GetByPlanSn(CompanyCode, PlineCode, plan_code, sn, StationCode);
if (prc.Count > 0)
{
complete_flag = prc.First <ProductCompleteEntity>().COMPLETE_FLAG;
}
if (complete_flag == "1")
{
MessageBox.Show("此项装配任务已经完成下线");
return(false);
}
List <ProductDataEntity> prd = ProductDataFactory.GetProductDataByPlanSn(CompanyCode, PlineCode, plan_code, sn);
//if (prd.Count > 0) quality_status = prd.First<ProductDataEntity>().QUALITY_STATUS;
if (quality_status == "B")
{
DialogResult dlg = MessageBox.Show("此项装配工件质量不合格，要继续装配吗", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dlg == DialogResult.No)
{
return(false);
}
}
return(true);
}
void ctrl_Tj_RMesDataChanged(object obj, Rmes.WinForm.Base.RMESEventArgs e)
{
RMESEventArgs arg = new RMESEventArgs();
arg.MessageHead = "";
arg.MessageBody = "";
if (e.MessageHead == null)
{
return;
}
if (e.MessageHead == "SN" || e.MessageHead == "RESN" || e.MessageHead == "RECHECK")
{
TheSn = e.MessageBody.ToString();
product = ProductInfoFactory.GetByCompanyCodeSNSingle(CompanyCode, TheSn);//获取sn信息
if (product == null)
{
return;
}
ThePlancode = product.PLAN_CODE;
//初始化质量数据
//string sql = "select count(1) from data_sn_qa where company_code='"+CompanyCode+"' and plan_code='"+product.PLAN_CODE+"' and sn='"+TheSn+"' and station_code='"+StationCode+"' and pline_code='"+PlineCode+"' ";
//if (dataConn.GetValue(sql) == "0")
//{
// //插入data_sn_qa
// sql = " insert into data_sn_qa(rmes_id,sn,company_code,plan_code,pline_code,location_code,station_code,question,standard_answer,station_name) values "
// + " select seq_rmes_id.nextval,'"+TheSn+"','" + CompanyCode + "','" + product.PLAN_CODE + "','" + PlineCode + "',gwdm,'" + StationCode + "',question,answer,'"+stationname+"' from RSTBOMQATS where zddm='" + StationCode + "' ";
// dataConn.ExeSql(sql);
//}
string type = "B";
Thetype = type;
string sn = TheSn;
product = ProductInfoFactory.GetByCompanyCodeSNSingle(CompanyCode, TheSn);//获取sn信息
if (product == null)
{
return;
}
//执行存储过程 获取RSTBOMQATS
ProductDataFactory.PL_QUERY_QAZJTS(product.PLAN_SO, StationCode, PlineCode, "", product.PLAN_CODE, sn);
string sql = "select count(1) from data_sn_qa where company_code='" + CompanyCode + "' and plan_code='" + product.PLAN_CODE + "' and sn='" + TheSn + "' and station_code='" + StationCode + "' and pline_code='" + PlineCode + "' ";
if (dataConn.GetValue(sql) == "0")
{
//插入data_sn_qa
sql = " insert into data_sn_qa(rmes_id,sn,company_code,plan_code,pline_code,location_code,station_code,question,standard_answer,station_name) "
+ " select seq_rmes_id.nextval,'" + TheSn + "','" + CompanyCode + "','" + product.PLAN_CODE + "','" + PlineCode + "',gwdm,'" + StationCode + "',question,answer,'" + stationname + "' from RSTBOMQATS where zddm='" + StationCode + "' ";
dataConn.ExeSql(sql);
}
ThePlancode = product.PLAN_CODE;
GridQuality.Focus();
IsABC = false;
ShowData(type, TheSn, StationCode);//A显示前道站点质量信息 B 显示当前站点质量信息
try
{
if (GridQuality.Rows.Count > 0 && IsABC)
{
PlanSnFactory.InitStationControl(CompanyCode, PlineID, LoginInfo.StationInfo.RMES_ID, product.PLAN_CODE, product.SN, "Rmes.WinForm.Controls.ctrl_quality");
dataConn.ExeSql("update data_sn_controls_complete set complete_flag='A' where station_code='" + LoginInfo.StationInfo.RMES_ID + "' and control_name='Rmes.WinForm.Controls.ctrl_quality' and sn='" + product.SN + "' and plan_code='" + product.PLAN_CODE + "' ");
}
}
catch
{ }
//
}
}
public IPrdcatView GetPrdcatByPrimaryKey(int prdcatId)
{
return(ProductDataFactory.GetPrdcatByPrimaryKey(prdcatId));
}
public void AddPrdcat(IPrdcatView productCat)
{
ProductDataFactory.AddPrdcat(productCat);
}
public void AddProduct(IProductView product)
{
ProductDataFactory.AddProduct(product);
}
