public List <SearchResult> GetPagedSearch(PagingContext pager,
string searchText, ObjectTypeDefine objectType)
{
if (string.IsNullOrEmpty(searchText))
{
return(new List <SearchResult>());
}
return(SearchDao.GetPagedSearch(pager, searchText, objectType));
}
internal static List <SearchResult> GetPagedSearch(PagingContext pager,
string searchText, ObjectTypeDefine objectType)
{
List <SearchResult> list = new List <SearchResult>(pager.RecordsPerPage);
string SearchSp = string.Empty;
switch (objectType)
{
case ObjectTypeDefine.Show:
SearchSp = "dbo.Search_GetPagedShow";
break;
case ObjectTypeDefine.MusicTitle:
case ObjectTypeDefine.Song:
SearchSp = "dbo.Search_GetPagedMusic";
break;
case ObjectTypeDefine.Album:
case ObjectTypeDefine.Image:
SearchSp = "dbo.Search_GetPagedAlbum";
break;
case ObjectTypeDefine.Video:
SearchSp = "dbo.Search_GetPagedVideoNews";
break;
case ObjectTypeDefine.News:
SearchSp = "dbo.Search_GetPagedNews";
break;
default:
return(list);
}
SafeProcedure.ExecuteAndMapRecords(Database.GetDatabase(D4DDefine.DBInstanceName),
SearchSp,
delegate(IParameterSet parameters)
{
parameters.AddWithValue("@SearchTxt", searchText);
parameters.AddWithValue("@PageIndex", pager.CurrentPageNumber);
parameters.AddWithValue("@PageSize", pager.RecordsPerPage);
parameters.AddWithValue("@NumberOfCount", 0, ParameterDirectionWrap.Output);
},
delegate(IRecord record)
{
MapSeachResultList(record, list, objectType);
},
delegate(IParameterSet outputParameters)
{
pager.TotalRecordCount = outputParameters.GetValue("@NumberOfCount") == DBNull.Value ? 0 : (int)outputParameters.GetValue("@NumberOfCount");
}
);
return(list);
}
internal static void MapSeachResultList(IRecord record, List<SearchResult> list,ObjectTypeDefine objectType)
{
SearchResult m = new SearchResult();
m.ObjectType = objectType;
m.ObjectId = record.GetInt32OrDefault(0, 0);
m.Title = record.GetStringOrEmpty(1);
m.Body = record.GetStringOrEmpty(2);
m.SImage = record.GetStringOrEmpty(3);
m.BandId = record.GetInt32OrDefault(4, 0);
m.PublishDate = record.GetDateTimeOrEmpty(5);
list.Add(m);
}
internal static List<SearchResult> GetPagedSearch(PagingContext pager,
string searchText,ObjectTypeDefine objectType)
{
List<SearchResult> list = new List<SearchResult>(pager.RecordsPerPage);
string SearchSp = string.Empty;
switch (objectType)
{
case ObjectTypeDefine.Show:
SearchSp = "dbo.Search_GetPagedShow";
break;
case ObjectTypeDefine.MusicTitle:
case ObjectTypeDefine.Song:
SearchSp = "dbo.Search_GetPagedMusic";
break;
case ObjectTypeDefine.Album:
case ObjectTypeDefine.Image:
SearchSp = "dbo.Search_GetPagedAlbum";
break;
case ObjectTypeDefine.Video:
SearchSp = "dbo.Search_GetPagedVideoNews";
break;
case ObjectTypeDefine.News:
SearchSp = "dbo.Search_GetPagedNews";
break;
default:
return list;
}
SafeProcedure.ExecuteAndMapRecords(Database.GetDatabase(D4DDefine.DBInstanceName),
SearchSp,
delegate(IParameterSet parameters)
{
parameters.AddWithValue("@SearchTxt", searchText);
parameters.AddWithValue("@PageIndex", pager.CurrentPageNumber);
parameters.AddWithValue("@PageSize", pager.RecordsPerPage);
parameters.AddWithValue("@NumberOfCount", 0, ParameterDirectionWrap.Output);
},
delegate(IRecord record)
{
MapSeachResultList(record, list, objectType);
},
delegate(IParameterSet outputParameters)
{
pager.TotalRecordCount = outputParameters.GetValue("@NumberOfCount") == DBNull.Value ? 0 : (int)outputParameters.GetValue("@NumberOfCount");
}
);
return list;
}
public void DeleteTagRelation(int tagId, int objectId, ObjectTypeDefine objectType)
{
TagsDao.DeleteTagRelation(tagId, objectId, (int)objectType);
}
public List<TagRelation> GetTagRelationByObject(int objectId, ObjectTypeDefine objectType)
{
return TagsDao.GetTagRelationByObject(objectId, (int)objectType);
}
public void DeleteCommentByObject(int objectId, ObjectTypeDefine objectType)
{
CommentDao.DeleteCommentByObject(objectId, (int)objectType);
}
internal static void MapSeachResultList(IRecord record, List <SearchResult> list, ObjectTypeDefine objectType)
{
SearchResult m = new SearchResult();
m.ObjectType = objectType;
m.ObjectId = record.GetInt32OrDefault(0, 0);
m.Title = record.GetStringOrEmpty(1);
m.Body = record.GetStringOrEmpty(2);
m.SImage = record.GetStringOrEmpty(3);
m.BandId = record.GetInt32OrDefault(4, 0);
m.PublishDate = record.GetDateTimeOrEmpty(5);
list.Add(m);
}
public void DeleteTagRelationByObject(int objectId, ObjectTypeDefine objectType)
{
TagsDao.DeleteTagRelationByObject(objectId, (int)objectType);
}
public void DeleteTagRelation(int tagId, int objectId, ObjectTypeDefine objectType)
{
TagsDao.DeleteTagRelation(tagId, objectId, (int)objectType);
}
public List<Comment> GetPagedComments(PagingContext pager, PublishStatus publishStatus, int objectId, ObjectTypeDefine objectType)
{
return CommentDao.GetPagedComments(pager, (int)publishStatus, objectId, (int)objectType);
}
/// <summary>
/// 获取指定objectid的comment数量
/// </summary>
/// <param name="oIds"></param>
/// <param name="objectType"></param>
/// <returns></returns>
public Dictionary<int, int> GetComments20(List<int> oIds, ObjectTypeDefine objectType)
{
return CommentDao.GetComments20(oIds, (int)objectType);
}
public void DeleteCommentByObject(int objectId, ObjectTypeDefine objectType)
{
CommentDao.DeleteCommentByObject(objectId, (int)objectType);
}
/// <summary>
/// 获取指定objectid的comment数量
/// </summary>
/// <param name="oIds"></param>
/// <param name="objectType"></param>
/// <returns></returns>
public Dictionary <int, int> GetComments20(List <int> oIds, ObjectTypeDefine objectType)
{
return(CommentDao.GetComments20(oIds, (int)objectType));
}
public List <Comment> GetPagedComments(PagingContext pager, PublishStatus publishStatus, int objectId, ObjectTypeDefine objectType)
{
return(CommentDao.GetPagedComments(pager, (int)publishStatus, objectId, (int)objectType));
}
public void DeleteTagRelationByObject(int objectId, ObjectTypeDefine objectType)
{
TagsDao.DeleteTagRelationByObject(objectId, (int)objectType);
}
public TagRelation GetTagRelation(int tagId, int objectId, ObjectTypeDefine objectType)
{
return TagsDao.GetTagRelation(tagId, objectId, (int)objectType);
}
public TagRelation GetTagRelation(int tagId, int objectId, ObjectTypeDefine objectType)
{
return(TagsDao.GetTagRelation(tagId, objectId, (int)objectType));
}
public List <TagRelation> GetTagRelationByObject(int objectId, ObjectTypeDefine objectType)
{
return(TagsDao.GetTagRelationByObject(objectId, (int)objectType));
}
public List<SearchResult> GetPagedSearch(PagingContext pager,
string searchText, ObjectTypeDefine objectType)
{
if (string.IsNullOrEmpty(searchText)) return new List<SearchResult>();
return SearchDao.GetPagedSearch(pager, searchText, objectType);
}
