/// <summary>
/// 计算购卡分润
/// </summary>
public void CalculateSalesVipCardOrderJob()
{
var numCount = 50;
var customerIDs = CustomerBLL.Instance.GetCustomerList();
foreach (var customer in customerIDs)
{
string connString = customer.Value;
var count = RedisOpenAPI.Instance.CCSalesCardOrder().GetSalesCardOrderLength(new CC_Order
{
CustomerID = customer.Key
});
if (count.Code != ResponseCode.Success)
{
BaseService.WriteLog("从redis获取vipcard订单数据失败");
continue;
}
if (count.Result <= 0)
{
continue;
}
if (count.Result < numCount)
{
numCount = Convert.ToInt32(count.Result);
}
//DataTable dtAmountDetail = CreateTableAmountDetail();
//DataTable dtAmount = CreateTableAmount();
//DataTable dtSplitProfitRecord = CreateTableSplitProfitRecord();
for (var i = 0; i < numCount; i++)
{
var response = RedisOpenAPI.Instance.CCSalesCardOrder().GetSalesCardOrder(new CC_Order
{
CustomerID = customer.Key
});
if (response.Code == ResponseCode.Success)
{
var orderInfo = response.Result.OrderInfo.JsonDeserialize <T_InoutEntity>();
var loggingSessionInfo = CustomerBLL.Instance.GetBSLoggingSession(customer.Key, "RedisSystem");
T_InoutBLL inoutBLL = new T_InoutBLL(loggingSessionInfo);
if (orderInfo != null)
{
VipBLL bllVip = new VipBLL(loggingSessionInfo);
T_Inout_DetailBLL bllInoutDetail = new T_Inout_DetailBLL(loggingSessionInfo);
T_VirtualItemTypeSettingBLL bllVirtualItemTypeSetting = new T_VirtualItemTypeSettingBLL(loggingSessionInfo);
VipCardUpgradeRuleBLL bllVipCardUpgradeRule = new VipCardUpgradeRuleBLL(loggingSessionInfo);
VipAmountBLL bllVipAmount = new VipAmountBLL(loggingSessionInfo);
VipAmountDetailBLL bllVipAmountDetail = new VipAmountDetailBLL(loggingSessionInfo);
T_SplitProfitRecordBLL bllSplitProfitRecord = new T_SplitProfitRecordBLL(loggingSessionInfo);
VipAmountEntity entityVipAmount = new VipAmountEntity();
VipAmountDetailEntity entityVipAmountDetail = new VipAmountDetailEntity();
T_SplitProfitRecordEntity entitySplitProfitRecord = new T_SplitProfitRecordEntity();
DataSet dsVipCardLevel = bllVip.GetVipCardLevel(orderInfo.vip_no, loggingSessionInfo.ClientID);
var entityInoutDetail = bllInoutDetail.QueryByEntity(new T_Inout_DetailEntity()
{
order_id = orderInfo.order_id
}, null).FirstOrDefault();
if (entityInoutDetail == null)
{
continue;
}
var vipCardType = bllVirtualItemTypeSetting.QueryByEntity(new T_VirtualItemTypeSettingEntity()
{
SkuId = entityInoutDetail.sku_id, IsDelete = 0
}, null).FirstOrDefault();
if (vipCardType != null)
{
int intVipCardTypeID = Convert.ToInt32(vipCardType.ObjecetTypeId);
var entityVipCardUpgradeRule = bllVipCardUpgradeRule.QueryByEntity(new VipCardUpgradeRuleEntity()
{
VipCardTypeID = intVipCardTypeID, IsPurchaseUpgrade = 1, IsDelete = 0
}, null).SingleOrDefault();
if (entityVipCardUpgradeRule != null)
{
VipCardProfitRuleBLL bllVipCardProfitRule = new VipCardProfitRuleBLL(loggingSessionInfo);
var entityVipCardProfitRule = bllVipCardProfitRule.QueryByEntity(new VipCardProfitRuleEntity()
{
VipCardTypeID = intVipCardTypeID, IsDelete = 0
}, null);
foreach (var ProfitRule in entityVipCardProfitRule)
{
if (ProfitRule.IsApplyAllUnits == 0)
{
VipCardProfitRuleUnitMappingBLL bllVipCardProfitRuleUnitMapping = new VipCardProfitRuleUnitMappingBLL(loggingSessionInfo);
var vipCardProfitRuleUnitMapping = bllVipCardProfitRuleUnitMapping.QueryByEntity(new VipCardProfitRuleUnitMappingEntity()
{
CardBuyToProfitRuleId = ProfitRule.CardBuyToProfitRuleId, UnitID = orderInfo.sales_unit_id, IsDelete = 0, CustomerID = loggingSessionInfo.ClientID
}, null).SingleOrDefault();
if (vipCardProfitRuleUnitMapping == null)
{
continue;
}
}
decimal amount = 0;
string strAmountSourceId = string.Empty;
string strVipId = string.Empty;
string strUserType = string.Empty;
if (ProfitRule.ProfitOwner == "Employee")
{
strAmountSourceId = "37";
strVipId = orderInfo.sales_user;
strUserType = "User";
}
if (ProfitRule.ProfitOwner == "Unit")
{
strAmountSourceId = "40";
strVipId = orderInfo.sales_unit_id;
strUserType = "Unit";
}
amount = (decimal)ProfitRule.FirstCardSalesProfitPct * (decimal)orderInfo.actual_amount * (decimal)0.01;
var vipAmountDetail = bllVipAmountDetail.QueryByEntity(new VipAmountDetailEntity()
{
ObjectId = orderInfo.order_id, AmountSourceId = strAmountSourceId
}, null);
if (vipAmountDetail != null && vipAmountDetail.Length > 0)
{
continue;
}
if (amount > 0)
{
IDbTransaction tran = new JIT.CPOS.BS.DataAccess.Base.TransactionHelper(loggingSessionInfo).CreateTransaction();
try {
// DataRow dr_SplitProfitRecord = dtSplitProfitRecord.NewRow();
// dr_SplitProfitRecord["Id"] = Guid.NewGuid();
// dr_SplitProfitRecord["SourceType"] = "Amount";
// dr_SplitProfitRecord["SourceId"] = strAmountSourceId;
// dr_SplitProfitRecord["ObjectId"] = orderInfo.order_id;
//dr_SplitProfitRecord["UserType"] = strUserType;
// dr_SplitProfitRecord["UserId"] = orderInfo.sales_user;
// dr_SplitProfitRecord["SplitAmount"] = amount;
// dr_SplitProfitRecord["SplitSattus"] = "10";
// dr_SplitProfitRecord["CustomerId"] = loggingSessionInfo.ClientID;
// dr_SplitProfitRecord["CreateTime"] = DateTime.Now;
// dr_SplitProfitRecord["CreateBy"] = loggingSessionInfo.ClientID;
// dr_SplitProfitRecord["LastUpdateTime"] = DateTime.Now;
// dr_SplitProfitRecord["LastUpdateBy"] = loggingSessionInfo.ClientID;
// dr_SplitProfitRecord["IsDelete"] = 0;
// dtSplitProfitRecord.Rows.Add(dr_SplitProfitRecord);
// DataRow dr_AmountDetail = dtAmountDetail.NewRow();
// dr_AmountDetail["VipAmountDetailId"] = Guid.NewGuid();
//dr_AmountDetail["VipId"] = strVipId;
// dr_AmountDetail["VipCardCode"] = "";
// dr_AmountDetail["UnitID"] = "";
// dr_AmountDetail["UnitName"] = "";
// dr_AmountDetail["SalesAmount"] = 0;
// dr_AmountDetail["Amount"] = amount;
// dr_AmountDetail["UsedReturnAmount"] = 0;
// dr_AmountDetail["Reason"] = "首次售卡分润";
// dr_AmountDetail["EffectiveDate"] = DateTime.Now;
// dr_AmountDetail["DeadlineDate"] = Convert.ToDateTime("9999-12-31 23:59:59");
// dr_AmountDetail["AmountSourceId"] = strAmountSourceId;
// dr_AmountDetail["ObjectId"] = orderInfo.order_id;
// dr_AmountDetail["Remark"] = "首次售卡分润";
// dr_AmountDetail["IsValid"] = 0;
// dr_AmountDetail["IsWithdrawCash"] = 0;
// dr_AmountDetail["CustomerID"] = loggingSessionInfo.ClientID;
// dr_AmountDetail["CreateTime"] = DateTime.Now;
// dr_AmountDetail["CreateBy"] = loggingSessionInfo.ClientID;
// dr_AmountDetail["LastUpdateBy"] = loggingSessionInfo.ClientID;
// dr_AmountDetail["LastUpdateTime"] = DateTime.Now;
// dr_AmountDetail["IsDelete"] = 0;
// //dr_AmountDetail["IsCalculated"] = 1;
// dtAmountDetail.Rows.Add(dr_AmountDetail);
entitySplitProfitRecord = new T_SplitProfitRecordEntity()
{
ID = Guid.NewGuid().ToString(),
SourceType = "Amount",
SourceId = strAmountSourceId,
ObjectId = orderInfo.order_id,
UserType = strUserType,
UserId = orderInfo.sales_user,
SplitAmount = amount,
SplitSattus = "10",
CustomerID = loggingSessionInfo.ClientID
};
bllSplitProfitRecord.Create(entitySplitProfitRecord, tran);
entityVipAmountDetail = new VipAmountDetailEntity {
VipAmountDetailId = Guid.NewGuid(),
VipId = strVipId,
Amount = amount,
UsedReturnAmount = 0,
EffectiveDate = DateTime.Now,
DeadlineDate = Convert.ToDateTime("9999-12-31 23:59:59"),
AmountSourceId = strAmountSourceId,
ObjectId = orderInfo.order_id,
CustomerID = loggingSessionInfo.ClientID,
Reason = "首次售卡分润",
Remark = "首次售卡分润",
IsWithdrawCash = 0
};
bllVipAmountDetail.Create(entityVipAmountDetail, (SqlTransaction)tran);
entityVipAmount = bllVipAmount.QueryByEntity(new VipAmountEntity()
{
VipId = orderInfo.sales_user, IsDelete = 0
}, null).SingleOrDefault();
if (entityVipAmount == null)
{
//DataRow dr_Amount = dtAmount.NewRow();
//dr_Amount["VipId"] = orderInfo.sales_user;
//dr_Amount["VipCardCode"] = "";
//dr_Amount["BeginAmount"] = 0;
//dr_Amount["InAmount"] = amount;
//dr_Amount["OutAmount"] = 0;
//dr_Amount["EndAmount"] = amount;
//dr_Amount["TotalAmount"] = amount;
//dr_Amount["BeginReturnAmount"] = 0;
//dr_Amount["InReturnAmount"] = 0;
//dr_Amount["OutReturnAmount"] = 0;
//dr_Amount["ReturnAmount"] = 0;
//dr_Amount["ImminentInvalidRAmount"] = 0;
//dr_Amount["InvalidReturnAmount"] = 0;
//dr_Amount["ValidReturnAmount"] = 0;
//dr_Amount["TotalReturnAmount"] = 0;
//dr_Amount["PayPassword"] = "";
//dr_Amount["IsLocking"] = 0;
//dr_Amount["CustomerID"] = loggingSessionInfo.ClientID;
//dr_Amount["CreateTime"] = DateTime.Now;
//dr_Amount["CreateBy"] = loggingSessionInfo.ClientID;
//dr_Amount["LastUpdateBy"] = loggingSessionInfo.ClientID;
//dr_Amount["LastUpdateTime"] = DateTime.Now;
//dr_Amount["IsDelete"] = 0;
//dtAmount.Rows.Add(dr_Amount);
entityVipAmount = new VipAmountEntity {
VipId = strVipId,
BeginAmount = 0,
InAmount = amount,
OutAmount = 0,
EndAmount = amount,
TotalAmount = amount,
BeginReturnAmount = 0,
InReturnAmount = 0,
OutReturnAmount = 0,
ReturnAmount = 0,
ImminentInvalidRAmount = 0,
InvalidReturnAmount = 0,
ValidReturnAmount = 0,
TotalReturnAmount = 0,
IsLocking = 0,
CustomerID = loggingSessionInfo.ClientID,
VipCardCode = ""
};
bllVipAmount.Create(entityVipAmount, tran);
}
else
{
entityVipAmount.InReturnAmount = (entityVipAmount.InReturnAmount == null ? 0 : entityVipAmount.InReturnAmount.Value) + amount;
entityVipAmount.TotalReturnAmount = (entityVipAmount.TotalReturnAmount == null ? 0 : entityVipAmount.TotalReturnAmount.Value) + amount;
entityVipAmount.ValidReturnAmount = (entityVipAmount.ValidReturnAmount == null ? 0 : entityVipAmount.ValidReturnAmount.Value) + amount;
entityVipAmount.ReturnAmount = (entityVipAmount.ReturnAmount == null ? 0 : entityVipAmount.ReturnAmount.Value) + amount;
bllVipAmount.Update(entityVipAmount);
}
tran.Commit();
}
catch (Exception) {
tran.Rollback();
throw;
}
}
}
}
}
}
}
}
//if (dtAmount.Rows.Count > 0)
//{
// Utils.SqlBulkCopy(connString, dtAmount, "VipAmount");
//}
//if (dtAmountDetail.Rows.Count > 0 && dtSplitProfitRecord.Rows.Count > 0)
//{
// Utils.SqlBulkCopy(connString, dtSplitProfitRecord, "T_SplitProfitRecord");
// Utils.SqlBulkCopy(connString, dtAmountDetail, "VipAmountDetail");
//}
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Update(T_SplitProfitRecordEntity pEntity, IDbTransaction pTran)
{
_currentDAO.Update(pEntity, pTran);
}
/// <summary>
/// 计算充值分润
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <param name="rechargeOrderInfo"></param>
public void CalculateRechargeOrder(LoggingSessionInfo loggingSessionInfo, RechargeOrderEntity rechargeOrderInfo)
{
VipCardProfitRuleBLL bllVipCardProfitRule = new VipCardProfitRuleBLL(loggingSessionInfo);
VipCardProfitRuleEntity[] entityVipCardProfitRule = null;
entityVipCardProfitRule = bllVipCardProfitRule.QueryByEntity(new VipCardProfitRuleEntity()
{
VipCardTypeID = rechargeOrderInfo.VipCardTypeId, IsDelete = 0
}, null);
if (entityVipCardProfitRule != null)
{
var bllVipCardGradeChangeLog = new VipCardGradeChangeLogBLL(loggingSessionInfo);
VipAmountBLL bllVipAmount = new VipAmountBLL(loggingSessionInfo);
VipAmountDetailBLL bllVipAmountDetail = new VipAmountDetailBLL(loggingSessionInfo);
VipAmountEntity entityVipAmount = new VipAmountEntity();
string connString = string.Empty;
foreach (var ProfitRule in entityVipCardProfitRule)
{
decimal amount = 0;
string strAmountSourceId = string.Empty;
string strVipId = string.Empty;
string strUserType = string.Empty;
if (ProfitRule.IsApplyAllUnits == 0)
{
VipCardProfitRuleUnitMappingBLL bllVipCardProfitRuleUnitMapping = new VipCardProfitRuleUnitMappingBLL(loggingSessionInfo);
var vipCardProfitRuleUnitMapping = bllVipCardProfitRuleUnitMapping.QueryByEntity(new VipCardProfitRuleUnitMappingEntity()
{
CardBuyToProfitRuleId = ProfitRule.CardBuyToProfitRuleId, UnitID = rechargeOrderInfo.UnitId, IsDelete = 0, CustomerID = loggingSessionInfo.ClientID
}, null).SingleOrDefault();
if (vipCardProfitRuleUnitMapping == null)
{
continue;
}
}
if (ProfitRule.ProfitOwner == "Employee")
{
strAmountSourceId = "38";
strVipId = rechargeOrderInfo.UserId;
strUserType = "User";
}
if (ProfitRule.ProfitOwner == "Unit")
{
strAmountSourceId = "42";
strVipId = rechargeOrderInfo.UnitId;
strUserType = "Unit";
}
var entityVipCardGradeChangeLog = bllVipCardGradeChangeLog.QueryByEntity(new VipCardGradeChangeLogEntity()
{
OrderId = rechargeOrderInfo.OrderID.ToString()
}, null).SingleOrDefault();
if (entityVipCardGradeChangeLog != null)//首充
{
amount = (decimal)ProfitRule.FirstRechargeProfitPct * (decimal)rechargeOrderInfo.ActuallyPaid * (decimal)0.01;
}
else//续充
{
VipCardReRechargeProfitRuleBLL bllVipCardReRechargeProfitRule = new VipCardReRechargeProfitRuleBLL(loggingSessionInfo);
var entityVipCardReRechargeProfitRule = bllVipCardReRechargeProfitRule.QueryByEntity(new VipCardReRechargeProfitRuleEntity()
{
VipCardTypeID = rechargeOrderInfo.VipCardTypeId, IsDelete = 0
}, null);
if (entityVipCardReRechargeProfitRule != null)
{
decimal discount = 0;
foreach (var ReRechargeProfitRule in entityVipCardReRechargeProfitRule)
{
if (ReRechargeProfitRule.ProfitType == "Superposition")
{
discount = ((decimal)rechargeOrderInfo.ActuallyPaid / (decimal)ReRechargeProfitRule.LimitAmount) * (decimal)ReRechargeProfitRule.ProfitPct * (decimal)0.01;
}
if (ReRechargeProfitRule.ProfitType == "Step")
{
if (rechargeOrderInfo.ActuallyPaid >= ReRechargeProfitRule.LimitAmount)
{
discount = (decimal)ReRechargeProfitRule.ProfitPct;
}
}
}
amount = (decimal)rechargeOrderInfo.ActuallyPaid * discount;
}
}
//入库
if (amount > 0)
{
IDbTransaction tran = new DataAccess.Base.TransactionHelper(loggingSessionInfo).CreateTransaction();
VipAmountDetailEntity entityVipAmountDetail = new VipAmountDetailEntity
{
VipAmountDetailId = Guid.NewGuid(),
VipId = strVipId,
Amount = amount,
UsedReturnAmount = 0,
EffectiveDate = DateTime.Now,
DeadlineDate = Convert.ToDateTime("9999-12-31 23:59:59"),
AmountSourceId = strAmountSourceId,
ObjectId = rechargeOrderInfo.OrderID.ToString(),
CustomerID = loggingSessionInfo.ClientID,
Reason = "超级分销商"
};
bllVipAmountDetail.Create(entityVipAmountDetail, (SqlTransaction)tran);
T_SplitProfitRecordBLL bllSplitProfitRecord = new T_SplitProfitRecordBLL(loggingSessionInfo);
T_SplitProfitRecordEntity entitySplitProfitRecord = new T_SplitProfitRecordEntity()
{
ID = Guid.NewGuid().ToString(),
SourceType = "Amount",
SourceId = strAmountSourceId,
ObjectId = rechargeOrderInfo.OrderID.ToString(),
UserType = strUserType,
UserId = rechargeOrderInfo.UserId,
SplitAmount = amount,
SplitSattus = "10",
CustomerID = loggingSessionInfo.ClientID,
IsDelete = 0
};
bllSplitProfitRecord.Create(entitySplitProfitRecord);
entityVipAmount = bllVipAmount.QueryByEntity(new VipAmountEntity()
{
VipId = strVipId, IsDelete = 0, CustomerID = loggingSessionInfo.ClientID
}, null).SingleOrDefault();
if (entityVipAmount == null)
{
entityVipAmount = new VipAmountEntity
{
VipId = strVipId,
BeginAmount = 0,
InAmount = amount,
OutAmount = 0,
EndAmount = amount,
TotalAmount = amount,
BeginReturnAmount = 0,
InReturnAmount = 0,
OutReturnAmount = 0,
ReturnAmount = 0,
ImminentInvalidRAmount = 0,
InvalidReturnAmount = 0,
ValidReturnAmount = 0,
TotalReturnAmount = 0,
IsLocking = 0,
CustomerID = loggingSessionInfo.ClientID,
VipCardCode = ""
};
bllVipAmount.Create(entityVipAmount, tran);
}
else
{
entityVipAmount.InReturnAmount = (entityVipAmount.InReturnAmount == null ? 0 : entityVipAmount.InReturnAmount.Value) + amount;
entityVipAmount.TotalReturnAmount = (entityVipAmount.TotalReturnAmount == null ? 0 : entityVipAmount.TotalReturnAmount.Value) + amount;
entityVipAmount.ValidReturnAmount = (entityVipAmount.ValidReturnAmount == null ? 0 : entityVipAmount.ValidReturnAmount.Value) + amount;
entityVipAmount.ReturnAmount = (entityVipAmount.ReturnAmount == null ? 0 : entityVipAmount.ReturnAmount.Value) + amount;
bllVipAmount.Update(entityVipAmount);
}
}
}
}
}
/// <summary>
/// 创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Create(T_SplitProfitRecordEntity pEntity)
{
_currentDAO.Create(pEntity);
}
/// <summary>
/// 分页根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public PagedQueryResult <T_SplitProfitRecordEntity> PagedQueryByEntity(T_SplitProfitRecordEntity pQueryEntity, OrderBy[] pOrderBys, int pPageSize, int pCurrentPageIndex)
{
return(_currentDAO.PagedQueryByEntity(pQueryEntity, pOrderBys, pPageSize, pCurrentPageIndex));
}
/// <summary>
/// 根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public T_SplitProfitRecordEntity[] QueryByEntity(T_SplitProfitRecordEntity pQueryEntity, OrderBy[] pOrderBys)
{
return(_currentDAO.QueryByEntity(pQueryEntity, pOrderBys));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pEntity"></param>
public void Delete(T_SplitProfitRecordEntity pEntity)
{
_currentDAO.Delete(pEntity);
}
/// <summary>
/// 充值订单循环队列计算
/// </summary>
public void CalculateRechargeOrderJob()
{
var numCount = 50;
var customerIDs = CustomerBLL.Instance.GetCustomerList();
foreach (var customer in customerIDs)
{
string connString = customer.Value;
var count = RedisOpenAPI.Instance.CCRechargeOrder().GetRechargeOrderLength(new CC_Order
{
CustomerID = customer.Key
});
if (count.Code != ResponseCode.Success)
{
BaseService.WriteLog("从redis获取充值订单数据失败");
continue;
}
if (count.Result <= 0)
{
continue;
}
if (count.Result < numCount)
{
numCount = Convert.ToInt32(count.Result);
}
var loggingSessionInfo = CustomerBLL.Instance.GetBSLoggingSession(customer.Key, "RedisSystem");
VipCardProfitRuleBLL bllVipCardProfitRule = new VipCardProfitRuleBLL(loggingSessionInfo);
VipCardProfitRuleEntity[] entityVipCardProfitRule = null;
var bllVipCardGradeChangeLog = new VipCardGradeChangeLogBLL(loggingSessionInfo);
VipAmountBLL bllVipAmount = new VipAmountBLL(loggingSessionInfo);
VipAmountDetailBLL bllVipAmountDetail = new VipAmountDetailBLL(loggingSessionInfo);
T_SplitProfitRecordBLL bllSplitProfitRecord = new T_SplitProfitRecordBLL(loggingSessionInfo);
for (var i = 0; i < numCount; i++)
{
var response = RedisOpenAPI.Instance.CCRechargeOrder().GetRechargeOrder(new CC_Order
{
CustomerID = customer.Key
});
if (response.Code == ResponseCode.Success)
{
var rechargeOrderInfo = response.Result.OrderInfo.JsonDeserialize <RechargeOrderEntity>();
entityVipCardProfitRule = bllVipCardProfitRule.QueryByEntity(new VipCardProfitRuleEntity()
{
VipCardTypeID = rechargeOrderInfo.VipCardTypeId, IsDelete = 0
}, null);
if (entityVipCardProfitRule != null)
{
//DataTable dtAmountDetail = CreateTableAmountDetail();
//DataTable dtAmount = CreateTableAmount();
//DataTable dtSplitProfitRecord = CreateTableSplitProfitRecord();
VipAmountEntity entityVipAmount = new VipAmountEntity();
VipAmountDetailEntity entityVipAmountDetail = new VipAmountDetailEntity();
T_SplitProfitRecordEntity entitySplitProfitRecord = new T_SplitProfitRecordEntity();
foreach (var ProfitRule in entityVipCardProfitRule)
{
decimal amount = 0;
string strAmountSourceId = string.Empty;
string strVipId = string.Empty;
string strUserType = string.Empty;
if (ProfitRule.IsApplyAllUnits == 0)
{
VipCardProfitRuleUnitMappingBLL bllVipCardProfitRuleUnitMapping = new VipCardProfitRuleUnitMappingBLL(loggingSessionInfo);
var vipCardProfitRuleUnitMapping = bllVipCardProfitRuleUnitMapping.QueryByEntity(new VipCardProfitRuleUnitMappingEntity()
{
CardBuyToProfitRuleId = ProfitRule.CardBuyToProfitRuleId, UnitID = rechargeOrderInfo.UnitId, IsDelete = 0, CustomerID = loggingSessionInfo.ClientID
}, null).SingleOrDefault();
if (vipCardProfitRuleUnitMapping == null)
{
continue;
}
}
if (ProfitRule.ProfitOwner == "Employee")
{
strAmountSourceId = "38";
strVipId = rechargeOrderInfo.UserId;
strUserType = "User";
}
if (ProfitRule.ProfitOwner == "Unit")
{
strAmountSourceId = "42";
strVipId = rechargeOrderInfo.UnitId;
strUserType = "Unit";
}
var vipAmountDetail = bllVipAmountDetail.QueryByEntity(new VipAmountDetailEntity()
{
ObjectId = rechargeOrderInfo.OrderID.ToString(), AmountSourceId = strAmountSourceId
}, null);
if (vipAmountDetail != null && vipAmountDetail.Length > 0)
{
continue;
}
if (rechargeOrderInfo.OrderDesc == "Upgrade") //首充
{
amount = (decimal)ProfitRule.FirstRechargeProfitPct * (decimal)rechargeOrderInfo.ActuallyPaid * (decimal)0.01;
}
if (rechargeOrderInfo.OrderDesc == "ReRecharge")//续充
{
VipCardReRechargeProfitRuleBLL bllVipCardReRechargeProfitRule = new VipCardReRechargeProfitRuleBLL(loggingSessionInfo);
var entityVipCardReRechargeProfitRule = bllVipCardReRechargeProfitRule.QueryByEntity(new VipCardReRechargeProfitRuleEntity()
{
VipCardTypeID = rechargeOrderInfo.VipCardTypeId, CardBuyToProfitRuleId = ProfitRule.CardBuyToProfitRuleId, IsDelete = 0
}, null);
if (entityVipCardReRechargeProfitRule != null)
{
decimal discount = 0;
foreach (var ReRechargeProfitRule in entityVipCardReRechargeProfitRule.OrderByDescending(a => a.LimitAmount))
{
if (ReRechargeProfitRule.ProfitType == "Superposition")
{
discount = (decimal)(ReRechargeProfitRule.LimitAmount * ReRechargeProfitRule.ProfitPct) * (decimal)0.01;
amount = (decimal)(rechargeOrderInfo.ActuallyPaid / ReRechargeProfitRule.LimitAmount) * discount;
}
if (ReRechargeProfitRule.ProfitType == "Step")
{
if (rechargeOrderInfo.ActuallyPaid >= ReRechargeProfitRule.LimitAmount)
{
if (discount == 0)
{
discount = (decimal)ReRechargeProfitRule.ProfitPct * (decimal)0.01;
amount = (decimal)rechargeOrderInfo.ActuallyPaid * discount;
}
}
}
}
}
}
//入库
if (amount > 0)
{
IDbTransaction tran = new JIT.CPOS.BS.DataAccess.Base.TransactionHelper(loggingSessionInfo).CreateTransaction();
try {
// DataRow dr_AmountDetail = dtAmountDetail.NewRow();
// dr_AmountDetail["VipAmountDetailId"] = Guid.NewGuid();
// dr_AmountDetail["VipId"] = strVipId;
// dr_AmountDetail["VipCardCode"] = "";
// dr_AmountDetail["UnitID"] = "";
// dr_AmountDetail["UnitName"] = "";
// dr_AmountDetail["SalesAmount"] = 0;
// dr_AmountDetail["Amount"] = amount;
// dr_AmountDetail["UsedReturnAmount"] = 0;
// dr_AmountDetail["Reason"] = "充值";
// dr_AmountDetail["EffectiveDate"] = DateTime.Now;
// dr_AmountDetail["DeadlineDate"] = Convert.ToDateTime("9999-12-31 23:59:59");
// dr_AmountDetail["AmountSourceId"] = strAmountSourceId;
// dr_AmountDetail["ObjectId"] = rechargeOrderInfo.OrderID.ToString();
// dr_AmountDetail["Remark"] = "充值";
// dr_AmountDetail["IsValid"] = 0;
// dr_AmountDetail["IsWithdrawCash"] = 0;
// dr_AmountDetail["CustomerID"] = loggingSessionInfo.ClientID;
// dr_AmountDetail["CreateTime"] = DateTime.Now;
// dr_AmountDetail["CreateBy"] = loggingSessionInfo.ClientID;
// dr_AmountDetail["LastUpdateBy"] = loggingSessionInfo.ClientID;
// dr_AmountDetail["LastUpdateTime"] = DateTime.Now;
// dr_AmountDetail["IsDelete"] = 0;
// //dr_AmountDetail["IsCalculated"] = 1;
// dtAmountDetail.Rows.Add(dr_AmountDetail);
//DataRow dr_SplitProfitRecord = dtSplitProfitRecord.NewRow();
//dr_SplitProfitRecord["Id"] = Guid.NewGuid();
//dr_SplitProfitRecord["SourceType"] = "Amount";
//dr_SplitProfitRecord["SourceId"] = strAmountSourceId;
//dr_SplitProfitRecord["ObjectId"] = rechargeOrderInfo.OrderID.ToString();
//dr_SplitProfitRecord["UserType"] = strUserType;
//dr_SplitProfitRecord["UserId"] = rechargeOrderInfo.UserId;
//dr_SplitProfitRecord["SplitAmount"] = amount;
//dr_SplitProfitRecord["SplitSattus"] = "10";
//dr_SplitProfitRecord["CustomerId"] = loggingSessionInfo.ClientID;
//dr_SplitProfitRecord["CreateTime"] = DateTime.Now;
//dr_SplitProfitRecord["CreateBy"] = loggingSessionInfo.ClientID;
//dr_SplitProfitRecord["LastUpdateTime"] = DateTime.Now;
//dr_SplitProfitRecord["LastUpdateBy"] = loggingSessionInfo.ClientID;
//dr_SplitProfitRecord["IsDelete"] = 0;
//dtSplitProfitRecord.Rows.Add(dr_SplitProfitRecord);
entitySplitProfitRecord = new T_SplitProfitRecordEntity()
{
ID = Guid.NewGuid().ToString(),
SourceType = "Amount",
SourceId = strAmountSourceId,
ObjectId = rechargeOrderInfo.OrderID.ToString(),
UserType = strUserType,
UserId = rechargeOrderInfo.UserId,
SplitAmount = amount,
SplitSattus = "10",
CustomerID = loggingSessionInfo.ClientID
};
bllSplitProfitRecord.Create(entitySplitProfitRecord, tran);
entityVipAmountDetail = new VipAmountDetailEntity {
VipAmountDetailId = Guid.NewGuid(),
VipId = strVipId,
Amount = amount,
UsedReturnAmount = 0,
EffectiveDate = DateTime.Now,
DeadlineDate = Convert.ToDateTime("9999-12-31 23:59:59"),
AmountSourceId = strAmountSourceId,
ObjectId = rechargeOrderInfo.OrderID.ToString(),
CustomerID = loggingSessionInfo.ClientID,
Reason = "充值",
IsWithdrawCash = 0
};
bllVipAmountDetail.Create(entityVipAmountDetail, (SqlTransaction)tran);
entityVipAmount = bllVipAmount.QueryByEntity(new VipAmountEntity()
{
VipId = strVipId, IsDelete = 0
}, null).SingleOrDefault();
if (entityVipAmount == null)
{
entityVipAmount = new VipAmountEntity {
VipId = strVipId,
BeginAmount = 0,
InAmount = amount,
OutAmount = 0,
EndAmount = amount,
TotalAmount = amount,
BeginReturnAmount = 0,
InReturnAmount = 0,
OutReturnAmount = 0,
ReturnAmount = 0,
ImminentInvalidRAmount = 0,
InvalidReturnAmount = 0,
ValidReturnAmount = 0,
TotalReturnAmount = 0,
IsLocking = 0,
CustomerID = loggingSessionInfo.ClientID,
VipCardCode = ""
};
bllVipAmount.Create(entityVipAmount, tran);
//DataRow dr_Amount = dtAmount.NewRow();
//dr_Amount["VipId"] = strVipId;
//dr_Amount["VipCardCode"] = "";
//dr_Amount["BeginAmount"] = 0;
//dr_Amount["InAmount"] = amount;
//dr_Amount["OutAmount"] = 0;
//dr_Amount["EndAmount"] = amount;
//dr_Amount["TotalAmount"] = amount;
//dr_Amount["BeginReturnAmount"] = 0;
//dr_Amount["InReturnAmount"] = 0;
//dr_Amount["OutReturnAmount"] = 0;
//dr_Amount["ReturnAmount"] = 0;
//dr_Amount["ImminentInvalidRAmount"] = 0;
//dr_Amount["InvalidReturnAmount"] = 0;
//dr_Amount["ValidReturnAmount"] = 0;
//dr_Amount["TotalReturnAmount"] = 0;
//dr_Amount["PayPassword"] = "";
//dr_Amount["IsLocking"] = 0;
//dr_Amount["CustomerID"] = loggingSessionInfo.ClientID;
//dr_Amount["CreateTime"] = DateTime.Now;
//dr_Amount["CreateBy"] = loggingSessionInfo.ClientID;
//dr_Amount["LastUpdateBy"] = loggingSessionInfo.ClientID;
//dr_Amount["LastUpdateTime"] = DateTime.Now;
//dr_Amount["IsDelete"] = 0;
//dtAmount.Rows.Add(dr_Amount);
}
else
{
entityVipAmount.InReturnAmount = (entityVipAmount.InReturnAmount == null ? 0 : entityVipAmount.InReturnAmount.Value) + amount;
entityVipAmount.TotalReturnAmount = (entityVipAmount.TotalReturnAmount == null ? 0 : entityVipAmount.TotalReturnAmount.Value) + amount;
entityVipAmount.ValidReturnAmount = (entityVipAmount.ValidReturnAmount == null ? 0 : entityVipAmount.ValidReturnAmount.Value) + amount;
entityVipAmount.ReturnAmount = (entityVipAmount.ReturnAmount == null ? 0 : entityVipAmount.ReturnAmount.Value) + amount;
bllVipAmount.Update(entityVipAmount);
}
tran.Commit();
}
catch (Exception) {
tran.Rollback();
throw;
}
}
}
//if (dtAmount.Rows.Count > 0 && dtAmountDetail.Rows.Count == dtAmount.Rows.Count)
//{
// Utils.SqlBulkCopy(connString, dtAmount, "VipAmount");
//}
//if (dtAmountDetail.Rows.Count > 0 && dtSplitProfitRecord.Rows.Count > 0)
//{
// Utils.SqlBulkCopy(connString, dtSplitProfitRecord, "T_SplitProfitRecord");
// Utils.SqlBulkCopy(connString, dtAmountDetail, "VipAmountDetail");
//}
}
}
}
}
}
