/// <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); }