public JsonResult GetTiresFloorInfoByFloorActivity(Guid flashId, Guid parentId)
{
TiresFloorActivityConfig result = new TiresFloorActivityConfig();
result = manager.SelectTiresActivityByFlashId(flashId, parentId);
return(Json(result, JsonRequestBehavior.AllowGet));
}
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 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);
}
private TiresFloorActivityConfig ConvertDetails(TiresFloorActivityConfig result, FlashSaleModel flashSaleInfo, List <DataAccess.Entity.TiresActivity.SimpleTireProductInfo> tireInfo)
{
try
{
result.ProductList = (from fs in flashSaleInfo.Products
join pl in result.ProductList ?? new List <DataAccess.Entity.TiresActivity.TiresActivityProductConfig>()
on fs.PID equals pl.ProductId into temp
from t in temp.DefaultIfEmpty()
join tp in tireInfo on fs.PID equals tp.PID into infoData
from o in infoData.DefaultIfEmpty()
select new DataAccess.Entity.TiresActivity.TiresActivityProductConfig()
{
ActivityId = fs.ActivityID,
ProductId = fs.PID,
ProductName = fs.ProductName,
Price = fs.Price,
Size = o != null ? o.CP_Tire_Rim : string.Empty,
Specification = o != null && !string.IsNullOrEmpty(o.CP_Tire_Width)
? (o.CP_Tire_Width + "/" + (!string.IsNullOrEmpty(o.CP_Tire_AspectRatio)
? o.CP_Tire_AspectRatio : string.Empty)) : string.Empty,
MaxQuantity = fs.MaxQuantity,
TotalQuantity = fs.TotalQuantity,
AdvertiseTitle = t != null && !string.IsNullOrEmpty(t.AdvertiseTitle) ? t.AdvertiseTitle : fs.AdvertiseTitle,
IsShow = t != null && !string.IsNullOrEmpty(t.AdvertiseTitle),
SpecialCondition = t != null ? t.SpecialCondition : 0,
IsCancelProgressBar = t != null ? t.IsCancelProgressBar : false
}).ToList();
}
catch (Exception ex)
{
logger.Error(ex);
}
return(result);
}
public ActionResult TiresFloorInfo(Guid?floorId, Guid parentId)
{
TiresFloorActivityConfig result = new TiresFloorActivityConfig();
ViewData["ImgDic"] = manager.GetAllImgMapping();
ViewBag.ParentId = parentId;
ViewBag.FloorActivityId = floorId ?? Guid.Empty;
if (floorId != null && floorId.Value != Guid.Empty)
{
result = manager.SelectTiresActivityByFloorId(floorId.Value);
}
return(View(result));
}
public static int InsertTiresFloorActivity(SqlConnection conn, TiresFloorActivityConfig data)
{
const string sql = @"INSERT INTO Configuration..TiresFloorActivityConfig
(TiresActivityId,
FloorActivityId,
FlashSaleId,
CreateDateTime,
LastUpdateDateTime
)
VALUES(@TiresActivityId,
@FloorActivityId,
@FlashSaleId,
GETDATE(),
GETDATE()
)";
return(conn.Execute(sql, new { TiresActivityId = data.TiresActivityId, FloorActivityId = data.FloorActivityId, FlashSaleId = data.FlashSaleId }, commandType: CommandType.Text));
}
public static int UpdateTiresFloorActivity(SqlConnection conn, TiresFloorActivityConfig data)
{
const string sql = "UPDATE Configuration..TiresFloorActivityConfig SET LastUpdateDateTime=GETDATE() WHERE FlashSaleId=@FlashSaleId";
return(conn.Execute(sql, new { FlashSaleId = data.FlashSaleId }, commandType: CommandType.Text));
}
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);
}
