public void getGrafica()
{
string titulo = "Gráfica de total metros cúbicos";
string script, script2, script3;
DataDecClassDataContext db = new DataDecClassDataContext();
script = "google.load('visualization', '1', { packages: ['corechart'] }); google.setOnLoadCallback(drawChart2); function drawChart2() { var data = new google.visualization.DataTable(); data.addColumn('string', 'Partido'); data.addColumn('number', '"+titulo+"');";
GetPresasResult[] t = db.GetPresas().ToArray();
script2 = "data.addRows("+t.Count()+");";
int c = 0;
foreach (GetPresasResult a in t)
{
script2 += "data.setValue("+c+",0, "+a.cDescripcion+"); ";
c++;
}
c = 0;
GetAguaSuperficial_PERCENTResult[] t_ = db.GetAguaSuperficial_PERCENT().ToArray();
foreach (GetAguaSuperficial_PERCENTResult a in t_)
{
script2 += "data.setValue(1," + c + ", " + String.Format("##.##",a.PRODUCCION)+"); ";
}
script3 = "var chart = new google.visualization.ColumnChart(document.getElementById('divGraf')); chart.draw(data, { width:640, height: 350,legend:'bottom' });}";
jscript += script + script2 + script3;
}
protected string Tabla(string presa)
{
string tabla = "";
string fila = "";
DataDecClassDataContext db = new DataDecClassDataContext();
GetEconomiaResult[] r = db.GetEconomia(presa).ToArray();
if (r.Length > 0)
{
foreach (GetEconomiaResult data in r)
{
fila = "<td align='center'>" + data.nEstablecimiento + "</td><td align='center'>" + data.nHabitaciones + "</td>";
tabla += "<tr>" + fila + "</tr>";
}
tabla = "<table id='tabla' width='100%'><thead><th>ESTABLECIMIENTO ALQUILADOS</th><th>NO. HABITACIONES</th></thead><tbody>" + tabla + "</tbody></table>";
return tabla;
}
else { return ""; }
}
protected string Tabla(string ano, string presa)
{
string tabla = "";
string fila = "";
DataDecClassDataContext db = new DataDecClassDataContext();
GetAguaSuperficialResult[] r = db.GetAguaSuperficial(ano, presa).ToArray();
if (r.Length > 0)
{
foreach (GetAguaSuperficialResult data in r)
{
fila = "<td align='center'>" + data.AÑO + "<td align='center'>" + data.PRESA + "</td></td><td align='center'>" + String.Format("{0:0,0.0}", data.PRODUCCION) + "</td>";
tabla += "<tr>" + fila + "</tr>";
}
tabla = "<table id='tabla' width='100%'><thead><th>AÑO</th><th>AGUA SUPERFICIAL</th><th>PRODUCCION</th></thead><tbody>" + tabla + "</tbody></table>";
return tabla;
}
else { return ""; }
}
