aspÖкϼƲéѯÓï¾äÕâÑùд¶Ô²»¶Ô
<%
set count_sell = server.createobject("ADODB.RecordSet")
count_sell.open sql,conn,1,3
hj=0
nowprice3=0
zongshulian3=0
do while count_sell.eof=false
sql5="select sum(price*shulian*guige),sum(price2*shulian*guige),sum(shulian) from sell where isok=false and type and bianhao='"&count_sell("bianhao")&"' and zu=false"
if nowku <>"" then
sql5=sql5&" and id_ku="&nowku
end if
if nowkeyword <>"" then
sql5=sql5&" and (bianhao = '"&nowkeyword&"' or id_huiyuan in (select id from huiyuan where username like '%"&nowkeyword&"%') or id_login in (select id from login where username like '%"&nowkeyword&"%') or title like '%"&nowkeyword&"%' or huohao like '%"&nowkeyword&"%')"
end if
set rs_sum=conn.execute(sql5)
hj=hj+rs_sum(0)
nowprice3=nowprice3+rs_sum(1)
zongshulian3=zongshulian3+rs_sum(2)
count_sell.movenext
loop
%>
Êä³öºÏ¼ÆµÄ±í´ïʽΪ£º
<%=formatnumber(hj,2)%>
ÇëÎÊÕâÑùдºÏ¼Æ£¨hj£©¶Ô²»¶Ô
¿ÉÒÔ£¬µÃµ½ºÏ¼ÆÓÐÁ½ÖÖ·½·¨£¬Ò»ÖÖÊÇÖ±½ÓÓòéѯÓï¾ä¼ÆËã³öºÏ¼Æ£
Ïà¹ØÎÊ´ð£º
http://www.zgjhjy.com/Test/PrimaryTest/Index.aspx
¾ÍÊÇÀàËÆÒÔÉϵÄÔÚÏß²âÊÔϵͳ£¬ÐèÒªÓÐÒ»¸öºǫ́µÄ£¬ÓïÑÔÊÇaspµÄ£¬Êý¾Ý¿âÊÇaccessµÄ£¬»¹ÐèÒªÄÜÔÚºǫ́¶ÔÐÅÏ¢½øÐÐÌíɾ¸Ä²éµÄ¡£Ð»Ð»¸÷λÁË¡£¡£¡£
³ÌÐòÕæµÄºÜ¶à£¬²»Öª ......
·þÎñÆ÷ÏÖÔÚÊÇ¡£net 2.0µÄ
ÎÒÏÖÔÚµÄÏîÄ¿¾ÍÊÇasp.net mvc + linqµÄ£¬ÏÖÔÚ·þÎñÆ÷µÄ»·¾³ÅäÖÃÓò»ÁË¡£
²»ÖªµÀÓÐǰ±²Åöµ½¹ýÕâÑùµÄÎÊÌâû¡£
ÄѵÀ·þÎñÆ÷±ØÐëҪװ.net3.5 ºÍ asp.net mvc
Çëǰ±²Ö¸µã
²»×°ÄãÈÏΪÄãÒªÔõô ......
AÒ³Ãæ
<table width="200" border="1">
<tr>
<td>1</td>
<td>3</td>
<td><!--#include/top.html#-- ......
asp.netÅúÁ¿ÉÏ´«Í¼Æ¬×îºÃÓÐÔ´Â룬ÔÚÏߵȣ¡£¡£¡£¡£¡£¡£¡
Ô´ÂëºÜ³¤µÄ¡£
²Î¿¼
C# code:
HttpFileCollection files = HttpContext.Current.Request.Files;
if (files.Count <= 1)
{
......
ÈçºÎÓÃjs»ñµÃ asp дÈëµÄsession
session("user_id") = "cqsj1987"
ÔõôÑùÓÃjs Õâ¸ösession Öµ?
JScript code:
var uid="<%=session("user_id")%>"
<%
s ......