studentm.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 StudentM
/// </summary>
public class StudentM
{
	public StudentM()
	{
	}
    public Table<Student> GetStudents()
    {
        DataClassesDataContext db = new DataClassesDataContext();
        Table<Student> stus;
        try
        {
            stus = db.Students;
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }

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

    public Student GetSingleStudent(int nStudentID)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        Student stu;
        try
        {
            stu = db.Students.Where(s => s.StudentID == nStudentID).First();
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }

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

    public IList<Student> GetStudentByClass(int nClassID)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        IList<Student> stus;
        try
        {
            stus = db.Students.Where(s => s.ClassID == nClassID).ToList();
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }

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

    public void AddStudent(int nClassID, string sName, int nAge, int nSex, string sAddress,
        string sPhone, DateTime dBirthday, DateTime dEntranceDate, string sNationality,
        string sPolitical, string sNativePlace, string sIdentityCard, int nMarital,
        string sHukou, int nState, string sDesn)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        try
        {
            Student stu = new Student {
                ClassID=nClassID,
                Name=sName,
                Age=nAge,
                Sex=nSex,
                Address=sAddress,
                Phone=sPhone,
                Birthday=dBirthday,
                EntranceDate=dEntranceDate,
                Nationality=sNationality,
                Political=sPolitical,
                NativePlace=sNativePlace,
                IdentityCard=sIdentityCard,
                Marital=nMarital,
                Hukou=sHukou,
                State=nState,
                Desn=sDesn
            };
            db.Students.InsertOnSubmit(stu);
            db.SubmitChanges();
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }
    }

    public void UpdateStudent(int nStudentID, int nClassID, string sName, int nAge, int nSex,
        string sAddress, string sPhone, DateTime dBirthday, DateTime dEntranceDate,
        string sNationality, string sPolitical, string sNativePlace, string sIdentityCard,
        int nMarital, string sHukou, int nState, string sDesn)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        try
        {

            Student stu = db.Students.Where(s => s.StudentID == nStudentID).First();
            stu.ClassID = nClassID;
            stu.Name=sName;
            stu.Age = nAge;
            stu.Sex = nSex;
            stu.Address = sAddress;
            stu.Phone = sPhone;
            stu.Birthday = dBirthday;
            stu.EntranceDate = dEntranceDate;
            stu.Nationality = sNationality;
            stu.Political = sPolitical;
            stu.NativePlace = sNativePlace;
            stu.IdentityCard = sIdentityCard;
            stu.Marital = nMarital;
            stu.Hukou = sHukou;
            stu.State = nState;
            stu.Desn = sDesn;
            db.SubmitChanges();
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }
    }

    public void DeleteStudent(int nStudentID)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        try
        {

            Student stu = db.Students.Where(s => s.StudentID == nStudentID).First();
            db.Students.DeleteOnSubmit(stu);
            db.SubmitChanges();
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }
    }
}