{
  "User": "XS",
  "Key": "5F5466FB38A3B03CAA239BF0C9855440D99D47E36F1E346FACB0A17D6288AC74AC7FCDB77F7313B9",
  "ProtocolVersion": 1,
  "CardReaderType": 6,
  "CustomerConfigs": [
    {
      "Id": 1,
      "CustomerCode": "ZL",
      "CustomerName": "ZL",
      "ModuleCountry": "China",
      "ModuleManufacturer": "Jolywood",
      "CellCountry": "China",
      "CellManufacturer": "Jolywood",
      "IECDate": "September 2023",
      "IECLab": null,
      "IECProvider": "TUV SUD Certification and Testing(China) Co., Ltd",
      "BIS": "",
      "ISO": ""
    }
  ],
  "DataClient": {
    "ServerHost": "10.12.8.100:8082",
    "Workshop": "4",
    "LineNo": "2",
    "RfidNo": "1"
  },
  "DataSourceInfo": {
    "type": 1,
    "dbConfig": {
      "ip": "192.168.0.69",
      "port": "1433",
      "dbname": "mes_main",
      "username": "rfid",
      "password": "rfid",
      "sql": "select\n  replace(family_code, '***', convert(nvarchar(3), (\n    SELECT DISTINCT\n      a.power_grade\n    FROM\n      mes_level2_iface.dbo.iv IV\n      LEFT JOIN assembly_status SM ON SM.serial_nbr = IV.serial_nbr\n      LEFT JOIN config_products BOM ON BOM.product_code = SM.product_code\n      LEFT JOIN wo_mfg GD ON GD.workorder = SM.workorder\n      LEFT JOIN config_power a ON a.power_grade_group_id = gd.power_grade_group_id\n    WHERE\n      SM.serial_nbr= '{0}'\n      AND iv.pmax >= a.lower_power\n      AND iv.pmax < a.upper_power\n  ))) as ProductType,\n  iv.wks_visit_date as ModelDate,\n  iv.pmax, iv.isc, iv.vpm as vmp, iv.ipm as imp, iv.voc,\n  case when iv.ff < 1 then iv.ff * 100.0 else iv.ff end ff,\n  s.serial_nbr as ModuleID,\n  dateadd(month, -1, iv.wks_visit_date) as CellDate\nfrom assembly_status s\nleft join config_products p on s.product_code = p.product_code\nleft join mes_level2_iface.dbo.iv iv on s.serial_nbr = iv.serial_nbr\nwhere s.serial_nbr = '{0}'",
      "file": null
    }
  }
}