public static DbQuery SimpleDelete <T>(QueryCondition conditioins) { var res = new DbQuery(); var t = typeof(T); res.Sql.AppendFormat(DELETE_FORMAT, t.Name); conditioins.BuildSqlWhere(res, t.Name); return(res); }
public static DbQuery SimpleSelect(string tableName, QueryCondition queryCondition, int?count = null) { var res = new DbQuery(); res.Sql.AppendFormat("Select {1} * from [{0}] ", tableName, count.HasValue ? " TOP " + count : ""); if (queryCondition != null) { queryCondition.BuildSqlWhere(res, tableName); } return(res); }
private static DbQuery SimpleUpdate(Type t, IDictionary <string, object> updateParams, IDictionary <string, string> updateParamsMapper, QueryCondition queryCondition) { var res = new DbQuery { Parameters = new Dictionary <string, object>() }; res.Sql.Append("Update [").Append(t.Name).Append("] set"); res.Sql.Append(updateParams.Select(x => "[" + updateParamsMapper[x.Key] + "]=@" + x.Key).JoinString(",")); foreach (var updateParam in updateParams) { if (!res.Parameters.ContainsKey(updateParam.Key)) { res.Parameters.Add(updateParam); } } queryCondition.BuildSqlWhere(res, t.Name); return(res); }