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);
}
