public FieldSet GetFieldSet(Guid id) { string sql = "SELECT * FROM UFfieldsets where id = @id"; IRecordsReader rr = sqlHelper.ExecuteReader(sql, sqlHelper.CreateParameter("@id", id)); FieldSet fs = new FieldSet(); if (rr.Read()) { fs = FieldSet.CreateFromDataReader(rr); fs.Fields.AddRange(storage.GetAllFields(fs)); return(fs); } rr.Dispose(); return(fs); }
public List <FieldSet> GetAllFieldSets(Page page) { string sql = "SELECT * FROM UFfieldsets where page = @id ORDER BY sortorder ASC"; IRecordsReader rr = sqlHelper.ExecuteReader(sql, sqlHelper.CreateParameter("@id", page.Id)); List <FieldSet> l = new List <FieldSet>(); while (rr.Read()) { FieldSet fs = FieldSet.CreateFromDataReader(rr); fs.Fields.AddRange(storage.GetAllFields(fs)); l.Add(fs); } rr.Dispose(); return(l); }