public override DataSet GetCategoryItems(int categoryId, int itemTypeId, int approvalStatusId, SearchSortOption sort)
{
var sql = new StringBuilder(512);
sql.Append("select ");
sql.Append(
"childItemId ItemId, ChildItemVersionId ItemVersionId, iv.DisplayTabId, iv.[Name] 'Name', ItemVersionDate, it.[Name] 'ItemType' ");
sql.Append("from ");
sql.Append(this.NamePrefix);
sql.Append("fnGetChildItemsAdminSearch(");
sql.Append(categoryId);
sql.Append(") fp ");
sql.Append("join ");
sql.Append(this.NamePrefix);
sql.Append("ItemVersion iv on (fp.ChildItemId = iv.ItemId and fp.ChildItemVersionId = iv.ItemVersionId) ");
sql.Append("join ");
sql.Append(this.NamePrefix);
sql.Append("ItemType it on (fp.ItemTypeId = it.ItemTypeId) ");
sql.Append("where fp.ItemTypeId = ");
sql.Append(itemTypeId);
if (approvalStatusId != -1)
{
sql.Append(" and ApprovalStatusId = "); // 3 ");
sql.Append(approvalStatusId);
}
sql.Append(" order by ");
switch (sort)
{
case SearchSortOption.ItemId:
sql.Append("ChildItemId");
break;
case SearchSortOption.Name:
sql.Append("iv.Name");
break;
case SearchSortOption.UpdatedDate:
sql.Append("ItemVersionDate");
break;
default:
sql.Append("ChildItemId");
break;
}
return SqlHelper.ExecuteDataset(this.ConnectionString, CommandType.Text, sql.ToString());
}
public abstract DataSet GetCategoryItems(int categoryId, int itemTypeId, int approvalStatusId, SearchSortOption sort);
public abstract DataSet GetCategoryItems(int categoryId, int itemTypeId, int approvalStatusId, SearchSortOption sort);
