protected override EmptyResponseData ProcessRequest(DTO.Base.APIRequest <GetActivityDeatilRP> pRequest)
{
var rd = new EmptyResponseData();
var para = pRequest.Parameters;
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var ActivityBLL = new C_ActivityBLL(loggingSessionInfo);
var ActivityMessageBLL = new C_ActivityMessageBLL(loggingSessionInfo);
var ActivityTargetGroupBLL = new C_TargetGroupBLL(loggingSessionInfo);
var ActivityPrizesBLL = new C_PrizesBLL(loggingSessionInfo);
var ActivityPrizesDetailBLL = new C_PrizesDetailBLL(loggingSessionInfo);
var ActivityRechargeStrategyBLL = new RechargeStrategyBLL(loggingSessionInfo);
var pTran = ActivityBLL.GetTran();
using (pTran.Connection)
{
try
{
//删除
C_ActivityEntity DelData = ActivityBLL.GetByID(para.ActivityID);
if (DelData == null)
{
throw new APIException("会员活动对象为NULL！")
{
ErrorCode = ERROR_CODES.INVALID_BUSINESS
};
}
//执行
List <IWhereCondition> complexCondition = new List <IWhereCondition> {
};
complexCondition.Add(new EqualsCondition()
{
FieldName = "ActivityID", Value = para.ActivityID
});
ActivityMessageBLL.Delete(ActivityMessageBLL.Query(complexCondition.ToArray(), null), pTran);
ActivityTargetGroupBLL.Delete(ActivityTargetGroupBLL.Query(complexCondition.ToArray(), null), pTran);
ActivityRechargeStrategyBLL.Delete(ActivityRechargeStrategyBLL.Query(complexCondition.ToArray(), null), pTran);
var prize = ActivityPrizesBLL.Query(complexCondition.ToArray(), null).FirstOrDefault();
if (prize != null)
{
if (!string.IsNullOrWhiteSpace(prize.PrizesID.ToString()))
{
List <IWhereCondition> cCondition = new List <IWhereCondition> {
};
cCondition.Add(new EqualsCondition()
{
FieldName = "PrizesID", Value = prize.PrizesID
});
ActivityPrizesDetailBLL.Delete(ActivityPrizesDetailBLL.Query(cCondition.ToArray(), null),
pTran);
}
ActivityPrizesBLL.Delete(ActivityPrizesBLL.Query(complexCondition.ToArray(), null), pTran);
}
ActivityBLL.Delete(DelData, pTran);
pTran.Commit();
}
catch (APIException apiEx)
{
pTran.Rollback();
throw new APIException(apiEx.ErrorCode, apiEx.Message);
}
}
return(rd);
}
protected override GetActivityDeatilRD ProcessRequest(DTO.Base.APIRequest <GetActivityDeatilRP> pRequest)
{
var rd = new GetActivityDeatilRD();
var para = pRequest.Parameters;
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var activityBll = new C_ActivityBLL(loggingSessionInfo);
var prizesBll = new C_PrizesBLL(loggingSessionInfo);
var prizesDetailBll = new C_PrizesDetailBLL(loggingSessionInfo);
var activityMessageBll = new C_ActivityMessageBLL(loggingSessionInfo);
var targetGroupBll = new C_TargetGroupBLL(loggingSessionInfo);
var rechargeStrategyBll = new RechargeStrategyBLL(loggingSessionInfo);
if (!string.IsNullOrWhiteSpace(para.ActivityID))
{
#region 基础信息
C_ActivityEntity activityData = activityBll.GetByID(para.ActivityID);
if (activityData != null)
{
rd.ActivityID = activityData.ActivityID.ToString();
rd.ActivityType = activityData.ActivityType ?? 2;
rd.ActivityName = activityData.ActivityName;
rd.StartTime = activityData.StartTime == null ? "" : activityData.StartTime.Value.ToString("yyyy-MM-dd");
rd.EndTime = activityData.EndTime == null ? "" : activityData.EndTime.Value.ToString("yyyy-MM-dd");
rd.IsLongTime = activityData.IsLongTime == null ? "0" : activityData.IsLongTime.Value.ToString();
rd.IsAllCardType = activityData.IsAllVipCardType ?? 0;
rd.VipCardTypeID = activityBll.GetTargetGroupId(rd.IsAllCardType, rd.ActivityID);
rd.HolderCardCount = activityBll.GetTargetCount(rd.VipCardTypeID, rd.ActivityType, rd.StartTime, rd.EndTime, activityData.IsLongTime.Value);
rd.Status = activityData.Status.Value;
}
#endregion
#region 奖品
var PrizesList = prizesBll.Query(new IWhereCondition[] { new EqualsCondition()
{
FieldName = "ActivityID", Value = para.ActivityID
}, new EqualsCondition()
{
FieldName = "CustomerID", Value = loggingSessionInfo.ClientID
} }, null).ToList();
if (PrizesList.Count > 0)
{
//奖品集合赋值
rd.PrizesInfoList = (from u in PrizesList
select new PrizesInfo()
{
PrizesID = Convert.ToString(u.PrizesID),
PrizesType = u.PrizesType.Value
}).ToList();
foreach (var item in rd.PrizesInfoList)
{
item.PrizesDetailList = new List <PrizesDetailInfo>();
//奖品明细
var PrizesDetailList = prizesDetailBll.GetPrizesDetailList(item.PrizesID);
if (PrizesDetailList.Count > 0)
{
CouponTypeBLL ctbll = new CouponTypeBLL(CurrentUserInfo);
foreach (var itemes in PrizesDetailList)
{
PrizesDetailInfo m = new PrizesDetailInfo();
m.PrizesDetailID = Convert.ToString(itemes.PrizesDetailID);
m.CouponTypeID = Convert.ToString(itemes.CouponTypeID);
m.CouponTypeName = itemes.CouponTypeName;
m.NumLimit = itemes.NumLimit.Value;
m.CouponTypeDesc = itemes.CouponTypeDesc;
//ValidityPeriod = t.BeginTime == null ? ("领取后" + (t.ServiceLife == 0 ? "1天内有效" : t.ServiceLife.ToString() + "天内有效")) : (t.BeginTime.Value.ToString("yyyy-MM-dd") + "至" + t.EndTime.Value.ToString("yyyy-MM-dd")),
var t = ctbll.GetByID(m.CouponTypeID);
m.ValidityPeriod = t.BeginTime == null ? ("领取后" + (t.ServiceLife == 0 ? "1天内有效" : t.ServiceLife.ToString() + "天内有效")) : (t.BeginTime.Value.ToString("yyyy-MM-dd") + "至" + t.EndTime.Value.ToString("yyyy-MM-dd"));
//奖品明细集合额赋值
item.PrizesDetailList.Add(m);
}
}
}
}
#endregion
#region 消息
var ActivityMessageList = activityMessageBll.Query(new IWhereCondition[] { new EqualsCondition()
{
FieldName = "ActivityID", Value = para.ActivityID
}, new EqualsCondition()
{
FieldName = "CustomerID", Value = loggingSessionInfo.ClientID
} }, null).ToList();
if (ActivityMessageList.Count > 0)
{
//消息赋值
rd.ActivityMessageInfoList = (from u in ActivityMessageList
select new ActivityMessageInfo()
{
MessageID = u.MessageID.Value.ToString(),
MessageType = u.MessageType.Trim(),
Content = u.Content,
SendTime = u.SendTime == null ? "" : u.SendTime.Value.ToString(),
AdvanceDays = u.AdvanceDays,
SendAtHour = u.SendAtHour
}).ToList();
}
#endregion
#region 充值策略
var rechargeStrategyInfoList = rechargeStrategyBll.Query(new IWhereCondition[] { new EqualsCondition()
{
FieldName = "ActivityID", Value = para.ActivityID
}, new EqualsCondition()
{
FieldName = "CustomerId", Value = loggingSessionInfo.ClientID
} }, new[] {
new OrderBy()
{
FieldName = "RechargeAmount", Direction = OrderByDirections.Asc
}
}).ToList();
if (rechargeStrategyInfoList.Count > 0)
{
//消息赋值
rd.RechargeStrategyInfoList = (from u in rechargeStrategyInfoList
select new RechargeStrategyInfo()
{
RechargeStrategyId = u.RechargeStrategyId.ToString(),
RuleType = u.RuleType,
RechargeAmount = u.RechargeAmount,
GiftAmount = u.GiftAmount.Value
}).ToList();
}
#endregion
}
return(rd);
}
protected override EmptyResponseData ProcessRequest(DTO.Base.APIRequest <SetPrizesRP> pRequest)
{
var rd = new EmptyResponseData();
var para = pRequest.Parameters;
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var ActivityBLL = new C_ActivityBLL(loggingSessionInfo);
var PrizesBLL = new C_PrizesBLL(loggingSessionInfo);
var PrizesDetailBLL = new C_PrizesDetailBLL(loggingSessionInfo);
var pTran = ActivityBLL.GetTran();
using (pTran.Connection)
{
try
{
if (string.IsNullOrWhiteSpace(para.ActivityID))
{
throw new APIException("必须输入活动编号!")
{
ErrorCode = ERROR_CODES.INVALID_BUSINESS
}
}
;
if (string.IsNullOrWhiteSpace(para.PrizesID))
{//新增
C_PrizesEntity AddPrizesData = new C_PrizesEntity();
AddPrizesData.ActivityID = new Guid(para.ActivityID);
AddPrizesData.PrizesType = para.PrizesType;
AddPrizesData.PrizesName = para.PrizesDetailList.FirstOrDefault().CouponTypeName;
AddPrizesData.CustomerID = loggingSessionInfo.ClientID;
AddPrizesData.SendDate = DateTime.Now;
List <IWhereCondition> complexCondition = new List <IWhereCondition> {
};
complexCondition.Add(new EqualsCondition()
{
FieldName = "ActivityID", Value = para.ActivityID
});
if (PrizesBLL.Query(complexCondition.ToArray(), null).ToList().Count > 0)
{
throw new APIException("不能重复创建奖品!")
{
ErrorCode = ERROR_CODES.INVALID_BUSINESS
}
}
;
PrizesBLL.Create(AddPrizesData);
Guid?PrizesID = PrizesBLL.Query(complexCondition.ToArray(), null).ToList().FirstOrDefault().PrizesID;
foreach (var itemes in para.PrizesDetailList)
{
C_PrizesDetailEntity AddDetailData = new C_PrizesDetailEntity();
AddDetailData.PrizesID = PrizesID;
AddDetailData.CouponTypeID = new Guid(itemes.CouponTypeID);
AddDetailData.CustomerID = loggingSessionInfo.ClientID;
AddDetailData.NumLimit = itemes.NumLimit;
AddDetailData.CouponTypeName = itemes.CouponTypeName;
AddDetailData.CouponTypeDesc = itemes.CouponTypeDesc;
PrizesDetailBLL.Create(AddDetailData, pTran);
}
}
else
{//编辑奖品明细
foreach (var itemes in para.PrizesDetailList)
{
C_PrizesDetailEntity AddDetailData = new C_PrizesDetailEntity();
AddDetailData.PrizesID = new Guid(para.PrizesID);
AddDetailData.CouponTypeID = new Guid(itemes.CouponTypeID);
AddDetailData.CustomerID = loggingSessionInfo.ClientID;
AddDetailData.NumLimit = itemes.NumLimit;
AddDetailData.CouponTypeName = itemes.CouponTypeName;
AddDetailData.CouponTypeDesc = itemes.CouponTypeDesc;
if (string.IsNullOrWhiteSpace(itemes.PrizesDetailID))
{
PrizesDetailBLL.Create(AddDetailData, pTran);
}
else
{
AddDetailData.PrizesDetailID = new Guid(itemes.PrizesDetailID);
if (itemes.IsEnable == 1)
{
PrizesDetailBLL.Update(AddDetailData, pTran);
}
else
{
PrizesDetailBLL.Delete(AddDetailData, pTran);
}
}
}
}
pTran.Commit();
if (ActivityBLL.IsActivityValid(para.ActivityID))
{
var activity = ActivityBLL.GetByID(para.ActivityID);
if (activity != null)
{
activity.Status = 0;
}
ActivityBLL.Update(activity);
}
}
catch (APIException apiEx)
{
pTran.Rollback();//回滚事物
throw new APIException(apiEx.ErrorCode, apiEx.Message);
}
}
return(rd);
}
/// <summary>
/// 活动服务送券业务方法
/// </summary>
private void ActivitySendCoupon()
{
#region 业务对象
var activityBLL = new C_ActivityBLL(c_loggingSessionInfo);
var targetGroupBLL = new C_TargetGroupBLL(c_loggingSessionInfo);
var prizesBLL = new C_PrizesBLL(c_loggingSessionInfo);
var prizesDetailBLL = new C_PrizesDetailBLL(c_loggingSessionInfo);
var CouponTypeBLL = new CouponTypeBLL(c_loggingSessionInfo);
var ActivityMessageBLL = new C_ActivityMessageBLL(c_loggingSessionInfo);
#endregion
#region 获取当前商户活动集合
List <IWhereCondition> complexCondition = new List <IWhereCondition> {
};
complexCondition.Add(new EqualsCondition()
{
FieldName = "CustomerID", Value = c_loggingSessionInfo.ClientID
});
//complexCondition.Add(new DirectCondition(" ((IsLongTime=1 and GETDATE()>=StartTime) OR (GETDATE()>=StartTime AND GETDATE()<=EndTime)) AND STATUS=0 and IsDelete=0 "));
complexCondition.Add(new DirectCondition(" (IsLongTime=1 or (IsLongTime=0 and GETDATE()<=EndTime)) and STATUS=0 and IsDelete=0 "));
var ActivityList = activityBLL.Query(complexCondition.ToArray(), null);//营销活动
#endregion
#region 轮循活动，送券业务处理
foreach (var activity in ActivityList)
{
Loggers.Debug(new DebugLogInfo()
{
Message = "轮循营销活动"
});
#region 获取卡类型ID（目标卡人群）
var targetGroupInfo = targetGroupBLL.QueryByEntity(new C_TargetGroupEntity()
{
ActivityID = activity.ActivityID, GroupType = 1
}, null).FirstOrDefault();
int VipCardTypeID = targetGroupInfo == null ? -1 : int.Parse(targetGroupInfo.ObjectID);//卡类型ID
#endregion
#region 活动是否设置奖品控制
//获取赠送礼券奖品
var prizesData = prizesBLL.QueryByEntity(new C_PrizesEntity()
{
ActivityID = activity.ActivityID, PrizesType = 1
}, null).FirstOrDefault();
//当前活动消息类型集合
var ActivityMessageLsit = ActivityMessageBLL.QueryByEntity(new C_ActivityMessageEntity()
{
ActivityID = activity.ActivityID
}, null).ToList();
List <IWhereCondition> PrizeDetailCondition = new List <IWhereCondition> {
};
if (prizesData != null)
{
PrizeDetailCondition.Add(new DirectCondition(" PrizesID='" + prizesData.PrizesID + "' "));
}
var PrizeDetailList = prizesDetailBLL.Query(PrizeDetailCondition.ToArray(), null).ToList();
#endregion
#region 当前活动券处理
#region 获取活动会员人数
int SumVipCount = 0;//会员数
if (activity.IsAllVipCardType == 0)
{
SumVipCount = activityBLL.GetholderCardCount(VipCardTypeID.ToString(), null);//当前卡类型会员数
}
else
{
SumVipCount = activityBLL.GetholderCardCount(null, null);//所有会员数
}
#endregion
#region 获取当前活动送券集合
List <IWhereCondition> CouponTypeCondition = new List <IWhereCondition> {
};
StringBuilder strWhere = new StringBuilder();
string NewStrWhere = "";
foreach (var itemPrizeDetail in PrizeDetailList)
{
strWhere.Append("couponTypeID='" + itemPrizeDetail.CouponTypeID + "' or ");
}
if (PrizeDetailList.Count > 0)
{
NewStrWhere = ((strWhere.ToString().TrimEnd()).TrimEnd('r')).Trim('o');
}
if (!string.IsNullOrWhiteSpace(NewStrWhere))
{
CouponTypeCondition.Add(new DirectCondition(NewStrWhere));
}
//券集合
var ActivityCouponTypeList = CouponTypeBLL.Query(CouponTypeCondition.ToArray(), null);
#endregion
#region 判断当前券数量是否充足，不充足：计算出缺省券数量，充足获取券数最少的一种券
//券种数量集合
List <int> CouponNumList = new List <int>();
bool CouponFlag = true;
string Remark = "";
foreach (var CouponTypeitem in ActivityCouponTypeList)
{
if (CouponTypeitem.IsVoucher >= CouponTypeitem.IssuedQty)
{
if (SumVipCount > activity.SendCouponQty)
{
int Math = SumVipCount - (activity.SendCouponQty ?? 0);//目标数-使用数
// Loggers.Debug(new DebugLogInfo() { Message = CouponTypeitem.CouponTypeName + "券数量库存不足！" + DateTime.Now });
Remark += string.Format("{1}都已发完还少{0}张，", Math, CouponTypeitem.CouponTypeName);
CouponFlag = false;
}
}
else
{
CouponNumList.Add((CouponTypeitem.IssuedQty ?? 0) - (CouponTypeitem.IsVoucher ?? 0));
}
}
if (CouponFlag == false)
{
Remark += "请追加券数量！";
//activity.Remark = Remark;
activityBLL.Update(activity);//更新当前活动备注
continue;
}
int MinCouponNum = 0;
if (CouponNumList.Count > 0)
{
MinCouponNum = CouponNumList.Min();//当前活动奖品券种数量最少的券数
}
if (MinCouponNum == 0)
{
continue;
}
#endregion
#endregion
#region 批量新增券关系,修改券数量
int ResultConunt = 0;
string CouponTypeNameStr = "";//所有券名称
foreach (var CouponTypeitem in ActivityCouponTypeList)
{
CouponTypeNameStr += CouponTypeitem.CouponTypeName + ",";
ResultConunt = BatchAddSendCoupon(MinCouponNum, activity.ActivityID.Value.ToString(), activity.ActivityType.Value, CouponTypeitem.CouponTypeID.Value.ToString(), VipCardTypeID);
System.Threading.Thread.Sleep(2000);//沉睡2秒
}
#endregion
if (ResultConunt > 0)
{
#region 修改活动领券人数
activity.SendCouponQty = activity.SendCouponQty + ResultConunt;
activityBLL.Update(activity);
#endregion
#region 批量新增活动获赠奖品预发送消息
//CouponTypeNameStr = CouponTypeNameStr.TrimEnd(',');
foreach (var ActMessageitem in ActivityMessageLsit)
{
string Content = ActMessageitem.Content + "," + CouponTypeNameStr; //消息内容
BatchAddMessageSend(ResultConunt, activity.ActivityID.Value.ToString(), VipCardTypeID, ActMessageitem.MessageID.Value.ToString(), ActMessageitem.MessageType, Content, ActMessageitem.SendTime.Value, activity.ActivityType ?? 2);
System.Threading.Thread.Sleep(2000); //沉睡2秒
}
#endregion
#region 批量新增获赠信息
BatchAddPrizeReceive(ResultConunt, activity.ActivityID.Value.ToString(), VipCardTypeID, activity.ActivityType ?? 2);
System.Threading.Thread.Sleep(2000);//沉睡2秒
#endregion
}
}
#endregion
}