/// <summary>
///Get Parameters
/// </summary>
/// <returns>array of parameters</returns>
public MWFNodePara[] GetParameters()
{
if (_paras == null)
{
_paras = MWFNodePara.GetParameters(GetCtx(), GetAD_WF_Node_ID());
}
return(_paras);
}
/// <summary>
/// Get Parameters for a node
/// </summary>
/// <param name="ctx">context</param>
/// <param name="AD_WF_Node_ID">node</param>
/// <returns>array of parameters</returns>
public static MWFNodePara[] GetParameters(Ctx ctx, int AD_WF_Node_ID)
{
List <MWFNodePara> list = new List <MWFNodePara>();
String sql = "SELECT * FROM AD_WF_Node_Para "
+ "WHERE AD_WF_Node_ID=" + AD_WF_Node_ID;
//String sql = "SELECT * FROM AD_Org WHERE AD_Client_ID=" + AD_WF_Node_ID;
DataSet ds = null;
try
{
ds = DataBase.DB.ExecuteDataset(sql, null, null);
if (ds.Tables.Count > 0)
{
DataRow dr = null;
int totCount = ds.Tables[0].Rows.Count;
for (int i = 0; i < totCount; i++)
{
dr = ds.Tables[0].Rows[i];
list.Add(new MWFNodePara(ctx, dr, null));
}
dr = null;
}
}
catch (Exception e)
{
_log.Log(Level.SEVERE, "GetParameters", e);
}
finally
{
ds = null;
}
//Make a array of MWFNodePara object and return
MWFNodePara[] retValue = new MWFNodePara[list.Count];
retValue = list.ToArray();
return(retValue);
}
