public static DataTable BinContentLinea(BincontentCPROLogica bin)
{
DataTable datos = new DataTable();
try
{
datos = AccesoDatos.ConsultarPRO("select folio,item,cantidad,contador,diferencia from t_bincont where planta = '" + bin.Planta + "' and bincode = '" + bin.BinCode + "' and hora = '" + bin.Hora + "' and cast(fecha as date) = cast('" + bin.Fecha + "' as date) order by 1");
}
catch (Exception ex)
{
throw ex;
}
return(datos);
}
public static DataTable ConsultarLinea(BincontentCPROLogica bin)
{
DataTable datos = new DataTable();
try
{
datos = AccesoDatos.ConsultarPRO("select distinct bincode from t_bincont where planta = '" + bin.Planta + "' and hora = '" + bin.Hora + "' and cast(fecha as date) = cast('" + bin.Fecha + "' as date) order by 1");
}
catch (Exception ex)
{
throw ex;
}
return(datos);
}
public static bool Verificar(BincontentCPROLogica bin)
{
try
{
string sQuery;
sQuery = "SELECT * FROM t_bincont where planta = '" + bin.Planta + "' and hora = '" + bin.Hora + "' and cast(fecha as date) = cast('" + bin.Fecha + "' as date) ";
DataTable datos = AccesoDatos.ConsultarPRO(sQuery);
if (datos.Rows.Count != 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
public static bool GuardaContador(BincontentCPROLogica bin)
{
try
{
DateTime dt = DateTime.Now;
string sQuery = string.Empty;
sQuery = "UPDATE t_bincont SET contador = " + bin.Contador + ", diferencia = " + bin.Diferencia + " WHERE folio = " + bin.Folio + " ";
if (AccesoDatos.UpdatePRO(sQuery) != 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
public static int Guardar(BincontentCPROLogica bin)
{
string[] parametros = { "@Hora", "@Planta", "@Bincode", "@Item", "@Descrip", "@UM", "@Cantidad" };
return(AccesoDatos.ActualizarPRO("sp_mant_bincont", parametros, bin.Hora, bin.Planta, bin.BinCode, bin.Item, bin.Descrip, bin.UM, bin.Cantidad));
}
