/// <summary> /// 点击确定按纽 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void OKClick(object sender, RoutedEventArgs e) { // 获取输入的数据 int capacity = int.Parse(Capacity.Text == ""? "0": Capacity.Text); int dayplan = int.Parse(DayPlan.Text == "" ? "0" : DayPlan.Text); int monthplan = int.Parse(MonthPlan.Text == "" ? "0" : MonthPlan.Text); var Daytime = DateTime.Today.Date.ToShortDateString(); if (capacity == CapacityText && dayplan == DayPlanText && monthplan == MonthPlanText) { // 关闭弹框 DialogResult = true; Console.WriteLine("111"); } else if (capacity != 0 && dayplan != 0 && monthplan != 0) { // 清空数据库当天设置的内容 string delsql = $"DELETE FROM StandardData WHERE Day = '{Daytime}'"; SQLiteHelp.DeleteSql(delsql); // 插入新数据 string sql = $"INSERT INTO StandardData VALUES('{Daytime}',{capacity},{dayplan},{monthplan})"; bool IsInsert = SQLiteHelp.SQLInsert(sql); if (IsInsert) { //关闭弹框 DialogResult = true; // 保存成功提示 Message mes = new Message(0, "修改成功"); mes.ShowDialog(); } else { // 保存失败提示 Message mes = new Message(2, "修改失败"); mes.ShowDialog(); } } else { Message mes = new Message(1, "数据不能为0"); mes.ShowDialog(); } }
/// <summary> /// OK按钮点击 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void OKClick(object sender, RoutedEventArgs e) { bool IsInsert = true; for (int i = 0; i < DevNameList.Count; i++) { if (DevNameList[i].ID == "" || DevNameList[i].Name == "") { // 提示框信息 Message message = new Message(1, "ID和设备名称不能为空"); message.ShowDialog(); return; } } // 清空数据库内容 string delsql = "DELETE FROM Equipment"; SQLiteHelp.DeleteSql(delsql); // 添加设备信息 for (int i = 0; i < DevNameList.Count; i++) { string sql = $"INSERT INTO Equipment VALUES ('{i}','{DevNameList[i].Name}')"; IsInsert = SQLiteHelp.SQLInsert(sql); } // 关闭弹框 DialogResult = true; if (IsInsert) { // 保存成功提示 Message mes = new Message(0, "添加修改设备成功"); mes.ShowDialog(); } else { // 保存失败提示 Message mes = new Message(2, "添加失败"); mes.ShowDialog(); } }
/// <summary> /// OK按钮点击 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void OKClick(object sender, RoutedEventArgs e) { if (IP1.Text == "" || IP2.Text == "" || IP3.Text == "" || IP4.Text == "" || Port.Text == "") { Message mes = new Message(1, "IP地址不能为空"); mes.ShowDialog(); //MessageBox.Show("IP地址不能为空"); } else { int ip1 = int.Parse(IP1.Text); int ip2 = int.Parse(IP2.Text); int ip3 = int.Parse(IP3.Text); int ip4 = int.Parse(IP4.Text); int port = int.Parse(Port.Text); string IPText = $"{ip1}.{ip2}.{ip3}.{ip4}:{port}"; if (ip1 > 255 || ip2 > 255 || ip3 > 255 || ip4 > 255 || ip1 < 0 || ip2 < 0 || ip3 < 0 || ip4 < 0) { Message mes = new Message(1, "IP地址错误"); mes.ShowDialog(); } else if (IPText == IP) { // 关闭弹框 DialogResult = true; // 运行读取Modbus数据函数 //ReadModBusIP(); RunGetModBus(); } else { // 清空数据库内容 string delsql = "DELETE FROM IPData"; SQLiteHelp.DeleteSql(delsql); // 插入新数据 string sql = $"INSERT INTO IPData VALUES('{ip1}',{ip2},{ip3},{ip4},{port})"; bool IsInsert = SQLiteHelp.SQLInsert(sql); if (IsInsert) { // 关闭弹框 DialogResult = true; // 保存成功提示 Message mes = new Message(0, "IP地址修改成功"); mes.ShowDialog(); // 运行读取Modbus IP数据函数 //ReadModBusIP(); RunGetModBus(); } else { // 保存失败提示 Message mes = new Message(2, "IP地址修改失败"); mes.ShowDialog(); } } } }