private void OnProcess(object source, FileSystemEventArgs e)
{
if (e.ChangeType == WatcherChangeTypes.Created)
{
DataRow dr = dt.NewRow();
dr["序号"] = dt.Rows.Count + 1;
string tmpPath = RecentFileHelper.GetShortcutTargetFile(e.FullPath);
dr["文件路径"] = tmpPath;
FileInfo fi = new FileInfo(tmpPath);
dr["上次修改时间"] = fi.LastWriteTime.ToString("yyyy-MM-dd hh:mm:ss");
dr["是否重要"] = "false";
dt.Rows.Add(dr);
this.gvTable.DataSource = dt;
}
if (e.ChangeType == WatcherChangeTypes.Deleted)
{
string tmpPath = RecentFileHelper.GetShortcutTargetFile(e.FullPath);
DataRow[] findRow = dt.Select("文件路径='" + tmpPath + "'");
foreach (DataRow row in findRow)
{
dt.Rows.Remove(row);
}
DataTable ds = dt;
}
}
/// <summary>
/// 创建excel并返回dataTable
/// </summary>
/// <param name="filePath"></param>
/// <returns></returns>
public static DataTable CreateExcel(string filePath, DataTable dt)
{
IWorkbook workbook = null;
ISheet sheet = null;
IRow row = null;
int k = 0;
FileStream fs = null;
// 2007版本
if (filePath.IndexOf(".xlsx") > 0)
{
workbook = new XSSFWorkbook();
}
if (workbook != null)
{
sheet = workbook.CreateSheet("sheet0");
//设置列头
row = sheet.CreateRow(0);//excel第一行设为列头
row.CreateCell(0).SetCellValue("序号");
row.CreateCell(1).SetCellValue("文件名");
row.CreateCell(2).SetCellValue("文件路径");
row.CreateCell(3).SetCellValue("上次修改时间");
row.CreateCell(4).SetCellValue("是否重要");
row.CreateCell(5).SetCellValue("文件备注");
foreach (var file in RecentFileHelper.GetRecentlyFiles())
{
if (File.Exists(file))
{
k++;
FileInfo fi = new FileInfo(file);
row = sheet.CreateRow(k);
DataRow dRow = dt.NewRow();
dRow["序号"] = k;
dRow["文件名"] = fi.Name;
dRow["文件路径"] = file;
dRow["上次修改时间"] = fi.LastWriteTime.ToString("yyyy-MM-dd hh:mm:ss");
dRow["是否重要"] = false;
dRow["文件备注"] = null;
dt.Rows.Add(dRow);
row.CreateCell(0).SetCellValue(k);
row.CreateCell(1).SetCellValue(fi.Name);
row.CreateCell(2).SetCellValue(file);
row.CreateCell(3).SetCellValue(fi.LastWriteTime.ToString("yyyy-MM-dd hh:mm:ss"));
row.CreateCell(4).SetCellValue(false);
row.CreateCell(5).SetCellValue("");
}
}
}
using (fs = File.OpenWrite(filePath))
{
workbook.Write(fs);//向打开的这个xls文件中写入数据
}
return(dt);
}
//退出菜单
private void tsmiExit_Click(object sender, EventArgs e)
{
if (MessageBox.Show("真的要退出程序吗？", "退出程序", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
string filePath = Application.StartupPath + @"\FileDataBase.xlsx";
//删除原excel 将dt 重新写入Excel
if (File.Exists(filePath))
{
File.Delete(filePath);
RecentFileHelper.ReWriteExcel(filePath, dt);
}
Application.Exit();
}
}
/// <summary>
/// 分类搜索（所有）
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void fsWatcher_Created(object sender, FileSystemEventArgs e)
{
DataTable newDt = dt.Copy();
DataRow newRow = newDt.NewRow();
newRow["序号"] = newDt.Rows.Count + 1;
string filepath = RecentFileHelper.GetShortcutTargetFile(e.FullPath);
FileInfo fi = new FileInfo(filepath);
newRow["文件名"] = fi.Name;
newRow["文件路径"] = filepath;
newRow["上次修改时间"] = fi.LastWriteTime.ToString("yyyy-MM-dd HH:mm:ss");
newRow["是否重要"] = false;
newRow["文件备注"] = null;
newDt.Rows.Add(newRow);
this.gvTable.DataSource = newDt;
dt = (DataTable)this.gvTable.DataSource;
}
private void FrmMain_Load(object sender, EventArgs e)
{
string path = Environment.GetFolderPath(Environment.SpecialFolder.Recent);
string filePath = Application.StartupPath + @"\FileDataBase.xlsx";
if (!File.Exists(filePath))
{
//创建FileDataBase.xlsx文件
dt = RecentFileHelper.CreateExcel(filePath, dt);
dtChanged = dt.Copy();
}
else
{
//读取FileDataBase.xlsx文件，并检核，如果有新的文件，写入excel
dt = RecentFileHelper.ReadWriteExcel(filePath, dt);
dtChanged = dt.Copy();
}
this.gvTable.DataSource = dt;
this.gvTable.Columns[5].ReadOnly = false;
fsWatcher.Path = path;
fsWatcher.EnableRaisingEvents = true;
}
/// <summary>
/// 读取excel，检核并写入 返回DataTable
/// </summary>
/// <param name="filePath"></param>
/// <param name="dt"></param>
/// <returns></returns>
public static DataTable ReadWriteExcel(string filePath, DataTable dt)
{
IWorkbook workbook = null;
ISheet sheet = null;
IRow row = null;
FileStream fs = null;
using (fs = new FileStream(filePath, FileMode.Open, FileAccess.ReadWrite))
{
workbook = new XSSFWorkbook(fs);
}
sheet = workbook.GetSheetAt(0);
int rowCount = sheet.LastRowNum;
int tempCount = rowCount;
foreach (var file in RecentFileHelper.GetRecentlyFiles())
{
bool flag = false;
for (int i = 1; i < rowCount + 1; i++)
{
if (File.Exists(file) && sheet.GetRow(i).Cells[2].ToString() == file)
{
flag = true;
break;
}
}
if (!flag)
{
if (File.Exists(file) && file != filePath)
{
tempCount++;
FileInfo fi = new FileInfo(file);
row = sheet.CreateRow(tempCount);
row.CreateCell(0).SetCellValue(sheet.LastRowNum);
row.CreateCell(1).SetCellValue(fi.Name);
row.CreateCell(2).SetCellValue(file);
row.CreateCell(3).SetCellValue(fi.LastWriteTime.ToString("yyyy-MM-dd hh:mm:ss"));
row.CreateCell(4).SetCellValue(false);
row.CreateCell(5).SetCellValue("");
}
}
}
for (int i = 1; i <= sheet.LastRowNum; i++)
{
DataRow dr = dt.NewRow();
dr["序号"] = i;
dr["文件名"] = sheet.GetRow(i).Cells[1].ToString();
dr["文件路径"] = sheet.GetRow(i).Cells[2].ToString();
FileInfo fi = new FileInfo(sheet.GetRow(i).Cells[2].ToString());
dr["上次修改时间"] = sheet.GetRow(i).Cells[3].ToString();
if (sheet.GetRow(i).Cells[4] == null)
{
dr["是否重要"] = false;
}
else
{
if (sheet.GetRow(i).Cells[4].ToString().ToLower() == "false")
{
dr["是否重要"] = false;
}
else
{
dr["是否重要"] = true;
}
}
dr["文件备注"] = string.IsNullOrEmpty(sheet.GetRow(i).Cells[5].ToString()) ? null : sheet.GetRow(i).Cells[5].ToString();
dt.Rows.Add(dr);
}
DataView dv = dt.DefaultView;//文件备注 desc,
dv.Sort = "是否重要 desc,文件备注 asc";
using (fs = File.OpenWrite(filePath))
{
workbook.Write(fs);
}
return(dv.ToTable());
}
