【验证】主键唯一验证

多主键合成

https://doc.rg1008.com/docs/rg_dev/rg_dev-1en3ekd7i8esk
\RG3.BO.DB\Repository\DbExecuteRepository$InsertSql.cs

唯一验证

https://doc.rg1008.com/docs/rg_pass_api/rg_pass_api-1d2u8685vrmds

db模式

\RG3.Web.Host.PaaS\Config\Mapper\basis\boapp\mapper_bo-app-config-setting_sql__rules.json

{
  "rules": {
    "settingId": [
      {
        "type": "required",
        "required": true,
        "isAdd": true,
        "isEdit": true,
        "message": "【{setting_id}】值必须填写。"
      },
      {
        "type": "maxlength",
        "required": false,
        "isAdd": true,
        "isEdit": true,
        "max": 50,
        "message": "【{setting_id}】值最大长度为50。"
      },
      {
        "type": "db", //remote db  远程验证 rule 和 sql必须填写；  db：sql必须填写
        "url": "~/bo/api/v3/remote/unique/{mkey}/{resField}?ownerId={ownerId}&sysId={sysId}&rule={rule}&{params}",
        "sql": "select count(setting_id) from bo_app_config_setting where setting_id=@settingId",
        "isAdd": true,
        "isEdit": false,
        "message": "【应用配置】已存在，可进入修改页面进行内容修改。"
      }
    ]
  }
}