public IList<Core.Business.Annex> GetAllAnnex() { IList<Core.Business.Annex> annexlist = new List<Core.Business.Annex>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectAnnicesAll"); if (reader != null) { while (reader.Read()) { Core.Business.Annex annex = new Core.Business.Annex(); if (!reader.IsDBNull(0)) annex.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) annex.AnnexTypeID = reader.GetGuid(1); if (!reader.IsDBNull(2)) annex.ContentType = reader.GetInt32(2); if (!reader.IsDBNull(3)) annex.ContentID = reader.GetGuid(3); if (!reader.IsDBNull(4)) annex.Name = reader.GetString(4); if (!reader.IsDBNull(5)) annex.AnnexURI = reader.GetString(5); annex.MarkOld(); annexlist.Add(annex); } reader.Close(); } return annexlist; }
public List<Annex> SelectAnnexWhere(string sqlwhere) { List<Core.Business.Annex> annexlist = new List<Core.Business.Annex>(); SqlServerUtility sql = new SqlServerUtility(); string sqlstr = "SELECT * FROM [dbo].[Annex] where "; sqlstr += sqlwhere; SqlDataReader reader = sql.ExecuteSqlReader(sqlstr); if (reader != null && !reader.IsClosed) { while (reader.Read()) { Core.Business.Annex annex = new Core.Business.Annex(); if (!reader.IsDBNull(0)) annex.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) annex.AnnexTypeID = reader.GetGuid(1); if (!reader.IsDBNull(2)) annex.ContentType = reader.GetInt32(2); if (!reader.IsDBNull(3)) annex.ContentID = reader.GetGuid(3); if (!reader.IsDBNull(4)) annex.Name = reader.GetString(4); if (!reader.IsDBNull(5)) annex.AnnexURI = reader.GetString(5); annex.MarkOld(); annexlist.Add(annex); } reader.Close(); } return annexlist; }
public List<Annex> SelectAnnexByContentID(Guid guid) { List<Core.Business.Annex> annexlist = new List<Core.Business.Annex>(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@ContentID", SqlDbType.UniqueIdentifier, guid); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectAnnexByContentID"); if (reader != null && !reader.IsClosed) { while (reader.Read()) { Core.Business.Annex annex = new Core.Business.Annex(); if (!reader.IsDBNull(0)) annex.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) annex.AnnexTypeID = reader.GetGuid(1); if (!reader.IsDBNull(2)) annex.ContentType = reader.GetInt32(2); if (!reader.IsDBNull(3)) annex.ContentID = reader.GetGuid(3); if (!reader.IsDBNull(4)) annex.Name = reader.GetString(4); if (!reader.IsDBNull(5)) annex.AnnexURI = reader.GetString(5); annex.MarkOld(); annexlist.Add(annex); } reader.Close(); } return annexlist; }