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) { 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 提交_Click(object sender, EventArgs e) { string sqlyuju = null; old_email = (string)Session["email"];//获取前台网页所提交的数据 //获取前台网页所提交的数据 string name = Request.Form["name"]; string email = Request.Form["email"]; string sex = Request.Form["sex"]; string phone = Request.Form["phone"]; string username = Request.Form["username"]; try { sqlconnection.openDatabase();//打开数据库 //将获取到的数据更新到数据库中 sqlyuju = "update UserManagement set Name='" + name + "', Sex='" + sex + "',Email = '" + email + "',Username='******',Phone='" + phone + "' where Email='" + old_email + "';"; SqlCommand cmd = sqlconnection.executeSQL(sqlyuju); cmd.ExecuteNonQuery(); sqlconnection.closeDatabase(); } catch (Exception ex) { throw ex; } Session["username"] = username; Response.Write("<script>alert('修改成功!');window.location.href ='personCenter_main.aspx'</script>");//返回个人信息页面,显示更新后的信息 }
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 <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; 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 <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 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) { 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 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 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 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) { //判断支付密码是否正确 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 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 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 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>"); } }