frmlogin.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 frmLogin : Form
    {
        public frmLogin()
        {
            InitializeComponent();
        }
        DBOperate operate = new DBOperate();
        private void btnLogin_Click(object sender, EventArgs e)
        {
            try
            {
                if (txtUserName.Text == "" || txtUserPwd.Text == "")
                {
                    MessageBox.Show("用户名或密码不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return;
                }
                else
                {
                    string name = txtUserName.Text.Trim();
                    string pwd = txtUserPwd.Text.Trim();
                    SqlConnection conn = PMSClass.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);
                        conn.Close();
                        this.Hide();
                        frmMain Main = new frmMain();
                        Main.User = name;
                        Main.Logintime = time;
                        Main.Show();
                    }
                    else
                    {
                        txtUserName.Text = "";
                        txtUserPwd.Text = "";
                        MessageBox.Show("用户名或密码错误！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

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

        private void frmLogin_Load(object sender, EventArgs e)
        {

        }
    }
}