testex02-HZXH
sql-SELECT Users.*,dev.DeviceID,dev.SerialNumber FROM Users left join(select * from Devices where deleted=0) dev on dev.UserID=Users.UserID WHERE Users.Deleted = 0 AND Users.LoginName='HZXH'
testex03-HZXH
testex04-HZXH
testex05-HZXH
sql-
declare @username varchar(50);select @username=username from users where userid='1161';select * from (select row_number() over(order by usr2.Created DESC) rownum,@username as yizhanname,dev.*,datediff(day,getdate(),dev.hireexpiredate) as expireday,usr2.UserName,lk.lastcommunication from Devices dev left
                         join dbo.GetSubUsers(1161) usr on dev.userid = usr.id
                         left join LKLocation lk on dev.Deviceid=lk.Deviceid
                         left join Users usr2 on usr2.userid=dev.userid
                         where exists(select 1 from dbo.GetSubUsers(1161) usr where usr.ID = dev.userid)
                         and dev.Deleted = 0 ) a where  a.rownum between (1-1)*(10)+1 and 10*1
未能加载文件或程序集“Newtonsoft.Json, Version=9.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed”或它的某一个依赖项。找到的程序集清单定义与程序集引用不匹配。 (异常来自 HRESULT:0x80131040)
sql-
declare @username varchar(50);select @username=username from users where userid='1161';select * from (select row_number() over(order by usr2.Created DESC) rownum,@username as yizhanname,dev.*,datediff(day,getdate(),dev.hireexpiredate) as expireday,usr2.UserName,lk.lastcommunication from Devices dev left
                         join dbo.GetSubUsers(1161) usr on dev.userid = usr.id
                         left join LKLocation lk on dev.Deviceid=lk.Deviceid
                         left join Users usr2 on usr2.userid=dev.userid
                         where exists(select 1 from dbo.GetSubUsers(1161) usr where usr.ID = dev.userid)
                         and dev.Deleted = 0 ) a where  a.rownum between (1-1)*(10)+1 and 10*1
未能加载文件或程序集“Newtonsoft.Json, Version=9.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed”或它的某一个依赖项。找到的程序集清单定义与程序集引用不匹配。 (异常来自 HRESULT:0x80131040)
sql-
declare @username varchar(50);select @username=username from users where userid='1161';select * from (select row_number() over(order by usr2.Created DESC) rownum,@username as yizhanname,dev.*,datediff(day,getdate(),dev.hireexpiredate) as expireday,usr2.UserName,lk.lastcommunication from Devices dev left
                         join dbo.GetSubUsers(1161) usr on dev.userid = usr.id
                         left join LKLocation lk on dev.Deviceid=lk.Deviceid
                         left join Users usr2 on usr2.userid=dev.userid
                         where exists(select 1 from dbo.GetSubUsers(1161) usr where usr.ID = dev.userid)
                         and dev.Deleted = 0 ) a where  a.rownum between (1-1)*(10)+1 and 10*1
Could not load file or assembly 'Newtonsoft.Json, Version=9.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
sql-
declare @username varchar(50);select @username=username from users where userid='1161';select * from (select row_number() over(order by usr2.Created DESC) rownum,@username as yizhanname,dev.*,datediff(day,getdate(),dev.hireexpiredate) as expireday,usr2.UserName,lk.lastcommunication from Devices dev left
                         join dbo.GetSubUsers(1161) usr on dev.userid = usr.id
                         left join LKLocation lk on dev.Deviceid=lk.Deviceid
                         left join Users usr2 on usr2.userid=dev.userid
                         where exists(select 1 from dbo.GetSubUsers(1161) usr where usr.ID = dev.userid)
                         and dev.Deleted = 0 ) a where  a.rownum between (1-1)*(10)+1 and 10*1
Could not load file or assembly 'Newtonsoft.Json, Version=9.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)