frmchangeuser.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;
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();
        }

        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();
                        conn.Close();
                        frmMain Main = new frmMain();
                        Main.User = name;
                        Main.Logintime = time;
                        Main.Show();
                    }
                    else
                    {
                        txtpwd.Text = "";
                        comboBox1.Text = "";
                        MessageBox.Show("用户名或密码错误！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
    }
}