当前文件路径：TicketOnline/OndutyInquiry.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 OndutyInquiry : System.Web.UI.Page
14...{
15    protected void Page_Load(object sender, EventArgs e)
16    ...{//还要加入session
17        if (!IsPostBack)
18        ...{
19            Checkperson1();
20            Checkpersonh2();
21        }
22    }
23    private void YudingMoney()
24    ...{
25        string person = Session["Aname"].ToString();
26        //所有当班人的预定车票收入
27
28        SqlConnection con = db.ceratcon();
29        con.Open();
30        SqlCommand cmd = new SqlCommand("select sum(Omoney) from OrderTicket where Oadmin='"+person+"' ", con);
31      decimal summoney = Convert.ToDecimal(cmd.ExecuteScalar());
32        this.Label1.Text =Convert.ToString(summoney);
33
34    
35    }
36    private void Money()
37    ...{
38        string person = Session["Aname"].ToString();
39        //所有当班人的出售车票收入
40
41        SqlConnection con = db.ceratcon();
42        con.Open();
43        SqlCommand cmd = new SqlCommand("select sum(Smoney) from SealTicket where Sadmin='"+person+"'", con);
44        decimal summoney = Convert.ToDecimal(cmd.ExecuteScalar());
45        this.Label2.Text = Convert.ToString(summoney);
46
47
48    }
49    private void Checkperson1()
50    ...{
51        //检索当班人的销售收入是否存在
52        string person = Session["Aname"].ToString();
53       
54        SqlConnection con = db.ceratcon();
55        con.Open();
56        SqlCommand cmd = new SqlCommand("select * from SealTicket   where Sadmin='"+person+"'", con);
57        SqlDataReader sdr = cmd.ExecuteReader();
58        if (sdr.Read())
59        ...{
60            Money();
61        }
62
63    }
64    private void Checkpersonh2()
65    ...{
66
67        //检索当班人的订票收入是否存在
68        string person = Session["Aname"].ToString();
69        SqlConnection con = db.ceratcon();
70        con.Open();
71        SqlCommand cmd = new SqlCommand("select * from OrderTicket  where Oadmin='" + person + "' ", con);
72        SqlDataReader sdr = cmd.ExecuteReader();
73        if (sdr.Read())
74        ...{
75            YudingMoney();
76        }
77
78
79    }
80
81
82}
83