/// <summary>
/// 活动明细 (活动启动)
/// </summary>
/// <param name="EventId"></param>
/// <returns></returns>
public MarketEventEntity GetMarketEventInfoById(string EventId)
{
MarketEventEntity eventInfo = new MarketEventEntity();
DataSet ds = new DataSet();
ds = _currentDAO.GetMarketEventInfoById(EventId);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
eventInfo = DataTableToObject.ConvertToObject <MarketEventEntity>(ds.Tables[0].Rows[0]);
}
//获取活动模板信息
ds = _currentDAO.GetMarketTemplateByEventID(EventId);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
eventInfo.MarketTemplageInfo = DataTableToObject.ConvertToObject <MarketTemplateEntity>(ds.Tables[0].Rows[0]);
//eventInfo.TemplateContent = eventInfo.MarketTemplageInfo.TemplateContent;
}
//获取活动波段
ds = _currentDAO.GetMarketWaveBandByEventID(EventId);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
eventInfo.MarketWaveBandInfoList = DataTableToObject.ConvertToList <MarketWaveBandEntity>(ds.Tables[0]);
}
//获取活动门店
//获取活动人群
return(eventInfo);
}
private void GetMarketEventById()
{
string EventID = "FC573AEC440C4BC7A530351A3D841E6C";
MarketEventBLL bll = new MarketEventBLL(Default.GetLoggingSession());
MarketEventEntity eventInfo = new MarketEventEntity();
eventInfo = bll.GetMarketEventInfoById(EventID);
}
/// <summary>
/// 保存EventTime
/// </summary>
public string SaveEventTimeData()
{
var service = new MarketEventBLL(CurrentUserInfo);
var marketWaveBandBLL = new MarketWaveBandBLL(CurrentUserInfo);
var obj = new MarketEventEntity();
string content = string.Empty;
string error = "";
var responseData = new ResponseData();
string key = string.Empty;
string MarketEventID = string.Empty;
if (Request("data") != null && Request("data") != string.Empty)
{
key = Request("data").ToString().Trim();
}
if (Request("MarketEventID") != null && Request("MarketEventID") != string.Empty)
{
MarketEventID = Request("MarketEventID").ToString().Trim();
}
obj = key.DeserializeJSONTo <MarketEventEntity>();
if (obj.MarketEventID == null || obj.MarketEventID.Trim().Length == 0 ||
obj.MarketEventID == "null" || obj.MarketEventID == "undefined")
{
responseData.success = false;
responseData.msg = "活动标示不能为空";
return(responseData.ToJSON());
}
service.Update(obj, false);
//if (obj.MarketWaveBandList != null)
//{
// foreach (var item in obj.MarketWaveBandList)
// {
// item.BeginTime = Convert.ToDateTime(item.BeginTime).ToString("yyyy-MM-dd");
// item.EndTime = Convert.ToDateTime(item.EndTime).ToString("yyyy-MM-dd");
// var exsitObj = marketWaveBandBLL.GetByID(item.WaveBandID);
// if (exsitObj != null && exsitObj.WaveBandID.ToString().Length > 0)
// {
// marketWaveBandBLL.Update(item, false);
// }
// else
// {
// marketWaveBandBLL.Create(item);
// }
// }
//}
responseData.success = true;
responseData.msg = error;
content = responseData.ToJSON();
return(content);
}
public string SetWaveBandData()
{
string content = string.Empty;
var responseData = new ResponseData();
string key = string.Empty;
if (Request("data") != null && Request("data") != string.Empty)
{
key = Request("data").ToString().Trim();
}
MarketWaveBandEntity marketWaveBandEntity = new MarketWaveBandEntity();
marketWaveBandEntity = key.DeserializeJSONTo <MarketWaveBandEntity>();
if (marketWaveBandEntity == null)
{
responseData.success = false;
responseData.msg = "没有传递波段信息";
return(responseData.ToJSON());
}
if (marketWaveBandEntity.MarketWaveBandInfoList == null && marketWaveBandEntity.MarketWaveBandInfoList.Count == 0)
{
responseData.success = false;
responseData.msg = "没有传递波段内容";
return(responseData.ToJSON());
}
MarketWaveBandBLL server = new MarketWaveBandBLL(this.CurrentUserInfo);
foreach (MarketWaveBandEntity info in marketWaveBandEntity.MarketWaveBandInfoList)
{
if (info.WaveBandID == null || info.WaveBandID.Equals(""))
{
responseData.success = false;
responseData.msg = "没有传递主标识";
return(responseData.ToJSON());
}
else
{
if (info.WaveBandID.Equals("xxxxx"))
{
MarketEventEntity eventInfo = new MarketEventEntity();
eventInfo.MarketEventID = info.MarketEventID;
eventInfo.BeginTime = info.FactBeginTime;
eventInfo.EndTime = info.FactEndTime;
MarketEventBLL eventBll = new MarketEventBLL(this.CurrentUserInfo);
eventBll.Update(eventInfo, false);
}
else
{
server.Update(info, false);
}
}
}
responseData.success = true;
responseData.msg = "保存成功.";
content = responseData.ToJSON();
return(content);
}
/// <summary>
/// 保存EventPerson
/// </summary>
public string SaveEventPersonData()
{
var service = new MarketEventBLL(CurrentUserInfo);
var marketWaveBandBLL = new MarketWaveBandBLL(CurrentUserInfo);
var marketPersonBLL = new MarketPersonBLL(CurrentUserInfo);
var obj = new MarketPersonEntity();
var eventObj = new MarketEventEntity();
string content = string.Empty;
string error = "";
var responseData = new ResponseData();
string key = string.Empty;
string MarketEventID = string.Empty;
if (Request("data") != null && Request("data") != string.Empty)
{
key = Request("data").ToString().Trim();
}
if (Request("MarketEventID") != null && Request("MarketEventID") != string.Empty)
{
MarketEventID = Request("MarketEventID").ToString().Trim();
}
obj = key.DeserializeJSONTo <MarketPersonEntity>();
if (obj.MarketEventID == null || obj.MarketEventID.Trim().Length == 0 ||
obj.MarketEventID == "null" || obj.MarketEventID == "undefined")
{
responseData.success = false;
responseData.msg = "活动标示不能为空";
return(responseData.ToJSON());
}
marketPersonBLL.WebDelete(new MarketPersonEntity()
{
MarketEventID = obj.MarketEventID
});
if (obj.MarketPersonInfoList != null)
{
foreach (var item in obj.MarketPersonInfoList)
{
//item.MarketPersonID = Utils.NewGuid();
item.MarketEventID = MarketEventID;
marketPersonBLL.Create(item);
}
}
eventObj.MarketEventID = MarketEventID;
eventObj.PersonCount = obj.MarketPersonInfoList.Count;
service.Update(eventObj, false);
responseData.success = true;
responseData.msg = error;
content = responseData.ToJSON();
return(content);
}
/// <summary>
/// 修改状态
/// </summary>
/// <param name="Status"></param>
/// <param name="EventID"></param>
/// <returns></returns>
public bool SetMarketEventStatus(int Status, string EventID)
{
MarketEventEntity info = new MarketEventEntity();
info.MarketEventID = EventID;
info.EventStatus = Status;
Update(info, false);
return(true);
}
/// <summary>
/// 保存EventSend
/// </summary>
public string SaveEventSendData()
{
var service = new MarketEventBLL(CurrentUserInfo);
var obj = new MarketEventEntity();
string content = string.Empty;
string error = "";
var responseData = new ResponseData();
string key = string.Empty;
string MarketEventID = string.Empty;
bool chk = true;
bool chkSMS = true;
bool chkAPP = true;
if (Request("data") != null && Request("data") != string.Empty)
{
key = Request("data").ToString().Trim();
}
if (Request("MarketEventID") != null && Request("MarketEventID") != string.Empty)
{
MarketEventID = Request("MarketEventID").ToString().Trim();
}
if (Request("chk") != null && Request("chk") != string.Empty)
{
chk = Convert.ToBoolean(Request("chk").ToString().Trim());
}
if (Request("chkSMS") != null && Request("chkSMS") != string.Empty)
{
chkSMS = Convert.ToBoolean(Request("chkSMS").ToString().Trim());
}
if (Request("chkAPP") != null && Request("chkAPP") != string.Empty)
{
chkAPP = Convert.ToBoolean(Request("chkAPP").ToString().Trim());
}
obj = key.DeserializeJSONTo <MarketEventEntity>();
var eventObj = service.GetByID(MarketEventID);
string msgUrl = ConfigurationManager.AppSettings["push_weixin_msg_url"].Trim();
MarketPersonBLL marketPersonBLL = new MarketPersonBLL(this.CurrentUserInfo);
var sendFlag = marketPersonBLL.SetEventPush(MarketEventID, msgUrl, eventObj.SendTypeId, chk, chkSMS, chkAPP);
// Update
obj.MarketEventID = MarketEventID;
service.Update(obj, false);
responseData.success = sendFlag;
responseData.msg = error;
responseData.data = obj.MarketEventID;
content = responseData.ToJSON();
return(content);
}
/// <summary>
/// 活动分析
/// </summary>
/// <param name="EventID"></param>
/// <returns></returns>
public MarketEventAnalysisEntity GetEventAnalysisInfo(string EventID)
{
MarketEventAnalysisEntity info = new MarketEventAnalysisEntity();
MarketEventEntity eventInfo = new MarketEventEntity();
eventInfo = GetByID(EventID);
if (eventInfo != null)
{
info.BeginDate = eventInfo.BeginTime + " 到 " + eventInfo.EndTime;
info.EndDate = eventInfo.EndTime;
info.BudgetTotal = eventInfo.BudgetTotal;
info.MarketEventID = EventID;
info.PersonCount = eventInfo.PersonCount;
info.StoreCount = eventInfo.StoreCount;
info.CurrentSales = GetEventCurrentSales(EventID); //当前销售额
if (info.StoreCount == null || info.StoreCount == 0)
{
info.StoreCount = 0;
info.ResponseStoreCount = 0;
info.ResponseStoreRate = "0%";
}
else
{
info.ResponseStoreCount = info.StoreCount / 2 + 30;
info.ResponseStoreRate = (Convert.ToDecimal(info.ResponseStoreCount) / Convert.ToDecimal(info.StoreCount) * 100).ToString("#0.00") + "%";
}
if (info.PersonCount != null && info.PersonCount > 0)
{
info.ResponsePersonCount = _currentDAO.GetAnalysisResponsePersonCount(EventID);
info.ResponsePersonRate = ((Convert.ToDecimal(info.ResponsePersonCount) / Convert.ToDecimal(info.PersonCount) * 100)).ToString("#0.00") + "%";
}
else
{
info.PersonCount = 200;
info.ResponsePersonCount = _currentDAO.GetAnalysisResponsePersonCount(EventID);
info.ResponsePersonRate = ((Convert.ToDecimal(info.ResponsePersonCount) / Convert.ToDecimal(info.PersonCount) * 100)).ToString("#0.00") + "%";
}
}
return(info);
}
/// <summary>
/// 保存EventTemplate
/// </summary>
public string SaveEventTemplateData()
{
var service = new MarketEventBLL(CurrentUserInfo);
var obj = new MarketEventEntity();
string content = string.Empty;
string error = "";
var responseData = new ResponseData();
string key = string.Empty;
string MarketEventID = string.Empty;
if (Request("data") != null && Request("data") != string.Empty)
{
key = Request("data").ToString().Trim();
}
if (Request("MarketEventID") != null && Request("MarketEventID") != string.Empty)
{
MarketEventID = Request("MarketEventID").ToString().Trim();
}
obj = key.DeserializeJSONTo <MarketEventEntity>();
if (MarketEventID.Trim().Length == 0 || MarketEventID == "null" || MarketEventID == "undefined")
{
obj.MarketEventID = Utils.NewGuid();
obj.EventStatus = 1;
service.Create(obj);
}
else
{
obj.MarketEventID = MarketEventID;
service.Update(obj, false);
}
responseData.success = true;
responseData.msg = error;
responseData.data = obj.MarketEventID;
content = responseData.ToJSON();
return(content);
}
public void Update(MarketEventEntity pEntity, bool pIsUpdateNullField, IDbTransaction pTran)
{
_currentDAO.Update(pEntity, pIsUpdateNullField, pTran);
}
public void Update(MarketEventEntity pEntity, bool pIsUpdateNullField)
{
_currentDAO.Update(pEntity, pIsUpdateNullField);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pEntity"></param>
public void Delete(MarketEventEntity pEntity)
{
_currentDAO.Delete(pEntity);
}
/// <summary>
/// 保存Event
/// </summary>
public string SaveEventData()
{
var service = new MarketEventBLL(CurrentUserInfo);
var obj = new MarketEventEntity();
string content = string.Empty;
string error = "";
var responseData = new ResponseData();
string key = string.Empty;
string MarketEventID = string.Empty;
if (Request("data") != null && Request("data") != string.Empty)
{
key = Request("data").ToString().Trim();
}
if (Request("MarketEventID") != null && Request("MarketEventID") != string.Empty)
{
MarketEventID = Request("MarketEventID").ToString().Trim();
}
obj = key.DeserializeJSONTo <MarketEventEntity>();
//if (obj.BrandID == null || obj.BrandID.Trim().Length == 0)
//{
// responseData.success = false;
// responseData.msg = "品牌不能为空";
// return responseData.ToJSON();
//}
//if (obj.EventType == null || obj.EventType.Trim().Length == 0)
//{
// responseData.success = false;
// responseData.msg = "活动类型不能为空";
// return responseData.ToJSON();
//}
//if (obj.EventMode == null || obj.EventMode.Trim().Length == 0)
//{
// responseData.success = false;
// responseData.msg = "活动方式不能为空";
// return responseData.ToJSON();
//}
if (MarketEventID.Trim().Length == 0 || MarketEventID == "null" || MarketEventID == "undefined")
{
obj.MarketEventID = Utils.NewGuid();
obj.CustomerId = CurrentUserInfo.CurrentUser.customer_id;
obj.EventStatus = 1;
obj.StoreCount = 0;
obj.PersonCount = 0;
service.Create(obj);
}
else
{
obj.MarketEventID = MarketEventID;
service.Update(obj, false);
}
responseData.success = true;
responseData.msg = error;
responseData.data = obj.MarketEventID;
content = responseData.ToJSON();
return(content);
}
/// <summary>
/// 根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public MarketEventEntity[] QueryByEntity(MarketEventEntity pQueryEntity, OrderBy[] pOrderBys)
{
return(_currentDAO.QueryByEntity(pQueryEntity, pOrderBys));
}
/// <summary>
/// 分页根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public PagedQueryResult <MarketEventEntity> PagedQueryByEntity(MarketEventEntity pQueryEntity, OrderBy[] pOrderBys, int pPageSize, int pCurrentPageIndex)
{
return(_currentDAO.PagedQueryByEntity(pQueryEntity, pOrderBys, pPageSize, pCurrentPageIndex));
}
/// <summary>
/// 创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Create(MarketEventEntity pEntity)
{
_currentDAO.Create(pEntity);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Update(MarketEventEntity pEntity)
{
Update(pEntity, true);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Update(MarketEventEntity pEntity, IDbTransaction pTran)
{
Update(pEntity, true, pTran);
}
/// <summary>
/// 在事务内创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Create(MarketEventEntity pEntity, IDbTransaction pTran)
{
_currentDAO.Create(pEntity, pTran);
}
