public static StringBuilder BuildOrderField <T>(OrderFieldStore <T> orderFieldStore) where T : class
{
StringBuilder sqlCommand = new StringBuilder();
bool ordered = false;
foreach (OrderField <T> orderField in orderFieldStore.OrderFields)
{
string orderType = string.Empty;
if (orderField.OrderType == OrderType.Descending)
{
orderType = "DESC";
}
else if (orderField.OrderType == OrderType.Ascending)
{
orderType = "ASC";
}
if (!string.IsNullOrEmpty(orderType))
{
sqlCommand.Append(ordered ? "," : "ORDER BY ");
string sortField = orderField.OrderKey;
sqlCommand.Append(sortField + " " + orderType);
ordered = true;
}
}
return(sqlCommand);
}
public OrderPagingQuery()
{
OrderFieldStore = new OrderFieldStore <TModel>();
}