ViewController/BookStatistics/BookSortForm.cs

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

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 BookMIS.Model.Book;
namespace BookMIS.ViewController.BookStatistics
{
    public partial class BookSortForm : Form
    {
        BookDAO bookDAO = new BookDAOImpl();
        public BookSortForm()
        {
            InitializeComponent();
        }

        private void btnQuery_Click(object sender, EventArgs e)
        {
            if (cBTimes.Checked)
            {
                DataTable dt = bookDAO.SelectBookForSort(dTPDate1.Value, dTPDate2.Value);
                if (dt != null)
                {
                    //dtGV.DataSource = dt;
                    int i = 1;
                    BookSortLV.Items.Clear();
                    foreach (DataRow dr in dt.Rows)
                    {
                        ListViewItem item = new ListViewItem("TOP" + (i++).ToString());
                        item.SubItems.Add(dr[0].ToString());
                        item.SubItems.Add(dr[1].ToString());
                        item.SubItems.Add(dr[2].ToString());
                        item.SubItems.Add(dr[3].ToString());
                        item.SubItems.Add(dr[4].ToString());
                        BookSortLV.Items.Add(item);
                    }
                }
            }
        }

        private void BookSortLV_SelectedIndexChanged(object sender, EventArgs e)
        {

        }
    }
}