/// <summary> /// get a list of patient checklist that are out of date /// </summary> /// <param name="strPatientID"></param> /// <param name="ds"></param> /// <returns></returns> public CStatus GetOutOfDatePatCLDS(DateTime dtEventStart, DateTime dtEventEnd, long lChecklistID, long lChecklistStatusID, string strPatIDs, string strCLIDs, out DataSet ds) { //initialize parameters ds = null; //create a status object and check for valid dbconnection CStatus status = DBConnValid(); if (!status.Status) { return(status); } //load the paramaters list CParameterList pList = new CParameterList(SessionID, ClientIP, UserID); pList.AddInputParameter("pi_dtEventStartDate", dtEventStart); pList.AddInputParameter("pi_dtEventEndDate", dtEventEnd); pList.AddInputParameter("pi_nChecklistID", lChecklistID); pList.AddInputParameter("pi_nChecklistStatusID", lChecklistStatusID); pList.AddInputParameterCLOB("pi_vPatIDs", strPatIDs); pList.AddInputParameterCLOB("pi_vCLIDs", strCLIDs); CDataSet cds = new CDataSet(); return(cds.GetOracleDataSet(DBConn, "PCK_PAT_CHECKLIST.GetOutOfDateMultiPatCLRS", pList, out ds)); }