public static string Build(Criteria crit)
{
string sql = "SELECT * FROM " + crit.TableName;
if (crit.Fields.Count == 0)
sql += " WHERE [Deleted]='false'";
else
sql += " WHERE ";
for (int i = 0; i < crit.Fields.Count; i++)
{
if (crit.Types[i] == DataTypeHelper.Type.DataType.String_Contains)
sql += "[" + crit.Fields[i] + "] LIKE '%" + crit.Values[i] + "%'";
else if (crit.Types[i] == DataTypeHelper.Type.DataType.String_Starts_With)
{
sql += "[" + crit.Fields[i] + "] LIKE '%" + crit.Values[i] + "%'";
}
else if (crit.Types[i] == DataTypeHelper.Type.DataType.String_Ends_With)
{
sql += "[" + crit.Fields[i] + "] LIKE '%" + crit.Values[i] + "%'";
if (i < crit.Fields.Count - 1)
{
sql += " AND ";
}
else
sql += " AND [Deleted] = 'false'";
}
}
return sql;
}
public static string BuildList(Criteria crit)
{
String sql = String.Empty;
if (crit.TableName != string.Empty)
{
sql = "SELECT Distinct PersonID FROM " + crit.TableName;
//add the where clause to selecft fields from table
//if there are no fields entered, give the whole table
if (crit.Fields.Count == 0)
{
sql += " WHERE [Deleted] = 'false'";
}
else
{
sql += " WHERE ";
}
for (int i = 0; i < crit.Fields.Count; i++)
{
if (crit.Types[i] == DataTypeHelper.Type.DataType.String_Contains)
{
sql += "[" + crit.Fields[i] + "]" + " LIKE '%" + crit.Values[i] + "%'";
}
else if (crit.Types[i] == DataTypeHelper.Type.DataType.String_Starts_With)
{
sql += "[" + crit.Fields[i] + "]" + " LIKE '" + crit.Values[i] + "%'";
}
else if (crit.Types[i] == DataTypeHelper.Type.DataType.String_Ends_With)
{
sql += "[" + crit.Fields[i] + "]" + " LIKE '%" + crit.Values[i] + "'";
}
if (i < crit.Fields.Count - 1)
{
sql += " AND ";
}
else
{
sql += " AND Deleted = 'false'";
}
}
}
else
{
throw new Exception("Table name not specified in criteria object");
}
return sql;
}