/// <summary>
/// 根据条件和排序得到查询语句
/// </summary>
/// <param name="condition"></param>
/// <param name="orderByBuilder"></param>
/// <param name="tableName"></param>
/// <returns></returns>
public string GetLoadSqlByBuilder(string condition, OrderBySqlClauseBuilder orderByBuilder, string tableName)
{
string sql = string.Format("SELECT * FROM {0}", tableName);
if (condition.IsNotEmpty())
{
sql = sql + string.Format(" WHERE {0}", condition);
}
if (orderByBuilder != null)
{
sql = sql + string.Format(" ORDER BY {0}", orderByBuilder.ToSqlString(TSqlBuilder.Instance));
}
return(sql);
}
/// <summary>
/// 构造查询语句
/// </summary>
/// <param name="condition"></param>
/// <param name="orderByBuilder"></param>
/// <param name="tableName"></param>
/// <param name="timePoint"></param>
/// <returns></returns>
public string GetLoadSqlByBuilder(string condition, OrderBySqlClauseBuilder orderByBuilder, DateTime timePoint, string tableName)
{
string sql = string.Format("SELECT * FROM {0} WHERE ", tableName);
ConnectiveSqlClauseCollection timePointBuilder = VersionStrategyQuerySqlBuilder.Instance.TimePointToBuilder(timePoint);
if (condition.IsNotEmpty())
{
sql = sql + condition;
}
sql += " AND " + timePointBuilder.ToSqlString(TSqlBuilder.Instance);
if (orderByBuilder != null)
{
sql = sql + string.Format(" ORDER BY {0}", orderByBuilder.ToSqlString(TSqlBuilder.Instance));
}
return(sql);
}
