public static int ApproveBack(string acid)
{
using (var dbHelper = new SqlDbHelper(ConnectionHelper.GetDecryptConn("Gungnir")))
{
dbHelper.BeginTransaction();
try
{
//var result1 = DalSeckill.DeleteFlashSaleTempByAcid(acid);
//if (result1 <= 0)
//{
// dbHelper.Rollback();
// return -1;
//}
//var result2 = DalSeckill.DeleteFlashSaleProductsTempByAcid(acid);
//if (result2 <= 0)
//{
// dbHelper.Rollback();
// return -1;
//}
var result3 = DalSeckill.UpdateSeckillToToApprove(acid, 2);
if (result3 <= 0)
{
dbHelper.Rollback();
return(-1);
}
dbHelper.Commit();
return(1);
}
catch (Exception e)
{
dbHelper.Rollback();
throw new Exception(e.Message);;
}
}
}
public ScheduleDetail GenerateDefaultActivity(DateTime dt, string schedule, string shortDate)
{
var status = CompareSchedule(schedule, ConvertToSchedule(DateTime.Now.Hour), dt);
var models = new List <QiangGouProductModel>();
if (status.Item1 != 1)
{
models = DalSeckill.SelectDefultActivityBySchedule(schedule)?.ToList() ?? new List <QiangGouProductModel>();;
}
var first = models.FirstOrDefault();
if (first == null || first.ActivityID == new Guid())
{
return(new ScheduleDetail
{
Status = 1,
StrStatus = "新建",
Schedule = schedule,
IsDefault = false,
ShortDate = shortDate
});
}
return(new ScheduleDetail
{
Status = status.Item1,
StrStatus = status.Item2,
ActivityId = models.Select(r => r.ActivityID).FirstOrDefault().ToString(),
Count = models.Count,
Schedule = schedule,
ShortDate = shortDate,
IsDefault = true
});
}
public static List <SeckillListModel> SelectSeckillList(DateTime dt)
{
var data1 = DalSeckill.SelectQiangGouAndProducts(dt); //已审核产品数据
var data2 = DalSeckill.SelectQiangGouTempAndProducts(dt); //待审核产品数据
var data2aids = data2.Select(r => r.ActivityID).ToList();
//var data3 = data2.Except(data1);
var dbResult = data1.Where(r => !data2aids.Contains(r.ActivityID)).Union(data2).ToList();
var scheduleDetails = dbResult.GroupBy(r => new
{
r.ActivityID,
r.StartDateTime,
r.EndDateTime,
r.IsShow
})
.Select(
d =>
new ScheduleDetail(DalSeckill.SelectActivityStatusByActivityId(d.Key.ActivityID.ToString()),
d.Key.StartDateTime, d.Key.EndDateTime)
{
ActivityId = d.Key.ActivityID.ToString(),
Count = dbResult.Where(a => a.ActivityID == d.Key.ActivityID).Count(),
IsShowCount = dbResult.Where(a => a.IsShow == true && a.ActivityID == d.Key.ActivityID).Count()
});
var scheduleModels = scheduleDetails.GroupBy(r => new
{
r.ShortDate,
r.Week
}).Select(d => new ScheduleModel()
{
Week = d.Key.Week,
ShortDate = d.Key.ShortDate,
Schedule = d.Select(s => new ScheduleDetail()
{
ActivityId = s.ActivityId,
Count = s.Count,
Schedule = s.Schedule,
Status = s.Status,
ShortDate = s.ShortDate,
StrStatus = s.StrStatus,
IsShowCount = s.IsShowCount
}).ToList()
}).ToList();
return(new List <SeckillListModel>
{
new SeckillListModel(dt, "0点场", scheduleModels),
new SeckillListModel(dt, "10点场", scheduleModels),
new SeckillListModel(dt, "13点场", scheduleModels),
new SeckillListModel(dt, "16点场", scheduleModels),
new SeckillListModel(dt, "20点场", scheduleModels),
});
}
public static QiangGouModel FetchNeedExamQiangGouAndProducts(Guid aid)
{
try
{
var dt = DalSeckill.FetchNeedExamQiangGouAndProducts(aid);
if (dt == null || dt.Rows.Count == 0)
{
return(null);
}
var model = dt.ConvertTo <QiangGouModel>()?.FirstOrDefault() ?? new QiangGouModel();
var pids = dt.ConvertTo <QiangGouProductModel>().Select(r => r.PID).ToList();
var costPriceSql = DalSeckill.SelectProductCostPriceByPids(pids);
var products = from a in dt.ConvertTo <QiangGouProductModel>()
join b in costPriceSql on a.PID equals b.PID into temp
from b in temp.DefaultIfEmpty()
select new QiangGouProductModel
{
PKID = a.PKID,
ActivityID = a.ActivityID,
ActivityName = a.ActivityName,
PID = a.PID,
HashKey = a.HashKey,
Price = a.Price,
TotalQuantity = a.TotalQuantity,
MaxQuantity = a.MaxQuantity,
SaleOutQuantity = a.SaleOutQuantity,
InstallAndPay = a.InstallAndPay,
IsUsePCode = a.IsUsePCode,
Channel = a.Channel,
IsJoinPlace = a.IsJoinPlace,
FalseOriginalPrice = a.FalseOriginalPrice,
DisplayName = a.DisplayName,
OriginalPrice = a.OriginalPrice,
ProductName = a.ProductName,
Label = a.Label,
CostPrice = b?.CostPrice,
Position = a.Position,
IsShow = a.IsShow,
Image = a.Image,
InstallService = a.InstallService,
DecreaseDegree = (Math.Round((a.OriginalPrice - a.Price) / a.OriginalPrice, 2) * 100) + "%"
};
model.Products = products;
return(model);
}
catch (Exception ex)
{
return(new QiangGouModel());
}
}
public ScheduleDetail DefaultGenerateDefaultActivity(string schedule, string shortDate)
{
var models = DalSeckill.SelectDefultActivityBySchedule(schedule)?.ToList() ?? new List <QiangGouProductModel>();;
var first = models.FirstOrDefault();
if (first == null || first.ActivityID == new Guid())
{
models = DalSeckill.SelectDefultActivityTempBySchedule(schedule)?.ToList() ?? new List <QiangGouProductModel>();
first = models.FirstOrDefault();
if (first == null || first.ActivityID == new Guid())
{
return(new ScheduleDetail
{
Status = 1,
StrStatus = "新建",
ShortDate = shortDate,
Schedule = schedule,
IsDefault = true,
});
}
}
var status = DalSeckill.SelectActivityStatusByActivityId(first.ActivityID.ToString());
var strStatus = "已发布";
var count = models.Count;
if (status != 0)
{
status = status == 1 ? 2 : 4;
count = DalSeckill.SelectActivityProductsByActivityId(first.ActivityID.ToString());
strStatus = status == 2
? "待审核"
: "已驳回";
}
else
{
status = 3;
}
return(new ScheduleDetail
{
Status = status,
StrStatus = strStatus,
ActivityId = models.Select(r => r.ActivityID).FirstOrDefault().ToString(),
Count = count,
Schedule = schedule,
IsDefault = true,
ShortDate = shortDate
});
}
public static int DeleteFirstCreateActivityApproveBack(string aid)
{
var mainDelete = DalSeckill.DeleteFlashSaleTempByAcid(aid);
if (mainDelete <= 0)
{
return(-1);
}
var subDelete = DalSeckill.DeleteFlashSaleProductsTempByAcid(aid);
if (subDelete <= 0)
{
return(-1);
}
return(1);
}
public static int SelectQiangGouIsExist(string acid) => DalSeckill.SelectQiangGouIsExist(acid);
public static int DeleteStatusData(string acid)
{
return(DalSeckill.DeleteStatusData(acid));
}
public static int UpdateSeckillToToApprove(string acid)
{
return(DalSeckill.UpdateSeckillToToApprove(acid));
}
public static List <string> SelectActivityProductPids(Guid aid)
{
return(DalSeckill.SelectActivityProductPids(aid));
}
/// <summary>
/// 备份活动状态数据
/// </summary>
/// <param name="acid"></param>
/// <returns></returns>
public static int InsertActivityApprovalStatus(ActivityApprovalStatus model)
{
return(DalSeckill.InsertActivityApprovalStatus(model));
}
/// <summary>
/// 查询活动获取状态
/// </summary>
/// <param name="activityId"></param>
/// <returns></returns>
public static ActivityApprovalStatus SelectActivityStatusModel(Guid activityId)
{
return(DalSeckill.SelectActivityStatusModel(activityId));
}
