public static void insertInContainerDataBase(string pn, string contenedor, int qty, string tipo, string modelo, string lote, char reimpresion) { if (ConexionCogiscanUtilities.State == ConnectionState.Closed) { ConexionCogiscanUtilities.Open(); } string[] usuario = HostAndUser.host(); using (MySqlCommand cmdInsertIRM = ConexionCogiscanUtilities.CreateCommand()) { cmdInsertIRM.CommandType = CommandType.StoredProcedure; cmdInsertIRM.CommandText = "spInsertNewContainer"; cmdInsertIRM.Parameters.AddWithValue("_pn", pn); cmdInsertIRM.Parameters.AddWithValue("_contenedor", contenedor); cmdInsertIRM.Parameters.AddWithValue("_qty", qty); cmdInsertIRM.Parameters.AddWithValue("_barcode", Global.barcode); cmdInsertIRM.Parameters.AddWithValue("_host", usuario[0]); cmdInsertIRM.Parameters.AddWithValue("_usuario", Global.userLogged); cmdInsertIRM.Parameters.AddWithValue("_tipo", tipo); cmdInsertIRM.Parameters.AddWithValue("_modelo", modelo); cmdInsertIRM.Parameters.AddWithValue("_lote", lote); cmdInsertIRM.Parameters.AddWithValue("_reimpresion", reimpresion); cmdInsertIRM.ExecuteNonQuery(); } ConexionCogiscanUtilities.Close(); }
public static void insertInSplitDataBase(string contenedorInicial, int qty, string contenedorNuevo) { if (ConexionCogiscanUtilities.State == ConnectionState.Closed) { ConexionCogiscanUtilities.Open(); } string[] usuario = HostAndUser.host(); using (MySqlCommand cmdInsertSplit = ConexionCogiscanUtilities.CreateCommand()) { cmdInsertSplit.CommandText = "spInsertSplitMaterial"; cmdInsertSplit.CommandType = CommandType.StoredProcedure; cmdInsertSplit.Parameters.AddWithValue("_contenedor_inicial", contenedorInicial); cmdInsertSplit.Parameters.AddWithValue("_qty_division", qty); cmdInsertSplit.Parameters.AddWithValue("_contenedor_nuevo", contenedorNuevo); cmdInsertSplit.Parameters.AddWithValue("_host", usuario[0]); cmdInsertSplit.Parameters.AddWithValue("_usuario", Global.userLogged); cmdInsertSplit.ExecuteNonQuery(); } ConexionCogiscanUtilities.Close(); }
public static void insertHearthBreath() { //Obtengo los datos del cliente string[] hostInfo = HostAndUser.host(); if (ConexionCogiscanUtilities.State == ConnectionState.Closed) { ConexionCogiscanUtilities.Open(); } using (MySqlCommand cmdInsertError = ConexionCogiscanUtilities.CreateCommand()) { cmdInsertError.CommandText = "spUpdHearthBreath"; cmdInsertError.CommandType = CommandType.StoredProcedure; cmdInsertError.Parameters.AddWithValue("_hostname", hostInfo[0]); cmdInsertError.Parameters.AddWithValue("_ip_address", hostInfo[2]); cmdInsertError.ExecuteNonQuery(); } if (ConexionCogiscanUtilities.State == ConnectionState.Open) { ConexionCogiscanUtilities.Close(); } }
private void Form1_Load(object sender, EventArgs e) { HostAndUser.host(); Global.chkUserLogged();//chequeo si hay algun usuario logueado lblresultado.Text = ""; lblResultSplit.Text = ""; lblPNSplit.Text = ""; lblQtySplit.Text = ""; //WS.queryTooling(); List <string> dataSource = new List <string>(); dataSource = Conexion.queryModelos(); cbModeloGC.DataSource = dataSource; cbModeloSM.DataSource = dataSource; cbTipoCG.SelectedIndex = 0;// por defecto selecciono el tipo REEL //****LOAD TAB****// lblSelectedContainer.Text = ""; lblSelectedLocation.Text = ""; lblStatusLoad.Text = ""; btnDelete.Enabled = false; btnDeleteAll.Enabled = false; //////////////////// string partNumber = "T2SC3332-S--"; string partNumberToRead = ""; if (partNumber.Contains("-")) { string[] splitted = partNumber.Split('-'); for (int i = 0; i < splitted.Length; i++) { if (i < (splitted.Length - 1)) { if (splitted[i] == "") { if (splitted[i - 1] == "") { partNumberToRead = partNumberToRead + "-"; } else { partNumberToRead = partNumberToRead + "-"; } } else { if (Char.IsLetter(splitted[i], splitted[i].Length - 1)) { partNumberToRead = partNumberToRead + splitted[i] + "->5"; } else if (Char.IsNumber(splitted[i], splitted[i].Length - 1)) { partNumberToRead = partNumberToRead + splitted[i] + ">6->5"; } } } else { partNumberToRead = partNumberToRead + splitted[i]; } } partNumberToRead = ""; //Este es para el caso "Letra - Nro - Letra/Nro" string pattern = @"(?'letra'[A-Z]\-)(?'centro'\w+)(?'digito'\d)(\-)"; string replacement = "${letra}>5${centro}${digito}>6->5"; Regex rgx = new Regex(pattern); partNumberToRead = rgx.Replace(partNumberToRead, replacement); } }