userdb.cs

图书馆的书目查询

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

namespace Library_BS
{
	/// <summary>
	/// UserDB 的摘要说明。
	/// </summary>
	public class UserDB
	{
		public UserDB()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

		/// <summary>

		///验证用户是否为“未注册图书馆合法用户”

		/// </summary>

		public int UserRegister(string UserBarCode) 

		{

			// Create Instance of Connection and Command Object

			//SqlConnection myConnection = new SqlConnection("server=(local);Trusted_Connection=true;database=Library_Dww");

			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
			SqlCommand myCommand = new SqlCommand("UserRegister", myConnection);

 

			// Mark the Command as a SPROC

			myCommand.CommandType = CommandType.StoredProcedure;

 

			// Add Parameters to SPROC

			SqlParameter parameterUserBarCode = new SqlParameter("@UserBarCode", SqlDbType.NVarChar, 20);

			parameterUserBarCode.Value = UserBarCode;

			myCommand.Parameters.Add(parameterUserBarCode);

 

			SqlParameter parameterErrorCode = new SqlParameter("@ErrorCode", SqlDbType.Int, 4);

			parameterErrorCode.Direction = ParameterDirection.Output;

			myCommand.Parameters.Add(parameterErrorCode);

 

			// Open the connection and execute the Command

			myConnection.Open();

			myCommand.ExecuteNonQuery();

			myConnection.Close();

 

			int ErrorCode = (int)(parameterErrorCode.Value);         

			return ErrorCode;           

		}


		public DataSet GetCurrentBorrow(string readerId)
		{
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
			SqlDataAdapter myAdapter = new SqlDataAdapter("GetCurrentBorrow", myConnection);
			//SqlCommand myCommand = new SqlCommand("GetCurrentBorrow", myConnection);

			// Mark the Command as a SPROC
			//myCommand.CommandType = CommandType.StoredProcedure;
			myAdapter.SelectCommand.CommandType=CommandType.StoredProcedure;

			// Add Parameters to SPROC
			SqlParameter parameterReaderID = new SqlParameter("@readerId", SqlDbType.VarChar, 20);
			parameterReaderID.Value = readerId;
			myAdapter.SelectCommand.Parameters.Add(parameterReaderID);

			// Create and Fill the DataSet
			DataSet myDataSet = new DataSet();
			myAdapter.Fill(myDataSet,"CurrentBorrow");

			// Return the DataSet
			return myDataSet;

		}

		public DataSet GetBorrowLog(string readerId)
		{
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
			SqlDataAdapter myAdapter = new SqlDataAdapter("GetBorrowLog", myConnection);
			//SqlCommand myCommand = new SqlCommand("GetCurrentBorrow", myConnection);

			// Mark the Command as a SPROC
			//myCommand.CommandType = CommandType.StoredProcedure;
			myAdapter.SelectCommand.CommandType=CommandType.StoredProcedure;

			// Add Parameters to SPROC
			SqlParameter parameterReaderID = new SqlParameter("@readerId", SqlDbType.VarChar, 20);
			parameterReaderID.Value = readerId;
			myAdapter.SelectCommand.Parameters.Add(parameterReaderID);

			// Create and Fill the DataSet
			DataSet myDataSet = new DataSet();
			myAdapter.Fill(myDataSet,"BorrowLog");

			// Return the DataSet
			return myDataSet;

		}
		public DataSet GetAboutFine(string readerId)
		{
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
			SqlDataAdapter myAdapter = new SqlDataAdapter("GetAboutFine", myConnection);
			//SqlCommand myCommand = new SqlCommand("GetCurrentBorrow", myConnection);

			// Mark the Command as a SPROC
			//myCommand.CommandType = CommandType.StoredProcedure;
			myAdapter.SelectCommand.CommandType=CommandType.StoredProcedure;

			// Add Parameters to SPROC
			SqlParameter parameterReaderID = new SqlParameter("@readerId", SqlDbType.VarChar, 20);
			parameterReaderID.Value = readerId;
			myAdapter.SelectCommand.Parameters.Add(parameterReaderID);

			// Create and Fill the DataSet
			DataSet myDataSet = new DataSet();
			myAdapter.Fill(myDataSet,"AboutFine");

			// Return the DataSet
			return myDataSet;

		}
		public DataSet GetLovelyBook(string readerId)
		{
			SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
			SqlDataAdapter myAdapter = new SqlDataAdapter("GetLovelyBook", myConnection);
			//SqlCommand myCommand = new SqlCommand("GetCurrentBorrow", myConnection);

			// Mark the Command as a SPROC
			//myCommand.CommandType = CommandType.StoredProcedure;
			myAdapter.SelectCommand.CommandType=CommandType.StoredProcedure;

			// Add Parameters to SPROC
			SqlParameter parameterReaderID = new SqlParameter("@readerId", SqlDbType.VarChar, 20);
			parameterReaderID.Value = readerId;
			myAdapter.SelectCommand.Parameters.Add(parameterReaderID);

			// Create and Fill the DataSet
			DataSet myDataSet = new DataSet();
			myAdapter.Fill(myDataSet,"LovelyBook");

			// Return the DataSet
			return myDataSet;

		}
		public System.Data.DataSet QueryReaderInfoByID(string iD) 
		{
		    string connStr = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
			System.Data.IDbConnection dbConnection = new System.Data.SqlClient.SqlConnection(connStr);
        
			string queryString = "SELECT * FROM [读者信息] JOIN [读者类型] ON ([读者信息].[类型号] = [读者类型].[类型号]) JOIN [工作单位] ON ([读者信息].[单位编号] = [工作单位].[单位编号])WHERE ([读者信息].[编号] = @ID)";
			System.Data.IDbCommand dbCommand = new System.Data.SqlClient.SqlCommand();
			dbCommand.CommandText = queryString;
			dbCommand.Connection = dbConnection;
        
			System.Data.IDataParameter dbParam_iD = new System.Data.SqlClient.SqlParameter();
			dbParam_iD.ParameterName = "@ID";
			dbParam_iD.Value = iD;
			dbParam_iD.DbType = System.Data.DbType.String;
			dbCommand.Parameters.Add(dbParam_iD);
        
			System.Data.IDbDataAdapter dataAdapter = new System.Data.SqlClient.SqlDataAdapter();
			dataAdapter.SelectCommand = dbCommand;
			System.Data.DataSet dataSet = new System.Data.DataSet();
			dataAdapter.Fill(dataSet);
        
			return dataSet;
		}

    
		public int UpdateRegister(string 编号, string 密码, string 密码问题, string 密码答案, string 注册名, string 性别, System.DateTime 出生日期, string 证件号码, string 电话, string 通讯地址, string 邮编, string e_mail) 
		{
			string connectionString = "server=\'(local)\'; trusted_connection=true; database=\'Library_BS\'";
			System.Data.IDbConnection dbConnection = new System.Data.SqlClient.SqlConnection(connectionString);