/// <summary> /// sqlinfo信息是否在List中存在 /// </summary> private bool IsEqualsSqlInfo(SqlInfo receiveSqlInfo, SqlInfo dataGridSqlInfo) { return receiveSqlInfo.MasterDbName == dataGridSqlInfo.MasterDbName && receiveSqlInfo.MasterHost == dataGridSqlInfo.MasterHost && receiveSqlInfo.SlaveDbName == dataGridSqlInfo.SlaveDbName && receiveSqlInfo.SlaveHost == dataGridSqlInfo.SlaveHost; }
/// <summary> /// 构建正确的类 /// </summary> private static SqlInfo BuildRightClass(XmlNodeList nodeList) { SqlInfo sqlInfo = new SqlInfo(); XmlNode MasterDBInfo = nodeList[0].ChildNodes[1]; XmlNode SlaveDBInfo = nodeList[0].ChildNodes[2]; sqlInfo.MasterHost = MasterDBInfo.Attributes[0].Value; sqlInfo.MasterPort = MasterDBInfo.Attributes[1].Value; sqlInfo.MasterDbName = MasterDBInfo.Attributes[2].Value; sqlInfo.SlaveHost = SlaveDBInfo.Attributes[0].Value; sqlInfo.SlavePort = SlaveDBInfo.Attributes[1].Value; sqlInfo.SlaveDbName = SlaveDBInfo.Attributes[2].Value; sqlInfo.SlaveType = SlaveDBInfo.Attributes[3].Value; sqlInfo.SlaveSerialNo = SlaveDBInfo.Attributes[4].Value; sqlInfo.SlaveServerID = SlaveDBInfo.Attributes[5].Value; sqlInfo.BinLog = SlaveDBInfo.Attributes[6].Value; sqlInfo.Position = SlaveDBInfo.Attributes[7].Value; sqlInfo.LastTime = System.DateTime.Now.ToString("HH:mm:ss MM-dd"); sqlInfo.Status = Constant.Normal; return sqlInfo; }
/// <summary> /// DataGrid中插入接收到的数据 /// </summary> private void doDataGridInsertData(SqlInfo temp) { lock (this) { bool flag = true; foreach (SqlInfo data in allListData) { if (IsEqualsSqlInfo(temp, data)) { data.BinLog = temp.BinLog; data.Position = temp.Position; data.Status = temp.Status; data.LastTime = temp.LastTime; flag = false; break; } } if (flag) allListData.Add(temp); } }
/// <summary> /// 构建错误的类 /// </summary> private static SqlInfo BuildErrorClass(XmlNodeList nodeList) { SqlInfo sqlInfo = new SqlInfo(); XmlNode Config = nodeList[0].ChildNodes[1]; XmlNode Error = nodeList[0].ChildNodes[2]; sqlInfo.MasterHost = Config.Attributes[0].Value; sqlInfo.MasterPort = Config.Attributes[1].Value; sqlInfo.MasterDbName = Config.Attributes[2].Value; sqlInfo.SlaveHost = Config.Attributes[3].Value; sqlInfo.SlavePort = Config.Attributes[4].Value; sqlInfo.SlaveDbName = Config.Attributes[5].Value; sqlInfo.SlaveType = Config.Attributes[6].Value; sqlInfo.LastTime = System.DateTime.Now.ToString("HH:mm:ss MM-dd"); sqlInfo.Status = Constant.Error; return sqlInfo; }