creditcardlogaccessor.cs.svn-base

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

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

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

        public CreditCardLog SelectByPaymentID(int paymentID)
        {
            CreditCardLog log = (CreditCardLog)base.Select(CreditCardLogSchema.FieldPaymentID, paymentID);
            return log;
        }

        protected override System.Collections.IList CreateEntityList()
        {
            return new CreditCardLogList();
        }

        public CreditCardLogList SelectList(string payStatus)
        {
            return (CreditCardLogList)base.SelectList(CreditCardLogSchema.FieldPayStatus, payStatus);
        }

        public CreditCardLogList SelectList(string contactKey,string payStatus)
        {
            return (CreditCardLogList)base.SelectList(CreditCardLogSchema.FieldContactKey, contactKey, CreditCardLogSchema.FieldPayStatus, payStatus);
        }

        public CreditCardLogList SelectList(string contactKey, CreditCardInfo ccInfo)
        {
            CreditCardLogList list = (CreditCardLogList)base.SelectList(CreditCardLogSchema.FieldContactKey, contactKey);
            CreditCardLogList resList = new CreditCardLogList();

            foreach (CreditCardLog ccLog in list)
            {
                CreditCardInfo creditCardInfo = MiedDatabase.Current.CreditCardAccessor.Select(ccLog.CreditCardID.Value);
                if (creditCardInfo.CardType == ccInfo.CardType &&
                    creditCardInfo.CardNumber == ccInfo.CardNumber &&
                    creditCardInfo.ExpirationMonth == ccInfo.ExpirationMonth &&
                    creditCardInfo.ExpirationYear == ccInfo.ExpirationYear &&
                    creditCardInfo.CardHolder == ccInfo.CardHolder &&
                    creditCardInfo.AddressLine1 == ccInfo.AddressLine1 &&
                    creditCardInfo.City == ccInfo.City &&
                    creditCardInfo.State == ccInfo.State &&
                    creditCardInfo.Zip == ccInfo.Zip &&
                    creditCardInfo.Country == ccInfo.Country)

                    resList.Add(ccLog);
            }

            return resList;
        }

        protected override CommandFieldValueList BuildPairList(Entity entity)
        {
            CreditCardLog log = (CreditCardLog)entity;
            CommandFieldValueList list = new CommandFieldValueList(log.ID);
            list.Add(CreditCardLogSchema.FieldPaymentID, log.PaymentID);
            list.Add(CreditCardLogSchema.FieldCreditCardID, log.CreditCardID);
            list.Add(CreditCardLogSchema.FieldOrderNumber, log.OrderNumber);
            list.Add(CreditCardLogSchema.FieldRefundNumber, log.RefundNumber);
            list.Add(CreditCardLogSchema.FieldPayback, log.Payback);
            list.Add(CreditCardLogSchema.FieldPayStatus, log.PayStatus);
            list.Add(CreditCardLogSchema.FieldAuthCode, log.AuthCode);
            list.Add(CreditCardLogSchema.FieldErrMsg, log.ErrMsg);
            list.Add(CreditCardLogSchema.FieldAVSResult, log.AVSResult);
            list.Add(CreditCardLogSchema.FieldCVVResult, log.CVVResult);
            list.Add(CreditCardLogSchema.FieldInterrupt, log.Interrupt);
            list.Add(CreditCardLogSchema.FieldRefNumber, log.RefNumber);
            list.Add(CreditCardLogSchema.FieldSettleDate, log.SettleDate);
            list.Add(CreditCardLogSchema.FieldContactKey, log.ContactKey);
            list.Add(CreditCardLogSchema.FieldAmount, log.Amount);
            return list;
        }

        protected override Entity ReadEntity(RecordReader reader)
        {
            CreditCardLog log = new CreditCardLog();
            log.ID = reader.GetInt32(CreditCardLogSchema.FieldID);
            log.PaymentID = reader.GetInt32(CreditCardLogSchema.FieldPaymentID);
            log.CreditCardID = reader.GetInt32(CreditCardLogSchema.FieldCreditCardID);
            log.OrderNumber = reader.GetString(CreditCardLogSchema.FieldOrderNumber);
            log.RefundNumber = reader.GetString(CreditCardLogSchema.FieldRefundNumber);
            log.Payback = reader.GetDecimal(CreditCardLogSchema.FieldPayback);
            log.PayStatus = reader.GetString(CreditCardLogSchema.FieldPayStatus);
            log.AuthCode = reader.GetString(CreditCardLogSchema.FieldAuthCode);
            log.ErrMsg = reader.GetString(CreditCardLogSchema.FieldErrMsg);
            log.AVSResult = reader.GetString(CreditCardLogSchema.FieldAVSResult);
            log.CVVResult = reader.GetString(CreditCardLogSchema.FieldCVVResult);
            log.Interrupt = reader.GetString(CreditCardLogSchema.FieldInterrupt);
            log.RefNumber = reader.GetString(CreditCardLogSchema.FieldRefNumber);
            log.SettleDate = reader.GetDateTime(CreditCardLogSchema.FieldSettleDate);
            log.ContactKey = reader.GetString(CreditCardLogSchema.FieldContactKey);
            log.Amount = reader.GetDecimal(CreditCardLogSchema.FieldAmount);
            return log;
        }       
    }
}