App_Code/DAL/dalBook.cs

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

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

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

namespace DAL
{
    public class  dalBook
    {
        public static string sql = "";

        public static bool AddBook(ENTITY.Book book)
        {
            string sql = "insert into Book(barcode,bookName,bookTypeId,price,number,photo,inTime,remarks) values(@barcode,@bookName,@bookTypeId,@price,@number,@photo,@inTime,@remarks)";
            SqlParameter[] parm = new SqlParameter[] { 
             new SqlParameter("@barcode",SqlDbType.VarChar),
             new SqlParameter("@bookName",SqlDbType.VarChar),
             new SqlParameter("@bookTypeId",SqlDbType.Int),
             new SqlParameter("@price",SqlDbType.Float),
             new SqlParameter("@number",SqlDbType.Int),
             new SqlParameter("@photo",SqlDbType.VarChar),
             new SqlParameter("@inTime",SqlDbType.DateTime),
             new SqlParameter("@remarks",SqlDbType.VarChar)
            };

            parm[0].Value = book.barcode;
            parm[1].Value = book.bookName;
            parm[2].Value = book.bookTypeId;
            parm[3].Value = book.price;
            parm[4].Value = book.number;
            parm[5].Value = book.photo;
            parm[6].Value = book.inTime;
            parm[7].Value = book.remark;

            return (DBHelp.ExecuteNonQuery(sql, parm) > 0) ? true : false;
        }

        public static ENTITY.Book getSomeBook(string barcode)
        {
            string sql = "select * from Book where barcode='" + barcode + "'"; 
            SqlDataReader DataRead = DBHelp.ExecuteReader(sql, null);
            ENTITY.Book book = new ENTITY.Book();
            while (DataRead.Read())
            {
                book.barcode = DataRead["barcode"].ToString();
                book.bookName = DataRead["bookName"].ToString();
                book.bookTypeId = Convert.ToInt32(DataRead["bookTypeId"]);
                book.price = float.Parse(DataRead["price"].ToString());
                book.number = Convert.ToInt32(DataRead["number"]);
                book.photo = DataRead["photo"].ToString();
                book.inTime = Convert.ToDateTime(DataRead["inTime"].ToString());
                book.remark = DataRead["remarks"] + "";
            }
            return book;

        }