remittance.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 Remittance : IRemittance
    {
        public bool Add(RemittanceInfo remittanceInfo)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@OrderID", DbType.Int32, remittanceInfo.OrderId);
            cmdParams.AddInParameter("@Money", DbType.Decimal, remittanceInfo.Money);
            return DBHelper.ExecuteProc("PR_Shop_Remittance_Add", cmdParams);
        }

        public RemittanceInfo GetByOrderId(int orderId)
        {
            Database database = DatabaseFactory.CreateDatabase();
            DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Shop_Remittance_GetByOrderId");
            database.AddInParameter(storedProcCommand, "OrderId", DbType.Int32, orderId);
            using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
            {
                if (reader.Read())
                {
                    RemittanceInfo info = new RemittanceInfo();
                    info.OrderId = reader.GetInt32("OrderID");
                    info.ClientId = reader.GetInt32("ClientID");
                    info.UserName = reader.GetString("UserName");
                    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 RemittanceInfo(true);
            }
        }
    }
}