温馨提示：代码在线浏览功能只能做为源码浏览参考，如果想更进一步了解该代码请下载：在线订票系统源码(毕业设计)
当前文件：
TicketOnline/QuarterStatistics.aspx.cs，打开代码结构图
TicketOnline/QuarterStatistics.aspx.cs，打开代码结构图
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class QuarterStatistics : System.Web.UI.Page
{
public string str;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
Checkidmonth1();
Checkidmonth2();
if (Label1.Text != "" || Label2.Text != "")
{
decimal str1 = Convert.ToDecimal(this.Label1.Text);
decimal str2 = Convert.ToDecimal(this.Label2.Text);
this.Label3.Text = Convert.ToString(str2 + str1);
}
}
private void YudingMoney()
{
if (DropDownList1.SelectedItem.Text == "第一季度")
{
str = "select sum(Omoney) from OrderTicket where ObuyTime between '2007-01-01' and '2007-03-31'";
}
else if (DropDownList1.SelectedItem.Text == "第二季度")
{
str = "select sum(Omoney) from OrderTicket where ObuyTime between '2007-04-01 'and '2007-06-30'";
}
else if (DropDownList1.SelectedItem.Text == "第三季度")
{
str = "select sum(Omoney) from OrderTicket where ObuyTime between '2007-07-01' and '2007-09-30'";
}
else if (DropDownList1.SelectedItem.Text == "第四季度")
{
str = "select sum(Omoney) from OrderTicket where ObuyTime between '2007-10-01' and '2007-12-31'";
}
//所有预定车票季度的收入
int month = this.DropDownList1.SelectedIndex + 1;
SqlConnection con = db.ceratcon();
con.Open();
SqlCommand cmd = new SqlCommand(str,con);
cmd.CommandText = str;
decimal summoney = Convert.ToDecimal(cmd.ExecuteScalar());
this.Label1.Text = Convert.ToString(summoney);
con.Close();
}
private void Money()
{
if (DropDownList1.SelectedItem.Text == "第一季度")
{
str = "select sum(Smoney) from SealTicket where Stime between '2007-01-01' and '2007-03-31'";
}
else if (DropDownList1.SelectedItem.Text == "第二季度")
{
str = "select sum(Smoney) from SealTicket where Stime between '2007-04-01 'and '2007-06-30'";
}
else if (DropDownList1.SelectedItem.Text == "第三季度")
{
str = "select sum(Smoney) from SealTicket where Stime between '2007-07-01' and '2007-09-30'";
}
else if (DropDownList1.SelectedItem.Text == "第四季度")
{
str = "select sum(Smoney) from SealTicket where Stime between '2007-10-01' and '2007-12-31'";
}
//所有出售车票季度的收入
SqlConnection con = db.ceratcon();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = (SqlConnection)con;
cmd.CommandText = str;
decimal summoney = Convert.ToDecimal(cmd.ExecuteScalar());
this.Label2.Text = Convert.ToString(summoney);
}
private void Checkidmonth1()
{
//检索出售的车票表中是否存在所选择月份信息
if (DropDownList1.SelectedItem.Text == "第一季度")
{
str = "select Stime from SealTicket where Stime between '2007-01-01' and '2007-03-31'";
}
else if (DropDownList1.SelectedItem.Text == "第二季度")
{
str = "select Stime from SealTicket where Stime between '2007-04-01 'and '2007-06-30'";
}
else if (DropDownList1.SelectedItem.Text == "第三季度")
{
str = "select Stime from SealTicket where Stime between '2007-07-01' and '2007-09-30'";
}
else if (DropDownList1.SelectedItem.Text == "第四季度")
{
str = "select Stime from SealTicket where Stime between '2007-10-01' and '2007-12-31'";
}
SqlConnection con = db.ceratcon();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = (SqlConnection)con;
cmd.CommandText = str;
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
Money();
}
else
{
Response.Write("<script language='javascript'>alert('该季度没有数据');location.href='QuarterStatistics.aspx'</script>");
}
}
private void Checkidmonth2()
{
//检索预售的车票表中是否存在所选择季度的信息
if (DropDownList1.SelectedItem.Text == "第一季度")
{
str = "select ObuyTime from OrderTicket where ObuyTime between '2007-01-01' and '2007-03-31'";
}
else if (DropDownList1.SelectedItem.Text == "第二季度")
{
str = "select ObuyTime from OrderTicket where ObuyTime between '2007-04-01 'and '2007-06-30'";
}
else if (DropDownList1.SelectedItem.Text == "第三季度")
{
str = "select ObuyTime from OrderTicket where ObuyTime between '2007-07-01' and '2007-09-30'";
}
else if (DropDownList1.SelectedItem.Text == "第四季度")
{
str = "select ObuyTime from OrderTicket where ObuyTime between '2007-10-01' and '2007-12-31'";
}
SqlConnection con = db.ceratcon();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = (SqlConnection)con;
cmd.CommandText = str;
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
YudingMoney();
}
else
{
Response.Write("<script language='javascript'>alert('该季度没有数据');location.href='QuarterStatistics.aspx'</script>");
}
}
}
打包下载该项目完整源码：在线订票系统源码(毕业设计)
