public RechargeDTO ToDTO(RechargeEntity recharge)
{
RechargeDTO reDTO = new RechargeDTO();
reDTO.ID = recharge.ID;
reDTO.UserID = recharge.UserID;
reDTO.RechargeableMoney = recharge.RechargeableMoney;
reDTO.AgentID = recharge.AgentID;
reDTO.YuAmount = recharge.YuAmount;
reDTO.Flag = recharge.Flag;
reDTO.RechargeDate = recharge.RechargeDate;
reDTO.Recharge001 = recharge.Recharge001;
reDTO.Recharge002 = recharge.Recharge002;
reDTO.Recharge003 = recharge.Recharge003;
reDTO.Recharge004 = recharge.Recharge004;
reDTO.Recharge005 = recharge.Recharge005;
reDTO.Recharge006 = recharge.Recharge006;
reDTO.UserCode = recharge.Users.UserCode;
reDTO.TrueName = recharge.Users.TrueName;
reDTO.CurrencyName = recharge.CurrencyNames.CurrencyName;
reDTO.CurrencyNameEn = recharge.CurrencyNames.CurrencyNameEn;
reDTO.StyleName = recharge.RechargeStyle == 1 ? "增加" : "减少";
return(reDTO);
}
private void Recharge(CustomerDto dto, UserType roleId)
{
var r = new RechargeEntity
{
UserId = dto.Id,
Value = _configuration.GetValue("giftNumber", 20),
Money = 0,
Bank = 0,
RechargeMode = 0,
SalesMan = dto.SalesMan,
OperatorId = dto.Operator,
CreateDate = DateTime.Now,
Remark = "赠送"
};
var id = _rechangeRepository.InsertAndGetId(r);
var orgId = _staffRepository.GetOrgId(dto.SalesMan).OrgId;
var dataInOrg = new DataInOrgEntity
{
DataId = id.ToString(),
DataType = (int)DataType.Recharge,
OrgId = orgId,
RoleId = ((int)roleId).ToString()
};
_dataInOrgRepository.Inserts(dataInOrg);
}
/// <summary>
/// 添加后台充值记录
/// </summary>
/// <param name="UserID"></param>
/// <param name="Amount"></param>
/// <param name="YuAmount"></param>
/// <param name="RechargeType"></param>
/// <param name="RechargeStyle"></param>
/// <returns></returns>
public long Add(long UserID, decimal Amount, decimal YuAmount, int RechargeType, int RechargeStyle)
{
using (MyDbContext dbcontext = new MyDbContext())
{
RechargeEntity rechargeModel = new RechargeEntity();
rechargeModel.UserID = UserID;
rechargeModel.RechargeableMoney = Amount;
rechargeModel.RechargeDate = DateTime.Now;
rechargeModel.YuAmount = YuAmount;
rechargeModel.RechargeType = RechargeType;
rechargeModel.RechargeStyle = RechargeStyle;
rechargeModel.Flag = 1;
dbcontext.Recharge.Add(rechargeModel);
dbcontext.SaveChanges();
return(rechargeModel.ID);
}
}
public int AddRecharge(RechargeEntity recharge)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tbrecharge (recharge_name,recharge_price,recharge_time,agent_id,vip_id)");
strSql.Append("values");
strSql.Append("(@RechargeName,@RechargePrice,@RechargeTime,@AgentID,@VipID)");
strSql.Append(";SELECT @@IDENTITY");
SqlParameter[] paras =
{
new SqlParameter("@RechargeName", recharge.RechargeName),
new SqlParameter("@RechargePrice", recharge.RechargePrice),
new SqlParameter("@RechargeTime", recharge.RechargeTime),
new SqlParameter("@AgentID", recharge.AgentID),
new SqlParameter("@VipID", recharge.VipID)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.connStr, CommandType.Text, strSql.ToString(), paras)));
}
private RechargeDTO ToDTO(RechargeEntity entity)
{
RechargeDTO dto = new RechargeDTO();
dto.CreateTime = entity.CreateTime;
dto.Id = entity.Id;
dto.UserID = entity.UserId;
dto.UserCode = entity.User.Mobile;
dto.RechargeableMoney = entity.RechargeableMoney;
dto.YuAmount = entity.YuAmount;
dto.Flag = entity.Flag;
dto.RechargeStyle = entity.RechargeStyle;
dto.RechargeDate = entity.RechargeDate;
dto.RechargeStyleName = entity.RechargeStyle == 1 ? "A积分" : entity.RechargeStyle == 2 ? "B积分" : entity.RechargeStyle == 3 ? "锁仓积分" :"";
dto.RechargeTypeName = entity.RechargeType == 1 ? "增加" : "减少";
dto.Recharge001Name = entity.Recharge001 == 0 ? "后台充值" : "";
dto.FlagName = entity.Flag == 1 ? "成功" : "失败";
return(dto);
}
/// <summary>
///
/// </summary>
/// <param name="userId"></param>
/// <param name="currencyType">积分类型，1-A积分，2-B积分，3-锁仓积分</param>
/// <param name="rechargeType">充值方式，1-增加，2-扣除</param>
/// <param name="rechargeableMoney">充值金额</param>
/// <returns></returns>
public async Task <long> AddAsync(long userId, int currencyType, int rechargeType, decimal rechargeableMoney)
{
using (MyDbContext dbc = new MyDbContext())
{
UserEntity user = await dbc.GetAll <UserEntity>().SingleOrDefaultAsync(u => u.Id == userId);
if (user == null)
{
return(-1);
}
//if (user.BonusAmount < rechargeableMoney)
//{
// return -2;
//}
RechargeEntity entity = new RechargeEntity();
entity.UserId = userId;
entity.AgentID = 1;
entity.RechargeStyle = currencyType;
entity.RechargeType = rechargeType;
entity.RechargeableMoney = rechargeableMoney;
entity.Flag = 1;
entity.RechargeDate = DateTime.Now;
entity.Recharge001 = 0;
entity.Recharge002 = 0;
entity.Recharge005 = 0;
entity.Recharge006 = 0;
dbc.Recharges.Add(entity);
int JournalTypeId = 1;
JournalEntity journal = new JournalEntity();
journal.InAmount = rechargeableMoney;
journal.OutAmount = 0;
journal.JournalTypeId = JournalTypeId;
journal.CurrencyType = currencyType;
journal.Remark = "后台充值" + (currencyType == 1 ? "A积分": currencyType == 2 ? "B积分" :currencyType == 3 ? "锁仓积分":"") + "(增加)";
journal.UserId = user.Id;
if (rechargeType == 1)
{
if (currencyType == 1)
{
entity.YuAmount = user.BonusAmount + rechargeableMoney;
journal.BalanceAmount = user.BonusAmount + rechargeableMoney;
user.BonusAmount += rechargeableMoney;
}
else if (currencyType == 2)
{
entity.YuAmount = user.Amount + rechargeableMoney;
journal.BalanceAmount = user.Amount + rechargeableMoney;
user.Amount += rechargeableMoney;
}
else if (currencyType == 3)
{
entity.YuAmount = user.FrozenAmount + rechargeableMoney;
journal.BalanceAmount = user.FrozenAmount + rechargeableMoney;
user.FrozenAmount += rechargeableMoney;
}
}
else if (rechargeType == 2)
{
journal.InAmount = 0;
journal.CurrencyType = currencyType;
journal.OutAmount = rechargeableMoney;
journal.Remark = "后台充值" + currencyType + "(扣除)";
if (currencyType == 1)
{
if (rechargeableMoney > user.BonusAmount)
{
return(-1);
}
entity.YuAmount = user.BonusAmount - rechargeableMoney;
journal.BalanceAmount = user.BonusAmount - rechargeableMoney;
user.BonusAmount -= rechargeableMoney;
}
else if (currencyType == 2)
{
if (rechargeableMoney > user.Amount)
{
return(-1);
}
entity.YuAmount = user.Amount - rechargeableMoney;
journal.BalanceAmount = user.Amount - rechargeableMoney;
user.Amount -= rechargeableMoney;
}
else if (currencyType == 3)
{
if (rechargeableMoney > user.FrozenAmount)
{
return(-1);
}
entity.YuAmount = user.FrozenAmount - rechargeableMoney;
journal.BalanceAmount = user.FrozenAmount - rechargeableMoney;
user.FrozenAmount -= rechargeableMoney;
}
}
dbc.Journals.Add(journal);
await dbc.SaveChangesAsync();
return(entity.Id);
}
}
