基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：78630559

本次赞助数额为： 5 元　

支付宝支付

微信支付

   源码介绍

---

使用C# SQL 完成 的一个模拟图书管理的实例，作为初步开发的学习案例，实例使用了SQL 数据库Book，数据库脚本再DB文件夹下，执行即可。实例有登陆、借书、还书等模快，及相关的数据库执行

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 Wingtech.BooksManage
{
    public partial class FrmMain : Form
    {
        public FrmMain()
        {
            InitializeComponent();
            this.Load  = FrmMain_Load;
            timer1.Tick  = Timer1_Tick;
        }

        private void Timer1_Tick(object sender, EventArgs e)
        {
            string time = DateTime.Now.ToLongTimeString().ToString();
            toolStripStatusLabel2.Text = time;
        }

        private void FrmMain_Load(object sender, EventArgs e)
        {
            toolStripStatusLabel1.Text = DateTime.Now.ToLongDateString().ToString();
            timer1.Interval = 1000;
            timer1.Start();
            toolStripStatusLabel3.Text = "用户:"   BaseFunction.UserName   "登陆";
        }

        private bool CheckChildForm(string childFrmName)
        {
            foreach (Form childFrm in this.MdiChildren)
            {
                if (childFrm.Name==childFrmName)
                {
                    if (childFrm.WindowState== FormWindowState.Minimized || childFrm.WindowState == FormWindowState.Normal || childFrm.WindowState == FormWindowState.Maximized)
                    {
                        //childFrm.StartPosition = FormStartPosition.CenterParent;
                        childFrm.WindowState = FormWindowState.Normal;
                        childFrm.Activate();
                        childFrm.Show();
                        return true;
                    } 
                }
            }

            return false;
        }

        private void ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            ToolStripMenuItem menuItem = (ToolStripMenuItem)sender;
            switch (menuItem.Name)
            {
                case "关于ToolStripMenuItem":
                    if (CheckChildForm("frmAbout"))
                    {
                        return;
                    }
                    else
                    {
                        frmAbout about = new  frmAbout();
                        about.ShowDialog();
                    }
                    break;
                case "管理员登陆ToolStripMenuItem":
                    if (CheckChildForm("frmLogin"))
                    {
                        return;
                    }
                    else
                    {
                        frmLogin log = new frmLogin();
                        log.ShowDialog();
                    }
                    break;
                case "管理员管理ToolStripMenuItem":
                    if (CheckChildForm("frmAddAdmin"))
                    {
                        return;
                    }
                    else
                    {
                        frmAddAdmin admin = new frmAddAdmin();
                        admin.ShowDialog();
                    }
                    break;
                case "读者管理ToolStripMenuItem":
                    if (CheckChildForm("frmManageReader"))
                    {
                        return;
                    }
                    else
                    {
                        frmManageReader reader = new frmManageReader();
                        reader.ShowDialog();
                    }
                    break;
                case "图书入库ToolStripMenuItem":
                    if (CheckChildForm("frmAddBooks"))
                    {
                        return;
                    }
                    else
                    {
                        FrmAddBooks addBooks = new FrmAddBooks();
                        addBooks.btnDelete.Enabled = false;
                        addBooks.btnModfy.Enabled = false;
                        addBooks.Text = "添加图书";
                        addBooks.ShowDialog();
                    }
                    break;
                case "图书更新ToolStripMenuItem":
                    if (CheckChildForm("frmAddBooks"))
                    {
                        return;
                    }
                    FrmAddBooks updateBook = new FrmAddBooks();
                    updateBook.btnAdd.Enabled = false;
                    updateBook.btnDelete.Enabled = false;
                    updateBook.Text = "更新图书";
                    updateBook.ShowDialog();
                    //frmUpdateBooks updateBooks = new frmUpdateBooks();
                    //updateBooks.ShowDialog();
                    break;
                case "图书检索ToolStripMenuItem":
                    if (CheckChildForm("frmSearchBooks"))
                    {
                        return;
                    }
                    frmSearchBooks searchBooks = new frmSearchBooks();
                    searchBooks.ShowDialog();
                    break;
                case "删除图书ToolStripMenuItem":
                    if (CheckChildForm("frmAddBooks"))
                    {
                        return;
                    }
                    FrmAddBooks deleteBooks = new FrmAddBooks();
                    deleteBooks.btnAdd.Enabled = false;
                    deleteBooks.btnModfy.Enabled = false;
                    deleteBooks.Text = "删除图书";
                    deleteBooks.ShowDialog();
                    //frmUpdateBooks updateBooks = new frmUpdateBooks();
                    //updateBooks.ShowDialog();
                    break;
                case "借阅图书ToolStripMenuItem":
                    if (CheckChildForm("frmBorrowBooks"))
                    {
                        return;
                    }
                    frmBorrowBooks borrowBooks = new frmBorrowBooks();
                    borrowBooks.tabPage2.Enabled = false;
                    borrowBooks.tabControl1.SelectedIndex = 0;
                    borrowBooks.Text = "借书模块";
                    borrowBooks.ShowDialog();
                    break;
                case "归还图书ToolStripMenuItem":
                    if (CheckChildForm("frmBorrowBooks"))
                    {
                        return;
                    }
                    frmBorrowBooks backBooks = new frmBorrowBooks();
                    backBooks.tabPage1.Enabled = false;
                    backBooks.tabControl1.SelectedIndex = 1;
                    backBooks.Text = "还书模快";
                    backBooks.ShowDialog();
                    break;
            }
        }
        private void 关于ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            ToolStripMenuItem_Click(sender,e);
        }

        private void 管理员登陆ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            ToolStripMenuItem_Click(sender,e);
        }

        private void 退出ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            this.Close();
            Application.Exit();
        }

        private void 图书入库ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            ToolStripMenuItem_Click(sender,e);
        }

        private void 图书更新ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            ToolStripMenuItem_Click(sender,e);
        }

        private void 图书检索ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            ToolStripMenuItem_Click(sender, e);
        }

        private void 图借阅书ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            ToolStripMenuItem_Click(sender, e);
        }

        private void 删除图书toolStripMenuItem_Click(object sender, EventArgs e)
        {
            ToolStripMenuItem_Click(sender,e);
        }

        private void 管理员管理ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            ToolStripMenuItem_Click(sender, e);
        }

        private void 读者管理ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            ToolStripMenuItem_Click(sender,e);
        }

        private void 借阅图书ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            ToolStripMenuItem_Click(sender, e);
        }

        private void 归还图书ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            ToolStripMenuItem_Click(sender, e);
        }
    }
}