带条件的Insert语句

<insert id="addHouseLocation" parameterType="HouseLocation">

   IF
   NOT EXISTS (
SELECT
*
FROM
HouseLocation
WHERE
CONVERT (VARCHAR(10), ParentID) + '-' + CONVERT (VARCHAR(10), Row) + '-' + CONVERT (VARCHAR(10), Col) + '-' + CONVERT (VARCHAR(10), Layer) = CONVERT (
VARCHAR (10) ,#{parentid }
) + '-' + CONVERT (VARCHAR(10) ,#{ row }) + '-' + CONVERT (VARCHAR(10) ,#{ col }) + '-' + CONVERT (VARCHAR(10) ,#{ layer })
)
INSERT INTO HouseLocation(
Name,
Pinyin,
ParentID,
Memo,
AddUser,
AddDate,
EditUser,
EditDate,
IPAddress,
IsEnable,
Row,
Col,
Layer,
FullPath,
AllOrPart
)VALUES(

#{name},
#{pinyin},
#{parentid},
#{memo},
#{adduser},
#{adddate},
#{edituser},
#{editdate},
#{ipaddress},
#{isenable},
#{row},
#{col},
#{layer},
#{fullpath},
#{allorpart}



)
</insert>