public string GetProductImageFile(int ProductId, ProductImage image) { string imageDir = FileUtils.GetUserDataFolder() + Path.DirectorySeparatorChar + Constants.MyItemImages; if (!Directory.Exists(imageDir)) { Directory.CreateDirectory(imageDir); } string imageFile = imageDir + Path.DirectorySeparatorChar + ProductId + "_" + image.Id + ".jpg"; if (File.Exists(imageFile)) { Int64 size = new FileInfo(imageFile).Length; if (size != image.Size) { byte[] imageBuffer = this.GetProductImage(image.Id); FileUtils.ByteArrayToImageFile(imageBuffer, imageFile); imageBuffer = null; } } else { byte[] imageBuffer = this.GetProductImage(image.Id); FileUtils.ByteArrayToImageFile(imageBuffer, imageFile); imageBuffer = null; } return imageFile; }
private ProductImage GetMainImageByProductId(int ProductId) { string sql = "SELECT Id, ProductId, Image,Size, IsMain,CreatedTime,ModifiedTime " + " FROM Product_Image where ProductId = " + ProductId + " and IsMain = 1 limit 0,1"; DataTable dt = dbHelper.ExecuteDataTable(sql, null); foreach (DataRow row in dt.Rows) { ProductImage kw = new ProductImage(); kw.Id = Convert.ToInt32(row["Id"]); kw.ProductId = Convert.ToInt32(row["ProductId"]); kw.Size = Convert.ToInt64(row["Size"]); kw.IsMain = Convert.ToBoolean(row["IsMain"]); kw.CreatedTime = Convert.ToDateTime(row["CreatedTime"]); kw.ModifiedTime = Convert.ToDateTime(row["ModifiedTime"]); return kw; } return null; }
public List<ProductImage> GetImagesInfoByProductId(int ProductId) { List<MySqlParameter> parameters = new List<MySqlParameter>(); parameters.Add(new MySqlParameter("@ProductId", ProductId)); string sql = "SELECT Id, ProductId, Image, Size, IsMain, CreatedTime, ModifiedTime " + " FROM Product_Image where ProductId = @ProductId order by IsMain desc, Id asc"; DataTable dt = dbHelper.ExecuteDataTable(sql, parameters.ToArray()); List<ProductImage> list = new List<ProductImage>(); foreach (DataRow row in dt.Rows) { ProductImage kw = new ProductImage(); kw.Id = Convert.ToInt32(row["Id"]); kw.ProductId = Convert.ToInt32(row["ProductId"]); kw.Size = Convert.ToInt64(row["Size"]); kw.IsMain = Convert.ToBoolean(row["IsMain"]); kw.CreatedTime = Convert.ToDateTime(row["CreatedTime"]); kw.ModifiedTime = Convert.ToDateTime(row["ModifiedTime"]); list.Add(kw); } return list; }
public void InsertOrUpdateProductImage(ProductImage item) { string InsSql = @"INSERT INTO Product_Image(ProductId, Image,Size, IsMain,CreatedTime,ModifiedTime)" + "values(@ProductId, @Image,@Size, @IsMain,@CreatedTime,@ModifiedTime)"; string UpdSql = @"Update Product_Image SET Size=@Size, Image=@Image, ModifiedTime=@ModifiedTime WHERE Id = @Id"; DateTime CurrentTime = DateTime.Now; MySqlParameter[] parameter = new MySqlParameter[] { new MySqlParameter("@Id",item.Id), new MySqlParameter("@ProductId",item.ProductId), new MySqlParameter("@Image", item.Image), new MySqlParameter("@Size",item.Size), new MySqlParameter("@IsMain",item.IsMain), new MySqlParameter("@CreatedTime",CurrentTime), new MySqlParameter("@ModifiedTime",CurrentTime) }; if (item.Id == 0) { dbHelper.ExecuteNonQuery(InsSql, parameter); } else { dbHelper.ExecuteNonQuery(UpdSql, parameter); } }