<%
'AdSql = " Select Top 1 seq , filename, link_site From ( " &_
' " Select Top 1 t.seq , t.filename, t.link_site " &_
' " From ad_trs_rotate r Left Join ad_trs t " &_
' " On t.seq > r.run_seq And r.mtype = 'A' And t.mtype = r.mtype " &_
' " where t.del_ok = 'n' " &_
' " And t.status = '00' " &_
' " And convert(char(8),getdate(),112) between t.open_ymd and t.mangi_ymd " &_
' " union all " &_
' " Select Top 1 t.seq , t.filename, t.link_site " &_
' " From ad_trs_rotate r Left Join ad_trs t " &_
' " On r.mtype = 'A' And t.mtype = r.mtype " &_
' " Where t.del_ok = 'n' " &_
' " And t.status = '00' " &_
' " And convert(char(8),getdate(),112) between t.open_ymd and t.mangi_ymd " &_
' " ) as t Order by seq Desc "
'Set adRs = DbCon.Execute ( AdSql )
'run_seq = adRs("seq")
'filename = adRs("filename")
'link_site = adRs("link_site")
'adRs.close
'Set adRs = Nothing
'UpSql = " Update ad_trs_rotate Set run_seq = " & run_seq & " Where mtype = 'A' "
'DbCon.Execute UpSql
%>
 |
 |
<%
'AdSql = " Select Top 1 seq , filename, link_site From ( " &_
' " Select Top 1 t.seq , t.filename, t.link_site " &_
' " From ad_trs_rotate r Left Join ad_trs t " &_
' " On t.seq > r.run_seq And r.mtype = 'A' And t.mtype = r.mtype " &_
' " where t.del_ok = 'n' " &_
' " And t.status = '00' " &_
' " And convert(char(8),getdate(),112) between t.open_ymd and t.mangi_ymd " &_
' " union all " &_
' " Select Top 1 t.seq , t.filename, t.link_site " &_
' " From ad_trs_rotate r Left Join ad_trs t " &_
' " On r.mtype = 'A' And t.mtype = r.mtype " &_
' " Where t.del_ok = 'n' " &_
' " And t.status = '00' " &_
' " And convert(char(8),getdate(),112) between t.open_ymd and t.mangi_ymd " &_
' " ) as t Order by seq Desc "
'Set adRs = DbCon.Execute ( AdSql )
'run_seq = adRs("seq")
'filename = adRs("filename")
'link_site = adRs("link_site")
'adRs.close
'Set adRs = Nothing
'UpSql = " Update ad_trs_rotate Set run_seq = " & run_seq & " Where mtype = 'A' "
'DbCon.Execute UpSql
'DbCon.close
'set DbCon=Nothing
cust_level=session("cust_level")
%>
 |
¸Þ´º¼Ò°³ |
<% If cust_level>=9000 Or cust_level=3510 Or cust_level=2510 Or cust_level=2010 Or cust_level=2020 Then %>°Ô½ÃÆÇ<%else%>°Ô½ÃÆÇ<%end if%> |
¸ðÀÓ¼Ò°³ |
<% If cust_level>=9000 Or cust_level=3510 Or cust_level=2510 Or cust_level=2010 Or cust_level=2020 Then %>ȸ¿øÇöȲ<%else%>ȸ¿øÇöȲ<%end if%> |
<% If cust_level>=9000 Or cust_level=3510 Or cust_level=2510 Or cust_level=2010 Or cust_level=2020 Then %>Á¤·ÊȸÀÇ<%else%>Á¤·ÊȸÀÇ<%end if%> |
<% If cust_level>=9000 Or cust_level=3510 Or cust_level=2510 Or cust_level=2010 Or cust_level=2020 Then %>ÀÚ·á½Ç<%else%>ÀÚ·á½Ç<%end if%> |
OB¾÷üÇöȲ |
 |
|
|
°ø°³Á¤º¸ |
|
|
|
°ø°³Á¤º¸ |
|
»ó¼¼ Á¤º¸´Â »óÈ£¸í Ŭ¸¯Çϼ¼¿ä.
¹øÈ£ |
»óÈ£¸í |
´ëÇ¥ÀÚ |
ȸ¿ø»ç |
ǰ
¸ñ |
01 |
|
±¸ÀÚ¿µ |
°Ç¿µ |
¹æ¼ö°ø»ç ÀÏü (±×¶ó¿ìÆÃ
¹× °¢Á¾ µµ¸·¹æ¼ö Æ÷ÇÔ) |
02 |
|
¾È¾çÀÏ |
°Ç¿µ |
¿å½Ç ¹× ÈÀå½Ç¿ëǰ |
03 |
|
¾öÀçÄ¥ |
°Ç¿µ |
°¡¼³ÀçÀÓ´ë, ö½áÆ÷Æ®,
Àè½áÆ÷Æ®,°°üºñ°è ¹× Å©·¥ÇÁ¿Ü |
04 |
|
À±µ¿Ã¶ |
´ë¸² |
°¡¼³ÀÚÀç ÀÓ´ë ¹× ÆÇ¸Å |
05 |
|
±è¼®¿µ |
·Ôµ¥ |
¸ð·¡, ÀÚ°¥, È¥ÇÕ°ñÀç |
06 |
|
Á¶µ¿ÀÏ |
º®»ê |
Ä«½ºÅäÆÛ, Àý¼ö±â µî |
07 |
|
¹Úµ¿ÇÑ |
»ï¼º |
»ç¹«Áý±â ºñǰ, °¡ÀüÁ¦Ç°,
°èÀý¿ëǰ¡æ °Ç¼³ÇöÀå ÀÓ´ë |
08 |
|
À̿뼮 |
¿ì¼º |
Ÿ¿öÅ©·¹ÀÎ ÀÓ´ë ¹×
¼³Ä¡ ÇØÃ¼ |
09 |
|
½ÅÁ¾¼ø |
û±¸ |
½Ã¸àÆ®(Æ÷Àå, ¹úÅ©),
µå¶óÀ̸ôÅ» |
10 |
|
¹Ú»óµ· |
ÄÚ¿À·Õ |
¹«Àü±â |
11 |
|
±è±¤½Ä |
ÇѾç |
¼ÒÀåÀåºñ, ±â±¸, ¹æÁ¦,
°úÇÐÀü½Ã¹°, ¼Ò¹æ½Ã¼³°ø»ç¿Ü |
12 |
|
¾ÈÀ±Á¶ |
ÇѽŰø¿µ |
¼öÃâÀÔ Åë°ü, ȯ±Þ,
¿î¼Û°ü·Ã¾÷¹« |
13 |
|
ÀÓ°æ¿ |
¿ì¼º |
°í±ÞÀ§»ý±â, ¼öÀü±Ý±¸,
¾Ç¼¼»ç¸®¿Ü |
14 |
|
¹ÚÁ¤¿í |
º®»ê |
½ÌÆ®´ë»óÆÇ, µµ¾Æ¾Á, ¸¶·ç±ÁƲ, Àç·áºÐ¸®´ë»þ¿öºÎ½º |
15 |
|
¿ÀÇÑ¿õ |
»ï¼º |
ŸÀÏ/ÀÎÁ¶´ë¸®¼® ³³Ç°, ¼öÀÔ´ëÇà, ¿ë¿ª°è¾à |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|