C# (CSharp) gov.va.medora.mdo.dao.oracle.mhv.sm UserDao.buildGetValidRecipientsForPatientQuery示例

buildGetValidRecipientsForPatientQuery() private method

private buildGetValidRecipientsForPatientQuery ( Int32 userId ) : OracleQuery
userId	System.Int32
return	OracleQuery

示例#1

        public void testGetValidRecipientsForPatientSqlStatement()
        {
            UserDao     dao   = new UserDao(_cxn);
            OracleQuery query = dao.buildGetValidRecipientsForPatientQuery(1);

            Assert.IsTrue(String.Equals(query.Command.CommandText, "SELECT TG.TRIAGE_GROUP_ID, TG.TRIAGE_GROUP_NAME, TG.DESCRIPTION FROM SMS.PATIENT_TRIAGE_MAP PTM JOIN SMS.TRIAGE_RELATION TR  ON PTM.RELATION_ID=TR.RELATION_ID  JOIN SMS.TRIAGE_GROUP TG ON TG.TRIAGE_GROUP_ID=TR.TRIAGE_GROUP_ID WHERE PTM.USER_ID = :userId AND PTM.ACTIVE=1"));
        }

示例#2

文件： UserDaoTest.cs 项目： ChristopherEdwards/MDWS

 public void testGetValidRecipientsForPatientSqlStatement()
 {
     UserDao dao = new UserDao(_cxn);
     OracleQuery query = dao.buildGetValidRecipientsForPatientQuery(1);
     Assert.IsTrue(String.Equals(query.Command.CommandText, "SELECT TG.TRIAGE_GROUP_ID, TG.TRIAGE_GROUP_NAME, TG.DESCRIPTION FROM SMS.PATIENT_TRIAGE_MAP PTM JOIN SMS.TRIAGE_RELATION TR  ON PTM.RELATION_ID=TR.RELATION_ID  JOIN SMS.TRIAGE_GROUP TG ON TG.TRIAGE_GROUP_ID=TR.TRIAGE_GROUP_ID WHERE PTM.USER_ID = :userId AND PTM.ACTIVE=1"));
 }