Repository navigation
Expand file tree
/
Copy pathDBImages.cs
More file actions
88 lines (87 loc) · 4.15 KB
/
Copy pathDBImages.cs
File metadata and controls
88 lines (87 loc) · 4.15 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
using System.Data;
using System.Drawing;
namespace ImagesInDB {
public static class DBImages {
public static void CreateDirImages(string[] dirNames) {
foreach(string dirName in dirNames) {
if(Directory.Exists(dirName)) {
CreateDBImages("xml", DBHelper.GetXMLDataSet, dirName);
CreateDBImages("mdb", DBHelper.GetMDBDataSet, dirName);
CreateDBImages("sqlite3", CreateSQLImages, dirName);
CreateDBImages("db", CreateSQLImages, dirName);
CreateDBImages("mdf", DBHelper.GetMDFDataSet, dirName);
CreateDataSetImages(DBHelper.GetDBFDataSet(dirName), "DBFTables", dirName);
}
}
}
static void CreateDBImages(string ext, Action<FileInfo, string> createImages, string dirName) {
Directory.GetFiles(dirName, $"*.{ext}").ToList()
.ForEach(f => createImages(new FileInfo(f), dirName));
}
static void CreateDBImages(string ext, Func<string, DataSet> getDataSet, string dirName) {
Directory.GetFiles(dirName, $"*.{ext}").ToList()
.ForEach(f => {
FileInfo fi = new(f);
CreateDataSetImages(getDataSet(fi.FullName), fi.Name, dirName);
});
}
static void CreateSQLImages(FileInfo fi, string prefix = ".") {
DBHelper.GetSQLTables(fi, prefix, SaveImagesByList);
}
static void CreateDataSetImages(DataSet ds, string name, string prefix) {
if(ds != null)
foreach(DataTable dt in ds.Tables)
SaveImagesByTable(dt, $"{name}_Images", prefix);
}
static void SaveImagesByTable(DataTable dt, string name, string prefix) {
int i = 0;
string folderName = $"DB_{name}";
Console.WriteLine($"Saving images to {folderName}: {dt.TableName} table");
foreach(DataRow dr in dt.Rows) {
i += 1;
foreach(DataColumn dc in dt.Columns) {
if(dr[dc] is System.DBNull) continue;
string fileName = @$"{prefix}\{folderName}\{dt.TableName}_{dc.ColumnName}_{i:D2}";
if(dc.DataType == typeof(byte[])) {
byte[] image = (byte[])dr[dc];
SaveImage(image, fileName);
}
else if(dc.DataType == typeof(string)) {
string base64String = (string)dr[dc];
if(base64String.Length > 255) {
try {
byte[] bytes = Convert.FromBase64String(base64String);
SaveImage(bytes, fileName);
} catch { }
}
}
}
}
}
static void SaveImagesByList(string prefix, string dbName, string tableName, List<object> list) {
int i = 0;
string folderName = $"DB_{dbName}_Images";
Console.WriteLine($"Saving images to {folderName}: {tableName} table");
foreach(var row in list) {
var rowDict = (IDictionary<string, object>)row;
foreach(var column in rowDict) {
if(column.Value is not null && column.Value.GetType() == typeof(byte[])) {
byte[] image = (byte[])column.Value;
SaveImage(image, @$"{prefix}\{folderName}\{tableName}_{column.Key}_{++i:D3}");
}
}
}
}
static void SaveImage(byte[] image, string name) {
try {
IOHelper.CheckDir(Path.GetDirectoryName(name));
using(MemoryStream ms = new(image)) {
using(Image img = Image.FromStream(ms))
img.Save($"{name}.{ImageHelper.GetImageExtension(img)}",
ImageHelper.GetImageFormat(img));
}
} catch {
}
}
}
}