//************************************************************************ /// <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";; }