departmentm.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 DepartmentM
/// </summary>
public class DepartmentM
{
	public DepartmentM()
	{
	}
    /// <summary>
    /// 获取所有的部门信息
    /// </summary>
    /// <returns>部门信息表</returns>
    public Table<Department> GetDepartments()
    {
        //创建数据上下文
        DataClassesDataContext db = new DataClassesDataContext();
        Table<Department> deps;
        try
        {
            //获取所有的部门集合
            deps = db.Departments;
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }

        ///返回从数据库获取的结果
        return (deps);
    }
    /// <summary>
    /// 根据部门ID所有部门信息
    /// </summary>
    /// <param name="nDepartmentID">部门的ID</param>
    /// <returns>一个部门对象</returns>
    public Department GetSingleDepartment(int nDepartmentID)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        Department dep;
        try
        {
            //使用LINQ表达式获取符合条件的对象
            dep = db.Departments.Where(d => d.DepartmentID == nDepartmentID).First();
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }

        ///返回从数据库获取的结果
        return (dep);
    }
    /// <summary>
    /// 添加新部门
    /// </summary>
    public void AddDepartment(string sName,string sDesn,string sPhone,int nParentID,string sRemark)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        try
        {
            //创建新部门对象
            Department dep = new Department { Desn = sDesn, Body = sBody, };
            //提交更改
            db.Departments.InsertOnSubmit(dep);
            db.SubmitChanges();
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }
    }
    /// <summary>
    /// 更新部门信息
    /// </summary>
    /// <param name="nDepartmentID">所要更新的部门ID</param>
    /// <param name="sDesn">部门名称</param>
    /// <param name="sBody">备注</param>
    public void UpdateDepartment(int nDepartmentID, string sDesn, string sBody)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        try
        {
            //找到指定ID的部门
            Department dep=db.Departments.Where(d=>d.DepartmentID == nDepartmentID).First();
            //从数据库和上下文中删除
            dep.Desn = sDesn;
            dep.Body = sBody;
            db.SubmitChanges();
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }
    }
    /// <summary>
    /// 删除指定的部门
    /// </summary>
    /// <param name="nDepartmentID">部门ID</param>
    public void DeleteDepartment(int nDepartmentID)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        try
        {
            //获取要删除的部门对象
            Department dep = db.Departments.Where(d => d.DepartmentID == nDepartmentID).First();
            //从数据库和上下文中删除
            db.Departments.DeleteOnSubmit(dep);
            db.SubmitChanges();

        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }
    }
}