异步委托的应用（五）文件对比的例子

　　　好了，我们前面已经说了很多，相信大家对异步委托已经有了一些了解。

　　　现在我就把我的例子放上来，这是一个比较简单的程序。仅供大家交流。

 

　　　第一步我定义一个操作数据库的类文件

　　　using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.SqlClient; namespace newFileIsNo { public class DBclass { public SqlConnection conn = new SqlConnection("server='127.0.0.1';uid='sa';pwd='sa1234';database='ETrain'"); //下面的方法是我的数据库中的方法，你可以根据自己的情况来改写 public DataTable getInfo(string SourceID, string TableName) { string strsql = "select * from " + TableName + " where source_id=" + SourceID + ""; SqlCommand cmd = new SqlCommand(strsql, conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); //closeConn(); return ds.Tables[0]; } public int GetCount(string SourceID, string TableName) { string strsql = "select Count(*) from " + TableName + " where source_id=" + SourceID + ""; conn.Open(); SqlCommand cmd = new SqlCommand(strsql, conn); return (int)cmd.ExecuteScalar(); } public void closeConn() { conn.Close(); } } } 

 

 控件名与功能：

 

　文本框　txtDir　      :　文件所在路径。

　文本框　txtCount      :  所对比文件总数

　文本框  txtOldNum　　 :　已检查文件数

　文本框  txtErrNum     :　文件错误数

 

  下拉框　cobSource　　 :  资源版本

  下拉框　cobSourceType :　资源类型

 

　显示框　rtbContent　　:  显示错误文件信息

 

  按钮　　btnSearch     :  检查按钮

 

 

代码如下：

 

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Threading; using System.IO; namespace newFileIsNo { public partial class Form1 : Form { //实例化数据库操作类 public DBclass db = new DBclass(); //建立一个主体的委托 public delegate void BeginRun(string source, string sourceType); //建立一个为了显示已经查询文件数的委托 public delegate void GetOldFileNum(); //建立一个为了显示错误文件数的委托 public delegate void GetErrFileNum(); //建立一个为了显示错误文件信息的委托 public delegate void GetErrFile(string FileInfo); public Form1() { InitializeComponent(); //Form.CheckForIllegalCrossThreadCalls = false; } private void Form1_Load(object sender, EventArgs e) { this.cobSource.DataSource = GetSourceDT(); this.cobSource.DisplayMember = "SourceName"; this.cobSource.ValueMember = "SourceValue"; this.cobSourceType.DataSource = GetSourceTypeDT(); this.cobSourceType.DisplayMember = "SourceName"; this.cobSourceType.ValueMember = "SourceValue"; } /// <summary> /// 得到资源版本的信息 /// </summary> public DataTable GetSourceDT() { //建立一个DataTable DataTable DtSource = new DataTable(); //为table建立二个列一个显示列，一个取值列 DataColumn dcName = new DataColumn(); dcName.ColumnName = "SourceName"; DtSource.Columns.Add(dcName); DataColumn dcValue = new DataColumn(); dcValue.ColumnName = "SourceValue"; DtSource.Columns.Add(dcValue); //为table赋值 DataRow dr1 = DtSource.NewRow(); dr1["SourceName"] = "人教新课标"; dr1["SourceValue"] = "2"; DtSource.Rows.Add(dr1); DataRow dr2 = DtSource.NewRow(); dr2["SourceName"] = "人教现行"; dr2["SourceValue"] = "1"; DtSource.Rows.Add(dr2); DataRow dr3 = DtSource.NewRow(); dr3["SourceName"] = "北师大新课标"; dr3["SourceValue"] = "3"; DtSource.Rows.Add(dr3); return DtSource; } /// <summary> /// 得到资源类型的信息 /// </summary> public DataTable GetSourceTypeDT() { //建立一个DataTable DataTable DtSource = new DataTable(); //为table建立二个列一个显示列，一个取值列 DataColumn dcName = new DataColumn(); dcName.ColumnName = "SourceName"; DtSource.Columns.Add(dcName); DataColumn dcValue = new DataColumn(); dcValue.ColumnName = "SourceValue"; DtSource.Columns.Add(dcValue); //为table赋值 DataRow dr1 = DtSource.NewRow(); dr1["SourceName"] = "素材中心"; dr1["SourceValue"] = "V_Material"; DtSource.Rows.Add(dr1); DataRow dr2 = DtSource.NewRow(); dr2["SourceName"] = "教案中心"; dr2["SourceValue"] = "V_samples"; DtSource.Rows.Add(dr2); DataRow dr3 = DtSource.NewRow(); dr3["SourceName"] = "课件中心"; dr3["SourceValue"] = "V_courseware"; DtSource.Rows.Add(dr3); DataRow dr4 = DtSource.NewRow(); dr4["SourceName"] = "同步训练"; dr4["SourceValue"] = "train"; DtSource.Rows.Add(dr4); DataRow dr5 = DtSource.NewRow(); dr5["SourceName"] = "知识拓展"; dr5["SourceValue"] = "develop"; DtSource.Rows.Add(dr5); return DtSource; } private void btnSearch_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(this.txtDir.Text.Trim())) { MessageBox.Show("请添加写文件所在路径"); return; } else { this.rtbContent.Text = "开始查询........../r/n"; this.txtErrNum.Text = "0"; this.txtOldNum.Text = "0"; this.txtCount.Text = db.GetCount(this.cobSource.SelectedValue.ToString().Trim(), this.cobSourceType.SelectedValue.ToString().Trim()).ToString(); BeginRun br = new BeginRun(Run); br.BeginInvoke(this.cobSource.SelectedValue.ToString().Trim(), this.cobSourceType.SelectedValue.ToString().Trim(), null, null); } } /// <summary> /// 检查文件是否不存在 /// </summary> public void Run(string source,string sourceType) { //DataTable dt = db.getInfo(this.cobSource.SelectedValue.ToString().Trim(), this.cobSourceType.SelectedValue.ToString().Trim()); DataTable dt = db.getInfo(source, sourceType); string TempPath = this.txtDir.Text.Trim(); switch (source) { case "1": TempPath += "/resource/"; break; case "2": TempPath += "/resource1/"; break; case "3": TempPath += "/resource2/"; break; } for (int i = 0; i < dt.Rows.Count; i++) { this.txtOldNum.BeginInvoke(new GetOldFileNum(getOldFile)); if (!File.Exists(TempPath + dt.Rows[i]["link"].ToString().Replace("//", "/"))) { Thread.Sleep(300); this.txtErrNum.BeginInvoke(new GetErrFileNum(getErrFile)); this.rtbContent.BeginInvoke(new GetErrFile(getErrFileCon), TempPath + dt.Rows[i]["link"].ToString().Replace("//", "/")); } } //this.rtbContent.Text += this.rtbContent.BeginInvoke(new GetErrFile(getErrFileCon), "查询结束......."); db.closeConn(); } /// <summary> /// 计算已经对比了，多少文件 /// </summary> public void getOldFile() { this.txtOldNum.Text = (Convert.ToInt32(this.txtOldNum.Text) + 1).ToString(); } /// <summary> /// 计算错误的文件数 /// </summary> public void getErrFile() { this.txtErrNum.Text = (Convert.ToInt32(this.txtErrNum.Text) + 1).ToString(); } /// <summary> /// 显示错误的文件路径 /// </summary> /// <param name="str"></param> public void getErrFileCon(string str) { this.rtbContent.Text += str + "/r/n"; } } }