telleruse.cs

连锁影院售票系统

			//产生SaleNewTickets类的对象
			SaleNewTickets mySaleNewTickets=new SaleNewTickets();
			//根据存储过程的输出参数的值对mySelectBackTickets对象进行赋值
			mySaleNewTickets.BoxTickets=(int)parameterBoxTickets.Value;
			mySaleNewTickets.SingleTickets=(int)parameterSingleTickets.Value;

			return mySaleNewTickets;

		}

		public void ProgramBackTicket(int OnShowIndex,string OnShowDate,string OnShowNOP,string FilmID,string CinemaID,int SeatNo,int BoxNo)
		//退票记录
		{
			//创建数据库连接和命令的对象
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
			SqlCommand myCommand = new SqlCommand("BackTicket", myConnection);

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

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

			SqlParameter parameterOnShowDate = new SqlParameter("@OnShowDate", SqlDbType.VarChar, 20);
			parameterOnShowDate.Value = OnShowDate;
			myCommand.Parameters.Add(parameterOnShowDate);

			SqlParameter parameterOnShowNOP = new SqlParameter("@OnShowNOP", SqlDbType.VarChar, 6);
			parameterOnShowNOP.Value = OnShowNOP;
			myCommand.Parameters.Add(parameterOnShowNOP);

			SqlParameter parameterFilmID = new SqlParameter("@FilmID", SqlDbType.VarChar, 8);
			parameterFilmID.Value = FilmID;
			myCommand.Parameters.Add(parameterFilmID);

			SqlParameter parameterCinemaID = new SqlParameter("@CinemaID", SqlDbType.VarChar, 4);
			parameterCinemaID.Value = CinemaID;
			myCommand.Parameters.Add(parameterCinemaID);

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

			SqlParameter parameterBoxNo = new SqlParameter("@BoxNo", SqlDbType.Int);
			parameterBoxNo.Value = BoxNo;
			myCommand.Parameters.Add(parameterBoxNo);
													
			//打开数据库连接
			myConnection.Open();
			//进行数据库操作
			myCommand.ExecuteNonQuery();
			//关闭数据库连接
			myConnection.Close();
		}
		public void ProgramLogoutInfRecord(string UserID)
		//票务人员离开记录及相关营业信息
		{
			//创建数据库连接和命令的对象
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
			SqlCommand myCommand = new SqlCommand("LogoutInfRecord", myConnection);

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

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

			//打开数据库连接
			myConnection.Open();
			//进行数据库操作
			myCommand.ExecuteNonQuery();
			//关闭数据库连接
			myConnection.Close();
		}
		public MaxSale ProgramMaxSaleOnce(int OnShowIndex)
		{
			//创建数据库连接和命令的对象
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
			SqlCommand myCommand = new SqlCommand("MaxSaleOnce", myConnection);

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

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

			SqlParameter parameterOnShowBand = new SqlParameter("@OnShowBand", SqlDbType.Int);
			//指出该参数是存储过程的OUTPUT参数
			parameterOnShowBand.Direction = ParameterDirection.Output;
			myCommand.Parameters.Add(parameterOnShowBand);
			
			//打开数据库连接
			myConnection.Open();
			//进行数据库操作
			myCommand.ExecuteNonQuery();
			//关闭数据库连接
			myConnection.Close();

			//产生MaxSale类的对象
			MaxSale myMaxSale=new MaxSale();
			//根据存储过程的输出参数的值对myMaxSale对象进行赋值
			myMaxSale.OnShowBand=(int)parameterOnShowBand.Value;
			
			return myMaxSale;

		}
		public TheaterInfSearch ProgramPintTheaterInf(string TheaterID)
		//打印票信息
		{
			//创建数据库连接和命令的对象
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
			SqlCommand myCommand = new SqlCommand("PintTheaterInf", myConnection);

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

			//给存储过程添加参数
			SqlParameter parameterTheaterID = new SqlParameter("@TheaterID", SqlDbType.VarChar, 4);
			parameterTheaterID.Value = TheaterID;
			myCommand.Parameters.Add(parameterTheaterID);
			
			SqlParameter parameterTheaterName = new SqlParameter("@TheaterName", SqlDbType.VarChar, 20);
			//指出该参数是存储过程的OUTPUT参数
			parameterTheaterName.Direction = ParameterDirection.Output;
			myCommand.Parameters.Add(parameterTheaterName);

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

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

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

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

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

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

			//产生TheaterInfSearch类的对象
			TheaterInfSearch myTheaterInfSearch=new TheaterInfSearch();
			//根据存储过程的输出参数的值对myTheaterInfSearch对象进行赋值
			myTheaterInfSearch.Address=(string)parameterAddress.Value;
			myTheaterInfSearch.Latitude=(string)parameterLatitude.Value;
			myTheaterInfSearch.LocationCity=(string)parameterLocationCity.Value;
			myTheaterInfSearch.Longitude=(string)parameterLongitude.Value;
			myTheaterInfSearch.TelNo=(string)parameterTelNo.Value;
			myTheaterInfSearch.TheaterName=(string)parameterTheaterName.Value;

			return myTheaterInfSearch;

		}
		public UserInf ProgramTransRights(string UserID,string Password,string TheaterID,int UserRights)
		//赋予普通票务人员以销售异地影票的权限
		{
			string psw,chpsw;
			psw=Password.ToString();
			LTTS.dieMaske mypswnew=new dieMaske();
			StringChange mychange=mypswnew.KappaSecret(psw.ToString());
			chpsw=mychange.strpsw.ToString();

			//创建数据库连接和命令的对象
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
			SqlCommand myCommand = new SqlCommand("TransRights", myConnection);

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

			//给存储过程添加参数			
			SqlParameter parameterUserID = new SqlParameter("@UserID", SqlDbType.VarChar, 6);
			parameterUserID.Value = UserID;
			myCommand.Parameters.Add(parameterUserID);
			
			SqlParameter parameterPassword = new SqlParameter("@Password", SqlDbType.VarChar, 10);
			parameterPassword.Value =chpsw;
			myCommand.Parameters.Add(parameterPassword);
			
			SqlParameter parameterUserRights = new SqlParameter("@UserRights", SqlDbType.Int);
			//指出该参数是存储过程的OUTPUT参数
			parameterUserRights.Direction = ParameterDirection.Output;
			myCommand.Parameters.Add(parameterUserRights);
			
			SqlParameter parameterTheaterID = new SqlParameter("@TheaterID", SqlDbType.VarChar, 4);
			parameterTheaterID.Value = TheaterID;
			myCommand.Parameters.Add(parameterTheaterID);

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

			//产生UserInf类的对象
			UserInf myUserInf=new UserInf();
			//根据存储过程的输出参数的值对myUserInf对象进行赋值
			myUserInf.UserRights=(int)parameterUserRights.Value;
			
			return myUserInf;

		}
	}
}