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