dabeginning.cs

数据库课程设计

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using Common;
using System.Data.SqlClient;

namespace DataAccess
{
    public class DABeginning
    {
        CommonOperator ComOP = new CommonOperator();
        SqlCommand objCMD = new SqlCommand();
        SqlConnection con = new SqlConnection("server=.;uid=sa;password=;database=libbook;");


        /// 此方法调用Borrow_Book存储过程
        /// </summary>
        /// <param name="ReaderID">读者编号</param>
        /// <param name="BookID">图书编号</param>
        public void BeginningBool(string MagazineYN, string BooksYN, string ReaderYN)
        {
            try
            {

                con.Open();
                BorrowParameter(MagazineYN, BooksYN, ReaderYN);
                objCMD.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                con.Close();
            }
        }
        /// <summary>
        /// 此方法对Borrow_Book存储过程的设置
        /// </summary>
        /// <param name="ReaderID">读者编号</param>
        /// <param name="BookID">图书编号</param>
        private void BorrowParameter(string MagazineYN, string BooksYN, string ReaderYN)
        {

            SqlParameter Magazine =null;
            SqlParameter Books = null;
            SqlParameter Reader = null;

            try
            {

                objCMD.Parameters.Clear();
                objCMD.CommandText = "DELETEALL";
                objCMD.CommandType = CommandType.StoredProcedure;

                Magazine = new SqlParameter();

                Magazine.SqlDbType = SqlDbType.VarChar;
                Magazine.ParameterName = "@Magazine";
                Magazine.Value = MagazineYN;
                objCMD.Parameters.Add(Magazine);

                Books = new SqlParameter();
                Books.SqlDbType = SqlDbType.VarChar;
                Books.ParameterName = "@Books";
                Books.Value = BooksYN;
                objCMD.Parameters.Add(Books);

                Reader = new SqlParameter();
                Reader.SqlDbType = SqlDbType.VarChar;
                Reader.ParameterName = "@Reader";
                Reader.Value = ReaderYN;
                objCMD.Parameters.Add(Reader);



                objCMD.Connection = con;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                ComOP.CloseDb();
            }
        }
    }
}