public virtual string GetDeleteSQL(string table, Dictionary <string, object> filters = null) { ICriteria criteria = GetNewCriteria(); if (filters != null) { foreach (string col in filters.Keys) { criteria.AddEqualTo("\"" + col + "\"", filters[col]); } } return(string.Format(DeleteFormat, "\"" + table + "\"", criteria.GetClauses())); }
public virtual string GetUpdateSQL(string table, Dictionary <string, object> values, Dictionary <string, object> filters = null) { ICriteria criteria = GetNewCriteria(); if (filters != null) { foreach (string col in filters.Keys) { criteria.AddEqualTo("\"" + col + "\"", filters[col]); } } string sets = string.Join(", ", values.Keys.Select(key => "\"" + key + "\" = " + criteria.ParseFormatValue(values[key]))); return(string.Format(UpdateFormat, "\"" + table + "\"", sets, criteria.GetClauses())); }
public virtual string GetSelectSQL(string table, List <string> columns = null, Dictionary <string, object> filters = null) { string cols = "*"; if (columns != null && columns.Count > 0) { cols = string.Join(",", columns.Select(column => "\"" + column + "\"")); } ICriteria criteria = GetNewCriteria(); if (filters != null) { foreach (string col in filters.Keys) { criteria.AddEqualTo("\"" + col + "\"", filters[col]); } } return(string.Format(SelectFormat, "\"" + table + "\"", cols, criteria.GetClauses())); }