/// <summary> /// 設定ファイル(db.conf)からdbInfoを生成する。 /// </summary> /// <param name="pConfFilePath">設定ファイルパス</param> /// <param name="pKindOfDB">KindOfDB</param> /// <returns>clsDBInfo</returns> public static clsDBInfo xLoadConf(string pConfFilePath, string pKindOfDB) { clsDBInfo me = new clsDBInfo(); me._LoadConfFile(pConfFilePath, pKindOfDB); return(me); }
//#################################################################### // // function // //#################################################################### /// <summary> /// herokuのローカルDB情報dbInfoを生成する。 /// </summary> /// <param name="pConfFilePath">設定ファイルパス</param> /// <param name="pKindOfDB">KindOfDB</param> /// <returns>clsDBInfo</returns> public static clsDBInfo xGetHerokuDBInfo() { clsDBInfo me = new clsDBInfo(); me._GetHerokuDBInfo(); return(me); }
internal clsPostgreSQL(clsDBInfo pDBInfo) { myDBInfo_ = pDBInfo; }
public clsDB(clsDBInfo pDBInfo) { myDBInfo_ = pDBInfo; _Initialize(); }
//#################################################################### // // function // //#################################################################### /// <summary> /// DB種別を指定し、該当するclsDBInfoを返す。 /// 該当するclsDBInfoが存在しない場合は、設定ファイルより作成したうえで返す。 /// </summary> /// <param name="pKindOfDB">DB種別</param> /// <returns>clsDBInfo</returns> public clsDBInfo xGetDBInfo(string pKindOfDB) { clsDBInfo dbInfo = null; DataTable dt = xGetInstance().myTBLInfo_; DataRow[] rows = null; DataRow row = null; lock (xGetInstance().myTBLInfo_) { string key = clsSystemInfo.xDomain + "_" + pKindOfDB; rows = dt.Select("Key=" + "'" + key + "'"); if (rows.Length > 0) { dbInfo = new clsDBInfo( rows[0]["DBMS"].ToString(), rows[0]["DBServer"].ToString(), rows[0]["DBPort"].ToString(), rows[0]["DBName"].ToString(), rows[0]["DBUserID"].ToString(), rows[0]["DBPassword"].ToString(), rows[0]["DBSslMode"].ToString(), Convert.ToBoolean(rows[0]["DBReadOnly"])); } else { string DBMS = ""; string DBServer = ""; string DBPort = ""; string DBName = ""; string DBUserID = ""; string DBPassword = ""; string DBSslMode = ""; string DBReadOnly = ""; DBMS = xGetInstance().myDBConf_.GetSection(key)["DBMS"]; if (DBMS == null) { DBMS = ""; } DBServer = xGetInstance().myDBConf_.GetSection(key)["DBServer"]; if (DBServer == null) { DBServer = ""; } DBPort = xGetInstance().myDBConf_.GetSection(key)["DBPort"]; if (DBPort == null) { DBPort = ""; } DBName = xGetInstance().myDBConf_.GetSection(key)["DBName"]; if (DBName == null) { DBName = ""; } DBUserID = xGetInstance().myDBConf_.GetSection(key)["DBUserID"]; if (DBUserID == null) { DBUserID = ""; } DBPassword = xGetInstance().myDBConf_.GetSection(key)["DBPassword"]; if (DBPassword == null) { DBPassword = ""; } DBSslMode = xGetInstance().myDBConf_.GetSection(key)["DBSslMode"]; if (DBSslMode == null) { DBSslMode = "false"; } DBReadOnly = xGetInstance().myDBConf_.GetSection(key)["DBReadOnly"]; if (DBReadOnly == null) { DBReadOnly = "false"; } row = dt.NewRow(); row["Key"] = key; row["DBMS"] = DBMS; row["DBServer"] = DBServer; row["DBPort"] = DBPort; row["DBName"] = DBName; row["DBUserID"] = DBUserID; row["DBPassword"] = DBPassword; row["DBSslMode"] = DBSslMode; row["DBReadOnly"] = DBReadOnly; dt.Rows.Add(row); dbInfo = new clsDBInfo(); dbInfo.xDBMS = DBMS; dbInfo.xDBServer = DBServer; dbInfo.xDBPort = DBPort; dbInfo.xDBName = DBName; dbInfo.xDBUserID = DBUserID; dbInfo.xDBPassword = DBPassword; dbInfo.xDBSslMode = DBSslMode; dbInfo.xDBReadOnly = Convert.ToBoolean(DBReadOnly); } } rows = null; return(dbInfo); }
internal clsSQLServer(clsDBInfo pDBInfo) { myDBInfo_ = pDBInfo; }