/// <summary> /// 测试数据库连接 /// </summary> /// <returns></returns> public bool TestDbLink() { try { switch (m_dbType) { case EnumDbType.DbOracle: return(DbHelperOra.TestDbLink()); case EnumDbType.DbSqlServer: return(DbHelperSql.TestDbLink());; case EnumDbType.DbOleDb: return(DbHelperOledb.TestDbLink()); default: return(DbHelperOra.TestDbLink()); } } catch (Exception exp) { m_strError = exp.Message; return(false); } }
/// <summary> /// 执行SQL语句,返回影响行数 /// </summary> /// <param name="p_strSql">SQL语句</param> /// <returns>影响行数 -1 失败 </returns> public int ExecuteSql(string p_strSql) { try { switch (m_dbType) { case EnumDbType.DbOracle: return(DbHelperOra.ExecuteSql(p_strSql)); case EnumDbType.DbSqlServer: return(DbHelperSql.ExecuteSql(p_strSql)); case EnumDbType.DbOleDb: return(DbHelperOledb.ExecuteSql(p_strSql)); default: return(DbHelperOra.ExecuteSql(p_strSql)); } } catch (Exception exp) { m_strError = exp.Message; return(-1); } }
public int QueryRecordCount(string p_strSql) { try { switch (m_dbType) { case EnumDbType.DbOracle: return(DbHelperOra.QueryRecordCount(p_strSql)); case EnumDbType.DbSqlServer: return(DbHelperSql.QueryRecordCount(p_strSql)); case EnumDbType.DbOleDb: return(DbHelperOledb.QueryRecordCount(p_strSql)); default: return(DbHelperOra.QueryRecordCount(p_strSql)); } } catch (Exception exp) { m_strError = exp.Message; return(0); } }
/// <summary> /// 执行存储过程查询返回DataTable /// </summary> /// <param name="p_storedProcName">存储过程名</param> /// <param name="p_parameters">存储过程参数</param> /// <returns>返回DataTable 错误则返回null</returns> public DataTable QueryToDt(string p_strStoredProcName, IDataParameter[] p_parameters) { try { switch (m_dbType) { case EnumDbType.DbOracle: return(DbHelperOra.QueryToDt(p_strStoredProcName, p_parameters)); case EnumDbType.DbSqlServer: return(DbHelperSql.QueryToDt(p_strStoredProcName, p_parameters)); case EnumDbType.DbOleDb: return(DbHelperOledb.QueryToDt(p_strStoredProcName, p_parameters)); default: return(DbHelperOra.QueryToDt(p_strStoredProcName, p_parameters)); } } catch (Exception exp) { m_strError = exp.Message; return(null); } }
/// <summary> /// 执行查询语句,返回DataSet /// </summary> /// <param name="p_strSql">sql语句</param> /// <returns>返回DataSet 错误返回null</returns> public DataSet QueryToDs(string p_strSql) { try { switch (m_dbType) { case EnumDbType.DbOracle: return(DbHelperOra.QueryToDs(p_strSql)); case EnumDbType.DbSqlServer: return(DbHelperSql.QueryToDs(p_strSql)); case EnumDbType.DbOleDb: return(DbHelperOledb.QueryToDs(p_strSql)); default: return(DbHelperOra.QueryToDs(p_strSql)); } } catch (Exception exp) { m_strError = exp.Message; return(null); } }
/// <summary> /// 执行Sql返回结果集中第一行第一列(空或无则返回null)。 /// </summary> /// <param name="p_strSql">sql语句</param> /// <param name="o_obj">返回第一行第一列的值</param> /// <returns>是否成功</returns> public bool GetSingle(string p_strSql, out object o_obj) { o_obj = null; try { switch (m_dbType) { case EnumDbType.DbOracle: o_obj = DbHelperOra.GetSingle(p_strSql); break; case EnumDbType.DbSqlServer: o_obj = DbHelperSql.GetSingle(p_strSql); break; case EnumDbType.DbOleDb: o_obj = DbHelperOledb.GetSingle(p_strSql); break; default: o_obj = DbHelperOra.GetSingle(p_strSql); break; } } catch (Exception exp) { m_strError = exp.Message; return(false); } return(true); }
// <summary> /// 执行多条SQL语句,实现数据库事务。 /// </summary> /// <param name="p_ArrListSqls">多条SQL语句</param> /// <returns>是否成功</returns> public bool ExecuteSqlTran(ArrayList p_ArrListSqls) { try { switch (m_dbType) { case EnumDbType.DbOracle: DbHelperOra.ExecuteSqlTran(p_ArrListSqls); break; case EnumDbType.DbSqlServer: DbHelperSql.ExecuteSqlTran(p_ArrListSqls); break; case EnumDbType.DbOleDb: DbHelperOledb.ExecuteSqlTran(p_ArrListSqls); break; default: DbHelperOra.ExecuteSqlTran(p_ArrListSqls); break; } } catch (Exception exp) { m_strError = exp.Message; return(false); } return(true); }