coursem.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.Data.Linq;
using System.Collections.Generic;

/// <summary>
/// Summary description for CourseM
/// </summary>
public class CourseM
{
	public CourseM()
	{
	}
    public Table<Course> GetCourses()
    {
        DataClassesDataContext db = new DataClassesDataContext();
        Table<Course> cous;
        try
        {
            cous = db.Courses;
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }

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

    public Course GetSingleCourse(int nCourseID)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        Course cou;
        try
        {
            cou = db.Courses.Where(c => c.CourseID == nCourseID).First();
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }

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

    public void AddCourse(string sDesn, string sBody, DateTime dStartDate, DateTime dEndDate,
        int nCourseHour, int nTeacherID, DateTime dExamineDate, decimal dTotalMark)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        try
        {
            Course cou = new Course { 
                Desn = sDesn,
                Body = sBody,
                StartDate = dStartDate,
                EndDate = dEndDate, 
                CourseHour = nCourseHour,
                TeacherID = nTeacherID, 
                ExamineDate = dExamineDate, 
                TotalMark = dTotalMark 
            };
            db.Courses.InsertOnSubmit(cou);
            db.SubmitChanges();
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }
    }

    public void UpdateCourse(int nCourseID, string sDesn, string sBody, DateTime dStartDate,
        DateTime dEndDate, int nCourseHour, int nTeacherID, DateTime dExamineDate,
        decimal dTotalMark)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        Course cou;
        try
        {
            cou = db.Courses.Where(c => c.CourseID == nCourseID).First();
            cou.Desn = sDesn;
            cou.Body = sBody;
            cou.StartDate = dStartDate;
            cou.EndDate = dEndDate;
            cou.CourseHour = nCourseHour;
            cou.ExamineDate = dExamineDate;
            cou.TotalMark = dTotalMark;
            db.SubmitChanges();
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
             throw new Exception(ex.Message, ex);
        }
    }

    public void DeleteCourse(int nCourseID)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        try
        {
           Course cou = db.Courses.Where(c => c.CourseID == nCourseID).First();
           db.Courses.DeleteOnSubmit(cou);
           db.SubmitChanges();
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }
    }
}