/// <summary> /// Get Stages /// </summary> /// <param name="project">project</param> /// <returns>stages</returns> public static MCStage[] GetStages(MWebProject project) { List <MCStage> list = new List <MCStage>(); SqlParameter[] param = new SqlParameter[1]; IDataReader idr = null; String sql = "SELECT * FROM CM_CStage WHERE CM_WebProject_ID=@param ORDER BY CM_CStage_ID"; try { //pstmt = DataBase.prepareStatement (sql, project.get_TrxName()); //pstmt.setInt (1, project.getCM_WebProject_ID()); param[0] = new SqlParameter("@param", project.GetCM_WebProject_ID()); idr = DataBase.DB.ExecuteReader(sql, param, project.Get_TrxName()); while (idr.Read()) { list.Add(new MCStage(project.GetCtx(), idr, project.Get_TrxName())); } idr.Close(); } catch (Exception e) { if (idr != null) { idr.Close(); } _log.Log(Level.SEVERE, sql, e); } MCStage[] retValue = new MCStage[list.Count]; retValue = list.ToArray(); return(retValue); } // getStages
} // getStages /// <summary> /// Get Stage by Name /// </summary> /// <param name="project">project</param> /// <param name="RelativeURL">relurl</param> /// <param name="parent_ID">id</param> /// <returns>stages</returns> public static MCStage GetByName(MWebProject project, String RelativeURL, int parent_ID) { MCStage retValue = null; IDataReader idr = null; SqlParameter[] param = new SqlParameter[4]; String sql = "SELECT * FROM CM_CStage WHERE CM_WebProject_ID=@param1 AND RelativeURL LIKE @param2 " + //1,2 "AND CM_CStage_ID IN (SELECT Node_ID FROM AD_TreeNodeCMS WHERE " + " AD_Tree_ID=@param3 AND Parent_ID=@param4)" + // 3, 4 "ORDER BY CM_CStage_ID"; try { //pstmt = DataBase.prepareStatement (sql, project.get_TrxName()); //pstmt.setInt (1, project.getCM_WebProject_ID()); param[0] = new SqlParameter("@param1", project.GetCM_WebProject_ID()); //pstmt.setString (2, RelativeURL); param[1] = new SqlParameter("@param2", RelativeURL); //pstmt.setInt (3, project.getAD_TreeCMS_ID ()); param[2] = new SqlParameter("@param3", project.GetAD_TreeCMS_ID()); //pstmt.setInt (4, parent_ID); param[3] = new SqlParameter("@param4", parent_ID); idr = DataBase.DB.ExecuteReader(sql, param, project.Get_TrxName()); if (idr.Read()) { retValue = new MCStage(project.GetCtx(), idr, project.Get_TrxName()); } idr.Close(); } catch (Exception e) { if (idr != null) { idr.Close(); } _log.Log(Level.SEVERE, sql, e); } return(retValue); } // getStages