public async Task <ResponseObject <string> > ExportOpeningTemplate()
        {
            try
            {
                CurrentUser currentUser = TokenManager.GetCurentUserbyToken(HttpContext.Request.Headers);
                var         result      = await _inventoryReportService.ExportOpeningTemplate(currentUser);

                ExportOpeningTemplateVM <MaterialFileTemplate> model = new ExportOpeningTemplateVM <MaterialFileTemplate>();
                model.Entitys = result.Data.List == null ? new List <MaterialFileTemplate>() : result.Data.List;
                model.Columns = new List <string>()
                {
                    "MaterialCode", "MaterialName", "Spec", "WareName", "WareUnitName"
                };
                model.Titles = new List <string>()
                {
                    "MaterialCode", "MaterialName", "Spec", "WareName", "WareUnitName"
                };
                model.HeaderText            = "期初模板";
                model.TableName             = "期初模板";
                model.FillRow               = 1;
                model.DropDownEntitys       = result.Data.WarehouseName;
                model.DropDownFillStartCell = 3;
                model.DropDownFillEndCell   = 3;
                model.Path = Path.Combine(AppContext.BaseDirectory, "Template", "ExportOpeningTemplate.xlsx");
                Stream stream   = ExcelHelp.ExportOpeningTemplate <MaterialFileTemplate>(model);
                string fileName = "期初模板.xlsx";
                Dictionary <string, string> headsSend = new Dictionary <string, string>();
                headsSend.Add(TokenConfig.Instace.TokenKey, Request.Headers[TokenConfig.Instace.TokenKey]);
                var filePath = RestfulApiClient.UploadFile(RestfulApiClient.UplaodUrl, "api/files/upload", headsSend, stream, fileName);
                return(ResponseUtil <string> .SuccessResult(filePath.ToString()));
            }
            catch (Exception ex)
            {
                return(ResponseUtil <string> .FailResult(null, ex.ToString()));
            }
        }
Ejemplo n.º 2
0
        public static MemoryStream ExportOpeningTemplate <T>(ExportOpeningTemplateVM <T> model)
        {
            DataTable dt = ListToDataTable <T>(model.Entitys, model.TableName, model.Columns, model.Titles);

            return(ExportOpeningTemplate(dt, model.DropDownEntitys, model.Path, model.FillRow, model.DropDownFillStartCell, model.DropDownFillEndCell));
        }