下面代码将演示如何使用NUnit进行并发测试启动多线程插入多个数据并在插入完数据后删除数据



using;
using.Collections.Generic;
using.Text;
usingNUnit.Framework;
usingWYEng.SQLServerDAL;
using.Threading;
using.Data;
using.Data.SqlClient;

WYEng.TestUnit
...{
[TestFixture]
publicExamComputerInfo
...{
SQLServerDAL.ExamComputerInfocomputerInfo;
WYEng.Model.ExamComputerInfomCompuerInfo;
privatej=0;
privatecomputerID=0;
privatePARAM_COMPUTERID=\"@ComputerID\";
[SetUp]
publicvoidCreateObject
...{
computerInfo=WYEng.SQLServerDAL.ExamComputerInfo;
mCompuerInfo=WYEng.Model.ExamComputerInfo;
TestGetComputerID;
}

[TearDown]
publicvoidDeleteObject
...{
TestDeleteComputerInfo;
computerInfo=null;
mCompuerInfo=null;

}
privatevoidTestGetComputerID
...{
computerID=XPWY.DBUtility.DBHelperSQL.GetMaxID(\"ComputerID\",\"ExamComputerInfo\");
} [Page]
privatevoidTestDeleteComputerInfo
...{
Console.WriteLine(computerID.);
strSql=\"DELETEFROMExamComputerInfoWHEREComputerID>=

@ComputerID\";
SqlParameterpram=SqlParameter(PARAM_COMPUTERID,SqlDbType.Int);
pram.Value=computerID;
XPWY.DBUtility.DBHelperSQL.ExecuteSql(strSql,pram);
}
[Test]
[Ignore(\"为了测试并发插入问题屏蔽该思路方法\")]
publicvoidGetComputerInfo
...{
Threadthreads=Thread[1000];
for(i=0;i<1000;i)
...{
Threadt=Thread(ThreadStart(Func));
threads[i]=t;
}
for(i=0;i<1000;i)
...{
threads[i].Start;
}




}
privatevoidFunc [Page]
...{
mCompuerInfo=computerInfo.GetComputerInfo(1);
Assert.AreEqual(mCompuerInfo.ComputerName,\"YMF-XPWY\");
}
[Test]
publicvoidGetComputerInfoByMAC
...{
mCompuerInfo=computerInfo.GetComputerInfoByMAC(\"00:1B:FC:64:6C:A3\");
Assert.AreEqual(mCompuerInfo.ComputerName,\"YMF-XPWY\");//正常条件
mCompuerInfo=computerInfo.GetComputerInfoByMAC(\"00:sdfsdfsdf\");
Assert.AreEqual(mCompuerInfo,null);//边界条件
}

[Test]
publicvoidTestInsertCPInfoWhileMorePeoper
...{
Threadthreads=Thread[1000];
for(i=0;i<1000;i)
...{
j;
threads[i]=Thread(ThreadStart(TestInsertCPInfo));
threads[i].Start;
}
}
privatevoidTestInsertCPInfo
...{
mCompuerInfo.AudioDapater=j.; [Page]
mCompuerInfo.BrowserInfo=j.;
mCompuerInfo.ComputerName=\"fw\";
mCompuerInfo.EthernetAddress=\"asdsad\";
mCompuerInfo.ExamSeatNo=j;
mCompuerInfo.IpAddress=\"192.168.0.1\";
mCompuerInfo.IsTestPassed=true;;
mCompuerInfo.NotPassedError=\"yes\";
mCompuerInfo.OSName=\"OSName\";
mCompuerInfo.OSVersion=\"1.0.1\";
computerInfo.InsertCPInfo(mCompuerInfo);
}
}
}