SQLServerDAL/AlertDAL.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 AlertDAL:DBAccess,IAlert
    {

     

       


       
        #region  学生查询自己的出勤统计情况
        /// <summary>
        /// 学生查询自己的出勤统计情况
        /// </summary>
        /// <param name="studentId"></param>
        /// <returns></returns>
        public IList<Alert> GetAlertInfoByStrdentId(string studentId, int annualID, int alert)
        {
            SqlParameter[] param ={
            
                new SqlParameter("@studentID", studentId),
                new SqlParameter("@annualID",annualID),
                new SqlParameter("@alert",alert)
            };
            IList<Alert> list=new List<Alert>();
            

            using (SqlDataReader read = ExecuteReader(StoredProcedureName.getAlertByStudentIdNEW, param))
            {
                while (read.Read())
                {
                   
                    
                    //构造学生统计考勤信息的对象
                    Alert alert2 = new Alert(read.GetInt32(0), read.GetString(1), read.GetInt32(2), read.GetInt32(3), read.GetBoolean(4), read.GetString(5), read.GetString(6), read.GetString(7), read.GetString(8), read.GetInt32(9), read.GetString(10));

                    list.Add(alert2);

                }
                return list;
            }
        }
        #endregion