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