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