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); }