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);
}
}
