SQLite 递归搜索批量添加大型图片数据

private void button1_Click(object sender, EventArgs e)
{
using (OpenFileDialog opd = new OpenFileDialog())
{
opd.Filter = "*.db|*.db|*.*|*.*";
if (opd.ShowDialog() == DialogResult.OK)
textBox1.Text = opd.FileName;
}
}
private void button3_Click(object sender, EventArgs e)
{
if (!importsatamap)
{
importsatamap = true;
terminated = false;
using (FolderBrowserDialog fd = new FolderBrowserDialog())
{
if (fd.ShowDialog() == DialogResult.OK)
{
if (cn.State == ConnectionState.Closed)
{
Stopwatch sw = new Stopwatch();
sw.Start();
try
{
cn.Open();
cmd = cn.CreateCommand();
mandType = CommandType.Text;
mandText = "insert /*+append*/ into satamaps
(mapkey,map,format) values (@mapkey,@map,@format);";
cmd.Parameters.Add("@mapkey", DbType.String);
cmd.Parameters.Add("@map", DbType.Object);
cmd.Parameters.Add("@format", DbType.String);
tr = cn.BeginTransaction();
AddSatelliteMaps(fd.SelectedPath); }
finally
{
mit();
tr.Dispose();
}
sw.Stop();
MessageBox.Show("完成数据入库，用时:" + sw.Elapsed.ToString());
}
else
MessageBox.Show("数据库连接有误！");
}
}
}
else
{
importsatamap = false;
terminated = true;
}
}
private void AddSatelliteMaps(string SelectedPath)
{
if (terminated)
return;
DirectoryInfo dir = new DirectoryInfo(SelectedPath);
FileInfo[] files = dir.GetFiles("*.jpg");
Tile tile;
string mapkey;
foreach (FileInfo file in files)
{
if (terminated)
break;
tile = GetMapKeyByFileFullPath(file.FullName);
if (!tile.Equals(new Tile()))
{
//记录/
mapkey = tile.MapKey();
Count += InsertMapToDB(tile, file.FullName);
Application.DoEvents();
label2.Text = "添加地图数：" + Count.ToString();
}
}
DirectoryInfo[] subdirs = dir.GetDirectories("*", SearchOption.TopDirectoryOnly);
foreach (DirectoryInfo subdir in subdirs)
{
if (terminated)
break;
AddSatelliteMaps(subdir.FullName);
}
}
private int InsertMapToDB(Tile tile, string FileName)
{
using (Image image = Image.FromFile(FileName))
{
using (Stream fs = new MemoryStream())
{
image.Save(fs, System.Drawing.Imaging.ImageFormat.Jpeg);
if (fs.Length > 0)
{
try
{
///BULK INSERT
byte[] bytes = new byte[fs.Length];
fs.Read(bytes, 0, bytes.Length);
cmd.Parameters["@mapkey"].Value = tile.MapKey();
cmd.Parameters["@map"].Value = bytes;
cmd.Parameters["@format"].Value = "jpeg";
return cmd.ExecuteNonQuery();
}
catch
{
return 0;
}
}
else
return 0;
}
}
}
private Tile GetMapKeyByFileFullPath(string FileFullName)
{
string fn = Path.GetFileNameWithoutExtension(FileFullName).ToLower();
string[] fna = fn.Split('_');
Tile tile = new Tile();
if (fna.Length == 3)
{
tile = new Tile(ConvertCustom.ToInt(fna[0]), ConvertCustom.ToInt(fna[1]), ConvertCustom.ToInt(fna[2]));
return tile;
}
else
if (fna.Length == 4)
{
tile = new Tile(ConvertCustom.ToInt(fna[1]), ConvertCustom.ToInt(fna[2]), ConvertCustom.ToInt(fna[3]));
return tile;
}
else return new Tile();
}。