/// <summary>
/// 获取选择语句内容
/// </summary>
/// <param name="baseCommand">源选择语句</param>
/// <param name="orderReverse">是否反转排序</param>
/// <returns>选择语句内容</returns>
internal static String InternalGetPagerCommand(SelectCommand baseCommand, Boolean orderReverse)
{
SqlCommandBuilder sb = new SqlCommandBuilder(baseCommand.Database);
sb.AppendSelectPrefix();
if (baseCommand.PageSize > 0 && baseCommand.RecordStart > 0)//分页模式
{
/*
SELECT * FROM
(
SELECT TOP 30 *, ROW_NUMBER() OVER(ORDER BY ID ASC) AS RN
FROM TABLE_NAME
) AS T
WHERE RN > 20
*/
sb.AppendSelectDistinct(baseCommand.UseDistinct).AppendAllColumnNames(baseCommand.UseDistinct, baseCommand.InternalGetQueryFieldList());
SqlCommandBuilder innerBuilder = new SqlCommandBuilder(baseCommand.Database);
innerBuilder.AppendSelectOrderBys(baseCommand.InternalGetOrderList(), false);
SelectCommand innerCommand = baseCommand.Database.InternalCreateSelectCommand(baseCommand, baseCommand.TableName);
innerCommand.InternalQuerys(baseCommand.QueryFields);
innerCommand.InternalQuerys(SqlQueryField.InternalCreateFromFunction(baseCommand, "ROW_NUMBER() OVER( " + innerBuilder.ToString() + ")", "RN"));
innerCommand.PageSize = baseCommand.RecordStart + baseCommand.PageSize;
innerCommand.InternalSetJoinList(baseCommand);
innerCommand.InternalSetWhereCondition(baseCommand);
innerCommand.InternalSetGroupByFieldList(baseCommand);
innerCommand.InternalSetHavingCondition(baseCommand);
sb.AppendSelectFrom(innerCommand.GetCommandText("T"), true);
sb.AppendWhere(baseCommand.ConditionBuilder.GreaterThanColumn("RN", baseCommand.RecordStart.ToString()));
}
else//正常模式
{
if (baseCommand.PageSize > 0)
{
sb.AppendSelectTop(baseCommand.PageSize);
}
sb.AppendSelectDistinct(baseCommand.UseDistinct).AppendAllColumnNames(baseCommand.UseDistinct, baseCommand.InternalGetQueryFieldList());
sb.AppendSelectFromAndJoins(baseCommand.TableName, baseCommand.IsFromSql, baseCommand.InternalGetJoinList());
sb.AppendWhere(baseCommand.WhereCondition);
sb.AppendSelectGroupBys(baseCommand.InternalGetGroupByFieldList());
sb.AppendHaving(baseCommand.InternalGetHavingCondition());
sb.AppendSelectOrderBys(baseCommand.InternalGetOrderList(), orderReverse);
}
return sb.ToString();
}
/// <summary>
/// 获取选择语句内容
/// </summary>
/// <param name="baseCommand">源选择语句</param>
/// <param name="orderReverse">是否反转排序</param>
/// <returns>选择语句内容</returns>
internal static String InternalGetPagerCommand(SelectCommand baseCommand, Boolean orderReverse)
{
SqlCommandBuilder sb = new SqlCommandBuilder(baseCommand.Database);
sb.AppendSelectPrefix();
sb.AppendSelectDistinct(baseCommand.UseDistinct).AppendAllColumnNames(baseCommand.UseDistinct, baseCommand.InternalGetQueryFieldList());
sb.AppendSelectFromAndJoins(baseCommand.TableName, baseCommand.IsFromSql, baseCommand.InternalGetJoinList());
sb.AppendWhere(baseCommand.WhereCondition);
sb.AppendSelectGroupBys(baseCommand.InternalGetGroupByFieldList());
sb.AppendHaving(baseCommand.InternalGetHavingCondition());
sb.AppendSelectOrderBys(baseCommand.InternalGetOrderList(), orderReverse);
if (baseCommand.PageSize > 0 && baseCommand.RecordStart <= 0)
{
sb.AppendSelectLimit(baseCommand.PageSize);
}
else if (baseCommand.PageSize > 0 && baseCommand.RecordStart > 0)
{
sb.AppendSelectLimit(baseCommand.RecordStart, baseCommand.PageSize);
}
return sb.ToString();
}
/// <summary>
/// 获取选择语句内容
/// </summary>
/// <param name="baseCommand">源选择语句</param>
/// <param name="orderReverse">是否反转排序</param>
/// <returns>选择语句内容</returns>
internal static String InternalGetPagerCommand(SelectCommand baseCommand, Boolean orderReverse)
{
SqlCommandBuilder sb = new SqlCommandBuilder(baseCommand.Database);
sb.AppendSelectPrefix();
sb.AppendSelectDistinct(baseCommand.UseDistinct).AppendAllColumnNames(baseCommand.UseDistinct, baseCommand.InternalGetQueryFieldList());
sb.AppendSelectFromAndJoins(baseCommand.TableName, baseCommand.IsFromSql, baseCommand.InternalGetJoinList());
sb.AppendWhere(baseCommand.WhereCondition);
sb.AppendSelectGroupBys(baseCommand.InternalGetGroupByFieldList());
sb.AppendHaving(baseCommand.InternalGetHavingCondition());
sb.AppendSelectOrderBys(baseCommand.InternalGetOrderList(), orderReverse);
if (baseCommand.PageSize > 0 && baseCommand.RecordStart <= 0)
{
sb.AppendSelectLimit(baseCommand.PageSize);
}
else if (baseCommand.PageSize > 0 && baseCommand.RecordStart > 0)
{
sb.AppendSelectLimit(baseCommand.RecordStart, baseCommand.PageSize);
}
return(sb.ToString());
}
/// <summary>
/// 获取选择语句内容
/// </summary>
/// <param name="baseCommand">源选择语句</param>
/// <param name="orderReverse">是否反转排序</param>
/// <returns>选择语句内容</returns>
internal static String InternalGetPagerCommand(SelectCommand baseCommand, Boolean orderReverse)
{
SqlCommandBuilder sb = new SqlCommandBuilder(baseCommand.Database);
sb.AppendSelectPrefix();
if (baseCommand.PageSize > 0 && baseCommand.RecordStart > 0)//分页模式
{
/*
* SELECT * FROM
* (
* SELECT TOP 30 *, ROW_NUMBER() OVER(ORDER BY ID ASC) AS RN
* FROM TABLE_NAME
* ) AS T
* WHERE RN > 20
*/
sb.AppendSelectDistinct(baseCommand.UseDistinct).AppendAllColumnNames(baseCommand.UseDistinct, baseCommand.InternalGetQueryFieldList());
SqlCommandBuilder innerBuilder = new SqlCommandBuilder(baseCommand.Database);
innerBuilder.AppendSelectOrderBys(baseCommand.InternalGetOrderList(), false);
SelectCommand innerCommand = baseCommand.Database.InternalCreateSelectCommand(baseCommand, baseCommand.TableName);
innerCommand.InternalQuerys(baseCommand.QueryFields);
innerCommand.InternalQuerys(SqlQueryField.InternalCreateFromFunction(baseCommand, "ROW_NUMBER() OVER( " + innerBuilder.ToString() + ")", "RN"));
innerCommand.PageSize = baseCommand.RecordStart + baseCommand.PageSize;
innerCommand.InternalSetJoinList(baseCommand);
innerCommand.InternalSetWhereCondition(baseCommand);
innerCommand.InternalSetGroupByFieldList(baseCommand);
innerCommand.InternalSetHavingCondition(baseCommand);
sb.AppendSelectFrom(innerCommand.GetCommandText("T"), true);
sb.AppendWhere(baseCommand.ConditionBuilder.GreaterThanColumn("RN", baseCommand.RecordStart.ToString()));
}
else//正常模式
{
if (baseCommand.PageSize > 0)
{
sb.AppendSelectTop(baseCommand.PageSize);
}
sb.AppendSelectDistinct(baseCommand.UseDistinct).AppendAllColumnNames(baseCommand.UseDistinct, baseCommand.InternalGetQueryFieldList());
sb.AppendSelectFromAndJoins(baseCommand.TableName, baseCommand.IsFromSql, baseCommand.InternalGetJoinList());
sb.AppendWhere(baseCommand.WhereCondition);
sb.AppendSelectGroupBys(baseCommand.InternalGetGroupByFieldList());
sb.AppendHaving(baseCommand.InternalGetHavingCondition());
sb.AppendSelectOrderBys(baseCommand.InternalGetOrderList(), orderReverse);
}
return(sb.ToString());
}
/// <summary>
/// 获取选择语句内容
/// </summary>
/// <param name="baseCommand">源选择语句</param>
/// <param name="orderReverse">是否反转排序</param>
/// <returns>选择语句内容</returns>
internal static String InternalGetPagerCommand(SelectCommand baseCommand, Boolean orderReverse)
{
SqlCommandBuilder sb = new SqlCommandBuilder(baseCommand.Database);
sb.AppendSelectPrefix();
sb.AppendSelectDistinct(baseCommand.UseDistinct).AppendAllColumnNames(baseCommand.UseDistinct, baseCommand.InternalGetQueryFieldList());
if (baseCommand.PageSize > 0 && baseCommand.RecordStart > 0)//分页模式
{
/*
* SELECT * FROM
* (
* SELECT *, ROWNUM RN
* FROM (SELECT * FROM TABLE_NAME)
* WHERE ROWNUM <= 30
* )
* WHERE RN > 20
*/
SelectCommand innestCommand = baseCommand.Database.InternalCreateSelectCommand(baseCommand, baseCommand.TableName);
innestCommand.InternalSetQueryFieldList(baseCommand);
innestCommand.InternalSetJoinList(baseCommand);
innestCommand.InternalSetWhereCondition(baseCommand);
innestCommand.InternalSetGroupByFieldList(baseCommand);
innestCommand.InternalSetHavingCondition(baseCommand);
innestCommand.InternalSetOrderList(baseCommand);
SelectCommand innerCommand = baseCommand.Database.InternalCreateSelectCommand(baseCommand, innestCommand, "");
innerCommand.InternalSetWhereCondition(innerCommand.ConditionBuilder.LessThanOrEqualColumn("ROWNUM", (baseCommand.RecordStart + baseCommand.PageSize).ToString()));
innerCommand.InternalQuerys(baseCommand.QueryFields);
innerCommand.InternalQuerys(SqlQueryField.InternalCreateFromFunction(baseCommand, "ROWNUM", "RN"));
sb.AppendSelectFrom(innerCommand.GetCommandText(), true);
sb.AppendWhere(baseCommand.ConditionBuilder.GreaterThanColumn("RN", baseCommand.RecordStart.ToString()));
}
else//正常模式
{
sb.AppendSelectFromAndJoins(baseCommand.TableName, baseCommand.IsFromSql, baseCommand.InternalGetJoinList());
ISqlCondition where = baseCommand.WhereCondition;
if (baseCommand.PageSize > 0)
{
where = baseCommand.ConditionBuilder.And(where, baseCommand.ConditionBuilder.LessThanOrEqualColumn("ROWNUM", baseCommand.PageSize.ToString()));
}
sb.AppendWhere(where);
sb.AppendSelectGroupBys(baseCommand.InternalGetGroupByFieldList());
sb.AppendHaving(baseCommand.InternalGetHavingCondition());
sb.AppendSelectOrderBys(baseCommand.InternalGetOrderList(), orderReverse);
}
return(sb.ToString());
}
/// <summary>
/// 获取选择语句内容
/// </summary>
/// <param name="baseCommand">源选择语句</param>
/// <param name="recordCount">记录数量</param>
/// <param name="orderReverse">是否反转排序</param>
/// <returns>选择语句内容</returns>
internal static String InternalGetPagerCommand(SelectCommand baseCommand, Int32 recordCount, Boolean orderReverse)
{
SqlCommandBuilder sb = new SqlCommandBuilder(baseCommand.Database);
sb.AppendSelectPrefix();
if (baseCommand.PageSize > 0 && baseCommand.RecordStart > 0)//分页模式
{
Int32 realPageCount = (recordCount + baseCommand.PageSize - 1) / baseCommand.PageSize;
Int32 realPageIndex = (baseCommand.RecordStart / baseCommand.PageSize) + 1;
if (realPageIndex >= realPageCount)//最后一页
{
sb.AppendSelectDistinct(baseCommand.UseDistinct).AppendAllColumnNames(baseCommand.UseDistinct, baseCommand.InternalGetQueryFieldList());
SelectCommand innerCommand = baseCommand.Database.InternalCreateSelectCommand(baseCommand, baseCommand.TableName);
innerCommand.PageSize = recordCount - baseCommand.RecordStart;
innerCommand.InternalSetQueryFieldList(baseCommand);
innerCommand.InternalSetJoinList(baseCommand);
innerCommand.InternalSetWhereCondition(baseCommand);
innerCommand.InternalSetGroupByFieldList(baseCommand);
innerCommand.InternalSetHavingCondition(baseCommand);
innerCommand.InternalSetOrderList(baseCommand);
sb.AppendSelectFrom(innerCommand.GetCommandText("T", !orderReverse), true);
sb.AppendSelectOrderBys(baseCommand.InternalGetOrderList(), orderReverse);
}
else if (realPageIndex < (realPageCount / 2 + realPageCount % 2))//前1/2部分页
{
/*
SELECT * FROM
(
SELECT TOP 10 * FROM
(
SELECT TOP 30 *
FROM TABLE_NAME
ORDER BY ID ASC
) AS T1
ORDER BY ID DESC
) AS T2
ORDER BY ID ASC
*/
sb.AppendSelectDistinct(baseCommand.UseDistinct).AppendAllColumnNames(baseCommand.UseDistinct, baseCommand.InternalGetQueryFieldList());
SelectCommand innestCommand = baseCommand.Database.InternalCreateSelectCommand(baseCommand, baseCommand.TableName);
innestCommand.PageSize = baseCommand.RecordStart + baseCommand.PageSize;
innestCommand.InternalSetQueryFieldList(baseCommand);
innestCommand.InternalSetJoinList(baseCommand);
innestCommand.InternalSetWhereCondition(baseCommand);
innestCommand.InternalSetGroupByFieldList(baseCommand);
innestCommand.InternalSetHavingCondition(baseCommand);
innestCommand.InternalSetOrderList(baseCommand);
SelectCommand innerCommand = baseCommand.Database.InternalCreateSelectCommand(baseCommand, innestCommand, "T1");
innerCommand.PageSize = baseCommand.PageSize;
innerCommand.InternalSetQueryFieldList(baseCommand);
innerCommand.InternalSetOrderList(baseCommand);
sb.AppendSelectFrom(innerCommand.GetCommandText("T2", !orderReverse), true);
sb.AppendSelectOrderBys(baseCommand.InternalGetOrderList(), orderReverse);
}
else//后1/2部分页
{
sb.AppendSelectTop(baseCommand.PageSize);
sb.AppendSelectDistinct(baseCommand.UseDistinct).AppendAllColumnNames(baseCommand.UseDistinct, baseCommand.InternalGetQueryFieldList());
SelectCommand innerCommand = baseCommand.Database.InternalCreateSelectCommand(baseCommand, baseCommand.TableName);
innerCommand.PageSize = recordCount - baseCommand.RecordStart;
innerCommand.InternalSetQueryFieldList(baseCommand);
innerCommand.InternalSetJoinList(baseCommand);
innerCommand.InternalSetWhereCondition(baseCommand);
innerCommand.InternalSetGroupByFieldList(baseCommand);
innerCommand.InternalSetHavingCondition(baseCommand);
innerCommand.InternalSetOrderList(baseCommand);
sb.AppendSelectFrom(innerCommand.GetCommandText("T", !orderReverse), true);
sb.AppendSelectOrderBys(baseCommand.InternalGetOrderList(), orderReverse);
}
}
else//正常模式
{
if (baseCommand.PageSize > 0)
{
sb.AppendSelectTop(baseCommand.PageSize);
}
sb.AppendSelectDistinct(baseCommand.UseDistinct).AppendAllColumnNames(baseCommand.UseDistinct, baseCommand.InternalGetQueryFieldList());
sb.AppendSelectFromAndJoins(baseCommand.TableName, baseCommand.IsFromSql, baseCommand.InternalGetJoinList());
sb.AppendWhere(baseCommand.WhereCondition);
sb.AppendSelectGroupBys(baseCommand.InternalGetGroupByFieldList());
sb.AppendHaving(baseCommand.InternalGetHavingCondition());
sb.AppendSelectOrderBys(baseCommand.InternalGetOrderList(), orderReverse);
}
return sb.ToString();
}
/// <summary>
/// 获取选择数量语句
/// </summary>
/// <param name="baseCommand">源选择语句</param>
/// <returns>选择数量语句</returns>
internal static String InternalGetCountCommand(SelectCommand baseCommand)
{
SqlCommandBuilder sb = new SqlCommandBuilder(baseCommand.Database);
List<SqlQueryField> queryFields = new List<SqlQueryField>();
queryFields.Add(SqlQueryField.InternalCreateFromAggregateFunction(baseCommand, SqlAggregateFunction.Count));
sb.AppendSelectPrefix();
sb.AppendSelectDistinct(baseCommand.UseDistinct).AppendAllColumnNames(baseCommand.UseDistinct, queryFields);
sb.AppendSelectFromAndJoins(baseCommand.TableName, baseCommand.IsFromSql, baseCommand.InternalGetJoinList());
sb.AppendWhere(baseCommand.WhereCondition);
sb.AppendSelectGroupBys(baseCommand.InternalGetGroupByFieldList());
sb.AppendHaving(baseCommand.InternalGetHavingCondition());
return sb.ToString();
}
/// <summary>
/// 获取选择空内容语句
/// </summary>
/// <param name="baseCommand">源选择语句</param>
/// <param name="orderReverse">是否反转排序</param>
/// <returns>选择空内容语句</returns>
internal static String InternalGetSelectNoneCommand(SelectCommand baseCommand, Boolean orderReverse)
{
SqlCommandBuilder sb = new SqlCommandBuilder(baseCommand.Database);
sb.AppendSelectPrefix();
sb.AppendSelectDistinct(baseCommand.UseDistinct).AppendAllColumnNames(baseCommand.UseDistinct, baseCommand.InternalGetQueryFieldList());
sb.AppendSelectFromAndJoins(baseCommand.TableName, baseCommand.IsFromSql, baseCommand.InternalGetJoinList());
if (baseCommand.WhereCondition != null)
{
sb.AppendWhere(baseCommand.ConditionBuilder.And(baseCommand.ConditionBuilder.False(), baseCommand.WhereCondition));
}
else
{
sb.AppendWhere(baseCommand.ConditionBuilder.False());
}
sb.AppendSelectGroupBys(baseCommand.InternalGetGroupByFieldList());
sb.AppendHaving(baseCommand.InternalGetHavingCondition());
sb.AppendSelectOrderBys(baseCommand.InternalGetOrderList(), orderReverse);
return sb.ToString();
}
/// <summary>
/// 获取选择语句内容
/// </summary>
/// <param name="baseCommand">源选择语句</param>
/// <param name="recordCount">记录数量</param>
/// <param name="orderReverse">是否反转排序</param>
/// <returns>选择语句内容</returns>
internal static String InternalGetPagerCommand(SelectCommand baseCommand, Int32 recordCount, Boolean orderReverse)
{
SqlCommandBuilder sb = new SqlCommandBuilder(baseCommand.Database);
sb.AppendSelectPrefix();
if (baseCommand.PageSize > 0 && baseCommand.RecordStart > 0)//分页模式
{
Int32 realPageCount = (recordCount + baseCommand.PageSize - 1) / baseCommand.PageSize;
Int32 realPageIndex = (baseCommand.RecordStart / baseCommand.PageSize) + 1;
if (realPageIndex >= realPageCount)//最后一页
{
sb.AppendSelectDistinct(baseCommand.UseDistinct).AppendAllColumnNames(baseCommand.UseDistinct, baseCommand.InternalGetQueryFieldList());
SelectCommand innerCommand = baseCommand.Database.InternalCreateSelectCommand(baseCommand, baseCommand.TableName);
innerCommand.PageSize = recordCount - baseCommand.RecordStart;
innerCommand.InternalSetQueryFieldList(baseCommand);
innerCommand.InternalSetJoinList(baseCommand);
innerCommand.InternalSetWhereCondition(baseCommand);
innerCommand.InternalSetGroupByFieldList(baseCommand);
innerCommand.InternalSetHavingCondition(baseCommand);
innerCommand.InternalSetOrderList(baseCommand);
sb.AppendSelectFrom(innerCommand.GetCommandText("T", !orderReverse), true);
sb.AppendSelectOrderBys(baseCommand.InternalGetOrderList(), orderReverse);
}
else if (realPageIndex < (realPageCount / 2 + realPageCount % 2))//前1/2部分页
{
/*
* SELECT * FROM
* (
* SELECT TOP 10 * FROM
* (
* SELECT TOP 30 *
* FROM TABLE_NAME
* ORDER BY ID ASC
* ) AS T1
* ORDER BY ID DESC
* ) AS T2
* ORDER BY ID ASC
*/
sb.AppendSelectDistinct(baseCommand.UseDistinct).AppendAllColumnNames(baseCommand.UseDistinct, baseCommand.InternalGetQueryFieldList());
SelectCommand innestCommand = baseCommand.Database.InternalCreateSelectCommand(baseCommand, baseCommand.TableName);
innestCommand.PageSize = baseCommand.RecordStart + baseCommand.PageSize;
innestCommand.InternalSetQueryFieldList(baseCommand);
innestCommand.InternalSetJoinList(baseCommand);
innestCommand.InternalSetWhereCondition(baseCommand);
innestCommand.InternalSetGroupByFieldList(baseCommand);
innestCommand.InternalSetHavingCondition(baseCommand);
innestCommand.InternalSetOrderList(baseCommand);
SelectCommand innerCommand = baseCommand.Database.InternalCreateSelectCommand(baseCommand, innestCommand, "T1");
innerCommand.PageSize = baseCommand.PageSize;
innerCommand.InternalSetQueryFieldList(baseCommand);
innerCommand.InternalSetOrderList(baseCommand);
sb.AppendSelectFrom(innerCommand.GetCommandText("T2", !orderReverse), true);
sb.AppendSelectOrderBys(baseCommand.InternalGetOrderList(), orderReverse);
}
else//后1/2部分页
{
sb.AppendSelectTop(baseCommand.PageSize);
sb.AppendSelectDistinct(baseCommand.UseDistinct).AppendAllColumnNames(baseCommand.UseDistinct, baseCommand.InternalGetQueryFieldList());
SelectCommand innerCommand = baseCommand.Database.InternalCreateSelectCommand(baseCommand, baseCommand.TableName);
innerCommand.PageSize = recordCount - baseCommand.RecordStart;
innerCommand.InternalSetQueryFieldList(baseCommand);
innerCommand.InternalSetJoinList(baseCommand);
innerCommand.InternalSetWhereCondition(baseCommand);
innerCommand.InternalSetGroupByFieldList(baseCommand);
innerCommand.InternalSetHavingCondition(baseCommand);
innerCommand.InternalSetOrderList(baseCommand);
sb.AppendSelectFrom(innerCommand.GetCommandText("T", !orderReverse), true);
sb.AppendSelectOrderBys(baseCommand.InternalGetOrderList(), orderReverse);
}
}
else//正常模式
{
if (baseCommand.PageSize > 0)
{
sb.AppendSelectTop(baseCommand.PageSize);
}
sb.AppendSelectDistinct(baseCommand.UseDistinct).AppendAllColumnNames(baseCommand.UseDistinct, baseCommand.InternalGetQueryFieldList());
sb.AppendSelectFromAndJoins(baseCommand.TableName, baseCommand.IsFromSql, baseCommand.InternalGetJoinList());
sb.AppendWhere(baseCommand.WhereCondition);
sb.AppendSelectGroupBys(baseCommand.InternalGetGroupByFieldList());
sb.AppendHaving(baseCommand.InternalGetHavingCondition());
sb.AppendSelectOrderBys(baseCommand.InternalGetOrderList(), orderReverse);
}
return(sb.ToString());
}
/// <summary>
/// 获取选择数量语句
/// </summary>
/// <param name="baseCommand">源选择语句</param>
/// <returns>选择数量语句</returns>
internal static String InternalGetCountCommand(SelectCommand baseCommand)
{
SqlCommandBuilder sb = new SqlCommandBuilder(baseCommand.Database);
List <SqlQueryField> queryFields = new List <SqlQueryField>();
queryFields.Add(SqlQueryField.InternalCreateFromAggregateFunction(baseCommand, SqlAggregateFunction.Count));
sb.AppendSelectPrefix();
sb.AppendSelectDistinct(baseCommand.UseDistinct).AppendAllColumnNames(baseCommand.UseDistinct, queryFields);
sb.AppendSelectFromAndJoins(baseCommand.TableName, baseCommand.IsFromSql, baseCommand.InternalGetJoinList());
sb.AppendWhere(baseCommand.WhereCondition);
sb.AppendSelectGroupBys(baseCommand.InternalGetGroupByFieldList());
sb.AppendHaving(baseCommand.InternalGetHavingCondition());
return(sb.ToString());
}
/// <summary>
/// 获取选择空内容语句
/// </summary>
/// <param name="baseCommand">源选择语句</param>
/// <param name="orderReverse">是否反转排序</param>
/// <returns>选择空内容语句</returns>
internal static String InternalGetSelectNoneCommand(SelectCommand baseCommand, Boolean orderReverse)
{
SqlCommandBuilder sb = new SqlCommandBuilder(baseCommand.Database);
sb.AppendSelectPrefix();
sb.AppendSelectDistinct(baseCommand.UseDistinct).AppendAllColumnNames(baseCommand.UseDistinct, baseCommand.InternalGetQueryFieldList());
sb.AppendSelectFromAndJoins(baseCommand.TableName, baseCommand.IsFromSql, baseCommand.InternalGetJoinList());
if (baseCommand.WhereCondition != null)
{
sb.AppendWhere(baseCommand.ConditionBuilder.And(baseCommand.ConditionBuilder.False(), baseCommand.WhereCondition));
}
else
{
sb.AppendWhere(baseCommand.ConditionBuilder.False());
}
sb.AppendSelectGroupBys(baseCommand.InternalGetGroupByFieldList());
sb.AppendHaving(baseCommand.InternalGetHavingCondition());
sb.AppendSelectOrderBys(baseCommand.InternalGetOrderList(), orderReverse);
return(sb.ToString());
}