readermanagementcenter.cs

这是个C#做成的图书管理系统,请大家参考,多提建议

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.IO;
namespace BookMS
{
    public partial class ReaderManagementCenter : Form
    {
        public ReaderManagementCenter()
        {
            InitializeComponent();
        }
        DataSet ds = new DataSet("ReaderDs");
        DataSet ds2 = new DataSet("BorrowDs");
        private void ReaderManagementCenter_Load(object sender, EventArgs e)
        {
            if (File.Exists("..\\..\\ReaderDs.ds"))
            {
                ds.ReadXml("..\\..\\ReaderDs.ds");

                ds.Tables["ReaderTab"].PrimaryKey = new DataColumn[] { ds.Tables["ReaderTab"].Columns["读者编号"] };

                dataGridView1.DataSource = ds.Tables["ReaderTab"];
            }

            if (File.Exists("..\\..\\BorrowDs.ds"))
            {
                ds2.ReadXml("..\\..\\BorrowDs.ds");

                dataGridView2.DataSource = ds2.Tables["BorrowTab"];
            }
        }
        

        private void button1_Click(object sender, EventArgs e)
        {
            DataTable dt1 = new DataTable();
            dt1 = ds.Tables["ReaderTab"].Clone();
            foreach (DataRow dr1 in ds.Tables["ReaderTab"].Select("读者姓名='" + textBox1.Text + "'"))
            {
                dt1.Rows.Add(dr1.ItemArray);
            }
            DataTable dt2 = new DataTable();
            dt2 = ds2.Tables["BorrowTab"].Clone();
            foreach (DataRow dr2 in ds2.Tables["BorrowTab"].Select("读者姓名='" + textBox1.Text + "'"))
            {
                dt2.Rows.Add(dr2.ItemArray);
            }
            dataGridView2.DataSource = dt2;
            dataGridView1.DataSource = dt1;
        }

        private void button2_Click(object sender, EventArgs e)
        {
            AddReader ar = new AddReader();
            ar.Show();
        }

        private void button5_Click(object sender, EventArgs e)
        {
            if (File.Exists("..\\..\\ReaderDs.ds"))
            {
                ds.Clear();
                ds.ReadXml("..\\..\\ReaderDs.ds");

                ds.Tables["ReaderTab"].PrimaryKey = new DataColumn[] { ds.Tables["ReaderTab"].Columns["读者编号"] };

                dataGridView1.DataSource = ds.Tables["ReaderTab"];
            }
            if (File.Exists("..\\..\\BorrowDs.ds"))
            {
                ds2.Clear();
                ds2.ReadXml("..\\..\\BorrowDs.ds");

                dataGridView2.DataSource = ds2.Tables["BorrowTab"];
            }
        }

        private void Return_Book_Click(object sender, EventArgs e)
        {
            BookBorrowCenter bbc = new BookBorrowCenter();
            bbc.Show();
        }


    }
}