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