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