zjh20250226

zjh

2025-02-26 07e99128114a015c11fe21858f21f00306216472

 ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java

@@ -44,13 +44,10 @@
public class TjSqlController extends BaseController {
    @Resource
    private TestMapper testMapper;

    @Resource
    private TjvLtkjvtjpatService tjvLtkjvtjpatService;

    @Resource
    private LtkjMiddleDetailService middleDetailService;

    @Resource
    private LtkjMiddleHeadService headService;
    @Resource
@@ -61,16 +58,8 @@
    private LtkjHybgdService ltkjHybgdService;
    @Resource
    private LtkjHysqdService ltkjHysqdService;
    @Autowired
    public RedisTemplate<Object,Object> redisTemplate;
    @Resource
    private ITjCustomerService tjCustomerService;
    @Resource
    private RedisCache redisCache;
    @Resource
    private TjAsyncService asyncService;
    @Resource
    private ITjOrderRemarkService remarkService;
    @Resource
    private ITjOrderService orderService;
    @Resource
@@ -83,16 +72,22 @@
    private ITjOrderDetailService tjOrderDetailService;
    @Resource
    private ITjOrderRemarkService tjOrderRemarkService;
    @Resource
    private ITjProjectService projectService;


    @GetMapping("/getTjHyBgList")
    @ApiOperation(value = "查询lis数据库项目信息接口")
    public AjaxResult getTjHyBgList(@RequestParam(required = false)String pacCode,
                                    @RequestParam(required = false)String pacName,
                                    @RequestParam(required = false)String pacRemark) {
        List<Map<String, Object>> maps = testMapper.getTjHyBgList(pacCode,pacName,pacRemark);
        DynamicDataSourceContextHolder.clearDataSourceType();
        return AjaxResult.success(maps);
    public AjaxResult getTjHyBgList(@RequestParam(defaultValue = "1")Integer page,
                                    @RequestParam(defaultValue = "10")Integer pageSize,
                                    @RequestParam(required = false)String pname,
                                    @RequestParam(required = false)String pid,
                                    @RequestParam(required = false)String pym,
                                    @RequestParam(required = false)String checktype) {
//        List<Map<String, Object>> maps = testMapper.getTjHyBgList(pacCode,pacName,pacRemark);
//        DynamicDataSourceContextHolder.clearDataSourceType();
        Map<String,Object> map=  projectService.getTjHyBgList(page,pageSize,pname,pid,pym,checktype);
        return AjaxResult.success(map);
    }


@@ -459,4 +454,13 @@
    }


    @GetMapping("/getWsxmLtkjHysqdByLisViBySLAVEWS")
    @ApiOperation(value = "查询外送项目SqlServer接口")
    public AjaxResult getWsxmLtkjHysqdByLisViBySLAVEWS(@RequestParam String s) {
//        List<LtkjHybgd> wsbg = testMapper.getWsxmLtkjHybgdByLisViBySLAVEWS(s);
//        log.info(wsbg.toString());
        return AjaxResult.success(testMapper.getWsxmLtkjHysqdByLisViBySLAVEWS(s));
    }


}