public void CreateTableOf8001()
{
StringBuilder sbCreateTableSql = new StringBuilder();
//附属信息
sbCreateTableSql.Append("Create table ControllerAttachedInfo(ID integer not null primary key autoincrement,controllerID integer not null,FileVersion varchar(4), ProtocolVersion varchar(4));");
//回路表
sbCreateTableSql.Append("Create table Loop(id integer not null primary key autoincrement,name varchar(20),Code varchar(6),controllerID int,DeviceAmount int );");
_logHelper = Substitute.For <SCA.Interface.ILogRecorder>();
_dbConn.ExecuteBySql(sbCreateTableSql);
int intControllerAttachedInfoNum = Convert.ToInt16(_dbConn.GetObjectValue(new StringBuilder("select count(*) from ControllerAttachedInfo")));
int intLoopNum = Convert.ToInt16(_dbConn.GetObjectValue(new StringBuilder("select count(*) from Loop")));
Assert.AreEqual(0, intControllerAttachedInfoNum);
// Assert.AreEqual(0, intLoopNum);//不知为什么查出的结果会是１
_dbConn.Dispose();
}
public void Initilize()
{
_fileService = new SCA.BusinessLib.Utility.FileService();
_logHelper = new SCA.BusinessLib.Utility.LogRecorder(_fileService);
}