基础控件
登录界面
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace Students
{
public partial class frm_Login : Form
{
public frm_Login()
{
InitializeComponent();
}
bool flag = false;
private void frm_Login_FormClosing(object sender, FormClosingEventArgs e)
{
if (flag)
{
e.Cancel = false;
}
else
{
if (!Close())
{
e.Cancel = true;
}
}
}
private void btn_close_Click(object sender, EventArgs e)
{
Close();
}
private bool Close()
{
DialogResult dr = MessageBox.Show("你确定要退出整个系统吗","友情提示",MessageBoxButtons.YesNo,MessageBoxIcon.Warning);
if (dr.CompareTo(DialogResult.Yes) == 0)
{
flag = true;
Application.Exit();
}
return flag;
}
private void frm_Login_FormClosed(object sender, FormClosedEventArgs e)
{
frm_Login frmlogin = new frm_Login();
frmlogin.Show();
}
private void btn_Login_Click(object sender, EventArgs e)
{
string uname = this.txt_uname.Text.Trim();
string pwd = this.txt_pwd.Text.Trim();
if (uname.Length > 0 && pwd.Length > 0)
{
Login(uname, pwd);
}
else
{
MessageBox.Show("密码或者用户名不能为空", "错误提示", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
}
}
private void Login(string uname, string pwd)
{
string url = "server=localhost;database=Student;uid=sa;pwd=123";
using (SqlConnection con=new SqlConnection(url))
{
con.Open();
SqlCommand com = new SqlCommand("select count(uid) from t_users where uname=@uname and upwd=@upwd", con);
com.Parameters.Add("@uname", uname);
com.Parameters.Add("@upwd", pwd);
int index = int.Parse(com.ExecuteScalar().ToString());
if (index > 0)
{
this.Hide();
Frm_MAIN fm = new Frm_MAIN();
fm.loginName = uname;
fm.ShowDialog();
}
else
{
MessageBox.Show("用户名或者密码错误", "错误提示", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
this.txt_pwd.Text = string.Empty;
this.txt_uname.Text = string.Empty;
}
}
}
private void frm_Login_KeyPress(object sender, KeyPressEventArgs e)
{
char keys = e.KeyChar;
if (keys == (char)Keys.Enter)
{
btn_Login_Click(sender, e);
}
}
}
}
主窗体
using System;
using System.Collections