<,6687" '엑셀데이터서식 카테고리는 DB를 사용하지 않고 현재 include파일에서 처리한다,6687" Function CategoryData_1(ReturnType,KeyValue,6687" set category = Server.CreateObject("Scripting.Dictionary",6687" category.add "재직증명서","1393,1394,1395,1396,1397,1398,1399,1400,1401,1402,1462,1461,1459,1876,1888,3282,6687" category.add "지출결의서","1411,1412,1413,1414,1415,1416,1417,1418,1419,1420,1867,1922,6687" category.add "발주서","1426,1427,1428,1429,1430,1431,1432,1433,1434,1435,1861,1868,1895,1917,1930,1941,1944,3198,3200,5058,6687" category.add "견적서","1436,1437,1438,1439,1440,1441,1442,1443,1444,1445,1869,1925,1926,1936,1945,1946,5027,6687" category.add "업무일지","1467,1468,1469,1470,1471,1472,1473,1474,1475,1476,1771,1772,1773,1774,1775,1776,1777,1778,1779,1780,1781,1782,1783,1784,1785,1786,1787,1788,1789,1790,1791,1792,1793,1794,1795,1796,1797,1798,1799,1800,1856,1894,1938,3197,3284,3285,3286,5015,5023,5028,5053,5057,6687" category.add "계산서","1448,1449,1450,1451,1452,1453,1454,1455,1456,1849,1860,1920,1921,3205,6687" category.add "경력증명서","1403,1404,1405,1406,1407,1408,1409,1410,1866,1929,6687" category.add "품의서","1478,1479,1480,1481,1482,1483,1484,1862,1863,1919,1931,3280,6687" category.add "관리대장","1485,1486,1487,1488,1489,1490,1491,1492,1493,1494,1741,1740,1739,1738,1737,1736,1735,1734,1733,1732,1731,1730,1729,1728,1727,1726,1725,1724,1723,1722,1721,1720,1719,1718,1717,1716,1715,1714,1713,1712,1711,1710,1709,1708,1707,1706,1705,1704,1703,1702,1701,1700,1699,1698,1697,1696,1695,1466,1857,1892,1896,1932,1940,3194,3195,3199,3201,3202,3203,3204,3206,3207,3208,3209,3263,3264,3266,3267,3268,3269,3270,3271,3275,3276,3277,3279,3281,3283,3288,3289,5016,5017,5018,5019,5024,5025,5035,5036,5037,5038,5040,5041,5042,5047,5048,5051,5052,5054,5059,5160,5162,5166,5175,6108,6109,6111,6112,6113,6114,6115,6116,6172,6173,6174,6177,6178,6181,6182,6183,6185,6191,6192,6193,6196,6197,6198,6199,6298,6299,6300,6301,6302,6304,6305,6306,6308,6309,6310,6311,6312,6313,6315,6316,6317,6318,6324,6325,6326,6327,6328,6330,6429,6430,6433,6434,6435,6437,6438,6439,6441,6442,6444,6543,6544,6545,6547,6549,6550,6552,6554,6555,6557,6558,6559,6560,6561,6562,6563,6564,6565,6663,6664,6665,6666,6667,6668,6669,6670,6672,6677,6678,6679,6685,6686,6687,6688" category.add "비즈니스일반","1691,1850,1851,1852,1854,1858,1855,1872,1875,1887,1889,1890,1891,1893,1897,1898,1899,1915,1916,1918,1923,1927,1928,1933,1934,1937,1939,3278,3378,4719,4721,5020,5021,5022,5026,5043,5044,5045,5046,5049,5050,5158,5159,5163,6261,6262,6319,6320,6321,6322,6323,6392,6393,6394,6432,6505,6506,6507,6626,6627,6628,6680,6681,6682,6683,6684,6687" set popular_category = Server.CreateObject("Scripting.Dictionary",6687" popular_category.add "영수증","1421,1422,1423,1424,1425,6687" popular_category.add "급여대장","1458,1460,6687" popular_category.add "급여명세서","1461,1463,6687" popular_category.add "세금계산서","1464,1465,1849,1860,1920,1921,3205,6687" popular_category.add "거래명세서","1446,1447,6687" popular_category.add "금전출납부","1457,6687" popular_category.add "입금표","1477,6687" if ReturnType = "normal" then ,6687" for each categoryName in category.key,6687" ret_val = ret_val &";"& categoryNam,6687" nex,6687" elseif ReturnType = "popular" the,6687" for each categoryName in popular_category.key,6687" ret_val = ret_val &";"& categoryNam,6687" nex,6687" ,6687" els,6687" if isnumeric(KeyValue) then '서식번호가 넘어오면 카테고리명 찾아서 리,6687" for each categoryName in category.key,6687" if instr(category.item(categoryName),KeyValue) the,6687" ret_val = categoryNam,6687" exit fo,6687" els,6687" ret_val = "전체,6687" end i,6687" nex,6687" if ret_val = "전체" the,6687" for each categoryName in popular_category.key,6687" if instr(popular_category.item(categoryName),KeyValue) the,6687" ret_val = categoryNam,6687" exit fo,6687" els,6687" ret_val = "전체,6687" end i,6687" nex,6687" end i,6687" else '카테고리명이 넘어오면 서식번호 배열을 리,6687" if KeyValue = "pAll" then '인기 서식 전,6687" for each categoryName in popular_category.key,6687" formNumber = formNumber &","& popular_category.item(categoryName,6687" nex,6687" ret_val = "popular§" & Mid(formNumber,2,6687" elseif KeyValue = "" then '서식 전,6687" for each categoryName in category.key,6687" formNumber = formNumber &","& category.item(categoryName,6687" nex,6687" for each categoryName in popular_category.key,6687" formNumber = formNumber &","& popular_category.item(categoryName,6687" nex,6687" ret_val = Mid(formNumber,2,6687" els,6687" if category.Exists(KeyValue) the,6687" ret_val = "normal§" & category.item(KeyValue,6687" els,6687" if popular_category.Exists(KeyValue) the,6687" ret_val = "popular§" & popular_category.item(KeyValue,6687" els,6687" ret_val = ",6687" end i,6687" end i,6687" end i,6687" end i,6687" end i,6687" set category = nothin,6687" set popular_category = nothin,6687" CategoryData_1 = ret_va,6687" End Functio,6687" ' response.write CategoryData_1("search","",6687" %,6687" 관리대장 엑셀데이터서식
문서/서식포탈사이트 비즈폼
  • 엑셀프로그램
  • 엑셀자동화
  • 엑셀데이터서식
  • 엑셀템플릿
  • 기업표준엑셀
  • 경리실무엑셀
  • 엑셀테마모음
  • 엑셀지식인
  • 엑셀상담서비스
엑셀데이터
관리대장 ( 398 )
최신순 인기순 이미지컷 리스트컷
비즈폼
Copyright (c) 2000-2021 by bizforms.co.kr All rights reserved.
고객센터 1588-8443. 오전9시~12시, 오후1시~6시 전화상담예약 원격지원요청
전화전 클릭
클린사이트 선정