添加设备提示undefined-旧ME

<p>只有admin账号可以添加设备； 添加设备的时候需要输入一个SIM card号，没有的话会提示undefined；</p> <p>一般改ID只改dev_info的accounID，account那边的ID不要改 ME-邵福 2018-01-30 14:13:57 因为account里面有type=1的设备号，还有type=2的客户端账号 ME-邵福 2018-01-30 14:14:32 有些dev_info的account id就跟客户端账号的ID重复了 导致搜不到错误</p> <p>select dev_info.AccountID, dev_info.IDNO from dev_info WHERE dev_info.AccountID noT IN (SELECT ID FROM Account);</p> <p>select account.ID, account.Account from account WHERE Type=1 AND account.ID noT IN (SELECT AccountID FROM dev_info);</p> <p>select user_dev_permit.AccountID, user_dev_permit.DevIDNO from user_dev_permit WHERE user_dev_permit.AccountID noT IN (SELECT ID FROM Account);</p> <p>select * from user_info u where u.AccountID not in (select ID from account);</p> <p>select <em> from dev_info where IDNO='设备号'; // 查询设备是否存在dev_info表 select </em> from account where Account='设备号'; // 查询设备是否存在Account表</p>