ÓÃASPÔõôдÒÔÏ´úÂë
µ±½áÊøÊ±¼ä´óÓÚ¿ªÊ¼Ê±¼äÔòÏÔʾδÍê³É
µ±½áÊøÊ±¼äСÓÚ¿ªÊ¼Ê±¼äÔòÏÔʾδ´ïµ½ÈÎÎñ
ûÓÐʱ¼äÔòÏÔʾÕýÔÚ½øÐÐÖÐ
asp´úÂëÓ¦¸ÃÔõôд
Èç:¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä Íê³Éʱ¼ä ״̬
2009-10-10 2009-10-20 2009-10-15 Íê³É
2009-10-10 2009-10-20 2009-10-21 delay
2009-10-10 2009-10-20 ûÓÐʱ¼ä ÕýÔÚ½øÐÐÖÐ
1.Ñ»·ÅжÏßÂ
2.ÓÃÒ»¾äsqlÒ²ÄÜд³öÀ´
SQL code:
select startTime,endTime,finishTime,case when finishTime>endTime then 'delay' when endTime<finishTime then 'Íê³É' when finishTime is null then 'ÕýÔÚ½øÐÐÖÐ' end as status from table
ÎÒ¾õµÃÁÖÕÑдµÃ±È½ÏºÃ±È½Ï·ûºÏÌâÒâ
ţţ »»Ò»ÖÖ½â¾ö·½·¨ Ò²²»´í
1LµÄºÜºÃ°¡
Ïà¹ØÎÊ´ð£º
ÕâÀïÊÇGridView°ó¶¨µÄÒ»¸öÄ£°å, ÎÒÏëͨ¹ýÕâÀïµÄ "²é¿´ÏêÇé", Ìø×ªµ½Ò»¸ö°üº¬DetailsView
µÄÒ³Ãæ. È»ºó¾Í»áÏÔʾÏàÓ¦µÄÐÅÏ¢.
°üº¬DetailsViewµÄÒ³Ãæ¸ù¾ÝIDÖµ°ó¶¨Êý¾Ý
°üº¬GridViewµÄÒ³ÃæµÄµÚÒ»ÁÐÊ ......
ÎÊÌ⣺µ±ÍøÒ³Îļþ³¬¹ýÏÔʾÆ÷·Ö±æÂʵÄʱºò£¬´¹Ö±¹ö¶¯ÌõÓ¦¸Ã³öÏֵ쬵«ÎªÊ²Ã´Ë®Æ½¹ö¶¯ÌõÒ²³öÏÖÄØ£¿ÈçºÎÈ¥µô°¡£¬ÏÂÃæÊǽØÍ¼ºÍ¿ò¼ÜÒ³Ãæ´úÂ룺
http://hi.baidu.com/w511170721/album/item/a61278226d558e4f9922ed13.h ......
Active Server Pages ´íÎó 'ASP 0113'
½Å±¾³¬Ê±
/admin/affiche_zx/i ......
news±íÀïÓÐpname(ÉÏ²ã¿ÆÄ¿),mname(¿ÆÄ¿),type(·ÖÀà)ÕâÈý¸ö×Ö¶Î;
ÏÂÃæÕâ¸öµÝ¹é.ʵÑé²âÊÔÖ»Äܵݹ鵽110²ã..ÐèÒªÔõô¸Ä,²ÅÄÜÎÞÏÞ??
JScript code:
function gethz(pname8,type8)
dim str,rs
......
id lbname topid ceng
1 ²úÆ·1 0 1
16 ²úÆ·2 0 1
17 ²úÆ·3 0 1
18 ²úÆ·4 0 1
19 ²úÆ·5 0 1
20 ²úÆ·6 0 1
21 ²úÆ·7 0 1
22 ²úÆ·8 0 1
23 ²úÆ·9 0 1
24 ²úÆ·10 0 1
25 ²úÆ·11 0 1
......