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