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)); }