C# winfrom人事管理系统带源码和文档

码猩

于 2024-06-27 00:05:38 发布

阅读量372

点赞数 8

分类专栏： C#从零到精通文章标签： c# 开发语言

本文链接：https://blog.csdn.net/weixin_43050480/article/details/140001333

版权

C#从零到精通专栏收录该内容

6 篇文章 0 订阅

订阅专栏

C# winfrom人事管理系统带源码和文档

在这里插入图片描述

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

namespace 人事管理系统
{
    public partial class Admin : Form
    {
        private string mID = "";
        public string ID
        {
            get
            {
                return mID;
            }
            set
            {
                mID = value;
            }
        }
        public Admin()
        {
            InitializeComponent();
        }

        private void Admin_Load(object sender, EventArgs e)
        {
            if (mID != "")
            {

                DataTable dt = new DataTable();
                dt = DBHelper.GetDataSet("select * from TB_Admin where ID='" + mID + "'").Tables[0];
                if (dt.Rows.Count > 0)
                {
                    this.textBox1.Text = dt.Rows[0]["UserName"].ToString();
                    this.textBox2.Text = dt.Rows[0]["PassWord"].ToString();
                 
                    this.textBox1.ReadOnly = true;
                }
            }
        }

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

        private void button1_Click(object sender, EventArgs e)
        {
            if (mID == "")
            {
                if (this.textBox1.Text == "")
                {
                    MessageBox.Show("编号不能为空");
                    return;
                }
                if (DBHelper.GetDataSet("select * from TB_YuanGong where UserName='" + textBox1.Text + "'").Tables[0].Rows.Count > 0)
                {
                    MessageBox.Show("用户名重复");
                    return;
                }
                DBHelper.ExecSql("INSERT INTO TB_YuanGong (UserName ,PassWord  ) VALUES ('" + textBox1.Text + "','" + textBox2.Text + "')"); MessageBox.Show("操作成功");
            }
            else
            {

                //修改
                DBHelper.ExecSql("UPDATE TB_YuanGong set UserName = '" + textBox1.Text + "',PassWord = '" + textBox2.Text + "' WHERE ID='" + mID + "' ");
                this.Close();
            }
           
        }
    }
}