/// <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);
}
}
/// <summary>
/// 得到原始的数据数据
/// 时间将不会被转化
/// </summary>
/// <param name="para">参数</param>
/// <param name="procname">存储过程的名称</param>
/// <param name="changeTime">是否将时间转为格林威治时间</param>
/// <returns></returns>
public List <T> GetOrgRecord(Dictionary <string, string> para, string procname)
{
var sp = new SqlParameter[] { };
var lsp = sp.ToList();
if (para != null)
{
foreach (var s in para)
{
var key = s.Key;
if (key.StartsWith("@") == false)
{
lsp.Add(new SqlParameter("@" + key, para[key]));
}
else
{
lsp.Add(new SqlParameter(key, para[key]));
}
}
}
List <T> list = new List <T>();
var db = new CommonDBHelper(conName);
using (var reader = db.getReader(procname, lsp.ToArray()))
{
while (reader.Read())
{
T t = new T();
for (var i = 0; i < reader.FieldCount; i++)
{
var name = reader.GetName(i);
var lowername = name.ToString();
var propertyInfo = t.GetType().GetProperty(name);
try
{
if (propertyInfo != null)
{
///当前列的值
var value = reader.GetValue(i);
var ft = reader.GetFieldType(i);
if (value == DBNull.Value)
{
///int 类型
if (ft == typeof(int) || ft == typeof(double) || ft == typeof(float))
{
propertyInfo.SetValue(t, 0, null);
}
///string 类型
else if (ft == typeof(string))
{
// propertyInfo.SetValue(t, value, null);
propertyInfo.SetValue(t, "", null);
}
else if (ft == typeof(DateTime))
{
propertyInfo.SetValue(t, DateTime.MinValue, null);
}
}
else if (value != DBNull.Value)
{
var ptype = propertyInfo.PropertyType;
if (name.IndexOf("lat") != -1 || name.IndexOf("lng") != -1)
{
}
else
{
if (ft == typeof(double))
{
value = Math.Round((double)value, 2);
}
}
propertyInfo.SetValue(t, value, null);
}
}
}
catch (Exception ex)
{
var msg = name + ex.Message;
throw new Exception(msg);
}
}
list.Add(t);
}
}
return(list);
}
