Home Explore Help
Register Sign In
dbs289
/
ConsentDemoServer
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 48a9dbbbc5
Branches Tags
ConsentDemoS...
/
CLIP.e-Form.Consent.Web
/
Logs
/
eFormServer.iBATIS.log_2016-08-26

eFormServer.iBATIS.log_2016-08-26 29 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159 
  1. 

  2. [Logging Date Time: 2016-08-26 16:37:34,830] =====================================================================================
    3. 

  3. SQL Command - Statement Id: [setFileName] Parameters: [param0=[pid,0586244], param1=[ordtype,I], param2=[orddd,20150615], param3=[dschdd,20150815], param4=[cretno,1], param5=[filesize,500], param6=[formcd,1300009935], param7=[pageno,3], param8=[ocrtag,2016080489195], param9=[userid,103043]]
    4. 

  4. 

  5. [Logging Date Time: 2016-08-26 16:37:34,838] =====================================================================================
    6. 

  6. SQL Command - Statement Id: [setFileName] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[AnsiString, System.String], param8=[AnsiString, System.String], param9=[AnsiString, System.String]]
    7. 

  7. 

  8. [Logging Date Time: 2016-08-26 16:37:34,838] =====================================================================================
    9. 

  9. SQL Command - Statement Id: [setFileName] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[AnsiString, System.String], param8=[AnsiString, System.String], param9=[AnsiString, System.String]]
    10. 

  10. 

  11. [Logging Date Time: 2016-08-26 16:37:34,847] =====================================================================================
    12. 

  12. SQL Command - Statement Id: [getFileName] PreparedStatement : [SELECT d.alias||'\'||'fnuImage'||'\'||substr(c.cdate,1,6)||'\'||substr(c.cdate,7)||'\'||to_char(c.pageno) as filename            FROM cmr.treatt a, cmr.chartpaget b, cmr.paget c, cmr.patht d           WHERE a.patid    =  :param0              AND a.class    =  :param1              AND a.indate   =  :param2              AND a.outdate  =  :param3              and a.TREATNO  =  b.TREATNO                     and b.formcode =  :param4              and b.ocrcode  =  :param5              and b.page =  :param6              and b.pageno   = c.pageno             and d.pathid  = c.pathid             and d.active = 'Y']
    13. 

  13. 

  14. [Logging Date Time: 2016-08-26 16:37:34,847] =====================================================================================
    15. 

  15. SQL Command - Statement Id: [getFileName] PreparedStatement : [SELECT d.alias||'\'||'fnuImage'||'\'||substr(c.cdate,1,6)||'\'||substr(c.cdate,7)||'\'||to_char(c.pageno) as filename            FROM cmr.treatt a, cmr.chartpaget b, cmr.paget c, cmr.patht d           WHERE a.patid    =  :param0              AND a.class    =  :param1              AND a.indate   =  :param2              AND a.outdate  =  :param3              and a.TREATNO  =  b.TREATNO                     and b.formcode =  :param4              and b.ocrcode  =  :param5              and b.page =  :param6              and b.pageno   = c.pageno             and d.pathid  = c.pathid             and d.active = 'Y']
    16. 

  16. 

  17. [Logging Date Time: 2016-08-26 16:37:34,847] =====================================================================================
    18. 

  18. SQL Command - Statement Id: [getFileName] Parameters: [param0=[pid,0586244], param1=[ordtype,I], param2=[orddd,20150615], param3=[dschdd,20150815], param4=[formcd,1300009935], param5=[ocrtag,2016080489195], param6=[pageno,3]]
    19. 

  19. 

  20. [Logging Date Time: 2016-08-26 16:37:34,847] =====================================================================================
    21. 

  21. SQL Command - Statement Id: [getFileName] Parameters: [param0=[pid,0586244], param1=[ordtype,I], param2=[orddd,20150615], param3=[dschdd,20150815], param4=[formcd,1300009935], param5=[ocrtag,2016080489195], param6=[pageno,3]]
    22. 

  22. 

  23. [Logging Date Time: 2016-08-26 16:37:34,847] =====================================================================================
    24. 

  24. SQL Command - Statement Id: [getFileName] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String]]
    25. 

  25. 

  26. [Logging Date Time: 2016-08-26 16:37:34,847] =====================================================================================
    27. 

  27. SQL Command - Statement Id: [getFileName] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String]]
    28. 

  28. 

  29. [Logging Date Time: 2016-08-26 16:37:34,860] =====================================================================================
    30. 

  30. SQL Command - Statement Id: [GET_SEQUENCE] PreparedStatement : [select ud1_num as seq        from EFORM_CODE        where main_cd = 'SEQUENCE'        and sub_cd =  :param0         for update]
    31. 

  31. 

  32. [Logging Date Time: 2016-08-26 16:37:34,860] =====================================================================================
    33. 

  33. SQL Command - Statement Id: [GET_SEQUENCE] PreparedStatement : [select ud1_num as seq        from EFORM_CODE        where main_cd = 'SEQUENCE'        and sub_cd =  :param0         for update]
    34. 

  34. 

  35. [Logging Date Time: 2016-08-26 16:37:34,860] =====================================================================================
    36. 

  36. SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_IMAGE]]
    37. 

  37. 

  38. [Logging Date Time: 2016-08-26 16:37:34,860] =====================================================================================
    39. 

  39. SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_IMAGE]]
    40. 

  40. 

  41. [Logging Date Time: 2016-08-26 16:37:34,860] =====================================================================================
    42. 

  42. SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]
    43. 

  43. 

  44. [Logging Date Time: 2016-08-26 16:37:34,860] =====================================================================================
    45. 

  45. SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]
    46. 

  46. 

  47. [Logging Date Time: 2016-08-26 16:37:34,865] =====================================================================================
    48. 

  48. SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE        set ud1_num =   :param0         where main_cd = 'SEQUENCE' and sub_cd =  :param1]
    49. 

  49. 

  50. [Logging Date Time: 2016-08-26 16:37:34,865] =====================================================================================
    51. 

  51. SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE        set ud1_num =   :param0         where main_cd = 'SEQUENCE' and sub_cd =  :param1]
    52. 

  52. 

  53. [Logging Date Time: 2016-08-26 16:37:34,866] =====================================================================================
    54. 

  54. SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,159], param1=[sub_cd,CONSENT_IMAGE]]
    55. 

  55. 

  56. [Logging Date Time: 2016-08-26 16:37:34,866] =====================================================================================
    57. 

  57. SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,159], param1=[sub_cd,CONSENT_IMAGE]]
    58. 

  58. 

  59. [Logging Date Time: 2016-08-26 16:37:34,866] =====================================================================================
    60. 

  60. SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]
    61. 

  61. 

  62. [Logging Date Time: 2016-08-26 16:37:34,866] =====================================================================================
    63. 

  63. SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]
    64. 

  64. 

  65. [Logging Date Time: 2016-08-26 16:37:34,867] =====================================================================================
    66. 

  66. SQL Command - Statement Id: [INSERT_CONSENT_IMAGE] PreparedStatement : [insert into CONSENT_IMAGE          (            CONSENT_Image_RID,            CONSENT_MST_RID,            FORM_RID,            IMAGE_PATH,            IMAGE_FILENAME,            COMPLETE_YN,            CREATE_USER_ID,            CREATE_DATETIME          )          values          (             :param0 ,             :param1 ,             :param2 ,             :param3 ,             :param4 ,             :param5 ,             :param6 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss')          )]
    67. 

  67. 

  68. [Logging Date Time: 2016-08-26 16:37:34,867] =====================================================================================
    69. 

  69. SQL Command - Statement Id: [INSERT_CONSENT_IMAGE] PreparedStatement : [insert into CONSENT_IMAGE          (            CONSENT_Image_RID,            CONSENT_MST_RID,            FORM_RID,            IMAGE_PATH,            IMAGE_FILENAME,            COMPLETE_YN,            CREATE_USER_ID,            CREATE_DATETIME          )          values          (             :param0 ,             :param1 ,             :param2 ,             :param3 ,             :param4 ,             :param5 ,             :param6 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss')          )]
    70. 

  70. 

  71. [Logging Date Time: 2016-08-26 16:37:34,867] =====================================================================================
    72. 

  72. SQL Command - Statement Id: [INSERT_CONSENT_IMAGE] Parameters: [param0=[consentImageRid,159], param1=[consentMstRid,63], param2=[formRid,184], param3=[imagePath,Image3\fnuImage\201608\26], param4=[imageFilename,100502080.jpg], param5=[completeYn,Y], param6=[userId,103043]]
    73. 

  73. 

  74. [Logging Date Time: 2016-08-26 16:37:34,867] =====================================================================================
    75. 

  75. SQL Command - Statement Id: [INSERT_CONSENT_IMAGE] Parameters: [param0=[consentImageRid,159], param1=[consentMstRid,63], param2=[formRid,184], param3=[imagePath,Image3\fnuImage\201608\26], param4=[imageFilename,100502080.jpg], param5=[completeYn,Y], param6=[userId,103043]]
    76. 

  76. 

  77. [Logging Date Time: 2016-08-26 16:37:34,867] =====================================================================================
    78. 

  78. SQL Command - Statement Id: [INSERT_CONSENT_IMAGE] Types: [param0=[Int32, System.Int32], param1=[Int32, System.Int32], param2=[Int32, System.Int32], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String]]
    79. 

  79. 

  80. [Logging Date Time: 2016-08-26 16:37:34,867] =====================================================================================
    81. 

  81. SQL Command - Statement Id: [INSERT_CONSENT_IMAGE] Types: [param0=[Int32, System.Int32], param1=[Int32, System.Int32], param2=[Int32, System.Int32], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String]]
    82. 

  82. 

  83. [Logging Date Time: 2016-08-26 16:37:35,470] =====================================================================================
    84. 

  84. SQL Command - CLIP.eForm File Upload: Image3\fnuImage\201608\26\100502080.jpg
    85. 

  85. 

  86. [Logging Date Time: 2016-08-26 16:37:35,470] =====================================================================================
    87. 

  87. SQL Command - CLIP.eForm File Upload: C:\@bin\@DFH\ImageTest\fnuImage\201608\26\100502080.jpg
    88. 

  88. 

  89. [Logging Date Time: 2016-08-26 16:37:35,493] =====================================================================================
    90. 

  90. SQL Command - Statement Id: [INSERT_CONSENT_IMAGE_SIGN] PreparedStatement : [insert into CONSENT_IMAGE_SIGN          (            CONSENT_MST_RID,            CONSENT_IMAGE_RID,            CERT_TARGET,            CERT_RESULT,            CERT_STATUS,            CREATE_USER_ID,            CREATE_DATETIME,            MODIFY_USER_ID,            MODIFY_DATETIME          )          values          (             :param0 ,             :param1 ,             :param2 ,             :param3 ,            'N',             :param4 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),              :param4 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss')          )]
    91. 

  91. 

  92. [Logging Date Time: 2016-08-26 16:37:35,493] =====================================================================================
    93. 

  93. SQL Command - Statement Id: [INSERT_CONSENT_IMAGE_SIGN] PreparedStatement : [insert into CONSENT_IMAGE_SIGN          (            CONSENT_MST_RID,            CONSENT_IMAGE_RID,            CERT_TARGET,            CERT_RESULT,            CERT_STATUS,            CREATE_USER_ID,            CREATE_DATETIME,            MODIFY_USER_ID,            MODIFY_DATETIME          )          values          (             :param0 ,             :param1 ,             :param2 ,             :param3 ,            'N',             :param4 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'),              :param4 ,            TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss')          )]
    94. 

  94. 

  95. [Logging Date Time: 2016-08-26 16:37:35,494] =====================================================================================
    96. 

  96. SQL Command - Statement Id: [INSERT_CONSENT_IMAGE_SIGN] Parameters: [param0=[consentMstRid,63], param1=[consentImageRid,156], param2=[certTarget,cf557d7fb48fd1f6a0d0bd933a1e562db3dc5626f4e7fb744597fdb3c40^de779bd693abffa5635849ed2821ec140b2e5971174d358f3b9bd39894c520^d6d24d8b53f2c38c6d4e6ffd17941f82fa1d63e8562cbc6d2e9d613b17767b^1522d5f0de572bcf1f1177d96f17122b60e2d240f0b3e018227f1cc11133e2], param3=[certResult,], param4=[userId,103043]]
    97. 

  97. 

  98. [Logging Date Time: 2016-08-26 16:37:35,494] =====================================================================================
    99. 

  99. SQL Command - Statement Id: [INSERT_CONSENT_IMAGE_SIGN] Parameters: [param0=[consentMstRid,63], param1=[consentImageRid,156], param2=[certTarget,cf557d7fb48fd1f6a0d0bd933a1e562db3dc5626f4e7fb744597fdb3c40^de779bd693abffa5635849ed2821ec140b2e5971174d358f3b9bd39894c520^d6d24d8b53f2c38c6d4e6ffd17941f82fa1d63e8562cbc6d2e9d613b17767b^1522d5f0de572bcf1f1177d96f17122b60e2d240f0b3e018227f1cc11133e2], param3=[certResult,], param4=[userId,103043]]
    100. 

  100. 

  101. [Logging Date Time: 2016-08-26 16:37:35,494] =====================================================================================
    102. 

  102. SQL Command - Statement Id: [INSERT_CONSENT_IMAGE_SIGN] Types: [param0=[Int32, System.Int32], param1=[Int32, System.Int32], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]]
    103. 

  103. 

  104. [Logging Date Time: 2016-08-26 16:37:35,494] =====================================================================================
    105. 

  105. SQL Command - Statement Id: [INSERT_CONSENT_IMAGE_SIGN] Types: [param0=[Int32, System.Int32], param1=[Int32, System.Int32], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String]]
    106. 

  106. 

  107. [Logging Date Time: 2016-08-26 16:37:36,541] =====================================================================================
    108. 

  108. SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID                , DECODE(CM.CONSENT_STATE, 'TEMP' ,'임시저장', 'ELECTR_CMP', '서명', 'PAPER_OUT', '출력' , 'CERTIFY_CMP', '인증', 'UNFINISHED', '미작성') AS CONSENT_STATE_DISP                , VEF.FORM_NAME AS CONSENT_NAME                , CM.HOS_TYPE                , CM.PID                , CM.VISIT_TYPE                , CM.ORDER_NO                , CM.ORDER_CD                , CM.ORDER_NAME                , CM.CLN_DEPT_CD                , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD) AS CLN_DEPT_NM                , CM.WARDCD                , CM.ROOMCD                , CM.FORM_RID                , VEF.FORM_CD                , VEF.FORM_GUID                , C.PRNTCNT                , CM.CONSENT_STATE                , CM.OCR_NUMBER                 , CM.COSIGN_DC_ID                , CM.COSIGN_DC_NAME                , CM.CREATE_USER_ID                , CM.CREATE_USER_NAME                , CM.CREATE_DATETIME                , CM.CLN_DATE                , CM.CRETNO            FROM  CONSENT_MST CM           INNER  JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID,                  EMR.MRFMFORM C           WHERE  CM.USE_YN = 'Y'              AND  CM.PID =  :param0                AND  TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN  :param1  and  :param2              AND  VEF.FORM_CD = C.FORMCD             AND  C.instcd = '111'             AND  C.formprogflag LIKE 'OCR%'             AND  C.formlevlcd != '-'             AND  SUBSTR (C.formtodt, 1, 8) = '99991231'                       AND  CM.CONSENT_STATE IN ('UNFINISHED','TEMP')                      ORDER  BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC]
    109. 

  109. 

  110. [Logging Date Time: 2016-08-26 16:37:36,541] =====================================================================================
    111. 

  111. SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID                , DECODE(CM.CONSENT_STATE, 'TEMP' ,'임시저장', 'ELECTR_CMP', '서명', 'PAPER_OUT', '출력' , 'CERTIFY_CMP', '인증', 'UNFINISHED', '미작성') AS CONSENT_STATE_DISP                , VEF.FORM_NAME AS CONSENT_NAME                , CM.HOS_TYPE                , CM.PID                , CM.VISIT_TYPE                , CM.ORDER_NO                , CM.ORDER_CD                , CM.ORDER_NAME                , CM.CLN_DEPT_CD                , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD) AS CLN_DEPT_NM                , CM.WARDCD                , CM.ROOMCD                , CM.FORM_RID                , VEF.FORM_CD                , VEF.FORM_GUID                , C.PRNTCNT                , CM.CONSENT_STATE                , CM.OCR_NUMBER                 , CM.COSIGN_DC_ID                , CM.COSIGN_DC_NAME                , CM.CREATE_USER_ID                , CM.CREATE_USER_NAME                , CM.CREATE_DATETIME                , CM.CLN_DATE                , CM.CRETNO            FROM  CONSENT_MST CM           INNER  JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID,                  EMR.MRFMFORM C           WHERE  CM.USE_YN = 'Y'              AND  CM.PID =  :param0                AND  TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN  :param1  and  :param2              AND  VEF.FORM_CD = C.FORMCD             AND  C.instcd = '111'             AND  C.formprogflag LIKE 'OCR%'             AND  C.formlevlcd != '-'             AND  SUBSTR (C.formtodt, 1, 8) = '99991231'                       AND  CM.CONSENT_STATE IN ('UNFINISHED','TEMP')                      ORDER  BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC]
    112. 

  112. 

  113. [Logging Date Time: 2016-08-26 16:37:36,541] =====================================================================================
    114. 

  114. SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,0586244], param1=[startDt,20010601], param2=[endDt,20160826]]
    115. 

  115. 

  116. [Logging Date Time: 2016-08-26 16:37:36,541] =====================================================================================
    117. 

  117. SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,0586244], param1=[startDt,20010601], param2=[endDt,20160826]]
    118. 

  118. 

  119. [Logging Date Time: 2016-08-26 16:37:36,541] =====================================================================================
    120. 

  120. SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]
    121. 

  121. 

  122. [Logging Date Time: 2016-08-26 16:37:36,541] =====================================================================================
    123. 

  123. SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]
    124. 

  124. 

  125. [Logging Date Time: 2016-08-26 16:37:39,070] =====================================================================================
    126. 

  126. SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID                , DECODE(CM.CONSENT_STATE, 'TEMP' ,'임시저장', 'ELECTR_CMP', '서명', 'PAPER_OUT', '출력' , 'CERTIFY_CMP', '인증', 'UNFINISHED', '미작성') AS CONSENT_STATE_DISP                , VEF.FORM_NAME AS CONSENT_NAME                , CM.HOS_TYPE                , CM.PID                , CM.VISIT_TYPE                , CM.ORDER_NO                , CM.ORDER_CD                , CM.ORDER_NAME                , CM.CLN_DEPT_CD                , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD) AS CLN_DEPT_NM                , CM.WARDCD                , CM.ROOMCD                , CM.FORM_RID                , VEF.FORM_CD                , VEF.FORM_GUID                , C.PRNTCNT                , CM.CONSENT_STATE                , CM.OCR_NUMBER                 , CM.COSIGN_DC_ID                , CM.COSIGN_DC_NAME                , CM.CREATE_USER_ID                , CM.CREATE_USER_NAME                , CM.CREATE_DATETIME                , CM.CLN_DATE                , CM.CRETNO            FROM  CONSENT_MST CM           INNER  JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID,                  EMR.MRFMFORM C           WHERE  CM.USE_YN = 'Y'              AND  CM.PID =  :param0                AND  TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN  :param1  and  :param2              AND  VEF.FORM_CD = C.FORMCD             AND  C.instcd = '111'             AND  C.formprogflag LIKE 'OCR%'             AND  C.formlevlcd != '-'             AND  SUBSTR (C.formtodt, 1, 8) = '99991231'                       AND  CM.CONSENT_STATE IN ('UNFINISHED','TEMP')                      ORDER  BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC]
    127. 

  127. 

  128. [Logging Date Time: 2016-08-26 16:37:39,070] =====================================================================================
    129. 

  129. SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID                , DECODE(CM.CONSENT_STATE, 'TEMP' ,'임시저장', 'ELECTR_CMP', '서명', 'PAPER_OUT', '출력' , 'CERTIFY_CMP', '인증', 'UNFINISHED', '미작성') AS CONSENT_STATE_DISP                , VEF.FORM_NAME AS CONSENT_NAME                , CM.HOS_TYPE                , CM.PID                , CM.VISIT_TYPE                , CM.ORDER_NO                , CM.ORDER_CD                , CM.ORDER_NAME                , CM.CLN_DEPT_CD                , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD) AS CLN_DEPT_NM                , CM.WARDCD                , CM.ROOMCD                , CM.FORM_RID                , VEF.FORM_CD                , VEF.FORM_GUID                , C.PRNTCNT                , CM.CONSENT_STATE                , CM.OCR_NUMBER                 , CM.COSIGN_DC_ID                , CM.COSIGN_DC_NAME                , CM.CREATE_USER_ID                , CM.CREATE_USER_NAME                , CM.CREATE_DATETIME                , CM.CLN_DATE                , CM.CRETNO            FROM  CONSENT_MST CM           INNER  JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID,                  EMR.MRFMFORM C           WHERE  CM.USE_YN = 'Y'              AND  CM.PID =  :param0                AND  TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN  :param1  and  :param2              AND  VEF.FORM_CD = C.FORMCD             AND  C.instcd = '111'             AND  C.formprogflag LIKE 'OCR%'             AND  C.formlevlcd != '-'             AND  SUBSTR (C.formtodt, 1, 8) = '99991231'                       AND  CM.CONSENT_STATE IN ('UNFINISHED','TEMP')                      ORDER  BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC]
    130. 

  130. 

  131. [Logging Date Time: 2016-08-26 16:37:39,071] =====================================================================================
    132. 

  132. SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,0586244], param1=[startDt,20010601], param2=[endDt,20160826]]
    133. 

  133. 

  134. [Logging Date Time: 2016-08-26 16:37:39,071] =====================================================================================
    135. 

  135. SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,0586244], param1=[startDt,20010601], param2=[endDt,20160826]]
    136. 

  136. 

  137. [Logging Date Time: 2016-08-26 16:37:39,071] =====================================================================================
    138. 

  138. SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]
    139. 

  139. 

  140. [Logging Date Time: 2016-08-26 16:37:39,071] =====================================================================================
    141. 

  141. SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]
    142. 

  142. 

  143. [Logging Date Time: 2016-08-26 16:37:43,447] =====================================================================================
    144. 

  144. SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID                , DECODE(CM.CONSENT_STATE, 'TEMP' ,'임시저장', 'ELECTR_CMP', '서명', 'PAPER_OUT', '출력' , 'CERTIFY_CMP', '인증', 'UNFINISHED', '미작성') AS CONSENT_STATE_DISP                , VEF.FORM_NAME AS CONSENT_NAME                , CM.HOS_TYPE                , CM.PID                , CM.VISIT_TYPE                , CM.ORDER_NO                , CM.ORDER_CD                , CM.ORDER_NAME                , CM.CLN_DEPT_CD                , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD) AS CLN_DEPT_NM                , CM.WARDCD                , CM.ROOMCD                , CM.FORM_RID                , VEF.FORM_CD                , VEF.FORM_GUID                , C.PRNTCNT                , CM.CONSENT_STATE                , CM.OCR_NUMBER                 , CM.COSIGN_DC_ID                , CM.COSIGN_DC_NAME                , CM.CREATE_USER_ID                , CM.CREATE_USER_NAME                , CM.CREATE_DATETIME                , CM.CLN_DATE                , CM.CRETNO            FROM  CONSENT_MST CM           INNER  JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID,                  EMR.MRFMFORM C           WHERE  CM.USE_YN = 'Y'              AND  CM.PID =  :param0                AND  TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN  :param1  and  :param2              AND  VEF.FORM_CD = C.FORMCD             AND  C.instcd = '111'             AND  C.formprogflag LIKE 'OCR%'             AND  C.formlevlcd != '-'             AND  SUBSTR (C.formtodt, 1, 8) = '99991231'                   ORDER  BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC]
    145. 

  145. 

  146. [Logging Date Time: 2016-08-26 16:37:43,447] =====================================================================================
    147. 

  147. SQL Command - Statement Id: [GET_CONSENT_LIST] PreparedStatement : [SELECT CM.CONSENT_MST_RID                , DECODE(CM.CONSENT_STATE, 'TEMP' ,'임시저장', 'ELECTR_CMP', '서명', 'PAPER_OUT', '출력' , 'CERTIFY_CMP', '인증', 'UNFINISHED', '미작성') AS CONSENT_STATE_DISP                , VEF.FORM_NAME AS CONSENT_NAME                , CM.HOS_TYPE                , CM.PID                , CM.VISIT_TYPE                , CM.ORDER_NO                , CM.ORDER_CD                , CM.ORDER_NAME                , CM.CLN_DEPT_CD                , (SELECT DEPTHNGNM FROM COM.ZSDDDEPT WHERE DEPTCD = CM.CLN_DEPT_CD) AS CLN_DEPT_NM                , CM.WARDCD                , CM.ROOMCD                , CM.FORM_RID                , VEF.FORM_CD                , VEF.FORM_GUID                , C.PRNTCNT                , CM.CONSENT_STATE                , CM.OCR_NUMBER                 , CM.COSIGN_DC_ID                , CM.COSIGN_DC_NAME                , CM.CREATE_USER_ID                , CM.CREATE_USER_NAME                , CM.CREATE_DATETIME                , CM.CLN_DATE                , CM.CRETNO            FROM  CONSENT_MST CM           INNER  JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID,                  EMR.MRFMFORM C           WHERE  CM.USE_YN = 'Y'              AND  CM.PID =  :param0                AND  TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN  :param1  and  :param2              AND  VEF.FORM_CD = C.FORMCD             AND  C.instcd = '111'             AND  C.formprogflag LIKE 'OCR%'             AND  C.formlevlcd != '-'             AND  SUBSTR (C.formtodt, 1, 8) = '99991231'                   ORDER  BY CM.CONSENT_STATE DESC, CM.CREATE_DATETIME DESC]
    148. 

  148. 

  149. [Logging Date Time: 2016-08-26 16:37:43,448] =====================================================================================
    150. 

  150. SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,0586244], param1=[startDt,20010601], param2=[endDt,20160826]]
    151. 

  151. 

  152. [Logging Date Time: 2016-08-26 16:37:43,448] =====================================================================================
    153. 

  153. SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,0586244], param1=[startDt,20010601], param2=[endDt,20160826]]
    154. 

  154. 

  155. [Logging Date Time: 2016-08-26 16:37:43,448] =====================================================================================
    156. 

  156. SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]
    157. 

  157. 

  158. [Logging Date Time: 2016-08-26 16:37:43,448] =====================================================================================
    159. 

  159. SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]
    160.