[Logging Date Time: 2016-11-10 10:23:34,895] =====================================================================================
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-11-10 10:23:34,895] =====================================================================================
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-11-10 10:23:34,930] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]]
[Logging Date Time: 2016-11-10 10:23:34,930] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]]
[Logging Date Time: 2016-11-10 10:23:34,931] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]
[Logging Date Time: 2016-11-10 10:23:34,931] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]
[Logging Date Time: 2016-11-10 10:23:34,947] =====================================================================================
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-11-10 10:23:34,947] =====================================================================================
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-11-10 10:23:34,948] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,1788], param1=[sub_cd,CONSENT_DATA]]
[Logging Date Time: 2016-11-10 10:23:34,948] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,1788], param1=[sub_cd,CONSENT_DATA]]
[Logging Date Time: 2016-11-10 10:23:34,949] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]
[Logging Date Time: 2016-11-10 10:23:34,949] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]
[Logging Date Time: 2016-11-10 10:23:34,966] =====================================================================================
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'), MODIFY_USER_NAME = COM.FN_ZS_GETUSERNM( :param3 , TO_CHAR(SYSDATE, 'YYYYMMDD')) WHERE CONSENT_MST_RID = :param4]
[Logging Date Time: 2016-11-10 10:23:34,966] =====================================================================================
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'), MODIFY_USER_NAME = COM.FN_ZS_GETUSERNM( :param3 , TO_CHAR(SYSDATE, 'YYYYMMDD')) WHERE CONSENT_MST_RID = :param4]
[Logging Date Time: 2016-11-10 10:23:34,966] =====================================================================================
SQL Command - Statement Id: [UPDATE_CONSENT_MST] Parameters: [param0=[consentState,ELECTR_CMP], param1=[completeYn,Y], param2=[paperYn,N], param3=[userId,105066], param4=[consentMstRid,1842]]
[Logging Date Time: 2016-11-10 10:23:34,966] =====================================================================================
SQL Command - Statement Id: [UPDATE_CONSENT_MST] Parameters: [param0=[consentState,ELECTR_CMP], param1=[completeYn,Y], param2=[paperYn,N], param3=[userId,105066], param4=[consentMstRid,1842]]
[Logging Date Time: 2016-11-10 10:23:34,966] =====================================================================================
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-11-10 10:23:34,966] =====================================================================================
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-11-10 10:23:34,972] =====================================================================================
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-11-10 10:23:34,972] =====================================================================================
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-11-10 10:23:34,972] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,1788], param1=[consentMstRid,1842], param2=[formRid,1307], param3=[deviceType,WIN], param4=[deviceIdentNo,16-101-33], param5=[completeYn,Y], param6=[userId,105066], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]]
[Logging Date Time: 2016-11-10 10:23:34,972] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,1788], param1=[consentMstRid,1842], param2=[formRid,1307], param3=[deviceType,WIN], param4=[deviceIdentNo,16-101-33], param5=[completeYn,Y], param6=[userId,105066], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]]
[Logging Date Time: 2016-11-10 10:23:34,972] =====================================================================================
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-11-10 10:23:34,972] =====================================================================================
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-11-10 10:23:37,579] =====================================================================================
SQL Command - CLIP.eForm SaveDataAll ERROR : [System.NullReferenceException: 개체 참조가 개체의 인스턴스로 설정되지 않았습니다.
위치: CLIP.eForm.Consent.Dfh.WebService.ConsentSvc.imageUpload(SaveConsentDac dac, Hashtable paramHashTable, String userId, String patientCode, String visitType, String clnDate, String Dschdd, Int32 cretno, String ocrcode, Int32 consentMstRid, String consentState, String formCd, Int32 formRid, String dataXml, String imageFileJson, String certTarget, String certResult, String hosType, String createUserName) 파일 D:\TeamDFH_Consent\DFH-Consent\CLIP.e-Form.Consent.Dfh.Web\ConsentSvc.asmx.cs:줄 971
위치: CLIP.eForm.Consent.Dfh.WebService.ConsentSvc.SaveDataAll(String userId, String patientCode, String clnDeptCode, Int32 formRid, String formCd, Int32 consentMstRid, Int32 rewriteConsentMstRid, Int32 reissueConsentMstRid, String consentState, String paperYn, String formXml, String dataXml, String deviceType, String deviceIdentNo, String vistType, String hosType, String clnDate, String ward, String roomcd, String reasonForUseN, Int32 orderNo, String orderName, String orderCd, String ocrCode, Int32 cretno, String createUserName, String modifyUserName, String imageFileJson, String certTarget, String certResult, String dschdd, String mainDrId) 파일 D:\TeamDFH_Consent\DFH-Consent\CLIP.e-Form.Consent.Dfh.Web\ConsentSvc.asmx.cs:줄 901]
[Logging Date Time: 2016-11-10 10:32:57,970] =====================================================================================
SQL Command - CLIP.eForm SaveCompleteAll param : clnDept[105066]patientCode[1715813]clnDeptCode[2010400000]formRid[1307]formCd[1300010589]consentMstRid[1842]rewriteConsentMstRid[0]deviceType[WIN]vistType[O]hosType[111]clnDate[20161110]ward[]roomcd[]orderNo[111]orderName[코감기]orderCd[J00.000.08]ocrCode[2016111063775]cretno[1]createUserName[이봉렬]modifyUserName[이봉렬]imageFileJson[{ "imageFile1" : "201611/10/00d3135d51d642a5946e8817c09947ba_1.jpg", "imageFile2" : "201611/10/00d3135d51d642a5946e8817c09947ba_2.jpg" }]certTarget[278a4c26b11e2327060a0f51ddad21bea5f49f32e035bcd23d468b4cd2fc3^d57fffbbe6132bb57bbd045394b7f79a3ea62f5ad6f890e1f682d91cfc25a2]dschdd[20161110]consentState[ELECTR_CMP]mainDrId[105066]dataXml[460,2204,460,2204?455,2204,452,2204?450,2201,447,2201?444,2199,442,2196?442,2191,439,2185?434,2180,434,2172?434,2167,434,2156?439,2148,442,2138?444,2125,450,2111?455,2098,460,2085?471,2069,479,2056?487,2040,500,2027?511,2011,521,1995?532,1982,542,1966?556,1953,564,1939?577,1929,585,1918?593,1908,603,1900?609,1894,614,1894?616,1894,619,1894?622,1900,622,1905?619,1918,619,1929?616,1945,611,1958?609,1976,603,1995?595,2016,590,2040?585,2061,579,2085?577,2109,569,2130?564,2154,561,2172?558,2191,558,2201?558,2209,558,2215?561,2215,564,2212?569,2204,577,2193?582,2180,590,2167?595,2151,606,2138?614,2122,619,2111?627,2098,635,2088?643,2077,648,2072?651,2066,659,2061?664,2058,667,2058?669,2058,672,2058?675,2061,677,2066?677,2069,680,2074?680,2085,680,2093?685,2101,685,2111?685,2119,688,2130?688,2140,691,2148?691,2156,693,2159?696,2167,698,2167?701,2167,704,2159?706,2156,714,2148?717,2140,722,2130?728,2119,730,2111?736,2101,743,2090?749,2085,754,2074?759,2072,762,2066?770,2064,773,2064?773,2061,775,2064?778,2064,778,2066?781,2069,781,2072?783,2074,783,2077?783,2085,786,2088?788,2090,788,2096?791,2098,791,2101?796,2109,799,2111?799,2114,802,2117?804,2117,804,2119?807,2122,807,2122?810,2125,812,2125?815,2125,818,2122?823,2119,826,2117?831,2114,833,2111?836,2103,839,2101?841,2098,844,2096?844,2096466,1254,466,1254?460,1262,458,1265?458,1265,458,1265?458,1265,460,1265?460,1262,468,1254?471,1249,476,1244?484,1236,495,1222?503,1214,508,1206?516,1196,527,1188?534,1180,542,1172?550,1167,556,1159?564,1154,569,1151?572,1143,579,1140?582,1138,582,1138?582,1138,582,1140?579,1140,579,1146?577,1151,569,1156?566,1162,561,1169?558,1177,556,1185?553,1193,548,1201?548,1212,542,1217?542,1225,542,1233?542,1238,542,1244?542,1246,548,1249?550,1251,553,1251?556,1251,558,1251?561,1251,566,1251?569,1249,572,1249?577,1246,579,1249?579,1251,582,1257?582,1262,582,1267?582,1273,582,1275?582,1281669,1217,669,1217?672,1217,675,1214?677,1214,680,1212?685,1212,688,1209?691,1209,691,1206?693,1206,696,1201?698,1201,701,1199?701,1199,704,1196?704,1196640,1601,640,1601?632,1609,624,1619?619,1625,614,1632?609,1638,603,1646?598,1648,598,1648?598,1648,598,1648?603,1646,609,1638?614,1632,622,1627?632,1619,643,1609?651,1601,661,1593?672,1582,680,1574?691,1566,698,1561?706,1550,714,1548?722,1543,728,1540?730,1535,736,1535?741,1529,743,1529?743,1527,743,1527?746,1529,746,1535?746,1537,746,1540?746,1543,743,1545?743,1550,743,1553?741,1561,741,1564?741,1572,743,1577?743,1582,743,1593?743,1601,746,1609?746,1619,746,1627?746,1632,749,1643?749,1648,751,1656?754,1662,754,1664?757,1672,759,1675857,1638,857,1638?860,1638,860,1638?863,1635,865,1635?868,1635,870,1632?873,1630,873,1627?878,1625,881,1622?884,1619,884,1617?886,1609,889,1603?892,1601,894,1595?894,1590,897,1580?897,1574,900,1569?900,1566,900,1561?900,1556,900,1553?900,1550,897,1548?897,1548,894,1548?892,1548,892,1550?889,1553,886,1556?884,1561,884,1566?881,1569,881,1574?878,1580,878,1585?881,1590,881,1595?884,1601,886,1603?886,1606,892,1606?894,1609,897,1609?905,1606,910,1606?915,1603,921,1598?926,1595,937,1590?942,1585,945,1580?950,1572,950,1572995,1482,995,1482?995,1479,995,1479?995,1474,995,1479?992,1479,992,1482?992,1484,990,1490?987,1495,987,1500?982,1508,982,1513?982,1519,982,1521?982,1527,987,1529?987,1529,990,1535?992,1535,995,1535?1000,1529,1005,1529?1008,1527,1016,1527?1021,1524,1027,1521?1032,1521,1035,1519?1037,1519,1042,1519?1042,1519,1045,1519?1045,1519,1045,1521?1045,1524,1045,1527?1042,1529,1037,1535?1037,1540,1035,1543?1032,1548,1032,1550?1029,1553,1029,15531130,1397,1130,1397?1132,1389,1138,1386?1140,1384,1146,1381?1151,1381,1151,1381?1154,1381,1156,1381?1156,1381,1159,1384?1159,1384,1159,1389?1159,1392,1159,1397?1159,1402,1159,1408?1159,1413,1159,1418?1162,1426,1162,1431?1162,1434,1164,1439?1164,1442,1167,1445?1169,1447,1172,1447?1177,1453,1180,1453?1185,1453,1191,1447?1196,1447,1206,1445?1212,1442,1220,1439?1225,1434,1236,1431?1241,1429,1249,1426?1254,1421,1265,1416?1270,1416,1275,1413?1278,1410,1281,1408?1281,1408,1281,14081159,1460,1159,1460?1156,1463,1154,1466?1154,1468,1154,1468?1156,1466,1162,1463?1167,1460,1172,1458?1180,1455,1188,1447?1193,1445,1199,1439?1209,1437,1214,1431?1220,1429,1225,1426?1233,1421,1233,1421881,2267,881,2267?878,2273,878,2273?878,2273,878,2273?873,2267,873,2267?878,2265,878,2265?881,2262,884,2257?889,2254,894,2249?900,2241,908,2236?915,2228,923,2220?934,2207,945,2199?955,2185,966,2178?976,2167,990,2154?997,2146,1005,2138?1016,2130,1016,21301024,2103,1024,2103?1019,2109,1013,2114?1003,2117,1000,2122?997,2125,992,2127?990,2133,987,2138?982,2143,979,2148?979,2154,976,2159?976,2170,976,2178?976,2185,976,2199?976,2209,976,2225?979,2238,979,2254?982,2273,987,2289?987,2307,990,2323?992,2342,995,2363?997,2376,1000,2394?1003,2410,1005,2421?1008,2432,1013,2442?1016,2447,1019,2453?1021,2453,1024,24551106,2275,1106,2275?1109,2275,1109,2275?1109,2278,1109,2281?1109,2283,1106,2286?1106,2291,1103,2294?1103,2302,1103,2305?1103,2307,1103,2307?1106,2307,1106,2307?1109,2307,1111,2305?1114,2302,1119,2297?1124,2291,1130,2283?1135,2278,1138,2267?1143,2257,1146,2249?1154,2236,1156,2225?1162,2215,1164,2204?1167,2196,1169,2183?1169,2178,1172,2170?1172,2164,1172,2159?1172,2156,1169,2154?1167,2154,1164,2154?1162,2154,1159,2156?1154,2164,1146,2170?1143,2175,1138,2183?1132,2193,1130,2201?1124,2209,1119,2220?1117,2230,1114,2238?1111,2249,1111,2260?1109,2267,1109,2275?1111,2283,1111,2291?1114,2297,1117,2305?1124,2307,1127,2312?1132,2312,1138,2315?1143,2315,1151,2312?1159,2312,1164,2307?1172,2305,1180,22971315,2119,1315,2119?1315,2119,1315,2117?1315,2119,1310,2122?1310,2125,1304,2130?1302,2138,1296,2146?1291,2156,1283,2167?1278,2175,1273,2185?1270,2196,1265,2207?1262,2215,1257,2222?1257,2228,1262,2230?1262,2233,1265,2233?1270,2230,1275,2228?1281,2225,1291,2220?1296,2212,1304,2207?1310,2201,1320,2199?1326,2193,1331,2191?1334,2191,1336,2191?1339,2191,1344,2193?1344,2196,1344,2199?1344,2204,1339,2209?1336,2215,1334,2225?1328,2233,1323,2241?1318,2252,1310,2260?1304,2267,1299,2281?1291,2289,1283,2297?1278,2305,1273,2310?1267,23151357,2008,1357,2008?1363,1995,1371,1984?1376,1974,1381,1963?1384,1953,1386,1945?1392,1937,1397,1931?1400,1926,1400,1921?1400,1921,1402,1921?1402,1921,1402,1924?1402,1929,1402,1934?1400,1945,1400,1955?1397,1966,1392,1979?1389,1992,1389,2008?1386,2021,1384,2037?1384,2056,1381,2069?1381,2085,1384,2098?1384,2111,1386,2122?1389,2127,1392,2138?1397,2140,1400,2143?1402,2146,1408,2146?1413,2146,1416,2146?1421,2146,1426,2143?1431,2143,1434,2140?1437,2140,1439,2138?1442,2138,1445,2133?1445,2133,1447,2130?1447,2127,1445,2125?1445,2122,1442,2119?1437,2114,1434,2111?1429,2109,1426,2103?1416,2101,1410,2096?1405,2093,1397,2090?1386,2090,1378,2088?1371,2088,1360,2088?1349,2088,1339,2088?1331,2088,1323,2090?1318,2090,1310,20931606,2170,1606,2170?1603,2172,1603,2178?1601,2180,1598,2180?1598,2183,1598,2183?1598,2183,1598,2183?1598,2183,1601,2180?1603,2178,1606,2172?1611,2167,1619,2159?1625,2151,1630,2140?1635,2130,1646,2119?1651,2109,1656,2096?1659,2085,1662,2072?1667,2061,1672,2045?1672,2032,1675,2019?1677,2006,1677,1987?1680,1974,1680,1955?1680,1939,1683,1926?1683,1910,1683,1897?1683,1884,1680,1876?1680,1868,1677,1857?1677,1852,1675,1847?1672,1844,1667,1842?1662,1839,1659,1836?1654,1836,1651,1836?1646,1839,1643,1842?1635,1847,1632,1852?1627,1863,1625,1871?1622,1881,1619,1894?1617,1908,1611,1924?1611,1937,1611,1953?1617,1968,1619,1987?1622,2003,1625,2016?1630,2032,1635,2045?1646,2061,1651,2072?1659,2085,1667,2093?1677,2103,1685,2114?1691,2119,1701,2125?1709,2130,1714,2138?1720,2140,1728,2143?1733,2146,1736,2148?1738,21511550,1995,1550,1995?1550,1995,1553,1992?1564,1990,1572,1984?1582,1976,1598,1966?1617,1958,1632,1947?1651,1934,1675,1924?1693,1908,1717,1897?1741,1884,1765,1873?1786,1863,1786,1863 | | |
| | |
| | |
| | |
|
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | |
| | | | | | |
| | | |
| | | | |
|
| |
| |
]formXml[460,2204,460,2204?455,2204,452,2204?450,2201,447,2201?444,2199,442,2196?442,2191,439,2185?434,2180,434,2172?434,2167,434,2156?439,2148,442,2138?444,2125,450,2111?455,2098,460,2085?471,2069,479,2056?487,2040,500,2027?511,2011,521,1995?532,1982,542,1966?556,1953,564,1939?577,1929,585,1918?593,1908,603,1900?609,1894,614,1894?616,1894,619,1894?622,1900,622,1905?619,1918,619,1929?616,1945,611,1958?609,1976,603,1995?595,2016,590,2040?585,2061,579,2085?577,2109,569,2130?564,2154,561,2172?558,2191,558,2201?558,2209,558,2215?561,2215,564,2212?569,2204,577,2193?582,2180,590,2167?595,2151,606,2138?614,2122,619,2111?627,2098,635,2088?643,2077,648,2072?651,2066,659,2061?664,2058,667,2058?669,2058,672,2058?675,2061,677,2066?677,2069,680,2074?680,2085,680,2093?685,2101,685,2111?685,2119,688,2130?688,2140,691,2148?691,2156,693,2159?696,2167,698,2167?701,2167,704,2159?706,2156,714,2148?717,2140,722,2130?728,2119,730,2111?736,2101,743,2090?749,2085,754,2074?759,2072,762,2066?770,2064,773,2064?773,2061,775,2064?778,2064,778,2066?781,2069,781,2072?783,2074,783,2077?783,2085,786,2088?788,2090,788,2096?791,2098,791,2101?796,2109,799,2111?799,2114,802,2117?804,2117,804,2119?807,2122,807,2122?810,2125,812,2125?815,2125,818,2122?823,2119,826,2117?831,2114,833,2111?836,2103,839,2101?841,2098,844,2096?844,2096466,1254,466,1254?460,1262,458,1265?458,1265,458,1265?458,1265,460,1265?460,1262,468,1254?471,1249,476,1244?484,1236,495,1222?503,1214,508,1206?516,1196,527,1188?534,1180,542,1172?550,1167,556,1159?564,1154,569,1151?572,1143,579,1140?582,1138,582,1138?582,1138,582,1140?579,1140,579,1146?577,1151,569,1156?566,1162,561,1169?558,1177,556,1185?553,1193,548,1201?548,1212,542,1217?542,1225,542,1233?542,1238,542,1244?542,1246,548,1249?550,1251,553,1251?556,1251,558,1251?561,1251,566,1251?569,1249,572,1249?577,1246,579,1249?579,1251,582,1257?582,1262,582,1267?582,1273,582,1275?582,1281669,1217,669,1217?672,1217,675,1214?677,1214,680,1212?685,1212,688,1209?691,1209,691,1206?693,1206,696,1201?698,1201,701,1199?701,1199,704,1196?704,1196640,1601,640,1601?632,1609,624,1619?619,1625,614,1632?609,1638,603,1646?598,1648,598,1648?598,1648,598,1648?603,1646,609,1638?614,1632,622,1627?632,1619,643,1609?651,1601,661,1593?672,1582,680,1574?691,1566,698,1561?706,1550,714,1548?722,1543,728,1540?730,1535,736,1535?741,1529,743,1529?743,1527,743,1527?746,1529,746,1535?746,1537,746,1540?746,1543,743,1545?743,1550,743,1553?741,1561,741,1564?741,1572,743,1577?743,1582,743,1593?743,1601,746,1609?746,1619,746,1627?746,1632,749,1643?749,1648,751,1656?754,1662,754,1664?757,1672,759,1675857,1638,857,1638?860,1638,860,1638?863,1635,865,1635?868,1635,870,1632?873,1630,873,1627?878,1625,881,1622?884,1619,884,1617?886,1609,889,1603?892,1601,894,1595?894,1590,897,1580?897,1574,900,1569?900,1566,900,1561?900,1556,900,1553?900,1550,897,1548?897,1548,894,1548?892,1548,892,1550?889,1553,886,1556?884,1561,884,1566?881,1569,881,1574?878,1580,878,1585?881,1590,881,1595?884,1601,886,1603?886,1606,892,1606?894,1609,897,1609?905,1606,910,1606?915,1603,921,1598?926,1595,937,1590?942,1585,945,1580?950,1572,950,1572995,1482,995,1482?995,1479,995,1479?995,1474,995,1479?992,1479,992,1482?992,1484,990,1490?987,1495,987,1500?982,1508,982,1513?982,1519,982,1521?982,1527,987,1529?987,1529,990,1535?992,1535,995,1535?1000,1529,1005,1529?1008,1527,1016,1527?1021,1524,1027,1521?1032,1521,1035,1519?1037,1519,1042,1519?1042,1519,1045,1519?1045,1519,1045,1521?1045,1524,1045,1527?1042,1529,1037,1535?1037,1540,1035,1543?1032,1548,1032,1550?1029,1553,1029,15531130,1397,1130,1397?1132,1389,1138,1386?1140,1384,1146,1381?1151,1381,1151,1381?1154,1381,1156,1381?1156,1381,1159,1384?1159,1384,1159,1389?1159,1392,1159,1397?1159,1402,1159,1408?1159,1413,1159,1418?1162,1426,1162,1431?1162,1434,1164,1439?1164,1442,1167,1445?1169,1447,1172,1447?1177,1453,1180,1453?1185,1453,1191,1447?1196,1447,1206,1445?1212,1442,1220,1439?1225,1434,1236,1431?1241,1429,1249,1426?1254,1421,1265,1416?1270,1416,1275,1413?1278,1410,1281,1408?1281,1408,1281,14081159,1460,1159,1460?1156,1463,1154,1466?1154,1468,1154,1468?1156,1466,1162,1463?1167,1460,1172,1458?1180,1455,1188,1447?1193,1445,1199,1439?1209,1437,1214,1431?1220,1429,1225,1426?1233,1421,1233,1421881,2267,881,2267?878,2273,878,2273?878,2273,878,2273?873,2267,873,2267?878,2265,878,2265?881,2262,884,2257?889,2254,894,2249?900,2241,908,2236?915,2228,923,2220?934,2207,945,2199?955,2185,966,2178?976,2167,990,2154?997,2146,1005,2138?1016,2130,1016,21301024,2103,1024,2103?1019,2109,1013,2114?1003,2117,1000,2122?997,2125,992,2127?990,2133,987,2138?982,2143,979,2148?979,2154,976,2159?976,2170,976,2178?976,2185,976,2199?976,2209,976,2225?979,2238,979,2254?982,2273,987,2289?987,2307,990,2323?992,2342,995,2363?997,2376,1000,2394?1003,2410,1005,2421?1008,2432,1013,2442?1016,2447,1019,2453?1021,2453,1024,24551106,2275,1106,2275?1109,2275,1109,2275?1109,2278,1109,2281?1109,2283,1106,2286?1106,2291,1103,2294?1103,2302,1103,2305?1103,2307,1103,2307?1106,2307,1106,2307?1109,2307,1111,2305?1114,2302,1119,2297?1124,2291,1130,2283?1135,2278,1138,2267?1143,2257,1146,2249?1154,2236,1156,2225?1162,2215,1164,2204?1167,2196,1169,2183?1169,2178,1172,2170?1172,2164,1172,2159?1172,2156,1169,2154?1167,2154,1164,2154?1162,2154,1159,2156?1154,2164,1146,2170?1143,2175,1138,2183?1132,2193,1130,2201?1124,2209,1119,2220?1117,2230,1114,2238?1111,2249,1111,2260?1109,2267,1109,2275?1111,2283,1111,2291?1114,2297,1117,2305?1124,2307,1127,2312?1132,2312,1138,2315?1143,2315,1151,2312?1159,2312,1164,2307?1172,2305,1180,22971315,2119,1315,2119?1315,2119,1315,2117?1315,2119,1310,2122?1310,2125,1304,2130?1302,2138,1296,2146?1291,2156,1283,2167?1278,2175,1273,2185?1270,2196,1265,2207?1262,2215,1257,2222?1257,2228,1262,2230?1262,2233,1265,2233?1270,2230,1275,2228?1281,2225,1291,2220?1296,2212,1304,2207?1310,2201,1320,2199?1326,2193,1331,2191?1334,2191,1336,2191?1339,2191,1344,2193?1344,2196,1344,2199?1344,2204,1339,2209?1336,2215,1334,2225?1328,2233,1323,2241?1318,2252,1310,2260?1304,2267,1299,2281?1291,2289,1283,2297?1278,2305,1273,2310?1267,23151357,2008,1357,2008?1363,1995,1371,1984?1376,1974,1381,1963?1384,1953,1386,1945?1392,1937,1397,1931?1400,1926,1400,1921?1400,1921,1402,1921?1402,1921,1402,1924?1402,1929,1402,1934?1400,1945,1400,1955?1397,1966,1392,1979?1389,1992,1389,2008?1386,2021,1384,2037?1384,2056,1381,2069?1381,2085,1384,2098?1384,2111,1386,2122?1389,2127,1392,2138?1397,2140,1400,2143?1402,2146,1408,2146?1413,2146,1416,2146?1421,2146,1426,2143?1431,2143,1434,2140?1437,2140,1439,2138?1442,2138,1445,2133?1445,2133,1447,2130?1447,2127,1445,2125?1445,2122,1442,2119?1437,2114,1434,2111?1429,2109,1426,2103?1416,2101,1410,2096?1405,2093,1397,2090?1386,2090,1378,2088?1371,2088,1360,2088?1349,2088,1339,2088?1331,2088,1323,2090?1318,2090,1310,20931606,2170,1606,2170?1603,2172,1603,2178?1601,2180,1598,2180?1598,2183,1598,2183?1598,2183,1598,2183?1598,2183,1601,2180?1603,2178,1606,2172?1611,2167,1619,2159?1625,2151,1630,2140?1635,2130,1646,2119?1651,2109,1656,2096?1659,2085,1662,2072?1667,2061,1672,2045?1672,2032,1675,2019?1677,2006,1677,1987?1680,1974,1680,1955?1680,1939,1683,1926?1683,1910,1683,1897?1683,1884,1680,1876?1680,1868,1677,1857?1677,1852,1675,1847?1672,1844,1667,1842?1662,1839,1659,1836?1654,1836,1651,1836?1646,1839,1643,1842?1635,1847,1632,1852?1627,1863,1625,1871?1622,1881,1619,1894?1617,1908,1611,1924?1611,1937,1611,1953?1617,1968,1619,1987?1622,2003,1625,2016?1630,2032,1635,2045?1646,2061,1651,2072?1659,2085,1667,2093?1677,2103,1685,2114?1691,2119,1701,2125?1709,2130,1714,2138?1720,2140,1728,2143?1733,2146,1736,2148?1738,21511550,1995,1550,1995?1550,1995,1553,1992?1564,1990,1572,1984?1582,1976,1598,1966?1617,1958,1632,1947?1651,1934,1675,1924?1693,1908,1717,1897?1741,1884,1765,1873?1786,1863,1786,1863 | | |
| | |
| | |
| | |
|
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | |
| | | | | | |
| | | |
| | | | |
|
| |
| |
]certResult[]
[Logging Date Time: 2016-11-10 10:32:58,054] =====================================================================================
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-11-10 10:32:58,054] =====================================================================================
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-11-10 10:32:58,056] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]]
[Logging Date Time: 2016-11-10 10:32:58,056] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Parameters: [param0=[sub_cd,CONSENT_DATA]]
[Logging Date Time: 2016-11-10 10:32:58,056] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]
[Logging Date Time: 2016-11-10 10:32:58,056] =====================================================================================
SQL Command - Statement Id: [GET_SEQUENCE] Types: [param0=[AnsiString, System.String]]
[Logging Date Time: 2016-11-10 10:32:58,084] =====================================================================================
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-11-10 10:32:58,084] =====================================================================================
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-11-10 10:32:58,085] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,1788], param1=[sub_cd,CONSENT_DATA]]
[Logging Date Time: 2016-11-10 10:32:58,085] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Parameters: [param0=[ud1_num,1788], param1=[sub_cd,CONSENT_DATA]]
[Logging Date Time: 2016-11-10 10:32:58,085] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]
[Logging Date Time: 2016-11-10 10:32:58,085] =====================================================================================
SQL Command - Statement Id: [UPDATE_SEQUENCE] Types: [param0=[Int32, System.Int32], param1=[AnsiString, System.String]]
[Logging Date Time: 2016-11-10 10:32:58,095] =====================================================================================
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'), MODIFY_USER_NAME = COM.FN_ZS_GETUSERNM( :param3 , TO_CHAR(SYSDATE, 'YYYYMMDD')) WHERE CONSENT_MST_RID = :param4]
[Logging Date Time: 2016-11-10 10:32:58,095] =====================================================================================
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'), MODIFY_USER_NAME = COM.FN_ZS_GETUSERNM( :param3 , TO_CHAR(SYSDATE, 'YYYYMMDD')) WHERE CONSENT_MST_RID = :param4]
[Logging Date Time: 2016-11-10 10:32:58,095] =====================================================================================
SQL Command - Statement Id: [UPDATE_CONSENT_MST] Parameters: [param0=[consentState,ELECTR_CMP], param1=[completeYn,Y], param2=[paperYn,N], param3=[userId,105066], param4=[consentMstRid,1842]]
[Logging Date Time: 2016-11-10 10:32:58,095] =====================================================================================
SQL Command - Statement Id: [UPDATE_CONSENT_MST] Parameters: [param0=[consentState,ELECTR_CMP], param1=[completeYn,Y], param2=[paperYn,N], param3=[userId,105066], param4=[consentMstRid,1842]]
[Logging Date Time: 2016-11-10 10:32:58,095] =====================================================================================
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-11-10 10:32:58,095] =====================================================================================
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-11-10 10:32:58,097] =====================================================================================
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-11-10 10:32:58,097] =====================================================================================
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-11-10 10:32:58,098] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,1788], param1=[consentMstRid,1842], param2=[formRid,1307], param3=[deviceType,WIN], param4=[deviceIdentNo,16-101-33], param5=[completeYn,Y], param6=[userId,105066], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]]
[Logging Date Time: 2016-11-10 10:32:58,098] =====================================================================================
SQL Command - Statement Id: [INSERT_CONSENT_DATA] Parameters: [param0=[consentDataRid,1788], param1=[consentMstRid,1842], param2=[formRid,1307], param3=[deviceType,WIN], param4=[deviceIdentNo,16-101-33], param5=[completeYn,Y], param6=[userId,105066], param7=[formXml,System.Byte[]], param8=[dataXml,System.Byte[]]]
[Logging Date Time: 2016-11-10 10:32:58,098] =====================================================================================
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-11-10 10:32:58,098] =====================================================================================
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-11-10 10:32:58,635] =====================================================================================
SQL Command - CLIP.eForm SaveDataAll ERROR : [System.NullReferenceException: 개체 참조가 개체의 인스턴스로 설정되지 않았습니다.
위치: CLIP.eForm.Consent.Dfh.WebService.ConsentSvc.imageUpload(SaveConsentDac dac, Hashtable paramHashTable, String userId, String patientCode, String visitType, String clnDate, String Dschdd, Int32 cretno, String ocrcode, Int32 consentMstRid, String consentState, String formCd, Int32 formRid, String dataXml, String imageFileJson, String certTarget, String certResult, String hosType, String createUserName) 파일 D:\TeamDFH_Consent\DFH-Consent\CLIP.e-Form.Consent.Dfh.Web\ConsentSvc.asmx.cs:줄 971
위치: CLIP.eForm.Consent.Dfh.WebService.ConsentSvc.SaveDataAll(String userId, String patientCode, String clnDeptCode, Int32 formRid, String formCd, Int32 consentMstRid, Int32 rewriteConsentMstRid, Int32 reissueConsentMstRid, String consentState, String paperYn, String formXml, String dataXml, String deviceType, String deviceIdentNo, String vistType, String hosType, String clnDate, String ward, String roomcd, String reasonForUseN, Int32 orderNo, String orderName, String orderCd, String ocrCode, Int32 cretno, String createUserName, String modifyUserName, String imageFileJson, String certTarget, String certResult, String dschdd, String mainDrId) 파일 D:\TeamDFH_Consent\DFH-Consent\CLIP.e-Form.Consent.Dfh.Web\ConsentSvc.asmx.cs:줄 901]
[Logging Date Time: 2016-11-10 10:34:37,928] =====================================================================================
SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] PreparedStatement : [SELECT CATEGORY_TYPE, CATEGORY_ID, CATEGORY_NAME FROM EFORM_CATEGORY WHERE USE_YN = 'Y' AND P_CATEGORY_RID = '1']
[Logging Date Time: 2016-11-10 10:34:37,928] =====================================================================================
SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] PreparedStatement : [SELECT CATEGORY_TYPE, CATEGORY_ID, CATEGORY_NAME FROM EFORM_CATEGORY WHERE USE_YN = 'Y' AND P_CATEGORY_RID = '1']
[Logging Date Time: 2016-11-10 10:34:38,058] =====================================================================================
SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] PreparedStatement : [SELECT CATEGORY_TYPE, CATEGORY_ID, CATEGORY_NAME FROM EFORM_CATEGORY WHERE USE_YN = 'Y' AND P_CATEGORY_RID = (SELECT CATEGORY_RID FROM EFORM_CATEGORY WHERE CATEGORY_ID = :param0 )]
[Logging Date Time: 2016-11-10 10:34:38,058] =====================================================================================
SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] PreparedStatement : [SELECT CATEGORY_TYPE, CATEGORY_ID, CATEGORY_NAME FROM EFORM_CATEGORY WHERE USE_YN = 'Y' AND P_CATEGORY_RID = (SELECT CATEGORY_RID FROM EFORM_CATEGORY WHERE CATEGORY_ID = :param0 )]
[Logging Date Time: 2016-11-10 10:34:38,059] =====================================================================================
SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] Parameters: [param0=[category_id,1CB1B494-1EF0-48BD-84D6-4965A54E6AEA]]
[Logging Date Time: 2016-11-10 10:34:38,059] =====================================================================================
SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] Parameters: [param0=[category_id,1CB1B494-1EF0-48BD-84D6-4965A54E6AEA]]
[Logging Date Time: 2016-11-10 10:34:38,059] =====================================================================================
SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] Types: [param0=[AnsiString, System.String]]
[Logging Date Time: 2016-11-10 10:34:38,059] =====================================================================================
SQL Command - Statement Id: [GET_CATEGORY_FOR_DROPDOWN] Types: [param0=[AnsiString, System.String]]
[Logging Date Time: 2016-11-10 11:00:16,471] =====================================================================================
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', '미작성', 'VERBAL', '구두') 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 and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM , COM.FN_ZS_GETDEPTNAME('111', (select dept.deptcd from com.zsdddept dept where dept.instcd = '111' and dept.valitodd = '99991231' and dept.deptengabbr = CM.WARDCD), '99991231') as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE AS CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.MODIFY_USER_ID AS CREATE_USER_ID , CM.MODIFY_USER_NAME AS CREATE_USER_NAME , CM.MODIFY_DATETIME AS CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO , (SELECT OCRTAGPRNTYN FROM V_EFORM_FORMDOC F WHERE F.FORM_RID = CM.FORM_RID ) AS OCRTAGPRNTYN FROM CONSENT_MST CM INNER JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID, EMR.MRFMFORM C WHERE CM.USE_YN = 'Y' AND CM.PID = :param0 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param1 and :param2 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY CONSENT_STATE DESC, CREATE_DATETIME DESC]
[Logging Date Time: 2016-11-10 11:00:16,471] =====================================================================================
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', '미작성', 'VERBAL', '구두') 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 and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM , COM.FN_ZS_GETDEPTNAME('111', (select dept.deptcd from com.zsdddept dept where dept.instcd = '111' and dept.valitodd = '99991231' and dept.deptengabbr = CM.WARDCD), '99991231') as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE AS CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.MODIFY_USER_ID AS CREATE_USER_ID , CM.MODIFY_USER_NAME AS CREATE_USER_NAME , CM.MODIFY_DATETIME AS CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO , (SELECT OCRTAGPRNTYN FROM V_EFORM_FORMDOC F WHERE F.FORM_RID = CM.FORM_RID ) AS OCRTAGPRNTYN FROM CONSENT_MST CM INNER JOIN EFORM_DOCUMENT VEF ON VEF.FORM_RID = CM.FORM_RID, EMR.MRFMFORM C WHERE CM.USE_YN = 'Y' AND CM.PID = :param0 AND TO_CHAR(TO_DATE(CM.CREATE_DATETIME, 'YYYY-MM-DD HH24:MI:SS'), 'YYYYMMDD') BETWEEN :param1 and :param2 AND VEF.FORM_CD = C.FORMCD AND C.instcd = '111' AND C.formprogflag LIKE 'OCR%' AND C.formlevlcd != '-' AND SUBSTR (C.formtodt, 1, 8) = '99991231' AND CM.CONSENT_STATE IN ('UNFINISHED','TEMP') ORDER BY CONSENT_STATE DESC, CREATE_DATETIME DESC]
[Logging Date Time: 2016-11-10 11:00:16,567] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,1715813], param1=[startDt,20010601], param2=[endDt,20161110]]
[Logging Date Time: 2016-11-10 11:00:16,567] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,1715813], param1=[startDt,20010601], param2=[endDt,20161110]]
[Logging Date Time: 2016-11-10 11:00:16,568] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]
[Logging Date Time: 2016-11-10 11:00:16,568] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]
[Logging Date Time: 2016-11-10 11:01:12,351] =====================================================================================
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', '미작성', 'VERBAL', '구두') 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 and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM , COM.FN_ZS_GETDEPTNAME('111', (select dept.deptcd from com.zsdddept dept where dept.instcd = '111' and dept.valitodd = '99991231' and dept.deptengabbr = CM.WARDCD), '99991231') as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE AS CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.MODIFY_USER_ID AS CREATE_USER_ID , CM.MODIFY_USER_NAME AS CREATE_USER_NAME , CM.MODIFY_DATETIME AS CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO , (SELECT OCRTAGPRNTYN FROM V_EFORM_FORMDOC F WHERE F.FORM_RID = CM.FORM_RID ) AS OCRTAGPRNTYN 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' UNION ALL SELECT NULL as CONSENT_MST_RID, case when b.formcd = '1300010308' then '출력' else 'FNU출력' end AS CONSENT_STATE_DISP, D.FORMNM AS CONSENT_NAME, A.INSTCD AS HOS_TYPE, B.PID AS PID, B.ORDTYPE AS VISIT_TYPE, NULL AS ORDER_NO, '' AS ORDER_CD, '' AS ORDER_NAME, B.ORDDEPTCD AS CLN_DEPT_CD, (SELECT depthngnm FROM com.zsdddept WHERE deptcd = b.orddeptcd AND instcd = b.instcd AND valifromdd <= b.orddd AND valitodd >= b.orddd) as CLN_DEPT_NM, (select (select dept.depthngnm from com.zsdddept dept where deptcd = inpt.wardcd and dept.valitodd = '99991231') from pam.pmihinpt inpt where inpt.instcd = '111' and inpt.pid = b.pid and inpt.indd = b.orddd and inpt.histstat = 'Y' and inpt.mskind = 'M' and inpt.cretno = b.cretno) AS WARDCD, '' AS ROOMCD, (SELECT V.FORM_RID FROM CMR.V_EFORM_FORMDOC V WHERE V.FORM_CD = B.FORMCD) AS FORM_RID, B.FORMCD AS FORM_CD, (SELECT V.FORM_GUID FROM CMR.V_EFORM_FORMDOC V WHERE V.FORM_CD = B.FORMCD) AS FORM_GUID, D.PRNTCNT, case when b.formcd = '1300010308' then 'PAPER_OUT' else 'FNU_PRINT' end AS CONSENT_STATE, A.OCRTAG AS OCR_NUMBER, '' AS COSIGN_CD_ID, '' AS COSIGN_DC_NAME, A.LASTUPDTRID AS CREATE_USER_ID, COM.FN_ZS_GETUSERNM(A.LASTUPDTRID, B.ORDDD) AS CREATE_USER_NAME, TO_CHAR(A.LASTUPDTDT,'YYYY-MM-DD HH24:MI:SS')AS CREATE_DATETIME, B.ORDDD AS CLN_DATE, B.CRETNO, DECODE(A.OCRTAG, '', 'N', 'Y' ) AS OCRTAGPRNTYN FROM emr.mrfhocrprnt a, emr.mrfmocrprnt b, pam.pmcmptbs c, emr.mrfmform d WHERE a.instcd = '111' AND a.ocrtag = b.ocrtag AND a.updtdt = b.FSTPRNTDT AND a.statcd = 'P' AND a.instcd = b.instcd AND b.instcd = c.instcd AND b.pid = c.pid AND b.instcd = d.instcd AND b.formcd = d.formcd AND b.formfromdt = d.formfromdt AND b.orddd >= :param1 AND b.orddd <= :param2 and b.pid = :param0 and not exists (select '1' from cmr.consent_mst mst where mst.hos_type = '111' and mst.use_yn = 'Y' and mst.ocr_number = a.ocrtag) ORDER BY CONSENT_STATE DESC, CREATE_DATETIME DESC]
[Logging Date Time: 2016-11-10 11:01:12,351] =====================================================================================
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', '미작성', 'VERBAL', '구두') 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 and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM , COM.FN_ZS_GETDEPTNAME('111', (select dept.deptcd from com.zsdddept dept where dept.instcd = '111' and dept.valitodd = '99991231' and dept.deptengabbr = CM.WARDCD), '99991231') as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE AS CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.MODIFY_USER_ID AS CREATE_USER_ID , CM.MODIFY_USER_NAME AS CREATE_USER_NAME , CM.MODIFY_DATETIME AS CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO , (SELECT OCRTAGPRNTYN FROM V_EFORM_FORMDOC F WHERE F.FORM_RID = CM.FORM_RID ) AS OCRTAGPRNTYN 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' UNION ALL SELECT NULL as CONSENT_MST_RID, case when b.formcd = '1300010308' then '출력' else 'FNU출력' end AS CONSENT_STATE_DISP, D.FORMNM AS CONSENT_NAME, A.INSTCD AS HOS_TYPE, B.PID AS PID, B.ORDTYPE AS VISIT_TYPE, NULL AS ORDER_NO, '' AS ORDER_CD, '' AS ORDER_NAME, B.ORDDEPTCD AS CLN_DEPT_CD, (SELECT depthngnm FROM com.zsdddept WHERE deptcd = b.orddeptcd AND instcd = b.instcd AND valifromdd <= b.orddd AND valitodd >= b.orddd) as CLN_DEPT_NM, (select (select dept.depthngnm from com.zsdddept dept where deptcd = inpt.wardcd and dept.valitodd = '99991231') from pam.pmihinpt inpt where inpt.instcd = '111' and inpt.pid = b.pid and inpt.indd = b.orddd and inpt.histstat = 'Y' and inpt.mskind = 'M' and inpt.cretno = b.cretno) AS WARDCD, '' AS ROOMCD, (SELECT V.FORM_RID FROM CMR.V_EFORM_FORMDOC V WHERE V.FORM_CD = B.FORMCD) AS FORM_RID, B.FORMCD AS FORM_CD, (SELECT V.FORM_GUID FROM CMR.V_EFORM_FORMDOC V WHERE V.FORM_CD = B.FORMCD) AS FORM_GUID, D.PRNTCNT, case when b.formcd = '1300010308' then 'PAPER_OUT' else 'FNU_PRINT' end AS CONSENT_STATE, A.OCRTAG AS OCR_NUMBER, '' AS COSIGN_CD_ID, '' AS COSIGN_DC_NAME, A.LASTUPDTRID AS CREATE_USER_ID, COM.FN_ZS_GETUSERNM(A.LASTUPDTRID, B.ORDDD) AS CREATE_USER_NAME, TO_CHAR(A.LASTUPDTDT,'YYYY-MM-DD HH24:MI:SS')AS CREATE_DATETIME, B.ORDDD AS CLN_DATE, B.CRETNO, DECODE(A.OCRTAG, '', 'N', 'Y' ) AS OCRTAGPRNTYN FROM emr.mrfhocrprnt a, emr.mrfmocrprnt b, pam.pmcmptbs c, emr.mrfmform d WHERE a.instcd = '111' AND a.ocrtag = b.ocrtag AND a.updtdt = b.FSTPRNTDT AND a.statcd = 'P' AND a.instcd = b.instcd AND b.instcd = c.instcd AND b.pid = c.pid AND b.instcd = d.instcd AND b.formcd = d.formcd AND b.formfromdt = d.formfromdt AND b.orddd >= :param1 AND b.orddd <= :param2 and b.pid = :param0 and not exists (select '1' from cmr.consent_mst mst where mst.hos_type = '111' and mst.use_yn = 'Y' and mst.ocr_number = a.ocrtag) ORDER BY CONSENT_STATE DESC, CREATE_DATETIME DESC]
[Logging Date Time: 2016-11-10 11:01:12,352] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,1715813], param1=[startDt,20161110], param2=[endDt,20161110]]
[Logging Date Time: 2016-11-10 11:01:12,352] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,1715813], param1=[startDt,20161110], param2=[endDt,20161110]]
[Logging Date Time: 2016-11-10 11:01:12,352] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]
[Logging Date Time: 2016-11-10 11:01:12,352] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]
[Logging Date Time: 2016-11-10 11:01:17,824] =====================================================================================
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', '미작성', 'VERBAL', '구두') 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 and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM , COM.FN_ZS_GETDEPTNAME('111', (select dept.deptcd from com.zsdddept dept where dept.instcd = '111' and dept.valitodd = '99991231' and dept.deptengabbr = CM.WARDCD), '99991231') as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE AS CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.MODIFY_USER_ID AS CREATE_USER_ID , CM.MODIFY_USER_NAME AS CREATE_USER_NAME , CM.MODIFY_DATETIME AS CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO , (SELECT OCRTAGPRNTYN FROM V_EFORM_FORMDOC F WHERE F.FORM_RID = CM.FORM_RID ) AS OCRTAGPRNTYN 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' UNION ALL SELECT NULL as CONSENT_MST_RID, case when b.formcd = '1300010308' then '출력' else 'FNU출력' end AS CONSENT_STATE_DISP, D.FORMNM AS CONSENT_NAME, A.INSTCD AS HOS_TYPE, B.PID AS PID, B.ORDTYPE AS VISIT_TYPE, NULL AS ORDER_NO, '' AS ORDER_CD, '' AS ORDER_NAME, B.ORDDEPTCD AS CLN_DEPT_CD, (SELECT depthngnm FROM com.zsdddept WHERE deptcd = b.orddeptcd AND instcd = b.instcd AND valifromdd <= b.orddd AND valitodd >= b.orddd) as CLN_DEPT_NM, (select (select dept.depthngnm from com.zsdddept dept where deptcd = inpt.wardcd and dept.valitodd = '99991231') from pam.pmihinpt inpt where inpt.instcd = '111' and inpt.pid = b.pid and inpt.indd = b.orddd and inpt.histstat = 'Y' and inpt.mskind = 'M' and inpt.cretno = b.cretno) AS WARDCD, '' AS ROOMCD, (SELECT V.FORM_RID FROM CMR.V_EFORM_FORMDOC V WHERE V.FORM_CD = B.FORMCD) AS FORM_RID, B.FORMCD AS FORM_CD, (SELECT V.FORM_GUID FROM CMR.V_EFORM_FORMDOC V WHERE V.FORM_CD = B.FORMCD) AS FORM_GUID, D.PRNTCNT, case when b.formcd = '1300010308' then 'PAPER_OUT' else 'FNU_PRINT' end AS CONSENT_STATE, A.OCRTAG AS OCR_NUMBER, '' AS COSIGN_CD_ID, '' AS COSIGN_DC_NAME, A.LASTUPDTRID AS CREATE_USER_ID, COM.FN_ZS_GETUSERNM(A.LASTUPDTRID, B.ORDDD) AS CREATE_USER_NAME, TO_CHAR(A.LASTUPDTDT,'YYYY-MM-DD HH24:MI:SS')AS CREATE_DATETIME, B.ORDDD AS CLN_DATE, B.CRETNO, DECODE(A.OCRTAG, '', 'N', 'Y' ) AS OCRTAGPRNTYN FROM emr.mrfhocrprnt a, emr.mrfmocrprnt b, pam.pmcmptbs c, emr.mrfmform d WHERE a.instcd = '111' AND a.ocrtag = b.ocrtag AND a.updtdt = b.FSTPRNTDT AND a.statcd = 'P' AND a.instcd = b.instcd AND b.instcd = c.instcd AND b.pid = c.pid AND b.instcd = d.instcd AND b.formcd = d.formcd AND b.formfromdt = d.formfromdt AND b.orddd >= :param1 AND b.orddd <= :param2 and b.pid = :param0 and not exists (select '1' from cmr.consent_mst mst where mst.hos_type = '111' and mst.use_yn = 'Y' and mst.ocr_number = a.ocrtag) ORDER BY CONSENT_STATE DESC, CREATE_DATETIME DESC]
[Logging Date Time: 2016-11-10 11:01:17,824] =====================================================================================
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', '미작성', 'VERBAL', '구두') 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 and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM , COM.FN_ZS_GETDEPTNAME('111', (select dept.deptcd from com.zsdddept dept where dept.instcd = '111' and dept.valitodd = '99991231' and dept.deptengabbr = CM.WARDCD), '99991231') as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE AS CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.MODIFY_USER_ID AS CREATE_USER_ID , CM.MODIFY_USER_NAME AS CREATE_USER_NAME , CM.MODIFY_DATETIME AS CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO , (SELECT OCRTAGPRNTYN FROM V_EFORM_FORMDOC F WHERE F.FORM_RID = CM.FORM_RID ) AS OCRTAGPRNTYN 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' UNION ALL SELECT NULL as CONSENT_MST_RID, case when b.formcd = '1300010308' then '출력' else 'FNU출력' end AS CONSENT_STATE_DISP, D.FORMNM AS CONSENT_NAME, A.INSTCD AS HOS_TYPE, B.PID AS PID, B.ORDTYPE AS VISIT_TYPE, NULL AS ORDER_NO, '' AS ORDER_CD, '' AS ORDER_NAME, B.ORDDEPTCD AS CLN_DEPT_CD, (SELECT depthngnm FROM com.zsdddept WHERE deptcd = b.orddeptcd AND instcd = b.instcd AND valifromdd <= b.orddd AND valitodd >= b.orddd) as CLN_DEPT_NM, (select (select dept.depthngnm from com.zsdddept dept where deptcd = inpt.wardcd and dept.valitodd = '99991231') from pam.pmihinpt inpt where inpt.instcd = '111' and inpt.pid = b.pid and inpt.indd = b.orddd and inpt.histstat = 'Y' and inpt.mskind = 'M' and inpt.cretno = b.cretno) AS WARDCD, '' AS ROOMCD, (SELECT V.FORM_RID FROM CMR.V_EFORM_FORMDOC V WHERE V.FORM_CD = B.FORMCD) AS FORM_RID, B.FORMCD AS FORM_CD, (SELECT V.FORM_GUID FROM CMR.V_EFORM_FORMDOC V WHERE V.FORM_CD = B.FORMCD) AS FORM_GUID, D.PRNTCNT, case when b.formcd = '1300010308' then 'PAPER_OUT' else 'FNU_PRINT' end AS CONSENT_STATE, A.OCRTAG AS OCR_NUMBER, '' AS COSIGN_CD_ID, '' AS COSIGN_DC_NAME, A.LASTUPDTRID AS CREATE_USER_ID, COM.FN_ZS_GETUSERNM(A.LASTUPDTRID, B.ORDDD) AS CREATE_USER_NAME, TO_CHAR(A.LASTUPDTDT,'YYYY-MM-DD HH24:MI:SS')AS CREATE_DATETIME, B.ORDDD AS CLN_DATE, B.CRETNO, DECODE(A.OCRTAG, '', 'N', 'Y' ) AS OCRTAGPRNTYN FROM emr.mrfhocrprnt a, emr.mrfmocrprnt b, pam.pmcmptbs c, emr.mrfmform d WHERE a.instcd = '111' AND a.ocrtag = b.ocrtag AND a.updtdt = b.FSTPRNTDT AND a.statcd = 'P' AND a.instcd = b.instcd AND b.instcd = c.instcd AND b.pid = c.pid AND b.instcd = d.instcd AND b.formcd = d.formcd AND b.formfromdt = d.formfromdt AND b.orddd >= :param1 AND b.orddd <= :param2 and b.pid = :param0 and not exists (select '1' from cmr.consent_mst mst where mst.hos_type = '111' and mst.use_yn = 'Y' and mst.ocr_number = a.ocrtag) ORDER BY CONSENT_STATE DESC, CREATE_DATETIME DESC]
[Logging Date Time: 2016-11-10 11:01:17,824] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,1715813], param1=[startDt,20161108], param2=[endDt,20161110]]
[Logging Date Time: 2016-11-10 11:01:17,824] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,1715813], param1=[startDt,20161108], param2=[endDt,20161110]]
[Logging Date Time: 2016-11-10 11:01:17,825] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]
[Logging Date Time: 2016-11-10 11:01:17,825] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]
[Logging Date Time: 2016-11-10 11:01:25,888] =====================================================================================
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', '미작성', 'VERBAL', '구두') 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 and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM , COM.FN_ZS_GETDEPTNAME('111', (select dept.deptcd from com.zsdddept dept where dept.instcd = '111' and dept.valitodd = '99991231' and dept.deptengabbr = CM.WARDCD), '99991231') as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE AS CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.MODIFY_USER_ID AS CREATE_USER_ID , CM.MODIFY_USER_NAME AS CREATE_USER_NAME , CM.MODIFY_DATETIME AS CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO , (SELECT OCRTAGPRNTYN FROM V_EFORM_FORMDOC F WHERE F.FORM_RID = CM.FORM_RID ) AS OCRTAGPRNTYN 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' UNION ALL SELECT NULL as CONSENT_MST_RID, case when b.formcd = '1300010308' then '출력' else 'FNU출력' end AS CONSENT_STATE_DISP, D.FORMNM AS CONSENT_NAME, A.INSTCD AS HOS_TYPE, B.PID AS PID, B.ORDTYPE AS VISIT_TYPE, NULL AS ORDER_NO, '' AS ORDER_CD, '' AS ORDER_NAME, B.ORDDEPTCD AS CLN_DEPT_CD, (SELECT depthngnm FROM com.zsdddept WHERE deptcd = b.orddeptcd AND instcd = b.instcd AND valifromdd <= b.orddd AND valitodd >= b.orddd) as CLN_DEPT_NM, (select (select dept.depthngnm from com.zsdddept dept where deptcd = inpt.wardcd and dept.valitodd = '99991231') from pam.pmihinpt inpt where inpt.instcd = '111' and inpt.pid = b.pid and inpt.indd = b.orddd and inpt.histstat = 'Y' and inpt.mskind = 'M' and inpt.cretno = b.cretno) AS WARDCD, '' AS ROOMCD, (SELECT V.FORM_RID FROM CMR.V_EFORM_FORMDOC V WHERE V.FORM_CD = B.FORMCD) AS FORM_RID, B.FORMCD AS FORM_CD, (SELECT V.FORM_GUID FROM CMR.V_EFORM_FORMDOC V WHERE V.FORM_CD = B.FORMCD) AS FORM_GUID, D.PRNTCNT, case when b.formcd = '1300010308' then 'PAPER_OUT' else 'FNU_PRINT' end AS CONSENT_STATE, A.OCRTAG AS OCR_NUMBER, '' AS COSIGN_CD_ID, '' AS COSIGN_DC_NAME, A.LASTUPDTRID AS CREATE_USER_ID, COM.FN_ZS_GETUSERNM(A.LASTUPDTRID, B.ORDDD) AS CREATE_USER_NAME, TO_CHAR(A.LASTUPDTDT,'YYYY-MM-DD HH24:MI:SS')AS CREATE_DATETIME, B.ORDDD AS CLN_DATE, B.CRETNO, DECODE(A.OCRTAG, '', 'N', 'Y' ) AS OCRTAGPRNTYN FROM emr.mrfhocrprnt a, emr.mrfmocrprnt b, pam.pmcmptbs c, emr.mrfmform d WHERE a.instcd = '111' AND a.ocrtag = b.ocrtag AND a.updtdt = b.FSTPRNTDT AND a.statcd = 'P' AND a.instcd = b.instcd AND b.instcd = c.instcd AND b.pid = c.pid AND b.instcd = d.instcd AND b.formcd = d.formcd AND b.formfromdt = d.formfromdt AND b.orddd >= :param1 AND b.orddd <= :param2 and b.pid = :param0 and not exists (select '1' from cmr.consent_mst mst where mst.hos_type = '111' and mst.use_yn = 'Y' and mst.ocr_number = a.ocrtag) ORDER BY CONSENT_STATE DESC, CREATE_DATETIME DESC]
[Logging Date Time: 2016-11-10 11:01:25,888] =====================================================================================
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', '미작성', 'VERBAL', '구두') 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 and valitodd = '99991231' and instcd = '111') AS CLN_DEPT_NM , COM.FN_ZS_GETDEPTNAME('111', (select dept.deptcd from com.zsdddept dept where dept.instcd = '111' and dept.valitodd = '99991231' and dept.deptengabbr = CM.WARDCD), '99991231') as WARDCD , CM.ROOMCD , CM.FORM_RID , VEF.FORM_CD , VEF.FORM_GUID , C.PRNTCNT , CM.CONSENT_STATE AS CONSENT_STATE , CM.OCR_NUMBER , CM.COSIGN_DC_ID , CM.COSIGN_DC_NAME , CM.MODIFY_USER_ID AS CREATE_USER_ID , CM.MODIFY_USER_NAME AS CREATE_USER_NAME , CM.MODIFY_DATETIME AS CREATE_DATETIME , CM.CLN_DATE , CM.CRETNO , (SELECT OCRTAGPRNTYN FROM V_EFORM_FORMDOC F WHERE F.FORM_RID = CM.FORM_RID ) AS OCRTAGPRNTYN 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' UNION ALL SELECT NULL as CONSENT_MST_RID, case when b.formcd = '1300010308' then '출력' else 'FNU출력' end AS CONSENT_STATE_DISP, D.FORMNM AS CONSENT_NAME, A.INSTCD AS HOS_TYPE, B.PID AS PID, B.ORDTYPE AS VISIT_TYPE, NULL AS ORDER_NO, '' AS ORDER_CD, '' AS ORDER_NAME, B.ORDDEPTCD AS CLN_DEPT_CD, (SELECT depthngnm FROM com.zsdddept WHERE deptcd = b.orddeptcd AND instcd = b.instcd AND valifromdd <= b.orddd AND valitodd >= b.orddd) as CLN_DEPT_NM, (select (select dept.depthngnm from com.zsdddept dept where deptcd = inpt.wardcd and dept.valitodd = '99991231') from pam.pmihinpt inpt where inpt.instcd = '111' and inpt.pid = b.pid and inpt.indd = b.orddd and inpt.histstat = 'Y' and inpt.mskind = 'M' and inpt.cretno = b.cretno) AS WARDCD, '' AS ROOMCD, (SELECT V.FORM_RID FROM CMR.V_EFORM_FORMDOC V WHERE V.FORM_CD = B.FORMCD) AS FORM_RID, B.FORMCD AS FORM_CD, (SELECT V.FORM_GUID FROM CMR.V_EFORM_FORMDOC V WHERE V.FORM_CD = B.FORMCD) AS FORM_GUID, D.PRNTCNT, case when b.formcd = '1300010308' then 'PAPER_OUT' else 'FNU_PRINT' end AS CONSENT_STATE, A.OCRTAG AS OCR_NUMBER, '' AS COSIGN_CD_ID, '' AS COSIGN_DC_NAME, A.LASTUPDTRID AS CREATE_USER_ID, COM.FN_ZS_GETUSERNM(A.LASTUPDTRID, B.ORDDD) AS CREATE_USER_NAME, TO_CHAR(A.LASTUPDTDT,'YYYY-MM-DD HH24:MI:SS')AS CREATE_DATETIME, B.ORDDD AS CLN_DATE, B.CRETNO, DECODE(A.OCRTAG, '', 'N', 'Y' ) AS OCRTAGPRNTYN FROM emr.mrfhocrprnt a, emr.mrfmocrprnt b, pam.pmcmptbs c, emr.mrfmform d WHERE a.instcd = '111' AND a.ocrtag = b.ocrtag AND a.updtdt = b.FSTPRNTDT AND a.statcd = 'P' AND a.instcd = b.instcd AND b.instcd = c.instcd AND b.pid = c.pid AND b.instcd = d.instcd AND b.formcd = d.formcd AND b.formfromdt = d.formfromdt AND b.orddd >= :param1 AND b.orddd <= :param2 and b.pid = :param0 and not exists (select '1' from cmr.consent_mst mst where mst.hos_type = '111' and mst.use_yn = 'Y' and mst.ocr_number = a.ocrtag) ORDER BY CONSENT_STATE DESC, CREATE_DATETIME DESC]
[Logging Date Time: 2016-11-10 11:01:25,889] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,1715813], param1=[startDt,20161003], param2=[endDt,20161110]]
[Logging Date Time: 2016-11-10 11:01:25,889] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Parameters: [param0=[patientCode,1715813], param1=[startDt,20161003], param2=[endDt,20161110]]
[Logging Date Time: 2016-11-10 11:01:25,889] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]
[Logging Date Time: 2016-11-10 11:01:25,889] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_LIST] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]
[Logging Date Time: 2016-11-10 11:04:19,860] =====================================================================================
SQL Command - CLIP.eForm SaveCompleteAll param : clnDept[105066]patientCode[1715813]clnDeptCode[2010400000]formRid[1307]formCd[1300010589]consentMstRid[1842]rewriteConsentMstRid[1842]deviceType[WIN]vistType[O]hosType[111]clnDate[20161110]ward[]roomcd[]orderNo[111]orderName[코감기]orderCd[J00.000.08]ocrCode[2016111063775]cretno[1]createUserName[이봉렬]modifyUserName[이봉렬]imageFileJson[{ "imageFile1" : "201611/10/69be4f611ab44653826689f31ee17979_1.jpg", "imageFile2" : "201611/10/69be4f611ab44653826689f31ee17979_2.jpg" }]certTarget[278a4c26b11e2327060a0f51ddad21bea5f49f32e035bcd23d468b4cd2fc3^d57fffbbe6132bb57bbd045394b7f79a3ea62f5ad6f890e1f682d91cfc25a2]dschdd[20161110]consentState[ELECTR_CMP]mainDrId[105066]dataXml[460,2204,460,2204?455,2204,452,2204?450,2201,447,2201?444,2199,442,2196?442,2191,439,2185?434,2180,434,2172?434,2167,434,2156?439,2148,442,2138?444,2125,450,2111?455,2098,460,2085?471,2069,479,2056?487,2040,500,2027?511,2011,521,1995?532,1982,542,1966?556,1953,564,1939?577,1929,585,1918?593,1908,603,1900?609,1894,614,1894?616,1894,619,1894?622,1900,622,1905?619,1918,619,1929?616,1945,611,1958?609,1976,603,1995?595,2016,590,2040?585,2061,579,2085?577,2109,569,2130?564,2154,561,2172?558,2191,558,2201?558,2209,558,2215?561,2215,564,2212?569,2204,577,2193?582,2180,590,2167?595,2151,606,2138?614,2122,619,2111?627,2098,635,2088?643,2077,648,2072?651,2066,659,2061?664,2058,667,2058?669,2058,672,2058?675,2061,677,2066?677,2069,680,2074?680,2085,680,2093?685,2101,685,2111?685,2119,688,2130?688,2140,691,2148?691,2156,693,2159?696,2167,698,2167?701,2167,704,2159?706,2156,714,2148?717,2140,722,2130?728,2119,730,2111?736,2101,743,2090?749,2085,754,2074?759,2072,762,2066?770,2064,773,2064?773,2061,775,2064?778,2064,778,2066?781,2069,781,2072?783,2074,783,2077?783,2085,786,2088?788,2090,788,2096?791,2098,791,2101?796,2109,799,2111?799,2114,802,2117?804,2117,804,2119?807,2122,807,2122?810,2125,812,2125?815,2125,818,2122?823,2119,826,2117?831,2114,833,2111?836,2103,839,2101?841,2098,844,2096?844,2096466,1254,466,1254?460,1262,458,1265?458,1265,458,1265?458,1265,460,1265?460,1262,468,1254?471,1249,476,1244?484,1236,495,1222?503,1214,508,1206?516,1196,527,1188?534,1180,542,1172?550,1167,556,1159?564,1154,569,1151?572,1143,579,1140?582,1138,582,1138?582,1138,582,1140?579,1140,579,1146?577,1151,569,1156?566,1162,561,1169?558,1177,556,1185?553,1193,548,1201?548,1212,542,1217?542,1225,542,1233?542,1238,542,1244?542,1246,548,1249?550,1251,553,1251?556,1251,558,1251?561,1251,566,1251?569,1249,572,1249?577,1246,579,1249?579,1251,582,1257?582,1262,582,1267?582,1273,582,1275?582,1281669,1217,669,1217?672,1217,675,1214?677,1214,680,1212?685,1212,688,1209?691,1209,691,1206?693,1206,696,1201?698,1201,701,1199?701,1199,704,1196?704,1196640,1601,640,1601?632,1609,624,1619?619,1625,614,1632?609,1638,603,1646?598,1648,598,1648?598,1648,598,1648?603,1646,609,1638?614,1632,622,1627?632,1619,643,1609?651,1601,661,1593?672,1582,680,1574?691,1566,698,1561?706,1550,714,1548?722,1543,728,1540?730,1535,736,1535?741,1529,743,1529?743,1527,743,1527?746,1529,746,1535?746,1537,746,1540?746,1543,743,1545?743,1550,743,1553?741,1561,741,1564?741,1572,743,1577?743,1582,743,1593?743,1601,746,1609?746,1619,746,1627?746,1632,749,1643?749,1648,751,1656?754,1662,754,1664?757,1672,759,1675857,1638,857,1638?860,1638,860,1638?863,1635,865,1635?868,1635,870,1632?873,1630,873,1627?878,1625,881,1622?884,1619,884,1617?886,1609,889,1603?892,1601,894,1595?894,1590,897,1580?897,1574,900,1569?900,1566,900,1561?900,1556,900,1553?900,1550,897,1548?897,1548,894,1548?892,1548,892,1550?889,1553,886,1556?884,1561,884,1566?881,1569,881,1574?878,1580,878,1585?881,1590,881,1595?884,1601,886,1603?886,1606,892,1606?894,1609,897,1609?905,1606,910,1606?915,1603,921,1598?926,1595,937,1590?942,1585,945,1580?950,1572,950,1572995,1482,995,1482?995,1479,995,1479?995,1474,995,1479?992,1479,992,1482?992,1484,990,1490?987,1495,987,1500?982,1508,982,1513?982,1519,982,1521?982,1527,987,1529?987,1529,990,1535?992,1535,995,1535?1000,1529,1005,1529?1008,1527,1016,1527?1021,1524,1027,1521?1032,1521,1035,1519?1037,1519,1042,1519?1042,1519,1045,1519?1045,1519,1045,1521?1045,1524,1045,1527?1042,1529,1037,1535?1037,1540,1035,1543?1032,1548,1032,1550?1029,1553,1029,15531130,1397,1130,1397?1132,1389,1138,1386?1140,1384,1146,1381?1151,1381,1151,1381?1154,1381,1156,1381?1156,1381,1159,1384?1159,1384,1159,1389?1159,1392,1159,1397?1159,1402,1159,1408?1159,1413,1159,1418?1162,1426,1162,1431?1162,1434,1164,1439?1164,1442,1167,1445?1169,1447,1172,1447?1177,1453,1180,1453?1185,1453,1191,1447?1196,1447,1206,1445?1212,1442,1220,1439?1225,1434,1236,1431?1241,1429,1249,1426?1254,1421,1265,1416?1270,1416,1275,1413?1278,1410,1281,1408?1281,1408,1281,14081159,1460,1159,1460?1156,1463,1154,1466?1154,1468,1154,1468?1156,1466,1162,1463?1167,1460,1172,1458?1180,1455,1188,1447?1193,1445,1199,1439?1209,1437,1214,1431?1220,1429,1225,1426?1233,1421,1233,1421881,2267,881,2267?878,2273,878,2273?878,2273,878,2273?873,2267,873,2267?878,2265,878,2265?881,2262,884,2257?889,2254,894,2249?900,2241,908,2236?915,2228,923,2220?934,2207,945,2199?955,2185,966,2178?976,2167,990,2154?997,2146,1005,2138?1016,2130,1016,21301024,2103,1024,2103?1019,2109,1013,2114?1003,2117,1000,2122?997,2125,992,2127?990,2133,987,2138?982,2143,979,2148?979,2154,976,2159?976,2170,976,2178?976,2185,976,2199?976,2209,976,2225?979,2238,979,2254?982,2273,987,2289?987,2307,990,2323?992,2342,995,2363?997,2376,1000,2394?1003,2410,1005,2421?1008,2432,1013,2442?1016,2447,1019,2453?1021,2453,1024,24551106,2275,1106,2275?1109,2275,1109,2275?1109,2278,1109,2281?1109,2283,1106,2286?1106,2291,1103,2294?1103,2302,1103,2305?1103,2307,1103,2307?1106,2307,1106,2307?1109,2307,1111,2305?1114,2302,1119,2297?1124,2291,1130,2283?1135,2278,1138,2267?1143,2257,1146,2249?1154,2236,1156,2225?1162,2215,1164,2204?1167,2196,1169,2183?1169,2178,1172,2170?1172,2164,1172,2159?1172,2156,1169,2154?1167,2154,1164,2154?1162,2154,1159,2156?1154,2164,1146,2170?1143,2175,1138,2183?1132,2193,1130,2201?1124,2209,1119,2220?1117,2230,1114,2238?1111,2249,1111,2260?1109,2267,1109,2275?1111,2283,1111,2291?1114,2297,1117,2305?1124,2307,1127,2312?1132,2312,1138,2315?1143,2315,1151,2312?1159,2312,1164,2307?1172,2305,1180,22971315,2119,1315,2119?1315,2119,1315,2117?1315,2119,1310,2122?1310,2125,1304,2130?1302,2138,1296,2146?1291,2156,1283,2167?1278,2175,1273,2185?1270,2196,1265,2207?1262,2215,1257,2222?1257,2228,1262,2230?1262,2233,1265,2233?1270,2230,1275,2228?1281,2225,1291,2220?1296,2212,1304,2207?1310,2201,1320,2199?1326,2193,1331,2191?1334,2191,1336,2191?1339,2191,1344,2193?1344,2196,1344,2199?1344,2204,1339,2209?1336,2215,1334,2225?1328,2233,1323,2241?1318,2252,1310,2260?1304,2267,1299,2281?1291,2289,1283,2297?1278,2305,1273,2310?1267,23151357,2008,1357,2008?1363,1995,1371,1984?1376,1974,1381,1963?1384,1953,1386,1945?1392,1937,1397,1931?1400,1926,1400,1921?1400,1921,1402,1921?1402,1921,1402,1924?1402,1929,1402,1934?1400,1945,1400,1955?1397,1966,1392,1979?1389,1992,1389,2008?1386,2021,1384,2037?1384,2056,1381,2069?1381,2085,1384,2098?1384,2111,1386,2122?1389,2127,1392,2138?1397,2140,1400,2143?1402,2146,1408,2146?1413,2146,1416,2146?1421,2146,1426,2143?1431,2143,1434,2140?1437,2140,1439,2138?1442,2138,1445,2133?1445,2133,1447,2130?1447,2127,1445,2125?1445,2122,1442,2119?1437,2114,1434,2111?1429,2109,1426,2103?1416,2101,1410,2096?1405,2093,1397,2090?1386,2090,1378,2088?1371,2088,1360,2088?1349,2088,1339,2088?1331,2088,1323,2090?1318,2090,1310,20931606,2170,1606,2170?1603,2172,1603,2178?1601,2180,1598,2180?1598,2183,1598,2183?1598,2183,1598,2183?1598,2183,1601,2180?1603,2178,1606,2172?1611,2167,1619,2159?1625,2151,1630,2140?1635,2130,1646,2119?1651,2109,1656,2096?1659,2085,1662,2072?1667,2061,1672,2045?1672,2032,1675,2019?1677,2006,1677,1987?1680,1974,1680,1955?1680,1939,1683,1926?1683,1910,1683,1897?1683,1884,1680,1876?1680,1868,1677,1857?1677,1852,1675,1847?1672,1844,1667,1842?1662,1839,1659,1836?1654,1836,1651,1836?1646,1839,1643,1842?1635,1847,1632,1852?1627,1863,1625,1871?1622,1881,1619,1894?1617,1908,1611,1924?1611,1937,1611,1953?1617,1968,1619,1987?1622,2003,1625,2016?1630,2032,1635,2045?1646,2061,1651,2072?1659,2085,1667,2093?1677,2103,1685,2114?1691,2119,1701,2125?1709,2130,1714,2138?1720,2140,1728,2143?1733,2146,1736,2148?1738,21511550,1995,1550,1995?1550,1995,1553,1992?1564,1990,1572,1984?1582,1976,1598,1966?1617,1958,1632,1947?1651,1934,1675,1924?1693,1908,1717,1897?1741,1884,1765,1873?1786,1863,1786,1863 | | |
| | |
| | |
| | |
|
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | |
| | | | | | |
| | | |
| | | | |
|
| |
| |
]formXml[460,2204,460,2204?455,2204,452,2204?450,2201,447,2201?444,2199,442,2196?442,2191,439,2185?434,2180,434,2172?434,2167,434,2156?439,2148,442,2138?444,2125,450,2111?455,2098,460,2085?471,2069,479,2056?487,2040,500,2027?511,2011,521,1995?532,1982,542,1966?556,1953,564,1939?577,1929,585,1918?593,1908,603,1900?609,1894,614,1894?616,1894,619,1894?622,1900,622,1905?619,1918,619,1929?616,1945,611,1958?609,1976,603,1995?595,2016,590,2040?585,2061,579,2085?577,2109,569,2130?564,2154,561,2172?558,2191,558,2201?558,2209,558,2215?561,2215,564,2212?569,2204,577,2193?582,2180,590,2167?595,2151,606,2138?614,2122,619,2111?627,2098,635,2088?643,2077,648,2072?651,2066,659,2061?664,2058,667,2058?669,2058,672,2058?675,2061,677,2066?677,2069,680,2074?680,2085,680,2093?685,2101,685,2111?685,2119,688,2130?688,2140,691,2148?691,2156,693,2159?696,2167,698,2167?701,2167,704,2159?706,2156,714,2148?717,2140,722,2130?728,2119,730,2111?736,2101,743,2090?749,2085,754,2074?759,2072,762,2066?770,2064,773,2064?773,2061,775,2064?778,2064,778,2066?781,2069,781,2072?783,2074,783,2077?783,2085,786,2088?788,2090,788,2096?791,2098,791,2101?796,2109,799,2111?799,2114,802,2117?804,2117,804,2119?807,2122,807,2122?810,2125,812,2125?815,2125,818,2122?823,2119,826,2117?831,2114,833,2111?836,2103,839,2101?841,2098,844,2096?844,2096466,1254,466,1254?460,1262,458,1265?458,1265,458,1265?458,1265,460,1265?460,1262,468,1254?471,1249,476,1244?484,1236,495,1222?503,1214,508,1206?516,1196,527,1188?534,1180,542,1172?550,1167,556,1159?564,1154,569,1151?572,1143,579,1140?582,1138,582,1138?582,1138,582,1140?579,1140,579,1146?577,1151,569,1156?566,1162,561,1169?558,1177,556,1185?553,1193,548,1201?548,1212,542,1217?542,1225,542,1233?542,1238,542,1244?542,1246,548,1249?550,1251,553,1251?556,1251,558,1251?561,1251,566,1251?569,1249,572,1249?577,1246,579,1249?579,1251,582,1257?582,1262,582,1267?582,1273,582,1275?582,1281669,1217,669,1217?672,1217,675,1214?677,1214,680,1212?685,1212,688,1209?691,1209,691,1206?693,1206,696,1201?698,1201,701,1199?701,1199,704,1196?704,1196640,1601,640,1601?632,1609,624,1619?619,1625,614,1632?609,1638,603,1646?598,1648,598,1648?598,1648,598,1648?603,1646,609,1638?614,1632,622,1627?632,1619,643,1609?651,1601,661,1593?672,1582,680,1574?691,1566,698,1561?706,1550,714,1548?722,1543,728,1540?730,1535,736,1535?741,1529,743,1529?743,1527,743,1527?746,1529,746,1535?746,1537,746,1540?746,1543,743,1545?743,1550,743,1553?741,1561,741,1564?741,1572,743,1577?743,1582,743,1593?743,1601,746,1609?746,1619,746,1627?746,1632,749,1643?749,1648,751,1656?754,1662,754,1664?757,1672,759,1675857,1638,857,1638?860,1638,860,1638?863,1635,865,1635?868,1635,870,1632?873,1630,873,1627?878,1625,881,1622?884,1619,884,1617?886,1609,889,1603?892,1601,894,1595?894,1590,897,1580?897,1574,900,1569?900,1566,900,1561?900,1556,900,1553?900,1550,897,1548?897,1548,894,1548?892,1548,892,1550?889,1553,886,1556?884,1561,884,1566?881,1569,881,1574?878,1580,878,1585?881,1590,881,1595?884,1601,886,1603?886,1606,892,1606?894,1609,897,1609?905,1606,910,1606?915,1603,921,1598?926,1595,937,1590?942,1585,945,1580?950,1572,950,1572995,1482,995,1482?995,1479,995,1479?995,1474,995,1479?992,1479,992,1482?992,1484,990,1490?987,1495,987,1500?982,1508,982,1513?982,1519,982,1521?982,1527,987,1529?987,1529,990,1535?992,1535,995,1535?1000,1529,1005,1529?1008,1527,1016,1527?1021,1524,1027,1521?1032,1521,1035,1519?1037,1519,1042,1519?1042,1519,1045,1519?1045,1519,1045,1521?1045,1524,1045,1527?1042,1529,1037,1535?1037,1540,1035,1543?1032,1548,1032,1550?1029,1553,1029,15531130,1397,1130,1397?1132,1389,1138,1386?1140,1384,1146,1381?1151,1381,1151,1381?1154,1381,1156,1381?1156,1381,1159,1384?1159,1384,1159,1389?1159,1392,1159,1397?1159,1402,1159,1408?1159,1413,1159,1418?1162,1426,1162,1431?1162,1434,1164,1439?1164,1442,1167,1445?1169,1447,1172,1447?1177,1453,1180,1453?1185,1453,1191,1447?1196,1447,1206,1445?1212,1442,1220,1439?1225,1434,1236,1431?1241,1429,1249,1426?1254,1421,1265,1416?1270,1416,1275,1413?1278,1410,1281,1408?1281,1408,1281,14081159,1460,1159,1460?1156,1463,1154,1466?1154,1468,1154,1468?1156,1466,1162,1463?1167,1460,1172,1458?1180,1455,1188,1447?1193,1445,1199,1439?1209,1437,1214,1431?1220,1429,1225,1426?1233,1421,1233,1421881,2267,881,2267?878,2273,878,2273?878,2273,878,2273?873,2267,873,2267?878,2265,878,2265?881,2262,884,2257?889,2254,894,2249?900,2241,908,2236?915,2228,923,2220?934,2207,945,2199?955,2185,966,2178?976,2167,990,2154?997,2146,1005,2138?1016,2130,1016,21301024,2103,1024,2103?1019,2109,1013,2114?1003,2117,1000,2122?997,2125,992,2127?990,2133,987,2138?982,2143,979,2148?979,2154,976,2159?976,2170,976,2178?976,2185,976,2199?976,2209,976,2225?979,2238,979,2254?982,2273,987,2289?987,2307,990,2323?992,2342,995,2363?997,2376,1000,2394?1003,2410,1005,2421?1008,2432,1013,2442?1016,2447,1019,2453?1021,2453,1024,24551106,2275,1106,2275?1109,2275,1109,2275?1109,2278,1109,2281?1109,2283,1106,2286?1106,2291,1103,2294?1103,2302,1103,2305?1103,2307,1103,2307?1106,2307,1106,2307?1109,2307,1111,2305?1114,2302,1119,2297?1124,2291,1130,2283?1135,2278,1138,2267?1143,2257,1146,2249?1154,2236,1156,2225?1162,2215,1164,2204?1167,2196,1169,2183?1169,2178,1172,2170?1172,2164,1172,2159?1172,2156,1169,2154?1167,2154,1164,2154?1162,2154,1159,2156?1154,2164,1146,2170?1143,2175,1138,2183?1132,2193,1130,2201?1124,2209,1119,2220?1117,2230,1114,2238?1111,2249,1111,2260?1109,2267,1109,2275?1111,2283,1111,2291?1114,2297,1117,2305?1124,2307,1127,2312?1132,2312,1138,2315?1143,2315,1151,2312?1159,2312,1164,2307?1172,2305,1180,22971315,2119,1315,2119?1315,2119,1315,2117?1315,2119,1310,2122?1310,2125,1304,2130?1302,2138,1296,2146?1291,2156,1283,2167?1278,2175,1273,2185?1270,2196,1265,2207?1262,2215,1257,2222?1257,2228,1262,2230?1262,2233,1265,2233?1270,2230,1275,2228?1281,2225,1291,2220?1296,2212,1304,2207?1310,2201,1320,2199?1326,2193,1331,2191?1334,2191,1336,2191?1339,2191,1344,2193?1344,2196,1344,2199?1344,2204,1339,2209?1336,2215,1334,2225?1328,2233,1323,2241?1318,2252,1310,2260?1304,2267,1299,2281?1291,2289,1283,2297?1278,2305,1273,2310?1267,23151357,2008,1357,2008?1363,1995,1371,1984?1376,1974,1381,1963?1384,1953,1386,1945?1392,1937,1397,1931?1400,1926,1400,1921?1400,1921,1402,1921?1402,1921,1402,1924?1402,1929,1402,1934?1400,1945,1400,1955?1397,1966,1392,1979?1389,1992,1389,2008?1386,2021,1384,2037?1384,2056,1381,2069?1381,2085,1384,2098?1384,2111,1386,2122?1389,2127,1392,2138?1397,2140,1400,2143?1402,2146,1408,2146?1413,2146,1416,2146?1421,2146,1426,2143?1431,2143,1434,2140?1437,2140,1439,2138?1442,2138,1445,2133?1445,2133,1447,2130?1447,2127,1445,2125?1445,2122,1442,2119?1437,2114,1434,2111?1429,2109,1426,2103?1416,2101,1410,2096?1405,2093,1397,2090?1386,2090,1378,2088?1371,2088,1360,2088?1349,2088,1339,2088?1331,2088,1323,2090?1318,2090,1310,20931606,2170,1606,2170?1603,2172,1603,2178?1601,2180,1598,2180?1598,2183,1598,2183?1598,2183,1598,2183?1598,2183,1601,2180?1603,2178,1606,2172?1611,2167,1619,2159?1625,2151,1630,2140?1635,2130,1646,2119?1651,2109,1656,2096?1659,2085,1662,2072?1667,2061,1672,2045?1672,2032,1675,2019?1677,2006,1677,1987?1680,1974,1680,1955?1680,1939,1683,1926?1683,1910,1683,1897?1683,1884,1680,1876?1680,1868,1677,1857?1677,1852,1675,1847?1672,1844,1667,1842?1662,1839,1659,1836?1654,1836,1651,1836?1646,1839,1643,1842?1635,1847,1632,1852?1627,1863,1625,1871?1622,1881,1619,1894?1617,1908,1611,1924?1611,1937,1611,1953?1617,1968,1619,1987?1622,2003,1625,2016?1630,2032,1635,2045?1646,2061,1651,2072?1659,2085,1667,2093?1677,2103,1685,2114?1691,2119,1701,2125?1709,2130,1714,2138?1720,2140,1728,2143?1733,2146,1736,2148?1738,21511550,1995,1550,1995?1550,1995,1553,1992?1564,1990,1572,1984?1582,1976,1598,1966?1617,1958,1632,1947?1651,1934,1675,1924?1693,1908,1717,1897?1741,1884,1765,1873?1786,1863,1786,1863 | | |
| | |
| | |
| | |
|
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | |
| | | | | | |
| | | |
| | | | |
|
| |
| |
]certResult[]