using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace DeleteFilesNoNeed
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            try
            {

         
            zj123.SQLDB.DbAccess dba = new zj123.SQLDB.DbAccess(this.textBox2.Text.Trim());
            //插入臨時表數據--對應年月的
           // string tempInsertSql = "insert into tempDataFiles([FileName]) select [FileName] from datafiles where [filename] like '%"+this.textBox1.Text.Trim()+"%'";
           // string tempDeleteSql = "delete from tempDataFiles";
            //dba.GetState(tempDeleteSql + ";" + tempInsertSql + ";");
            //dba.GetState(tempDeleteSql);
            StringBuilder sbsql = new StringBuilder("delete from DriveFiles;");
            System.IO.DirectoryInfo dir = new System.IO.DirectoryInfo(this.folderBrowserDialog1.SelectedPath);

            foreach (System.IO.FileInfo fi in dir.GetFiles())
            {
                sbsql.AppendFormat("insert into DriveFiles([FileName],[FilePath]) values('{0}','{1}');",fi.Name,fi.FullName);

            }
            foreach(System.IO.DirectoryInfo di in dir.GetDirectories())
            {
                foreach (System.IO.FileInfo fi in di.GetFiles())
                {
                    sbsql.AppendFormat("insert into DriveFiles([FileName],[FilePath]) values('{0}','{1}');", fi.Name, fi.FullName);

                }

            }
            dba.GetState(sbsql.ToString());
            string tempDeletSql = "select * from DriveFiles where ltrim(rtrim([FileName])) not in(select ltrim(rtrim([FileName])) from tempDataFiles)";
            DataTable dt = dba.GetTable(tempDeletSql);
            int i = 0;
            int a = dt.Rows.Count;
           // StringBuilder sb = new StringBuilder();
            foreach (DataRow dr in dt.Rows)
            {
                System.IO.File.Delete(Convert.ToString(dr["FilePath"]).Trim());
             //   sb.Append(Convert.ToString(dr["FilePath"]).Trim()).Append(System.Environment.NewLine);
                i++;
                this.label4.Text = "正在刪除" + i.ToString()+"---共"+a.ToString().ToString();
                Application.DoEvents();
            }
           // this.richTextBox1.Text = sb.ToString();

        }
        catch (Exception ex)
        {

            MessageBox.Show(ex.Message);
        }

        }

        private void button2_Click(object sender, EventArgs e)
        {
            this.folderBrowserDialog1.ShowDialog();
        }

        private void button3_Click(object sender, EventArgs e)
        {
            string filePath = this.folderBrowserDialog1.SelectedPath;

        }
    }
}