public bool SaveProcessInstanceVariable(IProcessInstanceVar var)
{
throw new NotImplementedException();
}
public bool SaveProcessInstanceVariable(IProcessInstanceVar var)
{
string insert = "INSERT INTO T_FF_RT_PROCINST_VAR (" +
"PROCESSINSTANCE_ID, VALUE, NAME )VALUES(@1, @2, @3)";
SqlParameter[] insertParms = {
SqlServerHelper.NewSqlParameter("@1", SqlDbType.VarChar, 50, var.ProcessInstanceId),
SqlServerHelper.NewSqlParameter("@2", SqlDbType.VarChar, 255, var.ValueType+"#"+var.Value),
SqlServerHelper.NewSqlParameter("@3", SqlDbType.VarChar, 255, var.Name)
};
if (SqlServerHelper.ExecuteNonQuery(connectionString, CommandType.Text, insert, insertParms) != 1)
return false;
else return true;
}
public bool SaveProcessInstanceVariable(IProcessInstanceVar var)
{
string insert = "INSERT INTO T_FF_RT_PROCINST_VAR (" +
"PROCESSINSTANCE_ID, VALUE, NAME )VALUES(:1, :2, :3)";
OracleParameter[] insertParms = {
OracleHelper.NewOracleParameter(":1", OracleType.VarChar, 50, var.ProcessInstanceId),
OracleHelper.NewOracleParameter(":2", OracleType.VarChar, 255, var.ValueType+"#"+var.Value),
OracleHelper.NewOracleParameter(":3", OracleType.VarChar, 255, var.Name)
};
if (OracleHelper.ExecuteNonQuery(connectionString, CommandType.Text, insert, insertParms) != 1)
return false;
else return true;
}
public bool UpdateProcessInstanceVariable(IProcessInstanceVar var)
{
string update = "UPDATE T_FF_RT_PROCINST_VAR SET " +
"VALUE=@2" +
" WHERE PROCESSINSTANCE_ID=@1 AND NAME=@3";
SqlParameter[] updateParms = {
SqlServerHelper.NewSqlParameter("@2", SqlDbType.VarChar, 255, var.ValueType+"#"+var.Value),
SqlServerHelper.NewSqlParameter("@1", SqlDbType.VarChar, 50, var.ProcessInstanceId),
SqlServerHelper.NewSqlParameter("@3", SqlDbType.VarChar, 255, var.Name)
};
if (SqlServerHelper.ExecuteNonQuery(connectionString, CommandType.Text, update, updateParms) != 1)
return false;
else return true;
}
public bool UpdateProcessInstanceVariable(IProcessInstanceVar var)
{
string update = "UPDATE T_FF_RT_PROCINST_VAR SET " +
"VALUE=:2" +
" WHERE PROCESSINSTANCE_ID=:1 AND NAME=:3";
OracleParameter[] updateParms = {
OracleHelper.NewOracleParameter(":2", OracleType.VarChar, 255, var.ValueType+"#"+var.Value),
OracleHelper.NewOracleParameter(":1", OracleType.VarChar, 50, var.ProcessInstanceId),
OracleHelper.NewOracleParameter(":3", OracleType.VarChar, 255, var.Name)
};
if (OracleHelper.ExecuteNonQuery(connectionString, CommandType.Text, update, updateParms) != 1)
return false;
else return true;
}
