telleruse.cs

连锁影院售票系统

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace LTTS
{
	public class SelectBackTickets//(1)
	{
		public int BackNums;
	}
	public class SaleBackTickets//(4)
	{
		public String OnShowDate;
		public String OnShowNOP;
		public int BoxNo;
		public int SeatNo; 
		public String FilmID;
		public String CinemaID;
	}
	public class SaleNewTickets//(5)
	{
		public int SingleTickets;
		public int BoxTickets;
	}
	public class UserInf//(13)(22)
	{
		public int UserRights;
		public String UserName;
		public String TheaterID;
		public int Online;
	}
	public class MaxSale//(15)
	{
		public int OnShowBand;
	}
	public class TheaterInfSearch//(17)
	{
		public String TheaterName;
		public String LocationCity;
		public String Address;
		public String TelNo;
		public String Longitude;
		public String Latitude;
	}
	/// <summary>
	/// TellerUse 的摘要说明。
	/// </summary>
	public class TellerUse
	{
		public TellerUse(){}
		public SqlDataReader ProgramOnShowofOurTheater(string TheaterID,int Marked)//查找选定影院当天上映信息
		{
			//创建数据库连接和命令的对象
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
			SqlCommand myCommand = new SqlCommand("LeftBackTickets", myConnection);

			//指明Sql命令的操作类型是使用存储过程
			myCommand.CommandType = CommandType.StoredProcedure;

			//给存储过程添加参数
			SqlParameter parameterTheaterID = new SqlParameter("@TheaterID", SqlDbType.VarChar,4);
			parameterTheaterID.Value = TheaterID;
			myCommand.Parameters.Add(parameterTheaterID);

			SqlParameter parameterMarked = new SqlParameter("@Marked", SqlDbType.Int);
			parameterMarked.Value = Marked;
			myCommand.Parameters.Add(parameterMarked);

			//打开数据库连接
			myConnection.Open();
			//执行数据操作命令
			//SqlDataReader读取数据到记录集后，会自动关闭数据库的连接
			SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
            
			//返回DataReader的结果
			return result;

		}
		public SelectBackTickets ProgramLeftBackTickets(int OnShowIndex,int BoxorNot,int BackNums)//返回符合条件的退回的票的数量
		{
			//创建数据库连接和命令的对象
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
			SqlCommand myCommand = new SqlCommand("LeftBackTickets", myConnection);

			//指明Sql命令的操作类型是使用存储过程
			myCommand.CommandType = CommandType.StoredProcedure;

			//给存储过程添加参数
			SqlParameter parameterOnShowIndex = new SqlParameter("@OnShowIndex", SqlDbType.Int);
			parameterOnShowIndex.Value = OnShowIndex;
			myCommand.Parameters.Add(parameterOnShowIndex);

			SqlParameter parameterBoxorNot = new SqlParameter("@BoxorNot", SqlDbType.Int);
			parameterBoxorNot.Value = BoxorNot;
			myCommand.Parameters.Add(parameterBoxorNot);

			SqlParameter parameterBackNums = new SqlParameter("@BackNums", SqlDbType.Int);//用于返回剩余票量
			//指出该参数是存储过程的OUTPUT参数
			parameterBackNums.Direction = ParameterDirection.Output;
			myCommand.Parameters.Add(parameterBackNums);

			//打开数据库连接
			myConnection.Open();
			//进行数据库操作
			myCommand.ExecuteNonQuery();
			//关闭数据库连接
			myConnection.Close();

			//产生SelectBackTickets类的对象
			SelectBackTickets mySelectBackTickets=new SelectBackTickets();
			//根据存储过程的输出参数的值对mySelectBackTickets对象进行赋值
			mySelectBackTickets.BackNums=(int)parameterBackNums.Value;

			return mySelectBackTickets;
		}

		public SaleBackTickets ProgramSaleOfBackTickets(String UserID,int OnShowIndex,int BoxorNot)
		//从退票表中搜寻符合条件的影票并售出
		{
			//创建数据库连接和命令的对象
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
			SqlCommand myCommand = new SqlCommand("SaleOfBackTickets", myConnection);

			//指明Sql命令的操作类型是使用存储过程
			myCommand.CommandType = CommandType.StoredProcedure;

			//给存储过程添加参数
			SqlParameter parameterUserID = new SqlParameter("@UserID", SqlDbType.VarChar, 6);
			parameterUserID.Value = UserID;
			myCommand.Parameters.Add(parameterUserID);

			SqlParameter parameterOnShowIndex = new SqlParameter("@OnShowIndex", SqlDbType.Int);
			parameterOnShowIndex.Value = OnShowIndex;
			myCommand.Parameters.Add(parameterOnShowIndex);

			SqlParameter parameterBoxorNot = new SqlParameter("@BoxorNot", SqlDbType.Int);
			parameterBoxorNot.Value = BoxorNot;
			myCommand.Parameters.Add(parameterBoxorNot);

			SqlParameter parameterOnShowDate = new SqlParameter("@OnShowDate", SqlDbType.VarChar, 20);
			//指出该参数是存储过程的OUTPUT参数
			parameterOnShowDate.Direction = ParameterDirection.Output;
			myCommand.Parameters.Add(parameterOnShowDate);

			SqlParameter parameterOnShowNOP = new SqlParameter("@OnShowNOP", SqlDbType.VarChar, 6);
			//指出该参数是存储过程的OUTPUT参数
			parameterOnShowNOP.Direction = ParameterDirection.Output;
			myCommand.Parameters.Add(parameterOnShowNOP);

			SqlParameter parameterBoxNo = new SqlParameter("@BoxNo", SqlDbType.Int);
			//指出该参数是存储过程的OUTPUT参数
			parameterBoxNo.Direction = ParameterDirection.Output;
			myCommand.Parameters.Add(parameterBoxNo);

			SqlParameter parameterSeatNo = new SqlParameter("@SeatNo", SqlDbType.Int);
			//指出该参数是存储过程的OUTPUT参数
			parameterSeatNo.Direction = ParameterDirection.Output;
			myCommand.Parameters.Add(parameterSeatNo);

			SqlParameter parameterFilmID = new SqlParameter("@FilmID", SqlDbType.VarChar, 8);
			//指出该参数是存储过程的OUTPUT参数
			parameterFilmID.Direction = ParameterDirection.Output;
			myCommand.Parameters.Add(parameterFilmID);

			SqlParameter parameterCinemaID = new SqlParameter("@CinemaID", SqlDbType.VarChar, 4);
			//指出该参数是存储过程的OUTPUT参数
			parameterCinemaID.Direction = ParameterDirection.Output;
			myCommand.Parameters.Add(parameterCinemaID);

			//打开数据库连接
			myConnection.Open();
			//进行数据库操作
			myCommand.ExecuteNonQuery();
			//关闭数据库连接
			myConnection.Close();

			//产生SaleBackTickets类的对象
			SaleBackTickets mySaleBackTickets=new SaleBackTickets();
			//根据存储过程的输出参数的值对mySelectBackTickets对象进行赋值
			mySaleBackTickets.BoxNo=(int)parameterBoxNo.Value;
			mySaleBackTickets.CinemaID=(string)parameterCinemaID.Value;
			mySaleBackTickets.FilmID=(string)parameterFilmID.Value;
			mySaleBackTickets.OnShowDate=(string)parameterOnShowDate.Value;
			mySaleBackTickets.OnShowNOP=(string)parameterOnShowNOP.Value;
			mySaleBackTickets.SeatNo=(int)parameterSeatNo.Value;

			return mySaleBackTickets;
		}
		public SaleNewTickets ProgramSaleOfNewTickets(int OnShowIndex,string UserID,int OnshowNOP,int BoxorNot,int SingleTickets,int BoxTickets) 
		//从票库中销售新的影票
		{
			//创建数据库连接和命令的对象
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
			SqlCommand myCommand = new SqlCommand("SaleOfNewTickets", myConnection);

			//指明Sql命令的操作类型是使用存储过程
			myCommand.CommandType = CommandType.StoredProcedure;

			//给存储过程添加参数
			SqlParameter parameterOnShowIndex = new SqlParameter("@OnShowIndex", SqlDbType.Int);
			parameterOnShowIndex.Value = OnShowIndex;
			myCommand.Parameters.Add(parameterOnShowIndex);

			SqlParameter parameterOnshowNOP = new SqlParameter("@OnshowNOP", SqlDbType.Int);
			parameterOnshowNOP.Value = OnshowNOP;
			myCommand.Parameters.Add(parameterOnshowNOP);

			SqlParameter parameterBoxorNot = new SqlParameter("@BoxorNot", SqlDbType.Int);
			parameterBoxorNot.Value = BoxorNot;
			myCommand.Parameters.Add(parameterBoxorNot);

			SqlParameter parameterSingleTickets = new SqlParameter("@SingleTickets", SqlDbType.Int);
			//指出该参数是存储过程的OUTPUT参数
			parameterSingleTickets.Value = SingleTickets;
			myCommand.Parameters.Add(parameterSingleTickets);

			SqlParameter parameterBoxTickets = new SqlParameter("@BoxTickets", SqlDbType.Int);
			//指出该参数是存储过程的OUTPUT参数
			parameterBoxTickets.Direction = ParameterDirection.Output;
			myCommand.Parameters.Add(parameterBoxTickets);

			SqlParameter parameterUserID = new SqlParameter("@UserID", SqlDbType.VarChar, 6);
			//指出该参数是存储过程的OUTPUT参数
			parameterUserID.Direction = ParameterDirection.Output;
			myCommand.Parameters.Add(parameterUserID);

			//打开数据库连接
			myConnection.Open();
			//进行数据库操作
			myCommand.ExecuteNonQuery();
			//关闭数据库连接
			myConnection.Close();