我想在下面这个查询代码中，加入条件，想通过当前的菜单名称查相应的数据，为什么我把 where (cdmch=''' + edit1.text+ ''')这个条件加上去后，他报错。请问如何加
str:='declare @sql varchar(8000) set @sql = '' select distinct cklx,''';
str:=str+' select @sql = @sql + ''sum(case zdmchy when ''''''+zdmchy+'''''' then shfxsh else 0 end ) as ''''''+zdmchy+'''''',''from (select distinct zdmchy from htcyerp01'+curgsbh+'..SY_btxshsz ) as a' ;
str:=str+' select @sql = left(@sql,len(@sql)-1)+ '' from htcyerp01'+curgsbh+'..SY_btxshsz group by cklx '' exec(@sql)';