private void carga_trailers() { TrailerBC cc = new TrailerBC(); DataTable dt = cc.obtenerXParametro("", null, dropsite.SelectedValue); utils.CargaDrop(trailers, "PLACA", "PLACA", dt); }
protected void btn_bloquear_Click(object sender, EventArgs e) { TrailerBC trailer = new TrailerBC(); if (ddTipoBloqueo.SelectedItem.Text == "Seleccione...") { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "modal", "alert('Debe Seleccionar un tipo de Bloqueo');", true); } else { string resultado; trailer.Bloquear(int.Parse(hf_idTrailer.Value), int.Parse(ddTipoBloqueo.SelectedValue), usuario.ID, out resultado); if (string.IsNullOrEmpty(resultado)) { ObtenerTrailer(true); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "modal", "showAalert('Operacion Realizada Correctamente');", true); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "modal1", "modalCerrar('modalBloqueo');", true); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "modal", "alert('" + resultado + "');", true); } } }
protected void btn_editGrabar_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txt_editPlaca.Text)) { utils.ShowMessage2(this, "crearTrailer", "warn_placaVacia"); return; } // if (ddl_editTran.SelectedIndex < 1) { utils.ShowMessage2(this, "crearTrailer", "warn_tranVacio"); return; } TrailerBC t = new TrailerBC(); t.PLACA = txt_editPlaca.Text; // t.TRAN_ID = Convert.ToInt32(ddl_editTran.SelectedValue); if (t.CrearGenerico(t, chk_vehiculoImportado.Checked)) { this.hf_idTrailer.Value = t.ID.ToString(); this.txt_placaTrailer.Text = t.PLACA; this.ddl_transportista.SelectedValue = t.TRAN_ID.ToString(); btnBuscarTrailer_Click(null, null); utils.ShowMessage2(this, "crearTrailer", "success"); utils.CerrarModal(this, "modalTrailer"); } else { utils.ShowMessage2(this, "crearTrailer", "error"); } }
protected void limpia(object sender, EventArgs e) { this.drop_SelectedIndexChanged(null, null); this.hf_trailerId.Value = ""; this.txt_nroFlota.Text = ""; //this.txt_buscarPatente.Text = ""; this.ddl_destinoZona1.ClearSelection(); this.ddl_destinoZona2.ClearSelection(); this.ddl_buscarPatente.ClearSelection(); this.ddl_destinoZona1.Enabled = false; this.ddl_destinoZona2.Enabled = false; this.ddl_destinoZona1_SelectedIndexChanged(null, null); this.ddl_destinoZona2_SelectedIndexChanged(null, null); this.pnl_detalleLugar.Style.Add("background-color", "#ffffff"); this.pnl_detalleLugar.Style.Add("color", "black"); this.pnl_detalleTrailer.Attributes.Add("style", string.Format("background-color:{0};", "#ffffff")); this.pnl_imgAlerta.BackColor = System.Drawing.Color.White; this.img_trailer.ImageUrl = ""; this.lbl_origenZona.Text = ""; this.lbl_origenPlaya.Text = ""; this.txt_transporte.Text = ""; this.lbl_lugar.Text = ""; TrailerBC t = new TrailerBC(); utils.CargaDrop(this.ddl_buscarPatente, "ID", "PLACA", t.obtenerDisponiblesDrop(Convert.ToInt32(this.dropsite.SelectedValue), false, false)); }
private void llenarForm() { SolicitudBC s = new SolicitudBC(); TrailerBC t = new TrailerBC(); LugarBC l = new LugarBC(); ZonaBC z = new ZonaBC(); s = s.ObtenerXId(int.Parse(hf_idSolicitud.Value)); hf_timestamp.Value = s.TIMESTAMP.ToString(); t = t.obtenerXID(s.ID_TRAILER); l = l.obtenerXID(t.LUGAR_ID); utils.CargaDropTodos(ddl_editZona, "ID", "DESCRIPCION", z.ObtenerXSite(s.ID_SITE, false)); ddl_editZona.SelectedValue = l.ID_ZONA.ToString(); ddl_editZona_IndexChanged(null, null); ddl_editPlaya.SelectedValue = l.ID_PLAYA.ToString(); ddl_editPlaya_IndexChanged(null, null); try { ddl_editPos.SelectedValue = l.ID.ToString(); } catch (Exception e) {} ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "asdf", "modalPosicion();", true); }
private void ObtenerTrailer(bool forzarBD) { if (ViewState["lista"] == null || forzarBD) { TrailerBC t = new TrailerBC(); t.PLACA = txt_buscarNombre.Text; t.NUMERO = txt_buscarNro.Text; t.EXTERNO = chk_buscarInterno.Checked; t.TRTI_ID = Convert.ToInt32(ddl_buscarTipo.SelectedValue); t.TRAN_ID = Convert.ToInt32(ddl_buscarTransportista.SelectedValue); t.SITE_ID = Convert.ToInt32(ddl_buscarSite.SelectedValue); int zona_id = Convert.ToInt32(ddl_buscarZona.SelectedValue); int play_id = Convert.ToInt32(ddl_buscarPlaya.SelectedValue); DataTable dt = t.obtenerXParametro(t, zona_id, play_id); ViewState["lista"] = dt; } DataView dw = new DataView((DataTable)ViewState["lista"]); if (ViewState["sortExpresion"] != null && ViewState["sortExpresion"].ToString() != "") { dw.Sort = (String)ViewState["sortExpresion"]; } this.gv_listar.DataSource = dw; this.gv_listar.DataBind(); }
protected void btn_mover_Click(object sender, EventArgs e) { if (this.ddl_bloqLugar.SelectedIndex > 0) { TrailerBC t = new TrailerBC().obtenerXID(int.Parse(this.hf_idTrailer.Value)); MovimientoBC m = new MovimientoBC(); m.ID_DESTINO = int.Parse(this.ddl_bloqLugar.SelectedValue); m.ID_TRAILER = t.ID; string resultado; if (m.MOVIMIENTO(t.SITE_ID, this.usuario.ID, out resultado) && resultado == "") { this.ObtenerTrailer(true); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "cerrar4", "showAlert('Movimiento Exitoso');", true); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "cerrar3", "cerrarModal('modalBloqueo');", true); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "msj", string.Format("alert('{0}');", resultado), true); } } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "msj", "alert('Seleccione un lugar de destino');", true); } }
private void llenarForm() { int soli_id = int.Parse(this.Request.Params["soli_id"].ToString()); this.hf_soliId.Value = soli_id.ToString(); SolicitudBC solicitud = new SolicitudBC(); SolicitudAndenesBC sa = new SolicitudAndenesBC(); LugarBC l = new LugarBC(); TrailerBC t = new TrailerBC(); solicitud = solicitud.ObtenerXId(soli_id); sa = sa.ObtenerXId(soli_id, 1); this.txt_buscarFecha.Text = solicitud.FECHA_CREACION.ToString("dd/MM/yyyy"); this.txt_buscarHora.Text = solicitud.FECHA_CREACION.ToString("hh:mm"); this.hf_trailerId.Value = solicitud.ID_TRAILER.ToString(); t = t.obtenerXID(solicitud.ID_TRAILER); this.btnBuscar_Click(null, null); l = l.obtenerXID(sa.LUGA_ID); this.dropsite.SelectedValue = l.ID_SITE.ToString(); this.drop_SelectedIndexChanged(null, null); this.ddl_destinoZona1.SelectedValue = l.ID_ZONA.ToString(); this.ddl_destinoZona1_SelectedIndexChanged(null, null); this.ddl_destinoPlaya1.SelectedValue = l.ID_PLAYA.ToString(); this.ddl_destinoPlaya1_SelectedIndexChanged(null, null); this.ddl_destinoPos1.SelectedValue = l.ID.ToString(); }
private void llenarForm(TrailerBC trailer) { hf_idTrailer.Value = trailer.TRAI_ID.ToString(); txt_editPlaca.Text = trailer.TRAI_PLACA; txt_editNumero.Text = trailer.TRAI_NUMERO; ddl_editTipo.SelectedValue = trailer.TRAILER_TIPO.TRTI_ID.ToString(); }
protected void ddl_vehiculoTipo_SelectedIndexChanged(object sender, EventArgs e) { int trti_id = Convert.ToInt32(ddl_vehiculoTipo.SelectedValue); DateTime fecha = Convert.ToDateTime(txt_buscarFecha.Text); DataTable dt = new TrailerBC().ObtenerTodo(fecha: fecha , hora_id: Convert.ToInt32(ddl_buscarHorario.SelectedValue) , trti_id: trti_id); ddl_vehiculoTrailer.Items.Clear(); ddl_vehiculoTrailer.Items.Add(new RadComboBoxItem("Sin Vehículo", "0")); foreach (DataRow dr in dt.Rows) { RadComboBoxItem cb = new RadComboBoxItem(dr["TRAI_PLACA"].ToString(), dr["TRAI_ID"].ToString()); if (dr["ID_RUTA"] != DBNull.Value) { int id_ruta = Convert.ToInt32(dr["ID_RUTA"]); if (id_ruta.ToString() != hf_idRuta.Value) { cb.Enabled = false; } } ddl_vehiculoTrailer.Items.Add(cb); } ddl_vehiculoTrailer.SelectedIndex = 0; }
protected void btn_confirmar_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(hf_idCond.Value)) { ConductorBC c = new ConductorBC(); c.RUT = txt_conductorRut.Text; c.NOMBRE = txt_conductorNombre.Text; c.TRAN_ID = Convert.ToInt32(ddl_transportista.SelectedValue); c.COND_EXTRANJERO = chk_conductorExtranjero.Checked; hf_idCond.Value = c.AgregarIdentity().ToString(); } MovimientoBC mov = new MovimientoBC(); TrailerUltEstadoBC trailerUE = new TrailerUltEstadoBC(); TrailerBC trailer = new TrailerBC(); mov.FECHA_CREACION = DateTime.Now; mov.ID_ESTADO = 10; mov.OBSERVACION = txt_obs.Text; DateTime fh = DateTime.Parse(string.Format("{0} {1}", txt_ingresoFecha.Text, txt_ingresoHora.Text)); mov.FECHA_ORIGEN = fh; mov.ID_DESTINO = Convert.ToInt32(this.ddl_posicion.SelectedValue); mov.FECHA_DESTINO = fh.AddMinutes(30); mov.PATENTE_TRACTO = txt_buscarPatente.Text; mov.MANT_EXTERNO = false; mov.ID_TRAILER = 0; trailer.ID = 0; trailer.PLACA = ""; trailer.TRAN_ID = Convert.ToInt32(ddl_transportista.SelectedValue); trailerUE.SITE_ID = Convert.ToInt32(dropsite.SelectedValue); // 1; // Cambiar después de introducir variables de sesión trailerUE.CHOFER_RUT = utils.formatearRut(txt_conductorRut.Text); trailerUE.CHOFER_NOMBRE = txt_conductorNombre.Text; trailerUE.ACOMP_RUT = txt_acomRut.Text; trailerUE.COND_ID = Convert.ToInt32(hf_idCond.Value); UsuarioBC usuario = (UsuarioBC)Session["USUARIO"]; string resultado; bool ejecucion = mov.ProcesoEntrada(mov, trailerUE, trailer, usuario.ID, out resultado); if (ejecucion && resultado == "") { utils.ShowMessage2(this, "confirmar", "success"); limpiarTodo(); } else { utils.ShowMessage(this, resultado, "error", false); } } catch (Exception ex) { utils.ShowMessage(this, ex.Message, "error", false); } }
protected void btn_buscarTrailer_Click(object sender, EventArgs e) { hf_traiId.Value = ""; carga_trailers(); DataTable dt2 = (DataTable)ViewState["locales"]; if (dt2.Rows.Count == 0) { hf_traiId.Value = ""; txt_trailerPatente.Text = ""; txt_trailerNro.Text = ""; //txt_trailerTransporte.Text = ""; utils.ShowMessage2(this, "buscarTrailer", "warn_andenLocalVacio"); return; } else { TrailerBC trailer = (!string.IsNullOrEmpty(txt_trailerNro.Text)) ? new TrailerBC().obtenerXNro(txt_trailerNro.Text) : new TrailerBC().obtenerXPlaca(txt_trailerPatente.Text); int old_id = Convert.ToInt32(hf_traiIdOld.Value); if (old_id == trailer.ID) { ddl_playaDescarga.Enabled = false; ddl_playaDescarga.ClearSelection(); ddl_playaDescarga_SelectedIndexChanged(null, null); hf_traiId.Value = trailer.ID.ToString(); txt_trailerPatente.Text = trailer.PLACA; txt_trailerNro.Text = trailer.NUMERO; txt_trailerShortek.Text = trailer.ID_SHORTEK; // txt_trailerTransporte.Text = trailer.TRANSPORTISTA.ToString(); utils.ShowMessage2(this, "buscarTrailer", "success"); } else if (ComprobarTrailer(trailer)) { ddl_playaDescarga.Enabled = true; ddl_playaDescarga_SelectedIndexChanged(null, null); hf_traiId.Value = trailer.ID.ToString(); txt_trailerPatente.Text = trailer.PLACA; txt_trailerNro.Text = trailer.NUMERO; txt_trailerShortek.Text = trailer.ID_SHORTEK; // txt_trailerTransporte.Text = trailer.TRANSPORTISTA.ToString(); utils.ShowMessage2(this, "buscarTrailer", "success"); } else { ddl_playaDescarga.Enabled = false; ddl_playaDescarga.ClearSelection(); ddl_playaDescarga_SelectedIndexChanged(null, null); hf_traiId.Value = ""; txt_trailerPatente.Text = ""; txt_trailerNro.Text = ""; // txt_trailerTransporte.Text = ""; utils.ShowMessage2(this, "buscarTrailer", "warn_andenLocalVacio"); return; } } }
private bool comprobarTrailerEx() { SolicitudBC s = new SolicitudBC(); s = s.ObtenerXId(int.Parse(this.hf_idSolicitud.Value)); TrailerBC t = new TrailerBC(); t = t.obtenerXID(s.ID_TRAILER); return(t.EXTERNO); }
protected void btn_editGrabar_Click(object sender, EventArgs e) { ServiciosExternosVehiculosBC s = new ServiciosExternosVehiculosBC(); s = this.LlenarBC(); TrailerBC t = new TrailerBC(); t = t.obtenerXPlaca(s.PLACA); if (t.ID > 0) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "modal", "alert('Patente corresponde a Trailer');", true); } else if (this.utils.patentevalida(s.PLACA) == true) { if (string.IsNullOrEmpty(this.hf_id.Value)) { if (s.ObtenerXPlaca(s.PLACA).SEVE_ID > 0) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "msj", "alert('Patente existente');", true); } else if (s.Crear()) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "msj", "showAlert('Vehículo agregado correctamente');", true); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "cerrar", "cerrarModal('modalEditar');", true); this.ObtenerServicios(true); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "modal", "alert('Error');", true); } } else { s.SEVE_ID = Convert.ToInt32(this.hf_id.Value); if (s.ObtenerXPlaca(s.PLACA).SEVE_ID > 0) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "msj", "alert('Patente existente');", true); } else if (s.Modificar()) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "msj", "showAlert('Vehículo modificado correctamente');", true); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "cerrar", "cerrarModal('modalEditar');", true); this.ObtenerServicios(true); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "modal", "alert('Error');", true); } } } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "modal", "alert('Patente Invalida');", true); } }
protected void txt_editPlaca_TextChanged(object sender, EventArgs e) { TrailerBC t = new TrailerBC().obtenerXPlaca(txt_editPlaca.Text); if (t.ID != 0) { utils.ShowMessage2(this, "agregarTrailer", "warn_placaExiste"); txt_editPlaca.Text = ""; txt_editPlaca.Focus(); } }
public void btn_guarda_cambios_click(object sender, EventArgs e) { LugarBC lugar = new LugarBC(); lugar.ID = int.Parse(this.hf_idLugar.Value); TrailerBC t = new TrailerBC(); t.NUMERO = this.txt_nroTrailer.Text; if (this.rb_tracto.Checked == true) { t.PATENTE_TRACTO = this.txt_placaTracto.Text; t.ID = 0; string msj; if (lugar.Cuadratura(this.usuario.ID, t, "", out msj) && msj == "") { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "cerrar", "cerrarModal('modalPendientes');", true); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "mensaje", "showAlert('cambios realizados correctamente!');", true); this.recargaplayas(null, null); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "mensaje", string.Format("alert('{0}');", msj), true); } } else { if (this.rb_trailer.Checked) { t.PLACA = this.txt_placaTrailer.Text; t.ID = Convert.ToInt32(this.hf_idTrailer.Value); } else if (this.rb_vacio.Checked) { t.PLACA = ""; t.ID = 0; } t.PATENTE_TRACTO = ""; string msj; if (lugar.Cuadratura(this.usuario.ID, t, this.ddl_estadoTrailer.SelectedValue, out msj) && msj == "") { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "cerrar", "cerrarModal('modalPendientes');", true); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "mensaje", "showAlert('cambios realizados correctamente!');", true); this.recargaplayas(null, null); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "mensaje", string.Format("alert('{0}');", msj), true); } } }
protected void btn_editGuardar_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txt_editPlaca.Text)) { utils.ShowMessage2(this, "modificar", "warn_placaVacia"); return; } if (ddl_editTipo.SelectedIndex < 1) { utils.ShowMessage2(this, "modificar", "warn_tipoVacio"); return; } try { TrailerBC trailer = new TrailerBC(); trailer.TRAI_PLACA = txt_editPlaca.Text; trailer.TRAI_NUMERO = txt_editNumero.Text; if (ddl_editTipo.SelectedIndex > 0) { trailer.TRAILER_TIPO.TRTI_ID = Convert.ToInt32(ddl_editTipo.SelectedValue); } trailer.TRAI_COD = txt_editPlaca.Text; if (hf_idTrailer.Value == "") { if (trailer.Guardar()) { utils.ShowMessage2(this, "guardar", "success_nuevo"); utils.CerrarModal(this, "modalEdit"); } else { utils.ShowMessage2(this, "guardar", "error_nuevo"); } } else { trailer.TRAI_ID = Convert.ToInt32(hf_idTrailer.Value); if (trailer.Guardar()) { utils.ShowMessage2(this, "guardar", "success_modificar"); } else { utils.ShowMessage2(this, "guardar", "error_modificar"); } } } catch (Exception ex) { utils.ShowMessage(this, ex.Message, "error", false); } finally { ObtenerTrailer(true); } }
protected void txt_buscarDoc_TextChanged(object sender, EventArgs e) { TrailerBC trailer = new TrailerBC(); trailer = trailer.obtenerXDoc(txt_buscarDoc.Text, dropsite.SelectedValue); if (trailer.ID != 0) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "mensaje", "alert('Documento ya existente.');", true); txt_buscarDoc.Text = ""; txt_buscarDoc.Focus(); } }
private void llenarForm(TrailerBC trailer) { this.hf_idTrailer.Value = trailer.ID.ToString(); // txt_editCodigo.Text = trailer.CODIGO; this.txt_editPlaca.Text = trailer.PLACA; this.chk_editExterno.Checked = trailer.EXTERNO; this.txt_editNumero.Text = trailer.NUMERO; this.ddl_editTran.SelectedValue = trailer.TRAN_ID.ToString(); this.ddl_editTipo.SelectedValue = trailer.TRTI_ID.ToString(); this.hf_excluyentes.Value = trailer.EXCLUYENTES; this.hf_noexcluyentes.Value = trailer.NO_EXCLUYENTES; }
protected void drop_SelectedIndexChanged(object sender, EventArgs e) { TrailerBC t = new TrailerBC(); ZonaBC z = new ZonaBC(); z.DESCRIPCION = ""; z.SITE_ID = Convert.ToInt32(this.dropsite.SelectedValue); z.ZOTI_ID = 200; utils.CargaDrop(this.ddl_destinoZona1, "ID", "DESCRIPCION", z.ObtenerXParametros()); utils.CargaDrop(this.ddl_destinoZona2, "ID", "DESCRIPCION", z.ObtenerXParametros()); utils.CargaDrop(this.ddl_buscarPatente, "ID", "PLACA", t.obtenerDisponiblesDrop(Convert.ToInt32(this.dropsite.SelectedValue), false, false)); }
protected void txt_editPlaca_TextChanged(object sender, EventArgs e) { TrailerBC t = new TrailerBC(); t = t.obtenerXPlaca(txt_editPlaca.Text); if (t.ID != 0 && t.ID != null) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "mensaje", "alert('Trailer ya existe en la base de datos!');", true); txt_editPlaca.Text = ""; txt_editPlaca.Focus(); } }
protected void btnBuscarTrailer_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txt_placaTrailer.Text)) { utils.ShowMessage2(this, "buscarTrailer", "warn_placaVacia"); return; } if (!chk_vehiculoImportado.Checked && !utils.patentevalida(txt_placaTrailer.Text)) { utils.ShowMessage2(this, "buscarTrailer", "warn_placaInvalida"); return; } TrailerBC trailer = new TrailerBC(); trailer = trailer.obtenerXPlaca(txt_placaTrailer.Text); if (trailer.ID == 0) //Trailer nuevo, no existe { TractoBC tracto = new TractoBC(); if (txt_placaTrailer.Text != "") { tracto = tracto.ObtenerXPatente(txt_placaTrailer.Text); } if (tracto.ID > 0) { utils.ShowMessage2(this, "buscarTrailer", "warn_placaTracto"); } else { utils.AbrirModal(this, "modalConfirmar"); } this.chk_vehiculoImportado.Enabled = false; } else //Trailer existente, trae datos { hf_idTrailer.Value = trailer.ID.ToString(); txt_placaTrailer.Text = trailer.PLACA; ddl_transportista.SelectedValue = trailer.TRAN_ID.ToString(); rb_propio.Checked = !trailer.EXTERNO; rb_externo.Checked = trailer.EXTERNO; ddl_tipo_carga.Enabled = true; txt_placaTracto.Enabled = true; txt_idSello.Enabled = true; txt_conductorRut.Enabled = true; chk_conductorExtranjero.Enabled = true; txt_conductorNombre.Enabled = true; txt_acomRut.Enabled = true; txt_doc2.Enabled = true; chk_vehiculoImportado.Enabled = false; txt_selloReferencia.Enabled = chk_vehiculoImportado.Checked; txt_conductorRut_TextChanged(null, null); utils.ShowMessage2(this, "buscarTrailer", "success"); } }
private void llenarForm(TrailerBC trailer) { hf_idTrailer.Value = trailer.ID.ToString(); txt_editPlaca.Text = trailer.PLACA; chk_editExterno.Checked = trailer.EXTERNO; cambia_interno(null, null); txt_editNumero.Text = trailer.NUMERO; ddl_editTran.SelectedValue = trailer.TRAN_ID.ToString(); ddl_editTipo.SelectedValue = trailer.TRTI_ID.ToString(); hf_excluyentes.Value = trailer.EXCLUYENTES; hf_noexcluyentes.Value = trailer.NO_EXCLUYENTES; ddl_editShorteck.SelectedValue = trailer.ID_SHORTEK; }
private void ObtenerPreIngresos(bool forzarBD) { if (ViewState["lista"] == null || forzarBD) { TrailerBC trailer = new TrailerBC(); DataTable dt = trailer.obtener_pre_ingresos(Convert.ToInt32(ddl_buscarSite.SelectedValue), Convert.ToInt32(ddl_buscarProveedor.SelectedValue), txt_buscarDesde.Text, txt_buscarHasta.Text); ViewState["lista"] = dt; } DataView dw = new DataView((DataTable)ViewState["lista"]); this.gv_listar.DataSource = dw.ToTable(); this.gv_listar.DataBind(); }
protected void txt_editPlaca_TextChanged(object sender, EventArgs e) { TrailerBC t = new TrailerBC(); t = t.obtenerXPlaca(this.txt_editPlaca.Text); if (t.ID != 0) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "mensaje", "alert('Trailer ya existe en la base de datos!');", true); this.txt_editPlaca.Text = ""; this.txt_editPlaca.Focus(); } utils.ShowMessage2(this, "buscarConductor", "warn_rutNovalido"); }
protected void gv_listar_RowEditing(object sender, GridViewEditEventArgs e) { TrailerBC t = new TrailerBC(); this.gv_listar.SelectedIndex = e.NewEditIndex; this.hf_idTrailer.Value = this.gv_listar.DataKeys[this.gv_listar.SelectedIndex].Value.ToString(); t = t.obtenerXID(int.Parse(this.hf_idTrailer.Value)); this.llenarForm(t); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "llenarForm", "llenarForm();", true); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "modal", "modalEditarTrailer();", true); }
public TrailerBC(int id) { this.ID = id; TrailerBC t = this.obtenerXID(); this.PLACA = t.PLACA; this.CODIGO = t.CODIGO; this.EXTERNO = t.EXTERNO; this.NUMERO = t.NUMERO; this.TRAN_ID = t.TRAN_ID; this.TRANSPORTISTA = t.TRANSPORTISTA; this.CARACTERISTICAS = t.CARACTERISTICAS; this.EXCLUYENTES = t.EXCLUYENTES; this.NO_EXCLUYENTES = t.NO_EXCLUYENTES; this.TRTI_ID = t.TRTI_ID; this.TIPO = t.TIPO; this.BLOQUEADO = t.BLOQUEADO; this.SITE_ID = t.SITE_ID; this.SITE_IN = t.SITE_IN; this.LUGAR_ID = t.LUGAR_ID; this.LUGAR = t.LUGAR; this.SOCA_ID = t.SOCA_ID; this.SOLI_ID = t.SOLI_ID; this.CARGADO = t.CARGADO; this.PROV_ID = t.PROV_ID; this.MOVI_ID = t.MOVI_ID; this.MOES_ID = t.MOES_ID; this.FECHA_INGRESO = t.FECHA_INGRESO; this.FECHA_RETIRO = t.FECHA_RETIRO; this.DOC_INGRESO = t.DOC_INGRESO; this.SELLO_INGRESO = t.SELLO_INGRESO; this.SELLO_CARGA = t.SELLO_CARGA; this.CHOFER_RUT = t.CHOFER_RUT; this.CHOFER_NOMBRE = t.CHOFER_NOMBRE; this.ACOMP_RUT = t.ACOMP_RUT; this.SOLI_ID = t.SOLI_ID; this.SOES_ID = t.SOES_ID; this.OBSERVACION = t.OBSERVACION; this.PATENTE_TRACTO = t.PATENTE_TRACTO; this.TRES_ID = t.TRES_ID; this.USUA_ID = t.USUA_ID; this.TCAR_ID = t.TCAR_ID; this.TIIC_ID = t.TIIC_ID; this.MOIC_ID = t.MOIC_ID; this.PRING_ID = t.PRING_ID; this.DEST_ID = t.DEST_ID; this.LOCA_ID = t.LOCA_ID; this.COND_ID = t.COND_ID; this.REQ_SELLO = t.REQ_SELLO; }
//private void CreaGrafico() //{ // string[] script = (string[])ViewState["script"]; // int cont = 0; // DataTable dt = (DataTable)ViewState["grafico"]; // foreach (DataRow dr in dt.Rows) // { // cont++; // ClientScript.RegisterStartupScript(this.GetType(), "grafico_" + dr["SITE_ID"].ToString(), script[cont], true); // //ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "grafico_" + dr["SITE_ID"].ToString(), script , true); // } //} private string CreaTablas() { DataSet ds = new DataSet(); TrailerBC t = new TrailerBC(); ds = t.CargaGrafico(); StringBuilder sb = new StringBuilder(); DataTable dtSites = ds.Tables[0]; ViewState["grafico"] = dtSites; int cont = 0; foreach (DataRow dr in dtSites.Rows) { sb.Append("<div class='col-xs-3'>"). Append("<div class='col-xs-12'>"). Append("<center>"). Append("<h4>"). Append(dr["SITE_DESC"].ToString()). Append("</h4>"). Append("</center>"); DataView dwSite = ds.Tables[1].AsDataView(); dwSite.RowFilter = "SITE_ID = " + dr["SITE_ID"].ToString(); DataTable dtSite = dwSite.ToTable(); sb.Append(CreaTablaSite(dtSite)); string datos = DatosGrafico(dtSite); string labels = LabelsGrafico(dtSite); string colores = ColoresGrafico(dtSite); sb.Append("</div>"). Append("<div class='col-xs-12 separador'>"). Append("</div>"). Append("<div class='col-xs-12'>"). Append("<canvas id='pieChart_"). Append(dr["SITE_ID"].ToString()). //Append("' width='200' height='200'>"). Append("' role='img'></canvas>"). Append("</div>"). Append("</div>"); hf_script.Value += "cargaGrafico(" + dr["SITE_ID"].ToString() + "," + datos + "," + labels + "," + colores + ");"; cont++; } DataTable dtRuta = ds.Tables[2]; lbl_ruta.Text = dtRuta.Rows[0]["CANTIDAD"].ToString(); cont++; //ViewState["script"] = script; hf_html.Value = sb.ToString(); return(sb.ToString()); }
protected void btn_editGrabar_Click(object sender, EventArgs e) { TrailerBC t = new TrailerBC(); t.PLACA = txt_editPlaca.Text; t.TRAN_ID = int.Parse(ddl_editTran.SelectedValue); if (t.CrearGenerico(t, extranjero.Checked)) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "mensaje", "showAlert('Trailer agregado correctamente.');", true); this.hf_idTrailer.Value = t.ID.ToString(); this.txt_buscarPatente.Text = t.PLACA; this.ddl_transportista.SelectedValue = t.TRAN_ID.ToString(); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "cerrar", "$('#modalTrailer').modal('hide');", true); } }
protected void btn_editGrabar_Click(object sender, EventArgs e) { TrailerBC t = new TrailerBC(); t.PLACA = this.txt_editPlaca.Text; t.TRAN_ID = Convert.ToInt32(this.ddl_editTran.SelectedValue); if (t.CrearGenerico(t, false)) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "mensaje", "alert('Trailer agregado correctamente.');", true); this.hf_idTrailer.Value = t.ID.ToString(); this.txt_buscarPatente.Text = t.PLACA; this.ddl_transportista.SelectedValue = t.TRAN_ID.ToString(); utils.CerrarModal(this, "modalTrailer"); } }