C# Class Discuz.Album.Data.DataProvider

Datei anzeigen Open project: CyranoChen/DiscuzNT

Public Methods

Method Description
AddAlbumCategory ( Discuz.Entity.AlbumCategoryInfo aci ) : void
AddSpaceAlbum ( Discuz.Entity.AlbumInfo spaceAlbum ) : bool
AddSpacePhoto ( Discuz.Entity.PhotoInfo photoinfo ) : int
ChangeAlbum ( int targetAlbumId, string photoIdList, int userid ) : int
CreatePhotoComment ( PhotoCommentInfo pcomment ) : int
CreatePhotoTags ( string tags, int photoid, int userid, string postdatetime ) : void
DeleteAlbumCategory ( int albumcateid ) : void
DeleteAll ( int userid ) : void
DeletePhotoComment ( int commentid ) : void

删除图片评论

DeletePhotoTags ( int photoid ) : void
DeleteSpaceAlbum ( int albumId, int userid ) : bool
DeleteSpacePhotoByIDList ( string photoidlist, int albumid, int userid ) : bool
GetAlbumCategory ( ) : Discuz.Common.Generic.List
GetAlbumCategorySql ( ) : string
GetAlbumListByCondition ( string username, string title, string description, string startdate, string enddate, int pageSize, int currentPage, bool isshowall ) : DataTable
GetAlbumListByCondition ( int type, int focusphotocount, int vaildDays ) : IDataReader
GetAlbumListCountByCondition ( string username, string title, string description, string startdate, string enddate, bool isshowall ) : int
GetAlbumLitByAlbumidList ( string albumlist ) : DataTable
GetFocusPhotoList ( int type, int focusphotocount, int validDays ) : IDataReader
GetFocusPhotoList ( int type, int focusphotocount, int validDays, int uid ) : IDataReader
GetHotTagsListForPhoto ( int count ) : IDataReader
GetPhotoByCondition ( string photousernamelist, string keylist, string startdate, string enddate, int pageSize, int currentPage ) : DataTable
GetPhotoByID ( int photoid, int albumid, byte mode ) : IDataReader

获得照片信息

GetPhotoCommentCollection ( int photoid ) : IDataReader
GetPhotoCountByCondition ( string photousernamelist, string keylist, string startdate, string enddate ) : int
GetPhotoCountWithSameTag ( int tagid ) : int
GetPhotoListByUserId ( int userid, int albumid, int count ) : IDataReader

获取图片集合

GetPhotoRankList ( int type, int photocount ) : IDataReader

获得图片排行图集合

GetPhotoSizeByUserid ( int userid ) : int
GetPhotosByAlbumid ( int albumid ) : DataTable
GetPhotosWithSameTag ( int tagid, int pageid, int pagesize ) : IDataReader
GetRecommendPhotoList ( string idlist ) : IDataReader
GetSearchAlbumList ( int pagesize, string albumids ) : DataTable
GetSpaceAlbumById ( int albumId ) : IDataReader
GetSpaceAlbumByUserId ( int userid ) : DataTable
GetSpaceAlbumsCount ( int userid ) : int
GetSpacePhotoByAlbumID ( int albumid ) : DataTable

通过相册ID得到相册中所有图片的信息

GetSpacePhotoCountByAlbumId ( int albumid ) : int
GetSpacePhotosCount ( int albumid ) : int
GetTagsListByPhotoId ( int photoid ) : IDataReader
GetUidByAlbumid ( int albumid ) : int
SaveSpaceAlbum ( Discuz.Entity.AlbumInfo spaceAlbum ) : bool
SpaceAlbumsList ( int pageSize, int currentPage, int userid ) : DataTable
SpaceAlbumsList ( int userid, int albumcategoryid, int pageSize, int currentPage ) : IDataReader
SpaceAlbumsListCount ( int userid, int albumcategoryid ) : int
SpacePhotosList ( int albumid ) : DataTable
SpacePhotosList ( int pageSize, int currentPage, int userid, int albumid ) : DataTable
UpdateAlbumCategory ( Discuz.Entity.AlbumCategoryInfo aci ) : void
UpdateAlbumViews ( int albumid ) : void
UpdatePhotoComments ( int photoid, int count ) : void
UpdatePhotoInfo ( Discuz.Entity.PhotoInfo photo ) : void

更新图片信息(仅更新 标题、描述、评论设置和标签设置4项)

UpdatePhotoViews ( int photoid ) : void

Private Methods

Method Description
GetAlbumListCondition ( string usernamelist, string titlelist, string descriptionlist, string startdate, string enddate ) : string
GetDateSpanParms ( string startdate, string enddate ) : System.Data.Common.DbParameter[]
GetPhotoCondition ( string photousernamelist, string keylist, string startdate, string enddate ) : string
RegEsc ( string str ) : string

SQL SERVER SQL语句转义

Method Details

AddAlbumCategory() public method

public AddAlbumCategory ( Discuz.Entity.AlbumCategoryInfo aci ) : void
aci Discuz.Entity.AlbumCategoryInfo
return void

AddSpaceAlbum() public method

public AddSpaceAlbum ( Discuz.Entity.AlbumInfo spaceAlbum ) : bool
spaceAlbum Discuz.Entity.AlbumInfo
return bool

AddSpacePhoto() public method

public AddSpacePhoto ( Discuz.Entity.PhotoInfo photoinfo ) : int
photoinfo Discuz.Entity.PhotoInfo
return int

ChangeAlbum() public method

public ChangeAlbum ( int targetAlbumId, string photoIdList, int userid ) : int
targetAlbumId int
photoIdList string
userid int
return int

CreatePhotoComment() public method

public CreatePhotoComment ( PhotoCommentInfo pcomment ) : int
pcomment Discuz.Entity.PhotoCommentInfo
return int

CreatePhotoTags() public method

public CreatePhotoTags ( string tags, int photoid, int userid, string postdatetime ) : void
tags string
photoid int
userid int
postdatetime string
return void

DeleteAlbumCategory() public method

public DeleteAlbumCategory ( int albumcateid ) : void
albumcateid int
return void

DeleteAll() public method

public DeleteAll ( int userid ) : void
userid int
return void

DeletePhotoComment() public method

删除图片评论
public DeletePhotoComment ( int commentid ) : void
commentid int 评论Id
return void

DeletePhotoTags() public method

public DeletePhotoTags ( int photoid ) : void
photoid int
return void

DeleteSpaceAlbum() public method

public DeleteSpaceAlbum ( int albumId, int userid ) : bool
albumId int
userid int
return bool

DeleteSpacePhotoByIDList() public method

public DeleteSpacePhotoByIDList ( string photoidlist, int albumid, int userid ) : bool
photoidlist string
albumid int
userid int
return bool

GetAlbumCategory() public method

public GetAlbumCategory ( ) : Discuz.Common.Generic.List
return Discuz.Common.Generic.List

GetAlbumCategorySql() public method

public GetAlbumCategorySql ( ) : string
return string

GetAlbumListByCondition() public method

public GetAlbumListByCondition ( string username, string title, string description, string startdate, string enddate, int pageSize, int currentPage, bool isshowall ) : DataTable
username string
title string
description string
startdate string
enddate string
pageSize int
currentPage int
isshowall bool
return System.Data.DataTable

GetAlbumListByCondition() public method

public GetAlbumListByCondition ( int type, int focusphotocount, int vaildDays ) : IDataReader
type int
focusphotocount int
vaildDays int
return IDataReader

GetAlbumListCountByCondition() public method

public GetAlbumListCountByCondition ( string username, string title, string description, string startdate, string enddate, bool isshowall ) : int
username string
title string
description string
startdate string
enddate string
isshowall bool
return int

GetAlbumLitByAlbumidList() public method

public GetAlbumLitByAlbumidList ( string albumlist ) : DataTable
albumlist string
return System.Data.DataTable

GetFocusPhotoList() public method

public GetFocusPhotoList ( int type, int focusphotocount, int validDays ) : IDataReader
type int
focusphotocount int
validDays int
return IDataReader

GetFocusPhotoList() public method

public GetFocusPhotoList ( int type, int focusphotocount, int validDays, int uid ) : IDataReader
type int
focusphotocount int
validDays int
uid int
return IDataReader

GetHotTagsListForPhoto() public method

public GetHotTagsListForPhoto ( int count ) : IDataReader
count int
return IDataReader

GetPhotoByCondition() public method

public GetPhotoByCondition ( string photousernamelist, string keylist, string startdate, string enddate, int pageSize, int currentPage ) : DataTable
photousernamelist string
keylist string
startdate string
enddate string
pageSize int
currentPage int
return System.Data.DataTable

GetPhotoByID() public method

获得照片信息
public GetPhotoByID ( int photoid, int albumid, byte mode ) : IDataReader
photoid int 图片Id
albumid int 相册Id
mode byte 模式,0=当前图片,1上一张,2下一张
return IDataReader

GetPhotoCommentCollection() public method

public GetPhotoCommentCollection ( int photoid ) : IDataReader
photoid int
return IDataReader

GetPhotoCountByCondition() public method

public GetPhotoCountByCondition ( string photousernamelist, string keylist, string startdate, string enddate ) : int
photousernamelist string
keylist string
startdate string
enddate string
return int

GetPhotoCountWithSameTag() public method

public GetPhotoCountWithSameTag ( int tagid ) : int
tagid int
return int

GetPhotoListByUserId() public method

获取图片集合
public GetPhotoListByUserId ( int userid, int albumid, int count ) : IDataReader
userid int 用户Id,必须指定一个用户,不能为0
albumid int 相册Id,当为0时表示此用户所有相册
count int 取出的数量
return IDataReader

GetPhotoRankList() public method

获得图片排行图集合
public GetPhotoRankList ( int type, int photocount ) : IDataReader
type int 排行方式,0浏览量,1评论数,2上传时间,3收藏数
photocount int
return IDataReader

GetPhotoSizeByUserid() public method

public GetPhotoSizeByUserid ( int userid ) : int
userid int
return int

GetPhotosByAlbumid() public method

public GetPhotosByAlbumid ( int albumid ) : DataTable
albumid int
return System.Data.DataTable

GetPhotosWithSameTag() public method

public GetPhotosWithSameTag ( int tagid, int pageid, int pagesize ) : IDataReader
tagid int
pageid int
pagesize int
return IDataReader

GetRecommendPhotoList() public method

public GetRecommendPhotoList ( string idlist ) : IDataReader
idlist string
return IDataReader

GetSearchAlbumList() public method

public GetSearchAlbumList ( int pagesize, string albumids ) : DataTable
pagesize int
albumids string
return System.Data.DataTable

GetSpaceAlbumById() public method

public GetSpaceAlbumById ( int albumId ) : IDataReader
albumId int
return IDataReader

GetSpaceAlbumByUserId() public method

public GetSpaceAlbumByUserId ( int userid ) : DataTable
userid int
return System.Data.DataTable

GetSpaceAlbumsCount() public method

public GetSpaceAlbumsCount ( int userid ) : int
userid int
return int

GetSpacePhotoByAlbumID() public method

通过相册ID得到相册中所有图片的信息
public GetSpacePhotoByAlbumID ( int albumid ) : DataTable
albumid int 相册ID
return System.Data.DataTable

GetSpacePhotoCountByAlbumId() public method

public GetSpacePhotoCountByAlbumId ( int albumid ) : int
albumid int
return int

GetSpacePhotosCount() public method

public GetSpacePhotosCount ( int albumid ) : int
albumid int
return int

GetTagsListByPhotoId() public method

public GetTagsListByPhotoId ( int photoid ) : IDataReader
photoid int
return IDataReader

GetUidByAlbumid() public method

public GetUidByAlbumid ( int albumid ) : int
albumid int
return int

SaveSpaceAlbum() public method

public SaveSpaceAlbum ( Discuz.Entity.AlbumInfo spaceAlbum ) : bool
spaceAlbum Discuz.Entity.AlbumInfo
return bool

SpaceAlbumsList() public method

public SpaceAlbumsList ( int pageSize, int currentPage, int userid ) : DataTable
pageSize int
currentPage int
userid int
return System.Data.DataTable

SpaceAlbumsList() public method

public SpaceAlbumsList ( int userid, int albumcategoryid, int pageSize, int currentPage ) : IDataReader
userid int
albumcategoryid int
pageSize int
currentPage int
return IDataReader

SpaceAlbumsListCount() public method

public SpaceAlbumsListCount ( int userid, int albumcategoryid ) : int
userid int
albumcategoryid int
return int

SpacePhotosList() public method

public SpacePhotosList ( int albumid ) : DataTable
albumid int
return System.Data.DataTable

SpacePhotosList() public method

public SpacePhotosList ( int pageSize, int currentPage, int userid, int albumid ) : DataTable
pageSize int
currentPage int
userid int
albumid int
return System.Data.DataTable

UpdateAlbumCategory() public method

public UpdateAlbumCategory ( Discuz.Entity.AlbumCategoryInfo aci ) : void
aci Discuz.Entity.AlbumCategoryInfo
return void

UpdateAlbumViews() public method

public UpdateAlbumViews ( int albumid ) : void
albumid int
return void

UpdatePhotoComments() public method

public UpdatePhotoComments ( int photoid, int count ) : void
photoid int
count int
return void

UpdatePhotoInfo() public method

更新图片信息(仅更新 标题、描述、评论设置和标签设置4项)
public UpdatePhotoInfo ( Discuz.Entity.PhotoInfo photo ) : void
photo Discuz.Entity.PhotoInfo
return void

UpdatePhotoViews() public method

public UpdatePhotoViews ( int photoid ) : void
photoid int
return void