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