public void getAntiguedad() { double iMonto30 = 0; double iDocumento30 = 0; double iMonto60 = 0; double iDocumento60 = 0; double iMonto90 = 0; double iDocumento90 = 0; double iMontoMayor90 = 0; double iDocumentoMayor90 = 0; DataTable dt; DBConn oConn = new DBConn(); if (oConn.Open()) { cLitigios oAntiguedad = new cLitigios(ref oConn); oAntiguedad.nKeyCliente = hdd_cliente.Value; oAntiguedad.CodHolding = hdd_holding.Value; //oAntiguedad.nKeyDeudor = oIsUsuario.NKeyDeudor; oAntiguedad.Periodo = "30"; dt = oAntiguedad.getAntiguedad(); if (dt != null) { if (dt.Rows.Count > 0) { iMonto30 = double.Parse(dt.Rows[0]["saldo"].ToString()); iDocumento30 = double.Parse(dt.Rows[0]["cantidad"].ToString()); } } dt = null; oAntiguedad.Periodo = "60"; dt = oAntiguedad.getAntiguedad(); if (dt != null) { if (dt.Rows.Count > 0) { iMonto60 = double.Parse(dt.Rows[0]["saldo"].ToString()); iDocumento60 = double.Parse(dt.Rows[0]["cantidad"].ToString()); } } dt = null; oAntiguedad.Periodo = "90"; dt = oAntiguedad.getAntiguedad(); if (dt != null) { if (dt.Rows.Count > 0) { iMonto90 = double.Parse(dt.Rows[0]["saldo"].ToString()); iDocumento90 = double.Parse(dt.Rows[0]["cantidad"].ToString()); } } dt = null; oAntiguedad.Periodo = "mayor"; dt = oAntiguedad.getAntiguedad(); if (dt != null) { if (dt.Rows.Count > 0) { iMontoMayor90 = double.Parse(dt.Rows[0]["saldo"].ToString()); iDocumentoMayor90 = double.Parse(dt.Rows[0]["cantidad"].ToString()); } } dt = null; double iTotal = iMonto30 + iMonto60 + iMonto90 + iMontoMayor90; lb_porcentaje_30.Text = ((iMonto30 / iTotal) * 100).ToString("N0") + "%"; lb_monto_30.Text = "$" + iMonto30.ToString("N0"); lb_documento_30.Text = iDocumento30.ToString("N0") + " Facturas"; lb_porcentaje_60.Text = ((iMonto60 / iTotal) * 100).ToString("N0") + "%"; lb_monto_60.Text = "$" + iMonto60.ToString("N0"); lb_documento_60.Text = iDocumento60.ToString("N0") + " Facturas"; lb_porcentaje_90.Text = ((iMonto90 / iTotal) * 100).ToString("N0") + "%"; lb_monto_90.Text = "$" + iMonto90.ToString("N0"); lb_documento_90.Text = iDocumento90.ToString("N0") + " Facturas"; lbl_porcentaje_mayor90.Text = ((iMontoMayor90 / iTotal) * 100).ToString("N0") + "%"; lb_monto_mayor90.Text = "$" + iMontoMayor90.ToString("N0"); lb_documento_mayor90.Text = iDocumentoMayor90.ToString("N0") + " Facturas"; StringBuilder sHtml_Graph = new StringBuilder(); sHtml_Graph.Append(" google.charts.setOnLoadCallback(drawPieChart); "); sHtml_Graph.Append(" function drawPieChart() { "); sHtml_Graph.Append(" var data = google.visualization.arrayToDataTable([ "); sHtml_Graph.Append(" ['Días','Monto'], "); sHtml_Graph.Append(" ['30 días'," + iMonto30.ToString("0.00", CultureInfo.InvariantCulture) + "], "); sHtml_Graph.Append(" ['60 días'," + iMonto60.ToString("0.00", CultureInfo.InvariantCulture) + "], "); sHtml_Graph.Append(" ['90 días'," + iMonto90.ToString("0.00", CultureInfo.InvariantCulture) + "], "); sHtml_Graph.Append(" ['> 90 días'," + iMontoMayor90.ToString("0.00", CultureInfo.InvariantCulture) + "] "); sHtml_Graph.Append(" ]); "); sHtml_Graph.Append(" var options = { "); sHtml_Graph.Append(" pieHole: 0.9, "); sHtml_Graph.Append(" pieSliceText:'none', pieSliceTextStyle: 'none', pieSliceBorderColor: 'none', "); sHtml_Graph.Append(" colors: ['#4285F4', '#AA66CC', '#F5A623','#D0021B'], "); sHtml_Graph.Append(" legend: 'none', chartArea: { left: 10, right: 10, bottom: 10, top: 10 } "); sHtml_Graph.Append(" }; "); sHtml_Graph.Append(" var chart = new google.visualization.PieChart(document.getElementById('donut_single')); "); sHtml_Graph.Append(" chart.draw(data, options); "); sHtml_Graph.Append(" }; "); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "donut_single", sHtml_Graph.ToString(), true); } oConn.Close(); }