DAL/ClassDAL.cs

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

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

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


namespace DAL
{  
   
    public   class ClassDAL
    {
        #region //获取表
        public DataTable GetClass(string cdeptno)
        {
            string classsql = "select * from class where cdeptno='" + cdeptno + "'";
            try
            {
                SqlConnection conn = DBHelper.Connection;
                if (DBHelper.GetTable(classsql).Rows.Count > 0)
                {
                    return DBHelper.GetTable(classsql);
                }
                else
                    return null;
            }
            catch (Exception e)
            {

                throw e;
            }
        }
        #endregion
        #region //查找班号
       public Class ClassCheck(string cNo)
        {
            string strSql = "select cName,cNo,cdeptNo from Class where cNo='" + cNo + "'";
            SqlConnection conn = DBHelper.Connection;
            DataTable dt = DBHelper.GetTable(strSql);
            Class model = new Class ();
            if (dt.Rows.Count > 0)
            {
                model.CName  = dt.Rows[0]["cName"].ToString();
                model.CNo = dt.Rows[0]["cNo"].ToString();
                model.CdeptNo  = dt.Rows[0]["cdeptNo"].ToString();
                return model;
            }

            return null;
        }
        #endregion
        #region//添加班级
       public bool ClassADD(Class cla)
       {
           string classAddSql = "insert into Class values('" + cla.CName + "','" + cla.CNo + "','" + cla.CdeptNo  + "')";
           try
           {