db_borrow.cs

来自「这是一个很好的图书管理系统 数据库SQL2005」· CS 代码 · 共 52 行

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

namespace DAL
{
    public class DB_Borrow
    {
        private PublicClass.BorrowModel _Borrow;

        public PublicClass.BorrowModel Borrow
        {
            get { return _Borrow; }
            set { _Borrow = value; }
        }

        /// <summary>
        /// 插入借书信息
        /// </summary>
        /// <returns>返回影响行数</returns>
        public int Insert()
        {
            SqlParameter[] sqlp = new SqlParameter[] { 
                new SqlParameter("@CardID", _Borrow.CardID),
                new SqlParameter("@ManID", _Borrow.ManID),
                new SqlParameter("@BorrowDate", _Borrow.BorrowDate) };

            int row = SqlHelper.Insert(sqlp, "T_BORROW_Insert");

            return row;
        }

        /// <summary>
        /// 更新借书信息
        /// </summary>
        /// <returns>返回影响行数</returns>
        public int Update()
        {
            SqlParameter[] sqlp = new SqlParameter[] { 
                new SqlParameter("@CardID", _Borrow.CardID),
            new SqlParameter("@ManID", _Borrow.ManID),
            new SqlParameter("@ReturnDate", _Borrow.ReturnDate)};

            int row = SqlHelper.Update(sqlp, "T_BORROW_Update");

            return row;
        }
    }
}