private void button2_Click(object sender, RoutedEventArgs e) { Getxmal xmal = new Getxmal("2.xml"); //这里需要判断放的位置是否能满足要求 MessageBox.Show(position); for (int i = 0; i <= aservertype; i++) { if (servercabinet.usize[aposition - 1 + i] == "1") { MessageBox.Show("此位置已被占用"); return; } } if (servercabinet.usize[aposition - 2] == "1") { MessageBox.Show("此位置已被占用"); return; } if (servercabinet.usize[aposition + aservertype - 1] == "1") { MessageBox.Show("此位置已被占用"); return; } MessageBox.Show(rfid); xmal.addnode(RFID, rfid, position, servertype); string sql = "UPDATE equipment SET Position='" + @position + "' WHERE ID=" + @rfid; MySqlParameter[] _Parameters = { new MySqlParameter("@position", position), new MySqlParameter("@rfid", rfid) }; MySqlHelper.ExecuteNonQuery(MySqlHelper.Conn, CommandType.Text, sql, _Parameters); NewEquipment s1 = DeviceMigrationsFactory.NewEquipment; OldEquipment s2 = DeviceMigrationsFactory.OldEquipment; s2.grid.Children.Remove(addserver); s2.FurnitureContainer2.Children.Clear(); s1.addequipment.Children.Remove(s2); MyEvent(); }
private void button2_Click(object sender, RoutedEventArgs e) { Getxmal xmal = new Getxmal("2.xml"); //这里需要判断放的位置是否能满足要求 for (int i = 0; i <= aservertype; i++) { if (servercabinet.usize[aposition - 1 + i] == "1") { MessageBox.Show("此位置已被占用"); return; } } if (servercabinet.usize[aposition - 2] == "1") { MessageBox.Show("此位置已被占用"); return; } if (servercabinet.usize[aposition + aservertype - 1] == "1") { MessageBox.Show("此位置已被占用"); return; } MessageBox.Show("服务器在机柜中的标签号::" + rfid); position = aposition.ToString(); MessageBox.Show("服务器在机柜中的位置::" + position); xmal.addnode(RFID, rfid, position, servertype); string sql = "UPDATE equipment SET Position='" + @position + "' WHERE ID=" + @rfid; MySqlParameter[] _Parameters = { new MySqlParameter("@position", position), new MySqlParameter("@rfid", rfid) }; MySqlHelper.ExecuteNonQuery(MySqlHelper.Conn, CommandType.Text, sql, _Parameters); MyEvent(); this.Close(); }
private void button2_Click(object sender, RoutedEventArgs e) { Getxmal xmal = new Getxmal("2.xml"); //这里需要判断放的位置是否能满足要求 for (int i = 0; i <= aservertype; i++) { if (servercabinet.usize[aposition - 1 + i] == "1") { MessageBox.Show("此位置已被占用"); return; } } if (servercabinet.usize[aposition - 2] == "1") { MessageBox.Show("此位置已被占用"); return; } if (servercabinet.usize[aposition + aservertype - 1] == "1") { MessageBox.Show("此位置已被占用"); return; } MessageBox.Show("服务器在机柜中的标签号::"+rfid); position = aposition.ToString(); MessageBox.Show("服务器在机柜中的位置::"+position); xmal.addnode(RFID, rfid, position, servertype); string sql = "UPDATE equipment SET Position='" + @position + "' WHERE ID=" + @rfid; MySqlParameter[] _Parameters = { new MySqlParameter("@position", position), new MySqlParameter("@rfid", rfid) }; MySqlHelper.ExecuteNonQuery(MySqlHelper.Conn, CommandType.Text, sql, _Parameters); MyEvent(); this.Close(); }