wlmscpfs: change worklist files to database query

关键词：DCMTK;   wlmscpfs;  worklist,  database;  oracle;  sql server;  mysql

（对标题的说明：标题是引用DCMTK论坛里面的一个帖子，地址是：http://forum.dcmtk.org/viewtopic.php?f=1&t=199，主要讨论如何修改wlmscpfs使其支持对mysql的数据库支持，由于自己最近也要做这方面的工作，主要是添加对oracle数据的支持，所以就引用了该讨论的标题）

       首先还是用google检索了下关于此方面的相关讨论与工作，发现牛人们已经在2005年做了该方面的工作，所以还是先贴出来牛人关于这方面的一些讨论。

DCMTK 论坛 1：

Look at WlmDataSourceFileSystem::StartFindRequest(...) and WlmDataSourceFileSystem::NextFindResponse(...). These are the two important methods in WlmDataSourceFileSystem. (The first actually reads information from the .wl files through the call to fileSystemInteractionManager->DetermineMatchingRecords(...).)

You will need to implement 2 classes, one class analogous to WlmDataSourceFileSystem, something like WlmDataSourceDatabase, and one class ananlogous to WlmFileSystemInteractionManager, something like WlmDatabaseInteractionManager.

Another important function is FindCallback(...) in wlmactmg.cc, this function calls dataSource->StartFindRequest(...) and dataSource->NextFindResponse(...).

In general, it should not be a problem for you to implement the 2 classes you need. Take the existing classes (WlmDataSourceFileSystem and WlmFileSystemInteractionManager) as an example an go from there.（http://forum.dcmtk.org/viewtopic.php?f=1&t=199）

 

DCMTK 论坛 2：

the worklist management module is well documented, so it should be relatively easy to understand the code. First you should learn from the standard, how WLM works in DICOM.

One of the most important steps for integration into a RIS should be the usage of an (SQL) database as a datasource. Due to the dcmwlm class structure it should be straightforward to extend the module (subclass WlmDataSource, see "wlds.h"). We've already done this for an Oracle Database, so it should be possible without bigger changes to the other classes.（http://forum.dcmtk.org/viewtopic.php?p=2276&sid=544fc11b61aa92ef2ea5c60a7794789c）

 

（由于google网上论坛的内容过多，所以只贴出网址，具体内容可以根据自己的需要去上面查询）

GOOGLE网上论坛 1：

http://groups.google.com/group/comp.protocols.dicom/browse_frm/month/2003-4?scoring=d&

GOOGLE网上论坛 2：

http://groups.google.com/group/comp.protocols.dicom/index/browse_frm/month/2003-1?_done=%2Fgroup%2Fcomp.protocols.dicom%2Fbrowse_frm%2Fmonth%2F2003-1%3Fscoring%3Dd%26&scoring=d&

        以上检索到的信息，个人认为最有帮助的是DCMTK论坛1：，按照该论坛上的指导，每增加对一种数据库的支持，需要相应的添加两个类，类似于WlmDataSourceFileSystem和WlmFileSystemInteractionManager，（待续 ）