protected void btnAgregar_Click(object sender, EventArgs e)
{
try
{
if (valor.Value != "0")
{
Bu_Eventos eve = new Bu_Eventos();
DetallesEventos d = new DetallesEventos();
d.id_evento = Convert.ToInt32(valor.Value);
d.detalle_eventos = txtDetalle.Value.ToString().Trim();
d.id_user = 16712750;
eve.IngresaDetalleEventos(d);
CargaTabla(Convert.ToInt32(valor.Value));
limpiar();
}
else
{
Response.Write("<script language=javascript>alert('NO HAS SELECCIONADO UN EVENTO');</script>");
}
}
catch (Exception ex)
{
Response.Write("<script language=javascript>alert('ERROR DE REGISTRO: \n " + ex.ToString() + "');</script>");
}
}
private void CargaTabla()
{
Bu_Eventos b = new Bu_Eventos();
DataSet ds = new DataSet();
ds = b.CantidadEventos_Maquina();
if (ds.Tables[0].Rows.Count > 0)
{
string cadena = "";
cadena += "<table id='tbVista' runat='server' class='table table-striped'><tbody><tr><th>ID</th><th>CANT_EVENTO</th><th>MAQUINA</th></tr>";
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
cadena += "<tr><th>" + ds.Tables[0].Rows[i]["ID"] + "</td>";
cadena += "<th>" + ds.Tables[0].Rows[i]["CANT_EVENTOS"] + "</td>";
cadena += "<th>" + ds.Tables[0].Rows[i]["MAQUINA"] + "</td></tr>";
}
cadena += "</tbody></table>";
ListarEventos.InnerHtml = cadena;
}
else
{
ListarEventos.InnerHtml = "";
}
}
private void CargaChart()
{
Bu_Eventos b = new Bu_Eventos();
Chart1.DataSource = b.CantidadEventos_Maquina();
Chart1.DataBind();
}
private void CargaTabla(int id_evento)
{
Bu_Eventos b = new Bu_Eventos();
DataSet ds = new DataSet();
ds = b.CargarListadoEventos(id_evento);
if (ds.Tables[0].Rows.Count > 0)
{
string cadena = "";
cadena += "<table id='tbVista' runat='server' class='table table-striped'><tbody><tr><th>ID</th><th>NOMBRE CLIENTE</th><th>MAQUINA</th><th>TIPO FALLA</th><th>FECHA EVENTO</th><th>ESTADO</th></tr>";
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
cadena += "<tr><th>" + ds.Tables[0].Rows[i]["ID"] + "</td>";
cadena += "<th>" + ds.Tables[0].Rows[i]["NOMBRE CLIENTE"] + "</td>";
cadena += "<th>" + ds.Tables[0].Rows[i]["MAQUINA"] + "</td>";
cadena += "<th>" + ds.Tables[0].Rows[i]["TIPO FALLA"] + "</td>";
cadena += "<th>" + ds.Tables[0].Rows[i]["FECHA EVENTO"] + "</td>";
cadena += "<th>" + ds.Tables[0].Rows[i]["ESTADO"] + "</td></tr>";
}
cadena += "</tbody></table>";
ListarEventos.InnerHtml = cadena;
}
else
{
ListarEventos.InnerHtml = "";
}
}
private void CargaBox(DropDownList control, int flag, int ddlFlag)
{
Bu_Eventos box = new Bu_Eventos();
DataSet ds = box.CargaCombos(flag, ddlFlag);
control.DataSource = ds;
control.DataTextField = "Nombre";
control.DataValueField = "Codigo";
control.DataBind();
}
protected void btnAgregar_Click(object sender, EventArgs a)
{
try
{
Bu_Eventos r = new Bu_Eventos();
Eventos e = new Eventos();
e.tipo_evento = Convert.ToInt32(ddlTipoEvento.SelectedValue);
e.cliente_rut = Convert.ToInt32(ddlCliente.SelectedValue);
e.maquina_id = Convert.ToInt32(ddlMaquina.SelectedValue);
e.detalle_eventos = txtDetalle.Value.ToString();
e.id_user = 16712750;
int nroEvento = r.IngresaEventos(e);
Response.Write("<script language=javascript>alert('SU NUMERO DE EVENTO ES: " + nroEvento.ToString() + "');</script>");
recarga();
}
catch (Exception ex)
{
Response.Write("<script language=javascript>alert('ERROR:\n " + ex.ToString() + "');</script>");
}
}
private void CargaTabla(int valor)
{
Bu_Eventos e = new Bu_Eventos();
DataSet ds = new DataSet();
ds = e.CargaGrid(valor);
if (ds.Tables[0].Rows.Count > 0)
{
string cadena = "";
cadena += "<table id='tbVista' runat='server' class='table table-striped'><tbody><tr><th style='width: 10px'>ID</th><th style='width: 30px'>NRO EVENTO</th><th>DESCRIPCIÓN</th><th style='width: 150px'>FECHA</th></tr>";
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
cadena += "<tr><th>" + ds.Tables[0].Rows[i]["ID"] + "</td>";
cadena += "<th>" + ds.Tables[0].Rows[i]["N_EVE"] + "</td>";
cadena += "<th>" + ds.Tables[0].Rows[i]["DESCRIPCIÓN"] + "</td>";
cadena += "<th>" + ds.Tables[0].Rows[i]["FECHA"] + "</td></tr>";
}
cadena += "</tbody></table>";
ListadoDetalle.InnerHtml = cadena;
}
}
