ホーム エクスプローラ ヘルプ
登録 サインイン
hs
/
zhny_bg_bak
5
0
フォーク 0
ファイル 課題 0 プルリクエスト 0 Wiki
ツリー: 492875ca40
ブランチ タグ
zhny_bg_bak
/
ems-cloud
/
sql
/
ems_init_data.sql

ems_init_data.sql 141 KB
履歴 Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671 
  1. -- 服务区初始数据
    2. 

  2. INSERT INTO `adm_service_area` (`area_code`, `area_name`, `short_name`, `service_star`, `city`, `highway`, `direction`, `address`, `attr_org`, `mgr_org`, `open_date`, `land_area`, `floor_area`, `longitude`, `latitude`) VALUES ('321283124S3001', '常泰高速服务区(北区)', '北区', 4, '泰州', 'S30如常高速', '常州方向', '江苏省泰州市泰兴市虹桥镇常泰高速常州方向', null, null, '2025-01-01', '72.5', '6000', '120.050937', '32.071956');
    3. 

  3. INSERT INTO `adm_service_area` (`area_code`, `area_name`, `short_name`, `service_star`, `city`, `highway`, `direction`, `address`, `attr_org`, `mgr_org`, `open_date`, `land_area`, `floor_area`, `longitude`, `latitude`) VALUES ('321283124S3002', '常泰高速服务区(南区)', '南区', 4, '泰州', 'S30如常高速', '泰兴方向', '江苏省泰州市泰兴市虹桥镇常泰高速泰州方向', null, null, '2025-01-01', '72.5', '6000', '120.052389', '32.070408');
    4. 

  4. INSERT INTO `adm_service_area` (`area_code`, `area_name`, `short_name`, `service_star`, `city`, `highway`, `direction`, `address`, `attr_org`, `mgr_org`, `open_date`, `land_area`, `floor_area`, `longitude`, `latitude`) VALUES ('321283124S3003', '主路沿线光伏', '主路', 4, '泰州', 'S30如常高速', null, '江苏省泰州市泰兴市虹桥镇常泰高速泰州方向', null, null, '2025-01-01', '72.5', '6000', '120.052389', '32.070408');
    5. 

  5. 

  6. -- 建筑初始数据
    7. 

  7. INSERT INTO `adm_area_building` (`bldg_code`, `bldg_name`, `address`, `up_bldg_floor`, `down_bldg_floor`, `bldg_height`, `floor_area`, `bldg_usage`, `area_code`) VALUES ('321283124S300101', '综合楼', '北区中部', 2, 1, 13.7, 4700, '一层提供商业、餐饮、卫生间、开水服务，二层为办公区、会议区', '321283124S3001');
    8. 

  8. INSERT INTO `adm_area_building` (`bldg_code`, `bldg_name`, `address`, `up_bldg_floor`, `down_bldg_floor`, `bldg_height`, `floor_area`, `bldg_usage`, `area_code`) VALUES ('321283124S300102', '配电泵房', '北区西北角', 1, 0, null, 300, '配电设施，水泵设施工作区', '321283124S3001');
    9. 

  9. INSERT INTO `adm_area_building` (`bldg_code`, `bldg_name`, `address`, `up_bldg_floor`, `down_bldg_floor`, `bldg_height`, `floor_area`, `bldg_usage`, `area_code`) VALUES ('321283124S300103', '维修间&货车之家', '北区东侧', 2, 0, null, 300, '提供车辆维修服务', '321283124S3001');
    10. 

  10. INSERT INTO `adm_area_building` (`bldg_code`, `bldg_name`, `address`, `up_bldg_floor`, `down_bldg_floor`, `bldg_height`, `floor_area`, `bldg_usage`, `area_code`) VALUES ('321283124S300104', '加油站', '北区西南角', 1, 0, null, 200, '提供加油服务', '321283124S3001');
    11. 

  11. INSERT INTO `adm_area_building` (`bldg_code`, `bldg_name`, `address`, `up_bldg_floor`, `down_bldg_floor`, `bldg_height`, `floor_area`, `bldg_usage`, `area_code`) VALUES ('321283124S300105', '警务站', '北区东北角', 1, 0, null, 50000, '警务办公场地', '321283124S3001');
    12. 

  12. INSERT INTO `adm_area_building` (`bldg_code`, `bldg_name`, `address`, `up_bldg_floor`, `down_bldg_floor`, `bldg_height`, `floor_area`, `bldg_usage`, `area_code`) VALUES ('321283124S300106', '停车场', '北区广场', 1, 0, null, 50000, '车位', '321283124S3001');
    13. 

  13. 

  14. INSERT INTO `adm_area_building` (`bldg_code`, `bldg_name`, `address`, `up_bldg_floor`, `down_bldg_floor`, `bldg_height`, `floor_area`, `bldg_usage`, `area_code`) VALUES ('321283124S300201', '综合楼', '南区中部', 2, 1, 14.2, 4788.2, '一层提供商业、餐饮、卫生间、开水服务，二层为员工餐厅、展厅', '321283124S3002');
    15. 

  15. INSERT INTO `adm_area_building` (`bldg_code`, `bldg_name`, `address`, `up_bldg_floor`, `down_bldg_floor`, `bldg_height`, `floor_area`, `bldg_usage`, `area_code`) VALUES ('321283124S300202', '配电泵房', '南区东南角', 1, 0, null, 300, '配电设施，水泵设施工作区', '321283124S3002');
    16. 

  16. INSERT INTO `adm_area_building` (`bldg_code`, `bldg_name`, `address`, `up_bldg_floor`, `down_bldg_floor`, `bldg_height`, `floor_area`, `bldg_usage`, `area_code`) VALUES ('321283124S300203', '维修间&货车之家', '南区西侧', 2, 0, null, 300, '提供车辆维修服务', '321283124S3002');
    17. 

  17. INSERT INTO `adm_area_building` (`bldg_code`, `bldg_name`, `address`, `up_bldg_floor`, `down_bldg_floor`, `bldg_height`, `floor_area`, `bldg_usage`, `area_code`) VALUES ('321283124S300204', '加油站', '南区东北角', 1, 0, null, 200, '提供加油服务', '321283124S3002');
    18. 

  18. INSERT INTO `adm_area_building` (`bldg_code`, `bldg_name`, `address`, `up_bldg_floor`, `down_bldg_floor`, `bldg_height`, `floor_area`, `bldg_usage`, `area_code`) VALUES ('321283124S300205', '宿舍楼', '南区西南角', 2, 0, null, 920, '提供员工住宿服务', '321283124S3002');
    19. 

  19. INSERT INTO `adm_area_building` (`bldg_code`, `bldg_name`, `address`, `up_bldg_floor`, `down_bldg_floor`, `bldg_height`, `floor_area`, `bldg_usage`, `area_code`) VALUES ('321283124S300206', '停车场', '南区广场', 1, 0, null, 50000, '车位', '321283124S3002');
    20. 

  20. 

  21. 

  22. -- 建筑初始数据
    23. 

  23. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300101', 'B-101', '开水泡面间', 1, '101', 100, '使用中');
    24. 

  24. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300101', 'B-102', '超市', 1, '102', 200, '使用中');
    25. 

  25. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300101', 'B-103', '中式糕点', 1, '103', 150, '使用中');
    26. 

  26. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300101', 'B-104', '特色产品市集', 1, '104', 200, '使用中');
    27. 

  27. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300101', 'B-105', '奶茶&咖啡', 1, '105', 100, '使用中');
    28. 

  28. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300101', 'B-106', '中式套餐', 1, '106', 200, '使用中');
    29. 

  29. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300101', 'B-107', '特色小吃', 1, '107', 100, '使用中');
    30. 

  30. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300101', 'B-108', '串串&卤味', 1, '108', 100, '使用中');
    31. 

  31. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300101', 'B-109', '糖葫芦&水果', 1, '109', 100, '使用中');
    32. 

  32. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300101', 'B-110', '美食广场', 1, '110', 300, '使用中');
    33. 

  33. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300101', 'B-111', '男卫', 1, '111', 200, '使用中');
    34. 

  34. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300101', 'B-112', '男盥洗室', 1, '112', 150, '使用中');
    35. 

  35. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300101', 'B-113', '女卫', 1, '113', 200, '使用中');
    36. 

  36. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300101', 'B-114', '女盥洗室', 1, '114', 150, '使用中');
    37. 

  37. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300101', 'B-115', '工具间1', 1, '115', 50, '使用中');
    38. 

  38. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300101', 'B-116', '工具间2', 1, '116', 50, '使用中');
    39. 

  39. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300101', 'B-117', '工具间3', 1, '117', 50, '使用中');
    40. 

  40. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300101', 'B-118', '工具间4', 1, '118', 50, '使用中');
    41. 

  41. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300101', 'B-119', '货车服务空间', 1, '119', 50, '使用中');
    42. 

  42. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300102', 'B-120', '配电间', 1, '120', 50, '使用中');
    43. 

  43. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300102', 'B-121', '水泵间', 1, '121', 50, '使用中');
    44. 

  44. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300102', 'B-122', '控制间', 1, '122', 50, '使用中');
    45. 

  45. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300103', 'B-123', '维修车间', 1, '123', 50, '使用中');
    46. 

  46. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300103', 'B-124', '办公室', 1, '124', 50, '使用中');
    47. 

  47. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300104', 'B-125', '加油站区', 1, '125', 100, '使用中');
    48. 

  48. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300104', 'B-126', '油罐区', 1, '126', 100, '使用中');
    49. 

  49. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300104', 'B-127', '营业区', 1, '127', 100, '使用中');
    50. 

  50. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300104', 'B-128', '辅助区', 1, '128', 100, '使用中');
    51. 

  51. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300105', 'B-129', '接待区', 1, '129', 50, '使用中');
    52. 

  52. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300105', 'B-130', '指挥室', 1, '130', 50, '使用中');
    53. 

  53. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300105', 'B-131', '调解室', 1, '131', 50, '使用中');
    54. 

  54. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300105', 'B-132', '便民服务区', 1, '132', 50, '使用中');
    55. 

  55. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300106', '321283124S3001_CW-XK', '小客停车位', 1, 'CW-XK', 100, '使用中');
    56. 

  56. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300106', '321283124S3001_CW-CD', '充电车位', 1, 'CW-CD', 100, '使用中');
    57. 

  57. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300106', '321283124S3001_CW-WZA', '无障碍车位', 1, 'CW-WZA', 100, '使用中');
    58. 

  58. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300106', '321283124S3001_CW-DKC', '大客车停车位', 1, 'CW-DKC', 100, '使用中');
    59. 

  59. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300106', '321283124S3001_CW-HC', '货车车位', 1, 'CW-HC', 100, '使用中');
    60. 

  60. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300106', '321283124S3001_CW-WXP', '危险品车位', 1, 'CW-WXP', 100, '使用中');
    61. 

  61. 

  62. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300201', 'N-101', '开水泡面间', 1, '101', 100, '使用中');
    63. 

  63. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300201', 'N-102', '超市', 1, '102', 200, '使用中');
    64. 

  64. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300201', 'N-103', '中式糕点', 1, '103', 150, '使用中');
    65. 

  65. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300201', 'N-104', '特色产品市集', 1, '104', 200, '使用中');
    66. 

  66. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300201', 'N-105', '奶茶&咖啡', 1, '105', 100, '使用中');
    67. 

  67. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300201', 'N-106', '中式套餐', 1, '106', 200, '使用中');
    68. 

  68. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300201', 'N-107', '特色小吃', 1, '107', 100, '使用中');
    69. 

  69. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300201', 'N-108', '串串&卤味', 1, '108', 100, '使用中');
    70. 

  70. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300201', 'N-109', '糖葫芦&水果', 1, '109', 100, '使用中');
    71. 

  71. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300201', 'N-110', '美食广场', 1, '110', 300, '使用中');
    72. 

  72. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300201', 'N-111', '男卫', 1, '111', 200, '使用中');
    73. 

  73. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300201', 'N-112', '男盥洗室', 1, '112', 150, '使用中');
    74. 

  74. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300201', 'N-113', '女卫', 1, '113', 200, '使用中');
    75. 

  75. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300201', 'N-114', '女盥洗室', 1, '114', 150, '使用中');
    76. 

  76. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300201', 'N-115', '工具间1', 1, '115', 50, '使用中');
    77. 

  77. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300201', 'N-116', '工具间2', 1, '116', 50, '使用中');
    78. 

  78. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300201', 'N-117', '工具间3', 1, '117', 50, '使用中');
    79. 

  79. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300201', 'N-118', '工具间4', 1, '118', 50, '使用中');
    80. 

  80. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300201', 'N-119', '货车服务空间', 1, '119', 50, '使用中');
    81. 

  81. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300202', 'N-120', '消防设备', 1, '120', 50, '使用中');
    82. 

  82. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300202', 'N-121', '照明设备', 1, '121', 50, '使用中');
    83. 

  83. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300202', 'N-122', '信号设备', 1, '122', 50, '使用中');
    84. 

  84. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300203', 'N-123', '备件管理', 1, '123', 50, '使用中');
    85. 

  85. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300203', 'N-124', '集装箱', 1, '124', 50, '使用中');
    86. 

  86. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300204', 'N-125', '加油站区', 1, '125', 100, '使用中');
    87. 

  87. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300204', 'N-126', '油罐区', 1, '126', 100, '使用中');
    88. 

  88. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300204', 'N-127', '营业区', 1, '127', 100, '使用中');
    89. 

  89. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300204', 'N-128', '辅助区', 1, '128', 100, '使用中');
    90. 

  90. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300205', 'N-129', '接待区', 1, '129', 50, '使用中');
    91. 

  91. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300205', 'N-130', '指挥中心', 1, '130', 50, '使用中');
    92. 

  92. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300205', 'N-131', '调解室', 1, '131', 50, '使用中');
    93. 

  93. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300205', 'N-132', '便民服务区', 1, '132', 50, '使用中');
    94. 

  94. 

  95. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300206', '321283124S3002_CW-XK', '小客停车位', 1, 'CW-XK', 100, '使用中');
    96. 

  96. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300206', '321283124S3002_CW-CD', '充电车位', 1, 'CW-XK', 100, '使用中');
    97. 

  97. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300206', '321283124S3002_CW-WZA', '无障碍车位', 1, 'CW-XK', 100, '使用中');
    98. 

  98. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300206', '321283124S3002_CW-DKC', '大客车停车位', 1, 'CW-XK', 100, '使用中');
    99. 

  99. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300206', '321283124S3002_CW-HC', '货车车位', 1, 'CW-XK', 100, '使用中');
    100. 

  100. INSERT INTO adm_area_building_zoning (`bldg_code`, `zoning_code`, `zoning_name`, `floor`, `room_no`, `bldg_ld_area`, `usage_detail`) VALUES ('321283124S300206', '321283124S3002_CW-WXP','危险品车位', 1, 'CW-XK', 100, '使用中');
    101. 

  101. 

  102. -- 能源设施初始数据
    103. 

  103. INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_type`, `facs_subtype`, `enable`, `ref_area`) VALUES ('W201', '北区-供电网', 'W', 'W2', 1, '321283124S3001');
    104. 

  104. INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_type`, `facs_subtype`, `enable`, `ref_area`) VALUES ('W202', '南区-供电网', 'W', 'W2', 1, '321283124S3002');
    105. 

  105. INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_type`, `facs_subtype`, `enable`, `ref_area`) VALUES ('E501', '北区-光伏', 'E', 'E5', 1, '321283124S3001');
    106. 

  106. INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_type`, `facs_subtype`, `enable`, `ref_area`) VALUES ('E502', '南区-光伏', 'E', 'E5', 1, '321283124S3002');
    107. 

  107. INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_type`, `facs_subtype`, `enable`, `ref_area`) VALUES ('C101', '北区-储能', 'C', 'C1', 1, '321283124S3001');
    108. 

  108. INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_type`, `facs_subtype`, `enable`, `ref_area`) VALUES ('C102', '南区-储能', 'C', 'C1', 1, '321283124S3002');
    109. 

  109. INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_type`, `facs_subtype`, `enable`, `ref_area`) VALUES ('Z101', '北区-室内照明', 'Z', 'Z001', 1, '321283124S3001');
    110. 

  110. INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_type`, `facs_subtype`, `enable`, `ref_area`) VALUES ('Z102', '北区-室外照明', 'Z', 'Z002', 1, '321283124S3001');
    111. 

  111. INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_type`, `facs_subtype`, `enable`, `ref_area`) VALUES ('Z110', '北区-公共设施', 'Z', 'Z010', 1, '321283124S3001');
    112. 

  112. INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_type`, `facs_subtype`, `enable`, `ref_area`) VALUES ('Z120', '北区-空调设施', 'Z', 'Z020', 1, '321283124S3001');
    113. 

  113. INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_type`, `facs_subtype`, `enable`, `ref_area`) VALUES ('Z201', '南区-室内照明', 'Z', 'Z001', 1, '321283124S3002');
    114. 

  114. INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_type`, `facs_subtype`, `enable`, `ref_area`) VALUES ('Z202', '南区-室外照明', 'Z', 'Z002', 1, '321283124S3002');
    115. 

  115. INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_type`, `facs_subtype`, `enable`, `ref_area`) VALUES ('Z210', '南区-公共设施', 'Z', 'Z010', 1, '321283124S3002');
    116. 

  116. INSERT INTO `adm_ems_facs` (`facs_code`, `facs_name`, `facs_type`, `facs_subtype`, `enable`, `ref_area`) VALUES ('Z220', '南区-空调设施', 'Z', 'Z020', 1, '321283124S3002');
    117. 

  117. 

  118. 

  119. -- 设施属性DEMO数据
    120. 

  120. INSERT INTO `adm_ems_facs_attr` (`facs_code`, `attr_name`, `attr_desc`, `attr_value`, `attr_unit`) VALUES ('W201', 'input_load', '进线负荷', '293.55', 'kw/h');
    121. 

  121. INSERT INTO `adm_ems_facs_attr` (`facs_code`, `attr_name`, `attr_desc`, `attr_value`, `attr_unit`) VALUES ('E501', 'installed_capacity', '装机容量', '2000', 'MW');
    122. 

  122. 

  123. -- 设施属性DEMO数据
    124. 

  124. INSERT INTO `adm_ems_facs_ability` (`facs_code`, `ability_name`, `ability_desc`, `ability_param`) VALUES ('Z020', '开启', '开启空调', '{\"enable\":1}');
    125. 

  125. INSERT INTO `adm_ems_facs_ability` (`facs_code`, `ability_name`, `ability_desc`, `ability_param`) VALUES ('Z020', '关闭', '关闭空调', '{\"enable\":0}');
    126. 

  126. 

  127. -- 设施事件DEMO数据
    128. 

  128. INSERT INTO `adm_ems_facs_event` (`facs_code`, `event_name`, `event_type`, `event_desc`, `event_code`, `ext_event_code`) VALUES ('Z101', '电压告警', '2', '电压过低告警', 'LOW_V',  '10001001');
    129. 

  129. 

  130. 

  131. -- 能源设施能流关系DEMO数据
    132. 

  132. INSERT INTO `adm_ems_facs_flow_rel` (`code`, `export_facs_code`, `input_facs_code`, `ems_cls`, `state`, `action_type`) VALUES ('W201_Z101', 'W201', 'Z101', '45', 1, '4501');
    133. 

  133. INSERT INTO `adm_ems_facs_flow_rel` (`code`, `export_facs_code`, `input_facs_code`, `ems_cls`, `state`, `action_type`) VALUES ('E501_W201', 'E501', 'W201', '45', 1, '4502');
    134. 

  134. INSERT INTO `adm_ems_facs_flow_rel` (`code`, `export_facs_code`, `input_facs_code`, `ems_cls`, `state`, `action_type`) VALUES ('E501_Z101', 'E501', 'Z101', '45', 1, '4505');
    135. 

  135. 

  136. -- 能源设备
    137. 

  137. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R102-002', '超市照明灯',       '1', '2', 'Zoning', 'B-102', '321283124S3001,321283124S300101,B-102', 'Z110', 'SYS_BA');
    138. 

  138. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R102-003', '超市监控和防盗设备', '1', '2', 'Zoning', 'B-102', '321283124S3001,321283124S300101,B-102', 'Z110', 'SYS_BA');
    139. 

  139. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R103-001', '空调',             '2', '1', 'Zoning', 'B-103', '321283124S3001,321283124S300101,B-103', 'Z120', 'SYS_BA');
    140. 

  140. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R103-002', '烤箱', '2', '2', 'Zoning', 'B-103', '321283124S3001,321283124S300101,B-103', 'Z110', 'SYS_BA');
    141. 

  141. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R103-003', '搅拌机', '2','2' , 'Zoning', 'B-103', '321283124S3001,321283124S300101,B-103', 'Z110', 'SYS_BA');
    142. 

  142. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R104-001', 'LED节能灯', '2', '1', 'Zoning', 'B-104', '321283124S3001,321283124S300101,B-104', 'Z110', 'SYS_BA');
    143. 

  143. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R104-002', '智能电表', '2', '1', 'Zoning', 'B-104', '321283124S3001,321283124S300101,B-104', 'Z110', 'SYS_BA');
    144. 

  144. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R104-003', '智慧路灯', '2', '1', 'Zoning', 'B-104', '321283124S3001,321283124S300101,B-104', 'Z102', 'SYS_BA');
    145. 

  145. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R105-001', '电源管理器', '2', '1', 'Zoning', 'B-105', '321283124S3001,321283124S300101,B-105', 'W201', 'SYS_BA');
    146. 

  146. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R105-002', '充电站', '1', '1', 'Zoning', 'B-105', '321283124S3001,321283124S300101,B-105', 'Z110', 'SYS_BA');
    147. 

  147. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R105-003', '调光系统', '1', '1', 'Zoning', 'B-105', '321283124S3001,321283124S300101,B-105', 'Z101', 'SYS_BA');
    148. 

  148. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R106-001', '吊灯', '2', '1', 'Zoning', 'B-106', '321283124S3001,321283124S300101,B-106', 'Z101', 'SYS_BA');
    149. 

  149. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R107-001', '橱窗照明','2', '1', 'Zoning', 'B-107', '321283124S3001,321283124S300101,B-107', 'Z101', 'SYS_BA');
    150. 

  150. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R107-002', 'UPS（不间断电源）系统', '1', '1', 'Zoning', 'B-107', '321283124S3001,321283124S300101,B-107', 'Z101', 'SYS_BA');
    151. 

  151. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R108-001', '吊灯', '2', '1', 'Zoning', 'B-108', '321283124S3001,321283124S300101,B-108', 'Z101', 'SYS_BA');
    152. 

  152. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R109-001', '指示灯', '2', '1', 'Zoning', 'B-109', '321283124S3001,321283124S300101,B-109', 'Z101', 'SYS_BA');
    153. 

  153. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R110-001', '应急照明', '2', '1', 'Zoning', 'B-110', '321283124S3001,321283124S300101,B-110', 'Z101', 'SYS_BA');
    154. 

  154. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R112-001', '自动感应灯', '2', '2', 'Zoning', 'B-112', '321283124S3001,321283124S300101,B-112', 'Z101', 'SYS_BA');
    155. 

  155. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R112-002', '电路保护装置', '1', '2', 'Zoning', 'B-112', '321283124S3001,321283124S300101,B-112', 'Z110', 'SYS_BA');
    156. 

  156. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R114-001', '自动感应灯', '2', '2', 'Zoning', 'B-114', '321283124S3001,321283124S300101,B-114', 'Z101', 'SYS_BA');
    157. 

  157. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R114-002', '电路保护装置', '1', '2', 'Zoning', 'B-114', '321283124S3001,321283124S300101,B-114', 'Z110', 'SYS_BA');
    158. 

  158. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R115-001', '工作灯', '1', '2', 'Zoning', 'B-115', '321283124S3001,321283124S300101,B-115', 'Z101', 'SYS_BA');
    159. 

  159. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R16-001',  '防水灯具', '1', '2', 'Zoning', 'B-116', '321283124S3001,321283124S300101,B-116', 'Z102', 'SYS_BA');
    160. 

  160. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R117-001', '防水灯具', '1', '2', 'Zoning', 'B-117', '321283124S3001,321283124S300101,B-117', 'Z102', 'SYS_BA');
    161. 

  161. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R118-001', '灯具', '1', '2', 'Zoning', 'B-118', '321283124S3001,321283124S300101,B-118', 'Z102', 'SYS_BA');
    162. 

  162. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R119-001', '防水灯具', '1', '2', 'Zoning', 'B-119', '321283124S3001,321283124S300101,B-119', 'Z102', 'SYS_BA');
    163. 

  163. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R120-001', '控制面板', '1', '1', 'Zoning', 'B-120', '321283124S3001,321283124S300102,B-120', 'W201', 'SYS_BA');
    164. 

  164. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R121-001', '配电柜', '2', '1', 'Zoning', 'B-121', '321283124S3001,321283124S300102,B-121', 'W201', 'SYS_BA');
    165. 

  165. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R122-001', '断路器', '1', '1', 'Zoning', 'B-122', '321283124S3001,321283124S300102,B-122', 'W201', 'SYS_BA');
    166. 

  166. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R123-001', '电源插座', '1', '1', 'Zoning', 'B-123', '321283124S3001,321283124S300103,B-123', 'Z110', 'SYS_BA');
    167. 

  167. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R124-001', '加热器', '1', '1', 'Zoning', 'B-124', '321283124S3001,321283124S300103,B-124', 'Z102', 'SYS_BA');
    168. 

  168. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R125-001', '空调', '1', '1', 'Zoning', 'B-125', '321283124S3001,321283124S300104,B-125', 'Z110', 'SYS_BA');
    169. 

  169. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R126-001', '空调', '1', '1', 'Zoning', 'B-126', '321283124S3001,321283124S300104,B-126', 'Z110', 'SYS_BA');
    170. 

  170. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R127-001', '空调', '1', '1', 'Zoning', 'B-127', '321283124S3001,321283124S300104,B-127', 'Z110', 'SYS_BA');
    171. 

  171. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R128-001', '空调', '1', '1', 'Zoning', 'B-128', '321283124S3001,321283124S300104,B-128', 'Z110', 'SYS_BA');
    172. 

  172. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R129-001', '空调', '1', '1', 'Zoning', 'B-129', '321283124S3001,321283124S300105,B-129', 'Z110', 'SYS_BA');
    173. 

  173. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R130-001', '空调', '1', '1', 'Zoning', 'B-130', '321283124S3001,321283124S300105,B-130', 'Z110', 'SYS_BA');
    174. 

  174. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R131-001', '空调', '1', '1', 'Zoning', 'B-131', '321283124S3001,321283124S300105,B-131', 'Z110', 'SYS_BA');
    175. 

  175. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R132-001', '空调', '1', '1', 'Zoning', 'B-132', '321283124S3001,321283124S300105,B-132', 'Z110', 'SYS_BA');
    176. 

  176. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Car-001', '照明灯', '1', '1', 'Zoning', '321283124S3001_CW-XK', '321283124S3001,321283124S300106,321283124S3001_CW-XK', 'Z102','SYS_BA');
    177. 

  177. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Car-002', '智能监控系统', '1', NULL, 'Zoning', '321283124S3001_CW-CD', '321283124S3001,321283124S300106,321283124S3001_CW-CD', 'Z110','SYS_BA');
    178. 

  178. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Car-003', '照明灯', '1', NULL, 'Zoning', '321283124S3001_CW-WZA', '321283124S3001,321283124S300106,321283124S3001_CW-WZA', 'Z102','SYS_BA');
    179. 

  179. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Car-004', '照明灯', '1', NULL, 'Zoning', '321283124S3001_CW-DKC', '321283124S3001,321283124S300106,321283124S3001_CW-DKC', 'Z102','SYS_BA');
    180. 

  180. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Car-005', '照明灯', '1', NULL, 'Zoning', '321283124S3001_CW-HC', '321283124S3001,321283124S300106,321283124S3001_CW-HC', 'Z102','SYS_BA');
    181. 

  181. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Car-006', '停车场照明灯', '1', NULL, 'Zoning', '321283124S3001_CW-WXP', '321283124S3001,321283124S300106,321283124S3001_CW-WXP', 'Z102','SYS_BA');
    182. 

  182. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Car-007', '智能监控系统', '1', NULL, 'Zoning', '321283124S3001_CW-WXP', '321283124S3001,321283124S300106,321283124S3001_CW-WXP', 'Z110','SYS_BA');
    183. 

  183. 

  184. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R101-101', '开水炉', '1', '2', 'Zoning', 'N-101', '321283124S3002,321283124S300201,N-101', 'Z110', 'SYS_BA');
    185. 

  185. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R102-101', '超市区空调', '2', '1', 'Zoning', 'N-102', '321283124S3002,321283124S300201,N-102', 'Z120', 'SYS_BA');
    186. 

  186. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R102-102', '超市照明灯', '1', '2', 'Zoning', 'N-102', '321283124S3002,321283124S300201,N-102', 'Z110', 'SYS_BA');
    187. 

  187. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R102-103', '超市监控和防盗设备', '1', '2', 'Zoning', 'N-102', '321283124S3002,321283124S300201,N-102', 'Z110', 'SYS_BA');
    188. 

  188. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R103-101', '空调', '2', NULL, 'Zoning', 'N-103', '321283124S3002,321283124S300201,N-103', 'Z120', 'SYS_BA');
    189. 

  189. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R103-102', '烤箱', '2', '2', 'Zoning', 'N-103', '321283124S3002,321283124S300201,N-103', 'Z110', 'SYS_BA');
    190. 

  190. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R103-103', '搅拌机', '2','2' , 'Zoning', 'N-103', '321283124S3002,321283124S300201,N-103', 'Z110', 'SYS_BA');
    191. 

  191. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R104-101', 'LED节能灯', '2', '1', 'Zoning', 'N-104', '321283124S3002,321283124S300201,N-104', 'Z110', 'SYS_BA');
    192. 

  192. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R104-102', '智能电表', '2', '1', 'Zoning', 'N-104', '321283124S3002,321283124S300201,N-104', 'Z110', 'SYS_BA');
    193. 

  193. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R104-103', '智慧路灯', '2', '1', 'Zoning', 'N-104', '321283124S3002,321283124S300201,N-104', 'Z102', 'SYS_BA');
    194. 

  194. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R105-101', '电源管理器', '2', '1', 'Zoning', 'N-105', '321283124S3002,321283124S300201,N-105', 'W201', 'SYS_BA');
    195. 

  195. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R105-102', '充电站', '1', '1', 'Zoning', 'N-105', '321283124S3002,321283124S300201,N-105', 'Z110', 'SYS_BA');
    196. 

  196. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R105-103', '调光系统', '1', '1', 'Zoning', 'N-105', '321283124S3002,321283124S300201,N-105', 'Z101', 'SYS_BA');
    197. 

  197. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R106-101', '吊灯', '2', '1', 'Zoning', 'N-106', '321283124S3002,321283124S300201,N-106', 'Z101', 'SYS_BA');
    198. 

  198. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R107-101', '橱窗照明','2', '1', 'Zoning', 'N-107', '321283124S3002,321283124S300201,N-107', 'Z101', 'SYS_BA');
    199. 

  199. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R107-102', 'UPS（不间断电源）系统', '1', '1', 'Zoning', 'N-107', '321283124S3002,321283124S300201,N-107', 'Z101', 'SYS_BA');
    200. 

  200. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R108-101', '吊灯', '2', '1', 'Zoning', 'N-108', '321283124S3002,321283124S300201,N-108', 'Z101', 'SYS_BA');
    201. 

  201. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R109-101', '指示灯', '2', '1', 'Zoning', 'N-109', '321283124S3002,321283124S300201,N-109', 'Z101', 'SYS_BA');
    202. 

  202. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R110-101', '应急照明', '2', '1', 'Zoning', 'N-110', '321283124S3002,321283124S300201,N-110', 'Z101', 'SYS_BA');
    203. 

  203. 

  204. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R112-101', '自动感应灯', '2', '2', 'Zoning', 'N-112', '321283124S3002,321283124S300201,N-112', 'Z101', 'SYS_BA');
    205. 

  205. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R112-102', '电路保护装置', '1', '2', 'Zoning', 'N-112', '321283124S3002,321283124S300201,N-112', 'Z110', 'SYS_BA');
    206. 

  206. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R114-101', '自动感应灯', '2', '2', 'Zoning', 'N-114', '321283124S3002,321283124S300201,N-114', 'Z101', 'SYS_BA');
    207. 

  207. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R114-102', '电路保护装置', '1', '2', 'Zoning', 'N-114', '321283124S3002,321283124S300201,N-114', 'Z110', 'SYS_BA');
    208. 

  208. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R115-101', '工作灯', '1', '2', 'Zoning', 'N-115', '321283124S3002,321283124S300201,N-115', 'Z101', 'SYS_BA');
    209. 

  209. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R16-101', '防水灯具', '1', '2', 'Zoning', 'N-116', '321283124S3002,321283124S300201,N-115', 'Z102', 'SYS_BA');
    210. 

  210. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R117-101', '防水灯具', '1', '2', 'Zoning', 'N-117', '321283124S3002,321283124S300201,N-117', 'Z102', 'SYS_BA');
    211. 

  211. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R118-101', '防水灯具', '1', '1', 'Zoning', 'N-118', '321283124S3002,321283124S300201,N-118', 'Z102', 'SYS_BA');
    212. 

  212. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R119-101', '防水灯具', '1', '1', 'Zoning', 'N-119', '321283124S3002,321283124S300201,N-119', 'Z102', 'SYS_BA');
    213. 

  213. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R120-101', '控制面板', '1', '1', 'Zoning', 'N-120', '321283124S3002,321283124S300202,N-120', 'W201', 'SYS_BA');
    214. 

  214. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R121-101', '配电柜', '2', '1', 'Zoning', 'N-121', '321283124S3002,321283124S300202,N-121', 'W201', 'SYS_BA');
    215. 

  215. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R122-101', '断路器', '1', '1', 'Zoning', 'N-122', '321283124S3002,321283124S300202,N-122', 'W201', 'SYS_BA');
    216. 

  216. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R123-101', '电源插座', '1', '1', 'Zoning', 'N-123', '321283124S3002,321283124S300203,N-123', 'Z110', 'SYS_BA');
    217. 

  217. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R124-101', '加热器', '1', '1', 'Zoning', 'N-124', '321283124S3002,321283124S300203,N-124', 'Z102', 'SYS_BA');
    218. 

  218. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R125-101', '空调', '1', '1', 'Zoning', 'N-125', '321283124S3002,321283124S300204,N-125', 'Z110', 'SYS_BA');
    219. 

  219. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R126-101', '空调', '1', '1', 'Zoning', 'N-126', '321283124S3002,321283124S300204,N-126', 'Z110', 'SYS_BA');
    220. 

  220. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R127-101', '空调', '1', '1', 'Zoning', 'N-127', '321283124S3002,321283124S300204,N-127', 'Z110', 'SYS_BA');
    221. 

  221. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R128-101', '空调', '1', '1', 'Zoning', 'N-128', '321283124S3002,321283124S300204,N-128', 'Z110', 'SYS_BA');
    222. 

  222. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R129-101', '空调', '1', '1', 'Zoning', 'N-129', '321283124S3002,321283124S300205,N-129', 'Z110', 'SYS_BA');
    223. 

  223. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R130-101', '空调', '1', '1', 'Zoning', 'N-130', '321283124S3002,321283124S300205,N-130', 'Z110', 'SYS_BA');
    224. 

  224. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R131-101', '空调', '1', '1', 'Zoning', 'N-131', '321283124S3002,321283124S300205,N-131', 'Z110', 'SYS_BA');
    225. 

  225. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Z010-R132-101', '空调', '1', '1', 'Zoning', 'N-132', '321283124S3002,321283124S300205,N-132', 'Z110', 'SYS_BA');
    226. 

  226. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Car-101', '照明灯', '1', '1', 'Zoning', '321283124S3002_CW-XK', '321283124S3002,321283124S300206,321283124S3002_CW-XK', 'Z102','SYS_BA');
    227. 

  227. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Car-102', '智能监控系统', '1', NULL, 'Zoning', '321283124S3002_CW-CD', '321283124S3002,321283124S300206,321283124S3002_CW-CD', 'Z110','SYS_BA');
    228. 

  228. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Car-103', '照明灯', '1', NULL, 'Zoning', '321283124S3002_CW-WZA', '321283124S3002,321283124S300206,321283124S3002_CW-WZA', 'Z102','SYS_BA');
    229. 

  229. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Car-104', '照明灯', '1', NULL, 'Zoning', '321283124S3002_CW-DKC', '321283124S3002,321283124S300206,321283124S3002_CW-DKC', 'Z102','SYS_BA');
    230. 

  230. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Car-105', '照明灯', '1', NULL, 'Zoning', '321283124S3002_CW-HC', '321283124S3002,321283124S300206,321283124S3002_CW-HC', 'Z102','SYS_BA');
    231. 

  231. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Car-106', '停车场照明灯', '1', NULL, 'Zoning', '321283124S3002_CW-WXP', '321283124S3002,321283124S300206,321283124S3002_CW-WXP', 'Z102','SYS_BA');
    232. 

  232. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Car-107', '智能监控系统', '1', NULL, 'Zoning', '321283124S3002_CW-WXP', '321283124S3002,321283124S300206,321283124S3002_CW-WXP', 'Z110','SYS_BA');
    233. 

  233. 

  234. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Road_001', '主板1', '2', '1', 'Area', '321283124S3003', '321283124S3003', 'Z110', 'SYS_BA');
    235. 

  235. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Road_002', '主板2', '2', '1', 'Area', '321283124S3003', '321283124S3003', 'Z110', 'SYS_BA');
    236. 

  236. INSERT INTO `adm_ems_device` ( `device_code`, `device_name`, `device_type`, `device_status`, `area_type`, `ref_area`, `area_ancestors`, `ref_facs`, `subsystem_code`) VALUES ( 'Road_003', '主板3', '2', '1', 'Area', '321283124S3003', '321283124S3003', 'Z110', 'SYS_BA');
    237. 

  237. 

  238. 

  239. -- 配电柜DEMO数据
    240. 

  240. INSERT INTO adm_power_box (`box_code`, `box_type`, `area_code`, `location`, `box_size`, `gateway_addr`, `gateway_port`) VALUES ('D-B-1001', 1, '321283124S3001', '综合楼配电间', '100*200', '0.0.0.0', 9999);
    241. 

  241. INSERT INTO adm_power_box (`box_code`, `box_type`, `area_code`, `location`, `box_size`, `gateway_addr`, `gateway_port`) VALUES ('D-B-1002', 1, '321283124S3001', '广场配电柜', '100*200', '0.0.0.0', 9999);
    242. 

  242. INSERT INTO adm_power_box (`box_code`, `box_type`, `area_code`, `location`, `box_size`, `gateway_addr`, `gateway_port`) VALUES ('D-N-1001', 1, '321283124S3002', '综合楼配电间', '100*200', '0.0.0.0', 9999);
    243. 

  243. INSERT INTO adm_power_box (`box_code`, `box_type`, `area_code`, `location`, `box_size`, `gateway_addr`, `gateway_port`) VALUES ('D-N-1002', 1, '321283124S3002', '广场配电柜', '100*200', '0.0.0.0', 9999);
    244. 

  244. 

  245. -- 动力箱柜电气设备表
    246. 

  246. INSERT INTO adm_box_elec_eqpt (`box_code`, `eqpt_code`, `ext_eqpt_code`, `eqpt_type`, `eqpt_spec`, `rated_voltage`, `rated_current`, `ancestors`, `parent_eqpt`, `sub_circuit`) VALUES ('D-B-1001', 'D-B-1001-10000', '0x0001', 'RCD', '总开（漏保）', 380, 200, '', '-1', '分开');
    247. 

  247. INSERT INTO adm_box_elec_eqpt (`box_code`, `eqpt_code`, `ext_eqpt_code`, `eqpt_type`, `eqpt_spec`, `rated_voltage`, `rated_current`, `ancestors`, `parent_eqpt`, `sub_circuit`) VALUES ('D-B-1001', 'D-B-1001-10011', '0x0002', 'QF', '分开（空开）', 380, 60, '-1,D-B-1001-10000', 'D-B-1001-10000', '照明');
    248. 

  248. INSERT INTO adm_box_elec_eqpt (`box_code`, `eqpt_code`, `ext_eqpt_code`, `eqpt_type`, `eqpt_spec`, `rated_voltage`, `rated_current`, `ancestors`, `parent_eqpt`, `sub_circuit`) VALUES ('D-B-1001', 'D-B-1001-11012', '0x0003', 'QF', '分开（空开）', 380, 60, '-1,D-B-1001-10000', 'D-B-1001-10000', 'LED');
    249. 

  249. INSERT INTO adm_box_elec_eqpt (`box_code`, `eqpt_code`, `ext_eqpt_code`, `eqpt_type`, `eqpt_spec`, `rated_voltage`, `rated_current`, `ancestors`, `parent_eqpt`, `sub_circuit`) VALUES ('D-B-1001', 'D-B-1001-11013', '0x0003', 'QF', '分开（空开）', 380, 60, '-1,D-B-1001-10000', 'D-B-1001-10000', '空调');
    250. 

  250. INSERT INTO adm_box_elec_eqpt (`box_code`, `eqpt_code`, `ext_eqpt_code`, `eqpt_type`, `eqpt_spec`, `rated_voltage`, `rated_current`, `ancestors`, `parent_eqpt`, `sub_circuit`) VALUES ('D-B-1001', 'D-B-1001-11014', '0x0004', 'QF', '分开（空开）', 380, 60, '-1,D-B-1001-10000', 'D-B-1001-10000', '水泵');
    251. 

  251. 

  252. INSERT INTO adm_box_elec_eqpt (`box_code`, `eqpt_code`, `ext_eqpt_code`, `eqpt_type`, `eqpt_spec`, `rated_voltage`, `rated_current`, `ancestors`, `parent_eqpt`, `sub_circuit`) VALUES ('D-B-1002', 'D-B-1002-10000', '0x0011', 'RCD', '总开（漏保）', 380, 200, '', '-1', '分开');
    253. 

  253. INSERT INTO adm_box_elec_eqpt (`box_code`, `eqpt_code`, `ext_eqpt_code`, `eqpt_type`, `eqpt_spec`, `rated_voltage`, `rated_current`, `ancestors`, `parent_eqpt`, `sub_circuit`) VALUES ('D-B-1002', 'D-B-1002-10011', '0x0012', 'QF', '分开（空开）', 380, 60, '-1,D-B-1002-10000', 'D-B-1002-10000', '照明');
    254. 

  254. INSERT INTO adm_box_elec_eqpt (`box_code`, `eqpt_code`, `ext_eqpt_code`, `eqpt_type`, `eqpt_spec`, `rated_voltage`, `rated_current`, `ancestors`, `parent_eqpt`, `sub_circuit`) VALUES ('D-B-1002', 'D-B-1002-11012', '0x0013', 'QF', '分开（空开）', 380, 60, '-1,D-B-1002-10000', 'D-B-1002-10000', '照明');
    255. 

  255. INSERT INTO adm_box_elec_eqpt (`box_code`, `eqpt_code`, `ext_eqpt_code`, `eqpt_type`, `eqpt_spec`, `rated_voltage`, `rated_current`, `ancestors`, `parent_eqpt`, `sub_circuit`) VALUES ('D-B-1002', 'D-B-1002-11013', '0x0013', 'QF', '分开（空开）', 380, 60, '-1,D-B-1002-10000', 'D-B-1002-10000', '照明');
    256. 

  256. INSERT INTO adm_box_elec_eqpt (`box_code`, `eqpt_code`, `ext_eqpt_code`, `eqpt_type`, `eqpt_spec`, `rated_voltage`, `rated_current`, `ancestors`, `parent_eqpt`, `sub_circuit`) VALUES ('D-B-1002', 'D-B-1002-11014', '0x0014', 'QF', '分开（空开）', 380, 60, '-1,D-B-1002-10000', 'D-B-1002-10000', '照明');
    257. 

  257. 

  258. INSERT INTO adm_box_elec_eqpt (`box_code`, `eqpt_code`, `ext_eqpt_code`, `eqpt_type`, `eqpt_spec`, `rated_voltage`, `rated_current`, `ancestors`, `parent_eqpt`, `sub_circuit`) VALUES ('D-N-1001', 'D-N-1001-10000', '0x0101', 'RCD', '总开（漏保）', 380, 200, '', '-1', '分开');
    259. 

  259. INSERT INTO adm_box_elec_eqpt (`box_code`, `eqpt_code`, `ext_eqpt_code`, `eqpt_type`, `eqpt_spec`, `rated_voltage`, `rated_current`, `ancestors`, `parent_eqpt`, `sub_circuit`) VALUES ('D-N-1001', 'D-N-1001-10011', '0x0102', 'QF', '分开（空开）', 380, 60, '-1,D-N-1001-10000', 'D-N-1001-10000', '空调');
    260. 

  260. INSERT INTO adm_box_elec_eqpt (`box_code`, `eqpt_code`, `ext_eqpt_code`, `eqpt_type`, `eqpt_spec`, `rated_voltage`, `rated_current`, `ancestors`, `parent_eqpt`, `sub_circuit`) VALUES ('D-N-1001', 'D-N-1001-11012', '0x0103', 'QF', '分开（空开）', 380, 60, '-1,D-N-1001-10000', 'D-N-1001-10000', '空调');
    261. 

  261. INSERT INTO adm_box_elec_eqpt (`box_code`, `eqpt_code`, `ext_eqpt_code`, `eqpt_type`, `eqpt_spec`, `rated_voltage`, `rated_current`, `ancestors`, `parent_eqpt`, `sub_circuit`) VALUES ('D-N-1001', 'D-N-1001-11013', '0x0103', 'QF', '分开（空开）', 380, 60, '-1,D-N-1001-10000', 'D-N-1001-10000', '空调');
    262. 

  262. INSERT INTO adm_box_elec_eqpt (`box_code`, `eqpt_code`, `ext_eqpt_code`, `eqpt_type`, `eqpt_spec`, `rated_voltage`, `rated_current`, `ancestors`, `parent_eqpt`, `sub_circuit`) VALUES ('D-N-1001', 'D-N-1001-11014', '0x0104', 'QF', '分开（空开）', 380, 60, '-1,D-N-1001-10000', 'D-N-1001-10000', '空调');
    263. 

  263. 

  264. INSERT INTO adm_box_elec_eqpt (`box_code`, `eqpt_code`, `ext_eqpt_code`, `eqpt_type`, `eqpt_spec`, `rated_voltage`, `rated_current`, `ancestors`, `parent_eqpt`, `sub_circuit`) VALUES ('D-N-1002', 'D-B-1002-10000', '0x0201', 'RCD', '总开（漏保）', 380, 200, '', '-1', '分开');
    265. 

  265. INSERT INTO adm_box_elec_eqpt (`box_code`, `eqpt_code`, `ext_eqpt_code`, `eqpt_type`, `eqpt_spec`, `rated_voltage`, `rated_current`, `ancestors`, `parent_eqpt`, `sub_circuit`) VALUES ('D-N-1002', 'D-B-1002-10011', '0x0202', 'QF', '分开（空开）', 380, 60, '-1,D-B-1002-10000', 'D-B-1002-10000', '水泵');
    266. 

  266. INSERT INTO adm_box_elec_eqpt (`box_code`, `eqpt_code`, `ext_eqpt_code`, `eqpt_type`, `eqpt_spec`, `rated_voltage`, `rated_current`, `ancestors`, `parent_eqpt`, `sub_circuit`) VALUES ('D-N-1002', 'D-B-1002-11012', '0x0203', 'QF', '分开（空开）', 380, 60, '-1,D-B-1002-10000', 'D-B-1002-10000', '水泵');
    267. 

  267. INSERT INTO adm_box_elec_eqpt (`box_code`, `eqpt_code`, `ext_eqpt_code`, `eqpt_type`, `eqpt_spec`, `rated_voltage`, `rated_current`, `ancestors`, `parent_eqpt`, `sub_circuit`) VALUES ('D-N-1002', 'D-B-1002-11013', '0x0203', 'QF', '分开（空开）', 380, 60, '-1,D-B-1002-10000', 'D-B-1002-10000', '水泵');
    268. 

  268. INSERT INTO adm_box_elec_eqpt (`box_code`, `eqpt_code`, `ext_eqpt_code`, `eqpt_type`, `eqpt_spec`, `rated_voltage`, `rated_current`, `ancestors`, `parent_eqpt`, `sub_circuit`) VALUES ('D-N-1002', 'D-B-1002-11014', '0x0204', 'QF', '分开（空开）', 380, 60, '-1,D-B-1002-10000', 'D-B-1002-10000', '水泵');
    269. 

  269. 

  270. -- 区域&标签关系表
    271. 

  271. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','B-101','Area_00');
    272. 

  272. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','B-102','Area_01');
    273. 

  273. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','B-103','Area_01');
    274. 

  274. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','B-104','Area_01');
    275. 

  275. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','B-105','Area_01');
    276. 

  276. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','B-106','Area_01');
    277. 

  277. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','B-107','Area_01');
    278. 

  278. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','B-108','Area_01');
    279. 

  279. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','B-109','Area_01');
    280. 

  280. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','B-110','Area_01');
    281. 

  281. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','B-111','Area_00');
    282. 

  282. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','B-112','Area_00');
    283. 

  283. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','B-113','Area_00');
    284. 

  284. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','B-114','Area_00');
    285. 

  285. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','B-115','Area_00');
    286. 

  286. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','B-116','Area_00');
    287. 

  287. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','B-117','Area_00');
    288. 

  288. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','B-118','Area_00');
    289. 

  289. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','B-119','Area_00');
    290. 

  290. 

  291. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','321283124S3001_CW-CD','Area_00');
    292. 

  292. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','321283124S3001_CW-DKC','Area_00');
    293. 

  293. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','321283124S3001_CW-HC','Area_00');
    294. 

  294. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','321283124S3001_CW-WXP','Area_00');
    295. 

  295. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','321283124S3001_CW-WZA','Area_00');
    296. 

  296. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','321283124S3001_CW-XK','Area_00');
    297. 

  297. 

  298. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','N-101','Area_00');
    299. 

  299. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','N-102','Area_01');
    300. 

  300. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','N-103','Area_01');
    301. 

  301. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','N-104','Area_01');
    302. 

  302. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','N-105','Area_01');
    303. 

  303. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','N-106','Area_01');
    304. 

  304. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','N-107','Area_01');
    305. 

  305. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','N-108','Area_01');
    306. 

  306. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','N-109','Area_01');
    307. 

  307. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','N-110','Area_01');
    308. 

  308. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','N-111','Area_00');
    309. 

  309. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','N-112','Area_00');
    310. 

  310. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','N-113','Area_00');
    311. 

  311. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','N-114','Area_00');
    312. 

  312. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','N-115','Area_00');
    313. 

  313. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','N-116','Area_00');
    314. 

  314. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','N-117','Area_00');
    315. 

  315. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','N-118','Area_00');
    316. 

  316. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','N-119','Area_00');
    317. 

  317. 

  318. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','321283124S3002_CW-CD','Area_00');
    319. 

  319. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','321283124S3002_CW-DKC','Area_00');
    320. 

  320. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','321283124S3002_CW-HC','Area_00');
    321. 

  321. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','321283124S3002_CW-WXP','Area_00');
    322. 

  322. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','321283124S3002_CW-WZA','Area_00');
    323. 

  323. insert into adm_obj_tag_rel (`tag_type`,`obj_code`,`tag_code`) VALUES ('3','321283124S3002_CW-XK','Area_00');
    324. 

  324. 

  325. -- 服务区用电属性数据
    326. 

  326. INSERT INTO adm_area_elec_attr (`area_code`, `price_code`, `req_capacity_flag`, `trans_capacity`, `req_quantity`) VALUES ('321283124S3001', '4001', 1, 630, NULL);
    327. 

  327. INSERT INTO adm_area_elec_attr (`area_code`, `price_code`, `req_capacity_flag`, `trans_capacity`, `req_quantity`) VALUES ('321283124S3002', '4001', 1, 630, NULL);
    328. 

  328. 

  329. -- 国网电价数据
    330. 

  330. -- 单一制初始电价数据
    331. 

  331. INSERT INTO adm_gw_elecprice_config (`cfg_code`, `elec_type`, `voltage_level`, `degree_price`, `fs_peak_degree_price`, `fs_high_degree_price`, `fs_flat_degree_price`, `fs_low_degree_price`, `max_req_price`, `trans_capacity_price`) VALUES ('3001', 3, '不满1千伏', 0.7624, 1.5296, 1.2747, 0.7624, 0.3445, NULL, NULL);
    332. 

  332. INSERT INTO adm_gw_elecprice_config (`cfg_code`, `elec_type`, `voltage_level`, `degree_price`, `fs_peak_degree_price`, `fs_high_degree_price`, `fs_flat_degree_price`, `fs_low_degree_price`, `max_req_price`, `trans_capacity_price`) VALUES ('3002', 3, '1-10(20)千伏', 0.7364, 1.4774, 1.2312, 0.7364, 0.3327, NULL, NULL);
    333. 

  333. INSERT INTO adm_gw_elecprice_config (`cfg_code`, `elec_type`, `voltage_level`, `degree_price`, `fs_peak_degree_price`, `fs_high_degree_price`, `fs_flat_degree_price`, `fs_low_degree_price`, `max_req_price`, `trans_capacity_price`) VALUES ('3003', 3, '35千伏', 0.7114, 1.4273, 1.1894, 0.7114, 0.3214, NULL, NULL);
    334. 

  334. 

  335. -- 两部制初始电价数据
    336. 

  336. INSERT INTO adm_gw_elecprice_config (`cfg_code`, `elec_type`, `voltage_level`, `degree_price`, `fs_peak_degree_price`, `fs_high_degree_price`, `fs_flat_degree_price`, `fs_low_degree_price`, `max_req_price`, `trans_capacity_price`) VALUES ('4001', 4, '1-10(20)千伏', 0.6587, 1.3592, 1.1327, 0.6587, 0.2757, 51.2, 32);
    337. 

  337. INSERT INTO adm_gw_elecprice_config (`cfg_code`, `elec_type`, `voltage_level`, `degree_price`, `fs_peak_degree_price`, `fs_high_degree_price`, `fs_flat_degree_price`, `fs_low_degree_price`, `max_req_price`, `trans_capacity_price`) VALUES ('4002', 4, '35千伏', 0.6337, 1.3076, 1.0897, 0.6337, 0.2652, 48, 30);
    338. 

  338. INSERT INTO adm_gw_elecprice_config (`cfg_code`, `elec_type`, `voltage_level`, `degree_price`, `fs_peak_degree_price`, `fs_high_degree_price`, `fs_flat_degree_price`, `fs_low_degree_price`, `max_req_price`, `trans_capacity_price`) VALUES ('4003', 4, '110千伏', 0.6087, 1.256, 1.0467, 0.6087, 0.2547, 44.8, 28);
    339. 

  339. INSERT INTO adm_gw_elecprice_config (`cfg_code`, `elec_type`, `voltage_level`, `degree_price`, `fs_peak_degree_price`, `fs_high_degree_price`, `fs_flat_degree_price`, `fs_low_degree_price`, `max_req_price`, `trans_capacity_price`) VALUES ('4004', 4, '220千伏及以上', 0.5827, 1.2024, 1.002, 0.5827, 0.2439, 41.6, 26);
    340. 

  340. 

  341. 

  342. -- 峰谷电价策略数据
    343. 

  343. -- 默认策略
    344. 

  344. INSERT INTO adm_elecprice_strategy (`strategy_code`, `strategy_name`, `strategy_desc`, `repeat_type`, `repeat_param`, `priority`, `edit_flag`) VALUES ('-1', '默认策略', '0:00-24:00 执行平峰电价', 2, null, 0, 0);
    345. 

  345. INSERT INTO adm_elecprice_strategy_hour (`strategy_code`, `start_time`, `end_time`, `type`) VALUES ('-1', '00:00:00', '23:59:59', 0);
    346. 

  346. 

  347. -- 默认策略
    348. 

  348. INSERT INTO adm_elecprice_strategy (`strategy_code`, `strategy_name`, `strategy_desc`, `repeat_type`, `repeat_param`, `priority`, `edit_flag`) VALUES ('1001', '100千伏安', '100千伏安以上峰谷电价', 2, null, 1, 1);
    349. 

  349. INSERT INTO adm_elecprice_strategy_hour (`strategy_code`, `start_time`, `end_time`, `type`) VALUES ('1001', '00:00:00', '08:00:00', -1);
    350. 

  350. INSERT INTO adm_elecprice_strategy_hour (`strategy_code`, `start_time`, `end_time`, `type`) VALUES ('1001', '08:00:00', '10:00:00', 1);
    351. 

  351. INSERT INTO adm_elecprice_strategy_hour (`strategy_code`, `start_time`, `end_time`, `type`) VALUES ('1001', '11:00:00', '17:00:00', 0);
    352. 

  352. INSERT INTO adm_elecprice_strategy_hour (`strategy_code`, `start_time`, `end_time`, `type`) VALUES ('1001', '17:00:00', '22:00:00', 1);
    353. 

  353. INSERT INTO adm_elecprice_strategy_hour (`strategy_code`, `start_time`, `end_time`, `type`) VALUES ('1001', '22:00:00', '23:59:59', 0);
    354. 

  354. 

  355. -- 商户能源计费策略
    356. 

  356. INSERT INTO adm_co_charging_config (`area_code`, `elec_unit_price`, `elec_gt_compute_type`, `elec_compute_desc`, `water_unit_price`, `water_gt_compute_type`, `water_compute_desc`) VALUES ('321283124S3001', 0.6068, 1, '1.按户数均摊\n公摊电费每户收费 = 公摊电费 / 户数\n2、按面积分摊\n单户公摊电费 = 公摊电费 * (单户面积 / 总面积)', 3.04, 0, NULL);
    357. 

  357. INSERT INTO adm_co_charging_config (`area_code`, `elec_unit_price`, `elec_gt_compute_type`, `elec_compute_desc`, `water_unit_price`, `water_gt_compute_type`, `water_compute_desc`) VALUES ('321283124S3002', 0.6068, 1, '1.按户数均摊\n公摊电费每户收费 = 公摊电费 / 户数\n2、按面积分摊\n单户公摊电费 = 公摊电费 * (单户面积 / 总面积)', 3.04, 0, NULL);
    358. 

  358. 

  359. -- 子系统DEMO数据
    360. 

  360. INSERT INTO `adm_ems_subsystem` (`system_code`, `system_name`, `short_name`, `man_facturer`, `contact_person`, `contact_number`, `maintainer_person`, `maintainer_number`, `descr`) VALUES ('SYS_GF', '光伏系统', '光伏', '南通', '张', '1380000', '李工', '123123', NULL);
    361. 

  361. INSERT INTO `adm_ems_subsystem` (`system_code`, `system_name`, `short_name`, `man_facturer`, `contact_person`, `contact_number`, `maintainer_person`, `maintainer_number`, `descr`) VALUES ('SYS_CN', '储能系统', '储能', '储能厂商', '王', '122112', '陈', '21212', NULL);
    362. 

  362. INSERT INTO `adm_ems_subsystem` (`system_code`, `system_name`, `short_name`, `man_facturer`, `contact_person`, `contact_number`, `maintainer_person`, `maintainer_number`, `descr`) VALUES ('SYS_BA', 'BA', '楼控', '楼控', '李', '12', '王', '121', NULL);
    363. 

  363. 

  364. 

  365. -- 能源计量设备DEMO数据
    366. 

  366. -- 电表
    367. 

  367. INSERT INTO `adm_meter_device` (`device_code`, `area_code`, `meter_cls`, `obj_type`, `obj_sub_type`, `obj_code`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('J-D-B-102', '321283124S3001', 45, 1, 3, 'B-102', 1, 4, 1, 1, '直采表');
    368. 

  368. INSERT INTO `adm_meter_device` (`device_code`, `area_code`, `meter_cls`, `obj_type`, `obj_sub_type`, `obj_code`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('J-D-B-103', '321283124S3001', 45, 1, 3, 'B-103', 1, 4, 1, 1, '直采表');
    369. 

  369. INSERT INTO `adm_meter_device` (`device_code`, `area_code`, `meter_cls`, `obj_type`, `obj_sub_type`, `obj_code`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('J-D-B-104', '321283124S3001', 45, 1, 3, 'B-104', 1, 4, 1, 1, '直采表');
    370. 

  370. INSERT INTO `adm_meter_device` (`device_code`, `area_code`, `meter_cls`, `obj_type`, `obj_sub_type`, `obj_code`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('J-D-B-105', '321283124S3001', 45, 1, 3, 'B-105', 1, 4, 1, 1, '直采表');
    371. 

  371. INSERT INTO `adm_meter_device` (`device_code`, `area_code`, `meter_cls`, `obj_type`, `obj_sub_type`, `obj_code`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('J-D-B-106', '321283124S3001', 45, 1, 3, 'B-106', 1, 4, 1, 1, '直采表');
    372. 

  372. INSERT INTO `adm_meter_device` (`device_code`, `area_code`, `meter_cls`, `obj_type`, `obj_sub_type`, `obj_code`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('J-D-B-107', '321283124S3001', 45, 1, 3, 'B-107', 1, 4, 1, 1, '直采表');
    373. 

  373. INSERT INTO `adm_meter_device` (`device_code`, `area_code`, `meter_cls`, `obj_type`, `obj_sub_type`, `obj_code`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('J-D-B-108', '321283124S3001', 45, 1, 3, 'B-108', 1, 4, 1, 1, '直采表');
    374. 

  374. INSERT INTO `adm_meter_device` (`device_code`, `area_code`, `meter_cls`, `obj_type`, `obj_sub_type`, `obj_code`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('J-D-B-109', '321283124S3001', 45, 1, 3, 'B-109', 1, 4, 1, 1, '直采表');
    375. 

  375. INSERT INTO `adm_meter_device` (`device_code`, `area_code`, `meter_cls`, `obj_type`, `obj_sub_type`, `obj_code`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('J-D-B-110', '321283124S3001', 45, 1, 3, 'B-110', 1, 4, 1, 1, '直采表');
    376. 

  376. INSERT INTO `adm_meter_device` (`device_code`, `area_code`, `meter_cls`, `obj_type`, `obj_sub_type`, `obj_code`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('J-D-B-Z101', '321283124S3001', 45, 2, 1, 'Z101', 0, 4, 1, 1, '直采表');
    377. 

  377. INSERT INTO `adm_meter_device` (`device_code`, `area_code`, `meter_cls`, `obj_type`, `obj_sub_type`, `obj_code`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('J-D-B-Z120', '321283124S3001', 45, 2, 1, 'Z120', 0, 4, 1, 50, '互感器表');
    378. 

  378. 

  379. INSERT INTO `adm_meter_device` (`device_code`, `area_code`, `meter_cls`, `obj_type`, `obj_sub_type`, `obj_code`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('J-D-N-101', '321283124S3002', 45, 1, 3, 'N-101', 1, 4, 1, 1, '直采表');
    380. 

  380. INSERT INTO `adm_meter_device` (`device_code`, `area_code`, `meter_cls`, `obj_type`, `obj_sub_type`, `obj_code`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('J-D-N-102', '321283124S3002', 45, 1, 3, 'N-103', 1, 4, 1, 1, '直采表');
    381. 

  381. INSERT INTO `adm_meter_device` (`device_code`, `area_code`, `meter_cls`, `obj_type`, `obj_sub_type`, `obj_code`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('J-D-N-103', '321283124S3002', 45, 1, 3, 'N-105', 1, 4, 1, 1, '直采表');
    382. 

  382. INSERT INTO `adm_meter_device` (`device_code`, `area_code`, `meter_cls`, `obj_type`, `obj_sub_type`, `obj_code`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('J-D-N-104', '321283124S3002', 45, 1, 3, 'N-107', 1, 4, 1, 1, '直采表');
    383. 

  383. INSERT INTO `adm_meter_device` (`device_code`, `area_code`, `meter_cls`, `obj_type`, `obj_sub_type`, `obj_code`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('J-D-N-105', '321283124S3002', 45, 1, 3, 'N-109', 1, 4, 1, 1, '直采表');
    384. 

  384. INSERT INTO `adm_meter_device` (`device_code`, `area_code`, `meter_cls`, `obj_type`, `obj_sub_type`, `obj_code`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('J-D-N-106', '321283124S3002', 45, 1, 3, 'N-110', 1, 4, 1, 1, '直采表');
    385. 

  385. INSERT INTO `adm_meter_device` (`device_code`, `area_code`, `meter_cls`, `obj_type`, `obj_sub_type`, `obj_code`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('J-D-N-107', '321283124S3002', 45, 1, 3, 'N-112', 1, 4, 1, 1, '直采表');
    386. 

  386. INSERT INTO `adm_meter_device` (`device_code`, `area_code`, `meter_cls`, `obj_type`, `obj_sub_type`, `obj_code`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('J-D-N-108', '321283124S3002', 45, 1, 3, 'N-113', 1, 4, 1, 1, '直采表');
    387. 

  387. INSERT INTO `adm_meter_device` (`device_code`, `area_code`, `meter_cls`, `obj_type`, `obj_sub_type`, `obj_code`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('J-D-N-109', '321283124S3002', 45, 1, 3, 'N-114', 1, 4, 1, 1, '直采表');
    388. 

  388. INSERT INTO `adm_meter_device` (`device_code`, `area_code`, `meter_cls`, `obj_type`, `obj_sub_type`, `obj_code`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('J-D-N-110', '321283124S3002', 45, 1, 3, 'N-115', 0, 4, 1, 1, '直采表');
    389. 

  389. INSERT INTO `adm_meter_device` (`device_code`, `area_code`, `meter_cls`, `obj_type`, `obj_sub_type`, `obj_code`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('J-D-Z010-R105-101', '321283124S3002', 45, 2, 2, 'Z010-R105-101', 0, 4, 1, 20, '互感器表');
    390. 

  390. 

  391. -- 水表
    392. 

  392. INSERT INTO `adm_meter_device` (`device_code`, `area_code`, `meter_cls`, `obj_type`, `obj_sub_type`, `obj_code`, `obj_tag`, `col_cycle`, `col_mode`, `magnification`, `spec_desc`) VALUES ('J-D-B-01', '321283124S3001', 70, 1, 2, '321283124S300101', 0, 4, 1, 1, '直采表');
    393. 

  393. 

  394. -- 抄表demo数据
    395. 

  395. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-102', '321283124S3001', '2024', '202401', 0, '2024-02-29', 100, '2024-01-31', 100, NULL, NULL);
    396. 

  396. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-102', '321283124S3001', '2024', '202402', 100, '2024-02-29', 238, '2024-02-28', 138, NULL, NULL);
    397. 

  397. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-102', '321283124S3001', '2024', '202403', 238, '2024-02-29', 365, '2024-03-31', 127, NULL, NULL);
    398. 

  398. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-102', '321283124S3001', '2024', '202404', 365, '2024-03-31', 537, '2024-04-30', 172, NULL, NULL);
    399. 

  399. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-102', '321283124S3001', '2024', '202405', 537, '2024-04-30', 686, '2024-05-31', 149, NULL, NULL);
    400. 

  400. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-102', '321283124S3001', '2024', '202406', 686, '2024-05-31', 921, '2024-06-30', 235, NULL, NULL);
    401. 

  401. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-102', '321283124S3001', '2024', '202407', 921, '2024-06-30', 1189, '2024-07-31', 268, NULL, NULL);
    402. 

  402. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-102', '321283124S3001', '2024', '202408', 1189, '2024-07-31', 1464, '2024-08-31', 275, NULL, NULL);
    403. 

  403. 

  404. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-103', '321283124S3001', '2024', '202401', 0, '2024-02-29', 100, '2024-01-31', 100, NULL, NULL);
    405. 

  405. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-103', '321283124S3001', '2024', '202402', 100, '2024-02-29', 250, '2024-02-28', 150, NULL, NULL);
    406. 

  406. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-103', '321283124S3001', '2024', '202403', 250, '2024-02-29', 360, '2024-03-31', 160, NULL, NULL);
    407. 

  407. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-103', '321283124S3001', '2024', '202404', 360, '2024-03-31', 500, '2024-04-30', 140, NULL, NULL);
    408. 

  408. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-103', '321283124S3001', '2024', '202405', 500, '2024-04-30', 600, '2024-05-31', 100, NULL, NULL);
    409. 

  409. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-103', '321283124S3001', '2024', '202406', 600, '2024-05-31', 720, '2024-06-30', 120, NULL, NULL);
    410. 

  410. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-103', '321283124S3001', '2024', '202407', 720, '2024-06-30', 800, '2024-07-31', 80, NULL, NULL);
    411. 

  411. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-103', '321283124S3001', '2024', '202408', 800, '2024-07-31', 860, '2024-08-31', 160, NULL, NULL);
    412. 

  412. 

  413. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-104', '321283124S3001', '2024', '202401', 0, '2024-02-29', 100, '2024-01-31', 100, NULL, NULL);
    414. 

  414. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-104', '321283124S3001', '2024', '202402', 100, '2024-02-29', 200, '2024-02-28', 100, NULL, NULL);
    415. 

  415. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-104', '321283124S3001', '2024', '202403', 200, '2024-02-29', 300, '2024-03-31', 100, NULL, NULL);
    416. 

  416. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-104', '321283124S3001', '2024', '202404', 300, '2024-03-31', 400, '2024-04-30', 100, NULL, NULL);
    417. 

  417. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-104', '321283124S3001', '2024', '202405', 400, '2024-04-30', 500, '2024-05-31', 100, NULL, NULL);
    418. 

  418. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-104', '321283124S3001', '2024', '202406', 500, '2024-05-31', 600, '2024-06-30', 100, NULL, NULL);
    419. 

  419. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-104', '321283124S3001', '2024', '202407', 600, '2024-06-30', 700, '2024-07-31', 100, NULL, NULL);
    420. 

  420. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-104', '321283124S3001', '2024', '202408', 700, '2024-07-31', 800, '2024-08-31', 100, NULL, NULL);
    421. 

  421. 

  422. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-105', '321283124S3001', '2024', '202401', 0, '2024-02-29', 100, '2024-01-31', 100, NULL, NULL);
    423. 

  423. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-105', '321283124S3001', '2024', '202402', 100, '2024-02-29', 200, '2024-02-28', 100, NULL, NULL);
    424. 

  424. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-105', '321283124S3001', '2024', '202403', 200, '2024-02-29', 300, '2024-03-31', 100, NULL, NULL);
    425. 

  425. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-105', '321283124S3001', '2024', '202404', 300, '2024-03-31', 400, '2024-04-30', 100, NULL, NULL);
    426. 

  426. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-105', '321283124S3001', '2024', '202405', 400, '2024-04-30', 500, '2024-05-31', 100, NULL, NULL);
    427. 

  427. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-105', '321283124S3001', '2024', '202406', 500, '2024-05-31', 600, '2024-06-30', 100, NULL, NULL);
    428. 

  428. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-105', '321283124S3001', '2024', '202407', 600, '2024-06-30', 700, '2024-07-31', 100, NULL, NULL);
    429. 

  429. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-105', '321283124S3001', '2024', '202408', 700, '2024-07-31', 800, '2024-08-31', 100, NULL, NULL);
    430. 

  430. 

  431. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-106', '321283124S3001', '2024', '202401', 0, '2024-02-29', 100, '2024-01-31', 100, NULL, NULL);
    432. 

  432. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-106', '321283124S3001', '2024', '202402', 100, '2024-02-29', 200, '2024-02-28', 100, NULL, NULL);
    433. 

  433. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-106', '321283124S3001', '2024', '202403', 200, '2024-02-29', 300, '2024-03-31', 100, NULL, NULL);
    434. 

  434. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-106', '321283124S3001', '2024', '202404', 300, '2024-03-31', 400, '2024-04-30', 100, NULL, NULL);
    435. 

  435. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-106', '321283124S3001', '2024', '202405', 400, '2024-04-30', 500, '2024-05-31', 100, NULL, NULL);
    436. 

  436. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-106', '321283124S3001', '2024', '202406', 500, '2024-05-31', 600, '2024-06-30', 100, NULL, NULL);
    437. 

  437. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-106', '321283124S3001', '2024', '202407', 600, '2024-06-30', 700, '2024-07-31', 100, NULL, NULL);
    438. 

  438. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-106', '321283124S3001', '2024', '202408', 700, '2024-07-31', 800, '2024-08-31', 100, NULL, NULL);
    439. 

  439. 

  440. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-107', '321283124S3001', '2024', '202401', 0, '2024-02-29', 100, '2024-01-31', 100, NULL, NULL);
    441. 

  441. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-107', '321283124S3001', '2024', '202402', 100, '2024-02-29', 200, '2024-02-28', 100, NULL, NULL);
    442. 

  442. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-107', '321283124S3001', '2024', '202403', 200, '2024-02-29', 300, '2024-03-31', 100, NULL, NULL);
    443. 

  443. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-107', '321283124S3001', '2024', '202404', 300, '2024-03-31', 400, '2024-04-30', 100, NULL, NULL);
    444. 

  444. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-107', '321283124S3001', '2024', '202405', 400, '2024-04-30', 500, '2024-05-31', 100, NULL, NULL);
    445. 

  445. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-107', '321283124S3001', '2024', '202406', 500, '2024-05-31', 600, '2024-06-30', 100, NULL, NULL);
    446. 

  446. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-107', '321283124S3001', '2024', '202407', 600, '2024-06-30', 700, '2024-07-31', 100, NULL, NULL);
    447. 

  447. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-107', '321283124S3001', '2024', '202408', 700, '2024-07-31', 800, '2024-08-31', 100, NULL, NULL);
    448. 

  448. 

  449. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-108', '321283124S3001', '2024', '202401', 0, '2024-02-29', 100, '2024-01-31', 100, NULL, NULL);
    450. 

  450. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-108', '321283124S3001', '2024', '202402', 100, '2024-02-29', 200, '2024-02-28', 100, NULL, NULL);
    451. 

  451. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-108', '321283124S3001', '2024', '202403', 200, '2024-02-29', 300, '2024-03-31', 100, NULL, NULL);
    452. 

  452. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-108', '321283124S3001', '2024', '202404', 300, '2024-03-31', 400, '2024-04-30', 100, NULL, NULL);
    453. 

  453. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-108', '321283124S3001', '2024', '202405', 400, '2024-04-30', 500, '2024-05-31', 100, NULL, NULL);
    454. 

  454. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-108', '321283124S3001', '2024', '202406', 500, '2024-05-31', 600, '2024-06-30', 100, NULL, NULL);
    455. 

  455. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-108', '321283124S3001', '2024', '202407', 600, '2024-06-30', 700, '2024-07-31', 100, NULL, NULL);
    456. 

  456. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-108', '321283124S3001', '2024', '202408', 700, '2024-07-31', 800, '2024-08-31', 100, NULL, NULL);
    457. 

  457. 

  458. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-109', '321283124S3001', '2024', '202401', 0, '2024-02-29', 100, '2024-01-31', 100, NULL, NULL);
    459. 

  459. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-109', '321283124S3001', '2024', '202402', 100, '2024-02-29', 200, '2024-02-28', 100, NULL, NULL);
    460. 

  460. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-109', '321283124S3001', '2024', '202403', 200, '2024-02-29', 300, '2024-03-31', 100, NULL, NULL);
    461. 

  461. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-109', '321283124S3001', '2024', '202404', 300, '2024-03-31', 400, '2024-04-30', 100, NULL, NULL);
    462. 

  462. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-109', '321283124S3001', '2024', '202405', 400, '2024-04-30', 500, '2024-05-31', 100, NULL, NULL);
    463. 

  463. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-109', '321283124S3001', '2024', '202406', 500, '2024-05-31', 600, '2024-06-30', 100, NULL, NULL);
    464. 

  464. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-109', '321283124S3001', '2024', '202407', 600, '2024-06-30', 700, '2024-07-31', 100, NULL, NULL);
    465. 

  465. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-109', '321283124S3001', '2024', '202408', 700, '2024-07-31', 800, '2024-08-31', 100, NULL, NULL);
    466. 

  466. 

  467. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-110', '321283124S3001', '2024', '202401', 0, '2024-02-29', 100, '2024-01-31', 100, NULL, NULL);
    468. 

  468. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-110', '321283124S3001', '2024', '202402', 100, '2024-02-29', 200, '2024-02-28', 100, NULL, NULL);
    469. 

  469. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-110', '321283124S3001', '2024', '202403', 200, '2024-02-29', 300, '2024-03-31', 100, NULL, NULL);
    470. 

  470. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-110', '321283124S3001', '2024', '202404', 300, '2024-03-31', 400, '2024-04-30', 100, NULL, NULL);
    471. 

  471. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-110', '321283124S3001', '2024', '202405', 400, '2024-04-30', 500, '2024-05-31', 100, NULL, NULL);
    472. 

  472. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-110', '321283124S3001', '2024', '202406', 500, '2024-05-31', 600, '2024-06-30', 100, NULL, NULL);
    473. 

  473. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-110', '321283124S3001', '2024', '202407', 600, '2024-06-30', 700, '2024-07-31', 100, NULL, NULL);
    474. 

  474. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-110', '321283124S3001', '2024', '202408', 700, '2024-07-31', 800, '2024-08-31', 100, NULL, NULL);
    475. 

  475. 

  476. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-Z101', '321283124S3001', '2024', '202401', 0, '2024-02-29', 1000, '2024-01-31', 100, NULL, NULL);
    477. 

  477. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-Z101', '321283124S3001', '2024', '202402', 1000, '2024-02-29', 2120, '2024-02-28', 1120, NULL, NULL);
    478. 

  478. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-Z101', '321283124S3001', '2024', '202403', 2120, '2024-02-29', 3345, '2024-03-31', 1225, NULL, NULL);
    479. 

  479. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-Z101', '321283124S3001', '2024', '202404', 3345, '2024-03-31', 4478, '2024-04-30', 1133, NULL, NULL);
    480. 

  480. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-Z101', '321283124S3001', '2024', '202405', 4478, '2024-04-30', 5521, '2024-05-31', 1043, NULL, NULL);
    481. 

  481. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-Z101', '321283124S3001', '2024', '202406', 5521, '2024-05-31', 6793, '2024-06-30', 1272, NULL, NULL);
    482. 

  482. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-Z101', '321283124S3001', '2024', '202407', 6793, '2024-06-30', 7886, '2024-07-31', 1093, NULL, NULL);
    483. 

  483. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-Z101', '321283124S3001', '2024', '202408', 7886, '2024-07-31', 8947, '2024-08-31', 1061, NULL, NULL);
    484. 

  484. 

  485. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-Z120', '321283124S3001', '2024', '202401', 0, '2024-02-29', 25, '2024-01-31', 1250, NULL, NULL);
    486. 

  486. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-Z120', '321283124S3001', '2024', '202402', 25, '2024-02-29', 73, '2024-02-28', 2400, NULL, NULL);
    487. 

  487. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-Z120', '321283124S3001', '2024', '202403', 73, '2024-02-29', 133, '2024-03-31', 3000, NULL, NULL);
    488. 

  488. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-Z120', '321283124S3001', '2024', '202404', 133, '2024-03-31', 187, '2024-04-30', 2700, NULL, NULL);
    489. 

  489. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-Z120', '321283124S3001', '2024', '202405', 187, '2024-04-30', 242, '2024-05-31', 2750, NULL, NULL);
    490. 

  490. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-Z120', '321283124S3001', '2024', '202406', 242, '2024-05-31', 293, '2024-06-30', 2550, NULL, NULL);
    491. 

  491. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-Z120', '321283124S3001', '2024', '202407', 293, '2024-06-30', 387, '2024-07-31', 4700, NULL, NULL);
    492. 

  492. INSERT INTO adm_meter_reading (`device_code`, `area_code`, `year`, `meter_month`, `last_reading`, `last_time`, `meter_reading`, `meter_time`, `increase`, `create_time`, `update_time`) VALUES ('J-D-B-Z120', '321283124S3001', '2024', '202408', 387, '2024-07-31', 465, '2024-08-31', 3900, NULL, NULL);
    493. 

  493. 

  494. -- 电网计量指标数据
    495. 

  495. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '00:00:00', 1, 0, 0.75, 70, 52.5);
    496. 

  496. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '01:00:00', 2, 0, 0.75, 65, 48.75);
    497. 

  497. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '02:00:00', 3, 0, 0.75, 60, 45);
    498. 

  498. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '03:00:00', 4, 0, 0.75, 68, 51);
    499. 

  499. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '04:00:00', 5, 0, 0.75, 77, 57.75);
    500. 

  500. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '05:00:00', 6, 0, 0.75, 86, 63);
    501. 

  501. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '06:00:00', 7, 0, 0.75, 97, 72.75);
    502. 

  502. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '07:00:00', 8, 0, 0.75, 127, 96);
    503. 

  503. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '08:00:00', 9, 0, 0.75, 133, 99.75);
    504. 

  504. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '09:00:00', 10, 0, 0.75, 150, 112.2);
    505. 

  505. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '10:00:00', 11, 0, 0.75, 120, 90);
    506. 

  506. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '11:00:00', 12, 0, 0.75, 158, 118.5);
    507. 

  507. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '12:00:00', 13, 0, 0.75, 164, 112.2);
    508. 

  508. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '13:00:00', 14, 0, 0.75, 147, 110.25);
    509. 

  509. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '14:00:00', 15, 0, 0.75, 184, 138);
    510. 

  510. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '15:00:00', 16, 0, 0.75, 135, 101.25);
    511. 

  511. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '16:00:00', 17, 0, 0.75, 120, 90);
    512. 

  512. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '17:00:00', 18, 0, 0.75, 117, 112.2);
    513. 

  513. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '18:00:00', 19, 0, 0.75, 110, 87.75);
    514. 

  514. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '19:00:00', 20, 0, 0.75, 98, 73.5);
    515. 

  515. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '20:00:00', 21, 0, 0.75, 87, 65.25);
    516. 

  516. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '21:00:00', 22, 0, 0.75, 77, 57.75);
    517. 

  517. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '22:00:00', 23, 0, 0.75, 84, 63);
    518. 

  518. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3001', 'W201', '2024-09-01', '23:00:00', 24, 0, 0.75, 62, 46.5);
    519. 

  519. 

  520. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '01:00:00', 1, 0, 0.75, 164, 112.2);
    521. 

  521. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '02:00:00', 2, 0, 0.75, 147, 110.25);
    522. 

  522. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '03:00:00', 3, 0, 0.75, 184, 138);
    523. 

  523. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '04:00:00', 4, 0, 0.75, 135, 101.25);
    524. 

  524. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '05:00:00', 5, 0, 0.75, 120, 90);
    525. 

  525. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '06:00:00', 6, 0, 0.75, 117, 112.2);
    526. 

  526. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '07:00:00', 7, 0, 0.75, 110, 87.75);
    527. 

  527. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '08:00:00', 8, 0, 0.75, 98, 73.5);
    528. 

  528. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '09:00:00', 9, 0, 0.75, 87, 65.25);
    529. 

  529. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '10:00:00', 10, 0, 0.75, 77, 57.75);
    530. 

  530. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '11:00:00', 11, 0, 0.75, 84, 63);
    531. 

  531. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '12:00:00', 12, 0, 0.75, 62, 46.5);
    532. 

  532. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '13:00:00', 13, 0, 0.75, 70, 52.5);
    533. 

  533. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '14:00:00', 14, 0, 0.75, 65, 48.75);
    534. 

  534. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '15:00:00', 15, 0, 0.75, 60, 45);
    535. 

  535. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '16:00:00', 16, 0, 0.75, 68, 51);
    536. 

  536. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '17:00:00', 17, 0, 0.75, 77, 57.75);
    537. 

  537. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '18:00:00', 18, 0, 0.75, 86, 63);
    538. 

  538. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '19:00:00', 19, 0, 0.75, 97, 72.75);
    539. 

  539. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '20:00:00', 20, 0, 0.75, 127, 96);
    540. 

  540. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '21:00:00', 21, 0, 0.75, 133, 99.75);
    541. 

  541. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '22:00:00', 22, 0, 0.75, 150, 112.2);
    542. 

  542. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '23:00:00', 23, 0, 0.75, 120, 90);
    543. 

  543. INSERT INTO `adm_ems_pg_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `meter_type`, `meter_unit_price`, `use_elec_quantity`, `use_elec_cost`) VALUES ('321283124S3002', 'W202', '2024-09-01', '24:00:00', 24, 0, 0.75, 158, 118.5);
    544. 

  544. 

  545. -- 光伏指标数据
    546. 

  546. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '00:00:00', 1, 0.45, 0, 0, 0, 0);
    547. 

  547. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '01:00:00', 2, 0.45, 0, 0, 0, 0);
    548. 

  548. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '02:00:00', 3, 0.45, 0, 0, 0, 0);
    549. 

  549. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '03:00:00', 4, 0.45, 0, 0, 0, 0);
    550. 

  550. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '04:00:00', 5, 0.45, 0, 0, 0, 0);
    551. 

  551. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '05:00:00', 6, 0.45, 0, 0, 0, 0);
    552. 

  552. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '06:00:00', 7, 0.45, 10, 10, 0, 0);
    553. 

  553. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '07:00:00', 8, 0.45, 17, 12, 5, 2.25);
    554. 

  554. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '08:00:00', 9, 0.45, 28, 15, 13, 5.85);
    555. 

  555. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '09:00:00', 10, 0.45, 40, 25, 25, 11.25);
    556. 

  556. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '10:00:00', 11, 0.45, 67, 30, 37, 16.65);
    557. 

  557. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '11:00:00', 12, 0.45, 88, 50, 38, 17.1);
    558. 

  558. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '12:00:00', 13, 0.45, 96, 72, 24, 10.8);
    559. 

  559. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '13:00:00', 14, 0.45, 112, 80, 32, 14.4);
    560. 

  560. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '14:00:00', 15, 0.45, 128, 97, 31, 13.95);
    561. 

  561. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '15:00:00', 16, 0.45, 108, 60, 48, 21.6);
    562. 

  562. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '16:00:00', 17, 0.45, 68, 38, 30, 13.5);
    563. 

  563. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '17:00:00', 18, 0.45, 37, 20, 17, 7.65);
    564. 

  564. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '18:00:00', 19, 0.45, 23, 10, 13, 5.85);
    565. 

  565. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '19:00:00', 20, 0.45, 0, 0, 0, 0);
    566. 

  566. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '20:00:00', 21, 0.45, 0, 0, 0, 0);
    567. 

  567. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '21:00:00', 22, 0.45, 0, 0, 0, 0);
    568. 

  568. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '22:00:00', 23, 0.45, 0, 0, 0, 0);
    569. 

  569. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3001', 'E501', '2024-09-01', '23:00:00', 24, 0.45, 0, 0, 0, 0);
    570. 

  570. 

  571. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '00:00:00', 1, 0.45, 0, 0, 0, 0);
    572. 

  572. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '01:00:00', 2, 0.45, 0, 0, 0, 0);
    573. 

  573. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '02:00:00', 3, 0.45, 0, 0, 0, 0);
    574. 

  574. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '03:00:00', 4, 0.45, 0, 0, 0, 0);
    575. 

  575. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '04:00:00', 5, 0.45, 0, 0, 0, 0);
    576. 

  576. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '05:00:00', 6, 0.45, 0, 0, 0, 0);
    577. 

  577. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '06:00:00', 7, 0.45, 10, 10, 0, 0);
    578. 

  578. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '07:00:00', 8, 0.45, 17, 12, 5, 2.25);
    579. 

  579. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '08:00:00', 9, 0.45, 28, 15, 13, 5.85);
    580. 

  580. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '09:00:00', 10, 0.45, 40, 25, 25, 11.25);
    581. 

  581. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '10:00:00', 11, 0.45, 67, 30, 37, 16.65);
    582. 

  582. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '11:00:00', 12, 0.45, 88, 50, 38, 17.1);
    583. 

  583. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '12:00:00', 13, 0.45, 96, 72, 24, 10.8);
    584. 

  584. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '13:00:00', 14, 0.45, 112, 80, 32, 14.4);
    585. 

  585. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '14:00:00', 15, 0.45, 128, 97, 31, 13.95);
    586. 

  586. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '15:00:00', 16, 0.45, 108, 60, 48, 21.6);
    587. 

  587. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '16:00:00', 17, 0.45, 68, 38, 30, 13.5);
    588. 

  588. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '17:00:00', 18, 0.45, 37, 20, 17, 7.65);
    589. 

  589. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '18:00:00', 19, 0.45, 23, 10, 13, 5.85);
    590. 

  590. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '19:00:00', 20, 0.45, 0, 0, 0, 0);
    591. 

  591. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '20:00:00', 21, 0.45, 0, 0, 0, 0);
    592. 

  592. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '21:00:00', 22, 0.45, 0, 0, 0, 0);
    593. 

  593. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '22:00:00', 23, 0.45, 0, 0, 0, 0);
    594. 

  594. INSERT INTO `adm_ems_pv_supply_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `up_unit_price`, `gen_elec_quantity`, `use_elec_quantity`, `up_elec_quantity`, `up_elec_earn`) VALUES ('321283124S3002', 'E502', '2024-09-01', '23:00:00', 24, 0.45, 0, 0, 0, 0);
    595. 

  595. 

  596. 

  597. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '00:00:00', 1, 35, 0);
    598. 

  598. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '01:00:00', 2, 43, 0);
    599. 

  599. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '02:00:00', 3, 55, 0);
    600. 

  600. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '03:00:00', 4, 51, 0);
    601. 

  601. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '04:00:00', 5, 46, 0);
    602. 

  602. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '05:00:00', 6, 49, 0);
    603. 

  603. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '06:00:00', 7, 35, 5);
    604. 

  604. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '07:00:00', 8, 20, 10);
    605. 

  605. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '08:00:00', 9, 10, 5);
    606. 

  606. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '09:00:00', 10, 0, 30);
    607. 

  607. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '10:00:00', 11, 0, 35);
    608. 

  608. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '11:00:00', 12, 0, 40);
    609. 

  609. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '12:00:00', 13, 0, 45);
    610. 

  610. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '13:00:00', 14, 0, 48);
    611. 

  611. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '14:00:00', 15, 0, 57);
    612. 

  612. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '15:00:00', 16, 0, 49);
    613. 

  613. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '16:00:00', 17, 0, 37);
    614. 

  614. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '17:00:00', 18, 0, 20);
    615. 

  615. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '18:00:00', 19, 33, 10);
    616. 

  616. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '19:00:00', 20, 42, 15);
    617. 

  617. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '20:00:00', 21, 44, 18);
    618. 

  618. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '21:00:00', 22, 56, 13);
    619. 

  619. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '22:00:00', 23, 40, 10);
    620. 

  620. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3001', 'C101', '2024-09-01', '23:00:00', 24, 47, 5);
    621. 

  621. 

  622. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '00:00:00', 1, 53, 0);
    623. 

  623. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '01:00:00', 2, 34, 0);
    624. 

  624. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '02:00:00', 3, 55, 0);
    625. 

  625. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '03:00:00', 4, 45, 0);
    626. 

  626. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '04:00:00', 5, 64, 0);
    627. 

  627. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '05:00:00', 6, 54, 0);
    628. 

  628. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '06:00:00', 7, 53, 8);
    629. 

  629. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '07:00:00', 8, 42, 12);
    630. 

  630. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '08:00:00', 9, 37, 11);
    631. 

  631. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '09:00:00', 10, 0, 22);
    632. 

  632. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '10:00:00', 11, 0, 45);
    633. 

  633. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '11:00:00', 12, 0, 46);
    634. 

  634. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '12:00:00', 13, 0, 51);
    635. 

  635. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '13:00:00', 14, 0, 39);
    636. 

  636. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '14:00:00', 15, 0, 60);
    637. 

  637. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '15:00:00', 16, 0, 39);
    638. 

  638. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '16:00:00', 17, 0, 46);
    639. 

  639. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '17:00:00', 18, 0, 18);
    640. 

  640. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '18:00:00', 19, 37, 15);
    641. 

  641. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '19:00:00', 20, 34, 19);
    642. 

  642. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '20:00:00', 21, 41, 13);
    643. 

  643. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '21:00:00', 22, 60, 17);
    644. 

  644. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '22:00:00', 23, 48, 15);
    645. 

  645. INSERT INTO `adm_ems_elec_store_h` (`area_code`, `facs_code`, `date`, `time`, `time_index`, `charge_elec_quantity`, `discharge_elec_quantity`) VALUES ('321283124S3002', 'C102', '2024-09-01', '23:00:00', 24, 43, 11);
    646. 

  646. 

  647. -- 设施用能计量demo数据
    648. 

  648. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '00:00:00', 1, 12);
    649. 

  649. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '01:00:00', 2, 13);
    650. 

  650. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '02:00:00', 3, 10);
    651. 

  651. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '03:00:00', 4, 13);
    652. 

  652. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '04:00:00', 5, 15);
    653. 

  653. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '05:00:00', 6, 12);
    654. 

  654. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '06:00:00', 7, 8);
    655. 

  655. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '07:00:00', 8, 0);
    656. 

  656. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '08:00:00', 9, 0);
    657. 

  657. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '09:00:00', 10, 0);
    658. 

  658. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '10:00:00', 11, 0);
    659. 

  659. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '11:00:00', 12, 0);
    660. 

  660. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '12:00:00', 13, 0);
    661. 

  661. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '13:00:00', 14, 0);
    662. 

  662. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '14:00:00', 15, 0);
    663. 

  663. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '15:00:00', 16, 0);
    664. 

  664. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '16:00:00', 17, 0);
    665. 

  665. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '17:00:00', 18, 0);
    666. 

  666. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '18:00:00', 19, 10);
    667. 

  667. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '19:00:00', 20, 13);
    668. 

  668. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '20:00:00', 21, 20);
    669. 

  669. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '21:00:00', 22, 17);
    670. 

  670. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '22:00:00', 23, 15);
    671. 

  671. INSERT INTO `adm_ems_facs_use_h` (`area_code`, `facs_code`, `device_code`, `date`, `time`, `time_index`, `elec_quantity`) VALUES ('321283124S3001', 'Z101', NULL, '2024-09-01', '23:00:00', 24, 13);
    672.