得到多个纬度

public DataSet GetCategoryZNames(string CategoryItem)
        {
            DataSet dt = null;
            string sqlStr = "select * from SYS_Category where 1=1 and ";
            string[] strarr = CategoryItem.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
            foreach (string CategoryID in strarr)
            {
                if (CategoryID != "")
                {
                    sqlStr += " CategoryID=" + CategoryID.FilterSql() + " or";
                }

            }
            // string sqlStr = string.Format("select * from SYS_Category where CategoryID='" + CategoryID + "'");
            sqlStr = sqlStr.Remove(sqlStr.Length - 2, 2);

            try
            {
                dt = DbHelperSQL.Query(sqlStr.ToString());
            }
            catch { }

            return dt;
        }