paymentdetailaccessor.cs

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

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

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

        protected override CommandFieldValueList BuildPairList(Entity entity)
        {
            PaymentDetail paymentDetail = entity as PaymentDetail;
            CommandFieldValueList pairList = new CommandFieldValueList( paymentDetail.ID);
            pairList.Add(PaymentDetailSchema.FieldPaymentID, paymentDetail.PaymentID);
            pairList.Add(PaymentDetailSchema.FieldBillID, paymentDetail.BillID);
            pairList.Add(PaymentDetailSchema.FieldNumber, paymentDetail.Number);
            pairList.Add(PaymentDetailSchema.FieldPaidAmount, paymentDetail.PaidAmount);
            return pairList;
        }

        protected override Entity ReadEntity(RecordReader reader)
        {
            PaymentDetail detail = new PaymentDetail();

            detail.ID = reader.GetInt32(PaymentDetailSchema.FieldID);
            detail.PaymentID = reader.GetInt32(PaymentDetailSchema.FieldPaymentID);
            detail.BillID = reader.GetInt32Null(PaymentDetailSchema.FieldBillID);
            detail.Number = reader.GetString(PaymentDetailSchema.FieldNumber);
            detail.PaidAmount = reader.GetDecimal(PaymentDetailSchema.FieldPaidAmount);

            return detail;
        }

        public PaymentDetailList SelectAllPaymentDetails(int paymentID)
        {
            return (PaymentDetailList)base.SelectList(PaymentDetailSchema.FieldPaymentID, paymentID);
        }

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