/// <summary>
/// 执行查询返回表
/// </summary>
/// <param name="strTableName">表名</param>
/// <param name="iTopNumber">TOP N</param>
/// <param name="queryCondition">查询条件</param>
/// <param name="queryOrder">排序集合</param>
/// <param name="conn">数据库连接</param>
/// <param name="tran">数据库操作事务</param>
/// <returns>结果集</returns>
private static DataTable ExcuteQuery(String strTableName, int iTopNumber,
QueryConditionDecorator queryCondition, QueryOrderCollection queryOrder, SqlConnection conn, SqlTransaction tran)
{
string strSql = "SELECT";
if (0 != iTopNumber)
{
strSql += " TOP " + iTopNumber;
}
strSql += " * FROM " + strTableName;
// 生成条件
SqlParameter[] paraQuery = null;
if (null != queryCondition)
{
QueryCondition condition = new QueryCondition();
condition.ConnectTo(queryCondition);
ArrayList lstSqlParameter = new ArrayList();
strSql += condition.MakeCondition(lstSqlParameter);
paraQuery = new SqlParameter[lstSqlParameter.Count];
for (int i = 0; i < lstSqlParameter.Count; i++)
{
paraQuery[i] = lstSqlParameter[i] as SqlParameter;
}
}
// 生成排序
if (null != queryOrder)
{
strSql += queryOrder.MakeOrder();
}
// 执行查询
if (null != paraQuery)
{
if (null != conn)
{
return(SqlHelper.ExecuteDataTable(conn, CommandType.Text, strSql, paraQuery));
}
else
{
return(SqlHelper.ExecuteDataTable(tran, CommandType.Text, strSql, paraQuery));
}
}
else
{
if (null != conn)
{
return(SqlHelper.ExecuteDataTable(conn, CommandType.Text, strSql));
}
else
{
return(SqlHelper.ExecuteDataTable(tran, CommandType.Text, strSql));
}
}
}
/// <summary>
/// 执行查询返回表
/// </summary>
/// <param name="strTableName">表名</param>
/// <param name="iTopNumber">TOP N</param>
/// <param name="queryCondition">查询条件</param>
/// <param name="queryOrder">排序集合</param>
/// <param name="tran">数据库操作事务</param>
/// <returns>结果集</returns>
public static DataTable ExcuteQuery(String strTableName, int iTopNumber,
QueryConditionDecorator queryCondition, QueryOrderCollection queryOrder, SqlTransaction tran)
{
return(ExcuteQuery(strTableName, iTopNumber, queryCondition, queryOrder, null, tran));
}
/// <summary>
/// 执行查询返回表
/// </summary>
/// <param name="strTableName">表名</param>
/// <param name="iTopNumber">TOP N</param>
/// <param name="queryCondition">查询条件</param>
/// <param name="queryOrder">排序集合</param>
/// <param name="conn">数据库连接</param>
/// <returns>结果集</returns>
public static DataTable ExcuteQuery(String strTableName, int iTopNumber,
QueryConditionDecorator queryCondition, QueryOrderCollection queryOrder, SqlConnection conn)
{
return(ExcuteQuery(strTableName, iTopNumber, queryCondition, queryOrder, conn, null));
}
/// <summary>
/// 执行查询返回表
/// </summary>
/// <param name="strTableName">表名</param>
/// <param name="queryOrder">排序集合</param>
/// <param name="tran">数据库操作事务</param>
/// <returns>结果集</returns>
public static DataTable ExcuteQuery(String strTableName, QueryOrderCollection queryOrder, SqlTransaction tran)
{
return(ExcuteQuery(strTableName, 0, null, queryOrder, null, tran));
}
/// <summary>
/// 执行查询返回表
/// </summary>
/// <param name="strTableName">表名</param>
/// <param name="queryOrder">排序集合</param>
/// <param name="conn">数据库连接</param>
/// <returns>结果集</returns>
public static DataTable ExcuteQuery(String strTableName, QueryOrderCollection queryOrder, SqlConnection conn)
{
return(ExcuteQuery(strTableName, 0, null, queryOrder, conn, null));
}
/// <summary>
/// 执行分页查询返回表
/// </summary>
/// <param name="strTableName">表名</param>
/// <param name="queryCondition">查询条件</param>
/// <param name="queryOrder">排序集合</param>
/// <param name="startRecord">开始查询记录</param>
/// <param name="maxRecords">查询记录数量</param>
/// <param name="tran">数据库操作事务</param>
/// <returns>结果集</returns>
public static DataTable ExcutePage(String strTableName, QueryConditionDecorator queryCondition,
QueryOrderCollection queryOrder, int startRecord, int maxRecords, SqlTransaction tran)
{
return(ExcutePage(strTableName, queryCondition, queryOrder, startRecord, maxRecords, null, tran));
}
/// <summary>
/// 执行分页查询返回表
/// </summary>
/// <param name="strTableName">表名</param>
/// <param name="queryOrder">排序集合</param>
/// <param name="startRecord">开始查询记录</param>
/// <param name="maxRecords">查询记录数量</param>
/// <param name="conn">数据库连接</param>
/// <returns>结果集</returns>
public static DataTable ExcutePage(String strTableName, QueryOrderCollection queryOrder, int startRecord, int maxRecords, SqlConnection conn)
{
return(ExcutePage(strTableName, null, queryOrder, startRecord, maxRecords, conn, null));
}