示例#1
0
        public void QueryTest2()
        {
            DBObject dbObj = new DBObject()
            {
                DataBaseType = DBObject.DataBase.Oracle,
                ID           = "CGHLABM",
                Password     = "******",
                Node         = "LNKA1"
            };

            DAOFactory target    = new DAOFactory(dbObj);
            var        daoobject = target.GetDataAccessObjectFactory();

            RPRSPDB rprspdb = new RPRSPDB()
            {
                CHTNO = "1234", SEX = "M"
            };

            var queryResult = daoobject.Query(rprspdb);

            bool result = false;

            if (queryResult.ReturnDataTable.Rows.Count > 0)
            {
                result = true;
            }

            Assert.AreEqual(false, result);
        }
示例#2
0
        public void ExpressionQueryTest()
        {
            DBObject dbObj = new DBObject()
            {
                DataBaseType = DBObject.DataBase.Oracle,
                ID           = "CGHLABM",
                Password     = "******",
                Node         = "LNKA1"
            };
            DAOFactory target    = new DAOFactory(dbObj);
            var        daoobject = target.GetDataAccessObjectFactory();

            var CHTNO = "123";
            var pdb   = new RPRSPDB()
            {
                CHTNO = "123"
            };

            //var result = daoobject.Query<RPRSPDB>((x) => x.CHTNO == CHTNO);
            //var result = daoobject.Query<RPRSPDB>((x) => x.CHTNO.StartsWith("; insert into rlabsyslog(exeemp,exedat,exetm,jobty) values('Test','20150820','0524','TEST');"));
            //var result = daoobject.Query<RPRSPDB>((x) => x.IDNO == "123" && x.ONWMK == null);
            //var result = daoobject.Query<RPRSPDB>((x) => x.CHTNO.EndsWith( pdb.CHTNO));
            var result           = daoobject.Query <RPRSPDB>(x => x.CHTNO == "123").DataList as List <RPRSPDB>;
            var rprspdbChtnoList = (from a in result select a.CHTNO).ToList <string>();
            var lisResult        = daoobject.Query <RPRSPDB>(x => rprspdbChtnoList.Contains(x.CHTNO));

            var startRCVDAT = "20140101";
            var endRCVDAT   = "20151031";
            //var result =
            //    daoobject.Query<RLABINDX>(
            //        x =>
            //            x.CHTNO == CHTNO &&
            //            (x.RCVDAT.CompareTo(startRCVDAT) >= 0 && x.RCVDAT.CompareTo(endRCVDAT) <= 0));
            //var t = (List<RPRSPDB>)result.DataList;

            //foreach (RPRSPDB item in result.DataList)
            //{

            //}

            //Assert.Fail();
        }
示例#3
0
        public void ExpressionQueryPropertiesTest()
        {
            DBObject dbObj = new DBObject()
            {
                DataBaseType = DBObject.DataBase.Oracle,
                ID           = "CGHLABM",
                Password     = "******",
                Node         = "LNKA1"
            };
            DAOFactory target    = new DAOFactory(dbObj);
            var        daoobject = target.GetDataAccessObjectFactory();

            var CHTNO = "123";
            var pdb   = new RPRSPDB()
            {
                CHTNO = "123"
            };

            var result = daoobject.Query <RPRSPDB>((x) => x.CHTNO.EndsWith(pdb.CHTNO));

            Assert.Fail();
        }
示例#4
0
        public void ExpressionQueryInCauseTest()
        {
            DBObject dbObj = new DBObject()
            {
                DataBaseType = DBObject.DataBase.Oracle,
                ID           = "CGHLABM",
                Password     = "******",
                Node         = "LNKA1"
            };
            DAOFactory target    = new DAOFactory(dbObj);
            var        daoobject = target.GetDataAccessObjectFactory();

            var CHTNO = "123";
            var pdb   = new RPRSPDB()
            {
                CHTNO = "123"
            };

            var result           = daoobject.Query <RPRSPDB>(x => x.CHTNO == "123" || x.CHTNO == "500" || x.CHTNO == "88888888").DataList as List <RPRSPDB>;
            var rprspdbChtnoList = (from a in result select a.CHTNO).ToList <string>();
            var lisResult        = daoobject.Query <RLABINDX>(x => rprspdbChtnoList.Contains(x.CHTNO));

            Assert.Fail();
        }