/// <summary>
/// 使用一段sql，进行分页查询， 目前只支持sqlserver
/// </summary>
/// <param name="sqlText"></param>
/// <param name="orderbyClause"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="recordCount"></param>
/// <returns></returns>
public DataTable Query(string sqlText, string orderbyClause, int pageIndex, int pageSize, ref int recordCount)
{
ThrowExceptionUtil.ArgumentNotNullOrEmpty(sqlText, "sql");
ThrowExceptionUtil.ArgumentNotNullOrEmpty(orderbyClause, "orderbyClause");
if (pageSize > 0 && pageIndex >= 0)
{
if (recordCount <= 0)
{
CmdTextBeeCommand countBeeCommand = new CmdTextBeeCommand(this, "select count(1) as beecount from ( {0} )t".FormatWith(sqlText), null);
DataTable countTable = countBeeCommand.Excute <DataTable>();
if (countTable != null && countTable.Rows.Count == 1)
{
int.TryParse(countTable.Rows[0]["beecount"].ToString(), out recordCount);
}
}
}
string sql = this.dbDriver.GetPagedSelectCmdText(sqlText, orderbyClause, pageIndex, pageSize);
CmdTextBeeCommand queryBeeCommand = new CmdTextBeeCommand(this, sql, null);
return(queryBeeCommand.Excute <DataTable>());
}
/// <summary>
/// sql文查询
/// </summary>
/// <param name="cmdText">sql文</param>
/// <param name="dataAdapter">数据集</param>
/// <returns>结果集</returns>
public DataTable ExecuteCommand(string cmdText, BeeDataAdapter dataAdapter)
{
ThrowExceptionUtil.ArgumentNotNullOrEmpty(cmdText, "cmdText");
CmdTextBeeCommand cmdTextBeeCommand = new CmdTextBeeCommand(this, cmdText, dataAdapter);
return(cmdTextBeeCommand.Excute <DataTable>());
}
public IEnumerable <T> ExecuteDataReader <T>(string cmdText, BeeDataAdapter dataAdapter)
where T : class
{
ThrowExceptionUtil.ArgumentNotNullOrEmpty(cmdText, "cmdText");
CmdTextBeeCommand cmdTextBeeCommand = new CmdTextBeeCommand(this, cmdText, dataAdapter);
return(cmdTextBeeCommand.DataRead <T>());
}
