SQLServerDAL/ValidTimeDAL.cs

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

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 ValidTimeDAL:DBAccess,IValidTime
    {
        /// <summary>
        /// 得到考勤时间以及每节课的上课时间
        /// </summary>
        /// <returns></returns>
        public ValidTime ValidTimeSelect()
        {
             ValidTime time1=new ValidTime();
            using (SqlDataReader read = ExecuteReader(StoredProcedureName.validTimeSelect, null))
            {
               if(read.Read())
                {
                    ValidTime time = new ValidTime(read.GetInt32(0), read.GetDateTime(1), read.GetDateTime(2), read.GetDateTime(3), read.GetDateTime(4), read.GetDateTime(5), read.GetInt32(6));
                    return time;
                }
               else 
                   return time1;
            }
        }
        /// <summary>
        /// 更新考勤时间以及每节课的上课时间
        /// </summary>
        /// <param name="validtime"></param>
        /// <returns></returns>
        public int ValidTimeUpdate(ValidTime validtime)
        {
            SqlParameter[] param ={
                                    new SqlParameter("@id",validtime.id),
                                     new SqlParameter("@oneTwo",validtime.oneTwo),
                                      new SqlParameter("@threeFour",validtime.threeFour),
                                       new SqlParameter("@fiveSix",validtime.fiveSix),
                                        new SqlParameter("@sevenEight",validtime.sevenEight),
                                        new SqlParameter("@nineTen",validtime.nineTen),
                                         new SqlParameter("@validTime",validtime.validTime)
                                 };
            return ExecuteNonQuery(StoredProcedureName.validTimeUpdate,param);
        }
    }
}