protected void Button1_Click(object sender, EventArgs e)
{
SQLConnection sqlconnection = new SQLConnection();
string queryType = Request.Form["queryType"];
sqlconnection.openDatabase();
queryMovieSessionList.Clear();//清楚queryMovieSessionList中的所有元素
if (queryType.Equals("影片编号"))
{
string movieNo = Request.Form["TextBox1"];
int result = -1;
if (isNumberic(movieNo, result))
{
string sqlyuju2 = "Select MovieSchedual.MovieNo,MovieName,HallName,PlayingDate,Time from Movies,MovieSchedual,Schedual,VedioHalls" + " where Movies.MovieNo = MovieSchedual.MovieNo and MovieSchedual.SessionNo = Schedual.SessionNo and MovieSchedual.HallNo = VedioHalls.HallNo and MovieSchedual.MovieNo= '" + movieNo + "'" + "order by PlayingDate asc,Time asc";
SqlCommand cmd2 = sqlconnection.executeSQL(sqlyuju2);
SqlDataAdapter sda = new SqlDataAdapter(cmd2);
DataSet dataSet = new DataSet();
sda.Fill(dataSet);
if (dataSet.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
Session["dataSet"] = dataSet;
Response.Redirect("/backStage_queryMovieSession.aspx");
}
}
else
{
Response.Write("<script>alert('抱歉，没有查找到该影片的放映信息！');</script>");
}
}
else
{
Response.Write("<script>alert('输入的索引与查找类型不一致！');</script>");
}
}
else if (queryType.Equals("影片名称"))
{
string movieName = Request.Form["TextBox1"];
int result = -1;
if (!(isNumberic(movieName, result)))
{
string sqlyuju3 = "Select MovieSchedual.MovieNo,MovieName,HallName,PlayingDate,Time from Movies,MovieSchedual,Schedual,VedioHalls" + " where Movies.MovieNo = MovieSchedual.MovieNo and MovieSchedual.SessionNo = Schedual.SessionNo and MovieSchedual.HallNo = VedioHalls.HallNo and MovieName= '" + movieName + "'" + "order by PlayingDate asc,Time asc";
SqlCommand cmd3 = sqlconnection.executeSQL(sqlyuju3);
SqlDataAdapter sda = new SqlDataAdapter(cmd3);
DataSet dataSet = new DataSet();
sda.Fill(dataSet);
if (dataSet.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
Session["dataSet"] = dataSet;
Response.Redirect("/backStage_queryMovieSession.aspx");
}
}
else
{
Response.Write("<script>alert('抱歉，没有查找到该影片的放映信息！');</script>");
}
}
else
{
Response.Write("<script>alert('输入的索引与查找类型不一致！');</script>");
}
}
else
{
Response.Write("<script>alert('请选择查询类型！');</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string queryType = Request.Form["queryType"];
SQLConnection sqlconnection = new SQLConnection();
sqlconnection.openDatabase();
if (queryType.Equals("影片编号"))
{
string movieNo = Request.Form["TextBox1"];
int result = -1;
if (isNumberic(movieNo, result))
{
string sqlyuju2 = "Select * from Movies" + " where MovieNo= '" + movieNo + "'";
SqlCommand cmd2 = sqlconnection.executeSQL(sqlyuju2);
SqlDataReader dr2 = cmd2.ExecuteReader();
if (dr2.Read())
{
queryMovie.setMovieNo((string)dr2[0].ToString().Trim());
queryMovie.setMovieName((string)dr2[1].ToString().Trim());
queryMovie.setType((string)dr2[2].ToString().Trim());
queryMovie.setCountry((string)dr2[3].ToString().Trim());
queryMovie.setMinute((string)dr2[4].ToString().Trim());
queryMovie.setDirector((string)dr2[5].ToString().Trim());
queryMovie.setActors((string)dr2[6].ToString().Trim());
queryMovie.setPlayDate((string)dr2[7].ToString().Trim());
queryMovie.setPrice((string)dr2[8].ToString().Trim());
queryMovie.setSummary((string)dr2[9].ToString().Trim());
queryMovie.setBriefIntroduction((string)dr2[10].ToString().Trim());
queryMovie.setImageMain((string)dr2[11].ToString().Trim());
queryMovie.setImage1((string)dr2[12].ToString().Trim());
queryMovie.setImage2((string)dr2[13].ToString().Trim());
queryMovie.setImage3((string)dr2[14].ToString().Trim());
queryMovie.setImage4((string)dr2[15].ToString().Trim());
queryMovie.setImage5((string)dr2[16].ToString().Trim());
queryMovie.setImage6((string)dr2[17].ToString().Trim());
Session["queryMovie"] = queryMovie;
Response.Redirect("/backStage_queryMovie.aspx");
}
else
{
Response.Write("<script>alert('抱歉，没有查找到有关该影片信息！');</script>");
}
}
else
{
Response.Write("<script>alert('输入的索引与查找类型不一致！');</script>");
}
}
else if (queryType.Equals("影片名称"))
{
string movieName = Request.Form["TextBox1"];
int result = -1;
if (!(isNumberic(movieName, result)))
{
string sqlyuju3 = "Select * from Movies" + " where MovieName= '" + movieName + "'";
SqlCommand cmd3 = sqlconnection.executeSQL(sqlyuju3);
SqlDataReader dr3 = cmd3.ExecuteReader();
if (dr3.Read())
{
queryMovie.setMovieNo((string)dr3[0].ToString().Trim());
queryMovie.setMovieName((string)dr3[1].ToString().Trim());
queryMovie.setType((string)dr3[2].ToString().Trim());
queryMovie.setCountry((string)dr3[3].ToString().Trim());
queryMovie.setMinute((string)dr3[4].ToString().Trim());
queryMovie.setDirector((string)dr3[5].ToString().Trim());
queryMovie.setActors((string)dr3[6].ToString().Trim());
queryMovie.setPlayDate((string)dr3[7].ToString().Trim());
queryMovie.setPrice((string)dr3[8].ToString().Trim());
queryMovie.setSummary((string)dr3[9].ToString().Trim());
queryMovie.setBriefIntroduction((string)dr3[10].ToString().Trim());
queryMovie.setImageMain((string)dr3[11].ToString().Trim());
queryMovie.setImage1((string)dr3[12].ToString().Trim());
queryMovie.setImage2((string)dr3[13].ToString().Trim());
queryMovie.setImage3((string)dr3[14].ToString().Trim());
queryMovie.setImage4((string)dr3[15].ToString().Trim());
queryMovie.setImage5((string)dr3[16].ToString().Trim());
queryMovie.setImage6((string)dr3[17].ToString().Trim());
Session["queryMovie"] = queryMovie;
Response.Redirect("/backStage_queryMovie.aspx");
}
else
{
Response.Write("<script>alert('抱歉，没有查找到有关该影片信息！');</script>");
}
}
else
{
Response.Write("<script>alert('输入的索引与查找类型不一致！');</script>");
}
}
else
{
Response.Write("<script>alert('请选择查询类型！');</script>");
}
}
//查询
protected void Button1_Click(object sender, EventArgs e)
{
SQLConnection sqlconnection = new SQLConnection();
string queryType = Request.Form["queryType"];
sqlconnection.openDatabase();
if (queryType.Equals("订单编号"))
{
string orderNo = Request.Form["TextBox1"];
int result = -1;
if (isNumberic(orderNo, result))
{
string sqlyuju2 = "Select * from Orders" + " where OrderNo= '" + orderNo + "'";
SqlCommand cmd2 = sqlconnection.executeSQL(sqlyuju2);
SqlDataAdapter sda = new SqlDataAdapter(cmd2);
DataSet dataSet = new DataSet();
sda.Fill(dataSet);
if (dataSet.Tables[0].Rows.Count > 0)
{
Session["dataSet"] = dataSet;
Response.Redirect("/backStage_queryOrder.aspx");
}
else
{
Response.Write("<script>alert('抱歉，没有查找到有关该订单的信息！');</script>");
}
}
else
{
Response.Write("<script>alert('输入的索引与查找类型不一致！');</script>");
}
}
else if (queryType.Equals("影片名称"))
{
string movieName = Request.Form["TextBox1"];
int result = -1;
if (!(isNumberic(movieName, result)))
{
string sqlyuju3 = "Select * from Orders" + " where MovieName= '" + movieName + "'";
SqlCommand cmd3 = sqlconnection.executeSQL(sqlyuju3);
SqlDataAdapter sda = new SqlDataAdapter(cmd3);
DataSet dataSet = new DataSet();
sda.Fill(dataSet);
if (dataSet.Tables[0].Rows.Count > 0)
{
Session["dataSet"] = dataSet;
Response.Redirect("/backStage_queryOrder.aspx");
}
else
{
Response.Write("<script>alert('抱歉，没有查找到有关该订单的信息！');</script>");
}
}
else
{
Response.Write("<script>alert('输入的索引与查找类型不一致！');</script>");
}
}
else
{
Response.Write("<script>alert('请选择查询类型！');</script>");
}
}