frmbookmanager.cs

图书馆管理系统的一个代码 很好的学习借鉴

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;
using System.Collections;
namespace BookManagementSystem
{
    public partial class frmBookManager : Form
    {
        ArrayList pBigClassOfBook;
        public frmBookManager(ArrayList ClassOfBook)
        {
            InitializeComponent();
            this.pBigClassOfBook = ClassOfBook;
        }

        private void bookBindingNavigatorSaveItem_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("确定要保存吗?", "保存确定", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                return;
            this.Validate();
            this.bookBindingSource.EndEdit();
            this.bookTableAdapter.Update(this.mydata2DataSet.Book);

        }

        private void frmBookManager_Load(object sender, EventArgs e)
        {
            // TODO: 这行代码将数据加载到表“mydata2DataSet.Book”中。您可以根据需要移动或移除它。
            this.bookTableAdapter.Fill(this.mydata2DataSet.Book);
            图片PictureBox.SizeMode = PictureBoxSizeMode.StretchImage;

        }

        private void InImage_Click(object sender, EventArgs e)
        {
            if (openFileDialog.ShowDialog() == DialogResult.OK)
            {
                图片PictureBox.Image = Program.DataProcessor.GetImageFromFilePath(openFileDialog.FileName);
            }
        }

        private void GetBookClass_Click(object sender, EventArgs e)
        {
            大类ComboBox.Items.Clear();
            foreach (string sdata in pBigClassOfBook)
            {
                大类ComboBox.Items.Add(sdata);
            }
        }

        private void 大类ComboBox_SelectedIndexChanged(object sender, EventArgs e)
        {
            ArrayList SmallClassOfBook = Program.DataOperator.GetSmallClassOfBook(大类ComboBox.Text);
            小类ComboBox.Items.Clear();
            foreach (string sdata in SmallClassOfBook)
                小类ComboBox.Items.Add(sdata);
        }

        private void SerchBox_Click(object sender, EventArgs e)
        {
            try
            {
                string []SerchData=new string[3];

                for (int i = 0; i < SerchData.Length; i++)
                    SerchData[i] = "%";
                if(SerchBoxNo.Text!="")
                    SerchData[0] = SerchBoxNo.Text;
                if(SerchBoxName.Text!="")
                SerchData[1] = SerchBoxName.Text;
               string CmdString = "SELECT 书籍编号, 书名, 作者, 出版社, 现有数量, 小类, 大类, 内容简介, 入库时间, 图片 FROM dbo.Book "
                                + " where 书籍编号 like  '" + SerchData[0] + "'" + " and 书名 like '%" + SerchData[1] + "%'";
              // MessageBox.Show(CmdString);
                Program.SerchCmd[1].CommandText = CmdString;
                try
                {
                    this.bookTableAdapter.FillBy(this.mydata2DataSet.Book);
                }
                catch (System.Exception ex)
                {
                    System.Windows.Forms.MessageBox.Show(ex.Message);
                }
               // int count = dataGridView.RowCount;
               //// MessageBox.Show(count.ToString());
               // if (SerchBoxNo.Text.Equals("") && SerchBoxName.Text.Equals(""))
               //     return;
               // for (int i = 0; i < count; i++)
               // {
               //     //MessageBox.Show(dataGridView.Rows[i].Cells[0].Value.ToString());
               //     if (SerchBoxNo.Text.Equals("") || dataGridView.Rows[i].Cells[0].Value.ToString() == SerchBoxNo.Text)
               //      if (SerchBoxName.Text.Equals("") || dataGridView.Rows[i].Cells[1].Value.ToString().Contains(SerchBoxName.Text))
               //     {
               //         dataGridView.Rows[i].Selected = true;
               //         dataGridView.CurrentCell = dataGridView.Rows[i].Cells[0];
               //         break;
               //     }
               // }
            }
            catch (Exception ex) 
            { 
               // MessageBox.Show(ex.Message); 
            }
        }
        
        private void clear_Click(object sender, EventArgs e)
        {
            SerchBoxNo.Text = SerchBoxName.Text="";
        }

        private void fillByToolStripButton_Click(object sender, EventArgs e)
        {
            try
            {
                this.bookTableAdapter.FillBy(this.mydata2DataSet.Book);
            }
            catch (System.Exception ex)
            {
                System.Windows.Forms.MessageBox.Show(ex.Message);
            }

        }
    }
}