public static DataTable ConsultarHorario(LineaConfigHrLogica cve)
{
DataTable datos = new DataTable();
try
{
datos = AccesoDatos.Consultar("SELECT * FROM t_lineconfh WHERE clave = '" + cve.Clave + "' and hora = '" + cve.Horario + "'");
}
catch (Exception ex)
{
throw ex;
}
return(datos);
}
public static DataTable ConsultarVistaHorario(LineaConfigHrLogica cve)
{
DataTable datos = new DataTable();
try
{
datos = AccesoDatos.Consultar("SELECT consec,hora as Horario,meta as Meta,meta_ac as [Meta Acumulada] FROM t_lineconfh WHERE clave = '" + cve.Clave + "' order by hora");
}
catch (Exception ex)
{
throw ex;
}
return(datos);
}
public static int Eliminar(LineaConfigHrLogica cve)
{
int iRes = 0;
try
{
iRes = AccesoDatos.Borrar("DELETE FROM t_lineconfh WHERE clave = " + cve.Clave + " and consec = " + cve.Consec + "");
}
catch (Exception ex)
{
throw ex;
}
return(iRes);
}
public static DataTable VistaHorarioLinea(LineaConfigHrLogica cve)
{
DataTable datos = new DataTable();
try
{
datos = AccesoDatos.Consultar("SELECT 0 as consec, hora as Hora,meta as Meta,meta_ac as [Meta Acum],0 as Actual,0 as [Actual Acu],0 as Defectos,'' as [Work Order],'' as Comentarios,'1' as cumple_meta FROM t_lineconfh WHERE clave = '" + cve.Clave + "' ");
}
catch (Exception ex)
{
throw ex;
}
return(datos);
}
public static int GuardarSP(LineaConfigHrLogica cve)
{
string[] parametros = { "@Clave", "@Consec", "@Hora", "@Meta", "@MetaAc" };
return(AccesoDatos.Actualizar("sp_mant_lineconfh", parametros, cve.Clave, cve.Consec, cve.Horario, cve.Meta, cve.MetaAc));
}
