sysadminuse.cs

连锁影院售票系统

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace LTTS
{	
	public class ShowCinema
		{
//			public string OnShowDate;
//			public string OnShowNOP;
			public String CinemaID;
		}

	/// <summary>
	/// SysAdminUse 的摘要说明。
	/// </summary>
	public class SysAdminUse
	{
			public SysAdminUse(){}
			public void ProgramAddFilm(string FilmID,string FilmName,string FilmType,string Director,string LeadActors,string PlayWright,string BriefStory,string PlaybillAdd)
			//影片库新片入库
			{
				//创建数据库连接和命令的对象
				SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
				SqlCommand myCommand = new SqlCommand("AddFilm", myConnection);

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

				//给存储过程添加参数
				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 parameterFilmType = new SqlParameter("@FilmType", SqlDbType.VarChar, 6);
				parameterFilmType.Value = FilmType;
				myCommand.Parameters.Add(parameterFilmType);

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

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

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

				SqlParameter parameterBriefStory = new SqlParameter("@BriefStory", SqlDbType.VarChar, 1000);
				parameterBriefStory.Value = BriefStory;
				myCommand.Parameters.Add(parameterBriefStory);

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

			}
			public void ProgramUpdateFilmInf(string FilmID,string FilmName,string FilmType,string Director,string LeadActors,string PlayWright,string BriefStory,string PlaybillAdd)
			//修改影片信息
			{
				//创建数据库连接和命令的对象
				SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
				SqlCommand myCommand = new SqlCommand("UpdateFilmInf", myConnection);

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

				//给存储过程添加参数
				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 parameterFilmType = new SqlParameter("@FilmType", SqlDbType.VarChar, 6);
				parameterFilmType.Value = FilmType;
				myCommand.Parameters.Add(parameterFilmType);

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

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

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

				SqlParameter parameterBriefStory = new SqlParameter("@BriefStory", SqlDbType.VarChar, 1000);
				parameterBriefStory.Value = BriefStory;
				myCommand.Parameters.Add(parameterBriefStory);

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


			}
			public void ProgramAddNewMember(string TheaterID,string TheaterName,string AdminID,string LocationCity,string Address,string TelNo,string Longitude,string Latitude,string AdminName)
			//添加新加盟成员
			{
				string psw,chpsw;
				psw="1234567890";
				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("UpdateFilmInf", 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);
				parameterTheaterName.Value = TheaterName;
				myCommand.Parameters.Add(parameterTheaterName);

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

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

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

				SqlParameter parameterTelNo = new SqlParameter("@TelNo", SqlDbType.VarChar, 15);
				parameterTelNo.Value = TelNo;
				myCommand.Parameters.Add(parameterTelNo);

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

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

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

				SqlParameter parameterPassword = new SqlParameter("@Password", SqlDbType.VarChar, 20);
				parameterPassword.Value =chpsw;
				myCommand.Parameters.Add(parameterPassword);

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

			public void ProgramDoOnShowPlan(string OnShowDate,string FilmID,string FilmName,string CinemaID,int 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 parameterOnShowDate = new SqlParameter("@OnShowDate", SqlDbType.DateTime);
				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.Int);
				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();

			}
			public void ProgramPreparforBusiness(string OnShowDate)//营业数据预备
			{
				//创建数据库连接和命令的对象
				SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
				SqlCommand myCommand = new SqlCommand("PreparforBusiness", myConnection);

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

				//给存储过程添加参数
				SqlParameter parameterOnShowDate = new SqlParameter("@OnShowDate", SqlDbType.VarChar, 20);
				parameterOnShowDate.Value =DateTime.Today.Date.ToShortDateString();
				myCommand.Parameters.Add(parameterOnShowDate);
																	
				//打开数据库连接
				myConnection.Open();
				//进行数据库操作
				myCommand.ExecuteNonQuery();
				//关闭数据库连接
				myConnection.Close();



			}
			public void ProgramUpdateMemberInf(string TheaterID,string TheaterName,string AdminID,string LocationCity,string Address,string TelNo,string Longitude,string Latitude,string AdminName)
			//修改加盟商信息
			{
				//创建数据库连接和命令的对象
				SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
				SqlCommand myCommand = new SqlCommand("UpdateFilmInf", 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);
				parameterTheaterName.Value = TheaterName;
				myCommand.Parameters.Add(parameterTheaterName);

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

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

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

				SqlParameter parameterTelNo = new SqlParameter("@TelNo", SqlDbType.VarChar, 15);
				parameterTelNo.Value = TelNo;
				myCommand.Parameters.Add(parameterTelNo);

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

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

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

			public  SqlDataReader ShowEmptyCinema(string OnShowDate,int OnShowNOP)
			//系统管理员察看所选时段的空闲放映室
			{
				//创建数据库连接和命令的对象
				SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
				SqlCommand myCommand = new SqlCommand("ShowEmptyCinemaforSystem", myConnection);

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

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

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

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

				//打开数据库连接
				myConnection.Open();
				//执行数据操作命令
				//SqlDataReader读取数据到记录集后，会自动关闭数据库的连接
				SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
			
				//返回DataReader的结果
				return result;
			}
					//
			// TODO: 在此处添加构造函数逻辑
			//
		}
	}