public static DataTable Consultar(MetadetLogica met)
{
DataTable datos = new DataTable();
try
{
datos = AccesoDatos.Consultar("SELECT * FROM t_metadet WHERE folio = " + met.Folio + "");
}
catch (Exception ex)
{
throw ex;
}
return(datos);
}
public static DataTable Listar(MetadetLogica met)
{
DataTable datos = new DataTable();
try
{
datos = AccesoDatos.Consultar("SELECT * from t_metadet");
}
catch (Exception ex)
{
throw ex;
}
return(datos);
}
public static DataTable VistaIndividual(MetadetLogica met)
{
DataTable datos = new DataTable();
try
{
string sSql = "SELECT meta,sum(real) as real FROM t_metadet md WHERE folio = " + met.Folio + " and linea='" + met.Linea + "' GROUP BY meta";
datos = AccesoDatos.Consultar(sSql);
}
catch (Exception ex)
{
throw ex;
}
return(datos);
}
public static DataTable ConsultarNoti(MetadetLogica met)
{
DataTable datos = new DataTable();
try
{
string sSql = "SELECT md.folio,md.consec, mt.hora, md.meta,md.real FROM t_metadet md inner join t_metadia mt on md.folio = mt.folio " +
"WHERE md.planta = '" + met.Planta + "' and md.linea = '" + met.Linea + "' and cast(mt.fecha as date) = cast(getdate() as date) and md.ind_noti = '0'";
datos = AccesoDatos.Consultar(sSql);
}
catch (Exception ex)
{
throw ex;
}
return(datos);
}
public static DataTable VistaGrafica(MetadetLogica met)
{
DataTable datos = new DataTable();
try
{
string sSql = "SELECT md.linea,md.meta,SUM(md.real) FROM t_metadet md INNER JOIN t_lineas li on md.linea = li.linea ";
sSql += "WHERE md.folio = " + met.Folio + " and('" + met.Global + "' = '1' or('" + met.Global + "' = '0' and li.area = '" + met.Area + "')) GROUP BY md.linea,md.meta ORDER BY md.linea";
datos = AccesoDatos.Consultar(sSql);
}
catch (Exception ex)
{
throw ex;
}
return(datos);
}
public static bool Verificar(MetadetLogica met)
{
try
{
string sQuery;
sQuery = "SELECT * FROM t_metadet WHERE folio = " + met.Folio + " and consec = " + met.Consec + "";
DataTable datos = AccesoDatos.Consultar(sQuery);
if (datos.Rows.Count != 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
public static int Guardar(MetadetLogica met)
{
string[] parametros = { "@Folio", "@Consec", "@Usuario", "@Planta", "@Linea", "@Meta", "@Real", "@Porcentaje" };
return(AccesoDatos.Actualizar("sp_mant_metadet", parametros, met.Folio, met.Consec, met.Usuario, met.Planta, met.Linea, met.Meta, met.Real, met.Porcen));
}