public ActionResult ExecuteSQL(string sql, bool?IsExport)
{
try
{
if (IsExport.HasValue && IsExport.Value)
{
ExcelHelper excelHelper = new ExcelHelper();
excelHelper.AddSheet("Sheet1", SqliteDBHelper.Query(sql).Tables[0]);
excelHelper.Export();
return(Content(string.Empty));
}
else
{
SqliteDBHelper.ExecuteSql(sql);
}
ViewBag.Message = "SQL执行成功";
ViewBag.Access = "True";
}
catch (Exception ex)
{
ViewBag.Message = "执行错误" + ex.Message;
}
return(View());
}
