怎么能达到查询所有分区的时候出现所有数据，查询空的时候也出现所有数据？

select
HR.lastname AS 姓名,
(SELECT    FST.COMPANYNAME
      FROM       dbo.FN_STORER_TREE() AS FST
      INNER JOIN
   (SELECT    ID, COMPANYNAME, F_ID
      FROM       dbo.FN_STORER_TREE() AS FN_STORER_TREE_1
      WHERE    (ID = HD.id)) AS A ON A.F_ID = FST.ID) AS 分区,
HD.departmentname AS 部门名称,
HL.locationname AS 工作地点,
HR.workroom As 办公室,
HR.telephone AS 电话,
HR.mobile 手机,
HR.mobilecall As 其它电话,
HR.email As 电子邮件,
HD.id AS 部门ID
from HrmResource HR
inner join HrmDepartment HD on HR.departmentid = HD.id
inner join HrmLocations HL on HL.id = HR.locationid
inner join dbo.FN_GET_STORER_TREE('${bumen}') FGS ON FGS.ID = HD.id
where
((1=1
${if(len(bumen) == 0,"","and HD.id  = '" + bumen + "'")} ${if(len(name) == 0,"","and HR.lastname = '" + name + "'")})
or
HR.lastname like '%${name}%' )
and
password <> ''
以上是我写的SQL和查询效果样本