/// <summary>
/// 保存更新促销活动信息
/// </summary>
/// <param name="para"></param>
/// <returns></returns>
public void SavePanicbuyingEvent(SetCTWEventRP para, T_CTW_PanicbuyingEventKVBLL bllPanicbuyingEventKV, ObjectImagesBLL imageBll, T_CTW_LEventInteractionBLL bllCustomerInteraction, string strThemeId, out string strStartDate, out string strEndDate)
{
strStartDate = string.Empty;
strEndDate = string.Empty;
var PanicbuyingEvent = para.PanicbuyingEventInfo;
imageEntity = new ObjectImagesEntity();
imageEntity.ImageURL = PanicbuyingEvent.ImageUrl;
imageEntity.ObjectId = "";
imageEntity.CreateBy = loggingSessionInfo.UserID;
imageEntity.IsDelete = 0;
imageEntity.CustomerId = loggingSessionInfo.ClientID;
imageEntity.ImageId = Guid.NewGuid().ToString();
imageBll.Create(imageEntity);
if (!string.IsNullOrEmpty(para.CTWEventId))
{
bllPanicbuyingEventKV.DeleteByCTWEventID(para.CTWEventId);
}
entityPanicbuyingEventKV = new T_CTW_PanicbuyingEventKVEntity()
{
CTWEventId = new Guid(strCTWEventId),
EventName = PanicbuyingEvent.EventName,
ImageId = imageEntity.ImageId
};
bllPanicbuyingEventKV.Create(entityPanicbuyingEventKV);
if (!string.IsNullOrEmpty(para.CTWEventId))
{
bllCustomerInteraction.DeleteByCTWEventID(para.CTWEventId);
}
foreach (var eventid in PanicbuyingEvent.PanicbuyingEventId)
{
///互动类型与（游戏或促销）关联
entityInteraction = new T_CTW_LEventInteractionEntity()
{
CTWEventId = new Guid(strCTWEventId),
ThemeId = new Guid(strThemeId),
InteractionType = para.InteractionType,
DrawMethodCode = para.DrawMethodCode,
LeventId = eventid.ToString(),
CustomerId = loggingSessionInfo.ClientID
};
bllCustomerInteraction.Create(entityInteraction);
}
DataSet ds = bllCustomerInteraction.GetPanicbuyingEventDate(strCTWEventId);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
strStartDate = ds.Tables[0].Rows[0]["BeginTime"].ToString();
strEndDate = ds.Tables[0].Rows[0]["EndTime"].ToString();
}
}
/// <summary>
/// 保存更新游戏信息
/// </summary>
/// <param name="para"></param>
/// <returns></returns>
public void SaveGameEvent(SetCTWEventRP para, LPrizesBLL bllPrize, T_CTW_LEventInteractionBLL bllCustomerInteraction, string strThemeId, out string strStartDate, out string strEndDate, out string strGameEventGuid)
{
strGameEventGuid = string.Empty;
var imageBll = new ObjectImagesBLL(loggingSessionInfo);
LEventsBLL bllGameEvent = new LEventsBLL(loggingSessionInfo);
var eventEntity = new LEventsEntity();
strStartDate = para.GameEventInfo.BeginTime;
strEndDate = para.GameEventInfo.EndTime + " 23:59:59";
if (string.IsNullOrEmpty(para.GameEventInfo.LeventId))
{
strGameEventGuid = Guid.NewGuid().ToString();
eventEntity.EventID = strGameEventGuid;
eventEntity.Title = para.GameEventInfo.Title;
eventEntity.BeginTime = para.GameEventInfo.BeginTime;
eventEntity.EndTime = para.GameEventInfo.EndTime;
eventEntity.DrawMethodId = GetDrawMethodIdByDrawMethodCode(para.DrawMethodCode);
eventEntity.PersonCount = para.GameEventInfo.PersonCount;
eventEntity.PointsLottery = para.GameEventInfo.PointsLottery;
eventEntity.LotteryNum = para.GameEventInfo.LotteryNum;
eventEntity.IsDelete = 0;
if (DateTime.Compare(Convert.ToDateTime(para.GameEventInfo.BeginTime), Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))) <= 0 && DateTime.Compare(Convert.ToDateTime(para.GameEventInfo.EndTime), Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))) >= 0)
{
eventEntity.EventStatus = 20; //10=未开始,20=运行中,30=暂停,40=结束
}
else if (DateTime.Compare(Convert.ToDateTime(para.GameEventInfo.BeginTime), Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))) > 0)
{
eventEntity.EventStatus = 10; //10=未开始,20=运行中,30=暂停,40=结束
}
eventEntity.IsCTW = 1;
eventEntity.CustomerId = loggingSessionInfo.ClientID;
bllGameEvent.Create(eventEntity);
}
else
{
strGameEventGuid = para.GameEventInfo.LeventId;
eventEntity = bllGameEvent.GetByID(strGameEventGuid);
eventEntity.Title = para.GameEventInfo.Title;
eventEntity.BeginTime = para.GameEventInfo.BeginTime;
eventEntity.EndTime = para.GameEventInfo.EndTime;
eventEntity.DrawMethodId = GetDrawMethodIdByDrawMethodCode(para.DrawMethodCode);
eventEntity.PersonCount = para.GameEventInfo.PersonCount;
eventEntity.PointsLottery = para.GameEventInfo.PointsLottery;
eventEntity.LotteryNum = para.GameEventInfo.LotteryNum;
bllGameEvent.Update(eventEntity);
}
///图片
if (para.GameEventInfo.ImageList.Count > 0)
{
imageBll.DeleteByObjectID(strGameEventGuid);
foreach (var i in para.GameEventInfo.ImageList)
{
imageEntity = new ObjectImagesEntity();
imageEntity.ImageURL = i.ImageURL;
imageEntity.ObjectId = strGameEventGuid;
imageEntity.CreateBy = loggingSessionInfo.UserID;
imageEntity.ImageId = Guid.NewGuid().ToString();
imageEntity.BatId = i.BatId;
imageEntity.RuleId = para.GameEventInfo.RuleId ?? 1;
imageEntity.RuleContent = para.GameEventInfo.RuleContent;
imageEntity.IsDelete = 0;
imageEntity.CustomerId = loggingSessionInfo.ClientID;
imageBll.Create(imageEntity);
}
}
//奖品信息
var entityPrize = new LPrizesEntity();
var redisPrizePoolsBLL = new JIT.CPOS.BS.BLL.RedisOperationBLL.PrizePools.RedisPrizePoolsBLL();
if (!string.IsNullOrEmpty(para.GameEventInfo.LeventId))
{
//bllPrize.Delete(new LPrizesEntity() { EventId = para.GameEventInfo.LeventId });
bllPrize.DeletePrizesByEventId(para.GameEventInfo.LeventId);
CC_PrizePool prizePool = new CC_PrizePool();
prizePool.CustomerId = loggingSessionInfo.ClientID;
prizePool.EventId = para.GameEventInfo.LeventId;
redisPrizePoolsBLL.DeletePrizePoolsList(prizePool);
}
if (para.GameEventInfo.PrizeList.Count > 0)
{
foreach (var i in para.GameEventInfo.PrizeList)
{
entityPrize.EventId = strGameEventGuid;
entityPrize.PrizeTypeId = i.PrizeTypeId;
entityPrize.Point = i.Point;
entityPrize.CouponTypeID = i.CouponTypeID;
entityPrize.PrizeName = i.PrizeName;
entityPrize.CountTotal = i.PrizeCount;
entityPrize.CreateBy = loggingSessionInfo.UserID;
entityPrize.PrizesID = Guid.NewGuid().ToString();
bllPrize.SavePrize(entityPrize);
}
//入奖品池队列
LPrizePoolsBLL bllPools = new LPrizePoolsBLL(loggingSessionInfo);
DataSet dsPools = bllPools.GetPrizePoolsByEvent(loggingSessionInfo.ClientID, strGameEventGuid);
if (dsPools != null && dsPools.Tables.Count > 0 && dsPools.Tables[0].Rows.Count > 0)
{
var poolTemp = DataTableToObject.ConvertToList <CC_PrizePool>(dsPools.Tables[0]);
var poolsList = Utils.GetRandomList <CC_PrizePool>(poolTemp); //随机列表
if (poolsList != null && poolsList.Count > 0)
{
CC_PrizePool prizePool = new CC_PrizePool();
prizePool.CustomerId = loggingSessionInfo.ClientID;
prizePool.EventId = strGameEventGuid;
redisPrizePoolsBLL.DeletePrizePoolsList(prizePool);
redisPrizePoolsBLL.SetPrizePoolsToRedis(poolsList);
}
}
}
if (!string.IsNullOrEmpty(para.CTWEventId))
{
bllCustomerInteraction.DeleteByCTWEventID(para.CTWEventId);
}
///互动类型与（游戏或促销）关联
entityInteraction = new T_CTW_LEventInteractionEntity()
{
CTWEventId = new Guid(strCTWEventId),
ThemeId = new Guid(strThemeId),
InteractionType = para.InteractionType,
DrawMethodCode = para.DrawMethodCode,
LeventId = strGameEventGuid,
OriginalLeventId = new Guid(para.OriginalLeventId),
CustomerId = loggingSessionInfo.ClientID
};
bllCustomerInteraction.Create(entityInteraction);
}
protected override SetCTWEventRD ProcessRequest(APIRequest <SetCTWEventRP> pRequest)
{
//图文信息
//微信 公共平台
var wapentity = new WApplicationInterfaceBLL(loggingSessionInfo).QueryByEntity(new WApplicationInterfaceEntity
{
CustomerId = loggingSessionInfo.ClientID,
IsDelete = 0
}, null).FirstOrDefault();//取默认的第一个微信
if (wapentity == null)
{
throw new APIException("微信公众号未授权")
{
ErrorCode = 343
};
}
var rd = new SetCTWEventRD();
var para = pRequest.Parameters;
strCTWEventId = para.CTWEventId;
string strThemeId = string.Empty;
string strStartDate = string.Empty;
string strEndDate = string.Empty;
string strGameEventGuid = string.Empty;
string strPageParamJson = string.Empty;
T_CTW_LEventBLL bllCustomerEvent = new T_CTW_LEventBLL(loggingSessionInfo);
T_CTW_LEventThemeBLL bllCustomerTheme = new T_CTW_LEventThemeBLL(loggingSessionInfo);
T_CTW_LEventInteractionBLL bllCustomerInteraction = new T_CTW_LEventInteractionBLL(loggingSessionInfo);
T_CTW_PanicbuyingEventKVBLL bllPanicbuyingEventKV = new T_CTW_PanicbuyingEventKVBLL(loggingSessionInfo);
T_CTW_SpreadSettingBLL bllSpreadSetting = new T_CTW_SpreadSettingBLL(loggingSessionInfo);
LPrizesBLL bllPrize = new LPrizesBLL(loggingSessionInfo);
ObjectImagesBLL imageBll = new ObjectImagesBLL(loggingSessionInfo);
entityCustomerEvent = bllCustomerEvent.GetByID(strCTWEventId);
if (entityCustomerEvent != null)
{
///风格
entityTheme = bllCustomerTheme.QueryByEntity(new T_CTW_LEventThemeEntity()
{
CTWEventId = new Guid(strCTWEventId), OriginalThemeId = new Guid(para.OriginalThemeId)
}, null).FirstOrDefault();
//互动方式
entityInteraction = bllCustomerInteraction.QueryByEntity(new T_CTW_LEventInteractionEntity {
CTWEventId = new Guid(strCTWEventId), OriginalLeventId = new Guid(para.OriginalLeventId)
}, null).FirstOrDefault();
}
//保存风格
SaveAndUpdateTheme(para, entityTheme, out strThemeId);
//互动类型--游戏
if (para.InteractionType == 1 && para.GameEventInfo != null)
{
SaveGameEvent(para, bllPrize, bllCustomerInteraction, strThemeId, out strStartDate, out strEndDate, out strGameEventGuid);
para.MaterialText.PageParamJson = "[{\"key\":\"eventId\",\"value\":\"" + strCTWEventId + "\"}]";
strPageParamJson = "[{\"key\":\"eventId\",\"value\":\"" + strCTWEventId + "\"}]";
}
//互动类型--促销
if (para.InteractionType == 2 && para.PanicbuyingEventInfo != null)
{
SavePanicbuyingEvent(para, bllPanicbuyingEventKV, imageBll, bllCustomerInteraction, strThemeId, out strStartDate, out strEndDate);
string strEventType = string.Empty;
switch (para.DrawMethodCode)
{
case "TG":
strEventType = "1";
break;
case "QG":
strEventType = "2";
break;
case "RX":
strEventType = "3";
break;
default:
strEventType = "99";
break;
}
para.MaterialText.PageParamJson = "[{\"key\":\"CTWEventId\",\"value\":\"" + strCTWEventId + "\"},{\"key\":\"eventTypeId\",\"value\":\"" + strEventType + "\"}]";
strPageParamJson = "[{\"key\":\"CTWEventId\",\"value\":\"" + strCTWEventId + "\"},{\"key\":\"eventTypeId\",\"value\":\"" + strEventType + "\"}]";
//SaveAndUpdatePanicbuyingEvent(para,bllPrize,bllPanicbuyingEventKV,imageBll,bllCustomerInteraction, strThemeId, out strStartDate, out strEndDate);
}
string strFocesQRCodeUrl = string.Empty;
//分享，推广
if (para.SpreadSettingList.Count > 0)
{
SaveSpreadSetting(para, bllSpreadSetting, imageBll, wapentity, out strFocesQRCodeUrl);
}
///推广关注的奖励设置入 触点活动数据表
if (para.ContactPrizeList != null && para.ContactPrizeList.Count > 0)
{
SaveContactPrize(para, bllPrize, strStartDate, strEndDate);
}
string strOnlineQRCodeId = string.Empty;
string strOfflineQRCodeId = string.Empty;
string strOnlineQRCodeUrl = string.Empty;
string strOfflineQRCodeUrl = string.Empty;
string strOnlineRedirectUrl = string.Empty;
string strOfflineRedirectUrl = string.Empty;
var WQRCodeManagerbll = new WQRCodeManagerBLL(loggingSessionInfo);
if (!string.IsNullOrEmpty(para.OfflineQRCodeId))
{
WQRCodeManagerbll.Delete(new WQRCodeManagerEntity()
{
QRCodeId = new Guid(para.OfflineQRCodeId)
});
}
if (!string.IsNullOrEmpty(para.OnlineQRCodeId))
{
WQRCodeManagerbll.Delete(new WQRCodeManagerEntity()
{
QRCodeId = new Guid(para.OnlineQRCodeId)
});
}
CreateQRCode(para, wapentity, strPageParamJson, out strOfflineQRCodeId, out strOfflineQRCodeUrl, out strOfflineRedirectUrl);
CreateH5QRCode(para, wapentity, out strOnlineQRCodeId, out strOnlineQRCodeUrl, out strOnlineRedirectUrl);
rd.OfflineQRCodeUrl = strOfflineQRCodeUrl;
rd.OnlineQRCodeUrl = strOnlineQRCodeUrl;
rd.OfflineRedirectUrl = strOfflineRedirectUrl;
rd.OnlineRedirectUrl = strOnlineRedirectUrl;//strFocesQRCodeUrl;
if (entityCustomerEvent != null)
{ //活动主表
entityCustomerEvent.Name = para.TemplateName;
entityCustomerEvent.Desc = para.TemplateDesc;
entityCustomerEvent.InteractionType = para.InteractionType;
entityCustomerEvent.ActivityGroupId = new Guid(para.ActivityGroupId);
entityCustomerEvent.ImageURL = para.TemplateImageURL;
entityCustomerEvent.StartDate = Convert.ToDateTime(strStartDate);
entityCustomerEvent.EndDate = Convert.ToDateTime(strEndDate);
entityCustomerEvent.OnlineQRCodeId = strOnlineQRCodeId;
entityCustomerEvent.OfflineQRCodeId = strOfflineQRCodeId;
entityCustomerEvent.OffLineRedirectUrl = strOfflineRedirectUrl;
entityCustomerEvent.OnLineRedirectUrl = strOnlineRedirectUrl;
bllCustomerEvent.Update(entityCustomerEvent);
}
else
{
entityCustomerEvent = new T_CTW_LEventEntity()
{
CTWEventId = new Guid(para.CTWEventId),
TemplateId = new Guid(para.TemplateId),
Name = para.TemplateName,
Desc = para.TemplateDesc,
ActivityGroupId = new Guid(para.ActivityGroupId),
InteractionType = para.InteractionType,
ImageURL = para.TemplateImageURL,
Status = 10,
CustomerId = loggingSessionInfo.ClientID,
StartDate = Convert.ToDateTime(strStartDate),
EndDate = Convert.ToDateTime(strEndDate),
OfflineQRCodeId = strOfflineQRCodeId,
OnlineQRCodeId = strOnlineQRCodeId,
OffLineRedirectUrl = strOfflineRedirectUrl,
OnLineRedirectUrl = strOnlineRedirectUrl
};
bllCustomerEvent.Create(entityCustomerEvent);
}
return(rd);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Update(T_CTW_LEventInteractionEntity pEntity, IDbTransaction pTran)
{
_currentDAO.Update(pEntity, pTran);
}
/// <summary>
/// 创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Create(T_CTW_LEventInteractionEntity pEntity)
{
_currentDAO.Create(pEntity);
}
/// <summary>
/// 分页根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public PagedQueryResult <T_CTW_LEventInteractionEntity> PagedQueryByEntity(T_CTW_LEventInteractionEntity 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_CTW_LEventInteractionEntity[] QueryByEntity(T_CTW_LEventInteractionEntity pQueryEntity, OrderBy[] pOrderBys)
{
return(_currentDAO.QueryByEntity(pQueryEntity, pOrderBys));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pEntity"></param>
public void Delete(T_CTW_LEventInteractionEntity pEntity)
{
_currentDAO.Delete(pEntity);
}
