去掉时间
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