CourseDAL/SourceService.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using Course.Models;
using System.Data.SqlClient;
using System.Data;

namespace Course.DAL
{
    public class SourceService
    {
        /// <summary>
        /// 获取所有教室或者机房信息
        /// </summary>
        /// <param name="type">0为教室 1 为机房</param>
        /// <returns></returns>
        public List<Source> GetSourceRoom(int type)
        {
            List<Source> sourceList = new List<Source>();
            using (SqlConnection conn = new SqlConnection(DBHelper.conStr))
            {
                SqlCommand cmd = new SqlCommand("usp_GetAllClassRoomOrMachineRoom", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@type", SqlDbType.Int).Value = type;
                conn.Open();
                using (SqlDataReader objReader = cmd.ExecuteReader())
                {
                    Source source = null;
                    string name = string.Empty;
                    while (objReader.Read())
                    {
                        source = new Source();
                        source.SourceId = Convert.ToInt32(objReader[0].ToString());
                        name = objReader[1].ToString();
                        source.SourceName = name;
                        sourceList.Add(source);
                    }
                    objReader.Close();
                }
            }
            return sourceList;
        }
        
        /// <summary>
        /// 获取教室名称或机房名称
        /// </summary>
        /// <param name="className"></param>
        /// <param name="storeName"></param>
        /// <returns></returns>
        public string GetClassRoomNameOrMachineRoomNameByClassName(string className, string storeName)
        {
            string RoomName = string.Empty;
            using (SqlConnection conn = new SqlConnection(DBHelper.conStr))
            {
                SqlCommand cmd = new SqlCommand(storeName, conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@className", SqlDbType.NVarChar).Value = className;
                conn.Open();
                RoomName = cmd.ExecuteScalar().ToString();
            }