protected void btnDelete_Click(object sender, EventArgs e) { //是否已经存在 LinQDBDataContext linqDB = new LinQDBDataContext(); int i = linqDB.User.Where(p => this.txtName.Text == p.UserName).Count(); if (i > 0) { User u = linqDB.User.Where(p => p.UserName == this.txtName.Text).Single(); linqDB.User.DeleteOnSubmit(u); //更新对象 linqDB.SubmitChanges(); } else { Response.Write("<script language=javascript>window.alert('该用户已经存在')</script>"); return; } }
protected void btnUpdate_Click(object sender, EventArgs e) { //是否已经存在 LinQDBDataContext linqDB = new LinQDBDataContext(); int i = linqDB.User.Where(p => this.txtName.Text == p.UserName).Count(); if (i > 0) { User u = linqDB.User.Where(p => p.UserName == this.txtName.Text).Single(); u.UserPassword = this.txtPwd.Text; u.RoleID = int.Parse(this.rdlRole.SelectedValue.ToString()); //更新对象 linqDB.SubmitChanges(); } else { Response.Write("<script language=javascript>window.alert('该用户已经存在')</script>"); return; } }
protected void btnRegister_Click(object sender, EventArgs e) { //是否已经存在 LinQDBDataContext linqDB = new LinQDBDataContext(); int i = linqDB.User.Where(p => this.txtName.Text == p.UserName).Count(); if (i > 0) { Response.Write("<script language=javascript>window.alert('该用户已经存在')</script>"); return; } //注册用户 //OR映射实现注册 //将需要保存的信息封装在对象内部,然后OR映射将对象转化为SQL语句 User u = new User(); u.UserName = this.txtName.Text; u.UserPassword = this.txtPwd.Text; u.RoleID = int.Parse(this.rdlRole.SelectedValue.ToString()); //在容器中添加一个新对象 linqDB.User.InsertOnSubmit(u); //更新到数据库 linqDB.SubmitChanges(); }