/// <summary>
/// 判断是否存在
/// </summary>
/// <param name="strSql"></param>
/// <returns></returns>
public static bool Exists(string strSql)
{
DataTable dt = OracleDBHelper.ExecuteDataTable(strSql, null, DataBaseType.DefaultDB);
int cmdresult = 0;
if ((Object.Equals(dt, null)) || (Object.Equals(dt, System.DBNull.Value)))
{
cmdresult = 0;
}
else
{
cmdresult = dt.Rows.Count;
}
if (cmdresult == 0)
{
return(false);
}
else
{
return(true);
}
}
/// <summary>
/// 功能:对传入的SQL执行增、改、删等操作
/// 日期:2013-05-15
/// </summary>
/// <param name="sql">要执行的SQl</param>
/// <param name="parList">参数列表</param>
/// <returns></returns>
public static int ExecuteNonQuery(string sql)
{
return(OracleDBHelper.ExecuteNonQuery(sql, null, DataBaseType.DefaultDB));
}
/// <summary>
/// 功能:对传入的SQL执行增、改、删等操作
/// 日期:2013-05-15
/// </summary>
/// <param name="sql">要执行的SQl</param>
/// <param name="parList">参数列表</param>
/// <returns></returns>
public static int ExecuteNonQuery(string sql, List <ParameterEntity> parList)
{
return(OracleDBHelper.ExecuteNonQuery(sql, parList, DataBaseType.DefaultDB));
}
/// <summary>
/// 功能：查询分页数据
/// 日期：2013-05-15
/// </summary>
/// <param name="sqlStr">查询SQL</param>
/// <param name="pi">页码</param>
/// <param name="pageSize">每页显示条数</param>
/// <param name="parList">参数类型</param>
/// <returns></returns>
public static PagedTable GetDataByPage(string sqlStr, int pi, int pageSize, List <ParameterEntity> parList)
{
return(OracleDBHelper.GetDataByPage(sqlStr, pi, pageSize, parList, DataBaseType.DefaultDB));
}
/// <summary>
/// 功能：执行事物 (返回结果List 0 影响行数 1 执行出现错误的SQL )
/// 日期：2013-05-15
/// </summary>
/// <param name="dic">SQL列表</param>
/// <returns></returns>
public static List <object> ExecuteDBTransaction(Dictionary <string, List <ParameterEntity> > dic)
{
return(OracleDBHelper.ExecuteDBTransaction(dic, DataBaseType.DefaultDB));
}
/// <summary>
/// 功能：对传入的SQL执行查询操作,返回单个值
/// 日期：2013-05-15
/// </summary>
/// <param name="sql">执行的数据库</param>
/// <returns></returns>
public static object ExecuteScalar(string sql)
{
return(OracleDBHelper.ExecuteScalar(sql, null, DataBaseType.DefaultDB));
}
/// <summary>
/// 功能：对传入的SQL执行查询操作,返回单个值
/// 日期：2013-05-15
/// </summary>
/// <param name="sql">执行的数据库</param>
/// <param name="parList">参数</param>
/// <returns></returns>
public static object ExecuteScalar(string sql, List <ParameterEntity> parList)
{
return(OracleDBHelper.ExecuteScalar(sql, parList, DataBaseType.DefaultDB));
}
/// <summary>
/// 功能：对传入的SQL执行查询操作，返回DataTable
/// 日期：2013-05-15
/// </summary>
/// <param name="sql">执行的SQL</param>
/// <returns></returns>
public static DataTable ExecuteDataTable(string sql)
{
return(OracleDBHelper.ExecuteDataTable(sql, null, DataBaseType.DefaultDB));
}
/// <summary>
/// 功能：对传入的SQL执行查询操作，返回DataTable
/// 日期：2013-05-15
/// </summary>
/// <param name="sql">执行的SQL</param>
/// <param name="parList">参数列表</param>
/// <returns></returns>
public static DataTable ExecuteDataTable(string sql, List <ParameterEntity> parList)
{
return(OracleDBHelper.ExecuteDataTable(sql, parList, DataBaseType.DefaultDB));
}
