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

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

计算机毕业设计订单信息功能介绍:

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页为计算机毕业论文用户注册功能介绍......

【联系方式】

【本站信誉】

用心做计算机毕业设计论文网