public IList <TopVisitInfo> GetVisitInfoByIp(string nickNo, string ip, DateTime start, DateTime end)
{
string sql = SQL_SELECT_VISITINFO_BYIP.Replace("@tableName", GetRealTable(nickNo));
SqlParameter[] param = new[]
{
new SqlParameter("@start", start),
new SqlParameter("@end", end),
new SqlParameter("@VisitIP", ip)
};
DataTable dt = DBHelper.ExecuteDataTable(sql, param);
IList <TopVisitInfo> list = new List <TopVisitInfo>();
foreach (DataRow dr in dt.Rows)
{
TopVisitInfo info = new TopVisitInfo();
info.VisitUrl = dr["VisitUrl"].ToString();
info.VisitTime = DateTime.Parse(dr["VisitTime"].ToString());
info.GoodsId = dr["GoodsId"].ToString();
info.GoodsClassId = dr["GoodsClassId"].ToString();
list.Add(info);
}
IList <TopVisitInfo> rlist = list.OrderBy(o => o.VisitTime).ToList();
return(rlist);
}
public IList <TopVisitInfo> GetVisitNowInfoList(string nickNo, DateTime start, DateTime end)
{
string sql = SQL_SELECT_VISITNOW.Replace("@tableName", GetRealTable(nickNo));
SqlParameter[] param = new[]
{
new SqlParameter("@start", start),
new SqlParameter("@end", end)
};
DataTable dt = DBHelper.ExecuteDataTable(sql, param);
IList <TopVisitInfo> list = new List <TopVisitInfo>();
foreach (DataRow dr in dt.Rows)
{
//VisitUrl,VisitIP,LastURL,VisitTime
TopVisitInfo info = new TopVisitInfo();
info.VisitUrl = dr["VisitUrl"].ToString();
info.VisitIP = dr["VisitIP"].ToString();
info.LastURL = dr["LastURL"].ToString();
info.VisitTime = DateTime.Parse(dr["VisitTime"].ToString());
list.Add(info);
}
return(list);
}
private static void InsertInfo(TopVisitInfo info)
{
VisitService visitDal = new VisitService();
//测试用
string nickNo = BasePage.Encrypt(info.VisitShopId);
visitDal.CreateTable(nickNo);
visitDal.InsertVisitInfo(info, nickNo);
}
private static SqlParameter[] CreateParameter(TopVisitInfo info)
{
SqlParameter[] param = new[]
{
new SqlParameter("@VisitID", info.VisitID),
new SqlParameter("@VisitIP", info.VisitIP),
new SqlParameter("@VisitUrl", info.VisitUrl),
new SqlParameter("@VisitTime", info.VisitTime),
new SqlParameter("@VisitUserAgent", info.VisitUserAgent),
new SqlParameter("@VisitBrower", info.VisitBrower),
new SqlParameter("@VisitOSLanguage", info.VisitOSLanguage),
new SqlParameter("@GoodsId", info.GoodsId),
new SqlParameter("@GoodsClassId", info.GoodsClassId)
};
return(param);
}
private TopVisitInfo CreateVisitInfo(string refer)
{
TopVisitInfo info = new TopVisitInfo();
info.VisitID = Guid.NewGuid();
info.VisitIP = GetIPAddress();
info.VisitTime = GetVisitTime();
info.VisitUrl = GetUrl();
info.VisitUserAgent = GetUserAgent();
info.VisitBrower = GetBrower();
info.VisitOSLanguage = GetOSLanguage();
info.VisitShopId = HttpUtility.UrlDecode(Request.QueryString["id"]); // "234543534"
info.LastURL = refer;
info.GoodsId = "";
info.GoodsClassId = "";
return(info);
}
public IList <TopVisitInfo> GetIndexOnlineCustomer(string nickNo, int topNum, DateTime start, DateTime end)
{
string sql = SQL_INDEX_TOP_ONLINECUSTOMER.Replace("@tableName", GetRealTable(nickNo)).Replace("@topNum", topNum.ToString());
SqlParameter[] param = new[]
{
new SqlParameter("@start", start),
new SqlParameter("@end", end)
};
DataTable dt = DBHelper.ExecuteDataTable(sql, param);
IList <TopVisitInfo> list = new List <TopVisitInfo>();
foreach (DataRow dr in dt.Rows)
{
TopVisitInfo info = new TopVisitInfo();
info.VisitIP = dr["VisitIP"].ToString();
info.VisitTime = DateTime.Parse(dr["VisitTime"].ToString());
list.Add(info);
}
IList <TopVisitInfo> rlist = list.OrderByDescending(o => o.VisitTime).ToList();
return(rlist);
}
//指定表插入一条浏览记录
public void InsertVisitInfo(TopVisitInfo info, string nickNo)
{
string sql = SQL_INSERT_TABLE.Replace("@tableName", GetRealTable(nickNo));
DBHelper.ExecuteNonQuery(sql, CreateParameter(info));
}
