/// <summary>
/// 导入Excell数据
/// </summary>
/// <returns></returns>
public ActionResult ImportExel()
{
int IsOk = 1; //导入状态
DataTable Result = new DataTable(); //导入错误记录表
try
{
string moduleId = Request["moduleId"];//表名
StringBuilder sb_table = new StringBuilder();
HttpFileCollectionBase files = Request.Files;
HttpPostedFileBase file = files["filePath"]; //获取上传的文件
string fullname = file.FileName;
string IsXls = System.IO.Path.GetExtension(fullname).ToString().ToLower(); //System.IO.Path.GetExtension获得文件的扩展名
if (IsXls != ".xls" && IsXls != ".xlsx")
{
IsOk = 0;
}
else
{
string filename = Guid.NewGuid().ToString() + ".xls";
if (fullname.IndexOf(".xlsx") > 0)
{
filename = Guid.NewGuid().ToString() + ".xlsx";
}
if (file != null && file.FileName != "")
{
string msg = UploadHelper.FileUpload(file, Server.MapPath("~/Resource/UploadFile/ImportExcel/"), filename);
}
DataTable dt = ImportExcel.ExcelToDataTable("Sheet1", Server.MapPath("~/Resource/UploadFile/ImportExcel/") + filename);
IsOk = Baseexceliportbll.ImportExcel(moduleId, dt, out Result);
}
}
catch (Exception ex)
{
BaseSysLogBll.Instance.WriteLog("", OperationType.Add, "-1", "异常错误：" + ex.Message);
IsOk = 0;
}
if (Result.Rows.Count > 0)
{
IsOk = 0;
}
var JsonData = new
{
Status = IsOk > 0 ? "true" : "false",
ResultData = Result
};
return(Content(Util.Json.ToJson(JsonData)));
}
