/// <summary> /// 根据家id获取撤防状态 /// </summary> /// <param name="homeId"></param> /// <returns></returns> public static DefenseStatus DefenseStatus_GetByHomeId(string homeId) { /* * * create proc DefenseStatus_GetByHomeId * @homeId varchar(50) * as * select * from DefenseStatus where homeId=@homeId */ var dt = new Dictionary <string, string>(); dt.Add("@homeId", homeId); var method = new CReader <DefenseStatus>(Connection.YZK); var data = method.GetOrgRecord(dt, "DefenseStatus_GetByHomeId"); if (data.Count > 0) { return(data[0]); } return(null); //var method = //var data = method.GetOrgRecord(dt, "DefenseStatus_GetByHomeId"); //if (data.Count > 0) //{ // return data[0]; //} //return null; }
/// <summary> /// 根据uuid得到 /// </summary> /// <param name="uuid"></param> /// <returns></returns> public static YZKUser YZKUser_GetByuuid(string uuid) { /* * create proc YZKUser_GetByuuid * @uuid varchar(50) * as * select * from YZKUser where uuid=@uuid * */ var key = "YZK.user.uid:" + uuid; if (RedisHelper <YZKUser> .IsKeyExist(key) == false) { var dt = new Dictionary <string, string>(); dt.Add("@uuid", uuid); var conName = Connection.YZK; var ac = new CReader <YZKUser>(conName); var data = ac.GetOrgRecord(dt, "YZKUser_GetByuuid"); if (data.Count > 0) { RedisHelper <YZKUser> .StoreOneKey(key, data[0], 3000); return(data[0]); } return(null); } else { var signdata = RedisHelper <YZKUser> .GetStoreValue(key); return(signdata); } }
public static YZKPushToken YZKPushToken_GetByUidDeviceTypeMac(string uid, DeviceType devicetype, string mac) { /* * use YZK * go * create proc YZKPushToken_GetByuiddevicetypeMac * @uid varchar(50), * @devicetype int, * @device_mac varchar(50) * as * select * from YZKPushToken where uid=@uid and devicetype=@devicetype and device_mac=@device_mac * */ var type = ((int)devicetype) + ""; var dt = new Dictionary <string, string>(); dt.Add("@uid", uid); dt.Add("@devicetype", type); dt.Add("@device_mac", mac); var method = new CReader <YZKPushToken>(Connection.YZK); var data = method.GetOrgRecord(dt, "YZKPushToken_GetByuiddevicetypeMac"); if (data.Count > 0) { return(data[0]); } return(null); }
/// <summary> /// 根据home_id,device_protocol,device_type /// </summary> /// <param name="home_id"></param> /// <param name="device_protocol"></param> /// <param name="device_type"></param> /// <returns></returns> public static List <YZKDeviceInfo_UserInfo> YZKDeviceInfo_UserInfo_GetXiaoFeiDieByHomeId(string home_id, int device_protocol, string device_type) { /* * use YZK * go * create proc YZKDeviceInfo_UserInfoGetXiaoFeiDieByHomeId * @device_type varchar(50), * @device_protocol int, * @home_id varchar(50) * as * select *from YZKDeviceInfo_UserInfo where device_type=@device_type and device_protocol=@device_protocol and home_id=@home_id * */ var dt = new Dictionary <string, string>(); dt.Add("@device_type", device_type); dt.Add("@device_protocol", device_protocol + ""); dt.Add("@home_id", home_id + ""); var method = new CReader <YZKDeviceInfo_UserInfo>(Connection.YZK); var data = method.GetOrgRecord(dt, "YZKDeviceInfo_UserInfoGetXiaoFeiDieByHomeId"); return(data); }
/// <summary> /// 根据uid获取设备token /// </summary> /// <param name="uid">uid</param> /// <returns></returns> public static List <YZKPushToken> YZKPushToken_GetByUid(string uid) { /* * * use YZK * go * create proc YZKPushToken_GetDataByuid * @uid varchar(50) * as * select * from YZKPushToken where uid=@uid * */ var dt = new Dictionary <string, string>(); dt.Add("@uid", uid); var method = new CReader <YZKPushToken>(Connection.YZK); var data = method.GetOrgRecord(dt, "YZKPushToken_GetDataByuid"); return(data); }
/// <summary> /// 根据设备的mac和设备的协议类型获取设备的token /// </summary> /// <param name="device_mac"></param> /// <param name="protocol_type"></param> /// <returns></returns> public static List <YZKPushToken> YZKPushToken_GetByDeviceMacProcoltype(string device_mac, string protocol_type) { /* * * create proc YZKPushToken_GetByDeviceMacProcoltype * @device_mac varchar(50), * @device_protocol varchar(50) * as * select uid,devicetoken,devicetype,device_mac from YZKPushToken where uid in(select uid from YZKDeviceInfo_UserInfo where device_mac=@device_mac and device_protocol=@device_protocol) * group by uid,devicetoken,devicetype,device_mac */ var dt = new Dictionary <string, string>(); dt.Add("@device_mac", device_mac); dt.Add("@device_protocol", protocol_type); var method = new CReader <YZKPushToken>(Connection.YZK); var data = method.GetOrgRecord(dt, "YZKPushToken_GetByDeviceMacProcoltype"); return(data); }
public static YZKDeviceInfo_UserInfo YZKDeviceInfo_UserInfo_GetDataByRecordid(string recordid) { /* * create proc YZKDeviceInfo_UserInfo_GetByRecordid * @deviceinfo_userinfo_id varchar(50) * as * select * from YZKDeviceInfo_UserInfo where deviceinfo_userinfo_id=@deviceinfo_userinfo_id */ var dt = new Dictionary <string, string>(); dt.Add("@deviceinfo_userinfo_id", recordid); var method = new CReader <YZKDeviceInfo_UserInfo>(Connection.YZK); var data = method.GetOrgRecord(dt, "YZKDeviceInfo_UserInfo_GetByRecordid"); if (data.Count > 0) { return(data[0]); } return(null); }
/// <summary> /// 根据记录id获取空调命令 /// </summary> /// <param name="deviceId"></param> /// <returns></returns> public static AirCondtionCmd GetByDeviceId(string deviceId) { /* * create proc AirCondtionCmdGetByDeviceId * @deviceId varchar(50) * as * select * from AirCondtionCmd where deviceId=@deviceId * */ var dt = new Dictionary <string, string>(); dt.Add("@deviceId", deviceId); var method = new CReader <AirCondtionCmd>(Connection.YZK); var data = method.GetOrgRecord(dt, "AirCondtionCmdGetByDeviceId"); if (data.Count > 0) { return(data[0]); } return(null); }
/// <summary> /// 根据uid 获取账户信息 /// </summary> /// <param name="uid"></param> /// <returns></returns> public static YZKUser YZKUser_GetByuid(string uid) { /* * create proc YZKUser_Getbyuserid * @userid varchar(50) * as * select * from YZKUser where userid=@userid * */ var readmethod = new CReader <YZKUser>(Connection.YZK); var dt = new Dictionary <string, string>(); dt.Add("@userid", uid); var data = readmethod.GetOrgRecord(dt, "YZKUser_Getbyuserid"); if (data != null && data.Count > 0) { return(data[0]); } return(null); }
public static DefenseStatus DefenseStatusGetByDeviceId(int deviceinfo_userinfo_id) { /* * create proc DefenseStatus_GetStatusByDeviceID * @deviceinfo_userinfo_id int * as * select * from DefenseStatus where homeId in(select homeId from YZKDeviceInfo_UserInfo * where deviceinfo_userinfo_id=@deviceinfo_userinfo_id) * */ var dt = new Dictionary <string, string>(); dt.Add("@deviceinfo_userinfo_id", deviceinfo_userinfo_id + ""); var method = new CReader <DefenseStatus>(Connection.YZK); var data = method.GetOrgRecord(dt, "DefenseStatus_GetStatusByDeviceID"); if (data.Count > 0) { return(data[0]); } return(null); }
/// <summary> /// 根据mac地址获取 macIPInfo /// </summary> /// <param name="mac"></param> /// <returns></returns> public static MacIPInfo MacIPInfo_GetInfoByMac(string mac) { /* * use YZK * go * create proc MacIPInfo_GetDatabymac * @mac varchar(50) * as * select * from MacIPInfo where mac=@mac * */ var dt = new Dictionary <string, string>(); dt.Add("@mac", mac); var method = new CReader <MacIPInfo>(Connection.YZK); var data = method.GetOrgRecord(dt, "MacIPInfo_GetDatabymac"); if (data.Count > 0) { return(data[0]); } return(null); }