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