public void CreateTableDoc(IConnector connector)
{
BaseFieldTable tableTree = new BaseFieldTable("文档表", "文档总表");
tableTree.AddField(new TableField()
{
Name = "所属报表ID",
Type = TableField.FieldTypeList[TableFieldType.整型]
});
tableTree.AddField(new TableField()
{
Name = "数据记录ID",
Type = TableField.FieldTypeList[TableFieldType.整型]
});
tableTree.AddField(new TableField()
{
Name = "文档名称",
Type = TableField.FieldTypeList[TableFieldType.文本]
});
tableTree.AddField(new TableField()
{
Name = "文档内容",
Type = TableField.FieldTypeList[TableFieldType.文档]
});
CreateTable(connector, tableTree);
}
/// <summary>
/// 获取职能表的所有字段
/// </summary>
/// <param name="tableName"></param>
/// <returns></returns>
public IFieldTable GetTableFields(string tableName)
{
TableField[] fields = connector.GetFieldMark(tableName);
BaseFieldTable table = new BaseFieldTable(tableName);
fields.ToList().ForEach(f => table.AddField(f));
return(table);
}
private IFieldTable GetTableFromField(string tableName, string tableDiscript, TableField[] fields)
{
BaseFieldTable table = new BaseFieldTable(tableName, tableDiscript);
foreach (TableField field in fields)
{
table.AddField(field);
}
return(table);
}
public void CreateTableTree(IConnector connector)
{
BaseFieldTable tableTree = new BaseFieldTable("报表目录", "文档管理系统表目录结构");
tableTree.AddField(new TableField()
{
Name = "报表类型ID",
Type = TableField.FieldTypeList[TableFieldType.整型]
});
tableTree.AddField(new TableField()
{
Name = "报表名称",
Type = TableField.FieldTypeList[TableFieldType.文本]
});
tableTree.AddField(new TableField()
{
Name = "备注",
Type = TableField.FieldTypeList[TableFieldType.文本]
});
CreateTable(connector, tableTree);
}
public void CreateTableDeviceCare(IConnector connector)
{
BaseFieldTable tableTree = new BaseFieldTable("保养提醒", "系统管理设备的保养提醒服务");
tableTree.AddField(new TableField()
{
Name = "设备表名",
Type = TableField.FieldTypeList[TableFieldType.文本]
});
tableTree.AddField(new TableField()
{
Name = "保养时间",
Type = TableField.FieldTypeList[TableFieldType.文本]
});
tableTree.AddField(new TableField()
{
Name = "保养周期",
Type = TableField.FieldTypeList[TableFieldType.整型]
});
CreateTable(connector, tableTree);
}