´ç½Å¿¡°Ô·Î ¶°³ª´Â ²Þ¼Ó¿©Çà - ²Þ¼Ó³ª¶ó(http://www.inyourdream.net) ÀÔ±¹Çϱâ | ¿µÁÖ±Ç ½Åû
  • ¸öºÎ¸² °ñ¶ó°ñ¶ó
  • ¼Ò±Ù¼Ò±Ù
  • µµ¶õµµ¶õ
  • ³«¼­¸¶´ç
  • Âø°¢ÇѾÆÀÌ
  • ¼ýÀÚ¸ÂÃß±â
  • ¼Ò¿øºô±â
  • ÈçÀû³²±â±â
  • ²Þ¼Ó¿©Çà
  • Ä£±¸Áý ³î·¯°¡±â
  • ¸ðµÎµå¸²´ÔÀÇ È¨
  • î¤éÞ´ÔÀÇ È¨
  • Çö¿ì´ÔÀÇ È¨
  • º°¾ÆÇØ´ÔÀÇ È¨
  • ÇÞ»ì´ÔÀÇ È¨
  • À̳ª´Ï´ÔÀÇ È¨
  • À¯¸®¾Ë´ÔÀÇ È¨
  • ³È³ÈÀÌ´ÔÀÇ È¨
  • ²ÀÁö´ÔÀÇ È¨
  • ´ë¼º´ÔÀÇ È¨
  • 俵ÀÌ / 2001-12-18 / ¿ÀÈÄ 7:07:12 / 203.255.3.190
    Á¶È¸¼ö : 131
    [Áú¹®] ¤¾¤¾¤¾ Áú¹® -_-;;
    > <%@ Language=VBScript %>
    > <%'·Î±ä Æñâ´Â °Å ´Þ±â%>
    > <%
    >
    > user_id = 2000066
    > 'user_id = session("edmsID")
    > approvePath = Request.Form("approvePath")
    > SendApprover = Request.Form("SendApprover")
    >
    > ' ³Ñ¾î¿Â °áÀçÀÚÁß¿¡¼­ »ç¿ø¹øÈ£¸¸ ÃßÃâÇÏ¿© ·çÇÁ¸¦ µ¹¸°´Ù.
    > tempApprover = split(SendApprover,",")
    > %>
    > <!--#include file="../include/ConnectString.asp"-->
    > <!--#include file="../include/ConnectData.asp"-->
    > <%
    > for i=0 to UBound(tempApprover)
    > temp = split(tempApprover(i),"-")
    > ApproverID = ApproverID & temp(1) &","
    > next
    >
    > ApproverID = left(ApproverID,len(ApproverID)-1) ' ¸¶Áö¸· ³¡ÀÇ ","¸¦ ¾ø¾Ø´Ù.
    > ApproverID = user_id&","& ApproverID&"," '±â¾ÈÀÚ¸¦ Ãß°¡ÇÑ´Ù. µÚ¿¡ ¡º , ¡» ´Â »ç¶÷¼ö¿¡ ¸Âµµ·Ï ºÙ¿©ÁØ °ÍÀÌ´Ù.
    >
    > 'ÇöÀç ³ª¿À´Â °ª ¡æ 2000066,2000001,2000066,2000002,2000003,2000004,
    >
    > strSQL="SELECT APP_NAME FROM APPROVAL_TABLE WHERE APP_NAME = '"& approvePath &"'"
    >
    > set rs = conn.execute(strSQL)
    >
    > if rs.eof then
    >
    > '°áÀç°æ·Î Å×ÀÌºí¿¡ ÀúÀå
    > ApproverID = split(ApproverID,",")
    >
    > s = 0
    > Do until s<UBound(ApproverID)
    >
    > ApproverID = ApproverID(s)
    >
    > AppID1 = Mid(ApproverID,1,4)
    > AppID2 = Mid(ApproverID,5,3)
    > AppID = AppID1&"-"&AppID2
    >
    > strSQLFind="insert into groupadmin.APPROVAL_TABLE (DEPTNO, APP_NAME, SEQNO, EMPNO)"
    > strSQLFind=strSQLFind & " "
    > strSQLFind=strSQLFind & " select ºÎ¼­CODE,'"&approverPath&"',"&s&","&ApproverID&" from openquery(stc,'select ºÎ¼­CODE from Àλç_ÃÖ±Ù¹ß·É Where »çÁ÷ÀÏÀÚ Is Null and »ç¹ø=''"&AppID&"''')"
    >
    > set rsFind = conn.execute(strSQLFind)
    > set rsFind = nothing
    > rs.MoveNext
    > s=s+1
    > loop
    >
    > else
    > %>
    > <script language=javascript>
    > alert("À̹ÌÁ¸ÀçÇÏ´Â °áÀç °æ·Î¸íÀÔ´Ï´Ù.\n´Ù¸¥ °áÀç°æ·Î¸íÀ» Àû¾îÁÖ¼¼¿ä.");
    > history.back();
    > </script>
    > <%
    > end if
    > set conn=nothing
    > %>
    > <script language=javascript>
    > top.frames[0].location.href="../popupFiles/popupGetApproverTop.asp";
    > top.frames[1].location.href="../popupFiles/popupGetApproverLeft.asp";
    > location.href="../popupFiles/popupGetApproverRight.asp";
    > </script>
    > <%
    > Response.write "Äõ¸®Æнº: "&approvePath&"<br><br>"
    > Response.write "Äõ¸®¹® : "&strSQL&"<br><br>"
    > Response.write "Àμ­Æ® Äõ¸®¹® : "&strSQLFind&"<br><br>"
    > Response.write "¾ÆÀ̵ð1 : "&AppID&""
    > %>
    >
    > Á¦°¡ ¸¸µç ÀüÀÚ°áÀçÁß... ¤Ñ¤Ñ¤» °áÀç¶óÀÎÀ» ÁöÁ¤Çؼ­... µðºñ¿¡ ³Ö¾îÁÖ´Â °ÍÁß ÇÑÆäÀÌÁö ÀÔ´Ï´Ù...
    >
    > ¼Ò½º Áß... Äõ¸®¹®ÀÌ...
    >
    > strSQLFind <== ¿ä ºÎºÐÀÌ...
    >
    > ¤Ñ¤Ñ;;; ¾ÈµÇ´Â°Í °°½À´Ï´Ù...
    >
    > 2000066,2000077
    >
    > ÀÌ·±µ¥ÀÌÅ͸¦...
    >
    > ·çÇÁ¹®...½ÃÀÛ
    >
    > 2000066 Á¤º¸ÀúÀå...
    >
    > 2000077 Á¤º¸ÀúÀå...
    >
    > ·çÇÁ¹®...³¡
    >
    > ÀÌ·±½ÄÀ¸·Î...
    >
    > ÇѰǵ¥¿ä...
    >
    > ¾ÈµÇ³×¿ä... ¤Ñ_¤Ì
    >
    > ¤Ñ¤Ñ¤» ¸·¸·...
    >
    > °áÀç °æ·Î Å×ÀÌºí¿¡ ÀúÀåÇÏ´Â °÷¿¡¼­¿ä...
    >
    > 2000066,2000001,2000066,2000002,2000003,2000004,
    >
    > ÀÌ·¸°Ô ³ª¿­µÈ°É...
    >
    > ½ºÇÁ¸´ ÇÔ¼ö ½á¼­... ¤Ñ¤Ñ;; Çϳª¾¿ Âï¾î³»´Â
    >
    > ·çÇÁ...... -_-;; À̹ø¿¡µµ ¹«Àð°Ô ¾î·Á¿ì¸é¼­...
    >
    > Àú¸¦ µµ¿ÍÁÙ¼ö ¾ø´Â Áú¹® °°³×¿ä ¤Ì_¤Ì
    >
    > Èæ... Á¦°¡ ¼³¸íÀ» ³Ê¹« ¸øÇؼ­...
    -----------------------------------------------------------

    strSQLFind="insert into groupadmin.APPROVAL_TABLE (DEPTNO, APP_NAME, SEQNO, EMPNO)"
    strSQLFind=strSQLFind & " "
    strSQLFind=strSQLFind & " select ºÎ¼­CODE,'"&approverPath&"',"&s&","&ApproverID&" from openquery(stc,'select ºÎ¼­CODE from Àλç_ÃÖ±Ù¹ß·É Where »çÁ÷ÀÏÀÚ Is Null and »ç¹ø=''"&AppID&"''')"


    ÀÏ´Ü Àú¹øºÎÅÍ ±×·¨´ø°Çµ¥... ÀÌ ºÎºÐ¿¡¼­ from µÚ¿¡ ÀÖ´Â

    openquery¶ó´Â°Ô ¹» ÀǹÌÇÏ´Â °Ç°¡¿ä?

    ÇÔ¼öÀΰ¡¿ä? ±×·³ ±× µÞºÎºÐÀº ¹» ÀǸ¶Çϴ°ǰ¡¿ä?

    ±×¸®°í openquery ¾È¿¡ »ç¹ø = ´ÙÀ½¿¡´Â ¿Ö ÀÛÀº µû¿ÈÇ¥°¡ 2°³¾¿ µé¾î°¬³ª¿ä?

    ±×¸®°í strSQLFind=strSQLFind & " select ºÎ¼­CODE,'"&approverPath&"',"&s&","&ApproverID&" from

    ÀÌ ¹®Àå¿¡¼­´Â approverPath º¯¼ö ÁÖÀ§¿¡ ÀÖ´Â ÀÛÀº µû¿ÈÇ¥´Â ºÒÇÊ¿ä ÇÑ°Í °°Àºµ¥¿ä...

    ±×¸®°í Àú¹ø¿¡µµ ¸»¾¸ µå·È´Âµ¥... Áú¹°À» ÇϽǶ§´Â

    ±×³É ¾È µÇ´Âµ¥¿ä ÀûÀ¸¸é ¾È µÇ°í¿ä.....

    ¾îµð¼­ ¾î¶»°Ô ¾È µÇ´ÂÁö¸¦ Àû¾î¾ß¸¸ ´äº¯ÀÌ °¡´ÉÇÕ´Ï´Ù....

    ¿¡·¯°¡ ³ª´ÂÁö ¾Æ´Ï¸é ¿¡·¯´Â ¾È ³ª´Âµ¥ ³í¸®ÀûÀ¸·Î ¿øÇÏ´Â ´äÀÌ ¾È ³ª¿À´ÂÁö

    ¿¡·¯°¡ ³­´Ù¸é ¾î¶² ¿¡·¯°¡ ³ª´ÂÁö¸¦ Àû¾î Áּž߸¸ ´Ù¸¥ ºÐµéÀÌ

    ¸®´õ´ÔÀÇ Áú¹®À» ÀÌÇØÇÒ ¼ö ÀÖ°ÚÁÒ... ¾ó±¼ ¸Â´ë°í À̾߱âÇÏ´Â °Íµµ ¾Æ´Ï°í ¸»ÀÌ¿¹¿ä... ^^

    ³Ñ ¹«¸®ÇÏÁö ¸¶½Ã°í ½¬¾ö½¬¾ö Çϼ¼¿ä~~

    Byte * 200 Byte À̳»·Î ÀÔ·ÂÇϼ¼¿ä À̸§ : Æнº¿öµå :