/// <summary>
/// 在队列失效的情况下，直接计算
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <param name="orderInfo"></param>
public void CalculateVipConsumeForUpgrade(LoggingSessionInfo loggingSessionInfo, T_InoutEntity orderInfo)
{
VipCardUpgradeRuleBLL bllVipCardUpgradeRule = new VipCardUpgradeRuleBLL(loggingSessionInfo);
VipCardVipMappingBLL vipCardVipMappingBLL = new VipCardVipMappingBLL(loggingSessionInfo);
T_InoutBLL bllInout = new T_InoutBLL(loggingSessionInfo);
var entityVipCardUpgradeRule = bllVipCardUpgradeRule.QueryByEntity(new VipCardUpgradeRuleEntity()
{
IsBuyUpgrade = 1, CustomerID = loggingSessionInfo.ClientID
}, null);
if (entityVipCardUpgradeRule != null)
{
decimal vipSumAmount = bllInout.GetVipSumAmount(orderInfo.vip_no);
bool isUpdate = false;
foreach (var rule in entityVipCardUpgradeRule.OrderByDescending(a => a.VipCardTypeID))
{
if (rule.BuyAmount > 0)
{
if (vipSumAmount >= rule.BuyAmount)
{
if (!isUpdate)
{
vipCardVipMappingBLL.BindVirtualItem(orderInfo.vip_no, orderInfo.VipCardCode, "", (int)rule.VipCardTypeID, "TotalSales", 2, orderInfo.order_id);
isUpdate = true;
}
}
}
if (rule.OnceBuyAmount > 0)
{
if (orderInfo.actual_amount >= rule.OnceBuyAmount)
{
if (!isUpdate)
{
vipCardVipMappingBLL.BindVirtualItem(orderInfo.vip_no, orderInfo.VipCardCode, "", (int)rule.VipCardTypeID, "OneSales", 2, orderInfo.order_id);
isUpdate = true;
}
}
}
}
}
}
protected override SetRechargeOrderRD ProcessRequest(APIRequest <SetRechargeOrderRP> pRequest)
{
SetRechargeOrderRP rp = pRequest.Parameters;
SetRechargeOrderRD rd = new SetRechargeOrderRD();
var rechargeOrderBll = new RechargeOrderBLL(CurrentUserInfo);
TUnitExpandBLL serviceUnitExpandBll = new TUnitExpandBLL(CurrentUserInfo);
var vipBll = new VipBLL(CurrentUserInfo);
var vipCardVipMappingBll = new VipCardVipMappingBLL(CurrentUserInfo);
var vipCardBll = new VipCardBLL(CurrentUserInfo);
var sysVipCardTypeBll = new SysVipCardTypeBLL(CurrentUserInfo);
var vipCardUpgradeRuleBll = new VipCardUpgradeRuleBLL(CurrentUserInfo);
//获取会员信息
VipEntity vipInfo;
string userId = "";
//微信
if (pRequest.ChannelId == "2")
{
vipInfo = vipBll.GetByID(pRequest.UserID);
UnitService unitServer = new UnitService(CurrentUserInfo);
rp.UnitId = unitServer.GetUnitByUnitTypeForWX("OnlineShopping", null).Id; //获取在线商城的门店标识
}
//掌柜App
else
{
vipInfo = vipBll.GetByID(rp.VipId);
userId = pRequest.UserID;
}
string OrderDesc = "ReRecharge"; //"升级","充值"
int? VipCardTypeId = null; //会员卡类型
decimal returnAmount = 0; //赠送金额
//会员卡类型条件
List <IWhereCondition> complexConditionOne = new List <IWhereCondition> {
};
//获取会员与会员卡关系表
var vipCardVipMappingEntity = vipCardVipMappingBll.QueryByEntity(new VipCardVipMappingEntity()
{
CustomerID = CurrentUserInfo.ClientID, VIPID = vipInfo.VIPID
}, null).FirstOrDefault();
//该会员有会员卡
if (vipCardVipMappingEntity != null)
{
//获取该会员会员卡信息
var vipCardEntity = vipCardBll.QueryByEntity(new VipCardEntity()
{
CustomerID = CurrentUserInfo.ClientID, VipCardID = vipCardVipMappingEntity.VipCardID
}, null).FirstOrDefault();
//获取该会员卡类型
var sysVipCardTypeEntity = sysVipCardTypeBll.GetByID(vipCardEntity.VipCardTypeID);
VipCardTypeId = vipCardEntity.VipCardTypeID;
//获取会员卡的会员活动
var rechargeStrategyBLL = new RechargeStrategyBLL(CurrentUserInfo);
var RechargeActivityDS = rechargeStrategyBLL.GetRechargeActivityList(CurrentUserInfo.ClientID, VipCardTypeId.ToString(), 3);
var RechargeStrategy = new RechargeStrategyInfo();
if (RechargeActivityDS != null && RechargeActivityDS.Tables[0].Rows.Count > 0)
{
var RechargeStrategyList = DataTableToObject.ConvertToList <RechargeStrategyInfo>(RechargeActivityDS.Tables[0]);
//获取与充值金额最接近的活动
RechargeStrategy = RechargeStrategyList.Where(n => n.RechargeAmount <= rp.ActuallyPaid).OrderByDescending(n => n.RechargeAmount).FirstOrDefault();
if (RechargeStrategy != null)
{
//梯度
if (RechargeStrategy.RuleType == "Step")
{
//赠送金额 = 会员活动梯度设置赠送金额
returnAmount = RechargeStrategy.GiftAmount;
}
//叠加
if (RechargeStrategy.RuleType == "Superposition")
{
//赠送金额与满赠条件金额比例
decimal discount = RechargeStrategy.GiftAmount / RechargeStrategy.RechargeAmount;
//赠送金额 = 充值金额 * （设置赠送金额 / 设置满赠条件金额）
returnAmount = rp.ActuallyPaid * RechargeStrategy.GiftAmount / RechargeStrategy.RechargeAmount;
}
}
}
//获取等级高的会员卡类型条件
complexConditionOne.Add(new MoreThanCondition()
{
FieldName = "VipCardLevel", Value = sysVipCardTypeEntity.VipCardLevel, IncludeEquals = false
});
complexConditionOne.Add(new EqualsCondition()
{
FieldName = "CustomerID", Value = CurrentUserInfo.ClientID
});
}
//该会员没有会员卡
else
{
//获取所有的会员卡类型条件
complexConditionOne.Add(new EqualsCondition()
{
FieldName = "CustomerID", Value = CurrentUserInfo.ClientID
});
}
var sysVipCardTypeList = sysVipCardTypeBll.Query(complexConditionOne.ToArray(), null).ToList();
if (sysVipCardTypeList == null)
{
throw new APIException("没有建立会员体系")
{
ErrorCode = 200
};
}
//获取会员卡类型升级规则
List <IWhereCondition> complexConditionTwo = new List <IWhereCondition> {
};
complexConditionTwo.Add(new EqualsCondition()
{
FieldName = "CustomerID", Value = CurrentUserInfo.ClientID
});
complexConditionTwo.Add(new EqualsCondition()
{
FieldName = "IsRecharge", Value = 1
});
var vipCardUpgradeRuleList = vipCardUpgradeRuleBll.Query(complexConditionTwo.ToArray(), null);
//将升级卡规则和可升级的会员卡匹配
var vipCardTypeDetailList = vipCardUpgradeRuleList.Join(sysVipCardTypeList, n => n.VipCardTypeID, m => m.VipCardTypeID, (n, m) => new { n, m }).OrderByDescending(t => t.m.VipCardLevel).ToList();
//判断是否满充值条件
bool isUpgrade = false;
for (int i = 0; i < vipCardTypeDetailList.Count; i++)
{
//实付金额 >= 可升级金额
if (vipCardTypeDetailList[i].n.OnceRechargeAmount <= rp.ActuallyPaid)
{
isUpgrade = true;
VipCardTypeId = vipCardTypeDetailList[i].n.VipCardTypeID ?? 0;
break;
}
}
if (isUpgrade)
{
OrderDesc = "Upgrade"; //升级
}
//充值订单
var rechargeOrderEntity = new RechargeOrderEntity()
{
OrderID = Guid.NewGuid(),
OrderNo = serviceUnitExpandBll.GetUnitOrderNo(),
OrderDesc = OrderDesc,
VipID = vipInfo.VIPID,
VipCardNo = vipInfo.VipCode,
UnitId = rp.UnitId,
UserId = userId,
TotalAmount = rp.ActuallyPaid,
ActuallyPaid = rp.ActuallyPaid,
PosSourceName = rp.PosSourceName,
ReturnAmount = returnAmount,
PayerID = vipInfo.VIPID,
Status = 0,
CustomerID = CurrentUserInfo.ClientID,
VipCardTypeId = VipCardTypeId
};
rechargeOrderBll.Create(rechargeOrderEntity);
rd.orderId = rechargeOrderEntity.OrderID.ToString();
//支付完成
if (rp.PayStatus == 1)
{
//获取门店信息
t_unitBLL unitBLL = new t_unitBLL(CurrentUserInfo);
t_unitEntity unitInfo = null;
if (!string.IsNullOrEmpty(rechargeOrderEntity.UnitId))
{
unitInfo = unitBLL.GetByID(rechargeOrderEntity.UnitId);
}
//充值
rechargeOrderBll.Recharge(rechargeOrderEntity, vipInfo, unitInfo, "");
}
return(rd);
}
/// <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>
/// 销售升级job
/// </summary>
public void CalculateVipConsumeForUpgradeJob()
{
var numCount = 50;
var customerIDs = CustomerBLL.Instance.GetCustomerList();
foreach (var customer in customerIDs)
{
string connString = customer.Value;
var count = RedisOpenAPI.Instance.CCAllOrder().GetOrderLength(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");
VipCardUpgradeRuleBLL bllVipCardUpgradeRule = new VipCardUpgradeRuleBLL(loggingSessionInfo);
VipCardVipMappingBLL vipCardVipMappingBLL = new VipCardVipMappingBLL(loggingSessionInfo);
T_InoutBLL bllInout = new T_InoutBLL(loggingSessionInfo);
for (var i = 0; i < numCount; i++)
{
var response = RedisOpenAPI.Instance.CCAllOrder().GetOrder(new CC_Order
{
CustomerID = customer.Key
});
if (response.Code == ResponseCode.Success)
{
var orderInfo = response.Result.OrderInfo.JsonDeserialize <T_InoutEntity>();
var entityVipCardUpgradeRule = bllVipCardUpgradeRule.QueryByEntity(new VipCardUpgradeRuleEntity()
{
IsBuyUpgrade = 1, CustomerID = loggingSessionInfo.ClientID
}, null);
if (entityVipCardUpgradeRule != null)
{
decimal vipSumAmount = bllInout.GetVipSumAmount(orderInfo.vip_no);
bool isUpdate = false;
foreach (var rule in entityVipCardUpgradeRule.OrderByDescending(a => a.VipCardTypeID))
{
if (rule.BuyAmount > 0)
{
if (vipSumAmount >= rule.BuyAmount)
{
if (!isUpdate)
{
vipCardVipMappingBLL.BindVirtualItem(orderInfo.vip_no, orderInfo.VipCardCode, "", (int)rule.VipCardTypeID, "TotalSales", 2, orderInfo.order_id);
isUpdate = true;
}
}
}
if (rule.OnceBuyAmount > 0)
{
if (orderInfo.actual_amount >= rule.OnceBuyAmount)
{
if (!isUpdate)
{
vipCardVipMappingBLL.BindVirtualItem(orderInfo.vip_no, orderInfo.VipCardCode, "", (int)rule.VipCardTypeID, "OneSales", 2, orderInfo.order_id);
isUpdate = true;
}
}
}
}
}
}
}
}
}
protected override EmptyResponseData ProcessRequest(DTO.Base.APIRequest <UpdateVipCardTypeSystemRP> pRequest)
{
var rd = new EmptyResponseData();
var para = pRequest.Parameters;
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var entitySysVipCardType = new SysVipCardTypeEntity();
var bllSysVipCardType = new SysVipCardTypeBLL(loggingSessionInfo);
//卡分润规则
var bllVipCardProfitRule = new VipCardProfitRuleBLL(loggingSessionInfo);
//续费充值方式
var VipCardReRechargeProfitRuleService = new VipCardReRechargeProfitRuleBLL(loggingSessionInfo);
//编辑会员卡等级
try
{
var SysVipCardTypeInfo = bllSysVipCardType.QueryByEntity(new SysVipCardTypeEntity()
{
CustomerID = loggingSessionInfo.ClientID, VipCardTypeID = para.VipCardTypeID, IsDelete = 0
}, null).FirstOrDefault();
switch (para.OperateType)
{
//如果为1编辑会员卡等级信息
case 1:
if (SysVipCardTypeInfo != null)
{
//获取当前会员信息
List <IWhereCondition> wheres = new List <IWhereCondition>();
wheres.Add(new EqualsCondition()
{
FieldName = "Category", Value = 0
});
wheres.Add(new EqualsCondition()
{
FieldName = "CustomerID", Value = loggingSessionInfo.ClientID
});
wheres.Add(new EqualsCondition()
{
FieldName = "VipCardTypeName", Value = para.VipCardTypeName
});
wheres.Add(new DirectCondition("VipCardLevel!='" + SysVipCardTypeInfo.VipCardLevel + "'"));
var ExistVipCardTypeResult = bllSysVipCardType.Query(wheres.ToArray(), null).FirstOrDefault();
if (ExistVipCardTypeResult != null)
{
throw new APIException("会员卡名称不能重复！")
{
ErrorCode = ERROR_CODES.INVALID_BUSINESS
};
}
SysVipCardTypeInfo.VipCardTypeID = para.VipCardTypeID;
SysVipCardTypeInfo.Category = 0;
SysVipCardTypeInfo.VipCardTypeName = para.VipCardTypeName;
SysVipCardTypeInfo.VipCardLevel = SysVipCardTypeInfo.VipCardLevel;
SysVipCardTypeInfo.IsPassword = SysVipCardTypeInfo.IsPassword;
if (SysVipCardTypeInfo.VipCardLevel == 1) //如果等级为1默认可充值
{
SysVipCardTypeInfo.Isprepaid = 1;
}
else
{
SysVipCardTypeInfo.Isprepaid = para.IsPrepaid;
}
SysVipCardTypeInfo.IsOnlineSales = para.IsOnlineSales;
SysVipCardTypeInfo.PicUrl = para.PicUrl;
SysVipCardTypeInfo.CustomerID = loggingSessionInfo.ClientID;
if (SysVipCardTypeInfo.VipCardLevel == 1)
{
SysVipCardTypeInfo.Prices = 0;
SysVipCardTypeInfo.ExchangeIntegral = 0;
SysVipCardTypeInfo.IsExtraMoney = 2;
}
}
//如果IsOnlineSales为0则需要逻辑删除分润规则数据
if (SysVipCardTypeInfo.IsOnlineSales == 0)
{
var VipCardProfitRuleInfo = bllVipCardProfitRule.QueryByEntity(new VipCardProfitRuleEntity()
{
VipCardTypeID = SysVipCardTypeInfo.VipCardTypeID, CustomerID = loggingSessionInfo.ClientID
}, null);
if (VipCardProfitRuleInfo.Length > 0)
{
bllVipCardProfitRule.Delete(VipCardProfitRuleInfo);
}
}
if (SysVipCardTypeInfo.Isprepaid == 0) //不可充值
{
var VipCardUpgradeRuleService = new VipCardUpgradeRuleBLL(loggingSessionInfo);
//升级规则信息 永远只有一条信息
var CardUpgradeRuleEntity = VipCardUpgradeRuleService.QueryByEntity(new VipCardUpgradeRuleEntity()
{
VipCardTypeID = SysVipCardTypeInfo.VipCardTypeID
}, null);
if (CardUpgradeRuleEntity != null && CardUpgradeRuleEntity.FirstOrDefault() != null) //如果有设置了升级条件
{
if (CardUpgradeRuleEntity.FirstOrDefault().IsBuyUpgrade == 1) //消费升级+不可充值==>逻辑删除 会员卡销售激励规则
{
var Ids = bllVipCardProfitRule.QueryByEntity(new VipCardProfitRuleEntity()
{
CustomerID = loggingSessionInfo.ClientID, VipCardTypeID = SysVipCardTypeInfo.VipCardTypeID
}, null).Select(m => m.CardBuyToProfitRuleId.Value.ToString()).ToArray();
if (Ids.Length > 0)
{
bllVipCardProfitRule.Delete(Ids);
}
}
}
//将所有梯度信息 逻辑删除
string[] ProfitRuleIds = bllVipCardProfitRule.GetRechargeProfitRuleByIsPrepaid(loggingSessionInfo.ClientID, SysVipCardTypeInfo.VipCardTypeID);
if (ProfitRuleIds.Length > 0)
{
VipCardReRechargeProfitRuleService.Delete(ProfitRuleIds);
}
}
bllSysVipCardType.Update(SysVipCardTypeInfo);
//修改虚拟商品
#warning 商品代码注释 Bear
ItemService _ItemService = new ItemService(loggingSessionInfo);
_ItemService.SaveCardToOffenTItem(loggingSessionInfo, SysVipCardTypeInfo);
break;
//如果为2编辑升级规则信息
case 2:
var bllVipCardUpgradeRule = new VipCardUpgradeRuleBLL(loggingSessionInfo);
//升级类型不能为空 (1=购卡升级；2=充值升级；3=消费升级;)
if (para.UpGradeType != 0)
{
VipCardUpgradeRuleEntity vipCardUpgradeRuleEntity = new VipCardUpgradeRuleEntity();
if (para.OperateObjectID != null)
{
var VipCardUpgradeRuleInfo = bllVipCardUpgradeRule.QueryByEntity(new VipCardUpgradeRuleEntity()
{
CustomerID = loggingSessionInfo.ClientID, VipCardUpgradeRuleId = new Guid(para.OperateObjectID), VipCardTypeID = para.VipCardTypeID
}, null).FirstOrDefault();
if (VipCardUpgradeRuleInfo != null)
{
//先置为0 再进行更新
SysVipCardTypeInfo.IsExtraMoney = 2;
SysVipCardTypeInfo.Prices = 0;
SysVipCardTypeInfo.ExchangeIntegral = 0;
VipCardUpgradeRuleInfo.OnceRechargeAmount = 0;
VipCardUpgradeRuleInfo.OnceBuyAmount = 0;
VipCardUpgradeRuleInfo.BuyAmount = 0;
switch (para.UpGradeType)
{
case 1:
VipCardUpgradeRuleInfo.IsPurchaseUpgrade = 1;
//金额和积分 与可补差价在卡等级表里面
SysVipCardTypeInfo.VipCardTypeID = para.VipCardTypeID;
SysVipCardTypeInfo.IsExtraMoney = para.IsExtraMoney;
SysVipCardTypeInfo.Prices = para.Prices;
SysVipCardTypeInfo.ExchangeIntegral = para.ExchangeIntegral;
//充值升级归零
VipCardUpgradeRuleInfo.IsRecharge = 0;
//消费升级置零
VipCardUpgradeRuleInfo.IsBuyUpgrade = 0;
break;
case 2:
VipCardUpgradeRuleInfo.IsPurchaseUpgrade = 0;
VipCardUpgradeRuleInfo.IsRecharge = 1;
VipCardUpgradeRuleInfo.IsBuyUpgrade = 0;
VipCardUpgradeRuleInfo.OnceRechargeAmount = para.OnceRechargeAmount;
break;
case 3:
VipCardUpgradeRuleInfo.IsPurchaseUpgrade = 0;
VipCardUpgradeRuleInfo.IsRecharge = 0;
VipCardUpgradeRuleInfo.IsBuyUpgrade = 1;
VipCardUpgradeRuleInfo.OnceBuyAmount = para.OnceBuyAmount;
VipCardUpgradeRuleInfo.BuyAmount = para.BuyAmount;
//如果该卡为不可充值 那么就默认删除
var syscardentity = bllSysVipCardType.GetByID(para.VipCardTypeID);
if (syscardentity != null && syscardentity.Isprepaid == 0) //消费升级 {不可充值} 默认删除该卡的激励规则
{
var Ids = bllVipCardProfitRule.QueryByEntity(new VipCardProfitRuleEntity()
{
CustomerID = loggingSessionInfo.ClientID, VipCardTypeID = para.VipCardTypeID
}, null).Select(m => m.CardBuyToProfitRuleId.Value.ToString()).ToArray();
if (Ids.Length > 0)
{
bllVipCardProfitRule.Delete(Ids);
}
}
break;
}
//更新卡等级部分信息
bllSysVipCardType.Update(SysVipCardTypeInfo);
//修改虚拟商品
ItemService _ItemServices = new ItemService(loggingSessionInfo);
_ItemServices.SaveCardToOffenTItem(loggingSessionInfo, SysVipCardTypeInfo);
bllVipCardUpgradeRule.Update(VipCardUpgradeRuleInfo);
}
}
else
{
//先置为0 再进行更新
SysVipCardTypeInfo.IsExtraMoney = 2;
SysVipCardTypeInfo.Prices = 0;
SysVipCardTypeInfo.ExchangeIntegral = 0;
vipCardUpgradeRuleEntity.OnceRechargeAmount = 0;
vipCardUpgradeRuleEntity.OnceBuyAmount = 0;
vipCardUpgradeRuleEntity.BuyAmount = 0;
switch (para.UpGradeType)
{
case 1:
vipCardUpgradeRuleEntity.IsPurchaseUpgrade = 1;
vipCardUpgradeRuleEntity.VipCardTypeID = para.VipCardTypeID;
//金额和积分 与可补差价在卡等级表里面
SysVipCardTypeInfo.VipCardTypeID = para.VipCardTypeID;
SysVipCardTypeInfo.IsExtraMoney = para.IsExtraMoney;
SysVipCardTypeInfo.Prices = para.Prices;
SysVipCardTypeInfo.ExchangeIntegral = para.ExchangeIntegral;
//充值升级归零
vipCardUpgradeRuleEntity.IsRecharge = 0;
//消费升级置零
vipCardUpgradeRuleEntity.IsBuyUpgrade = 0;
break;
case 2:
vipCardUpgradeRuleEntity.IsPurchaseUpgrade = 0;
vipCardUpgradeRuleEntity.IsRecharge = 1;
vipCardUpgradeRuleEntity.IsBuyUpgrade = 0;
vipCardUpgradeRuleEntity.OnceRechargeAmount = para.OnceRechargeAmount;
break;
case 3: //消费升级
vipCardUpgradeRuleEntity.IsPurchaseUpgrade = 0;
vipCardUpgradeRuleEntity.IsRecharge = 0;
vipCardUpgradeRuleEntity.IsBuyUpgrade = 1;
vipCardUpgradeRuleEntity.OnceBuyAmount = para.OnceBuyAmount;
vipCardUpgradeRuleEntity.BuyAmount = para.BuyAmount;
break;
}
//更新卡等级部分信息
bllSysVipCardType.Update(SysVipCardTypeInfo);
//修改虚拟商品
ItemService _ItemServices = new ItemService(loggingSessionInfo);
_ItemServices.SaveCardToOffenTItem(loggingSessionInfo, SysVipCardTypeInfo);
//添加卡升级规则
vipCardUpgradeRuleEntity.VipCardUpgradeRuleId = Guid.NewGuid();
vipCardUpgradeRuleEntity.CustomerID = loggingSessionInfo.ClientID;
bllVipCardUpgradeRule.Create(vipCardUpgradeRuleEntity);
}
}
else
{
throw new APIException("升级类型不能为空！")
{
ErrorCode = ERROR_CODES.INVALID_BUSINESS
};
}
break;
//如果为3编辑基本权益信息
case 3:
var bllVipCardRule = new VipCardRuleBLL(loggingSessionInfo);
var entityVipCardRule = new VipCardRuleEntity();
var VipCardRuleInfo = bllVipCardRule.QueryByEntity(new VipCardRuleEntity()
{
CustomerID = loggingSessionInfo.ClientID, RuleID = Convert.ToInt32(para.OperateObjectID), VipCardTypeID = para.VipCardTypeID
}, null).FirstOrDefault();
if (VipCardRuleInfo != null)
{
entityVipCardRule.RuleID = Convert.ToInt32(para.OperateObjectID);
entityVipCardRule.VipCardTypeID = para.VipCardTypeID;
entityVipCardRule.CardDiscount = para.CardDiscount * 10;
entityVipCardRule.PaidGivePoints = para.PaidGivePoints;
entityVipCardRule.PaidGivePercetPoints = para.PaidGivePercetPoints;
entityVipCardRule.CustomerID = loggingSessionInfo.ClientID;
bllVipCardRule.Update(entityVipCardRule);
}
break;
}
try
{
var msg = new EventContract
{
Operation = OptEnum.Update,
EntityType = EntityTypeEnum.VipCardType,
Id = SysVipCardTypeInfo.VipCardTypeID.ToString()
};
var eventService = new EventService();
eventService.PublishMsg(msg);
}
catch (Exception)
{
throw new Exception("RabbitMQ Error");
}
}
catch (APIException ex)
{
throw ex;
}
return(rd);
}
protected override EmptyResponseData ProcessRequest(DTO.Base.APIRequest <SetVipCardTypeSystemRP> pRequest)
{
var rd = new EmptyResponseData();
var para = pRequest.Parameters;
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
//卡相关逻辑
var bllVipCardType = new SysVipCardTypeBLL(loggingSessionInfo);
//升级规则逻辑
var bllVipCardUpgradeRule = new VipCardUpgradeRuleBLL(loggingSessionInfo);
//基本权益逻辑
var bllVipCardRule = new VipCardRuleBLL(loggingSessionInfo);
//开卡礼逻辑
var bllVipCardUpgradeReward = new VipCardUpgradeRewardBLL(loggingSessionInfo);
//卡分润规则
var bllVipCardProfitRule = new VipCardProfitRuleBLL(loggingSessionInfo);
//续费充值方式
var VipCardReRechargeProfitRuleService = new VipCardReRechargeProfitRuleBLL(loggingSessionInfo);
string _CustomerId = loggingSessionInfo.ClientID;
if (para.VipCardRelateList.Count > 0)
{
try
{
foreach (var VipCardSystem in para.VipCardRelateList)
{
//获取当前会员信息
//List<IWhereCondition> wheres = new List<IWhereCondition>();
//wheres.Add(new EqualsCondition() { FieldName = "Category", Value = 0 });
//wheres.Add(new EqualsCondition() { FieldName = "CustomerID", Value = loggingSessionInfo.ClientID });
//wheres.Add(new EqualsCondition() { FieldName = "VipCardTypeName", Value = VipCardSystem.VipCardType.VipCardTypeName });
//wheres.Add(new DirectCondition("VipCardLevel!='" + VipCardSystem.VipCardType.VipCardLevel + "'"));
//var ExistVipCardTypeResult = bllVipCardType.Query(wheres.ToArray(), null).FirstOrDefault();
//if (ExistVipCardTypeResult != null)
//{
// throw new APIException("会员卡名称不能重复！") { ErrorCode = ERROR_CODES.INVALID_BUSINESS };
//}
//获取当前待添加的卡等级数据
var VipCardTypeResult = bllVipCardType.QueryByEntity(new SysVipCardTypeEntity()
{
Category = 0, VipCardLevel = VipCardSystem.VipCardType.VipCardLevel, CustomerID = loggingSessionInfo.ClientID
}, null).FirstOrDefault();
if (VipCardTypeResult != null)
{
#region 编辑会员卡等级信息
//throw new APIException("卡等级不能重复！") { ErrorCode = ERROR_CODES.INVALID_BUSINESS };
//如果存在数据需要进行修改
VipCardTypeResult.VipCardTypeName = VipCardSystem.VipCardType.VipCardTypeName;
VipCardTypeResult.VipCardLevel = VipCardSystem.VipCardType.VipCardLevel;
if (VipCardTypeResult.VipCardLevel == 1)//如果等级为1默认可充值
{
VipCardTypeResult.Isprepaid = 1;
}
else
{
VipCardTypeResult.Isprepaid = VipCardSystem.VipCardType.IsPrepaid;
}
VipCardTypeResult.IsOnlineSales = VipCardSystem.VipCardType.IsOnlineSales;
//如果IsOnlineSales为0则需要逻辑删除分润规则数据
if (VipCardTypeResult.IsOnlineSales == 0)
{
var VipCardProfitRuleInfo = bllVipCardProfitRule.QueryByEntity(new VipCardProfitRuleEntity()
{
VipCardTypeID = VipCardTypeResult.VipCardTypeID, CustomerID = loggingSessionInfo.ClientID
}, null);
if (VipCardProfitRuleInfo.Length > 0)
{
bllVipCardProfitRule.Delete(VipCardProfitRuleInfo);
}
}
VipCardTypeResult.PicUrl = VipCardSystem.VipCardType.PicUrl;
if (VipCardSystem.VipCardUpgradeRule != null)
{
if (VipCardSystem.VipCardUpgradeRule.IsPurchaseUpgrade == 1)
{
VipCardTypeResult.Prices = VipCardSystem.VipCardUpgradeRule.Prices;
VipCardTypeResult.ExchangeIntegral = VipCardSystem.VipCardUpgradeRule.ExchangeIntegral;
VipCardTypeResult.IsExtraMoney = VipCardSystem.VipCardUpgradeRule.IsExtraMoney;
}
else
{
VipCardTypeResult.Prices = 0;
VipCardTypeResult.ExchangeIntegral = 0;
VipCardTypeResult.IsExtraMoney = 2;
}
}
else
{
VipCardTypeResult.Prices = 0;
VipCardTypeResult.ExchangeIntegral = 0;
VipCardTypeResult.IsExtraMoney = 2;
}
//要先生成卡等级数据 不然取不到VipCardTypeID
if (VipCardSystem.VipCardType.VipCardLevel != 0)
{
bllVipCardType.Update(VipCardTypeResult);
//修改虚拟商品
#warning 商品代码注释 Bear
ItemService _ItemService = new ItemService(loggingSessionInfo);
_ItemService.SaveCardToOffenTItem(loggingSessionInfo, VipCardTypeResult);
try
{
var msg = new EventContract
{
Operation = OptEnum.Update,
EntityType = EntityTypeEnum.VipCardType,
Id = VipCardTypeResult.VipCardTypeID.ToString()
};
var eventService = new EventService();
eventService.PublishMsg(msg);
}
catch (Exception)
{
throw new Exception("RabbitMQ Error");
}
}
#endregion
#region 编辑卡升级规则信息
//编辑卡升级规则
if (VipCardSystem.VipCardType.VipCardLevel != 1)
{
VipCardUpgradeRuleEntity vipCardUpgradeRuleEntity = new VipCardUpgradeRuleEntity();
var entityVipCardUpgradeRule = bllVipCardUpgradeRule.QueryByEntity(new VipCardUpgradeRuleEntity()
{
CustomerID = loggingSessionInfo.ClientID, VipCardTypeID = VipCardTypeResult.VipCardTypeID
}, null).FirstOrDefault();
//entityVipCardUpgradeRule.VipCardUpgradeRuleId = System.Guid.NewGuid();
if (entityVipCardUpgradeRule != null)
{
if (VipCardTypeResult.Isprepaid == 0) //不可充值
{
//将所有梯度信息 逻辑删除
string[] ProfitRuleIds = bllVipCardProfitRule.GetRechargeProfitRuleByIsPrepaid(loggingSessionInfo.ClientID, VipCardTypeResult.VipCardTypeID);
if (ProfitRuleIds.Length > 0)
{
VipCardReRechargeProfitRuleService.Delete(ProfitRuleIds);
}
}
if (VipCardTypeResult != null && VipCardTypeResult.VipCardTypeID != null)
{
entityVipCardUpgradeRule.VipCardTypeID = VipCardTypeResult.VipCardTypeID;
}
//是否购卡升级
if (VipCardSystem.VipCardUpgradeRule != null)
{
if (VipCardSystem.VipCardUpgradeRule.IsPurchaseUpgrade == 1)
{
entityVipCardUpgradeRule.IsPurchaseUpgrade = 1;
}
else
{
entityVipCardUpgradeRule.IsPurchaseUpgrade = 0;
}
//是否充值升级
if (VipCardSystem.VipCardUpgradeRule.IsRecharge == 1)
{
entityVipCardUpgradeRule.IsRecharge = 1;
entityVipCardUpgradeRule.OnceRechargeAmount = VipCardSystem.VipCardUpgradeRule.OnceRechargeAmount;
}
else
{
entityVipCardUpgradeRule.IsRecharge = 0;
entityVipCardUpgradeRule.OnceRechargeAmount = 0;
}
//是否消费升级
if (VipCardSystem.VipCardUpgradeRule.IsBuyUpgrade == 1)
{
entityVipCardUpgradeRule.IsBuyUpgrade = 1;
entityVipCardUpgradeRule.BuyAmount = VipCardSystem.VipCardUpgradeRule.BuyAmount;
entityVipCardUpgradeRule.OnceBuyAmount = VipCardSystem.VipCardUpgradeRule.OnceBuyAmount;
}
else
{
entityVipCardUpgradeRule.IsBuyUpgrade = 0;
entityVipCardUpgradeRule.BuyAmount = 0;
entityVipCardUpgradeRule.OnceBuyAmount = 0;
}
}
else
{
throw new APIException("升级条件不能为空！")
{
ErrorCode = ERROR_CODES.INVALID_BUSINESS
};
}
entityVipCardUpgradeRule.CustomerID = loggingSessionInfo.ClientID;
}
else
{
if (VipCardTypeResult != null && VipCardTypeResult.VipCardTypeID != null)
{
vipCardUpgradeRuleEntity.VipCardTypeID = VipCardTypeResult.VipCardTypeID;
}
//是否购卡升级
if (VipCardSystem.VipCardUpgradeRule != null)
{
if (VipCardSystem.VipCardUpgradeRule.IsPurchaseUpgrade == 1)
{
vipCardUpgradeRuleEntity.IsPurchaseUpgrade = 1;
}
else
{
vipCardUpgradeRuleEntity.IsPurchaseUpgrade = 0;
}
//是否充值升级
if (VipCardSystem.VipCardUpgradeRule.IsRecharge == 1)
{
vipCardUpgradeRuleEntity.IsRecharge = 1;
vipCardUpgradeRuleEntity.OnceRechargeAmount = VipCardSystem.VipCardUpgradeRule.OnceRechargeAmount;
}
else
{
vipCardUpgradeRuleEntity.IsRecharge = 0;
vipCardUpgradeRuleEntity.OnceRechargeAmount = 0;
}
//是否消费升级
if (VipCardSystem.VipCardUpgradeRule.IsBuyUpgrade == 1)
{
vipCardUpgradeRuleEntity.IsBuyUpgrade = 1;
vipCardUpgradeRuleEntity.BuyAmount = VipCardSystem.VipCardUpgradeRule.BuyAmount;
vipCardUpgradeRuleEntity.OnceBuyAmount = VipCardSystem.VipCardUpgradeRule.OnceBuyAmount;
}
else
{
vipCardUpgradeRuleEntity.IsBuyUpgrade = 0;
vipCardUpgradeRuleEntity.BuyAmount = 0;
vipCardUpgradeRuleEntity.OnceBuyAmount = 0;
}
}
else
{
throw new APIException("升级条件不能为空！")
{
ErrorCode = ERROR_CODES.INVALID_BUSINESS
};
}
vipCardUpgradeRuleEntity.CustomerID = loggingSessionInfo.ClientID;
}
//将卡升级规则进行入库
if (entityVipCardUpgradeRule != null)
{
bllVipCardUpgradeRule.Update(entityVipCardUpgradeRule);
}
else
{
vipCardUpgradeRuleEntity.VipCardUpgradeRuleId = Guid.NewGuid();
bllVipCardUpgradeRule.Create(vipCardUpgradeRuleEntity);
}
}
#endregion
#region 编辑基本权益信息
//基本权益实体
var VipCardRuleInfo = bllVipCardRule.QueryByEntity(new VipCardRuleEntity()
{
VipCardTypeID = VipCardTypeResult.VipCardTypeID, CustomerID = loggingSessionInfo.ClientID
}, null).FirstOrDefault();
if (VipCardRuleInfo != null)
{
if (VipCardSystem.VipCardRule != null)
{
VipCardRuleInfo.CardDiscount = VipCardSystem.VipCardRule.CardDiscount * 10;//因为给的是整数 目前折扣这里乘10
VipCardRuleInfo.PaidGivePoints = VipCardSystem.VipCardRule.PaidGivePoints;
VipCardRuleInfo.PaidGivePercetPoints = VipCardSystem.VipCardRule.PaidGivePercetPoints;
}
else
{
VipCardRuleInfo.CardDiscount = 0;//因为给的是整数 目前折扣这里乘10
VipCardRuleInfo.PaidGivePoints = 0;
VipCardRuleInfo.PaidGivePercetPoints = 0;
}
//将基本权益数据进行入库
bllVipCardRule.Update(VipCardRuleInfo);
}
else
{
var vipCardRuleEntity = new VipCardRuleEntity();
vipCardRuleEntity.VipCardTypeID = VipCardTypeResult.VipCardTypeID;
vipCardRuleEntity.CardDiscount = VipCardSystem.VipCardRule.CardDiscount * 10;//因为给的是整数 目前折扣这里乘10
vipCardRuleEntity.PaidGivePoints = VipCardSystem.VipCardRule.PaidGivePoints;
vipCardRuleEntity.PaidGivePercetPoints = VipCardSystem.VipCardRule.PaidGivePercetPoints;
vipCardRuleEntity.CustomerID = loggingSessionInfo.ClientID;
bllVipCardRule.Create(vipCardRuleEntity);
}
#endregion
#region 编辑开卡礼信息
if (VipCardSystem.VipCardUpgradeRewardList != null)
{
//开卡礼处理
foreach (var Rewards in VipCardSystem.VipCardUpgradeRewardList)
{
var entityVipCardUpgradeReward = new VipCardUpgradeRewardEntity();
if (VipCardTypeResult != null && VipCardTypeResult.VipCardTypeID != null)
{
entityVipCardUpgradeReward.VipCardTypeID = VipCardTypeResult.VipCardTypeID;
}
entityVipCardUpgradeReward.CouponTypeId = new Guid(Rewards.CouponTypeID);
entityVipCardUpgradeReward.CouponNum = Rewards.CouponNum;
entityVipCardUpgradeReward.CustomerID = loggingSessionInfo.ClientID;
if (!string.IsNullOrEmpty(Rewards.CardUpgradeRewardId))
{
entityVipCardUpgradeReward.CardUpgradeRewardId = new Guid(Rewards.CardUpgradeRewardId);
}
switch (Rewards.OperateType) //判断此处为何种操作(0=删除券;1=新增;2=修改;)
{
case 0: //删除券
bllVipCardUpgradeReward.Delete(entityVipCardUpgradeReward);
break;
case 1: //新增券
var existVipCardUpgradeReward = bllVipCardUpgradeReward.QueryByEntity(new VipCardUpgradeRewardEntity()
{
CustomerID = loggingSessionInfo.ClientID, VipCardTypeID = VipCardTypeResult.VipCardTypeID, CouponTypeId = new Guid(Rewards.CouponTypeID)
}, null).FirstOrDefault();
if (existVipCardUpgradeReward != null)
{
existVipCardUpgradeReward.CouponTypeId = new Guid(Rewards.CouponTypeID);
existVipCardUpgradeReward.CouponNum = Rewards.CouponNum;
existVipCardUpgradeReward.CustomerID = loggingSessionInfo.ClientID;
bllVipCardUpgradeReward.Update(existVipCardUpgradeReward);
}
else
{
entityVipCardUpgradeReward.CardUpgradeRewardId = Guid.NewGuid();
bllVipCardUpgradeReward.Create(entityVipCardUpgradeReward);
}
break;
case 2: //修改
bllVipCardUpgradeReward.Update(entityVipCardUpgradeReward);
break;
}
}
}
#endregion
}
else
{
#region 添加会员卡等级信息
//如果卡等级不重复则添加卡等级数据
var entityVipCardType = new SysVipCardTypeEntity();
entityVipCardType.Category = 0;
entityVipCardType.VipCardTypeName = VipCardSystem.VipCardType.VipCardTypeName;
entityVipCardType.VipCardLevel = VipCardSystem.VipCardType.VipCardLevel;
entityVipCardType.IsPassword = 0;
if (entityVipCardType.VipCardLevel == 1)//如果等级为1默认可充值
{
entityVipCardType.Isprepaid = 1;
}
else
{
entityVipCardType.Isprepaid = VipCardSystem.VipCardType.IsPrepaid;
}
entityVipCardType.IsOnlineSales = VipCardSystem.VipCardType.IsOnlineSales;
entityVipCardType.PicUrl = VipCardSystem.VipCardType.PicUrl;
entityVipCardType.CustomerID = loggingSessionInfo.ClientID;
if (VipCardSystem.VipCardUpgradeRule != null)
{
if (VipCardSystem.VipCardUpgradeRule.IsPurchaseUpgrade == 1)
{
entityVipCardType.Prices = VipCardSystem.VipCardUpgradeRule.Prices;
entityVipCardType.ExchangeIntegral = VipCardSystem.VipCardUpgradeRule.ExchangeIntegral;
entityVipCardType.IsExtraMoney = VipCardSystem.VipCardUpgradeRule.IsExtraMoney;
}
else
{
entityVipCardType.Prices = 0;
entityVipCardType.ExchangeIntegral = 0;
entityVipCardType.IsExtraMoney = 2;
}
}
else
{
entityVipCardType.Prices = 0;
entityVipCardType.ExchangeIntegral = 0;
entityVipCardType.IsExtraMoney = 2;
}
var existVipCardType = bllVipCardType.QueryByEntity(new SysVipCardTypeEntity()
{
Category = 0, VipCardLevel = VipCardSystem.VipCardType.VipCardLevel, CustomerID = loggingSessionInfo.ClientID
}, null).FirstOrDefault();
if (existVipCardType == null)
{
//要先生成卡等级数据 不然取不到VipCardTypeID
if (VipCardSystem.VipCardType.VipCardLevel != 0 && VipCardSystem.VipCardType.VipCardLevel < 8)
{
bllVipCardType.Create(entityVipCardType);
//添加虚拟商品
#warning 商品代码注释 Bear
ItemService _ItemService = new ItemService(loggingSessionInfo);
_ItemService.SaveCardToOffenTItem(loggingSessionInfo, entityVipCardType);
var tmp =
bllVipCardType.QueryByEntity(
new SysVipCardTypeEntity()
{
Category = 0,
VipCardLevel = entityVipCardType.VipCardLevel,
CustomerID = loggingSessionInfo.ClientID
}, null).FirstOrDefault();
try
{
var msg = new EventContract
{
Operation = OptEnum.Create,
EntityType = EntityTypeEnum.VipCardType,
Id = tmp.VipCardTypeID.ToString()
};
var eventService = new EventService();
eventService.PublishMsg(msg);
}
catch (Exception)
{
throw new Exception("RabbitMQ Error");
}
}
else
{
throw new APIException("等级不能超过七级！")
{
ErrorCode = ERROR_CODES.INVALID_BUSINESS
};
}
}
//else
//{
// throw new APIException("会员卡名称不能重复！") { ErrorCode = ERROR_CODES.INVALID_BUSINESS };
//}
#endregion
//因为卡等级不能重复 所以这里根据卡等级获取VipCardTypeID的信息
var vipCardTypeInfo = bllVipCardType.QueryByEntity(new SysVipCardTypeEntity()
{
Category = 0, VipCardLevel = VipCardSystem.VipCardType.VipCardLevel, CustomerID = loggingSessionInfo.ClientID
}, null).FirstOrDefault();
//因为注册表单暂时没用上 如果卡等级不等于1时 就有升级条件数据存进去
if (VipCardSystem.VipCardType.VipCardLevel != 0)
{
#region 添加卡升级规则信息
if (VipCardSystem.VipCardType.VipCardLevel != 1)
{
var entityVipCardUpgradeRule = new VipCardUpgradeRuleEntity();
entityVipCardUpgradeRule.VipCardUpgradeRuleId = System.Guid.NewGuid();
if (vipCardTypeInfo != null && vipCardTypeInfo.VipCardTypeID != null)
{
entityVipCardUpgradeRule.VipCardTypeID = vipCardTypeInfo.VipCardTypeID;
}
//是否购卡升级
if (VipCardSystem.VipCardUpgradeRule != null)
{
if (VipCardSystem.VipCardUpgradeRule.IsPurchaseUpgrade == 1)
{
entityVipCardUpgradeRule.IsPurchaseUpgrade = 1;
}
else
{
entityVipCardUpgradeRule.IsPurchaseUpgrade = 0;
entityVipCardUpgradeRule.OnceRechargeAmount = 0;
}
//是否充值升级
if (VipCardSystem.VipCardUpgradeRule.IsRecharge == 1)
{
entityVipCardUpgradeRule.IsRecharge = 1;
entityVipCardUpgradeRule.OnceRechargeAmount = VipCardSystem.VipCardUpgradeRule.OnceRechargeAmount;
}
else
{
entityVipCardUpgradeRule.IsRecharge = 0;
entityVipCardUpgradeRule.OnceRechargeAmount = 0;
}
//是否消费升级
if (VipCardSystem.VipCardUpgradeRule.IsBuyUpgrade == 1)
{
entityVipCardUpgradeRule.IsBuyUpgrade = 1;
entityVipCardUpgradeRule.BuyAmount = VipCardSystem.VipCardUpgradeRule.BuyAmount;
entityVipCardUpgradeRule.OnceBuyAmount = VipCardSystem.VipCardUpgradeRule.OnceBuyAmount;
}
else
{
entityVipCardUpgradeRule.IsBuyUpgrade = 0;
entityVipCardUpgradeRule.BuyAmount = 0;
entityVipCardUpgradeRule.OnceBuyAmount = 0;
}
}
else
{
throw new APIException("升级条件不能为空！")
{
ErrorCode = ERROR_CODES.INVALID_BUSINESS
};
}
entityVipCardUpgradeRule.CustomerID = loggingSessionInfo.ClientID;
//将卡升级规则进行入库
bllVipCardUpgradeRule.Create(entityVipCardUpgradeRule);
}
#endregion
#region 添加基本权益实体
//基本权益实体
var entityVipCardRule = new VipCardRuleEntity();
if (vipCardTypeInfo != null && vipCardTypeInfo.VipCardTypeID != null)
{
entityVipCardRule.VipCardTypeID = vipCardTypeInfo.VipCardTypeID;
}
if (VipCardSystem.VipCardRule != null)
{
entityVipCardRule.CardDiscount = VipCardSystem.VipCardRule.CardDiscount * 10;//因为给的是整数 目前折扣这里乘10
entityVipCardRule.PaidGivePoints = VipCardSystem.VipCardRule.PaidGivePoints;
entityVipCardRule.PaidGivePercetPoints = VipCardSystem.VipCardRule.PaidGivePercetPoints;
}
else
{
entityVipCardRule.CardDiscount = 0;//因为给的是整数 目前折扣这里乘10
entityVipCardRule.PaidGivePoints = 0;
entityVipCardRule.PaidGivePercetPoints = 0;
}
entityVipCardRule.CustomerID = loggingSessionInfo.ClientID;
//将基本权益数据进行入库
bllVipCardRule.Create(entityVipCardRule);
#endregion
#region 添加开卡礼信息
if (VipCardSystem.VipCardUpgradeRewardList != null)
{
//开卡礼处理
foreach (var Rewards in VipCardSystem.VipCardUpgradeRewardList)
{
var entityVipCardUpgradeReward = new VipCardUpgradeRewardEntity();
entityVipCardUpgradeReward.CardUpgradeRewardId = Guid.NewGuid();
if (vipCardTypeInfo != null && vipCardTypeInfo.VipCardTypeID != null)
{
entityVipCardUpgradeReward.VipCardTypeID = vipCardTypeInfo.VipCardTypeID;
}
entityVipCardUpgradeReward.CouponTypeId = new Guid(Rewards.CouponTypeID);
entityVipCardUpgradeReward.CouponNum = Rewards.CouponNum;
entityVipCardUpgradeReward.CustomerID = loggingSessionInfo.ClientID;
var existVipCardUpgradeReward = bllVipCardUpgradeReward.QueryByEntity(new VipCardUpgradeRewardEntity()
{
CustomerID = loggingSessionInfo.ClientID, VipCardTypeID = vipCardTypeInfo.VipCardTypeID, CouponTypeId = new Guid(Rewards.CouponTypeID)
}, null).FirstOrDefault();
if (existVipCardUpgradeReward != null)
{
existVipCardUpgradeReward.CouponTypeId = new Guid(Rewards.CouponTypeID);
existVipCardUpgradeReward.CouponNum = Rewards.CouponNum;
existVipCardUpgradeReward.CustomerID = loggingSessionInfo.ClientID;
bllVipCardUpgradeReward.Update(existVipCardUpgradeReward);
}
else
{
bllVipCardUpgradeReward.Create(entityVipCardUpgradeReward);
}
}
}
#endregion
}
}
}
}
catch (APIException ex)
{
//pTran.Rollback();
throw ex;
}
}
return(rd);
}
