public void TestPerforman() { DateTime timeNow = DateTime.Now; //Console.Out.WriteLine("time now:" + (DateTime.Now)); for (int i = 0; i < 1000; i++) { string constr = ConfigCache.GetDBConnectStr("SQLSERVER"); MySQLHelper.ExecuteDataset(constr, CommandType.Text, "select * from city ", null); MySQLHelper.ExecuteDataset(constr, CommandType.Text, "select * from city ", null); MySQLHelper.ExecuteDataset(constr, CommandType.Text, "select * from city ", null); } //Console.Out.WriteLine("time now:" + (DateTime.Now)); Console.Out.WriteLine("Aop use time:" + timeNow.Subtract(DateTime.Now).Duration()); timeNow = DateTime.Now; //Console.Out.WriteLine("time now:" + (DateTime.Now)); for (int i = 0; i < 1000; i++) { BizBO bizBo = TransactionAOP.newInstance(typeof(BizBO)) as BizBO; bizBo.queryCity(); } //Console.Out.WriteLine("time now:" + (DateTime.Now)); Console.Out.WriteLine("No Aop use time:" + timeNow.Subtract(DateTime.Now).Duration()); }
public void TestMethod_Table2List() { BizBO bizBo = TransactionAOP.newInstance(typeof(BizBO)) as BizBO; DataTable table = bizBo.add3(); IList <MyCity> city = DBUtil.Table2List <MyCity>(table); string s = city[9].city; Assert.AreEqual("Akishima", s, "cityname"); }
public void TestMethod_Table2List2() { BizBO bizBo = TransactionAOP.newInstance(typeof(BizBO)) as BizBO; DataTable table = bizBo.add3(); IList <MyCity2> city = DBUtil.Table2List <MyCity2>(table); int s = city[9].city_id1; Assert.AreEqual(0, s, "cityid"); }
public void TestMethod_Row2Object2() { BizBO bizBo = TransactionAOP.newInstance(typeof(BizBO)) as BizBO; DataRow dr = bizBo.add2(); MyCity2 city = DBUtil.Row2Object <MyCity2>(dr); Assert.AreEqual(0, city.city_id1, "id "); Assert.AreEqual("A Corua (La Corua)", city.city, "cityname"); Assert.AreEqual(87, city.country_id, "countryid"); }
public void TestMethod_Row2Object() { BizBO bizBo = TransactionAOP.newInstance(typeof(BizBO)) as BizBO; DataRow dr = bizBo.add2(); MyCity city = DBUtil.Row2Object <MyCity>(dr); Assert.AreEqual(1, city.city_id, "id is 1"); //BizBO bizBo = TransactionAOP.newInstance(typeof(BizBO)) as BizBO; //DataRow dr = bizBo.add2(); //TimeSpan ts1 = new TimeSpan(DateTime.Now.Ticks); //获取当前时间的刻度数 //for (int i = 0; i < 3000; i++) //{ // MyCity city = DBUtil.Row2Object<MyCity>(dr); //} //TimeSpan ts2 = new TimeSpan(DateTime.Now.Ticks); //TimeSpan ts = ts2.Subtract(ts1).Duration(); //时间差的绝对值 //string spanTotalSeconds = ts.TotalSeconds.ToString(); //执行时间的总秒数 //Console.WriteLine("执行时间总秒数:" + spanTotalSeconds); }
public void TestMethod1() { BizBO bizBo = TransactionAOP.newInstance(typeof(BizBO)) as BizBO; bizBo.add(); }