ConsentDemoServer/CLIP.e-Form.Consent.Web/Logs/eFormServer.iBATIS.log_2016-11-08

[Logging Date Time: 2016-11-08 10:42:10,289] =====================================================================================
SQL Command - SetDeptDropdown : OP

[Logging Date Time: 2016-11-08 10:42:11,197] =====================================================================================
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]

[Logging Date Time: 2016-11-08 10:42:11,197] =====================================================================================
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]

[Logging Date Time: 2016-11-08 10:42:11,208] =====================================================================================
SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]

[Logging Date Time: 2016-11-08 10:42:11,208] =====================================================================================
SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]

[Logging Date Time: 2016-11-08 10:42:11,208] =====================================================================================
SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-08 10:42:11,208] =====================================================================================
SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-08 10:42:39,820] =====================================================================================
SQL Command - SetDeptDropdown : 

[Logging Date Time: 2016-11-08 10:42:40,250] =====================================================================================
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]

[Logging Date Time: 2016-11-08 10:42:40,250] =====================================================================================
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]

[Logging Date Time: 2016-11-08 10:42:40,257] =====================================================================================
SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]

[Logging Date Time: 2016-11-08 10:42:40,257] =====================================================================================
SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]

[Logging Date Time: 2016-11-08 10:42:40,258] =====================================================================================
SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-08 10:42:40,258] =====================================================================================
SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-08 10:43:16,305] =====================================================================================
SQL Command - SetDeptDropdown : 

[Logging Date Time: 2016-11-08 10:43:16,324] =====================================================================================
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]

[Logging Date Time: 2016-11-08 10:43:16,324] =====================================================================================
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]

[Logging Date Time: 2016-11-08 10:43:16,324] =====================================================================================
SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]

[Logging Date Time: 2016-11-08 10:43:16,324] =====================================================================================
SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]

[Logging Date Time: 2016-11-08 10:43:16,324] =====================================================================================
SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-08 10:43:16,324] =====================================================================================
SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-08 10:43:34,361] =====================================================================================
SQL Command - SetDeptDropdown : OP

[Logging Date Time: 2016-11-08 10:43:34,517] =====================================================================================
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]

[Logging Date Time: 2016-11-08 10:43:34,517] =====================================================================================
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]

[Logging Date Time: 2016-11-08 10:43:34,517] =====================================================================================
SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]

[Logging Date Time: 2016-11-08 10:43:34,517] =====================================================================================
SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]

[Logging Date Time: 2016-11-08 10:43:34,517] =====================================================================================
SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-08 10:43:34,517] =====================================================================================
SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-08 10:55:45,369] =====================================================================================
SQL Command - SetDeptDropdown : OP

[Logging Date Time: 2016-11-08 10:55:45,908] =====================================================================================
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]

[Logging Date Time: 2016-11-08 10:55:45,908] =====================================================================================
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]

[Logging Date Time: 2016-11-08 10:55:45,916] =====================================================================================
SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]

[Logging Date Time: 2016-11-08 10:55:45,916] =====================================================================================
SQL Command - Statement Id: [getDeptList] Parameters: [param0=[instcd,111]]

[Logging Date Time: 2016-11-08 10:55:45,916] =====================================================================================
SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-08 10:55:45,916] =====================================================================================
SQL Command - Statement Id: [getDeptList] Types: [param0=[AnsiString, System.String]]

[Logging Date Time: 2016-11-08 10:55:49,267] =====================================================================================
SQL Command - SetDoctorList : deptCd[2060000000]

[Logging Date Time: 2016-11-08 10:55:49,267] =====================================================================================
SQL Command - SetDoctorList : deptNm[신경외과]

[Logging Date Time: 2016-11-08 10:55:49,267] =====================================================================================
SQL Command - SetDoctorList : srchdd[2016-11-08]

[Logging Date Time: 2016-11-08 10:55:49,286] =====================================================================================
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]

[Logging Date Time: 2016-11-08 10:55:49,286] =====================================================================================
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]

[Logging Date Time: 2016-11-08 10:55:49,286] =====================================================================================
SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd,2060000000], param2=[srchdd,20161108]]

[Logging Date Time: 2016-11-08 10:55:49,286] =====================================================================================
SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd,2060000000], param2=[srchdd,20161108]]

[Logging Date Time: 2016-11-08 10:55:49,286] =====================================================================================
SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]

[Logging Date Time: 2016-11-08 10:55:49,286] =====================================================================================
SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]

[Logging Date Time: 2016-11-08 10:55:52,675] =====================================================================================
SQL Command - SetDoctorList : deptCd[2010300000]

[Logging Date Time: 2016-11-08 10:55:52,675] =====================================================================================
SQL Command - SetDoctorList : deptNm[소화기내과]

[Logging Date Time: 2016-11-08 10:55:52,675] =====================================================================================
SQL Command - SetDoctorList : srchdd[2016-11-08]

[Logging Date Time: 2016-11-08 10:55:52,689] =====================================================================================
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]

[Logging Date Time: 2016-11-08 10:55:52,689] =====================================================================================
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]

[Logging Date Time: 2016-11-08 10:55:52,689] =====================================================================================
SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd,2010300000], param2=[srchdd,20161108]]

[Logging Date Time: 2016-11-08 10:55:52,689] =====================================================================================
SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd,2010300000], param2=[srchdd,20161108]]

[Logging Date Time: 2016-11-08 10:55:52,689] =====================================================================================
SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]

[Logging Date Time: 2016-11-08 10:55:52,689] =====================================================================================
SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]

[Logging Date Time: 2016-11-08 10:55:57,138] =====================================================================================
SQL Command - SetDoctorList : deptCd[2010300000]

[Logging Date Time: 2016-11-08 10:55:57,139] =====================================================================================
SQL Command - SetDoctorList : deptNm[소화기내과]

[Logging Date Time: 2016-11-08 10:55:57,139] =====================================================================================
SQL Command - SetDoctorList : srchdd[2016-11-08]

[Logging Date Time: 2016-11-08 10:55:57,161] =====================================================================================
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]

[Logging Date Time: 2016-11-08 10:55:57,161] =====================================================================================
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]

[Logging Date Time: 2016-11-08 10:55:57,161] =====================================================================================
SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd,2010300000], param2=[srchdd,20161108]]

[Logging Date Time: 2016-11-08 10:55:57,161] =====================================================================================
SQL Command - Statement Id: [getDocList] Parameters: [param0=[instcd,111], param1=[orddeptcd,2010300000], param2=[srchdd,20161108]]

[Logging Date Time: 2016-11-08 10:55:57,161] =====================================================================================
SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]

[Logging Date Time: 2016-11-08 10:55:57,161] =====================================================================================
SQL Command - Statement Id: [getDocList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]