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