frmChangeUser.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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;
using PMS.PMSClass;
namespace PMS
{
    public partial class frmChangeUser : Form
    {
        public frmChangeUser()
        {
            InitializeComponent();
        }
        DBOperate operate = new DBOperate();
        private void button2_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        // 下载于www.51aspx.com
        private void frmChangeUser_Load(object sender, EventArgs e)
        {
            SqlConnection conn = DBConnection.MyConnection();
            conn.Open();
            SqlCommand cmd = new SqlCommand("select * from tb_User",conn);
            SqlDataReader sdr = cmd.ExecuteReader();
            while (sdr.Read())
            {
                comboBox1.Items.Add(sdr["UserName"].ToString());
            }
            conn.Close();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                if (txtpwd.Text.Trim()==""||comboBox1.Text=="")
                {
                    MessageBox.Show("用户名或密码不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return;
                }
                else
                {
                    string name = comboBox1.Text;
                    string pwd = txtpwd.Text.Trim();
                    SqlConnection conn = DBConnection.MyConnection();
                    conn.Open();
                    SqlCommand cmd = new SqlCommand("select * from tb_User where UserName='" + name + "' and UserPwd='" + pwd + "'", conn);
                    SqlDataReader sdr = cmd.ExecuteReader();
                    sdr.Read();
                    if (sdr.HasRows)
                    {
                        string time = DateTime.Now.ToString();
                        string sql = "update tb_User set LoginTime='" + time + "' where UserName='" + name + "'";
                        operate.OperateData(sql);
                        this.MdiParent.Close();