/// <summary>
/// 插入记录
/// </summary>
/// <param name="inviteCode">邀请码</param>
/// <param name="accoundId">被邀请人id</param>
/// /// <param name="type">1:fiiipay 2:fiiipos</param>
public void InsertRecord(InviteRecordIM im)
{
//判断是fiiipos还是fiiipay
//1 插入数据 invite profit两个表 邀请双方都支持插入数据 钱包 流水进行更新
// 判断当前邀请人数到达五十 进行推送。。。。。。。。。。。。
//2 插入数据 invite
if (!(im.Type == (int)SystemPlatform.FiiiPay || im.Type == (int)SystemPlatform.FiiiPOS))
{
throw new ArgumentException("只支持fiiipay和fiiipos邀请");
}
var userAccountDAC = new UserAccountDAC();
var account = userAccountDAC.GetByInvitationCode(im.InvitationCode);
var settingCollection = new MasterSettingDAC().SelectByGroup("InviteReward");
var cryptoCurrencty = new CryptocurrencyDAC().GetByCode("FIII");
var cryptoId = cryptoCurrencty.Id;
if (im.Type == (int)SystemPlatform.FiiiPay)
{
var iDAC = new InviteRecordDAC();
var pfDAC = new ProfitDetailDAC();
var uwComponent = new UserWalletComponent();
var uwDAC = new UserWalletDAC();
var uwsDAC = new UserWalletStatementDAC();
var utDAC = new UserTransactionDAC();
var inviteMoney = decimal.Parse(settingCollection.Where(item => item.Name == "Invite_Reward_Amount").Select(item => item.Value).FirstOrDefault());
var rewardMoney = decimal.Parse(settingCollection.Where(item => item.Name == "Over_People_Count_Reward_Amount").Select(item => item.Value).FirstOrDefault());
var maxCount = decimal.Parse(settingCollection.Where(item => item.Name == "Max_Reward_Amount").Select(item => item.Value).FirstOrDefault());
var orderNo1 = CreateOrderno();
var orderNo2 = CreateOrderno();
var inviteWallet = uwComponent.GetUserWallet(account.Id, cryptoId);
if (inviteWallet == null)
{
inviteWallet = uwComponent.GenerateWallet(account.Id, cryptoId);
}
var beInvitedWallet = uwComponent.GetUserWallet(im.BeInvitedAccountId, cryptoId);
if (beInvitedWallet == null)
{
beInvitedWallet = uwComponent.GenerateWallet(im.BeInvitedAccountId, cryptoId);
}
int inviteId;
long profitId1 = 0; //邀请人奖励ID
long profitId2 = 0; //被邀请人奖励ID
long exProfitId1 = 0; //邀请人额外奖励ID
decimal totalReward = pfDAC.GetTotalReward(account);
int invitedCount = pfDAC.GetInvitedCount(account);
using (var scope = new System.Transactions.TransactionScope(System.Transactions.TransactionScopeOption.Required, new TimeSpan(0, 0, 1, 30)))
{
//插入数据到inviterecord表中
inviteId = iDAC.Insert(new InviteRecord()
{
Type = (InviteType)im.Type, AccountId = im.BeInvitedAccountId, Timestamp = DateTime.UtcNow, InviterCode = im.InvitationCode, InviterAccountId = account.Id
});
if (totalReward < maxCount)
{
profitId1 = pfDAC.Insert(new ProfitDetail()
{
InvitationId = inviteId,
CryptoAmount = inviteMoney,
AccountId = account.Id,
Status = InviteStatusType.IssuedFrozen,
Type = ProfitType.InvitePiiiPay,
OrderNo = orderNo1,
Timestamp = DateTime.UtcNow,
CryptoId = cryptoId
});
utDAC.Insert(new UserTransaction
{
Id = Guid.NewGuid(),
AccountId = account.Id,
CryptoId = cryptoCurrencty.Id,
CryptoCode = cryptoCurrencty.Code,
Type = UserTransactionType.Profit,
DetailId = profitId1.ToString(),
Status = (byte)InviteStatusType.IssuedFrozen,
Timestamp = DateTime.UtcNow,
Amount = inviteMoney,
OrderNo = orderNo1
});
uwDAC.IncreaseFrozen(inviteWallet.Id, inviteMoney);
uwsDAC.Insert(new UserWalletStatement
{
WalletId = inviteWallet.Id,
Action = UserWalletStatementAction.Invite,
Amount = 0,
Balance = inviteWallet.Balance,
FrozenAmount = inviteMoney,
FrozenBalance = inviteWallet.FrozenBalance + inviteMoney,
Timestamp = DateTime.UtcNow
});
// 每当满50人时则可以奖励 采用了插入操作 所以只要满足为49个就可以了
if ((invitedCount + 1) % 50 == 0)
{
var pd50 = new ProfitDetail()
{
InvitationId = inviteId,
CryptoAmount = rewardMoney,
AccountId = account.Id,
Status = InviteStatusType.IssuedFrozen,
Type = ProfitType.Reward,
OrderNo = CreateOrderno(),
Timestamp = DateTime.UtcNow,
CryptoId = cryptoId
};
exProfitId1 = pfDAC.Insert(pd50);
utDAC.Insert(new UserTransaction
{
Id = Guid.NewGuid(),
AccountId = account.Id,
CryptoId = cryptoCurrencty.Id,
CryptoCode = cryptoCurrencty.Code,
Type = UserTransactionType.Profit,
DetailId = exProfitId1.ToString(),
Status = (byte)InviteStatusType.IssuedFrozen,
Timestamp = DateTime.UtcNow,
Amount = rewardMoney,
OrderNo = pd50.OrderNo
});
uwDAC.IncreaseFrozen(inviteWallet.Id, rewardMoney);
uwsDAC.Insert(new UserWalletStatement
{
WalletId = inviteWallet.Id,
Action = UserWalletStatementAction.Invite,
Amount = 0,
Balance = inviteWallet.Balance,
FrozenAmount = rewardMoney,
FrozenBalance = inviteWallet.FrozenBalance + inviteMoney + rewardMoney,
Timestamp = DateTime.UtcNow
});
}
profitId2 = pfDAC.Insert(new ProfitDetail()
{
InvitationId = inviteId,
CryptoAmount = inviteMoney,
AccountId = im.BeInvitedAccountId,
Type = ProfitType.BeInvited,
Status = InviteStatusType.IssuedActive,
OrderNo = orderNo2,
Timestamp = DateTime.UtcNow,
CryptoId = cryptoId
});
utDAC.Insert(new UserTransaction
{
Id = Guid.NewGuid(),
AccountId = im.BeInvitedAccountId,
CryptoId = cryptoCurrencty.Id,
CryptoCode = cryptoCurrencty.Code,
Type = UserTransactionType.Profit,
DetailId = profitId2.ToString(),
Status = (byte)InviteStatusType.IssuedActive,
Timestamp = DateTime.UtcNow,
Amount = inviteMoney,
OrderNo = orderNo2
});
uwDAC.Increase(beInvitedWallet.Id, inviteMoney);
uwsDAC.Insert(new UserWalletStatement
{
WalletId = beInvitedWallet.Id,
Action = UserWalletStatementAction.BeInvite,
Amount = inviteMoney,
Balance = beInvitedWallet.Balance + inviteMoney,
FrozenAmount = 0,
FrozenBalance = beInvitedWallet.FrozenBalance,
Timestamp = DateTime.UtcNow
});
}
scope.Complete();
}
if (!(im.Type == (int)SystemPlatform.FiiiPay || im.Type == (int)SystemPlatform.FiiiPOS))
{
throw new ArgumentException("只支持fiiipay和fiiipos邀请");
}
if (im.Type == (int)SystemPlatform.FiiiPay)
{
UserMSMQ.PubUserInviteSuccessed(profitId2, 0);
}
//else if (im.Type == SystemPlatform.FiiiPOS)
// MerchantMSMQ.PubUserInviteSuccessed(profitId2, 0);
}
//else
//{
// var iDAC = new InviteRecordDAC();
// iDAC.Insert(new InviteRecord() { Type = im.Type, AccountId = im.BeInvitedAccountId, Timestamp = DateTime.UtcNow, InviterCode = im.InvitationCode, InviterAccountId = account.Id });
//}
}
public void DistributeRewards(FiiiPayRewardMessage message, int fiiicoinId)
{
MerchantAccountDAC maDAC = new MerchantAccountDAC();
var merchant = maDAC.GetByUsername(message.Account);
if (merchant == null)
{
throw new CommonException(10000, $"无效的商家名:{message.Account}");
}
InviteRecord invitor = GetInvitor(merchant.Id);
if (invitor == null)
{
throw new CommonException(10000, "没有邀请人");
}
var invitedList = new InviteRecordDAC().GetFiiiPosRecordsByInvitorId(invitor.InviterAccountId, InviteType.Fiiipos);
var rewardRate = GetRewardPercentage(invitedList == null ? 0 : invitedList.Count);
if (rewardRate == 0)
{
throw new CommonException(10000, "没有达到奖励条件");
}
decimal t = (decimal)Math.Pow(10, -8);
long nTotalReward = (long)Math.Floor(message.Reward * rewardRate);
if (nTotalReward == 0)
{
throw new CommonException(10000, "奖励金额为0");
}
decimal rewardAmount = nTotalReward * t;
DateTime dtNow = DateTime.UtcNow;
if (message.CurrentDate > 0)
{
dtNow = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc).AddMilliseconds(message.CurrentDate);
}
var distributeRecord = new RewardDistributeRecords
{
UserAccountId = invitor.InviterAccountId,
MerchantAccountId = merchant.Id,
SN = message.SN,
OriginalReward = message.Reward,
Percentage = rewardRate,
ActualReward = rewardAmount,
Timestamp = dtNow
};
long profitId;
decimal oldBalance = 0;
var invitorWallet = uwDAC.GetByAccountId(invitor.InviterAccountId, fiiicoinId);
using (var scope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(0, 0, 1, 30)))
{
if (invitorWallet == null)
{
invitorWallet = CreateWallet(invitor.InviterAccountId, fiiicoinId, rewardAmount);
}
else
{
oldBalance = invitorWallet.Balance;
uwDAC.Increase(invitorWallet.Id, rewardAmount);
}
var profitDetail = new ProfitDetail
{
InvitationId = invitor.Id,
CryptoAmount = rewardAmount,
AccountId = invitor.InviterAccountId,
Status = InviteStatusType.IssuedActive,
Type = ProfitType.InvitePiiiPos,
OrderNo = CreateOrderno(),
Timestamp = dtNow,
CryptoId = invitorWallet.CryptoId,
CryptoCode = "FIII"
};
profitId = pfDAC.Insert(profitDetail);
uwsDAC.Insert(new UserWalletStatement
{
WalletId = invitorWallet.Id,
Action = UserWalletStatementAction.Reward,
Amount = rewardAmount,
Balance = oldBalance + rewardAmount,
FrozenAmount = 0,
FrozenBalance = invitorWallet.FrozenBalance,
Timestamp = dtNow
});
transDAC.Insert(new UserTransaction
{
AccountId = invitor.InviterAccountId,
Amount = rewardAmount,
CryptoCode = "FIII",
CryptoId = fiiicoinId,
DetailId = profitId.ToString(),
Id = Guid.NewGuid(),
MerchantName = string.Empty,
OrderNo = profitDetail.OrderNo,
Status = 2,
Timestamp = dtNow,
Type = UserTransactionType.Profit
});
distributeRecord.ProfitId = profitId;
rdrDAC.Insert(distributeRecord);
scope.Complete();
}
if (profitId > 0)
{
try
{
MessagePushService.PubUserInviteSuccessed(profitId, 0);
}
catch (Exception ex)
{
throw new CommonException(10000, ex.Message);
}
}
}
public void DistributeRewards(FiiiPayRewardMessage message, DateTime dt)
{
if (fiiicoinId == 0)
{
var fiiicoin = new CryptocurrencyDAC().GetByCode("FIII");
fiiicoinId = fiiicoin.Id;
}
MerchantAccountDAC maDAC = new MerchantAccountDAC();
var merchant = maDAC.GetByUsername(message.Account);
if (merchant == null)
{
throw new CommonException(10000, $"无效的商家名:{message.Account}");
}
InviteRecord invitor = GetInvitor(merchant.Id);
if (invitor == null)
{
throw new CommonException(10000, "没有邀请人");
}
var invitedList = new InviteRecordDAC().GetFiiiPosRecordsByInvitorId(invitor.InviterAccountId, InviteType.Fiiipos);
var rewardRate = GetRewardPercentage(invitedList == null ? 0 : invitedList.Count);
if (rewardRate == 0)
{
throw new CommonException(10000, "没有达到奖励条件");
}
decimal t = (decimal)Math.Pow(10, -8);
long nTotalReward = (long)Math.Floor(message.ActualReward * rewardRate);
if (nTotalReward == 0)
{
throw new CommonException(10000, "奖励金额为0");
}
decimal rewardAmount = nTotalReward * t;
var distributeRecord = new RewardDistributeRecords
{
UserAccountId = invitor.InviterAccountId,
MerchantAccountId = merchant.Id,
SN = message.SN,
OriginalReward = message.ActualReward,
Percentage = rewardRate,
ActualReward = rewardAmount,
Timestamp = dt
};
long profitId = 0;
decimal oldBalance = 0;
var invitorWallet = uwDAC.GetByAccountId(invitor.InviterAccountId, fiiicoinId);
using (var scope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(0, 0, 1, 30)))
{
if (invitorWallet == null)
{
invitorWallet = CreateWallet(invitor.InviterAccountId, fiiicoinId, rewardAmount);
}
else
{
oldBalance = invitorWallet.Balance;
uwDAC.Increase(invitorWallet.Id, rewardAmount);
}
profitId = pfDAC.Insert(new ProfitDetail()
{
InvitationId = invitor.Id,
CryptoAmount = rewardAmount,
AccountId = invitor.InviterAccountId,
Status = InviteStatusType.IssuedActive,
Type = ProfitType.InvitePiiiPos,
OrderNo = CreateOrderno(),
Timestamp = dt,
CryptoId = invitorWallet.CryptoId
});
uwsDAC.Insert(new UserWalletStatement
{
WalletId = invitorWallet.Id,
Action = UserWalletStatementAction.Reward,
Amount = rewardAmount,
Balance = oldBalance + rewardAmount,
FrozenAmount = 0,
FrozenBalance = invitorWallet.FrozenBalance,
Timestamp = dt,
Remark = "System"
});
distributeRecord.ProfitId = profitId;
rdrDAC.Insert(distributeRecord);
new TempDataDAC().MessageComplated(message.Id);
scope.Complete();
}
}
