站内搜索：

ASP.NET在线香水销售系统(9)

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

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)
    {
        if (Convert.ToDecimal(this.TextBox4.Text) > Convert.ToDecimal(this.TextBox6.Text))
        {
            Page.ClientScript('该用户预付金不足，请联系！'>");
            return;
        }