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

buildGetUserByIdQuery() private method

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

示例#1

        public void testGetUserByIdSqlStatement()
        {
            UserDao     dao   = new UserDao(_cxn);
            OracleQuery query = dao.buildGetUserByIdQuery(1);

            Assert.IsTrue(String.Equals(query.Command.CommandText, "SELECT USER_ID, FIRST_NAME, LAST_NAME, USER_TYPE, STATUS, EMAIL_ADDRESS, OPLOCK, ACTIVE, DOB, ICN, SSN, STATION_NO, DUZ, EMAIL_NOTIFICATION, DEFAULT_MESSAGE_FILTER, LAST_EMAIL_NOTIFICATION, NSSN, PROVIDER, EXTERNAL_USER_NAME FROM SMS.sms_user WHERE USER_ID = :userId"));
        }

示例#2

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

 public void testGetUserByIdSqlStatement()
 {
     UserDao dao = new UserDao(_cxn);
     OracleQuery query = dao.buildGetUserByIdQuery(1);
     Assert.IsTrue(String.Equals(query.Command.CommandText, "SELECT USER_ID, FIRST_NAME, LAST_NAME, USER_TYPE, STATUS, EMAIL_ADDRESS, OPLOCK, ACTIVE, DOB, ICN, SSN, STATION_NO, DUZ, EMAIL_NOTIFICATION, DEFAULT_MESSAGE_FILTER, LAST_EMAIL_NOTIFICATION, NSSN, PROVIDER, EXTERNAL_USER_NAME FROM SMS.sms_user WHERE USER_ID = :userId"));
 }