ViewController/BookStatistics/BookQueryForm.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 BookQueryForm : Form
    {
        BookDAO bookDAO = new BookDAOImpl();
        DataTable dt=null;
        public BookQueryForm()
        {
            InitializeComponent();
        }

        private void btnSelect_Click(object sender, EventArgs e)
        {
            if (rdBtnbook.Checked)
            {
                dt = bookDAO.SelectBookQuery(dTPtime1.Value,dTPtime2.Value, 0);
            }
            else if (rdBtntype.Checked)
            {
                dt = bookDAO.SelectBookQuery(dTPtime1.Value, dTPtime2.Value, 1);
            }
            if (dt != null)
            {
                QueryLV.Items.Clear();
                foreach (DataRow dr in dt.Rows)
                {
                    ListViewItem item = new ListViewItem(dr["BookName"].ToString());
                    item.SubItems.Add(dr["TypeName"].ToString());
                    item.SubItems.Add(dr["Hire"].ToString());
                    QueryLV.Items.Add(item);
                }

                float hire = 0.0F;
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    hire = hire + Convert.ToSingle(dt.Rows[i][2].ToString());
                }

                lbsum.Text = "总租金：" + hire.ToString() + "元";
            }
           
        }

        private void QueryLV_SelectedIndexChanged(object sender, EventArgs e)
        {

        }
    }
}