개정판 57428b38
dev issue #507: minor
Change-Id: Ib9a6db5cced63197d85c896faf09a8a7fde130f0
| DTI_PID/SPPIDConverter/DB/SPPID_DB.cs | ||
|---|---|---|
| 12 | 12 |
{
|
| 13 | 13 |
public class SPPID_DB |
| 14 | 14 |
{
|
| 15 |
private const string oConnString = "(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST ={0}" + @")(PORT = {1}))(CONNECT_DATA = (SERVICE_NAME = {2})))";
|
|
| 15 |
private const string oracleConnString = "(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST ={0}" + @")(PORT = {1}))(CONNECT_DATA = (SERVICE_NAME = {2})))";
|
|
| 16 |
private const string sqlConnString = "(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST ={0}" + @")(PORT = {1}))(CONNECT_DATA = (SERVICE_NAME = {2})))";
|
|
| 16 | 17 |
|
| 17 | 18 |
public static bool CheckAndSetSPPIDInfo(SPPID_DBInfo dbInfo) |
| 18 | 19 |
{
|
| ... | ... | |
| 21 | 22 |
{
|
| 22 | 23 |
if (dbInfo.DBType == "ORACLE") |
| 23 | 24 |
{
|
| 24 |
string connString = string.Format(oConnString, dbInfo.ServerIP, dbInfo.Port, dbInfo.Service); |
|
| 25 |
string connString = string.Format(oracleConnString, dbInfo.ServerIP, dbInfo.Port, dbInfo.Service);
|
|
| 25 | 26 |
connString = "Data Source=" + connString + ";User Id=" + dbInfo.DBUser + ";Password=" + dbInfo.DBPassword; |
| 26 | 27 |
|
| 27 | 28 |
using (OracleConnection conn = new OracleConnection(connString)) |
| ... | ... | |
| 101 | 102 |
{
|
| 102 | 103 |
if (dbInfo.DBType == "ORACLE") |
| 103 | 104 |
{
|
| 104 |
string connString = string.Format(oConnString, dbInfo.ServerIP, dbInfo.Port, dbInfo.Service); |
|
| 105 |
string connString = string.Format(oracleConnString, dbInfo.ServerIP, dbInfo.Port, dbInfo.Service);
|
|
| 105 | 106 |
connString = "Data Source=" + connString + ";User Id=" + dbInfo.DBUser + ";Password=" + dbInfo.DBPassword; |
| 106 | 107 |
|
| 107 | 108 |
using (OracleConnection conn = new OracleConnection(connString)) |
| ... | ... | |
| 177 | 178 |
{
|
| 178 | 179 |
if (dbInfo.DBType == "ORACLE") |
| 179 | 180 |
{
|
| 180 |
string connString = string.Format(oConnString, dbInfo.ServerIP, dbInfo.Port, dbInfo.Service); |
|
| 181 |
string connString = string.Format(oracleConnString, dbInfo.ServerIP, dbInfo.Port, dbInfo.Service);
|
|
| 181 | 182 |
connString = "Data Source=" + connString + ";User Id=" + dbInfo.DBUser + ";Password=" + dbInfo.DBPassword; |
| 182 | 183 |
|
| 183 | 184 |
using (OracleConnection conn = new OracleConnection(connString)) |
| ... | ... | |
| 223 | 224 |
{
|
| 224 | 225 |
if (dbInfo.DBType == "ORACLE") |
| 225 | 226 |
{
|
| 226 |
string connString = string.Format(oConnString, dbInfo.ServerIP, dbInfo.Port, dbInfo.Service); |
|
| 227 |
string connString = string.Format(oracleConnString, dbInfo.ServerIP, dbInfo.Port, dbInfo.Service);
|
|
| 227 | 228 |
connString = "Data Source=" + connString + ";User Id=" + dbInfo.DBUser + ";Password=" + dbInfo.DBPassword; |
| 228 | 229 |
|
| 229 | 230 |
using (OracleConnection conn = new OracleConnection(connString)) |
| ... | ... | |
| 270 | 271 |
{
|
| 271 | 272 |
if (dbInfo.DBType == "ORACLE") |
| 272 | 273 |
{
|
| 273 |
string connString = string.Format(oConnString, dbInfo.ServerIP, dbInfo.Port, dbInfo.Service); |
|
| 274 |
string connString = string.Format(oracleConnString, dbInfo.ServerIP, dbInfo.Port, dbInfo.Service);
|
|
| 274 | 275 |
connString = "Data Source=" + connString + ";User Id=" + dbInfo.DBUser + ";Password=" + dbInfo.DBPassword; |
| 275 | 276 |
|
| 276 | 277 |
using (OracleConnection conn = new OracleConnection(connString)) |
내보내기 Unified diff
