C# 클래스 Engage.Dnn.Publish.Data.SqlDataProvider

상속: DataProvider
파일 보기 프로젝트 열기: EngageSoftware/Engage-Publish

공개 메소드들

메소드 설명
AddArticleVersion ( IDbTransaction trans, int itemVersionId, int itemId, string versionNumber, string versionDescription, string articleText, string referenceNumber ) : void
AddArticleVersion ( int itemVersionId, int itemId, string versionNumber, string versionDescription, string articleText, string referenceNumber ) : void
AddCategoryVersion ( IDbTransaction trans, int itemVersionId, int itemId, int sortOrder, int childDisplayTabId ) : void
AddCategoryVersion ( int itemVersionId, int itemId, int sortOrder, int childDisplayTabId ) : void
AddItem ( IDbTransaction trans, int itemTypeId, int portalId, int moduleId, System.Guid itemIdentifier ) : int
AddItemRelationship ( IDbTransaction trans, int childItemId, int childItemVersionId, int parentItemId, int relationshipTypeId, string startDate, string endDate, int sortOrder ) : void
AddItemRelationship ( int childItemId, int childItemVersionId, int parentItemId, int relationshipTypeId, string startDate, string endDate, int sortOrder ) : void
AddItemRelationshipWithOriginalSortOrder ( IDbTransaction trans, int childItemId, int childItemVersionId, int parentItemId, int relationshipTypeId, string startDate, string endDate, int originalItemVersionId ) : void
AddItemTag ( IDbTransaction trans, int itemVersionId, int tagId ) : void
AddItemTag ( int itemVersionId, int tagId ) : void
AddItemVersion ( IDbTransaction trans, int itemId, int originalItemVersionId, string name, string description, string startDate, string endDate, int languageId, int authorUserId, string metaKeywords, string metaDescription, string metaTitle, int displayTabId, bool disabled, string thumbnail, System.Guid itemVersionIdentifier, string url, bool newWindow, int revisingUserId ) : int
AddItemVersion ( int itemId, int originalItemVersionId, string name, string description, string startDate, string endDate, int languageId, int authorUserId, string metaKeywords, string metaDescription, string metaTitle, int displayTabId, bool disabled, string thumbnail, System.Guid itemVersionIdentifier, string url, bool newWindow, int revisingUserId ) : int
AddItemVersionSetting ( IDbTransaction trans, int itemVersionId, string controlName, string propertyName, string propertyValue ) : void
AddItemVersionSetting ( int itemVersionId, string controlName, string propertyName, string propertyValue ) : void
AddTag ( IDbTransaction trans, Tag tag ) : int
AddTag ( Tag tag ) : int
CheckItemTag ( IDbTransaction trans, int itemId, int tagId ) : int
CheckItemTag ( int itemId, int tagId ) : int
ClearItemsCommentCount ( int portalId ) : void
ClearItemsViewCount ( int portalId ) : void
CommentsWaitingForApprovalCount ( int portalId, int authorUserId ) : int
ConvertTagsToXml ( ArrayList tagIds ) : object
DeleteItem ( int itemId ) : void
DeleteItems ( ) : void
DeletePermissions ( int categoryId ) : void
FindItemId ( string name, int authorUserId ) : int
FindItemId ( string name, int authorUserId, int categoryId ) : int
GetAdminCommentListing ( int categoryId, int approvalStatusId, int portalId, int authorUserId, string articleSearch ) : DataSet
GetAdminItemListing ( int parentItemId, int itemTypeId, int relationshipTypeId, int approvalStatusId, int portalId ) : DataSet
GetAdminItemListing ( int parentItemId, int itemTypeId, int relationshipTypeId, int otherRelationshipTypeId, int approvalStatusId, int portalId ) : DataSet
GetAdminItemListing ( int parentItemId, int itemTypeId, int relationshipTypeId, int otherRelationshipTypeId, int approvalStatusId, string orderBy, int portalId ) : DataSet
GetAdminItemListing ( int parentItemId, int itemTypeId, int relationshipTypeId, int approvalStatusId, string orderBy, int portalId ) : DataSet
GetAdminItemListingSearchKey ( int parentItemId, int itemTypeId, int relationshipTypeId, int otherRelationshipTypeId, int approvalStatusId, string orderBy, string searchKey, int portalId ) : DataSet
GetAdminKeywordSearch ( string searchString, int itemTypeId, int portalId ) : DataSet
GetAdminKeywordSearch ( string searchString, int itemTypeId, int approvalStatusId, int portalId ) : DataSet
GetAllChildCategories ( int parentItemId, int portalId ) : DataTable
GetAllChildren ( int parentId, int relationshipTypeId, int portalId ) : DataSet
GetAllChildren ( int itemTypeId, int parentId, int relationshipTypeId, int portalId ) : DataSet
GetAllChildren ( int itemTypeId, int parentId, int relationshipTypeId, int otherRelationshipTypeId, int portalId ) : DataSet
GetAllChildrenAsDataReader ( int itemTypeId, int parentId, int relationshipTypeId, int otherRelationshipTypeId, int portalId ) : IDataReader
GetAllChildrenNLevels ( int parentCategoryId, int nLevels, int mItems, int portalId ) : DataTable
GetAllRelationships ( int moduleId ) : IDataReader

This currently returns all rows in the item relationship table. We may/could filter to only active at some point.
GetAllRelationshipsByPortalId ( int portalId ) : IDataReader
GetApprovalStatusId ( string itemName ) : IDataReader
GetApprovalStatusTypeName ( int approvalStatusId ) : string
GetApprovalStatusTypes ( int portalId ) : DataSet
GetApprovalStatusTypesForAuthors ( int portalId ) : DataSet
GetArticle ( int itemId ) : IDataReader
GetArticle ( int itemId, int portalId ) : IDataReader
GetArticleVersion ( int itemVersionId, int portalId ) : IDataReader
GetArticles ( int portalId ) : DataTable
GetArticles ( int parentItemId, int portalId ) : DataTable
GetArticlesByModuleId ( int moduleId ) : DataTable
GetArticlesByModuleIdCurrent ( int moduleId ) : DataTable
GetArticlesByPortalId ( int portalId ) : DataTable
GetArticlesSearchIndexingNew ( int portalId, int displayTabId ) : DataTable
GetArticlesSearchIndexingUpdated ( int portalId, int moduleDefId, int displayTabId ) : DataTable
GetAssignedRoles ( int categoryId ) : DataTable
GetCategories ( int portalId ) : DataTable
GetCategoriesByModuleId ( int moduleId ) : DataTable
GetCategoriesByPortalId ( int portalId ) : DataTable
GetCategoriesHierarchy ( int portalId ) : DataTable
GetCategory ( int itemId ) : IDataReader
GetCategory ( int itemId, int portalId ) : IDataReader
GetCategoryItemId ( string categoryName, int portalId ) : int
GetCategoryItems ( int categoryId, int itemTypeId ) : DataSet
GetCategoryItems ( int categoryId, int itemTypeId, int approvalStatusId ) : DataSet
GetCategoryItems ( int categoryId, int itemTypeId, int approvalStatusId, SearchSortOption sort ) : DataSet
GetCategoryListing ( int parentItemId, int portalId ) : IDataReader
GetCategoryVersion ( int itemVersionId, int portalId ) : IDataReader
GetChildCategories ( int parentItemId, int portalId ) : DataTable
GetChildCategories ( int parentItemId, int portalId, int itemTypeId ) : DataTable
GetChildrenInCategory ( int categoryId, int childTypeId, int maxItems, int portalId ) : DataTable
GetChildrenInCategory ( int categoryId, int childTypeId, int maxItems, int portalId, string sortOrder ) : DataTable
GetChildrenInCategoryPaging ( int categoryId, int childTypeId, int maxItems, int portalId, bool customSort, bool customSortDirection, string sortOrder, int index, int pageSize ) : DataTable
GetComments ( int itemId, int approvalStatusId ) : IDataReader
GetDataTable ( string sql, int portalId ) : DataTable
GetItem ( int itemId, int portalId, bool isCurrent ) : IDataReader
GetItemChildRelationships ( int parentItemId, int relationshipTypeId ) : IDataReader
GetItemIdFromVersion ( int itemVersionId ) : int
GetItemIdFromVersion ( int itemVersionId, int portalId ) : int
GetItemName ( int itemId ) : string
GetItemRelationshipByIdentifiers ( System.Guid parentItemIdentifier, System.Guid childItemVersionIdentifier, int currentPortalId ) : IDataReader
GetItemRelationshipByItemRelationshipId ( int itemRelationshipId ) : DataSet
GetItemRelationships ( int childItemId, int childItemVersionId, bool isActive ) : IDataReader
GetItemRelationships ( int childItemId, int childItemVersionId, int relationshipTypeId, bool isActive ) : IDataReader
GetItemTags ( int itemVersionId ) : IDataReader
GetItemType ( string itemName ) : IDataReader
GetItemType ( int itemId ) : string
GetItemTypeFromVersion ( int itemVersionId ) : string
GetItemTypeId ( int itemId ) : int
GetItemTypeName ( int itemTypeId ) : string
GetItemTypeName ( int itemTypeId, bool useCache, int portalId, int cacheTime ) : string
GetItemTypes ( ) : DataTable
GetItemVersion ( System.Guid guid, int portalId ) : IDataReader
GetItemVersionInfo ( int itemVersionId ) : IDataReader
GetItemVersionSettings ( int itemVersionId ) : IDataReader
GetItemVersionSettings ( int itemVersionId, string controlName ) : IDataReader
GetItemVersionSettingsByModuleId ( int moduleId ) : IDataReader
GetItemVersionSettingsByPortalId ( int portalId ) : IDataReader
GetItemVersions ( int itemId, int portalId ) : DataSet
GetItemViewPaging ( int itemTypeId, int categoryId, int pageIndex, int pageSize, string sortOrder, string startDate, string endDate, int portalId ) : DataTable
GetItems ( int parentItemId, int portalId, int relationshipTypeId ) : DataSet
GetItems ( int parentItemId, int portalId, int relationshipTypeId, int itemTypeId ) : DataSet
GetItems ( int parentItemId, int portalId, int relationshipTypeId, int otherRelationshipTypeId, int itemTypeId ) : DataSet
GetItems ( int itemTypeId, int portalId ) : IDataReader
GetItemsFromTags ( int portalId, ArrayList tagList ) : DataTable
GetItemsFromTagsPaging ( int portalId, ArrayList tagList, int maxItems, int pageId, string sortOrder ) : DataTable
GetModuleInfo ( int moduleId ) : IDataReader
GetMostPopular ( int categoryId, int childTypeId, int maxItems, int portalId ) : DataTable
GetMostRecent ( int childTypeId, int maxItems, int portalId ) : DataTable
GetMostRecentByCategoryId ( int categoryId, int childTypeId, int maxItems, int portalId ) : DataTable
GetOldArticleId ( int itemId ) : int
GetOldCategoryId ( int itemId ) : int
GetParentCategories ( int articleId, int portalId ) : DataTable
GetParentCategory ( int childItemId, int portalId ) : int
GetParentItems ( int itemId, int portalId, int relationshipTypeId ) : DataSet
GetPermissionType ( string permissionName ) : IDataReader
GetPopularTags ( int portalId, ArrayList tagList, bool selectTop ) : DataTable
GetPopularTagsCount ( int portalId, ArrayList tagList, bool selectTop ) : int
GetPublishModuleId ( string moduleTitle, int portalId ) : IDataReader
GetPublishTabId ( string tabName, int portalId ) : IDataReader
GetPublishTabName ( int tabId, int portalId ) : IDataReader
GetRelationshipType ( string relationshipName ) : IDataReader
GetSimpleGalleryAlbums ( int moduleId ) : IDataReader
GetSimpleGalleryPhotos ( int albumId, int maxCount ) : DataTable
GetTag ( int tagId ) : DataTable
GetTag ( string tag, int portalId ) : DataTable
GetTags ( int portalId ) : DataTable
GetTagsByString ( string partialTag, int portalId ) : DataTable
GetTopLevelCategories ( int portalId ) : DataSet
GetTopLevelCategoryItem ( string itemName ) : IDataReader
GetUltraMediaGalleryAlbums ( int moduleId ) : IDataReader
GetUltraMediaGalleryPhotos ( int albumId, int maxCount ) : DataTable
GetViewableArticleIds ( int permissionId ) : IDictionary
GetViewableCategoryIds ( int permissionId ) : IDictionary
InsertPermission ( int categoryId, int roleId, int permissionId, int userId ) : void
RunPublishStats ( ) : void
SqlDataProvider ( ) : System
UpdateDescription ( int itemVersionId, string description, string metaDescription ) : void
UpdateItem ( IDbTransaction trans, int itemId, int moduleId ) : void
UpdateItemRelationship ( int itemRelationshipId, int sortOrder ) : void
UpdateItemVersion ( IDbTransaction trans, int itemId, int itemVersionId, int approvalStatusId, int userId, string approvalComments ) : void
UpdateTag ( IDbTransaction trans, Tag tag ) : void
UpdateTag ( Tag tag ) : void
UpdateVenexusBraindump ( int itemId, string indexTitle, string indexContent, string indexWashedContent, int portalId, string indexUrl ) : void
WaitingForApprovalCount ( int portalId ) : int

비공개 메소드들

메소드 설명
AddItemView ( int itemId, int itemVersionId, int userId, int tabId, string ipAddress, string userAgent, string httpReferrer, string siteUrl ) : void
EnforceMaxCount ( int maxCount, DataTable photos ) : void
GetAllChildrenFromTwoParents ( int itemTypeId, int parentId, int relationshipTypeId, int otherParentId, int otherRelationshipTypeId, int portalId ) : DataSet
GetCategories ( int itemTypeId, int portalId ) : IDataReader
GetChildren ( int parentId, int relationshipTypeId, int portalId ) : DataSet
GetConnection ( ) : IDbConnection
GetItemVersionSetting ( int itemVersionId, string controlName, string propertyName ) : IDataReader
GetModulesByModuleId ( int moduleId ) : IDataReader
GetSimpleGalleryAlbum ( int albumId ) : IDataReader
GetSimpleGalleryVersion ( ) : string
GetUltraMediaGalleryAlbum ( int albumId ) : IDataReader
GetUserRoles ( ) : string
LimitRows ( int maxItems, DataTable dt ) : void

메소드 상세

AddArticleVersion() 공개 메소드

public AddArticleVersion ( IDbTransaction trans, int itemVersionId, int itemId, string versionNumber, string versionDescription, string articleText, string referenceNumber ) : void
trans IDbTransaction
itemVersionId int
itemId int
versionNumber string
versionDescription string
articleText string
referenceNumber string
리턴 void

AddArticleVersion() 공개 메소드

public AddArticleVersion ( int itemVersionId, int itemId, string versionNumber, string versionDescription, string articleText, string referenceNumber ) : void
itemVersionId int
itemId int
versionNumber string
versionDescription string
articleText string
referenceNumber string
리턴 void

AddCategoryVersion() 공개 메소드

public AddCategoryVersion ( IDbTransaction trans, int itemVersionId, int itemId, int sortOrder, int childDisplayTabId ) : void
trans IDbTransaction
itemVersionId int
itemId int
sortOrder int
childDisplayTabId int
리턴 void

AddCategoryVersion() 공개 메소드

public AddCategoryVersion ( int itemVersionId, int itemId, int sortOrder, int childDisplayTabId ) : void
itemVersionId int
itemId int
sortOrder int
childDisplayTabId int
리턴 void

AddItem() 공개 메소드

public AddItem ( IDbTransaction trans, int itemTypeId, int portalId, int moduleId, System.Guid itemIdentifier ) : int
trans IDbTransaction
itemTypeId int
portalId int
moduleId int
itemIdentifier System.Guid
리턴 int

AddItemRelationship() 공개 메소드

public AddItemRelationship ( IDbTransaction trans, int childItemId, int childItemVersionId, int parentItemId, int relationshipTypeId, string startDate, string endDate, int sortOrder ) : void
trans IDbTransaction
childItemId int
childItemVersionId int
parentItemId int
relationshipTypeId int
startDate string
endDate string
sortOrder int
리턴 void

AddItemRelationship() 공개 메소드

public AddItemRelationship ( int childItemId, int childItemVersionId, int parentItemId, int relationshipTypeId, string startDate, string endDate, int sortOrder ) : void
childItemId int
childItemVersionId int
parentItemId int
relationshipTypeId int
startDate string
endDate string
sortOrder int
리턴 void

AddItemRelationshipWithOriginalSortOrder() 공개 메소드

public AddItemRelationshipWithOriginalSortOrder ( IDbTransaction trans, int childItemId, int childItemVersionId, int parentItemId, int relationshipTypeId, string startDate, string endDate, int originalItemVersionId ) : void
trans IDbTransaction
childItemId int
childItemVersionId int
parentItemId int
relationshipTypeId int
startDate string
endDate string
originalItemVersionId int
리턴 void

AddItemTag() 공개 메소드

public AddItemTag ( IDbTransaction trans, int itemVersionId, int tagId ) : void
trans IDbTransaction
itemVersionId int
tagId int
리턴 void

AddItemTag() 공개 메소드

public AddItemTag ( int itemVersionId, int tagId ) : void
itemVersionId int
tagId int
리턴 void

AddItemVersion() 공개 메소드

public AddItemVersion ( IDbTransaction trans, int itemId, int originalItemVersionId, string name, string description, string startDate, string endDate, int languageId, int authorUserId, string metaKeywords, string metaDescription, string metaTitle, int displayTabId, bool disabled, string thumbnail, System.Guid itemVersionIdentifier, string url, bool newWindow, int revisingUserId ) : int
trans IDbTransaction
itemId int
originalItemVersionId int
name string
description string
startDate string
endDate string
languageId int
authorUserId int
metaKeywords string
metaDescription string
metaTitle string
displayTabId int
disabled bool
thumbnail string
itemVersionIdentifier System.Guid
url string
newWindow bool
revisingUserId int
리턴 int

AddItemVersion() 공개 메소드

public AddItemVersion ( int itemId, int originalItemVersionId, string name, string description, string startDate, string endDate, int languageId, int authorUserId, string metaKeywords, string metaDescription, string metaTitle, int displayTabId, bool disabled, string thumbnail, System.Guid itemVersionIdentifier, string url, bool newWindow, int revisingUserId ) : int
itemId int
originalItemVersionId int
name string
description string
startDate string
endDate string
languageId int
authorUserId int
metaKeywords string
metaDescription string
metaTitle string
displayTabId int
disabled bool
thumbnail string
itemVersionIdentifier System.Guid
url string
newWindow bool
revisingUserId int
리턴 int

AddItemVersionSetting() 공개 메소드

public AddItemVersionSetting ( IDbTransaction trans, int itemVersionId, string controlName, string propertyName, string propertyValue ) : void
trans IDbTransaction
itemVersionId int
controlName string
propertyName string
propertyValue string
리턴 void

AddItemVersionSetting() 공개 메소드

public AddItemVersionSetting ( int itemVersionId, string controlName, string propertyName, string propertyValue ) : void
itemVersionId int
controlName string
propertyName string
propertyValue string
리턴 void

AddTag() 공개 메소드

public AddTag ( IDbTransaction trans, Tag tag ) : int
trans IDbTransaction
tag Tag
리턴 int

AddTag() 공개 메소드

public AddTag ( Tag tag ) : int
tag Tag
리턴 int

CheckItemTag() 공개 메소드

public CheckItemTag ( IDbTransaction trans, int itemId, int tagId ) : int
trans IDbTransaction
itemId int
tagId int
리턴 int

CheckItemTag() 공개 메소드

public CheckItemTag ( int itemId, int tagId ) : int
itemId int
tagId int
리턴 int

ClearItemsCommentCount() 공개 메소드

public ClearItemsCommentCount ( int portalId ) : void
portalId int
리턴 void

ClearItemsViewCount() 공개 메소드

public ClearItemsViewCount ( int portalId ) : void
portalId int
리턴 void

CommentsWaitingForApprovalCount() 공개 메소드

public CommentsWaitingForApprovalCount ( int portalId, int authorUserId ) : int
portalId int
authorUserId int
리턴 int

ConvertTagsToXml() 공개 정적인 메소드

public static ConvertTagsToXml ( ArrayList tagIds ) : object
tagIds System.Collections.ArrayList
리턴 object

DeleteItem() 공개 메소드

public DeleteItem ( int itemId ) : void
itemId int
리턴 void

DeleteItems() 공개 메소드

public DeleteItems ( ) : void
리턴 void

DeletePermissions() 공개 메소드

public DeletePermissions ( int categoryId ) : void
categoryId int
리턴 void

FindItemId() 공개 메소드

public FindItemId ( string name, int authorUserId ) : int
name string
authorUserId int
리턴 int

FindItemId() 공개 메소드

public FindItemId ( string name, int authorUserId, int categoryId ) : int
name string
authorUserId int
categoryId int
리턴 int

GetAdminCommentListing() 공개 메소드

public GetAdminCommentListing ( int categoryId, int approvalStatusId, int portalId, int authorUserId, string articleSearch ) : DataSet
categoryId int
approvalStatusId int
portalId int
authorUserId int
articleSearch string
리턴 System.Data.DataSet

GetAdminItemListing() 공개 메소드

public GetAdminItemListing ( int parentItemId, int itemTypeId, int relationshipTypeId, int approvalStatusId, int portalId ) : DataSet
parentItemId int
itemTypeId int
relationshipTypeId int
approvalStatusId int
portalId int
리턴 System.Data.DataSet

GetAdminItemListing() 공개 메소드

public GetAdminItemListing ( int parentItemId, int itemTypeId, int relationshipTypeId, int otherRelationshipTypeId, int approvalStatusId, int portalId ) : DataSet
parentItemId int
itemTypeId int
relationshipTypeId int
otherRelationshipTypeId int
approvalStatusId int
portalId int
리턴 System.Data.DataSet

GetAdminItemListing() 공개 메소드

public GetAdminItemListing ( int parentItemId, int itemTypeId, int relationshipTypeId, int otherRelationshipTypeId, int approvalStatusId, string orderBy, int portalId ) : DataSet
parentItemId int
itemTypeId int
relationshipTypeId int
otherRelationshipTypeId int
approvalStatusId int
orderBy string
portalId int
리턴 System.Data.DataSet

GetAdminItemListing() 공개 메소드

public GetAdminItemListing ( int parentItemId, int itemTypeId, int relationshipTypeId, int approvalStatusId, string orderBy, int portalId ) : DataSet
parentItemId int
itemTypeId int
relationshipTypeId int
approvalStatusId int
orderBy string
portalId int
리턴 System.Data.DataSet

GetAdminItemListingSearchKey() 공개 메소드

public GetAdminItemListingSearchKey ( int parentItemId, int itemTypeId, int relationshipTypeId, int otherRelationshipTypeId, int approvalStatusId, string orderBy, string searchKey, int portalId ) : DataSet
parentItemId int
itemTypeId int
relationshipTypeId int
otherRelationshipTypeId int
approvalStatusId int
orderBy string
searchKey string
portalId int
리턴 System.Data.DataSet

GetAdminKeywordSearch() 공개 메소드

public GetAdminKeywordSearch ( string searchString, int itemTypeId, int portalId ) : DataSet
searchString string
itemTypeId int
portalId int
리턴 System.Data.DataSet

GetAdminKeywordSearch() 공개 메소드

public GetAdminKeywordSearch ( string searchString, int itemTypeId, int approvalStatusId, int portalId ) : DataSet
searchString string
itemTypeId int
approvalStatusId int
portalId int
리턴 System.Data.DataSet

GetAllChildCategories() 공개 메소드

public GetAllChildCategories ( int parentItemId, int portalId ) : DataTable
parentItemId int
portalId int
리턴 System.Data.DataTable

GetAllChildren() 공개 메소드

public GetAllChildren ( int parentId, int relationshipTypeId, int portalId ) : DataSet
parentId int
relationshipTypeId int
portalId int
리턴 System.Data.DataSet

GetAllChildren() 공개 메소드

public GetAllChildren ( int itemTypeId, int parentId, int relationshipTypeId, int portalId ) : DataSet
itemTypeId int
parentId int
relationshipTypeId int
portalId int
리턴 System.Data.DataSet

GetAllChildren() 공개 메소드

public GetAllChildren ( int itemTypeId, int parentId, int relationshipTypeId, int otherRelationshipTypeId, int portalId ) : DataSet
itemTypeId int
parentId int
relationshipTypeId int
otherRelationshipTypeId int
portalId int
리턴 System.Data.DataSet

GetAllChildrenAsDataReader() 공개 메소드

public GetAllChildrenAsDataReader ( int itemTypeId, int parentId, int relationshipTypeId, int otherRelationshipTypeId, int portalId ) : IDataReader
itemTypeId int
parentId int
relationshipTypeId int
otherRelationshipTypeId int
portalId int
리턴 IDataReader

GetAllChildrenNLevels() 공개 메소드

public GetAllChildrenNLevels ( int parentCategoryId, int nLevels, int mItems, int portalId ) : DataTable
parentCategoryId int
nLevels int
mItems int
portalId int
리턴 System.Data.DataTable

GetAllRelationships() 공개 메소드

This currently returns all rows in the item relationship table. We may/could filter to only active at some point.
public GetAllRelationships ( int moduleId ) : IDataReader
moduleId int
리턴 IDataReader

GetAllRelationshipsByPortalId() 공개 메소드

public GetAllRelationshipsByPortalId ( int portalId ) : IDataReader
portalId int
리턴 IDataReader

GetApprovalStatusId() 공개 메소드

public GetApprovalStatusId ( string itemName ) : IDataReader
itemName string
리턴 IDataReader

GetApprovalStatusTypeName() 공개 메소드

public GetApprovalStatusTypeName ( int approvalStatusId ) : string
approvalStatusId int
리턴 string

GetApprovalStatusTypes() 공개 메소드

public GetApprovalStatusTypes ( int portalId ) : DataSet
portalId int
리턴 System.Data.DataSet

GetApprovalStatusTypesForAuthors() 공개 메소드

public GetApprovalStatusTypesForAuthors ( int portalId ) : DataSet
portalId int
리턴 System.Data.DataSet

GetArticle() 공개 메소드

public GetArticle ( int itemId ) : IDataReader
itemId int
리턴 IDataReader

GetArticle() 공개 메소드

public GetArticle ( int itemId, int portalId ) : IDataReader
itemId int
portalId int
리턴 IDataReader

GetArticleVersion() 공개 메소드

public GetArticleVersion ( int itemVersionId, int portalId ) : IDataReader
itemVersionId int
portalId int
리턴 IDataReader

GetArticles() 공개 메소드

public GetArticles ( int portalId ) : DataTable
portalId int
리턴 System.Data.DataTable

GetArticles() 공개 메소드

public GetArticles ( int parentItemId, int portalId ) : DataTable
parentItemId int
portalId int
리턴 System.Data.DataTable

GetArticlesByModuleId() 공개 메소드

public GetArticlesByModuleId ( int moduleId ) : DataTable
moduleId int
리턴 System.Data.DataTable

GetArticlesByModuleIdCurrent() 공개 메소드

public GetArticlesByModuleIdCurrent ( int moduleId ) : DataTable
moduleId int
리턴 System.Data.DataTable

GetArticlesByPortalId() 공개 메소드

public GetArticlesByPortalId ( int portalId ) : DataTable
portalId int
리턴 System.Data.DataTable

GetArticlesSearchIndexingNew() 공개 메소드

public GetArticlesSearchIndexingNew ( int portalId, int displayTabId ) : DataTable
portalId int
displayTabId int
리턴 System.Data.DataTable

GetArticlesSearchIndexingUpdated() 공개 메소드

public GetArticlesSearchIndexingUpdated ( int portalId, int moduleDefId, int displayTabId ) : DataTable
portalId int
moduleDefId int
displayTabId int
리턴 System.Data.DataTable

GetAssignedRoles() 공개 메소드

public GetAssignedRoles ( int categoryId ) : DataTable
categoryId int
리턴 System.Data.DataTable

GetCategories() 공개 메소드

public GetCategories ( int portalId ) : DataTable
portalId int
리턴 System.Data.DataTable

GetCategoriesByModuleId() 공개 메소드

public GetCategoriesByModuleId ( int moduleId ) : DataTable
moduleId int
리턴 System.Data.DataTable

GetCategoriesByPortalId() 공개 메소드

public GetCategoriesByPortalId ( int portalId ) : DataTable
portalId int
리턴 System.Data.DataTable

GetCategoriesHierarchy() 공개 메소드

public GetCategoriesHierarchy ( int portalId ) : DataTable
portalId int
리턴 System.Data.DataTable

GetCategory() 공개 메소드

public GetCategory ( int itemId ) : IDataReader
itemId int
리턴 IDataReader

GetCategory() 공개 메소드

public GetCategory ( int itemId, int portalId ) : IDataReader
itemId int
portalId int
리턴 IDataReader

GetCategoryItemId() 공개 메소드

public GetCategoryItemId ( string categoryName, int portalId ) : int
categoryName string
portalId int
리턴 int

GetCategoryItems() 공개 메소드

public GetCategoryItems ( int categoryId, int itemTypeId ) : DataSet
categoryId int
itemTypeId int
리턴 System.Data.DataSet

GetCategoryItems() 공개 메소드

public GetCategoryItems ( int categoryId, int itemTypeId, int approvalStatusId ) : DataSet
categoryId int
itemTypeId int
approvalStatusId int
리턴 System.Data.DataSet

GetCategoryItems() 공개 메소드

public GetCategoryItems ( int categoryId, int itemTypeId, int approvalStatusId, SearchSortOption sort ) : DataSet
categoryId int
itemTypeId int
approvalStatusId int
sort SearchSortOption
리턴 System.Data.DataSet

GetCategoryListing() 공개 메소드

public GetCategoryListing ( int parentItemId, int portalId ) : IDataReader
parentItemId int
portalId int
리턴 IDataReader

GetCategoryVersion() 공개 메소드

public GetCategoryVersion ( int itemVersionId, int portalId ) : IDataReader
itemVersionId int
portalId int
리턴 IDataReader

GetChildCategories() 공개 메소드

public GetChildCategories ( int parentItemId, int portalId ) : DataTable
parentItemId int
portalId int
리턴 System.Data.DataTable

GetChildCategories() 공개 메소드

public GetChildCategories ( int parentItemId, int portalId, int itemTypeId ) : DataTable
parentItemId int
portalId int
itemTypeId int
리턴 System.Data.DataTable

GetChildrenInCategory() 공개 메소드

public GetChildrenInCategory ( int categoryId, int childTypeId, int maxItems, int portalId ) : DataTable
categoryId int
childTypeId int
maxItems int
portalId int
리턴 System.Data.DataTable

GetChildrenInCategory() 공개 메소드

public GetChildrenInCategory ( int categoryId, int childTypeId, int maxItems, int portalId, string sortOrder ) : DataTable
categoryId int
childTypeId int
maxItems int
portalId int
sortOrder string
리턴 System.Data.DataTable

GetChildrenInCategoryPaging() 공개 메소드

public GetChildrenInCategoryPaging ( int categoryId, int childTypeId, int maxItems, int portalId, bool customSort, bool customSortDirection, string sortOrder, int index, int pageSize ) : DataTable
categoryId int
childTypeId int
maxItems int
portalId int
customSort bool
customSortDirection bool
sortOrder string
index int
pageSize int
리턴 System.Data.DataTable

GetComments() 공개 메소드

public GetComments ( int itemId, int approvalStatusId ) : IDataReader
itemId int
approvalStatusId int
리턴 IDataReader

GetDataTable() 공개 메소드

public GetDataTable ( string sql, int portalId ) : DataTable
sql string
portalId int
리턴 System.Data.DataTable

GetItem() 공개 메소드

public GetItem ( int itemId, int portalId, bool isCurrent ) : IDataReader
itemId int
portalId int
isCurrent bool
리턴 IDataReader

GetItemChildRelationships() 공개 메소드

public GetItemChildRelationships ( int parentItemId, int relationshipTypeId ) : IDataReader
parentItemId int
relationshipTypeId int
리턴 IDataReader

GetItemIdFromVersion() 공개 메소드

public GetItemIdFromVersion ( int itemVersionId ) : int
itemVersionId int
리턴 int

GetItemIdFromVersion() 공개 메소드

public GetItemIdFromVersion ( int itemVersionId, int portalId ) : int
itemVersionId int
portalId int
리턴 int

GetItemName() 공개 메소드

public GetItemName ( int itemId ) : string
itemId int
리턴 string

GetItemRelationshipByIdentifiers() 공개 메소드

public GetItemRelationshipByIdentifiers ( System.Guid parentItemIdentifier, System.Guid childItemVersionIdentifier, int currentPortalId ) : IDataReader
parentItemIdentifier System.Guid
childItemVersionIdentifier System.Guid
currentPortalId int
리턴 IDataReader

GetItemRelationshipByItemRelationshipId() 공개 메소드

public GetItemRelationshipByItemRelationshipId ( int itemRelationshipId ) : DataSet
itemRelationshipId int
리턴 System.Data.DataSet

GetItemRelationships() 공개 메소드

public GetItemRelationships ( int childItemId, int childItemVersionId, bool isActive ) : IDataReader
childItemId int
childItemVersionId int
isActive bool
리턴 IDataReader

GetItemRelationships() 공개 메소드

public GetItemRelationships ( int childItemId, int childItemVersionId, int relationshipTypeId, bool isActive ) : IDataReader
childItemId int
childItemVersionId int
relationshipTypeId int
isActive bool
리턴 IDataReader

GetItemTags() 공개 메소드

public GetItemTags ( int itemVersionId ) : IDataReader
itemVersionId int
리턴 IDataReader

GetItemType() 공개 메소드

public GetItemType ( string itemName ) : IDataReader
itemName string
리턴 IDataReader

GetItemType() 공개 메소드

public GetItemType ( int itemId ) : string
itemId int
리턴 string

GetItemTypeFromVersion() 공개 메소드

public GetItemTypeFromVersion ( int itemVersionId ) : string
itemVersionId int
리턴 string

GetItemTypeId() 공개 메소드

public GetItemTypeId ( int itemId ) : int
itemId int
리턴 int

GetItemTypeName() 공개 메소드

public GetItemTypeName ( int itemTypeId ) : string
itemTypeId int
리턴 string

GetItemTypeName() 공개 메소드

public GetItemTypeName ( int itemTypeId, bool useCache, int portalId, int cacheTime ) : string
itemTypeId int
useCache bool
portalId int
cacheTime int
리턴 string

GetItemTypes() 공개 메소드

public GetItemTypes ( ) : DataTable
리턴 System.Data.DataTable

GetItemVersion() 공개 메소드

public GetItemVersion ( System.Guid guid, int portalId ) : IDataReader
guid System.Guid
portalId int
리턴 IDataReader

GetItemVersionInfo() 공개 메소드

public GetItemVersionInfo ( int itemVersionId ) : IDataReader
itemVersionId int
리턴 IDataReader

GetItemVersionSettings() 공개 메소드

public GetItemVersionSettings ( int itemVersionId ) : IDataReader
itemVersionId int
리턴 IDataReader

GetItemVersionSettings() 공개 메소드

public GetItemVersionSettings ( int itemVersionId, string controlName ) : IDataReader
itemVersionId int
controlName string
리턴 IDataReader

GetItemVersionSettingsByModuleId() 공개 메소드

public GetItemVersionSettingsByModuleId ( int moduleId ) : IDataReader
moduleId int
리턴 IDataReader

GetItemVersionSettingsByPortalId() 공개 메소드

public GetItemVersionSettingsByPortalId ( int portalId ) : IDataReader
portalId int
리턴 IDataReader

GetItemVersions() 공개 메소드

public GetItemVersions ( int itemId, int portalId ) : DataSet
itemId int
portalId int
리턴 System.Data.DataSet

GetItemViewPaging() 공개 메소드

public GetItemViewPaging ( int itemTypeId, int categoryId, int pageIndex, int pageSize, string sortOrder, string startDate, string endDate, int portalId ) : DataTable
itemTypeId int
categoryId int
pageIndex int
pageSize int
sortOrder string
startDate string
endDate string
portalId int
리턴 System.Data.DataTable

GetItems() 공개 메소드

public GetItems ( int parentItemId, int portalId, int relationshipTypeId ) : DataSet
parentItemId int
portalId int
relationshipTypeId int
리턴 System.Data.DataSet

GetItems() 공개 메소드

public GetItems ( int parentItemId, int portalId, int relationshipTypeId, int itemTypeId ) : DataSet
parentItemId int
portalId int
relationshipTypeId int
itemTypeId int
리턴 System.Data.DataSet

GetItems() 공개 메소드

public GetItems ( int parentItemId, int portalId, int relationshipTypeId, int otherRelationshipTypeId, int itemTypeId ) : DataSet
parentItemId int
portalId int
relationshipTypeId int
otherRelationshipTypeId int
itemTypeId int
리턴 System.Data.DataSet

GetItems() 공개 메소드

public GetItems ( int itemTypeId, int portalId ) : IDataReader
itemTypeId int
portalId int
리턴 IDataReader

GetItemsFromTags() 공개 메소드

public GetItemsFromTags ( int portalId, ArrayList tagList ) : DataTable
portalId int
tagList System.Collections.ArrayList
리턴 System.Data.DataTable

GetItemsFromTagsPaging() 공개 메소드

public GetItemsFromTagsPaging ( int portalId, ArrayList tagList, int maxItems, int pageId, string sortOrder ) : DataTable
portalId int
tagList System.Collections.ArrayList
maxItems int
pageId int
sortOrder string
리턴 System.Data.DataTable

GetModuleInfo() 공개 메소드

public GetModuleInfo ( int moduleId ) : IDataReader
moduleId int
리턴 IDataReader

GetMostPopular() 공개 메소드

public GetMostPopular ( int categoryId, int childTypeId, int maxItems, int portalId ) : DataTable
categoryId int
childTypeId int
maxItems int
portalId int
리턴 System.Data.DataTable

GetMostRecent() 공개 메소드

public GetMostRecent ( int childTypeId, int maxItems, int portalId ) : DataTable
childTypeId int
maxItems int
portalId int
리턴 System.Data.DataTable

GetMostRecentByCategoryId() 공개 메소드

public GetMostRecentByCategoryId ( int categoryId, int childTypeId, int maxItems, int portalId ) : DataTable
categoryId int
childTypeId int
maxItems int
portalId int
리턴 System.Data.DataTable

GetOldArticleId() 공개 메소드

public GetOldArticleId ( int itemId ) : int
itemId int
리턴 int

GetOldCategoryId() 공개 메소드

public GetOldCategoryId ( int itemId ) : int
itemId int
리턴 int

GetParentCategories() 공개 메소드

public GetParentCategories ( int articleId, int portalId ) : DataTable
articleId int
portalId int
리턴 System.Data.DataTable

GetParentCategory() 공개 메소드

public GetParentCategory ( int childItemId, int portalId ) : int
childItemId int
portalId int
리턴 int

GetParentItems() 공개 메소드

public GetParentItems ( int itemId, int portalId, int relationshipTypeId ) : DataSet
itemId int
portalId int
relationshipTypeId int
리턴 System.Data.DataSet

GetPermissionType() 공개 메소드

public GetPermissionType ( string permissionName ) : IDataReader
permissionName string
리턴 IDataReader

GetPopularTags() 공개 메소드

public GetPopularTags ( int portalId, ArrayList tagList, bool selectTop ) : DataTable
portalId int
tagList System.Collections.ArrayList
selectTop bool
리턴 System.Data.DataTable

GetPopularTagsCount() 공개 메소드

public GetPopularTagsCount ( int portalId, ArrayList tagList, bool selectTop ) : int
portalId int
tagList System.Collections.ArrayList
selectTop bool
리턴 int

GetPublishModuleId() 공개 메소드

public GetPublishModuleId ( string moduleTitle, int portalId ) : IDataReader
moduleTitle string
portalId int
리턴 IDataReader

GetPublishTabId() 공개 메소드

public GetPublishTabId ( string tabName, int portalId ) : IDataReader
tabName string
portalId int
리턴 IDataReader

GetPublishTabName() 공개 메소드

public GetPublishTabName ( int tabId, int portalId ) : IDataReader
tabId int
portalId int
리턴 IDataReader

GetRelationshipType() 공개 메소드

public GetRelationshipType ( string relationshipName ) : IDataReader
relationshipName string
리턴 IDataReader

GetSimpleGalleryAlbums() 공개 메소드

Could not retrieve the module's version to determine which stored procedure to use
public GetSimpleGalleryAlbums ( int moduleId ) : IDataReader
moduleId int
리턴 IDataReader

GetSimpleGalleryPhotos() 공개 메소드

Could not retrieve the module's version to determine which stored procedure to use
public GetSimpleGalleryPhotos ( int albumId, int maxCount ) : DataTable
albumId int
maxCount int
리턴 System.Data.DataTable

GetTag() 공개 메소드

public GetTag ( int tagId ) : DataTable
tagId int
리턴 System.Data.DataTable

GetTag() 공개 메소드

public GetTag ( string tag, int portalId ) : DataTable
tag string
portalId int
리턴 System.Data.DataTable

GetTags() 공개 메소드

public GetTags ( int portalId ) : DataTable
portalId int
리턴 System.Data.DataTable

GetTagsByString() 공개 메소드

public GetTagsByString ( string partialTag, int portalId ) : DataTable
partialTag string
portalId int
리턴 System.Data.DataTable

GetTopLevelCategories() 공개 메소드

public GetTopLevelCategories ( int portalId ) : DataSet
portalId int
리턴 System.Data.DataSet

GetTopLevelCategoryItem() 공개 메소드

public GetTopLevelCategoryItem ( string itemName ) : IDataReader
itemName string
리턴 IDataReader

GetUltraMediaGalleryAlbums() 공개 메소드

public GetUltraMediaGalleryAlbums ( int moduleId ) : IDataReader
moduleId int
리턴 IDataReader

GetUltraMediaGalleryPhotos() 공개 메소드

public GetUltraMediaGalleryPhotos ( int albumId, int maxCount ) : DataTable
albumId int
maxCount int
리턴 System.Data.DataTable

GetViewableArticleIds() 공개 메소드

public GetViewableArticleIds ( int permissionId ) : IDictionary
permissionId int
리턴 IDictionary

GetViewableCategoryIds() 공개 메소드

public GetViewableCategoryIds ( int permissionId ) : IDictionary
permissionId int
리턴 IDictionary

InsertPermission() 공개 메소드

public InsertPermission ( int categoryId, int roleId, int permissionId, int userId ) : void
categoryId int
roleId int
permissionId int
userId int
리턴 void

RunPublishStats() 공개 메소드

public RunPublishStats ( ) : void
리턴 void

SqlDataProvider() 공개 메소드

public SqlDataProvider ( ) : System
리턴 System

UpdateDescription() 공개 메소드

public UpdateDescription ( int itemVersionId, string description, string metaDescription ) : void
itemVersionId int
description string
metaDescription string
리턴 void

UpdateItem() 공개 메소드

public UpdateItem ( IDbTransaction trans, int itemId, int moduleId ) : void
trans IDbTransaction
itemId int
moduleId int
리턴 void

UpdateItemRelationship() 공개 메소드

public UpdateItemRelationship ( int itemRelationshipId, int sortOrder ) : void
itemRelationshipId int
sortOrder int
리턴 void

UpdateItemVersion() 공개 메소드

public UpdateItemVersion ( IDbTransaction trans, int itemId, int itemVersionId, int approvalStatusId, int userId, string approvalComments ) : void
trans IDbTransaction
itemId int
itemVersionId int
approvalStatusId int
userId int
approvalComments string
리턴 void

UpdateTag() 공개 메소드

public UpdateTag ( IDbTransaction trans, Tag tag ) : void
trans IDbTransaction
tag Tag
리턴 void

UpdateTag() 공개 메소드

public UpdateTag ( Tag tag ) : void
tag Tag
리턴 void

UpdateVenexusBraindump() 공개 메소드

public UpdateVenexusBraindump ( int itemId, string indexTitle, string indexContent, string indexWashedContent, int portalId, string indexUrl ) : void
itemId int
indexTitle string
indexContent string
indexWashedContent string
portalId int
indexUrl string
리턴 void

WaitingForApprovalCount() 공개 메소드

public WaitingForApprovalCount ( int portalId ) : int
portalId int
리턴 int