质证证据解决查询不到内容接问题查方式

接口：/huaxia/v1/GetEvidenceInfo

1、查找案件是否存在

SELECT * 

FROM [dbo].[CS_CaseManage]
where CM_CaseCode= '(2020)苏民初03560937号'

 

2、查询证据是否存在

exec Proc_GetCategoryList 'caseid','b1','法院id','jpg'

 

 

1、查找同义词库中是否存在关键词

select StandardName,SynonymAttr from
(SELECT CD_Name AS StandardName, CD_Name AS SynonymWord, '0' AS SynonymAttr
FROM Ldt_JudgeDocSystem.dbo.SYS_CaseType_DocType WHERE CD_DocType = 1
UNION
SELECT BDSynA AS StandardName, BDSynB AS SynonymWord, '1' AS SynonymAttr FROM LdtCommonManage..WL_BDSyn
WHERE BDSynA IN
(SELECT CD_Name FROM Ldt_JudgeDocSystem.dbo.SYS_CaseType_DocType WHERE CD_DocType = 1)
UNION
SELECT WW_RightText AS StandardName, WW_WrongText AS SynonymWord, '2' AS SynonymAttr
FROM LdtCommonManage..WL_WrongWord WHERE WW_UseScene = '1' ) as DocSynonymword
where SynonymWord='娃哈哈'