form1.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.Data.SqlClient;
using System.IO;


namespace 图书馆管理系统
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            
            InitializeComponent();
        }
        //----------------------查询MDI子窗体是否存在-----------------------------
        public bool childFraShow(string childName)
        {
            foreach (Form childFrm in this.MdiChildren)
            {
                if (childFrm.Name == childName)
                {
                    if (childFrm.WindowState == FormWindowState.Minimized)
                        childFrm.WindowState = FormWindowState.Normal;
                    childFrm.Activate();
                    return true;
                }
            }
            return false;
        }
         
       

        private void 图书类型设置ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (this.childFraShow("图书类型设置") == true)
            {
                return;
            }
            图书类型设置 f1 = new 图书类型设置();
            f1.MdiParent = this;
            f1.Show();
            label4.Visible = false;
        }

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

        private void 图书档案管理ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (this.childFraShow("图书档案管理") == true)
            {
                return;
            }
            图书档案管理 f2 = new 图书档案管理();
            f2.MdiParent = this;
            f2.Show();
            label4.Visible = false;
        }

        private void 出版社管理ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (this.childFraShow("出版社管理") == true)
            {
                return;
            }
            出版社管理 f3 = new 出版社管理();
            f3.MdiParent = this;
            f3.Show();
            label4.Visible = false;
        }

        private void 图书注销ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (this.childFraShow("图书注销") == true)
            {
                return;
            }
            图书注销 f4 = new 图书注销();
            f4.MdiParent = this;
            f4.Show();
            label4.Visible = false;
        }

        private void 图书ToolStripMenuItem1_Click(object sender, EventArgs e)
        {
            if (this.childFraShow("图书借阅") == true)
            {
                return;
            }
            图书借阅 f5 = new 图书借阅();
            f5.MdiParent = this;
            f5.Show();
            label4.Visible = false;
        }

        private void 图书征定ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (this.childFraShow("图书征定") == true)
            {
                return;
            }
            图书征定 f6 = new 图书征定();
            f6.MdiParent = this;
            f6.Show();
            label4.Visible = false;
        }

        private void 管理员信息ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (this.childFraShow("管理员信息") == true)
            {
                return;
            }
            管理员信息 f7 = new 管理员信息();
            f7.MdiParent = this;
            f7.button1.Visible = false;
            f7.button2.Visible = false;
            f7.button3.Visible = false;
            f7.button8.Visible = false;
            f7.button8.Visible = false;
            f7.button10.Visible = false;
            f7.Show();
            label4.Visible = false;
        }

        private void 图书ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (this.childFraShow("图书验收") == true)
            {
                return;
            }
            图书验收 f8 = new 图书验收();
            f8.MdiParent = this;
            f8.Show();
            label4.Visible = false;
        }

        private void 图书馆管理系统10版ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (this.childFraShow("关于图书馆系统") == true)
            {
                return;
            }
            关于图书馆系统 f9 = new 关于图书馆系统();
            f9.MdiParent = this;
            f9.Show();
            label4.Visible = false;
        }

        private void 图书盘点ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (this.childFraShow("图书盘点") == true)
            {
                return;
            }
            图书盘点 f10 = new 图书盘点();
            f10.MdiParent = this;
            f10.Show();
            label4.Visible = false;
        }

        private void 图书归还ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (this.childFraShow("图书归还") == true)
            {
                return;
            }
            图书归还 f11 = new 图书归还();
            f11.MdiParent = this;
            f11.Show();
            label4.Visible = false;
        }

        private void 逾期清单ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (this.childFraShow("逾期图书清单") == true)
            {
                return;
            }
            逾期图书清单 f12 = new 逾期图书清单();
            f12.MdiParent = this;
            f12.Show();
            label4.Visible = false;
        }

        private void 图书罚款ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (this.childFraShow("图书罚款") == true)
            {
                return;
            }
            图书罚款 f13 = new 图书罚款();
            f13.MdiParent = this;
            f13.Show();
            label4.Visible = false;
        }

        private void 图书馆管理ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (this.childFraShow("图书管管理") == true)
            {
                return;
            }
            图书管管理 f20 = new 图书管管理();
            f20.MdiParent = this;
            f20.Show();
            label4.Visible = false;
        }

        private void 管理员管理ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (this.childFraShow("管理员信息") == true)
            {
                return;
            }
            管理员信息 f15 = new 管理员信息();
            f15.MdiParent = this;
            f15.Show();
            f15.showButton(false);
            label4.Visible = false;
        }

        private void 读者类型设置ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (this.childFraShow("读者类型管理") == true)
            {
                return;
            }
            读者类型管理 f16 = new 读者类型管理();
            f16.MdiParent = this;
            f16.Show();
            label4.Visible = false;
        }

        private void 读者档案管理ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (this.childFraShow("读者档案管理") == true)
            {
                return;
            }
            读者档案管理 f17 = new 读者档案管理();
            f17.MdiParent = this;
            f17.Show();
            label4.Visible = false;
        }

        private void 退出系统QToolStripMenuItem_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void Form1_FormClosing(object sender, FormClosingEventArgs e)
        {
            DialogResult result = MessageBox.Show("确定要关闭窗体吗？", "确认", MessageBoxButtons.OKCancel);
            if (result == DialogResult.OK)
            {
                Application.Exit();
                label4.Visible = true;
           }
            else
                e.Cancel = true;
        }

        private void 借书证挂失与恢复ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (this.childFraShow("借书证件管理") == true)
            {
                return;
            }
            借书证件管理 f18 = new 借书证件管理();
            f18.MdiParent = this;
            f18.Show();
            label4.Visible = false;
        }

        private void 过期续证管理ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (this.childFraShow("续证管理") == true)
            {
                return;
            }
            续证管理 f19 = new 续证管理();
            f19.MdiParent = this;
            f19.Show();
            label4.Visible = false;
        }
//-------------------------------日期----------------------
        private void timer1_Tick(object sender, EventArgs e)
        {
            DateTime time = DateTime.Now;
            toolStripStatusLabel2.Text = time.Year.ToString() + "年" + time.Month.ToString() + "月" + time.Day.ToString() + "日";
            toolStripStatusLabel3.Text = System.DateTime.Now.ToLongTimeString();//  time.Hour.ToString() +"时"+ time.Minute.ToString() +"分"+ time.Second.ToString()+"秒";
        }

        private void 帮助HToolStripMenuItem_Click(object sender, EventArgs e)
        {
            帮助 f = new 帮助();
            f.ShowDialog();
            label4.Visible = false;
            
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            label4.Visible = false;
            axWindowsMediaPlayer2.Visible = false;
            音乐ToolStripMenuItem.CheckOnClick = true;
            音乐ToolStripMenuItem.Checked =true;
            this.系统管理ToolStripMenuItem.Enabled = false;
            this.图书管理ToolStripMenuItem.Enabled = false;
            this.流通管理ToolStripMenuItem.Enabled = false;
            this.读者管理ToolStripMenuItem.Enabled = false;
            
        }
        public int power;
        private void button1_Click(object sender, EventArgs e)
        {

            sqlConnection1.Open();
            if (textBox1.Text == "" || textBox2.Text == "")
            {
                MessageBox.Show("请输入用户名和密码，然后再登录!");
                return;
            }

            string sql = "select 权限 from 管理员信息 where 姓名='" + textBox1.Text.Trim() + "' and 密码='" + textBox2.Text.Trim() + "'";
            SqlCommand mycom = null;
            try
            {
                mycom = new SqlCommand(sql, sqlConnection1);
                SqlDataReader mydr = mycom.ExecuteReader();
                if (mydr.HasRows)
                {
                    mydr.Read();
                    power = Convert.ToInt32(mydr[0]);
                    
                    switch (power)
                    {
                        case 220:
                            this.读者管理ToolStripMenuItem.Enabled = true; break;
                        case 330:
                            this.读者管理ToolStripMenuItem.Enabled = true;
                            this.图书管理ToolStripMenuItem.Enabled = true; break;
                        case 110:
                            this.读者管理ToolStripMenuItem.Enabled = true;
                            this.流通管理ToolStripMenuItem.Enabled = true;
                            this.图书管理ToolStripMenuItem.Enabled = true;
                            this.系统管理ToolStripMenuItem.Enabled = true; break;

                        default:
                            MessageBox.Show("你没有使使用本系统的权限"); break;
                    }
                    MessageBox.Show("登录成功！");
                    panel1.Hide();
                    label4.Visible = true;
                    
                  
                    mydr.Close();

                }
                else
                    MessageBox.Show("没有这个用户或密码不正确，请重新登录！");

            }
            catch (SqlException a)
            {
                MessageBox.Show(a.Message, "错误");
            }

            sqlConnection1.Close();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            this.panel1.Hide();
        }

        private void 音乐ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            try
            {
                string str = "D:\\C#\\重要文件\\图书馆管理系统\\图书馆管理系统\\感动天感动地.mp3";
                if (音乐ToolStripMenuItem.Checked == true)
                {
                    axWindowsMediaPlayer2.URL = str;
                }
                else
                    axWindowsMediaPlayer2.URL = "";
            }
            catch (SqlException a)
            {
                MessageBox.Show(a.Message, "错误"); 
            }
        }

       

        

        

      

       
    }
}