DAL/DormInfoService.cs

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

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

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

namespace Jackone
{
    public class DormInfoService
    {
        /// <summary>
        /// 
        /// </summary>
        /// <param name="dormid"></param>
        /// <returns></returns>
        public static DataTable GetDorm(string dormid)
        {
            string StrSql = @"SELECT * FROM DormInfo
            WHERE dormid=@dormid ";
            List<SqlParameter> Params = new List<SqlParameter>();
            SqlParameter para = new SqlParameter("@dormid", SqlDbType.NVarChar);
            para.Value = dormid;
            Params.Add(para);
            DataTable tb = SqlHelper.QueryTable(CommandType.Text, StrSql, Params.ToArray());

            return tb;
        }

        public static DataTable GetValidDormInfoByInStu(string dormid)
        {
            List<SqlParameter> Params = new List<SqlParameter>();
            string StrSql = @"SELECT * FROM DormInfo
            WHERE dormbednum >innum";
            if (dormid.Trim().Length > 0)
            {
                StrSql = @"SELECT * FROM DormInfo
            WHERE dormbednum >innum AND dormid=@dormid ";


                SqlParameter para = new SqlParameter("@dormid", SqlDbType.NVarChar);
                para.Value = dormid;
                Params.Add(para);
            }

         
            DataTable tb = SqlHelper.QueryTable(CommandType.Text, StrSql, Params.ToArray());

            return tb;
        }

        public static DataTable GetAllDorm()
        {
            string StrSql = @"SELECT * FROM DormInfo
            ";
            DataTable tb = SqlHelper.QueryTable(CommandType.Text, StrSql);

            return tb;
        }