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;
}
