<% '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
¿ÀÇÑ¿õ
»ï¼º
ŸÀÏ/ÀÎÁ¶´ë¸®¼® ³³Ç°, ¼öÀÔ´ëÇà, ¿ë¿ª°è¾à