/// <summary>
/// Returns string for ORDER BY clause and disables remembering unigrid state.
/// </summary>
private string GetOrderBy()
{
string orderBy = null;
// OrderBy specified by drop-down list
switch (OrderBy)
{
case ORDERBY_DATE_ASC:
orderBy = SqlHelper.AddOrderBy(orderBy, ORDERBY_DATE_ASC);
break;
case ORDERBY_PRICE_ASC:
orderBy = SqlHelper.AddOrderBy(orderBy, ORDERBY_PRICE_ASC);
break;
case ORDERBY_PRICE_DESC:
orderBy = SqlHelper.AddOrderBy(orderBy, ORDERBY_PRICE_DESC);
break;
case ORDERBY_DATE_DESC:
default:
orderBy = SqlHelper.AddOrderBy(orderBy, ORDERBY_DATE_DESC);
break;
}
// Disables remembering unigrid state
gridElem.RememberState = false;
return(orderBy);
}
/// <summary>
/// Returns string for ORDER BY clause.
/// </summary>
private string GetOrderBy()
{
// OrderBy specified by drop-down list
string column = null;
switch (OrderBy)
{
case ORDER_BY_NAME_DESC:
column = "SKUName DESC";
break;
case ORDER_BY_NUMBER_ASC:
column = "SKUNumber ASC";
break;
case ORDER_BY_NUMBER_DESC:
column = "SKUNumber DESC";
break;
case ORDER_BY_PRICE_ASC:
column = "SKUPrice ASC";
break;
case ORDER_BY_PRICE_DESC:
column = "SKUPrice DESC";
break;
case ORDER_BY_DATE_DESC:
column = "SKUCreated DESC";
break;
case ORDER_BY_DATE_ASC:
column = "SKUCreated ASC";
break;
case ORDER_BY_AVAILABLE_ITEMS_ASC:
column = "SKUAvailableItems ASC";
break;
case ORDER_BY_REORDER_DESC:
column = "(ISNULL(SKUReorderAt,0) - SKUAvailableItems) DESC";
break;
case ORDER_BY_NAME_ASC:
default:
column = "SKUName ASC";
break;
}
// Disables remembering unigrid state
gridElem.RememberState = false;
return(SqlHelper.AddOrderBy("", column));
}
/// <summary>
/// DocumentQuery that mimics the Hierarchy Viewer webpart, with caching included.
/// </summary>
/// <param name="Path">The Path for the documents to select</param>
/// <param name="ClassNames">Class Names to include, semicolon seperated.</param>
/// <param name="CombineWithDefaultCulture"></param>
/// <param name="CultureCode"></param>
/// <param name="MaxRelativeLevel"></param>
/// <param name="UseHierarchicalOrder">Ensures the NodeLevel, NodeOrder is set first as the order.</param>
/// <param name="AdditionalOrderBy"></param>
/// <param name="SelectOnlyPublished"></param>
/// <param name="SiteName"></param>
/// <param name="WhereCondition"></param>
/// <param name="Columns"></param>
/// <param name="FilterOutDuplicates"></param>
/// <param name="RelationshipWithNodeGuid">The Relationship to use, defaults to the current page.</param>
/// <param name="RelatedNodeIsOnTheLeftSide"></param>
/// <param name="RelationshipName"></param>
/// <param name="CheckPermission"></param>
/// <param name="LoadPagesIndividually"></param>
/// <param name="CacheItemName">The Cache Item Name, required if you wish to cache.</param>
/// <param name="CacheMinutes">The Cache minutes, if not provided uses the site default.</param>
/// <param name="CacheDependencies">Any cache dependencies</param>
/// <returns></returns>
public static CacheableDocumentQuery HierarchyViewerQuery(
string Path = "/%",
string ClassNames = null,
bool CombineWithDefaultCulture = false,
string CultureCode = null,
int MaxRelativeLevel = -1,
bool UseHierarchicalOrder = true,
string AdditionalOrderBy = null,
bool SelectOnlyPublished = true,
string SiteName = null,
string WhereCondition = null,
string Columns = null,
bool FilterOutDuplicates = false,
Guid RelationshipWithNodeGuid = new Guid(),
bool RelatedNodeIsOnTheLeftSide = true,
string RelationshipName = null,
bool CheckPermission = false,
bool LoadPagesIndividually = false,
string CacheItemName = null,
int CacheMinutes = -1,
string[] CacheDependencies = null
)
{
AdditionalOrderBy = !string.IsNullOrWhiteSpace(AdditionalOrderBy) ? AdditionalOrderBy : "1";
if (UseHierarchicalOrder)
{
AdditionalOrderBy = SqlHelper.AddOrderBy(AdditionalOrderBy, "NodeLevel, NodeOrder");
}
return(RepeaterQuery(
Path: Path,
ClassNames: ClassNames,
CombineWithDefaultCulture: CombineWithDefaultCulture,
CultureCode: CultureCode,
MaxRelativeLevel: MaxRelativeLevel,
OrderBy: AdditionalOrderBy,
SelectOnlyPublished: SelectOnlyPublished,
SelectTopN: -1,
SiteName: SiteName,
WhereCondition: WhereCondition,
Columns: Columns,
FilterOutDuplicates: FilterOutDuplicates,
RelationshipWithNodeGuid: RelationshipWithNodeGuid,
RelatedNodeIsOnTheLeftSide: RelatedNodeIsOnTheLeftSide,
RelationshipName: RelationshipName,
CheckPermission: CheckPermission,
LoadPagesIndividually: LoadPagesIndividually,
CacheItemName: CacheItemName,
CacheMinutes: CacheMinutes,
CacheDependencies: CacheDependencies));
}
public IEnumerable <T> PagerList <T>(string sql, int pageindex, out int count, string defaultsort = "", IDbDataParameter[] paramters = null)
{
StringBuilder sqlcountbuilder = new StringBuilder(sql);
StringBuilder sqlrownumbuilder = new StringBuilder(sql);
SqlHelper.Driver = this;
SqlHelper.AddCounter(sqlcountbuilder);
SqlHelper.AddPager(pageindex, pagesize, sqlrownumbuilder, defaultsort);
if (OrderByName != null)
{
SqlHelper.AddOrderBy(OrderByName, OrderByOrder == OrderBy.Asc ? true : false, defaultsort, sqlrownumbuilder);
}
count = Int32.Parse(ExecuteScalar(sqlcountbuilder.ToString(), paramters).ToString());
return(FindAll <T>(sqlrownumbuilder.ToString(), paramters));
}