SQLServerDAL/AlertSetDAL.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 AlertSetDAL:DBAccess,IAlertSet
    {
        #region 更新设置表
        /// <summary>
        /// 更新设置表，
        /// </summary>
        /// <param name="alertSet"></param>
        /// <returns></returns>
        public int AlertSetUpdate(AlertSet alertSet)
        {
            SqlParameter[] param = { 
                                   new SqlParameter("@ID",alertSet.ID),
                                   new SqlParameter("@UserID",alertSet.UserID),
                                   new SqlParameter("@alertType",alertSet.alertType),
                                   new SqlParameter("@alertNum",alertSet.alertNum),
                                   new SqlParameter("@role",alertSet.role),
                                   new SqlParameter("@courseID",alertSet.courseID),
                                   new SqlParameter("@annualID",alertSet.annualID)
                                   };
            return ExecuteNonQuery(StoredProcedureName.alertSetUpdeate,param);
        }
        #endregion  

        /// <summary>
        /// 根据类型查询预警线，True为单科FALSE为累计
        /// </summary>
        /// <param name="type"></param>
        /// <returns></returns>
        public int AlertGetNumByType(bool type)
        {
            SqlParameter param = new SqlParameter("@alertType", type);
            int AlertLine=-1;

            using (SqlDataReader read = ExecuteReader(StoredProcedureName.alertSetGetNumByType, param))
            {
                if (read.Read())
                {
                    AlertLine = read.GetInt32(0);
                }

                return AlertLine;
            }
        }