public IList<Core.Business.NewsPhoto> GetAllNewsPhoto() { IList<Core.Business.NewsPhoto> newsPhotolist = new List<Core.Business.NewsPhoto>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectNewsPhotosAll"); if(reader != null) { while(reader.Read()) { Core.Business.NewsPhoto newsPhoto = new Core.Business.NewsPhoto(); if (!reader.IsDBNull(0)) newsPhoto.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) newsPhoto.Title = reader.GetString(1); if (!reader.IsDBNull(2)) newsPhoto.PhotoSrc = reader.GetString(2); if (!reader.IsDBNull(3)) newsPhoto.Author = reader.GetString(3); if (!reader.IsDBNull(4)) newsPhoto.AddDate = reader.GetDateTime(4); if (!reader.IsDBNull(5)) newsPhoto.ContentUrl = reader.GetString(5); if (!reader.IsDBNull(6)) newsPhoto.Status = reader.GetInt32(6); if (!reader.IsDBNull(7)) newsPhoto.ContentID = reader.GetGuid(7); newsPhoto.MarkOld(); newsPhotolist.Add(newsPhoto); } reader.Close(); } return newsPhotolist; }
public Core.Business.NewsPhoto Select(Guid id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Id", SqlDbType.UniqueIdentifier, id); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectNewsPhoto"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.NewsPhoto newsPhoto = new Core.Business.NewsPhoto(); if (!reader.IsDBNull(0)) newsPhoto.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) newsPhoto.Title = reader.GetString(1); if (!reader.IsDBNull(2)) newsPhoto.PhotoSrc = reader.GetString(2); if (!reader.IsDBNull(3)) newsPhoto.Author = reader.GetString(3); if (!reader.IsDBNull(4)) newsPhoto.AddDate = reader.GetDateTime(4); if (!reader.IsDBNull(5)) newsPhoto.ContentUrl = reader.GetString(5); if (!reader.IsDBNull(6)) newsPhoto.Status = reader.GetInt32(6); if (!reader.IsDBNull(7)) newsPhoto.ContentID = reader.GetGuid(7); reader.Close(); return newsPhoto; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public IEnumerable<NewsPhoto> Search(NewsPhotoJson json) { try { if (json == null) throw new ArgumentNullException(" json is null "); IList<Core.Business.NewsPhoto> newsPhotolist = new List<Core.Business.NewsPhoto>(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@module", SqlDbType.UniqueIdentifier, json.Module.Value); SqlDataReader reader = sql.ExecuteSqlReader(Sql_Search); if (reader != null) { while (reader.Read()) { Core.Business.NewsPhoto newsPhoto = new Core.Business.NewsPhoto(); if (!reader.IsDBNull(0)) newsPhoto.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) newsPhoto.Title = reader.GetString(1); if (!reader.IsDBNull(2)) newsPhoto.PhotoSrc = reader.GetString(2); if (!reader.IsDBNull(3)) newsPhoto.Author = reader.GetString(3); if (!reader.IsDBNull(4)) newsPhoto.AddDate = reader.GetDateTime(4); if (!reader.IsDBNull(5)) newsPhoto.ContentUrl = reader.GetString(5); if (!reader.IsDBNull(6)) newsPhoto.Status = reader.GetInt32(6); if (!reader.IsDBNull(7)) newsPhoto.ContentID = reader.GetGuid(7); newsPhoto.MarkOld(); newsPhotolist.Add(newsPhoto); } reader.Close(); } return newsPhotolist; } catch (Exception ex) { throw ex; } }
public IList<NewsPhoto> SelectNewsPhotosDynamic(string sqlwhere) { IList<Core.Business.NewsPhoto> newsPhotolist = new List<Core.Business.NewsPhoto>(); SqlServerUtility sql = new SqlServerUtility(); StringBuilder sbOrderExpression = new StringBuilder(); sbOrderExpression.Append("[AddDate] desc"); sql.AddParameter("@WhereCondition", SqlDbType.NVarChar, sqlwhere); sql.AddParameter("@OrderByExpression", SqlDbType.NVarChar, sbOrderExpression.ToString()); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectNewsPhotosDynamic"); if (reader != null) { while (reader.Read()) { Core.Business.NewsPhoto newsPhoto = new Core.Business.NewsPhoto(); if (!reader.IsDBNull(0)) newsPhoto.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) newsPhoto.Title = reader.GetString(1); if (!reader.IsDBNull(2)) newsPhoto.PhotoSrc = reader.GetString(2); if (!reader.IsDBNull(3)) newsPhoto.Author = reader.GetString(3); if (!reader.IsDBNull(4)) newsPhoto.AddDate = reader.GetDateTime(4); if (!reader.IsDBNull(5)) newsPhoto.ContentUrl = reader.GetString(5); if (!reader.IsDBNull(6)) newsPhoto.Status = reader.GetInt32(6); if (!reader.IsDBNull(7)) newsPhoto.ContentID = reader.GetGuid(7); newsPhoto.MarkOld(); newsPhotolist.Add(newsPhoto); } reader.Close(); } return newsPhotolist; }
public IEnumerable<NewsPhoto> Search(NewsPhotoJson json, PagingInfo pageinfo) { if (json == null || pageinfo == null) throw new ArgumentNullException("json and pageinfo is null "); IList<Core.Business.NewsPhoto> newsPhotolist = new List<Core.Business.NewsPhoto>(); SqlServerUtility sql = new SqlServerUtility(); if (json.Module != null && json.Module.HasValue && json.Module.Value != Guid.Empty) { sql.AddParameter("@module", SqlDbType.UniqueIdentifier, json.Module); } sql.AddParameter("@pagesize", SqlDbType.Int, pageinfo.PageSize); sql.AddParameter("@pageindex", SqlDbType.Int, pageinfo.CurrentPage); SqlDataReader reader = sql.ExecuteSPReader("usp_SearchNewsPhoto"); if (reader != null) { while (reader.Read()) { Core.Business.NewsPhoto newsPhoto = new Core.Business.NewsPhoto(); if (!reader.IsDBNull(0)) newsPhoto.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) newsPhoto.Title = reader.GetString(1); if (!reader.IsDBNull(2)) newsPhoto.PhotoSrc = reader.GetString(2); if (!reader.IsDBNull(3)) newsPhoto.Author = reader.GetString(3); if (!reader.IsDBNull(4)) newsPhoto.AddDate = reader.GetDateTime(4); if (!reader.IsDBNull(5)) newsPhoto.ContentUrl = reader.GetString(5); if (!reader.IsDBNull(6)) newsPhoto.Status = reader.GetInt32(6); if (!reader.IsDBNull(7)) newsPhoto.ContentID = reader.GetGuid(7); newsPhoto.MarkOld(); newsPhotolist.Add(newsPhoto); } reader.Close(); } return newsPhotolist; }