6. ¶©µ¥ä¯ÀÀ
¶©µ¥¹ÜÀíÖ÷ÒªÊǶÔÍøÂ繺ÎïÉ̳ÇÍøÉϹºÎïµÄ¶©µ¥¹ÜÀí
6.1 ¶©µ¥ä¯ÀÀ
6.1.1 ¶©µ¥ä¯ÀÀ ½çÃæÈçͼËùʾ¡£
½çÃæ
using System; using System.Data;
using System.Configuration; using System.Collections; using System.Web;
using System.Web.Security; using System.Web.UI;
21
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Drawing;
public partial class orderbrown : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
if (!Page.IsPostBack) {
databind(); } }
public void databind() {
string orderbook = \; GridView1.DataSource = Class1.ExecSel(orderbook); GridView1.DataBind(); }
protected void GridView1_PageIndexChanging(object sender,
22
GridViewPageEventArgs e) {
GridView1.PageIndex = e.NewPageIndex; databind(); }
protected void Button2_Click(object sender, EventArgs e) {
string px = \
orderID ,orderTime,orderSum,payment,ship,buyerName,buyerEmail,buyerAddress,buyerCode,buyerTel,Payed from tblorder order by orderTime desc \;
GridView1.DataSource = Class1.ExecSel(px); GridView1.DataBind(); }
protected void Button4_Click(object sender, EventArgs e) {
string px = \
orderID,orderTime,orderSum,payment,ship,buyerName,buyerEmail,buyerAddress,buyerCode,buyerTel,Payed from tblorder order by orderTime asc \;
GridView1.DataSource = Class1.ExecSel(px);
23
GridView1.DataBind(); } }
7£®²âÊÔ·ÖÎö±¨¸æ
ÓÐÁ½ÖÖ»ù±¾·½·¨¿ÉÒÔÓÃÀ´±êʶ²âÊÔÓÃÀý£¬¼´¹¦ÄܲâÊÔ£¨ºÚºÐ²âÊÔ£©ºÍ½á¹¹²âÊÔ£¨°×ºÐ²âÊÔ£©¡£±¾´Î²âÊÔÎÒÖ÷Òª²ÉÓÃÁ˹¦ÄܲâÊÔ¡£
¹¦ÄܲâÊԵĻù±¾¹ÛµãÊÇ£¬ÈκγÌÐò¶¼¿ÉÒÔ¿´×÷Êǽ«ÊäÈ붨ÒåÓòȡֵӳÉäµ½Êä³öÖµÓòµÄº¯Êý¡£
7.1 ²âÊԼƻ®ºÍÒªµã
Èí¼þ²âÊԵı¾ÖÊÊÇÕë¶ÔÒª²âÊÔµÄÄÚÈÝÈ·¶¨Ò»×é²âÊÔÓÃÀý¡£ÔÚÌÖÂÛ֮ǰ£¬ÎÒÏȰÑÒª²âÊÔ¸÷¸öÄ£¿éµÄ¼Æ»®ºÍÒªµãÁгö¡£
7.1.1 ×Öµäά»¤²âÊÔÒªµã
Êý¾Ý¿âÁ¬½ÓÇé¿ö£ºÕý³£Çé¿ö£¬Êý¾Ý¿âÎļþȱÉÙ£¬ÍⲿϵͳÒì³£¡£ ϵͳÉèÖûñÈ¡£ºÕý³£Çé¿ö£¬ÍⲿϵͳÒì³£¡£
¶ÔÓû§ÊäÈëµÄÏìÓ¦£ººÏ·¨ÊäÈ룬Äܹ»Õý³£µ÷ÓÃ×ÓÄ£¿é£» ·Ç·¨ÊäÈ룬ϵͳÄÜ·ñ±æ±ð£¬²¢×÷³öÏìÓ¦(Ìá³ö¾¯¸æ)£» ×ÓÄ£¿éµÄÒì³£×´¿ö£¬ÏµÍ³ÄÜ·ñ¼°Ê±×ö³öÏìÓ¦¡£
7.1.2 Óû§¹ÜÀí²âÊÔÒªµã Ä£¿éÕý³£ÔËÐÐÁ÷³Ì
Óû§ÊäÈëÊý¾Ý¼ì²é£¬°üÀ¨Êý¾ÝºÏÀíÐÔ¼ì²é£¬ÒÔ¼°ºÏ·¨ÐÔ¼ì²é Êý¾Ý¿â²Ù×÷
24