//************************************************************************
/// <summary>IDデータロック取得</summary>
/// <param name="filter_id">スケジュールID</param>
/// <param name="dbType">DB種別</param>
/// <return>検索結果</return>
//************************************************************************
public int GetLock(object filter_id, Consts.DBTYPE dbType)
{
if (dbType == Consts.DBTYPE.MYSQL)
{
return(GetLock4Mysql(filter_id));
}
return(GetLock4NotMysql(filter_id));
}
//************************************************************************
/// <summary>パラメータテーブルロック取得</summary>
/// <param name="windowId">画面ID</param>
/// <param name="dbType">DB種別</param>
/// <return>検索結果</return>
//************************************************************************
public int GetLock(object windowId, Consts.DBTYPE dbType)
{
if (dbType == Consts.DBTYPE.MYSQL)
{
return(GetLock4Mysql(windowId));
}
return(GetLock4NotMysql(windowId));
}
public static JobconDBSource Create(DataRow dr)
{
String jobconName = (String)dr["JobconName"];
String dbUser = (String)dr["DBUser"];
String dbPass = (String)dr["DBPassword"];
String dbs = (String)dr["DBSource"];
String strDbtype = (String)dr["DBType"];
Consts.DBTYPE dbType = (Consts.DBTYPE)Convert.ToInt16(strDbtype);
bool healthCheckFlag = true;
if (dr["HealthCheckFlag"] != null)
{
if (((String)dr["HealthCheckFlag"]).Equals("0"))
{
healthCheckFlag = false;
}
}
int healthCheckInterval = 5;
if (dr["HealthCheckInterval"] != null)
{
healthCheckInterval = Convert.ToInt32(dr["HealthCheckInterval"]);
}
if (healthCheckFlag && healthCheckInterval == 0)
{
healthCheckInterval = 5;
}
//added by YAMA 2014/03/03
int jazabbixVersion = 0;
try
{
jazabbixVersion = Convert.ToInt16(dr["JaZabbixVersion"]);
}
catch (Exception ex)
{
jazabbixVersion = 2;
}
//added by YAMA 2014/03/03
return(new JobconDBSource(jobconName, dbUser, dbPass, dbs, dbType, healthCheckFlag, healthCheckInterval, jazabbixVersion));
// return new JobconDBSource(jobconName, dbUser, dbPass, dbs, dbType, healthCheckFlag, healthCheckInterval);
}
public JobconDBSource(String jobconName, String dbUser, String dbPass, String dbs, Consts.DBTYPE dbType,
bool healthCheckFlag, int healthCheckInterval, int jazabbixVersion)
// public JobconDBSource(String jobconName, String dbUser, String dbPass, String dbs, Consts.DBTYPE dbType,
// bool healthCheckFlag, int healthCheckInterval)
{
_jobconName = jobconName;
_dbUser = dbUser;
_dbPass = dbPass;
_dbs = dbs;
_dbType = dbType;
_healthCheckFlag = healthCheckFlag;
_healthCheckInterval = healthCheckInterval;
//added by YAMA 2014/03/03
_jazabbixVersion = jazabbixVersion;
_connnectStr = "DSN=" + dbs + ";UID=" + dbUser + ";PWD=" + dbPass + "; Connect Timeout=300";;
}
