scheduleaccessor.cs.svn-base

MIED是用于个人帐务管理的小型软件

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

namespace Mied.DAL.Accesses
{
    public class ScheduleAccessor : AccessorSelect
    {
        internal ScheduleAccessor(MiedDatabase database)
            : base(database, ScheduleSchema.TableName)
        {
        }

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

        protected override Entity ReadEntity(RecordReader reader)
        {
            Schedule schedule = new Schedule();
            schedule.ID = reader.GetInt32(ScheduleSchema.FieldID);
            schedule.BillID = reader.GetInt32(ScheduleSchema.FieldBillID);
            schedule.EndAfterOccurrences = reader.GetInt32(ScheduleSchema.FieldEndAfterOccurrences);
            schedule.EndByDate = reader.GetDateTime(ScheduleSchema.FieldEndByDate);
            schedule.ScheduleEndingType = (ScheduleEndingTypeEnum)reader.GetInt32(ScheduleSchema.FieldEndingDateType);
            schedule.IsAutomatically = reader.GetBoolean(ScheduleSchema.FieldIsAutomatically);
            schedule.IsEmailing = reader.GetBoolean(ScheduleSchema.FieldIsEmailing);
            schedule.IsPrinting = reader.GetBoolean(ScheduleSchema.FieldIsPrinting);
            schedule.IsRecurring = reader.GetBoolean(ScheduleSchema.FieldIsRecurring);
            schedule.LastNextDueDate = reader.GetDateTime(ScheduleSchema.FieldLastNextDueDate);
            schedule.OnlyOnceDate = reader.GetDateTime(ScheduleSchema.FieldOnlyOnceDate);
            schedule.DaysInAdvance = reader.GetInt32(ScheduleSchema.FieldRemindDays);
            schedule.ScheduleName = reader.GetString(ScheduleSchema.FieldScheduleName);
            schedule.StartingOnDate = reader.GetDateTime(ScheduleSchema.FieldStartingOnDate);
            schedule.Frequency = ScheduleFrequency.FromNumeric(reader.GetInt32(ScheduleSchema.FieldFrequency));
            return schedule;
        }

        protected override CommandFieldValueList BuildPairList(Entity entity)
        {
            Schedule schedule = (Schedule)entity;
            CommandFieldValueList pairList = new CommandFieldValueList(schedule.ID);
            pairList.Add(ScheduleSchema.FieldBillID, schedule.BillID);
            pairList.Add(ScheduleSchema.FieldEndAfterOccurrences, schedule.EndAfterOccurrences);
            pairList.Add(ScheduleSchema.FieldEndByDate, schedule.EndByDate);
            pairList.Add(ScheduleSchema.FieldEndingDateType, (int)schedule.ScheduleEndingType);
            pairList.Add(ScheduleSchema.FieldIsAutomatically, schedule.IsAutomatically);
            pairList.Add(ScheduleSchema.FieldIsEmailing, schedule.IsEmailing);
            pairList.Add(ScheduleSchema.FieldIsPrinting, schedule.IsPrinting);
            pairList.Add(ScheduleSchema.FieldIsRecurring, schedule.IsRecurring);
            pairList.Add(ScheduleSchema.FieldLastNextDueDate, schedule.LastNextDueDate);
            pairList.Add(ScheduleSchema.FieldOnlyOnceDate, schedule.OnlyOnceDate);
            pairList.Add(ScheduleSchema.FieldRemindDays, schedule.DaysInAdvance);
            pairList.Add(ScheduleSchema.FieldScheduleName, schedule.ScheduleName);
            pairList.Add(ScheduleSchema.FieldStartingOnDate, schedule.StartingOnDate);
            pairList.Add(ScheduleSchema.FieldFrequency, schedule.Frequency.ToNumeric());
            return pairList;
        }
    }
}