/// <summary>
/// 写入操作作业日志
/// </summary>
/// <param name="CreateUserId">创建用户主键</param>
/// <param name="CreateUserName">创建用户</param>
/// <param name="busingessName">业务名称</param>
/// <param name="Remark">描述</param>
/// <param name="Result">操作业务把结果记录起来</param>
/// <returns></returns>
public void AddTaskLog(string CreateUserId, string CreateUserName, string busingessName, string Remark, OperationType operationtype, string Result = "")
{
try
{
List <StringBuilder> ListSql = new List <StringBuilder>();
List <object> ListParam = new List <object>();
BPMS_SysLogs SysLog = new BPMS_SysLogs();
SysLog.SyslogsId = CommonHelper.GetGuid;
SysLog.BusinessName = busingessName;
SysLog.OperationIp = RequestHelper.GetIPAddress();
SysLog.CreateUserId = CreateUserId;
SysLog.CreateUserName = CreateUserName;
SysLog.Result = Result;
SysLog.OperationType = (int)operationtype;
ListSql.Add(DbCommon.InsertSql(SysLog));
ListParam.Add(DbCommon.GetParameter(SysLog));
//添加日志详细信息
BPMS_SysLogDetails SysLogDetails = new BPMS_SysLogDetails();
SysLogDetails.SysLogDetailsId = CommonHelper.GetGuid;
SysLogDetails.SyslogsId = SysLog.SyslogsId;
SysLogDetails.Remark = Remark;
ListSql.Add(DbCommon.InsertSql(SysLogDetails));
ListParam.Add(DbCommon.GetParameter(SysLogDetails));
DataFactory.SqlHelper().BatchExecuteBySql(ListSql.ToArray(), ListParam.ToArray());
}
finally
{
}
}
/// <summary>
/// 写入更新操作日志
/// </summary>
/// <param name="oldObj">旧实体对象</param>
/// <param name="newObj">新实体对象</param>
/// <param name="CreateUserId">创建用户主键</param>
/// <param name="CreateUserName">创建用户</param>
/// <param name="busingessName">业务名称</param>
/// <param name="Result">操作业务把结果记录起来</param>
/// <returns></returns>
public void UpdateTaskLog <T>(T oldObj, T newObj, string CreateUserId, string CreateUserName, string busingessName = "", string Result = "")
{
try
{
List <StringBuilder> ListSql = new List <StringBuilder>();
List <object> ListParam = new List <object>();
Type objTye = typeof(T);
BPMS_SysLogs SysLog = new BPMS_SysLogs();
SysLog.SyslogsId = CommonHelper.GetGuid;
SysLog.TableName = newObj.ToString();
if (busingessName == "")
{
busingessName = GetBusingessName <T>();
}
SysLog.BusinessName = busingessName;
SysLog.OperationIp = RequestHelper.GetIPAddress();
SysLog.CreateUserId = CreateUserId;
SysLog.CreateUserName = CreateUserName;
SysLog.Result = Result;
SysLog.OperationType = (int)OperationType.Update;
PropertyInfo property = objTye.GetProperty(GetKeyField(objTye).ToString());
SysLog.Object_ID = property.GetValue(newObj, null).ToString();
ListSql.Add(DbCommon.InsertSql(SysLog));
ListParam.Add(DbCommon.GetParameter(SysLog));
//添加日志详细信息
foreach (PropertyInfo pi in objTye.GetProperties())
{
object oldVal = pi.GetValue(oldObj, null);
object newVal = pi.GetValue(newObj, null);
if (!Equals(oldVal, newVal))
{
if (oldVal != null && newVal != null)
{
BPMS_SysLogDetails SysLogDetails = new BPMS_SysLogDetails();
SysLogDetails.SysLogDetailsId = CommonHelper.GetGuid;
SysLogDetails.SyslogsId = SysLog.SyslogsId;
SysLogDetails.FieldName = GetFieldText(pi);
SysLogDetails.FieldText = pi.Name;
SysLogDetails.NewValue = "" + newVal + "";
SysLogDetails.OldValue = "" + oldVal + "";
ListSql.Add(DbCommon.InsertSql(SysLogDetails));
ListParam.Add(DbCommon.GetParameter(SysLogDetails));
}
}
}
DataFactory.SqlHelper().BatchExecuteBySql(ListSql.ToArray(), ListParam.ToArray());
}
finally
{
}
}
