private void Buscar() { int total = 0; try { IChofer chofer = ChoferFactory.GetChofer(); DsChofer ds = chofer.GetChoferesDataSet(); string filtro = "LegajoSITT LIKE '" + this.legajo + "%' AND Nombre LIKE '" + this.nombre + "%'"; DsChofer.DatosRow[] drLista = (DsChofer.DatosRow[])ds.Datos.Select(filtro); total = drLista.Length; if (total > 0) { if (total == 1) { DsChofer.DatosRow dr = drLista[0]; this.txtLegajo.Text = dr.LegajoSITT; this.txtNombre.Text = dr.Nombre; this.txtChoferID.Text = dr.ChoferID.ToString(); this.txtErrorMsg.Text = ""; this.txtOpen.Text = ""; this.txtSoloLectura.Text = this.soloLectura; } else { this.txtLegajo.Text = this.legajo; this.txtNombre.Text = this.nombre; this.txtOpen.Text = "S"; this.txtFiltro.Text = this.filtroEspecial; this.txtAgenciaActual.Text = this.agenciaActual; this.txtSoloLectura.Text = this.soloLectura; } } else { this.txtLegajo.Text = ""; this.txtChoferID.Text = ""; this.txtErrorMsg.Text = "No se encontraron datos."; this.txtOpen.Text = ""; this.txtSoloLectura.Text = this.soloLectura; } } catch (Exception ex) { this.txtErrorMsg.Text = "Error al consultar datos de agencias: " + ex.Message; } }
private void dtgChoferes_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { if (e.CommandName == "Select") { int indice = e.Item.DataSetIndex; BindGrid(); DsChofer.DatosRow[] drLista = (DsChofer.DatosRow[])dtgChoferes.DataSource; if (drLista == null) { return; } if (drLista.Length == 0) { return; } DsChofer.DatosRow dr = drLista[indice]; if (dr == null) { return; } string legajo = dr.LegajoSITT; string nombre = dr.Nombre; int choferID = dr.ChoferID; StringBuilder scriptString = new StringBuilder(); scriptString.Append("<script language='javascript'>\n"); scriptString.Append("window.dialogArguments.Legajo = '" + legajo.ToString() + "';\n"); scriptString.Append("window.dialogArguments.Nombre = '" + nombre + "';\n"); scriptString.Append("window.dialogArguments.ChoferID = '" + choferID + "';\n"); scriptString.Append("window.returnValue = true;\n"); scriptString.Append("window.close();\n"); scriptString.Append("</script>"); Page.RegisterClientScriptBlock("scriptModalChofer", scriptString.ToString()); } }
public void Consultar() { DsChofer ds = new DsChofer(); SqlParameter pChoferID = new SqlParameter("@ChoferID", this.ChoferID); if (ChoferID != 0) { Config.Conexion.LlenarTypeDataSet(ds.Datos, System.Data.CommandType.StoredProcedure, "ChoferONE", pChoferID); } if (ds.Datos.Rows.Count > 0) { DsChofer.DatosRow dr = (DsChofer.DatosRow)ds.Datos.Rows[0]; //if (dr.IsPrimerNombreNull()) this.Nombre = dr.IsNombreNull()?"": dr.Nombre.Trim(); //else //this.Nombre = dr.IsPrimerNombreNull()?"": dr.PrimerNombre; this.Apellido = dr.IsApellidoNull() ? "" : dr.Apellido; this.LegajoSITT = dr.LegajoSITT; } }