public static void Add(WebLogVisitInfo model) { string strSQL = "INSERT INTO Visit(Url,Referrer,Querys,IP,UserAgent,VisitTime,SiteId,OS,Brower,UserName) VALUES(@Url,@Referrer,@Querys,@IP,@UserAgent,GETDATE(),@SiteId,@OS,@Brower,@UserName) "; SqlParameter[] parms = { new SqlParameter("Url", SqlDbType.NVarChar), new SqlParameter("Referrer", SqlDbType.NVarChar), new SqlParameter("Querys", SqlDbType.NVarChar), new SqlParameter("UserAgent", SqlDbType.NVarChar), new SqlParameter("SiteId", SqlDbType.Int), new SqlParameter("OS", SqlDbType.NVarChar), new SqlParameter("Brower", SqlDbType.NVarChar), new SqlParameter("UserName", SqlDbType.NVarChar), new SqlParameter("IP", SqlDbType.NVarChar), }; parms[0].Value = model.Url; parms[1].Value = model.Referrer; parms[2].Value = model.Querys; parms[3].Value = model.UserAgent; parms[4].Value = model.SiteId; parms[5].Value = model.OS; parms[6].Value = model.Brower; parms[7].Value = model.UserName; parms[8].Value = model.IP; SQLPlus.ExecuteNonQuery("weblog", CommandType.Text, strSQL, parms); }
public void Statistics() { WebLogVisitInfo visitInfo = new WebLogVisitInfo(); visitInfo.IP = Goodspeed.Common.BrowserInfo.Current.IP; visitInfo.Querys = Goodspeed.Common.BrowserInfo.Current.Referrer == null ? string.Empty : Goodspeed.Common.BrowserInfo.Current.Referrer.Query; visitInfo.Referrer = Controleng.Common.CECRequest.GetQueryString("referrer"); visitInfo.Url = Goodspeed.Common.BrowserInfo.Current.Referrer == null ? string.Empty : Goodspeed.Common.BrowserInfo.Current.Referrer.ToString(); visitInfo.UserAgent = Request == null ? string.Empty : (string.IsNullOrEmpty(Request.UserAgent) ? string.Empty : Request.UserAgent); visitInfo.SiteId = CECRequest.GetQueryInt("siteid", 0); visitInfo.Brower = Goodspeed.Common.BrowserInfo.Current.Browser; visitInfo.OS = Goodspeed.Common.BrowserInfo.Current.OS; visitInfo.UserName = User.Identity.Name; if (string.IsNullOrEmpty(visitInfo.Url)) { return; } WebLogVisitService.Add(visitInfo); Response.AddHeader("Expires", DateTime.Now.Add(TimeSpan.FromHours(5)).ToUniversalTime().ToString("r")); Response.End(); }
public static void Add(WebLogVisitInfo model) { WebLogVisitManage.Add(model); }