月度归档： 2015 年 12 月

C#在线程中使用Invoke来调用UI线程里的控件

C#在线程中使用Invoke来调用UI线程里的控件

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

namespace TextTool
{
    public partial class Form1 : Form
    {
        private Thread workThread = null; //工作线程
        private List <string> fileList = new List <string>();
        public Form1()
        {
            InitializeComponent();
        }

        // 导入 可多选
        private void button1_Click(object sender, EventArgs e)
        {
            Stream mystream;
            OpenFileDialog openfiledialog1 = new OpenFileDialog();
            openfiledialog1.Multiselect = true;//允许同时选择多个文件
            openfiledialog1.Filter = "txt files(*.txt)|*.txt|All files(*.*)|*.*" ;
            openfiledialog1.FilterIndex = 1;
            openfiledialog1.RestoreDirectory = true;
            if (openfiledialog1.ShowDialog() == DialogResult.OK)
            {
                if ((mystream = openfiledialog1.OpenFile()) != null)
                {
                    fileList.Clear();
                    for (int fi = 0; fi < openfiledialog1.FileNames.Length; fi++)
                    {
                        fileList.Add(openfiledialog1.FileNames[fi]);
                    }
                    mystream.Close();
                }

                listView1.Items.Clear();
                foreach (var filePath in fileList)
                {
                    ListViewItem lvi = new ListViewItem(filePath);
                    listView1.Items.Add(lvi);
                }
            }
        }

        // 合并处理并输出
        private void button2_Click(object sender, EventArgs e)
        {
            if (fileList.Count == 0)
            {
                MessageBox.Show("请先添加要处理的文件" );
                return;
            }

            SaveFileDialog savefiledialog1 = new SaveFileDialog();
            savefiledialog1.Filter = "txt files(*.txt)|*.txt" ;
            if (savefiledialog1.ShowDialog() == DialogResult.OK)
            {
                button2.Text = "处理中..." ;
                button2.Enabled = false;

                workThread = new Thread (WorkThread);
                workThread.Start(savefiledialog1.FileName);
            }
        }

        private int MyCompareString(string x, string y)
        {
            int pos1 = x.IndexOf("(" );
            int pos2 = x.IndexOf(")" );
            int cnt1 = Convert .ToInt32(x.Substring(pos1 + 1, pos2-pos1 -1));

            pos1 = y.IndexOf( "(");
            pos2 = y.IndexOf( ")");
            int cnt2 = Convert .ToInt32(y.Substring(pos1 + 1, pos2 - pos1 - 1));
 
            if (cnt1 > cnt2)
            {
                return -1;
            }
            else if (cnt1< cnt2)
            {
                return 1;
            }
            else
            {
                return 0;
            }
        }

        public void WorkThread(object savePath)
        {
            List<string > allLines = new List< string>();
            foreach (var filePath in fileList)
            {
                allLines.AddRange( File.ReadAllLines(filePath));
            }

            int totalCount = 0;
            List<string > outputList = new List< string>();
            foreach (var line in (from t in allLines where t.Trim() != "" select t).Distinct())
            {
                int count = (from c in allLines where c == line select c).Count();
                totalCount += count;
                outputList.Add( $"{line} ( {count})");
            }
            outputList.Sort(MyCompareString);
            outputList.Add( $"总数：{totalCount}" );
            File.WriteAllLines(savePath.ToString(), outputList);

            Invoke( new MethodInvoker (delegate ()
            {
                button2.Text = "合并处理输出" ;
                button2.Enabled = true;
                MessageBox.Show("处理完成！" );
            }));
        }

        private void Form1_FormClosing(object sender, FormClosingEventArgs e)
        {
            if (workThread != null && workThread.IsAlive)
            {
                workThread.Abort();
            }
        }
    }
}

如果是WPF程序，则在线程中像下面这样操作控件

this.Dispatcher.Invoke(new Action( delegate
{
    lblState.Content = "正在检测域名" + fullUrl;
}));

C#使用OleDB连接Access数据库

C#使用OleDB连接Access数据库的代码：

public class DbHelper
{
    static DbHelper()
    {
        connectionString = GetConnectionString();
    }

    private static string connectionString;

    private static string GetConnectionString()
    {
        return string.Format( "File Name={0}\\link.udl", Application .StartupPath);
    }


    public static DataTable ExecuteDataTable( string sql)
    {
        try
        {
            using ( OleDbDataAdapter da = new OleDbDataAdapter (sql, connectionString))
            {
                DataSet ds = new DataSet();
                da.Fill(ds);
                return ds.Tables[0];
            }
        }
        catch( Exception e)
        {
            MessageBox.Show(e.Message);
            return null;
        }

    }

    public static void ExecuteNonQuery( string sql)
    {
        using ( OleDbConnection conn = new OleDbConnection (connectionString))
        {
            try
            {
                conn.Open();

                OleDbCommand cmd = conn.CreateCommand();
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = sql;
                cmd.ExecuteNonQuery();
                cmd.Dispose();
            }
            finally
            {
                if (conn.State == ConnectionState.Open) conn.Close();
            }
        }          
    }

}

Linux历险记

今天我犯了个大错，我在服务器上的htdocs目录下使用了 rm -rf * ，造成所有网站文件全没有了。犯这个错误的原因是：我以为当前的操作目录是网站目录。

当按下回车键后就傻了，愣了几秒钟。赶紧到网上找恢复方法，显示用debugfs试了下，发现只能一个文件一个文件的恢复（或许可以恢复目录，我没查到），不可行。继续插，又找到了extundelete，这个可以恢复目录，使用命令如下：

extundelete  /dev/vda1 --restore-directory /web/httpd/htdocs

/dev/vad1是用命令df -h找出来的（看第一列）。

这个倒是可以恢复，可能由于我extundelete是的误删了以后才装的，造成覆盖了磁盘，所以博客网站的文件没能恢复全。其他几个没用的网站倒是恢复了。

“算了，反正数据库还在，重新下载一个WordPress”，心里这么想着。于是备份了数据库，开始全新安装。神奇的是，安装好后，数据还在！！这说明WordPress做了检测，如果数据存在，就不覆盖。然后安装代码高亮插件。Ok，到这里，一切如初。

以后使用rm要考虑好！！！