// // GET: /Test/ public ActionResult Index() { //TestExcel(); //TestAddData(); //TestQueryData(); var helper = new NHTestHelper(this); //helper.TestAdd(); //helper.TestUpdate(); //helper.TestQuery(); //helper.TestPaged(); //helper.TestSQL(); for (var i = 0; i < 100000; i++) { helper.TestQueryAll(); } //helper.TestProcedure(); //var helper = new AdoNetHelper(this); //helper.TestQuery(); //helper.TestProcedure(); //var mZipHelper = new ZipHelper(); //var mDesFolder = System.Web.HttpContext.Current.Server.MapPath("~/Log"); //ViewBag.logsPath= MyFactory.GetExceptionLogHelper().PackLogs(mZipHelper, mDesFolder); MyFactory.GetExceptionLogHelper().LogException("", "", new Exception("TES--111T"), null); var user = new UserInfo(); user.UserName = "******"; MyFactory.GetLogVisitorHelper().LogUser("", user); return(View()); }
public void TestExcel() { //test exception var mLogExceptionHelper = MyFactory.GetExceptionLogHelper(); mLogExceptionHelper.LogException(MethodBase.GetCurrentMethod(), new Exception("TEST...."), null); //test visitor var mLogVisitorHelper = MyFactory.GetLogVisitorHelper(); var mVisitor = new UserInfo(); mVisitor.UserId = "BBWANG"; mVisitor.UserName = "******"; mLogVisitorHelper.LogUser("Index", mVisitor); //test export var excelExportHelper = MyFactory.GetExportToExcelHelper(); var tab = new DataTable(); tab.Columns.Add(new DataColumn("A", typeof(string))); tab.Columns.Add(new DataColumn("B", typeof(string))); for (var i = 1; i <= 100; i++) { var row = tab.NewRow(); row["A"] = string.Format("Row {0} Column{1}", i, 1); row["B"] = string.Format("Row {0} Column{1}", i, 2); tab.Rows.Add(row); } mCurrentController.ViewBag.DownloadLink = excelExportHelper.ExportToExcel("Test", "TEST-BEN", tab); }