我做的一个条件查询,可是一触发查询条件就报着个错,以下是我写的代码:
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));
}
}
麻烦大家帮忙看看有什么错误啊?
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));
}
}
麻烦大家帮忙看看有什么错误啊?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货