12.11每日总结

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

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

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