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