public void TestAdd() { TestEntity t = new TestEntity { Name = null, Password = "******", Mobile = "tcp://180.169.101.177:41205", Pk = "12340", Email = "中信期货" }; var en = new EntityFrameWork <TestEntity>(DBType.MYSQL); var s1 = en.Add(t, dbConnection); }
public void TestUpdate() { TestEntity t = new TestEntity { Name = "tcp://180.169.101.177:41213", Password = "******", Mobile = "tcp://180.169.101.177:41205", Pk = "1234", Email = "中信期货0" }; var en = new EntityFrameWork <TestEntity>(DBType.MYSQL); var s1 = en.Update(t, dbConnection); Assert.AreEqual(s1, 1); }
public void TestSelectPage() { var en = new EntityFrameWork <TestEntity>(DBType.MYSQL); var parm = new Dictionary <string, object>(); //parm.Add("Email>=", "Simnow模拟"); var page = new DataAccess.Model.DataPage { PageIndex = 1, PageSize = 1 }; var s1 = en.List(dbConnection, parm, page); Assert.AreEqual(s1.Count, 1); }
public void TestSelectNoPage() { Stopwatch watch = new Stopwatch(); watch.Restart(); var en = new EntityFrameWork <StockSymbolInfo>(DBType.MYSQL); var parm = new Dictionary <string, object>(); //parm.Add("Email", "中信期货"); var s1 = en.List(dbConnection, parm); watch.Stop(); var s = watch.ElapsedMilliseconds; //Assert.AreEqual(s1.Count, 1); }
public void TestOnlyUpdate() { TestEntity t = new TestEntity { Name = "tcp://180.169.101.177", Password = "******", Mobile = "tcp://180.169.101.177", OldPk = "1234", Email = "中信期货1" }; var en = new EntityFrameWork <TestEntity>(DBType.MYSQL); var fileds = new List <string>() { "Email" }; var s1 = en.Update(t, dbConnection, fileds); Assert.AreEqual(s1, 1); }
public void TestSelectTimee() { var en = new EntityFrameWork <StockSymbolInfo>(DBType.MYSQL); var parm = new Dictionary <string, object>(); Stopwatch watch = new Stopwatch(); watch.Restart(); //parm.Add("Email", "中信期货"); var s1 = en.List(dbConnection, parm); watch.Stop(); StockSymbolInfo asd = new StockSymbolInfo(); //var s2 = en.SelectDataTable(new FrameWorkItem //{ // ConnectionString = dbConnection, // SqlParam = parm, // Sql = asd.GetSelectSql() //}); var s = watch.ElapsedMilliseconds; //Assert.AreEqual(s1.Count, 1); }