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;
}
public IEnumerable<NewsContent> Search(NewsSearchJson json, PagingInfo pageInfo)
{
if (json == null || pageInfo == null)
throw new ArgumentNullException("the json or pageinfo is null ");
IList<Core.Business.NewsContent> newsContentlist = new List<Core.Business.NewsContent>();
SqlServerUtility sql = new SqlServerUtility();
if (!string.IsNullOrEmpty(json.Title))
{
sql.AddParameter("@title", SqlDbType.NVarChar, json.Title);
}
if (json.PublishStartTime != null && json.PublishStartTime.Value > DateTime.MinValue)
{
sql.AddParameter("@publishstartdate", SqlDbType.DateTime, json.PublishStartTime.Value);
}
if (json.PublishEndTime != null && json.PublishEndTime.Value > DateTime.MinValue)
{
sql.AddParameter("@publishenddate", SqlDbType.DateTime, json.PublishEndTime.Value);
}
if (json.CheckStartTime != null && json.CheckStartTime.Value > DateTime.MinValue)
{
sql.AddParameter("@checkstartdate", SqlDbType.DateTime, json.CheckStartTime.Value);
}
if (json.CheckEndTime != null && json.CheckEndTime.Value > DateTime.MinValue)
{
sql.AddParameter("@checkenddate", SqlDbType.DateTime, json.CheckEndTime.Value);
}
if (!string.IsNullOrEmpty(json.Tag))
{
sql.AddParameter("@tag", SqlDbType.NVarChar, json.Tag);
}
if (!string.IsNullOrEmpty(json.Source))
{
sql.AddParameter("@source", SqlDbType.NVarChar, json.Source);
}
if (!string.IsNullOrEmpty(json.Author))
{
sql.AddParameter("@author", SqlDbType.NVarChar, json.Author);
}
if (!string.IsNullOrEmpty(json.Checker))
{
sql.AddParameter("@checker", SqlDbType.NVarChar, json.Checker);
}
if (json.StartTraffic != null && json.StartTraffic >= 0)
{
sql.AddParameter("@starttraffic", SqlDbType.Int, json.StartTraffic.Value);
}
if (json.EndTraffic != null && json.EndTraffic >= 0)
{
sql.AddParameter("@endtraffic", SqlDbType.Int, json.EndTraffic.Value);
}
if (json.Module != null && json.Module.Value != Guid.Empty)
{
sql.AddParameter("@moduleid", SqlDbType.UniqueIdentifier, json.Module.Value);
}
if (json.Unit != null && json.Unit.Value != Guid.Empty)
{
sql.AddParameter("@unit", SqlDbType.UniqueIdentifier, json.Unit.Value);
}
if (json.IsCenter != null)
{
sql.AddParameter("@center", SqlDbType.Int, json.IsCenter.Value);
}
if (json.Status != null)
{
sql.AddParameter("@status", SqlDbType.Int, json.Status.Value);
}
int lowBand = (pageInfo.CurrentPage - 1) * pageInfo.PageSize;
int highBand = pageInfo.CurrentPage * pageInfo.PageSize;
sql.AddParameter("@lowBand", SqlDbType.Int, lowBand);
sql.AddParameter("@highBand", SqlDbType.Int, highBand);
SqlDataReader reader = sql.ExecuteSPReader("usp_SearchNew");
if (reader != null)
{
while (reader.Read())
{
Core.Business.NewsContent newsContent = new Core.Business.NewsContent();
if (!reader.IsDBNull(0)) newsContent.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) newsContent.ModuleID = reader.GetGuid(1);
if (!reader.IsDBNull(2)) newsContent.Title = reader.GetString(2);
if (!reader.IsDBNull(3)) newsContent.Content = reader.GetString(3);
if (!reader.IsDBNull(4)) newsContent.PublishTime = reader.GetDateTime(4);
if (!reader.IsDBNull(5)) newsContent.Tag = reader.GetInt32(5);
if (!reader.IsDBNull(6)) newsContent.Annex = reader.GetInt32(6);
if (!reader.IsDBNull(7)) newsContent.Status = reader.GetInt32(7);
if (!reader.IsDBNull(8)) newsContent.Source = reader.GetString(8);
if (!reader.IsDBNull(9)) newsContent.Author = reader.GetString(9);
if (!reader.IsDBNull(10)) newsContent.Checker = reader.GetString(10);
if (!reader.IsDBNull(11)) newsContent.CheckTime = reader.GetDateTime(11);
if (!reader.IsDBNull(12)) newsContent.Index = reader.GetInt32(12);
if (!reader.IsDBNull(13)) newsContent.Traffic = reader.GetInt64(13);
if (!reader.IsDBNull(14)) newsContent.SortTime = reader.GetDateTime(14);
if (!reader.IsDBNull(15)) newsContent.ModuleName = reader.GetString(15);
newsContent.MarkOld();
newsContentlist.Add(newsContent);
}
reader.Close();
}
return newsContentlist;
}
public IEnumerable<Note> Search(NoteSearchJson json, PagingInfo pageinfo)
{
if (json == null || pageinfo == null)
{
throw new ArgumentNullException("the pageinfo is null ");
}
IList<Core.Business.Note> notelist = new List<Core.Business.Note>();
SqlServerUtility sql = new SqlServerUtility();
if (!string.IsNullOrEmpty(json.Title))
{
sql.AddParameter("@title", SqlDbType.NVarChar, json.Title);
}
if (json.Reciever != null && json.Reciever.Value > 0)
{
sql.AddParameter("@reciever", SqlDbType.NVarChar, json.Reciever.Value);
}
if (json.Sender != null && json.Sender.Value > 0)
{
sql.AddParameter("@sender", SqlDbType.Int, json.Sender.Value);
}
if (!string.IsNullOrEmpty(json.Depart))
{
sql.AddParameter("@depart", SqlDbType.NVarChar, json.Depart);
}
if (json.Status != null)
{
sql.AddParameter("@status", SqlDbType.Int, json.Status.Value);
}
if (json.Type != null && json.Type.HasValue)
{
sql.AddParameter("@type", SqlDbType.Int, json.Type.Value);
}
sql.AddParameter("@deletestatus", SqlDbType.Int, json.DeleteStatus.Value);
int lowBand = (pageinfo.CurrentPage - 1) * pageinfo.PageSize;
int highBand = pageinfo.PageSize * pageinfo.PageSize;
sql.AddParameter("@lowband", SqlDbType.Int, lowBand);
sql.AddParameter("@highband", SqlDbType.Int, highBand);
SqlDataReader reader = sql.ExecuteSPReader("Search_NotePaged");
if (reader != null)
{
while (reader.Read())
{
Core.Business.Note note = new Core.Business.Note();
if (!reader.IsDBNull(0)) note.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) note.NoteTitle = reader.GetString(1);
if (!reader.IsDBNull(2)) note.NoteContent = reader.GetString(2);
if (!reader.IsDBNull(3)) note.NoteDate = reader.GetDateTime(3);
if (!reader.IsDBNull(4)) note.NoteTimes = reader.GetInt32(4);
if (!reader.IsDBNull(5)) note.NoteType = reader.GetInt32(5);
if (!reader.IsDBNull(6)) note.PulisherKey = reader.GetInt32(6);
if (!reader.IsDBNull(7)) note.PulishModule = reader.GetInt32(7);
if (!reader.IsDBNull(8)) note.IsFront = reader.GetBoolean(8);
note.MarkOld();
notelist.Add(note);
}
reader.Close();
}
return notelist;
}