C# 클래스 Discuz.Album.Data.DataProvider

파일 보기 프로젝트 열기: CyranoChen/DiscuzNT

공개 메소드들

메소드 설명
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

비공개 메소드들

메소드 설명
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语句转义

메소드 상세

AddAlbumCategory() 공개 메소드

public AddAlbumCategory ( Discuz.Entity.AlbumCategoryInfo aci ) : void
aci Discuz.Entity.AlbumCategoryInfo
리턴 void

AddSpaceAlbum() 공개 메소드

public AddSpaceAlbum ( Discuz.Entity.AlbumInfo spaceAlbum ) : bool
spaceAlbum Discuz.Entity.AlbumInfo
리턴 bool

AddSpacePhoto() 공개 메소드

public AddSpacePhoto ( Discuz.Entity.PhotoInfo photoinfo ) : int
photoinfo Discuz.Entity.PhotoInfo
리턴 int

ChangeAlbum() 공개 메소드

public ChangeAlbum ( int targetAlbumId, string photoIdList, int userid ) : int
targetAlbumId int
photoIdList string
userid int
리턴 int

CreatePhotoComment() 공개 메소드

public CreatePhotoComment ( PhotoCommentInfo pcomment ) : int
pcomment Discuz.Entity.PhotoCommentInfo
리턴 int

CreatePhotoTags() 공개 메소드

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

DeleteAlbumCategory() 공개 메소드

public DeleteAlbumCategory ( int albumcateid ) : void
albumcateid int
리턴 void

DeleteAll() 공개 메소드

public DeleteAll ( int userid ) : void
userid int
리턴 void

DeletePhotoComment() 공개 메소드

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

DeletePhotoTags() 공개 메소드

public DeletePhotoTags ( int photoid ) : void
photoid int
리턴 void

DeleteSpaceAlbum() 공개 메소드

public DeleteSpaceAlbum ( int albumId, int userid ) : bool
albumId int
userid int
리턴 bool

DeleteSpacePhotoByIDList() 공개 메소드

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

GetAlbumCategory() 공개 메소드

public GetAlbumCategory ( ) : Discuz.Common.Generic.List
리턴 Discuz.Common.Generic.List

GetAlbumCategorySql() 공개 메소드

public GetAlbumCategorySql ( ) : string
리턴 string

GetAlbumListByCondition() 공개 메소드

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
리턴 System.Data.DataTable

GetAlbumListByCondition() 공개 메소드

public GetAlbumListByCondition ( int type, int focusphotocount, int vaildDays ) : IDataReader
type int
focusphotocount int
vaildDays int
리턴 IDataReader

GetAlbumListCountByCondition() 공개 메소드

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
리턴 int

GetAlbumLitByAlbumidList() 공개 메소드

public GetAlbumLitByAlbumidList ( string albumlist ) : DataTable
albumlist string
리턴 System.Data.DataTable

GetFocusPhotoList() 공개 메소드

public GetFocusPhotoList ( int type, int focusphotocount, int validDays ) : IDataReader
type int
focusphotocount int
validDays int
리턴 IDataReader

GetFocusPhotoList() 공개 메소드

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

GetHotTagsListForPhoto() 공개 메소드

public GetHotTagsListForPhoto ( int count ) : IDataReader
count int
리턴 IDataReader

GetPhotoByCondition() 공개 메소드

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
리턴 System.Data.DataTable

GetPhotoByID() 공개 메소드

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

GetPhotoCommentCollection() 공개 메소드

public GetPhotoCommentCollection ( int photoid ) : IDataReader
photoid int
리턴 IDataReader

GetPhotoCountByCondition() 공개 메소드

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

GetPhotoCountWithSameTag() 공개 메소드

public GetPhotoCountWithSameTag ( int tagid ) : int
tagid int
리턴 int

GetPhotoListByUserId() 공개 메소드

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

GetPhotoRankList() 공개 메소드

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

GetPhotoSizeByUserid() 공개 메소드

public GetPhotoSizeByUserid ( int userid ) : int
userid int
리턴 int

GetPhotosByAlbumid() 공개 메소드

public GetPhotosByAlbumid ( int albumid ) : DataTable
albumid int
리턴 System.Data.DataTable

GetPhotosWithSameTag() 공개 메소드

public GetPhotosWithSameTag ( int tagid, int pageid, int pagesize ) : IDataReader
tagid int
pageid int
pagesize int
리턴 IDataReader

GetRecommendPhotoList() 공개 메소드

public GetRecommendPhotoList ( string idlist ) : IDataReader
idlist string
리턴 IDataReader

GetSearchAlbumList() 공개 메소드

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

GetSpaceAlbumById() 공개 메소드

public GetSpaceAlbumById ( int albumId ) : IDataReader
albumId int
리턴 IDataReader

GetSpaceAlbumByUserId() 공개 메소드

public GetSpaceAlbumByUserId ( int userid ) : DataTable
userid int
리턴 System.Data.DataTable

GetSpaceAlbumsCount() 공개 메소드

public GetSpaceAlbumsCount ( int userid ) : int
userid int
리턴 int

GetSpacePhotoByAlbumID() 공개 메소드

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

GetSpacePhotoCountByAlbumId() 공개 메소드

public GetSpacePhotoCountByAlbumId ( int albumid ) : int
albumid int
리턴 int

GetSpacePhotosCount() 공개 메소드

public GetSpacePhotosCount ( int albumid ) : int
albumid int
리턴 int

GetTagsListByPhotoId() 공개 메소드

public GetTagsListByPhotoId ( int photoid ) : IDataReader
photoid int
리턴 IDataReader

GetUidByAlbumid() 공개 메소드

public GetUidByAlbumid ( int albumid ) : int
albumid int
리턴 int

SaveSpaceAlbum() 공개 메소드

public SaveSpaceAlbum ( Discuz.Entity.AlbumInfo spaceAlbum ) : bool
spaceAlbum Discuz.Entity.AlbumInfo
리턴 bool

SpaceAlbumsList() 공개 메소드

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

SpaceAlbumsList() 공개 메소드

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

SpaceAlbumsListCount() 공개 메소드

public SpaceAlbumsListCount ( int userid, int albumcategoryid ) : int
userid int
albumcategoryid int
리턴 int

SpacePhotosList() 공개 메소드

public SpacePhotosList ( int albumid ) : DataTable
albumid int
리턴 System.Data.DataTable

SpacePhotosList() 공개 메소드

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

UpdateAlbumCategory() 공개 메소드

public UpdateAlbumCategory ( Discuz.Entity.AlbumCategoryInfo aci ) : void
aci Discuz.Entity.AlbumCategoryInfo
리턴 void

UpdateAlbumViews() 공개 메소드

public UpdateAlbumViews ( int albumid ) : void
albumid int
리턴 void

UpdatePhotoComments() 공개 메소드

public UpdatePhotoComments ( int photoid, int count ) : void
photoid int
count int
리턴 void

UpdatePhotoInfo() 공개 메소드

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

UpdatePhotoViews() 공개 메소드

public UpdatePhotoViews ( int photoid ) : void
photoid int
리턴 void