sample.aspx

掌握学习.net开发的非常好的资料

                    case "salesbyday":
                    case "salesbyday/hour":
                    case "salesbyhours":
                    case "salesbyweek":
                    case "salesbyweeks":
                    case "salesbyweek/day":
                    case "salesbymonth/day":
                    case "salesbymonth":
                    case "salesbydays":
                    case "salesbyyear":
                    case "salesbyquarter":
                    case "salesbyyear/month":
                    case "salesbymonths":
                    case "salesbyquarters":
                    case "salesbyyears":
                    {
                        switch(splitBy.ToLower())
                        {
                            case "customer":
                            	Chart.Title="Sales By customer";
                                SqlSelect = new StringBuilder("SELECT  OrderDate,Total, Name FROM Orders ",128);
                                if(where !=null)
                                    SqlSelect.Append(where);
                                SqlSelect.Append(" ORDER BY Orders.OrderDate");
                                Chart.Series.SqlStatement= SqlSelect.ToString();
                                Chart.SeriesCollection.Add();
                                break;
                            default:
                            	Chart.Title="Sales";
                                SqlSelect = new StringBuilder("SELECT OrderDate,Total FROM Orders ");
                                if(where !=null)
                                    SqlSelect.Append(where);
                                SqlSelect.Append(" ORDER BY OrderDate");
                                Chart.Series.SqlStatement= SqlSelect.ToString();
                                Chart.SeriesCollection.Add();
                                break;
                            }
                        }
                    break;
                 case "ordersbyday/hour":
                case "ordersbyday":
                case "ordersbyhours":
                case "ordersbyweek":
                case "ordersbyweek/day":
                case "ordersbymonth/day":
                case "ordersbymonth":
                case "ordersbydays":
                case "ordersbyyear":
                case "ordersbyquarter":
                case "ordersbyyear/month":
                case "ordersbymonths":
    			   case "ordersbyweeks":
                case "ordersbyyears":
                case "ordersbyquarters":
                    {
                        switch(splitBy.ToLower())
                        {

                            case "customer":
                            	Chart.Title="Orders by customer";
                                SqlSelect = new StringBuilder("SELECT  OrderDate,1 AS q, Name FROM Orders ",128);
                                if(where !=null)
                                    SqlSelect.Append(where);
                                SqlSelect.Append(" ORDER BY Orders.OrderDate");
                                Chart.Series.SqlStatement= SqlSelect.ToString();
                                Chart.SeriesCollection.Add();
                                break;
                            default:
                            	Chart.Title="Orders";
                                SqlSelect = new StringBuilder("SELECT OrderDate,1 AS q FROM Orders ");
                                if(where !=null)
                                    SqlSelect.Append(where);
                                SqlSelect.Append(" ORDER BY OrderDate");
                                Chart.Series.SqlStatement= SqlSelect.ToString();
                                Chart.SeriesCollection.Add();
                                break;
                            }
                      }
                break;
     
                case "itemsbyday/hour":
                case "itemsbyday":
                case "itemsbyhours":
                case "itemsbyweek/day":
                case "itemsbyweek":
                case "itemsbymonth/day":
                case "itemsbymonth":
                case "itemsbyweeks":
                case "itemsbydays":
                case "itemsbyyear":
                case "itemsbyquarter":
                case "itemsbyyear/month":
                case "itemsbymonths":
                case "itemsbyyears":
                case "itemsbyquarters":
                {
                    switch(splitBy.ToLower())
                    {

                        case "customer":
                        	Chart.Title="Items by customer";
                            SqlSelect = new StringBuilder(@"SELECT  OrderDate,Sum(Quantity) AS CountOfQuantity, Name FROM Orders",128);
                            if(where !=null)
                                SqlSelect.Append(where);
                            SqlSelect.Append(" GROUP BY Orders.OrderDate, Orders.Name ORDER BY Orders.OrderDate");
                            Chart.Series.SqlStatement= SqlSelect.ToString();
                            Chart.SeriesCollection.Add();
                            break;
                        default:
                        	Chart.Title="Items";
                            SqlSelect = new StringBuilder("SELECT  OrderDate,Sum(Quantity) FROM Orders ",128);
                            if(where !=null)
                               SqlSelect.Append(where);
                            SqlSelect.Append(" GROUP BY Orders.OrderDate ORDER BY Orders.OrderDate");
                            Chart.Series.SqlStatement= SqlSelect.ToString();
                            Chart.SeriesCollection.Add();
                            break;
                        }
                    }
                break;
    
                case "salesbycustomer":
                	Chart.Title="Sales by customer";
                    SqlSelect = new StringBuilder("SELECT  Orders.Name,Sum(Orders.Total) AS TotalOrders FROM Orders ");
                            if(where !=null)
                               SqlSelect.Append(where);
                            SqlSelect.Append(" GROUP BY Orders.Name ORDER BY Count(Orders.Total) DESC");
                    Chart.Series.SqlStatement= SqlSelect.ToString();
                    Chart.SeriesCollection.Add();
                break;
                case "itemsbycustomer":
                	Chart.Title="Items by customer";
                    SqlSelect = new StringBuilder("SELECT Name,Sum(Quantity) FROM Orders ");
                            if(where !=null)
                               SqlSelect.Append(where);
                            SqlSelect.Append(" GROUP BY Name ORDER BY Sum(Quantity) DESC");
                    Chart.Series.SqlStatement= SqlSelect.ToString();    
                    Chart.SeriesCollection.Add();
                break;
    
                case "ordersbycustomer":
                	Chart.Title="Orders by customer";
              				SqlSelect = new StringBuilder("SELECT Name,Count(1) FROM Orders ",128);
                            if(where !=null)
                               SqlSelect.Append(where);
                            SqlSelect.Append(" GROUP BY Name ORDER BY Count(1) DESC");
                            Chart.Series.SqlStatement= SqlSelect.ToString();
                    Chart.SeriesCollection.Add();
                break;

                //**************************************************************************    
                }
                }
                if(seriesAggregation!="")
                {                  
                   
                        Chart.Series.Name = seriesAggregation;
                        Chart.Series.Type = (dotnetCHARTING.SeriesType)Enum.Parse(typeof(dotnetCHARTING.SeriesType),SummerySeriesType.SelectedItem.Value,true);
                        Chart.SeriesCollection.Add((dotnetCHARTING.Calculation)Enum.Parse(typeof(dotnetCHARTING.Calculation), seriesAggregation,true));
                        
                }
    }
</script>
<html>
<head>
    <title>Report Options</title>
</head>
<body topmargin="0" leftmargin="0" marginheight="0" marginwidth="0">
    <form runat="server">
        <div align="center">
            <table border="1" cellpadding="3" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber1">
                <tbody>
                <tr>
    <td width="1%">
<img border="0" src="../../images/dotnetCharting.gif" width="230" height="94"></td>
    <td width="99%" bgcolor="#BFC0DB">Report: 
 <ASP:DropDownList id=DropDownShow runat="server" name="DropDownShow" size="1">
    </ASP:DropDownList>&nbsp;By:&nbsp; 
<ASP:DropDownList id="DropDownBy" runat="server" name="DropDownBy" size="1">
    </ASP:DropDownList>
<ASP:DropDownList id="Month" runat="server" name="Month" size="1">
    </ASP:DropDownList>/
<ASP:DropDownList id="Day" runat="server" name="Day" size="1">
    </ASP:DropDownList>/
<ASP:DropDownList id="Year" runat="server" name="Year" size="1">
    </ASP:DropDownList>
Split By: 
    <ASP:DropDownList id="SplitBy" runat="server" size="1"/>
 Limit Series:
 <asp:TextBox id="SplitByLimit" Width=25 runat="server" /> 
        <br>From Date: 
    <ASP:DropDownList id="MonthFrom" runat="server" name="MonthFrom" size="1">
    </ASP:DropDownList>/
<ASP:DropDownList id="DayFrom" runat="server" name="DayFrom" size="1">
    </ASP:DropDownList>/
<ASP:DropDownList id="YearFrom" runat="server" name="YearFrom" size="1">
    </ASP:DropDownList>
&nbsp;To Date: 
      <ASP:DropDownList id="MonthTo" runat="server" name="MonthTo" size="1">
    </ASP:DropDownList>/
<ASP:DropDownList id="DayTo" runat="server" name="DayTo" size="1">
    </ASP:DropDownList>/
<ASP:DropDownList id="YearTo" runat="server" name="YearTo" size="1">
    </ASP:DropDownList>
&nbsp;Limit Elements: <asp:TextBox id="TextBoxLimit" Width=25 runat="server" ></asp:TextBox>
Limit Mode:<ASP:DropDownList id="DropDownLimitMode" runat="server" name="DropDownLimitMode" size="1"> 
    </ASP:DropDownList>
	<asp:CheckBox id="ShowOther" Text="Show other" value="showOther" runat="server"/>
      <asp:CheckBox id="ShowValues" Text="Show Values" runat="server"/>
        <asp:CheckBox id="Average" Text="Average" runat="server"/>
      	<asp:CheckBox id="Sum" Text="Sum" runat="server"/>
      	<asp:CheckBox id="Mode" Text="Mode" runat="server"/>
		<asp:CheckBox id="Median" Text="Median" runat="server"/>
		<asp:CheckBox id="Min" Text="Minimum" runat="server"/>
		<asp:CheckBox id="Max" Text="Maximum" runat="server"/>
	
of series. Chart Type: 
    <ASP:DropDownList id="DropDownChartType" runat="server" name="DropDownChartType" size="1">
    </ASP:DropDownList>&nbsp; 
     Axis Scale:<ASP:DropDownList id="DropDownScale" runat="server" name="DropDownScale" size="1">
    </ASP:DropDownList>&nbsp;
    Transpose:
		<asp:CheckBox id="Transpose" runat="server"/>

<ASP:DropDownList id=Chart3D runat="server" name="Chart3D" size="1">
    </ASP:DropDownList>&nbsp; 
<ASP:DropDownList id=DropDownSeriesType runat="server" name="DropDownSeriesType" size="1">
    </ASP:DropDownList>
    &nbsp;Summary series: 
    <ASP:DropDownList id="DropDownSeriesAggregation" runat="server" name="DropDownSeriesAggregation" size="1">
    </ASP:DropDownList>
    <ASP:DropDownList id="SummerySeriesType" runat="server" name="SummerySeriesType" size="1">
    </ASP:DropDownList>
    <asp:Button id="ButtonDisplay" onclick="ButtonDisplay_Click" runat="server" Text="Display">
    </asp:Button>
                  </td>
  
                                        
                </tbody>
            </table>
            <DOTNET:Chart id="Chart" runat="server" ShowDataGrid="true" Visible="false" />
        </div>
    </form></body>
</html>