DAL/AccDAL.cs

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

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

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

namespace DAL
{
    /// <summary>
    /// 学生住宿信息管理
    /// </summary>
    public class AccDAL
    {
        /// <summary>
        /// 根据学生姓名查询学生住宿信息
        /// </summary>
        /// <param name="stuName"></param>
        /// <returns>返回List</returns>
        public static List<AccModel> GetListByStuName(string stuName)
        {
            List<AccModel> list = new List<AccModel>();
            string sql = string.Format("select * from [t_accInfo] where studentname like {0}", "'%" + stuName + "%'");
            DataTable dt = MsSqlHelper.ExecuteDataSet(sql).Tables[0];
            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    AccModel accInfoModel = new AccModel();
                    accInfoModel.Id = Convert.ToInt32(dt.Rows[i]["Id"].ToString());
                    accInfoModel.Studentclass = dt.Rows[i]["studentclass"].ToString();
                    accInfoModel.Studentid = dt.Rows[i]["studentid"].ToString();
                    accInfoModel.Studentname = dt.Rows[i]["studentname"].ToString();
                    accInfoModel.Buildingno = dt.Rows[i]["buildingno"].ToString();
                    accInfoModel.Dormitoryno = dt.Rows[i]["dormitoryno"].ToString();
                    accInfoModel.Bedno = dt.Rows[i]["bedno"].ToString();
                    accInfoModel.Accdate = dt.Rows[i]["accdate"].ToString();
                    list.Add(accInfoModel);
                }
            }
            return list;
        }
        /// <summary>
        /// 判断学生是否已经安排住宿
        /// </summary>
        /// <param name="stuName"></param>
        /// <param name="stuId"></param>
        /// <param name="stuClass"></param>
        /// <returns>返回true或false</returns>
        public static bool IsExistsStuInfo(string stuName, string stuId, string stuClass)
        {
            bool flag = false;
            string sql = string.Format("select studentclass,studentid from [t_accInfo] where studentname='{0}' and studentid='{1}' and studentclass='{2}'", stuName, stuId, stuClass);
            DataTable dt = MsSqlHelper.ExecuteDataSet(sql).Tables[0];
            if (dt.Rows.Count > 0) { flag = true; }
            return flag;
        }
        /// <summary>