/// <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 "{}"; }