private void NodeNameOK()
{
bool flag = true;
string sql = "select Descripe from tb_AreaSet";
sql += " where IPandPort = '" + tboxoldtext.Split(',')[0] + "'";
sql += " and AreaNum = '" + tboxoldtext.Split(',')[1] + "'";
for (int i = 0; i < FormMain.DataModel.AreaSet.Count; i++)
{
if (FormMain.DataModel.AreaSet[i].IPport == tboxoldtext.Split(',')[0] &&
FormMain.DataModel.AreaSet[i].AreaNum == tboxoldtext.Split(',')[1]
)
{
string s = FormMain.DataModel.AreaSet[i].Describe;
if (s == tBox_new.Text)
{
flag = false;
}
}
}
if (flag)
{
sql = "select Map from tb_AreaSet";
sql += " where IPandPort = '" + tboxoldtext.Split(',')[0] + "'";
sql += " and AreaNum = '" + tboxoldtext.Split(',')[1] + "'";
sql += " and Descripe = '" + tboxoldtext.Split(',')[2] + "'";
string mapTemp = "";
for (int i = 0; i < FormMain.DataModel.AreaSet.Count; i++)
{
if (FormMain.DataModel.AreaSet[i].IPport == tboxoldtext.Split(',')[0] &&
FormMain.DataModel.AreaSet[i].AreaNum == tboxoldtext.Split(',')[1] &&
FormMain.DataModel.AreaSet[i].Describe == tboxoldtext.Split(',')[2]
)
{
mapTemp = FormMain.DataModel.AreaSet[i].Map;
}
}
string descripe = tBox_new.Text.Trim();
sql = " update tb_AreaSet set Descripe ='" + descripe;
sql += "' Where Descripe = '" + tboxoldtext.Split(',')[2] + "'";
sql += " and IPandPort = '" + tboxoldtext.Split(',')[0] + "'";
sql += " and AreaNum = '" + tboxoldtext.Split(',')[1] + "'";
for (int i = 0; i < FormMain.DataModel.AreaSet.Count; i++)
{
cmsAreaSet updAS = FormMain.DataModel.AreaSet[i];
if (updAS.IPport == tboxoldtext.Split(',')[0] &&
updAS.AreaNum == tboxoldtext.Split(',')[1] &&
updAS.Describe == tboxoldtext.Split(',')[2]
)
{
updAS.Describe = descripe;
FormMain.DataModel.AreaSet[i] = updAS;
}
}
sql = " update tb_Map set MapInfo ='" +
FormMain.CurrentNode.Split(',')[0] + "," +
FormMain.CurrentNode.Split(',')[1] + "," +
tBox_new.Text +
" 'Where MapInfo = '" + FormMain.CurrentNode + "'";
for (int i = 0; i < FormMain.DataModel.Map.Count; i++)
{
cmsMap updM = FormMain.DataModel.Map[i];
if (updM.MapInfo == FormMain.CurrentNode)
{
updM.MapInfo = FormMain.CurrentNode.Split(',')[0] + "," + FormMain.CurrentNode.Split(',')[1] + "," + tBox_new.Text;
FormMain.DataModel.Map[i] = updM;
}
}
FormMain.ContentBuff[mapTemp] = descripe;
thisMapNodeName(tBox_new.Text);
LoadTreeView();
tBox_old.Text = tBox_new.Text;
tBox_new.Text = "";
}
else
{
MessageBox.Show("name repeate", "WARN");
}
}
private void btn_confirm_Click(object sender, EventArgs e)
{
string addressOld = textBox_IP.Text.Trim();
string address = textBox_IPn.Text.Trim();
string position = textBox_SatNamen.Text.Trim();
string type = textBox_Portn.Text.Trim();
string sql = null;
try
{
sql = " update tb_AreaSet set ";
sql += " AreaNum = '" + address;
sql += "' , Descripe = '" + position;
sql += "' , DeviceType = '" + type;
sql += "' , Map = replace( Map , '," + addressOld + "-' , '," + address + "-' )";
sql += " Where IPandPort = '" + ipPort + "' and AreaNum = '" + addr + "' and Descripe = '" + posi + "'";
for (int i = 0; i < FormMain.DataModel.AreaSet.Count; i++)
{
cmsAreaSet tmpAS = FormMain.DataModel.AreaSet[i];
if (tmpAS.IPport == ipPort &&
tmpAS.AreaNum == addr &&
tmpAS.Describe == posi
)
{
tmpAS.AreaNum = address;
tmpAS.Describe = position;
tmpAS.DeviceType = type;
tmpAS.Map = tmpAS.Map.Replace(addressOld + "-", address + "-");
FormMain.DataModel.AreaSet[i] = tmpAS;
}
}
sql = " update tb_AreaSet set ";
sql += " AreaNum = '" + address;
sql += "' , DeviceType = '" + type;
sql += "' , Map = replace( Map , '," + addressOld + "-' , '," + address + "-' )";
sql += " Where IPandPort = '" + ipPort + "' and AreaNum = '" + addr + "'";
for (int i = 0; i < FormMain.DataModel.AreaSet.Count; i++)
{
cmsAreaSet tmpAS = FormMain.DataModel.AreaSet[i];
if (tmpAS.IPport == ipPort &&
tmpAS.AreaNum == addr
)
{
tmpAS.AreaNum = address;
tmpAS.DeviceType = type;
tmpAS.Map = tmpAS.Map.Replace(addressOld + "-", address + "-");
FormMain.DataModel.AreaSet[i] = tmpAS;
}
}
update_datagridView();
}
catch
{
MessageBox.Show("Zone change failed");
}
try
{
sql = " update tb_Map set ";
sql += " MapInfo = '" + ipPort + "," + address + "," + position + "'";
sql += " Where MapInfo = '" + ipPort + "," + addr + "," + posi + "'";
for (int i = 0; i < FormMain.DataModel.Map.Count; i++)
{
cmsMap tmpMap = FormMain.DataModel.Map[i];
if (tmpMap.MapInfo == ipPort + "," + addr + "," + posi)
{
tmpMap.MapInfo = ipPort + "," + address + "," + position;
FormMain.DataModel.Map[i] = tmpMap;
}
}
sql = " update tb_Map set ";
sql += " MapInfo = replace(MapInfo,'," + addr + ",','," + address + ",'" + ")";
for (int i = 0; i < FormMain.DataModel.Map.Count; i++)
{
cmsMap tmpMap = FormMain.DataModel.Map[i];
tmpMap.MapInfo = tmpMap.MapInfo.Replace(addr, address);
FormMain.DataModel.Map[i] = tmpMap;
}
}
catch
{
MessageBox.Show("map change failed");
}
GetDatabaseData();
LoadTreeView();
this.Close();
}
private void btn_Done_Click(object sender, EventArgs e)
{
if (textBox_AreaNum.Text != "" && textBox_Position.Text != "")
{
try
{
data[0] = StaBuff[comboBox_StaName.Text].Trim();
}
catch
{
data[0] = "null";
}
data[1] = textBox_AreaNum.Text.Trim();
data[2] = comboBox_AreaStatus.Text.Trim();
data[3] = textBox_Position.Text.Trim();
data[4] = comboBox_type.Text.Split('-')[1].Trim();
bool flag = true;
string sql = "select AreaNum from tb_AreaSet Where IPandPort ='" + data[0] + "'";
List <string> areaNum = new List <string>();
foreach (cmsAreaSet cmsAS in FormMain.DataModel.AreaSet)
{
if (cmsAS.IPport == data[0])
{
areaNum.Add(cmsAS.AreaNum);
}
}
for (int i = 0; i < areaNum.Count; i++)
{
string temp = areaNum[i];
if (temp == data[1])
{
flag = false;
break;
}
}
if (flag)
{
char CheckState = (comboBox_type.Text.Split('-')[0] == "SingleZone" ? 'N' : 'Y');
if (CheckState == 'N')
{
string insertstr = "insert into tb_areaset(ipandport,areanum,status,descripe,devicetype,map) values('";
for (int i = 0; i < 5; i++)
{
insertstr += data[i] + "', '";
}
insertstr += data[0] + "," + data[1] + "-0" + "')";
cmsAreaSet addAS = new cmsAreaSet();
addAS.IPport = data[0];
addAS.AreaNum = data[1];
addAS.Status = data[2];
addAS.Describe = data[3];
addAS.DeviceType = data[4];
addAS.Map = data[0] + "," + data[1] + "-0";
FormMain.DataModel.AreaSet.Add(addAS);
FormDenfenAreaSet.DataLength++;
UpdateDataBase(insertstr);
}
else
{
for (int j = 1; j < 3; j++)
{
string insertstr = "insert into tb_areaset(ipandport,areanum,status,descripe,devicetype,map) values('";
for (int i = 0; i < 3; i++)
{
insertstr += data[i] + "', '";
}
insertstr += data[3] + "_" + j.ToString() + "', '";
insertstr += data[4] + "', '";
insertstr += data[0] + "," + data[1] + "-" + j.ToString() + "')";
cmsAreaSet addAS = new cmsAreaSet();
addAS.IPport = data[0];
addAS.AreaNum = data[1];
addAS.Status = data[2];
addAS.Describe = data[3] + "_" + j.ToString();
addAS.DeviceType = data[4];
addAS.Map = data[0] + "," + data[1] + "-" + j.ToString();
FormMain.DataModel.AreaSet.Add(addAS);
FormDenfenAreaSet.DataLength++;
UpdateDataBase(insertstr);
}
}
}
else
{
MessageBox.Show("Zone Number Is Repeated Under The Same Base Station", "WARN");
}
}
else
{
MessageBox.Show("Please complete the filling");
}
LoadTreeView();
}
private void btn_confirm_Click(object sender, EventArgs e)
{
string ipn = textBox_IPn.Text.Trim();
string namen = textBox_SatNamen.Text.Trim();
string portn = textBox_Portn.Text.Trim();
if (true)
{
string sql = null;
try
{
sql = " update tb_StaSet set";
sql += " IP= '" + ipn;
sql += "' , Port= '" + portn;
sql += "' , StaName= '" + namen;
sql += "' , IPandPort= '" + ipn + ":" + portn;
sql += " 'Where IPandPort = '" + ip + ":" + port + "'";
for (int i = 0; i < FormMain.DataModel.StationSet.Count; i++)
{
cmsStationSet udSS = FormMain.DataModel.StationSet[i];
if (udSS.IPandPort == (ip + ":" + port))
{
udSS.IP = ipn;
udSS.Port = portn;
udSS.StaName = namen;
udSS.IPandPort = ipn + ":" + portn;
FormMain.DataModel.StationSet[i] = udSS;
}
}
update_datagridView();
}
catch
{
MessageBox.Show("change failed");
}
try
{
sql = " update tb_AreaSet set ";
sql += " IPandPort= '" + ipn + ":" + portn;
sql += "' , Map = replace( Map , '" + ip + ":" + port + "' , '" + ipn + ":" + portn + "' )";
sql += " Where IPandPort = '" + ip + ":" + port + "'";
for (int i = 0; i < FormMain.DataModel.AreaSet.Count; i++)
{
cmsAreaSet udAS = FormMain.DataModel.AreaSet[i];
if (udAS.IPport == (ip + ":" + port))
{
udAS.IPport = ipn + ":" + portn;
udAS.Map = udAS.Map.Replace(ip + ":" + port, ipn + ":" + portn);
FormMain.DataModel.AreaSet[i] = udAS;
}
}
}
catch
{
MessageBox.Show("change failed");
}
try
{
sql = " update tb_Map set ";
sql += " MapInfo = replace( MapInfo , '" + ip + ":" + port + "' , '" + ipn + ":" + portn + "' )";
foreach (cmsMap udMap in FormMain.DataModel.Map)
{
udMap.MapInfo = udMap.MapInfo.Replace(ip + ":" + port, ipn + ":" + portn);
}
}
catch
{
MessageBox.Show("change failed");
}
GetDatabaseData();
LoadTreeView();
this.Close();
}
else
{
MessageBox.Show("Fill in non-standard");
}
}