form1.cs

data structure c 学校管理系统

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

namespace schoolManager
{
    public partial class Form1 : Form
    {
        public Form1(string pass)
        {
            InitializeComponent();
            this.currentpass = pass;
        }
        //标识按钮位置

        private string runPath;
        private string currentpass;
        private int PosFlag = 0;
        private DataSet res = new DataSet("导出数据");
        private void Form1_Load(object sender, EventArgs e)
        {
            runPath = Application.StartupPath;
            loadtitle();

            this.BackColor = Color.FromArgb(28, 109, 139);
            this.panel3.BackColor = this.panel2.BackColor =this.panel1.BackColor = this.BackColor;
            this.dataGridView1.BackgroundColor = this.panel3.BackColor;
            this.dataGridView1.GridColor = this.panel3.BackColor;

            loadxianzhen();//初始化查询
        }

        private void loadxianzhen()
        {
            string xiangzhenname = "select xiangzhenmingcheng from xiangzhen";
            DataMessager data = new DataMessager(Application.StartupPath);
            DataTable mytable = data.query(xiangzhenname, "xiangzhen");
            for (int i = 0; i < mytable.Rows.Count; i++)
            {
                this.comboBox2.Items.Add(mytable.Rows[i].ItemArray[0].ToString());
                this.comboBox5.Items.Add(mytable.Rows[i].ItemArray[0].ToString());
            }
        }
        private void loadtitle()
        {
            string schoolname = "select user from users where id=1";
            DataMessager data = new DataMessager(Application.StartupPath);
            DataTable mytable = data.query(schoolname, "users");
            this.Text = mytable.Rows[0].ItemArray.GetValue(0).ToString();
        }
        private void Form1_SizeChanged(object sender, EventArgs e)
        {
            this.panel1.Height = this.Height - this.statusStrip1.Height-this.menuStrip1.Height-35;
            this.panel3.Height = this.Height - this.statusStrip1.Height - this.menuStrip1.Height - 35-this.panel2.Height-11;
            this.panel2.Width = this.panel3.Width = this.Width - this.panel1.Width - 50;
        }

        private void button1_Click(object sender, EventArgs e)
        {//教师管理
            jiaoshiguanli jiaoshi = new jiaoshiguanli();
            jiaoshi.ShowDialog();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            //教师查询
        }

        private void button3_Click(object sender, EventArgs e)
        {//学生管理
            xueshengguanli xuesheng = new xueshengguanli();
            xuesheng.ShowDialog();
        }

        private void button4_Click(object sender, EventArgs e)
        {
            //学生查询
        }

        private void button5_Click(object sender, EventArgs e)
        {
            //学校管理
        }

        private void button6_Click(object sender, EventArgs e)
        {
            //学校查询
        }

        private void button7_Click(object sender, EventArgs e)
        {
            //学校视图
        }

        private void 快捷菜单ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            this.timer1.Start();
                System.Media.SoundPlayer player;
                if (PosFlag == 1)
                {
                    player = new SoundPlayer(runPath + @"\wave\Restore.wav");
                    player.Play();
                }
                else
                {
                    player = new SoundPlayer(runPath + @"\wave\Minimize.wav");
                    player.Play();
                }
        }
        private void moveit()
        {
            Point pt = this.panel1.Location;
            if (PosFlag==1)
            {
                if (pt.X == -200) { this.timer1.Stop(); PosFlag = 0; return; }                
                pt.X -= 20;
                this.panel1.Location = pt;
            }
            else
            {
                if (pt.X == 0) { this.timer1.Stop(); PosFlag = 1; return; }                
                pt.X += 20;
                this.panel1.Location = pt;
            }
        }

        private void timer1_Tick(object sender, EventArgs e)
        {
            moveit();
        }

        private void 帮助ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            this.panel2.BackColor = this.BackColor;
            this.panel3.Visible = this.panel2.Visible = !this.panel2.Visible;           
        }

        private void button8_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }

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

        private void 数据备份ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            //backup
            if (this.folderBrowserDialog1.ShowDialog() == DialogResult.OK)
            {
                File.Copy(Application.StartupPath + @"\data.mdb", this.folderBrowserDialog1.SelectedPath + @"\data.mdb",true);
                MessageBox.Show("数据已备份成功！", "提示", MessageBoxButtons.OK);
            }
        }

        private void 数据恢复ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            //restore            
            if (this.openFileDialog1.ShowDialog()==DialogResult.OK)
            {
                File.Copy(this.openFileDialog1.FileName, Application.StartupPath + @"\data.mdb", true);
                MessageBox.Show("数据已还原成功！", "提示", MessageBoxButtons.OK);
            }
        }

        private void 权限设置ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            config shezhi = new config(this.currentpass);
            shezhi.ShowDialog();
        }

        private void button10_Click(object sender, EventArgs e)
        {
            this.panel2.Visible = false;
            this.panel3.Visible = false;
        }

        private void button9_Click(object sender, EventArgs e)
        {
            //查询panel2
        }

        private void 帮助ToolStripMenuItem1_Click(object sender, EventArgs e)
        {
            about about = new about();
            about.ShowDialog();
        }

        private void 学生ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            xueshengguanli xueshen = new xueshengguanli();
            xueshen.ShowDialog();
        }

        private void button11_Click(object sender, EventArgs e)
        {//学校视图
            xuexiaoshitu shitu = new xuexiaoshitu();
            shitu.ShowDialog();
        }

        private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
        {
            this.comboBox1.Items.Clear();
            string xiangzhenname = "select xuexiaomingcheng from xuexiaobiao where xiangzhen='" + comboBox2.SelectedItem.ToString() + "'";
            DataMessager data = new DataMessager(Application.StartupPath);
            DataTable mytable = data.query(xiangzhenname, "xuexiaobiao");
            for (int i = 0; i < mytable.Rows.Count; i++)
            {
                this.comboBox1.Items.Add(mytable.Rows[i].ItemArray[0].ToString());
            }
        }

        private void comboBox5_SelectedIndexChanged(object sender, EventArgs e)
        {
            this.comboBox6.Items.Clear();
            string xiangzhenname = "select xuexiaomingcheng from xuexiaobiao where xiangzhen='" + comboBox5.SelectedItem.ToString() + "'";
            DataMessager data = new DataMessager(Application.StartupPath);
            DataTable mytable = data.query(xiangzhenname, "xuexiaobiao");
            for (int i = 0; i < mytable.Rows.Count; i++)
            {
                this.comboBox6.Items.Add(mytable.Rows[i].ItemArray[0].ToString());
            }
        }

        private void button12_Click(object sender, EventArgs e)
        {
            this.dataGridView1.DataSource = null;
        }

        private void 教师管理ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            //教师管理
            jiaoshiguanli jiaoshi = new jiaoshiguanli();
            jiaoshi.ShowDialog();
        }
        private void 分类统计ToolStripMenuItem1_Click(object sender, EventArgs e)
        {
            //教师统计
            chaxuntongji tongji = new chaxuntongji();
            tongji.ShowDialog();
        }

        private void 学校管理ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            xuexiao xuexiao = new xuexiao();
            xuexiao.ShowDialog();
        }

        private void 事务记录ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            richangshuwu shiwu = new richangshuwu();
            shiwu.ShowDialog();
        }
    }
}