//************************************************************************ /// <summary> テーブルの構築</summary> /// <return>テーブルの結構</return> //************************************************************************ public DataTable GetEmptyTable() { _db.CreateSqlConnect(); DataTable dt = _db.ExecuteQuery(SelectSql); return(dt); }
//************************************************************************ /// <summary>MysqlDBのIDデータロック取得</summary> /// <param name="windowId">画面ID</param> /// <return>検索結果</return> //************************************************************************ public int GetLock4Mysql(object windowId) { int count = 0; string _getLock = "SELECT GET_LOCK('ja_parameter_table." + windowId + "', 0) as count"; List <ComSqlParam> sqlParams = new List <ComSqlParam>(); sqlParams.Add(new ComSqlParam(DbType.String, "@windowId", windowId)); DataTable dt = _db.ExecuteQuery(_getLock, sqlParams, TableName); count = int.Parse(Convert.ToString(dt.Rows[0]["count"])); if (count < 1) { RealseLock(windowId); _db.CloseSqlConnect(); throw new DBException(); } return(count); }
//************************************************************************ /// <summary> /// テーブルの構築. /// </summary> /// <return>テーブルの結構</return> //************************************************************************ public DataTable GetEmptyTable() { DataTable dt = _db.ExecuteQuery(SelectSql); return(dt); }