public bool CreateTableStructure() { // try // { // List<String> lstTableName = (List<String>)_databaseService.GetDataListBySQL<string>(new StringBuilder(DBSchemaDefinition.GetTableNameBySpecificValueSQL("DeviceInfo8007"))); // if (lstTableName.Count == 0)//数据库中不存在表DeviceInfo8007 // { // StringBuilder sbDeviceInfoSQL = new StringBuilder("Create table DeviceInfo8007("); // sbDeviceInfoSQL.Append("ID integer not null primary key autoincrement,"); // sbDeviceInfoSQL.Append("Code varchar(8),"); // sbDeviceInfoSQL.Append("Disable Boolean,"); // sbDeviceInfoSQL.Append("Feature integer,"); // sbDeviceInfoSQL.Append("SensitiveLevel integer,"); // sbDeviceInfoSQL.Append("LinkageGroup1 varchar(4),"); // sbDeviceInfoSQL.Append("LinkageGroup2 varchar(4),"); // sbDeviceInfoSQL.Append("BuildingNo integer,"); // sbDeviceInfoSQL.Append("ZoneNo integer,"); // sbDeviceInfoSQL.Append("FloorNo integer,"); // sbDeviceInfoSQL.Append("RoomNo 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("DeviceInfo8007"); if (lstTableName.Count == 0)//数据库中不存在表DeviceInfo8007 { _dbFileVersionService.CreateTableForDeviceInfoOfControllerType8007(); } } catch { return(false); } return(true); }