top.ascx

ASP.net+sql server2000编写的完整鲜花在线销售系统

<%@ Control Language="c#" AutoEventWireup="false" CodeFile="top.ascx.cs" Inherits="flower.control.top" TargetSchema="http://schemas.microsoft.com/intellisense/ie5"%>
<tr>
	<td width="25" height="36" background="/flower/images/left_bg1.jpg"><img src="/flower/images/left_3.jpg" width="25" height="36"></td>
	<td width="126" height="36" align="center" valign="middle" background="/flower/images/left_bg1.jpg"><img src="/flower/images/left_rmtj.jpg" width="59" height="36"></td>
	<td width="25" height="36" background="/flowerimages/left_bg1.jpg"><img src="/flower/images/left_4.jpg" width="25" height="36"></td>
</tr>
<tr>
	<td height="210" colspan="3" align="center" valign="top" bgcolor="#ffd5e5"><table width="86%" border="0" cellspacing="0" cellpadding="0">
			<% 
   flower.DBOP myDBOP=new flower.DBOP();
   System.Data.DataSet myDataSet=new System.Data.DataSet();
   string myCommStr="select name,outprice,id from flower order by outcount desc";
   myDataSet=myDBOP.mySelect(myCommStr);
  
   if(myDataSet.Tables[0].Rows.Count>0)
   {
      int loopCount=10;
      if(myDataSet.Tables[0].Rows.Count<10)
      {
         loopCount=myDataSet.Tables[0].Rows.Count;
      }
      
      for(int i=0;i<loopCount;i++)
      { 
%>
			<tr>
				<td width="18%" height="20" align="right"><%=i+1%>．</td>
				<td width="63%" height="20" align="left"><a href="/flower/front/flower/flowerdetail.aspx?id=<%=myDataSet.Tables[0].Rows[i][2].ToString().Trim()%>"><%=myDataSet.Tables[0].Rows[i][0].ToString().Trim()%></a>
				</td>
				<td width="19%" height="20" align="left"><%=myDataSet.Tables[0].Rows[i][1].ToString().Trim()%></td>
			</tr>
			<%
      }%>
			<tr>
				<td colspan="3" align="right"><a href="/flower/front/top/viewtop.aspx">more...</a></td>
			</tr>
			<%}
%>
		</table>
	</td>
</tr>