public IList<Core.Business.Link> GetAllLinkByClass(Guid classId)
{
IList<Core.Business.Link> linklist = new List<Core.Business.Link>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@LinkClass", SqlDbType.UniqueIdentifier, classId);
SqlDataReader reader = sql.ExecuteSPReader("usp_SelectLinksByLinkClass");
if (reader != null)
{
while (reader.Read())
{
Core.Business.Link link = new Core.Business.Link();
if (!reader.IsDBNull(0)) link.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) link.Type = reader.GetInt32(1);
if (!reader.IsDBNull(2)) link.Unit = reader.GetGuid(2);
if (!reader.IsDBNull(3)) link.LinkClass = reader.GetGuid(3);
if (!reader.IsDBNull(4)) link.Name = reader.GetString(4);
if (!reader.IsDBNull(5)) link.URL = reader.GetString(5);
if (!reader.IsDBNull(6)) link.Des = reader.GetString(6);
if (!reader.IsDBNull(7)) link.PicURI = reader.GetString(7);
if (!reader.IsDBNull(8)) link.Index = reader.GetInt32(8);
link.MarkOld();
linklist.Add(link);
}
reader.Close();
}
return linklist;
}
public Core.Business.Link Select(Guid id)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Id", SqlDbType.UniqueIdentifier, id);
SqlDataReader reader = sql.ExecuteSPReader("usp_SelectLink");
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.Link link = new Core.Business.Link();
if (!reader.IsDBNull(0)) link.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) link.Type = reader.GetInt32(1);
if (!reader.IsDBNull(2)) link.Unit = reader.GetGuid(2);
if (!reader.IsDBNull(3)) link.LinkClass = reader.GetGuid(3);
if (!reader.IsDBNull(4)) link.Name = reader.GetString(4);
if (!reader.IsDBNull(5)) link.URL = reader.GetString(5);
if (!reader.IsDBNull(6)) link.Des = reader.GetString(6);
if (!reader.IsDBNull(7)) link.PicURI = reader.GetString(7);
if (!reader.IsDBNull(8)) link.Index = reader.GetInt32(8);
reader.Close();
return link;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
