//Acá obtengo los valores para llenar la grafica de pie
protected void s()
{
//System.Diagnostics.Debug.WriteLine("Agencia seleccionada: " + cmbAgency.SelectedIndex.ToString());
//fill_cets(cmbAgency.SelectedValue);
All_Data.DataSourceID = null;
All_Data.DataSource = null;
All_Data.DataBind();
try
{
obtieneRutas(cets);
show_all();
for (int i = 0; i < All_Data.Rows.Count; i++)
{
string status = All_Data.Rows[i].Cells[3].Text;
string cod = All_Data.Rows[i].Cells[2].Text;
if (status.Equals("0"))
{
cero += 1;
Session["NLiq"] = cod;
}
else if (status.Equals("1"))
{
uno += 1;
Session["Liq"] = cod;
}
else
{
vacio += 1;
Session["Pend"] = cod;
}
}
fill_pie();
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("<-- seleccionarAgencia Error: " + ex.Message + " -->");
}
}
//muestra todos los datos
public void show_all()
{
DataSet ds = new DataSet();
string name_function = "Zdsd_Funciones_Asp_Net";
var fecha = DateTime.Now.ToString("yyyyMMdd");
string nSVent = null;
string nCets = null;
try
{
IRfcFunction rfcFunction_Company = rfcRepository.CreateFunction(name_function.ToUpper());
rfcFunction_Company.SetValue("I_Proceso", "REFRESH");
IRfcTable i_tbl_refresh = rfcFunction_Company.GetTable("I_Tbl_Refresh");
foreach (DatosPermitidos dp in datos)
{
i_tbl_refresh.Append();
i_tbl_refresh.SetValue("SALA_VENTA", dp.sala_venta);
i_tbl_refresh.SetValue("CET", dp.cet);
i_tbl_refresh.SetValue("RUTA", dp.ruta);
i_tbl_refresh.SetValue("FECHA_LIQUIDA", fecha);
}
rfcFunction_Company.Invoke(rfcDestination);
//ds.Tables.Add(convert.toGridView(rfcFunction_Company.GetTable("O_Tbl_Refresh"), prueba_Dataso));
DataTable dtDatos = convert.toDataTable(rfcFunction_Company.GetTable("O_Tbl_Refresh"));
DataTable dtFinal = new DataTable();
dtFinal.Columns.Add("COD_SALA_VENTA", typeof(string));
dtFinal.Columns.Add("SALA_VENTA", typeof(string));
dtFinal.Columns.Add("COD_CET", typeof(string));
dtFinal.Columns.Add("CET", typeof(string));
dtFinal.Columns.Add("RUTA", typeof(string));
dtFinal.Columns.Add("FECHA_LIQUIDA", typeof(DateTime));
dtFinal.Columns.Add("LISTA_VISITA", typeof(string));
dtFinal.Columns.Add("MENSAJE", typeof(string));
dtFinal.Columns.Add("STATUS", typeof(string));
dtFinal.Columns.Add("REPORT1", typeof(string));
dtFinal.Columns.Add("LIQUIDA", typeof(string));
dtFinal.Columns.Add("REPORT2", typeof(string));
dtFinal.Columns.Add("STATUSF", typeof(string));
for (int x = 0; x < dtDatos.Rows.Count; x++)
{
//System.Diagnostics.Debug.WriteLine(CSVENT.Rows[0].Cells[0].Text);
for (int y = 0; y < CSVENT.Rows.Count; y++)
{
if (CSVENT.Rows[y].Cells[0].Text == dtDatos.Rows[x][0].ToString())
{
nSVent = CSVENT.Rows[y].Cells[1].Text;
break;
}
}
for (int zx = 0; zx < CCETS.Rows.Count; zx++)
{
if (CCETS.Rows[zx].Cells[0].Text == dtDatos.Rows[x][1].ToString())
{
nCets = CCETS.Rows[zx].Cells[1].Text;
break;
}
}
//System.Diagnostics.Debug.WriteLine(CSVENT.Rows[0].Cells[0].Text +" -- "+dtDatos.Rows[x][0].ToString());
//System.Diagnostics.Debug.WriteLine("prueba: -- " + nSVent);
DataRow data = dtFinal.NewRow();
data[0] = nSVent;
data[1] = dtDatos.Rows[x][0].ToString();
data[2] = nCets;
data[3] = dtDatos.Rows[x][1].ToString();
data[4] = dtDatos.Rows[x][2].ToString();
data[5] = dtDatos.Rows[x][3].ToString();
data[6] = dtDatos.Rows[x][4].ToString();
data[7] = dtDatos.Rows[x][5].ToString();
data[8] = dtDatos.Rows[x][6].ToString();
data[9] = dtDatos.Rows[x][7].ToString();
data[10] = dtDatos.Rows[x][8].ToString();
data[11] = dtDatos.Rows[x][9].ToString();
data[12] = dtDatos.Rows[x][10].ToString();
dtFinal.Rows.Add(data);
}
All_Data.DataSource = dtFinal;
All_Data.DataBind();
Semaforo();
//All_Data.Columns[0].ControlStyle.CssClass = "Column0";
//All_Data.Columns[1].ControlStyle.CssClass = "Column1";
//All_Data.Columns[2].ControlStyle.CssClass = "Column2";
//All_Data.Columns[3].ControlStyle.CssClass = "Column3";
//All_Data.Columns[4].ControlStyle.CssClass = "Column4";
//All_Data.Columns[5].ControlStyle.CssClass = "Column5";
//All_Data.Columns[6].ControlStyle.CssClass = "Column6";
//All_Data.Columns[7].ControlStyle.CssClass = "Column7";
//All_Data.Columns[8].ControlStyle.CssClass = "Column8";
//All_Data.Columns[9].ControlStyle.CssClass = "Column9";
//All_Data.Columns[10].ControlStyle.CssClass = "Column10";
//All_Data.Columns[11].ControlStyle.CssClass = "Column11";
//All_Data.Columns[12].ControlStyle.CssClass = "Column12";
//All_Data.Columns[13].ControlStyle.CssClass = "Column13";
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("<-- show_all Error: " + ex.Message + " -->");
}
}