public bool CreateTableStructure()
{
//try
//{
// List<String> lstTableName = (List<String>)_databaseService.GetDataListBySQL<string>(new StringBuilder(DBSchemaDefinition.GetTableNameBySpecificValueSQL("DeviceInfo8003")));
// if (lstTableName.Count == 0)//数据库中不存在表DeviceInfo8007
// {
// StringBuilder sbDeviceInfoSQL = new StringBuilder("Create table DeviceInfo8003(");
// sbDeviceInfoSQL.Append("ID integer not null primary key autoincrement,");
// sbDeviceInfoSQL.Append("Code varchar(8),");
// sbDeviceInfoSQL.Append("Disable Boolean,");
// sbDeviceInfoSQL.Append("Feature integer,");
// sbDeviceInfoSQL.Append("DelayValue integer,");
// sbDeviceInfoSQL.Append("SensitiveLevel integer,");
// sbDeviceInfoSQL.Append("LinkageGroup1 varchar(4),");
// sbDeviceInfoSQL.Append("LinkageGroup2 varchar(4),");
// sbDeviceInfoSQL.Append("LinkageGroup3 varchar(4),");
// sbDeviceInfoSQL.Append("sdpKey integer,");
// sbDeviceInfoSQL.Append("BroadcastZone varchar(8),");
// sbDeviceInfoSQL.Append("ZoneNo integer,");
// sbDeviceInfoSQL.Append("Location varchar(20),");
// sbDeviceInfoSQL.Append("LoopID integer references Loop(ID) on delete restrict deferrable initially deferred not null,");
// sbDeviceInfoSQL.Append("TypeCode integer references DeviceType(Code) on delete restrict deferrable initially deferred not null,unique(Code,LoopID));");
// _databaseService.ExecuteBySql(sbDeviceInfoSQL);
// }
//}
//catch
//{
// return false;
//}
//return true;
try
{
List <String> lstTableName = _dbFileVersionService.GetTablesOfDB("DeviceInfo8003");
if (lstTableName.Count == 0)//数据库中不存在表DeviceInfo8003
{
_dbFileVersionService.CreateTableForDeviceInfoOfControllerType8003();
}
}
catch
{
return(false);
}
return(true);
}
