private void AddColumnSorterHash(
Context context, SiteSettings ss, string columnName, SqlOrderBy.Types value)
{
if (ColumnSorterHash == null)
{
ColumnSorterHash = new Dictionary <string, SqlOrderBy.Types>();
}
var column = ss.GetColumn(context: context, columnName: columnName);
if (column != null)
{
if (value != SqlOrderBy.Types.release)
{
if (ColumnSorterHash.ContainsKey(columnName))
{
ColumnSorterHash.Remove(columnName);
ColumnSorterHash = ColumnSorterHash.ToDictionary(o => o.Key, o => o.Value);
ColumnSorterHash.Add(columnName, value);
}
else
{
ColumnSorterHash.Add(columnName, value);
}
}
else if (ColumnSorterHash.ContainsKey(columnName))
{
ColumnSorterHash.Remove(columnName);
ColumnSorterHash = ColumnSorterHash.ToDictionary(o => o.Key, o => o.Value);
}
}
}
internal Column(string columnName, int no, string orderType, bool unique = false)
{
ColumnName = columnName;
No = no;
switch (orderType.ToLower())
{
case "asc": OrderType = SqlOrderBy.Types.asc; break;
case "desc": OrderType = SqlOrderBy.Types.desc; break;
default: OrderType = SqlOrderBy.Types.asc; break;
}
Unique = unique;
}
public SqlOrderByCollection Add(
string columnBracket,
SqlOrderBy.Types orderType,
string tableName,
Sqls.Functions function = Sqls.Functions.None)
{
if (orderType != SqlOrderBy.Types.release)
{
Add(new SqlOrderBy(
columnBracket: columnBracket,
orderType: orderType,
tableName: tableName,
function: function));
}
return(this);
}
public SqlOrderByCollection Add(
string columnBracket = null,
SqlOrderBy.Types orderType = SqlOrderBy.Types.asc,
string tableName = null,
string isNullValue = null,
Sqls.Functions function = Sqls.Functions.None,
SqlStatement sub = null,
string raw = null)
{
if (orderType != SqlOrderBy.Types.release)
{
Add(new SqlOrderBy(
columnBracket: columnBracket,
orderType: orderType,
tableName: tableName,
isNullValue: isNullValue,
function: function,
sub: sub,
raw: raw));
}
return(this);
}
