DAL/DeptDAL.cs

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

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

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


namespace DAL
{
   public  class DeptDAL
    {
       #region //查找系别
       public Dept DeptCheck(string cdeptNo)
       {
           string strSql = "select cdeptNo,cdeptName from Department where cdeptNo='" + cdeptNo  + "'";
           SqlConnection conn = DBHelper.Connection;
           DataTable dt = DBHelper.GetTable(strSql);
           Dept model = new Dept();
           if (dt.Rows.Count > 0)
           {
               model.CdeptNo = dt.Rows[0]["cdeptNo"].ToString();
               model.CdeptName = dt.Rows[0]["cdeptName"].ToString();
             
               return model;
           }

           return null;
       }
       #endregion
       #region//获取系别信息
       public DataTable getDept()
       {
           string DeptDTSql = "select * from department";
           try
           {
               SqlConnection conn = DBHelper.Connection;
               if (DBHelper.GetTable(DeptDTSql).Rows.Count > 0)
               {
                   return DBHelper.GetTable(DeptDTSql);
               }
               else
                   return null;

           }
           catch (Exception ex)
           {
               throw ex;
           }
       }
       #endregion
        #region//添加系别
       public bool  DeptADD(Dept dept)
       {
           string deptAddSql = "insert into Department values('" + dept.CdeptNo  + "','" + dept.CdeptName+ "')";
           try
           {

               if (DBHelper.changeData(deptAddSql) > 0)