.Net6.0+Vue3实现数据简易导入功能全过程_实用技巧_

[DisableRequestSizeLimit] [HttpPost] public IActionResult Upload() { var files = Request.Form.Files; long size = files.Sum(f => f.Length); string contentRootPath = AppContext.BaseDirectory; List filenames = new List(); foreach (IFormFile formFile in files) { if (formFile.Length > 0) { string fileExt = Path.GetExtension(formFile.FileName); long fileSize = formFile.Length; string newFileName = System.Guid.NewGuid().ToString() + fileExt; var filePath = contentRootPath + "/fileUpload/"; if (!Directory.Exists(filePath)) { Directory.CreateDirectory(filePath); } using (var stream = new FileStream(filePath + newFileName, FileMode.Create)) { formFile.CopyTo(stream); } filenames.Add(newFileName); } } return Ok(filenames); }

/// 
 /// 上传文件数据 /// 
 ///  ///  [HttpPut] public IActionResult Put(DataInput uploadStuInfoInput) { Encoding.RegisterProvider(CodePagesEncodingProvider.Instance); var filePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "fileUpload", uploadStuInfoInput.filePath); if (!System.IO.File.Exists(filePath)) { return BadRequest("导入失败,文件不存在!"); } var row = MiniExcelLibs.MiniExcel.Query(filePath).ToList(); companies.AddRange(row.Select(x => new Company { Name = x.名称, Address = x.地址 })); return Ok("导入成功!"); }

const getData = () => {       axios.get('/Company', { params: state.searchInput }).then(function (response) {         state.tableData = response.data;       })     }

[HttpGet] public dynamic Get([FromQuery] SelectInput selectInput) { return new { total = companies.Count(), data = companies.Skip((selectInput.pageIndex - 1) * selectInput.pageSize).Take(selectInput.pageSize).ToList() }; }

import FileUpload from '@/components/FileUpload.vue';

                              
将文件拖到此处，或点击上传
         
请选择({{  accept  }})文件
              
                    导入           取消                
        

const fileUploadEnd = (response, file) => {       state.fileresponse = file.name;       state.formData.filePath = response[0];       if (state.fileList.length > 0) {         state.fileList.splice(0, 1);       }     }

const submit = () => {       if (state.formData.filePath == '') {         ElMessage.error('请选择上传的文件')         return;       }       context.emit('childClick', state.formData)     }

const fileUploadchildClick = (e) => {       axios.put('/Company', {         filePath: e.filePath,       }).then(function (response) {         if (response.status == 200) {           ElMessage.success(response.data);           fileUpload.value.cancel();           getData();         } else {           ElMessage.error(response.data)         }       })     }

/// 
 /// 上传文件数据 /// 
 ///  ///  [HttpPut] public IActionResult Put(DataInput uploadStuInfoInput) { Encoding.RegisterProvider(CodePagesEncodingProvider.Instance); var filePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "fileUpload", uploadStuInfoInput.filePath); if (!System.IO.File.Exists(filePath)) { return BadRequest("导入失败,文件不存在!"); } var row = MiniExcelLibs.MiniExcel.Query(filePath).ToList(); companies.AddRange(row.Select(x => new Company { Name = x.名称, Address = x.地址 })); return Ok("导入成功!"); 　　　　 }

import DataUpload from '@/components/DataUpload.vue';

                   
将文件拖到此处，或点击上传
          
                确认导入            
                             
            
   

const uploadChange = async (file) => {       let dataBinary = await readFile(file.raw)       let workBook = XLSX.read(dataBinary, { type: 'binary', c
                
提示：
                    本文由神整理自网络，如有侵权请联系本站删除！
                    

                    本站声明： 

                    1、本站所有资源均来源于互联网，不保证100%完整、不提供任何技术支持； 

                    2、本站所发布的文章以及附件仅限用于学习和研究目的;不得将用于商业或者非法用途；否则由此产生的法律后果，本站概不负责！
                
                

                

                                            
上一篇：.Net实现图片裁剪图片缩放及图片加水印详解_ASP.NET_
                                                                
下一篇：.NET使用StackTrace获取方法调用信息的代码演示_实用技巧_