维护常用脚本

案件优选成功失败查询——查询案件信息

/****** Script for SelectTopNRows command from SSMS ******/
SELECT *
FROM [Ldt_JudgeDoc].[dbo].[CS_Case] where casecode =N'(2020)鲁民初20200609号'
/****** Script for SelectTopNRows command from SSMS ******/
SELECT *
FROM [Ldt_JudgeDoc].[dbo].[CS_CaseManage] where CM_casecode =N'(2020)鲁民初20200609号'
/****** Script for SelectTopNRows command from SSMS ******/
SELECT *
FROM [Ldt_JudgeSource].[dbo].[CS_Case] where casecode =N'(2020)鲁民初20200609号'

案由信息查询

select * From [Ldt_JudgeSource].[dbo].CS_CaseCauseRelation r
                 where r.CaseID = 'CS2006181410520001'
select * From [Ldt_JudgeDoc].[dbo].CS_CaseCauseRelation r
                 where r.CaseID = 'CS2006181410520001'

CMS案件优选成功失败查询——查询案件信息
  SELECT *
 FROM [Ldt_JudgeDoc].[dbo].[CS_Case] c ,  [Ldt_JudgeDoc].[dbo].CS_CaseManage cm
  where c.caseid = cm.caseid  and cm.cm_caseState= '1' and cm.CM_CaseSource = N'审判平台' order by 1 desc

到庭情况信息查询

 select * from [Ldt_JudgeDoc].[dbo].CS_OpenCourt where CaseID = 'CS2006111641500001'
 
 select * from [Ldt_JudgeSource].[dbo].CS_OpenCourt where CaseID = 'CS2006111641500001'

诉讼参与人信息查询
 
 select * From [Ldt_JudgeDoc].[dbo].CS_SuitParticipant where CaseID = 'CS2006111558380001'
 
select * From [Ldt_JudgeSource].[dbo].CS_SuitParticipant where CaseID = 'CS2006111558380001'

获取授权法院信息

  SELECT t2.CourtID,t2.CH_Name,t2.CH_ShortName,t2.CH_Code,t2.CH_RepresentativeWord,t2.CH_StandardCode
                                        FROM Ldt_JudgeDocSystem.dbo.SYS_Org_Court t1
                                        LEFT JOIN Ldt_JudgeDocSystem.dbo.SYS_Court t2
                                         ON t1.OC_ID = t2.CourtID 

 

查询笔录纲要内容

 

select * From [Ldt_JudgeDoc].[dbo].cs_installoutline where CaseID = 'CS2006160113510001'

select * From [Ldt_JudgeDoc].dbo.CS_Multiple_InstallOutline where CaseID = 'CS2006160113510001'