main_staff.cs

一个农村管理系统的程序 数据库那部分可能不全 大家可以

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

namespace MsgSystem
{
    public partial class Main_staff : Form
    {
        ArrayList mods = null;
        ArrayList groups = null;
        ArrayList staff = null;
        
        //modId, groupId, personId代表真正的ID，而不是目前操作的对象在mods, groups, staff的索引位置
        int modId = 0;
        int groupId = 0;
        int persionId = 0;


        public Main_staff()
        {
            InitializeComponent();
            
        }

        private void label5_Click(object sender, EventArgs e)
        {

        }

        private void label6_Click(object sender, EventArgs e)
        {

        }

        private void label1_Click(object sender, EventArgs e)
        {

        }

        private void label3_Click(object sender, EventArgs e)
        {

        }

        private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            Console.WriteLine(modList.SelectedIndex);

            modId = ((ModInfo)mods[modList.SelectedIndex]).getID();
            groupList.Items.Clear();

            refreshGroups();
            staffList.Items.Clear();
            buttonDel.Enabled = false;

            clearForm();

        }

        private void label9_Click(object sender, EventArgs e)
        {

        }

        private void listBox3_SelectedIndexChanged(object sender, EventArgs e)
        {
            Console.WriteLine(staffList.SelectedIndex);

            persionId = ((PersonInfo)staff[staffList.SelectedIndex]).getID();

            refreshPerson();
            buttonDel.Enabled = true;
            buttonAdd.Enabled = false;

        }

        private void button2_Click(object sender, EventArgs e)
        {
            String tableName = "TAB_STAFF";
            int id = persionId;
            String personName = ((PersonInfo)staff[staffList.SelectedIndex]).getName();
            DbFun.deleteRecord(tableName, id);
            
            refreshStaff();
            clearForm();
            DbFun.insertSysMsg("人员删除: " + personName);
            buttonDel.Enabled = false;

        }

        private void Main_staff_Load(object sender, EventArgs e)
        {
            refreshMods();

            buttonAdd.Enabled = false;
            buttonDel.Enabled = false;

        }

        private void groupList_SelectedIndexChanged(object sender, EventArgs e)
        {
            Console.WriteLine(groupList.SelectedIndex);

            groupId = ((GroupInfo)groups[groupList.SelectedIndex]).getID();
            staffList.Items.Clear();
            refreshStaff();
            buttonDel.Enabled = false;

            clearForm();

        }

        private void refreshGroups()
        {
            int modId = this.modId;
            groups = DbFun.getGroups(modId);
            GroupInfo group = null;
            int count = groups.Count;

            groupList.Items.Clear();
            staffList.Items.Clear();
            clearForm();
            for (int i = 0; i < count; i++)
            {
                group = (GroupInfo)groups[i];
                groupList.Items.Add( group.getName( ));

            }

            groupId = -1;
            persionId = -1;
        }

        private void refreshMods()
        {
            mods = DbFun.getModsInfo();

            int count = mods.Count;
            ModInfo mod = null;
            modList.Items.Clear();
            groupList.Items.Clear();
            staffList.Items.Clear();

            for (int i = 0; i < count; i++)
            {
                mod = (ModInfo)mods[i];
                modList.Items.Add(mod.getName( ));

            }
            modId = -1;
            groupId = -1;
            persionId = -1;


        }

        private void refreshStaff()
        {

            int groupId = this.groupId;
            staff = DbFun.getStaff(groupId);
            PersonInfo person = null;
            int count = staff.Count;
            staffList.Items.Clear();
            for (int i = 0; i < count; i++)
            {
                person = (PersonInfo)staff[i];
                staffList.Items.Add(person.getName( ));

            }

            persionId = -1;

        }

        private void refreshPerson()
        {
            int i = staffList.SelectedIndex;

            PersonInfo person = (PersonInfo)staff[i];

            this.textName.Text = person.getName();
            this.textAge.Text = Convert.ToString( person.getAge());
            this.textPost.Text = person.getPost();
            if (person.getSex( ) == "M")
            {
                this.radioSex1.Checked = true;
                this.radioSex2.Checked = false;
            }
            else
            {
                this.radioSex1.Checked = false;
                this.radioSex2.Checked = true;
            }
            this.textPhone.Text = person.getPhone();
            this.textDesc.Text = person.getDesc();



        }

        private void buttonClear_Click(object sender, EventArgs e)
        {

            clearForm();

        }

        private void clearForm()
        {
            

            this.textName.Text = "";
            this.textAge.Text = "";
            this.textPost.Text = "";

            this.radioSex1.Checked = true;
            this.radioSex2.Checked = false;

            this.textPhone.Text = "";
            this.textDesc.Text = "";

            buttonAdd.Enabled = true;
            buttonDel.Enabled = false;

        }
        private void buttonAdd_Click(object sender, EventArgs e)
        {
            PersonInfo person = new PersonInfo();

            person.setName(textName.Text);
            person.setAge( Convert.ToInt32( textAge.Text));
            person.setPhone(textPhone.Text);
            person.setPost( textPost.Text);
            person.setDesc( textDesc.Text);
            person.setGroup(groupId);

            if (radioSex1.Checked)
            {
                person.setSex("M");
            }
            else
            {
                person.setSex("F");
            }

            DbFun.insertPerson(person);

            refreshStaff();
            clearForm();
            DbFun.insertSysMsg("人员添加: " + person.getName());

            buttonAdd.Enabled = false;

        }

        private void radioSex1_CheckedChanged(object sender, EventArgs e)
        {
            //radioSex2.Checked = false;

        }

        private void radioSex2_CheckedChanged(object sender, EventArgs e)
        {
            //radioSex1.Checked = false;

        }

    }
}