1.引用文件 ajaxfileupload.js

 

@{    ViewBag.Title = "数据导入";    Layout = "~/Views/Shared/_IndexLayout.cshtml";}
     
     
    
      
        
       
            
        
                
                     
        
            
        
                
         
                    
           开始导入                    
            下载模板                
         
            
        
            
        
                          
        
        
       
     
      
 
     

 

 

3.后台接收

public ActionResult ImportData(string key,string funName="")        {            try            {                HttpFileCollection files = System.Web.HttpContext.Current.Request.Files;                if (files != null && files.Count > 0 && files[0].ContentLength > 0 && !string.IsNullOrEmpty(files[0].FileName))                {                    string path = AppDomain.CurrentDomain.BaseDirectory + @"Upload\temp\";                    DirectoryInfo dir = new DirectoryInfo(path);                    if (!dir.Exists)                    {                        dir.Create();                    }                    string filename = Path.GetFileName(files[0].FileName);                    if (!string.IsNullOrEmpty(filename))                    {                        var keyValue = Guid.NewGuid().ToString();                        string FileEextension = Path.GetExtension(files[0].FileName);                        filename = keyValue + FileEextension;                        string Fullfilename = Path.Combine(path, filename);                        files[0].SaveAs(Fullfilename); //保存服务器                        //写入数据库                        ImportExcelBiz importBiz = new ImportExcelBiz();                        ImportExcelResultEntity result = importBiz.ImportData(key, funName, Fullfilename);                                                 //用完即删                        if (System.IO.File.Exists(Fullfilename))                        {                            //如果存在则删除                            System.IO.File.Delete(Fullfilename);                        }                         return new ReponseModel { status = true, msg = result.Msg };                    }                    else                    {                        return Error("没有发现您上传的文件名,可能是浏览器兼容问题,请您换个浏览器试试! 详情: files[0].FileName  filename为null");                    }                }                else                {                    return HttpNotFound("没有发现您要上传的文件!");                }            }            catch (Exception ex)            {                return Error("导入excel到报价中出现了异常 详情:"+ex.Message);            }                                            }    }