[Logging Date Time: 2016-08-26 16:33:58,179] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] Parameters: [param0=[patientCode,0586244], param1=[clnDate,20150615], param2=[bp,01], param3=[dm,01], param4=[heart,01], param5=[kidney,01], param6=[respiration,02], param7=[hx,02], param8=[allergy,02], param9=[drug,02], param10=[smoking,02], param11=[idio,02], param12=[nacrotics,02], param13=[airway,02], param14=[hemorrhage,02], param15=[status_etc,어쩌구], param16=[userId,103043]] [Logging Date Time: 2016-08-26 16:33:58,192] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] 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], param10=[AnsiString, System.String], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[AnsiString, System.String], param16=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:33:58,192] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] 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], param10=[AnsiString, System.String], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[AnsiString, System.String], param16=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:33:58,303] ===================================================================================== SQL Command - Statement Id: [setFileName] PreparedStatement : [declare I_PID VARCHAR2(10) := :param0 ; I_IOFLAG VARCHAR2(1) := :param1 ; I_ORDDD VARCHAR2(8) := :param2 ; I_DSCHDD VARCHAR2(8) := :param3 ; I_CRETNO NUMBER(10) := :param4 ; I_FILESIZE NUMBER(18) := :param5 ; I_FORMCD VARCHAR2(10) := :param6 ; I_PAGE NUMBER(18) := :param7 ; I_OCRCODE VARCHAR2(13) := :param8 ; I_USERID VARCHAR2(10) := :param9 ; begin EMR.LCTECH_PROCESS(I_PID, I_IOFLAG, I_ORDDD, I_DSCHDD, I_CRETNO, I_FILESIZE, I_FORMCD, I_PAGE, I_OCRCODE, I_USERID); end;] [Logging Date Time: 2016-08-26 16:33:58,303] ===================================================================================== SQL Command - Statement Id: [setFileName] PreparedStatement : [declare I_PID VARCHAR2(10) := :param0 ; I_IOFLAG VARCHAR2(1) := :param1 ; I_ORDDD VARCHAR2(8) := :param2 ; I_DSCHDD VARCHAR2(8) := :param3 ; I_CRETNO NUMBER(10) := :param4 ; I_FILESIZE NUMBER(18) := :param5 ; I_FORMCD VARCHAR2(10) := :param6 ; I_PAGE NUMBER(18) := :param7 ; I_OCRCODE VARCHAR2(13) := :param8 ; I_USERID VARCHAR2(10) := :param9 ; begin EMR.LCTECH_PROCESS(I_PID, I_IOFLAG, I_ORDDD, I_DSCHDD, I_CRETNO, I_FILESIZE, I_FORMCD, I_PAGE, I_OCRCODE, I_USERID); end;] [Logging Date Time: 2016-08-26 16:33:58,303] ===================================================================================== 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,0], param8=[ocrtag,2016082689390], param9=[userid,103043]] [Logging Date Time: 2016-08-26 16:33:58,303] ===================================================================================== 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,0], param8=[ocrtag,2016082689390], param9=[userid,103043]] [Logging Date Time: 2016-08-26 16:33:58,303] ===================================================================================== 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]] [Logging Date Time: 2016-08-26 16:33:58,303] ===================================================================================== 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]] [Logging Date Time: 2016-08-26 16:33:58,307] ===================================================================================== 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'] [Logging Date Time: 2016-08-26 16:33:58,307] ===================================================================================== 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'] [Logging Date Time: 2016-08-26 16:33:58,307] ===================================================================================== SQL Command - Statement Id: [getFileName] Parameters: [param0=[pid,0586244], param1=[ordtype,I], param2=[orddd,20150615], param3=[dschdd,20150815], param4=[formcd,1300009935], param5=[ocrtag,2016082689390], param6=[pageno,0]] [Logging Date Time: 2016-08-26 16:33:58,307] ===================================================================================== SQL Command - Statement Id: [getFileName] Parameters: [param0=[pid,0586244], param1=[ordtype,I], param2=[orddd,20150615], param3=[dschdd,20150815], param4=[formcd,1300009935], param5=[ocrtag,2016082689390], param6=[pageno,0]] [Logging Date Time: 2016-08-26 16:33:58,307] ===================================================================================== 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]] [Logging Date Time: 2016-08-26 16:33:58,307] ===================================================================================== 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]] [Logging Date Time: 2016-08-26 16:33:58,335] ===================================================================================== 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] [Logging Date Time: 2016-08-26 16:33:58,335] ===================================================================================== 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] [Logging Date Time: 2016-08-26 16:33:58,335] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_IMAGE]] [Logging Date Time: 2016-08-26 16:33:58,335] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_IMAGE]] [Logging Date Time: 2016-08-26 16:33:58,335] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:33:58,335] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:33:58,337] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE set ud1_num = :param0 where main_cd = 'SEQUENCE' and sub_cd = :param1] [Logging Date Time: 2016-08-26 16:33:58,337] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE set ud1_num = :param0 where main_cd = 'SEQUENCE' and sub_cd = :param1] [Logging Date Time: 2016-08-26 16:33:58,338] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,153], param1=[sub_cd,CONSENT_IMAGE]] [Logging Date Time: 2016-08-26 16:33:58,338] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,153], param1=[sub_cd,CONSENT_IMAGE]] [Logging Date Time: 2016-08-26 16:33:58,338] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:33:58,338] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:33:58,340] ===================================================================================== 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') )] [Logging Date Time: 2016-08-26 16:33:58,340] ===================================================================================== 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') )] [Logging Date Time: 2016-08-26 16:33:58,340] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_IMAGE] Parameters: [param0=[consentImageRid,153], param1=[consentMstRid,129], param2=[formRid,184], param3=[imagePath,Image3\fnuImage\201608\26], param4=[imageFilename,100502074.jpg], param5=[completeYn,Y], param6=[userId,103043]] [Logging Date Time: 2016-08-26 16:33:58,340] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_IMAGE] Parameters: [param0=[consentImageRid,153], param1=[consentMstRid,129], param2=[formRid,184], param3=[imagePath,Image3\fnuImage\201608\26], param4=[imageFilename,100502074.jpg], param5=[completeYn,Y], param6=[userId,103043]] [Logging Date Time: 2016-08-26 16:33:58,340] ===================================================================================== 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]] [Logging Date Time: 2016-08-26 16:33:58,340] ===================================================================================== 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]] [Logging Date Time: 2016-08-26 16:33:58,436] ===================================================================================== SQL Command - CLIP.eForm File Upload: Image3\fnuImage\201608\26\100502074.jpg [Logging Date Time: 2016-08-26 16:33:58,437] ===================================================================================== SQL Command - CLIP.eForm File Upload: C:\@bin\@DFH\DFH-Consent\CLIP.e-Form.Consent.Dfh.Web\ [Logging Date Time: 2016-08-26 16:33:58,447] ===================================================================================== SQL Command - CLIP.eForm error: 'C:\@bin\@DFH\DFH-Consent\CLIP.e-Form.Consent.Dfh.Web\' 경로의 일부를 찾을 수 없습니다. [Logging Date Time: 2016-08-26 16:34:56,190] ===================================================================================== 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] [Logging Date Time: 2016-08-26 16:34:56,190] ===================================================================================== 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] [Logging Date Time: 2016-08-26 16:34:56,190] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_MST]] [Logging Date Time: 2016-08-26 16:34:56,190] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_MST]] [Logging Date Time: 2016-08-26 16:34:56,190] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:34:56,190] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:34:56,194] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE set ud1_num = :param0 where main_cd = 'SEQUENCE' and sub_cd = :param1] [Logging Date Time: 2016-08-26 16:34:56,194] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE set ud1_num = :param0 where main_cd = 'SEQUENCE' and sub_cd = :param1] [Logging Date Time: 2016-08-26 16:34:56,195] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,130], param1=[sub_cd,CONSENT_MST]] [Logging Date Time: 2016-08-26 16:34:56,195] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,130], param1=[sub_cd,CONSENT_MST]] [Logging Date Time: 2016-08-26 16:34:56,195] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:34:56,195] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:34:56,196] ===================================================================================== 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] [Logging Date Time: 2016-08-26 16:34:56,196] ===================================================================================== 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] [Logging Date Time: 2016-08-26 16:34:56,196] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-08-26 16:34:56,196] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-08-26 16:34:56,196] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:34:56,196] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:34:56,202] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE set ud1_num = :param0 where main_cd = 'SEQUENCE' and sub_cd = :param1] [Logging Date Time: 2016-08-26 16:34:56,202] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE set ud1_num = :param0 where main_cd = 'SEQUENCE' and sub_cd = :param1] [Logging Date Time: 2016-08-26 16:34:56,202] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,166], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-08-26 16:34:56,202] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,166], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-08-26 16:34:56,202] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:34:56,202] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:34:56,216] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_MST] PreparedStatement : [insert into CONSENT_MST ( CONSENT_MST_RID, HOS_TYPE, PID, VISIT_TYPE, ORDER_NO, ORDER_NAME, ORDER_CD, OCR_NUMBER, CLN_DEPT_CD, CLN_DATE, CRETNO, WARDCD, ROOMCD, FORM_RID, CONSENT_STATE, COMPLETE_YN, COMPLETE_DATETIME, PAPER_YN, REISSUE_YN, REISSUE_CONSENT_MST_RID, REWRITE_YN, REWRITE_CONSENT_MST_RID, USE_YN, CREATE_USER_ID, CREATE_DATETIME, MODIFY_USER_ID, MODIFY_DATETIME, CREATE_USER_NAME, MODIFY_USER_NAME ) values ( :param0 , :param1 , :param2 , :param3 , :param4 , :param5 , :param6 , :param7 , :param8 , :param9 , :param10 , :param11 , :param12 , :param13 , :param14 , :param15 , '', :param16 , :param17 , :param18 , :param19 , :param20 , 'Y', :param21 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param21 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param22 , :param23 )] [Logging Date Time: 2016-08-26 16:34:56,216] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_MST] PreparedStatement : [insert into CONSENT_MST ( CONSENT_MST_RID, HOS_TYPE, PID, VISIT_TYPE, ORDER_NO, ORDER_NAME, ORDER_CD, OCR_NUMBER, CLN_DEPT_CD, CLN_DATE, CRETNO, WARDCD, ROOMCD, FORM_RID, CONSENT_STATE, COMPLETE_YN, COMPLETE_DATETIME, PAPER_YN, REISSUE_YN, REISSUE_CONSENT_MST_RID, REWRITE_YN, REWRITE_CONSENT_MST_RID, USE_YN, CREATE_USER_ID, CREATE_DATETIME, MODIFY_USER_ID, MODIFY_DATETIME, CREATE_USER_NAME, MODIFY_USER_NAME ) values ( :param0 , :param1 , :param2 , :param3 , :param4 , :param5 , :param6 , :param7 , :param8 , :param9 , :param10 , :param11 , :param12 , :param13 , :param14 , :param15 , '', :param16 , :param17 , :param18 , :param19 , :param20 , 'Y', :param21 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param21 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param22 , :param23 )] [Logging Date Time: 2016-08-26 16:34:56,217] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_MST] Parameters: [param0=[consentMstRid,130], param1=[hosType,111], param2=[patientCode,0586244], param3=[vistType,I], param4=[orderNo,111], param5=[orderName,null], param6=[orderCd,null], param7=[ocrCode,2016082689390], param8=[clnDeptCd,2040000000], param9=[clnDate,20150615], param10=[cretno,1], param11=[ward,82], param12=[roomcd,832], param13=[formRid,184], param14=[consentState,TEMP], param15=[completeYn,N], param16=[paperYn,N], param17=[reissueYn,N], param18=[reissueConsentMstRid,0], param19=[rewriteYn,N], param20=[rewriteConsentMstRid,0], param21=[userId,103043], param22=[createUserName,이중기], param23=[modifyUserName,이중기]] [Logging Date Time: 2016-08-26 16:34:56,217] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_MST] Parameters: [param0=[consentMstRid,130], param1=[hosType,111], param2=[patientCode,0586244], param3=[vistType,I], param4=[orderNo,111], param5=[orderName,null], param6=[orderCd,null], param7=[ocrCode,2016082689390], param8=[clnDeptCd,2040000000], param9=[clnDate,20150615], param10=[cretno,1], param11=[ward,82], param12=[roomcd,832], param13=[formRid,184], param14=[consentState,TEMP], param15=[completeYn,N], param16=[paperYn,N], param17=[reissueYn,N], param18=[reissueConsentMstRid,0], param19=[rewriteYn,N], param20=[rewriteConsentMstRid,0], param21=[userId,103043], param22=[createUserName,이중기], param23=[modifyUserName,이중기]] [Logging Date Time: 2016-08-26 16:34:56,217] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_MST] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[Int32, System.Int32], param5=[System.DBNull, null], param6=[System.DBNull, null], param7=[AnsiString, System.String], param8=[AnsiString, System.String], param9=[AnsiString, System.String], param10=[Int32, System.Int32], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[Int32, System.Int32], param14=[AnsiString, System.String], param15=[AnsiString, System.String], param16=[AnsiString, System.String], param17=[AnsiString, System.String], param18=[Int32, System.Int32], param19=[AnsiString, System.String], param20=[Int32, System.Int32], param21=[AnsiString, System.String], param22=[AnsiString, System.String], param23=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:34:56,217] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_MST] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[Int32, System.Int32], param5=[System.DBNull, null], param6=[System.DBNull, null], param7=[AnsiString, System.String], param8=[AnsiString, System.String], param9=[AnsiString, System.String], param10=[Int32, System.Int32], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[Int32, System.Int32], param14=[AnsiString, System.String], param15=[AnsiString, System.String], param16=[AnsiString, System.String], param17=[AnsiString, System.String], param18=[Int32, System.Int32], param19=[AnsiString, System.String], param20=[Int32, System.Int32], param21=[AnsiString, System.String], param22=[AnsiString, System.String], param23=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:34:56,220] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] PreparedStatement : [insert into CONSENT_DATA ( CONSENT_DATA_RID, CONSENT_MST_RID, FORM_RID, DEVICE_TYPE, DEVICE_IDENT_NO, COMPLETE_YN, CREATE_USER_ID, CREATE_DATETIME, FORM_XML, DATA_XML ) values ( :param0 , :param1 , :param2 , :param3 , :param4 , :param5 , :param6 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param7 , :param8 )] [Logging Date Time: 2016-08-26 16:34:56,220] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] PreparedStatement : [insert into CONSENT_DATA ( CONSENT_DATA_RID, CONSENT_MST_RID, FORM_RID, DEVICE_TYPE, DEVICE_IDENT_NO, COMPLETE_YN, CREATE_USER_ID, CREATE_DATETIME, FORM_XML, DATA_XML ) values ( :param0 , :param1 , :param2 , :param3 , :param4 , :param5 , :param6 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param7 , :param8 )] [Logging Date Time: 2016-08-26 16:34:56,220] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,166], param1=[consentMstRid,130], param2=[formRid,184], param3=[deviceType,WIN], param4=[deviceIdentNo,CHLEE-PC], param5=[completeYn,N], param6=[userId,103043], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]] [Logging Date Time: 2016-08-26 16:34:56,220] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,166], param1=[consentMstRid,130], param2=[formRid,184], param3=[deviceType,WIN], param4=[deviceIdentNo,CHLEE-PC], param5=[completeYn,N], param6=[userId,103043], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]] [Logging Date Time: 2016-08-26 16:34:56,220] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] 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], param7=[Binary, System.Byte[]], param8=[Binary, System.Byte[]]] [Logging Date Time: 2016-08-26 16:34:56,220] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] 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], param7=[Binary, System.Byte[]], param8=[Binary, System.Byte[]]] [Logging Date Time: 2016-08-26 16:34:56,290] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] PreparedStatement : [DECLARE v_cnt NUMBER:=0; BEGIN SELECT COUNT(*) INTO V_CNT FROM CONSENT_DATA_EX WHERE PID = :param0 AND CLN_DATE = :param1 ; IF v_cnt = 0 THEN insert into consent_data_ex (pid, cln_date, use_yn, bp, dm, heart, kidney, respiration, hx, allergy, drug, smoking, idio, nacrotics, airway, hemorrhage, etc, create_user_id, create_datetime, modify_user_id, modify_datetime) values ( :param0 , :param1 ,'Y', :param2 , :param3 , :param4 , :param5 , :param6 , :param7 , :param8 , :param9 , :param10 , :param11 , :param12 , :param13 , :param14 , :param15 , :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss')); ELSE update consent_data_ex set bp = :param2 , dm = :param3 , heart = :param4 , kidney = :param5 , respiration = :param6 , hx = :param7 , allergy = :param8 , drug = :param9 , smoking = :param10 , idio = :param11 , nacrotics = :param12 , airway = :param13 , hemorrhage = :param14 , etc = :param15 , modify_user_id = :param16 , modify_datetime = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss') where PID = :param0 AND CLN_DATE = :param1 ; END IF; END;] [Logging Date Time: 2016-08-26 16:34:56,290] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] PreparedStatement : [DECLARE v_cnt NUMBER:=0; BEGIN SELECT COUNT(*) INTO V_CNT FROM CONSENT_DATA_EX WHERE PID = :param0 AND CLN_DATE = :param1 ; IF v_cnt = 0 THEN insert into consent_data_ex (pid, cln_date, use_yn, bp, dm, heart, kidney, respiration, hx, allergy, drug, smoking, idio, nacrotics, airway, hemorrhage, etc, create_user_id, create_datetime, modify_user_id, modify_datetime) values ( :param0 , :param1 ,'Y', :param2 , :param3 , :param4 , :param5 , :param6 , :param7 , :param8 , :param9 , :param10 , :param11 , :param12 , :param13 , :param14 , :param15 , :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss')); ELSE update consent_data_ex set bp = :param2 , dm = :param3 , heart = :param4 , kidney = :param5 , respiration = :param6 , hx = :param7 , allergy = :param8 , drug = :param9 , smoking = :param10 , idio = :param11 , nacrotics = :param12 , airway = :param13 , hemorrhage = :param14 , etc = :param15 , modify_user_id = :param16 , modify_datetime = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss') where PID = :param0 AND CLN_DATE = :param1 ; END IF; END;] [Logging Date Time: 2016-08-26 16:34:56,291] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] Parameters: [param0=[patientCode,0586244], param1=[clnDate,20150615], param2=[bp,01], param3=[dm,01], param4=[heart,01], param5=[kidney,01], param6=[respiration,02], param7=[hx,02], param8=[allergy,02], param9=[drug,02], param10=[smoking,02], param11=[idio,02], param12=[nacrotics,02], param13=[airway,02], param14=[hemorrhage,02], param15=[status_etc,어쩌구], param16=[userId,103043]] [Logging Date Time: 2016-08-26 16:34:56,291] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] Parameters: [param0=[patientCode,0586244], param1=[clnDate,20150615], param2=[bp,01], param3=[dm,01], param4=[heart,01], param5=[kidney,01], param6=[respiration,02], param7=[hx,02], param8=[allergy,02], param9=[drug,02], param10=[smoking,02], param11=[idio,02], param12=[nacrotics,02], param13=[airway,02], param14=[hemorrhage,02], param15=[status_etc,어쩌구], param16=[userId,103043]] [Logging Date Time: 2016-08-26 16:34:56,291] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] 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], param10=[AnsiString, System.String], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[AnsiString, System.String], param16=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:34:56,291] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] 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], param10=[AnsiString, System.String], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[AnsiString, System.String], param16=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:34:58,095] ===================================================================================== 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] [Logging Date Time: 2016-08-26 16:34:58,095] ===================================================================================== 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] [Logging Date Time: 2016-08-26 16:34:58,096] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,0586244], param1=[startDt,20010601], param2=[endDt,20160826]] [Logging Date Time: 2016-08-26 16:34:58,096] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,0586244], param1=[startDt,20010601], param2=[endDt,20160826]] [Logging Date Time: 2016-08-26 16:34:58,096] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:34:58,096] ===================================================================================== SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:35:00,736] ===================================================================================== 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] [Logging Date Time: 2016-08-26 16:35:00,736] ===================================================================================== 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] [Logging Date Time: 2016-08-26 16:35:00,737] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-08-26 16:35:00,737] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-08-26 16:35:00,737] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:35:00,737] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:35:00,739] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE set ud1_num = :param0 where main_cd = 'SEQUENCE' and sub_cd = :param1] [Logging Date Time: 2016-08-26 16:35:00,739] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE set ud1_num = :param0 where main_cd = 'SEQUENCE' and sub_cd = :param1] [Logging Date Time: 2016-08-26 16:35:00,739] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,167], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-08-26 16:35:00,739] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,167], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-08-26 16:35:00,740] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:35:00,740] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:35:00,748] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] PreparedStatement : [UPDATE CONSENT_MST SET CONSENT_STATE = :param0 , COMPLETE_YN = :param1 , COMPLETE_DATETIME = TO_CHAR(SYSDATE,'YYYY-MM-DD hh24:mi:ss'), PAPER_YN = :param2 , MODIFY_USER_ID = :param3 , MODIFY_DATETIME = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss') WHERE CONSENT_MST_RID = :param4] [Logging Date Time: 2016-08-26 16:35:00,748] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] PreparedStatement : [UPDATE CONSENT_MST SET CONSENT_STATE = :param0 , COMPLETE_YN = :param1 , COMPLETE_DATETIME = TO_CHAR(SYSDATE,'YYYY-MM-DD hh24:mi:ss'), PAPER_YN = :param2 , MODIFY_USER_ID = :param3 , MODIFY_DATETIME = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss') WHERE CONSENT_MST_RID = :param4] [Logging Date Time: 2016-08-26 16:35:00,748] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Parameters: [param0=[consentState,ELECTR_CMP], param1=[completeYn,Y], param2=[paperYn,N], param3=[userId,103043], param4=[consentMstRid,130]] [Logging Date Time: 2016-08-26 16:35:00,748] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Parameters: [param0=[consentState,ELECTR_CMP], param1=[completeYn,Y], param2=[paperYn,N], param3=[userId,103043], param4=[consentMstRid,130]] [Logging Date Time: 2016-08-26 16:35:00,748] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[Int32, System.Int32]] [Logging Date Time: 2016-08-26 16:35:00,748] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[Int32, System.Int32]] [Logging Date Time: 2016-08-26 16:35:00,750] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] PreparedStatement : [insert into CONSENT_DATA ( CONSENT_DATA_RID, CONSENT_MST_RID, FORM_RID, DEVICE_TYPE, DEVICE_IDENT_NO, COMPLETE_YN, CREATE_USER_ID, CREATE_DATETIME, FORM_XML, DATA_XML ) values ( :param0 , :param1 , :param2 , :param3 , :param4 , :param5 , :param6 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param7 , :param8 )] [Logging Date Time: 2016-08-26 16:35:00,750] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] PreparedStatement : [insert into CONSENT_DATA ( CONSENT_DATA_RID, CONSENT_MST_RID, FORM_RID, DEVICE_TYPE, DEVICE_IDENT_NO, COMPLETE_YN, CREATE_USER_ID, CREATE_DATETIME, FORM_XML, DATA_XML ) values ( :param0 , :param1 , :param2 , :param3 , :param4 , :param5 , :param6 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param7 , :param8 )] [Logging Date Time: 2016-08-26 16:35:00,751] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,167], param1=[consentMstRid,130], param2=[formRid,184], param3=[deviceType,WIN], param4=[deviceIdentNo,CHLEE-PC], param5=[completeYn,Y], param6=[userId,103043], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]] [Logging Date Time: 2016-08-26 16:35:00,751] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,167], param1=[consentMstRid,130], param2=[formRid,184], param3=[deviceType,WIN], param4=[deviceIdentNo,CHLEE-PC], param5=[completeYn,Y], param6=[userId,103043], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]] [Logging Date Time: 2016-08-26 16:35:00,751] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] 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], param7=[Binary, System.Byte[]], param8=[Binary, System.Byte[]]] [Logging Date Time: 2016-08-26 16:35:00,751] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] 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], param7=[Binary, System.Byte[]], param8=[Binary, System.Byte[]]] [Logging Date Time: 2016-08-26 16:35:00,816] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] PreparedStatement : [DECLARE v_cnt NUMBER:=0; BEGIN SELECT COUNT(*) INTO V_CNT FROM CONSENT_DATA_EX WHERE PID = :param0 AND CLN_DATE = :param1 ; IF v_cnt = 0 THEN insert into consent_data_ex (pid, cln_date, use_yn, bp, dm, heart, kidney, respiration, hx, allergy, drug, smoking, idio, nacrotics, airway, hemorrhage, etc, create_user_id, create_datetime, modify_user_id, modify_datetime) values ( :param0 , :param1 ,'Y', :param2 , :param3 , :param4 , :param5 , :param6 , :param7 , :param8 , :param9 , :param10 , :param11 , :param12 , :param13 , :param14 , :param15 , :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss')); ELSE update consent_data_ex set bp = :param2 , dm = :param3 , heart = :param4 , kidney = :param5 , respiration = :param6 , hx = :param7 , allergy = :param8 , drug = :param9 , smoking = :param10 , idio = :param11 , nacrotics = :param12 , airway = :param13 , hemorrhage = :param14 , etc = :param15 , modify_user_id = :param16 , modify_datetime = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss') where PID = :param0 AND CLN_DATE = :param1 ; END IF; END;] [Logging Date Time: 2016-08-26 16:35:00,816] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] PreparedStatement : [DECLARE v_cnt NUMBER:=0; BEGIN SELECT COUNT(*) INTO V_CNT FROM CONSENT_DATA_EX WHERE PID = :param0 AND CLN_DATE = :param1 ; IF v_cnt = 0 THEN insert into consent_data_ex (pid, cln_date, use_yn, bp, dm, heart, kidney, respiration, hx, allergy, drug, smoking, idio, nacrotics, airway, hemorrhage, etc, create_user_id, create_datetime, modify_user_id, modify_datetime) values ( :param0 , :param1 ,'Y', :param2 , :param3 , :param4 , :param5 , :param6 , :param7 , :param8 , :param9 , :param10 , :param11 , :param12 , :param13 , :param14 , :param15 , :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss')); ELSE update consent_data_ex set bp = :param2 , dm = :param3 , heart = :param4 , kidney = :param5 , respiration = :param6 , hx = :param7 , allergy = :param8 , drug = :param9 , smoking = :param10 , idio = :param11 , nacrotics = :param12 , airway = :param13 , hemorrhage = :param14 , etc = :param15 , modify_user_id = :param16 , modify_datetime = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss') where PID = :param0 AND CLN_DATE = :param1 ; END IF; END;] [Logging Date Time: 2016-08-26 16:35:00,816] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] Parameters: [param0=[patientCode,0586244], param1=[clnDate,20150615], param2=[bp,01], param3=[dm,01], param4=[heart,01], param5=[kidney,01], param6=[respiration,02], param7=[hx,02], param8=[allergy,02], param9=[drug,02], param10=[smoking,02], param11=[idio,02], param12=[nacrotics,02], param13=[airway,02], param14=[hemorrhage,02], param15=[status_etc,어쩌구], param16=[userId,103043]] [Logging Date Time: 2016-08-26 16:35:00,816] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] Parameters: [param0=[patientCode,0586244], param1=[clnDate,20150615], param2=[bp,01], param3=[dm,01], param4=[heart,01], param5=[kidney,01], param6=[respiration,02], param7=[hx,02], param8=[allergy,02], param9=[drug,02], param10=[smoking,02], param11=[idio,02], param12=[nacrotics,02], param13=[airway,02], param14=[hemorrhage,02], param15=[status_etc,어쩌구], param16=[userId,103043]] [Logging Date Time: 2016-08-26 16:35:00,816] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] 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], param10=[AnsiString, System.String], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[AnsiString, System.String], param16=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:35:00,816] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] 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], param10=[AnsiString, System.String], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[AnsiString, System.String], param16=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:35:00,907] ===================================================================================== SQL Command - Statement Id: [setFileName] PreparedStatement : [declare I_PID VARCHAR2(10) := :param0 ; I_IOFLAG VARCHAR2(1) := :param1 ; I_ORDDD VARCHAR2(8) := :param2 ; I_DSCHDD VARCHAR2(8) := :param3 ; I_CRETNO NUMBER(10) := :param4 ; I_FILESIZE NUMBER(18) := :param5 ; I_FORMCD VARCHAR2(10) := :param6 ; I_PAGE NUMBER(18) := :param7 ; I_OCRCODE VARCHAR2(13) := :param8 ; I_USERID VARCHAR2(10) := :param9 ; begin EMR.LCTECH_PROCESS(I_PID, I_IOFLAG, I_ORDDD, I_DSCHDD, I_CRETNO, I_FILESIZE, I_FORMCD, I_PAGE, I_OCRCODE, I_USERID); end;] [Logging Date Time: 2016-08-26 16:35:00,907] ===================================================================================== SQL Command - Statement Id: [setFileName] PreparedStatement : [declare I_PID VARCHAR2(10) := :param0 ; I_IOFLAG VARCHAR2(1) := :param1 ; I_ORDDD VARCHAR2(8) := :param2 ; I_DSCHDD VARCHAR2(8) := :param3 ; I_CRETNO NUMBER(10) := :param4 ; I_FILESIZE NUMBER(18) := :param5 ; I_FORMCD VARCHAR2(10) := :param6 ; I_PAGE NUMBER(18) := :param7 ; I_OCRCODE VARCHAR2(13) := :param8 ; I_USERID VARCHAR2(10) := :param9 ; begin EMR.LCTECH_PROCESS(I_PID, I_IOFLAG, I_ORDDD, I_DSCHDD, I_CRETNO, I_FILESIZE, I_FORMCD, I_PAGE, I_OCRCODE, I_USERID); end;] [Logging Date Time: 2016-08-26 16:35:00,907] ===================================================================================== 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,0], param8=[ocrtag,2016082689390], param9=[userid,103043]] [Logging Date Time: 2016-08-26 16:35:00,907] ===================================================================================== 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,0], param8=[ocrtag,2016082689390], param9=[userid,103043]] [Logging Date Time: 2016-08-26 16:35:00,907] ===================================================================================== 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]] [Logging Date Time: 2016-08-26 16:35:00,907] ===================================================================================== 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]] [Logging Date Time: 2016-08-26 16:35:00,912] ===================================================================================== 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'] [Logging Date Time: 2016-08-26 16:35:00,912] ===================================================================================== 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'] [Logging Date Time: 2016-08-26 16:35:00,912] ===================================================================================== SQL Command - Statement Id: [getFileName] Parameters: [param0=[pid,0586244], param1=[ordtype,I], param2=[orddd,20150615], param3=[dschdd,20150815], param4=[formcd,1300009935], param5=[ocrtag,2016082689390], param6=[pageno,0]] [Logging Date Time: 2016-08-26 16:35:00,912] ===================================================================================== SQL Command - Statement Id: [getFileName] Parameters: [param0=[pid,0586244], param1=[ordtype,I], param2=[orddd,20150615], param3=[dschdd,20150815], param4=[formcd,1300009935], param5=[ocrtag,2016082689390], param6=[pageno,0]] [Logging Date Time: 2016-08-26 16:35:00,912] ===================================================================================== 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]] [Logging Date Time: 2016-08-26 16:35:00,912] ===================================================================================== 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]] [Logging Date Time: 2016-08-26 16:35:00,953] ===================================================================================== 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] [Logging Date Time: 2016-08-26 16:35:00,953] ===================================================================================== 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] [Logging Date Time: 2016-08-26 16:35:00,954] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_IMAGE]] [Logging Date Time: 2016-08-26 16:35:00,954] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_IMAGE]] [Logging Date Time: 2016-08-26 16:35:00,954] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:35:00,954] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:35:00,957] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE set ud1_num = :param0 where main_cd = 'SEQUENCE' and sub_cd = :param1] [Logging Date Time: 2016-08-26 16:35:00,957] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE set ud1_num = :param0 where main_cd = 'SEQUENCE' and sub_cd = :param1] [Logging Date Time: 2016-08-26 16:35:00,958] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,154], param1=[sub_cd,CONSENT_IMAGE]] [Logging Date Time: 2016-08-26 16:35:00,958] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,154], param1=[sub_cd,CONSENT_IMAGE]] [Logging Date Time: 2016-08-26 16:35:00,958] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:35:00,958] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:35:00,959] ===================================================================================== 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') )] [Logging Date Time: 2016-08-26 16:35:00,959] ===================================================================================== 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') )] [Logging Date Time: 2016-08-26 16:35:00,959] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_IMAGE] Parameters: [param0=[consentImageRid,154], param1=[consentMstRid,130], param2=[formRid,184], param3=[imagePath,Image3\fnuImage\201608\26], param4=[imageFilename,100502075.jpg], param5=[completeYn,Y], param6=[userId,103043]] [Logging Date Time: 2016-08-26 16:35:00,959] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_IMAGE] Parameters: [param0=[consentImageRid,154], param1=[consentMstRid,130], param2=[formRid,184], param3=[imagePath,Image3\fnuImage\201608\26], param4=[imageFilename,100502075.jpg], param5=[completeYn,Y], param6=[userId,103043]] [Logging Date Time: 2016-08-26 16:35:00,959] ===================================================================================== 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]] [Logging Date Time: 2016-08-26 16:35:00,959] ===================================================================================== 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]] [Logging Date Time: 2016-08-26 16:35:11,076] ===================================================================================== SQL Command - CLIP.eForm File Upload: Image3\fnuImage\201608\26\100502075.jpg [Logging Date Time: 2016-08-26 16:35:28,330] ===================================================================================== SQL Command - CLIP.eForm File Upload: C:\@bin\@DFH\DFH-Consent\CLIP.e-Form.Consent.Dfh.Web\ [Logging Date Time: 2016-08-26 16:35:28,338] ===================================================================================== SQL Command - CLIP.eForm error: 'C:\@bin\@DFH\DFH-Consent\CLIP.e-Form.Consent.Dfh.Web\' 경로의 일부를 찾을 수 없습니다. [Logging Date Time: 2016-08-26 16:35:56,469] ===================================================================================== 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] [Logging Date Time: 2016-08-26 16:35:56,469] ===================================================================================== 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] [Logging Date Time: 2016-08-26 16:35:56,469] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-08-26 16:35:56,469] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-08-26 16:35:56,470] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:35:56,470] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:35:56,472] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE set ud1_num = :param0 where main_cd = 'SEQUENCE' and sub_cd = :param1] [Logging Date Time: 2016-08-26 16:35:56,472] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE set ud1_num = :param0 where main_cd = 'SEQUENCE' and sub_cd = :param1] [Logging Date Time: 2016-08-26 16:35:56,473] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,168], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-08-26 16:35:56,473] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,168], param1=[sub_cd,CONSENT_DATA]] [Logging Date Time: 2016-08-26 16:35:56,473] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:35:56,473] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:35:56,488] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] PreparedStatement : [UPDATE CONSENT_MST SET CONSENT_STATE = :param0 , COMPLETE_YN = :param1 , COMPLETE_DATETIME = TO_CHAR(SYSDATE,'YYYY-MM-DD hh24:mi:ss'), PAPER_YN = :param2 , MODIFY_USER_ID = :param3 , MODIFY_DATETIME = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss') WHERE CONSENT_MST_RID = :param4] [Logging Date Time: 2016-08-26 16:35:56,488] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] PreparedStatement : [UPDATE CONSENT_MST SET CONSENT_STATE = :param0 , COMPLETE_YN = :param1 , COMPLETE_DATETIME = TO_CHAR(SYSDATE,'YYYY-MM-DD hh24:mi:ss'), PAPER_YN = :param2 , MODIFY_USER_ID = :param3 , MODIFY_DATETIME = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss') WHERE CONSENT_MST_RID = :param4] [Logging Date Time: 2016-08-26 16:35:56,488] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Parameters: [param0=[consentState,ELECTR_CMP], param1=[completeYn,Y], param2=[paperYn,N], param3=[userId,103043], param4=[consentMstRid,130]] [Logging Date Time: 2016-08-26 16:35:56,488] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Parameters: [param0=[consentState,ELECTR_CMP], param1=[completeYn,Y], param2=[paperYn,N], param3=[userId,103043], param4=[consentMstRid,130]] [Logging Date Time: 2016-08-26 16:35:56,488] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[Int32, System.Int32]] [Logging Date Time: 2016-08-26 16:35:56,488] ===================================================================================== SQL Command - Statement Id: [UPDATE_CONSENT_MST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[Int32, System.Int32]] [Logging Date Time: 2016-08-26 16:35:56,491] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] PreparedStatement : [insert into CONSENT_DATA ( CONSENT_DATA_RID, CONSENT_MST_RID, FORM_RID, DEVICE_TYPE, DEVICE_IDENT_NO, COMPLETE_YN, CREATE_USER_ID, CREATE_DATETIME, FORM_XML, DATA_XML ) values ( :param0 , :param1 , :param2 , :param3 , :param4 , :param5 , :param6 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param7 , :param8 )] [Logging Date Time: 2016-08-26 16:35:56,491] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] PreparedStatement : [insert into CONSENT_DATA ( CONSENT_DATA_RID, CONSENT_MST_RID, FORM_RID, DEVICE_TYPE, DEVICE_IDENT_NO, COMPLETE_YN, CREATE_USER_ID, CREATE_DATETIME, FORM_XML, DATA_XML ) values ( :param0 , :param1 , :param2 , :param3 , :param4 , :param5 , :param6 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param7 , :param8 )] [Logging Date Time: 2016-08-26 16:35:56,491] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,168], param1=[consentMstRid,130], param2=[formRid,184], param3=[deviceType,WIN], param4=[deviceIdentNo,CHLEE-PC], param5=[completeYn,Y], param6=[userId,103043], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]] [Logging Date Time: 2016-08-26 16:35:56,491] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,168], param1=[consentMstRid,130], param2=[formRid,184], param3=[deviceType,WIN], param4=[deviceIdentNo,CHLEE-PC], param5=[completeYn,Y], param6=[userId,103043], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]] [Logging Date Time: 2016-08-26 16:35:56,491] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] 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], param7=[Binary, System.Byte[]], param8=[Binary, System.Byte[]]] [Logging Date Time: 2016-08-26 16:35:56,491] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_DATA] 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], param7=[Binary, System.Byte[]], param8=[Binary, System.Byte[]]] [Logging Date Time: 2016-08-26 16:35:56,564] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] PreparedStatement : [DECLARE v_cnt NUMBER:=0; BEGIN SELECT COUNT(*) INTO V_CNT FROM CONSENT_DATA_EX WHERE PID = :param0 AND CLN_DATE = :param1 ; IF v_cnt = 0 THEN insert into consent_data_ex (pid, cln_date, use_yn, bp, dm, heart, kidney, respiration, hx, allergy, drug, smoking, idio, nacrotics, airway, hemorrhage, etc, create_user_id, create_datetime, modify_user_id, modify_datetime) values ( :param0 , :param1 ,'Y', :param2 , :param3 , :param4 , :param5 , :param6 , :param7 , :param8 , :param9 , :param10 , :param11 , :param12 , :param13 , :param14 , :param15 , :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss')); ELSE update consent_data_ex set bp = :param2 , dm = :param3 , heart = :param4 , kidney = :param5 , respiration = :param6 , hx = :param7 , allergy = :param8 , drug = :param9 , smoking = :param10 , idio = :param11 , nacrotics = :param12 , airway = :param13 , hemorrhage = :param14 , etc = :param15 , modify_user_id = :param16 , modify_datetime = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss') where PID = :param0 AND CLN_DATE = :param1 ; END IF; END;] [Logging Date Time: 2016-08-26 16:35:56,564] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] PreparedStatement : [DECLARE v_cnt NUMBER:=0; BEGIN SELECT COUNT(*) INTO V_CNT FROM CONSENT_DATA_EX WHERE PID = :param0 AND CLN_DATE = :param1 ; IF v_cnt = 0 THEN insert into consent_data_ex (pid, cln_date, use_yn, bp, dm, heart, kidney, respiration, hx, allergy, drug, smoking, idio, nacrotics, airway, hemorrhage, etc, create_user_id, create_datetime, modify_user_id, modify_datetime) values ( :param0 , :param1 ,'Y', :param2 , :param3 , :param4 , :param5 , :param6 , :param7 , :param8 , :param9 , :param10 , :param11 , :param12 , :param13 , :param14 , :param15 , :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss'), :param16 , TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss')); ELSE update consent_data_ex set bp = :param2 , dm = :param3 , heart = :param4 , kidney = :param5 , respiration = :param6 , hx = :param7 , allergy = :param8 , drug = :param9 , smoking = :param10 , idio = :param11 , nacrotics = :param12 , airway = :param13 , hemorrhage = :param14 , etc = :param15 , modify_user_id = :param16 , modify_datetime = TO_CHAR(SYSDATE,'yyyy-mm-dd hh24:mi:ss') where PID = :param0 AND CLN_DATE = :param1 ; END IF; END;] [Logging Date Time: 2016-08-26 16:35:56,564] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] Parameters: [param0=[patientCode,0586244], param1=[clnDate,20150615], param2=[bp,01], param3=[dm,01], param4=[heart,01], param5=[kidney,01], param6=[respiration,02], param7=[hx,02], param8=[allergy,02], param9=[drug,02], param10=[smoking,02], param11=[idio,02], param12=[nacrotics,02], param13=[airway,02], param14=[hemorrhage,02], param15=[status_etc,어쩌구], param16=[userId,103043]] [Logging Date Time: 2016-08-26 16:35:56,564] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] Parameters: [param0=[patientCode,0586244], param1=[clnDate,20150615], param2=[bp,01], param3=[dm,01], param4=[heart,01], param5=[kidney,01], param6=[respiration,02], param7=[hx,02], param8=[allergy,02], param9=[drug,02], param10=[smoking,02], param11=[idio,02], param12=[nacrotics,02], param13=[airway,02], param14=[hemorrhage,02], param15=[status_etc,어쩌구], param16=[userId,103043]] [Logging Date Time: 2016-08-26 16:35:56,564] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] 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], param10=[AnsiString, System.String], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[AnsiString, System.String], param16=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:35:56,564] ===================================================================================== SQL Command - Statement Id: [SET_MEDI_HISTORY] 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], param10=[AnsiString, System.String], param11=[AnsiString, System.String], param12=[AnsiString, System.String], param13=[AnsiString, System.String], param14=[AnsiString, System.String], param15=[AnsiString, System.String], param16=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:35:56,636] ===================================================================================== SQL Command - Statement Id: [setFileName] PreparedStatement : [declare I_PID VARCHAR2(10) := :param0 ; I_IOFLAG VARCHAR2(1) := :param1 ; I_ORDDD VARCHAR2(8) := :param2 ; I_DSCHDD VARCHAR2(8) := :param3 ; I_CRETNO NUMBER(10) := :param4 ; I_FILESIZE NUMBER(18) := :param5 ; I_FORMCD VARCHAR2(10) := :param6 ; I_PAGE NUMBER(18) := :param7 ; I_OCRCODE VARCHAR2(13) := :param8 ; I_USERID VARCHAR2(10) := :param9 ; begin EMR.LCTECH_PROCESS(I_PID, I_IOFLAG, I_ORDDD, I_DSCHDD, I_CRETNO, I_FILESIZE, I_FORMCD, I_PAGE, I_OCRCODE, I_USERID); end;] [Logging Date Time: 2016-08-26 16:35:56,636] ===================================================================================== SQL Command - Statement Id: [setFileName] PreparedStatement : [declare I_PID VARCHAR2(10) := :param0 ; I_IOFLAG VARCHAR2(1) := :param1 ; I_ORDDD VARCHAR2(8) := :param2 ; I_DSCHDD VARCHAR2(8) := :param3 ; I_CRETNO NUMBER(10) := :param4 ; I_FILESIZE NUMBER(18) := :param5 ; I_FORMCD VARCHAR2(10) := :param6 ; I_PAGE NUMBER(18) := :param7 ; I_OCRCODE VARCHAR2(13) := :param8 ; I_USERID VARCHAR2(10) := :param9 ; begin EMR.LCTECH_PROCESS(I_PID, I_IOFLAG, I_ORDDD, I_DSCHDD, I_CRETNO, I_FILESIZE, I_FORMCD, I_PAGE, I_OCRCODE, I_USERID); end;] [Logging Date Time: 2016-08-26 16:35:56,636] ===================================================================================== 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,0], param8=[ocrtag,2016082689390], param9=[userid,103043]] [Logging Date Time: 2016-08-26 16:35:56,636] ===================================================================================== 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,0], param8=[ocrtag,2016082689390], param9=[userid,103043]] [Logging Date Time: 2016-08-26 16:35:56,636] ===================================================================================== 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]] [Logging Date Time: 2016-08-26 16:35:56,636] ===================================================================================== 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]] [Logging Date Time: 2016-08-26 16:35:56,642] ===================================================================================== 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'] [Logging Date Time: 2016-08-26 16:35:56,642] ===================================================================================== 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'] [Logging Date Time: 2016-08-26 16:35:56,642] ===================================================================================== SQL Command - Statement Id: [getFileName] Parameters: [param0=[pid,0586244], param1=[ordtype,I], param2=[orddd,20150615], param3=[dschdd,20150815], param4=[formcd,1300009935], param5=[ocrtag,2016082689390], param6=[pageno,0]] [Logging Date Time: 2016-08-26 16:35:56,642] ===================================================================================== SQL Command - Statement Id: [getFileName] Parameters: [param0=[pid,0586244], param1=[ordtype,I], param2=[orddd,20150615], param3=[dschdd,20150815], param4=[formcd,1300009935], param5=[ocrtag,2016082689390], param6=[pageno,0]] [Logging Date Time: 2016-08-26 16:35:56,642] ===================================================================================== 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]] [Logging Date Time: 2016-08-26 16:35:56,642] ===================================================================================== 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]] [Logging Date Time: 2016-08-26 16:35:56,654] ===================================================================================== 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] [Logging Date Time: 2016-08-26 16:35:56,654] ===================================================================================== 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] [Logging Date Time: 2016-08-26 16:35:56,654] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_IMAGE]] [Logging Date Time: 2016-08-26 16:35:56,654] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_IMAGE]] [Logging Date Time: 2016-08-26 16:35:56,654] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:35:56,654] ===================================================================================== SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:35:56,657] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE set ud1_num = :param0 where main_cd = 'SEQUENCE' and sub_cd = :param1] [Logging Date Time: 2016-08-26 16:35:56,657] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] PreparedStatement : [update EFORM_CODE set ud1_num = :param0 where main_cd = 'SEQUENCE' and sub_cd = :param1] [Logging Date Time: 2016-08-26 16:35:56,657] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,155], param1=[sub_cd,CONSENT_IMAGE]] [Logging Date Time: 2016-08-26 16:35:56,657] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,155], param1=[sub_cd,CONSENT_IMAGE]] [Logging Date Time: 2016-08-26 16:35:56,657] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:35:56,657] ===================================================================================== SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]] [Logging Date Time: 2016-08-26 16:35:56,659] ===================================================================================== 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') )] [Logging Date Time: 2016-08-26 16:35:56,659] ===================================================================================== 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') )] [Logging Date Time: 2016-08-26 16:35:56,659] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_IMAGE] Parameters: [param0=[consentImageRid,155], param1=[consentMstRid,130], param2=[formRid,184], param3=[imagePath,Image3\fnuImage\201608\26], param4=[imageFilename,100502076.jpg], param5=[completeYn,Y], param6=[userId,103043]] [Logging Date Time: 2016-08-26 16:35:56,659] ===================================================================================== SQL Command - Statement Id: [INSERT_CONSENT_IMAGE] Parameters: [param0=[consentImageRid,155], param1=[consentMstRid,130], param2=[formRid,184], param3=[imagePath,Image3\fnuImage\201608\26], param4=[imageFilename,100502076.jpg], param5=[completeYn,Y], param6=[userId,103043]] [Logging Date Time: 2016-08-26 16:35:56,659] ===================================================================================== 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]]