网上购物系统（Task009）——FormView显示商品详细信息

源代码：13033480群共享

一、在数据库表Item中添加字段Descn、SupplyTime、SupplyDate、SupplyArea。因为除Descn，其它几个字段内容都差不多，所以，设置一下默认值，以后添加，更新数据库内容时，会更方便。二、在数据集Model类库中添加类ItemDetails.cs。

using System;

namespace WestGarden.Model
{
    public class ItemDetails
    {
        private int itemid;
        private string categoryid;
        private string name;
        private decimal price;
        private string image;
        private string categoryname;

        private string descn;
        private string supplytime;
        private string supplydate;
        private string supplyarea;

        public ItemDetails() { }

        public ItemDetails(int itemid, string categoryid, string name, decimal price, string image, string categoryname,
            string descn, string supplytime,string supplydate,string supplyarea)
        {
            this.itemid = itemid;
            this.categoryid = categoryid;
            this.name = name;
            this.price = price;
            this.image = image;
            this.categoryname = categoryname;

            this.descn = descn;
            this.supplytime = supplytime;
            this.supplydate = supplydate;
            this.supplyarea = supplyarea;
        }

        public int ItemId
        {
            get { return itemid; }
            set { itemid = value; }
        }
        public string CategoryId
        {
            get { return categoryid; }
            set { categoryid = value; }
        }
        public string Name
        {
            get { return name; }
            set { name = value; }
        }
        public decimal Price
        {
            get { return price; }
            set { price = value; }
        }
        public string Image
        {
            get { return image; }
            set { image = value; }
        }
        public string CategoryName
        {
            get { return categoryname; }
            set { categoryname = value; }
        }

        public string Descn
        {
            get { return descn; }
            set { descn = value; }
        }
        public string SupplyTime
        {
            get { return supplytime; }
            set { supplytime = value; }
        }
        public string SupplyDate
        {
            get { return supplydate; }
            set { supplydate = value; }
        }
        public string SupplyArea
        {
            get { return supplyarea; }
            set { supplyarea = value; }
        }
    }
}

 

三、在数据访问层DAL的Item.cs类中添加函数GetItemDetailsByItemId()

public IList<ItemDetails> GetItemDetailsByItemId(int ItemId)
{

    IList<ItemDetails> itemDetailsByItemId = new List<ItemDetails>();

    SqlParameter parm = new SqlParameter(PARM_ITEM_ID, SqlDbType.Int);
    parm.Value = ItemId;

    using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_ITEMDETAILS_BY_CATEGORY, parm))
{
    		while (rdr.Read())
    		{
        		ItemDetails item = new ItemDetails(rdr.GetInt32(0), rdr.GetString(1), rdr.GetString(2), rdr.GetDecimal(3), rdr.GetString(4), rdr.GetString(5),rdr.GetString(6),rdr.GetString(7),rdr.GetString(8),rdr.GetString(9));
            	itemDetailsByItemId.Add(item);
        }
    }
    return itemDetailsByItemId;
}

四、Controls中添加用户控件ItemDetailsControl.ascx

1、前台代码：

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="ItemDetailsControl.ascx.cs" Inherits="WestGarden.Web.ItemDetailsControl" %>
<%@ Register TagPrefix="WestGardenControl" Namespace="WestGarden.Web" %>
<div>
<asp:FormView ID="fvwItemDetails" runat="server">
    <ItemTemplate>
        <table cellpadding="0" cellspacing="0">
            <tr>
                <td height="18" width="18">
                </td>
                <td height="18" width="96">
                </td>
                <td height="18" width="18">
                </td>
                <td height="18" width="96">
                </td>
                <td height="18" width="180">
                </td>
            </tr>
            <tr>
                <td width="18">
                </td>
                <td rowspan="7" width="96">
                    <asp:Image Width="144" Height="144" ID="imgItem" ImageUrl='<%# Eval("Image") %>'
                        AlternateText='<%# Eval("Name") %>' runat="server" /></td>
                <td width="18">
                </td>
                <td width="96">
                    商品类别：</td>
                <td width="180">
                    <%# Eval("CategoryName") %>
                </td>
            </tr>
            <tr>
                <td width="18">
                </td>
                <td width="18">
                </td>
                <td width="96">
                    商品名称：</td>
                <td width="180">
                    <%# Eval("Name") %>
                </td>
            </tr>
            <tr>
                <td width="18">
                </td>
                <td width="18">
                </td>
                <td width="96">
                    商品价格：</td>
                <td width="180">
                    <%# Eval("Price") %>
                </td>
            </tr>
            <tr>
                <td width="18">
                </td>
                <td width="18">
                </td>
                <td width="96">
                    商品描述：</td>
                <td width="180">
                    <%# Eval("Descn") %>
                </td>
            </tr>
            <tr>
                <td width="18">
                </td>
                <td width="18">
                </td>
                <td width="96">
                    供应时间：</td>
                <td width="180">
                    <%# Eval("SupplyTime") %>
                </td>
            </tr>
            <tr>
                <td width="18">
                </td>
                <td width="18">
                </td>
                <td width="96">
                    供应日期：</td>
                <td width="180">
                    <%# Eval("SupplyDate") %>
                </td>
            </tr>
            <tr>
                <td width="18">
                </td>
                <td width="18">
                </td>
                <td width="96">
                    供应地区：</td>
                <td width="180">
                    <%# Eval("SupplyArea") %>
                </td>
            </tr>
            <tr>
                <td height="18" width="18">
                </td>
                <td height="18" width="96">
                </td>
                <td height="18" width="18">
                </td>
                <td height="18" width="96">
                </td>
                <td height="18" width="180">
                </td>
            </tr>
        </table>
    </ItemTemplate>
</asp:FormView>
</div>
<div><a href='Items.aspx?categoryId=<%=Request.QueryString["categoryId"] %>'>< 返回</a></div>

2、后台代码

using System;
using System.Web;
using System.Web.UI.WebControls;
using WestGarden.DAL;

namespace WestGarden.Web
{
    public partial class ItemDetailsControl : System.Web.UI.UserControl
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            int itemKey = int.Parse(Request.QueryString["itemId"]);

            Item item = new Item();
            fvwItemDetails.DataSource = item.GetItemDetailsByItemId(itemKey);
            fvwItemDetails.DataBind();
        }
    }
}

五、Web中添加窗体ItemDetails.aspx并选择母版页MasterPage.master，拖入用户控件ItemDetailsControl.ascx，并在Page_Load()函数中添加代码：

protected void Page_Load(object sender, EventArgs e)
{
    Page.Title = WebUtility.GetCategoryName(Request.QueryString["categoryId"]);
}

版权所有©2012,西园电脑工作室.欢迎转载,转载请注明出处.更多文章请参阅博客http://blog.csdn.com/yousuosi

转载于:https://www.cnblogs.com/WestGarden/archive/2012/05/10/3138429.html