/// <summary>
/// 创建商品图片
/// </summary>
public static bool CreateProductImage(ProductImageInfo productImageInfo)
{
return BrnMall.Data.Products.CreateProductImage(productImageInfo);
}
/// <summary>
/// 创建商品图片
/// </summary>
public bool CreateProductImage(ProductImageInfo productImageInfo)
{
DbParameter[] parms = {
GenerateInParam("@pid", SqlDbType.Int, 4, productImageInfo.Pid),
GenerateInParam("@showimg", SqlDbType.NVarChar, 100, productImageInfo.ShowImg),
GenerateInParam("@ismain", SqlDbType.TinyInt, 1, productImageInfo.IsMain),
GenerateInParam("@displayorder", SqlDbType.Int, 4, productImageInfo.DisplayOrder),
GenerateInParam("@storeid", SqlDbType.Int, 4, productImageInfo.StoreId)
};
string commandText = string.Format("INSERT INTO [{0}productimages]([pid],[showimg],[ismain],[displayorder],[storeid]) VALUES(@pid,@showimg,@ismain,@displayorder,@storeid)",
RDBSHelper.RDBSTablePre);
return TypeHelper.ObjectToInt(RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms), -1) > 0;
}
/// <summary>
/// 创建商品图片
/// </summary>
public static bool CreateProductImage(ProductImageInfo productImageInfo)
{
bool result = BrnMall.Core.BMAData.RDBS.CreateProductImage(productImageInfo);
if (_productnosql != null)
_productnosql.ClearProductImage(productImageInfo.Pid);
return result;
}
/// <summary>
/// 从IDataReader创建ProductImageInfo
/// </summary>
public static ProductImageInfo BuildProductImageFromReader(IDataReader reader)
{
ProductImageInfo productImageInfo = new ProductImageInfo();
productImageInfo.PImgId = TypeHelper.ObjectToInt(reader["pimgid"]);
productImageInfo.Pid = TypeHelper.ObjectToInt(reader["pid"]);
productImageInfo.ShowImg = reader["showimg"].ToString();
productImageInfo.IsMain = TypeHelper.ObjectToInt(reader["ismain"]);
productImageInfo.DisplayOrder = TypeHelper.ObjectToInt(reader["displayorder"]);
productImageInfo.StoreId = TypeHelper.ObjectToInt(reader["storeid"]);
return productImageInfo;
}
/// <summary>
/// 添加商品图片
/// </summary>
public ActionResult AddProductImage(string showImg, int displayOrder = 0, int pid = -1)
{
PartProductInfo partProductInfo = AdminProducts.AdminGetPartProductById(pid);
if (partProductInfo == null)
return PromptView(Url.Action("productimagelist", new { pid = pid }), "商品不存在");
if (string.IsNullOrWhiteSpace(showImg))
return PromptView(Url.Action("productimagelist", new { pid = pid }), "图片不能为空");
ProductImageInfo productImageInfo = new ProductImageInfo
{
Pid = pid,
ShowImg = showImg,
IsMain = 0,
DisplayOrder = displayOrder,
StoreId = partProductInfo.StoreId
};
AdminProducts.CreateProductImage(productImageInfo);
AddMallAdminLog("添加商品图片", "添加商品图片,商品ID为:" + pid);
return PromptView(Url.Action("productimagelist", new { pid = pid }), "商品图片添加成功");
}
