private static Parameters GetStatVisitorParameters(StatVisitorInfo statVisitorInfo) { Parameters parameters = new Parameters(); parameters.AddInParameter("@Ip", DbType.AnsiString, statVisitorInfo.IP); parameters.AddInParameter("@Address", DbType.String, statVisitorInfo.Address); parameters.AddInParameter("@System", DbType.AnsiString, statVisitorInfo.System); parameters.AddInParameter("@Browser", DbType.AnsiString, statVisitorInfo.Browser); parameters.AddInParameter("@Screen", DbType.AnsiString, statVisitorInfo.Screen); parameters.AddInParameter("@Color", DbType.AnsiString, statVisitorInfo.Color); parameters.AddInParameter("@Referer", DbType.AnsiString, statVisitorInfo.Referer); parameters.AddInParameter("@Timezone", DbType.Int32, statVisitorInfo.Timezone); return(parameters); }
private static StatVisitorInfo StatVisitorFromrdr(NullableDataReader rdr) { StatVisitorInfo info = new StatVisitorInfo(); info.Id = rdr.GetInt32("Id"); info.VTime = rdr.GetDateTime("VTime"); info.IP = rdr.GetString("Ip"); info.Address = rdr.GetString("Address"); info.System = rdr.GetString("System"); info.Browser = rdr.GetString("Browser"); info.Screen = rdr.GetString("Screen"); info.Color = rdr.GetString("Color"); info.Referer = rdr.GetString("Referer"); info.Timezone = rdr.GetInt32("Timezone"); return(info); }
public static bool StatVisitorAdd() { HttpRequest request = HttpContext.Current.Request; StatVisitorInfo statVisitorInfo = new StatVisitorInfo(); statVisitorInfo.VTime = DateTime.Now; statVisitorInfo.IP = PEContext.Current.UserHostAddress; statVisitorInfo.Referer = request.ServerVariables["HTTP_REFERER"]; statVisitorInfo.Browser = request.Browser.Browser + request.Browser.Version; statVisitorInfo.System = string.IsNullOrEmpty(request.Browser.Platform) ? "其它" : request.Browser.Platform; statVisitorInfo.Timezone = 8; statVisitorInfo.Screen = ""; statVisitorInfo.Address = IPScanner.IPLocation(PEContext.Current.UserHostAddress); statVisitorInfo.Color = ""; return(dal.StatVisitorAdd(statVisitorInfo)); }
protected void Page_Load(object sender, EventArgs e) { if ((!base.IsPostBack && (base.PreviousPage != null)) && (base.PreviousPage.Items["StatVisitorId"] != null)) { StatVisitorInfo statVisitorById = OtherReport.GetStatVisitorById(DataConverter.CLng(base.PreviousPage.Items["StatVisitorId"])); if (!statVisitorById.IsNull) { int masterTimeZone = OtherReport.GetStatInfoListInfo().MasterTimeZone; DateTime time = statVisitorById.VTime.AddHours((double)(statVisitorById.Timezone - (masterTimeZone / 60))); this.LblVTime.Text = statVisitorById.VTime.ToString(); this.LblIP.Text = statVisitorById.IP; this.LblTimezone.Text = "GMT" + statVisitorById.Timezone.ToString(); this.LblAddress.Text = statVisitorById.Address; this.LblClientTime.Text = time.ToString(); this.LblReferer.Text = statVisitorById.Referer; this.LblSystem.Text = statVisitorById.System; this.LblBrowser.Text = statVisitorById.Browser; this.LblScreen.Text = statVisitorById.Screen; this.LblColor.Text = statVisitorById.Color; } } }
public bool StatVisitorAdd(StatVisitorInfo statVisitorInfo) { return(DBHelper.ExecuteProc("PR_Analytics_StatVisitor_Add", GetStatVisitorParameters(statVisitorInfo))); }