/// <summary>
/// 分页获取数据
/// </summary>
/// <param name="sqlCommand"></param>
/// <param name="pageInfo"></param>
/// <param name="parameter"></param>
/// <returns></returns>
public PageResult PaginationQuery <T>(string sqlCommand, PageInfo pageInfo, OracleDbParameters parameter = null)
{
IDbConnection conn = null;
try
{
if (parameter == null)
{
parameter = new OracleDbParameters();
}
conn = GetOracleConnection();
if (conn == null)
{
throw new ApplicationException("未获取到连接对象。");
}
return(DoPaginationQuery <T>(conn, sqlCommand, pageInfo, parameter.GetParameters()));
}
catch (Exception ex)
{
logger.Info(ex.Message);
logger.Fatal(ex.Message, ex);
return(default(PageResult));
}
finally
{
CloseConnect(conn);
}
}
/// <summary>
/// 执行储存过程
/// </summary>
/// <param name="sProcedureName"></param>
/// <param name="Parameters"></param>
public int ExcuteProcedure(string sProcedureName, OracleDbParameters Parameters)
{
IDbConnection conn = null;
try
{
conn = GetOracleConnection();
if (conn == null)
{
throw new ApplicationException("未获取到连接对象.");
}
return(DoExcuteProcedure(conn, sProcedureName, Parameters.GetParameters()));
}
catch (Exception ex)
{
logger.Info(ex.Message);
logger.Fatal(ex.Message, ex);
return(-1);
}
finally
{
CloseConnect(conn);
}
}
