式式

C ++ APIのAspose.Tasksは、式の式としてタスク、リソース、プロジェクトフィールドを使用できます。作業、コスト、数字フィールド、DateTime、Boolean、およびタスクカウントやリソースカウントなどのプロジェクトフィールドなどのフィールドは、拡張属性の式式で使用できます。

算術式の使用

 1System::SharedPtr<Project> project = CreateTestProjectWithCustomField();
 2    
 3// Set arithmetic formula for extended attribute
 4System::SharedPtr<ExtendedAttributeDefinition> attr = project->get_ExtendedAttributes()->idx_get(0);
 5attr->set_Alias(u"Arithmetic Expression");
 6attr->set_Formula(u"(1+3*(2+ -5)+8/2)^3");
 7    
 8// Display extended attribute value
 9System::SharedPtr<Task> task = project->get_RootTask()->get_Children()->GetById(1);
10System::Console::WriteLine(task->get_ExtendedAttributes()->idx_get(0)->get_NumericValue());

Examples-CPP-WorkingWithFormulas-UsingArithmeticExpression-UsingArithmeticExpression.cpp hosted with ❤ by GitHub

Using Task Number Fields

 1System::SharedPtr<Project> project = CreateTestProjectWithCustomField();
 2    
 3// Set formula
 4System::SharedPtr<ExtendedAttributeDefinition> attr = project->get_ExtendedAttributes()->idx_get(0);
 5attr->set_Alias(u"Task number fields");
 6attr->set_Formula(u"([Outline Level] + [Priority] + [% Complete])/2");
 7    
 8System::SharedPtr<Task> task = project->get_RootTask()->get_Children()->GetById(1);
 9    
10// Print extended attribute value before and after updating task percent complete
11System::Console::WriteLine(task->get_ExtendedAttributes()->idx_get(0)->get_NumericValue());
12task->Set<int32_t>(Tsk::PercentComplete(), 50);
13System::Console::WriteLine(task->get_ExtendedAttributes()->idx_get(0)->get_NumericValue());

Examples-CPP-WorkingWithFormulas-UsingTaskNumberFields-UsingTaskNumberFields.cpp hosted with ❤ by GitHub

Formula With Boolean Values

1System::SharedPtr<Project> project = CreateTestProjectWithCustomField();
2    
3// Set formula for extended attribute
4project->get_ExtendedAttributes()->idx_get(0)->set_Formula(u"[Critical]-[Marked]+4+[Active]-Not [Active]");
5    
6// Print value of extened attribute
7System::SharedPtr<Task> task = project->get_RootTask()->get_Children()->GetById(1);
8System::Console::WriteLine(System::String(u"Formula with boolean values: ") + task->get_ExtendedAttributes()->idx_get(0)->get_TextValue());

Examples-CPP-WorkingWithFormulas-FormulaWithBooleanValues-FormulaWithBooleanValues.cpp hosted with ❤ by GitHub

Formula With Project Fields

1System::SharedPtr<Project> project = CreateTestProjectWithCustomFieldWithoutResource();
2    
3// Set formula
4project->get_ExtendedAttributes()->idx_get(0)->set_Formula(u"\"Total tasks: \" & [Task Count] & \" Total resources: \" & [Resource Count]");
5    
6// Print if formula value is computed correctly
7System::SharedPtr<Task> task = project->get_RootTask()->get_Children()->GetById(1);
8System::Console::WriteLine(u"Check Total tasks: 1 Total resources: 0 - {0}", System::ObjectExt::Box<bool>(System::ObjectExt::Equals(task->get_ExtendedAttributes()->idx_get(0)->get_TextValue(), u"Total tasks: 1 Total resources: 0")));

Examples-CPP-WorkingWithFormulas-FormulaWithProjectFields-FormulaWithProjectFields.cpp hosted with ❤ by GitHub

式の紹介プロジェクトで式を操作します