ASP.NET测试

using System;
using System.Collections.Generic;
//using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
  String StrConnection = " Server=(local); Database=B2CSystem; User ID=sa;Password=529529;";
  SqlConnection conn;
  SqlCommand cmd;

  protected void Page_Load(object sender, EventArgs e)
  {
    if (!IsPostBack)
    {
      FlashNews();
      FlashCommend();
      FlashHotClick();
      FlashHotSales();
      FlashNew();
    }
  }

  public string SubStr(string sString, int nLeng)
  {
    if (sString.Length <= nLeng)
    {
      return sString;
    }
    string sNewStr = sString.Substring(0, nLeng);
    sNewStr = sNewStr + "...";
    return sNewStr;
  }
  private void FlashNews()
  {
    conn = new SqlConnection(StrConnection);
    conn.Open();
    String sql = "select * from News order by datetimed desc";
    SqlDataAdapter myda = new SqlDataAdapter(sql, conn);
    DataSet ds = new DataSet();
    myda.Fill(ds, "News");

    GridView1.DataSource = ds.Tables["News"].DefaultView;
    GridView1.DataBind();
    /****/
    for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
    {
      DataRowView mydrv;
      string gIntro,id;
      if (GridView1.PageIndex == 0)
      {
        mydrv = ds.Tables["News"].DefaultView[i];//表名
        gIntro = Convert.ToString(mydrv["Name"]);//所要处理的字段
        id = Convert.ToString(mydrv["ID"]);
        GridView1.Rows[i].Cells[0].Text = "<a href='News.aspx?ID="+id+"'>" + SubStr(gIntro, 10) + "</a>";
        gIntro = Convert.ToString(mydrv["Memo"]);
        GridView1.Rows[i].Cells[1].Text = SubStr(gIntro, 27);
      }
      else
      {
        mydrv = ds.Tables["News"].DefaultView[i + (5 * GridView1.PageIndex)];
        gIntro = Convert.ToString(mydrv["Name"]);
        id = Convert.ToString(mydrv["ID"]);
        GridView1.Rows[i].Cells[0].Text = "<a href='News.aspx?ID=" + id + "'>" + SubStr(gIntro, 10) + "</a>";
        gIntro = Convert.ToString(mydrv["Memo"]);
        GridView1.Rows[i].Cells[1].Text = SubStr(gIntro, 27);
      }
      //GridView1.Rows[i].Cells[1].Style.Add("white-space", "nowrap");
    }
    conn.Close();
  }
  private void FlashHotClick()
  {
    conn = new SqlConnection(StrConnection);
    conn.Open();
    String sql = "select top 6 * from Products order by clicks desc";
    SqlDataAdapter myda = new SqlDataAdapter(sql, conn);
    DataSet ds = new DataSet();
    myda.Fill(ds, "Products");

    GridView2.DataSource = ds.Tables["Products"].DefaultView;
    GridView2.DataBind();
    conn.Close();
  }
  private void FlashHotSales()
  {
    conn = new SqlConnection(StrConnection);
    conn.Open();
    String sql = "select top 6 * from Products order by sales desc";
    SqlDataAdapter myda = new SqlDataAdapter(sql, conn);
    DataSet ds = new DataSet();
    myda.Fill(ds, "Products");

    GridView3.DataSource = ds.Tables["Products"].DefaultView;
    GridView3.DataBind();
    conn.Close();
  }

  protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
  {

  }
  // 翻页
  protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
  {
    GridView1.PageIndex = e.NewPageIndex;
    FlashNews();
  }

  private void FlashCommend()
  {
    conn = new SqlConnection(StrConnection);
    conn.Open();
    String sql = "select top 8 * from Products where Commend='1'";
    SqlDataAdapter myda = new SqlDataAdapter(sql, conn);
    DataSet ds = new DataSet();
    myda.Fill(ds, "Products");

    DataList1.DataSource = ds.Tables["Products"].DefaultView;
    DataList1.DataBind();
    conn.Close();
  }
  private void FlashNew()
  {
    conn = new SqlConnection(StrConnection);
    conn.Open();
    String sql = "select top 3 * from Products order by datetimed desc";
    SqlDataAdapter myda = new SqlDataAdapter(sql, conn);
    DataSet ds = new DataSet();
    myda.Fill(ds, "Products");

    DataList2.DataSource = ds.Tables["Products"].DefaultView;
    DataList2.DataBind();
    conn.Close();
  }

  /*******************************/
  protected void GridView_RowDataBound(object sender, GridViewRowEventArgs e)
  {
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
      e.Row.Attributes.Add("onmouseover", "currentcolor=this.style.backgroundColor;this.style.backgroundColor='#f5f5f5'; this.style.fontWeight='bold';");
      e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=currentcolor; this.style.fontWeight='';");
    }

    if (e.Row.RowType == DataControlRowType.DataRow)
    {
      e.Row.Attributes.Add("onclick", "this.style.backgroundColor='#f5f5f5'; this.style.cursor='hand';");
    }
  }
  protected void GridView1_SelectedIndexChanged1(object sender, EventArgs e)
  {

  }
}
<%@ Page Title="" Language="C#" MasterPageFile="~/FrontPage.master" AutoEventWireup="true"
  CodeFile="Default.aspx.cs" Inherits="_Default" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
  <link rel="Stylesheet" type="text/css" href="CSS/FrontPage.css" />
  <style type="text/css">
    .style4
    {
      width: 100%;
    }
  </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
  <div id="default-main">
    <div id="left">
      <div id="tab-hotclick">
        <asp:GridView ID="GridView2" runat="server" PageSize="6" Width="100%" AutoGenerateColumns="False"
          CellPadding="4" ForeColor="#000000" GridLines="None" Font-Italic="False" Font-Size="18px"
          OnRowDataBound="GridView_RowDataBound">
          <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
          <Columns>
            <asp:HyperLinkField DataNavigateUrlFields="ProductId" DataNavigateUrlFormatString="Product.aspx?ProductId={0}"
              DataTextField="ModelName" DataTextFormatString="{0}" HeaderText="所有热门商品">
              <HeaderStyle Width="70%" Font-Bold="True" ForeColor="Black" HorizontalAlign="Left"
                CssClass="title" Height="45px" VerticalAlign="Top" Wrap="True" />
              <ItemStyle CssClass="normalfont" />
            </asp:HyperLinkField>
            <asp:HyperLinkField DataNavigateUrlFields="ProductId" DataNavigateUrlFormatString="Product.aspx?ProductId={0}"
              DataTextField="Clicks" DataTextFormatString="{0}" HeaderText="点" ItemStyle-CssClass="data">
              <ItemStyle CssClass="data"></ItemStyle>
            </asp:HyperLinkField>
            <asp:HyperLinkField DataNavigateUrlFields="ProductId" DataNavigateUrlFormatString="Product.aspx?ProductId={0}"
              DataTextField="Sales" DataTextFormatString="{0}" HeaderText="销" />
          </Columns>
          <EditRowStyle BackColor="#999999" />
          <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
          <HeaderStyle BackColor="#e5e5e5" Font-Bold="True" ForeColor="White" Height="40px" />
          <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
          <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
          <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
          <%--<SortedAscendingCellStyle BackColor="#E9E7E2" />
          <SortedAscendingHeaderStyle BackColor="#506C8C" />
          <SortedDescendingCellStyle BackColor="#FFFDF8" />
          <SortedDescendingHeaderStyle BackColor="#6F8DAE" />--%>
        </asp:GridView>
        <div class="more">
          <a href="ProductsTop.aspx?Type=Clicks">更多产品</a></div>
      </div>
      <div id="tab-hotsale">
        <asp:GridView ID="GridView3" runat="server" PageSize="6" Width="100%" AutoGenerateColumns="False"
          CellPadding="4" ForeColor="#333333" GridLines="None" OnRowDataBound="GridView_RowDataBound">
          <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
          <Columns>
            <asp:HyperLinkField DataNavigateUrlFields="ProductId" DataNavigateUrlFormatString="Product.aspx?ProductId={0}"
              DataTextField="ModelName" DataTextFormatString="{0}" HeaderText="所有热销商品">
              <ControlStyle ForeColor="Black" />
              <HeaderStyle Width="70%" CssClass="title" ForeColor="Black" Height="45px" HorizontalAlign="Left"
                VerticalAlign="Top" />
            </asp:HyperLinkField>
            <asp:HyperLinkField DataNavigateUrlFields="ProductId" DataNavigateUrlFormatString="Product.aspx?ProductId={0}"
              DataTextField="Clicks" DataTextFormatString="{0}" HeaderText="点" />
            <asp:HyperLinkField DataNavigateUrlFields="ProductId" DataNavigateUrlFormatString="Product.aspx?ProductId={0}"
              DataTextField="Sales" DataTextFormatString="{0}" HeaderText="销" />
          </Columns>
          <EditRowStyle BackColor="#999999" />
          <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
          <HeaderStyle BackColor="#e5e5e5" Font-Bold="True" ForeColor="White" Height="40px" />
          <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
          <RowStyle BackColor="#F7F6F3" ForeColor="#333333" CssClass="data" Font-Size="18px"
            Height="30px" VerticalAlign="Middle" />
          <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
          <%--<SortedAscendingCellStyle BackColor="#E9E7E2" />
          <SortedAscendingHeaderStyle BackColor="#506C8C" />
          <SortedDescendingCellStyle BackColor="#FFFDF8" />
          <SortedDescendingHeaderStyle BackColor="#6F8DAE" />--%>
        </asp:GridView>
        <div class="more">
          <a href="ProductsTop.aspx?Type=Sales">更多产品</a></div>
      </div>
      <div id="tab-new">
        <div class="title">
          最新商品</div>
        <asp:DataList ID="DataList2" runat="server" Width="100%">
          <ItemTemplate>
            <table class="style4">
              <tr>
                <div class="card-h">
                  <a href='Product.aspx?ProductID=<%# DataBinder.Eval(Container.DataItem, "ProductID") %>'
                    title="点击查看明细">
                    <img alt="" src='ProductImages/<%# DataBinder.Eval(Container.DataItem, "ProductImage") %>'
                      border="0" width="100px" height="100px">
                    <%# DataBinder.Eval(Container.DataItem, "ModelNumber") %>
                    -
                    <%# DataBinder.Eval(Container.DataItem, "ModelName") %>
                    <br>
                    <font color="silver"><del>
                      <%# DataBinder.Eval(Container.DataItem, "UnitCost", "{0:c}") %>
                    </del></font>
                    <br>
                    <font color="coral">
                      <%# DataBinder.Eval(Container.DataItem, "Discount", "{0:c}") %>
                    </font></a>&nbsp;&nbsp;&nbsp;&nbsp;</div>
              </tr>
            </table>
          </ItemTemplate>
        </asp:DataList>
        <div class="more">
          <a href="ProductsTop.aspx?Type=Datetimed">更多产品</a></div>
      </div>
    </div>
    <div id="right">
      <div id="tab-news">
        <div class="title">
          最新消息</div>
        <asp:GridView ID="GridView1" runat="server" CellPadding="4" AutoGenerateColumns="False"
          Width="100%" AllowPaging="True" OnPageIndexChanging="GridView1_PageIndexChanging"
          PageSize="5" ForeColor="#333333" GridLines="None" OnSelectedIndexChanged="GridView1_SelectedIndexChanged1">
          <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
          <Columns>
            <asp:HyperLinkField DataTextField="Name" HeaderText="标题">
              <HeaderStyle Width="25%" />
            </asp:HyperLinkField>
            <asp:BoundField DataField="Memo" HeaderText="内容" />
            <asp:BoundField DataField="DateTimed" HeaderText="时间">
              <HeaderStyle Width="25%" />
            </asp:BoundField>
          </Columns>
          <EditRowStyle BackColor="#999999" />
          <FooterStyle BackColor="White" Font-Bold="True" ForeColor="Black" />
          <HeaderStyle BackColor="#C1D739" Font-Bold="True" ForeColor="White" />
          <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
          <RowStyle BackColor="#F7F6F3" ForeColor="#333333" Height="40px" />
          <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
          <%--<SortedAscendingCellStyle BackColor="#E9E7E2" />
          <SortedAscendingHeaderStyle BackColor="#506C8C" />
          <SortedDescendingCellStyle BackColor="#FFFDF8" />
          <SortedDescendingHeaderStyle BackColor="#6F8DAE" />--%>
        </asp:GridView>
      </div>
      <div id="tab-recom">
        <div class="title">
          诚意推荐
        </div>
        <div>
          <asp:DataList ID="DataList1" runat="server" RepeatColumns="4" RepeatDirection="Horizontal">
            <ItemTemplate>
              <table>
                <tr>
                  <td valign="top" align="middle" class="card">
                    <a target="view_window" href='Product.aspx?ProductID=<%# DataBinder.Eval(Container.DataItem, "ProductID") %>'
                      title="点击查看明细">
                      <img src='ProductImages/<%# DataBinder.Eval(Container.DataItem, "ProductImage") %>'
                        border="0" width="100%" height="60%">
                      <br>
                      </div class="card-bottom">
                      <%# DataBinder.Eval(Container.DataItem, "ModelNumber") %>
                      -
                      <%# DataBinder.Eval(Container.DataItem, "ModelName") %>
                      <br>
                      <font color="silver"><del>
                        <%# DataBinder.Eval(Container.DataItem, "UnitCost", "{0:c}") %>
                      </del></font>
                      <br>
                      <font color="coral">
                        <%# DataBinder.Eval(Container.DataItem, "Discount", "{0:c}") %>
                      </font></a>&nbsp;&nbsp;<br>
                    <a href='<%# "AddToCart.aspx?ProductID=" + DataBinder.Eval(Container.DataItem, "ProductID") %>'>
                      </div>
                      <img alt="" src="ProductImages/ShoppingCart.gif" border="0" title="点击订单此商品"></a>
                  </td>
                </tr>
              </table>
            </ItemTemplate>
          </asp:DataList>
        </div>
      </div>
    </div>
  </div>
</asp:Content>
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值