Hidistro.SqlDal/Orders/OrderDao.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

namespace Hidistro.SqlDal.Orders
{
    using Hidistro.Core;
    using Hidistro.Core.Entities;
    using Hidistro.Entities;
    using Hidistro.Entities.Members;
    using Hidistro.Entities.Orders;
    using Hidistro.Entities.Promotions;
    using Hidistro.SqlDal.Commodities;
    using Hidistro.SqlDal.Members;
    using Microsoft.Practices.EnterpriseLibrary.Data;
    using System;
    using System.Collections;
    using System.Collections.Generic;
    using System.Data;
    using System.Data.Common;
    using System.Runtime.InteropServices;
    using System.Text;

    public class OrderDao
    {
        private Database database = DatabaseFactory.CreateDatabase();

        public bool AddMemberPointNumber(int PointNumber, OrderInfo orderInfo, DbTransaction dbTran)
        {
            IntegralDetailInfo point = new IntegralDetailInfo {
                IntegralChange = PointNumber,
                IntegralSource = "获取积分-订单号：" + orderInfo.OrderId,
                IntegralSourceType = 1
            };
            string activitiesName = orderInfo.ActivitiesName;
            if (!string.IsNullOrEmpty(activitiesName))
            {
                point.Remark = "活动送积分：" + activitiesName;
            }
            else
            {
                point.Remark = "购物获取积分";
            }
            point.Userid = orderInfo.UserId;
            point.GoToUrl = Globals.ApplicationPath + "/Vshop/MemberOrderDetails.aspx?OrderId=" + orderInfo.OrderId;
            point.IntegralStatus = Convert.ToInt32(IntegralDetailStatus.OrderToIntegral);
            if (!new IntegralDetailDao().AddIntegralDetail(point, dbTran))
            {
                dbTran.Rollback();
                return false;
            }
            return true;
        }

        public bool CheckRefund(string orderId, string Operator, string adminRemark, int refundType, bool accept)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("UPDATE Hishop_Orders SET OrderStatus = @OrderStatus WHERE OrderId = @OrderId;");
            builder.Append(" update Hishop_OrderRefund set Operator=@Operator,AdminRemark=@AdminRemark,HandleStatus=@HandleStatus,HandleTime=@HandleTime where HandleStatus=0 and OrderId = @OrderId;");
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString());
            if (accept)
            {
                this.database.AddInParameter(sqlStringCommand, "OrderStatus", DbType.Int32, 9);
                this.database.AddInParameter(sqlStringCommand, "HandleStatus", DbType.Int32, 1);