using Dapper;
|
using Hydro.CommonBase;
|
using MetroFramework;
|
using Newtonsoft.Json;
|
using Newtonsoft.Json.Linq;
|
using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Linq;
|
|
namespace Hydro.ConfigModel
|
{
|
public class LogicPoint
|
{
|
public dict<string, dynamic> History = null;
|
public static dict<string, dynamic> Compare(LogicPoint host1, LogicPoint host2,out bool Sameflag,out bool Sameflag_Calc)
|
{
|
dict<string,dynamic> di=new dict<string, dynamic>();
|
Sameflag = true;
|
Sameflag_Calc = true;
|
//比较host1和host2的所有属性,并记录不同的属性，按照以下格式记录："属性名(old)":host1的属性值(old) "属性名(new)":host2的属性值(new)，如果属性值相同，则不记录，例如：di.Add("Name (old)", host1.Name.ToString()); di.Add("Name (new)", host2.Name.ToString());
|
|
|
|
if (host1.Name != host2.Name) { Sameflag_Calc=Sameflag = false; di.Add("Name (old)", host1.Name); di.Add("Name (new)", host2.Name); }
|
if (host1.LogicType != host2.LogicType) { Sameflag_Calc = Sameflag = false; di.Add("LogicType (old)", host1.LogicType); di.Add("LogicType (new)", host1.LogicType); }
|
if (host1.ExpressionType != host2.ExpressionType) { Sameflag_Calc = Sameflag = false; di.Add("ExpressionType (old)", host1.ExpressionType); di.Add("ExpressionType (new)", host2.ExpressionType); }
|
if (host1.IndicatorType != host2.IndicatorType) { Sameflag_Calc = Sameflag = false; di.Add("IndicatorType (old)", host1.IndicatorType); di.Add("IndicatorType (new)", host2.IndicatorType); }
|
if (host1.ModelObjectID != host2.ModelObjectID) { Sameflag_Calc = Sameflag = false; di.Add("ModelObjectID (old)", host1.ModelObjectID); di.Add("ModelObjectID (new)", host2.ModelObjectID); }
|
//if (host1.Sort != host2.Sort) { flag = false; di.Add("Sort", host1.Sort); }
|
if (host1.ParentId != host2.ParentId) { Sameflag_Calc = Sameflag = false; di.Add("ParentId (old)", host1.ParentId); di.Add("ParentId (new)", host2.ParentId); }
|
if (host1.Expression != host2.Expression) { Sameflag_Calc = Sameflag = false; di.Add("Expression (old)", host1.Expression); di.Add("Expression (new)", host2.Expression); }
|
|
|
//if (!isShowVisual)
|
//{
|
|
//}
|
//else
|
//{
|
// host1.ExtJson=JsonConvert.SerializeObject(host1.Ext);
|
// host2.ExtJson=JsonConvert.SerializeObject(host2.Ext);
|
// if (host1.ExtJson != host2.ExtJson) { Sameflag = false; di.Add("ExtJson (old)", host1.ExtJson); di.Add("ExtJson (new)", host2.ExtJson); }
|
//}
|
if (host1.ObjectType != host2.ObjectType) { Sameflag_Calc = Sameflag = false; di.Add("ObjectType (old)", host1.ObjectType); di.Add("ObjectType (new)", host2.ObjectType); }
|
if (host1.accurary != host2.accurary) { Sameflag_Calc = Sameflag = false; di.Add("accurary (old)", host1.accurary); di.Add("accurary (new)", host2.accurary); }
|
if (host1.childSolution != host2.childSolution) { Sameflag_Calc = Sameflag = false; di.Add("childSolution (old)", host1.childSolution); di.Add("childSolution (new)", host2.childSolution); }
|
if (host1.childTag != host2.childTag) { Sameflag_Calc = Sameflag = false; di.Add("childTag (old)", host1.childTag); di.Add("childTag (new)", host2.childTag); }
|
if (host1.childType != host2.childType) { Sameflag_Calc = Sameflag = false; di.Add("childType (old)", host1.childType); di.Add("childType (new)", host2.childType); }
|
if (host1.SaveAcc != host2.SaveAcc) { Sameflag_Calc = Sameflag = false; di.Add("SaveAcc (old)", host1.SaveAcc); di.Add("SaveAcc (new)", host2.SaveAcc); }
|
if (host1.isSave != host2.isSave) { Sameflag_Calc = Sameflag = false; di.Add("isSave (old)", host1.isSave); di.Add("isSave (new)", host2.isSave); }
|
if (host1.SaveRange != host2.SaveRange) { Sameflag_Calc = Sameflag = false; di.Add("SaveRange (old)", host1.SaveRange); di.Add("SaveRange (new)", host2.SaveRange); }
|
if (host1.isMemSave != host2.isMemSave) { Sameflag_Calc = Sameflag = false; di.Add("isMemSave (old)", host1.isMemSave); di.Add("isMemSave (new)", host2.isMemSave); }
|
if (host1.MemSaveRange != host2.MemSaveRange) { Sameflag_Calc = Sameflag = false; di.Add("MemSaveRange (old)", host1.MemSaveRange); di.Add("MemSaveRange (new)", host2.MemSaveRange); }
|
if (host1.MemSaveAcc != host2.MemSaveAcc) { Sameflag_Calc = Sameflag = false; di.Add("MemSaveAcc (old)", host1.MemSaveAcc); di.Add("MemSaveAcc (new)", host2.MemSaveAcc); }
|
if (host1.MemSaveIndex != host2.MemSaveIndex) { Sameflag_Calc = Sameflag = false; di.Add("MemSaveIndex (old)", host1.MemSaveIndex); di.Add("MemSaveIndex (new)", host2.MemSaveIndex); }
|
if (host1.Enable != host2.Enable) { Sameflag_Calc = Sameflag = false; di.Add("Enable (old)", host1.Enable); di.Add("Enable (new)", host2.Enable); }
|
if (host1.Tag != host2.Tag) { Sameflag_Calc = Sameflag = false; di.Add("Tag (old)", host1.Tag); di.Add("Tag (new)", host2.Tag); }
|
|
|
if (host1.Prefer != host2.Prefer) { Sameflag = false; di.Add("Prefer (old)", host1.Prefer); di.Add("Prefer (new)", host2.Prefer); }
|
if (host1.Visible != host2.Visible) { Sameflag = false; di.Add("Visible (old)", host1.Visible); di.Add("Visible (new)", host2.Visible); }
|
if (host1.isUseCustomColor != host2.isUseCustomColor) { Sameflag = false; di.Add("isUseCustomColor (old)", host1.isUseCustomColor); di.Add("isUseCustomColor (new)", host2.isUseCustomColor); }
|
if (host1.ContentColor != host2.ContentColor) { Sameflag = false; di.Add("ContentColor (old)", host1.ContentColor); di.Add("ContentColor (new)", host2.ContentColor); }
|
|
|
|
return di;
|
|
}
|
public static string selectColumn = "Id, Name, LogicType, ExpressionType, IndicatorType, ModelObjectID, Sort, ParentId, Expression, ExtJson";
|
public void updateByhost(LogicPoint host,bool OnlyUpdateShowProperty)
|
{
|
|
if (!OnlyUpdateShowProperty)
|
{
|
//更新host的所有属性到当前对象
|
this.Name = host.Name;
|
this.LogicType = host.LogicType;
|
this.ExpressionType = host.ExpressionType;
|
this.IndicatorType = host.IndicatorType;
|
this.ModelObjectID = host.ModelObjectID;
|
this.Sort = host.Sort;
|
this.ParentId = host.ParentId;
|
this.Expression = host.Expression;
|
|
|
//host.ExtJson = JsonConvert.SerializeObject(host.Ext);
|
//this.ExtJson = host.ExtJson;
|
//this._ext = null;
|
|
this.accurary = host.accurary;
|
this.childSolution = host.childSolution;
|
this.childTag = host.childTag;
|
this.childType = host.childType;
|
this.SaveAcc = host.SaveAcc;
|
this.isSave = host.isSave;
|
this.SaveRange = host.SaveRange;
|
this.isMemSave = host.isMemSave;
|
this.MemSaveRange = host.MemSaveRange;
|
this.MemSaveAcc = host.MemSaveAcc;
|
this.MemSaveIndex = host.MemSaveIndex;
|
this.Enable = host.Enable;
|
this.Tag = host.Tag;
|
this.ObjectType = host.ObjectType;
|
this.VPN = host.VPN;
|
}
|
|
|
|
|
this.Visible = host.Visible;
|
this.Prefer = host.Prefer;
|
this.isUseCustomColor = host.isUseCustomColor;
|
this.ContentColor = host.ContentColor;
|
|
this.ExtJson = JsonConvert.SerializeObject(this.Ext);
|
//this.ExtJson = host.ExtJson;
|
|
|
}
|
|
public int saveToDb(Db Db, bool delete = false, bool isSetID = true, bool isEdit = true, bool onlyUpdateShowProperty = false)
|
{
|
var host = this;
|
host.ExtJson = JsonConvert.SerializeObject(host.Ext);
|
int Exec_Num = 0;
|
if (!delete)
|
{
|
if (isEdit)
|
{
|
if (onlyUpdateShowProperty)
|
{
|
//只更新显示属性，将原LogicPoint查询出来，然后更新显示属性
|
var host0 = ((List<LogicPoint>)Db.Connection.Query<LogicPoint>(
|
$"SELECT {LogicPoint.selectColumn} FROM RemoteHost WHERE Id={host.Id}"))[0];
|
host0.updateByhost(host, true);
|
host = host0;
|
}
|
|
Exec_Num = Db.Connection.Execute(
|
@"UPDATE RemoteHost SET Name=@Name,LogicType=@LogicType,ExpressionType=@ExpressionType,IndicatorType=@IndicatorType,ModelObjectID=@ModelObjectID,Sort=@Sort,ParentId=@ParentId,
|
Expression=@Expression,ExtJson=@ExtJson,VPN=@VPN WHERE Id=" + host.Id, host);
|
|
}
|
|
if (Exec_Num == 0)//没有成功更新，则插入
|
{
|
if (isSetID)
|
{
|
Exec_Num = Db.Connection.Execute(
|
@"INSERT INTO RemoteHost(Id,Name,LogicType,ExpressionType,IndicatorType,ModelObjectID,Sort,ParentId,Expression,ExtJson,VPN)
|
VALUES(@Id,@Name,@LogicType,@ExpressionType,@IndicatorType,@ModelObjectID,@Sort,@ParentId,@Expression,@ExtJson,@VPN)",
|
host);
|
return host.Id;
|
}
|
else
|
{
|
Exec_Num = Db.Connection.Execute(
|
@"INSERT INTO RemoteHost(Name,LogicType,ExpressionType,IndicatorType,ModelObjectID,Sort,ParentId,Expression,ExtJson,VPN)
|
VALUES(@Name,@LogicType,@ExpressionType,@IndicatorType,@ModelObjectID,@Sort,@ParentId,@Expression,@ExtJson,@VPN)",
|
host);
|
var ids = (List<int>)Db.Connection.Query<int>(
|
$"SELECT Max(Id) FROM RemoteHost");
|
host.Id = ids[0];
|
return host.Id;
|
}
|
|
}
|
return host.Id;
|
}
|
else
|
{
|
Db.Connection.Execute("DELETE FROM RemoteHost WHERE Id=" + host.Id, " VACUUM");
|
return 0;
|
}
|
return host.Id;
|
|
|
}
|
public void UpdateByOldVersion()
|
{
|
var host = this;
|
if (host.LogicType == "集合")
|
{
|
List<string> list = new List<string>() { "最大值", "最小值", "平均值", "累计值", "计数" };
|
if (list.IndexOf(host.ExpressionType) >= 0)
|
{
|
host.accurary = host.ExpressionType;
|
host.ExpressionType = "集合计算";
|
}
|
}
|
}
|
public static List<string> Columns
|
{
|
get
|
{
|
return selectColumn.Split(',').Select(item => item.Trim()).ToList();
|
}
|
set {
|
selectColumn = string.Concat(value, ',');
|
}
|
}
|
[DisplayName("编号")]
|
[Category("基本信息")]
|
public int Id { get; set; }
|
[DisplayName("名称")]
|
[Category("基本信息")]
|
public string Name { get; set; }
|
/// <summary>
|
/// 逻辑类型
|
/// </summary>
|
[DisplayName("类型")]
|
[Category("基本信息")]
|
public string LogicType { get; set; }
|
/// <summary>
|
/// 数据来源类型（接口值、基准值、计算值、变化值、初始计算值、最小、最大、∈、∉）
|
/// </summary>
|
[DisplayName("数据来源")]
|
[Category("计算参数")]
|
public string ExpressionType { get; set; }
|
/// <summary>
|
/// 数值表达式（接口值、基准值）
|
/// </summary>
|
[DisplayName("值")]
|
[Category("计算参数")]
|
public string Expression { get; set; }
|
|
private string _fullAddress;
|
[Browsable(false)]
|
public string FullAddress => _fullAddress ?? (_fullAddress = ExpressionType == "3389" ? LogicType : $"{LogicType}:{ExpressionType}");
|
[Browsable(false)]
|
public string ExpressionToShow
|
{
|
get
|
{
|
if (ExpressionType == null) return null;
|
if (ExpressionType.IndexOf("接口") >= 0 )
|
{
|
return ExpressionType + " " + Expression;
|
}
|
else if (ExpressionType.IndexOf("基准值") >= 0 || ExpressionType.IndexOf("计算值") >= 0 || ExpressionType.IndexOf("变化值") >= 0 || ExpressionType.IndexOf("初始计算值") >= 0)
|
{
|
return ExpressionType + " " + Expression;
|
}
|
else if (ExpressionType.IndexOf("值") >= 0 || ExpressionType.IndexOf("系数") >= 0)
|
{
|
return ExpressionType;
|
}
|
else
|
{
|
return $"{ExpressionType} " + (ExpressionType == "∈" ? $"[{Expression}] ▲{accurary}" : (ExpressionType == "最小" || ExpressionType == "最大" ? $"| 容许范围[{Expression}]" : Expression));
|
}
|
}
|
}
|
[DisplayName("监测类型")]
|
[Category("基本信息")]
|
public string IndicatorType { get; set; }
|
[DisplayName("模型编号或内容")]
|
[Category("计算参数")]
|
public string ModelObjectID { get; set; }
|
[DisplayName("排序")]
|
[Category("其他")]
|
public int Sort { get; set; }
|
[DisplayName("父节点编号")]
|
[Category("其他")]
|
public int ParentId { get; set; }
|
|
[Browsable(false)]
|
public string ExtJson { get; set; } = "";
|
|
private HostExt _ext;
|
[Browsable(false)]
|
public HostExt Ext
|
{
|
get
|
{
|
if (_ext == null)
|
{
|
try
|
{
|
_ext = JsonConvert.DeserializeObject<HostExt>(ExtJson);
|
if (_ext == null) _ext = new HostExt();
|
return _ext;
|
}
|
catch
|
{
|
return (_ext=new HostExt());
|
}
|
|
}
|
else
|
return _ext;// ??
|
}
|
|
}
|
|
[Browsable(false)]
|
public byte[] VPN { get; set; } = null;
|
[DisplayName("结果")]
|
[Category("计算参数")]
|
public string Result
|
{
|
get
|
{
|
string result = null;
|
if (Ext==null || Ext.Result_Arr == null)
|
{
|
return "-";
|
}
|
int 小数位数 = Ext.小数位数;
|
if (Ext.ResultShowType==0)
|
{
|
|
|
|
if (LogicType=="试算参数" )
|
{
|
try
|
{
|
var arr = Expression.Split(',').Select(v => Convert.ToDouble(v)).ToArray();
|
var range = new DRange(arr[0], arr[1]);
|
var accuracy = double.Parse(accurary);
|
result = getFormat(getRoundByAccuracy(Ext.Result_Arr[Ext.Period], range,accuracy));
|
}
|
catch
|
{
|
result = "-";
|
}
|
|
}
|
else
|
if ( Ext.Result_Arr.Length> Ext.Period && !double.IsNaN( Ext.Result_Arr[Ext.Period]))
|
{
|
result= getFormat(Math.Round(Ext.Result_Arr[Ext.Period],小数位数));
|
}
|
else
|
{
|
result= "-";
|
}
|
}
|
else if (Ext.ResultShowType == 1)
|
{
|
int LengthLimit = 16; //GlobalConfig.LengthLimit??16;
|
|
string txt = Ext.Result_Arr.ToList().Select(v0 => getFormat(Math.Round( v0, 小数位数))).Aggregate((a, b) => a + "," + b);
|
//最长保留16个字符
|
if (txt.Length > LengthLimit) txt = txt.Substring(0, LengthLimit) + "...";
|
result= txt;
|
}
|
|
if (Ext.bestObj!=null)
|
{
|
result += Ext.bestObj;
|
}
|
return result;
|
|
}
|
}
|
private double getRoundByAccuracy(double v, DRange range, double accuracy)
|
{
|
//精度为accuracy的倍数，且在range范围内，最小值为range.Min，取最接近v的值
|
if (accuracy == 0) return v;
|
if (v < range.Min) return range.Min;
|
if (v > range.Max) v=range.Max;
|
|
var delta = v - range.Min;
|
//比较v - delta % accuracy和v+accuracy-delta % accuracy哪个接近v，且在range范围内
|
double value = 0;
|
if (delta % accuracy>accuracy/2)
|
{
|
value = v + accuracy - delta % accuracy;
|
}
|
else
|
{
|
value = v - delta % accuracy;
|
}
|
return Math.Round(value,5);
|
//return v - delta % accuracy;
|
}
|
private string getFormat(double value)
|
{
|
if (Ext.ResultFormat == null) return value.ToString();
|
if (Ext.ResultFormat.ContainsKey(value))
|
{
|
return Ext.ResultFormat[value];
|
}
|
else
|
{
|
return value.ToString();
|
}
|
}
|
|
public string objListString = null;
|
|
public string Text_change = null;
|
|
[DisplayName("对象名称")]
|
[Category("基本信息")]
|
public string ObjectType
|
{
|
get { return this.Ext.ObjectType; }
|
set { this.Ext.ObjectType = value; }
|
}
|
[DisplayName("精度")]
|
[Category("计算参数")]
|
public string accurary
|
{
|
get { return this.Ext.accurary; }
|
set { this.Ext.accurary = value; }
|
}
|
[DisplayName("子方案名称")]
|
[Category("子方案")]
|
public string childSolution
|
{
|
get { return this.Ext.childSolution; }
|
set { this.Ext.childSolution = value; }
|
}
|
[DisplayName("子方案键")]
|
[Category("子方案")]
|
public string childTag
|
{
|
get { return this.Ext.childTag; }
|
set { this.Ext.childTag = value; }
|
}
|
[DisplayName("子方案传输")]
|
[Category("子方案")]
|
public string childType
|
{
|
get { return this.Ext.childType; }
|
set { this.Ext.childType = value; }
|
}
|
[DisplayName("子搜索精度")]
|
[Category("子方案")]
|
public string SaveAcc
|
{
|
get { return this.Ext.SaveAcc; }
|
set { this.Ext.SaveAcc = value; }
|
}
|
[DisplayName("是否存储")]
|
[Category("子方案")]
|
public string isSave
|
{
|
get { return this.Ext.isSave; }
|
set { this.Ext.isSave = value; }
|
}
|
[DisplayName("存储键值")]
|
[Category("子方案")]
|
public string SaveRange
|
{
|
get { return this.Ext.SaveRange; }
|
set { this.Ext.SaveRange = value; }
|
}
|
|
[DisplayName("是否内存存储")]
|
[Category("子方案")]
|
public string isMemSave
|
{
|
get { return this.Ext.isMemSave; }
|
set { this.Ext.isMemSave = value; }
|
}
|
[DisplayName("内存存储范围")]
|
[Category("子方案")]
|
public string MemSaveRange
|
{
|
get { return this.Ext.MemSaveRange; }
|
set { this.Ext.MemSaveRange = value; }
|
}
|
[DisplayName("内存存储精度")]
|
[Category("子方案")]
|
public string MemSaveAcc
|
{
|
get { return this.Ext.MemSaveAcc; }
|
set { this.Ext.MemSaveAcc = value; }
|
}
|
[DisplayName("内存存储次序")]
|
[Category("子方案")]
|
public string MemSaveIndex
|
{
|
get { return this.Ext.MemSaveIndex; }
|
set { this.Ext.MemSaveIndex = value; }
|
}
|
[DisplayName("启用")]
|
[Category("基本信息")]
|
public bool Enable
|
{
|
get { return this.Ext.Enable; }
|
set { this.Ext.Enable = value; }
|
}
|
|
[DisplayName("可见性")]
|
[Category("基本信息")]
|
public bool Visible
|
{
|
get { return this.Ext.Visible; }
|
set { this.Ext.Visible = value; }
|
}
|
[DisplayName("标签")]
|
[Category("基本信息")]
|
public string Tag
|
{
|
get { return this.Ext.Tag; }
|
set { this.Ext.Tag = value; }
|
}
|
|
[DisplayName("收藏")]
|
[Category("基本信息")]
|
public bool Prefer
|
{
|
get { return this.Ext.Prefer; }
|
set { this.Ext.Prefer = value; }
|
}
|
[DisplayName("使用自定义色")]
|
[Category("自定义")]
|
public bool isUseCustomColor
|
{
|
get { return this.Ext.isUseCustomColor; }
|
set { this.Ext.isUseCustomColor = value; }
|
}
|
|
[DisplayName("内容色")]
|
[Category("自定义")]
|
public MetroColorStyle_Inner ContentColor
|
{
|
get { return this.Ext.ContentColor; }
|
set { this.Ext.ContentColor = value; }
|
}
|
|
|
}
|
}
|
