当前文件路径：TicketOnline/DayStatistics.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 DayStatistics : System.Web.UI.Page
14...{
15  
16    protected void Page_Load(object sender, EventArgs e)
17    ...{
18        if (!IsPostBack)
19        ...{
20            Checkperson1();
21            Checkpersonh2();
22          
23         //计算总营业额
24           
25                decimal str1 = Convert.ToDecimal(this.Label1.Text);
26                decimal str2 = Convert.ToDecimal(this.Label2.Text);
27                this.Label3.Text = Convert.ToString(str2 + str1);
28           
29        }
30    }
31    private void YudingMoney()
32    ...{
33        //所有预定车票当天的收入
34        
35        
36        SqlConnection con = db.ceratcon();
37        con.Open();
38        SqlCommand cmd = new SqlCommand("select sum(Omoney) from OrderTicket where datediff(day,ObuyTime,getdate())=0", con);
39    
40        decimal summoney = Convert.ToDecimal(cmd.ExecuteScalar());
41        this.Label1.Text = Convert.ToString(summoney);
42
43
44    }
45    private void Money()
46    ...{
47        //所有出售车票当天的收入
48
49        SqlConnection con = db.ceratcon();
50        con.Open();
51        SqlCommand cmd = new SqlCommand("select sum(Smoney) from SealTicket  where datediff(day,Stime,getdate())=0", con);
52        decimal summoney = Convert.ToDecimal(cmd.ExecuteScalar());
53        this.Label2.Text = Convert.ToString(summoney);
54
55
56    }
57
58    private void Checkperson1()
59    ...{
60        //检索当天出售的车票表中是否存
61        
62
63        SqlConnection con = db.ceratcon();
64        con.Open();
65        SqlCommand cmd = new SqlCommand("select * from SealTicket   where datediff(day,Stime,getdate())=0", con);
66        SqlDataReader sdr = cmd.ExecuteReader();
67        if (sdr.Read())
68        ...{
69            Money();
70        }
71
72    }
73    private void Checkpersonh2()
74    ...{
75
76        //检索当天预定的车票表中是否存
77      
78        SqlConnection con = db.ceratcon();
79        con.Open();
80        SqlCommand cmd = new SqlCommand("select * from OrderTicket  where datediff(day,ObuyTime,getdate())=0", con);
81        SqlDataReader sdr = cmd.ExecuteReader();
82        if (sdr.Read())
83        ...{
84            YudingMoney();
85        }
86
87
88    }
89}
90