Model/Book/BookDAOImpl.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using System.Data;
using System.Data.SqlClient;
using BookMIS.Model.Common;

namespace BookMIS.Model.Book
{
    class BookDAOImpl:BookDAO
    {
        ConnectDB con = new ConnectDB();
        SqlDataAdapter sda = new SqlDataAdapter();
        SqlCommand cmd = null;
        DataTable dt = null;
        string str="";

        #region 查询数据
        public DataTable SelectBook()
        {
            try
            {
                dt = new DataTable();
                string sql = "select BookID,BookName,TypeName,Author,HireByDay,Deposit,BookType.TypeID from BookInfo,BookType ";
                sql = sql + "where BookInfo.TypeID=BookType.TypeID";
                cmd = new SqlCommand(sql, con.Getcon());
                sda.SelectCommand = cmd;
                sda.Fill(dt);
            }
            catch (Exception ex)
            {
                dt = null;
            }
            finally
            {
                con.Close();
            }
            return dt;
        }
        #endregion

        #region 添加数据
        public string AddBook(BookEntity book)
        {
            try
            {
            cmd = new SqlCommand("insert into BookInfo values(@bookid,@bookname,@typeid,@author,@hirebyday,@deposit,0,'0')", con.Getcon());
            SqlParameter sptid = new SqlParameter("@bookid", SqlDbType.VarChar, 10);
            sptid.Value = book.Bookid;
            cmd.Parameters.Add(sptid);

            SqlParameter sptname = new SqlParameter("@bookname", SqlDbType.VarChar, 50);
            sptname.Value = book.Bookname;
            cmd.Parameters.Add(sptname);

            SqlParameter spttypeid = new SqlParameter("@typeid", SqlDbType.VarChar, 10);
            spttypeid.Value = book.Typeid;
            cmd.Parameters.Add(spttypeid);