protected void Page_Load(object sender, EventArgs e)
{
sqlconnection.openDatabase();//打开数据库
//查询所有用户的邮箱，并存放在userEmailList里
string sqlyuju1 = "select email from UserManagement";
SqlCommand cmd1 = sqlconnection.executeSQL(sqlyuju1);
SqlDataReader dr1 = cmd1.ExecuteReader();
if (dr1.HasRows)
{
//读取多个结果集
//用do--while方法，do中先读取第一个结果集，while中读取第二个结果集，依次循环
do
{
if (dr1.HasRows)
{
while (dr1.Read())
{
for (int i = 0; i < dr1.FieldCount; i++)
{
userEmailList.Add((string)dr1.GetValue(i));//将读取到的某一条记录添加到userEmailList中
}
}
}
}while (dr1.NextResult());
}
dr1.Close();
sqlconnection.closeDatabase();//关闭数据库
//根据userEmailList中的所有用户邮箱来查询出该用户的所有信息
sqlconnection.openDatabase();//打开数据库
for (int i = 0; i < userEmailList.Count(); i++)
{
//根据userIdList中的一项，读取某个用户的全部信息
string sqlyuju2 = "Select * from UserManagement where email='" + userEmailList[i] + "'";
SqlCommand cmd2 = sqlconnection.executeSQL(sqlyuju2);
SqlDataReader dr2 = cmd2.ExecuteReader();
if (dr2.Read())
{
Users user = new Users();//创建一个新的User对象
//将读取到的数据赋值给新建Users对象
user.setName((string)dr2[0].ToString().Trim());
user.setSex((string)dr2[1].ToString().Trim());
user.setEmail(userEmailList[i]);
user.setPhone((string)dr2[3].ToString().Trim());
user.setUsername((string)dr2[4].ToString().Trim());
list.Add(user);//将此Users对象添加到list中
}
dr2.Close();
}
Session["list"] = list;
}
protected void Button1_Click(object sender, EventArgs e)
{
string sqlyuju = null;
string username = (string)Session["username"];
//获取前台网页所提交的数据
string beforecode = Request.Form["beforecode1"];
string newcode = Request.Form["newcode1"];
string renewrode = Request.Form["renewrode1"];
if (newcode == "")//用户未输入新密码
{
message1 = "请输入新密码";
}
else if (!newcode.Equals(renewrode))//用户两次输入的新密码不一致
{
message1 = "两次新密码输入不一致，请重新输入";
}
else
{
try
{
sqlconnection.openDatabase();//打开数据库
//根据用户名和输入的原密码查询是否有此记录，以核对输入的原密码是否正确
sqlyuju = "SELECT count(*) FROM UserManagement WHERE Username = '******'and Password = '******'";
SqlCommand cmd1 = sqlconnection.executeSQL(sqlyuju);
SqlDataReader sdr = cmd1.ExecuteReader();//创建数据读取器对象
sdr.Read();
sdr.Close();
int n = (int)cmd1.ExecuteScalar(); //传回第一行，赋给n
if (n >= 1) //原密码输入正确
{
sqlyuju = "update UserManagement set Password = '******' where username = '******';";
SqlCommand cmd2 = sqlconnection.executeSQL(sqlyuju);
cmd2.ExecuteNonQuery();
Response.Write("<script>alert('修改成功!');window.location.href ='personCenter_main.aspx'</script>");//返回个人信息页面
}
else
{
message1 = "原密码错误,请重新输入";
}
sqlconnection.closeDatabase();
}
catch (Exception ex)
{
throw ex;
}
}
Session["username"] = username;
}
protected void Page_Load(object sender, EventArgs e)
{
sqlconnection.openDatabase();
string sqlyuju1 = "select * from Movies";
SqlCommand cmd1 = sqlconnection.executeSQL(sqlyuju1);
SqlDataAdapter sda = new SqlDataAdapter(cmd1);
DataSet dataSet = new DataSet();
sda.Fill(dataSet);
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
Movies movie = new Movies();
movie.setMovieNo(dataSet.Tables[0].Rows[i][0].ToString().Trim());
movie.setMovieName(dataSet.Tables[0].Rows[i][1].ToString().Trim());
movie.setType(dataSet.Tables[0].Rows[i][2].ToString().Trim());
movie.setCountry(dataSet.Tables[0].Rows[i][3].ToString().Trim());
movie.setMinute(dataSet.Tables[0].Rows[i][4].ToString().Trim());
movie.setDirector(dataSet.Tables[0].Rows[i][5].ToString().Trim());
movie.setActors(dataSet.Tables[0].Rows[i][6].ToString().Trim());
movie.setPlayDate(dataSet.Tables[0].Rows[i][7].ToString().Trim());
movie.setPrice(dataSet.Tables[0].Rows[i][8].ToString().Trim());
movie.setSummary(dataSet.Tables[0].Rows[i][9].ToString().Trim());
movie.setBriefIntroduction(dataSet.Tables[0].Rows[i][10].ToString().Trim());
movie.setImageMain(dataSet.Tables[0].Rows[i][11].ToString().Trim());
movie.setImage1(dataSet.Tables[0].Rows[i][12].ToString().Trim());
movie.setImage2(dataSet.Tables[0].Rows[i][13].ToString().Trim());
movie.setImage3(dataSet.Tables[0].Rows[i][14].ToString().Trim());
movie.setImage4(dataSet.Tables[0].Rows[i][15].ToString().Trim());
movie.setImage5(dataSet.Tables[0].Rows[i][16].ToString().Trim());
movie.setImage6(dataSet.Tables[0].Rows[i][17].ToString().Trim());
moviesList.Add(movie);
sqlconnection.closeDatabase();
}
//点击删除按钮时
string deleteMovieNo = Request.QueryString["deleteMovieNo"];
Session["deleteMovieNo"] = deleteMovieNo;
if (deleteMovieNo != null)
{
Session["request"] = "backStage_movieManagement";
string strMsg = "确定要删除吗？";
Response.Write("<Script Language='JavaScript'>if ( window.confirm('" + strMsg + "')) {alert('删除成功!');window.location.href ='executeDeleteSql.aspx'} else {history.back();};</script>");
//Response.Write("<script>alert('删除成功!');window.location.href ='backStage_movieManagement.aspx'</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
string movieNo = Request.QueryString["movieNo"];
sqlconnection.openDatabase();
string sqlyuju = "Select * from Movies" + " where MovieNo= '" + movieNo + "'";
SqlCommand cmd = sqlconnection.executeSQL(sqlyuju);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
updateMovie.setMovieNo((string)dr[0].ToString().Trim());
updateMovie.setMovieName((string)dr[1].ToString().Trim());
updateMovie.setType((string)dr[2].ToString().Trim());
updateMovie.setCountry((string)dr[3].ToString().Trim());
updateMovie.setMinute((string)dr[4].ToString().Trim());
updateMovie.setDirector((string)dr[5].ToString().Trim());
updateMovie.setActors((string)dr[6].ToString().Trim());
updateMovie.setPlayDate((string)dr[7].ToString().Trim());
updateMovie.setPrice((string)dr[8].ToString().Trim());
updateMovie.setSummary((string)dr[9].ToString().Trim());
updateMovie.setBriefIntroduction((string)dr[10].ToString().Trim());
updateMovie.setImageMain((string)dr[11].ToString().Trim());
updateMovie.setImage1((string)dr[12].ToString().Trim());
updateMovie.setImage2((string)dr[13].ToString().Trim());
updateMovie.setImage3((string)dr[14].ToString().Trim());
updateMovie.setImage4((string)dr[15].ToString().Trim());
updateMovie.setImage5((string)dr[16].ToString().Trim());
updateMovie.setImage6((string)dr[17].ToString().Trim());
}
sqlconnection.closeDatabase();
//显示图片
pic.ImageUrl = updateMovie.getImageMain();
Session["imageMain"] = updateMovie.getImageMain();
pic1.ImageUrl = updateMovie.getImage1();
Session["image1"] = updateMovie.getImage1();
pic2.ImageUrl = updateMovie.getImage2();
Session["image2"] = updateMovie.getImage2();
pic3.ImageUrl = updateMovie.getImage3();
Session["image3"] = updateMovie.getImage3();
pic4.ImageUrl = updateMovie.getImage4();
Session["image4"] = updateMovie.getImage4();
pic5.ImageUrl = updateMovie.getImage5();
Session["image5"] = updateMovie.getImage5();
pic6.ImageUrl = updateMovie.getImage6();
Session["image6"] = updateMovie.getImage6();
}
protected void Page_Load(object sender, EventArgs e)
{
old_email = (string)Session["email"];
string sqlyuju = "select * from UserManagement where Email = '" + old_email + "'";
sqlconnection.openDatabase();
SqlCommand cmd = sqlconnection.executeSQL(sqlyuju);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
old_name = (string)dr[0].ToString().Trim();
old_sex = (string)dr[1].ToString().Trim();
old_email = (string)dr[2].ToString().Trim();
old_phone = (string)dr[3].ToString().Trim();
old_username = (string)dr[4].ToString().Trim();
}
}
protected void Page_Load(object sender, EventArgs e)
{
String sqlyuju = null;
Session["yeshuTime"] = 1;
sqlconnection.openDatabase(); //打开数据库
id = (string)Session["id"]; //获取前台网页所提交的数据
sqlyuju = "select * from administrator where Id = '" + id + "'"; //查询当前用户的所有信息
SqlCommand cmd = sqlconnection.executeSQL(sqlyuju);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())//读取查询到的记录
{
//从记录里取值，赋值给需显示的对应的字段
id = (string)dr[0].ToString().Trim();
Session["id"] = id;
name = (string)dr[1].ToString().Trim();
Session["name"] = name;
sex = (string)dr[2].ToString().Trim();
Session["sex"] = sex;
email = (string)dr[3].ToString().Trim();
Session["email"] = email;
phone = (string)dr[4].ToString().Trim();
Session["phone"] = phone;
}
sqlconnection.closeDatabase();//关闭数据库
}
protected void Page_Load(object sender, EventArgs e)
{
string sqlyuju = null;
sqlconnection.openDatabase();//打开数据库
sqlyuju = "select MovieName from Movies";
SqlCommand cmd = sqlconnection.executeSQL(sqlyuju);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
//读取多个结果集
//用do--while方法，do中先读取第一个结果集，while中读取第二个结果集，依次循环
do
{
if (dr.HasRows)
{
while (dr.Read())
{
for (int i = 0; i < dr.FieldCount; i++)
{
list.Add((string)dr.GetValue(i));
}
}
}
}while (dr.NextResult());
}
sqlconnection.closeDatabase();//关闭数据库
}
protected List <Entity.Movies> movieList = new List <Entity.Movies>(); //创建一个列表用来存放电影类
protected void Page_Load(object sender, EventArgs e)
{
SQLConnection sqlconnection = new SQLConnection();
string sqlyuju = null;
//显示首页上的电影信息,数据库存储的前6行电影信息
sqlyuju = "SELECT TOP 6* FROM Movies";
sqlconnection.openDatabase();//打开数据库
SqlCommand cmd2 = sqlconnection.executeSQL(sqlyuju);
SqlDataAdapter sda = new SqlDataAdapter(cmd2);
DataSet dataSet = new DataSet();
sda.Fill(dataSet);
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
Entity.Movies movie = new Entity.Movies();
movie.setMovieName(dataSet.Tables[0].Rows[i][1].ToString().Trim());
movie.setDirector(dataSet.Tables[0].Rows[i][5].ToString().Trim());
movie.setActors(dataSet.Tables[0].Rows[i][6].ToString().Trim());
movie.setType(dataSet.Tables[0].Rows[i][2].ToString().Trim());
movie.setCountry(dataSet.Tables[0].Rows[i][3].ToString().Trim());
movie.setPlayDate(dataSet.Tables[0].Rows[i][7].ToString().Trim());
movie.setSummary(dataSet.Tables[0].Rows[i][9].ToString().Trim());
movie.setImageMain(dataSet.Tables[0].Rows[i][11].ToString().Trim());
movieList.Add(movie);
}
sqlconnection.closeDatabase();
}
protected void Page_Load(object sender, EventArgs e)
{
String sqlyuju = null;
sqlconnection.openDatabase(); //打开数据库
username = (string)Session["username"]; //获取前台网页所提交的数据
sqlyuju = "select * from UserManagement where Username = '******'"; //查询当前用户的所有信息
SqlCommand cmd = sqlconnection.executeSQL(sqlyuju);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())//读取查询到的记录
{
//从记录里取值，赋值给需显示的对应的字段
name = (string)dr[0].ToString().Trim();
Session["name"] = name;
sex = (string)dr[1].ToString().Trim();
Session["sex"] = sex;
email = (string)dr[2].ToString().Trim();
Session["email"] = email;
phone = (string)dr[3].ToString().Trim();
Session["phone"] = phone;
Session["username"] = username;
}
sqlconnection.closeDatabase();//关闭数据库
}
protected List <int> countList = new List <int>(); //创建一个列表用来存放每个日期的上映次数
protected void Page_Load(object sender, EventArgs e)
{
string sqlyuju1 = null;
string sqlyuju2 = null;
sqlconnection.openDatabase();//打开数据库
string movieName = Request.QueryString["content"];
sqlyuju1 = "Select MovieName,Type,Price,PlayingDate,Time,HallName,HallType 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";
sqlyuju2 = "Select count(*) from Movies,MovieSchedual,Schedual,VedioHalls" + " where Movies.MovieNo = MovieSchedual.MovieNo and MovieSchedual.SessionNo = Schedual.SessionNo and MovieSchedual.HallNo = VedioHalls.HallNo and MovieName= '" + movieName + "'" + "group by PlayingDate";
SqlCommand cmd1 = sqlconnection.executeSQL(sqlyuju1);
SqlCommand cmd2 = sqlconnection.executeSQL(sqlyuju2);
SqlDataAdapter sda = new SqlDataAdapter(cmd1);
DataSet dataSet = new DataSet();
sda.Fill(dataSet);
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
Entity.MovieSession movSession = new Entity.MovieSession();
movSession.setMovieName(dataSet.Tables[0].Rows[i][0].ToString().Trim());
movSession.setType(dataSet.Tables[0].Rows[i][1].ToString().Trim());
movSession.setPrice(dataSet.Tables[0].Rows[i][2].ToString().Trim());
movSession.setPlayingDate(dataSet.Tables[0].Rows[i][3].ToString().Trim());
movSession.setTime(dataSet.Tables[0].Rows[i][4].ToString().Trim());
movSession.setHallName(dataSet.Tables[0].Rows[i][5].ToString().Trim());
movSession.setHallType(dataSet.Tables[0].Rows[i][6].ToString().Trim());
sessionList.Add(movSession);
}
SqlDataReader dr = cmd2.ExecuteReader();
if (dr.HasRows)
{
//读取多个结果集
//用do--while方法，do中先读取第一个结果集，while中读取第二个结果集，依次循环
do
{
if (dr.HasRows)
{
while (dr.Read())
{
for (int i = 0; i < dr.FieldCount; i++)
{
countList.Add((int)dr.GetValue(i));
}
}
}
}while (dr.NextResult());
}
dr.Close();
sqlconnection.closeDatabase();//关闭数据库
}
protected void Button1_Click(object sender, EventArgs e)
{
SQLConnection sqlconnection = new SQLConnection();
//获取前台网页所提交的数据
string movieNo = Request.Form["movieNo"];
string movieName = Request.Form["movieName"];
string hallName = Request.Form["hallName"];
string playingDate = Request.Form["playingDate"];
string time = Request.Form["time"];
string hallNo = null;
string sessionNo = null;
sqlconnection.openDatabase();
string sqlyuju1 = "select HallNo from VedioHalls where HallName ='" + hallName + "'";
string sqlyuju2 = "select SessionNo from Schedual where Time ='" + time + "'";
SqlCommand cmd1 = sqlconnection.executeSQL(sqlyuju1);
SqlDataReader sdr1 = cmd1.ExecuteReader();//创建数据读取器对象
if (sdr1.Read())
{
hallNo = sdr1[0].ToString().Trim();
}
sdr1.Close();//查询出影厅名称对应的影厅编号
SqlCommand cmd2 = sqlconnection.executeSQL(sqlyuju2);
SqlDataReader sdr2 = cmd2.ExecuteReader();//创建数据读取器对象
if (sdr2.Read())
{
sessionNo = sdr2[0].ToString().Trim();
}
sdr2.Close();//查询出场次时间对应的场次号
string sqlyuju3 = "select count(*) from MovieSchedual where HallNo = '" + hallNo + "' and SessionNo = '" + sessionNo + "' and PlayingDate = '" + playingDate + "'";
SqlCommand cmd3 = sqlconnection.executeSQL(sqlyuju3);
SqlDataReader sdr3 = cmd3.ExecuteReader();//创建数据读取器对象
sdr3.Read();
sdr3.Close();
int n = (int)cmd3.ExecuteScalar();//传回第一行，赋给n
if (n == 0)
{//查询是否存在影片已在该日期该时间段该影厅，避免重复
string sqlyuju4 = "insert into MovieSchedual(MovieNo,HallNo,SessionNo,PlayingDate) values('" + movieNo + "','" + hallNo + "','" + sessionNo + "','" + playingDate + "')";
SqlCommand cmd = sqlconnection.executeSQL(sqlyuju4);
cmd.ExecuteNonQuery();
Response.Write("<script>alert('添加成功!');window.location.href ='backStage_playManagement.aspx'</script>");
}
else
{
Response.Write("<script>alert('已有影片安排在当前日期当前时间当前影厅，请重新选择!')</script>");
}
sqlconnection.closeDatabase();
}
protected string old_sessionNo; //原来的场次号
protected void Page_Load(object sender, EventArgs e)
{
old_hallName = Request.QueryString["hallName"];
old_playingDate = Request.QueryString["playingDate"];
old_time = Request.QueryString["time"];
sqlconnection.openDatabase();
string sqlyuju = "Select MovieSchedual.MovieNo,MovieName,MovieSchedual.HallNo,HallName,PlayingDate,MovieSchedual.SessionNo,Time from Movies,MovieSchedual,Schedual,VedioHalls" + " where Movies.MovieNo = MovieSchedual.MovieNo and MovieSchedual.SessionNo = Schedual.SessionNo and MovieSchedual.HallNo = VedioHalls.HallNo and HallName = '" + old_hallName + "'" + "and playingDate = '" + old_playingDate + "'" + "and Time = '" + old_time + "'";
SqlCommand cmd = sqlconnection.executeSQL(sqlyuju);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
old_movieNo = (string)dr[0].ToString().Trim();
old_movieName = (string)dr[1].ToString().Trim();
old_hallNo = (string)dr[2].ToString().Trim();
old_sessionNo = (string)dr[5].ToString().Trim();
}
sqlconnection.closeDatabase();
}
protected void Page_Load(object sender, EventArgs e)
{
sqlconnection.openDatabase();
string sqlyuju1 = "select * from Orders";
SqlCommand cmd1 = sqlconnection.executeSQL(sqlyuju1);
SqlDataAdapter sda = new SqlDataAdapter(cmd1);
DataSet dataSet = new DataSet();
sda.Fill(dataSet);
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
Orders orders = new Orders();
orders.setOrderNo(dataSet.Tables[0].Rows[i][0].ToString().Trim());
orders.setMovieName(dataSet.Tables[0].Rows[i][1].ToString().Trim());
orders.setCustomerName(dataSet.Tables[0].Rows[i][2].ToString().Trim());
orders.setPlayingDate(dataSet.Tables[0].Rows[i][3].ToString().Trim());
orders.setTime(dataSet.Tables[0].Rows[i][4].ToString().Trim());
orders.setHallName(dataSet.Tables[0].Rows[i][5].ToString().Trim());
orders.setSeat(dataSet.Tables[0].Rows[i][6].ToString().Trim());
orders.setPrice(dataSet.Tables[0].Rows[i][7].ToString().Trim());
orders.setStatement(dataSet.Tables[0].Rows[i][8].ToString().Trim());
orders.setGenerateDate(dataSet.Tables[0].Rows[i][9].ToString().Trim());
ordersList.Add(orders);
}
//点击删除按钮时
string deleteOrderNo = Request.QueryString["deleteOrderNo"];
Session["deleteOrderNo"] = deleteOrderNo;
if (deleteOrderNo != null)
{
string strMsg = "确定要删除吗？";
Session["request"] = "backStage_orderManagement";
Response.Write("<Script Language='JavaScript'>if ( window.confirm('" + strMsg + "')) {alert('删除成功!');window.location.href ='executeDeleteSql.aspx'} else {history.back();};</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string sqlyuju = null;
//获取前台网页所提交的数据
string name = Request.Form["name"];
string email = Request.Form["email"];
string phonenum = Request.Form["phoneNo"];
string username = Request.Form["userName"];
string password = Request.Form["password"];
string repassword = Request.Form["pswRepeat"];
string payPassword = Request.Form["payPassword"];
string rePayPassword = Request.Form["rePayPassword"];
int result = -1;
//Session["email"] = this.email.Text;
if (name == "" || email == "" || phonenum == "" || username == "" || password == "" || repassword == "" || payPassword == "" || rePayPassword == "")
{
message = "请完善个人信息！";
}
else if (!password.Equals(repassword))
{
message = "登录密码输入不一致，请重新输入！";
}
else if (payPassword.Length != 6 || !(isNumberic(payPassword, out result)))
{
message = "支付密码必须为6位数字!";
if (!payPassword.Equals(rePayPassword))
{
message = "支付密码输入不一致，请重新输入！";
}
}
else
{
try
{
sqlconnection.openDatabase();//打开数据库
sqlyuju = "insert into UserManagement(Name,Email,Phone,Username,Password,PayPassword) values('" + name + "','" + email + "','" + phonenum + "','" + username + "','" + password + "','" + payPassword + "')";
SqlCommand cmd = sqlconnection.executeSQL(sqlyuju);
cmd.ExecuteNonQuery();
sqlconnection.closeDatabase();
}
catch (Exception ex)
{
throw ex;
}
Response.Write("<script>alert('注册成功!');window.location.href ='login.aspx'</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string sqlyuju = null;
//获取前台网页所提交的数据
string email = Request.Form["email"];
string password = Request.Form["password"];
Session["email"] = this.email.Text;
if (email == "")
{
message = "用户名为空，请输入用户名！";
}
else if (password == "")
{
message = "密码为空，请输入密码！";
}
else
{
try
{
sqlconnection.openDatabase();//打开数据库
sqlyuju = "SELECT count(*) FROM UserManagement WHERE Email = '" + email + "'and Password = '******'";
SqlCommand cmd = sqlconnection.executeSQL(sqlyuju);
SqlDataReader sdr = cmd.ExecuteReader();//创建数据读取器对象
sdr.Read();
sdr.Close();
int n = (int)cmd.ExecuteScalar();//传回第一行，赋给n
if (n >= 1)
{
Response.Redirect("/homePage2.aspx");
}
else
{
message = "用户名或密码错误！请重新输入";
}
sqlconnection.closeDatabase();
}
catch (Exception ex)
{
throw ex;
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
SQLConnection sqlconnection = new SQLConnection();
//获取前台网页所提交的数据
string movieNo = Request.Form["movieNo"];
string movieName = Request.Form["movieName"];
string type = Request.Form["type"];
string country = Request.Form["country"];
string minute = Request.Form["minute"];
string director = Request.Form["director"];
string actors = Request.Form["actors"];
string playDate = Request.Form["playDate"];
string price = Request.Form["price"];
string summary = Request.Form["summary"];
string briefIntroduction = Request.Form["briefIntroduction"];
string imageMain = (string)Session["imageMain"];
string image1 = (string)Session["image1"];
string image2 = (string)Session["image2"];
string image3 = (string)Session["image3"];
string image4 = (string)Session["image4"];
string image5 = (string)Session["image5"];
string image6 = (string)Session["image6"];
if (movieNo == null)
{
Response.Write("<script>alert('你没有输入影片编号，无法进行影片的添加！');</script>");
}
else
{
sqlconnection.openDatabase();
string sqlyuju = "insert into Movies(MovieNo,MovieName,Type,Country,Minute,Director,Actors,PlayDate,Price,Summary,BriefIntroduction,ImageMain,Image1,Image2,Image3,Image4,Image5,Image6) values('" + movieNo + "','" + movieName + "','" + type + "','" + country + "','" + minute + "','" + director + "','" + actors + "','" + playDate + "','" + price + "','" + summary + "','" + briefIntroduction + "','" + imageMain + "','" + image1 + "','" + image2 + "','" + image3 + "','" + image4 + "','" + image5 + "','" + image6 + "')";
SqlCommand cmd = sqlconnection.executeSQL(sqlyuju);
cmd.ExecuteNonQuery();
sqlconnection.closeDatabase();
Response.Write("<script>alert('添加成功!');window.location.href ='backStage_movieManagement.aspx'</script>");
}
}
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 Page_Load(object sender, EventArgs e)
{
{ //显示电影列表
string sqlyuju = null;
sqlconnection.openDatabase(); //打开数据库
sqlyuju = "select MovieName from Movies";
SqlCommand cmd = sqlconnection.executeSQL(sqlyuju);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
//读取多个结果集
//用do--while方法，do中先读取第一个结果集，while中读取第二个结果集，依次循环
do
{
if (dr.HasRows)
{
while (dr.Read())
{
for (int i = 0; i < dr.FieldCount; i++)
{
list.Add((string)dr.GetValue(i));
}
}
}
}while (dr.NextResult());
}
sqlconnection.closeDatabase();//关闭数据库
}
{ //显示某部影片的详细信息
string sqlyuju = null;
sqlconnection.openDatabase(); //打开数据库
//LinkButton alter = (LinkButton)sender;
string movieName = Request.QueryString["content"];
sqlyuju = "Select * from Movies" + " where MovieName= '" + movieName + "'";
SqlCommand cmd = sqlconnection.executeSQL(sqlyuju);
SqlDataReader dr = cmd.ExecuteReader();
Entity.Movies movie = new Entity.Movies();
if (dr.Read())
{
movie.setMovieNo((string)dr[0].ToString().Trim());
movie.setMovieName((string)dr[1].ToString().Trim());
movie.setType((string)dr[2].ToString().Trim());
movie.setCountry((string)dr[3].ToString().Trim());
movie.setMinute((string)dr[4].ToString().Trim());
movie.setDirector((string)dr[5].ToString().Trim());
movie.setActors((string)dr[6].ToString().Trim());
movie.setPlayDate((string)dr[7].ToString().Trim());
movie.setPrice((string)dr[8].ToString().Trim());
movie.setSummary((string)dr[9].ToString().Trim());
movie.setBriefIntroduction((string)dr[10].ToString().Trim());
movie.setImageMain((string)dr[11].ToString().Trim());
movie.setImage1((string)dr[12].ToString().Trim());
movie.setImage2((string)dr[13].ToString().Trim());
movie.setImage3((string)dr[14].ToString().Trim());
movie.setImage4((string)dr[15].ToString().Trim());
movie.setImage5((string)dr[16].ToString().Trim());
movie.setImage6((string)dr[17].ToString().Trim());
Session["Movie"] = movie; //保存movie对象
//Response.Redirect("/movieDetail.aspx");
}
mov = (Entity.Movies)Session["Movie"];
sqlconnection.closeDatabase();//关闭数据库
}
}
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 Page_Load(object sender, EventArgs e)
{
SQLConnection sqlconnection = new SQLConnection();
string request = (string)Session["request"];
re = request;
if (request.Equals("backStage_movieManagement"))
{//影片管理的删除
//执行删除的sql语句的函数
string deleteMovieNo = (string)Session["deleteMovieNo"];
sqlconnection.openDatabase();
string sqlyuju = "Delete from Movies where MovieNo = '" + deleteMovieNo + "'";
SqlCommand cmd = sqlconnection.executeSQL(sqlyuju);
cmd.ExecuteNonQuery();
sqlconnection.closeDatabase();
Response.Redirect("backStage_movieManagement.aspx");
}
if (request.Equals("backStage_playManagement") || request.Equals("backStage_queryMovieSession"))
{//放映管理的删除
string deleteHallName = (string)Session["deleteHallName"];
string deletePlayingDate = (string)Session["deletePlayingDate"];
string deleteTime = (string)Session["deleteTime"];
sqlconnection.openDatabase();
string hallNo = null;
string sessionNo = null;
string sqlyuju11 = "select HallNo from VedioHalls where HallName ='" + deleteHallName + "'";
string sqlyuju22 = "select SessionNo from Schedual where Time ='" + deleteTime + "'";
SqlCommand cmd11 = sqlconnection.executeSQL(sqlyuju11);
SqlDataReader sdr11 = cmd11.ExecuteReader();//创建数据读取器对象
if (sdr11.Read())
{
hallNo = sdr11[0].ToString().Trim();
}
sdr11.Close();
SqlCommand cmd22 = sqlconnection.executeSQL(sqlyuju22);
SqlDataReader sdr22 = cmd22.ExecuteReader();//创建数据读取器对象
if (sdr22.Read())
{
sessionNo = sdr22[0].ToString().Trim();
}
sdr22.Close();
string sqlyuju = "Delete from MovieSchedual where HallNo = '" + hallNo + "' and SessionNo = '" + sessionNo + "' and PlayingDate = '" + deletePlayingDate + "'";
SqlCommand cmd = sqlconnection.executeSQL(sqlyuju);
cmd.ExecuteNonQuery();
sqlconnection.closeDatabase();
if (request.Equals("backStage_playManagement"))
{
Response.Redirect("backStage_playManagement.aspx");
}
else
{
Response.Redirect("backStage_queryMovieSession.aspx");
}
}
if (request.Equals("backStage_orderManagement") || request.Equals("backStage_queryOrder"))
{//订单管理的删除
string deleteOrderNo = (string)Session["deleteOrderNo"];
deleteorderno = deleteOrderNo;
sqlconnection.openDatabase();
string sqlyuju = "Delete from Orders where OrderNo = '" + deleteOrderNo + "'";
SqlCommand cmd = sqlconnection.executeSQL(sqlyuju);
cmd.ExecuteNonQuery();
sqlconnection.closeDatabase();
if (request.Equals("backStage_orderManagement"))
{
Response.Redirect("backStage_orderManagement.aspx");
}
else
{
Response.Redirect("backStage_queryOrder.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string username = (string)Session["username"];
{ //显示电影列表
sqlconnection.openDatabase(); //打开数据库
//联合Orders表和UserManagement表，根据用户名查询该用户的未完成订单编号
string sqlyuju1 = "select OrderNo from Orders,UserManagement where Cusname=Name and Username='******' and Statement='未完成'; ";
SqlCommand cmd1 = sqlconnection.executeSQL(sqlyuju1);
SqlDataReader dr1 = cmd1.ExecuteReader();
if (dr1.HasRows)
{
//读取多个结果集
//用do--while方法，do中先读取第一个结果集，while中读取第二个结果集，依次循环
do
{
if (dr1.HasRows)
{
while (dr1.Read())
{
for (int i = 0; i < dr1.FieldCount; i++)
{
orderNoList1.Add((string)dr1.GetValue(i));//将读取到的某一条记录添加到orderNoList1中
}
}
}
}while (dr1.NextResult());
}
dr1.Close();
sqlconnection.closeDatabase();//关闭数据库
}
{
sqlconnection.openDatabase();//打开数据库
//联合Orders表和UserManagement表，根据用户名查询该用户的已完成订单编号
string sqlyuju2 = "select OrderNo from Orders,UserManagement where Cusname=Name and Username='******' and Statement='已完成'; ";
SqlCommand cmd2 = sqlconnection.executeSQL(sqlyuju2);
SqlDataReader dr2 = cmd2.ExecuteReader();
if (dr2.HasRows)
{
//读取多个结果集
do
{
if (dr2.HasRows)
{
while (dr2.Read())
{
for (int i = 0; i < dr2.FieldCount; i++)
{
orderNoList2.Add((string)dr2.GetValue(i));//将读取到的某一条记录添加到orderNoList2中
}
}
}
}while (dr2.NextResult());
}
dr2.Close();
sqlconnection.closeDatabase();//关闭数据库
}
{
sqlconnection.openDatabase();//打开数据库
//根据orderNoList1中的所有订单编号来查询出该用户的所有未完成订单信息
for (int i = 0; i < orderNoList1.Count(); i++)
{
//根据orderNoList1中的一项，查询某个订单的全部信息
string sqlyuju3 = "Select * from Orders where OrderNo='" + orderNoList1[i] + "'";
SqlCommand cmd3 = sqlconnection.executeSQL(sqlyuju3);
SqlDataReader dr3 = cmd3.ExecuteReader();
//Orders order = new Orders();
if (dr3.Read())
{
Orders order = new Orders();//创建一个新的Order对象
//将读取到的数据赋值给新建Orders对象
order.setOrderNo((string)dr3[0].ToString().Trim());
order.setMovieName((string)dr3[1].ToString().Trim());
order.setCustomerName((string)dr3[2].ToString().Trim());
order.setPlayingDate((string)dr3[3].ToString().Trim());
order.setTime((string)dr3[4].ToString().Trim());
order.setHallName((string)dr3[5].ToString().Trim());
order.setSeat((string)dr3[6].ToString().Trim());
order.setPrice((string)dr3[7].ToString().Trim());
order.setStatement((string)dr3[8].ToString().Trim());
order.setGenerateDate((string)dr3[9].ToString().Trim());
list1.Add(order);//将此Orders对象添加到list1中
}
dr3.Close();
}
//根据orderNoList2中的所有订单编号来查询出该用户的所有未完成订单信息
for (int i = 0; i < orderNoList2.Count(); i++)
{
//根据orderNoList2中的一项，查询某个订单的全部信息
string sqlyuju4 = "Select * from Orders where OrderNo='" + orderNoList2[i] + "'";
SqlCommand cmd4 = sqlconnection.executeSQL(sqlyuju4);
SqlDataReader dr4 = cmd4.ExecuteReader();
//Orders order = new Orders();
if (dr4.Read())
{
Orders order = new Orders();//创建一个新的Order对象
//将读取到的数据赋值给新建Orders对象
order.setOrderNo((string)dr4[0].ToString().Trim());
order.setMovieName((string)dr4[1].ToString().Trim());
order.setCustomerName((string)dr4[2].ToString().Trim());
order.setPlayingDate((string)dr4[3].ToString().Trim());
order.setTime((string)dr4[4].ToString().Trim());
order.setHallName((string)dr4[5].ToString().Trim());
order.setSeat((string)dr4[6].ToString().Trim());
order.setPrice((string)dr4[7].ToString().Trim());
order.setStatement((string)dr4[8].ToString().Trim());
order.setGenerateDate((string)dr4[9].ToString().Trim());
list2.Add(order);//将此Orders对象添加到list2中
}
dr4.Close();
}
sqlconnection.closeDatabase();//关闭数据库
}
//打印，模拟线下取票
{
string orderNo = Request.QueryString["orderNo"];
if (orderNo != null)
{
string statement = "已完成";
sqlconnection.openDatabase();//打开数据库
string sqlyuju = "update Orders set Statement = '" + statement + "' where OrderNo = '" + orderNo + "';";
SqlCommand cmd = sqlconnection.executeSQL(sqlyuju);
cmd.ExecuteNonQuery();
Response.Write("<script>alert('打印成功!');window.location.href ='personCenter_myOrders.aspx'</script>"); //返回个人信息页面
sqlconnection.closeDatabase(); //关闭数据库
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string sqlyuju1 = "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 order by MovieNo asc,PlayingDate asc,Time asc";
string sqlyuju2 = "Select count(*) from MovieSchedual";
sqlconnection.openDatabase();
SqlCommand cmd1 = sqlconnection.executeSQL(sqlyuju1);
SqlDataAdapter sda = new SqlDataAdapter(cmd1);
DataSet dataSet = new DataSet();
sda.Fill(dataSet);
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
MovieSession movieSession = new MovieSession();
movieSession.setMovieNo(dataSet.Tables[0].Rows[i][0].ToString().Trim());
movieSession.setMovieName(dataSet.Tables[0].Rows[i][1].ToString().Trim());
movieSession.setHallName(dataSet.Tables[0].Rows[i][2].ToString().Trim());
movieSession.setPlayingDate(dataSet.Tables[0].Rows[i][3].ToString().Trim());
movieSession.setTime(dataSet.Tables[0].Rows[i][4].ToString().Trim());
movieSessionList.Add(movieSession);
}
SqlCommand cmd2 = sqlconnection.executeSQL(sqlyuju2);
SqlDataReader sdr = cmd2.ExecuteReader();//创建数据读取器对象
sdr.Read();
sdr.Close();
int playCount = (int)cmd2.ExecuteScalar();//传回放映信息记录数
double n = playCount / 12.0;
yeshu = (int)Math.Ceiling(n);
sqlconnection.closeDatabase();
string ye = Request.QueryString["ye"];
if (ye != null && ye != "0")
{
int yeshuTime = int.Parse(ye);
if (yeshuTime <= yeshu)
{
if (yeshuTime > (int)Session["yeshuTime"])
{
Session["yeshuTime"] = yeshuTime;
}
if (yeshuTime <= (int)Session["yeshuTime"])
{
Session["yeshuTime"] = yeshuTime;
}
}
}
//点击删除按钮时
string deleteHallName = Request.QueryString["deleteHallName"];
string deletePlayingDate = Request.QueryString["deletePlayingDate"];
string deleteTime = Request.QueryString["deleteTime"];
Session["deleteHallName"] = deleteHallName;
Session["deletePlayingDate"] = deletePlayingDate;
Session["deleteTime"] = deleteTime;
if (deleteHallName != null)
{
string strMsg = "确定要删除吗？";
Session["request"] = "backStage_playManagement";
Response.Write("<Script Language='JavaScript'>if ( window.confirm('" + strMsg + "')) {alert('删除成功!');window.location.href ='executeDeleteSql.aspx'} else {history.back();};</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//判断支付密码是否正确
string payPassword = Request.Form["payPassword"];
SQLConnection sqlconnection = new SQLConnection();
try
{
string email = (string)Session["email"];
sqlconnection.openDatabase();
string sqlyuju = "SELECT count(*) FROM UserManagement WHERE Email = '" + email + "'and PayPassword = '******'";
SqlCommand cmd = sqlconnection.executeSQL(sqlyuju);
SqlDataReader sdr = cmd.ExecuteReader();//创建数据读取器对象
sdr.Read();
sdr.Close();
int n = (int)cmd.ExecuteScalar();//传回第一行，赋给n
if (n >= 1)
{
//生成相应的订单
string movieName = (string)Session["movieName"];
string playingDate = (string)Session["playingDate"];
string time = (string)Session["time"];
string hallName = (string)Session["hallName"];
string seat = (string)Session["seat"];
string statement = "未完成";
string customerName = null;
string generateDate = DateTime.Now.ToLongDateString().ToString(); //订单生成的日期
Session["generateDate"] = generateDate;
//生成订单号，订单号由支付成功时的当前物理时间组成
string orderNo1 = DateTime.Now.ToString("yyyy-MM-dd");
string orderNo2 = DateTime.Now.ToString("hh:mm:ss");
string orderNo = orderNo1 + orderNo2;
//提取字符串类型数据orderNo中的所有数字
string num = null;
foreach (char item in orderNo)
{
if (item >= 48 && item <= 57)
{
num += item;
}
}
orderNo = num;
Session["orderNo"] = orderNo;
try
{
sqlconnection.openDatabase();
string sqlyuju1 = "SELECT Name FROM UserManagement WHERE Email = '" + email + "'";
SqlCommand cmd1 = sqlconnection.executeSQL(sqlyuju1);
SqlDataReader dr1 = cmd1.ExecuteReader();//创建数据读取器对象
if (dr1.Read())
{
customerName = dr1[0].ToString().Trim();
Session["customerName"] = customerName;
}
dr1.Close();
string sqlyuju2 = "insert into Orders(OrderNo,MovieName,CusName,PlayingDate,Time,HallName,Seat,Price,Statement,GenerateDate) values('" + orderNo + "','" + movieName + "','" + customerName + "','" + playingDate + "','" + time + "','" + hallName + "','" + seat + "','" + price + "','" + statement + "','" + generateDate + "')";
SqlCommand cmd2 = sqlconnection.executeSQL(sqlyuju2);
cmd2.ExecuteNonQuery();
sqlconnection.closeDatabase();
}
catch (Exception ex)
{
throw ex;
}
Response.Write("<script>alert('支付成功!');window.location.href ='paymentSuccess.aspx'</script>");
}
else
{
message = "支付密码错误！请重新输入!";
}
sqlconnection.closeDatabase();
}
catch (Exception ex)
{
throw ex;
}
}
//查询
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>");
}
}
