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