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; } }