public static DataTable ConsultarWO(SetupLogica set)
{
DataTable datos = new DataTable();
try
{
string sSql = "SELECT Product_Name as product,Product_Description AS name,Original_Work_Order_Quantity AS box,Product_Kits_per_Case AS kits," +
"In_Kits_Work_Order_Quantity total_kits, ((" + set.Takt + " * In_Kits_Work_Order_Quantity) / 60)/60 as duration,'' as boxhr,'' as duration_min " +
"FROM Work_Order_Details where Work_Order_Number = '" + set.WorkOrder + "'"; //Company_Number = 686 and
datos = AccesoDatos.ConsultarSetup(sSql);
}
catch (Exception ex)
{
throw ex;
}
return(datos);
}
public static int EjecutaSP(SetupLogica config)
{
//string[] parametros = { "@Jornada", "@HrsDisp", "@SegDisp", "@CajasLinea", "@KitsCaja", "@KitsLinea", "@TakTime", "@Tak80", "@AssyTime", "@MaxComp", "@MesaEns", "@MesaWrap", "@MesaSub", "@OperNA", "@Surtidor", "@InspSella", "@Sellador", "@Inspeccion", "@Usuario", "@Horiz", "@Vertical", "@Sobre", "@TuckTape", "@WrapNA" };
//return AccesoDatos.Actualizar("sp_mant_config", parametros, config.Jornada, config.HorasDisp, config.SegDisp, config.Cajas, config.Kits, config.KitLinea, config.Tak, config.Tak80,config.Assy, config.MaxComp, config.Mesas, config.MesaWrap, config.MesaSub, config.OperNA, config.Surtidor, config.InspSella, config.Selladora, config.Inspeccion, config.Usuario,config.Horizontal,config.Vertical,config.Sobre,config.Tape,config.WrapNA);
return(0);
}
