public string Desbloqueo(string linea, string contrasena)
{
string correcto = "0";
var usuarios = db.t_boxingscan_pass.ToList();
foreach (var usuario in usuarios)
{
if (contrasena == usuario.contrasena)
{
correcto = "1";
int ultimobloqueo = 0;
try
{
ultimobloqueo = db.t_boxingscan_cambiowo.OrderByDescending(x => x.folio).ToList().First().folio;
}
catch
{
ultimobloqueo = 0;
}
t_boxingscan_cambiowo newboxingscan_cambiowo = new t_boxingscan_cambiowo();
newboxingscan_cambiowo.folio = ultimobloqueo + 1;
newboxingscan_cambiowo.fecha = System.DateTime.Now;
newboxingscan_cambiowo.bloqueo = 0;
newboxingscan_cambiowo.linea = linea;
newboxingscan_cambiowo.usuario = usuario.usuario;
db.t_boxingscan_cambiowo.Add(newboxingscan_cambiowo);
db.SaveChanges();
break;
}
}
return(correcto);
}
public void Bloqueo(string linea, string lote_anterior, string lote_nuevo)
{
string wo_anterior = "-", wo_nueva = "-";
#region as400
OdbcConnection myCon = new OdbcConnection();
string sConnection = "Driver=iSeries Access ODBC Driver;System=AS400SYS;uid=inqmex;pwd=inqmex;";
myCon.ConnectionString = sConnection;
try
{
myCon.Open();
Console.WriteLine("Connection successful!");
string sQuery = "SELECT FCSTRHDR.SHWONO WO, FCSTRHDR.SHLOT LOT, FCSTRHDR.SHSPN PN, FCSTRHDR.SHSQTY CASES, FKITMSTR.IMSTCK KPC FROM B20E386T.CSM400MFG.FCSTRHDR FCSTRHDR INNER JOIN B20E386T.KBM400MFG.FKITMSTR FKITMSTR ON FCSTRHDR.SHSPN = FKITMSTR.IMPN AND FCSTRHDR.SHSCO = FKITMSTR.IMCO WHERE(FCSTRHDR.SHLOT = '" + lote_anterior + "' AND FCSTRHDR.SHSCO = '686')";
string sQuery2 = "SELECT FCSTRHDR.SHWONO WO, FCSTRHDR.SHLOT LOT, FCSTRHDR.SHSPN PN, FCSTRHDR.SHSQTY CASES, FKITMSTR.IMSTCK KPC FROM B20E386T.CSM400MFG.FCSTRHDR FCSTRHDR INNER JOIN B20E386T.KBM400MFG.FKITMSTR FKITMSTR ON FCSTRHDR.SHSPN = FKITMSTR.IMPN AND FCSTRHDR.SHSCO = FKITMSTR.IMCO WHERE(FCSTRHDR.SHLOT = '" + lote_nuevo + "' AND FCSTRHDR.SHSCO = '686')";
OdbcCommand myCom = new OdbcCommand(sQuery, myCon);
OdbcDataReader myReader;
myReader = myCom.ExecuteReader();
while (myReader.Read())
{
wo_anterior = myReader[0].ToString();
//Console.WriteLine(myReader[0].ToString() + myReader[1].ToString() + myReader[2].ToString() + " " + myReader[3].ToString());
}
OdbcCommand myCom2 = new OdbcCommand(sQuery2, myCon);
OdbcDataReader myReader2;
myReader2 = myCom2.ExecuteReader();
while (myReader2.Read())
{
wo_nueva = myReader2[0].ToString();
//Console.WriteLine(myReader[0].ToString() + myReader[1].ToString() + myReader[2].ToString() + " " + myReader[3].ToString());
}
}
catch
{
wo_anterior = "-";
wo_nueva = "-";
}
myCon.Close();
#endregion
int ultimobloqueo = 0;
try
{
ultimobloqueo = db.t_boxingscan_cambiowo.OrderByDescending(x => x.folio).ToList().First().folio;
}
catch
{
ultimobloqueo = 0;
}
t_boxingscan_cambiowo newboxingscan_cambiowo = new t_boxingscan_cambiowo();
newboxingscan_cambiowo.folio = ultimobloqueo + 1;
newboxingscan_cambiowo.fecha = System.DateTime.Now;
newboxingscan_cambiowo.bloqueo = 1;
newboxingscan_cambiowo.linea = linea;
newboxingscan_cambiowo.wo_anterior = wo_anterior.Replace(" ", String.Empty);
newboxingscan_cambiowo.wo_nueva = wo_nueva.Replace(" ", String.Empty);
db.t_boxingscan_cambiowo.Add(newboxingscan_cambiowo);
db.SaveChanges();
}
