public JsonResult UpsertZeroActivity(string productId, string variantId, string des, DateTime start, DateTime end, string imgUrl, int period = 0, int successQuota = 0, int quantity = 0)
{
var msg = string.Empty;
if (start != null && end != null && start > end)
{
return(Json(new { status = "fail", msg = "日期选择错误" }, JsonRequestBehavior.AllowGet));
}
var details = ZeroActivityManager.SelectZeroActivityDetail();
if (start > details.Where(o => !o.Period.Equals(period)).OrderByDescending(_ => _.EndDateTime).Select(x => x.EndDateTime).FirstOrDefault())
{
return(Json(new { status = "fail", msg = "活动时间有间断" }, JsonRequestBehavior.AllowGet));
}
ZeroActivityDetail data = new ZeroActivityDetail()
{
Period = period,
ProductID = productId,
VariantID = variantId,
Description = des,
StartDateTime = start,
EndDateTime = end,
SucceedQuota = successQuota,
Quantity = quantity,
ImgUrl = imgUrl
};
var result = ZeroActivityManager.ZAConfigureAct(data) > 0;
if (result)
{
return(Json(new { status = "success" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = "fail", msg = "操作失败" }, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 0元购活动配置
/// </summary>
/// <param name="Zadetail"></param>
/// <returns></returns>
public static int ZAConfigureAct(ZeroActivityDetail Zadetail)
{
return(DalZeroActivity.ZAConfigureAct(Zadetail));
}
public static int ZAConfigureAct(ZeroActivityDetail Zadetail)
{
const string sql = @" IF EXISTS ( SELECT 1
FROM Activity..tbl_ZeroActivity WITH (NOLOCK)
WHERE Period = @Period )
BEGIN
UPDATE Activity..tbl_ZeroActivity
SET ProductID = @ProductID ,
VariantID = @VariantID ,
SucceedQuota = @SucceedQuota ,
Quantity = @Quantity ,
StartDateTime = @StartDateTime ,
EndDateTime = @EndDateTime ,
Description = @Description,
ImgUrl = @ImgUrl ,
Pid = @Pid
WHERE Period = @Period;
END;
ELSE
BEGIN
IF NOT EXISTS ( SELECT *
FROM Activity..tbl_ZeroActivity WITH (NOLOCK)
WHERE Period = @Period
AND ProductID = @ProductID
AND VariantID = @VariantID )
BEGIN
INSERT INTO Activity..tbl_ZeroActivity
( Period ,
ProductID ,
VariantID ,
SucceedQuota ,
Quantity ,
StartDateTime ,
EndDateTime ,
CreateDateTime ,
[Description],
ImgUrl ,
Pid
)
VALUES ( @Period ,
@ProductID ,
@VariantID ,
@SucceedQuota ,
@Quantity ,
@StartDateTime ,
@EndDateTime ,
GETDATE() ,
@Description ,
@ImgUrl ,
@Pid
);
END;
END;";
using (var dbhelper = new SqlDbHelper(ConnectionHelper.GetDecryptConn("Gungnir")))
{
var cmd = new SqlCommand(sql);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Period", Zadetail.Period);
cmd.Parameters.AddWithValue("@ProductID", Zadetail.ProductID);
cmd.Parameters.AddWithValue("@VariantID", Zadetail.VariantID ?? string.Empty);
cmd.Parameters.AddWithValue("@SucceedQuota", Zadetail.SucceedQuota);
cmd.Parameters.AddWithValue("@Quantity", Zadetail.Quantity);
cmd.Parameters.AddWithValue("@StartDateTime", Zadetail.StartDateTime.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("@EndDateTime", Zadetail.EndDateTime.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("@Description", Zadetail.Description);
cmd.Parameters.AddWithValue("@ImgUrl", Zadetail.ImgUrl);
cmd.Parameters.AddWithValue("@Pid", $"{Zadetail.ProductID}|{Zadetail.VariantID ?? string.Empty}");
var n = dbhelper.ExecuteNonQuery(cmd);
return(n);
}
}
