public static bool UpdateByActivityProduct(UserPermissionActivityProduct model)
{
string sql = @"update Activity.[dbo].[tbl_FlashSaleProducts] set [Price]=@Price , TotalQuantity=@TotalQuantity,MaxQuantity=@MaxQuantity
,ProductName=@ProductName,FalseOriginalPrice=@FalseOriginalPrice where PKID=@PKID ";
var conn = ConfigurationManager.ConnectionStrings["Gungnir"].ConnectionString;
if (SecurityHelp.IsBase64Formatted(conn))
{
conn = SecurityHelp.DecryptAES(conn);
}
using (var dbhelper = new SqlDbHelper(conn))
{
SqlCommand cmd = new SqlCommand(sql);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Price", model.Price);
cmd.Parameters.AddWithValue("@TotalQuantity", model.TotalQuantity);
cmd.Parameters.AddWithValue("@MaxQuantity", model.MaxQuantity);
cmd.Parameters.AddWithValue("@ProductName", model.DisplayName);
cmd.Parameters.AddWithValue("@PKID", model.PKID);
cmd.Parameters.AddWithValue("@FalseOriginalPrice", model.FalseOriginalPrice);
int i = dbhelper.ExecuteNonQuery(cmd);
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// 添加商品
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool AddByActivityProduct(UserPermissionActivityProduct model)
{
if (model.PKID == 0)
{
return(DALUserPermission.AddByActivityProduct(model));
}
else
{
return(DALUserPermission.UpdateByActivityProduct(model));
}
}
public static bool AddByActivityProduct(UserPermissionActivityProduct model)
{
DeleteByActivityProductPID(model.ActivityID.ToString(), model.PID);
string sql = @"INSERT INTO Activity.[dbo].[tbl_FlashSaleProducts]
([ActivityID]
,[PID]
,[Price]--促销价
,[TotalQuantity]--库存
,[MaxQuantity]--个人限购
,[CreateDateTime]
,[ProductName]--产品名称简称
,[IsUsePCode]--是否可以使用优惠券 true
,[Channel]--all pc app
,[FalseOriginalPrice]
)
VALUES
(@ActivityID,@PID,@Price,@TotalQuantity,@MaxQuantity,getdate(),@ProductName,1,'all',@FalseOriginalPrice)";
var conn = ConfigurationManager.ConnectionStrings["Gungnir"].ConnectionString;
if (SecurityHelp.IsBase64Formatted(conn))
{
conn = SecurityHelp.DecryptAES(conn);
}
using (var dbhelper = new SqlDbHelper(conn))
{
var cmd = new SqlCommand(sql);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@ActivityID", model.ActivityID);
cmd.Parameters.AddWithValue("@PID", model.PID.Trim());
cmd.Parameters.AddWithValue("@Price", model.Price);
cmd.Parameters.AddWithValue("@TotalQuantity", model.TotalQuantity);
cmd.Parameters.AddWithValue("@MaxQuantity", model.MaxQuantity);
// cmd.Parameters.AddWithValue("@SaleOutQuantity",model.SaleOutQuantity);
cmd.Parameters.AddWithValue("@ProductName", model.DisplayName);
cmd.Parameters.AddWithValue("@FalseOriginalPrice", model.FalseOriginalPrice);
int i = dbhelper.ExecuteNonQuery(cmd);
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public ActionResult SaleProductEdit(string id = "")
{
if (id == "")
{
return(View(new UserPermissionActivityProduct()));
}
else
{
UserPermissionActivityProduct model = UserPermissionManager.GetActivityProduct(id);
if (model == null)
{
return(View(new UserPermissionActivityProduct()));
}
return(View(model));
}
}
public ActionResult AddActivityProduct(UserPermissionActivityProduct model)
{
if (model.PID == "")
{
return(JavaScript("{\"status\":0}"));
}
else
{
if (UserPermissionManager.AddByActivityProduct(model))
{
return(JavaScript("{\"status\":1}"));
}
else
{
return(JavaScript("{\"status\":0}"));
}
}
}
