/// <summary>
/// 命令是否存在
/// </summary>
/// <param name="deviceId"></param>
/// <returns></returns>
public static bool IsCmdExists(string deviceId)
{
/*
* create proc AirCondtionCmdIsExists
* @deviceId varchar(50)
* as
* if not exists(select * from AirCondtionCmd with(index=IX_AirCondtionCmd_deviceId) where deviceId=@deviceId)
* begin
* select '1'
* end
* else
* begin
* select '0'
* end
*/
var com = new CommonDBHelper(Connection.YZK);
var sp = new SqlParameter[]
{
new SqlParameter("@deviceId", deviceId)
};
var data = com.getSalar("AirCondtionCmdIsExists", sp);
if (data.Equals("0"))
{
return(true);
}
return(false);
}
/// <summary>
/// 判断海底捞设备是否存在
/// </summary>
/// <param name="deviceinfo_userinfo_id"></param>
/// <returns></returns>
public static bool YZKDeviceInfo_UserInfo_IsHDLDeviceExists(string deviceinfo_userinfo_id)
{
/*
* 判断海底捞设备是否存在
* create proc YZKDeviceInfo_UserInfo_IsDataExists
* @deviceinfo_userinfo_id varchar(50)
* as
* if exists(select * from YZKDeviceInfo_UserInfo where deviceinfo_userinfo_id=@deviceinfo_userinfo_id)
* begin
* select '1'
* end
* else
* begin
* select '0'
* end
*/
var key = "key:deviceinfo_userinfo_id:hdl:" + deviceinfo_userinfo_id;
if (RedisHelper <string> .IsKeyExist(key))
{
return(true);
}
else
{
var sp = new SqlParameter[]
{
new SqlParameter("@deviceinfo_userinfo_id", deviceinfo_userinfo_id)
};
var db = new CommonDBHelper(Connection.hdl);
var data = db.getSalar("YZKDeviceInfo_UserInfo_IsDataExists", sp) + "";
if (data.Equals("1"))
{
RedisHelper <string> .StoreOneKeyMilliseconds(key, "1", 1000 * 120);
return(true);
}
return(false);
}
}
