protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
List <StudentClass> listClass = new List <StudentClass>();
listClass = new StudentClassServer().GetStudentClassList();
dpdClassName.DataSource = listClass;
dpdClassName.DataTextField = "ClassName";
dpdClassName.DataValueField = "ClassId";
dpdClassName.DataBind();
//【1】获取学员的ID
string studentId = Request.QueryString["StudentId"].ToString();
StudentSimpleExt objStudent = new StudentSimpleExt();
objStudent = new StudentServer().GetStuSentById(studentId);
//【2】解析对象
latStudentId.Text = studentId;
txtNmae.Text = objStudent.StudentName;
txtAddress.Text = objStudent.StudentAddress;
txtBirthday.Text = objStudent.Birthday.ToString("yyyy-MM-dd");
txtPhoneNum.Text = objStudent.PhoneNumber;
dpdClassName.SelectedIndex = objStudent.ClassID;
rdoFelmem.Checked = objStudent.Gender == "女" ? true : false;
rdoMen.Checked = objStudent.Gender == "女" ? false : true;
txtStuIdCardNum.Text = objStudent.StudentIDNub;
imgStudent.ImageUrl = string.Format("~/images/student-img/{0}.png", studentId);
}
LtaMsg.Text = "";
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
StudentServer objStudentServer = new StudentServer();
//【1】判断身份证是否重复
if (objStudentServer.IsExistsStudent(latStudentId.Text.Trim(), txtStuIdCardNum.Text.Trim()))
{
LtaMsg.Text = "<script type='text / javascript'>alert('" + latStudentId.Text.Trim() + "学员身份号信息已存在！请检查学员的身份证号')</script>";
return;
}
//【2】封装学员对象
Student objStudent = new Student()
{
StudentID = Convert.ToInt32(latStudentId.Text.Trim()),
StudentName = txtNmae.Text.Trim(),
StudentAddress = txtAddress.Text.Trim(),
Birthday = Convert.ToDateTime(txtBirthday.Text),
PhoneNumber = txtPhoneNum.Text.Trim(),
ClassID = dpdClassName.SelectedIndex,
Gender = rdoFelmem.Checked ? "女":"男",
StudentIDNub = txtStuIdCardNum.Text.Trim()
};
if (objStudentServer.ModifyStudentInfo(objStudent) != 1)
{
//LtaMsg.Text = "<script type='text / javascript'>alert('" + latStudentId.Text.Trim() + "学员身份号信息已存在！请检查学员的身份证号')</script>";
Response.Redirect("~/errPage.html");
}
else
{
Response.Redirect("~/StudentWebASP/UpLoadImg.aspx?IsModify=1&Id=" + objStudent.StudentID);
}
}
public static bool UpdateStudentInfo(Student s)
{
try
{
////查询出来一个student
//Student stu = StudentServer.SelectStudentByID(s.StuID);
//ExamDBEntities db = new ExamDBEntities();
//db.Entry(stu).State = EntityState.Modified;
////逐个更新
//stu.StuName = s.StuName;
//stu.StuLoginName = s.StuLoginName;
//stu.StuSex = s.StuSex;
//stu.StuGrade = s.StuGrade;
//stu.StuEmail = s.StuEmail;
//stu.StuLoginPwd = s.StuLoginPwd;
//stu.StuPhone = s.StuPhone;
//查询出来一个student
Student stu = StudentServer.SelectStudentByID(s.StuID);
ExamDBEntities db = new ExamDBEntities();
//这也可以实现对象的快速修改，推荐用这个方法
db.Entry(s).State = EntityState.Modified; //直接将传入的对象，设置修改装填
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public static bool CheckStudentUser(string name, string pwd)
{
Student s = StudentServer.SelectStudentByName(name);
//不为空，表示查询到了一条学生信息的记录
if (s != null)
{
return(s.StuLoginPwd == pwd);
}
else
{
return(false);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
//【1】检查学员的信息
if (new StudentServer().IsExistsStudent(txtStuIdCardNum.Text.Trim()))
{
LtaMsg.Text = "<script type='text/javascript'>alert('学员信息重复请检查信息的输入！')</script>";
return;
}
else
{
//【2】验证验证码是否正确
if (txtCord.Text == Session["CheckCode"].ToString())
{
//【3】封装学员数据
Student objStudent = new Student()
{
StudentName = txtNmae.Text.Trim(),
Gender = rdoMen.Checked ? "男" : "女",
Birthday = Convert.ToDateTime(txtBirthday.Text),
ClassID = dpdClassName.SelectedIndex,
StudentIDNub = txtStuIdCardNum.Text,
PhoneNumber = txtPhoneNum.Text,
StudentAddress = txtAddress.Text.Trim().Length == 0 ? "地址不详" : txtAddress.Text.Trim()
};
//【4】提交学员信息
try
{
int newStudentId = new StudentServer().AddStudentInfo(objStudent);
if (newStudentId > 0)
{
Response.Redirect("~/StudentWebASP/UpLoadImg.aspx?Id=" + newStudentId);
// LtaMsg.Text = "<script type='text/javascript'>alert('添加学员信息时出现错误:')</script>";
}
}
catch (Exception ex)
{
//LtaMsg.Text = "<script type='text/javascript'>alert(' 验证码错误，请重新输入验证码！')</script>";
LtaMsg.Text = "<script type='text/javascript'>alert('添加学员信息时出现错误:" + ex.Message.ToString().Replace('\'', '_') + " ')</script>";
//throw ex ;
}
}
else
{
LtaMsg.Text = "<script type='text/javascript'>alert(' 验证码错误，请重新输入验证码！')</script>";
return;
}
}
}
public static bool DeleteStudentByID(int id)
{
try
{
//获取要删除的学生信息
Student s = StudentServer.SelectStudentByID(id);
ExamDBEntities db = new ExamDBEntities();
//将要删除的学生对象状态，修改为删除。
db.Entry(s).State = EntityState.Deleted;
db.Students.Remove(s);//Remove删除
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public static Student GetStudentById(int id)
{
return(StudentServer.SelectStudentByID(id));
}
public static List <Student> GetAllStudent()
{
return(StudentServer.SelectAllStudent());
}
