public double GetTotalByPedido(int id)
{
string Statement = string.Format("SELECT sum(t08_f001) FROM t08_notas_abonos where t05_pk01 = '{0}'", id);
double result = 0;
try
{
result = DBMysql_.GetScalarDouble(Statement);
return(result);
}
catch (DBException ex)
{
throw ex;
}
catch (MySqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
public double GetTotalByCliente(int id)
{
string Statement = string.Format("SELECT sum(t10_f006) FROM site.t10_productos where t04_pk01 = '{0}';", id);
try
{
double result = DBMysql_.GetScalarDouble(Statement);
return(result);
}
catch (DBException ex)
{
throw ex;
}
catch (MySqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
public double GetTotalByPedido(string type, int idPedido)
{
string Statement = string.Format("select sum(t09_f001) from t09_notas_ajustes where t09_f003 = '{0}' and t05_pk01 = '{1}'", type, idPedido);
try
{
double result = DBMysql_.GetScalarDouble(Statement);
return(result);
}
catch (DBException ex)
{
throw ex;
}
catch (MySqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
public double GetTotalByCliente(string typeMovimiento, int idCliente)
{
string Statement = string.Format("SELECT sum(t11_f001) FROM t11_abonos_cuenta where t04_pk01 = '{0}' and t11_f003 = '{1}'", idCliente, typeMovimiento);
try
{
double result = DBMysql_.GetScalarDouble(Statement);
return(result);
}
catch (DBException ex)
{
throw ex;
}
catch (MySqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}