//修改教师资料
public void Update(string teacherName, string gender, DateTime birthday, string idCard, string university, string specialfield, string diploma, string imagePath, string remark)
{
string newFileName = imagePath;
if (imagePath.Trim().Length > 0)
{
newFileName = teacherName.ToString() + new FileInfo(imagePath).Extension;
}
DataAccess.Teacher objTeacher = new DataAccess.Teacher(teacherName);
objTeacher.Gender = gender;
objTeacher.Birthday = birthday;
objTeacher.IDCard = idCard;
objTeacher.University = university;
objTeacher.Specialfield = specialfield;
objTeacher.Diploma = diploma;
objTeacher.Picture = newFileName;
objTeacher.Remark = remark;
if (objTeacher.Update() > 0)
{
UpdateDataGrid();
//更新图片
if (imagePath.Trim().Length > 0)
{
BusinessRuler.ImageManage.UpdateImageFile(imagePath, newFileName);
}
MessageBox.Show("修改教师资料成功！", "操作成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("更新教师资料失败，请重试！", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
protected static void Copy(DataAccess.Teacher obj, Teacher newObj)
{
newObj.ID = obj.ID;
newObj.SSN = obj.SSN;
newObj.FirstName = obj.FirstName;
newObj.LastName = obj.LastName;
newObj.Active = obj.Active;
}
public static Teacher FromDataAccessObject(DataAccess.Teacher obj)
{
if (obj == null)
{
return(null);
}
Teacher newObj = new Teacher();
ServiceObjects.Teacher.Copy(obj, newObj);
return(newObj);
}
public static Teacher FromDataAccessObject(DataAccess.Teacher obj)
{
if (obj == null)
{
return(null);
}
Teacher newObj = new Teacher();
ServiceObjects.Teacher.Copy(obj, newObj);
newObj.Links.Add(new Link("Courses", LinkType.Courses, RESTUrlUtil.Service.RESTSvc.GetCoursesByTeacherID(newObj.ID, 1)));
return(newObj);
}
//删除教师
public void Delete()
{
string teacherName = this._dgvTeacher.CurrentRow.Cells["TeacherName"].Value.ToString();
DialogResult result = MessageBox.Show("真的要删除教师' " + teacherName + " '吗?\n删除教师资料，将级联删除该教师所授课程记录以及相应课程的成绩记录，确定要继续吗？", "删除确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
DataAccess.Teacher objTeacher = new DataAccess.Teacher(teacherName);
if (objTeacher.Delete() > 0)
{
UpdateDataGrid();
MessageBox.Show("成功删除教师资料!' " + teacherName + " '!", "操作成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("删除操作失败，请重试!", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
public static Teacher CreateInstance(string teacherName)
{
DataAccess.Teacher objTeacher = null;
string strSql = "select * from Teacher where [TeacherName] = @teacherName ";
SqlCommon sqlcomm = new SqlCommon();
SqlDataReader reader = sqlcomm.ExecuteReader(strSql, new SqlParameter("@teacherName", teacherName));
if (reader.Read())
{
objTeacher = new DataAccess.Teacher(teacherName);
objTeacher.Gender = reader["Gender"].ToString();
objTeacher.Birthday = DateTime.Parse(reader["Birthday"].ToString());
objTeacher.IDCard = reader["IDCard"].ToString();
objTeacher.University = reader["University"].ToString();
objTeacher.Diploma = reader["Diploma"].ToString();
objTeacher.Picture = reader["Picture"].ToString();
objTeacher.Remark = reader["Remark"].ToString();
}
reader.Close();
return(objTeacher);
}
private void cboTeacherNames_SelectedIndexChanged(object sender, EventArgs e)
{
DataAccess.Teacher objTeacher = DataAccess.Teacher.CreateInstance(this.cboTeacherNames.SelectedItem.ToString());
if (objTeacher != null)
{
if (objTeacher.Gender.Equals("男"))
{
this.rdoMale.Checked = true;
}
else
{
this.rdoFemale.Checked = true;
}
this.dtpBirthday.Value = objTeacher.Birthday;
this.txtIdCard.Text = objTeacher.IDCard;
this.txtUniversity.Text = objTeacher.University;
this.txtSpecialfield.Text = objTeacher.Specialfield;
FillCboDiploma(objTeacher.Diploma);
this.txtRemark.Text = objTeacher.Remark;
}
}
static partial void PerformPreDeleteLogic(DataAccess.SampleDataContext context, DataAccess.Teacher obj)
{
if (obj.Courses != null)
{
foreach (DataAccess.Course course in obj.Courses)
{
CourseLogic.DeleteCourse(context, course.ID);
}
}
}