public static bool AddLog(string title, string msg, string ipAddress)
{
Model.BackgroundUserInfo_log logEntity = new Model.BackgroundUserInfo_log()
{
UserID = Identity.LoginUserInfo == null ? 0 : Identity.LoginUserInfo.UserID,
OperateTile = title,
OperateDetail = msg,
OperateTime = DateTime.Now,
IpAddress = ipAddress
};
return(DAL.BackgroundUserInfoDal_log.Add(logEntity));
}
public static bool Add(Model.BackgroundUserInfo_log entity)
{
var sql = @"
INSERT INTO [BackgroundUserInfo_log]
(
[UserID]
,[OperateTile]
,[OperateDetail]
,[OperateTime]
,[IpAddress]
)
VALUES
(
@UserID
,@OperateTile
,@OperateDetail
,@OperateTime
,@IpAddress
)
";
var parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter()
{
ParameterName = "@UserID", Value = entity.UserID
});
parameters.Add(new SqlParameter()
{
ParameterName = "@OperateTile", Value = entity.OperateTile
});
parameters.Add(new SqlParameter()
{
ParameterName = "@OperateDetail", Value = entity.OperateDetail
});
parameters.Add(new SqlParameter()
{
ParameterName = "@OperateTime", Value = entity.OperateTime
});
parameters.Add(new SqlParameter()
{
ParameterName = "@IpAddress", Value = entity.IpAddress
});
int i = SqlHelper.ExecuteNonQuery(sql, parameters.ToArray());
return(i > 0 ? true : false);
}
