Ejemplos de gov.va.medora.mdo.dao.oracle.mhv.sm FolderDao.buildGetFolderQuery en C# (CSharp)

buildGetFolderQuery() private method

private buildGetFolderQuery ( Int32 folderId ) : OracleQuery
folderId	System.Int32
return	OracleQuery

Ejemplo n.º 1

Archivo: FolderDaoTest.cs Proyecto: ChristopherEdwards/MDWS

        public void testGetFolderSql()
        {
            FolderDao dao = new FolderDao(new MdoOracleConnection(new DataSource() { ConnectionString = "MyCxnString" }));
            OracleQuery result = dao.buildGetFolderQuery(1);

            Assert.IsNotNull(result);
            Assert.AreEqual("SELECT FOLDER_ID, USER_ID, FOLDER_NAME, OPLOCK AS FOLDOPLOCK FROM SMS.FOLDER WHERE FOLDER_ID=:folderId AND ACTIVE=1", result.Command.CommandText);
            Assert.AreEqual(1, result.Command.Parameters.Count);
            Assert.AreEqual(System.Data.DbType.Decimal, result.Command.Parameters[0].DbType);
            Assert.AreEqual("folderId", result.Command.Parameters[0].ParameterName);
            Assert.AreEqual(1, result.Command.Parameters[0].Value);
            Assert.AreEqual(1, result.Command.Parameters.Count);
        }

Ejemplo n.º 2

        public void testGetFolderSql()
        {
            FolderDao dao = new FolderDao(new MdoOracleConnection(new DataSource()
            {
                ConnectionString = "MyCxnString"
            }));
            OracleQuery result = dao.buildGetFolderQuery(1);

            Assert.IsNotNull(result);
            Assert.AreEqual("SELECT FOLDER_ID, USER_ID, FOLDER_NAME, OPLOCK AS FOLDOPLOCK FROM SMS.FOLDER WHERE FOLDER_ID=:folderId AND ACTIVE=1", result.Command.CommandText);
            Assert.AreEqual(1, result.Command.Parameters.Count);
            Assert.AreEqual(System.Data.DbType.Decimal, result.Command.Parameters[0].DbType);
            Assert.AreEqual("folderId", result.Command.Parameters[0].ParameterName);
            Assert.AreEqual(1, result.Command.Parameters[0].Value);
            Assert.AreEqual(1, result.Command.Parameters.Count);
        }