\RG3.BO.DB\Repository\DbExecuteRepository$InsertSql.cs

  #region 前缀信息
                    var primaryBeforeSuffix = sqlColumn.PrimaryBeforeSuffix;
                    var befSufX = $"{sqlColumn.Field}_bef_suf";
                    var befSufL = $"{sqlColumn.Field}BefSuf";
                    if (dicPK.ContainsKey(befSufL))
                    {
                        primaryBeforeSuffix = dicPK[befSufL]?.ToString();
                    }
                    else if (dicPK.ContainsKey(befSufX))
                    {
                        primaryBeforeSuffix = dicPK[befSufX]?.ToString();
                    }
                    #endregion 前缀信息

\mapper_mkey_sql__biz.primary.json

{
  "rules": {},
  "responseField": {
  },
  "columns": {
    "cfcItemId": {
      //主键前缀
      "primaryBeforeSuffix": "CFI",
      // #region 避免修改时候id不一直导致其他问题,如何组合的字段超过 maxLength, 需要截取前面的primaryFromFieldOne
      "primaryFromFieldOne": "cfcPresId",
      "primaryFromFieldTwo": "tradeName",
      "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": {}
}

文档更新时间: 2022-12-13 17:03   作者:admin