public static DataSet RQMTDefectsImpact_Get(int intRQMT_ID = 0, int intSYSTEM_ID = 0) { return(WTSData.GetDataSetFromStoredProcedure("RQMTDefectsImpact_Get", new string[] { "Data", "SR", "Tasks" }, new SqlParameter[] { new SqlParameter("@RQMT_ID", intRQMT_ID), new SqlParameter("@SYSTEM_ID", intSYSTEM_ID) })); }
public static DataSet RQMTBuilder_Data_Get(int RQMTSetID, string RQMTSetName, int WTS_SYSTEMID, int WorkAreaID, int RQMTTypeID, int RQMTSet_RQMTSystemID) { // note: this query can bring back multiple rows for the same rqmt because each rqmt can have multiple descriptions and functionalities; the code viewing the data must account for the dups return(WTSData.GetDataSetFromStoredProcedure("RQMTBuilder_Data_Get", new string[] { "RQMT", "DESC", "FUNC", "DEFECT", "RQMTSETTASK" }, new SqlParameter[] { new SqlParameter("@RQMTSetID", RQMTSetID), new SqlParameter("@RQMTSetName", RQMTSetName), new SqlParameter("@WTS_SYSTEMID", WTS_SYSTEMID), new SqlParameter("@WorkAreaID", WorkAreaID), new SqlParameter("@RQMTTypeID", RQMTTypeID), new SqlParameter("@RQMTSet_RQMTSystemID", RQMTSet_RQMTSystemID) })); }
public static DataSet RQMTEditData_Get(int RQMTID) { return(WTSData.GetDataSetFromStoredProcedure("RQMTEditData_Get", new string[] { "RQMT", "ALLSETS", "ASSOCIATIONS", "ATTRIBUTES", "USAGE", "AVAILABLEFUNCTIONALITIES", "FUNCTIONALITY", "DESCRIPTIONS", "DESCTYPES", "DEFECTS", "DESCATT" }, new SqlParameter[] { new SqlParameter("@RQMTID", RQMTID) })); }