学习内容：C#从server数据库读取一行数据返回到自定义类

 #region 获取书本实体
    /// <summary>
    /// 获取书本实体
    /// </summary>
    /// <param name="booksID">书本信息ID</param>
    /// <returns>返回书本信息</returns>
    public MDL_Book GetModel(int booksID)
    {
        using (SqlConnection conn = new SqlConnection(connStr))
        {                
            conn.Open();
            string sql = string.Format("select * from BooksB where booksID=@booksID");
            SqlCommand cmd = new SqlCommand(sql, conn);
            cmd.Parameters.Add(new SqlParameter("@booksID", booksID));                
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            DataSet set = new DataSet();
            adapter.Fill(set);
            DataTable dt = set.Tables[0];
            if (dt.Rows.Count==0)
            {
                return null;
            }
            MDL_Book model=new MDL_Book();
            model.BooksID = (int)dt.Rows[0]["booksID"];

            return model;                
        }
    }
    #endregion

–
自定义类
internal class MDL_Book
{

    private int booksID = 0;
    /// <summary>
    /// 图书信息ID
    /// </summary>
    public int BooksID
    {
        get { return booksID; }
        set { booksID = value; }
    }

    private string bookName = "";
    /// <summary>
    /// 书名
    /// </summary>
    public string BookName
    {
        get { return bookName; }
        set { bookName = value; }
    }
 
    private int bookNumber=0;
    /// <summary>
    /// 书号
    /// </summary>
    public int BookNumber
    {
        get { return bookNumber; }
        set { bookNumber = value; }
    }

    private string cover="";
    /// <summary>
    /// 封面
    /// </summary>
    public string Cover
    {
        get { return cover; }
        set { cover = value; }
    }

    private int classTypeID=0;
    /// <summary>
    /// 分类信息ID
    /// </summary>
    public int ClassTypeID
    {
        get { return classTypeID; }
        set { classTypeID = value; }
    }
    

    
    private double price=0;
    /// <summary>
    /// 单价
    /// </summary>
    public double Price
    {
        get { return price; }
        set { price = value; }
    }
    

   
    private int quantity=0;
    /// <summary>
    /// 数量
    /// </summary>
    public int Quantity
    {
        get { return quantity; }
        set { quantity = value; }
    }
  
    private DateTime come= DateTime.Parse("1900-01-01");
    /// <summary>
    /// 出版日期
    /// </summary>
    public DateTime Come 
    {
        get { return come; }
        set { come = value; }
    }

    private int sudscribState=0;
    /// <summary>
    /// 是否允许借阅
    /// </summary>
    public int SudscribState
    {
        get { return sudscribState; }
        set{ sudscribState = value; }
    }

    private string bookIntroduction="";
    /// <summary>
    /// 图书简介
    /// </summary>
    public string BookIntroduction
    {
        get { return bookIntroduction; }
        set { bookIntroduction = value; }
    }

    private DateTime lastUpdateTime;
    /// <summary>
    /// 最新修改时间
    /// </summary>
    public DateTime LastUpdateTime
    {
        get { return lastUpdateTime; }
        set { lastUpdateTime = value; }
    }

    private DateTime createTime;
    
    /// <summary>
    /// 创建时间
    /// </summary>
    public DateTime CreateTime
    {
        get { return createTime; }
        set { createTime = value; }
    }
    
}