clsImportQualificationPlan Class |
MS Access Table: MARIProjektImportQualificationPlans. See clsImportBase.eImportMode relative tables in MS-Access.
Use MPInterface.bImportQualificationPlan(clsImportQualificationPlan, clsImportBaseeImportMode) to import. MSAccess Import Table: MARIProjektImportWorkItemQualificationPlan.
Namespace: MARIInterface
The clsImportQualificationPlan type exposes the following members.
| Name | Description | |
|---|---|---|
| clsImportQualificationPlan | Initializes a new instance of the clsImportQualificationPlan class |
| Name | Description | |
|---|---|---|
| CheckList | CheckList (int) | |
| CycleType | Cycle Type: Defines the recuurent cycle for the QualificationPlans. Define as standard. Can be overwritten in the Plan | |
| CycleValue |
Cycle Value = Number of month. For standard CycleType this value is set automatically
| |
| EmployeeNumber |
Mandatory employee number.
| |
| EndDate | WorkItemEnd End of the plan | |
| Matchcode |
NVARCHAR (50) Name of the Qualificaion
| |
| QualificationID |
Link to the qualification (mandatory field). See clsImportQualification to create qualifications.
| |
| QualificationPlanDocNum |
INT (4) Visible ID based on Number Series. Will be created automatically. Leave this blank.
| |
| QualificationPlanDocSeries |
INT (4) ID of the number series
| |
| QualificationPlanID |
Internal ID of the qualification INT (4) Unique ID (via MPTAN). In access can be <100000 to align the positiosn
| |
| QualificationPlanStatus |
INT (4) Status See clsImportQualificationPlaneQualificationPlanStatus for details.
| |
| ScheduleType | Handling definition to create the plan dates for a service plan. See eScheduleType. When a ServicePlanTemplate (QualificationID) is linked and this value=None, the value is copied from the template. | |
| StartDate | StartDate start of the plan | |
| WorkDescription |
NTEXT (0) Memo What to do
| |
| WorkNotes |
NTEXT (0) Memo for notes on site
|
| Name | Description | |
|---|---|---|
| GetListUserDefinedFields |
Returns the user defined field definition for all dimension "WorkItem: Service Plan Template, Service Plan, Service Task, etc.". The fields have to be defined directly in MARIProject.
(Overrides clsImportBaseGetListUserDefinedFields(MPInterface).) |
private int CreateQualificationPlan(string sEmployeeNumber, string sMatchcode, int lQualificationId, DateTime dtStartDate) { clsImportQualificationPlan NewPlan = new clsImportQualificationPlan(); NewPlan.EmployeeNumber = sEmployeeNumber; //SELECT EmployeeNumber FROM MARIEmployeeMaster NewPlan.Matchcode = sMatchcode; NewPlan.StartDate = dtStartDate; NewPlan.EndDate = dtStartDate.AddYears(5); NewPlan.QualificationID = lQualificationId; // SELECT WorkItemID FROM MARIWorkItem where workitemtype=493 NewPlan.CycleType = clsImportWorkItemServicePlanTemplate.ePlanTemplateCycleType.None; //copy cycle from Qualification if (oMPInterface.bImportQualificationPlan(NewPlan, clsImportBase.eImportMode.ValidateAndImport)) { return NewPlan.QualificationPlanID; } else { string sErrordetails; sErrordetails = oMPInterface.oErrors.PrintErrors(true); Assert.False(true, sErrordetails); return 0; } }
private int CreateQualificationMaster(string sQualification, int GroupID) { string sErrordetails; clsImportQualification NewQualification = new clsImportQualification(); NewQualification.Matchcode = sQualification; NewQualification.CycleType = clsImportWorkItemServicePlanTemplate.ePlanTemplateCycleType.Yearly; NewQualification.GroupId = GroupID; // SELECT GroupID FROM MARIGroups WHERE GroupType=10600 if (oMPInterface.bImportQualification(NewQualification, clsImportBase.eImportMode.ValidateAndImport)) { return NewQualification.QualificationID; } else { sErrordetails = oMPInterface.oErrors.PrintErrors(true); Assert.False(true, sErrordetails); return 0; } }