public bool CreateTableStructure()
{
try
{
//List<String> lstTableName = (List<String>)_databaseService.GetDataListBySQL<string>(new StringBuilder(DBSchemaDefinition.GetTableNameBySpecificValueSQL("DeviceInfo8001")));
List <String> lstTableName = _dbFileVersionService.GetTablesOfDB("DeviceInfo8001");
if (lstTableName.Count == 0)//数据库中不存在表DeviceInfo8001
{
//StringBuilder sbDeviceInfoSQL = new StringBuilder("Create table DeviceInfo8001(");
//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("BoardNo integer,");
//sbDeviceInfoSQL.Append("SubBoardNo integer,");
//sbDeviceInfoSQL.Append("KeyNo integer,");
//sbDeviceInfoSQL.Append("BroadcastZone varchar(8),");
//sbDeviceInfoSQL.Append("LinkageGroup1 varchar(4),");
//sbDeviceInfoSQL.Append("LinkageGroup2 varchar(4),");
//sbDeviceInfoSQL.Append("LinkageGroup3 varchar(4),");
//sbDeviceInfoSQL.Append("BuildingNo integer,");
//sbDeviceInfoSQL.Append("ZoneNo integer,");
//sbDeviceInfoSQL.Append("FloorNo integer,");
//sbDeviceInfoSQL.Append("RoomNo integer,");
//sbDeviceInfoSQL.Append("Location varchar(40),");
//sbDeviceInfoSQL.Append("SDPKey varchar(6),");
//sbDeviceInfoSQL.Append("MCBID integer references ManualControlBoard(ID) on delete restrict deferrable initially deferred,");
//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);
_dbFileVersionService.CreateTableForDeviceInfoOfControllerType8001();
}
}
catch
{
return(false);
}
return(true);
}
