bookmanagementcenter.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 BookManagementCenter : Form
    {
        public BookManagementCenter()
        {
            InitializeComponent();
        }
        DataSet ds = new DataSet("BookDs");
        private void BookManagementCenter_Load(object sender, EventArgs e)
        {
            if (File.Exists("..\\..\\BookDs.ds"))
            {
                ds.ReadXml("..\\..\\BookDs.ds");

                ds.Tables["BookTab"].PrimaryKey = new DataColumn[] { ds.Tables["BookTab"].Columns["BookID"] };

                dataGridView1.DataSource = ds.Tables["BookTab"];
            }
            else
            {
                MessageBox.Show("请与管理员确认服务是否启动", "提示", MessageBoxButtons.RetryCancel);
                DataTable Bdt = new DataTable("BookTab");

                DataColumn Bdc1 = new DataColumn("BookID");
                DataColumn Bdc2 = new DataColumn("BookName");
                DataColumn Bdc3 = new DataColumn("Publishing");
                DataColumn Bdc4 = new DataColumn("BookNum");
                DataColumn Bdc5 = new DataColumn("Author");
                DataColumn Bdc6 = new DataColumn("Publishingtime");

                Bdt.Columns.AddRange(new DataColumn[] { Bdc1, Bdc2, Bdc3, Bdc4, Bdc5 ,Bdc6});
                ds.Tables.Add(Bdt);

                DataRow dr = Bdt.NewRow();
                dr["BookID"] = "BK100001";
                dr["BookName"] = "abc";
                dr["Publishing"] = "";
                dr["BookNum"] = "0";
                dr["Author"] = "";
                dr["Publishingtime"] = Convert.ToDateTime("2008年11月10日").ToLongDateString();

                Bdt.Rows.Add(dr);

                ds.WriteXml("..\\..\\BookDs.ds");
            }
        }
       
        private void button1_Click_1(object sender, EventArgs e)
        {
            DataTable dt1 = new DataTable();
            dt1 = ds.Tables["BookTab"].Clone();
            foreach (DataRow dr1 in ds.Tables["BookTab"].Select("BookName='" + textBox1.Text + "'"))
            {
                dt1.Rows.Add(dr1.ItemArray);
            }

            dataGridView1.DataSource = dt1;
        }

        private void button2_Click_1(object sender, EventArgs e)
        {
            AddBooks ab = new AddBooks();
            ab.Show();
        }

        private void button3_Click_1(object sender, EventArgs e)
        {
            UpdateBooks ub = new UpdateBooks();
            ub.Show();
        }

        private void button4_Click(object sender, EventArgs e)
        {
            if (textBox1.Text != "")
            {
                try
                {
                    ds.Tables["BookTab"].PrimaryKey = new DataColumn[] { ds.Tables["BookTab"].Columns["BookID"] };
                    DataRow dr = ds.Tables["BookTab"].Rows.Find(this.textBox1.Text);
                    MessageBox.Show("是否要删除" + dr["BookName"] + "这本书", "提示", MessageBoxButtons.OKCancel);
                    dr.Delete();
                    ds.WriteXml("..\\..\\BookDs.ds");
                    MessageBox.Show("删除成功！", "提示");
                }
                catch(Exception){}
            }
            
        }

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

                ds.Tables["BookTab"].PrimaryKey = new DataColumn[] { ds.Tables["BookTab"].Columns["BookID"] };

                dataGridView1.DataSource = ds.Tables["BookTab"];
            }
            else
            {
                MessageBox.Show("请与管理员确认服务是否启动", "提示", MessageBoxButtons.RetryCancel);
            }
        }

    }
}