public static Int32 ConnExecute(DBConnType conntype, String connname, String sql)
{
string ConnStr = ConfigurationManager.ConnectionStrings[connname].ConnectionString;
switch (conntype)
{
case DBConnType.Oledb:
OleDbConnection Conn = new OleDbConnection(ConnStr);
OleDbCommand cmd = new OleDbCommand(sql, Conn);
cmd.Connection.Open();
Int32 rowAffected = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return(rowAffected);
case DBConnType.Sql:
SqlConnection Conn2 = new SqlConnection(ConnStr);
SqlCommand cmd2 = new SqlCommand(sql, Conn2);
cmd2.Connection.Open();
Int32 rowAffected2 = cmd2.ExecuteNonQuery();
cmd2.Connection.Close();
return(rowAffected2);
default:
return(-1);
}
}
public DataTable ExecuteSQL(string sql, string conn, DBConnType connType)
{
DataTable table = new DataTable();
switch (connType)
{
case DBConnType.SQLServer:
SqlDataReader reader;
using (SqlConnection dbConn = new SqlConnection(conn))
{
using (SqlCommand cmd = new SqlCommand(sql, dbConn))
{
try
{
dbConn.Open();
reader = cmd.ExecuteReader();
table.Load(reader);
}
catch (Exception err)
{
throw err;
}
}
}
break;
case DBConnType.Oracle:
using (OracleConnection oracleConn = new OracleConnection(conn))
{
using (OracleCommand cmd = new OracleCommand(sql, oracleConn))
{
//cmd.BindByName = true;
//cmd.Parameters.Add(":OrgId", OracleDbType.Varchar2).Value = orgId;
//cmd.Parameters.Add(":SDate", OracleDbType.Varchar2).Value = sDate;
//cmd.Parameters.Add(":EDate", OracleDbType.Varchar2).Value = eDate;
try
{
oracleConn.Open();
table.Load(cmd.ExecuteReader());
return(table);
}
catch (Exception err)
{
throw err;
}
}
}
}
return(table);
}
/// <summary>
/// DB連線
/// </summary>
/// <param name="dbConnType"></param>
/// <returns></returns>
public static string getDBConnectionString(DBConnType dbConnType)
{
return(getDBConnectionString(dbConnType.ToString()));
}
