schedulelogaccessor.cs.svn-base

来自「MIED是用于个人帐务管理的小型软件」· SVN-BASE 代码 · 共 55 行

using System.Data;
using DatabaseUtil;
using Mied.BusinessObject;
using Mied.DAL.TableSchema;
using System.Collections;
using System.Data.Common;

namespace Mied.DAL.Accesses
{
    public class ScheduleLogAccessor : AccessorSelect
    {
        public ScheduleLogAccessor(MiedDatabase database)
            : base(database, ScheduleLogSchema.TableName)
        {
        }

        protected override CommandFieldValueList BuildPairList(Entity entity)
        {
            ScheduleLog scheduleLog = (ScheduleLog)entity;
            CommandFieldValueList pairList = new CommandFieldValueList(scheduleLog.ID);
            pairList.Add(ScheduleLogSchema.FieldScheduleID, scheduleLog.ScheduleID);
            pairList.Add(ScheduleLogSchema.FieldIsAuto, scheduleLog.IsAuto);
            pairList.Add(ScheduleLogSchema.FieldTimeStamp, scheduleLog.TimeStamp);
            pairList.Add(ScheduleLogSchema.FieldEnterResult, scheduleLog.EnterResult);
            pairList.Add(ScheduleLogSchema.FieldEmailResult, (int)scheduleLog.EmailResult);
            pairList.Add(ScheduleLogSchema.FieldPrintResult, (int)scheduleLog.PrintResult);
            return pairList;
        }

        protected override Entity ReadEntity(RecordReader reader)
        {
            ScheduleLog log = new ScheduleLog();
            log.ID = reader.GetInt32(ScheduleLogSchema.FieldID);
            log.ScheduleID = reader.GetInt32(ScheduleLogSchema.FieldScheduleID);
            log.IsAuto = reader.GetBoolean(ScheduleLogSchema.FieldIsAuto);
            log.TimeStamp = reader.GetDateTime(ScheduleLogSchema.FieldTimeStamp);
            log.EnterResult = reader.GetBoolean(ScheduleLogSchema.FieldEnterResult);
            log.EmailResult = (ScheduleLog.ScheduleEmailStatusEnum)reader.GetInt32(ScheduleLogSchema.FieldEmailResult);
            log.PrintResult = (ScheduleLog.SchedulePrintStatusEnum)reader.GetInt32(ScheduleLogSchema.FieldPrintResult);
            log.EnteredBillNumber = reader.GetString(ScheduleLogSchema.FieldEnterBillNumber);
            return log;
        }

        protected override IList CreateEntityList()
        {
            return new ScheduleLogList();
        }

        public ScheduleLogList SelectListByScheduleID(int scheduleID)
        {
            return (ScheduleLogList)this.SelectList(ScheduleLogSchema.FieldScheduleID, (int?)scheduleID);
        }
    }
}