当前文件路径：TicketOnline/SealTicket.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 SealTicket : System.Web.UI.Page
14...{
15    public int time;//定义全局变量获取设置的时间
16    protected void Page_Load(object sender, EventArgs e)
17    ...{
18    }
19    protected void Linkbuy_Click(object sender, EventArgs e)
20    ...{//以下判断售票时间时间根据设置的时间进行卖票
21        Time();
22        if (DateTime.Now.Hour > time)
23        ...{
24            this.Label1.Text = this.DropDownList1.SelectedItem.Text;
25            this.Label2.Text = this.DropDownList2.SelectedItem.Text;
26            this.Label3.Text = this.DropDownList3.SelectedItem.Text;
27            this.Label4.Text = DropDownList2.SelectedValue;
28        }
29        else
30        ...{
31
32            Response.Write("<script language='javascript'>alert('当前时间不能卖票');location.href='SealTicket.aspx'</script>");
33        
34        }
35    }
36
37    protected void LinkButton1_Click(object sender, EventArgs e)
38    ...{
39        InsertTicket();//把购票信息添加到数据库中
40        Response.Write("<script language='javascript'>alert('购买成功确认打印  ')</script>");
41    }
42     public  void Time()//判断售票时间时间根据设置的时间进行卖票过程
43    ...{
44        SqlConnection con = db.ceratcon();
45        con.Open();
46        SqlCommand cmd = new SqlCommand("select SysBuyTime  from System", con);//从数据库中选择设置时间
47        time = Convert.ToInt32(cmd.ExecuteScalar());
48     
49        con.Close();
50       
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 SealTicket (SCar,SticketType,Stime,Smoney,Sadmin)values(@SCar,@SticketType,@Stime,@Smoney,@Sadmin)";
60
61
62        cmd.Parameters.Add("@SCar", SqlDbType.VarChar);
63        cmd.Parameters.Add("@SticketType", SqlDbType.VarChar);
64        cmd.Parameters.Add("@Stime", SqlDbType.DateTime);
65        cmd.Parameters.Add("@Smoney",SqlDbType.Money);
66        cmd.Parameters.Add("@Sadmin", SqlDbType.VarChar);
67
68        cmd.Parameters["@SCar"].Value = this.Label1.Text;
69        cmd.Parameters["@SticketType"].Value = this.Label2.Text;
70        cmd.Parameters["@Stime"].Value = this.Label3.Text;
71        cmd.Parameters["@Smoney"].Value = Label4.Text;
72        cmd.Parameters["@Sadmin"].Value = Session["Aname"].ToString();
73        cmd.ExecuteNonQuery();
74        con.Close();
75       
76    
77    
78    
79    }
80}
81