private string ExportResourceByLoading()
{
using (var db = new MODkingfilesEntities())
{
srcbaseUrl = ConfigurationManager.AppSettings["srcPath"];
desbaseUrl = ConfigurationManager.AppSettings["desPath"];
savaUrl = desbaseUrl + "/Temp/" + DateTime.Now.ToString("yyyyMMdd") + System.Guid.NewGuid().ToString();
string imgurl = srcbaseUrl + "/Img/";
string desimgUrl = savaUrl + "/Img/";
if (!Directory.Exists(savaUrl))
{
Directory.CreateDirectory(savaUrl);
}
if (!Directory.Exists(desimgUrl))
{
Directory.CreateDirectory(desimgUrl);
}
List <tb_Files> fileList = new List <tb_Files>();
List <Resource> resList = new List <Resource>();
foreach (Resource res in resourceList)
{
tb_Files f = db.tb_Files.Find(res.FileID);
resList.Add(res);
fileList.Add(f);
string realfile = srcbaseUrl + "\\" + f.FilePath + "\\" + f.ID;
string desfile = savaUrl + "\\" + f.FilePath + "\\";
try
{
if (!Directory.Exists(desfile))
{
Directory.CreateDirectory(desfile);
}
if (File.Exists(imgurl + f.ID + ".jpg"))
{
File.Copy(imgurl + f.ID + ".jpg", desimgUrl + f.ID + ".jpg", true);
}
desfile = desfile + f.ID;
CopyFileToDestion(realfile, desfile, f.FileExtension);
}
catch (Exception ex)
{
OutErrorLog(realfile + ex.Message, savaUrl + "\\ErrorLog.txt");
}
}
OutLog(JsonHelper.EncodeJson(resList), savaUrl + "\\Tb_Resource.txt");
OutLog(JsonHelper.EncodeJson(fileList), savaUrl + "\\Tb_File.txt");
return(savaUrl);
}
}
private void UploadDataBase_Click(object sender, EventArgs e)
{
using (var db = new ModMetaEntities())
{
using (var dbres = new MODResourceEntities())
{
using (var dbfile = new MODkingfilesEntities())
{
/////////////先增加文件信息//////////////
foreach (tb_Files file in filelist)
{
tb_Files tempfile = dbfile.tb_Files.Find(file.ID);
if (tempfile == null)
{
dbfile.tb_Files.Add(file);
}
}
dbfile.SaveChanges();
/////////////再增加资源信息//////////////
foreach (tb_Resource resource in resourcelist)
{
tb_Resource tempresource = dbres.tb_Resource.Find(resource.ID);
if (tempresource == null)
{
if (resource.Edition == 66 && resource.Grade == 3 && resource.BookReel == 2 && resource.Subject == 1)
{
ViewMod_Trunt_Branch tbmodel = db.ViewMod_Trunt_Branch.Where(w => w.tID == resource.Catalog).FirstOrDefault();
resource.Catalog = tbmodel.bID;
}
resource.ResourceClass = 1;
dbres.tb_Resource.Add(resource);
}
}
dbres.SaveChanges();
MessageBox.Show("操作成功");
}
}
}
}
