Exemplo n.º 1
0
 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;
     }
 }
Exemplo n.º 2
0
        /// <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);
        }
Exemplo n.º 3
0
 //退出菜单
 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();
     }
 }
Exemplo n.º 4
0
        /// <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;
        }
Exemplo n.º 5
0
        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;
        }
Exemplo n.º 6
0
        /// <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());
        }