站内搜索：

ASP.NET网上订餐系统(9)

来源：xiaoniu168.com 作者：本站原创添加时间：2011-12-16 点击数：32436

5.3 订单信息管理页面
此模块可以查看定购餐品的用户信息，及该用户定购餐品的详细信息，并对订单中的餐品同意预定。此时关联用户信息表和餐品信息表。

以下是引用片段：

核心代码如下：
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            //根据传递的订单编号查询显示订单主表内容
            DataTable tmpda = new DataTable();
            tmpda = DataBase.Get_Table("select * from hyddhz where ddbh='" + Request.QueryString["ID"].ToString() + "'");
            if (tmpda.Rows.Count > 0)
            {
                this.TextBox1.Text = tmpda.Rows[0]["ddbh"].ToString();
                this.TextBox2.Text = tmpda.Rows[0]["hydlm"].ToString();
                this.TextBox3.Text = tmpda.Rows[0]["zsl"].ToString();
                this.TextBox4.Text = tmpda.Rows[0]["zje"].ToString();
                this.TextBox15.Text = tmpda.Rows[0]["ddrq"].ToString();
            }

            //控制订单使用权限
            if (tmpda.Rows[0]["qddd"].ToString() != "")
            {
                this.Button1.Visible = false;
            }

            tmpda = DataBase.Get_Table("select * from hyxx where hydlm='" + this.TextBox2.Text.ToString() + "'");
            if (tmpda.Rows.Count > 0)
            {
                this.TextBox6.Text = tmpda.Rows[0]["ljycj"].ToString();
            }

            //显示订单明细表内容
            tmpda = DataBase.Get_Table("select * from hyddmx,spxx where hyddmx.spbh=spxx.spbh and hyddmx.ddbh='" + Request.QueryString["Id"].ToString() + "'");
            this.GridView1.DataSource = tmpda;
            this.GridView1.DataBind();
        }
    }

protected void Button1_Click(object sender, EventArgs e)
{

        //确认当前的订单信息
        DataBase.ExecSql("update hyddhz set qddd='同意预定' where ddbh='" + Request.QueryString["ID"].ToString() + "'");
        DataBase.ExecSql("update hyxx set ljycj= ljycj - " + this.TextBox4.Text + " where hydlm='" + this.TextBox2.Text.ToString() + "'");
    }

〖资料来源:计算机毕业论文 www.xiaoniu168.com〗

第10页为计算机毕业论文用户注册功能介绍......