webapi文件上传和下载

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

文件上传我们可以做上传文件保存到图片与导入数据，下载可以下载多样的文件。

上传：实例是单个文件导入

NopiHelper：地址

①简单的上传图片进行保存，方法跟MVC中的一样

 <form name="form1" method="post" enctype="multipart/form-data" action="../api/upload/PostFormData2">

        <div>

            <label for="caption">Image Caption</label>

            <input name="caption" type="text" />

        </div>

        <div>

            <label for="image1">Image File</label>

            <input name="image1" type="file" />

        </div>

        <div>

            <input type="submit" value="Submit" />

        </div>

    </form>

 [HttpPost]

        public async Task<IHttpActionResult> PostFormData2()

        {

            IList<string> paths = new List<string>();

            var files = HttpContext.Current.Request.Files;

            for (int i = ; i < files.Count; i++)

            {

                HttpPostedFile file = files[];

                string filePath = $@"upload/{DateTime.Now.ToString("yyyyMMddssfff")}_{file.FileName}";

                DirectoryInfo rootDir2 = Directory.GetParent(AppDomain.CurrentDomain.BaseDirectory);

                string path = System.IO.Path.Combine(

                     rootDir2.FullName, filePath);

                var dir = Path.GetDirectoryName(path);

                if (!Directory.Exists(dir))

                {

                    Directory.CreateDirectory(dir);

                }

                file.SaveAs(path);

                paths.Add(path);

            }

            return await Task.FromResult(Ok(new { errcode = , data = paths }));

        }

导入数据：这里需要我们Nuget:Npoi

  [HttpPost]

        public async Task<IHttpActionResult> UploadFile()

        {

            try

            {

                //得到上传的文件

                HttpPostedFile file = HttpContext.Current.Request.Files[];
　　　　　　　　　　//转DataTable

                DataTable dt = NopiHelper.ExcelToTable(file.InputStream, , , Path.GetExtension(file.FileName));
　　　　　　　　　　//通过DataTable转实体

                List<TVideosurveillance> list = NopiHelper.Mapper<TVideosurveillance>(dt);

                foreach (TVideosurveillance item in list)

                {

                    TVideosurveillance model = await dbOracle.TVideosurveillances.AsQueryable().FirstAsync(x => x.Dwname == item.Dwname);

                    if (model == null)

                    {

                        model.Dwname = item.Dwname;

                        model.Dwcode = item.Dwcode;

                        model.Code = item.Code;

                        model.Ip = item.Ip;

                        model.Sbtdmc = item.Sbtdmc;

                        double[] vs = WGS84Helper.bd09togcj02(item.Coordx.ToDouble(), item.Coordy.ToDouble());

                        double[] vs2 = WGS84Helper.gcj02towgs84(vs[], vs[]);

                        model.Coordx = vs2[] + "";

                        model.Coordy = vs2[] + "";

                        dbOracle.TVideosurveillances.Insert(model);

                    }

                }

                return await Task.FromResult(Ok(new { errcode = , data = "成功" }));

            }

            catch (Exception ex)

            {

                return await Task.FromResult(Ok(new { errcode = , data = ex.Message }));

            }

        }

下载（导出）：webapi中需要我们对 HttpResponseMessage 进行设置

  /// <summary>

        /// 下载只能使用Get方式，需要我们返回 HttpResponseMessage

        /// </summary>

        /// <returns></returns>

        [HttpGet]

        public async Task<HttpResponseMessage> Test()

        {

            DataTable dt = NopiHelper.Mapper<TestA>();

            //导出的名字，需要带扩展名 *.xls   *.xlsx

            string fileName = "测试.xls";

            Stream stream = NopiHelper.StreamFromDataTable(dt, fileName);

            //设置状态

            HttpResponseMessage httpResponseMessage = new HttpResponseMessage(HttpStatusCode.OK);

            //内容

            httpResponseMessage.Content = new StreamContent(stream);

            //类型

            httpResponseMessage.Content.Headers.ContentType = new MediaTypeHeaderValue("application/vnd.ms-excel");

            //响应内容的值，附件形式

            httpResponseMessage.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment")

            {

                FileName = HttpUtility.UrlEncode(Path.GetFileName(fileName))

            };

            return await Task.FromResult(httpResponseMessage);

        }