/// <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>
/// 删除数据项，并且根据数据类型返回遥测或者遥信数据项配置列表
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string SjxDel(HttpContext context)
{
try
{
string sjlx = context.Request["sjlx"] ?? "";
string id = context.Request["id"] ?? "";
//删除
PointCfgBll pointCfgBll = new PointCfgBll();
pointCfgBll.Del(new PointCfg()
{
Id = id
});
//操作日志
string name = "";
if (null != context.Session[Constant.LoginUser])
{
name = (context.Session[Constant.LoginUser] as Employer ?? new Employer()).Name;
}
else
{
return("{\"total\":0,\"rows\":[],\"status\":\"2\",\"msg\":\"修改成功！\"}");
}
new OprLogBll().Add(new OprLog()
{
Operator = name,
OprSrc = "删除数据项配置，ID：" + id,
OperResult = "成功",
LogDate = DateTime.Now
});
//查询
if (sjlx.ToUpper().Equals(Constant.SjlxYc))
{
return(GetYcxData(context));
}
else if (sjlx.ToUpper().Equals(Constant.SjlxYx))
{
return(GetYxxData(context));
}
else
{
return(ErrorJson);
}
}
catch (Exception e)
{
Log.Error("SjxDel出错：" + e);
return(ErrorJson);
}
}
/// <summary>
/// 获取数据项配置
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string GetSjxpz(HttpContext context)
{
try
{
PointCfgBll pointCfgBll = new PointCfgBll();
string id = context.Request["id"] ?? "";
PointCfg pointCfg = pointCfgBll.QueryEntity(new PointCfg()
{
Id = id
});
return(_jss.Serialize(pointCfg));
}
catch (Exception e)
{
Log.Error("GetSjxpz出错：" + e);
return(ErrorJson);
}
}
/// <summary>
/// 获取遥信项数据
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string GetYxxData(HttpContext context)
{
try
{
PointCfgBll pointCfgBll = new PointCfgBll();
int page = int.Parse(context.Request["page"] ?? "1");
int rows = int.Parse(context.Request["rows"] ?? "10");
string xh = context.Request["xh"] ?? "";
string sjx = context.Request["sjx"] ?? "";
int count = 0;
DataTable dt = pointCfgBll.QueryBySjlx(Constant.SjlxYx, xh, sjx, page, rows, ref count);
List <PointCfg> list = ConvertHelper <PointCfg> .ConvertToList(dt);
PageObject <PointCfg> pObject = new PageObject <PointCfg>(count, list);
return(_jss.Serialize(pObject));
}
catch (Exception e)
{
Log.Error("GetYxxData方法出错：" + e);
return(ErrorJson);
}
}
