theateradminuse.cs

连锁影院售票系统

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

namespace LTTS
{
	public class CheckUserID
	{
		public int Flag;
	}
//	public class ShowEmptyCinemaforTheater
//	{
//		public String CinemaID;
//	}
	/// <summary>
	/// TheaterAdminUse 的摘要说明。
	/// </summary>
	public class TheaterAdminUse
	{
		public TheaterAdminUse(){}
		public void ProgramAddNewCinema(string CinemaID,string CinemaType,string TheaterID,int SingleSeat,int Boxes)
		//添加新放映室信息
		{
			//创建数据库连接和命令的对象
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
			SqlCommand myCommand = new SqlCommand("AddNewCinema", myConnection);

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

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

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

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

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

			SqlParameter parameterBoxes = new SqlParameter("@Boxes", SqlDbType.Int);
			parameterBoxes.Value = Boxes;
			myCommand.Parameters.Add(parameterBoxes);
																				
			//打开数据库连接
			myConnection.Open();
			//进行数据库操作
			myCommand.ExecuteNonQuery();
			//关闭数据库连接
			myConnection.Close();

		}
		public void ProgramAddNewUser(string UserID,string Password,int UserRights,string TheaterID,string UserName)
		//添加新用户
		{
			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("AddNewUser", 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);
			parameterUserRights.Value = UserRights;
			myCommand.Parameters.Add(parameterUserRights);

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

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

			//打开数据库连接
			myConnection.Open();
			//进行数据库操作
			myCommand.ExecuteNonQuery();
			//关闭数据库连接
			myConnection.Close();
		}
		public CheckUserID ProgramCheckUserID(string UserID,int Flag)
		//检验用户ID是否可用
		{
			//创建数据库连接和命令的对象
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
			SqlCommand myCommand = new SqlCommand("CheckUserID", myConnection);

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

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

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

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

			//产生CheckUserID类的对象
			CheckUserID myCheckUserID=new CheckUserID();
			//根据存储过程的输出参数的值对myCheckUserID对象进行赋值
			myCheckUserID.Flag=(int)parameterFlag.Value;

			return myCheckUserID;

		}
		public SqlDataReader ProgramShowEmptyCinemaforTheater( string OnShowDate,string OnShowNOP,string TheaterID)
		//剧场管理员察看所选时段的空闲/即可修改的放映室
		{
			//创建数据库连接和命令的对象
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
			SqlCommand myCommand = new SqlCommand("ShowEmptyCinemaforTheater", myConnection);

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

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

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

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

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

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

		}

		public void ProgramUpdateOnShowPlan(int OnShowIndex,string OnShowDate,string FilmID,string FilmName,string CinemaID,string OnShowNOP,int SaleAble,int ChangeAble,int OnShowBand)
		//剧场管理员对上映信息进行修改
		{
			//创建数据库连接和命令的对象
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
			SqlCommand myCommand = new SqlCommand("UpdateFilmInf", 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 parameterFilmID = new SqlParameter("@FilmID", SqlDbType.VarChar, 8);
			parameterFilmID.Value = FilmID;
			myCommand.Parameters.Add(parameterFilmID);

			SqlParameter parameterFilmName = new SqlParameter("@FilmName", SqlDbType.VarChar, 50);
			parameterFilmName.Value = FilmName;
			myCommand.Parameters.Add(parameterFilmName);

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

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

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

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

			SqlParameter parameterOnShowBand = new SqlParameter("@OnShowBand", SqlDbType.Int);
			parameterOnShowBand.Value = OnShowBand;
			myCommand.Parameters.Add(parameterOnShowBand);
													
			//打开数据库连接
			myConnection.Open();
			//进行数据库操作
			myCommand.ExecuteNonQuery();
			//关闭数据库连接
			myConnection.Close();

		}


	}
}