{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Yes_Mem_Search_By_CI","암복호화관련"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,2,11,2],[2,1,11,1],[2,0,11,0],[14,2,20,2],[12,2,13,2],[12,1,13,1],[12,0,13,0],[14,0,20,0],[14,1,20,1],[0,4,0,5],[0,6,0,7],[0,2,1,2],[0,1,1,1],[0,0,1,0],[0,3,1,3]]}
["연동내역","iSTYLE메뉴","YES웹서비스이름","사용 서비스","REQUEST",null,"RESPONSE"]
[{"$nulls":4},"parameter","parameter설명","ResultCode","ResultCode_설명"]
["상품권","마이페이지>상품권>상품권등록 \n","http://api.yes24.com/Yes24GiftTicketAPI/Yes24GiftTicketService.asmx","Approval","ticPubNo","상품권번호","00|승인금액|사용시작일|사용종료일|승인번호","성공 (|승인금액|사용시작일|사용만료일|승인번호)"]
[null,null,null,"(승인요청)","ipAddress","IP주소","01","존재하지 않는 상품권입니다"]
[{"$nulls":4},"iStyle24UserID","사용자로그인ID","02","이미 등록된 상품권입니다"]
[{"$nulls":6},"03","삭제된 상품권입니다."]
[{"$nulls":6},"40","기간이 만료된 상품권입니다"]
[{"$nulls":6},"99","시스템 오류입니다."]
[null,null,null,"Reset","ticPubNo","상품권번호","00 ","정상"]
[null,null,null,"(DB저장중 exception발생시 상품권 초기화)","approvalNo","승인번호","01 ","승인내역 없음"]
[{"$nulls":4},"ipAddress","IP주소","02 ","이미 취소 처리됨"]
[{"$nulls":4},"iStyle24UserID","사용자로그인ID","99 ","시스템 오류"]
["로그인","로그인>YES24 아이디로 로그인","https://wsyes24.yes24.com/Yes_Mem.asmx","Yes_Mem_Search_By_CI","str_ci","인코딩된 CI","XML로 회원정보 전달됨 ","상세 내용은Yes_Mem_Search_By_CI 시트 참고"]
[{"$nulls":4},"str_Type","제휴채널 구분값:ISTYLE 로 고정 "]
["연동하기","로그인>YES24 아이디로 로그인","https://wsyes24.yes24.com/Yes_Mem.asmx","Yes_Mem_Search_By_CI","str_ci","인코딩된 CI","XML로 회원정보 전달됨 ","상세 내용은Yes_Mem_Search_By_CI 시트 참고"]
[{"$nulls":4},"str_Type","제휴채널 구분값:ISTYLE 로 고정 "]
[null,null,null,"Yes_Partner_Insert","str_ci","인코딩된 CI","Yes_Partner_InsertResult"]
[{"$nulls":4},"mem_id","yes24아이디"]
[{"$nulls":4},"partner_id","istyle24아이디"]
[{"$nulls":4},"join_gb","P 고정(모바일시 M고정)"]
[{"$nulls":4},"str_Type","제휴채널 구분값:ISTYLE 고정"]
["연동해지","마이페이지>기본정보관리","https://wsyes24.yes24.com/Yes_Mem.asmx","Yes_Partner_Remove","str_ci","인코딩된 CI","Yes_Partner_RemoveResult"]
[{"$nulls":4},"mem_id","yes24아이디"]
[{"$nulls":4},"partner_id","istyle24아이디"]
[{"$nulls":4},"join_gb","P 고정(모바일시 M고정)"]
[{"$nulls":4},"str_Type","제휴채널 구분값:ISTYLE 고정"]

{"sheet":"Yes_Mem_Search_By_CI","index":1,"n_rows":75,"n_cols":1,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["-<Yes_Mem_CInfo_Rtn xmlns=\"http://tempuri.org/\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">"]
[]
["<str_MEM_NO>5371381</str_MEM_NO>"]
[]
["<str_MEM_NM>이선미</str_MEM_NM>"]
[]
["<str_MEM_ID>pe******</str_MEM_ID>"]
[]
["<str_IDN_NO>999999-2000000</str_IDN_NO>"]
[]
["<str_MEM_EML>pe******@naver.com</str_MEM_EML>"]
[]
["<str_OCB_NO/>"]
[]
["<str_BLOG_URL>pe******</str_BLOG_URL>"]
[]
["<str_DEREG_APP_PROC/>"]
[]
["<str_MEM_LVL_GB>01</str_MEM_LVL_GB>"]
[]
["<str_BLOG_STATE/>"]
[]
["<str_RMEM_NM/>"]
[]
["<str_RIDN_NO>999999-2000000</str_RIDN_NO>"]
[]
["<str_RNM_CHK_DTS/>"]
[]
["<str_NICK_NM>pe**</str_NICK_NM>"]
[]
["<str_MEM_LVL_SB/>"]
[]
["<str_STARBLOGGER_RATING/>"]
[]
["<str_MEM_GB>01</str_MEM_GB>"]
[]
["<str_IPIN_CHECK/>"]
[]
["<str_IPIN_DI>MC0GCCqGSIb3DQIJAyEA6cb1+8qmFpzkmb0duhNGNcxhw1b868oze/EdzPpTtiU=</str_IPIN_DI>"]
[]
["<str_IPIN_CI>+7TCkTAL8JjwQs0jisI4frvgj+n7SUahAtHgJdXAB7MqZPzh/4uiWK/rB8+GCCu2uQ6dtYYOU20U0cgGPL3zdQ==</str_IPIN_CI>"]
[]
["<str_BIRTH_DM>1900-01-01</str_BIRTH_DM>"]
[]
["<str_SEX>F</str_SEX>"]
[]
["<str_PURE_TOT_AMT>0</str_PURE_TOT_AMT>"]
[]
["<str_LVL_UPT_DTS>2020-10-08T10:10:24.0470017+09:00</str_LVL_UPT_DTS>"]
[]
["<str_MEM_LVL_END_DTS>2020-10-08T10:10:24.0470017+09:00</str_MEM_LVL_END_DTS>"]
[]
["<str_ORD_PATH_GB/>"]
[]
["<str_SMS_REC_YN>N</str_SMS_REC_YN>"]
[]
["<str_EML_REC_YN>Y</str_EML_REC_YN>"]
[]
["<str_DORMANCY_YEAR>1</str_DORMANCY_YEAR>"]
[]
["<str_ADDR_ZIP>06263</str_ADDR_ZIP>"]
[]
["<str_ADDR_ADDR1>서울 강남구 </str_ADDR_ADDR1>"]
[]
["<str_ADDR_MOB_NO>010-0000-0000</str_ADDR_MOB_NO>"]
[]
["<str_ADDR_ADDR2>일신빌딩 8층 </str_ADDR_ADDR2>"]
[]
["<str_ADDR_ADDR3/>"]
[]
["<str_ADDR_ADDR4/>"]
[]
["<str_ADDR_TEL_NO>02-000-0000</str_ADDR_TEL_NO>"]
[]
["</Yes_Mem_CInfo_Rtn>"]

{"sheet":"암복호화관련","index":2,"n_rows":60,"n_cols":1,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["  <!--Yes24 암호화키-->"]
["  <add key=\"YesSecurityKey\" value=\"dPtm24dnpqtjqltmdkaghsmsqlalf!@#\" />"]
[]
[" public static string Encrypt(string key, string text)"]
["        {"]
["            RijndaelManaged aes = new RijndaelManaged();"]
["            aes.KeySize = 256;"]
["            aes.BlockSize = 128;"]
["            aes.Mode = CipherMode.CBC;"]
["            aes.Padding = PaddingMode.PKCS7;"]
["            aes.Key = Encoding.UTF8.GetBytes(key);"]
["            aes.IV = new byte[] { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 };"]
[]
["            ICryptoTransform encrypt = aes.CreateEncryptor(aes.Key, aes.IV);"]
["            byte[] xBuff = null;"]
["            using (MemoryStream ms = new MemoryStream())"]
["            {"]
["                using (CryptoStream cs = new CryptoStream(ms, encrypt, CryptoStreamMode.Write))"]
["                {"]
["                    byte[] xXml = Encoding.UTF8.GetBytes(text);"]
["                    cs.Write(xXml, 0, xXml.Length);"]
["                }"]
[]
["                xBuff = ms.ToArray();"]
["            }"]
[]
["            return Convert.ToBase64String(xBuff);"]
["        }"]
[]
["        /// <summary>"]
["        /// AES 복호화 텍스트를 반환한다."]
["        /// </summary>"]
["        /// <param name=\"key\">암호화 키</param>"]
["        /// <param name=\"text\">복호화 대상문자열</param>"]
["        /// <returns>복호화 문자열</returns>"]
["        public static string Decrypt(string key, string text)"]
["        {"]
["            RijndaelManaged aes = new RijndaelManaged();"]
["            aes.KeySize = 256;"]
["            aes.BlockSize = 128;"]
["            aes.Mode = CipherMode.CBC;"]
["            aes.Padding = PaddingMode.PKCS7;"]
["            aes.Key = Encoding.UTF8.GetBytes(key);"]
["            aes.IV = new byte[] { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 };"]
[]
["            ICryptoTransform decrypt = aes.CreateDecryptor();"]
["            byte[] xBuff = null;"]
["            using (MemoryStream ms = new MemoryStream())"]
["            {"]
["                using (CryptoStream cs = new CryptoStream(ms, decrypt, CryptoStreamMode.Write))"]
["                {"]
["                    byte[] xXml = Convert.FromBase64String(text);"]
["                    cs.Write(xXml, 0, xXml.Length);"]
["                }"]
[]
["                xBuff = ms.ToArray();"]
["            }"]
[]
["            return Encoding.UTF8.GetString(xBuff);"]
["        }"]