Model/BookRecord/BookRecordDAOImpl.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.BookRecord
{
    class BookRecordDAOImpl:BookRecordDAO
    {
        SqlDataAdapter sda = new SqlDataAdapter();
        ConnectDB con = new ConnectDB();
        SqlCommand cmd = null;
        DataTable dt = null;

        string str = "";
        public string RecordAdd(BookRecordEntity record)
        {
            try
            {
                cmd = new SqlCommand("insert into BorrowRecord(BookID,LendDate,ReturnDate,Pawn,IDCard,UserID) values(@bookid,@lenddate,@returndate,@pawn,@idcard,@userid)", con.Getcon());
                SqlParameter sptid = new SqlParameter("@bookid", SqlDbType.VarChar, 10);
                sptid.Value = record.Bookid;
                cmd.Parameters.Add(sptid);

                SqlParameter sptlend = new SqlParameter("@lenddate", SqlDbType.DateTime);
                sptlend.Value = record.Lenddate;
                cmd.Parameters.Add(sptlend);

                SqlParameter sptreturn = new SqlParameter("@returndate", SqlDbType.DateTime);
                sptreturn.Value = record.Returndate;
                cmd.Parameters.Add(sptreturn);

                SqlParameter sptpawn = new SqlParameter("@pawn", SqlDbType.VarChar, 1);
                sptpawn.Value = record.Pawn;
                cmd.Parameters.Add(sptpawn);

                SqlParameter sptcard = new SqlParameter("@idcard", SqlDbType.VarChar, 18);
                sptcard.Value = record.Idcard;
                cmd.Parameters.Add(sptcard);

                SqlParameter sptuserid = new SqlParameter("@userid", SqlDbType.VarChar, 10);
                sptuserid.Value = record.Userid;
                cmd.Parameters.Add(sptuserid);

                cmd.ExecuteNonQuery();
                str = "ok";
            }
            catch (Exception ex)
            {
                str = "error";
            }
            finally
            {
                con.Close();
            }
            return str;
        }