TB_ClientList
SELECT TB_Area.Name AS AreaName,
TB_A_Service.Service as ServiceRoom,
TB_ClientList.* ,
TB_ModuleType.title as ModuleType,
TB_Templet.T_Name as Templet,
CASE WHEN TB_ClientList.StatusUpDateTime IS NULL THEN '未启用'
WHEN DATEDIFF(mi, TB_ClientList.StatusUpDateTime, GETDATE()) <= 122 THEN '正常' ELSE '不正常' END AS StatusName
FROM TB_ClientList
LEFT OUTER JOIN TB_Area ON TB_ClientList.AreaID = TB_Area.ID
LEFT OUTER JOIN TB_A_Service ON TB_A_Service.Id = TB_ClientList.A_ServiceId
left outer join TB_ModuleType on TB_ModuleType.ID = TB_ClientList.ModeTypeID
left outer join TB_Templet on TB_Templet.ID = templetID
where 0=0
SELECT
TB_Transact.* ,
--TB_Area.Name AS AreaName,
--TB_A_Service.Service as ServiceRoom,
TB_Module.Name as ModuleType
--TB_Templet.T_Name as Templet
FROM TB_Transact
--LEFT OUTER JOIN TB_Area ON TB_ClientList.AreaID = TB_Area.ID
--LEFT OUTER JOIN TB_A_Service ON TB_A_Service.Id = TB_ClientList.A_ServiceId
left outer join TB_Module on TB_Module.ID = TB_Transact.ModuleID
--left outer join TB_Templet on TB_Templet.ID = templetID
where 1=1
SELECT TB_Area.Name AS AreaName, TB_A_Service.Service as ServiceRoom,TB_ClientList.* ,TB_ModuleType.title as ModuleType,TB_Templet.T_Name as Templet
FROM TB_ClientList
LEFT OUTER JOIN TB_Area ON TB_ClientList.AreaID = TB_Area.ID
LEFT OUTER JOIN TB_A_Service ON TB_A_Service.Id = TB_ClientList.A_ServiceId
left outer join TB_ModuleType on TB_ModuleType.ID = TB_ClientList.ModeTypeID
left outer join TB_Templet on TB_Templet.ID = templetID
where 1=1
select a.*, case IsPass when 0 then '已审核' else '未审核' end as pass ,
b.name as areaname ,c.service, d.Title modulename
from TB_ServerFileList a
left join TB_Area b on a.area_id=b.id
left join TB_ModuleType d on a.ModeID=d.ID
left join TB_A_Service c on a.ServiceRoom_Id = c.id
where (IsPass = 1 or ispass is null)
