我正在处理一个项目,该项目是为了解压缩文件夹,循环浏览提取的文件夹中的文件,然后将数据上传到数据库,然后将zip和文件文件夹移至另一个目录。我遇到了移动提取的文件夹的问题。
Message "Access to the path 'Insurance_Documents\Test_2017' is denied." string
我最初的本能是这是一个许可问题。但是,我检查了许可,看上去都不错。此外,由于该程序创建了目录本身,因此权限成为原因似乎并不是很合乎逻辑的。
接下来,在互联网上浏览了一点之后,我以为我的uploadreportdata()函数可能一直在锁定文件(它确实使用语句使用了,但是我认为可能仍然有一个"滞后"锁定)。作为回应,我将thread.sleep语句放在我的代码中而没有成功。该程序将Zip文件夹移动恰到好处。正是"正常"目录给我带来麻烦。
program.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using UploadInsurance.Helpers;
namespace UploadInsurance
{
class Program
{
static void Main(string[] args)
{
try
{
ZipHelper.processDirectory();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message + "n" + ex.StackTrace);
}
finally {
Console.Read();
}
}
}
}
ziphelper.cs(部分)
static class ZipHelper
{
private static String BASE_DIRECTORY = @"Insurance_Documents";
private static String OLD_ZIPS = @"Insurance_DocumentsOld";
private static String EXTRACTED_FOLDERS = @"Insurance_DocumentsInserted";
private static List<String> zipFileList = new List<string>();
private static void getZipFiles()
{
zipFileList = Directory.GetFiles(BASE_DIRECTORY, "*.zip").ToList();
}
private static void processZipFiles()
{
String zipFolderName = "";
String reportFolderName = "";
foreach (String file in zipFileList)
{
folderName = Path.GetFileNameWithoutExtension(file);
reportFolderPath= BASE_DIRECTORY + folderName;
ZipFile.ExtractToDirectory(file, reportFolderPath);
uploadReportData(reportFolderPath);
Directory.Move(file, OLD_ZIPS + Path.GetFileName(file));
Thread.Sleep(2000);
Directory.Move(reportFolderPath + "//", EXTRACTED_FOLDERS + folderName);
}
}
... // MORE CODE HERE, INCLUDE uploadReportData function .. ///
public static void processDirectory()
{
ZipHelper.getZipFiles();
ZipHelper.processZipFiles();
}
我也尝试更改
Directory.Move(reportFolderPath, EXTRACTED_FOLDERS + folderName);
to
Directory.Move(reportFolderPath + "//", EXTRACTED_FOLDERS + folderName);
,但仍然收到错误。我尝试下载和使用ProcessExplorer(如在此处的另一个答案中指出),而访问该目录本身的唯一过程是我的程序。
任何帮助都将不胜感激。
编辑
我为这一长度表示歉意,但我怀疑问题可能在以下代码中:
private static void uploadReportData(String folderPath)
{
String empFile = "";
String reportFile = "";
String spouseFile = "";
String childrenFile = "";
String beneficiaryFile = "";
String visionDependentFile = "";
Boolean hasEmployeeFile = false;
Boolean hasReportFile = false;
foreach (String files in Directory.GetFiles(folderPath).ToList())
{
if (files.Contains("employee"))
{
hasEmployeeFile = true;
empFile = files;
}
if (files.Contains("report"))
{
hasReportFile = true;
reportFile = files;
}
if (files.Contains("spouse"))
{
spouseFile = files;
}
if (files.Contains("children"))
{
childrenFile = files;
}
if (files.Contains("beneficiaries"))
{
beneficiaryFile = files;
}
if (files.Contains("vision"))
{
visionDependentFile = files;
}
}
String employee;
String report;
String vision;
String beneficiary;
String children;
String spouse;
CsvFileReader reader;
try
{
using (InsuranceModel dbContext = new InsuranceModel())
{
EmployeeReportData empData = new EmployeeReportData();
Employee emp;
Report newReport = new Report();
if (empFile != "")
{
report = reportFile;
employee = empFile;
employee.Trim();
reader = new CsvFileReader(employee);
List<String> employees = new List<string>();
while (reader.ReadRow(employees)) { }
String employeeID = employees[0];
emp = dbContext.Employees.FirstOrDefault(em => em.EmployeeID == employeeID);
// see if employee exists in the database
if (emp == null)
{
emp = new Employee();
emp.EmployeeID = employeeID;
emp.SSN = employees[1];
emp.FirstName = employees[2];
emp.LastName = employees[3];
emp.DOB = Convert.ToDateTime(employees[4]);
dbContext.Employees.Add(emp);
}
List<String> reportList = new List<string>();
reader = new CsvFileReader(report);
while (reader.ReadRow(reportList)) { }
newReport.Employee = emp;
newReport.EmployeeID = emp.EmployeeID;
newReport.Year = reportList[1];
newReport.DateSubmitted = Convert.ToDateTime(reportList[2]);
newReport.Action = Convert.ToInt32(reportList[3]);
dbContext.Reports.Add(newReport);
// add employees year specific data regardless
empData.EmployeeFirst = employees[2];
empData.EmployeeLast = employees[3];
empData.EmployeeGender = employees[5];
empData.EmployeeEmail = employees[6];
empData.EmployeeStreet = employees[7];
empData.EmployeeCity = employees[8];
empData.EmployeeState = employees[9];
empData.EmployeeZip = employees[10];
String locCode = employees[11].Trim();
Location loc = dbContext.Locations.First(l => l.LocationCode == locCode);
empData.EmployeeLocation = loc.LocationID;
empData.EmployeePhone = employees[12];
empData.InsurancePlan = Convert.ToInt32(employees[13]);
empData.VisionPlan = Convert.ToInt32(employees[14]);
empData.Status = employees[15].Trim();
empData.Report = newReport;
dbContext.EmployeeReportDatas.Add(empData);
}
if (childrenFile != "")
{
children = childrenFile;
reader = new CsvFileReader(children);
List<String> childrenList = new List<string>();
while (reader.ReadRow(childrenList))
{
ChildReportData newChild = new ChildReportData();
newChild.Report = newReport;
newChild.ChildFirst = childrenList[0];
newChild.ChildLast = childrenList[1];
newChild.ChildDOB = Convert.ToDateTime(childrenList[2]);
newChild.ChildGender = childrenList[3];
newChild.ChildStreet = childrenList[4];
newChild.ChildCity = childrenList[5];
newChild.ChildState = childrenList[6];
newChild.ChildZip = childrenList[7];
newChild.Step = childrenList[8];
newChild.Foster = childrenList[9];
newChild.Student = childrenList[10];
newChild.Handicap = childrenList[11];
newChild.ChildSSN = childrenList[12];
dbContext.ChildReportDatas.Add(newChild);
childrenList.Clear(); // clear in preparation for reading a new row
}
}
if (spouseFile != "")
{
spouse = spouseFile;
reader = new CsvFileReader(spouse);
List<String> spouseList = new List<string>();
while (reader.ReadRow(spouseList)) { }
SpouseReportData newSpouse = new SpouseReportData();
newSpouse.Report = newReport;
newSpouse.SpouseSSN = spouseList[0];
newSpouse.SpouseFirst = spouseList[1];
newSpouse.SpouseLast = spouseList[2];
newSpouse.SpouseStreet = spouseList[3];
newSpouse.SpouseCity = spouseList[4];
newSpouse.SpouseState = spouseList[5];
newSpouse.SpouseZip = spouseList[6];
newSpouse.SpouseGender = spouseList[7];
newSpouse.SpouseDOB = Convert.ToDateTime(spouseList[8]);
newSpouse.SpouseEmployed = spouseList[9];
dbContext.SpouseReportDatas.Add(newSpouse);
}
if (beneficiaryFile != "")
{
beneficiary = beneficiaryFile;
reader = new CsvFileReader(beneficiary);
List<String> beneficiaryList = new List<string>();
while (reader.ReadRow(beneficiaryList))
{
BeneficiaryReportData newBeneficiary = new BeneficiaryReportData();
newBeneficiary.Report = newReport;
newBeneficiary.BeneficiarySSN = beneficiaryList[0];
newBeneficiary.BeneficiaryFirst = beneficiaryList[1];
newBeneficiary.BeneficiaryLast = beneficiaryList[2];
newBeneficiary.BeneficiaryStreet = beneficiaryList[3];
newBeneficiary.BeneficiaryCity = beneficiaryList[4];
newBeneficiary.BeneficiaryState = beneficiaryList[5];
newBeneficiary.BeneficiaryZip = beneficiaryList[6];
newBeneficiary.BeneficiaryPercentage = Convert.ToDecimal(beneficiaryList[7]);
newBeneficiary.BeneficiaryRelationship = beneficiaryList[8];
newBeneficiary.BeneficiaryType = beneficiaryList[9];
dbContext.BeneficiaryReportDatas.Add(newBeneficiary);
beneficiaryList.Clear(); // clear in preparation for reading a new row
}
}
if (visionDependentFile != "")
{
vision = visionDependentFile;
reader = new CsvFileReader(vision);
List<String> visionList = new List<string>();
while (reader.ReadRow(visionList))
{
VisionDependentReportData newVision = new VisionDependentReportData();
newVision.Report = newReport;
newVision.VisionSSN = visionList[0];
newVision.VisionFirst = visionList[1];
newVision.VisionLast = visionList[2];
newVision.VisionDOB = Convert.ToDateTime(visionList[3]);
newVision.VisionGender = visionList[4];
newVision.VisionRelationship = visionList[5];
dbContext.VisionDependentReportDatas.Add(newVision);
visionList.Clear(); // clear in preparation for reading a new row
}
}
dbContext.SaveChanges();
}
}
我的直觉说您需要关闭/处置CSVFILEREDER对象。任何要文件的流将锁定直到您发布。