public ActionResult getrecord(int pagesize, int pageno, int? mid, string name, string begintime, string endtime) { try { MachineDAL dal = new MachineDAL(); TemperatureRecordDAL trDAL = new TemperatureRecordDAL(); MachineModel model = dal.QuerySingle(" id=" + mid.TryParseInt()); IList<TemperatureRecordModel> list = new List<TemperatureRecordModel>(); int record = 0; string where = " 1=1"; if (!name.IsNullOrEmpty()) where += " and (MachineName like'%" + name + "%' or MachineCode like'%" + name + "%')"; else if (model != null) { where += " and MachineID=" + model.ID; } if (begintime.TryParseDateTime() > DateTime.MinValue) where += " and addtime>='" + begintime + "'"; if (endtime.TryParseDateTime() > DateTime.MinValue) where += " and addtime<'" + endtime.TryParseDateTime().AddDays(1) + "'"; list = trDAL.QuerySQL(pagesize, pageno, out record, where, "AddTime desc"); if (list != null && list.Count > 0) return Content(true.ToResult(record.ToString(), list).ToJsonString()); else return Content(false.ToResult("没有查询到任何数据").ToJsonString()); } catch (Exception ex) { Log.Default.Error(ex); return Content(false.ToResult("网络异常,请稍后重试").ToJsonString()); } }
public string TemperatureRecord(JObject obj) { MachineDAL machineDAL = new MachineDAL(); MachineModel machine = machineDAL.QuerySingle(" MachineCode='" + obj["mc"].ToString() + "'"); if (machine != null && machine.ID > 0) { TemperatureRecordModel model = new TemperatureRecordModel(); model.MachineName = machine.MachineName; model.AddTime = DateTime.Now; model.MachineCode = obj["mc"].TryParseString(); model.Temperature = obj["tt"].TryParseDecimal(8); model.Longitude = obj["lon"].TryParseDecimal(10); model.Latitude = obj["lat"].TryParseDecimal(10); model.RemainingPower = obj["rp"].TryParseDecimal(2); model.WorkingMode = obj["wm"].TryParseString(); model.SignalStrength = obj["ss"].TryParseString(); model.IP = obj["ip"].TryParseString(); model.Port = obj["port"].TryParseInt(); model.WorkingFrequency = obj["wf"].TryParseString(); TemperatureRecordDAL dal = new TemperatureRecordDAL(); dal.InsertSQL(model); SystemConfigDAL conDAL = new SystemConfigDAL(); SystemConfigModel conMinModel = conDAL.QuerySingle(" ConfigKey='TemperatureMinValue'"); SystemConfigModel conMaxModel = conDAL.QuerySingle(" ConfigKey='TemperatureMaxValue'"); if ((conMinModel != null && model.Temperature < conMinModel.ConfigValue.TryParseDecimal()) || (conMaxModel != null && model.Temperature > conMaxModel.ConfigValue.TryParseDecimal())) { SystemConfigModel conMobile = conDAL.QuerySingle(" ConfigKey='TemperatureMobile'"); SystemConfigModel conContent = conDAL.QuerySingle(" ConfigKey='SMSTemperatureTemplate'"); if (conMobile != null && !conMobile.ConfigValue.IsNullOrEmpty() && conContent != null && !conContent.ConfigValue.IsNullOrEmpty()) { foreach (string mobile in conMobile.ConfigValue.Split(',')) { string content = string.Format(conContent.ConfigValue, model.MachineCode, model.Temperature); StringBuilder sbTemp = new StringBuilder(); string url = "http://api.sms.cn/mtutf8/"; string data = "uid=" + ConfigurationManager.AppSettings["SMSUserName"] + "&pwd=" + ConfigurationManager.AppSettings["SMSPassword"] + "&mobile=" + mobile + "&content=" + Server.UrlEncode(content); sbTemp.Append(data); byte[] bTemp = System.Text.Encoding.GetEncoding("GBK").GetBytes(sbTemp.ToString()); string res = doPostRequest(url, bTemp); Log.Default.Debug("温度短信报警:" + res); } } } return true.ToResult().ToJsonString(); } return false.ToResult("后台无此机器码").ToJsonString(); }
public ActionResult index() { TemperatureRecordDAL dal = new TemperatureRecordDAL(); try { List<TemperatureRecordModel> list = dal.GetIndexList(" 1=1"); if (list != null) ViewBag.list = list; } catch (Exception ex) { Log.Default.Error(ex); } return View(); }