主键前缀、合成（多列值作为主键）

合并列作为主键数据

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

主键前缀、合成和加密截取

https://doc.rg1008.com/docs/rg_pass_log/rg_pass_log-1ec2acp0vqqos

mapper_zt-curposition_sql__primarys.json

\RG3.Web.Host.PaaS\Config\Mapper\basis\zentao\mapper_zt-curposition_sql__primarys.json

{
  "rules": {},
  "responseField": {},
  "columns": {
    "curpId": {
      //主键前缀
      "primaryBeforeSuffix": "CUR",
      // #region 避免修改时候id不一直导致其他问题,如何组合的字段超过 maxLength， 需要截取前面的primaryFromFieldOne
      "primaryFromFieldOne": "loginId",
      "primaryFromFieldTwo": "scriptureId",
      "primaryFromFieldThree": "", //_gidSnowflakeGuid  primary_from_field_two primary_from_field_three
      "primaryFormat": "{primary_from_field_one}{primary_from_field_two}",
      "primaryFromMethodOne": "",
      "primaryFromMethodTwo": "guid_8",
      "primaryFromMethodThree": ""
      // #endregion 避免修改时候id不一直导致其他问题
    }
  },
  "dimDatas": {}
}

使用案例

    requestMessage.Body = JsonUtilText.Serialize(new List<dynamic> { new  {
                BatO="ui",
                CurpId="0",
                LoginId=body.LoginId,
                ScriptureId=body.ScriptureId,
                WordNo=body.WordNo,
                AllWordNo=body.AllWordNo,
                LastDate=new DataKvString{Value= body.LastDate?.Value??DateTimeUtil.Now().ToString("yyyy-MM-ddTHH:mm:ss")},
                IsEnabled=new DataKvInt{ Value=1 }
            } });