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