private string getDatos(int nNodo, int nAnno)
{
StringBuilder sb = new StringBuilder();
try
{
SqlDataReader dr = ConsultasPGE.ObtenerDatosResumidosGraficosNodo(nNodo, nAnno);
while (dr.Read())
{
sb.Append(dr["T325_ANOMES"].ToString() + "##");
sb.Append(dr["Ingresos_Netos"].ToString().Replace(",", ".") + "##");
sb.Append(dr["Margen"].ToString().Replace(",", ".") + "##");
sb.Append(dr["Obra_en_curso"].ToString().Replace(",", ".") + "##");
sb.Append(dr["Saldo_de_Clientes"].ToString().Replace(",", ".") + "##");
sb.Append(dr["Total_Cobros"].ToString().Replace(",", ".") + "##");
sb.Append(dr["Total_Ingresos"].ToString().Replace(",", ".") + "##");
sb.Append(dr["Volumen_de_Negocio"].ToString().Replace(",", ".") + "##");
sb.Append(dr["Total_consumos"].ToString().Replace(",", ".") + "##");
sb.Append(dr["Ratio"].ToString().Replace(",", ".") + "///");
}
dr.Close();
dr.Dispose();
return("OK@#@" + sb.ToString());
}
catch (Exception ex)
{
return("Error@#@" + Errores.mostrarError("Error al obtener los datos", ex));
}
}
