From SkobbaPedia

iControl is a Windows CE application for creating control reports of units with barcodes. It's running SQL Server Compact which syncronizes with with a local PC running ActiveSync.

• Platform: Windows CE
• SDK: Windows Mobile 5.0 Smartphone SDK
• Download: Image:IControlStudio 1.0.0.0.zip
• Download: Image:TestWindowsFormsApplication.zip
• Download: Image:IDeliver.zip

Contents 1 Requirements 2 URS 2.1 History 2.2 Rapporter 2.2.1 iManageMobile 2.2.2 iManageReporting 3 Implementation 3.1 Database 3.2 TODO

[edit] Requirements

• Microsoft .NET Framework 3.5 for PowerPC (CAB file) Image:NETCFv35.ppc.armv4.zip
• Microsoft .NET Framework 3.5 for CE (CAB file) Image:NETCFv35.wce.armv4.zip
• Microsoft .NET Framework 3.5 [1]
• Microsoft SQL Server Compact 3.5 and Microsoft Synchronization Services for ADO.Net v1.0 for Windows Desktop [2]
• Windows CE Unit (PHL-7x00 Media:PHL-7x00 User Manual_En-GB-A4.pdf )

[edit] URS

[edit] History

• Hendelsene lagres i databasen.

[edit] Rapporter

• Ikke avleste enheter
• Enheter som snart skal til kontroll

[edit] iManageMobile

Application running on mobile device using .NET Compact Framework 3.5.

[edit] iManageReporting

Application running on local machine using .NET Framework 3.5.

• Deviation Report over Units which are checked

[edit] Implementation

• Barcode implementation [3]

[edit] Database

Asks for the last control date for all units:

SELECT u.UnitID, (
SELECT top 1 cr.DateTime FROM ControlReports cr
WHERE cr.Unit = u.UnitID 
ORDER BY cr.DateTime ASC)
FROM Units u

Same as over but with User (need optimization):

SELECT u.UnitID, ut.Name, 
(SELECT top 1 cr.DateTime FROM ControlReports cr
WHERE cr.Unit = u.UnitID 
ORDER BY cr.DateTime ASC),
(SELECT top 1 cr.[User] FROM ControlReports cr
WHERE cr.Unit = u.UnitID 
ORDER BY cr.DateTime ASC)
FROM Units u, UnitTypes ut
WHERE u.UnitType = ut.UnitTypeID

Same as over but with datetime parameter:

SELECT u.UnitID, ut.Name, 
(SELECT top 1 cr.DateTime FROM ControlReports cr
WHERE cr.Unit = u.UnitID 
ORDER BY cr.DateTime ASC),
(SELECT top 1 cr2.[User] FROM ControlReports cr2
WHERE cr2.Unit = u.UnitID 
ORDER BY cr2.DateTime ASC)
FROM Units u, UnitTypes ut
WHERE u.UnitType = ut.UnitTypeID
AND
(
(SELECT top 1 cr2.DateTime FROM ControlReports cr2
WHERE cr2.Unit = u.UnitID 
ORDER BY cr2.DateTime ASC) > '2008.05.03 00:00:00'
OR
(SELECT top 1 cr2.DateTime FROM ControlReports cr2
WHERE cr2.Unit = u.UnitID 
ORDER BY cr2.DateTime ASC) IS NULL
)

[edit] TODO

• Remove ID text box for all controls
• Remove delete buttons for all controls
• Change to 4 character barcode length
• Make the barcode height higher