/// <summary>
/// 创建 dataPage页面，首先要传入 装载页面的容器 PageView，这个方法 没有 缓存
/// </summary>
/// <param name="pLayer"></param>
/// <param name="features"></param>
/// <returns></returns>
private static PagerPage CreateMapDataPage(ILayer pLayer, IList <IFeature> features)
{
PageViewItem pageViewItem = new PageViewItem();
pageViewItem.Header = pLayer.Name;
DataGrid dataGrid = new DataGrid();
pageView.Items.Add(pageViewItem);
//pageView.Items.Insert(0, pageViewItem);
pageView.SelectedIndex = pageView.Items.Count - 1;
PagerPage pagerPage = GetPagerPage(pLayer, features);
pageViewItem.Padding = new Thickness(0);
pageViewItem.Margin = new Thickness(3, 0, 3, 0);
pageViewItem.Content = pagerPage;
// pageViewItem.MouseDoubleClick += PageViewItem_DBClick;
return(pagerPage);
}
private string getTrafficOrigin(string distributor, string startDate, string endDate, string blog)
{
combineBlogDistributor(blog, distributor);
// select distinct(refer), COUNT(id) as visit from tb_page_visit_info_xango where distributor='paul' and visit_time >= '2016-05-05' and visit_time <= '2016-06-03' group by refer order by visit desc
string strSQL = "";
try
{
string strClause = String.IsNullOrEmpty(startDate) ? "" : string.Format(" and convert(date, visit_time) >= '{0}'", startDate);
string strClause2 = String.IsNullOrEmpty(endDate) ? "" : string.Format(" and convert(date, visit_time) <= '{0}'", endDate);
strSQL = string.Format("select top 5 refer, COUNT(*) as visit, COUNT(*) * 1.0/ SUM(COUNT(*)) over() as percentage, SUM(COUNT(*)) over() as total from tb_page_visit_info_xango where distributor='{0}'{1}{2} group by refer order by percentage desc", distributor, strClause, strClause2);
}
catch (Exception e)
{
AdssLogger.WriteLog("GetSampleAnalyticsInfo(getTrfficOrigin) --- Exception: " + e.Message);
return "{}";
}
try
{
using (SqlConnection sc = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlserver"].ConnectionString))
{
if (sc != null)
{
DataSet ds = SqlHelper.ExecuteDataset(sc, CommandType.Text, strSQL);
if (ds != null && ds.Tables.Count > 0)
{
TopFiveStat tfs = new TopFiveStat();
tfs.list = new List<PageViewItem>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow r = ds.Tables[0].Rows[i];
PageViewItem pv = new PageViewItem();
pv.page = Convert.ToString(r[0]);
pv.count = Convert.ToInt32(r[1]);
pv.percentage = string.Format("{0:P1}", Convert.ToSingle(r[2]));
tfs.list.Add(pv);
tfs.total = Convert.ToInt32(r[3]);
}
return new JavaScriptSerializer().Serialize(tfs);
}
}
}
}
catch (Exception e)
{
//Trace.WriteLine(e.Message);
AdssLogger.WriteLog("GetSampleAnalyticsInfo(getTrfficOrigin) --- Exception: " + e.Message + " --- sql: " + strSQL);
}
return "{}";
}
