package com.ltkj.web.controller.sqlserver; import com.ltkj.common.core.controller.BaseController; import com.ltkj.common.core.domain.AjaxResult; import com.ltkj.common.enums.DataSourceType; import com.ltkj.framework.datasource.DynamicDataSourceContextHolder; import com.ltkj.hosp.service.LtkjMiddleDetailService; import com.ltkj.hosp.service.LtkjMiddleHeadService; import com.ltkj.hosp.service.TjvLtkjvtjpatService; import com.ltkj.hosp.sqlDomain.LtkjMiddleDetail; import com.ltkj.hosp.sqlDomain.LtkjMiddleHead; import com.ltkj.hosp.sqlDomain.LtkjTjPat; import com.ltkj.hosp.mapper.TestMapper; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; import java.util.List; @RestController @RequestMapping("/sqlserver/getdata") @Api(tags = "获取从库数据") public class TjSqlController extends BaseController { @Resource private TestMapper testMapper; @Resource private TjvLtkjvtjpatService tjvLtkjvtjpatService; @Resource private LtkjMiddleDetailService middleDetailService; @Resource private LtkjMiddleHeadService headService; @GetMapping("/getMiddleDetail") @ApiOperation(value = "查看列表") public AjaxResult getMiddleDetail() { List list = testMapper.getMiddleDetail(); return AjaxResult.success(list); } @GetMapping("/getMiddleHead") @ApiOperation(value = "查看列表") public AjaxResult getMiddleHead() { List list = testMapper.getMiddleHead(); return AjaxResult.success(list); } // @GetMapping("/getVbjitem") // @ApiOperation(value = "查看列表") // public AjaxResult getVbjitem() { // List list = testMapper.getVbjitem(); // return AjaxResult.success(list); // } @GetMapping("/getTjPat") @ApiOperation(value = "查看列表") public AjaxResult getTjPat() { List list = testMapper.getTjPat(); return AjaxResult.success(list); } @GetMapping("/getLtkjTjPatById") @ApiOperation(value = "根据id查,存进mysql") public AjaxResult getLtkjTjPatById(String id) { LtkjTjPat one = testMapper.getTjPatById(id); DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name()); final boolean save = tjvLtkjvtjpatService.save(one); DynamicDataSourceContextHolder.clearDataSourceType(); return AjaxResult.success(save); } @GetMapping("/getMiddleDetailById") @ApiOperation(value = "根据id查,存进mysql") public AjaxResult getMiddleDetailById(String id) { LtkjMiddleDetail one = testMapper.getMiddleDetailById(id); DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name()); final boolean save = middleDetailService.save(one); DynamicDataSourceContextHolder.clearDataSourceType(); return AjaxResult.success(save); } @GetMapping("/getMiddleHeadById") @ApiOperation(value = "根据id查,存进mysql") public AjaxResult getMiddleHeadById(String id) { LtkjMiddleHead one = testMapper.getMiddleHeadById(id); DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name()); final boolean save = headService.save(one); DynamicDataSourceContextHolder.clearDataSourceType(); return AjaxResult.success(save); } }