formothersetting.cs

数据库开发与实例（1+1混合数据库开发实例丛书）人事管理系统的源代码

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

namespace HRMan.SysOper
{
    public partial class FormOtherSetting : Form
    {
        public FormOtherSetting()
        {
            InitializeComponent();
            HRMan.SysOper.FormOtherSetting.othersetting = this;
        }

        private void FormOtherSetting_Load(object sender, EventArgs e)
        {
            InitListBox1();
            InitListBox2();
            InitListBox3();
        }
        public void InitListBox1()
        {
            this.listBox1.Items.Clear();
            string SqlText = "select * from RaceInfo";
            DataAccess DA = new DataAccess();
            DataTable dt = new DataTable();
            dt = DA.ExeSQLdt(SqlText);
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                this.listBox1.Items.Add(dt.Rows[i]["rName"].ToString());
            }
        }

        public void InitListBox2()
        {
            this.listBox2.Items.Clear();
            string SqlText = "select * from JobInfo";
            DataAccess DA = new DataAccess();
            DataTable dt = new DataTable();
            dt = DA.ExeSQLdt(SqlText);
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                this.listBox2.Items.Add(dt.Rows[i]["JName"].ToString());
            }
        }

        public void InitListBox3()
        {
            this.listBox3.Items.Clear();
            string SqlText = "select * from Title";
            DataAccess DA = new DataAccess();
            DataTable dt = new DataTable();
            dt = DA.ExeSQLdt(SqlText);
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                this.listBox3.Items.Add(dt.Rows[i]["tName"].ToString());
            }
        }

        private void toolStripAdd_Click(object sender, EventArgs e)
        {
            switch(this.tabControl1.SelectedIndex)
            {
                case 0: //添加民族
                    {
                        if (FormMain.FM.CheckForm("FormTreeNode") == true)
                        {
                            return;
                        }
                        else
                        {
                            FormTreeNode treenode = new FormTreeNode();
                            treenode.MdiParent = FormMain.FM;
                            treenode.Show();
                            treenode.label1.Text = "请输入民族名称";
                            treenode.TopMost = true;
                        }
                        break;
                    }
                case 1://添加职务
                    {
                        if (FormMain.FM.CheckForm("FormTreeNode") == true)
                        {
                            return;
                        }
                        else
                        {
                            FormTreeNode treenode = new FormTreeNode();
                            treenode.MdiParent = FormMain.FM;
                            treenode.Show();
                            treenode.label1.Text = "请输入职务名称";
                            treenode.TopMost = true;
                        } 
                        break;
                    }
                case 2: //添加职称
                    {
                        if (FormMain.FM.CheckForm("FormTreeNode") == true)
                        {
                            return;
                        }
                        else
                        {
                            FormTreeNode treenode = new FormTreeNode();
                            treenode.MdiParent = FormMain.FM;
                            treenode.Show();
                            treenode.label1.Text = "请输入职称名称";
                            treenode.TopMost = true;
                        } 
                        break;
                    }
                default:
                    {
                        MessageBox.Show("请选择一个Tab页！");
                        break;
                    }
               
            }
        }

        private void toolStripDelete_Click(object sender, EventArgs e)
        {
            switch (this.tabControl1.SelectedIndex)
            {
                case 0: //删除民族
                    {
                        if (this.listBox1.SelectedItems.Count != 0)
                        {
                            string str = "delete from RaceInfo where rName='" + this.listBox1.SelectedItem.ToString() + "'";
                            DataAccess DA = new DataAccess();
                            DA.ExeSQL(str);
                            this.InitListBox1();
                        }
                        else
                        {
                            MessageBox.Show("请选择你要删除的项!");
                        }
                        break;
                    }
                case 1://删除职务
                    {
                        
                        if (this.listBox2.SelectedItems.Count != 0)
                        {
                            string str = "delete from JobInfo where JName='" + this.listBox2.SelectedItem.ToString() + "'";
                            DataAccess DA = new DataAccess();
                            DA.ExeSQL(str);
                            this.InitListBox2();
                        }
                        else
                        {
                            MessageBox.Show("请选择你要删除的项!");
                        }
                        break;
                    }
                case 2: //删除职称
                    {
                        if (this.listBox3.SelectedItems.Count != 0)
                        {
                            string str = "delete from Title where tName='" + this.listBox3.SelectedItem.ToString() + "'";
                            DataAccess DA = new DataAccess();
                            DA.ExeSQL(str);
                            this.InitListBox3();
                        }
                        else
                        {
                            MessageBox.Show("请选择你要删除的项!");
                        }
                        break;
                    }
                default:
                    {
                        break;
                    }

            }
        }

        private void toolStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
        {

        }
    }


}