62,046
社区成员
发帖
与我相关
我的任务
分享
string pattern = @"(and|or)\s*\?=@SCode";
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+'%'
*/