public void TestSimpleSelectList()
        {
            MockSimpleObject obj = new MockSimpleObject();

            //obj.DBOrderBy = new Dictionary<string, bool>();
            //obj.DBOrderBy.Add("Status", true);
            obj.Status = 1;
            //obj.CommonName = "cn10%";
            OleDbConnection con = new OleDbConnection(connectString);

            con.Open();
            SimpleDAO.SimpleDAO <MockSimpleObject> dao = new SimpleDAO.SimpleDAO <MockSimpleObject>();
            dao.NullStringValue = null;
            dao.NullIntValue    = 0;
            List <MockSimpleObject> list = dao.SimpleSelectList(con, obj);

            con.Close();
            Assert.IsTrue(list.Count == 3);
        }
示例#2
0
        public void TestSimpleSelectList()
        {
            MockSimpleObject obj = new MockSimpleObject();

            //obj.DBOrderBy = new Dictionary<string, bool>();
            //obj.DBOrderBy.Add("Status", true);
            obj.Status = 1;
            //obj.CommonName = "cn10%";
            //SqlConnection con = new SqlConnection("Data Source=(local);Initial Catalog=JPAS;User ID=jpas_user;Password=jpas2007");
            OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\dev\SimpleDAO\SimpleDAOTest\SimpleDAO.mdb");

            con.Open();
            SimpleDAO.SimpleDAO <MockSimpleObject> dao = new SimpleDAO.SimpleDAO <MockSimpleObject>();
            dao.NullStringValue = null;
            dao.NullIntValue    = 0;
            List <MockSimpleObject> list = dao.SimpleSelectList(con, obj);

            con.Close();
            Assert.IsTrue(list.Count == 3);
        }
示例#3
0
        public void TestSimpleSelectList()
        {
            MockSimpleObject obj = new MockSimpleObject();
            //obj.DBOrderBy = new Dictionary<string, bool>();
            //obj.DBOrderBy.Add("Status", true);
            obj.Status = 1;
            //obj.CommonName = "cn10%";
            OleDbConnection con = new OleDbConnection(connectString);

            con.Open();
            SimpleDAO.SimpleDAO<MockSimpleObject> dao = new SimpleDAO.SimpleDAO<MockSimpleObject>();
            dao.NullStringValue = null;
            dao.NullIntValue = 0;
            List<MockSimpleObject> list = dao.SimpleSelectList(con, obj);
            con.Close();
            Assert.IsTrue(list.Count == 3);
        }
示例#4
0
        public void TestSimpleSelectList()
        {
            MockSimpleObject obj = new MockSimpleObject();
            //obj.DBOrderBy = new Dictionary<string, bool>();
            //obj.DBOrderBy.Add("Status", true);
            obj.Status = 1;
            //obj.CommonName = "cn10%";
            //SqlConnection con = new SqlConnection("Data Source=(local);Initial Catalog=JPAS;User ID=jpas_user;Password=jpas2007");
            OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\dev\SimpleDAO\SimpleDAOTest\SimpleDAO.mdb");

            con.Open();
            SimpleDAO.SimpleDAO<MockSimpleObject> dao = new SimpleDAO.SimpleDAO<MockSimpleObject>();
            dao.NullStringValue = null;
            dao.NullIntValue = 0;
            List<MockSimpleObject> list = dao.SimpleSelectList(con, obj);
            con.Close();
            Assert.IsTrue(list.Count == 3);
        }