/// <summary>
/// 记录一次访问
/// </summary>
/// <param name="recommendUrlId"></param>
/// <param name="openId"></param>
public void Log(Guid recommendUrlId, string openId)
{
RecommendUrlEntity url = Get(recommendUrlId);
if (url == null)
{
return;
}
RecommendUrlLogEntity log = new RecommendUrlLogEntity();
log.Domain = url.Domain;
log.AppId = url.AppId;
log.UrlOwnMember = url.Member;
log.VisitOpenId = openId;
log.Time = DateTime.Now;
_dataBase.Insert(log);
//递增访问量计数
List <CommandParameter> parameterList = new List <CommandParameter>();
parameterList.Add(new CommandParameter("@id", recommendUrlId));
_dataBase.ExecuteNonQuery(
"UPDATE [RecommendUrl] SET [LandingCount] = [LandingCount] + 1 WHERE [Id] = @id",
parameterList);
}
public RecommendUrlEntity Get(Guid id)
{
RecommendUrlEntity recommendUrl = new RecommendUrlEntity();
recommendUrl.Id = id;
if (_dataBase.Fill <RecommendUrlEntity>(recommendUrl))
{
return(recommendUrl);
}
else
{
return(null);
}
}
public RecommendUrlEntity Get(DomainContext domainContext, Guid memberId)
{
List <CommandParameter> parameterList = new List <CommandParameter>();
parameterList.Add(new CommandParameter("@domainId", domainContext.Domain.Id));
parameterList.Add(new CommandParameter("@appId", domainContext.AppId));
parameterList.Add(new CommandParameter("@memberId", memberId));
List <RecommendUrlEntity> list = _dataBase.Select <RecommendUrlEntity>(
"SELECT * FROM [RecommendUrl] WHERE [Domain] = @domainId AND [AppId] = @appId AND [Member] = @memberId", parameterList);
if (list.Count > 0)
{
return(list[0]);
}
Guid id = Guid.NewGuid();
string url = "{0}Function/RecommendUrl/{1}?id={2}";
url = String.Format(url, _settingsManager.GetClientAddress(domainContext.AppId), domainContext.Domain.Id, id);
string shortUrl = String.Empty;
RequestApiResult <WeixinCreateShortUrlResult> getShortUrlResult = ShortUrlApiWrapper.GetShortUrl(domainContext, url);
if (getShortUrlResult.Success)
{
shortUrl = getShortUrlResult.ApiResult.ShortUrl;
}
parameterList.Add(new CommandParameter("@id", id));
parameterList.Add(new CommandParameter("@url", url));
parameterList.Add(new CommandParameter("@shortUrl", shortUrl));
_dataBase.ExecuteNonQuery(CommandType.StoredProcedure, "CreateRecommendUrl", parameterList);
RecommendUrlEntity recommendUrl = new RecommendUrlEntity()
{
Id = id,
Domain = domainContext.Domain.Id,
AppId = domainContext.AppId,
Member = memberId,
Url = url,
ShortUrl = shortUrl
};
return(recommendUrl);
}
