public void Modify(DataGridRule TablaQuery) { if (!string.IsNullOrEmpty(TablaQuery.Name)) { _dataGridRules[TablaQuery.Name] = TablaQuery; } }
public string ComputeClause(DataGridRule dataGridRule) { string sClausula = ""; string sCampo = ""; if (!string.IsNullOrEmpty(dataGridRule.ExpressionDb)) { sCampo = dataGridRule.ExpressionDb; } else if (!string.IsNullOrEmpty(dataGridRule.AliasField) & dataGridRule.AliasField != dataGridRule.ExtendedFieldName) { sCampo = dataGridRule.AliasField; } else { sCampo = dataGridRule.Table + "."; sCampo += dataGridRule.ExtendedFieldName; } if (dataGridRule.Criterio == DataGridRule.SortingCriteria.Contains) { sClausula = sCampo + dataGridRule.OrderBy + "'%" + dataGridRule.Value + "%'"; } else if (dataGridRule.Criterio == DataGridRule.SortingCriteria.NotContains) { sClausula = sCampo + dataGridRule.OrderBy + "'%" + dataGridRule.Value + "%'"; } else if (dataGridRule.Criterio == DataGridRule.SortingCriteria.IsNotEqualTo) { sClausula = sCampo + dataGridRule.OrderBy + "'" + dataGridRule.Value + "'"; } else if (dataGridRule.Criterio == DataGridRule.SortingCriteria.IsEqualTo) { sClausula = sCampo + dataGridRule.OrderBy + "'" + dataGridRule.Value + "'"; } else if (dataGridRule.Criterio == DataGridRule.SortingCriteria.StartsWith) { sClausula = sCampo + dataGridRule.OrderBy + "'" + dataGridRule.Value + "%'"; } else if (dataGridRule.Criterio == DataGridRule.SortingCriteria.Ends) { sClausula = sCampo + dataGridRule.OrderBy + "'%" + dataGridRule.Value + "'"; } else if (dataGridRule.Criterio == DataGridRule.SortingCriteria.IsNull) { sClausula = sCampo + " IS NULL "; } else if (dataGridRule.Criterio == DataGridRule.SortingCriteria.IsNotNull) { sClausula = sCampo + " IS NOT NULL "; } else { sClausula = sCampo + dataGridRule.OrderBy + "'" + dataGridRule.Value + "'"; } return(sClausula); }
public void Add(DataGridRule queryTable) { queryTable.Item = _dataGridRules.Count; _dataGridRules.Add(queryTable.Name, queryTable); }