public List <eFormularioCampo> GetList(short IdFormulario) { SqlCommand cmd = new SqlCommand("pCMS_FormularioCampo_list"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@IdFormulario", SqlDbType.SmallInt).Value = IdFormulario; SqlDataReader reader = ExecuteReader(cmd); List <eFormularioCampo> lista = new List <eFormularioCampo>(); while (reader.Read()) { eFormularioCampo oFormularioCampo = new eFormularioCampo(); oFormularioCampo.IdCampo = reader.GetInt32(0); oFormularioCampo.Descripcion = reader.GetString(1); oFormularioCampo.Alias = ((!reader[2].Equals(DBNull.Value)) ? reader.GetString(2) : ""); oFormularioCampo.TipoControl = reader.GetByte(3); oFormularioCampo.Opciones = ((!reader[4].Equals(DBNull.Value)) ? reader.GetString(4) : ""); oFormularioCampo.Activo = reader.GetBoolean(5); lista.Add(oFormularioCampo); } reader.Close(); return(lista); }
protected void grvRegistroCampo_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { eFormularioCampo oCampo = cFormulario.FormularioCampo_item(((eRegistroCampo)e.Row.DataItem).IdCampo); if (oCampo.TipoControl == 4 && e.Row.Cells[1].Text != "") { e.Row.Cells[1].Text = "[<a target='_blank' href='" + e.Row.Cells[1].Text + "'><strong>Descargar</strong></a>]"; } } }
public eFormularioCampo GetItem(int IdCampo) { SqlCommand cmd = new SqlCommand("pCMS_FormularioCampo_select"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@IdCampo", SqlDbType.Int).Value = IdCampo; SqlDataReader reader = ExecuteReader(cmd); eFormularioCampo oFormularioCampo = null; if (reader.Read()) { oFormularioCampo = new eFormularioCampo(); oFormularioCampo.IdCampo = reader.GetInt32(0); oFormularioCampo.Descripcion = reader.GetString(1); oFormularioCampo.Alias = ((!reader[2].Equals(DBNull.Value)) ? reader.GetString(2) : ""); oFormularioCampo.TipoControl = reader.GetByte(3); oFormularioCampo.Opciones = ((!reader[4].Equals(DBNull.Value)) ? reader.GetString(4) : ""); oFormularioCampo.Activo = reader.GetBoolean(5); } reader.Close(); return(oFormularioCampo); }