SourceCode/RFrameGenerate.BLL/Marketing/ActivityDetailManage.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using RFramework.SQLServer;
using RFrameGenerate.BLL.DALExtensions;
using System.Linq.Expressions;
using RFrameGenerate.Model;
using RFrameGenerate.Model.PageModel;
using System.Data.SqlClient;
using System.Data;
using RFrameGenerate.Common;

namespace RFrameGenerate.BLL.Marketing
{
    public class ActivityDetailManage
    {
        #region 逻辑处理

        /// <summary>
        /// 获取已使用优惠券数量
        /// </summary>
        public static int GetUseCoupons(Guid activityGuid)
        {
            if (activityGuid == Guid.Empty) return 0;

            using (var query = Factory.CreateT_SA_ActivityDetail())
            {
                return query.GetCount(m => m.State == DictionaryConst.CouponsState.Used && m.StoreActivityGuid == activityGuid);
            }
        }

        /// <summary>
        /// 获取活动交易额
        /// </summary>
        public static decimal? GetOrderVolume(Guid activityGuid)
        {
            if (activityGuid == Guid.Empty) return null;

            Expression<Func<T_ST_ActivityOrders, bool>> condition = m => m.State == DictionaryConst.CouponsState.Used;

            condition = condition.AndAlso(m => m.OrderState == DictionaryConst.OrderState.Completed);
            condition = condition.AndAlso(m => m.StoreActivityGuid == activityGuid);
            condition = condition.AndAlso(m => m.MerchantGuid == CurrentManage.MerchantGuid);

            return CommonDAL<Model.T_ST_ActivityOrders>.Sum(m => m.TotalMoney, condition);
        }

        /// <summary>
        /// 获取优惠券详情列表
        /// </summary>
        public static List<T_ST_CouponStatistics> GetCouponPageList(GridModel gridModel, Guid activityGuid)
        {
            if (gridModel.recordCount <= 0)
            {
                gridModel.recordCount = GetCouponCount(activityGuid);
            }

            int start = (gridModel.page - 1) * gridModel.rows;