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