//************************************************************************
/// <summary>
/// データの更新.
/// </summary>
/// <param name="inner_jobnet_id">実行用ジョブネット内部管理ID</param>
/// <return>検索結果</return>
//************************************************************************
public int UpdateErrJobnetStop(object innerJobnetId)
{
List <ComSqlParam> sqlParams = new List <ComSqlParam>();
sqlParams.Add(new ComSqlParam(DbType.UInt64, "@inner_jobnet_id", innerJobnetId));
int count = _db.ExecuteNonQuery(_stop_err_jobnet, sqlParams);
return(count);
}
//************************************************************************
/// <summary>
/// データを削除.
/// </summary>
/// <param name="filter_id">フィルターID</param>
/// <param name="update_date">更新日</param>
/// <return>検索結果</return>
//************************************************************************
public int DeleteByPk(object filter_id, object update_date)
{
List <ComSqlParam> sqlParams = new List <ComSqlParam>();
sqlParams.Add(new ComSqlParam(DbType.String, "@filter_id", filter_id));
sqlParams.Add(new ComSqlParam(DbType.Int64, "@update_date", update_date));
int count = _db.ExecuteNonQuery(_deleteSqlByPk, sqlParams);
return(count);
}
// added by YAMA 2014/11/05 拡張ジョブアイコンの再実行
//************************************************************************
/// <summary>
/// 待合せ回数(wait_count)を更新.
/// </summary>
/// <param name="inner_jobnet_id">実行用ジョブネット内部管理ID</param>
/// <return>更新件数</return>
//************************************************************************
public int SetWaitCountByJobnet(int wait_count, object inner_jobnet_id)
{
List <ComSqlParam> sqlParams = new List <ComSqlParam>();
sqlParams.Add(new ComSqlParam(DbType.Int64, "@wait_count", wait_count));
sqlParams.Add(new ComSqlParam(DbType.String, "@inner_jobnet_id", inner_jobnet_id));
int cnt = _db.ExecuteNonQuery(_updateWaitCountSqlByPk, sqlParams);
return(cnt);
}
//added by YAMA 2014/08/18
public void SetJaParameterTable(String parameter_name, String value)
{
String updateSql = "update ja_parameter_table set value = ? where parameter_name = ? ";
//String updateSql = "update ja_parameter_table set value = " + "'" + value + "'" + " where parameter_name = " + "'" + parameter_name + "'" ;
List <ComSqlParam> sqlParams = new List <ComSqlParam>();
sqlParams.Add(new ComSqlParam(DbType.String, "@value", value));
sqlParams.Add(new ComSqlParam(DbType.String, "@parameter_name", parameter_name));
//DBConnect db = new DBConnect(LoginSetting.ConnectStr);
_db.ExecuteNonQuery(updateSql, sqlParams);
}
