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);
         }
     }
 }
示例#3
0
        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);
        }