/// <summary>
/// 修改UserAccessLogInfo
/// </summary>
/// <param name="useraccesslog"></param>
/// <returns></returns>
public static int UpdateUserAccessLog(UserAccessLogInfo useraccesslog)
{
string sql = @"UPDATE [UserAccessLog] SET
Url=@Url,
Referer=@Referer,
UserAgent=@UserAgent,
UserId=@UserId,
Ip=@Ip,
InsertTime=@InsertTime,
Other=@Other,
Type=@Type
WHERE Id=@Id";
var par = new DynamicParameters();
par.Add("@Id", useraccesslog.Id, DbType.Int64);
par.Add("@Url", useraccesslog.Url, DbType.AnsiString);
par.Add("@Referer", useraccesslog.Referer, DbType.AnsiString);
par.Add("@UserAgent", useraccesslog.UserAgent, DbType.AnsiString);
par.Add("@UserId", useraccesslog.UserId, DbType.Int32);
par.Add("@Ip", useraccesslog.Ip, DbType.AnsiString);
par.Add("@InsertTime", useraccesslog.InsertTime, DbType.DateTime);
par.Add("@Other", useraccesslog.Other, DbType.String);
par.Add("@Type", useraccesslog.Type, DbType.Int16);
return(DapWrapper.InnerExecuteSql(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 添加UserAccessLogInfo
/// </summary>
/// <param name="useraccesslog"></param>
/// <returns></returns>
public async static Task <long> AddUserAccessLogAsync(UserAccessLogInfo useraccesslog)
{
string sql = @"INSERT INTO [UserAccessLog]
([Url],[Referer],[UserAgent],[UserId],[Ip],[Other],[Type])
VALUES
(@Url,@Referer,@UserAgent,@UserId,@Ip,@Other,@Type)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@Url", useraccesslog.Url, DbType.AnsiString);
par.Add("@Referer", useraccesslog.Referer, DbType.AnsiString);
par.Add("@UserAgent", useraccesslog.UserAgent, DbType.AnsiString);
par.Add("@UserId", useraccesslog.UserId, DbType.Int32);
par.Add("@Ip", useraccesslog.Ip, DbType.AnsiString);
par.Add("@Other", useraccesslog.Other, DbType.String);
par.Add("@Type", useraccesslog.Type, DbType.Int16);
return(await DapWrapper.InnerQueryScalarSqlAsync <int>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// DataModel 转 ViewModel
/// </summary>
/// <param name="useraccesslog"></param>
/// <returns></returns>
public static UserAccessLogVModel UserAccessLogInfoToVModel(UserAccessLogInfo useraccesslog)
{
if (useraccesslog == null)
{
return(new UserAccessLogVModel());
}
return(new UserAccessLogVModel
{
Id = useraccesslog.Id,
Url = useraccesslog.Url,
Referer = useraccesslog.Referer,
UserAgent = useraccesslog.UserAgent,
UserId = useraccesslog.UserId,
Ip = useraccesslog.Ip,
InsertTime = useraccesslog.InsertTime,
Other = useraccesslog.Other,
Type = useraccesslog.Type
});
}
/// <summary>
/// 修改UserAccessLogInfo
/// </summary>
/// <param name="useraccesslog"></param>
/// <returns></returns>
public static int UpdateUserAccessLog(UserAccessLogInfo useraccesslog)
{
return(DataProvider.UserAccessLogs.UpdateUserAccessLog(useraccesslog));
}
/// <summary>
/// 添加UserAccessLogInfo
/// </summary>
/// <param name="useraccesslog"></param>
/// <returns></returns>
public static async Task <long> AddUserAccessLogAsync(UserAccessLogInfo useraccesslog)
{
return(await DataProvider.UserAccessLogs.AddUserAccessLogAsync(useraccesslog));
}
/// <summary>
/// 添加UserAccessLogInfo
/// </summary>
/// <param name="useraccesslog"></param>
/// <returns></returns>
public static long AddUserAccessLog(UserAccessLogInfo useraccesslog)
{
return(DataProvider.UserAccessLogs.AddUserAccessLog(useraccesslog));
}
