DAL/CourseDAL.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using Model;


namespace DAL
{
   public  class CourseDAL
   {
       #region//查询课程
       public bool CourseCheck(string curno)
       {
           string strSql = "select * from Course where curNo='" + curno + "'";
           SqlConnection conn = DBHelper.Connection;
           DataTable dt = DBHelper.GetTable(strSql);
           if (dt.Rows.Count > 0)
           {
               return true;
           }
           return false;
       }
       #endregion
       #region//获取课程
       public DataTable GetCourse()
       {
           string CourseSql = "select * from Course";
           try
           {
               SqlConnection conn = DBHelper.Connection;
               if (DBHelper.GetTable(CourseSql).Rows.Count > 0)
               {
                   return DBHelper.GetTable(CourseSql);
               }
               else
                   return null;

           }
           catch (Exception ex)
           {
               throw ex;
           }
       }
       #endregion
       #region//添加课程
       public bool CourseAdd(Course course)
       {
           string strAddsql = "insert into Course values('" + course.CurNo + "','" + course.CurName + "','" + course.CurCredit + "','" + course.CurPeriod + "','" + course.CurType + "')";
           try
           {

               if (DBHelper.changeData(strAddsql) > 0)
               { return true; }
               else
               {
                   return false;
               }