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