From acfff22fdec6f230a64b8b6f61906e01cc29dd65 Mon Sep 17 00:00:00 2001 From: whywhyo <1511349576@qq.com> Date: 星期二, 23 五月 2023 16:38:41 +0800 Subject: [PATCH] 456 --- ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZfPropertyController.java | 60 +++++++++++++++++++++++++++++------------------------------- 1 files changed, 29 insertions(+), 31 deletions(-) diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZfPropertyController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZfPropertyController.java index ee85e92..46810a1 100644 --- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZfPropertyController.java +++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZfPropertyController.java @@ -3,14 +3,14 @@ import com.ruoyi.common.annotation.Log; import com.ruoyi.common.core.controller.BaseController; import com.ruoyi.common.core.domain.AjaxResult; -import com.ruoyi.common.core.domain.entity.SysUser; -import com.ruoyi.common.core.domain.model.LoginUser; import com.ruoyi.common.core.text.Convert; import com.ruoyi.common.enums.BusinessType; import com.ruoyi.common.utils.ServletUtils; import com.ruoyi.common.utils.poi.ExcelUtil; +import com.ruoyi.domain.ZfEquipment; import com.ruoyi.domain.ZfProperty; -import com.ruoyi.framework.web.service.TokenService; +import com.ruoyi.domain.excel.ZfEconomyExcelBean; +import com.ruoyi.domain.excel.ZfPropertyExcelBean; import com.ruoyi.service.IZfPropertyService; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; @@ -19,6 +19,7 @@ import javax.servlet.http.HttpServletResponse; import java.util.Arrays; +import java.util.Collections; import java.util.List; import static com.ruoyi.common.core.page.TableSupport.PAGE_NUM; @@ -37,27 +38,22 @@ @Autowired private IZfPropertyService zfPropertyService; - @Autowired - private TokenService tokenService; - @GetMapping("/all") public AjaxResult listAll(ZfProperty zfProperty){ Integer pageNum = Convert.toInt(ServletUtils.getParameter(PAGE_NUM), 1); Integer pageSize = Convert.toInt(ServletUtils.getParameter(PAGE_SIZE), 10); - return zfPropertyService.selectUserList(zfProperty, pageNum, pageSize); + return zfPropertyService.selectPropertyList(zfProperty, pageNum, pageSize); } -// /** -// * 鏌ヨ瀹跺涵璧勪骇璁板綍鍒楄〃 -// */ -//// @PreAuthorize("@ss.hasPermi('system:property:list')") -// @GetMapping("/list") -// public TableDataInfo list(ZfProperty zfProperty) -// { -// startPage(); -// List<ZfProperty> list = zfPropertyService.selectZfPropertyList(zfProperty); -// return getDataTable(list); -// } + /** + * 鑾峰彇瀵煎叆妯℃澘 + */ + @PostMapping("/model") + public void getExportModel(HttpServletResponse response){ + List<ZfPropertyExcelBean> list = Collections.singletonList(new ZfPropertyExcelBean()); + ExcelUtil<ZfPropertyExcelBean> util = new ExcelUtil<>(ZfPropertyExcelBean.class); + util.exportExcel(response,list,"瀹跺涵璧勪骇瀵煎叆妯℃澘"); + } /** * 瀵煎嚭瀹跺涵璧勪骇璁板綍鍒楄〃 @@ -69,8 +65,20 @@ { List<ZfProperty> list = zfPropertyService.selectByCondition(zfProperty); log.info("瀵煎嚭璁板綍涓�:{}",list); - ExcelUtil<ZfProperty> util = new ExcelUtil<ZfProperty>(ZfProperty.class); + ExcelUtil<ZfProperty> util = new ExcelUtil<>(ZfProperty.class); util.exportExcel(response, list, "瀹跺涵璧勪骇璁板綍鏁版嵁"); + } + /** + * 瀵煎嚭瀹跺涵璧勪骇璁板綍鍒楄〃 + */ + @Log(title = "瀹跺涵澶т簨浠惰褰�", businessType = BusinessType.EXPORT) + @PostMapping("/export1/{ids}") + public void export1(HttpServletResponse response, @PathVariable Long[] ids) { + List<ZfProperty> list = zfPropertyService.selectByIds(ids); + log.info("瀵煎嚭璁板綍涓�:{}", list); + ExcelUtil<ZfProperty> util = new ExcelUtil<ZfProperty>(ZfProperty.class); + util.exportExcel(response, list, "瀹跺涵澶т簨浠惰褰曟暟鎹�"); + } // @@ -81,18 +89,8 @@ @PostMapping("/importData") public AjaxResult importData(@RequestParam("excelImport")MultipartFile file) throws Exception { - ExcelUtil<ZfProperty> util = new ExcelUtil<>(ZfProperty.class); - List<ZfProperty> propertyList = util.importExcel(file.getInputStream()); - log.info("璧勪骇鍒楄〃涓猴細{}",propertyList); - - if (zfPropertyService.saveBatch(propertyList)) { - return AjaxResult.success("瀵煎叆鏁版嵁鎴愬姛"); - } - - return AjaxResult.error("瀵煎叆鏁版嵁澶辫触"); - + return zfPropertyService.importExcel(file); } - /** * 鑾峰彇瀹跺涵璧勪骇璁板綍璇︾粏淇℃伅 @@ -112,7 +110,7 @@ @PostMapping public AjaxResult add(@RequestBody ZfProperty zfProperty) { - return toAjax(zfPropertyService.save(zfProperty)); + return zfPropertyService.addData2(zfProperty); } /** -- Gitblit v1.9.1