招標採購
目前並無相關資料!! select t.*,c.[title] [classifyName],d.[title] [deptmentName]
from tcNews t
left join [sysClassify] c on c.[classifyID]=t.[classifyID]
left join [sysDepartment] d on d.[departmentID]=t.[departmentID]
where t.menuID=@menuID and t.tcNewsID=@tcNewsID and t.secureChk=@secureChk
and t.beEnable=1 and t.statusID='P' and datediff(day,isnull(t.[sDate],getdate()),getdate())>=0 and datediff(day,isnull(t.[eDate],getdate()),getdate())<=0
