departmentservice.cs

在线考试系统完整版源码(C#&Access) 该考试系统为一同学毕业设计

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
using ExamModel.Auto_Generated_Code;
namespace ExamDAL.Auto_Generated_Code
{
   public static class DepartmentService
    {
       //获取系列表
       public static DataSet GetDepartmentList()
       {
           string sql = "select * from Department";
           return DBHelp.GetDataSet(sql);
       }


       //此方法是在添加科目时，分配相关的Department对象
       public static Department GetDepartmentById(int id)
       {
           string sql = "select * from Department where DepartmentID=@id";
           try
           {
               OleDbDataReader reader = DBHelp.GetReader(sql, new OleDbParameter("@id", id));
               if (reader.Read())
               {
                   Department department = new Department();
                   department.DepartmentID = (int)reader["DepartmentID"];
                   department.DepartmentName = (string)reader["DepartmentName"];
                   reader.Close();
                   return department;
               }
               else
               {
                   reader.Close();
                   return null;

               }
           }
           catch (Exception e)
           {
               Console.WriteLine(e.Message);
               return null;
           }
       }
      //获得所有系别
       public static IList<Department> GetAllDepartment()
       {
           string sql = "select * from Department";
           return GetDepartmentBySql(sql);
       }
       //sql语句方法
       public static IList<Department> GetDepartmentBySql(string safeSql)
       {
           List<Department> list = new List<Department>();
           using (DataSet table = DBHelp.GetDataSet(safeSql))
           {
               foreach (DataRow row in table.Tables[0].Rows)
               {
                   Department dep = new Department();
                   dep.DepartmentID = (int)row["DepartmentID"];
                   dep.DepartmentName = (string)row["DepartmentName"];
                   list.Add(dep);
                   
               }
               return list;

           }
       }

      
    }
}