BookManager/frmBook/frmBookUser.cs

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

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

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using BLL;
using Model;

namespace BookManager.frmBook
{
    public partial class frmBookUser : Form
    {
        private DataTable dtBook = new DataTable();
        private DataSet ds = new DataSet();
        public frmBookUser()
        {
            InitializeComponent();
        }
        //加载所有图书信息
        private void dgvload()
        {
            dgvBook.DataSource = dtBook;
            //设置主键
            DataColumn[] dc = { dtBook.Columns["bookId"] };
            dtBook.PrimaryKey = dc;
            dgvBook.Columns["bookId"].HeaderText = "图书编号";
            dgvBook.Columns["bookName"].HeaderText = "图书名称";
            dgvBook.Columns["bookTypeName"].HeaderText = "图书类别";
            dgvBook.Columns["publisher"].HeaderText = "出版社";
            dgvBook.Columns["Author"].HeaderText = "作者";
            dgvBook.Columns["Status"].HeaderText = "图书状态";
            dgvBook.Columns["bookPrice"].HeaderText = "价格";
            dgvBook.Columns["bookPage"].HeaderText = "页数";
            dgvBook.Columns["checkDate"].HeaderText = "登记日期";
            dgvBook.Columns["bookInfo"].HeaderText = "备注";
            dgvBook.Columns["bookTypeId"].Visible = false;
        }
        private void frmBookUser_Load(object sender, EventArgs e)
        {
            BookBLL bookBLL = new BookBLL();
            dtBook = bookBLL.getBook();
            dgvBook.DataSource = dtBook;
            //设置主键
            DataColumn[] dc = { dtBook.Columns["bookId"] };
            dtBook.PrimaryKey = dc;
            dgvBook.Columns["bookId"].HeaderText = "图书编号";
            dgvBook.Columns["bookName"].HeaderText = "图书名称";
            dgvBook.Columns["bookTypeName"].HeaderText = "图书类别";
            dgvBook.Columns["publisher"].HeaderText = "出版社";
            dgvBook.Columns["Author"].HeaderText = "作者";
            dgvBook.Columns["Status"].HeaderText = "图书状态";
            dgvBook.Columns["bookPrice"].HeaderText = "价格";
            dgvBook.Columns["bookPage"].HeaderText = "页数";
            dgvBook.Columns["checkDate"].HeaderText = "登记日期";
            dgvBook.Columns["bookInfo"].HeaderText = "备注";
            dgvBook.Columns["bookTypeId"].Visible = false;
            dgvload();