public OraclePocoHelper(DBInfo dbInfo)
{
#region 資料驗證
if (dbInfo == null)
throw new ArgumentNullException("DBInfo", "參數遺失");
if (string.IsNullOrWhiteSpace(dbInfo.HostIP))
throw new ArgumentNullException("主機名稱", "必填");
if (string.IsNullOrWhiteSpace(dbInfo.DBName))
throw new ArgumentNullException("Service Name", "必填");
if (string.IsNullOrWhiteSpace(dbInfo.DBOwner))
throw new ArgumentNullException("DB Owner Name", "必填");
if (string.IsNullOrWhiteSpace(dbInfo.UserID))
throw new ArgumentNullException("使用者名稱", "必填");
if (string.IsNullOrWhiteSpace(dbInfo.UserPwd))
throw new ArgumentNullException("密碼", "必填");
#endregion 資料驗證
_HostIP = dbInfo.HostIP;
_Port = dbInfo.Port;
_UserID = dbInfo.UserID;
_UserPwd = dbInfo.UserPwd;
_ServiceName = dbInfo.DBName;
_OwnerName = dbInfo.DBOwner;
connStr = string.Format(connstrFormat, _HostIP, _ServiceName, _UserID, _UserPwd, _Port);
}
public MSSQLPocoHelper(DBInfo dbInfo)
{
#region 資料驗證
if (dbInfo == null)
throw new ArgumentNullException("DBInfo", "參數遺失");
if (string.IsNullOrWhiteSpace(dbInfo.HostIP))
throw new ArgumentNullException("主機名稱", "必填");
if (string.IsNullOrWhiteSpace(dbInfo.DBName))
throw new ArgumentNullException("資料庫名稱名稱", "必填");
if (!dbInfo.ValidateByWindow)
{
if (string.IsNullOrWhiteSpace(dbInfo.UserID))
throw new ArgumentNullException("使用者名稱", "必填");
if (string.IsNullOrWhiteSpace(dbInfo.UserPwd))
throw new ArgumentNullException("密碼", "必填");
}
#endregion 資料驗證
_HostIP = dbInfo.HostIP;
_UserID = dbInfo.UserID;
_UserPwd = dbInfo.UserPwd;
_DBName = dbInfo.DBName;
_IsValidateWindow = dbInfo.ValidateByWindow;
connStr = string.Format(connstrFormat, _HostIP, _DBName, _UserID, _UserPwd);
if (_IsValidateWindow)
this.connStr += "Integrated Security=True;";
}
/// <summary>
/// 更新DBInf設定設定App.Config 中AppSetting
/// </summary>
/// <param name="dbInfo"> <see cref="DBInfo" /> </param>
public static void UpdateDbInfo(DBInfo dbInfo)
{
foreach (var prop in dbInfo.GetType().GetProperties())
{
var val = prop.GetValue(dbInfo);
var key = prop.Name;
UpdateSetting(key, val.ToString());
}
}
public IPocoHelper GetPocoHelper(string dbType, DBInfo dbinfo)
{
IPocoHelper helper = null;
switch (dbType)
{
case "MSSQL":
helper = new MSSQLPocoHelper(dbinfo);
break;
case "Oracle":
helper = new OraclePocoHelper(dbinfo);
break;
default:
throw new NotSupportedException("Not Support" + dbType);
}
return helper;
}
public IPocoHelper GetPocoHelper(string dbType, DBInfo dbInfo)
{
IPocoHelper helper;
helper = _factory.GetPocoHelper(dbType, dbInfo);
return helper;
}
private DBInfo GetDBInfo()
{
var dbInfo = new DBInfo()
{
DBType = ddlDbType.SelectedIndex,
HostIP = tbxHost.Text.Trim(),
Port = tbxPort.Text.Trim(),
UserID = tbxUserName.Text.Trim(),
UserPwd = tbxPwd.Text.Trim(),
DBName = tbxDBName.Text.Trim(),
ValidateByWindow = cbxValidateByWindow.Checked,
DBOwner = tbxDBOwner.Text.Trim()
};
return dbInfo;
}
