protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["usuario"] == null) { Response.Redirect("../InicioQYMS.aspx"); } usuario = (UsuarioBC)Session["usuario"]; CaractCargaBC catt = new CaractCargaBC(); TransportistaBC tran = new TransportistaBC(); TrailerTipoBC tipo = new TrailerTipoBC(); SiteBC site = new SiteBC(); DataTable dt = catt.obtenerTodo(); //rlcli.DataSource = dt; //rlcli.DataTextField = "DESCRIPCION"; //rlcli.DataValueField = "ID"; //rlcli.DataBind(); //utils.CargaCheck(this.chklst_editCaracteristicas, "ID", "DESCRIPCION", catt.obtenerTodo()); utils.CargaDrop(ddl_editTran, "ID", "NOMBRE", tran.ObtenerTodos()); utils.CargaDrop(ddl_editTipo, "ID", "DESCRIPCION", tipo.obtenerTodo()); utils.CargaDrop(ddl_buscarTransportista, "ID", "NOMBRE", tran.ObtenerTodos()); utils.CargaDrop(ddl_buscarTipo, "ID", "DESCRIPCION", tipo.obtenerTodo()); utils.CargaDropNormal(ddl_site, "ID", "NOMBRE", site.ObtenerTodos()); utils.CargaDrop(ddl_buscarMotivo, "ID", "NOMBRE", tran.ObtenerMotivoBloqueo("1")); ltl_contenidoCaract.Text = crearContenido(); ObtenerTrailer(true); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["usuario"] == null) { Response.Redirect("~/InicioQYMS2.aspx"); } usuario = (UsuarioBC)Session["Usuario"]; if (!IsPostBack) { CaractCargaBC catt = new CaractCargaBC(); TransportistaBC tran = new TransportistaBC(); TrailerTipoBC tipo = new TrailerTipoBC(); YMS_ZONA_BC yms = new YMS_ZONA_BC(); DataTable dt = catt.obtenerTodo(); CargaDrops c = new CargaDrops(); c.Proveedor_Todos(ddl_buscarProveedor); if (usuario.PROVEEDOR != "") { this.ddl_buscarProveedor.SelectedValue = usuario.ID_PROVEEDOR.ToString(); this.ddl_buscarProveedor.Enabled = false; } DataTable ds = yms.ObteneSites(((UsuarioBC)Session["Usuario"]).ID); utils.CargaDropNormal(this.ddl_buscarSite, "ID", "NOMBRE", ds); txt_buscarDesde.Text = DateTime.Now.ToShortDateString(); txt_buscarHasta.Text = DateTime.Now.ToShortDateString(); ObtenerPreIngresos(true); } }
private int obtenerId(string codigo) { CaractCargaBC cc = new CaractCargaBC(); cc = cc.obtenerSeleccionado(0, codigo); return(cc.ID); }
private void marca_seleccion() { CaractCargaBC cc = new CaractCargaBC(); DataTable dt = cc.caracteristicasdesdelocales(this.hf_localesSeleccionados.Value, this.hf_caractSolicitud.Value); int maxplancha = 6; int mincantidad = 32; int maxpallet = 0; foreach (DataRow dr in dt.Rows) { int orden = dr.Field <int>("ID"); if (dr.Field <int>("caract_ID") == 10) { maxplancha = Math.Max(maxplancha, orden); } if (dr.Field <int>("caract_ID") == 0) { mincantidad = Math.Min(mincantidad, orden); maxpallet = maxpallet + dr.Field <int>("valor"); } Session["MaxPallet"] = maxpallet; } chk_plancha.Checked = maxplancha.ToString().Equals("7");// 6 caca plancha falso ddl_largoMax.SelectedValue = mincantidad.ToString(); }
protected void btn_editGrabar_Click(object sender, EventArgs e) { CaractCargaBC caca = new CaractCargaBC(); caca.DESCRIPCION = txt_editDesc.Text; caca.VALOR = int.Parse(txt_editValor.Text); caca.CACT_ID = int.Parse(ddl_editTipo.SelectedValue); caca.CODIGO = txt_editCodigo.Text; if (hf_idCaractCarga.Value == "") { if (caca.Crear(caca)) { utils.ShowMessage2(this, "crear", "success"); utils.CerrarModal(this, "modalEdit"); } else { utils.ShowMessage2(this, "crear", "error"); } } else { caca.ID = int.Parse(hf_idCaractCarga.Value); if (caca.Modificar(caca)) { utils.ShowMessage2(this, "modificar", "success"); utils.CerrarModal(this, "modalEdit"); } else { utils.ShowMessage2(this, "modificar", "error"); } } ObtenerCaractCarga(true); }
internal string crearContenido() { CaractCargaBC c = new CaractCargaBC(); DataTable caract = c.obtenerTodoYTipos(); System.Text.StringBuilder strb = new System.Text.StringBuilder(); DataTable tipos = caract.DefaultView.ToTable(true, "CACT_ID", "CACT_DESC", "CACT_EXCLUYENTE"); foreach (DataRow row in tipos.Rows) { strb.Append("<div class='col-xs-3' id='menu_tipo_").Append(row["CACT_ID"].ToString()).Append("' style='margin-bottom:5px;'>"). Append(row["CACT_DESC"].ToString()). Append("<br />"); DataRow[] caracteristicas = caract.Select("CACT_ID = " + row["CACT_ID"].ToString()); if (row["CACT_EXCLUYENTE"].ToString() == "True") { strb.Append("<input name='check' id='caractTipo_").Append(row["CACT_ID"].ToString()).Append("' type='checkbox' value='").Append(row["CACT_ID"].ToString()). Append("'></input>"); } else { strb.Append("<select class='form-control' name='drop' id='caractTipo_").Append(row["CACT_ID"].ToString()).Append("' value='").Append(row["CACT_ID"].ToString()). Append("' >"); foreach (DataRow c1 in caracteristicas) { strb.Append("<option value='").Append(c1["CACA_ID"].ToString()).Append("' id='op_drop_").Append(c1["CACA_ID"].ToString()).Append("'>").Append(c1["CACA_DESC"].ToString()). Append("</option>"); } strb.Append("</select>"); } strb.Append("</div>"); //Append("</div>"); } return(strb.ToString()); }
private void marca_seleccion() { CaractCargaBC cc = new CaractCargaBC(); DataTable dt = cc.caracteristicasdesdelocales(this.hf_localesSeleccionados.Value, this.hf_caractSolicitud.Value); // this.chk_solFrio.Checked= Boolean.Parse( dt.Select("min(caca_orden) where caract_ID='20'")[0][0].ToString()); int maxplancha = 6; int mincantidad = 32; int maxpallet = 0; foreach (DataRow dr in dt.Rows) { int orden = dr.Field <int>("ID"); if (dr.Field <int>("caract_ID") == 10) { maxplancha = Math.Max(maxplancha, orden); } if (dr.Field <int>("caract_ID") == 0) { mincantidad = Math.Min(mincantidad, orden); maxpallet = maxpallet + dr.Field <int>("valor"); } this.Session["MaxPallet"] = maxpallet; } }
private void carga_playas() { this.carga_temperaturas(); CaractCargaBC cc = new CaractCargaBC(); DataTable dt = cc.obtenerplayasCompatibles(this.hf_localesSeleccionados.Value, this.hf_caractSolicitud.Value, Int32.Parse(this.dropsite.SelectedValue)); utils.CargaDrop(this.ddl_solPlaya, "PLAY_ID", "PLAY_DESC", dt); this.ddl_solPlaya_SelectedIndexChanged(null, null); }
private void carga_trailers() { try { ddl_id_shortrec2.Enabled = false; ddl_id_shortrec2.ClearSelection(); CaractCargaBC cc = new CaractCargaBC(); DataTable dt = cc.obtenertrailersCompatibles(this.hf_localesSeleccionados.Value, Convert.ToInt32(this.txt_totalPallets.Text), this.hf_caractSolicitud.Value, Convert.ToInt32(this.dropsite.SelectedValue)); this.ViewState["trailers"] = dt; string query = "SOLI_ID = 0"; if (this.ddl_idShortek.SelectedIndex > 0) { query += string.Format(" AND ID_SHORTEK = '{0}' ", this.ddl_idShortek.SelectedValue); DataTable dt2; try { dt2 = dt.Select(query).CopyToDataTable(); } catch (Exception ex3) { ddl_id_shortrec2.Enabled = true; dt2 = new DataTable(); } dt = dt2; } else { DataTable dt2 = dt.Select(query).CopyToDataTable(); dt = dt2; } try { utils.CargaDrop_patentes(this.ddl_trailers, "TRAI_ID", "TRAI_PATENTE", this.TopDataRow(dt, 20), null, "id_shortek", this.ddl_idShortek.SelectedValue); } catch (Exception) { ddl_id_shortrec2.Enabled = true; this.ddl_trailers.Items.Clear(); this.ddl_trailers.Items.Add(new ListItem("No Disponibles", "0")); } this.ddl_trailers.ClearSelection(); } catch (Exception ex) { } }
public void Page_Load(object sender, EventArgs e) { if (IsPostBack == false) { TransportistaBC tran = new TransportistaBC(); TrailerTipoBC tipo = new TrailerTipoBC(); utils.CargaDrop(ddl_editTran, "ID", "NOMBRE", tran.ObtenerTodos()); CaractCargaBC catt = new CaractCargaBC(); DataTable dt = catt.obtenerTodo(); // rlcli.DataSource = dt; // rlcli.DataTextField = "DESCRIPCION"; // rlcli.DataValueField = "ID"; // rlcli.DataBind(); } }
protected void btn_EliminarCaractCarga_Click(object sender, EventArgs e) { CaractCargaBC caca = new CaractCargaBC(); if (caca.Eliminar(int.Parse(hf_idCaractCarga.Value))) { utils.ShowMessage2(this, "eliminar", "success"); utils.CerrarModal(this, "modalConf"); } else { utils.ShowMessage2(this, "eliminar", "error"); } ObtenerCaractCarga(true); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { CargaTipoBC ct = new CargaTipoBC(); ShorteckBC sh = new ShorteckBC(); YMS_ZONA_BC yms = new YMS_ZONA_BC(); DataTable ds = yms.ObteneSites(((UsuarioBC)Session["Usuario"]).ID); utils.CargaDropNormal(this.DDL_SITE, "ID", "NOMBRE", ds); TrailerEstadoBC estadobc = new TrailerEstadoBC(); CaractCargaBC car = new CaractCargaBC(); utils.CargaDropTodos(DDL_disponibilidad, "ID", "NOMBRE", estadobc.ObtenerTodosSTOCK()); utils.CargaDropTodos(this.ddl_capacidad, "ID", "DESCRIPCION", car.obtenerXTipo(0)); utils.CargaDropTodos(this.ddl_tipocarga, "ID", "DESCRIPCION", ct.obtenerTodo()); utils.CargaDropTodos(this.ddl_shortec, "SHOR_ID", "SHOR_DESC", sh.ObtenerTodos()); } }
protected void gv_listaLocal_RowEditing(object sender, GridViewEditEventArgs e) { ViewState.Remove("datosA"); LocalBC local = new LocalBC(); ComunaBC comuna = new ComunaBC(); CaractCargaBC caracteristica = new CaractCargaBC(); DataTable dt = new DataTable(); gv_listar.SelectedIndex = e.NewEditIndex; hf_idLocal.Value = this.gv_listar.SelectedDataKey.Value.ToString(); local = local.obtenerXID(int.Parse(hf_idLocal.Value)); txt_editCodigo.Text = local.CODIGO; txt_editDesc.Text = local.DESCRIPCION; txt_editDireccion.Text = local.DIRECCION; ddl_editRegion.SelectedValue = local.REGION_ID.ToString(); hf_caracteristicasLocal.Value = local.EXCLUYENTES; hf_excluyentes.Value = local.EXCLUYENTES; hf_noexcluyentes.Value = local.NO_EXCLUYENTES; dt = caracteristica.obtenerXLocal(int.Parse(hf_idLocal.Value)); ViewState["datosA"] = dt; if (local.INTERNOS == 0) { chk_editInternos.Checked = false; } else { chk_editInternos.Checked = true; } if (local.EXTERNOS == 0) { chk_editExternos.Checked = false; } else { chk_editExternos.Checked = true; } ddl_editRegion_IndexChanged(null, null); if (ddl_editRegion.SelectedIndex != 0) { utils.CargaDrop(ddl_editComuna, "ID", "NOMBRE", comuna.obtenerComunasXRegion(int.Parse(ddl_editRegion.SelectedValue))); ddl_editComuna.SelectedValue = local.COMUNA_ID.ToString(); } ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "llenarForm", "llenarForm();", true); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "modal", "modalEditarLocal();", true); }
private void CargaDrops() { YMS_ZONA_BC yms = new YMS_ZONA_BC(); CaractCargaBC car = new CaractCargaBC(); ShorteckBC sh = new ShorteckBC(); DataTable dt; dt = yms.ObteneSites(usuario.ID); utils.CargaDropNormal(dropsite, "ID", "NOMBRE", dt); dt = car.obtenerXTipo(30); utils.CargaDrop(ddl_solTemp, "ID", "DESCRIPCION", dt); dt = car.obtenerXTipo(0); utils.CargaDrop(ddl_largoMax, "ID", "DESCRIPCION", dt); dt = sh.ObtenerTodos(); utils.CargaDrop(ddl_idShortek, "SHOR_ID", "SHOR_DESC", dt); utils.CargaDrop(ddl_id_shortrec2, "SHOR_ID", "SHOR_DESC", dt); }
protected void ObtenerCaractCarga(bool forzarBD) { if (ViewState["lista"] == null || forzarBD) { CaractCargaBC caca = new CaractCargaBC(); int cact_id = Convert.ToInt32(ddl_buscarTipo.SelectedValue); DataTable dt = caca.obtenerXParametro(txt_buscarDescripcion.Text, txt_buscarCodigo.Text, cact_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(); }
private string LocalesCompatibles(string seleccionados, string caracteristicas) { string compatibles = ""; CaractCargaBC cc = new CaractCargaBC(); DataTable dt = cc.obtenerCompatibles(seleccionados, caracteristicas); bool primero = true; foreach (DataRow dr in dt.Rows) { if (!primero) { compatibles += ","; } compatibles += dr[0].ToString(); primero = false; } return(compatibles); }
private void locales_Compatibles() { CaractCargaBC cc = new CaractCargaBC(); DataTable dt = cc.obtenerCompatibles(this.hf_localesSeleccionados.Value, this.hf_caractSolicitud.Value); bool primero = true; string compatibles = ""; foreach (DataRow dr in dt.Rows) { if (primero) { compatibles += dr[0].ToString(); primero = false; } else { compatibles += string.Format(",{0}", dr[0].ToString()); } } this.hf_localesCompatibles.Value = compatibles; }
protected void gv_listar_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "ELIMINAR") { Limpiar(); hf_idCaractCarga.Value = e.CommandArgument.ToString(); utils.AbrirModal(this, "modalConf"); } if (e.CommandName == "MODIFICAR") { CaractCargaBC cc = new CaractCargaBC(); Limpiar(); hf_idCaractCarga.Value = e.CommandArgument.ToString(); cc.ID = Convert.ToInt32(e.CommandArgument); cc = cc.obtenerSeleccionado(); txt_editCodigo.Text = cc.CODIGO.ToString(); txt_editDesc.Text = cc.DESCRIPCION; txt_editValor.Text = cc.VALOR.ToString(); ddl_editTipo.SelectedValue = cc.CACT_ID.ToString(); utils.AbrirModal(this, "modalEdit"); } }
private int CantMaxPallets(string seleccionados, string caracteristicas) { CaractCargaBC cc = new CaractCargaBC(); DataTable dt = cc.caracteristicasdesdelocales(seleccionados, caracteristicas); int maxplancha = 6; int mincantidad = 32; int maxpallet = 0; foreach (DataRow dr in dt.Rows) { int orden = dr.Field <int>("ID"); if (dr.Field <int>("caract_ID") == 10) { maxplancha = Math.Max(maxplancha, orden); } if (dr.Field <int>("caract_ID") == 0) { mincantidad = Math.Min(mincantidad, orden); maxpallet = maxpallet + dr.Field <int>("valor"); } } return(maxpallet); }
public bool Crear(CaractCargaBC trailer) { return(tran.CaractCarga_Crear(trailer)); }
protected void Page_Load(object sender, EventArgs e) { if (this.Session["usuario"] == null) { this.Response.Redirect("~/InicioQYMS2.aspx"); } this.usuario = (UsuarioBC)this.Session["usuario"]; SolicitudBC sol = new SolicitudBC(); CaractCargaBC car = new CaractCargaBC(); ShorteckBC sh = new ShorteckBC(); if (!this.IsPostBack) { this.volver.Visible = false; sol.ID_TIPO = 1; sol.FECHA_CREACION = DateTime.Now; this.txt_solHora.Text = DateTime.Now.AddMinutes(63).ToShortTimeString(); YMS_ZONA_BC yms = new YMS_ZONA_BC(); utils.CargaDropNormal(this.dropsite, "ID", "NOMBRE", yms.ObteneSites(this.usuario.ID)); utils.CargaDrop(this.ddl_solTemp, "ID", "DESCRIPCION", car.obtenerXTipo(30)); utils.CargaDrop(this.ddl_largoMax, "ID", "DESCRIPCION", car.obtenerXTipo(0)); // utils.CargaDropTodos(this.ddl_idShortek, "SHOR_ID", "SHOR_DESC", sh.ObtenerTodos()); ddl_idShortek.DataSource = sh.ObtenerTodos(); ddl_idShortek.DataTextField = "SHOR_DESC"; ddl_idShortek.DataValueField = "SHOR_ID"; ddl_idShortek.DataBind(); ddl_idShortek.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Seleccione", "0")); ddl_idShortek.SelectedValue = "0"; ddl_id_shortrec2.DataSource = sh.ObtenerTodos(); ddl_id_shortrec2.DataTextField = "SHOR_DESC"; ddl_id_shortrec2.DataValueField = "SHOR_ID"; ddl_id_shortrec2.DataBind(); ddl_id_shortrec2.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Seleccione", "0")); ddl_id_shortrec2.SelectedValue = "0"; this.txt_solFecha.Text = DateTime.Now.AddMinutes(63).ToShortDateString(); this.ddl_solTemp.ClearSelection(); this.ddl_largoMax.ClearSelection(); this.LimpiarLocales(); if (this.Request.Params["type"] != null) { TrailerBC trailer = new TrailerBC(); CaractCargaBC cc = new CaractCargaBC(); this.hf_soliId.Value = this.Request.Params["id"].ToString(); this.btn_limpiarDatos.Visible = false; this.txt_solNumero.Text = this.hf_soliId.Value; sol = sol.ObtenerXId(int.Parse(this.hf_soliId.Value)); this.hf_localesSeleccionados.Value = sol.LOCALES; this.txt_totalPallets.Text = sol.Pallets.ToString(); this.txt_ruta.Text = sol.RUTA; this.ddl_idShortek.SelectedValue = sol.ID_SHORTECK; this.hf_timeStamp.Value = sol.TIMESTAMP.ToString(); this.volver.Visible = true; string[] caract = sol.CARACTERISTICAS.Split(",".ToCharArray()); foreach (string c in caract) { if (c != "") { cc = cc.obtenerSeleccionado(int.Parse(c)); switch (cc.CODIGO) { case "CCF": this.chk_solFrio.Checked = true; break; case "CCS": this.chk_solSeco.Checked = true; break; case "CCC": this.chk_solCongelado.Checked = true; break; case "CCMF": this.chk_solMultifrio.Checked = true; break; case "CCCP": this.chk_plancha.Checked = true; break; case "CCWAY": this.chk_solWays.Checked = true; break; } } } this.chk_solMultifrio.Enabled = false; this.chk_solCongelado.Enabled = false; this.chk_solSeco.Enabled = false; this.chk_solFrio.Enabled = false; this.dropsite.Enabled = false; this.txt_solFecha.Enabled = false; this.txt_solHora.Enabled = false; SolicitudAndenesBC sa = new SolicitudAndenesBC(); sa.ObtenerTodo(sol.SOLI_ID); this.ObtenerLocalesSolicitud(true); this.stringCaractSolicitud(); this.carga_playas(); if (sol.TETR_ID != 0) { this.DDL_TEMP.SelectedValue = sol.TETR_ID.ToString(); } trailer = trailer.obtenerXID(sol.ID_TRAILER); this.txt_trailerPatente.Text = trailer.PLACA; this.calcula_solicitud(null, null); this.btn_buscarTrailer_Click(null, null); if (this.hf_traiId.Value != "0" && sol.SOES_ID > 101) { this.visiblasignamanual.Enabled = false; } } } this.visiblasignamanual.Visible = false; }
protected void Page_Load(object sender, EventArgs e) { if (Session["usuario"] == null) { Response.Redirect("~/InicioQYMS2.aspx"); } usuario = (UsuarioBC)Session["usuario"]; if (!IsPostBack) { SolicitudBC sol = new SolicitudBC(); CargaDrops(); volver.Visible = false; sol.ID_TIPO = 1; sol.FECHA_CREACION = DateTime.Now; txt_solHora.Text = DateTime.Now.AddMinutes(63).ToShortTimeString(); txt_solFecha.Text = DateTime.Now.AddMinutes(63).ToShortDateString(); ddl_solTemp.ClearSelection(); ddl_largoMax.ClearSelection(); LimpiarLocales(); ddl_idShortek.Enabled = true; string request = Request.Params["type"]; if (request == "devolucion") { hf_devoId.Value = Request.Params["id"].ToString(); DevolucionBC dev = new DevolucionBC().ObtenerXId(Convert.ToInt32(hf_devoId.Value)); hf_soliId.Value = dev.SOLI_ID_DEVOLUCION.ToString(); hf_traiIdOld.Value = dev.TRAI_ID.ToString(); CaractCargaBC cc = new CaractCargaBC(); ddl_idShortek.Enabled = false; btn_limpiarDatos.Visible = false; sol = sol.ObtenerFinalizadaXId(Convert.ToInt32(hf_soliId.Value)); dropsite.SelectedValue = sol.ID_SITE.ToString(); drop_SelectedIndexChanged(null, null); hf_localesSeleccionados.Value = sol.LOCALES; txt_totalPallets.Text = sol.Pallets.ToString(); txt_ruta.Text = sol.RUTA; ddl_idShortek.SelectedValue = sol.ID_SHORTECK; hf_timeStamp.Value = sol.TIMESTAMP.ToString(); volver.Visible = true; volver2.Visible = false; string[] caract = sol.CARACTERISTICAS.Split(",".ToCharArray()); foreach (string c in caract) { if (c != "") { cc = cc.obtenerSeleccionado(Convert.ToInt32(c)); switch (cc.CODIGO) { case "CCF": chk_solFrio.Checked = true; break; case "CCS": chk_solSeco.Checked = true; break; case "CCC": chk_solCongelado.Checked = true; break; case "CCMF": chk_solMultifrio.Checked = true; break; case "CCCP": chk_plancha.Checked = true; break; case "CCWAY": chk_solWays.Checked = true; break; } } } chk_frio_CheckedChanged(null, null); chk_solMultifrio.Enabled = false; chk_solCongelado.Enabled = false; chk_solSeco.Enabled = false; chk_solFrio.Enabled = false; chk_solWays.Enabled = false; dropsite.Enabled = false; ObtenerLocalesSolicitud(true); DataTable dsol = (DataTable)ViewState["locales"]; carga_playas(); ddl_solPlaya.SelectedValue = new LugarBC().obtenerXID(Convert.ToInt32(dsol.Rows[0]["LUGA_ID"])).ID_PLAYA.ToString(); // dsol.Rows[0]["id_playa"].ToString() ; ddl_solPlaya_SelectedIndexChanged(null, null); if (sol.TETR_ID != 0) { DDL_TEMP.SelectedValue = sol.TETR_ID.ToString(); } if (sol.ID_TRAILER != 0) { TrailerBC t = new TrailerBC().obtenerXID(sol.ID_TRAILER); hf_traiId.Value = t.ID.ToString(); txt_trailerPatente.Text = t.PLACA; txt_trailerNro.Text = t.NUMERO; txt_trailerShortek.Text = t.ID_SHORTEK; // txt_trailerTransporte.Text = t.TRANSPORTISTA; txt_trailerTransporte_1.Text = t.PLACA; } calcula_solicitud(null, null); } } visibleasignamovilmanual(null, null); }
internal void crearContenido() { CaractCargaBC c = new CaractCargaBC(); DataTable caract = c.obtenerTodoYTipos(); //System.Text.StringBuilder strb = new System.Text.StringBuilder(); DataTable tipos = caract.DefaultView.ToTable(true, "CACT_ID", "CACT_DESC", "CACT_EXCLUYENTE"); Panel p = new Panel(); foreach (DataRow row in tipos.Rows) { Panel pnl_caract = new Panel(); pnl_caract.ID = "menu_tipo_" + row["CACT_ID"].ToString(); pnl_caract.Style.Add("margin-bottom", "5px"); pnl_caract.CssClass = "col-xs-3"; Literal ltl_caract = new Literal(); ltl_caract.Text = row["CACT_DESC"].ToString() + "<br />"; pnl_caract.Controls.Add(ltl_caract); //strb.Append("<div class='col-xs-3' id='menu_tipo_"). // Append(row["CACT_ID"].ToString()). // Append("' style='margin-bottom:5px;'>"). // Append(row["CACT_DESC"].ToString()). // Append("<br />"); DataRow[] caracteristicas = caract.Select("CACT_ID = " + row["CACT_ID"].ToString()); if (row["CACT_EXCLUYENTE"].ToString() == "True") { CheckBox chk_caract = new CheckBox(); chk_caract.ID = "caractTipo_" + row["CACT_ID"].ToString(); chk_caract.Attributes.Add("value", row["CACT_ID"].ToString()); chk_caract.Attributes.Add("name", "check"); chk_caract.CssClass = "check"; chk_caract.ClientIDMode = ClientIDMode.Static; pnl_caract.Controls.Add(chk_caract); //strb.Append("<input name='check' id='caractTipo_"). // Append(row["CACT_ID"].ToString()). // Append("' type='checkbox' value='"). // Append(row["CACT_ID"].ToString()). // Append("'></input>"); } else { DropDownList ddl_caract = new DropDownList(); ddl_caract.ID = "caractTipo_" + row["CACT_ID"].ToString(); ddl_caract.Attributes.Add("value", row["CACT_ID"].ToString()); //ddl_caract.Attributes.Add("name", "drop"); ddl_caract.CssClass = "drop form-control"; ddl_caract.ClientIDMode = ClientIDMode.Static; ListItem li = new ListItem(); li.Attributes.Add("id", "op_drop_0"); li.Text = "No Aplica"; li.Value = "0"; if (row["CACT_ID"].ToString() != "0") { ddl_caract.Items.Add(li); } //strb.Append("<select name='drop' class='form-control' id='caractTipo_"). // Append(row["CACT_ID"].ToString()). // Append("' value='"). // Append(row["CACT_ID"].ToString()). // Append("' >"). // Append("<option value='0' >No Aplica</option>"); foreach (DataRow c1 in caracteristicas) { li = new ListItem(); li.Attributes.Add("id", "op_drop_" + c1["CACA_ID"].ToString()); li.Text = c1["CACA_DESC"].ToString(); li.Value = c1["CACA_ID"].ToString(); ddl_caract.Items.Add(li); //strb.Append("<option value='"). // Append(c1["CACA_ID"].ToString()). // Append("' id='op_drop_"). // Append(c1["CACA_ID"].ToString()). // Append("'>"). // Append(c1["CACA_DESC"].ToString()). // Append("</option>"); } pnl_caract.Controls.Add(ddl_caract); //strb.Append("</select>"); } p.Controls.Add(pnl_caract); //panel_caract.Controls.Add(pnl_caract); //strb.Append("</div>"); } Session["panel"] = p; }
public bool Modificar(CaractCargaBC trailer) { return(tran.CaractCarga_Modificar(trailer)); }
protected void Page_Load(object sender, EventArgs e) { if (Session["usuario"] == null) { Response.Redirect("~/InicioQYMS2.aspx"); } usuario = (UsuarioBC)Session["usuario"]; if (!this.IsPostBack) { SolicitudBC sol = new SolicitudBC(); CargaDrops(); volver.Visible = false; sol.ID_TIPO = 1; sol.FECHA_CREACION = DateTime.Now; txt_solHora.Text = DateTime.Now.AddMinutes(63).ToShortTimeString(); txt_solFecha.Text = DateTime.Now.AddMinutes(63).ToShortDateString(); ddl_solTemp.ClearSelection(); ddl_largoMax.ClearSelection(); LimpiarLocales(); ddl_idShortek.Enabled = true; string request = Request.Params["type"]; if (request != null && request == "edit") { CaractCargaBC cc = new CaractCargaBC(); SolicitudAndenesBC sa = new SolicitudAndenesBC(); TrailerBC trailer; DataTable dsol; ddl_idShortek.Enabled = false; hf_soliId.Value = Request.Params["id"].ToString(); btn_limpiarDatos.Visible = false; txt_solNumero.Text = this.hf_soliId.Value; sol = sol.ObtenerXId(Convert.ToInt32(hf_soliId.Value)); dropsite.SelectedValue = sol.ID_SITE.ToString(); drop_SelectedIndexChanged(null, null); hf_localesSeleccionados.Value = sol.LOCALES; txt_totalPallets.Text = sol.Pallets.ToString(); txt_ruta.Text = sol.RUTA; ddl_idShortek.SelectedValue = sol.ID_SHORTECK; hf_timeStamp.Value = sol.TIMESTAMP.ToString(); volver.Visible = true; volver2.Visible = false; string[] caract = sol.CARACTERISTICAS.Split(",".ToCharArray()); foreach (string c in caract) { if (c != "") { cc = cc.obtenerSeleccionado(Convert.ToInt32(c)); switch (cc.CODIGO) { case "CCF": chk_solFrio.Checked = true; break; case "CCS": chk_solSeco.Checked = true; break; case "CCC": chk_solCongelado.Checked = true; break; case "CCMF": chk_solMultifrio.Checked = true; break; case "CCCP": chk_plancha.Checked = true; break; case "CCWAY": chk_solWays.Checked = true; break; } } } chk_frio_CheckedChanged(null, null); chk_solMultifrio.Enabled = false; chk_solCongelado.Enabled = false; chk_solSeco.Enabled = false; chk_solFrio.Enabled = false; chk_solWays.Enabled = false; dropsite.Enabled = false; txt_solFecha.Enabled = false; txt_solHora.Enabled = false; ObtenerLocalesSolicitud(true); dsol = (DataTable)ViewState["locales"]; carga_playas(); ddl_solPlaya.SelectedValue = new LugarBC().obtenerXID(Convert.ToInt32(dsol.Rows[0]["LUGA_ID"])).ID_PLAYA.ToString(); // dsol.Rows[0]["id_playa"].ToString() ; ddl_solPlaya_SelectedIndexChanged(null, null); if (sol.TETR_ID != 0) { DDL_TEMP.SelectedValue = sol.TETR_ID.ToString(); } if (sol.ID_TRAILER != 0) { trailer = new TrailerBC().obtenerXID(sol.ID_TRAILER); 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; } calcula_solicitud(null, null); if (hf_traiId.Value != "" && sol.SOES_ID > 101) { visiblasignamanual.Enabled = false; } } if (request != null && request == "new") { TrailerBC trailer = new TrailerBC(); CaractCargaBC cc = new CaractCargaBC(); string trai_id = this.Request.Params["trai_id"]; ddl_idShortek.Enabled = false; btn_limpiarDatos.Visible = false; txt_solNumero.Text = ""; hf_localesSeleccionados.Value = sol.LOCALES; txt_totalPallets.Text = "0"; txt_ruta.Text = "Ways"; ddl_idShortek.SelectedValue = "0"; hf_timeStamp.Value = DateTime.Now.ToString(); volver.Visible = false; volver2.Visible = true; chk_solWays.Checked = true; chk_solMultifrio.Enabled = false; chk_solCongelado.Enabled = false; chk_solSeco.Enabled = false; chk_solFrio.Enabled = false; dropsite.Enabled = false; string resultado = ""; DataTable dsol = sol.ObtenerAndenesXNewWays(trai_id, out resultado); ViewState["datosA"] = dsol; gv_solLocales.DataSource = dsol; gv_solLocales.DataBind(); stringCaractSolicitud(); carga_playas(); LugarBC lugar = new LugarBC(); lugar = lugar.obtenerXID(Convert.ToInt32(dsol.Rows[0]["luga_id"].ToString())); ddl_solPlaya.SelectedValue = lugar.ID_PLAYA.ToString(); // dsol.Rows[0]["id_playa"].ToString() ; ddl_solPlaya_SelectedIndexChanged(null, null); trailer = trailer.obtenerXID(Convert.ToInt32(trai_id)); txt_trailerPatente.Text = trailer.PLACA; calcula_solicitud(null, null); ddl_trailers.Enabled = false; txt_trailerNro.Enabled = false; txt_trailerPatente.Enabled = false; btn_buscarTrailer.Enabled = false; btn_buscarTrailer_Click(null, null); } } visibleasignamovilmanual(); }