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