paymenttype.cs

动易SiteFactory&#8482 网上商店系统1.0源代码

namespace PowerEasy.SqlServerDal.Shop
{
    using Microsoft.Practices.EnterpriseLibrary.Data;
    using PowerEasy.IDal.Shop;
    using PowerEasy.Model.Shop;
    using PowerEasy.SqlServerDal;
    using System;
    using System.Collections.Generic;
    using System.Data;
    using System.Data.Common;

    public sealed class PaymentType : IPaymentType
    {
        public bool Add(PaymentTypeInfo paymentTypeInfo)
        {
            return DBHelper.ExecuteProc("PR_Shop_PaymentType_Add", GetParameters(paymentTypeInfo));
        }

        public bool Delete(int typeId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@typeId", DbType.Int32, typeId);
            return DBHelper.ExecuteProc("PR_Shop_PaymentType_Delete", cmdParams);
        }

        private static Parameters GetParameters(PaymentTypeInfo paymentTypeInfo)
        {
            Parameters parameters = new Parameters();
            parameters.AddInParameter("@typeName", DbType.String, paymentTypeInfo.TypeName);
            parameters.AddInParameter("@intro", DbType.String, paymentTypeInfo.Intro);
            parameters.AddInParameter("@discount", DbType.Double, paymentTypeInfo.Discount);
            parameters.AddInParameter("@isDefault", DbType.Boolean, paymentTypeInfo.IsDefault);
            parameters.AddInParameter("@isDisabled", DbType.Boolean, paymentTypeInfo.IsDisabled);
            parameters.AddInParameter("@category", DbType.Int32, paymentTypeInfo.Category);
            return parameters;
        }

        public PaymentTypeInfo GetPaymentTypeById(int typeId)
        {
            Database database = DatabaseFactory.CreateDatabase();
            DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Shop_PaymentType_GetById");
            database.AddInParameter(storedProcCommand, "@id", DbType.Int32, typeId);
            using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
            {
                if (reader.Read())
                {
                    return PaymentTypeFromrdr(reader);
                }
                return new PaymentTypeInfo(true);
            }
        }

        public IList<PaymentTypeInfo> GetPaymentTypeList()
        {
            IList<PaymentTypeInfo> list = new List<PaymentTypeInfo>();
            Database database = DatabaseFactory.CreateDatabase();
            DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Shop_PaymentType_GetList");
            using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
            {
                while (reader.Read())
                {
                    list.Add(PaymentTypeFromrdr(reader));
                }
            }
            return list;
        }

        public IList<PaymentTypeInfo> GetPaymentTypeList(int category)
        {
            IList<PaymentTypeInfo> list = new List<PaymentTypeInfo>();
            using (NullableDataReader reader = DBHelper.ExecuteReaderSql("select * from pe_paymentType where category = @category and isDisabled = 0  order by orderId", new Parameters("@category", DbType.Int32, category)))
            {
                while (reader.Read())
                {
                    list.Add(PaymentTypeFromrdr(reader));
                }
            }
            return list;
        }

        public IList<PaymentTypeInfo> GetPaymentTypeListByEnabled()
        {
            IList<PaymentTypeInfo> list = new List<PaymentTypeInfo>();
            using (NullableDataReader reader = DBHelper.ExecuteReaderSql("Select * from PE_PaymentType where IsDisabled=0 order by orderID"))
            {
                while (reader.Read())
                {
                    list.Add(PaymentTypeFromrdr(reader));
                }
            }
            return list;
        }

        private static PaymentTypeInfo PaymentTypeFromrdr(NullableDataReader rdr)
        {
            PaymentTypeInfo info = new PaymentTypeInfo();
            info.TypeId = rdr.GetInt32("TypeId");
            info.TypeName = rdr.GetString("TypeName");
            info.Intro = rdr.GetString("Intro");
            info.Discount = Convert.IsDBNull(rdr["Discount"]) ? 0f : float.Parse(rdr["Discount"].ToString(), (IFormatProvider) null);
            info.IsDefault = rdr.GetBoolean("IsDefault");
            info.IsDisabled = rdr.GetBoolean("IsDisabled");
            info.OrderId = rdr.GetInt32("OrderId");
            info.Category = rdr.GetInt32("Category");
            return info;
        }

        public bool Update(PaymentTypeInfo paymentTypeInfo)
        {
            Parameters cmdParams = GetParameters(paymentTypeInfo);
            cmdParams.AddInParameter("@typeId", DbType.Int32, paymentTypeInfo.TypeId);
            cmdParams.AddInParameter("@orderId", DbType.Int32, paymentTypeInfo.OrderId);
            return DBHelper.ExecuteProc("PR_Shop_PaymentType_Update", cmdParams);
        }
    }
}