protected virtual bool TestNotEqual(object[] values)
{
var s = values[0];
var d = values[1];
var r = testEqualFunc(s);
return(!Equ.Al(d, r));
}
public MyObject()
{
equ = new Equ();
LocationInMap = new Point(0, 0);
picName = "";
//if (LocationInMapChangeChanged!=null)
//{
// this.LocationInMapChangeChanged += MyObject_LocationInMapChangeChanged;
//}
}
public List<Equ> GetAllEqus()
{
SqlConnection conn = null;
string strSelect = "SELECT * FROM [Equ]";
try
{
conn = new SqlConnection(SqlHelper.SqlConStr);
conn.Open();
SqlCommand cmd = new SqlCommand(strSelect, conn);
SqlDataReader reader = cmd.ExecuteReader();
List<Equ> equList = new List<Equ>();
while (reader.Read())
{
Equ equ = new Equ {
ID = int.Parse(reader["ID"].ToString()),
secID = reader["secID"].ToString().Trim(),
ticker = reader["ticker"].ToString().Trim(),
exchangeCD = reader["exchangeCD"].ToString().Trim(),
ListSectorCD = reader["ListSectorCD"].ToString().Trim(),
ListSector = reader["ListSector"].ToString().Trim(),
transCurrCD = reader["transCurrCD"].ToString().Trim(),
secShortName = reader["secShortName"].ToString().Trim(),
secFullName = reader["secFullName"].ToString().Trim(),
listStatusCD = reader["listStatusCD"].ToString().Trim(),
listDate = reader["listDate"].ToString().Trim(),
delistDate = reader["delistDate"].ToString().Trim(),
equTypeCD = reader["equTypeCD"].ToString().Trim(),
equType = reader["equType"].ToString().Trim(),
exCountryCD = reader["exCountryCD"].ToString().Trim(),
partyID = reader["partyID"].ToString().Trim(),
totalShares = double.Parse(reader["totalShares"].ToString()),
nonrestFloatShares = double.Parse(reader["nonrestFloatShares"].ToString()),
nonrestfloatA = double.Parse(reader["nonrestfloatA"].ToString()),
officeAddr = reader["officeAddr"].ToString().Trim(),
primeOperating = reader["primeOperating"].ToString().Trim()
};
equList.Add(equ);
}
reader.Close();
return equList;
}
catch
{
return null;
}
finally
{
if (conn != null && conn.State != ConnectionState.Closed)
{
conn.Close();
}
}
}
private void button1_Click(object sender, EventArgs e)
{
string denk = this.denklem_txt.Text;
Equ denklem = new Equ(denk);
kok1.Text = denklem.kok1.ToString();
kok2.Text = denklem.kok2.ToString();
toplami.Text = (denklem.kok1 + denklem.kok2).ToString();
carpimi.Text = (denklem.kok1 * denklem.kok2).ToString();
disk_txt.Text = denklem.delta.ToString();
}
public virtual void OpenObject(XmlNode node)
{
if (equ == null)
{
equ = new Equ();
}
equ.EquID = ((XmlElement)node).GetAttribute("equid");
equtype = (MyObject.ObjectType)Convert.ToInt32(((XmlElement)node).GetAttribute("equtype"));
picName = ((XmlElement)node).GetAttribute("pic");
equ.EquName = ((XmlElement)node).GetAttribute("equName");
equ.PointX = ((XmlElement)node).GetAttribute("pointX");
equ.PointY = ((XmlElement)node).GetAttribute("pointY");
equ.PileNo = ((XmlElement)node).GetAttribute("PileNo");
equ.DirectionID = Convert.ToInt32(((XmlElement)node).GetAttribute("DirectionId"));
equ.Code = ((XmlElement)node).GetAttribute("Code");
equ.AddressDiscribe = ((XmlElement)node).GetAttribute("AddressDiscribe");
equ.AlarmMethod = ((XmlElement)node).GetAttribute("AlarmMethod");
equ.IP = ((XmlElement)node).GetAttribute("IP");
if (!string.IsNullOrEmpty(((XmlElement)node).GetAttribute("Port")))
{
equ.Port = Convert.ToInt32(((XmlElement)node).GetAttribute("Port"));
}
equ.FatherEquID = ((XmlElement)node).GetAttribute("FatherEquID");
if (!string.IsNullOrEmpty(((XmlElement)node).GetAttribute("TaskWV")))
{
equ.TaskWV = Convert.ToInt32(((XmlElement)node).GetAttribute("TaskWV"));
}
if (!string.IsNullOrEmpty(((XmlElement)node).GetAttribute("msgTimeoutSec")))
{
equ.msgTimeoutSec = Convert.ToInt32(((XmlElement)node).GetAttribute("msgTimeoutSec"));
}
equ.Encode = ((XmlElement)node).GetAttribute("Encode");
equ.Note = ((XmlElement)node).GetAttribute("Note");
equ.plcStationAddress = ((XmlElement)node).GetAttribute("plcStationAddress");
equ.Vendor = ((XmlElement)node).GetAttribute("Vendor");
equ.RunMode = ((XmlElement)node).GetAttribute("RunMode");
}
public MyObject()
{
equ = new Equ();
LocationInMap = new PointF(0, 0);
picName = "";
}
public bool Insert(Equ equ)
{
//权宜之计，改为参数化方法会报“将截断字符串或二进制数据”异常，故将’替换成"
if (equ.primeOperating != null)
{
equ.primeOperating = equ.primeOperating.Replace('\'', '\"');
}
SqlConnection conn = null;
string sqlInsert = string.Format("Insert Into Equ([secID],[ticker],[exchangeCD],[ListSectorCD],[ListSector],[transCurrCD],[secShortName],[secFullName],[listStatusCD],[listDate],[delistDate],[equTypeCD],[equType],[exCountryCD],[partyID],[totalShares],[nonrestFloatShares],[nonrestfloatA],[officeAddr],[primeOperating]) Values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}',{15},{16},{17},'{18}','{19}')",
equ.secID, equ.ticker, equ.exchangeCD, equ.ListSectorCD, equ.ListSector, equ.transCurrCD, equ.secShortName, equ.secFullName, equ.listStatusCD, equ.listDate, equ.delistDate ?? string.Empty, equ.equTypeCD, equ.equType, equ.exCountryCD, equ.partyID, equ.totalShares, equ.nonrestFloatShares, equ.nonrestfloatA, equ.officeAddr ?? string.Empty, equ.primeOperating ?? string.Empty);
try
{
conn = new SqlConnection(SqlHelper.SqlConStr);
conn.Open();
SqlCommand cmd = new SqlCommand(sqlInsert, conn);
cmd.ExecuteNonQuery();
return true;
}
catch
{
return false;
}
finally
{
if (conn != null && conn.State != ConnectionState.Closed)
{
conn.Close();
}
}
}
/// <summary>
/// 生成设备json文件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void CreateEquJesonFile_Click(object sender, RoutedEventArgs e)
{
IList <EquType> equTypes = new List <EquType>();
EquType rootType = new EquType()
{
Id = "01", Code = "EquType", Name = "设备类型"
};
EquType dType = new EquType()
{
Id = "0101", Code = "Led", Name = "灯", ParentId = "01"
};
//EquType hdType = new EquType() { Id = "010101", Code = "RedLed", Name = "红灯", ParentId = "0101" };
//EquType ldType = new EquType() { Id = "010102", Code = "GreenLed", Name = "绿灯", ParentId = "0101" };
EquType hwType = new EquType()
{
Id = "0102", Code = "InfraredCorrelation", Name = "红外对射", ParentId = "01"
};
//dType.Child.Add(hdType);
//dType.Child.Add(ldType);
rootType.Child.Add(dType);
rootType.Child.Add(hwType);
equTypes.Add(rootType);
string equTypeJsonStr = JsonConvert.SerializeObject(equTypes);
IList <Equ> equs = new List <Equ>();
Equ zhd = new Equ()
{
EquTypeId = "0101", Name = "左红绿灯", Id = "1", Code = "LeftLed"
};
Equ yhd = new Equ()
{
EquTypeId = "0101", Name = "右红绿灯", Id = "2", Code = "RightLed"
};
//Equ zhd = new Equ() { EquTypeId = "010101", Name = "左红灯", Id = "1", Code = "LeftRedLed" };
//Equ yhd = new Equ() { EquTypeId = "010101", Name = "右红灯", Id = "2", Code = "RightRedLed" };
//Equ zld = new Equ() { EquTypeId = "010102", Name = "左绿灯", Id = "3", Code = "LeftGreenLed" };
//Equ yld = new Equ() { EquTypeId = "010102", Name = "右绿灯", Id = "4", Code = "RightGreenLed" };
Equ zhw = new Equ()
{
EquTypeId = "0102", Name = "左红外", Id = "3", Code = "LeftInfraredCorrelation"
};
Equ yhw = new Equ()
{
EquTypeId = "0102", Name = "右红外", Id = "4", Code = "RightInfraredCorrelation"
};
Equ qhw = new Equ()
{
EquTypeId = "0102", Name = "前红外", Id = "5", Code = "AheadInfraredCorrelation"
};
Equ hhw = new Equ()
{
EquTypeId = "0102", Name = "后红外", Id = "6", Code = "BehindInfraredCorrelation"
};
equs.Add(zhd);
equs.Add(yhd);
//equs.Add(zld);
//equs.Add(yld);
equs.Add(zhw);
equs.Add(yhw);
equs.Add(qhw);
equs.Add(hhw);
string equJsonStr = JsonConvert.SerializeObject(equs);
JesonOperateHelper.WriteJesonFile("EquTypeList.json", equTypeJsonStr);
JesonOperateHelper.WriteJesonFile("EquList.json", equJsonStr);
}
