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