BookManager/frmBorrBook/frmBorrBookInfoNormal.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 frmBorrBookInfoNormal : Form
    {
        private DataTable dtBorr;
        private string login;
        public frmBorrBookInfoNormal()
        {
            InitializeComponent();
        }
        public frmBorrBookInfoNormal(string login)
        {
            this.login = login;
            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 frmBorrBookInfoNormal_Load(object sender, EventArgs e)
        {
            BorrowBookBLL borrBookBLL = new BorrowBookBLL();
            dtBorr = borrBookBLL.getBorrByBorrId(login);
            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();
        }