去掉时间

 string value1 = dicPK[sqlColumn.Extend.Field].ToString().Replace(" 00:00:00", "").Replace("T00:00:00", "").Replace("00:00:00", "");
                string value2 = dicPK[sqlColumn.Extend.UniqueField].ToString().Replace(" 00:00:00", "").Replace("T00:00:00", "").Replace("00:00:00", "");
                string value3 = "";
                if (!string.IsNullOrEmpty(sqlColumn.Extend.ThreeField) && dicPK.ContainsKey(sqlColumn.Extend.ThreeField) && !ValidateUtil.ValidateExistsValue(dicPK[sqlColumn.Extend.ThreeField]))
                {
                    value3 = dicPK[sqlColumn.Extend.ThreeField].ToString().Replace(" 00:00:00", "").Replace("T00:00:00", "").Replace("00:00:00", "");
                }
                dicPK[sqlColumn.Field] = MD5.MD5Encrypt(value1 + value2 + value3);

合并特定字段为md5加密(用于查询、统计)


    "manager_detail": {
      "uniqueMd5": {
        "bdBbrId": {
          "field": "bdBbrId",
          "name": "bd_bbr_id",
          "alias": "bd_bbr_id",
          "children": [
            {
              "field": "familyId",
              "name": "family_id",
              "alias": "family_id",
              "sortId": 1
            },
            {
              "field": "bdBbr",
              "name": "bd_bbr",
              "alias": "bd_bbr",
              "sortId": 5
            }
          ]
        }
    }
}

开启组合加密

{
  "columns": {
    // #region 开启组合加密
    "bdTbrId": {
      "field": "bdTbrId",
      "name": "bd_tbr_id",
      "alias": "bd_tbr_id",
      "extend": {
        "uniqueMd5": true,
        "field": "bdTbr",
        "alias": "bd_tbr",
        "name": "bd_tbr",
        "uniqueField": "familyId",
        "uniqueAlias": "family_id",
        "uniqueName": "family_id",
        "threeField": "",
        "threeAlias": "",
        "threeName": ""
      }
    }
    // #endregion 开启组合加密
   }
}
文档更新时间: 2022-07-26 20:43   作者:admin