根据下拉列表的内容查询数据库有几条数据

Question

public void QueryAnalyseAddressInfo(string ddlCaseType, string ddlTypeID1, string ddlTypeID2,
string ddlDepartmentID1, string ddlDepartmentID2, string ddlDepartmentID3)
{
string strSql = "select count(*) from tbData_AddressAnalyzeInfo where AddAnaInfo_bit_IsDeleted=0";

        #region 参数
        if (!String.IsNullOrEmpty(ddlCaseType) && !ddlCaseType.Equals("0"))//业务类别
        {
            strSql += " and AddAnaInfo_int_WorkTicketTypeID = ";
        }
        if (!String.IsNullOrEmpty(ddlTypeID1) && !ddlTypeID1.Equals("0"))//业务大类
        {
            strSql += " and AddAnaInfo_int_TypeID1 = ";
        }
        if (!String.IsNullOrEmpty(ddlTypeID2) && !ddlTypeID2.Equals("0"))//业务小类
        {
            strSql += " and AddAnaInfo_int_TypeID2 = ";
        }
        if (!String.IsNullOrEmpty(ddlDepartmentID1) && !ddlDepartmentID1.Equals("0"))//流向部门一
        {
            strSql += " and AddAnaInfo_int_DepartmentID1 = ";
        }
        if (!String.IsNullOrEmpty(ddlDepartmentID2) && !ddlDepartmentID2.Equals("0"))//流向部门二
        {
            strSql += " and AddAnaInfo_int_DepartmentID2 = ";
        }
        if (!String.IsNullOrEmpty(ddlDepartmentID3) && !ddlDepartmentID3.Equals("0"))//流向部门三
        {
            strSql += " and AddAnaInfo_int_DepartmentID3 = ";
        }

        #endregion
        lbShow.Text = strSql;
        var result = DBHelper.GetScalar(strSql);
        lbShow.Text = result.ToString();
    }
            protected void btnSearch_Click(object sender, EventArgs e)
    {
        QueryAnalyseAddressInfo(ddlCaseType.SelectedValue,
                            ddlTypeID1.SelectedValue,
                            ddlTypeID2.SelectedValue,
                            ddlDepartmentID1.SelectedValue,
                            ddlDepartmentID2.SelectedValue,
                            ddlDepartmentID3.SelectedValue);
            }

问下          strSql += " and AddAnaInfo_int_DepartmentID2 = ";的等号后面加什么，

Answer 1

加参数值啊，其他的也一样，要不选择了值就要报错了你没加上值

         if (!String.IsNullOrEmpty(ddlDepartmentID2) && !ddlDepartmentID2.Equals("0"))//流向部门二
        {
            strSql += " and AddAnaInfo_int_DepartmentID2 = "+ddlDepartmentID2;//如果是字符用下面的
            //strSql += " and AddAnaInfo_int_DepartmentID2 = '"+ddlDepartmentID2+"'";//
        }