protected void AddPageLog(long PagesNo, string Lang, int Ver, long SiteID, string SessionID, long?MemberID, string ReferrerUrl, string ReferrerUrlTitle, string ReferrerUrlPageNo)
{
try
{
PagesView_LogModel logModel = new PagesView_LogModel()
{
PagesNo = PagesNo,
ReferrerUrl = ReferrerUrl,
ReferrerUrlTitle = ReferrerUrlTitle,
ReferrerUrlPageNo = ReferrerUrlPageNo,
Lang = Lang,
Ver = Ver,
SiteID = SiteID,
SessionID = SessionID,
MemberID = MemberID,
Browser = Request.Browser.Browser,
UserAgent = Request.UserAgent,
IP = WorkLib.GetItem.IPAddr(),
AddTime = DateTime.Now,
IPNum = (long)WorkLib.GetItem.GetIPNum()
};
PagesView_LogDAO.AddPageLogs(logModel);
}
catch (Exception exp)
{
try
{
//WorkLib.WriteLog.Write(true, exp.Message);
}
catch { }
}
}
public static bool AddPageLogs(PagesView_LogModel logModel)
{
PagesModels nData = new PagesModels();
using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(WebInfo.Conn))
{
string sql = @" UPDATE PagesView_Log SET StaySeconds=LastPageViewLog.StaySeconds
FROM
(
SELECT ID, DATEDIFF(SECOND, [AddTime], GETDATE()) AS StaySeconds
FROM
(
SELECT top 1 * FROM PagesView_Log
WHERE SessionID=@SessionID ORDER BY AddTime DESC
)
AS LastPageViewTMP
) AS LastPageViewLog
WHERE LastPageViewLog.ID=PagesView_Log.ID;
INSERT PagesView_Log(PagesNo, ReferrerUrl, ReferrerUrlTitle, ReferrerUrlPageNo, Lang, Browser, UserAgent, SiteID, SessionID, MemberID, AddTime, IP, IPNum)
VALUES (@PagesNo, @ReferrerUrl, @ReferrerUrlTitle, @ReferrerUrlPageNo, @Lang, @Browser, @UserAgent, @SiteID, @SessionID, @MemberID, @AddTime, @IP, @IPNum);";
conn.Execute(sql, new
{
PagesNo = logModel.PagesNo,
ReferrerUrl = logModel.ReferrerUrl,
ReferrerUrlTitle = logModel.ReferrerUrlTitle,
ReferrerUrlPageNo = logModel.ReferrerUrlPageNo,
Lang = logModel.Lang,
Browser = logModel.Browser,
UserAgent = logModel.UserAgent,
SiteID = logModel.SiteID,
SessionID = logModel.SessionID,
MemberID = logModel.MemberID,
AddTime = logModel.AddTime,
IP = logModel.IP,
IPNum = logModel.IPNum
});
}
return(true);
}
