From 926dc4daf0ea8be960647ecaeec389e866037ef9 Mon Sep 17 00:00:00 2001
From: lige <bestlige@outlook.com>
Date: 星期一, 11 十二月 2023 18:39:09 +0800
Subject: [PATCH] sqlserver拿视图数据存储mysql表
---
ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjMiddleHeadService.java | 12 +
ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjTjPat.java | 28 ++++
ltkj-admin/src/test/java/lgTest.java | 6
ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjMiddleDetailImpl.java | 18 ++
ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjMiddleDetail.java | 22 +++
ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java | 102 ++++++++++++++
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjMiddleDetailMapper.java | 18 ++
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java | 36 ++++
ltkj-framework/src/main/java/com/ltkj/framework/config/SecurityConfig.java | 2
/dev/null | 14 --
ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjVbjitem.java | 20 ++
ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjMiddleDetailService.java | 12 +
ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjMiddleHeadImpl.java | 20 ++
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjMiddleHeadMapper.java | 17 ++
ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjvLtkjvtjpatServiceImpl.java | 21 +++
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjvLtkjvtjpatMapper.java | 18 ++
ltkj-hosp/src/main/java/com/ltkj/hosp/service/TjvLtkjvtjpatService.java | 13 +
ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjMiddleHead.java | 25 +++
18 files changed, 378 insertions(+), 26 deletions(-)
diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java
new file mode 100644
index 0000000..fe9db4e
--- /dev/null
+++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java
@@ -0,0 +1,102 @@
+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<LtkjMiddleDetail> list = testMapper.getMiddleDetail();
+ return AjaxResult.success(list);
+ }
+
+
+ @GetMapping("/getMiddleHead")
+ @ApiOperation(value = "鏌ョ湅鍒楄〃")
+ public AjaxResult getMiddleHead() {
+ List<LtkjMiddleHead> list = testMapper.getMiddleHead();
+ return AjaxResult.success(list);
+ }
+
+// @GetMapping("/getVbjitem")
+// @ApiOperation(value = "鏌ョ湅鍒楄〃")
+// public AjaxResult getVbjitem() {
+// List<LtkjVbjitem> list = testMapper.getVbjitem();
+// return AjaxResult.success(list);
+// }
+
+
+ @GetMapping("/getTjPat")
+ @ApiOperation(value = "鏌ョ湅鍒楄〃")
+ public AjaxResult getTjPat() {
+ List<LtkjTjPat> 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);
+ }
+
+}
diff --git a/ltkj-admin/src/test/java/lgTest.java b/ltkj-admin/src/test/java/lgTest.java
index 122334e..bd42a2d 100644
--- a/ltkj-admin/src/test/java/lgTest.java
+++ b/ltkj-admin/src/test/java/lgTest.java
@@ -1,5 +1,4 @@
import com.ltkj.LtkjApplication;
-import com.ltkj.hosp.domain.SqlTest;
import com.ltkj.hosp.mapper.TestMapper;
import lombok.extern.slf4j.Slf4j;
import org.junit.Test;
@@ -10,8 +9,6 @@
import org.springframework.test.context.junit4.SpringRunner;
import javax.annotation.Resource;
-import java.util.ArrayList;
-import java.util.List;
/**
* @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
@@ -28,8 +25,7 @@
private TestMapper testMapper;
@Test
public void lige() {
- final SqlTest list = testMapper.getList();
- System.out.println(list);
+
}
public static void main(String[] args) {
diff --git a/ltkj-framework/src/main/java/com/ltkj/framework/config/SecurityConfig.java b/ltkj-framework/src/main/java/com/ltkj/framework/config/SecurityConfig.java
index c673e97..71f8432 100644
--- a/ltkj-framework/src/main/java/com/ltkj/framework/config/SecurityConfig.java
+++ b/ltkj-framework/src/main/java/com/ltkj/framework/config/SecurityConfig.java
@@ -108,7 +108,7 @@
// 杩囨护璇锋眰
.authorizeRequests()
// 瀵逛簬鐧诲綍login 娉ㄥ唽register 楠岃瘉鐮乧aptchaImage 鍏佽鍖垮悕璁块棶
- .antMatchers("/login", "/register", "/captchaImage","/cus/**","/getCaptchaConfigKey","/report/jmreport/**").permitAll()
+ .antMatchers("/login", "/register", "/captchaImage","/cus/**","/getCaptchaConfigKey","/report/jmreport/**","/sqlserver/getdata/**").permitAll()
// 闈欐�佽祫婧愶紝鍙尶鍚嶈闂�
.antMatchers(HttpMethod.GET, "/", "/*.html", "/**/*.html", "/**/*.css", "/**/*.js", "/profile/**").permitAll()
.antMatchers("/swagger-ui.html", "/swagger-resources/**", "/webjars/**", "/*/api-docs", "/druid/**").permitAll()
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/domain/SqlTest.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/domain/SqlTest.java
deleted file mode 100644
index f923489..0000000
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/domain/SqlTest.java
+++ /dev/null
@@ -1,14 +0,0 @@
-package com.ltkj.hosp.domain;
-
-import lombok.Data;
-
-/**
- * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
- * @Author: lige
- * @Date: 2023/12/11 14:55
- */
-@Data
-public class SqlTest {
- private String id;
- private String address;
-}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjMiddleDetailMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjMiddleDetailMapper.java
new file mode 100644
index 0000000..d5eaf51
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjMiddleDetailMapper.java
@@ -0,0 +1,18 @@
+package com.ltkj.hosp.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ltkj.common.annotation.DataSource;
+import com.ltkj.common.enums.DataSourceType;
+import com.ltkj.hosp.sqlDomain.LtkjMiddleDetail;
+import com.ltkj.hosp.sqlDomain.LtkjTjPat;
+import org.apache.ibatis.annotations.Mapper;
+
+/**
+ * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
+ * @Author: lige
+ * @Date: 2023/12/11 17:56
+ */
+@Mapper
+@DataSource(value = DataSourceType.MASTER)
+public interface LtkjMiddleDetailMapper extends BaseMapper<LtkjMiddleDetail> {
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjMiddleHeadMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjMiddleHeadMapper.java
new file mode 100644
index 0000000..b4f5bed
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjMiddleHeadMapper.java
@@ -0,0 +1,17 @@
+package com.ltkj.hosp.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ltkj.common.annotation.DataSource;
+import com.ltkj.common.enums.DataSourceType;
+import com.ltkj.hosp.sqlDomain.LtkjMiddleHead;
+import org.apache.ibatis.annotations.Mapper;
+
+/**
+ * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
+ * @Author: lige
+ * @Date: 2023/12/11 17:56
+ */
+@Mapper
+@DataSource(value = DataSourceType.MASTER)
+public interface LtkjMiddleHeadMapper extends BaseMapper<LtkjMiddleHead> {
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java
index d19e750..6c255ef 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java
@@ -3,10 +3,14 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.common.annotation.DataSource;
import com.ltkj.common.enums.DataSourceType;
-import com.ltkj.hosp.domain.SqlTest;
-import com.ltkj.hosp.domain.TjAdvice;
+import com.ltkj.hosp.sqlDomain.LtkjMiddleDetail;
+import com.ltkj.hosp.sqlDomain.LtkjMiddleHead;
+import com.ltkj.hosp.sqlDomain.LtkjTjPat;
import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
+
+import java.util.List;
/**
* @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
@@ -14,8 +18,28 @@
* @Date: 2023/12/11 14:51
*/
@Mapper
-public interface TestMapper extends BaseMapper<SqlTest> {
- @DataSource(value = DataSourceType.SLAVE)
- @Select("select * from City where id=1")
- public SqlTest getList();
+@DataSource(value = DataSourceType.SLAVE)
+public interface TestMapper{
+
+ @Select("SELECT * FROM tjv_Ltkj_middle_detail")
+ public List<LtkjMiddleDetail> getMiddleDetail();
+
+ @Select("SELECT * FROM tjv_Ltkj_middle_head")
+ public List<LtkjMiddleHead> getMiddleHead();
+
+// @Select("SELECT * FROM tjv_LTKJVBJITEM")
+// public List<LtkjVbjitem> getVbjitem();
+
+ @Select("SELECT * FROM tjv_LTKJVTJPAT")
+ public List<LtkjTjPat> getTjPat();
+
+
+ @Select("SELECT * FROM tjv_LTKJVTJPAT where pat_id=#{id}")
+ public LtkjTjPat getTjPatById(String id);
+
+ @Select("SELECT * FROM tjv_Ltkj_middle_detail where fdetall_id=#{id}")
+ public LtkjMiddleDetail getMiddleDetailById(String id);
+
+ @Select("SELECT * FROM tjv_Ltkj_middle_head where fead_id=#{id}")
+ public LtkjMiddleHead getMiddleHeadById(String id);
}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjvLtkjvtjpatMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjvLtkjvtjpatMapper.java
new file mode 100644
index 0000000..436316b
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjvLtkjvtjpatMapper.java
@@ -0,0 +1,18 @@
+package com.ltkj.hosp.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ltkj.common.annotation.DataSource;
+import com.ltkj.common.enums.DataSourceType;
+import com.ltkj.hosp.domain.TjTollCollector;
+import com.ltkj.hosp.sqlDomain.LtkjTjPat;
+import org.apache.ibatis.annotations.Mapper;
+
+/**
+ * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
+ * @Author: lige
+ * @Date: 2023/12/11 17:56
+ */
+@Mapper
+@DataSource(value = DataSourceType.MASTER)
+public interface TjvLtkjvtjpatMapper extends BaseMapper<LtkjTjPat> {
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjMiddleDetailService.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjMiddleDetailService.java
new file mode 100644
index 0000000..f59972a
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjMiddleDetailService.java
@@ -0,0 +1,12 @@
+package com.ltkj.hosp.service;
+
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ltkj.hosp.sqlDomain.LtkjMiddleDetail;
+
+/**
+ * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
+ * @Author: lige
+ * @Date: 2023/12/11 17:57
+ */
+public interface LtkjMiddleDetailService extends IService<LtkjMiddleDetail> {
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjMiddleHeadService.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjMiddleHeadService.java
new file mode 100644
index 0000000..75eddc2
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjMiddleHeadService.java
@@ -0,0 +1,12 @@
+package com.ltkj.hosp.service;
+
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ltkj.hosp.sqlDomain.LtkjMiddleHead;
+
+/**
+ * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
+ * @Author: lige
+ * @Date: 2023/12/11 17:57
+ */
+public interface LtkjMiddleHeadService extends IService<LtkjMiddleHead> {
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/TjvLtkjvtjpatService.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/TjvLtkjvtjpatService.java
new file mode 100644
index 0000000..3e379f1
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/TjvLtkjvtjpatService.java
@@ -0,0 +1,13 @@
+package com.ltkj.hosp.service;
+
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ltkj.hosp.domain.TjReport;
+import com.ltkj.hosp.sqlDomain.LtkjTjPat;
+
+/**
+ * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
+ * @Author: lige
+ * @Date: 2023/12/11 17:57
+ */
+public interface TjvLtkjvtjpatService extends IService<LtkjTjPat> {
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjMiddleDetailImpl.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjMiddleDetailImpl.java
new file mode 100644
index 0000000..3c7a53f
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjMiddleDetailImpl.java
@@ -0,0 +1,18 @@
+package com.ltkj.hosp.service.impl;
+
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ltkj.hosp.mapper.LtkjMiddleDetailMapper;
+import com.ltkj.hosp.service.LtkjMiddleDetailService;
+import com.ltkj.hosp.sqlDomain.LtkjMiddleDetail;
+import org.springframework.stereotype.Service;
+
+/**
+ * 鐥呯+鎰忚Service涓氬姟灞傚鐞�
+ *
+ * @author ltkj_璧典匠璞�&鏉庢牸
+ * @date 2023-08-30
+ */
+@Service
+public class LtkjMiddleDetailImpl extends ServiceImpl<LtkjMiddleDetailMapper, LtkjMiddleDetail> implements LtkjMiddleDetailService {
+
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjMiddleHeadImpl.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjMiddleHeadImpl.java
new file mode 100644
index 0000000..70ca832
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjMiddleHeadImpl.java
@@ -0,0 +1,20 @@
+package com.ltkj.hosp.service.impl;
+
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ltkj.hosp.mapper.LtkjMiddleDetailMapper;
+import com.ltkj.hosp.mapper.LtkjMiddleHeadMapper;
+import com.ltkj.hosp.service.LtkjMiddleDetailService;
+import com.ltkj.hosp.service.LtkjMiddleHeadService;
+import com.ltkj.hosp.sqlDomain.LtkjMiddleHead;
+import org.springframework.stereotype.Service;
+
+/**
+ * 鐥呯+鎰忚Service涓氬姟灞傚鐞�
+ *
+ * @author ltkj_璧典匠璞�&鏉庢牸
+ * @date 2023-08-30
+ */
+@Service
+public class LtkjMiddleHeadImpl extends ServiceImpl<LtkjMiddleHeadMapper, LtkjMiddleHead> implements LtkjMiddleHeadService {
+
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjvLtkjvtjpatServiceImpl.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjvLtkjvtjpatServiceImpl.java
new file mode 100644
index 0000000..e447e22
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjvLtkjvtjpatServiceImpl.java
@@ -0,0 +1,21 @@
+package com.ltkj.hosp.service.impl;
+
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ltkj.hosp.domain.TjRuleAdvice;
+import com.ltkj.hosp.mapper.TjRuleAdviceMapper;
+import com.ltkj.hosp.mapper.TjvLtkjvtjpatMapper;
+import com.ltkj.hosp.service.ITjRuleAdviceService;
+import com.ltkj.hosp.service.TjvLtkjvtjpatService;
+import com.ltkj.hosp.sqlDomain.LtkjTjPat;
+import org.springframework.stereotype.Service;
+
+/**
+ * 鐥呯+鎰忚Service涓氬姟灞傚鐞�
+ *
+ * @author ltkj_璧典匠璞�&鏉庢牸
+ * @date 2023-08-30
+ */
+@Service
+public class TjvLtkjvtjpatServiceImpl extends ServiceImpl<TjvLtkjvtjpatMapper, LtkjTjPat> implements TjvLtkjvtjpatService {
+
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjMiddleDetail.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjMiddleDetail.java
new file mode 100644
index 0000000..645a101
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjMiddleDetail.java
@@ -0,0 +1,22 @@
+package com.ltkj.hosp.sqlDomain;
+
+import lombok.Data;
+
+/**
+ * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
+ * @Author: lige
+ * @Date: 2023/12/11 16:37
+ */
+@Data
+public class LtkjMiddleDetail {
+ private String fdetallId;
+ private String fheadId;
+ private String chgItemid;
+ private String chgItemname;
+ private String itemId;
+ private String rprice;
+ private String quantity;
+ private String sumTotal;
+ private String discount;
+ private String checkexamId;
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjMiddleHead.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjMiddleHead.java
new file mode 100644
index 0000000..e4fb767
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjMiddleHead.java
@@ -0,0 +1,25 @@
+package com.ltkj.hosp.sqlDomain;
+
+import lombok.Data;
+
+/**
+ * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
+ * @Author: lige
+ * @Date: 2023/12/11 17:13
+ */
+@Data
+public class LtkjMiddleHead {
+ private String feadId;
+ private String patBarCode;
+ private String patId;
+ private String isChg;
+ private String chgnoteId;
+ private String invoiceId;
+ private String chgDate;
+ private String cancelApp;
+ private String cancelAppDate;
+ private String isCanceled;
+ private String canceledDate;
+ private String insertTime;
+
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjTjPat.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjTjPat.java
new file mode 100644
index 0000000..df82a63
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjTjPat.java
@@ -0,0 +1,28 @@
+package com.ltkj.hosp.sqlDomain;
+
+import lombok.Data;
+
+/**
+ * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
+ * @Author: lige
+ * @Date: 2023/12/11 17:20
+ */
+@Data
+public class LtkjTjPat {
+ private String patId;
+ private String patName;
+ private String patsexId;
+ private String patbDate;
+ private String addressHeng;
+ private String addressHi;
+ private String addresXianq;
+ private String addresXiangz;
+ private String addressHeqc;
+ private String addresXiangx;
+ private String fullAddress;
+ private String fixPhone;
+ private String mobile;
+ private String postBox;
+ private String fcardId;
+ private String fcardNo;
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjVbjitem.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjVbjitem.java
new file mode 100644
index 0000000..ccdfa86
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjVbjitem.java
@@ -0,0 +1,20 @@
+package com.ltkj.hosp.sqlDomain;
+
+import lombok.Data;
+
+/**
+ * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃
+ * @Author: lige
+ * @Date: 2023/12/11 17:18
+ */
+@Data
+public class LtkjVbjitem {
+ private String itemId;
+ private String itemCnname;
+ private String rprice;
+ private String pkgUnit;
+ private String pkgName;
+ private String pkgId;
+ private String pkgDept;
+ private String pkgDeptid;
+}
--
Gitblit v1.8.0