/// <summary>
/// 创建基础表结构
/// </summary>
/// <returns></returns>
public bool CreatFundamentalTableStructure()
{
try
{
//取得数据表结构(在某个数据文件版本中，如果表结构有变化，可通过构造此值完成逻辑，建议：为兼容老版本，以下代码不要删减)
List <String> lstTableName = GetTablesOfDB();
if (lstTableName == null)
{
lstTableName = new List <string>();
}
;
if (!lstTableName.Contains("Project"))//创建项目信息数据表
{
//StringBuilder sbProjectSQL = new StringBuilder("Create table project(ID integer not null primary key autoincrement, Name varchar(255), SaveInterval integer, SavePath varchar(255));");
//_databaseService.ExecuteBySql(sbProjectSQL);
_dbFileVersionService.CreateTableForProject();
}
if (!lstTableName.Contains("ControllerType"))//创建控制器类别数据表
{
//StringBuilder sbControllerTypeSQL = new StringBuilder("Create table ControllerType(ID integer not null primary key,Name varchar(255), DeFireSystemCategoryID integer references DeFireSystemCategory(ID) on delete restrict deferrable initially deferred not null);");
//_databaseService.ExecuteBySql(sbControllerTypeSQL);
_dbFileVersionService.CreateTableForControllerType();
}
if (!lstTableName.Contains("DeFireSystemCatetory")) //创建消防系统分类数据表
{
//StringBuilder sbDeFireSystemCategorySQL = new StringBuilder("Create table DeFireSystemCatetory(ID integer not null primary key autoincrement, Name varchar(255), Memo varchar(255));");
//_databaseService.ExecuteBySql(sbDeFireSystemCategorySQL);
_dbFileVersionService.CreateTableForDeFireSystemCategory();
}
if (!lstTableName.Contains("DeviceType")) //创建器件类别数据表
{
//StringBuilder sbDeviceTypeSQL = new StringBuilder("Create table DeviceType(Code integer not null primary key autoincrement, Name varchar(20),CustomImage blob,StandardImage blob,IsValid Boolean,MatchingController varchar(100), ProjectID integer references Project(ID) on delete restrict deferrable initially deferred not null);");
//_databaseService.ExecuteBySql(sbDeviceTypeSQL);
_dbFileVersionService.CreateTableForDeviceType();
}
#region 创建控制器相关信息
//创建控制器信息数据表
//创建控制器附属信息数据表
//创建标准组态信息数据表
//创建回路信息数据表
if (!lstTableName.Contains("Controller"))
{
//StringBuilder sbControllerSQL = new StringBuilder("Create table Controller(ID integer not null primary key autoincrement, PrimaryFlag Boolean,TypeID integer references ControllerType(ID) on delete restrict deferrable initially deferred not null, DeviceAddressLength integer, Name varchar(20), PortName varchar(5),BaudRate integer,MachineNumber varchar(5), Version integer,ProjectID integer references Project(ID) on delete restrict deferrable initially deferred not null);");
//_databaseService.ExecuteBySql(sbControllerSQL);
_dbFileVersionService.CreateTableForController();
}
//此处的涉及文件版本，主要用于区分不同版本的Controller相关数据字段特性
if (!lstTableName.Contains("ControllerAttachedInfo")) //obsolete
{
//StringBuilder sbControllerAttachedInfoSQL = new StringBuilder("Create table ControllerAttachedInfo(ID integer not null primary key autoincrement,FileVersion varchar(4),ProtocolVersion varchar(4),Position varchar(15),controllerID integer references Controller(ID) on delete restrict deferrable initially deferred not null);");
//_databaseService.ExecuteBySql(sbControllerAttachedInfoSQL);
// _dbFileVersionService.CreateTableForControllerAttachedInfo();
}
if (!lstTableName.Contains("LinkageConfigStandard"))
{
//StringBuilder sbLinkageConfigStandardSQL = new StringBuilder("Create table LinkageConfigStandard(ID integer not null primary key autoincrement,Code varchar(4) not null, DeviceNo1 varchar(10),DeviceNo2 varchar(10), DeviceNo3 varchar(10), DeviceNo4 varchar(10), DeviceNo5 varchar(10),DeviceNo6 varchar(10),DeviceNo7 varchar(10),DeviceNo8 varchar(10),DeviceNo9 varchar(10),DeviceNo10 varchar(10), ActionCoefficient integer, LinkageNo1 varchar(4),LinkageNo2 varchar(4),LinkageNo3 varchar(4),controllerID integer references Controller(ID) on delete restrict deferrable initially deferred not null,unique(Code,controllerID))");
//_databaseService.ExecuteBySql(sbLinkageConfigStandardSQL);
_dbFileVersionService.CreateTableForLinkageConfigStandard();
}
if (!lstTableName.Contains("LinkageConfigGeneral"))
{
//StringBuilder sbLinkageConfigStandardSQL = new StringBuilder("Create table LinkageConfigGeneral(ID integer not null primary key autoincrement,Code varchar(4) not null,ActionCoefficient integer, BuildingNoA integer,ZoneNoA integer, LayerNoA1 integer, LayerNoA2 integer, DeviceTypeCodeA integer references DeviceType(Code) on delete restrict deferrable initially deferred,TypeC varchar(20),MachineNoC varchar2(10),LoopNoC varchar(10),DeviceCodeC varchar(10),BuildingNoC integer,ZoneNoC integer, LayerNoC integer ,DeviceTypeCodeC integer references DeviceType(Code) on delete restrict deferrable initially deferred,controllerID integer references Controller(ID) on delete restrict deferrable initially deferred not null,unique(Code,controllerID))");
//_databaseService.ExecuteBySql(sbLinkageConfigStandardSQL);
_dbFileVersionService.CreateTableForLinkageConfigGeneral();
}
if (!lstTableName.Contains("LinkageConfigMixed"))
{
//StringBuilder sbLinkageConfigStandardSQL = new StringBuilder("Create table LinkageConfigMixed(ID integer not null primary key autoincrement,Code varchar(4) not null, ActionCoefficient integer,ActionType varchar(10), TypeA varchar(20), LoopNoA varchar(10), DeviceCodeA varchar(10),BuildingNoA integer,ZoneNoA integer, LayerNoA integer, DeviceTypeCodeA integer , TypeB varchar(20), LoopNoB varchar(10), DeviceCodeB varchar(10),BuildingNoB integer,ZoneNoB integer, LayerNoB integer, DeviceTypeCodeB integer ,TypeC varchar(20),MachineNoC varchar(10),LoopNoC varchar(10),DeviceCodeC varchar(10),BuildingNoC integer,ZoneNoC integer, LayerNoC integer ,DeviceTypeCodeC integer,controllerID integer references Controller(ID) on delete restrict deferrable initially deferred not null,unique(Code,controllerID))");
//_databaseService.ExecuteBySql(sbLinkageConfigStandardSQL);
_dbFileVersionService.CreateTableForLinkageconfigMixed();
}
if (!lstTableName.Contains("ManualControlBoard"))
{
//StringBuilder sbLinkageConfigStandardSQL = new StringBuilder("Create table ManualControlBoard(ID integer not null primary key autoincrement,Code varchar(4) not null, BoardNo varchar(10),SubBoardNo varchar(10),KeyNo varchar(10), DeviceCode varchar(10), SDPKey varchar(10),controllerID integer references Controller(ID) on delete restrict deferrable initially deferred not null,unique(Code,controllerID))");
//_databaseService.ExecuteBySql(sbLinkageConfigStandardSQL);
_dbFileVersionService.CreateTableForManualControlBoard();
}
if (!lstTableName.Contains("Loop"))
{
//StringBuilder sbLoopSQL = new StringBuilder("Create table Loop(ID integer not null primary key autoincrement,Code varchar(6),Name varchar(20),DeviceAmount integer,controllerID integer references Controller(ID) on delete restrict deferrable initially deferred not null,unique(Code,controllerID));");
//_databaseService.ExecuteBySql(sbLoopSQL);
_dbFileVersionService.CreateTableForLoop();
}
#endregion
return(true);
}
catch (Exception ex)
{
return(false);
}
}
