“#”号是注释

“T：”是加入

“D：”是删除表里面的数据

“C：”是检查数据

数据与数据之间用TAB隔开（可以从企业治理器直接把数据拷贝出来作为数据源）

加入数据的事列如下：

#插入用户表
# null为插入空
T:Users
John <TAB>John chan
Cake<TAB>Cake.lu
jeff<TAB>jeff.hu

# CheckTable\\\'s Data
#null为检查是否为空，skip掉过不检查，notnull检查他是否不为空
C:Users
John <TAB>John chan
Cake<TAB>Cake.lu
jeff<TAB>jeff.hu

#Delete All Data
D：TAbleName

调用代码：
参数1：文本文件的路径
参数2：是Helper里面的两个常量（其实可以是个Enum，不过写的时候没有注重）
Helper.ExecuteAction(\"Data.txt\",Helper.INSERT);

参数3：是指定对那个对象操作（T：D：C：后面的名称，如T:Users，那么就填Users）
Helper.ExecuteACtion(\"Data.txt\",Helper.Insert,\"Users\")

代码如下：

using System;
using System.Data;
using System.IO;
using System.Data.SqlClient;
using Microsoft.ApplicationBlocks.Data;
using NUnit.Framework;

namespace TestCore
{
 
 public class Helper
 {
  public const string DELETE=\"D\";
  public const string INSERT=\"T\";
  public const string CHECK=\"C\";
  public const string ANNOTATE=\"#\";
  
  public static string ConnectionString
  {
   //这里要写返回的连接字符串
   get{return null;}
  }
  public static void ExecuteAction(string path,string action)
  {
   ExecuteAction(path,action,null);
  }
   
  public static void ExecuteAction(string path,string action,string inputTable)
  {
   Console.WriteLine(\"----------------\"+action+\" action is Start--------------------\");
   
   StreamReader reader=new StreamReader(path);
   string line;
   string table=null;
   try
   {
    while(true)
    {
     line =reader.ReadLine();
     if(line==null)
      break;
     
     if(line.Length==0)
      continue;
     string Key=line.Substring(0,1);
     if(Key==action)
     {
      table=line.Substring(2);
      if(action==DELETE)
      {
       if(CheckTable(inputTable,table))
       {
        Delete(table);
       }
       table=null;
      }
      else
      {
       continue;
      }
     }
     else if(table!=null)
     {
      switch(action)
      {
       case INSERT:
        if(CheckTable(inputTable,table))
        {
         string[] datas=line.Split(\\\'/t\\\');
         AddData(datas,table);
        }
        break;
       case CHECK:
        if(CheckTable(inputTable,table))
        {
         string[] checkDatas=line.Split(\\\'/t\\\');
         Check(checkDatas,table);
         
        }
        break;
      }
      table =null;
     }
     else
     {
      continue;
     }
    }
   }
   finally
   {
    Console.WriteLine(\"----------------\"+action+\" action is End--------------------\");
    reader.Close();
   }
  }
  private static bool CheckTable(string inputTable,string SettingTable)
  {
   if(inputTable==null)
    return true;
   return (inputTable==SettingTable);
  }
 
  private static void Delete(string table)
  {
   string sql=\" delete from \"+table;
   Console.WriteLine(sql);
   try
   {
    SqlHelper.ExecuteNonQuery(ConnectionString,CommandType.Text,sql);
   }
   catch(Exception e)
   {
    throw new ApplicationException(\"删除错误:Sql是\"+sql,e);
   }
  }
  private static void AddData(string[] data,string table)
  {
   SqlConnection conn=new SqlConnection(ConnectionString);
   string sql=\"insert into \"+table+\" values \";
   string temp=\"(\\\'\"+data[0]+\"\\\'\";
   for(int i=1;i<data.Length;i++)
   {
    if(data[i]!=\"null\")
     temp+=\",\\\'\"+data[i]+\"\\\'\";
    else
     temp+=\",null\";
   }
   sql+=temp+\")\";
   conn.Open();
   try
   {

    Console.WriteLine(sql);
    SqlCommand comm =new SqlCommand(sql,conn);
    comm.ExecuteNonQuery();
   }
   catch(Exception e)
   {
    throw new ApplicationException(table+\":\"+sql,e);
   }
   finally
   {
    conn.Close();
   }
  }
  private static void Check(string[] data,string table)
  {
   string sql=\"select * from \"+table;
   Console.WriteLine(sql);
   DataSet ds = SqlHelper.ExecuteDataset(Helper.ConnectionString,CommandType.Text,sql);
   DataTable dt=ds.Tables[0];
   
   if(dt.Rows.Count==0)
    throw new ArgumentOutOfRangeException( sql+\" 返回结构为空\");

   foreach(DataRow dr in dt.Rows)
   {
    for(int i=0;i<data.Length;i++)
    {
     if(data[i].ToLower()==\"skip\")
      continue;
     if(data[i].ToLower()==\"null\")
     {
      Assert.IsTrue(dr[i].Equals(DBNull.Value),\"expect is null ,but it\\\'s not null actualy\");
      continue;
     }
     if(data[i].ToLower()==\"notnull\")
     {
      Assert.IsFalse(dr[i].Equals(DBNull.Value),\"expect isn\\\'t null but it\\\'s null actualy\");
      continue;
     }
     if(data[i].Length>=4 && data[i].Substring(0,4).ToLower()==\"not:\")
     {
      string txtValue=data[i].Substring(4).ToLower().Trim();
      string dbValue=dr[i].ToString().ToLower().Trim();
      Assert.IsTrue(txtValue!=dbValue,\"db value is the same as data in text file,text file value is \"+txtValue);
      continue;
     }

     if(dr[i].ToString().Length!=0 || dr[i].Equals(DBNull.Value))
     {
      Assert.IsTrue(dr[i].ToString()==data[i],table+\":Check Value Is \"+data[i]+\",but DB is \"+dr[i]);
      continue;
     }
    }
   }
  }
 }
}