12.11每日总结

今天进行了软件案例分析的大作业，下面是部分代码

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace 图书管理系统
{
    public partial class BooksManage : Form
    {
        Form form;
        DataBaseConection dataBaseConection = new DataBaseConection();

        private string bookID;
        

        public string BookID { get { return bookID; } }

        public BooksManage(Form form)
        {
            InitializeComponent();
            this.form = form;
            bookClassComboBox.SelectedIndex = 0;
            showBook();
        }

        private void exitButtom_Click(object sender, EventArgs e)
        {
            form.Show();
            this.Close();
        }

        private void bookAddButtom_Click(object sender, EventArgs e)
        {
            NewBookAdd newBookAdd = new NewBookAdd(this);
            newBookAdd.Show();
            this.Hide();
        }

        private void borrowRwcordButtom_Click(object sender, EventArgs e)
        {
            BorrowList borrowRecord = new BorrowList(this);
            borrowRecord.Show();
            this.Hide();
        }

        private void btnSearchBook_Click(object sender, EventArgs e)
        {
            string bookName = bookNameTextBox.Text;
            if (bookNameTextBox.Text == String.Empty)
                MessageBox.Show("器材名不能为空", "搜索终止");
            else
            {
                if (dataBaseConection.seekBookByName(bookName).Rows.Count == 0)
                    MessageBox.Show("查无此器材", "查询结果");
                else
                    booksDVG.DataSource = dataBaseConection.seekBookByName(bookName);
                    booksDVG.BackgroundColor = Color.White;
            }
        }

        private void btnAlter_Click(object sender, EventArgs e)
        {
            if (bookDigestTextBox.Text == String.Empty || bookNameText.Text == String.Empty || bookKindText.Text == String.Empty
                || pressText.Text == String.Empty || authorText.Text == String.Empty || publishTimeText.Text == String.Empty)
            {
                MessageBox.Show("所有项目数据不应该为空", "修改失败");
                return;
            }
            else
            {
                
                dataBaseConection.bookInfoChange(BookID, bookNameText.Text, bookKindText.Text,
                   pressText.Text, authorText.Text, publishTimeText.Text);
                showBook();
                MessageBox.Show("修改成功", "修改结果");

            }
        }

        private void searchByKindButtom_Click(object sender, EventArgs e)
        {
            string bookClass = bookClassComboBox.SelectedItem.ToString();
            booksDVG.DataSource = dataBaseConection.seekBookByClass(bookClass);
        }

        private void booksDVG_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            updateInfo();
        }

        private void deleteBook_Click(object sender, EventArgs e)
        {
            string bookName= booksDVG.CurrentRow.Cells[0].Value.ToString();
            dataBaseConection.bookDelete(bookName);
            showBook();
            MessageBox.Show("器材删除成功", "消息提示");
        }

        private void btnUpdate_Click(object sender, EventArgs e)
        {
            showBook();
        }

        public void updateInfo()
        {
            string bookName = booksDVG.CurrentRow.Cells[0].Value.ToString();
            string[] bookinfos = dataBaseConection.bookinfos(bookName);
            bookDigestTextBox.Text = bookinfos[0];
            bookNameText.Text = bookinfos[1];
            bookKindText.Text = bookinfos[2];
            pressText.Text = bookinfos[3];
            authorText.Text = bookinfos[4];
            publishTimeText.Text = bookinfos[5];
            bookID = bookinfos[6];
        }

        public void showBook()
        {
            
            booksDVG.DataSource = dataBaseConection.showBook();
            
        }

        private void bookClassComboBox_SelectedIndexChanged(object sender, EventArgs e)
        {

        }

        private void lblKind_Click(object sender, EventArgs e)
        {

        }

        private void booksDVG_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }
    }
}