SELECT d.DicName , --DevelopMode
ISNULL(NULL,NULL) , --Orgid
b.FullName , --Areid
c.DicName , --InvestProperty
f.DicName , --TwoProperty
PJName ,
PJLength ,
PJWidth ,
UseArea ,
BuildArea ,
--IsSetUp as ,
CASE a.IsSetUp WHEN 0 THEN '否'when 1 THEN '是' END ,
--case when '' like '%'+[BasePositionID] then 1 else 2 end [BasePositionID] from SysPosition p
CASE a.IsMeragr WHEN 0 THEN '否'when 1 THEN '是' END ,
e.DicName
FROM TopProjectNew a
INNER JOIN dbo.SysOrganization b ON a.AreaID=b.id
INNER JOIN dbo.SysDictionary c ON a.InvestProperty =c.ID
INNER JOIN dbo.SysDictionary d ON a.DevelopMode=d.ID
INNER JOIN dbo.SysDictionary f ON a.TwoProperty=f.ID
INNER JOIN dbo.SysDictionary e ON a.PJDomain=e.ID
WHERE AreaID=''
'性别'=case Sex when 1 then '女' else '男' end
