public static int InsertOpLogForProductVehicleTypeConfig(ProductVehicleTypeConfigOpLog logEntity)
{
var conn = ConfigurationManager.ConnectionStrings["SystemLogConnectionString"].ConnectionString;
if (SecurityHelp.IsBase64Formatted(conn))
{
conn = SecurityHelp.DecryptAES(conn);
}
var dbhelper = new SqlDbHelper(conn);
var sql = @"INSERT INTO ProductVehicleTypeConfigOprLog(PID,Operator,OperateContent,OperateTime,CreatedTime) VALUES(@Pid,@Operator,@OperateContent,@OperateTime,@CreatedTime)";
try
{
using (var cmd = new SqlCommand(sql))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Pid", logEntity.PID);
cmd.Parameters.AddWithValue("@Operator", logEntity.Operator);
cmd.Parameters.AddWithValue("@OperateContent", logEntity.OperateContent);
cmd.Parameters.AddWithValue("@OperateTime", logEntity.OperateTime);
cmd.Parameters.AddWithValue("@CreatedTime", logEntity.CreatedTime);
return(dbhelper.ExecuteNonQuery(cmd));
}
}
catch (Exception e)
{
return(-1);
}
}
public static bool InsertOpLogForProductVehicleTypeConfig(ProductVehicleTypeConfigOpLog logEntity)
{
if (logEntity != null)
{
return(InsertLog("PrdVehicleOprLog", logEntity));
}
return(false);
}
public void InsertPidAssociationLog(string pid)
{
using (var configclient = new ConfigLogClient())
{
var entity = new ProductVehicleTypeConfigOpLog()
{
PID = pid,
Operator = "系统自动",
OperateContent = string.Format("修改配置：产品{0}已自动适配车型", pid),
OperateTime = DateTime.Now,
CreatedTime = DateTime.Now,
};
var status = configclient.InsertDefaultLogQueue("PrdVehicleOprLog", JsonConvert.SerializeObject(entity));
if (!status.Success)
{
logger.Error("记录产品适配车型日志失败", status.Exception);
}
}
}
public void WriteOperatorLog(ProductVehicleTypeConfigOpLog log)
{
//User.Identity.Name, "", id, operation
LoggerManager.InsertOpLogForProductVehicleTypeConfig(log);
}
