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("操作成功"); } } } }