Ejemplo n.º 1
0
        /// <summary>
        /// 新增主播提现记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Insert(SysAnchorInfoEntity agentModel, SysAnchorWithdrawalRecordEntity model)
        {
            var result = 0;

            using (var db = GetInstance())
            {
                try
                {
                    db.Ado.BeginTran();
                    //更新主播余额
                    db.Updateable <SysAnchorInfoEntity>().SetColumns(it => new SysAnchorInfoEntity {
                        agentGold = agentModel.agentGold - model.WithdrawalAmount * 10
                    }).Where(it => it.aid == agentModel.aid).ExecuteCommand();
                    model.Status           = 3;
                    model.createTime       = DateTime.Now;
                    model.ModifiedTime     = DateTime.Now;
                    model.Remark           = model.Remark;
                    model.WithdrawalAmount = Math.Truncate(model.WithdrawalAmount * 100) / 100;
                    result = db.Insertable(model).ExecuteCommand();
                    db.Ado.CommitTran();
                }
                catch (Exception ex)
                {
                    db.Ado.RollbackTran();
                    new LogLogic().Write(Level.Error, "新增主播提现记录", ex.Message, ex.StackTrace);
                }
            }
            return(result);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 处理主播提现驳回  把钱返回
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Reject(SysAnchorWithdrawalRecordEntity model, SysAnchorInfoEntity sysAnchorInfoModel)
        {
            var result = 0;

            using (var db = GetInstance())
            {
                try
                {
                    db.Ado.BeginTran();//事务
                    //更新主播余额
                    db.Updateable <SysAnchorInfoEntity>().SetColumns(it => new SysAnchorInfoEntity {
                        agentGold = sysAnchorInfoModel.agentGold + model.WithdrawalAmount * 10
                    }).Where(it => it.aid == sysAnchorInfoModel.aid).ExecuteCommand();
                    result = db.Updateable <SysAnchorWithdrawalRecordEntity>().SetColumns(it => new SysAnchorWithdrawalRecordEntity
                    {
                        Status       = 2,
                        Feedback     = model.Feedback,
                        ModifiedBy   = OperatorProvider.Instance.Current.Account,
                        ModifiedTime = DateTime.Now
                    }).Where(it => it.id == model.id).ExecuteCommand();
                    db.Ado.CommitTran();
                }
                catch (Exception ex)
                {
                    db.Ado.RollbackTran();
                    new LogLogic().Write(Level.Error, "处理主播提现驳回", ex.Message, ex.StackTrace);
                }
                return(result);
            }
        }