|
|
|
俵ÀÌ / 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 º¯¼ö ÁÖÀ§¿¡ ÀÖ´Â ÀÛÀº µû¿ÈÇ¥´Â ºÒÇÊ¿ä ÇÑ°Í °°Àºµ¥¿ä...
±×¸®°í Àú¹ø¿¡µµ ¸»¾¸ µå·È´Âµ¥... Áú¹°À» ÇϽǶ§´Â
±×³É ¾È µÇ´Âµ¥¿ä ÀûÀ¸¸é ¾È µÇ°í¿ä.....
¾îµð¼ ¾î¶»°Ô ¾È µÇ´ÂÁö¸¦ Àû¾î¾ß¸¸ ´äº¯ÀÌ °¡´ÉÇÕ´Ï´Ù....
¿¡·¯°¡ ³ª´ÂÁö ¾Æ´Ï¸é ¿¡·¯´Â ¾È ³ª´Âµ¥ ³í¸®ÀûÀ¸·Î ¿øÇÏ´Â ´äÀÌ ¾È ³ª¿À´ÂÁö
¿¡·¯°¡ ³´Ù¸é ¾î¶² ¿¡·¯°¡ ³ª´ÂÁö¸¦ Àû¾î Áּž߸¸ ´Ù¸¥ ºÐµéÀÌ
¸®´õ´ÔÀÇ Áú¹®À» ÀÌÇØÇÒ ¼ö ÀÖ°ÚÁÒ... ¾ó±¼ ¸Â´ë°í À̾߱âÇÏ´Â °Íµµ ¾Æ´Ï°í ¸»ÀÌ¿¹¿ä... ^^
³Ñ ¹«¸®ÇÏÁö ¸¶½Ã°í ½¬¾ö½¬¾ö Çϼ¼¿ä~~
|
|
|
|