我做的一个条件查询,可是一触发查询条件就报着个错,以下是我写的代码:
        private void Parse(AgentInfoSearchWhere search, ref string cmdText, ref List<SqlParameter> cmdParams)
        {
            if (!string.IsNullOrEmpty(search.AgentID))
            {
                cmdText += " and AgentID like '%'+@agentID+'%'";
                cmdParams.Add(dbUtil.BuildInParameter("@agentID", search.AgentID));
            }
            if (!string.IsNullOrEmpty(search.AgentName))
            {
                cmdText += " and AgentName like '%'+@agentName+'%'";
                cmdParams.Add(dbUtil.BuildInParameter("@agentName", search.AgentName));
            }
            if (search.RegionId.HasValue)
            {
                if (string.IsNullOrEmpty(search.UserCode))
                {
                    cmdText += " and (RegionId=@region or IsHQ=1)";
                    cmdParams.Add(dbUtil.BuildInParameter("@region", search.RegionId));
                }
                else
                {
                    cmdText += " and RegionId=@region";
                    cmdParams.Add(dbUtil.BuildInParameter("@region", search.RegionId));
                }
            }
            if (search.ManageRegionID.HasValue)
            {
                if (string.IsNullOrEmpty(search.UserCode))
                {
                    cmdText += " and (ManageRegionID=@regionCompany or IsHQ=1)";
                    cmdParams.Add(dbUtil.BuildInParameter("@regionCompany", search.ManageRegionID));
                }
                else
                {
                    cmdText += " and ManageRegionID=@regionCompany";
                    cmdParams.Add(dbUtil.BuildInParameter("@regionCompany", search.ManageRegionID));
                }
            }
            else if (!string.IsNullOrEmpty(search.UserCode))
            {
                cmdText += " and (ManageRegionID is null or ManageRegionID in (select ManageRegionID from UserManageRegion where UserCode=@userCode1))";
                cmdParams.Add(dbUtil.BuildInParameter("@userCode1", search.UserCode));
            }
        }
麻烦大家帮忙看看有什么错误啊?