/// <summary>
/// 处理访问参数
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private AccessLogEntity InitAccessLog(System.Web.HttpContext context)
{
string realIp = GetRealClientIp(context);
string urlHost = new RequestHelp().GetHost(context);
string urlRaw = context.Request.RawUrl.ToString();
AccessLogEntity entity = new AccessLogEntity();
entity.WebSiteName = urlHost;
entity.UrlAddress = context.Request.Url.ToString();
if (context.Session != null)
{
entity.SessionID = context.Session.SessionID;
}
if (context.Request != null)
{
entity.IPAddress = realIp;
entity.Browser = context.Request.Browser.Browser;
entity.BrowserID = context.Request.Browser.Id;
entity.BrowserVersion = context.Request.Browser.Version;
entity.BrowserType = context.Request.Browser.Type;
entity.BrowserPlatform = context.Request.Browser.Platform;
if (context.Request.UrlReferrer != null)
{
entity.PUrlAddress = context.Request.UrlReferrer.ToString();
}
}
entity.EnabledMark = true;
return(entity);
}
/// <summary>
/// 创建前台页面访问日志
/// </summary>
/// <param name="accessLogEntity"></param>
private void InsertAccessLog(AccessLogEntity entity)
{
entity = InitAccessLog(entity, true);
AccessLogApp accessLogApp = new AccessLogApp();
accessLogApp.Createlog(entity);
}
/// <summary>
/// 创建前台页面访问日志
/// </summary>
/// <param name="accessLogEntity"></param>
public void CreateAccessLog(System.Web.HttpContext context, bool IsAsync)
{
if (IsAsync)
{
AccessLogEntity entity = InitAccessLog(context);
HttpCookie cookie = context.Request.Cookies.Get(CLINETID);
if (cookie != null && !string.IsNullOrEmpty(cookie.Value))
{
entity.ClientID = cookie.Value;
}
else
{
string clientIds = Guid.NewGuid().ToString();
entity.ClientID = clientIds;
cookie = new HttpCookie(CLINETID);
cookie.Name = CLINETID;
cookie.Value = clientIds;
cookie.Expires = DateTime.Now.AddYears(1);
entity.ClientID = clientIds;
context.Response.Cookies.Set(cookie);
}
Thread thread = new Thread(new ThreadStart(() =>
{
InsertAccessLog(entity);
}));
thread.Start();
}
else
{
AccessLogEntity entity = InitAccessLog(context);
InsertAccessLog(entity);
}
}
/// <summary>
/// 处理访问参数
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private AccessLogEntity InitAccessLog(AccessLogEntity entity, bool IsProcessWebSite)
{
WebSiteApp app = new WebSiteApp();
WebSiteEntity webSiteEntity = app.GetModelByUrlHost(entity.WebSiteName);
if (webSiteEntity != null)
{
entity.WebSiteId = webSiteEntity.Id;
}
return(entity);
}
public void SubmitForm(AccessLogEntity accessLogEntity, string keyValue)
{
if (!string.IsNullOrEmpty(keyValue))
{
accessLogEntity.Modify(keyValue);
service.Update(accessLogEntity);
}
else
{
accessLogEntity.Create();
service.Insert(accessLogEntity);
}
}
//
public static List <AccessLogEntity> GetAccessLog
(
string constring
)
{
//
List <AccessLogEntity> listLog = new List <AccessLogEntity>();
//
using (var connection = new SqlConnection(constring))
{
//
connection.Open();
//
string tsql = Build_6_Tsql_SelectLog(LogType.Info);
//
using (var command = new SqlCommand(tsql, connection))
{
//
using (SqlDataReader reader = command.ExecuteReader())
{
//
while (reader.Read())
{
//
int id_Column = Convert.ToInt32(reader["ID_Column"]);
string pageName = (string)reader["PageName"];
System.DateTime accessDate = (DateTime)reader["AccessDate"];
string ipValue = (string)reader["IPValue"];
//
AccessLogEntity Obj = new AccessLogEntity();
//
Obj.Id_Column = id_Column;
Obj.PageName = pageName;
Obj.AccessDate = accessDate;
Obj.IPValue = ipValue;
//
listLog.Add(Obj);
}
}
}
}
//
return(listLog);
}
//
public void CrearExcel()
{
//
string nombreHoja = "LOG";
//
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
ExcelPackage excel = new ExcelPackage();
//
using (excel = new ExcelPackage(new FileInfo(_resultFilePath)))
{
//
excel.Workbook.Worksheets.Add(nombreHoja);
excel.Save();
//
var hojaActual = excel.Workbook.Worksheets[nombreHoja];
//-----------------------------------------------------------
// ENCABEZADO
//-----------------------------------------------------------
//
List <string> headerNames = new List <string>();
//
headerNames.Add("PAGE_NAME");
headerNames.Add("ACCESS_DATE");
headerNames.Add("IP_VALUE");
//
for (int index = 0; index < headerNames.Count; index++)
{
//
string cellPosition = string.Format(@"{0}1", GetCellPositionFromIndex((index + 1)));
string cellValue = headerNames[index];
//
hojaActual.Cells[cellPosition].Value = cellValue;
hojaActual.Cells[cellPosition].Style.Font.Color.SetColor(System.Drawing.Color.White);
hojaActual.Cells[cellPosition].Style.Font.Bold = true;
hojaActual.Cells[cellPosition].Style.Fill.PatternType = ExcelFillStyle.Solid;
hojaActual.Cells[cellPosition].Style.Fill.BackgroundColor.SetColor(System.Drawing.Color.SaddleBrown);
hojaActual.Cells[cellPosition].Style.Border.BorderAround(OfficeOpenXml.Style.ExcelBorderStyle.Thick);
}
//------------------------------------------------------------------
// CONTENIDO
//------------------------------------------------------------------
for (int index = 0; index < this._listadoAccessLog.Count; index++)
{
//
AccessLogEntity accessLogEntity = this._listadoAccessLog[index];
string cellPosition = string.Empty;
string cellValue = string.Empty;
// PAGE_NAME
cellPosition = string.Format(@"A{0}", (index + 2));
cellValue = accessLogEntity.PageName;
hojaActual.Cells[cellPosition].Value = cellValue;
hojaActual.Cells[cellPosition].Style.Border.BorderAround(OfficeOpenXml.Style.ExcelBorderStyle.Thin);
// ACCESS_DATE
cellPosition = string.Format(@"B{0}", (index + 2));
cellValue = accessLogEntity.AccessDate.ToString();
hojaActual.Cells[cellPosition].Value = cellValue;
hojaActual.Cells[cellPosition].Style.Border.BorderAround(OfficeOpenXml.Style.ExcelBorderStyle.Thin);
// IP_VALUE
cellPosition = string.Format(@"C{0}", (index + 2));
cellValue = accessLogEntity.IPValue;
hojaActual.Cells[cellPosition].Value = cellValue;
hojaActual.Cells[cellPosition].Style.Border.BorderAround(OfficeOpenXml.Style.ExcelBorderStyle.Thin);
}
//--------------------------------------------------------------------
// FORMATEAR DOCUMENTO
//--------------------------------------------------------------------
hojaActual.Cells.AutoFitColumns();
hojaActual.View.ShowGridLines = false;
hojaActual.View.FreezePanes(2, 1);
excel.Save();
}
}
/// <summary>
/// 创建访问日志
/// </summary>
/// <param name="accessLogEntity"></param>
public void Createlog(AccessLogEntity accessLogEntity)
{
accessLogEntity.Id = Common.GuId();
accessLogEntity.Date = DateTime.Now;
service.Insert(accessLogEntity);
}
