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>"); } }