SQLServerDAL/ClassroomDAL.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;


using System.Data;
using System.Data.SqlClient;

using CheckOnWork.Model;
using CheckOnWork.IDAL;
using CheckOnWork.DBHelper;
using CheckOnWork.WebConfig;

namespace CheckOnWork.SQLServerDAL
{
    public class ClassroomDAL:DBAccess,IClassroom
    {
        #region 得到所有教室信息
        /// <summary>
        /// 得到所有教室信息
        /// </summary>
        /// <returns></returns>
        public IList<Classroom> ClassroomSelectAll()
        {
            IList<Classroom> list=new List<Classroom>();

            using (SqlDataReader read = ExecuteReader(StoredProcedureName.classroomSelectAll, null))
            {
                while (read.Read())
                {
                    Classroom room = new Classroom(read.GetInt32(0),read.GetString(1),read.GetString(2),read.GetString(3));
                    list.Add(room);
                }
                return list;
            }
        }
        #endregion

        #region 添加教室信息
        /// <summary>
        /// 添加教室信息
        /// </summary>
        /// <param name="classroom"></param>
        /// <returns></returns>
        public int InsertClassroom(Classroom classroom)
        {
            SqlParameter[] param = { 
                                    
                                     new SqlParameter("@classroom",classroom.classroom),
                                      new SqlParameter("@classroomType",classroom.classroomType),
                                       new SqlParameter("@classroomIP",classroom.classroomIP),
                                   };
            if (CheckClassroom(classroom.classroomID))
            {
                return -1;
            }
            else
            return ExecuteNonQuery(StoredProcedureName.classroomInsert,param);
        }