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