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