Winson.Framework C#中的一个条件生成器类

winson - 2007-11-12 17:15:00

【转自kaipingk】

在进行sql查询的时候，有时候要进行很多条件限制，自己来拼写SQLwhere条件容易出错，而且判断条件复杂，后期维护困难，基于这个原因我在一个小项目中写了一套生成sql条件的类。总共包括一个Condition类，与两个枚举型类型（LogicOper，CompareOper）
代码如下：

[Codehighlighter] id=bbs.szblogs.com style='BORDER-RIGHT: #cccccc 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: #cccccc 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: #cccccc 1px solid; WIDTH: 98%; WORD-BREAK: break-all; PADDING-TOP: 4px; BORDER-BOTTOM: #cccccc 1px solid; BACKGROUND-COLOR: #eeeeee'[Codeleft][Coderight][Codedv][Codeleft][Coderight]!--[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft]Code highlighting produced by Actipro CodeHighlighter (freeware)[Coderight][Codeb][Codeleft]http://bbs.szblogs.com[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft]--[Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]public[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]class[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] Condition[Coderight][Codeb][Codeleft]{[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]static[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft][] logicOpers [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]new[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft][] { [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]and[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]or[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] };[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]static[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft][] compareOpers [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]new[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft][] { [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]>[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]<[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]<=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]>=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]<>[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]like[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]not like[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]in[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] };[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] compareOper [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]null[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft];[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] name [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]null[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft];[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] templateName [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]null[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft];[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] valType [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]null[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft];[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]object[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] val [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]null[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft];[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]public[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] Condition(CompareOper co, [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] valType, [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] name, [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]object[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] val)[Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]this[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft].compareOper [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] compareOpers[([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]int[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]) co];[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]this[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft].name [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] name;[Coderight][Codeb][Codeleft] templateName [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] name;[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]this[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft].valType [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] valType;[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]this[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft].val [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] val;[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]public[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] Condition(CompareOper co, [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] valType, [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] name, [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]object[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] val, [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] templateName)[Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]this[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft].compareOper [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] compareOpers[([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]int[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]) co];[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]this[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft].name [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] name;[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]this[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft].templateName [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] templateName;[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]this[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft].valType [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] valType;[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]this[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft].val [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] val;[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]public[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] Condition() { }[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]public[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] toSqlString()[Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft][] arr1 [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] ([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft][]) operaters.ToArray([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]""[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft].GetType());[Coderight][Codeb][Codeleft] Condition[] arr2 [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] (Condition[]) conditions.ToArray(([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]new[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] Condition()).GetType());[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft] StringBuilder outStr [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]new[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] StringBuilder();[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]int[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] count [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]0[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft];[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]if[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] (name [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]!=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]null[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]&&[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] val [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]!=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]null[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft])[Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] outStr.Append(name);[Coderight][Codeb][Codeleft] outStr.Append([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]);[Coderight][Codeb][Codeleft] outStr.Append(compareOper);[Coderight][Codeb][Codeleft] outStr.Append([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]);[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]if[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] (valType.ToLower() [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]==[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]int[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft][Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]||[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] valType.ToLower() [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]==[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]float[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft][Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]||[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] valType.ToLower() [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]==[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]double[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft][Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]||[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] valType.ToLower() [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]==[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]bool[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft][Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]||[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] valType.ToLower() [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]==[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]number[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft][Coderight][Codeb][Codeleft] )[Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] outStr.Append(val);[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]else[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]if[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] (valType.ToLower() [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]==[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft])[Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] tmp [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] ([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]) val;[Coderight][Codeb][Codeleft] outStr.Append([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]+[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] tmp.Replace([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]''[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]) [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]+[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]);[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]else[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]if[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] (valType.ToLower() [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]==[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]date[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft])[Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] DateTime dt [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] (DateTime) val;[Coderight][Codeb][Codeleft] outStr.Append([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]+[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] dt.ToString([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]yyyy-MM-dd[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]) [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]+[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]);[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]else[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]if[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] (valType.ToLower() [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]==[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]datetime[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft])[Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] DateTime dt [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] (DateTime) val;[Coderight][Codeb][Codeleft] outStr.Append([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]+[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] dt.ToString([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]yyyy-MM-dd hh:mm:ss.fff[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]) [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]+[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]);[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]else[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft][Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] tmp [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] val.ToString();[Coderight][Codeb][Codeleft] outStr.Append([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]+[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] tmp.Replace([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]''[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]) [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]+[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]);[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft] count[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]++[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft];[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]if[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] (arr1.Length [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]>[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]0[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft])[Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]for[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] ([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]int[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] i [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]0[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]; i [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]<[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] arr1.Length; i[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]++[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft])[Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]if[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] (arr2.toSqlTempletString() [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]==[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]""[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft])[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]continue[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft];[Coderight][Codeb][Codeleft] count[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]++[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft];[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]if[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] ((name [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]!=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]null[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]&&[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] val [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]!=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]null[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]) [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]||[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] count [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]>[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]1[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft])[Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] outStr.Append([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]);[Coderight][Codeb][Codeleft] outStr.Append(arr1);[Coderight][Codeb][Codeleft] outStr.Append([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]);[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft] outStr.Append(arr2.toSqlString());[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]if[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] (count [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]>[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]1[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft])[Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] outStr.Insert([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]0[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]);[Coderight][Codeb][Codeleft] outStr.Append([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft])[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]);[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]return[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] outStr.ToString();[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]public[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] toSqlTempletString()[Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft][] arr1 [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] ([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft][]) operaters.ToArray([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]""[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft].GetType());[Coderight][Codeb][Codeleft] Condition[] arr2 [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] (Condition[]) conditions.ToArray(([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]new[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] Condition()).GetType());[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft] StringBuilder outStr [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]new[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] StringBuilder();[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]int[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] count [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]0[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft];[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]if[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] (name [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]!=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]null[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]&&[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] val [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]!=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]null[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft])[Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] outStr.Append(name);[Coderight][Codeb][Codeleft] outStr.Append([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]);[Coderight][Codeb][Codeleft] outStr.Append(compareOper);[Coderight][Codeb][Codeleft] outStr.Append([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft] @[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]);[Coderight][Codeb][Codeleft] outStr.Append(templateName);[Coderight][Codeb][Codeleft] count[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]++[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft];[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]if[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] (arr1.Length [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]>[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]0[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft])[Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]for[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] ([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]int[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] i [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]0[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]; i [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]<[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] arr1.Length; i[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]++[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft])[Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]if[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] (arr2.toSqlTempletString() [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]==[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]""[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft])[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]continue[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft];[Coderight][Codeb][Codeleft] count[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]++[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft];[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]if[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] ((name [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]!=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]null[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]&&[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] val [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]!=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]null[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]) [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]||[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] count [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]>[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]1[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft])[Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] outStr.Append([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]);[Coderight][Codeb][Codeleft] outStr.Append(arr1);[Coderight][Codeb][Codeleft] outStr.Append([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]);[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft] outStr.Append(arr2.toSqlTempletString());[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]if[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] (count [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]>[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]1[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft])[Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] outStr.Insert([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]0[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]);[Coderight][Codeb][Codeleft] outStr.Append([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft])[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]);[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]return[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] outStr.ToString();[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]public[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] SqlParameter[] getSqlParameters()[Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] ArrayList tmp [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]new[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] ArrayList();[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]if[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] (name [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]!=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]null[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]&&[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] val [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]!=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]null[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft])[Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] tmp.Add([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]new[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] SqlParameter([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]@[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]+[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] templateName, val));[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft] Condition[] arr [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] (Condition[]) conditions.ToArray(([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]new[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] Condition()).GetType());[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]for[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] ([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]int[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] i [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]0[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]; i [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]<[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] arr.Length; i[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]++[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft])[Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] SqlParameter[] sps [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] arr.getSqlParameters();[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]for[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] ([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]int[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] j [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]0[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]; j [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]<[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] sps.Length; j[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]++[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft])[Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] tmp.Add(sps[j]);[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]return[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] (SqlParameter[]) tmp.ToArray([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]new[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] SqlParameter([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]""[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]""[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]).GetType());[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft] ArrayList operaters [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]new[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] ArrayList();[Coderight][Codeb][Codeleft] ArrayList conditions [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]new[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] ArrayList();[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]public[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]void[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] addCondition(LogicOper lo, Condition c)[Coderight][Codeb][Codeleft] {[Coderight][Codeb][Codeleft] operaters.Add(logicOpers[([Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]int[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]) lo]);[Coderight][Codeb][Codeleft] conditions.Add(c);[Coderight][Codeb][Codeleft] }[Coderight][Codeb][Codeleft]}[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft][Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]public[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]enum[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] LogicOper : [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]int[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft][Coderight][Codeb][Codeleft]{[Coderight][Codeb][Codeleft] and [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]0[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft],[Coderight][Codeb][Codeleft] or [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]1[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft][Coderight][Codeb][Codeleft]}[Coderight][Codeb][Codeleft][Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]public[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]enum[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] CompareOper : [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]int[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft][Coderight][Codeb][Codeleft]{[Coderight][Codeb][Codeleft] moreThan [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]0[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft],[Coderight][Codeb][Codeleft] lessThan [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]1[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft],[Coderight][Codeb][Codeleft] notMoreThan [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]2[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft],[Coderight][Codeb][Codeleft] notLessThan [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]3[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft],[Coderight][Codeb][Codeleft] equal [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]4[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft],[Coderight][Codeb][Codeleft] notEqual [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]5[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft],[Coderight][Codeb][Codeleft] like [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]6[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft],[Coderight][Codeb][Codeleft] notLike [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]7[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft],[Coderight][Codeb][Codeleft] IN [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]8[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft][Coderight][Codeb][Codeleft]}[Coderight]/[Codesp][Codeleft][Coderight]/[Codedv][Codeleft][/Codehighlighter]

使用如下:

[Codehighlighter] id=bbs.szblogs.com style='BORDER-RIGHT: #cccccc 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: #cccccc 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: #cccccc 1px solid; WIDTH: 98%; WORD-BREAK: break-all; PADDING-TOP: 4px; BORDER-BOTTOM: #cccccc 1px solid; BACKGROUND-COLOR: #eeeeee'[Codeleft][Coderight][Codedv][Codeleft][Coderight]!--[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft]Code highlighting produced by Actipro CodeHighlighter (freeware)[Coderight][Codeb][Codeleft]http://bbs.szblogs.com[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft]--[Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]Condition condition [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]new[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] Condition(CompareOper.equal, [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]name[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]%kkp%[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]);[Coderight][Codeb][Codeleft]Condition condition2 [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]new[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] Condition(CompareOper.equal, [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]int[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]id[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800080;"[Codeleft]1024[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]);[Coderight][Codeb][Codeleft]Condition condition3 [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]new[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] Condition(CompareOper.like, [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]string[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]nickName[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]%'kkp'%[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]);[Coderight][Codeb][Codeleft]Condition condition4 [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]new[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] Condition(CompareOper.equal, [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]date[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]age[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], DateTime.Now);[Coderight][Codeb][Codeleft]Condition condition5 [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]new[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] Condition(CompareOper.equal, [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]datetime[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]signTime[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000;"[Codeleft]"[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft], DateTime.Now);[Coderight][Codeb][Codeleft]Condition condition6 [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #0000FF;"[Codeleft]new[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] Condition();[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft]condition.addCondition(LogicOper.or, condition2);[Coderight][Codeb][Codeleft]condition.addCondition(LogicOper.or, condition3);[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft]condition6.addCondition(LogicOper.or, condition4);[Coderight][Codeb][Codeleft]condition6.addCondition(LogicOper.or, condition5);[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft]condition6.addCondition(LogicOper.and, condition);[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft]condition6.toSqlString();[Coderight][Codeb][Codeleft]condition6.toSqlTempletString();[Coderight][Codeb][Codeleft]condition6.getSqlParameters();[Coderight]/[Codesp][Codeleft][Coderight]/[Codedv][Codeleft][/Codehighlighter]

通过Condition类的addCondition方法可以实现任意复杂的条件组合。toSqlString()方法返回sql条件，可以用于sql拼接方式使用。而toSqlTempletString()方式生成的是以参数形式的 sql条件，配合getSqlParameters()方法可以实现以参数传递的条件（相当于java中的prepareStatement实现）。

[Codehighlighter] id=bbs.szblogs.com style='BORDER-RIGHT: #cccccc 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: #cccccc 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: #cccccc 1px solid; WIDTH: 98%; WORD-BREAK: break-all; PADDING-TOP: 4px; BORDER-BOTTOM: #cccccc 1px solid; BACKGROUND-COLOR: #eeeeee'[Codeleft][Coderight][Codedv][Codeleft][Coderight]!--[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft]Code highlighting produced by Actipro CodeHighlighter (freeware)[Coderight][Codeb][Codeleft]http://bbs.szblogs.com[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft]--[Codeleft][Coderight][Codeim] src="/Images/OutliningIndicators/None.gif" align="top"/[Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]condition6.toSqlString();[Coderight][Codeb][Codeleft][Coderight][Codeim] src="/Images/OutliningIndicators/None.gif" align="top"/[Codeleft]condition6.toSqlTempletString();[Coderight]/[Codesp][Codeleft][Coderight]/[Codedv][Codeleft][/Codehighlighter]

的结果分别是：

[Codehighlighter] id=bbs.szblogs.com style='BORDER-RIGHT: #cccccc 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: #cccccc 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: #cccccc 1px solid; WIDTH: 98%; WORD-BREAK: break-all; PADDING-TOP: 4px; BORDER-BOTTOM: #cccccc 1px solid; BACKGROUND-COLOR: #eeeeee'[Codeleft][Coderight][Codedv][Codeleft][Coderight]!--[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft]Code highlighting produced by Actipro CodeHighlighter (freeware)[Coderight][Codeb][Codeleft]http://bbs.szblogs.com[Coderight][Codeb][Codeleft][Coderight][Codeb][Codeleft]--[Codeleft][Coderight][Codeim] src="/Images/OutliningIndicators/None.gif" align="top"/[Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft](age [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #808080;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #FF0000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #FF0000;"[Codeleft]2007-07-16[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #FF0000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #808080;"[Codeleft]or[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] signTime [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #808080;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #FF0000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #FF0000;"[Codeleft]2007-07-16 02:06:02.667[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #FF0000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #808080;"[Codeleft]and[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] (name [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #808080;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #FF0000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #FF0000;"[Codeleft]%kkp%[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #FF0000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #808080;"[Codeleft]or[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] id [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #808080;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #800000; font-weight: bold;"[Codeleft]1024[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #808080;"[Codeleft]or[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] nickName [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #808080;"[Codeleft]like[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #FF0000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #FF0000;"[Codeleft]%[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #FF0000;"[Codeleft]''[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #FF0000;"[Codeleft]kkp[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #FF0000;"[Codeleft]''[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #FF0000;"[Codeleft]%[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #FF0000;"[Codeleft]'[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]))[Coderight][Codeb][Codeleft][Coderight][Codeim] src="/Images/OutliningIndicators/None.gif" align="top"/[Codeleft][Coderight][Codeb][Codeleft][Coderight][Codeim] src="/Images/OutliningIndicators/None.gif" align="top"/[Codeleft](age [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #808080;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #008000;"[Codeleft]@age[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #808080;"[Codeleft]or[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] signTime [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #808080;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #008000;"[Codeleft]@signTime[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #808080;"[Codeleft]and[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] (name [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #808080;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #008000;"[Codeleft]@name[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #808080;"[Codeleft]or[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] id [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #808080;"[Codeleft]=[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #008000;"[Codeleft]@id[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #808080;"[Codeleft]or[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] nickName [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #808080;"[Codeleft]like[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft] [Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #008000;"[Codeleft]@nickName[Coderight]/[Codesp][Codeleft][Coderight][Codesp] style="color: #000000;"[Codeleft]))[Coderight]/[Codesp][Codeleft][Coderight]/[Codedv][Codeleft][/Codehighlighter]

深圳博客技术论坛