使用oracle做的数据上传系统后台
kongdeqiang
2026-03-23 bdeb03a42dace46b1211bf12f3ad66837814035d
src/main/java/com/example/controller/DataExcelController.java
@@ -9,6 +9,7 @@
import com.example.security.UserContext;
import com.example.service.DataExcelService;
import com.example.service.DepartmentService;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
@@ -34,12 +35,12 @@
    public Result<PageResult<DataExcel>> page(
            @RequestParam(defaultValue = "1") Long current,
            @RequestParam(defaultValue = "10") Long size,
            @RequestParam(required = false) String unitName,
            @RequestParam(required = false) String unitCode,
            @RequestParam(required = false) String transactionNo,
            @RequestParam(required = false) String accountingPeriod) {
        String currentDeptCode = UserContext.getCurrentDeptCode();
        List<String> permissionDeptCodes = departmentService.getChildDeptCodes(currentDeptCode);
        IPage<DataExcel> page = dataExcelService.getDataExcelPage(current, size, unitName, transactionNo, accountingPeriod, permissionDeptCodes);
        IPage<DataExcel> page = dataExcelService.getDataExcelPage(current, size, unitCode, transactionNo, accountingPeriod, permissionDeptCodes);
        return Result.success(new PageResult<>(page.getTotal(), current, size, page.getRecords()));
    }
@@ -59,12 +60,14 @@
    @PostMapping
    public Result<Boolean> save(@RequestBody DataExcel dataExcel) {
        DataExcel dataExcel1 = new DataExcel();
        String currentDeptCode = UserContext.getCurrentDeptCode();
        List<String> permissionDeptCodes = departmentService.getChildDeptCodes(currentDeptCode);
        if (!permissionDeptCodes.contains(dataExcel.getUnitCode())) {
            return Result.error("无权限在该部门创建数据");
        }
        return Result.success(dataExcelService.save(dataExcel));
        BeanUtils.copyProperties(dataExcel,dataExcel1);
        return Result.success(dataExcelService.save(dataExcel1));
    }
    @PutMapping