/// <summary> /// 更新用户会员币并记录日志 /// </summary> /// <param name="customerSysNo">用户编号</param> /// <param name="amount">调整惠源币金额数(正数:增加 负数:减少)</param> /// <param name="model">惠源币日志实体</param> /// <returns></returns> /// <remarks>2013-07-11 黄波 创建</remarks> public override void AdjustExperienceCoin(int customerSysNo, decimal amount, CrExperienceCoinLog model) { using (var context = Context.UseSharedConnection(true)) { context.Insert <Model.CrExperienceCoinLog>("CrExperienceCoinLog", model) .AutoMap(o => o.SysNo) .Execute(); context.Sql("update CrCustomer set ExperienceCoin=ExperienceCoin+@ExperienceCoin where sysno=@sysno") .Parameter("ExperienceCoin", amount) .Parameter("sysno", customerSysNo) .Execute(); } }
/// <summary> /// 调整会员币 /// </summary> /// <param name="customer">会员信息</param> /// <param name="userSysNo">系统用户编号</param> /// <param name="changeType">惠源币变更类型</param> /// <param name="amount">会员币数量(正数:增加;负数:减少)</param> /// <param name="description">变更说明</param> /// <param name="transactionSysNo">事务编号</param> /// <returns>void</returns> /// <remarks>2013-07-10 黄波 创建</remarks> private void UpdateExperienceCoin(CrCustomer customer, int userSysNo, CustomerStatus.惠源币变更类型 changeType, int amount, string description, string transactionSysNo) { var customerSysNo = customer.SysNo; var model = new CrExperienceCoinLog { TransactionSysNo = transactionSysNo, CustomerSysNo = customerSysNo, ChangeDate = DateTime.Now, ChangeDescription = description, ChangeType = (int)changeType, CreatedBy = userSysNo, CreatedDate = DateTime.Now, Surplus = customer.ExperienceCoin + amount, Increased = amount > 0 ? amount : 0, Decreased = amount > 0 ? 0 : amount }; //更新用户会员币 IPointDao.Instance.AdjustExperienceCoin(customerSysNo, amount, model); }
/// <summary> /// 更新用户会员币并记录日志 /// </summary> /// <param name="customerSysNo">用户编号</param> /// <param name="amount">调整会员币金额数(正数:增加 负数:减少)</param> /// <param name="model">会员币日志实体</param> /// <returns>void</returns> /// <remarks>2013-07-11 黄波 创建</remarks> public abstract void AdjustExperienceCoin(int customerSysNo, decimal amount, CrExperienceCoinLog model);
/// <summary> /// 插入惠源币日志 /// </summary> /// <param name="model">惠源币日志详情</param> /// <returns>创建结果</returns> /// <remarks>2013-07-10 黄波 添加</remarks> public abstract bool InsertCrExperienceCoinLogItem(CrExperienceCoinLog model);