C# 书店管理源码(含数据库)

【实例截图】

【核心代码】

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

namespace BooksManger
{
    public partial class frmManger : Form
    {
        //定义成员变量
        public int Num;  //书的编号
        public string State;  //书本状态
        //程序入口
        public frmManger()
        {
            InitializeComponent();
        }
        //实例化DB_Help对象
        DB_Help help = new DB_Help();
        //查询按钮事件
        private void btnSelect_Click(object sender, EventArgs e)
        {
            //获取查询文本框中的内容
            string selectTXT = this.txtSelect.Text;
            //判断选项分类选项
            if (this.cmbSelect.Text == "按编号查询")
            {
                if (this.radSelect1.Checked)
                {
                    //精确查询
                    string sql1 = "select BookID,BookName,BookAuthor,TypeName,BookSpec,BookConcert,BookPrice,BookState from TblBookInfo inner join TblBookType on TblBookInfo.BookTypeID=TblBookType.ID where BookID='"   selectTXT   "'";
                    this.dgvInfo.DataSource = help.GetSelect(sql1);
                }
                else
                {
                    //模糊查询
                    string sql2 = "select BookID,BookName,BookAuthor,TypeName,BookSpec,BookConcert,BookPrice,BookState from TblBookInfo inner join TblBookType on TblBookInfo.BookTypeID=TblBookType.ID where BookID like '%"   selectTXT   "%'";
                    this.dgvInfo.DataSource = help.GetSelect(sql2);
                }
            }
            else if (this.cmbSelect.Text == "按书名查询")
            {
                if (this.radSelect1.Checked)
                {
                    //精确查询
                    string sql3 = "select BookID,BookName,BookAuthor,TypeName,BookSpec,BookConcert,BookPrice,BookState from TblBookInfo inner join TblBookType on TblBookInfo.BookTypeID=TblBookType.ID where BookName='"   selectTXT   "'";
                    this.dgvInfo.DataSource = help.GetSelect(sql3);
                }
                else
                {
                    //模糊查询
                    string sql4 = "select BookID,BookName,BookAuthor,TypeName,BookSpec,BookConcert,BookPrice,BookState from TblBookInfo inner join TblBookType on TblBookInfo.BookTypeID=TblBookType.ID where BookName like '%"   selectTXT   "%'";
                    this.dgvInfo.DataSource = help.GetSelect(sql4);
                }
            }
            else if (this.cmbSelect.Text == "按作者查询")
            {
                if (this.radSelect1.Checked)
                {
                    //精确查询
                    string sql5 = "select BookID,BookName,BookAuthor,TypeName,BookSpec,BookConcert,BookPrice,BookState from TblBookInfo inner join TblBookType on TblBookInfo.BookTypeID=TblBookType.ID where BookAuthor='"   selectTXT   "'";
                    this.dgvInfo.DataSource = help.GetSelect(sql5);
                }
                else
                {
                    //模糊查询
                    string sql6 = "select BookID,BookName,BookAuthor,TypeName,BookSpec,BookConcert,BookPrice,BookState from TblBookInfo inner join TblBookType on TblBookInfo.BookTypeID=TblBookType.ID where BookAuthor like '%"   selectTXT   "%'";
                    this.dgvInfo.DataSource = help.GetSelect(sql6);
                }
            }
            else if (this.cmbSelect.Text == "按类型查询")
            {
                if (this.radSelect1.Checked)
                {
                    //精确查询
                    string sql7 = "select BookID,BookName,BookAuthor,TypeName,BookSpec,BookConcert,BookPrice,BookState from TblBookInfo inner join TblBookType on TblBookInfo.BookTypeID=TblBookType.ID where TypeName='"   selectTXT   "'";
                    this.dgvInfo.DataSource = help.GetSelect(sql7);
                }
                else
                {
                    //模糊查询
                    string sql8 = "select BookID,BookName,BookAuthor,TypeName,BookSpec,BookConcert,BookPrice,BookState from TblBookInfo inner join TblBookType on TblBookInfo.BookTypeID=TblBookType.ID where TypeName like '%"   selectTXT   "%'";
                    this.dgvInfo.DataSource = help.GetSelect(sql8);
                }
            }
            else
            {
                //查询所有
                string sql9 = "select BookID,BookName,BookAuthor,TypeName,BookSpec,BookConcert,BookPrice,BookState from TblBookInfo inner join TblBookType on TblBookInfo.BookTypeID=TblBookType.ID";
                this.dgvInfo.DataSource = help.GetSelect(sql9);
            }
        }
        //借阅按钮事件
        private void btnBorrow_Click(object sender, EventArgs e)
        {
            if (this.State == "未借出")
            {
                string sql = "update TblBookInfo set BookState='已借出' where BookID='"   Num   "'";
                if (help.GetExecute(sql) > 0)
                {
                    MessageBox.Show("借阅成功！");
                    //刷新
                    this.btnSelect_Click(sender,e);
                }
            }
            else
            {
                MessageBox.Show("本书已经被借阅！","提示",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
            }
        }
        //归还按钮事件
        private void btnReturn_Click(object sender, EventArgs e)
        {
            if (this.State == "已借出")
            {
                string sql = "update TblBookInfo set BookState='未借出' where BookID='"   Num   "'";
                if (help.GetExecute(sql) > 0)
                {
                    MessageBox.Show("归还成功！");
                    //刷新
                    this.btnSelect_Click(sender, e);
                }
            }
            else
            {
                MessageBox.Show("本书未被被借阅！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
        }
        //关闭按钮事件
        private void btnClose_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("你确定退出吗？", "退出", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
            {
                Application.Exit();
            }
        }
        //打印按钮事件
        private void btnMimeograph_Click(object sender, EventArgs e)
        {
            MessageBox.Show("打印中。。。");
        }
        //鼠标点击获取索引
        private void dgvInfo_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            try
            {
                //获取行索引
                int index = e.RowIndex;
                //获得书的编号
                Num = int.Parse(this.dgvInfo.Rows[index].Cells[0].Value.ToString());
                //获得书的状态
                State = this.dgvInfo.Rows[index].Cells[7].Value.ToString();
            }
            catch (Exception)
            {
                MessageBox.Show("请正确选择书籍索引", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
    }
}