源代码:13033480群共享
一、数据集Model添加商品信息类ItemInfo.cs。
using System;
namespace WestGarden.Model
{
public class ItemInfo
{
private int itemid;
private string categoryid;
private string name;
private decimal price;
private string image;
private string categoryname;
public ItemInfo() { }
public ItemInfo(int itemid, string categoryid, string name, decimal price, string image, string categoryname)
{
this.itemid = itemid;
this.categoryid = categoryid;
this.name = name;
this.price = price;
this.image = image;
this.categoryname = categoryname;
}
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; }
}
}
}
二、数据访问层DAL中添加类Item.cs,并添加函数GetItemsByCategory()
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using WestGarden.Model;
using WestGarden.DBUtility;
namespace WestGarden.DAL
{
public class Item
{
private const string SQL_SELECT_ITEMS_BY_CATEGORY = "SELECT Item.ItemId,Item.CategoryId,Item.Name,Item.Price,Item.Image,Category.Name FROM Item INNER JOIN Category ON Item.CategoryId=Category.CategoryId WHERE Item.CategoryId = @CategoryId";
private const string PARM_CATEGORY_ID = "@CategoryId";
public IList<ItemInfo> GetItemsByCategory(string CagegoryId)
{
IList<ItemInfo> itemsByCategory = new List<ItemInfo>();
SqlParameter parm = new SqlParameter(PARM_CATEGORY_ID, SqlDbType.VarChar, 20);
parm.Value = CagegoryId;
//Execute the query against the database
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_ITEMS_BY_CATEGORY, parm))
{
// Scroll through the results
while (rdr.Read())
{
ItemInfo item = new ItemInfo(rdr.GetInt32(0), rdr.GetString(1), rdr.GetString(2), rdr.GetDecimal(3), rdr.GetString(4), rdr.GetString(5));
itemsByCategory.Add(item);
}
}
return itemsByCategory;
}
}
}
三、DataList显示商品信息
1、 Item.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Items1.aspx.cs" Inherits="WestGarden.Web.Items1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>肯德基订餐系统——西园工作室</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:DataList ID="dlstItems" runat="server">
<ItemTemplate>
<table cellpadding="0" cellspacing="0">
<tr>
<td>
<asp:Image ID="imgItem" runat="server" AlternateText='<%# Eval("Name") %>' Height="120"
ImageUrl='<%# Eval("Image") %>' Width="120" />
</td>
</tr>
<tr>
<td>
<%# Eval("Name") %>
</td>
</tr>
<tr>
<td>
<%# Eval("Price") %>
</td>
</tr>
</table>
</ItemTemplate>
</asp:DataList></div>
</form>
</body>
</html>
2、Item.aspx.cx
using WestGarden.DAL;
namespace WestGarden.Web
{
public partial class Items1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string categoryKey = Request.QueryString["categoryId"];
Item item =new Item();
dlstItems.DataSource = item.GetItemsByCategory(categoryKey);
dlstItems.DataBind();
}
}
}
四、自定义DataList分页显示商品信息
1、自定义控件CustomList.cs,添加分页功能。
using System;
using System.Collections;
using System.Collections.Specialized;
using System.Text;
using System.Text.RegularExpressions;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace WestGarden.Web {
public class CustomList : DataList {
//Static constants
protected const string HTML1 = "<table cellpadding=0 cellspacing=0><tr><td colspan=2>";
protected const string HTML2 = "</td></tr><tr><td class=paging align=left>";
protected const string HTML3 = "</td><td align=right class=paging>";
protected const string HTML4 = "</td></tr></table>";
private static readonly Regex RX = new Regex(@"^&page=\d+", RegexOptions.Compiled);
private const string LINK_PREV = "<a href=?page={0}><上一页</a>";
private const string LINK_MORE = "<a href=?page={0}>下一页></a>";
private const string KEY_PAGE = "page";
private const string COMMA = "?";
private const string AMP = "&";
protected string emptyText;
private IList dataSource;
private int pageSize = 10;
private int currentPageIndex;
private int itemCount;
override public object DataSource {
set {
//This try catch block is to avoid issues with the VS.NET designer
//The designer will try and bind a datasource which does not derive from ILIST
try {
dataSource = (IList)value;
ItemCount = dataSource.Count;
}
catch {
dataSource = null;
ItemCount = 0;
}
}
}
public int PageSize {
get { return pageSize; }
set { pageSize = value; }
}
protected int PageCount {
get { return (ItemCount - 1) / pageSize; }
}
virtual protected int ItemCount {
get { return itemCount; }
set { itemCount = value; }
}
virtual public int CurrentPageIndex {
get { return currentPageIndex; }
set { currentPageIndex = value; }
}
public string EmptyText {
set { emptyText = value; }
}
public void SetPage(int index) {
OnPageIndexChanged(new DataGridPageChangedEventArgs(null, index));
}
override protected void OnLoad(EventArgs e) {
if (Visible) {
string page = Context.Request[KEY_PAGE];
int index = (page != null) ? int.Parse(page) : 0;
SetPage(index);
}
}
/// <summary>
/// Overriden method to control how the page is rendered
/// </summary>
/// <param name="writer"></param>
override protected void Render(HtmlTextWriter writer) {
//Check there is some data attached
if (ItemCount == 0) {
writer.Write(emptyText);
return;
}
//Mask the query
string query = Context.Request.Url.Query.Replace(COMMA, AMP);
query = RX.Replace(query, string.Empty);
// Write out the first part of the control, the table header
writer.Write(HTML1);
// Call the inherited method
base.Render(writer);
// Write out a table row closure
writer.Write(HTML2);
//Determin whether next and previous buttons are required
//Previous button?
if (currentPageIndex > 0)
writer.Write(string.Format(LINK_PREV, (currentPageIndex - 1) + query));
//Close the table data tag
writer.Write(HTML3);
//Next button?
if (currentPageIndex < PageCount)
writer.Write(string.Format(LINK_MORE, (currentPageIndex + 1) + query));
//Close the table
writer.Write(HTML4);
}
override protected void OnDataBinding(EventArgs e) {
//Work out which items we want to render to the page
int start = CurrentPageIndex * pageSize;
int size = Math.Min(pageSize, ItemCount - start);
IList page = new ArrayList();
//Add the relevant items from the datasource
for (int i = 0; i < size; i++)
page.Add(dataSource[start + i]);
//set the base objects datasource
base.DataSource = page;
base.OnDataBinding(e);
}
public event DataGridPageChangedEventHandler PageIndexChanged;
virtual protected void OnPageIndexChanged(DataGridPageChangedEventArgs e) {
if (PageIndexChanged != null)
PageIndexChanged(this, e);
}
}
}
2、用户控件
1、ItemssControl.ascx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Items1.aspx.cs" Inherits="WestGarden.Web.Items1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>肯德基订餐系统——西园工作室</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:DataList ID="dlstItems" runat="server">
<ItemTemplate>
<table cellpadding="0" cellspacing="0">
<tr>
<td>
<asp:Image ID="imgItem" runat="server" AlternateText='<%# Eval("Name") %>' Height="120"
ImageUrl='<%# Eval("Image") %>' Width="120" />
</td>
</tr>
<tr>
<td>
<%# Eval("Name") %>
</td>
</tr>
<tr>
<td>
<%# Eval("Price") %>
</td>
</tr>
</table>
</ItemTemplate>
</asp:DataList></div>
</form>
</body>
</html>
2、ItemssControl.ascx.cs
using System;
using System.Web;
using System.Web.UI.WebControls;
using WestGarden.DAL;
namespace WestGarden.Web {
public partial class ItemsControl : System.Web.UI.UserControl {
/// <summary>
/// Rebind control
/// </summary>
protected void PageChanged(object sender, DataGridPageChangedEventArgs e) {
//reset index
dlstItems.CurrentPageIndex = e.NewPageIndex;
//get category id
string categoryKey = Request.QueryString["categoryId"];
//bind data
Item item = new Item();
dlstItems.DataSource = item.GetItemsByCategory(categoryKey);
dlstItems.DataBind();
}
}
}
分享到:
相关推荐
DATELIST分页 公式化 直接套用 上下页 指定页码 首尾页
网上书店管理系统 1.登陆 注册 2.查询用户信息 光棒效果 修改用户信息 删除用户信息 3.显示所有图书信息 修改所有图书信息 删除所有图书信息 图书模糊查询 添加图书 图书排序 分页 4.DateList Repeater ...
用datelist做分页是asp.net方面的小例子
这是一个基于C#的关于网上购物的示例。 里面包含了注册,登陆,加入购物车,购买等功能,还能实时监测访问量和在线人数量。 界面清新,采用大量js,jquery特效进行页面的特效设计,很值得学习。 同时对ASP.net里面的...
list, 控件排序
本人亲自调试通过。网上有一些这种类型的代码,但讲得不清楚。现在附上.aspx和.aspx.cs文件供大家参考。
网上书店管理系统 JavaScript 动态显示脚本,页面美观大方 1.登陆 超级管理员登陆 注册 2.查询用户信息 光棒效果 修改用户信息 删除一条用户信息 删除多条图书信息 3.显示所有图书信息 光棒效果 修改所有图书信息...
使用三个联动DropDownList做的ASP.NET日期选择控件,里面包含两个控件,一个是同步的DateList,一个是异步的AsyDateList需要页面上有ScriptManager。
\'四个标签\"年\"\"月\"\"日\",其中一个caption为空name 为lb作为显示日期的容器 Private Sub Combo1_Click() Dim ty As Integer, tm As Integer, td As Integer, yl As String, sx As String, yOn As Boolean...
语言:English 您网站的在线预订小部件。 允许您的客户使用您网站的“日期列表”预订小部件在线预订。
SQL数据库操作,查询/提交/修改/搜索/精华/置顶; 页面参数传递; TREE应用,就是左边的树型目录; DATAGRID显示数据/排序/链接; DATELIST显示数据/图片; catch应用,缓存以提高性能。
DATELIST显示数据/图片; 新增功能: 搜索/置顶/精华 贴的设置 其实就怎么简单,就是将一些小技巧混合应用。 开放源码有两个目的: 1.供大家参考和指正; 2.希望大家能够在此基础上做些修改,尤其是美工方面,...
微信小程序的日历选择,主要针对... let dateList = this.data.dateList; let { checkInDate, checkOutDate } = wx.getStorageSync("ROOM_SOURCE_DATE"); let curreInid = checkInDate.substr(0, 4) + "-" + (checkI
比如用 print ‘,’.join(datelist) 就可以将datelist列表里面的所有项目并成一个字符串,当然这个表达式会在每一个项目中间插入一个逗号,这种方式比用循环的方式更简洁。 日期的操作必须使用time或datetime库 ...
更像是生成器,用于生成一个农历日期列表,给定一个起始Date和一个RRule ,返回一个农历日期的DateList 该应用程序已针对越南农历进行了明确显示,这意味着默认时区为GMT +7。 可能在1900年之前的日期无法正常...
读取时间序列 datelist = pd.read_csv('data.csv', header=None)[1] # 对时间序列进⾏格式化操作 x = [] for i in datelist: i = datetime.strptime(i, '%d-%m-%Y') x.append(datetime.strftime(i, '%Y-%m-%d')) # ...
应用场景,不同组件中操作统一组数据,不论哪个组件对数据进行了操作,其他组件中立马看到效果。这样他们就要共用一个服务实例,是本次的重点,如果不同实例,那么操作的就不是... public dateList: any = [ { name:
本文实例为大家分享了小程序日历左右滑动效果的具体代码,供大家参考,具体内容如下 ... <view class='item' xss=removed wx:for={{dateList}} data-index='{{index}}' bindtap='clickDate'> <view class='text-vie