初步提交 公共api

schangxiang@126.com

2025-05-08 8fc78b34650a12ab32538170c5bb74110c6f0e74

 Weben_CMSרÓôúÂëÉú³ÉÆ÷/WareCmsUtilityApi/server/src/CMS.Plugin.WareCmsUtilityApi/Controller/SampleController.cs

@@ -1,187 +1,187 @@
using Ao.Lang;
using CMS.Extensions.Abp.AspNetCore.Mvc.Filters;
using CMS.Plugin.WareCmsUtilityApi.Application.Contracts.Dtos.Samples;
using CMS.Plugin.WareCmsUtilityApi.Application.Contracts.Services;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using MiniExcelLibs;
using System.Reflection;
using Volo.Abp;
using Volo.Abp.Application.Dtos;
//using Ao.Lang;
//using CMS.Extensions.Abp.AspNetCore.Mvc.Filters;
//using CMS.Plugin.WareCmsUtilityApi.Application.Contracts.Dtos.Samples;
//using CMS.Plugin.WareCmsUtilityApi.Application.Contracts.Services;
//using Microsoft.AspNetCore.Authorization;
//using Microsoft.AspNetCore.Http;
//using Microsoft.AspNetCore.Mvc;
//using MiniExcelLibs;
//using System.Reflection;
//using Volo.Abp;
//using Volo.Abp.Application.Dtos;

namespace CMS.Plugin.WareCmsUtilityApi.Controller
{
    /// <summary>
    /// Sample服务
    /// </summary>
    [ApiController]
    [TypeFilter(typeof(CMSLanguageFilter))]
    [TypeFilter(typeof(CMSUowActionFilter))]
    [TypeFilter(typeof(CMSAuditActionFilter))]
    [TypeFilter(typeof(CMSExceptionFilter))]
    [Route("api/v{version:apiVersion}/WareCmsUtilityApi/[controller]")]
    public class SampleController : ControllerBase
    {
        private readonly ISampleAppService _sampleAppService;
//namespace CMS.Plugin.WareCmsUtilityApi.Controller
//{
//    /// <summary>
//    /// Sample服务
//    /// </summary>
//    [ApiController]
//    [TypeFilter(typeof(CMSLanguageFilter))]
//    [TypeFilter(typeof(CMSUowActionFilter))]
//    [TypeFilter(typeof(CMSAuditActionFilter))]
//    [TypeFilter(typeof(CMSExceptionFilter))]
//    [Route("api/v{version:apiVersion}/WareCmsUtilityApi/[controller]")]
//    public class SampleController : ControllerBase
//    {
//        private readonly ISampleAppService _sampleAppService;

        /// <summary>
        /// Initializes a new instance of the <see cref="SampleController"/> class.
        /// </summary>
        /// <param name="sampleAppService">The sample application service.</param>
        public SampleController(ISampleAppService sampleAppService)
        {
            _sampleAppService = sampleAppService;
        }
//        /// <summary>
//        /// Initializes a new instance of the <see cref="SampleController"/> class.
//        /// </summary>
//        /// <param name="sampleAppService">The sample application service.</param>
//        public SampleController(ISampleAppService sampleAppService)
//        {
//            _sampleAppService = sampleAppService;
//        }

        /// <summary>
        /// èŽ·å–sample.
        /// </summary>
        /// <param name="id">标识符.</param>
        /// <returns></returns>
        [HttpGet]
        [Route("{id}")]
        public virtual Task<SampleDto> GetAsync(Guid id)
        {
            return _sampleAppService.GetAsync(id);
        }
//        /// <summary>
//        /// èŽ·å–sample.
//        /// </summary>
//        /// <param name="id">标识符.</param>
//        /// <returns></returns>
//        [HttpGet]
//        [Route("{id}")]
//        public virtual Task<SampleDto> GetAsync(Guid id)
//        {
//            return _sampleAppService.GetAsync(id);
//        }

        /// <summary>
        /// èŽ·å–sample的列表.
        /// </summary>
        /// <param name="input">输入.</param>
        /// <returns></returns>
        [HttpGet]
        public virtual Task<PagedResultDto<SampleDto>> GetListAsync([FromQuery] GetSamplesInput input)
        {
            return _sampleAppService.GetListAsync(input);
        }
//        /// <summary>
//        /// èŽ·å–sample的列表.
//        /// </summary>
//        /// <param name="input">输入.</param>
//        /// <returns></returns>
//        [HttpGet]
//        public virtual Task<PagedResultDto<SampleDto>> GetListAsync([FromQuery] GetSamplesInput input)
//        {
//            return _sampleAppService.GetListAsync(input);
//        }

        /// <summary>
        /// åˆ›å»ºsample.
        /// </summary>
        /// <param name="input">输入.</param>
        /// <returns></returns>
        //[Authorize]
        [HttpPost]
        public virtual Task<SampleDto> CreateAsync(SampleCreateDto input)
        {
            return _sampleAppService.CreateAsync(input);
        }
//        /// <summary>
//        /// åˆ›å»ºsample.
//        /// </summary>
//        /// <param name="input">输入.</param>
//        /// <returns></returns>
//        //[Authorize]
//        [HttpPost]
//        public virtual Task<SampleDto> CreateAsync(SampleCreateDto input)
//        {
//            return _sampleAppService.CreateAsync(input);
//        }

        /// <summary>
        /// æ›´æ–°sample.
        /// </summary>
        /// <param name="id">标识符.</param>
        /// <param name="input">输入.</param>
        /// <returns></returns>
        //[Authorize]
        [HttpPut]
        [Route("{id}")]
        public virtual Task<SampleDto> UpdateAsync(Guid id, SampleUpdateDto input)
        {
            return _sampleAppService.UpdateAsync(id, input);
        }
//        /// <summary>
//        /// æ›´æ–°sample.
//        /// </summary>
//        /// <param name="id">标识符.</param>
//        /// <param name="input">输入.</param>
//        /// <returns></returns>
//        //[Authorize]
//        [HttpPut]
//        [Route("{id}")]
//        public virtual Task<SampleDto> UpdateAsync(Guid id, SampleUpdateDto input)
//        {
//            return _sampleAppService.UpdateAsync(id, input);
//        }

        /// <summary>
        /// å…‹éš†Sample.
        /// </summary>
        /// <param name="ids">Id集合.</param>
        /// <returns></returns>
        //[Authorize]
        [HttpPost]
        [Route("Clone")]
        public virtual Task<List<SampleDto>> CloneAsync([FromBody] IEnumerable<Guid> ids)
        {
            return _sampleAppService.CloneAsync(ids);
        }
//        /// <summary>
//        /// å…‹éš†Sample.
//        /// </summary>
//        /// <param name="ids">Id集合.</param>
//        /// <returns></returns>
//        //[Authorize]
//        [HttpPost]
//        [Route("Clone")]
//        public virtual Task<List<SampleDto>> CloneAsync([FromBody] IEnumerable<Guid> ids)
//        {
//            return _sampleAppService.CloneAsync(ids);
//        }

        /// <summary>
        /// åˆ é™¤sample.
        /// </summary>
        /// <param name="id">标识符.</param>
        /// <returns></returns>
        //[Authorize]
        [HttpDelete]
        [Route("{id}")]
        public virtual Task DeleteAsync(Guid id)
        {
            return _sampleAppService.DeleteAsync(id);
        }
//        /// <summary>
//        /// åˆ é™¤sample.
//        /// </summary>
//        /// <param name="id">标识符.</param>
//        /// <returns></returns>
//        //[Authorize]
//        [HttpDelete]
//        [Route("{id}")]
//        public virtual Task DeleteAsync(Guid id)
//        {
//            return _sampleAppService.DeleteAsync(id);
//        }

        /// <summary>
        /// æ‰¹é‡åˆ é™¤sample.
        /// </summary>
        /// <param name="ids">The ids.</param>
        /// <returns></returns>
        //[Authorize]
        [HttpDelete]
        public virtual Task DeleteAsync([FromBody] IEnumerable<Guid> ids)
        {
            return _sampleAppService.DeleteManyAsync(ids);
        }
//        /// <summary>
//        /// æ‰¹é‡åˆ é™¤sample.
//        /// </summary>
//        /// <param name="ids">The ids.</param>
//        /// <returns></returns>
//        //[Authorize]
//        [HttpDelete]
//        public virtual Task DeleteAsync([FromBody] IEnumerable<Guid> ids)
//        {
//            return _sampleAppService.DeleteManyAsync(ids);
//        }

        /// <summary>
        /// è°ƒæ•´æŽ’序.
        /// </summary>
        /// <param name="id">标识符.</param>
        /// <returns></returns>
        [HttpPut]
        [Route("{id}/AdjustSort/{sort}")]
        public virtual Task AdjustSortAsync(Guid id, int sort)
        {
            return _sampleAppService.AdjustSortAsync(id, sort);
        }
//        /// <summary>
//        /// è°ƒæ•´æŽ’序.
//        /// </summary>
//        /// <param name="id">标识符.</param>
//        /// <returns></returns>
//        [HttpPut]
//        [Route("{id}/AdjustSort/{sort}")]
//        public virtual Task AdjustSortAsync(Guid id, int sort)
//        {
//            return _sampleAppService.AdjustSortAsync(id, sort);
//        }

        /// <summary>
        /// å¯¼å…¥sample.
        /// </summary>
        /// <returns></returns>
        [Authorize]
        [HttpPost]
        [Route("Import")]
        public virtual async Task<IActionResult> ImportAsync(IFormFile file)
        {
            using var stream = new MemoryStream();
            await file.CopyToAsync(stream);
            stream.Seek(0L, SeekOrigin.Begin);
//        /// <summary>
//        /// å¯¼å…¥sample.
//        /// </summary>
//        /// <returns></returns>
//        [Authorize]
//        [HttpPost]
//        [Route("Import")]
//        public virtual async Task<IActionResult> ImportAsync(IFormFile file)
//        {
//            using var stream = new MemoryStream();
//            await file.CopyToAsync(stream);
//            stream.Seek(0L, SeekOrigin.Begin);

            var sheetNames = stream.GetSheetNames();
            var sampleRows = sheetNames.Contains("配置") ? MiniExcel.Query<SamplesImportModel.SampleImportModel>(stream, sheetName: "配置").ToList() : new();
//            var sheetNames = stream.GetSheetNames();
//            var sampleRows = sheetNames.Contains("配置") ? MiniExcel.Query<SamplesImportModel.SampleImportModel>(stream, sheetName: "配置").ToList() : new();

            if (!sampleRows.Any())
            {
                throw new UserFriendlyException("请检查导入的表格");
            }
//            if (!sampleRows.Any())
//            {
//                throw new UserFriendlyException("请检查导入的表格");
//            }

            await _sampleAppService.ImportAsync(new SamplesImportModel
            {
                Samples = sampleRows,
            });
//            await _sampleAppService.ImportAsync(new SamplesImportModel
//            {
//                Samples = sampleRows,
//            });

            return Ok();
        }
//            return Ok();
//        }

        /// <summary>
        /// å¯¼å‡ºsample.
        /// </summary>
        /// <returns></returns>
        [HttpGet]
        [Route("Export")]
        public virtual async Task<IActionResult> ExportAsync([FromQuery] GetSamplesInput input)
        {
            input.MaxResultCount = int.MaxValue;
            var exportData = await _sampleAppService.ExportAsync(input);
            var templatePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, $"Resources/Templates/Sample导出模板.xlsx");
            if (!System.IO.File.Exists(templatePath))
            {
                templatePath = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location) ?? string.Empty, $"Resources/Templates/Sample导出模板.xlsx");
            }
//        /// <summary>
//        /// å¯¼å‡ºsample.
//        /// </summary>
//        /// <returns></returns>
//        [HttpGet]
//        [Route("Export")]
//        public virtual async Task<IActionResult> ExportAsync([FromQuery] GetSamplesInput input)
//        {
//            input.MaxResultCount = int.MaxValue;
//            var exportData = await _sampleAppService.ExportAsync(input);
//            var templatePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, $"Resources/Templates/Sample导出模板.xlsx");
//            if (!System.IO.File.Exists(templatePath))
//            {
//                templatePath = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location) ?? string.Empty, $"Resources/Templates/Sample导出模板.xlsx");
//            }

            var memoryStream = new MemoryStream();
            await memoryStream.SaveAsByTemplateAsync(templatePath, exportData.Sheets);
            memoryStream.Seek(0L, SeekOrigin.Begin);
            return new FileStreamResult(memoryStream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet") { FileDownloadName = $"{exportData.FileName}_{DateTime.Now:yyyyMMddhhmmss}.xlsx" };
        }
    }
}
//            var memoryStream = new MemoryStream();
//            await memoryStream.SaveAsByTemplateAsync(templatePath, exportData.Sheets);
//            memoryStream.Seek(0L, SeekOrigin.Begin);
//            return new FileStreamResult(memoryStream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet") { FileDownloadName = $"{exportData.FileName}_{DateTime.Now:yyyyMMddhhmmss}.xlsx" };
//        }
//    }
//}