frmusermanage.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;

namespace HRP.UserManage
{
    public partial class frmUserManage : Form
    {
        public frmUserManage()
        {
            InitializeComponent();
        }

        BaseClass.SqlClass sqlclass = new HRP.BaseClass.SqlClass();
        BaseClass.UserClass userclass = new HRP.BaseClass.UserClass();
        private void frmUserManage_Load(object sender, EventArgs e)
        {
            this.Bind();
        }

        private void lbUserName_SelectedIndexChanged(object sender, EventArgs e)
        {
            if(Convert.ToString(this.lbUserName.SelectedItem)!="")
            {
                DataRowView rowview = sqlclass.SqlDaAd("select * from tb_Purview where UserName='" + this.lbUserName.Text + "'", "tb_Purview").Tables["tb_Purview"].DefaultView[0];
                this.chkBase.Checked = Convert.ToBoolean(rowview["Base"]);
                this.chkWageSetUp.Checked = Convert.ToBoolean(rowview["WageSetUp"]);
                this.chkPersonel.Checked = Convert.ToBoolean(rowview["Personel"]);
                this.chkWage.Checked = Convert.ToBoolean(rowview["Wage"]);
                this.chkSystem.Checked = Convert.ToBoolean(rowview["System"]);
            }
        }

        private void btnPurviewEdit_Click(object sender, EventArgs e)
        {
            userclass.PurviewEdit(this.chkBase.Checked, this.chkWageSetUp.Checked, this.chkPersonel.Checked, this.chkWage.Checked, this.chkSystem.Checked,Convert.ToString(this.lbUserName.SelectedItem));
            MessageBox.Show("修改成功","成功提示");
        }

        private void btnUserAdd_Click(object sender, EventArgs e)
        {
            frmUserAdd frm_useradd = new frmUserAdd();
            frm_useradd.frmusermanage = this;
            frm_useradd.ShowDialog();
        }

        private void btnUserEdit_Click(object sender, EventArgs e)
        {
            frmUserEdit frm_useredit = new frmUserEdit();
            frm_useredit.strUserName =Convert.ToString(this.lbUserName.SelectedItem);
            frm_useredit.ShowDialog();
        }

        private void btnDelete_Click(object sender, EventArgs e)
        {
            userclass.UserDelete(Convert.ToString(this.lbUserName.SelectedItem));
            this.Bind();
        }
        public void Bind()
        {
            this.lbUserName.Items.Clear();
            DataSet ds = sqlclass.SqlDaAd("select * from tb_Purview", "tb_Purview");
            for (int i = 0; i < ds.Tables["tb_Purview"].Rows.Count; i++)
            {
                this.lbUserName.Items.Add(Convert.ToString(ds.Tables["tb_Purview"].Rows[i][5]));
            }
            this.lbUserName.SetSelected(0, true);
        }
    }
}