teacherm.cs

精通网络应用系统开发 光盘 该书是人民邮电出版社出版的

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Collections.Generic;
using System.Data.Linq;
/// <summary>
/// Summary description for TeacherM
/// </summary>
public class TeacherM
{
	public TeacherM()
	{
	}
    public Table<Teacher> GetTeachers()
	{
        //创建数据上下文
        DataClassesDataContext db=new DataClassesDataContext();
        Table<Teacher> teachers;
		try
		{
            teachers = db.Teachers;
		}
		catch (Exception ex)
		{
			///抛出执行数据库异常
			throw new Exception(ex.Message,ex);
		}

		///返回从数据库获取的结果
		return (teachers);
	}
    /// <summary>
    /// 获取指定ID的教师
    /// </summary>
    /// <param name="nTeacherID">教师的ID</param>
    /// <returns>一个教师对象</returns>
	public Teacher GetSingleTeacher(int nTeacherID)
	{
        //创建数据上下文
        DataClassesDataContext db = new DataClassesDataContext();
        Teacher teac;
		try
		{
            //获取符合条件的教师对象
            teac = db.Teachers.Where(t => t.TeacherID == nTeacherID).First();
		}
		catch (Exception ex)
		{
			///抛出执行数据库异常
			throw new Exception(ex.Message,ex);
		}

		///返回从数据库获取的结果
        return (teac);
	}

	public void AddTeacher(string sName,int nAge,string sAddress,string sPhone,DateTime dBirthday,
		DateTime dHireDate,int nDepartmentID)
	{
        DataClassesDataContext db = new DataClassesDataContext();
		try
		{
            //根据参数创建新教师对象
            Teacher teac = new Teacher { 
                Name = sName,
                Age = nAge, 
                Address = sAddress, 
                Phone = sPhone,
                Birthday = dBirthday,
                HireDate = dHireDate, 
                DepartmentID = nDepartmentID
            };
            //添加新对象到数据库
            db.Teachers.InsertOnSubmit(teac);
            db.SubmitChanges();
		}
		catch (Exception ex)
		{
			///抛出执行数据库异常
			throw new Exception(ex.Message,ex);
		}
	}

	public void UpdateTeacher(int nTeacherID,string sName,int nAge,string sAddress,
		string sPhone,DateTime dBirthday,DateTime dHireDate,int nDepartmentID)
	{
        DataClassesDataContext db = new DataClassesDataContext();
		try
		{
            //获取符合条件的教师对象,只取一条
            Teacher teac = db.Teachers.Where(t => t.TeacherID == nTeacherID).First();
            //更新教师信息
            teac.Name = sName;
            teac.Age = nAge;
            teac.Address = sAddress;
            teac.Phone = sPhone;
            teac.Birthday = dBirthday;
            teac.HireDate = dHireDate;
            teac.DepartmentID = nDepartmentID;
            //提交到数据库
            db.SubmitChanges();
		}
		catch (Exception ex)
		{
			///抛出执行数据库异常
			throw new Exception(ex.Message,ex);
		}
	}
    /// <summary>
    /// 删除指定ID的教师
    /// </summary>
    /// <param name="nTeacherID">要删除教师的ID</param>
	public void DeleteTeacher(int nTeacherID)
	{
        DataClassesDataContext db = new DataClassesDataContext();
		try
		{
            //找到要删除的教师对象
            Teacher teac = db.Teachers.Where(t => t.TeacherID == nTeacherID).First();
            //从数据库中删除
            db.Teachers.DeleteOnSubmit(teac);
            db.SubmitChanges();
		}
		catch (Exception ex)
		{
			///抛出执行数据库异常
			throw new Exception(ex.Message,ex);
		}
	}
}