creditcardaccessor.cs

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

using DatabaseUtil;
using Mied.BusinessObject;
using Mied.DAL.TableSchema;
using Mied.DAL.Internal;

namespace Mied.DAL.Accesses
{
    public class CreditCardAccessor : AccessorBase
    {
        internal CreditCardAccessor(MiedDatabase database)
            : base(database, CreditCardInfoSchema.TableName)
        {
        }

        public new CreditCardInfo Select(int id)
        {
            return (CreditCardInfo)base.Select(id);
        }

        protected override CommandFieldValueList BuildPairList(Entity entity)
        {
            CreditCardInfo creditCard = (CreditCardInfo)entity;
            CommandFieldValueList list = new CommandFieldValueList(creditCard.ID);
            JiaMiAddToList(list, CreditCardInfoSchema.FieldCardType, creditCard.CardType);
            JiaMiAddToList(list, CreditCardInfoSchema.FieldCardNumber, creditCard.CardNumber);
            JiaMiAddToList(list, CreditCardInfoSchema.FieldExpirationMonth, creditCard.ExpirationMonth);
            JiaMiAddToList(list, CreditCardInfoSchema.FieldExpirationYear, creditCard.ExpirationYear);
            JiaMiAddToList(list, CreditCardInfoSchema.FieldCardCode, creditCard.CardCode);
            JiaMiAddToList(list, CreditCardInfoSchema.FieldCardHolder, creditCard.CardHolder);
            JiaMiAddToList(list, CreditCardInfoSchema.FieldAddressLine1, creditCard.AddressLine1);
            JiaMiAddToList(list, CreditCardInfoSchema.FieldAddressLine2, creditCard.AddressLine2);
            JiaMiAddToList(list, CreditCardInfoSchema.FieldCity, creditCard.City);
            JiaMiAddToList(list, CreditCardInfoSchema.FieldState, creditCard.State);
            JiaMiAddToList(list, CreditCardInfoSchema.FieldZip, creditCard.Zip);
            JiaMiAddToList(list, CreditCardInfoSchema.FieldCountry, creditCard.Country);
            return list;
        }

        protected override Entity ReadEntity(RecordReader reader)
        {
            CreditCardInfo creditCard = new CreditCardInfo();
            creditCard.ID = reader.GetInt32(CreditCardInfoSchema.FieldID);
            creditCard.CardType = GetJieMiString(reader, CreditCardInfoSchema.FieldCardType);
            creditCard.CardNumber = GetJieMiString(reader, CreditCardInfoSchema.FieldCardNumber);
            creditCard.ExpirationMonth = GetJieMiString(reader, CreditCardInfoSchema.FieldExpirationMonth);
            creditCard.ExpirationYear = GetJieMiString(reader, CreditCardInfoSchema.FieldExpirationYear);
            creditCard.CardCode = GetJieMiString(reader, CreditCardInfoSchema.FieldCardCode);
            creditCard.CardHolder = GetJieMiString(reader, CreditCardInfoSchema.FieldCardHolder);
            creditCard.AddressLine1 = GetJieMiString(reader, CreditCardInfoSchema.FieldAddressLine1);
            creditCard.AddressLine2 = GetJieMiString(reader, CreditCardInfoSchema.FieldAddressLine2);
            creditCard.City = GetJieMiString(reader, CreditCardInfoSchema.FieldCity);
            creditCard.State = GetJieMiString(reader, CreditCardInfoSchema.FieldState);
            creditCard.Zip = GetJieMiString(reader, CreditCardInfoSchema.FieldZip);
            creditCard.Country = GetJieMiString(reader, CreditCardInfoSchema.FieldCountry);
            return creditCard;
        }

        private static string GetJieMiString(RecordReader reader, string fieldName)
        {
            string strStored = reader.GetString(fieldName);
            return JiaJieMi.JieMiStringToString(strStored);
        }

        private static void JiaMiAddToList(CommandFieldValueList list, string fieldName, string value)
        {
            list.Add(fieldName, JiaJieMi.JiaMiStringToString(value));
        }
    }
}