ÓÃ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µÄºÜºÃ°¡
Ïà¹ØÎÊ´ð£º
<form id="form1" runat="server">
<div>
<script type="text/javascript">
function oo(a){
document.getEleme ......
ÎÒ×öÁËÒ»¸öASPÍøÕ¾£¨µÚÒ»´Î×ö£©£º
ÔÚÎÒµçÄÔÉÏ£¬ÎÒÏÂÁ˸öMySQLµÄODBC£¬
Á¬½ÓÓï¾ä£º
ConnStr = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=127.0.0.1;DATABASE=test;USER=root;PASSWORD=123456;"
......
ÎÒÃÇÓÐÒ»¸öÍøÕ¾Ä£°å£¬www.c111.com.cn,Ï£ÍûÐÞ¸ÄһЩµØ·½£º
1£©µã»÷×ó²à¡°·þÎñÆ·ÅÆ¡±µÄÆäÖÐÒ»¸öС·ÖÀ࣬Èç¡°×ãÇò¡±£¬½çÃæµÄÓÒ²à¾Í³öÏÖÈçwww.c111.com.cn/1.jpg£¬µã»÷1.jpgÉÏ·½µÄÆäÖÐÒ»¸öÆ·ÅÆlogo£¬ÏÂÃæ¾Í³öÏÖÏà¹ØµÄÍ ......
ÎÒҪΪ ·þÎñÆ÷¶Ë¿Ø¼þ asp£ºcheckbox ×¢²á¿Í»§¶ËÊôÐÔ value Ôõô×ö°¡
valueÊôÐÔÎÞ·¨×¢²á£¬½¨Òélz»»¸öÊôÐÔ£¬·´ÕýÊôÐÔÃû×ÖÒ²¾ÍÊǸö´úºÅ¶øÒÑÈ磺
CheckBox1.Attributes.Add("value1", ......