Ejemplo n.º 1
0
 /// <summary>
 /// 更新用户可用积分并记录日志
 /// </summary>
 /// <param name="customerSysNo">用户编号</param>
 /// <param name="point">积分数</param>
 /// <param name="model">可用积分日志实体</param>
 /// <returns></returns>
 /// <remarks>2013-10-30 黄波 创建</remarks>
 public override void UpdateAvailablePoint(int customerSysNo, int point, CrAvailablePointLog model)
 {
     using (var context = Context.UseSharedConnection(true))
     {
         context.Insert <Model.CrAvailablePointLog>("CrAvailablePointLog", model)
         .AutoMap(o => o.SysNo)
         .Execute();
         context.Sql("update CrCustomer set AvailablePoint=AvailablePoint+@AvailablePoint where sysno=@sysNo")
         .Parameter("AvailablePoint", point)
         .Parameter("sysNo", customerSysNo)
         .Execute();
     }
 }
Ejemplo n.º 2
0
        /// <summary>
        /// 调整可用积分
        /// </summary>
        /// <param name="customer">会员信息</param>
        /// <param name="userSysNo">系统用户编号</param>
        /// <param name="changeType">积分变更类型</param>
        /// <param name="point">积分数量(正数:增加;负数:减少)</param>
        /// <param name="description">变更说明</param>
        /// <param name="transactionSysNo">事务编号</param>
        /// <remarks>2013-10-31 黄波 创建</remarks>
        public void UpdateAvailablePoint(CrCustomer customer, int userSysNo, CustomerStatus.可用积分变更类型 changeType, int point, string description, string transactionSysNo)
        {
            if (string.IsNullOrEmpty(description))
            {
                description = "积分兑换";
            }
            var nowDate = DateTime.Now;
            var crAvailablePointLogmodel = new CrAvailablePointLog
            {
                TransactionSysNo = transactionSysNo,
                CustomerSysNo    = customer.SysNo,
                ChangeDate       = nowDate,
                CreatedBy        = userSysNo,
                CreatedDate      = nowDate,
                Surplus          = customer.AvailablePoint + point,
                PointType        = (int)changeType,
                PointDescription = description,//"积分兑换",
                Increased        = point > 0 ? point : 0,
                Decreased        = point > 0 ? 0 : point
            };

            IPointDao.Instance.UpdateAvailablePoint(customer.SysNo, point, crAvailablePointLogmodel);
        }
Ejemplo n.º 3
0
        /// <summary>
        /// 调整经验积分
        /// </summary>
        /// <param name="customer">会员信息</param>
        /// <param name="userSysNo">系统用户编号</param>
        /// <param name="changeType">经验积分变更类型</param>
        /// <param name="point">积分数量(正数:增加;负数:减少)</param>
        /// <param name="description">变更说明</param>
        /// <param name="transactionSysNo">事务编号</param>
        /// <returns>void</returns>
        /// <remarks>2013-07-10 黄波 创建</remarks>
        private void UpdateExperiencePoint(CrCustomer customer, int userSysNo, CustomerStatus.经验积分变更类型 changeType, int point, string description, string transactionSysNo)
        {
            var customerSysNo             = customer.SysNo;
            var nowDate                   = DateTime.Now;
            var experiencePointCahngeType = (int)changeType;
            var availablePointChangeType  = 0;

            if (experiencePointCahngeType == (int)CustomerStatus.经验积分变更类型.参与活动)
            {
                availablePointChangeType = (int)CustomerStatus.可用积分变更类型.参与活动;
            }
            else if (experiencePointCahngeType == (int)CustomerStatus.经验积分变更类型.过期调整)
            {
                availablePointChangeType = (int)CustomerStatus.可用积分变更类型.过期调整;
            }
            else if (experiencePointCahngeType == (int)CustomerStatus.经验积分变更类型.积分兑换)
            {
                availablePointChangeType = (int)CustomerStatus.可用积分变更类型.积分兑换;
            }
            else if (experiencePointCahngeType == (int)CustomerStatus.经验积分变更类型.交易变更)
            {
                availablePointChangeType = (int)CustomerStatus.可用积分变更类型.交易变更;
            }
            else if (experiencePointCahngeType == (int)CustomerStatus.经验积分变更类型.客服调整)
            {
                availablePointChangeType = (int)CustomerStatus.可用积分变更类型.客服调整;
            }
            else
            {
                availablePointChangeType = (int)CustomerStatus.可用积分变更类型.系统赠送;
            }

            var experiencePointLogmodel = new CrExperiencePointLog
            {
                TransactionSysNo = transactionSysNo,
                CustomerSysNo    = customerSysNo,
                ChangeDate       = nowDate,
                CreatedBy        = userSysNo,
                CreatedDate      = nowDate,
                Surplus          = customer.ExperiencePoint + point,
                PointType        = experiencePointCahngeType,
                PointDescription = description,
                Increased        = point > 0 ? point : 0,
                Decreased        = point > 0 ? 0 : point
            };
            var availablePointLogModel = new CrAvailablePointLog
            {
                TransactionSysNo = transactionSysNo,
                CustomerSysNo    = customerSysNo,
                ChangeDate       = nowDate,
                CreatedBy        = userSysNo,
                CreatedDate      = nowDate,
                Surplus          = customer.AvailablePoint + point,
                PointType        = availablePointChangeType,
                PointDescription = description,
                Increased        = point > 0 ? point : 0,
                Decreased        = point > 0 ? 0 : point
            };

            IPointDao.Instance.AdjustExperiencePoint(customerSysNo, point, experiencePointLogmodel, availablePointLogModel);
        }
Ejemplo n.º 4
0
 /// <summary>
 /// 更新用户可用积分
 /// </summary>
 /// <param name="customerSysNo">用户编号</param>
 /// <param name="point">积分数(正数:增加 负数:减少)</param>
 /// <param name="model">可用积分日志实体</param>
 /// <returns>void</returns>
 /// <remarks>2013-10-30 黄波 创建</remarks>
 public abstract void UpdateAvailablePoint(int customerSysNo, int point, CrAvailablePointLog model);
Ejemplo n.º 5
0
 /// <summary>
 /// 更新用户经验积分并记录日志
 /// </summary>
 /// <param name="customerSysNo">用户编号</param>
 /// <param name="point">调整经验积分数(正数:增加 负数:减少)</param>
 /// <param name="experiencePointLogModel">经验积分日志实体</param>
 /// <param name="availablePointLogModel">可用积分日志实体</param>
 /// <returns>void</returns>
 /// <remarks>2013-07-11 黄波 创建</remarks>
 public abstract void AdjustExperiencePoint(int customerSysNo, int point, CrExperiencePointLog experiencePointLogModel, CrAvailablePointLog availablePointLogModel);