BookManager/frmBorrBook/frmBorrBookInfo.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 Model;
using BLL;

namespace BookManager.frmBorrBook
{
    public partial class frmBorrBookInfo : Form
    {
        private DataTable dtBorr;
        public frmBorrBookInfo()
        {
            InitializeComponent();
        }
        private void dgvload()
        {
            dgvBorrBook.DataSource = dtBorr;
            //设置主键
            DataColumn[] dc = { dtBorr.Columns["borrId"] };
            dtBorr.PrimaryKey = dc;
            dgvBorrBook.Columns["borrId"].HeaderText = "借阅ID";
            dgvBorrBook.Columns["borrowerId"].HeaderText = "借阅者ID";
            dgvBorrBook.Columns["bookId"].HeaderText = "图书ID";
            dgvBorrBook.Columns["status"].HeaderText = "交易状态";
            dgvBorrBook.Columns["borTime"].HeaderText = "借书时间";
            dgvBorrBook.Columns["shouldReturnTime"].HeaderText = "应还时间";
            dgvBorrBook.Columns["returnTime"].HeaderText = "还书时间";            
            dgvBorrBook.Columns["borrInfo"].HeaderText = "备注";
        }
        private void frmBorrBookInfo_Load(object sender, EventArgs e)
        {
            BorrowBookBLL borrBookBLL = new BorrowBookBLL();
            dtBorr = borrBookBLL.getBorr();
            dgvBorrBook.DataSource = dtBorr;
            //设置主键
            DataColumn[] dc = { dtBorr.Columns["borrId"] };
            dtBorr.PrimaryKey = dc;
            dgvBorrBook.Columns["borrId"].HeaderText = "借阅ID";
            dgvBorrBook.Columns["borrowerId"].HeaderText = "借阅者ID";
            dgvBorrBook.Columns["bookId"].HeaderText = "图书ID";
            dgvBorrBook.Columns["status"].HeaderText = "交易状态";
            dgvBorrBook.Columns["borTime"].HeaderText = "借书时间";
            dgvBorrBook.Columns["shouldReturnTime"].HeaderText = "应还时间";
            dgvBorrBook.Columns["returnTime"].HeaderText = "还书时间";
            dgvBorrBook.Columns["borrInfo"].HeaderText = "备注";
            dgvload();
        }
        //条件查询
        private void btnQuery_Click(object sender, EventArgs e)
        {
            BorrowBookBLL borrBLL = new BorrowBookBLL();
            dgvBorrBook.DataSource = borrBLL.getBorrBy(cobSelect.Text, txtBorrId.Text, txtBookId.Text);
        }       
    }