api后台 导入execl

dal 层

 public int Uploading(List<Attendance> user)
        {
            using (IDbConnection conn = new SqlConnection(MSSQL))
            {
                {
                    var list = conn.BulkInsert(user);
                    if (list != null)
                    {
                        return 1;
                    }
                    else
                    {
                        return 0;
                    }
                }
            }
        }

控制器层

 public IActionResult Uploading(IFormFile execl)
        {
            try
            {
                var stream = new MemoryStream();
                execl.CopyTo(stream);
                var list = stream.Query<Attendance>().ToList();
                return Ok(_hongDal.Uploading(list));
            }
            catch (Exception)
            {

                throw;
            }
        }