コード例 #1
0
ファイル: frAddRules.cs プロジェクト: itxstcom/qrcode
        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();
        }
コード例 #2
0
        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);
        }