private void SaveXmlButton_Click(object sender, RoutedEventArgs e)
{
if (UserMessageBox.Show("消息提示", "确认修改数据库信息?") == true)
{
string ConnectionString = "Data Source = " + DataSourceBox.Text + "; User Id = " + UserIDBox.Text + "; Password ="******" CREATE database if not exists " + DataBaseBox.Text + ";DROP TABLE IF EXISTS " + DataBaseBox.Text + ".`firewallip`;" +
" CREATE TABLE " + DataBaseBox.Text + ".`firewallip` (fw_ip VARCHAR(255) DEFAULT NULL, `fw_mac` varchar(255) DEFAULT NULL," +
" dev_ip VARCHAR(255) DEFAULT NULL, dev_mac VARCHAR(255) DEFAULT NULL, dev_type VARCHAR(255) DEFAULT NULL)" +
" ENGINE = InnoDB DEFAULT CHARSET = utf8;" +
" DROP TABLE IF EXISTS " + DataBaseBox.Text + ".`firewallrules`;" +
" CREATE TABLE " + DataBaseBox.Text + ".`firewallrules` (`fw_mac` varchar(255) DEFAULT NULL,`protocol` varchar(255) DEFAULT NULL," +
" `source` varchar(255) DEFAULT NULL,`destination` varchar(255) DEFAULT NULL,`coiladdressstart` varchar(255) DEFAULT NULL," +
" `coiladdressend` varchar(255) DEFAULT NULL, minspeed varchar(255) DEFAULT NULL, maxspeed varchar(255) DEFAULT NULL," +
" `functioncode` varchar(255) DEFAULT NULL,`log` varchar(255) DEFAULT NULL" +
" ) ENGINE = InnoDB DEFAULT CHARSET = utf8;" +
" DROP TABLE IF EXISTS " + DataBaseBox.Text + ".`useraccount`;" +
" CREATE TABLE " + DataBaseBox.Text + ".`useraccount` (`UserID` tinyint(3) unsigned NOT NULL AUTO_INCREMENT," +
" `UserName` char(16) NOT NULL,`Password` char(8) DEFAULT NULL,`Purview` char(32) DEFAULT NULL," +
" PRIMARY KEY(`UserID`),UNIQUE KEY `useName` (`UserName`)) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8;" +
" INSERT INTO " + DataBaseBox.Text + ".`useraccount` (`UserID`, `UserName`, `Password`, `Purview`) VALUES('1', 'admin', 'admin', 'SUPER');";
try
{
//Open DataBase
//打开数据库
conn.Open();
MySqlCommand cmd = new MySqlCommand(CommandText, conn);
cmd.ExecuteNonQuery();
//读取全局配置信息
XmlSerializationHelper configContext = new XmlSerializationHelper("Config");
GlobalConfig globalconfig = configContext.Get <GlobalConfig>();
globalconfig.DataBaseConfigs[0].DataBase = DataBaseBox.Text;
globalconfig.DataBaseConfigs[0].DataSource = DataSourceBox.Text;
globalconfig.DataBaseConfigs[0].UserId = UserIDBox.Text;
globalconfig.DataBaseConfigs[0].Password = PassWordBox.Text;
configContext.Save(globalconfig);
StaticGlobal.database = DataBaseBox.Text;
StaticGlobal.datasource = DataSourceBox.Text;
StaticGlobal.userid = UserIDBox.Text;
StaticGlobal.password = PassWordBox.Text;
StaticGlobal.ConnectionString = "Database = " + StaticGlobal.database + ";Data Source = " + StaticGlobal.datasource + "; User Id = " + StaticGlobal.userid + "; Password ="******"提示", "输入信息有误或Mysql服务未打开，无法连接数据库！");
}
finally
{
//Close DataBase
//关闭数据库连接
conn.Close();
}
}
}
//*----------------------------------------------------------------
//函数说明：静态方法读取全局变量
//输入：无
//输出：无
//----------------------------------------------------------------*//
public static void ReadXmlConfig()
{
//读取全局配置信息
XmlSerializationHelper configContext = new XmlSerializationHelper("Config");
GlobalConfig globalconfig = configContext.Get <GlobalConfig>();
//数据库连接配置
StaticGlobal.database = globalconfig.DataBaseConfigs[0].DataBase;
StaticGlobal.datasource = globalconfig.DataBaseConfigs[0].DataSource;
StaticGlobal.userid = globalconfig.DataBaseConfigs[0].UserId;
StaticGlobal.password = globalconfig.DataBaseConfigs[0].Password;
StaticGlobal.ConnectionString = "Database = " + StaticGlobal.database + ";Data Source = " + StaticGlobal.datasource + "; User Id = " + StaticGlobal.userid + "; Password =" + StaticGlobal.password;
//参数配置
StaticGlobal.FunctionCodeNumber = globalconfig.Parameters[0].FunctionCodeNum;
//第一次使用软件标志
StaticGlobal.firstloginflag = globalconfig.LoginSettings[0].firstloginflag;
}
//设备扫描IP范围删除
private void IPDeletButton_Click(object sender, RoutedEventArgs e)
{
string[] Array1;
Array1 = StaticGlobal.ScanIP.Split('+');
string[] Array2 = new string[Array1.Length - 1];
int darray = ScanIPrangeBox.SelectedIndex;
if (StaticGlobal.ScanIP != "")
{
int j = 0;
while (j < darray)
{
Array2[j] = Array1[j];
j++;
}
while (darray < Array1.Length - 1)
{
Array2[darray] = Array1[darray + 1];
darray++;
}
string NewIP = Array2[0];
for (int i = 1; i < Array2.Length; i++)
{
NewIP = NewIP + "+" + Array2[i];
}
StaticGlobal.ScanIP = NewIP;
ScanIPrangeBox.SelectedItem = ScanIPrangeBox.Items[0];
}
//将设备扫描范围存入配置文件
XmlSerializationHelper configContext = new XmlSerializationHelper("Config");
GlobalConfig globalconfig = configContext.Get <GlobalConfig>();
globalconfig.ScanIPConfig[0].scanip = StaticGlobal.ScanIP;
configContext.Save(globalconfig);
StaticGlobal.ScanIP = globalconfig.ScanIPConfig[0].scanip;
ScanIPrangeBox.Items.Remove(ScanIPrangeBox.SelectedItem);
}