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

buildGetTriageGroupMembersQuery() private method

private buildGetTriageGroupMembersQuery ( Int32 groupId ) : OracleQuery
groupId	System.Int32
return	OracleQuery

示例#1

        public void testGetTriageGroupMemberIdsSqlStatement()
        {
            UserDao     dao   = new UserDao(_cxn);
            OracleQuery query = dao.buildGetTriageGroupMembersQuery(1);

            Assert.IsTrue(String.Equals(query.Command.CommandText, "SELECT CTM.USER_ID, USR.EMAIL_ADDRESS, USR.OPLOCK, USR.EMAIL_NOTIFICATION, USR.LAST_EMAIL_NOTIFICATION FROM SMS.CLINICIAN_TRIAGE_MAP CTM JOIN SMS.SMS_USER USR ON CTM.USER_ID=USR.USER_ID WHERE CTM.TRIAGE_GROUP_ID=:groupId AND CTM.ACTIVE=1"));
        }

示例#2

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

 public void testGetTriageGroupMemberIdsSqlStatement()
 {
     UserDao dao = new UserDao(_cxn);
     OracleQuery query = dao.buildGetTriageGroupMembersQuery(1);
     Assert.IsTrue(String.Equals(query.Command.CommandText, "SELECT CTM.USER_ID, USR.EMAIL_ADDRESS, USR.OPLOCK, USR.EMAIL_NOTIFICATION, USR.LAST_EMAIL_NOTIFICATION FROM SMS.CLINICIAN_TRIAGE_MAP CTM JOIN SMS.SMS_USER USR ON CTM.USER_ID=USR.USER_ID WHERE CTM.TRIAGE_GROUP_ID=:groupId AND CTM.ACTIVE=1"));
 }