SQLServerDAL/AnnualDAL.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 AnnualDAL:DBAccess,IAnnual
    {
        #region 设置本学期信息，添加至学期信息中
        /// <summary>
        /// 设置本学期信息，添加至学期信息中
        /// </summary>
        /// <param name="annual"></param>
        /// <returns></returns>
        public int AnnualInsert(Annual annual)
        {
            SqlParameter[] param = { 
                                   new SqlParameter("@annualName",annual.annualName),
                                   new SqlParameter("@annualStart",annual.annualStart),
                                   new SqlParameter("@annualEnd",annual.annualEnd),
                                   new SqlParameter("@annualWeeks",annual.annualWeeks),
                                   new SqlParameter("@isPresentAnnual",annual.isPresentAnnual)
                                   };
            return ExecuteNonQuery(StoredProcedureName.annualInsert,param);
        }
        #endregion

        #region 删除学期信息
        /// <summary>
        /// 删除学期信息
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public int AnnualDelete(int id)
        {
            SqlParameter param = new SqlParameter("@annulId", id);

            return ExecuteNonQuery(StoredProcedureName.annualDeleteById,param);
        }
        #endregion

        #region 更新学期信息
        /// <summary>
        /// 更新学期信息
        /// </summary>
        /// <param name="annual"></param>
        /// <returns></returns>
        public int AnnualUpdate(Annual annual)
        {
            SqlParameter[] param = { 
                                    new SqlParameter("@annualId", annual.annualID),