//
// 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);
}
