public List <Wip> ListaMaquinaProceso(int proceso) { List <Wip> lista = new List <Wip>(); Conexion con = new Conexion(); SqlCommand cmd = con.AbrirConexionIntranet(); if (cmd != null) { cmd.CommandText = "Wip_ListMaquina"; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Area", "Encuadernacion"); cmd.Parameters.AddWithValue("@proceso", proceso); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Wip wp = new Wip(); wp.Maquina = reader["Maquina"].ToString(); wp.ID_Control = reader["CodigoMaquina"].ToString(); lista.Add(wp); } con.CerrarConexion(); } return(lista); }
protected void txtCodigo_TextChanged(object sender, EventArgs e) { string codigo = txtCodigo.Text; Wip wip = wipControl.BuscarPallet_Wip(codigo); if (wip.OT != null) { DivMensaje.Visible = false; lblOT.Text = wip.OT; lblNombreOT.Text = wip.NombreOT; txtcantidad.Text = wip.PliegosImpresos.ToString(); txtPeso.Text = wip.PesoPallet.ToString(); btnGuardar.Visible = true; pnlDetalle.Visible = true; DivMensaje.Visible = false; txtcantidad.Focus(); } else { btnGuardar.Visible = false; pnlDetalle.Visible = false; DivMensaje.Visible = true; DivMensaje.Attributes.Add("style", "background-color:Red"); Image1.ImageUrl = "../../Images/cross.png"; lblMensaje.ForeColor = Color.White; lblMensaje.Text = "Codigo de Pallet Incorrecto."; } }
protected void btnGuardar_Click(object sender, EventArgs e) { string Codigo = txtCodigo.Text.Trim(); int Cantidad = Convert.ToInt32(txtcantidad.Text.Trim()); double Peso = Convert.ToDouble(txtPeso.Text.Trim()); Wip wip = wipControl.BuscarPallet_Wip(Codigo); if (wipControl.UpdatePallet(Codigo, Cantidad, Peso, lblNombre.Text)) { if (wip.EstadoPallet == 6) { EnvioCorreo("Sunipac", lblNombre.Text, Codigo); } else if (wip.EstadoPallet == 7) { EnvioCorreo("Despacho Servico Externo", lblNombre.Text, Codigo); } Response.Redirect("Ajustar_Pallet.aspx?id=" + lblNombre.Text + "&tipo=" + lblTipo.Text); } else { DivMensaje.Visible = true; DivMensaje.Attributes.Add("style", "background-color:Red"); Image1.ImageUrl = "../../Images/cross.png"; lblMensaje.ForeColor = Color.White; lblMensaje.Text = "Error al Conectar al Servidor."; } }
/// <summary> /// Stores the point specified by (screenX, screenY) coordinates in the data structure.<br/> /// Determines the curve it belongs to according to the nearest last point of the curves existing.<br/> /// </summary> /// <param name="screenX"></param> /// <param name="screenY"></param> /// <param name="time">time in ms</param> public void AddInput(double screenX, double screenY, double distToWall, long time) { // transform screen coordinates double x; double y; adaptCoordinates(screenX, screenY, out x, out y); // update current position this.curX = x; this.curY = y; this.distToWall = distToWall; Boolean wasDrawing = this.isDrawing; this.isDrawing = distToWall < LIMIT_DIST_FOR_DRAWING; // check if there is a line to continue if (wasDrawing) { Wip w = curves.ElementAt(curves.Count - 1); if (time - w.time < DELTA_TIME && isPointWithinRange(x, y, w.lastPoint())) { completeLine(w, x, y, time); return; } } // new line insertNewLine(x, y, time); }
public Wip BuscarWip_ControlPorCodigo(string Codigo, string TipoMaquina = "", string Usuario = "") { Wip wip = new Wip(); Conexion con = new Conexion(); SqlCommand cmd = con.AbrirConexionIntranet(); if (cmd != null) { cmd.CommandText = "Wip_Buscar_ControlPorCodigo"; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Codigo", Codigo); cmd.Parameters.AddWithValue("@TipoMovil", TipoMaquina); cmd.Parameters.AddWithValue("@Usuario", Usuario); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { wip.ID_Control = reader["ID_Control"].ToString(); wip.Fecha_Creacion = Convert.ToDateTime(reader["Fecha_Creacion"].ToString()); wip.NombreOT = reader["NombreOT"].ToString(); wip.OT = reader["OT"].ToString(); wip.Usuario = reader["Usuario_Creador"].ToString(); wip.Ubicacion = reader["Ubicacion"].ToString(); wip.Posicion = reader["Posicion"].ToString(); wip.ProxProceso = reader["Prox_Proceso"].ToString(); } } return(wip); }
static void UpdateNextProcess(ProductProcess ProductProcess, int Accepted, WebApplication5Context db) { ProductProcess NextProductProcess = db.ProductProcesses.FirstOrDefault(q => q.Product.Code == ProductProcess.Product.Code && q.Order == ProductProcess.Order + 1); if (NextProductProcess != null) { //gets the next productprocess Wip nextw = db.Wips.FirstOrDefault <Wip>(e => e.ProductProcess.ID == NextProductProcess.ID); if (nextw == null) { nextw = new Wip(); nextw.ProductProcess = NextProductProcess; nextw.Input = Accepted; nextw.UpdatedAt = DateTime.Now; db.Wips.Add(nextw); } else { db.Entry(nextw).State = EntityState.Modified; nextw.UpdatedAt = DateTime.Now; //adds the previous accepter quantity nextw.Input = nextw.Input + Accepted; } } }
protected void txtCodigo_TextChanged(object sender, EventArgs e) { string codigo = txtCodigo.Text; Wip wip = wipControl.BuscarWip_ControlPorCodigo(codigo, "Movil", lblNombre.Text); if (wip.OT != null) { lblOT.Text = wip.OT.ToUpper(); lblNombreOT.Text = wip.NombreOT; pnlDetalle.Visible = true; string[] str = wipControl.UbicacionSugLibre(wip.OT).Split(','); lblRecomendacion.Text = str[1]; lblRecomUbi.Text = str[0]; btnGuardar.Visible = true; } else { DivMensaje.Visible = true; DivMensaje.Attributes.Add("style", "background-color:Red"); lblMensaje.Text = "Error de Codigo. Vuelva a Intentarlos"; lblMensaje.ForeColor = System.Drawing.Color.White; Image1.ImageUrl = "../../Images/cross.png"; } txtUbicacion.Focus(); }
public static void Calculate(ProductProcess ProductProcess, int Produced, int Rejected, WebApplication5Context db) { Wip w = db.Wips.FirstOrDefault <Wip>(q => q.ProductProcess.ID == ProductProcess.ID); if (w == null) { w = new Wip(); w.ProductProcess = ProductProcess; w.Input = Produced; w.Accepted = Produced - Rejected; w.Rejected = Rejected; w.UpdatedAt = DateTime.Now; db.Wips.Add(w); UpdateNextProcess(ProductProcess, w.Accepted, db); } else { db.Entry(w).State = EntityState.Modified; w.ProductProcess = ProductProcess; if (Produced <= w.Input) { w.Input = w.Input - Produced; w.Accepted = Produced - Rejected; w.Rejected = Rejected; w.UpdatedAt = DateTime.Now; UpdateNextProcess(ProductProcess, w.Accepted, db); } } }
//Wip Persist internal static void WriteUnpegHistory(Wip item, string reason, FabStep mainStep) { Outputs.UnpegHistory hist = new Outputs.UnpegHistory(); hist.VERSION_NO = ModelContext.Current.VersionNo; hist.FACTORY_ID = item.FACTORY_ID; hist.AREA_ID = Constants.NULL_ID; hist.SHOP_ID = item.SHOP_ID; hist.LOT_ID = item.LOT_ID; hist.UNPEG_REASON = reason; hist.REMAIN_QTY = item.GLASS_QTY; hist.PRODUCT_ID = item.PRODUCT_ID; hist.PRODUCT_VERSION = item.PRODUCT_VERSION; hist.PROCESS_ID = item.PROCESS_ID; hist.STEP_ID = item.STEP_ID; if (mainStep != null) { hist.PROCESS_ID = mainStep.ProcessID; hist.STEP_ID = mainStep.StepID; } hist.LOT_QTY = item.PANEL_QTY; hist.HOLD_CODE = item.HOLD_CODE; hist.LOT_STATUS = item.LOT_STATUS; hist.OWNER_TYPE = item.OWNER_TYPE; hist.WIP_PROCESS_ID = item.PROCESS_ID; hist.WIP_STEP_ID = item.STEP_ID; hist.WIP_STATE = item.LOT_STATUS; OutputMart.Instance.UnpegHistory.Add(hist); }
/// <summary> /// </summary> /// <param name="entity"/> /// <returns/> public bool OnAfterLoad_Wip(Wip entity) { MicronBETestProduct product = FindHelper.FindProduct(entity.PRODUCT_ID); if (product == null) { return(false); } MicronBETestProcess process = FindHelper.FindProcess(entity.PROCESS_ID); if (process == null) { return(false); } MicronBETestWipInfo wipInfo = new MicronBETestWipInfo(); wipInfo.LotID = entity.LOT_ID; wipInfo.LineID = entity.LINE_ID; wipInfo.Product = product; wipInfo.Process = process; wipInfo.UnitQty = Convert.ToDouble(entity.LOT_QTY); wipInfo.InitialStep = process.FindStep(entity.STEP_ID); wipInfo.CurrentState = FindHelper.FindLotState(entity.LOT_STATE); InputMart.Instance.MicronBETestWipInfo.Add(wipInfo.InitialStep.StepID, wipInfo); return(false); }
public Wip BuscarPallet_Wip(string Codigo) { Wip wip = new Wip(); Conexion con = new Conexion(); SqlCommand cmd = con.AbrirConexionIntranet(); if (cmd != null) { cmd.CommandText = "Wip_BuscarPallet"; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Codigo", Codigo); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { wip.ID_Control = reader["ID_Control"].ToString(); wip.NombreOT = reader["NombreOT"].ToString(); wip.OT = reader["OT"].ToString(); wip.Ubicacion = reader["Ubicacion"].ToString(); wip.Posicion = reader["Posicion"].ToString(); wip.PesoPallet = Convert.ToDouble(reader["Peso_Pallet"].ToString()); wip.PliegosImpresos = Convert.ToInt32(reader["Pliegos_Impresos"].ToString()); wip.EstadoPallet = Convert.ToInt32(reader["Estado_Pallet"].ToString()); wip.Tiraje = Convert.ToInt32(reader["Total_Tiraje"].ToString()); wip.Pliego = reader["Pliego"].ToString(); wip.Maquina = reader["Maquina_Origen"].ToString(); wip.ProxProceso = reader["Prox_Proceso"].ToString(); } } return(wip); }
private void insertNewLine(double x, double y, long time) { List <Point> line = new List <Point>(); line.Add(new Point(x, y)); Wip w = new Wip(line, time); curves.Enqueue(w); }
private void completeLine(Wip w, double x, double y, long time) { // TODO: move w at the top of the window if handling drawing several lines at the same time Point lastPoint = w.lastPoint(); // --- check that this is not the same point as the previous one if (lastPoint.x == x && lastPoint.y == y) { lastPoint.IncreaseSize(); return; } // --- check that X coordinate is not a change of direction if (w.direction == NO_DIRECTION) { if (x > lastPoint.x) { w.direction = LEFT_TO_RIGHT; } else { w.direction = RIGHT_TO_LEFT; } } else if ((w.direction == LEFT_TO_RIGHT && x < lastPoint.x) || (w.direction == RIGHT_TO_LEFT && x > lastPoint.x)) { // if change of direction, begin a new line insertNewLine(x, y, time); return; } // add the new point ... // --- if the three last points are aligned: remove the current last point before adding the new one Point lastBoPoint = w.lastBoPoint(); double coef1 = (double)(y - lastBoPoint.y) / (double)(x - lastBoPoint.x); double coef2 = (double)(lastPoint.y - lastBoPoint.y) / (double)(lastPoint.x - lastBoPoint.x); if (Math.Abs(1 - coef1 / coef2) < 0.05) { w.line.Remove(lastPoint); } Point newPoint = new Point(x, y); if (w.direction == LEFT_TO_RIGHT || w.direction == NO_DIRECTION) { w.line.Add(newPoint); } else { w.line.Insert(0, newPoint); } }
private bool IsUnpredictWip(Wip item) { string shopID = item.SHOP_ID; ICollection <UnpredictWip> stepList; if (InputMart.Instance.UnpredictWips.TryGetValue(UnpredictType.STEP, out stepList)) { if (IsMatched_UnpredictWip(stepList, shopID, item.STEP_ID)) { return(true); } } ICollection <UnpredictWip> lotList; if (InputMart.Instance.UnpredictWips.TryGetValue(UnpredictType.LOT, out lotList)) { if (IsMatched_UnpredictWip(lotList, shopID, item.LOT_ID)) { return(true); } } ICollection <UnpredictWip> cstList; if (InputMart.Instance.UnpredictWips.TryGetValue(UnpredictType.CASSETTE, out cstList)) { if (IsMatched_UnpredictWip(cstList, shopID, item.BATCH_ID)) { return(true); } } ICollection <UnpredictWip> ownerIDList; if (InputMart.Instance.UnpredictWips.TryGetValue(UnpredictType.OWNER_ID, out ownerIDList)) { if (IsMatched_UnpredictWip(ownerIDList, shopID, item.OWNER_ID)) { return(true); } } return(false); }
internal static void WriteLoadWipError(string key, Wip item, ErrLevel errLevel, string reason, string detail) { key = string.Format("Load Wip:{0}", key); WriteIf(key, ErrCategory.PERSIST, errLevel, item.FACTORY_ID, item.SHOP_ID, item.LOT_ID, item.PRODUCT_ID, item.PRODUCT_VERSION, item.PROCESS_ID, item.EQP_ID, item.STEP_ID, reason, detail); }
protected void txtCodigo_TextChanged(object sender, EventArgs e) { string codigo = txtCodigo.Text; Wip wip = wipControl.BuscarWip_ControlPorCodigo(codigo, "Pistola", Session["Usuario"].ToString()); if (wip.ProxProceso != null) { lblOT.Text = wip.OT; lblNombreOT.Text = wip.NombreOT; btnGuardar.Visible = true; pnlDetalle.Visible = true; DivMensaje.Visible = false; } else { DivMensaje.Visible = true; DivMensaje.Attributes.Add("style", "background-color:Red"); Image1.ImageUrl = "../../Images/cross.png"; lblMensaje.ForeColor = Color.White; lblMensaje.Text = "Codigo de Pallet Incorrecto."; } }
public Wip ListaMaquinaENC(string Codigo, int Procedimiento) { Wip wp = new Wip(); Conexion con = new Conexion(); SqlCommand cmd = con.AbrirConexionIntranet(); if (cmd != null) { cmd.CommandText = "[Wip_ListMaquina_LecturaMetrics]"; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Codigo", Codigo); cmd.Parameters.AddWithValue("@Procedimiento", Procedimiento); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { wp.Maquina = reader["NombreMaquina"].ToString(); wp.ID_Control = reader["CodigoMaquina"].ToString(); } con.CerrarConexion(); } return(wp); }
public void AddMatchWip(Wip wip) { this.MatchWips.Add(wip); }
/// <summary> /// </summary> /// <param name="entity"/> /// <returns/> public bool OnAfterLoad_Wip(Wip entity) { try { entity.LOT_ID = UtilityHelper.Trim(entity.LOT_ID); entity.LINE_ID = UtilityHelper.Trim(entity.LINE_ID); entity.STEP_ID = UtilityHelper.Trim(entity.STEP_ID); entity.PROCESS_ID = UtilityHelper.Trim(entity.PROCESS_ID); entity.PRODUCT_ID = UtilityHelper.Trim(entity.PRODUCT_ID); entity.PRODUCT_NAME = UtilityHelper.Trim(entity.PRODUCT_NAME); entity.HOLD_CODE = UtilityHelper.Trim(entity.HOLD_CODE); entity.LOT_STATE = UtilityHelper.Trim(entity.LOT_STATE); entity.EQP_ID = UtilityHelper.Trim(entity.EQP_ID); entity.ASM_RESERVATION_ID = UtilityHelper.Trim(entity.ASM_RESERVATION_ID); #if DEBUG if (entity.LOT_ID.StartsWith("BF8QK4N.5X")) { Console.WriteLine(); } if (entity.PRODUCT_ID == "BF8QK4N.5X") { Console.WriteLine(); } #endif ProductDetail productDetail = FindHelper.FindProductDetail(entity.LINE_ID, entity.PRODUCT_ID); Mozart.SeePlan.Simulation.EntityState state = FindHelper.FindLotState(entity.LOT_STATE, entity.HOLD_CODE, entity.EQP_ID); if (productDetail == null) { WriteHelper.WriteMasterDataErrorLog(MasterDataErrorEventType.WIP, entity.LINE_ID, entity.STEP_ID, entity.LOT_ID, entity.PRODUCT_ID, string.Empty, string.Empty, entity.LOT_QTY, string.Empty, "Cannot find ProductMaster", string.Empty, "Wip"); WriteHelper.WriteUnpeg(entity, string.Empty, false, state, UnpegReason.MASTER_DATA, "Cannot find ProductMaster"); return(false); } MicronBEAssyProcess process = productDetail.Process; MicronBEAssyBEStep step = process.FindStep(entity.STEP_ID) as MicronBEAssyBEStep; if (step == null) { WriteHelper.WriteMasterDataErrorLog(MasterDataErrorEventType.WIP, entity.LINE_ID, entity.STEP_ID, entity.LOT_ID, entity.PRODUCT_ID, productDetail.DesignID, string.Empty, entity.LOT_QTY, string.Empty, "Cannot find ProcessStep", string.Format("PROCESS_ID : {0}", productDetail.Process.ProcessID), "Wip"); WriteHelper.WriteUnpeg(entity, productDetail.DesignID, false, state, UnpegReason.MASTER_DATA, "Cannot find ProcessStep"); return(false); } string unpegReason = string.Empty; Product product = FindHelper.FindWipProduct(entity, process, step, state, out unpegReason); if (product == null) { WriteHelper.WriteMasterDataErrorLog(MasterDataErrorEventType.WIP, entity.LINE_ID, entity.STEP_ID, entity.LOT_ID, entity.PRODUCT_ID, productDetail.DesignID, string.Empty, entity.LOT_QTY, string.Empty, "Cannot find ProcessStep", string.Format("PROCESS_ID : {0}", productDetail.Process.ProcessID), "Wip"); WriteHelper.WriteUnpeg(entity, productDetail.DesignID, false, state, UnpegReason.MASTER_DATA, unpegReason); return(false); } MicronBEAssyWipInfo wipInfo = new MicronBEAssyWipInfo(); wipInfo.LotID = entity.LOT_ID; wipInfo.Product = product; wipInfo.Process = process; wipInfo.UnitQty = (double)entity.LOT_QTY; wipInfo.InitialStep = process.FindStep(entity.STEP_ID); wipInfo.CurrentState = state; wipInfo.LineID = entity.LINE_ID; InputMart.Instance.MicronBEAssyWipInfo.Add(wipInfo.InitialStep.StepID, wipInfo); return(false); } catch (Exception e) { WriteHelper.WriteErrorHistory(ErrorLevel.FATAL, string.Format("ErrorMessage : {0} MethodName : {1}", e.Message, System.Reflection.MethodInfo.GetCurrentMethod().Name)); return(false); } }
internal static Product FindWipProduct(Wip entity, MicronBEAssyProcess process, MicronBEAssyBEStep step, Mozart.SeePlan.Simulation.EntityState state, out string unpegReason) { Product product = null; unpegReason = string.Empty; #if DEBUG if (entity.PRODUCT_ID == "264153") { Console.WriteLine(); } if (entity.PRODUCT_ID == "264157") { Console.WriteLine(); } #endif int daThroughtCnt = step.DaThroughCount; if (step.StepGroup == Constants.DieAttach && state != EntityState.RUN) { daThroughtCnt = daThroughtCnt - 1;//DA 대기중인 재공은 DA를 진행하지 않은 상태로 판단 } Product wipProduct = FindHelper.FindProduct(entity.LINE_ID, entity.PRODUCT_ID); if (wipProduct is MicronBEAssyProduct) { product = wipProduct; } else if (wipProduct != null && wipProduct is AssyMcpProduct && daThroughtCnt >= 1) { AssyMcpProduct mcpProduct = wipProduct as AssyMcpProduct; if (daThroughtCnt == mcpProduct.MaxSequence) { product = mcpProduct; } else { AssyMcpPart midPart = FindHelper.FindProduct(entity.LINE_ID, entity.PRODUCT_ID, true, true, daThroughtCnt) as AssyMcpPart; if (midPart != null) { product = midPart; } #if DEBUG if (midPart == null) { Console.WriteLine(); } #endif } } else { //임시로직 - 로직이 정해지먼 재정의 해야함. //초기화시 CompSeq가 확정된 Part를 찾을 수 없기 때문에 대표로 Part를 하나 찾아서 정의를 해야함. ICollection <AssyMcpPart> products = FindHelper.FindAssyInParts(entity.LINE_ID, entity.PRODUCT_ID); if (products != null && products.Count > 0) { product = products.ElementAt(0); } } if (product == null) { if (step.StepID == Constants.LOTSRECEIVED) { unpegReason = "Cannot find McpBom or ProductRoute"; } else { unpegReason = "Cannot find McpBom"; } } return(product); }
protected void btnGuardar_Click(object sender, EventArgs e) { ////******************************************************************CODIGO INICIAL ***************************************************************************** //string Codigo = txtCodigo.Text.Trim(); //string Ubicacion = txtUbicacion.Text.Trim().ToUpper(); //List<Wip> wp = wipControl.ListaMaquinaProceso(0); //string CodigosMachine = ","; //foreach (Wip w in wp) //{ // CodigosMachine = CodigosMachine + w.ID_Control + ","; //} ////Asignar ubicacion en Encuadernacion //int n = CodigosMachine.IndexOf(Ubicacion); //if (n > 0) //{ // if (wipControl.ConsumirPorEnc(Codigo, Ubicacion, lblNombre.Text)) // { // Response.Redirect("Asignar_Ubicacion.aspx?id=" + lblNombre.Text + "&tipo=" + lblTipo.Text); // } //} ////Asignar ubicacion en Servicio Externo //else if (Ubicacion == "SE002" || Ubicacion == "DSE01" || Ubicacion == "TD001" || Ubicacion == "DD003") //{ // string proceso = ""; // if (wipControl.ConsumirPorServicioExterno(Codigo, Ubicacion, lblNombre.Text, proceso)) // { // if (Ubicacion == "SE002") // { // proceso = "Sunipac"; // EnvioCorreo(Ubicacion, lblNombre.Text, Codigo, proceso); // } // else if (Ubicacion == "DSE01") // { // proceso = "Despacho Servicio Externo"; // EnvioCorreo(Ubicacion, lblNombre.Text, Codigo, proceso); // } // else if (Ubicacion == "TD001") // { // proceso = "Taller Digital"; // } // else if (Ubicacion == "DD003") // { // proceso = "Directo Despacho"; // } // Response.Redirect("Asignar_Ubicacion.aspx?id=" + lblNombre.Text + "&tipo=" + lblTipo.Text); // } //} ////Asignar Ubicacion en rack //else if (Ubicacion != "TD001" && Ubicacion != "ENC01" && Ubicacion != "SE002" && Ubicacion != "DSE01") //{ // List<Wip> wp2 = wipControl.ListaMaquinaProceso(1); // if (wp2.Count(o => o.Maquina == Ubicacion) > 0) // { // if (wipControl.AsignarUbicacionPallet(Codigo, Ubicacion, lblNombre.Text)) // { // Response.Redirect("Asignar_Ubicacion.aspx?id=" + lblNombre.Text + "&tipo=" + lblTipo.Text); // } // } //} try { string Codigo = txtCodigo.Text.Trim(); string Ubicacion = txtUbicacion.Text.Trim().ToUpper(); string CodigoMetrics = ""; CodigoMetrics = wlm.ListaMaquinaProceso(Ubicacion, 1); if (CodigoMetrics != "0" && CodigoMetrics != "UNICO") { //Asignar Ubicacion en rack if (CodigoMetrics != "TD001" && CodigoMetrics != "ENC01" && CodigoMetrics != "SE002" && CodigoMetrics != "DSE01") { if (wipControl.AsignarUbicacionPallet(Codigo, CodigoMetrics, lblNombre.Text)) { Response.Redirect("Asignar_Ubicacion.aspx?id=" + lblNombre.Text + "&tipo=" + lblTipo.Text); } } } //Asignar ubicacion en Servicio Externo else if (Ubicacion == "SE002" || Ubicacion == "DSE01" || Ubicacion == "TD001" || Ubicacion == "DD003") { string proceso = ""; if (wipControl.ConsumirPorServicioExterno(Codigo, Ubicacion, lblNombre.Text, proceso)) { if (Ubicacion == "SE002") { proceso = "Sunipac"; EnvioCorreo(Ubicacion, lblNombre.Text, Codigo, proceso); } else if (Ubicacion == "DSE01") { proceso = "Despacho Servicio Externo"; EnvioCorreo(Ubicacion, lblNombre.Text, Codigo, proceso); } else if (Ubicacion == "TD001") { proceso = "Taller Digital"; } else if (Ubicacion == "DD003") { proceso = "Directo Despacho"; } Response.Redirect("Asignar_Ubicacion.aspx?id=" + lblNombre.Text + "&tipo=" + lblTipo.Text); } } //Ubicacion Maquinas ENC else { Wip w2 = wlm.ListaMaquinaENC(Ubicacion, 2); if (w2 != null) { if (wipControl.ConsumirPorEnc(Codigo, w2.ID_Control, lblNombre.Text)) { Response.Redirect("Asignar_Ubicacion.aspx?id=" + lblNombre.Text + "&tipo=" + lblTipo.Text); } } } } catch (Exception ex) { string popupScript = "<script language='JavaScript'> alert('" + ex.ToString() + "');' </script>"; Page.RegisterStartupScript("PopupScript", popupScript); } }
public bool EnvioCorreo(string Destino, string Usuario, string Codigo, string Proceso) { if (Destino == "SE002") { Destino = "Sunipac"; } else if (Destino == "DSE01") { Destino = "Despacho Servico Externo"; } /* Carga de PAra la base de Datos*/ /*-------------------------MENSAJE DE CORREO----------------------*/ Wip wip = wipControl.BuscarPallet_Wip(Codigo); //Creamos un nuevo Objeto de mensaje System.Net.Mail.MailMessage mmsg = new System.Net.Mail.MailMessage(); //Direccion de correo electronico a la que queremos enviar el mensaje //mmsg.To.Add("*****@*****.**"); if (Destino == "Sunipac") { mmsg.To.Add("*****@*****.**"); } else if (Destino == "Despacho Servico Externo") { mmsg.To.Add("*****@*****.**"); } //mmsg.To.Add("*****@*****.**"); //Nota: La propiedad To es una colección que permite enviar el mensaje a más de un destinatario //Asunto mmsg.Subject = "Destino " + Destino + " OT: " + wip.OT + " Pliego: " + wip.Pliego; mmsg.SubjectEncoding = System.Text.Encoding.UTF8; //Direccion de correo electronico que queremos que reciba una copia del mensaje //mmsg.Bcc.Add("*****@*****.**"); //Opcional DateTime hoy = DateTime.Now; string fecha = hoy.ToString("dd/MM/yyyy HH:mm"); string[] str = fecha.Split('/'); string dia = str[0]; string mes = str[1]; string año = str[2]; //año = año.Substring(0, 4); //string hora = hoy.ToLongTimeString(); //Cuerpo del Mensaje mmsg.Body = "<table style='width:80%;'>" + "<tr>" + "<td>" + "<img src='http://intranet.qgchile.cl/images/Logo color lateral.jpg' width='267px' height='67px' />" + //"<img src='//"<img src='http://www.qg.com/la/es/images/QG_Tagline_sp.jpg' />" +' />" + " </td>" + "</tr>" + "</table>" + //termino cargar logo "<div style='border-color:Black;border-width:3px;border-style:solid;'>" + "<table style='width:80%;'>" + "<tr>" + "<td style='width:194px;'>" + " </td>" + "<td colspan='3'>" + " </td>" + "</tr>" + "<tr>" + "<td style='width:194px;'>" + "OT Nro.: </td>" + "<td>" + wip.OT.ToUpper() + "</td>" + "<td style='width:194px;'>" + "Nombre OT: </td>" + "<td>" + wip.NombreOT + "</td>" + "</tr>" + "<tr>" + "<td style='width:194px;'>" + " Tiraje OT:</td>" + "<td colspan='3'>" + wip.Tiraje.ToString("N0").Replace(",", ".") + "</td>" + "</tr>" + "<tr>" + "<td style='width:194px;'>" + " Fecha:</td>" + "<td colspan='3'>" + dia + "/" + mes + "/" + año + "</td>" + "</tr>" + "<tr>" + "<td style='width:194px;'>" + "Creador Por:</td>" + "<td colspan='3'>" + Usuario + "</td>" + "</tr>" + "</table>" + "<br />" + "</div>" + "<table style='width:80%;'><tr>" + "<td style='border:1px solid #5D8CC9;background:#5D8CC9;' align='center'>Proveedor</td>" + "<td style='border:1px solid #5D8CC9;background:#5D8CC9;' align='center'>Codigo Pallet</td>" + "<td style='border:1px solid #5D8CC9;background:#5D8CC9;' align='center'>Pliego</td>" + "<td style='border:1px solid #5D8CC9;background:#5D8CC9;' align='center'>Pliego Imp.</td>" + "<td style='border:1px solid #5D8CC9;background:#5D8CC9;' align='center'>Maquina</td>" + "<td style='border:1px solid #5D8CC9;background:#5D8CC9;' align='center'>Proceso</td>" + "<td style='border:1px solid #5D8CC9;background:#5D8CC9;' align='center'>Peso Pallet</td>" + "</tr>" + "<tr>" + "<td style='border:1px solid #5D8CC9;'>" + Destino + "</td>" + "<td style='border:1px solid #5D8CC9;'>" + Codigo + "</td>" + "<td style='border:1px solid #5D8CC9;'>" + wip.Pliego + "</td>" + "<td style='border:1px solid #5D8CC9;' align='right'>" + wip.PliegosImpresos.ToString("N0").Replace(",", ".") + "</td>" + "<td style='border:1px solid #5D8CC9;'>" + wip.Maquina + "</td>" + "<td style='border:1px solid #5D8CC9;'>" + Proceso + "</td>" + "<td style='border:1px solid #5D8CC9;'>" + wip.PesoPallet + "</td>" + "</tr></table>"; mmsg.BodyEncoding = System.Text.Encoding.UTF8; mmsg.IsBodyHtml = true; //Si no queremos que se envíe como HTML //Correo electronico desde la que enviamos el mensaje mmsg.From = new System.Net.Mail.MailAddress("*****@*****.**");//"*****@*****.**"); /*-------------------------CLIENTE DE CORREO----------------------*/ //Creamos un objeto de cliente de correo System.Net.Mail.SmtpClient cliente = new System.Net.Mail.SmtpClient(); //Hay que crear las credenciales del correo emisor cliente.Credentials = new System.Net.NetworkCredential("*****@*****.**", "SI2013."); //Lo siguiente es obligatorio si enviamos el mensaje desde Gmail /* * cliente.Port = 587; * cliente.EnableSsl = true; */ cliente.Host = "mail.aimpresores.cl"; /*-------------------------ENVIO DE CORREO----------------------*/ try { //Enviamos el mensaje cliente.Send(mmsg); return(true); //Label1.Text = "enviado correctamente"; } catch (System.Net.Mail.SmtpException ex) { return(false); //Aquí gestionamos los errores al intentar enviar el correo //Label1.Text = "error al enviar el correo"; } }
private string CheckMainProcessID(string factoryID, string shopID, string productID, string stepID, Wip wip, string where, ref bool hasError) { var proc = BopHelper.FindProcess2(productID, stepID); if (proc == null) { hasError = true; ErrHist.WriteIf(where + proc, ErrCategory.PERSIST, ErrLevel.WARNING, factoryID, shopID, Constants.NULL_ID, productID, Constants.NULL_ID, Constants.NULL_ID, Constants.NULL_ID, stepID, "NOT FOUND MAIN_PROCESS", string.Format("Table:{0}", where) ); return(null); } return(proc.ProcessID); }