求个C#的正则表达式

[anzhiqiang_touzi]

select count(0) from Ship where 1=1
and SCode=@SCode
and OCode=@OCode
and (SCode=@SCode OR SCode=@SCode)
and SCode=@SCode
or SCode like '%'+@SCode+'%'

其中已知:and ?=@SCode 或or ?=@SCode

目的删除SQL语句的条件=号前面是未知的

要C#的正则表达式

[人生难得一只鸡]

没看明白.

[EnForGrass]

模糊
是要这个效果吗？

string sql=@"select count(0) from Ship where 1=1   
and SCode=@SCode
and OCode=@OCode
and (SCode=@SCode OR SCode=@SCode)
and SCode=@SCode  
and ?=@SCode or ?=@SCode
or SCode like '%'+@SCode+'%'";
sql=Regex.Replace(sql,@"(?i)(and \?=@SCode)|(or \?=@SCode)",""); 
/*
select count(0) from Ship where 1=1   
and SCode=@SCode
and OCode=@OCode
and (SCode=@SCode OR SCode=@SCode)
and SCode=@SCode  
or SCode like '%'+@SCode+'%'
*/

[anzhiqiang_touzi]

我想知道你们的怎么写出来的

[anzhiqiang_touzi]

没对啊

[人生难得一只鸡]

string pattern = @"(and|or)\s*\?=@SCode";

[EnForGrass]

(?i)(and\s*\?=@SCode)|(or\s*\?=@SCode)试试，
你最好给个例子，说你要的结果

[anzhiqiang_touzi]

string sql=@"select count(0) from Ship where 1=1
and SCode=@SCode
and OCode=@OCode
and (SCode=@SCode OR SCode=@SCode)
and SCode=@SCode
and ?=@SCode or ?=@SCode
or SCode like '%'+@SCode+'%'";

我想做的东西是：
如果条件为空串的话
就删除sql语句中的条件表达式

[lee3217813]

说的啥子哟

[tancily]

cmd.CommandText=sql;
cmd.SqlParameters.AddRange(paras);
Regex(cmd.CommandText,"and\s+\w+=null"," ");

[饕餮123]

这哥们
我不知道你说的什么啊。

[anzhiqiang_touzi]

string sql=@"select count(0) from Ship where 1=1
and SCode=@SCode
and OCode=@OCode
and (SCode=@SCode OR SCode=@SCode)
and SCode=@SCode
and ?=@SCode or ?=@SCode
or SCode like '%'+@SCode+'%'";

我想做的东西是：
如果条件为空串的话
就删除sql语句中的条件表达式

[-过客-]

不知所云啊

描述不清楚就给例子，并给出对应的结果，一定要给结果