public static DbQuery CountSelect <T>(QueryCondition queryCondition, string resultName) { return(CountSelect(SimpleSelect <T>(queryCondition), resultName)); }
public static DbQuery PaginationSelect <T>(QueryCondition queryCondition, string orderColumn, OrderType orderType, int start, int count) { return(PaginationSelect(SimpleSelect <T>(queryCondition), orderColumn, orderType, start, count)); }
public static DbQuery OrderedSelect(string tName, QueryCondition queryCondition, string orderBy, OrderType orderType, int?count = null) { return(OrderBy(SimpleSelect(tName, queryCondition, count), tName, orderBy, orderType)); }
public static DbQuery SimpleSelect <T>(QueryCondition queryCondition, int?count = null) { return(SimpleSelect(typeof(T).Name, queryCondition, count)); }
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); }
public static DbQuery SimpleUpdate(Type t, IEnumerable <KeyValuePair <string, object> > updateParams, QueryCondition queryCondition, int index = 0) { var setParamsPrefix = "set_param_" + index + "_"; var setParamMapper = new Dictionary <string, string>(); var setParams = new Dictionary <string, object>(); foreach (var updateParam in updateParams) { var setParamsKey = setParamsPrefix + updateParam.Key; setParamMapper.Add(setParamsKey, updateParam.Key); setParams.Add(setParamsKey, updateParam.Value); } return(SimpleUpdate(t, setParams, setParamMapper, queryCondition)); }
public static DbQuery SimpleUpdate <T>(IDictionary <string, object> updateParams, QueryCondition conditions) { var t = typeof(T); return(SimpleUpdate(t, updateParams, conditions)); }