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