public static int DeleteVirtualProductConfig(string pid)
{
using (var conn = ProcessConnection.OpenConfiguration)
{
return(DalGroupBuyingProductGroupConfig.DeleteVirtualProductConfig(conn, pid, ThreadIdentity.Operator.UserName));
}
}
/// <summary>
/// 根据PID查询单个优惠券详情
/// </summary>
/// <param name="pid">pid</param>
/// <returns></returns>
public static List <VirtualProductCouponConfigModel> FetchProductCouponConfig(string pid)
{
using (var conn = ProcessConnection.OpenConfigurationReadOnly)
{
return(DalGroupBuyingProductGroupConfig.FetchProductCouponConfig(conn, pid).ToList());
}
}
public static List <string> SelectProductCouponConfig(IEnumerable <string> pids)
{
using (var conn = ProcessConnection.OpenConfigurationReadOnly)
{
return(DalGroupBuyingProductGroupConfig.SelectProductCouponConfig(conn, pids).ToList());
}
}
/// <summary>
/// 查询虚拟商品列表
/// </summary>
/// <param name="pageIndex">pageIndex</param>
/// <param name="pageSize">pageSize</param>
/// <param name="pid">商品pid</param>
/// <returns></returns>
public static List <VirtualProductCouponConfigModel> SelectProductCouponConfig(int pageIndex, int pageSize, string pid)
{
using (var conn = ProcessConnection.OpenConfigurationReadOnly)
{
return(DalGroupBuyingProductGroupConfig.
SelectProductCouponConfig(conn, pageIndex, pageSize, pid).ToList());
}
}
public static int SelectProductCouponConfigCount(string pid)
{
using (var conn = ProcessConnection.OpenConfigurationReadOnly)
{
return(DalGroupBuyingProductGroupConfig.
SelectProductCouponConfigCount(conn, pid));
}
}
public static List <LotteryUserModel> LotteryInfoList(string productGroupId, int orderId, int lotteryResult, PagerModel pager)
{
var totalCount = DalGroupBuyingProductGroupConfig.LotteryInfoCount(productGroupId, orderId, lotteryResult);
pager.TotalItem = totalCount;
if (totalCount > 0)
{
return(DalGroupBuyingProductGroupConfig.LotteryInfoList(productGroupId, orderId, lotteryResult, pager.CurrentPage, pager.PageSize));
}
return(new List <LotteryUserModel>());
}
public static bool DeleteLotteryCoupons(string productGroupId, List <Guid> couponIds, string _operator)
{
var result = false;
foreach (var item in couponIds)
{
var resultItem = DalGroupBuyingProductGroupConfig.DeleteLotteryCoupon(productGroupId, item);
var resultStr = resultItem ? "成功" : "失败";
LotteryLog(productGroupId, "DeleteCouponOne", _operator, $"{item:D}优惠券删除{resultStr}");
result |= resultItem;
}
return(result);
}
public List <VW_ProductsModel> GetProductsByPIDAndIsLottery(string pid, bool isLottery)
{
List <VW_ProductsModel> result = new List <VW_ProductsModel>();
try
{
result = dbScopeReadManager.Execute(conn => DalGroupBuyingProductGroupConfig.GetProductsByPIDAndIsLottery(conn, pid, isLottery));
}
catch (Exception ex)
{
logger.Error(ex);
}
return(result);
}
public static List <LotteryCouponModel> GetLotteryCoupon(string productGroupId)
{
var data = DalGroupBuyingProductGroupConfig.GetLotteryCouponList(productGroupId);
var result = new List <LotteryCouponModel>();
if (data.Any())
{
foreach (var item in data)
{
var resultItem = GetCouponDetail(item.Item1, productGroupId);
if (resultItem != null)
{
resultItem.Creator = item.Item2;
result.Add(resultItem);
}
}
}
return(result);
}
public static List <GroupBuyingStockModel> GetGroupBuyingStockInfo(List <string> pids)
{
var data = DalGroupBuyingProductGroupConfig.GetGroupBuyingStockInfo(pids);
var result = data.GroupBy(g => g.PID).Select(g => new GroupBuyingStockModel
{
PID = g.Key,
SHAvailableStockQuantity =
g.FirstOrDefault(t => t.WAREHOUSEID == 8598)?.TotalAvailableStockQuantity ?? 0,
SHStockCost = g.FirstOrDefault(t => t.WAREHOUSEID == 8598)?.StockCost ?? 0,
SHZaituStockQuantity = g.FirstOrDefault(t => t.WAREHOUSEID == 8598)?.CaigouZaitu ?? 0,
WHAvailableStockQuantity =
g.FirstOrDefault(t => t.WAREHOUSEID == 7295)?.TotalAvailableStockQuantity ?? 0,
WHStockCost = g.FirstOrDefault(t => t.WAREHOUSEID == 7295)?.StockCost ?? 0,
WHZaituStockQuantity = g.FirstOrDefault(t => t.WAREHOUSEID == 7295)?.CaigouZaitu ?? 0,
TotalAvailableStockQuantity = g.Sum(t => t.TotalAvailableStockQuantity),
TotalZaituStockQuantity = g.Sum(t => t.CaigouZaitu)
}).ToList();
return(result);
}
/// <summary>
/// 通过GroupId获取团购信息
/// </summary>
/// <param name="ProductGroupId"></param>
/// <returns></returns>
public GroupBuyingProductGroupConfigEntity SelectGroupBuyingV2ConfigByGroupId(string productGroupId)
{
GroupBuyingProductGroupConfigEntity result = null;
try
{
dbScopeReadManager.Execute(conn =>
{
result = DalGroupBuyingProductGroupConfig.GetGroupBuyingV2ConfigByGroupId(conn, productGroupId);
result.GroupProductDetails = DalGroupBuyingProductGroupConfig.GetGroupBuyingV2ProductConfigByGroupId(conn, new List <string> {
productGroupId
});
});
}
catch (Exception ex)
{
logger.Error(ex);
}
return(result);
}
public static Tuple <int, string> SetLotteryResult(string productGroupId, int level, Guid userId, int orderId, string _operator)
{
var result = -1;
var info = "设置失败";
var setResult = DalGroupBuyingProductGroupConfig.SetUserLotteryResult(productGroupId, level, orderId, userId);
if (setResult > 0)
{
result = 1; info = $"{productGroupId}产品组下，用户{orderId}设置{level}等奖成功；";
}
if (setResult > 0 && level == 1)
{
setResult = DalGroupBuyingProductGroupConfig.SetOtherLotteryResult(productGroupId, 2);
info = $"{productGroupId}产品组下，用户{orderId}设置{level}等奖成功；" + (setResult == 0 ? "" : $"其他未开奖订单设置奖励{setResult}个成功");
if (setResult < 1)
{
result = 2;
}
}
LotteryLog(productGroupId, $"SetLevel->{level}", _operator, info);
return(Tuple.Create(result, info));
}