数据库课程设计 教务管理系统

洛 阳 理 工 学 院 课 程 设 计 报 告

} }

} if (!b) {

MessageBox.Show(\用户名不存在或密码错误\ UsecrettextBox.Clear(); UnametextBox.Focus(); return; }

} else {

MessageBox.Show(\请选择用户类型\ UnametextBox.Clear(); UsecrettextBox.Clear(); UnametextBox.Focus(); return; } } }

public partial class StudentForm : Form //学生界面 {

public StudentForm() {

11

洛 阳 理 工 学 院 课 程 设 计 报 告

InitializeComponent(); }

DataClasses1DataContext db;

private void StudentForm_Load(object sender, EventArgs e) {

db = new DataClasses1DataContext(); SnotextBox.Text = UserInform.UserName; SnotextBox1.Text = UserInform.UserName;

var ss = from s in db.Student where s.Sno == UserInform.UserName select s; foreach (var itm in ss) {

SnametextBox.Text = itm.Sname; SagetextBox.Text = itm.Sage.ToString(); SsextextBox.Text = itm.Ssex; } }

private void label4_Click(object sender, EventArgs e) {

this.Close();

UserInform.lg.Visible = true; }

private void label3_Click(object sender, EventArgs e) {

panel2.Visible = true; }

private void Enterbutton_Click(object sender, EventArgs e)

12

洛 阳 理 工 学 院 课 程 设 计 报 告

{

db = new DataClasses1DataContext(); if (textBox1.Text == \ {

MessageBox.Show(\请输入原密码\ textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); textBox1.Focus(); }

else if (textBox1.Text == UserInform.UserSecret) {

if(textBox2.Text==textBox3.Text) {

var ss = from s in db.UserInfo where s.Uname == UserInform.UserName && s.Utype == UserInform.UserType select s; var ui = ss.FirstOrDefault(); if (ui != null) {

ui.Usecret = textBox2.Text; db.SubmitChanges();

MessageBox.Show(\修改成功\ textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); panel2.Visible = false; }

}

13

洛 阳 理 工 学 院 课 程 设 计 报 告

else {

MessageBox.Show(\两次输入应相同\ textBox3.Clear(); textBox3.Focus(); } } else {

MessageBox.Show(\原密码输入错误，请重新输入\ textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); textBox1.Focus(); } }

private void Cancelbutton_Click(object sender, EventArgs e) {

textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); panel2.Visible = false; }

private void StudentForm_FormClosing(object sender, FormClosingEventArgs e) {

db = new DataClasses1DataContext(); this.bindingSource1.DataSource = db.UserInfo;

14