public static void UpdateFlashSalesProduct(SqlConnection connection, FlashSalesProduct flashSalesProduct)
{
var sqlParamters = new[]
{
new SqlParameter("@PKID", flashSalesProduct.PKID),
new SqlParameter("@PID", flashSalesProduct.PID),
new SqlParameter("@Position", flashSalesProduct.Position),
new SqlParameter("@PromotionPrice", flashSalesProduct.PromotionPrice),
new SqlParameter("@MarketPrice", flashSalesProduct.MarketPrice),
new SqlParameter("@PromotionNum", flashSalesProduct.PromotionNum),
new SqlParameter("@MaxNum", flashSalesProduct.MaxNum),
new SqlParameter("@NumLeft", flashSalesProduct.NumLeft),
new SqlParameter("@ProductID", flashSalesProduct.FlashSalesProductPara.ProductID),
new SqlParameter("@VariantID", flashSalesProduct.FlashSalesProductPara.VariantID),
new SqlParameter("@DisplayName", flashSalesProduct.FlashSalesProductPara.DisplayName),
new SqlParameter("@CP_Vehicle", flashSalesProduct.FlashSalesProductPara.CP_Vehicle),
new SqlParameter("@Price", flashSalesProduct.FlashSalesProductPara.Price),
new SqlParameter("@Description", flashSalesProduct.FlashSalesProductPara.Description),
new SqlParameter("@DefinitionName", flashSalesProduct.FlashSalesProductPara.DefinitionName),
new SqlParameter("@Image_filename", flashSalesProduct.FlashSalesProductPara.Image_filename),
new SqlParameter("@Image_filename_2", flashSalesProduct.FlashSalesProductPara.Image_filename_2),
new SqlParameter("@Image_filename_3", flashSalesProduct.FlashSalesProductPara.Image_filename_3),
new SqlParameter("@Image_filename_4", flashSalesProduct.FlashSalesProductPara.Image_filename_4),
new SqlParameter("@Image_filename_5", flashSalesProduct.FlashSalesProductPara.Image_filename_5),
new SqlParameter("@Variant_Image_filename_1", flashSalesProduct.FlashSalesProductPara.Variant_Image_filename_1),
new SqlParameter("@Variant_Image_filename_2", flashSalesProduct.FlashSalesProductPara.Variant_Image_filename_2),
new SqlParameter("@Variant_Image_filename_3", flashSalesProduct.FlashSalesProductPara.Variant_Image_filename_3),
new SqlParameter("@Variant_Image_filename_4", flashSalesProduct.FlashSalesProductPara.Variant_Image_filename_4)
};
SqlHelper.ExecuteNonQuery(connection, CommandType.Text, @"UPDATE Marketing.dbo.tbl_FlashSalesProduct SET PID=@PID,Position=@Position,PromotionPrice=@PromotionPrice,MarketPrice=@MarketPrice,PromotionNum=@PromotionNum,MaxNum=@MaxNum,NumLeft=@NumLeft,
ProductID=@ProductID,VariantID=@VariantID,DisplayName=@DisplayName,CP_Vehicle=@CP_Vehicle,Price=@Price,Description=@Description,Image_filename=@Image_filename,Image_filename_2=@Image_filename_2,Image_filename_3=@Image_filename_3,Image_filename_4=@Image_filename_4,
Image_filename_5=@Image_filename_5,Variant_Image_filename_1=@Variant_Image_filename_1,Variant_Image_filename_2=@Variant_Image_filename_2,Variant_Image_filename_3=@Variant_Image_filename_3,Variant_Image_filename_4=@Variant_Image_filename_4
WHERE PKID=@PKID", sqlParamters);
}
public static void AddFlashSalesProduct(SqlConnection connection, FlashSalesProduct flashSalesProduct)
{
var sqlParamters = new[]
{
new SqlParameter("@PKID", flashSalesProduct.PKID),
new SqlParameter("@FlashSalesID", flashSalesProduct.FlashSalesID),
new SqlParameter("@PID", flashSalesProduct.PID),
new SqlParameter("@Position", flashSalesProduct.Position),
new SqlParameter("@PromotionPrice", flashSalesProduct.PromotionPrice),
new SqlParameter("@MarketPrice", flashSalesProduct.MarketPrice),
new SqlParameter("@PromotionNum", flashSalesProduct.PromotionNum),
new SqlParameter("@MaxNum", flashSalesProduct.MaxNum),
new SqlParameter("@NumLeft", flashSalesProduct.NumLeft),
new SqlParameter("@Status", flashSalesProduct.Status),
new SqlParameter("@IsHotSale", flashSalesProduct.IsHotSale),
new SqlParameter("@ProductID", flashSalesProduct.FlashSalesProductPara.ProductID),
new SqlParameter("@VariantID", flashSalesProduct.FlashSalesProductPara.VariantID),
new SqlParameter("@DisplayName", flashSalesProduct.FlashSalesProductPara.DisplayName),
new SqlParameter("@CP_Vehicle", flashSalesProduct.FlashSalesProductPara.CP_Vehicle),
new SqlParameter("@Price", flashSalesProduct.FlashSalesProductPara.Price),
new SqlParameter("@Description", flashSalesProduct.FlashSalesProductPara.Description),
new SqlParameter("@DefinitionName", flashSalesProduct.FlashSalesProductPara.DefinitionName),
new SqlParameter("@Image_filename", flashSalesProduct.FlashSalesProductPara.Image_filename),
new SqlParameter("@Image_filename_2", flashSalesProduct.FlashSalesProductPara.Image_filename_2),
new SqlParameter("@Image_filename_3", flashSalesProduct.FlashSalesProductPara.Image_filename_3),
new SqlParameter("@Image_filename_4", flashSalesProduct.FlashSalesProductPara.Image_filename_4),
new SqlParameter("@Image_filename_5", flashSalesProduct.FlashSalesProductPara.Image_filename_5),
new SqlParameter("@Variant_Image_filename_1", flashSalesProduct.FlashSalesProductPara.Variant_Image_filename_1),
new SqlParameter("@Variant_Image_filename_2", flashSalesProduct.FlashSalesProductPara.Variant_Image_filename_2),
new SqlParameter("@Variant_Image_filename_3", flashSalesProduct.FlashSalesProductPara.Variant_Image_filename_3),
new SqlParameter("@Variant_Image_filename_4", flashSalesProduct.FlashSalesProductPara.Variant_Image_filename_4)
};
SqlHelper.ExecuteNonQuery(connection, CommandType.Text,
@"insert into Marketing.dbo.tbl_FlashSalesProduct(FlashSalesID,PID,Position,PromotionPrice,MarketPrice,PromotionNum,MaxNum,NumLeft,Status,IsHotSale,
ProductID,VariantID,DisplayName,CP_Vehicle,Price,Description,DefinitionName,Image_filename,Image_filename_2,Image_filename_3,Image_filename_4,Image_filename_5,Variant_Image_filename_1,Variant_Image_filename_2,Variant_Image_filename_3,Variant_Image_filename_4) values
(@FlashSalesID,@PID,@Position,@PromotionPrice,@MarketPrice,@PromotionNum,@MaxNum,@NumLeft,@Status,@IsHotSale,
@ProductID,@VariantID,@DisplayName,@CP_Vehicle,@Price,@Description,@DefinitionName,@Image_filename,@Image_filename_2,@Image_filename_3,@Image_filename_4,@Image_filename_5,@Variant_Image_filename_1,@Variant_Image_filename_2,@Variant_Image_filename_3,@Variant_Image_filename_4)"
, sqlParamters);
}
public void AddFlashSalesProduct(FlashSalesProduct flashSalesProduct)
{
handler.AddFlashSalesProduct(flashSalesProduct);
}
public void UpdateFlashSalesProduct(FlashSalesProduct flashSalesProduct)
{
handler.UpdateFlashSalesProduct(flashSalesProduct);
}
public void AddFlashSalesProduct(FlashSalesProduct flashSalesProduct)
{
Action <SqlConnection> action = (connection) => DalFlashSales.AddFlashSalesProduct(connection, flashSalesProduct);
dbManager.Execute(action);
}
public ActionResult AllOperate(string opstr, int?Cate)
{
try
{
if (string.IsNullOrEmpty(opstr) || !Cate.HasValue)
{
return(Json(new { IsSuccess = false, ReturnStr = "输入的参数不能为空" }, JsonRequestBehavior.AllowGet));
}
else
{
string[] _Oparr = opstr.Split('*');
foreach (string Paras in _Oparr)
{
try
{
if (!string.IsNullOrEmpty(Paras))
{
string[] _Para = Paras.Split(',');
if (_Para.Length == 8)
{
int _PKID = int.Parse(_Para[0]);
string _PID = _Para[1];
byte _Position = byte.Parse(_Para[2]);
decimal _PromotionPrice = decimal.Parse(_Para[3]);
decimal _MarketPrice = decimal.Parse(_Para[4]);
int _PromotionNum = int.Parse(_Para[5]);
int _MaxNum = int.Parse(_Para[6]);
int _NumLeft = int.Parse(_Para[7]);
if (!string.IsNullOrEmpty(_PID))
{
//删除
if (Cate == 1)
{
manager.DeleteFlashSalesProduct(_PKID);
}
//保存
else if (Cate == 2)
{
FlashSalesProduct _FlashSalesProduct = new FlashSalesProduct
{
PKID = _PKID,
PID = _PID,
Position = _Position,
PromotionPrice = _PromotionPrice,
MarketPrice = _MarketPrice,
PromotionNum = _PromotionNum,
MaxNum = _MaxNum,
NumLeft = _NumLeft,
FlashSalesProductPara = _PImanager.GetFlashSalesProductParaByPID(_PID)
};
manager.UpdateFlashSalesProduct(_FlashSalesProduct);
}
}
}
}
}
catch { }
}
}
return(Json(new { IsSuccess = true, ReturnStr = Cate.Value == 1 ? "批量删除成功" : "批量保存成功" }, JsonRequestBehavior.AllowGet));
}
catch
{
return(Json(new { IsSuccess = false, ReturnStr = "保存失败" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult OperateProduct(int?FlashSalesID, int?PKID, string PID, byte?Position, byte?Status, int?Cate, decimal?PromotionPrice, int?PromotionNum, decimal?MarketPrice, int?MaxNum, int?NumLeft, bool?IsHotSale)
{
try
{
if (!FlashSalesID.HasValue || !Cate.HasValue)
{
return(Json("请确保活动编号和操作类型不为空", JsonRequestBehavior.AllowGet));
}
else
{
int _PKID = PKID.GetValueOrDefault(0);
//删除产品
if (Cate == 1)
{
manager.DeleteFlashSalesProduct(_PKID);
}
//设置为已禁止
else if (Cate == 2)
{
manager.ChangeStatus(_PKID, Status.GetValueOrDefault(0));
}
//设置为已禁止
else if (Cate == 5)
{
manager.ChangeIsHotSale(_PKID, IsHotSale ?? false);
}
//保存产品
else if (Cate == 3 || Cate == 4)
{
int _FlashSalesID = FlashSalesID.GetValueOrDefault(0);
FlashSalesProduct _FlashSalesProduct = new FlashSalesProduct
{
PKID = _PKID,
FlashSalesID = _FlashSalesID,
PID = PID,
Position = Position.GetValueOrDefault(0),
Status = Status.GetValueOrDefault(0),
PromotionPrice = PromotionPrice.GetValueOrDefault(0),
PromotionNum = PromotionNum.GetValueOrDefault(0),
MarketPrice = MarketPrice.GetValueOrDefault(0),
MaxNum = MaxNum.GetValueOrDefault(0),
NumLeft = NumLeft.GetValueOrDefault(0),
FlashSalesProductPara = _PImanager.GetFlashSalesProductParaByPID(PID)
};
if (_FlashSalesProduct.FlashSalesProductPara != null)
{
if (Cate == 3)
{
//修改产品
manager.UpdateFlashSalesProduct(_FlashSalesProduct);
}
else
{
//新增产品
if (!Position.HasValue || !Status.HasValue)
{
return(Json("排序顺序和状态不能为空", JsonRequestBehavior.AllowGet));
}
else
{
manager.AddFlashSalesProduct(_FlashSalesProduct);
}
}
}
else
{
return(Json("该产品不存在，请重新选择", JsonRequestBehavior.AllowGet));
}
}
return(Json("OK", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json("保存失败" + (Cate.HasValue && (Cate.Value == 3 || Cate.Value == 4) ? "请确认产品编号不要重复和顺序号为两位内整数" : "") + ex.Message.Replace("'", ""), JsonRequestBehavior.AllowGet));
}
}