=== 1. DeviceWorkRecords 琛ㄧ储寮?绾︽潫 ===
[
  {
    "IndexName": "IX_DeviceWorkRecords_Device",
    "is_unique": false,
    "ColName": "DeviceId"
  },
  {
    "IndexName": "IX_DeviceWorkRecords_Device",
    "is_unique": false,
    "ColName": "WorkDate"
  },
  {
    "IndexName": "PK__DeviceWo__FBDF78E9350E7D6B",
    "is_unique": true,
    "ColName": "RecordId"
  }
]

=== 2. 閲嶅璁板綍妫€鏌?(DeviceId, WorkDate) ===
閲嶅缁勬暟: 0
鍓?0缁? []

=== 3. 鍗曟棩宸ユ椂瓒呰繃24灏忔椂鐨勮褰?===
瓒呰繃24灏忔椂鐨勫ぉ鏁? 538
鍓?0鏉? [
  {
    "DeviceId": "865167041633992",
    "WorkDate": "2026-08-02T00:00:00.000Z",
    "totalHours": 10253595.62,
    "recordCount": 1
  },
  {
    "DeviceId": "10543082857",
    "WorkDate": "2026-08-02T00:00:00.000Z",
    "totalHours": 8244818.77,
    "recordCount": 1
  },
  {
    "DeviceId": "4EIZ7IQ5OLS8",
    "WorkDate": "2026-08-02T00:00:00.000Z",
    "totalHours": 7426347.75,
    "recordCount": 1
  },
  {
    "DeviceId": "865167041633992",
    "WorkDate": "2026-08-01T00:00:00.000Z",
    "totalHours": 1437338.9,
    "recordCount": 1
  },
  {
    "DeviceId": "4EIZ7IQ5OLS8",
    "WorkDate": "2026-08-01T00:00:00.000Z",
    "totalHours": 658951.92,
    "recordCount": 1
  },
  {
    "DeviceId": "865167041631020",
    "WorkDate": "2026-08-02T00:00:00.000Z",
    "totalHours": 5515.15,
    "recordCount": 1
  },
  {
    "DeviceId": "865167041631822",
    "WorkDate": "2026-08-02T00:00:00.000Z",
    "totalHours": 5292.42,
    "recordCount": 1
  },
  {
    "DeviceId": "865167041631012",
    "WorkDate": "2026-08-02T00:00:00.000Z",
    "totalHours": 5193.68,
    "recordCount": 1
  },
  {
    "DeviceId": "865167041630733",
    "WorkDate": "2026-08-02T00:00:00.000Z",
    "totalHours": 5192.38,
    "recordCount": 1
  },
  {
    "DeviceId": "865167041631087",
    "WorkDate": "2026-08-02T00:00:00.000Z",
    "totalHours": 5135.18,
    "recordCount": 1
  },
  {
    "DeviceId": "6JFE2N04MXC7",
    "WorkDate": "2026-08-02T00:00:00.000Z",
    "totalHours": 5111.72,
    "recordCount": 1
  },
  {
    "DeviceId": "865167041630766",
    "WorkDate": "2026-08-02T00:00:00.000Z",
    "totalHours": 5100.18,
    "recordCount": 1
  },
  {
    "DeviceId": "865167041630626",
    "WorkDate": "2026-08-02T00:00:00.000Z",
    "totalHours": 5005.52,
    "recordCount": 1
  },
  {
    "DeviceId": "865167041630634",
    "WorkDate": "2026-08-02T00:00:00.000Z",
    "totalHours": 4954.28,
    "recordCount": 1
  },
  {
    "DeviceId": "865167041630345",
    "WorkDate": "2026-08-02T00:00:00.000Z",
    "totalHours": 4933.12,
    "recordCount": 1
  },
  {
    "DeviceId": "865167041631657",
    "WorkDate": "2026-08-02T00:00:00.000Z",
    "totalHours": 4922.33,
    "recordCount": 1
  },
  {
    "DeviceId": "865167041630857",
    "WorkDate": "2026-08-02T00:00:00.000Z",
    "totalHours": 4912.3,
    "recordCount": 1
  },
  {
    "DeviceId": "865167041631913",
    "WorkDate": "2026-08-02T00:00:00.000Z",
    "totalHours": 4905.82,
    "recordCount": 1
  },
  {
    "DeviceId": "15123081514",
    "WorkDate": "2026-08-02T00:00:00.000Z",
    "totalHours": 4904.13,
    "recordCount": 1
  },
  {
    "DeviceId": "6J189SK0JV47",
    "WorkDate": "2026-08-02T00:00:00.000Z",
    "totalHours": 4895.27,
    "recordCount": 1
  }
]

=== 4. 绀轰緥: DeviceId=865167041633992, WorkDate=Sun Aug 02 2026 08:00:00 GMT+0800 (涓浗鏍囧噯鏃堕棿) 鐨勬槑缁?===
[
  {
    "RecordId": 68568,
    "DeviceId": "865167041633992",
    "WorkDate": "2026-08-02T00:00:00.000Z",
    "WorkHours": 10253595.62,
    "LegacySourceId": null,
    "CreatedAt": "2026-08-02T08:03:05.550Z"
  }
]

=== 5. 妫€鏌?GpsDeviceNo 涓?DeviceWorkRecords.DeviceId 鐨勫尮閰嶆儏鍐?===
璁惧 K31 (GpsDeviceNo=15123081469, SmbGpsDeviceId=null): [{"DeviceId":"15123081469","cnt":57,"days":57}]
璁惧 K28 (GpsDeviceNo=15123081483, SmbGpsDeviceId=null): [{"DeviceId":"15123081483","cnt":62,"days":62}]
璁惧 K27 (GpsDeviceNo=15123081503, SmbGpsDeviceId=null): [{"DeviceId":"15123081503","cnt":56,"days":56}]
璁惧 K23 (GpsDeviceNo=15123081524, SmbGpsDeviceId=1985960065330614273): [{"DeviceId":"15123081524","cnt":66,"days":66}]
璁惧 K26 (GpsDeviceNo=15123081492, SmbGpsDeviceId=1985960088650391553): [{"DeviceId":"15123081492","cnt":53,"days":53}]
璁惧 K22 (GpsDeviceNo=15123081472, SmbGpsDeviceId=1985960049739833346): [{"DeviceId":"15123081472","cnt":38,"days":38}]
璁惧 K21 (GpsDeviceNo=15123081519, SmbGpsDeviceId=1987018347851845634): [{"DeviceId":"15123081519","cnt":76,"days":76}]
璁惧 K19 (GpsDeviceNo=15123081504, SmbGpsDeviceId=1985960055918596098): [{"DeviceId":"15123081504","cnt":48,"days":48}]
璁惧 K18 (GpsDeviceNo=15123081525, SmbGpsDeviceId=1985960060594692098): [{"DeviceId":"15123081525","cnt":62,"days":62}]
璁惧 鍏?0-22 (GpsDeviceNo=10543082996, SmbGpsDeviceId=90Y7LJZUTMOH): [{"DeviceId":"10543082996","cnt":542,"days":542}]