private void Add() { if (txtGZMC.Text.Trim() == "") { MessageBox.Show("规则名称不能为空"); txtGZMC.Focus(); return; } DialogResult dr = MessageBox.Show("确定保存吗,保存后不允许修改?", "保存规则", MessageBoxButtons.OKCancel); if (dr != DialogResult.OK) { return; } var ds = SQLiteHelper.ExecuteDataset(" select * from Rules where name='" + txtGZMC.Text.Trim() + "' limit 1 "); if (Comm.Func.HasData(ds) == true) { MessageBox.Show("规则已存在,请修改规则名称"); return; } var json = ""; if (rbType1.Checked == true) { json = Comm.JsonHelper.GetJson(new Rules.Auto { RuleType = "zz", Len = int.Parse(txtCD.Text.Trim()), StartValue = int.Parse(txtQSZ.Text.Trim()), Format = txtGS.Text }); } if (rbType2.Checked == true) { json = Comm.JsonHelper.GetJson(new Rules.Random { RuleType = "sj", Len = int.Parse(txtCD.Text.Trim()), Format = txtGS.Text }); } var item = new Datas.Rules() { Name = txtGZMC.Text.Trim(), Data = json }; var rows = SQLiteHelper.ExecuteNonQuery("insert into Rules(Name,Data)values('" + txtGZMC.Text.Trim() + "','" + json + "')"); MessageBox.Show("保存成功"); this.DialogResult = DialogResult.OK; this.Close(); }
private string BuildCode() { var rule = Comm.JsonHelper.GetModel <QRCode.Rules.Base>(_Rule.Data); var code = ""; if (rule.RuleType == "zz") { if (_ruleAuto == null) { _ruleAuto = Comm.JsonHelper.GetModel <QRCode.Rules.Auto>(_Rule.Data); } code = QRCode.Build.Get(_ruleAuto); _ruleAuto.StartValue = _ruleAuto.StartValue + 1; var ds = SQLiteHelper.ExecuteDataset(" select * from Rules where name='" + _RuleName + "' limit 1 "); var item = new QRCode.Datas.Rules(); if (Comm.Func.HasData(ds) == false) { return(""); } else { item.Name = ds.Tables[0].Rows[0]["Name"] + ""; item.Data = ds.Tables[0].Rows[0]["Data"] + ""; } item.Data = Comm.JsonHelper.GetJson(_ruleAuto); SQLiteHelper.ExecuteNonQuery(" update Rules set Data='" + item.Data + "' whhere name='" + _RuleName + "' "); } if (rule.RuleType == "sj") { if (_ruleRandom == null) { _ruleRandom = Comm.JsonHelper.GetModel <QRCode.Rules.Random>(_Rule.Data); } code = QRCode.Build.Get(_ruleRandom); } return(code); }