当前文件路径：TicketOnline/PredeterminedTicket.aspx.cs

		            
 1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient;
12
13public partial class PredeterminedTicket : System.Web.UI.Page
14...{
15    public int time;//定义全局变量获取设置的时间
16    protected void Page_Load(object sender, EventArgs e)
17    ...{
18
19    }
20    protected void Linkbuy_Click(object sender, EventArgs e)
21    ...{//以下判断售票时间时间根据设置的时间进行卖票
22        Time();
23        if (DateTime.Now.Hour > time)
24        ...{
25            this.Label1.Text = this.DropDownList1.SelectedItem.Text;
26            this.Label2.Text = this.DropDownList2.SelectedItem.Text;
27            this.Label3.Text = this.DropDownList3.SelectedItem.Text;
28            this.Label4.Text = this.DropDownList2.SelectedValue;
29        }
30        else
31        ...{
32
33            Response.Write("<script language='javascript'>alert('当前时间不能订票');location.href='PredeterminedTicket.aspx'</script>");
34
35        }
36    }
37    public void Time()//判断售票时间时间根据设置的时间进行卖票过程
38    ...{
39        SqlConnection con = db.ceratcon();
40        con.Open();
41        SqlCommand cmd = new SqlCommand("select SysOrderTime  from System", con);//从数据库中选择设置时间
42        time = Convert.ToInt32(cmd.ExecuteScalar());
43
44        con.Close();
45       
46    }
47    protected void LinkButton1_Click(object sender, EventArgs e)
48    ...{
49        InsertTicket();//把购票信息添加到数据库中预定表中
50        Response.Write("<script language='javascript'>alert('预定成功成功确认打印  ')</script>");
51    }
52    private void InsertTicket()
53    ...{//把购票信息添加到数据库中预定表中
54
55        SqlConnection con = db.ceratcon();
56        con.Open();
57        SqlCommand cmd = new SqlCommand();
58        cmd.Connection = (SqlConnection)con;//对象实例化
59        cmd.CommandText = "insert into OrderTicket (OCar,OTicketype,ObuyTime,Omoney,Ousetime,Oadmin)values(@OCar,@OTicketype,@ObuyTime,@Omoney,@Ousetime,@Oadmin)";
60
61
62        cmd.Parameters.Add("@OCar", SqlDbType.VarChar);
63        cmd.Parameters.Add("@OTicketype", SqlDbType.VarChar);
64        cmd.Parameters.Add("@ObuyTime", SqlDbType.DateTime);
65        cmd.Parameters.Add("@Omoney", SqlDbType.Money);
66        cmd.Parameters.Add("@Ousetime", SqlDbType.DateTime);
67        cmd.Parameters.Add("@Oadmin", SqlDbType.VarChar);
68
69        cmd.Parameters["@OCar"].Value = this.Label1.Text;
70        cmd.Parameters["@OTicketype"].Value = this.Label2.Text;
71        cmd.Parameters["@ObuyTime"].Value = DateTime.Now;
72        cmd.Parameters["@Omoney"].Value =Convert.ToDecimal(Label4.Text);
73        cmd.Parameters["@Ousetime"].Value = Convert.ToDateTime(Label3.Text);
74        cmd.Parameters["@Oadmin"].Value = Session["Aname"].ToString();
75        cmd.ExecuteNonQuery();
76        con.Close();
77
78
79
80
81    }
82}
83