//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 + " -->"); } }