/// <summary>
/// Get paramter entity
/// </summary>
public List <ParamEntity> GetParams()
{
var _params = new List <ParamEntity>();
using (var conn = new SQLiteConnection(registryConnectionString)) {
conn.SetPassword(dbPassword);
conn.Open();
using (var command = new SQLiteCommand(SqliteCommands.Registry_Get_Param, conn)) {
using (var rdr = command.ExecuteReader(CommandBehavior.CloseConnection)) {
while (rdr.Read())
{
var _param = new ParamEntity();
_param.Id = SqlTypeConverter.DBNullParamIdHandler(rdr["id"]);
_param.Value = SqlTypeConverter.DBNullStringHandler(rdr["value"]);
_param.Time = SqlTypeConverter.DBNullDateTimeHandler(rdr["time"]);
_params.Add(_param);
}
}
}
}
return(_params);
}
private void paramSaveButton_Click(object sender, EventArgs e)
{
try {
var tag = _currentNode.Tag as TagModel;
if (tag.Type != NodeType.Param)
{
throw new Exception("节点类型错误。");
}
if (string.IsNullOrWhiteSpace(scOff.Text))
{
scOff.Focus();
MessageBox.Show("信号编码不能为空", "系统警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (string.IsNullOrWhiteSpace(fsuOff.Text))
{
fsuOff.Focus();
MessageBox.Show("信号编码不能为空", "系统警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (string.IsNullOrWhiteSpace(fzdl.Text))
{
fzdl.Focus();
MessageBox.Show("信号编码不能为空", "系统警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (string.IsNullOrWhiteSpace(gzzt.Text))
{
gzzt.Focus();
MessageBox.Show("信号编码不能为空", "系统警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (string.IsNullOrWhiteSpace(dczdy.Text))
{
dczdy.Focus();
MessageBox.Show("信号编码不能为空", "系统警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (string.IsNullOrWhiteSpace(dczdl.Text))
{
dczdy.Focus();
MessageBox.Show("信号编码不能为空", "系统警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (string.IsNullOrWhiteSpace(dcdy.Text))
{
dczdy.Focus();
MessageBox.Show("信号编码不能为空", "系统警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (string.IsNullOrWhiteSpace(dcwd.Text))
{
dczdy.Focus();
MessageBox.Show("信号编码不能为空", "系统警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var sc = new ParamEntity {
Id = ParamId.ScOff, Value = scOff.Text.Trim(), Time = DateTime.Now
};
var fsu = new ParamEntity {
Id = ParamId.FsuOff, Value = fsuOff.Text.Trim(), Time = DateTime.Now
};
var _fzdl = new ParamEntity {
Id = ParamId.FZDL, Value = fzdl.Text.Trim(), Time = DateTime.Now
};
var _gzzt = new ParamEntity {
Id = ParamId.GZZT, Value = gzzt.Text.Trim(), Time = DateTime.Now
};
var _dczdy = new ParamEntity {
Id = ParamId.DCZDY, Value = dczdy.Text.Trim(), Time = DateTime.Now
};
var _dczdl = new ParamEntity {
Id = ParamId.DCZDL, Value = dczdl.Text.Trim(), Time = DateTime.Now
};
var _dcdy = new ParamEntity {
Id = ParamId.DCDY, Value = dcdy.Text.Trim(), Time = DateTime.Now
};
var _dcwd = new ParamEntity {
Id = ParamId.DCWD, Value = dcwd.Text.Trim(), Time = DateTime.Now
};
var _nhzq = new ParamEntity {
Id = ParamId.NHZQ, Value = nhPeriodField.SelectedValue.ToString(), Time = DateTime.Now
};
var _xxpl = new ParamEntity {
Id = ParamId.XXPL, Value = vpPeriod.Value.ToString(), Time = DateTime.Now
};
var _gjjk = new ParamEntity {
Id = ParamId.GJJK, Value = gjjkField.Checked ? "1" : "0", Time = DateTime.Now
};
var _dcsj = new ParamEntity {
Id = ParamId.DCSJ, Value = batField.Checked ? "1" : "0", Time = DateTime.Now
};
var _dxgj = new ParamEntity {
Id = ParamId.DXGJ, Value = dxgjField.Checked ? "1" : "0", Time = DateTime.Now
};
var _yygj = new ParamEntity {
Id = ParamId.YYGJ, Value = yygjField.Checked ? "1" : "0", Time = DateTime.Now
};
_registry.SaveParams(new List <ParamEntity> {
sc, fsu, _fzdl, _gzzt, _dczdy, _dczdl, _dcdy, _dcwd, _nhzq, _xxpl, _gjjk, _dcsj, _dxgj, _yygj
});
MessageBox.Show("保存成功", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
} catch (Exception err) {
MessageBox.Show(err.Message, "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}