📄 pagingelements.aspx

📁 掌握学习.net开发的非常好的资料
💻 ASPX
字号:
<%@ Import Namespace="System.Text" %>
<%@ Import Namespace="System.Drawing" %>
<%@ Register TagPrefix="dotnet"  Namespace="dotnetCHARTING" Assembly="dotnetCHARTING"%>
<%@ Page Language="C#" Debug="true" Trace="false" EnableSessionState="true" Description="dotnetCHARTING Component" %>
<HTML>
	<HEAD>
		<TITLE>Paging Elements</TITLE>
		<script runat="server">
int currentPage = 1 ;
int pageSize=4;
void Page_Load(Object sender,EventArgs e)
{
	//set global properties
    Chart.Width = 700;
    Chart.Height = 300;
    Chart.TempDirectory="temp";
    Chart.Debug=true;
    Chart.Title="Item sales";   
    Chart.TitleBox.Position = TitleBoxPosition.Right;
    Chart.TitleBox.ClearColors();
    Chart.XAxis.Label.Text="Year 2002";
    

	// Get the page from the query string.
    if(Request.QueryString["Page"]!=null)
    	currentPage = Convert.ToInt32(Request.QueryString["Page"]);
    	
	//set global database properties
    Chart.DefaultSeries.ConnectionString = Server.MapPath("../../database/chartsample.mdb"); 
    Chart.DefaultSeries.StartDate=new System.DateTime(2002,1,1,0,0,0);
    Chart.DefaultSeries.EndDate = new System.DateTime(2002,12,31,23,59,59);
    Chart.DefaultSeries.SqlStatement= @"SELECT Name,Sum(Quantity) FROM Orders  WHERE OrderDate >= #STARTDATE# AND OrderDate <= #ENDDATE#  GROUP BY Name";  							
 
    
     //Add a series
    Chart.Series.Name="Items 1";
    Chart.Series.Limit= currentPage.ToString() + "x" + pageSize.ToString();       
	Chart.Series.LimitMode = dotnetCHARTING.LimitMode.Top;
	Chart.Series.ShowOther=false;
    Chart.SeriesCollection.Add();
    
     //Add a series
    Chart.Series.Name="Other";
    Chart.Series.Limit= currentPage.ToString() + "x" + pageSize.ToString();       
	Chart.Series.LimitMode = dotnetCHARTING.LimitMode.ExcludeTop;
	Chart.Series.ShowOther=false;
	//Chart.Series.Visible=false;
    Chart.SeriesCollection.Add();

   
    
	
	
	// Create an annotation button          
	Annotation an2 = new Annotation(" < Previous");
	setAnnotation(an2);
	
	an2.Position = new Point(49,20);
	an2.CornerTopLeft = BoxCorner.Cut;
	an2.CornerTopRight = BoxCorner.Square;
	an2.Size = new Size(85,16);
	Chart.Annotations.Add(an2);
	
	// Activate it
	if(currentPage > 1)
	{
		an2.URL = "PagingElements.aspx?page=" + Convert.ToString(currentPage-1);
	}
	else
		an2.Label.Color = Color.Gray;
		
 
 


   
    
Chart.PostDataProcessing +=new PostDataProcessingEventHandler(OnPostDataProcessing);

}

void setAnnotation(Annotation an)
{
	// Set default annotation properties
	an.DefaultCorner = BoxCorner.Square;
	an.Size = new Size(66,16);
	an.Background = new Background(Color.FromArgb(241,250,180), Color.White,90);
	an.Label.Font = new Font("verdana",7.7f,FontStyle.Bold);
	an.CornerTopRight = BoxCorner.Cut;
	an.Padding = 2;
	
}

void OnPostDataProcessing(Object sender)
{
	int totalElements=Chart.SeriesCollection[0].TotalElements;
	int totalPage = totalElements%pageSize==0?totalElements/pageSize:(totalElements/pageSize)+1;
	
	//Create the next button annotation
	Annotation an = new Annotation("Next >");
	setAnnotation(an);
	an.Position = new Point(224,20);
	
	// Activate it
	if(totalPage>currentPage)
	{
		an.URL = "PagingElements.aspx?page=" + Convert.ToString(currentPage+1);
	}
	else
		an.Label.Color = Color.Gray;
	
	// 	
	Annotation an2 = new Annotation("(Page "+currentPage+" of "+totalPage+")");
	
	
	setAnnotation(an2);
	an2.Size = new Size(90,16);
	an2.Position = new Point(134,20);
	an2.CornerTopRight = BoxCorner.Square;
	an2.Label.Font = new Font("arial",7.7f);
	an2.Label.Color = Color.DarkBlue;
		
	Chart.Annotations.Add(an,an2);
	
	ElementCollection otherElements = Chart.SeriesCollection[1].Elements;
	StringBuilder otherList = new StringBuilder();
	foreach(Element el in otherElements)
		otherList.Append(el.Name + ", ");
	
	if(otherList.Length>0)
	{
		otherList.Insert(0,"Others:\n");
		otherList.Remove(otherList.Length-2,2);
		
		Annotation an3 = new Annotation(otherList.ToString());	
		an3.Position = new Point(580,60);
		an3.Size =new Size(110,60);
		an3.CornerTopLeft = BoxCorner.Square;
		an3.Label.Font = new Font("arial",7.7f);
		an3.Label.Color = Color.Black;
				
		Chart.Annotations.Add(an,an3);

	}
	Chart.SeriesCollection.RemoveAt(1);

	
}

		</script>
	</HEAD>
	<body topmargin="0" leftmargin="0" marginheight="0" marginwidth="0">
		<DIV align="center">
			<dotnet:Chart id="Chart" runat="server" />
		</DIV>
	</body>
</HTML>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -