zszq-trs/YLErpWeb/Controllers/eod_currency_rateController.cs

using YLErp.Modules.EodModule;

namespace YLErp.Web.Controllers
{
    public class eod_currency_rateController : BaseController
    {
        readonly IViewRenderService _viewRenderer;

        public eod_currency_rateController(IViewRenderService viewRenderer)
        {
            _viewRenderer = viewRenderer;
        }

        [MyAuthorize("结算管理-结算汇率查看")]
        public ActionResult eod_currency_rateList()
        {
            return View();
        }

        [HttpPost]
        public JsonResult eod_currency_rateQuery(EodCurrencyRateReq req)
        {
            var sList = new EodCurrencyRateService(CurUser).SearchEodCurrencyRateList(req);
            return Json(sList);
        }

        /// <summary>
        /// 导入结算价
        /// </summary>
        public async Task<ActionResult> UploadCurrencyRate(IFormFile file)
        {
            try
            {
                if (file == null || string.IsNullOrWhiteSpace(file.FileName))
                {
                    return JsonError("未获取上传文件");
                }
                var fileExtension = Path.GetExtension(file.FileName);
                if (fileExtension.ToLowerInvariant() != ".xlsx")
                {
                    return JsonError("请上传xlsx格式的文件");
                }
                using var openStream = file.OpenReadStream();
                var result = new EodCurrencyRateService(CurUser).ImportxlsxDatas(openStream);
                var html = await _viewRenderer.RenderToStringAsync("Common/ImportResult", result);
                return JsonSuccess(null, html);
            }
            catch (Exception ex)
            {
                LogFactory.GetLogger<eod_currency_rateController>().Error("导入汇率出错", ex);
                return JsonError(ex.Message);
            }
        }
    }
}