• 周五. 10月 7th, 2022

5G编程聚合网

5G时代下一个聚合的编程学习网

热门标签

检查实体字段是否被修改并记录修改内容

admin

11月 28, 2021

Dictionary<string, string> keyValueByFields = new Dictionary<string, string>();

keyValueByFields.Add(“Doc_Name”, “单证”);
keyValueByFields.Add(“Doc_Name2”, “单证2”);
keyValueByFields.Add(“Marking_Name”, “市场人员”);
keyValueByFields.Add(“BookingMan_Name”, “订舱人”);
keyValueByFields.Add(“BusinessRisk_Remark”, “业务风险备注”);

public static Tuple<bool, string> CompareTypeFieldValue<T>(T newT, T oldT, Dictionary<string, string> keyValueByFields) where T : class
{
bool compareResult = true;
string compareMsg = string.Empty;

if (newT == null || oldT == null)
return new Tuple<bool, string>(compareResult, compareMsg);

PropertyInfo[] newProps = newT.GetType().GetProperties();
PropertyInfo[] oldProps = oldT.GetType().GetProperties();

foreach (var item in newProps)
{
ColumnAttribute column = item.GetCustomAttribute(typeof(ColumnAttribute)) as ColumnAttribute;
if (column != null && column.IsSQLColumn)
{
if (!column.IsPrimaryKey)
{
if (keyValueByFields.Keys.Contains(item.Name))
{
object newPropValue = item.GetValue(newT, null);
object oldPropValue = oldProps.FirstOrDefault(e => e.Name == item.Name).GetValue(oldT, null);

if (newPropValue == null)
newPropValue = string.Empty;

if (oldPropValue == null)
oldPropValue = string.Empty;

Type colType = item.PropertyType;
//当类型为Nullable<>时
if ((colType.IsGenericType) && (colType.GetGenericTypeDefinition() == typeof(Nullable<>)))
{
colType = colType.GetGenericArguments()[0];
}

if (colType.Name.ToLower().StartsWith(“decimal”))
{
if (string.IsNullOrWhiteSpace(newPropValue.ToString()))
newPropValue = “0.000”;

if(string.IsNullOrWhiteSpace(oldPropValue.ToString()))
oldPropValue = “0.000”;

decimal newD = decimal.Parse(newPropValue.ToString());
decimal oldD = decimal.Parse(oldPropValue.ToString());
if (newD != oldD)
{
compareResult = false;
compareMsg += keyValueByFields[item.Name] + “【” + oldPropValue + “】修改为【” + newPropValue + “】<br>”;
}
}
else
{
if (newPropValue.ToString() != oldPropValue.ToString())
{
compareResult = false;
compareMsg += keyValueByFields[item.Name] + “【” + oldPropValue + “】修改为【” + newPropValue + “】<br>”;
}
}
}
}
}
}

return new Tuple<bool, string>(compareResult, compareMsg);
}

发表回复

您的电子邮箱地址不会被公开。