BookManager/frmFine/frmFineInfo.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;
using System.IO;

namespace BookManager.frmFine
{
    using Excel = Microsoft.Office.Interop.Excel;
    public partial class frmFineInfo : Form
    {
        private DataTable dtFine;
        public frmFineInfo()
        {
            InitializeComponent();
        }
        public void dgvload() {
            dgvFine.DataSource = dtFine;
            DataColumn[] dc = { dtFine.Columns["fineId"] };
            dtFine.PrimaryKey = dc;
            dgvFine.Columns["fineId"].HeaderText = "罚单ID";
            dgvFine.Columns["bookId"].HeaderText = "图书ID";
            dgvFine.Columns["borrowerId"].HeaderText = "借阅者ID";           
            dgvFine.Columns["status"].HeaderText = "状态";
            dgvFine.Columns["overDays"].HeaderText = "超过天数";
            dgvFine.Columns["fineMoney"].HeaderText = "应罚金额";
            dgvFine.Columns["checkDate"].HeaderText = "惩罚日期";
            dgvFine.Columns["info"].HeaderText = "备注";
        }

        private void frnFineInfo_Load(object sender, EventArgs e)
        {
            FineBLL fineBLL = new FineBLL();
            dtFine = fineBLL.getFine();
            dgvFine.DataSource = dtFine;
            DataColumn[] dc = { dtFine.Columns["fineId"] };
            dtFine.PrimaryKey = dc;
            dgvFine.Columns["fineId"].HeaderText = "罚单ID";
            dgvFine.Columns["bookId"].HeaderText = "图书ID";
            dgvFine.Columns["borrowerId"].HeaderText = "借阅者ID";
            dgvFine.Columns["status"].HeaderText = "状态";
            dgvFine.Columns["overDays"].HeaderText = "超过天数";
            dgvFine.Columns["fineMoney"].HeaderText = "应罚金额";
            dgvFine.Columns["checkDate"].HeaderText = "惩罚日期";
            dgvFine.Columns["info"].HeaderText = "备注";
            dgvload();
        }

        private void txtBorrowerId_TextChanged(object sender, EventArgs e)
        {
            FineBLL fine = new FineBLL();
            dgvFine.DataSource = fine.getFineBy(txtBorrowerId.Text);
        }