/// <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 }), "商品图片添加成功"); }