/// <summary> /// 判断接口数据是否存在于PointCfg和GatItem里 /// 如果不存在就显示灰色(根据DataGatherId来判断) /// 最后都保存到PointCfgItem /// </summary> /// <param name="zid">桩id</param> /// <param name="listItem">接口数据项</param> /// <returns></returns> public static List <PointCfgItem> IsHavePointCfgAndGatItemTable(int zid, List <Items> listItem) { var gatItemBll = new GatItemBll(); var listCfg = new List <PointCfgItem>(); var dt = gatItemBll.FindByItemName(zid); if (dt.Rows.Count <= 0 || listItem == null) { return(null); } var list = ConvertHelper <GatItem> .ConvertToList(dt); foreach (var items in list) //这是表gat_item里面的值(要全部显示) { var pointCfgItem = new PointCfgItem(); const string isItemShowColor = "gray"; foreach (var itemse in listItem)//这里接口里的值 { if (itemse.DataItemId != items.ITEMNO) { continue; } pointCfgItem.DataGatherId = itemse.DataGatherId; break; } pointCfgItem.ItemNo = items.ITEMNO; pointCfgItem.ItemName = items.ITEMNAME; pointCfgItem.IsItemShowColor = isItemShowColor; listCfg.Add(pointCfgItem); } return(listCfg); }
/// <summary> /// 获取采集项(复杂sql查询) /// </summary> /// <param name="context"></param> /// <returns></returns> private string GetItem(HttpContext context) { string ret = null; var message = new JsonMessage <GatItem>(); var gatItemBll = new GatItemBll(); var id = context.Request.Params["zhuanid"]; if (string.IsNullOrEmpty(id)) { return(ret); } var zhuanid = int.Parse(id); try { var dt = gatItemBll.FindByItemName(zhuanid); var list = ConvertHelper <GatItem> .ConvertToList(dt); message.Rows = list; message.Status = 1; message.Msg = "返回成功"; message.JsExecuteMethod = "ajaxSuccess_responseBtnHtml"; ret = _jss.Serialize(message); } catch (Exception e) { Log.Error(e); } return(ret); }
/// <summary> /// 获取电压表的值和范围 /// </summary> /// <param name="ztype">桩类型</param> /// <param name="itemsList">接口数据项</param> /// <returns></returns> public static Voltage GetVoltage(string ztype, List <Items> itemsList) { var gatItemBll = new GatItemBll(); var pointCfgBll = new PointCfgBll(); var voltage = new Voltage(); DataTable dtVoltage; foreach (var itemse in itemsList) { dtVoltage = gatItemBll.FindByCurrentAndVoltage("电压", itemse.DataItemId); if (dtVoltage.Rows.Count <= 0) { continue; } if (itemse.Value == null) { continue; } voltage.ItemNo = itemse.DataItemId; voltage.VoltagePointer = itemse.Value; voltage.VoltageTime = itemse.GatDt; break;//只要查到一个有值就可以了 } dtVoltage = pointCfgBll.FindByEffectiveAndThreshold(voltage.ItemNo, ztype); if (dtVoltage.Rows.Count <= 0) { return(voltage); } try { if (!string.IsNullOrEmpty(dtVoltage.Rows[0]["Eff_Max"].ToString())) { voltage.VoltageEffectiveMax = decimal.Parse(dtVoltage.Rows[0]["Eff_Max"].ToString()); } if (!string.IsNullOrEmpty(dtVoltage.Rows[0]["Eff_Min"].ToString())) { voltage.VoltageEffectiveMin = decimal.Parse(dtVoltage.Rows[0]["Eff_Min"].ToString()); } if (!string.IsNullOrEmpty(dtVoltage.Rows[0]["LimitMax"].ToString())) { voltage.VoltageThresholdMax = decimal.Parse(dtVoltage.Rows[0]["LimitMax"].ToString()); } if (!string.IsNullOrEmpty(dtVoltage.Rows[0]["LimitMin"].ToString())) { voltage.VoltageThresholdMin = decimal.Parse(dtVoltage.Rows[0]["LimitMin"].ToString()); } } catch (Exception) { throw; } return(voltage); }
/// <summary> /// 获取电流的值和范围 /// </summary> /// <param name="ztype">桩类型</param> /// <param name="itemsList">接口数据项</param> /// <returns></returns> public static Current GetCurrent(string ztype, List <Items> itemsList) { var gatItemBll = new GatItemBll(); var pointCfgBll = new PointCfgBll(); var current = new Current(); DataTable dtCurrent; foreach (var itemse in itemsList) { dtCurrent = gatItemBll.FindByCurrentAndVoltage("电流", itemse.DataItemId); if (dtCurrent.Rows.Count <= 0) { continue; } if (itemse.Value == null) { continue; } current.ItemNo = itemse.DataItemId; current.CurrentPointer = itemse.Value; current.CurrentTime = itemse.GatDt; break;//只要查到一个有值就可以了(值为空就继续查,不为空就跳出) } dtCurrent = pointCfgBll.FindByEffectiveAndThreshold(current.ItemNo, ztype); if (dtCurrent.Rows.Count <= 0) { return(current); } try { if (!string.IsNullOrEmpty(dtCurrent.Rows[0]["Eff_Max"].ToString())) { current.CurrentEffectiveMax = decimal.Parse(dtCurrent.Rows[0]["Eff_Max"].ToString()); } if (!string.IsNullOrEmpty(dtCurrent.Rows[0]["Eff_Min"].ToString())) { current.CurrentEffectiveMin = decimal.Parse(dtCurrent.Rows[0]["Eff_Min"].ToString()); } if (!string.IsNullOrEmpty(dtCurrent.Rows[0]["LimitMax"].ToString())) { current.CurrentThresholdMax = decimal.Parse(dtCurrent.Rows[0]["LimitMax"].ToString()); } if (!string.IsNullOrEmpty(dtCurrent.Rows[0]["LimitMin"].ToString())) { current.CurrentThresholdMin = decimal.Parse(dtCurrent.Rows[0]["LimitMin"].ToString()); } } catch (Exception) { throw; } return(current); }
/// <summary> /// 获取采集项(单纯query方法) /// </summary> /// <param name="context"></param> /// <returns></returns> private string QueryItemsName(HttpContext context) { string ret = null; var message = new JsonMessage <Dictionary <string, string> >(); var gatItemBll = new GatItemBll(); var id = context.Request.Params["itemid"]; var list = new List <Dictionary <string, string> >(); if (string.IsNullOrEmpty(id)) { return(ret); } var idlist = id.Split('|'); try { foreach (var s in idlist) { var listItem = new Dictionary <string, string>(); var gatItem = new GatItem() { ITEMNO = s }; var dt = gatItemBll.Query(gatItem); if (dt.Rows.Count <= 0) { continue; } var name = dt.Rows[0]["itemname"].ToString(); listItem.Add(s, name); list.Add(listItem); } //var list = ConvertHelper<GatItem>.ConvertToList(dt); //var list = _jss.Serialize(listItem); message.Rows = list; message.Status = 1; message.Msg = "返回成功"; message.JsExecuteMethod = "ajaxSuccess_remoteAjaxSuccess_setCurrentTimeInfo"; ret = _jss.Serialize(message); } catch (Exception e) { Log.Error(e); } return(ret); }
/// <summary> /// 加载数据项 /// </summary> /// <param name="context"></param> /// <returns></returns> private string GetSjx(HttpContext context) { string dataType = context.Request["datatype"] ?? ""; if (dataType.ToUpper().Equals(Constant.SjlxYx)) { dataType = Constant.SjlxYx; } else if (dataType.ToUpper().Equals(Constant.SjlxYc)) { dataType = Constant.SjlxYc; } else { } string zhuangxing_h = context.Request["zhuangxing_h"] ?? ""; GatItemBll gatItemBll = new GatItemBll(); DataTable dt = gatItemBll.QuerySjxNotUse(dataType, zhuangxing_h); var list = ConvertHelper <GatItem> .ConvertToList(dt); return(_jss.Serialize(list)); }