using Ao.Lang; using CMS.Extensions.Abp.AspNetCore.Mvc.Filters; using CMS.Plugin.HIAWms.Application.Contracts.Dtos.WmsMaterialStocks; using CMS.Plugin.HIAWms.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.HIAWms.Controller { /// /// WmsMaterialStock服务 /// [ApiController] [TypeFilter(typeof(CMSLanguageFilter))] [TypeFilter(typeof(CMSUowActionFilter))] [TypeFilter(typeof(CMSAuditActionFilter))] [TypeFilter(typeof(CMSExceptionFilter))] [Route("api/v{version:apiVersion}/HIAWms/[controller]")] public class WmsMaterialStockController : ControllerBase { private readonly IWmsMaterialStockAppService _wmsmaterialstockAppService; /// /// Initializes a new instance of the class. /// /// The wmsmaterialstock application service. public WmsMaterialStockController(IWmsMaterialStockAppService wmsmaterialstockAppService) { _wmsmaterialstockAppService = wmsmaterialstockAppService; } /// /// 获取wmsmaterialstock. /// /// 标识符. /// [HttpGet] [Route("{id}")] public virtual Task GetAsync(Guid id) { return _wmsmaterialstockAppService.GetAsync(id); } /// /// 获取wmsmaterialstock的列表. /// /// 输入. /// [HttpGet] public virtual Task> GetListAsync([FromQuery] GetWmsMaterialStockInput input) { return _wmsmaterialstockAppService.GetListAsync(input); } /// /// 库存明细 /// /// /// [HttpGet] [Route("StockDetail")] public async Task> GetStockDetailAsync([FromQuery]GetWmsMaterialStockInput input) { return await _wmsmaterialstockAppService.GetStockDetailAsync(input); } /// /// 创建wmsmaterialstock. /// /// 输入. /// //[Authorize] [HttpPost] public virtual Task CreateAsync(WmsMaterialStockCreateDto input) { return _wmsmaterialstockAppService.CreateAsync(input); } /// /// 更新wmsmaterialstock. /// /// 标识符. /// 输入. /// //[Authorize] [HttpPut] [Route("{id}")] public virtual Task UpdateAsync(Guid id, WmsMaterialStockUpdateDto input) { return _wmsmaterialstockAppService.UpdateAsync(id, input); } /// /// 克隆WmsMaterialStock. /// /// Id集合. /// //[Authorize] [HttpPost] [Route("Clone")] public virtual Task> CloneAsync([FromBody] IEnumerable ids) { return _wmsmaterialstockAppService.CloneAsync(ids); } /// /// 删除wmsmaterialstock. /// /// 标识符. /// //[Authorize] [HttpDelete] [Route("{id}")] public virtual Task DeleteAsync(Guid id) { return _wmsmaterialstockAppService.DeleteAsync(id); } [HttpDelete] [Route("DeleteStock")] public virtual Task DeleteStockAsync(Guid id) { return _wmsmaterialstockAppService.DeleteAsync(id); } /// /// 批量删除wmsmaterialstock. /// /// The ids. /// //[Authorize] [HttpDelete] public virtual Task DeleteAsync([FromBody] IEnumerable ids) { return _wmsmaterialstockAppService.DeleteManyAsync(ids); } /// /// 调整排序. /// /// 标识符. /// [HttpPut] [Route("{id}/AdjustSort/{sort}")] public virtual Task AdjustSortAsync(Guid id, int sort) { return _wmsmaterialstockAppService.AdjustSortAsync(id, sort); } /// /// 导入wmsmaterialstock. /// /// [Authorize] [HttpPost] [Route("Import")] public virtual async Task ImportAsync(IFormFile file) { using var stream = new MemoryStream(); await file.CopyToAsync(stream); stream.Seek(0L, SeekOrigin.Begin); var sheetNames = stream.GetSheetNames(); var wmsmaterialstockRows = sheetNames.Contains("配置") ? MiniExcel.Query(stream, sheetName: "配置").ToList() : new(); if (!wmsmaterialstockRows.Any()) { throw new UserFriendlyException("请检查导入的表格"); } await _wmsmaterialstockAppService.ImportAsync(new WmsMaterialStocksImportModel { WmsMaterialStocks = wmsmaterialstockRows, }); return Ok(); } /// /// 导出wmsmaterialstock. /// /// [HttpGet] [Route("Export")] public virtual async Task ExportAsync([FromQuery] GetWmsMaterialStockInput input) { input.MaxResultCount = int.MaxValue; var exportData = await _wmsmaterialstockAppService.ExportAsync(input); var templatePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, $"Resources/Templates/WmsMaterialStock导出模板.xlsx"); if (!System.IO.File.Exists(templatePath)) { templatePath = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location) ?? string.Empty, $"Resources/Templates/WmsMaterialStock导出模板.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" }; } } }