protected void Page_Load(object sender, EventArgs e) { bool bEnable = false; oIsUsuario = oWeb.ValidaUserAppReport(); if ((!string.IsNullOrEmpty(oIsUsuario.NKeyDeudor)) && (!string.IsNullOrEmpty(oIsUsuario.NKeyUsuario)) || (!string.IsNullOrEmpty(oIsUsuario.NCodHolding))) { DBConn oConn = new DBConn(); { if (oConn.Open()) { string sMes = ("00" + DateTime.Now.AddMonths(-1).Month.ToString()).Substring(("00" + DateTime.Now.AddMonths(-1).Month.ToString()).Length - 2); double iEstimadoMesAnterior = 0; double iReaMesAnterior = 0; cDashboard oEstadimadoVsReal = new cDashboard(ref oConn); oEstadimadoVsReal.nKeyCliente = oIsUsuario.NKeyUsuario; oEstadimadoVsReal.nKeyDeudor = oIsUsuario.NKeyDeudor; oEstadimadoVsReal.CodHolding = oIsUsuario.NCodHolding; oEstadimadoVsReal.Periodo = sMes + "-01-" + (sMes == "12" ? DateTime.Now.AddYears(-1).Year.ToString() : DateTime.Now.Year.ToString()); //Response.Write("GetEstimadoVsReal;" + DateTime.Now.Millisecond.ToString() + "<br>"); DataTable dt = oEstadimadoVsReal.GetEstimadoVsReal(); //Response.Write("GetEstimadoVsReal;" + DateTime.Now.Millisecond.ToString() + "<br>"); if (dt != null) { if (dt.Rows.Count > 0) { bEnable = true; iEstimadoMesAnterior = double.Parse(dt.Rows[0]["estimado"].ToString()); iReaMesAnterior = double.Parse(dt.Rows[0]["real"].ToString()); } } dt = null; oEstadimadoVsReal.Periodo = (sMes == "12" ? DateTime.Now.AddYears(-1).Year.ToString() : DateTime.Now.Year.ToString()) + sMes; //Response.Write("GetFacturado;" + DateTime.Now.Millisecond.ToString() + "<br>"); double iFacturadoMesAnterior = oEstadimadoVsReal.GetFacturado(); //Response.Write("GetFacturado;" + DateTime.Now.Millisecond.ToString() + "<br>"); sMes = ("00" + DateTime.Now.Month.ToString()).Substring(("00" + DateTime.Now.Month.ToString()).Length - 2); double iEstimadoMes = 0; double iReaMes = 0; oEstadimadoVsReal.Periodo = sMes + "-01-" + DateTime.Now.Year.ToString(); //Response.Write("GetEstimadoVsReal;" + DateTime.Now.Millisecond.ToString() + "<br>"); dt = oEstadimadoVsReal.GetEstimadoVsReal(); //Response.Write("GetEstimadoVsReal;" + DateTime.Now.Millisecond.ToString() + "<br>"); if (dt != null) { if (dt.Rows.Count > 0) { bEnable = true; iEstimadoMes = double.Parse(dt.Rows[0]["estimado"].ToString()); iReaMes = double.Parse(dt.Rows[0]["real"].ToString()); } } dt = null; oEstadimadoVsReal.Periodo = DateTime.Now.Year.ToString() + sMes; //Response.Write("GetFacturado;" + DateTime.Now.Millisecond.ToString() + "<br>"); float iFacturado = oEstadimadoVsReal.GetFacturado(); //Response.Write("GetFacturado;" + DateTime.Now.Millisecond.ToString() + "<br>"); string sdata = "['PERIODO', 'Facturado', { type: 'string', role: 'annotation' }, 'Estimado', { type: 'string', role: 'annotation' }, 'Real', { type: 'string', role: 'annotation' }],"; sdata = sdata + "['Anterior'," + Math.Round(iFacturadoMesAnterior, 0).ToString() + ",'" + ((iFacturadoMesAnterior > 0)? Math.Round((iFacturadoMesAnterior / 1000000), 0).ToString() :"0") + "M'," + Math.Round(iEstimadoMesAnterior, 0).ToString() + ",'" + ((iEstimadoMesAnterior > 0) ? Math.Round((iEstimadoMesAnterior / 1000000), 0).ToString() : "0") + "M'," + Math.Round(iReaMesAnterior, 0).ToString() + ",'" + ((iReaMesAnterior > 0) ? Math.Round((iReaMesAnterior / 1000000), 0).ToString() : "0") + "M'],"; sdata = sdata + "['Actual'," + Math.Round(iFacturado, 0).ToString() + ",'" + ((iFacturado > 0) ? Math.Round((iFacturado / 1000000), 0).ToString() : "0") + "M'," + Math.Round(iEstimadoMes, 0).ToString() + ",'" + ((iEstimadoMes > 0) ? Math.Round((iEstimadoMes / 1000000), 0).ToString() : "0") + "M'," + Math.Round(iReaMes, 0).ToString() + ",'" + ((iReaMes > 0) ? Math.Round((iReaMes / 1000000), 0).ToString() : "0") + "M']"; StringBuilder sHtml = new StringBuilder(); sHtml.Append(" google.charts.setOnLoadCallback(drawlineChart2); "); sHtml.Append(" function drawlineChart2() { "); sHtml.Append(" var data = google.visualization.arrayToDataTable([ "); sHtml.Append(sdata); sHtml.Append(" ]); "); sHtml.Append(" var options = { annotations: { alwaysOutside: true, textStyle: { fontSize: 12, auraColor: 'none', color: '#fff' }, boxStyle: { stroke: '#79B6CD', strokeWidth: 1, rx: 10, ry: 10, gradient: { color1: '#79B6CD', color2: '#79B6CD', x1: '0%', y1: '0%', x2: '100%', y2: '100%' } } }, legend: { position: 'bottom', textStyle: { color: '#c5c5c5', fontName: 'Lato', fontSize: 13, bold: true, } }, vAxis: { format: 'short', textStyle: { color: '#c5c5c5', fontName: 'Lato', fontSize: 12, bold: true } }, hAxis: { textStyle: { color: '#c5c5c5', fontName: 'Lato', fontSize: 13, bold: true } }, colors: ['#BAE1EF', '#A5E6FE', '#6498FF'] }; "); sHtml.Append(" var chart = new google.visualization.ColumnChart(document.getElementById('lineChart2')); "); sHtml.Append(" chart.draw(data, options); "); sHtml.Append(" } "); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "lineChart2", sHtml.ToString(), true); string sDia = ("00" + DateTime.Now.Day.ToString()).Substring(("00" + DateTime.Now.Day.ToString()).Length - 2); oEstadimadoVsReal.Periodo = DateTime.Now.Year.ToString() + sMes + sDia; //Response.Write("GetTotal;" + DateTime.Now.Millisecond.ToString() + "<br>"); double itotal = oEstadimadoVsReal.GetTotal(); //Response.Write("GetTotal;" + DateTime.Now.Millisecond.ToString() + "<br>"); double iDeudaVencida = oEstadimadoVsReal.GetDeudaVencida(); //Response.Write("GetDeudaVencida;" + DateTime.Now.Millisecond.ToString() + "<br>"); double iDeudaDocumentada = oEstadimadoVsReal.GetDeudaDocumentada(); //Response.Write("GetDeudaDocumentada;" + DateTime.Now.Millisecond.ToString() + "<br>"); double iFacturasMayor30 = oEstadimadoVsReal.GetFacturasMayor30(); //Response.Write("GetFacturasMayor30;" + DateTime.Now.Millisecond.ToString() + "<br>"); double iFacturasMayor30SinLitigio = oEstadimadoVsReal.GetFacturasMayor30SinLitigio(); //Response.Write("GetFacturasMayor30SinLitigio;" + DateTime.Now.Millisecond.ToString() + "<br>"); lblTotal.Text = oIsUsuario.Moneda + " " + Math.Truncate(itotal).ToString("N0"); lblVencidas.Text = oIsUsuario.Moneda + " " + Math.Truncate(iDeudaVencida).ToString("N0"); lblDeudaDocumentada.Text = oIsUsuario.Moneda + " " + Math.Truncate(iDeudaDocumentada).ToString("N0"); lblVencidas30.Text = oIsUsuario.Moneda + " " + Math.Truncate(iFacturasMayor30).ToString("N0"); lblVencidas30SinLitigios.Text = oIsUsuario.Moneda + " " + Math.Truncate(iFacturasMayor30SinLitigio).ToString("N0"); //if ((iEstimadoMesAnterior != 0) || (iReaMesAnterior != 0) || (iEstimadoMes != 0) || (iReaMes != 0) || (itotal != 0) || (iDeudaVencida != 0) || (iFacturasMayor30 != 0) || (iFacturasMayor30SinLitigio != 0)) // bEnable = true; } oConn.Close(); } if (bEnable) { idVistaEnable.Visible = true; idVistaNoEnable.Visible = false; } else { idVistaEnable.Visible = false; idVistaNoEnable.Visible = true; } } else { idVistaEnable.Visible = false; idVistaNoEnable.Visible = true; } }