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
/
.svn
/
text-base
/
eFormServer.iBATIS.log_2016-11-08.svn-base

eFormServer.iBATIS.log_2016-11-08.svn-base 22 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186 
  1. 

  2. [Logging Date Time: 2016-11-08 10:42:10,289] =====================================================================================
    3. 

  3. SQL Command - SetDeptDropdown : OP
    4. 

  4. 

  5. [Logging Date Time: 2016-11-08 10:42:11,197] =====================================================================================
    6. 

  6. SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd,               '진료과' as deptnm,               0 as clincdeptdispseq,               0 as sort               from dual        UNION ALL        SELECT deptcd,               depthngnm as deptnm,               clincdeptdispseq,               1 as sort          FROM com.zsdddept        WHERE instcd =  :param0           AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd                    AND  orddeptflag = 'D'          AND  orduseyn = 'Y'          ORDER BY sort, deptnm]
    7. 

  7. 

  8. [Logging Date Time: 2016-11-08 10:42:11,197] =====================================================================================
    9. 

  9. SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd,               '진료과' as deptnm,               0 as clincdeptdispseq,               0 as sort               from dual        UNION ALL        SELECT deptcd,               depthngnm as deptnm,               clincdeptdispseq,               1 as sort          FROM com.zsdddept        WHERE instcd =  :param0           AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd                    AND  orddeptflag = 'D'          AND  orduseyn = 'Y'          ORDER BY sort, deptnm]
    10. 

  10. 

  11. [Logging Date Time: 2016-11-08 10:42:11,208] =====================================================================================
    12. 

  12. SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]
    13. 

  13. 

  14. [Logging Date Time: 2016-11-08 10:42:11,208] =====================================================================================
    15. 

  15. SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]
    16. 

  16. 

  17. [Logging Date Time: 2016-11-08 10:42:11,208] =====================================================================================
    18. 

  18. SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]]
    19. 

  19. 

  20. [Logging Date Time: 2016-11-08 10:42:11,208] =====================================================================================
    21. 

  21. SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]]
    22. 

  22. 

  23. [Logging Date Time: 2016-11-08 10:42:39,820] =====================================================================================
    24. 

  24. SQL Command - SetDeptDropdown : 
    25. 

  25. 

  26. [Logging Date Time: 2016-11-08 10:42:40,250] =====================================================================================
    27. 

  27. SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd,               '진료과' as deptnm,               0 as clincdeptdispseq,               0 as sort               from dual        UNION ALL        SELECT deptcd,               depthngnm as deptnm,               clincdeptdispseq,               1 as sort          FROM com.zsdddept        WHERE instcd =  :param0           AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd                    AND rcptuseyn = 'Y'          ORDER BY clincdeptdispseq ASC]
    28. 

  28. 

  29. [Logging Date Time: 2016-11-08 10:42:40,250] =====================================================================================
    30. 

  30. SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd,               '진료과' as deptnm,               0 as clincdeptdispseq,               0 as sort               from dual        UNION ALL        SELECT deptcd,               depthngnm as deptnm,               clincdeptdispseq,               1 as sort          FROM com.zsdddept        WHERE instcd =  :param0           AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd                    AND rcptuseyn = 'Y'          ORDER BY clincdeptdispseq ASC]
    31. 

  31. 

  32. [Logging Date Time: 2016-11-08 10:42:40,257] =====================================================================================
    33. 

  33. SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]
    34. 

  34. 

  35. [Logging Date Time: 2016-11-08 10:42:40,257] =====================================================================================
    36. 

  36. SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]
    37. 

  37. 

  38. [Logging Date Time: 2016-11-08 10:42:40,258] =====================================================================================
    39. 

  39. SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]]
    40. 

  40. 

  41. [Logging Date Time: 2016-11-08 10:42:40,258] =====================================================================================
    42. 

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

  43. 

  44. [Logging Date Time: 2016-11-08 10:43:16,305] =====================================================================================
    45. 

  45. SQL Command - SetDeptDropdown : 
    46. 

  46. 

  47. [Logging Date Time: 2016-11-08 10:43:16,324] =====================================================================================
    48. 

  48. SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd,               '진료과' as deptnm,               0 as clincdeptdispseq,               0 as sort               from dual        UNION ALL        SELECT deptcd,               depthngnm as deptnm,               clincdeptdispseq,               1 as sort          FROM com.zsdddept        WHERE instcd =  :param0           AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd                    AND rcptuseyn = 'Y'          ORDER BY clincdeptdispseq ASC]
    49. 

  49. 

  50. [Logging Date Time: 2016-11-08 10:43:16,324] =====================================================================================
    51. 

  51. SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd,               '진료과' as deptnm,               0 as clincdeptdispseq,               0 as sort               from dual        UNION ALL        SELECT deptcd,               depthngnm as deptnm,               clincdeptdispseq,               1 as sort          FROM com.zsdddept        WHERE instcd =  :param0           AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd                    AND rcptuseyn = 'Y'          ORDER BY clincdeptdispseq ASC]
    52. 

  52. 

  53. [Logging Date Time: 2016-11-08 10:43:16,324] =====================================================================================
    54. 

  54. SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]
    55. 

  55. 

  56. [Logging Date Time: 2016-11-08 10:43:16,324] =====================================================================================
    57. 

  57. SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]
    58. 

  58. 

  59. [Logging Date Time: 2016-11-08 10:43:16,324] =====================================================================================
    60. 

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

  61. 

  62. [Logging Date Time: 2016-11-08 10:43:16,324] =====================================================================================
    63. 

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

  64. 

  65. [Logging Date Time: 2016-11-08 10:43:34,361] =====================================================================================
    66. 

  66. SQL Command - SetDeptDropdown : OP
    67. 

  67. 

  68. [Logging Date Time: 2016-11-08 10:43:34,517] =====================================================================================
    69. 

  69. SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd,               '진료과' as deptnm,               0 as clincdeptdispseq,               0 as sort               from dual        UNION ALL        SELECT deptcd,               depthngnm as deptnm,               clincdeptdispseq,               1 as sort          FROM com.zsdddept        WHERE instcd =  :param0           AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd                    AND  orddeptflag = 'D'          AND  orduseyn = 'Y'          ORDER BY sort, deptnm]
    70. 

  70. 

  71. [Logging Date Time: 2016-11-08 10:43:34,517] =====================================================================================
    72. 

  72. SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd,               '진료과' as deptnm,               0 as clincdeptdispseq,               0 as sort               from dual        UNION ALL        SELECT deptcd,               depthngnm as deptnm,               clincdeptdispseq,               1 as sort          FROM com.zsdddept        WHERE instcd =  :param0           AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd                    AND  orddeptflag = 'D'          AND  orduseyn = 'Y'          ORDER BY sort, deptnm]
    73. 

  73. 

  74. [Logging Date Time: 2016-11-08 10:43:34,517] =====================================================================================
    75. 

  75. SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]
    76. 

  76. 

  77. [Logging Date Time: 2016-11-08 10:43:34,517] =====================================================================================
    78. 

  78. SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]
    79. 

  79. 

  80. [Logging Date Time: 2016-11-08 10:43:34,517] =====================================================================================
    81. 

  81. SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]]
    82. 

  82. 

  83. [Logging Date Time: 2016-11-08 10:43:34,517] =====================================================================================
    84. 

  84. SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]]
    85. 

  85. 

  86. [Logging Date Time: 2016-11-08 10:55:45,369] =====================================================================================
    87. 

  87. SQL Command - SetDeptDropdown : OP
    88. 

  88. 

  89. [Logging Date Time: 2016-11-08 10:55:45,908] =====================================================================================
    90. 

  90. SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd,               '진료과' as deptnm,               0 as clincdeptdispseq,               0 as sort               from dual        UNION ALL        SELECT deptcd,               depthngnm as deptnm,               clincdeptdispseq,               1 as sort          FROM com.zsdddept        WHERE instcd =  :param0           AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd                    AND  orddeptflag = 'D'          AND  orduseyn = 'Y'          ORDER BY sort, deptnm]
    91. 

  91. 

  92. [Logging Date Time: 2016-11-08 10:55:45,908] =====================================================================================
    93. 

  93. SQL Command - Statement Id: [getDeptList] PreparedStatement : [SELECT ' ' as deptcd,               '진료과' as deptnm,               0 as clincdeptdispseq,               0 as sort               from dual        UNION ALL        SELECT deptcd,               depthngnm as deptnm,               clincdeptdispseq,               1 as sort          FROM com.zsdddept        WHERE instcd =  :param0           AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')>=valifromdd AND TO_CHAR(CURRENT_DATE,'YYYYMMDD')<=valitodd                    AND  orddeptflag = 'D'          AND  orduseyn = 'Y'          ORDER BY sort, deptnm]
    94. 

  94. 

  95. [Logging Date Time: 2016-11-08 10:55:45,916] =====================================================================================
    96. 

  96. SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]
    97. 

  97. 

  98. [Logging Date Time: 2016-11-08 10:55:45,916] =====================================================================================
    99. 

  99. SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]
    100. 

  100. 

  101. [Logging Date Time: 2016-11-08 10:55:45,916] =====================================================================================
    102. 

  102. SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]]
    103. 

  103. 

  104. [Logging Date Time: 2016-11-08 10:55:45,916] =====================================================================================
    105. 

  105. SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]]
    106. 

  106. 

  107. [Logging Date Time: 2016-11-08 10:55:49,267] =====================================================================================
    108. 

  108. SQL Command - SetDoctorList : deptCd[2060000000]
    109. 

  109. 

  110. [Logging Date Time: 2016-11-08 10:55:49,267] =====================================================================================
    111. 

  111. SQL Command - SetDoctorList : deptNm[신경외과]
    112. 

  112. 

  113. [Logging Date Time: 2016-11-08 10:55:49,267] =====================================================================================
    114. 

  114. SQL Command - SetDoctorList : srchdd[2016-11-08]
    115. 

  115. 

  116. [Logging Date Time: 2016-11-08 10:55:49,286] =====================================================================================
    117. 

  117. SQL Command - Statement Id: [getDocList] PreparedStatement : [SELECT ' ' as doctorid,               '진료의' as doctornm,               1 as sort               from dual        UNION ALL        SELECT b.userid       AS doctorid,                 b.usernm       AS doctornm,                 2 as sort            FROM com.zsumusrd a                 INNER JOIN com.zsumusrb b ON  a.userid  = b.userid           WHERE a.psnworkyn = 'N'             AND a.dutplceinstcd =  :param0              AND a.jobkindcd LIKE '03%'                                     AND a.dutplcecd =  :param1                                   AND  :param2  BETWEEN a.fromdd AND a.todd             AND  :param2  BETWEEN b.userfromdd AND b.usertodd        ORDER BY sort, doctorid]
    118. 

  118. 

  119. [Logging Date Time: 2016-11-08 10:55:49,286] =====================================================================================
    120. 

  120. SQL Command - Statement Id: [getDocList] PreparedStatement : [SELECT ' ' as doctorid,               '진료의' as doctornm,               1 as sort               from dual        UNION ALL        SELECT b.userid       AS doctorid,                 b.usernm       AS doctornm,                 2 as sort            FROM com.zsumusrd a                 INNER JOIN com.zsumusrb b ON  a.userid  = b.userid           WHERE a.psnworkyn = 'N'             AND a.dutplceinstcd =  :param0              AND a.jobkindcd LIKE '03%'                                     AND a.dutplcecd =  :param1                                   AND  :param2  BETWEEN a.fromdd AND a.todd             AND  :param2  BETWEEN b.userfromdd AND b.usertodd        ORDER BY sort, doctorid]
    121. 

  121. 

  122. [Logging Date Time: 2016-11-08 10:55:49,286] =====================================================================================
    123. 

  123. SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd,2060000000], param2=[srchdd,20161108]]
    124. 

  124. 

  125. [Logging Date Time: 2016-11-08 10:55:49,286] =====================================================================================
    126. 

  126. SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd,2060000000], param2=[srchdd,20161108]]
    127. 

  127. 

  128. [Logging Date Time: 2016-11-08 10:55:49,286] =====================================================================================
    129. 

  129. SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]
    130. 

  130. 

  131. [Logging Date Time: 2016-11-08 10:55:49,286] =====================================================================================
    132. 

  132. SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]
    133. 

  133. 

  134. [Logging Date Time: 2016-11-08 10:55:52,675] =====================================================================================
    135. 

  135. SQL Command - SetDoctorList : deptCd[2010300000]
    136. 

  136. 

  137. [Logging Date Time: 2016-11-08 10:55:52,675] =====================================================================================
    138. 

  138. SQL Command - SetDoctorList : deptNm[소화기내과]
    139. 

  139. 

  140. [Logging Date Time: 2016-11-08 10:55:52,675] =====================================================================================
    141. 

  141. SQL Command - SetDoctorList : srchdd[2016-11-08]
    142. 

  142. 

  143. [Logging Date Time: 2016-11-08 10:55:52,689] =====================================================================================
    144. 

  144. SQL Command - Statement Id: [getDocList] PreparedStatement : [SELECT ' ' as doctorid,               '진료의' as doctornm,               1 as sort               from dual        UNION ALL        SELECT b.userid       AS doctorid,                 b.usernm       AS doctornm,                 2 as sort            FROM com.zsumusrd a                 INNER JOIN com.zsumusrb b ON  a.userid  = b.userid           WHERE a.psnworkyn = 'N'             AND a.dutplceinstcd =  :param0              AND a.jobkindcd LIKE '03%'                                     AND a.dutplcecd =  :param1                                   AND  :param2  BETWEEN a.fromdd AND a.todd             AND  :param2  BETWEEN b.userfromdd AND b.usertodd        ORDER BY sort, doctorid]
    145. 

  145. 

  146. [Logging Date Time: 2016-11-08 10:55:52,689] =====================================================================================
    147. 

  147. SQL Command - Statement Id: [getDocList] PreparedStatement : [SELECT ' ' as doctorid,               '진료의' as doctornm,               1 as sort               from dual        UNION ALL        SELECT b.userid       AS doctorid,                 b.usernm       AS doctornm,                 2 as sort            FROM com.zsumusrd a                 INNER JOIN com.zsumusrb b ON  a.userid  = b.userid           WHERE a.psnworkyn = 'N'             AND a.dutplceinstcd =  :param0              AND a.jobkindcd LIKE '03%'                                     AND a.dutplcecd =  :param1                                   AND  :param2  BETWEEN a.fromdd AND a.todd             AND  :param2  BETWEEN b.userfromdd AND b.usertodd        ORDER BY sort, doctorid]
    148. 

  148. 

  149. [Logging Date Time: 2016-11-08 10:55:52,689] =====================================================================================
    150. 

  150. SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd,2010300000], param2=[srchdd,20161108]]
    151. 

  151. 

  152. [Logging Date Time: 2016-11-08 10:55:52,689] =====================================================================================
    153. 

  153. SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd,2010300000], param2=[srchdd,20161108]]
    154. 

  154. 

  155. [Logging Date Time: 2016-11-08 10:55:52,689] =====================================================================================
    156. 

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

  157. 

  158. [Logging Date Time: 2016-11-08 10:55:52,689] =====================================================================================
    159. 

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

  160. 

  161. [Logging Date Time: 2016-11-08 10:55:57,138] =====================================================================================
    162. 

  162. SQL Command - SetDoctorList : deptCd[2010300000]
    163. 

  163. 

  164. [Logging Date Time: 2016-11-08 10:55:57,139] =====================================================================================
    165. 

  165. SQL Command - SetDoctorList : deptNm[소화기내과]
    166. 

  166. 

  167. [Logging Date Time: 2016-11-08 10:55:57,139] =====================================================================================
    168. 

  168. SQL Command - SetDoctorList : srchdd[2016-11-08]
    169. 

  169. 

  170. [Logging Date Time: 2016-11-08 10:55:57,161] =====================================================================================
    171. 

  171. SQL Command - Statement Id: [getDocList] PreparedStatement : [SELECT ' ' as doctorid,               '진료의' as doctornm,               1 as sort               from dual        UNION ALL        SELECT b.userid       AS doctorid,                 b.usernm       AS doctornm,                 2 as sort            FROM com.zsumusrd a                 INNER JOIN com.zsumusrb b ON  a.userid  = b.userid           WHERE a.psnworkyn = 'N'             AND a.dutplceinstcd =  :param0              AND a.jobkindcd LIKE '03%'                                     AND a.dutplcecd =  :param1                                   AND  :param2  BETWEEN a.fromdd AND a.todd             AND  :param2  BETWEEN b.userfromdd AND b.usertodd        ORDER BY sort, doctorid]
    172. 

  172. 

  173. [Logging Date Time: 2016-11-08 10:55:57,161] =====================================================================================
    174. 

  174. SQL Command - Statement Id: [getDocList] PreparedStatement : [SELECT ' ' as doctorid,               '진료의' as doctornm,               1 as sort               from dual        UNION ALL        SELECT b.userid       AS doctorid,                 b.usernm       AS doctornm,                 2 as sort            FROM com.zsumusrd a                 INNER JOIN com.zsumusrb b ON  a.userid  = b.userid           WHERE a.psnworkyn = 'N'             AND a.dutplceinstcd =  :param0              AND a.jobkindcd LIKE '03%'                                     AND a.dutplcecd =  :param1                                   AND  :param2  BETWEEN a.fromdd AND a.todd             AND  :param2  BETWEEN b.userfromdd AND b.usertodd        ORDER BY sort, doctorid]
    175. 

  175. 

  176. [Logging Date Time: 2016-11-08 10:55:57,161] =====================================================================================
    177. 

  177. SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd,2010300000], param2=[srchdd,20161108]]
    178. 

  178. 

  179. [Logging Date Time: 2016-11-08 10:55:57,161] =====================================================================================
    180. 

  180. SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd,2010300000], param2=[srchdd,20161108]]
    181. 

  181. 

  182. [Logging Date Time: 2016-11-08 10:55:57,161] =====================================================================================
    183. 

  183. SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]
    184. 

  184. 

  185. [Logging Date Time: 2016-11-08 10:55:57,161] =====================================================================================
    186. 

  186. SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]
    187.