From 00062ed2e07d3d705abd1baa10ee483617f10dfb Mon Sep 17 00:00:00 2001
From: ludc
Date: 星期五, 09 六月 2023 18:44:57 +0800
Subject: [PATCH] 提交get请求中文编码问题,表名常量类,表别名枚举类

---
 Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/service/impl/CodeBasicSecServiceImpl.java |   31 ++++++++++++++++++-------------
 1 files changed, 18 insertions(+), 13 deletions(-)

diff --git a/Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/service/impl/CodeBasicSecServiceImpl.java b/Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/service/impl/CodeBasicSecServiceImpl.java
index 3247b19..e363a31 100644
--- a/Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/service/impl/CodeBasicSecServiceImpl.java
+++ b/Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/service/impl/CodeBasicSecServiceImpl.java
@@ -26,11 +26,13 @@
 import com.vci.ubcs.code.wrapper.CodeBasicSecWrapper;
 import com.vci.ubcs.omd.cache.EnumCache;
 import com.vci.ubcs.omd.enums.EnumEnum;
+import com.vci.ubcs.starter.enumpack.CodeTableNameEnum;
 import com.vci.ubcs.starter.exception.VciBaseException;
 import com.vci.ubcs.starter.revision.service.RevisionModelUtil;
 import com.vci.ubcs.starter.util.DefaultAttrAssimtUtil;
 import com.vci.ubcs.starter.util.UBCSCondition;
 import com.vci.ubcs.starter.util.UBCSSqlKeyword;
+import com.vci.ubcs.starter.web.enumpck.NewAppConstantEnum;
 import com.vci.ubcs.starter.web.enumpck.OsCodeFillTypeEnum;
 import com.vci.ubcs.starter.web.pagemodel.BladeQueryObject;
 import com.vci.ubcs.starter.web.pagemodel.KeyValue;
@@ -40,6 +42,7 @@
 import com.vci.ubcs.starter.web.util.WebUtil;
 import com.vci.ubcs.system.entity.DictBiz;
 import com.vci.ubcs.system.feign.IDictBizClient;
+import org.springblade.core.log.exception.ServiceException;
 import org.springblade.core.mp.support.Query;
 import org.springblade.core.secure.utils.AuthUtil;
 import org.springblade.core.tool.api.R;
@@ -120,15 +123,17 @@
 	 * @throws VciBaseException 鏌ヨ鏉′欢鍜屽垎椤靛嚭閿欑殑鏃跺�欎細鎶涘嚭寮傚父
 	 */
 	@Override
-	public IPage<CodeBasicSecVO> gridCodeBasicSec(Query query, Map<String,Object> conditionMap) throws VciBaseException {
-		if(Func.isEmpty(conditionMap.get("pkCodeRule")) && Func.isEmpty(conditionMap.get("t.pkCodeRule_equal")) ){
+	public IPage<CodeBasicSecVO> gridCodeBasicSec(Query query, Map<String,Object> conditionMap) throws ServiceException {
+		if(Func.isEmpty(Func.isEmpty(conditionMap.get(CodeTableNameEnum.PL_CODE_BASICSEC.getText()+".pkCodeRule")))){
 			return null;
 		}
-		// 鑱旇〃鏌ヨ
-		MPJLambdaWrapper<CodeBasicSec> mpjLambdaWrapper = UBCSCondition.getMPJLambdaWrapper(conditionMap, CodeBasicSec.class)
+		// 鑱旇〃鏌ヨ ,璁剧疆琛ㄥ埆鍚嶏紝琛ㄥ埆鍚嶉粯璁ゅ氨閲囩敤琛ㄥ悕灏忓啓锛岄厤缃珮绾ф煡璇㈢殑鏃跺�欏氨闇�瑕佹牴鎹繖涓潵瀵箇here鏉′欢杩涜閰嶇疆
+		MPJLambdaWrapper<CodeBasicSec> mpjLambdaWrapper = new MPJLambdaWrapper<>(CodeBasicSec.class, CodeTableNameEnum.PL_CODE_BASICSEC.getText())
 			.selectAll(CodeBasicSec.class)
 			.selectAs(CodeClassify::getName, CodeBasicSec::getReferCodeClassifyOidName)
-			.leftJoin(CodeClassify.class, CodeClassify::getOid, CodeBasicSec::getReferCodeClassifyOid);
+			.leftJoin(CodeClassify.class,CodeTableNameEnum.PL_CODE_CLASSIFY.getText(), CodeClassify::getOid, CodeBasicSec::getReferCodeClassifyOid);
+		// 娣诲姞where鏉′欢
+		UBCSSqlKeyword.buildCondition(conditionMap,mpjLambdaWrapper);
 		IPage<CodeBasicSec> codeBasicSecIPage = codeBasicSecMapper.selectPage(UBCSCondition.getPage(query), mpjLambdaWrapper);
 		return CodeBasicSecWrapper.build().pageVO(codeBasicSecIPage);
 	}
@@ -140,7 +145,7 @@
 	 */
 	@Override
 	@Transactional(rollbackFor = Exception.class)
-	public boolean batchDeleteSecByCodeRuleOid(String codeRuleOid) {
+	public boolean batchDeleteSecByCodeRuleOid(String codeRuleOid) throws ServiceException {
 		VciBaseUtil.alertNotNull(codeRuleOid,"缂栫爜瑙勫垯涓婚敭");
 		// 1銆侀�氳繃pkcoderule浣滀负鏉′欢锛屽厛鏌ヨ瑕佸垹闄ゅ熀纭�鐮佹
 		List<CodeBasicSec> deleteList = this.codeBasicSecMapper.selectList(Wrappers.<CodeBasicSec>query().eq("pkcoderule", codeRuleOid));
@@ -183,7 +188,7 @@
 	 * @return 鏈夌┖鐨勫垯浼爇ey-灞炴�у悕 value-瀛楁鍚箟锛屾病鏈夌┖鐨勫垯浼� key-success value-true
 	 */
 	@Override
-	public KeyValue checkAttrNullableBySecType(CodeBasicSecDTO codeBasicSecDTO) {
+	public KeyValue checkAttrNullableBySecType(CodeBasicSecDTO codeBasicSecDTO) throws ServiceException {
 		VciBaseUtil.alertNotNull(codeBasicSecDTO.getSecType(), "鐮佹鍒嗙被");
 		String secType = codeBasicSecDTO.getSecType();
 		HashMap<String, String> attrMap = JSONObject.parseObject(JSONObject.toJSONString(codeBasicSecDTO), HashMap.class);
@@ -346,7 +351,7 @@
 	 * @param secType 鐮佹绫诲瀷
 	 * @return 涓嶅彲涓虹┖鐨勫瓧娈甸泦鍚�
 	 */
-	private Map<String, String> getNotNullableAttr(String secType) {
+	private Map<String, String> getNotNullableAttr(String secType) throws ServiceException {
 		Map<String, String> attrMap = new HashMap<>();
 		if (CodeSecTypeEnum.CODE_ATTR_SEC.getValue().equalsIgnoreCase(secType)) {
 			attrMap.put("name", "灞炴�х爜娈靛悕绉�");
@@ -496,7 +501,7 @@
 	 */
 	@Override
 	@Transactional(rollbackFor = Exception.class)
-	public R cloneCodeBasicSec(List<String> oidList, String pkCodeRule) {
+	public R cloneCodeBasicSec(List<String> oidList, String pkCodeRule) throws ServiceException {
 		boolean isLinked = checkIsLinked(pkCodeRule,null);
 		if (isLinked) {
 			return R.fail("缂栫爜瑙勫垯宸茶寮曠敤锛屼笉鍏佽缂栬緫鎴栧垹闄�");
@@ -560,7 +565,7 @@
 	 */
 	@Override
 	@Transactional(rollbackFor = Exception.class)
-	public boolean upOrderNum(String oid) {
+	public boolean upOrderNum(String oid) throws ServiceException{
 		CodeBasicSec secDO = selectByOid(oid);
 		if(secDO.getOrderNum() > 1){
 			//绛変簬1鐨勬椂鍊欎笉鑳戒笂绉讳簡
@@ -591,7 +596,7 @@
 	 */
 	@Override
 	@Transactional(rollbackFor = Exception.class)
-	public boolean downOrderNum(String oid) {
+	public boolean downOrderNum(String oid) throws ServiceException {
 		CodeBasicSec secDO = selectByOid(oid);
 		Long total = codeBasicSecMapper.selectCount(Wrappers.<CodeBasicSec>query()
 			.lambda().eq(CodeBasicSec::getPkCodeRule,secDO.getPkCodeRule())
@@ -623,7 +628,7 @@
 	 * @return
 	 */
 	@Override
-	public List<String> getOidByCodeclassifysecOid(String codeClassifySecOid) {
+	public List<String> getOidByCodeclassifysecOid(String codeClassifySecOid)throws ServiceException {
 		return codeBasicSecMapper.getOidByCodeclassifysecOid(codeClassifySecOid.trim());
 	}
 
@@ -703,7 +708,7 @@
 	 * @return 鐮佹鐨勫唴瀹�
 	 */
 	@Override
-	public List<CodeBasicSecVO> listCodeBasicSecByRuleOid(String ruleOid) {
+	public List<CodeBasicSecVO> listCodeBasicSecByRuleOid(String ruleOid)throws ServiceException {
 		if(StringUtils.isBlank(ruleOid)){
 			return new ArrayList<>();
 		}

--
Gitblit v1.9.3