/// <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)); }