clsImportWorkItemServiceTask Class |
MS Access Table: MARIProjektImportWorkItemServiceTask. See clsImportBase.eImportMode relative tables in MS-Access.
Use MPInterface.bImportServiceTask(clsImportWorkItemServiceTask, clsImportBaseeImportMode) to import.
Use clsImportWorkItemServiceTaskPosition to import positions to the task.
Use clsImportWorkItemServiceTaskResource to import the teacher or equpiment to be used in the qualification task.
Use clsImportWorkItemServiceTaskResults to import results to a linked checklist.
Namespace: MARIInterface
The clsImportWorkItemServiceTask type exposes the following members.
| Name | Description | |
|---|---|---|
| clsImportWorkItemServiceTask | Initializes a new instance of the clsImportWorkItemServiceTask class |
| Name | Description | |
|---|---|---|
| AddrAddrType |
NVARCHAR (100) A0AddrType
| |
| AddrBlock |
NVARCHAR (100) A0Gebaeude
| |
| AddrBuilding |
NTEXT (0) A0GebaeudeStockwerk
| |
| AddrCardFName |
NVARCHAR (100) A0CardFName
| |
| AddrCity |
NVARCHAR (100) A0Ort
| |
| AddrContactPersonID |
INT (4) A0AnsprechpartnerID
| |
| AddrCountry |
NVARCHAR (3) A0Land
| |
| AddrCounty |
NVARCHAR (100) A0Bezirk
| |
| AddrMatchcode |
NVARCHAR (100) A0Matchcode
| |
| AddrName1 |
NVARCHAR (100) A0Name1
| |
| AddrName2 |
NVARCHAR (50) A0Name2
| |
| AddrName3 |
NVARCHAR (50) A0Zusatz
| |
| AddrSalutation |
NVARCHAR (50) A0Anrede
| |
| AddrState |
NVARCHAR (3) A0Bundesland
| |
| AddrStreet |
NVARCHAR (100) A0Strasse
| |
| AddrStreetNo |
NVARCHAR (100) A0Hausnummer
| |
| AddrZIP |
NVARCHAR (20) A0PLZ
| |
| CardCode |
Link to Customer
| |
| CheckList | CheckList (int) | |
| CollectionPositions |
(Optionally) Add a list of clsImportWorkItemServiceTaskPosition positions
| |
| CollectionResources |
(Optionally) Add a list of clsImportWorkItemServiceTaskResource linked resources
| |
| CompanyId |
SMALLINT (2) Link to company (SBO Database)
| |
| ContactPersonText |
NVARCHAR (100) ContactPersonText
| |
| ContractID |
INT (4) Link to Contract (Plan, Task)
| |
| ContractPositionID |
INT (4) 0=New positions as "at cost", Link to fixed price position
| |
| Group1 | Group1 The GroupType (GruppenArt) depends on the WorkItemType | |
| Group2 | Group2 The GroupType (GruppenArt) depends on the WorkItemType | |
| Group3 | Group3 The GroupType (GruppenArt) depends on the WorkItemType | |
| GroupID | Group0 The GroupType (GruppenArt) depends on the WorkItemType | |
| Matchcode |
Name of the Service Task
| |
| OSCLCallID |
Link to SBO Service Call
| |
| PhaseID |
INT (4) Link to Phase Plan, Task)
| |
| PMTicketID |
Link to PM Support Ticket
| |
| Priority |
INT (4) Internal Priority (not used at the moment)
| |
| Project |
NVARCHAR (20) Link to Project (Plan, Task)
| |
| Reference1 | Reference1 | |
| Reference2 | Reference2 | |
| Reference3 | Reference3 | |
| ServicePlanTemplate |
INT (4) Link to Template (For Plan)
| |
| ServiceTaskID |
ServiceTaskID INT (4) Unique ID (via MPTAN). In access can be <100000 to align the positiosn
| |
| ServiceTaskType |
Distringuishes between different types. See eServiceTaskType for details.
| |
| SignaturePic |
INT (4) Link to picture table for the signature
| |
| StandardWarehouse |
NVARCHAR (20) warehouse for new positions / vehicles warehouse
| |
| WorkDescription |
NTEXT (0) Memo What to do, You can use html
| |
| WorkItemDocNum |
Visible ID based on Number Series. Will be created automatically. Leave this blank.
| |
| WorkItemDocSeries |
INT (4) ID of the number series
| |
| WorkItemEnd |
Datetime (8) End of Task
| |
| WorkItemStart |
Datetime (8) Start of task
| |
| WorkItemStatus |
INT (4) Status (depending on type) 1:Request,2=Active,3=CloseReadyToInvoice,4=ClosedInvoiced. See eWorkItemStatus for details.
| |
| WorkNotes |
NTEXT (0) Memo for notes on site
|
| Name | Description | |
|---|---|---|
| bReadFromDB | (Overrides clsImportBasebReadFromDB(MPInterface, String).) | |
| 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).) |
View: MARIWorkItem, MARIWorkItem_ServiceTask, MARIWorkItem_InternalServiceTask or MARIWorkItem_ResultTask: :Table: MPWorkItem With WorkItemType=364 or 365 or 456. (See clsImportWorkItemServiceTaskeServiceTaskType)
public bool CreateServiceTaskAndResult(string sEquipmentCode, int lCheckList, int lServiceplanID) { string sErrordetails = ""; //Create Service Task clsImportWorkItemServiceTask oServiceTask = new clsImportWorkItemServiceTask(); oServiceTask.Matchcode = "DTW Result Task"; oServiceTask.ServiceTaskType = clsImportWorkItemServiceTask.eServiceTaskType.ResultTask; oServiceTask.WorkItemStart = new DateTime(2016, 12, 12, 07, 30, 00); oServiceTask.WorkItemEnd = new DateTime(2016, 12, 12, 15, 30, 00); oServiceTask.CompanyId = 1; oServiceTask.WorkItemStatus = clsImportWorkItemServiceTask.eWorkItemStatus.ServiceActive; oServiceTask.CardCode = "10000"; if (oMPInterface.bImportServiceTask(oServiceTask, clsImportBase.eImportMode.ValidateAndImport)) { //Create Service Task Position clsImportWorkItemServiceTaskPosition oLinkPos = new clsImportWorkItemServiceTaskPosition(); oLinkPos.ServiceTaskID = oServiceTask.ServiceTaskID; oLinkPos.PosType = clsImportWorkItemServiceTaskPosition.ePositionTyp.EquipmentServiceIsFor; oLinkPos.LineKeyValue = sEquipmentCode; oLinkPos.QualityProcess = lCheckList; //Store Reference to the scheduled date oLinkPos.ReferenceServicePlan = lServiceplanID; oLinkPos.QualityResult = 100000; // Result Status: SELECT QualityStatus FROM MARIQualityStatus WHERE ClassID=378 if (oMPInterface.bImportServiceTasksPositions(oLinkPos, clsImportBase.eImportMode.ValidateAndImport)) { //Create Result to the check list clsImportWorkItemServiceTaskResults oResult = new clsImportWorkItemServiceTaskResults(); oResult.QualityProcess = oLinkPos.QualityProcess; oResult.ServiceTaskPosID = oLinkPos.ServiceTaskPosID; oResult.ServiceTaskId = oLinkPos.ServiceTaskID; oResult.QualityProcessQuestion = 100009; //one selected question SELECT QualityProcessQuestion FROM MARIQualityProcessQuestions oResult.ResultValue = 88.881m; if (oMPInterface.bImportServiceTaskResults(oResult, clsImportBase.eImportMode.ValidateAndImport)) { return true; } else { sErrordetails = oMPInterface.oErrors.PrintErrors(true); LogFail(sErrordetails); return false; } } else { sErrordetails = oMPInterface.oErrors.PrintErrors(true); LogFail(sErrordetails); return false; } } else { return false; } }