/// <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);
