本文整理汇总了C#中SelectCommand.InternalQuerys方法的典型用法代码示例。如果您正苦于以下问题：C# SelectCommand.InternalQuerys方法的具体用法？C# SelectCommand.InternalQuerys怎么用？C# SelectCommand.InternalQuerys使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SelectCommand的用法示例。
在下文中一共展示了SelectCommand.InternalQuerys方法的3个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: InternalGetPagerCommand
/// <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.QueryFields);
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 = new SelectCommand(baseCommand.Database, baseCommand.TableName);
innestCommand.QueryFields = baseCommand.QueryFields;
innestCommand.SqlJoins = baseCommand.SqlJoins;
innestCommand.SqlWhere = baseCommand.SqlWhere;
innestCommand.GroupByColumns = baseCommand.GroupByColumns;
innestCommand.SqlHaving = baseCommand.SqlHaving;
innestCommand.SqlOrders = baseCommand.SqlOrders;
SelectCommand innerCommand = new SelectCommand(baseCommand.Database, innestCommand, "");
innerCommand.SqlWhere = SqlCondition.LessThanOrEqualColumn(innerCommand, "ROWNUM", (baseCommand.RecordStart + baseCommand.PageSize).ToString());
innerCommand.InternalQuerys(baseCommand.QueryFields.ToArray());
innerCommand.InternalQuerys(SqlQueryField.InternalCreateFromFunction(baseCommand, "ROWNUM", "RN"));
sb.AppendSelectFrom(innerCommand.GetCommandText(), true);
sb.AppendWhere(SqlCondition.GreaterThanColumn(baseCommand, "RN", baseCommand.RecordStart.ToString()));
}
else//正常模式
{
sb.AppendSelectFromAndJoins(baseCommand.TableName, baseCommand.IsFromSql, baseCommand.SqlJoins);
ISqlCondition where = baseCommand.SqlWhere;
if (baseCommand.PageSize > 0)
{
where = SqlCondition.And(baseCommand, where, SqlCondition.LessThanOrEqualColumn(baseCommand, "ROWNUM", baseCommand.PageSize.ToString()));
}
sb.AppendWhere(where);
sb.AppendSelectGroupBys(baseCommand.GroupByColumns);
sb.AppendHaving(baseCommand.SqlHaving);
sb.AppendSelectOrderBys(baseCommand.SqlOrders, orderReverse);
}
return sb.ToString();
}示例2: InternalGetPagerCommand
/// <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.QueryFields);
SqlCommandBuilder innerBuilder = new SqlCommandBuilder(baseCommand.Database);
innerBuilder.AppendSelectOrderBys(baseCommand.SqlOrders, false);
SelectCommand innerCommand = new SelectCommand(baseCommand.Database, baseCommand.TableName);
innerCommand.InternalQuerys(baseCommand.QueryFields.ToArray());
innerCommand.InternalQuerys(SqlQueryField.InternalCreateFromFunction(baseCommand, "ROW_NUMBER() OVER( " + innerBuilder.ToString() + ")", "RN"));
innerCommand.PageSize = baseCommand.RecordStart + baseCommand.PageSize;
innerCommand.SqlJoins = baseCommand.SqlJoins;
innerCommand.SqlWhere = baseCommand.SqlWhere;
innerCommand.GroupByColumns = baseCommand.GroupByColumns;
innerCommand.SqlHaving = baseCommand.SqlHaving;
sb.AppendSelectFrom(innerCommand.GetCommandText("T"), true);
sb.AppendWhere(SqlCondition.GreaterThanColumn(baseCommand, "RN", baseCommand.RecordStart.ToString()));
}
else//正常模式
{
if (baseCommand.PageSize > 0)
{
sb.AppendSelectTop(baseCommand.PageSize);
}
sb.AppendSelectDistinct(baseCommand.UseDistinct).AppendAllColumnNames(baseCommand.QueryFields);
sb.AppendSelectFromAndJoins(baseCommand.TableName, baseCommand.IsFromSql, baseCommand.SqlJoins);
sb.AppendWhere(baseCommand.SqlWhere);
sb.AppendSelectGroupBys(baseCommand.GroupByColumns);
sb.AppendHaving(baseCommand.SqlHaving);
sb.AppendSelectOrderBys(baseCommand.SqlOrders, orderReverse);
}
return sb.ToString();
}示例3: InternalGetSelectCommand
/// <summary>
/// 获取选择语句内容
/// </summary>
/// <param name="cmd">选择语句类</param>
/// <param name="realPageIndex">实际页索引</param>
/// <param name="realPageCount">实际页数量</param>
/// <param name="orderReverse">是否反转排序</param>
/// <returns>选择语句内容</returns>
internal static String InternalGetSelectCommand(SelectCommand cmd, Int32 realPageIndex, Int32 realPageCount, Boolean orderReverse)
{
SqlCommandBuilder sb = new SqlCommandBuilder(cmd.DatabaseType);
sb.AppendSelectPrefix();
sb.AppendSelectDistinct(cmd.UseDistinct).AppendAllColumnNames(cmd.QueryFields);
if (cmd.PageSize == 0)//正常模式
{
sb.AppendSelectFromAndJoins(cmd.TableName, cmd.IsFromSql, cmd.SqlJoins);
sb.AppendWhere(cmd.SqlWhere);
sb.AppendSelectGroupBys(cmd.GroupByColumns);
sb.AppendHaving(cmd.SqlHaving);
sb.AppendSelectOrderBys(cmd.SqlOrders, orderReverse);
}
else//分页模式
{
/*
SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLE_NAME) A
WHERE ROWNUM <= 40
)
WHERE RN >= 21
*/
SelectCommand innestCommand = new SelectCommand(cmd.Database, cmd.TableName);
innestCommand.QueryFields = cmd.QueryFields;
innestCommand.SqlJoins = cmd.SqlJoins;
innestCommand.SqlWhere = cmd.SqlWhere;
innestCommand.GroupByColumns = cmd.GroupByColumns;
innestCommand.SqlHaving = cmd.SqlHaving;
innestCommand.SqlOrders = cmd.SqlOrders;
SelectCommand innerCommand = new SelectCommand(cmd.Database, innestCommand, "T");
innerCommand.SqlWhere = SqlCondition.LessThanOrEqual("ROWNUM", realPageIndex * cmd.PageSize);
innerCommand.InternalQuerys(cmd.QueryFields.ToArray());
innerCommand.InternalQuerys(SqlQueryField.InternalCreateFromFunction("ROWNUM", "RN"));
sb.AppendSelectFrom(innerCommand.ToString("T"), true);
sb.AppendWhere(SqlCondition.GreaterThanOrEqual("RN", (realPageIndex - 1) * cmd.PageSize + 1));
}
return sb.ToString();
}