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