public JsonResult ImportExcelFile(HttpPostedFileBase file)
{
try
{
if (file.ContentLength == 0)
{
return this.Json(new { IsSuccess = false, ErrorMsg = "没有文件！" });
}
// 生成文件名
var fileName = Path.Combine(Request.MapPath("~/Upload/" + DateTime.Now.ToString("yyyyMM")), Guid.NewGuid().ToString().ToUpper() + Path.GetFileName(file.FileName));
// 按月存储文件
if (Directory.Exists(Request.MapPath("~/Upload/" + DateTime.Now.ToString("yyyyMM"))) == false)
{
Directory.CreateDirectory(Request.MapPath("~/Upload/" + DateTime.Now.ToString("yyyyMM")));
}
// 存储文件
file.SaveAs(fileName);
BGetTableDefineFromExcel bll = new BGetTableDefineFromExcel();
var result = bll.GetTableDefineListFromExcel(fileName);
BGeneratorSQL generatorSql = new BGeneratorSQL();
var sqlResult = generatorSql.GeneratorSQL(result);
return this.Json(new { IsSuccess = true, Result = sqlResult });
}
catch (Exception ex)
{
return this.Json(new { IsSuccess = false, ErrorMsg = ex.Message.ToString() });
}
}
public static void TestSQL()
{
BGetTableDefineFromExcel bll = new BGetTableDefineFromExcel();
var db = bll.GetTableDefineListFromExcel(@"D:\01code\02mine\01component\HelpWeb\HelpWeb\Upload\UserManageDB.xls");
string json = JsonConvert.SerializeObject(db);
BGeneratorSQL sqlBll = new BGeneratorSQL();
var ret = sqlBll.GeneratorSQL(db);
string jsonRet = JsonConvert.SerializeObject(ret);
}