Example #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            //Cartgar las fechass a los Dropdown list FECHA_REPORTE_1 Y FECHA_REPORTE_2
            //FECHA_REPORTE_1.DataSource = items;
            //DateTime Fecha = DateTime.Today;
            //obtener_datos(Fecha.ToString,Fecha.ToString);


            if (!IsPostBack)
            {
                Conection con = new Conection();

                SqlConnection conn = new SqlConnection();

                conn.ConnectionString = Conection.constr;

                SqlCommand cmd = new SqlCommand("Select MIN(FECHA_MAGNA) FROM FALLOS_REPORTADOS", conn);

                conn.Open();

                SqlDataReader reader = cmd.ExecuteReader();

                while (reader.Read())
                {
                    dt = reader.GetDateTime(0);
                }

                for (DateTime d = dt; d < DateTime.Now; d = d.AddDays(1))
                {
                    Fecha_1.Items.Add(d.ToShortDateString());
                    Fecha_2.Items.Add(d.ToShortDateString());
                }


                reader.Close();
                conn.Close();
            }
        }
Example #2
0
        protected void obtener_datos(string fecha, string fecha2)
        {
            int       contador = 0;
            Conection con      = new Conection();

            SqlConnection conn = new SqlConnection();

            conn.ConnectionString = Conection.constr;

            SqlCommand cmd = new SqlCommand("Select Ambiente, count(TIPO_FALLA) AS Fallas_capturadas FROM FALLOS_REPORTADOS WHERE FECHA_MAGNA BETWEEN '" + Fecha_1.SelectedValue + "' and '" + Fecha_2.SelectedValue + "' Group by Ambiente", conn);

            conn.Open();

            SqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                nombs[contador]  = reader.GetString(0);
                barras[contador] = reader.GetInt32(1);
                contador++;
            }
            ;

            reader.Close();


            //Grafica.Series["Serie"].Points.DataBindXY();
            Grafica.Series["Serie"].Points.DataBindXY(nombs, barras);

            SqlDataAdapter DBAdapter = new SqlDataAdapter();

            //Agregar la tabla con los estadísticos
            DBAdapter.SelectCommand = new SqlCommand("Select Distinct AMBIENTE, SUM(DISTINCT MIN_FALLA) AS Minutos_paro, SUM(MINUTOS) as Minutos_capturados, sum(DISTINCT MIN_PRODUCCION) AS Minutos_produccion FROM FALLOS_REPORTADOS WHERE FECHA_MAGNA BETWEEN '" + Fecha_1.SelectedValue + "' and '" + Fecha_2.SelectedValue + "' GROUP BY AMBIENTE", conn);

            DataSet ds = new DataSet();

            DBAdapter.Fill(ds, "FALLOS_REPORTADOS");

            DataTable     dt   = ds.Tables[0];
            StringBuilder html = new StringBuilder();

            //Table format je je
            html.Append("<style>");
            html.Append("table {");
            html.Append("border-spacing: 0;");
            html.Append("width: 100 %;");
            html.Append("border: 1px solid #ddd;}");

            html.Append("th {");
            html.Append("cursor:pointer;}");

            html.Append("th, td {");
            html.Append("text-align: left;");
            html.Append("padding: 16px;}");

            html.Append("tr: nth - child(even) {");
            html.Append("background-color: #f2f2f2}</style>");



            //Table start.
            html.Append("<table id='tareas' class='tablesorter' border='1' style='padding-left:5px; padding-bottom:3px;cursor: pointer'><col width='240'>");

            //Building the Header row.
            int j = 0;

            html.Append("<tr>");
            foreach (DataColumn column in dt.Columns)
            {
                html.Append("<th font-size:25px; onclick='sortTable(" + j + ")'>");
                html.Append(column.ColumnName);
                html.Append("</th>");

                j++;
            }
            html.Append("</tr>");


            //Building the Data rows.
            foreach (DataRow row in dt.Rows)
            {
                html.Append("<tr>");
                foreach (DataColumn column in dt.Columns)
                {
                    html.Append("<td style='padding-left: 5px; padding-bottom:3px; font-size:15px;' width='30%'>" + row[column.ColumnName] + "</td>");
                }
                html.Append("</tr>");
            }

            html.Append("</table>");

            //Append the HTML string to Placeholder # 2.
            PlaceHolder2.Controls.Add(new Literal {
                Text = html.ToString()
            });



            conn.Close();
        }