12.25

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)
    {

    }
}

}