我想构建一个查询语句，哪儿错了，VS2008 VC++ MFC ？

CString strSql = (_bstr_t)"select * from Product where 1=1";
if(str_ProName)
{
这里应该有空格 没有的话就是1and
strSql =strSql + (_bstr_t)(" and proName = ")+(_bstr_t)str_ProName;
}
if(str_ProZhi)
{
这里也应该有空格 and前 下边的也一样
strSql =strSql + (_bstr_t)(" and proZhi = ")+(_bstr_t)str_ProZhi;
}
if(str_FengZhuang)
{
strSql =strSql + (_bstr_t)(" and proFengZhuang = ")+(_bstr_t)str_FengZhuang;
}