refund.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.Data;
    using System.Data.Common;

    public class Refund : IRefund
    {
        public bool Add(RefundInfo refundInfo)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@OrderID", DbType.Int32, refundInfo.OrderId);
            cmdParams.AddInParameter("@Money", DbType.Decimal, refundInfo.Money);
            cmdParams.AddInParameter("@HandlingCharge", DbType.Decimal, refundInfo.HandlingCharge);
            cmdParams.AddInParameter("@RefundType", DbType.Int32, refundInfo.RefundType);
            return DBHelper.ExecuteProc("PR_Shop_Refund_Add", cmdParams);
        }

        public RefundInfo GetByOrderId(int orderId)
        {
            Database database = DatabaseFactory.CreateDatabase();
            DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Shop_Refund_GetByOrderId");
            database.AddInParameter(storedProcCommand, "OrderId", DbType.Int32, orderId);
            using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
            {
                if (reader.Read())
                {
                    RefundInfo info = new RefundInfo();
                    info.UserName = reader.GetString("UserName");
                    info.ClientId = reader.GetInt32("ClientID");
                    info.OrderNum = reader.GetString("OrderNum");
                    info.ClientName = reader.GetString("ClientName");
                    info.MoneyTotal = reader.GetDecimal("MoneyTotal");
                    info.MoneyReceipt = reader.GetDecimal("MoneyReceipt");
                    info.Email = reader.GetString("Email");
                    return info;
                }
                return new RefundInfo(true);
            }
        }
    }
}