One order search dynamic SQL build logic

Created by Jerry Wang, last modified on Jul 24, 2015

 

One order search dynamic SQL build logic

 

 

 

One order search dynamic SQL build logic

 

 

使用传入的search tab构造SQL:

 

One order search dynamic SQL build logic

 

 

取得逻辑操作符:

 

One order search dynamic SQL build logic

 

 

依次处理search tab里传入的search criteria。首先是OBJECT_TYPE:

 

One order search dynamic SQL build logic

 

 

如果object type为activity,自动把businessactivity和task的type传入:

 

One order search dynamic SQL build logic

 

 

得到包含两个BOR type的querypart:

 

One order search dynamic SQL build logic

 

 

再处理传入的guid:

 

One order search dynamic SQL build logic

 

 

guid分别处理:

 

One order search dynamic SQL build logic

 

 

得到guid的query part:

 

One order search dynamic SQL build logic

 

 

依次执行两个query:

 

One order search dynamic SQL build logic

 

 

走的是FAE 这条路:

 

One order search dynamic SQL build logic

 

 

 

One order search dynamic SQL build logic

上一篇:开机只有一个下滑线在闪


下一篇:C#:Guid.NewGuid()和DateTime.Now该选择哪个???