public static DataSet BuscarDepFisicos(string Fecha)
{
string Sentencia = "SELECT * FROM PortalGene.DepositoFisico ";
Sentencia += "WHERE (Fecha = '" + Fecha + "') ";
Sentencia += "ORDER BY NumeroDep";
return(AyudanteMySQL.EjecutarDataSet(ConfigurationSettings.AppSettings["PortalGene"], Sentencia));
}
public static DataSet BuscarAnalisis(string Busqueda)
{
string Sentencia = "SELECT *,sum(Cantidad*Precio1) As SubTotal1,";
Sentencia += " sum(Cantidad*Precio2) As SubTotal2,";
Sentencia += " sum(Cantidad*Precio3) As SubTotal3";
Sentencia += " FROM PortalGene.AnalisisDePrecios WHERE";
Sentencia += " Numero = '" + Busqueda + "' ";
Sentencia += " Group by Numero, Codigo With RollUp";
Sentencia += " Having Numero is not null";
return(AyudanteMySQL.EjecutarDataSet(ConfigurationSettings.AppSettings["PortalGene"], Sentencia));
}
public static DataSet BuscarDepFisicos(string Mes, string Seleccion)
{
string Sentencia = "SELECT A.NumeroDep,A.Fecha,sum(A.Monto) As MontoL,sum(B.Monto) As MontoB ";
Sentencia += " FROM PortalGene.DepositoFisico A LEFT JOIN PortalGene.DepositoBanco B ON A.NumeroDep = B.NumeroDep ";
Sentencia += " WHERE (MONTH(A.Fecha) = '" + Mes + "') ";
switch (Seleccion)
{
case "T": Sentencia += " and ( A.Conciliado = 'T' ) "; break;
case "C": Sentencia += " and ( A.Conciliado = 'C' ) "; break;
}
Sentencia += " GROUP bY A.NumeroDep With RollUp";
return(AyudanteMySQL.EjecutarDataSet(ConfigurationSettings.AppSettings["PortalGene"], Sentencia));
}
