private FilterElement(string key, IEnumerable <short> values)
{
this.Key = key;
this.Operator = FilterOperator.In.Value;
this.Value = values.ToList();
this.DataType = PfeDataType.Number;
}
internal FilterElement(string key, FilterOperator op, object value)
{
this.Key = key;
//support null value
if (value == null)
{
if (op.Value == FilterOperator.Eq.Value || op.Value == FilterOperator.Null.Value)
{
this.Operator = FilterOperator.Null.Value;
}
else
{
this.Operator = FilterOperator.NotNull.Value;
}
}
else
{
this.Operator = op.Value;
this.DataType = GetPfeDataType(value.GetType());
this.Value = value;
// this.Parameters.Add(string.Format("@{0}", key), value);
//if (this.DataType == PfeDataType.Boolean)
// this.Value = (bool)value ? "1" : "0";
//else if (this.DataType == PfeDataType.DateTime)
// this.Value = ((DateTime)value).ToString("yyyyMMdd HH:mm:ss");
//else
// this.Value = value.ToString();
}
}
internal FilterElement(string key, FilterOperator op, object value, PfeDataType type)
{
this.Key = key;
//support null value
if (value == null)
{
if (op.Value == FilterOperator.Eq.Value || op.Value == FilterOperator.Null.Value)
{
this.Operator = FilterOperator.Null.Value;
}
else
{
this.Operator = FilterOperator.NotNull.Value;
}
}
else
{
this.Operator = op.Value;
this.Value = value;
this.DataType = type;
// this.Parameters.Add(string.Format("@{0}", key), value);
}
}
/// <summary>
/// Creates 'Not less then' FilterElement.
/// </summary>
/// <param name="key">The key (column)</param>
/// <param name="value">The value.</param>
public static FilterElement NotLessThan(string key, object value, PfeDataType type = PfeDataType.Unknown)
{
return(new FilterElement(key, FilterOperator.Nl, value, type));
}
/// <summary>
/// Creates 'Greater or equal to' FilterElement.
/// </summary>
/// <param name="key">The key (column)</param>
/// <param name="value">The value.</param>
public static FilterElement GreaterThanOrEq(string key, object value, PfeDataType type = PfeDataType.Unknown)
{
return(new FilterElement(key, FilterOperator.Ge, value, type));
}
private FilterElement(string customQuery)
{
this.Key = "CUSTOM";
this.Value = customQuery;
this.DataType = PfeDataType.Unknown;
}
/// <summary>
/// Konštruktor pre vytvorenie filtra
/// </summary>
/// <param name="field">Nazov stlpca</param>
/// <param name="comparisionOperator">Operator porovnania</param>
/// <param name="value">Hodnota pre vyhladanie</param>
/// <param name="onlyIdentical">Len ideticke</param>
/// <param name="logicOperator">Logicke operatory</param>
/// <param name="leftBrace">Povolenie lavej zatvorky</param>
/// <param name="rightBrace">Povolenie pravej zatvorky</param>
public PfeFilterAttribute(string field, string comparisonOperator, object value, bool onlyIdentical, string logicOperator, byte leftBrace, byte rightBrace, PfeDataType type)
{
this.Field = field;
this.ComparisonOperator = comparisonOperator;
this.Value = value;
this.OnlyIdentical = onlyIdentical;
this.LogicOperator = logicOperator;
this.LeftBrace = leftBrace;
this.RightBrace = rightBrace;
this.Type = type;
}
/// <summary>
/// Konštruktor pre vytvorenie stĺpca
/// </summary>
/// <param name="name">Názov stĺpca</param>
/// <param name="text">Popis stĺpca</param>
/// <param name="rank">Poradie stĺpca</param>
/// <param name="hidden">Skrytie stĺpca (bez dát)</param>
/// <param name="alwaysData">Skrytý stĺpec s dátami</param>
/// <param name="type">Dátový typ stĺpca</param>
/// <param name="xtype">Typ stĺpca</param>
/// <param name="editable"></param>
/// <param name="mandatory">Je stĺpece povinný</param>
/// <param name="width">Šírka stĺpca</param>
/// <param name="align">Zarovnanie obsahu stĺpca</param>
/// <param name="tooltip">Tooltip pre stĺpec</param>
/// <param name="sortable">Povolanie zoradenia</param>
/// <param name="sortDirection">Určenie povoloného zoradenia</param>
/// <param name="format">Formátovanie obsahu stĺpca</param>
/// <param name="decimalPalces">Počet miest na zaokrúhľovanie</param>
/// <param name="dataUrl"><Odkaz na číselník/param>
/// <param name="total">Spocitavanie??</param>
/// <param name="defaultValue">Prednastavená hodnota stĺpca</param>
/// <param name="maxlength">Maximálna dĺžka text. reťazca</param>
/// <param name="description">Popis stĺpca</param>
/// <param name="loadWhenVisible">Ak je dany stlpec visible tak sa bude selectovat z DB</param>
public PfeColumnAttribute(string name, string text, int rank, bool hidden = false, bool?hideable = null, PfeDataType type = PfeDataType.Unknown, PfeXType xtype = PfeXType.Unknown,
bool?editable = null, bool?mandatory = null, int width = 0, PfeAligment align = PfeAligment.Unknown, string tooltip = "", bool sortable = true, PfeOrder sortDirection = PfeOrder.Asc,
string format = "0", int decimalPlaces = 2, string dataUrl = "", object defaultValue = null, bool?readOnly = null, int?maxlength = null, string description = "", bool loadWhenVisible = false)
{
this.Name = name;
this.Text = text;
this.Rank = rank;
this.Type = type;
this.Xtype = xtype;
this.Width = width;
this.editable = editable;
this.mandatory = mandatory;
this.Hidden = hidden;
this.hideable = hideable;
this.Align = align;
this.Tooltip = tooltip;
this.Sortable = sortable;
this.SortDirection = sortDirection;
this.Format = format;
this.DecimalPlaces = decimalPlaces;
this.DataUrl = dataUrl;
this.DefaultValue = defaultValue;
this.readOnly = readOnly;
this.MaxLength = maxlength;
this.Description = description;
this.LoadWhenVisible = loadWhenVisible;
}
