protected void Page_Load(object sender, EventArgs e)
{
oIsUsuario = oWeb.ValidaUserAppReport();
if ((!string.IsNullOrEmpty(oIsUsuario.NKeyDeudor)) && (!string.IsNullOrEmpty(oIsUsuario.NKeyUsuario)) || (!string.IsNullOrEmpty(oIsUsuario.NCodHolding)))
{
DBConn oConn = new DBConn();
if (oConn.Open())
{
cDashboard oHistDBT = new cDashboard(ref oConn);
oHistDBT.nKeyCliente = oIsUsuario.NKeyUsuario;
oHistDBT.nKeyDeudor = oIsUsuario.NKeyDeudor;
oHistDBT.CodHolding = oIsUsuario.NCodHolding;
//Response.Write("GetDBT;" + DateTime.Now.Millisecond.ToString() + "<br>");
DataTable dt = oHistDBT.GetDBT();
//Response.Write("GetDBT;" + DateTime.Now.Millisecond.ToString() + "<br>");
if (dt != null)
{
if (dt.Rows.Count > 0)
{
string sMes = string.Empty;
string sMeses = string.Empty;
string sDBT = string.Empty;
string sData = "['Meses','Días', { role: 'annotation' } ]";
foreach (DataRow oRow in dt.Rows)
{
sMes = oRow["periodo"].ToString().Trim();
sData = sData + ",['" + sMes + "'," + Math.Round(double.Parse(oRow["dbt"].ToString()), 0).ToString() + ",'" + Math.Round(double.Parse(oRow["dbt"].ToString()), 0).ToString("N0") + "']";
}
StringBuilder sHtml = new StringBuilder();
sHtml.Append(" google.charts.setOnLoadCallback(drawRightY); ");
sHtml.Append(" function drawRightY() { ");
sHtml.Append(" var data = google.visualization.arrayToDataTable([ ");
sHtml.Append(sData);
sHtml.Append(" ]); ");
sHtml.Append(" var materialOptions = { 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: 'top', textStyle: { color: '#c5c5c5', fontName: 'Lato', fontSize: 13, bold: true, } }, vAxis: { format: 'short', textStyle: { color: '#c5c5c5', fontName: 'Lato', fontSize: 12, bold: true } }, hAxis: { textStyle: { color: '#91BBDB', fontName: 'Lato', fontSize: 13, bold: true } }, colors: ['#A5E6FE', '#A5E6FE', '#A5E6FE', '#A5E6FE', '#A5E6FE'], bars: 'horizontal', axes: { y: { 0: { side: 'right' } } } }; ");
sHtml.Append(" var materialChart = new google.visualization.BarChart(document.getElementById('horizontalBar')); ");
sHtml.Append(" materialChart.draw(data, materialOptions); } ");
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "horizontalBar", sHtml.ToString(), true);
}
}
dt = null;
dt = oHistDBT.GetCondicionPago();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
lb_sla_dbt.Text = dt.Rows[0]["condicion_pago"].ToString() + " días";
}
}
dt = null;
}
oConn.Close();
}
}