public TiresFloorActivityConfig SelectTiresActivityByFloorId(Guid floorId)
{
var result = new TiresFloorActivityConfig();
try
{
dbScopeReadManager.Execute(conn =>
{
result = DALTiresActivity.SelectTiresFloorInfoByFloorId(conn, floorId);
if (result != null)
{
result.ImgList = DALTiresActivity.SelectActivityImgById(conn, result.FloorActivityId) ?? new List <DataAccess.Entity.TiresActivity.ActivityImageConfig>();
result.ProductList = DALTiresActivity.SelectRegionProductsByActivityId(conn, result.FloorActivityId) ?? new List <DataAccess.Entity.TiresActivity.TiresActivityProductConfig>();
var flashSaleInfo = SelectFlashSaleDataByActivityID(result.FlashSaleId);
if (flashSaleInfo != null && flashSaleInfo.Products != null && flashSaleInfo.Products.Any())
{
var products = flashSaleInfo.Products;
var pidStr = string.Join(",", products.Select(x => x.PID));
var tireInfo = DALTiresActivity.SelectProductInfoByPID(conn, pidStr);
result = ConvertDetails(result, flashSaleInfo, tireInfo);
}
}
});
}
catch (Exception ex)
{
logger.Error(ex);
}
return(result);
}
public TiresFloorActivityConfig SelectTiresActivityByFlashId(Guid flashId, Guid parentId)
{
var result = new TiresFloorActivityConfig();
try
{
dbScopeReadManager.Execute(conn =>
{
result = DALTiresActivity.SelectTiresFloorInfoByFlashId(conn, flashId, parentId);
if (result != null)
{
var flashSaleInfo = SelectFlashSaleDataByActivityID(flashId);
if (flashSaleInfo != null && flashSaleInfo.Products != null && flashSaleInfo.Products.Any())
{
var products = flashSaleInfo.Products;
var pidStr = string.Join(",", products.Select(x => x.PID));
var tireInfo = DALTiresActivity.SelectProductInfoByPID(conn, pidStr);
result = ConvertDetails(result, flashSaleInfo, tireInfo);
}
}
});
}
catch (Exception ex)
{
logger.Error(ex);
}
return(result);
}
public bool DeleteTiresActivityConfig(Guid activityId, string user)
{
var result = false;
try
{
dbScopeManager.CreateTransaction(conn =>
{
DALTiresActivity.DeleteTiresActivityConfig(conn, activityId);
var floorActivityInfo = DALTiresActivity.SelectTiresFloorInfoByParentId(conn, activityId);
if (floorActivityInfo != null && floorActivityInfo.Any())
{
foreach (var item in floorActivityInfo)
{
DALTiresActivity.DeleteTiresFloorActivity(conn, item.FloorActivityId);
}
}
result = true;
});
}
catch (Exception ex)
{
logger.Error(ex);
}
if (result)
{
InsertLog("DeleteTiresActivityConfig", activityId, "删除轮胎活动", "删除轮胎活动", user, LogType);
CallCRMService.NewDeleteActivityBySourceId(activityId.ToString(), CRMSourceType.TiresActivityTwo, user);
}
return(result);
}
public bool UpserTiresActivity(TiresActivityModel data, string user)
{
var result = false;
var msg = string.Empty;
var isAdd = false;
try
{
dbScopeManager.Execute(conn =>
{
if (data == null || data.ActivityId == Guid.Empty)
{
isAdd = true;
msg = "增加轮胎活动";
data.ActivityId = Guid.NewGuid();
result = DALTiresActivity.InsertTiresActivityConfig(conn, data, user) > 0;
}
else
{
msg = "修改轮胎活动";
result = DALTiresActivity.UpdateTiresActivityConfig(conn, data, user) > 0;
}
});
}
catch (Exception ex)
{
logger.Error(ex);
}
if (result)
{
InsertLog("UpserTiresActivity", data.ActivityId, JsonConvert.SerializeObject(data), msg, user, LogType);
if (isAdd)
{
CallCRMService.NewAddActivity(data.ActivityName, data.StartTime.GetValueOrDefault(), data.EndTime.GetValueOrDefault(), "", data.ActivityRules, data.ActivityId.ToString(), CRMSourceType.TiresActivityTwo, user);
}
else
{
CallCRMService.NewUpdateActivity(data.ActivityName, data.StartTime.GetValueOrDefault(), data.EndTime.GetValueOrDefault(), "", data.ActivityRules, data.ActivityId.ToString(), CRMSourceType.TiresActivityTwo, user);
}
}
return(result);
}
public bool DeleteTiresFloorActivity(Guid activityId, Guid floorId, string user)
{
var result = false;
try
{
result = dbScopeManager.Execute(conn => DALTiresActivity.DeleteTiresFloorActivity(conn, floorId)) > 0;
}
catch (Exception ex)
{
logger.Error(ex);
}
if (result)
{
InsertLog("DeleteTiresActivityConfig", activityId, "删除轮胎楼层活动", "删除轮胎楼层活动", user, LogType);
}
return(result);
}
public List <TiresActivityModel> SelectTiresActivity(string activityName, DateTime?startTime, DateTime?endTime, Guid?activityId, int pageIndex, int pageSize)
{
var result = new List <TiresActivityModel>();
try
{
dbScopeReadManager.Execute(conn =>
{
result = DALTiresActivity.SelectTiresActivity(conn, activityName, startTime, endTime, activityId ?? Guid.Empty, pageIndex, pageSize);
if (result != null && result.Any())
{
result.ForEach(x => x.TiresFloorList = DALTiresActivity.SelectTiresFloorInfoByParentId(conn, x.ActivityId));
}
});
}
catch (Exception ex)
{
logger.Error(ex);
}
return(result);
}
public bool UpsertTiresFloorActivity(TiresFloorActivityConfig model, string user)
{
var result = false;
string msg = string.Empty;
try
{
dbScopeManager.CreateTransaction(conn =>
{
if (model != null && model.TiresActivityId != Guid.Empty && model.FlashSaleId != Guid.Empty)
{
if (model.FloorActivityId == Guid.Empty)
{
msg = "添加楼层活动";
model.FloorActivityId = Guid.NewGuid();
DALTiresActivity.InsertTiresFloorActivity(conn, model);
}
else
{
msg = "修改楼层活动";
DALTiresActivity.UpdateTiresFloorActivity(conn, model);
}
foreach (var item in model.ImgList)
{
item.ActivityId = model.FloorActivityId;
var imgInfo = DALTiresActivity.SelectActivityImgByIdAndType(conn, item.ActivityId, item.Type);
if (imgInfo != null)
{
DALTiresActivity.UpdateActivityImgByIdAnType(conn, item.ActivityId, item.ImgUrl, item.Type, item.Position);
}
else
{
DALTiresActivity.InsertActivityImg(conn, item.ActivityId, item.ImgUrl, item.Type, item.Position);
}
}
foreach (var item in model.ProductList)
{
item.ActivityId = model.FloorActivityId;
var proInfo = DALTiresActivity.SelectRegionProductsByPID(conn, item.ActivityId, item.ProductId);
if (proInfo != null)
{
DALTiresActivity.UpdateTiresProductInfo(conn, item.ActivityId, item.ProductId, item.AdvertiseTitle, item.SpecialCondition, item.IsCancelProgressBar, item.Position);
}
else
{
DALTiresActivity.InsertTiresProductInfo(conn, item.ActivityId, item.ProductId, item.AdvertiseTitle, item.SpecialCondition, item.IsCancelProgressBar, item.Position);
}
}
result = true;
}
});
}
catch (Exception ex)
{
logger.Error($"UpsertTiresFloorActivity Error:{ex.Message}; Stack:{ex.StackTrace}", ex);
}
if (result)
{
model.ProductList = new List <DataAccess.Entity.TiresActivity.TiresActivityProductConfig>();
model.ImgList = new List <DataAccess.Entity.TiresActivity.ActivityImageConfig>();
InsertLog("UpsertTiresFloorActivity", model.TiresActivityId, JsonConvert.SerializeObject(model), msg, user, LogType);
}
return(result);
}
