generaluse.cs

连锁影院售票系统

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace LTTS
{
	public class SelectUseInf
	{
		public String UserName;
	}
	public class UserInfCheck
	{
		public int UserRights;
		public String UserName;
		public String TheaterID;
		public int Online;
	}

	/// <summary>
	/// GeneralUse 的摘要说明。
	/// </summary>
	public class GeneralUse
	{
		public GeneralUse()	{}
		public UserInfCheck ProgramLoginCheck(string UserID,string Password)//验证用户是否存在，若存在返回其UserName,UserRights,TheaterID信息；若不存在则返回权限值为0
			
		{
			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("LoginCheck", 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, 20);
			parameterPassword.Value =chpsw;
			myCommand.Parameters.Add(parameterPassword);

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

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

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

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

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

			//产生UserInfCheck类的对象
			UserInfCheck myUserInfCheck=new UserInfCheck();
			//根据存储过程的输出参数的值对mySelectBackTickets对象进行赋值
			myUserInfCheck.Online=(int)parameterOnline.Value;
			myUserInfCheck.TheaterID=(string)parameterTheaterID.Value;
			myUserInfCheck.UserName=(string)parameterUserName.Value;
			myUserInfCheck.UserRights=(int)parameterUserRights.Value;

			return myUserInfCheck;
		}
		public void ProgramLoginInfRecord(string UserID)//,string LoginTime)//记录前台票务人员登陆及相关营业信息信息

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

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

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

			SqlParameter parameterLoginTime = new SqlParameter("@LoginTime", SqlDbType.DateTime);
			parameterLoginTime.Value =DateTime.Now.ToString();
			myCommand.Parameters.Add(parameterLoginTime);

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

		}
		public SqlDataReader ProgramMostSoldFilms()//最佳票房（前10）

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

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

			//打开数据库连接
			myConnection.Open();
			//执行数据操作命令
			//SqlDataReader读取数据到记录集后，会自动关闭数据库的连接
			SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
			
			//返回DataReader的结果
			return result;
		}
		public void ProgramUpdateUserLogin(string Password,string NewPassword,string UserID,string UserName)//用于修改密码或姓名
		{
			string psw,chpsw;
			psw=Password.ToString();
			LTTS.dieMaske mypswnew=new dieMaske();
			StringChange mychange=mypswnew.KappaSecret(psw.ToString());
			chpsw=mychange.strpsw.ToString();

			string newpsw,newchpsw;
			newpsw=NewPassword.ToString();
			LTTS.dieMaske mynewpswnew=new dieMaske();
			StringChange mynewchange=mynewpswnew.KappaSecret(psw.ToString());
			newchpsw=mychange.strpsw.ToString();

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

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

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

			SqlParameter parameterNewPassword = new SqlParameter("@NewPassword", SqlDbType.VarChar, 20);
			parameterNewPassword.Value =newchpsw;
			myCommand.Parameters.Add(parameterNewPassword);

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

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

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

		}
		public SelectUseInf ProgramSelectUserInf(string UserID)//查询用户姓名
		{
			//创建数据库连接和命令的对象
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
			SqlCommand myCommand = new SqlCommand("SelectUserInf", myConnection);

			//指明Sql命令的操作类型是使用存储过程
			myCommand.CommandType = CommandType.StoredProcedure;
			//给存储过程添加参数
			SqlParameter parameterUserID = new SqlParameter("@UserID", SqlDbType.VarChar, 6);
			parameterUserID.Value = UserID;
			myCommand.Parameters.Add(parameterUserID);

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

			//产生SelectUseInf类的对象
			SelectUseInf mySelectUseInf=new SelectUseInf();
			//根据存储过程的输出参数的值对mySelectUseInf对象进行赋值
			mySelectUseInf.UserName=(string)parameterUserName.Value;

			return mySelectUseInf;
		}
	}
}