protected void LoadAdditionalFilters()
{
foreach (String key in DataTablesrequest.AdditionalFilters.Keys)
{
SPParams.Add(key, DataTablesrequest.AdditionalFilters[key]);
}
}
protected void LoadColumnsFilters()
{
foreach (Column column in DataTablesrequest.Columns)
{
if (column.Search.Value != null && column.Search.Value != String.Empty)
{
SPParams.Add(column.Name, column.Search.Value);
}
}
}
public void AddParameter(string paramName, object paramValue, DbType dbtype, ParameterDirection pDirection)
{
SqlParameter p = new SqlParameter();
p.DbType = dbtype;
p.ParameterName = paramName;
p.Value = paramValue;
p.Direction = pDirection;
SPParams.Add(p);
}
protected void LoadColumnsToOrder()
{
byte count = 0;
String OrderBy = "";
foreach (ColumnOrder columnToOrder in DataTablesrequest.Order)
{
OrderBy += (count > 0 ? ", " : "") + DataTablesrequest.Columns[columnToOrder.Column].Name + " " + columnToOrder.Dir;
count++;
}
SPParams.Add("OrderBy", OrderBy);
}