天天看點
傳回

報表動态代碼

頁面前台

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="IntegrateSonChart.aspx.cs"

    Inherits="Com.DRPENG.INFOPLAT.UI.XFZGL.ScoreManager.Report.IntegrateSonChart"

    ResponseEncoding="utf-8" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>

<head>

    <title>綜合分析各率分布圖</title>

    <script language="Javascript" src="FusionCharts/FusionCharts.js"></script>

    <link href="../../css/main.css" target="_blank" rel="external nofollow" type="text/css" rel="stylesheet" />

</head>

<body>

    <form id="form1" runat="server">

    <div align="center">

        <asp:Label ID="lblTopInfo" Font-Size="Large" Font-Bold="true" Text="各率分布圖" runat="server"></asp:Label></div>

    <div align="center" runat="server">

        <asp:RadioButtonList runat="server" ID="rdoList" AutoPostBack="true" OnSelectedIndexChanged="RG_SelectedIndexChanged"

            RepeatDirection="Horizontal">

        </asp:RadioButtonList>

    </div>

    </form>

    <%=GetProductChartHtml()%>

</body>

</html>

頁面背景

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Text;

using ScoreManageModule.BusinessModel;

using ScoreManageModule.DataModel;

using Com.DRPENG.SDXY.BasicData.Business;

using Com.DRPENG.SDXY.BasicData.DataModel;

using Com.DRPENG.SDXY.CouseModule.DataModel;

using Com.DRPENG.SDXY.CouseModule.Business;

using Com.DRPENG.Common.ControlFactory;

namespace Com.DRPENG.INFOPLAT.UI.XFZGL.ScoreManager.Report

{

    public partial class IntegrateSonChart : Com.DRPENG.Common.WebStruct.BaseForm

    {

        private static ScoreInfoOneMng ScoreMng = new ScoreInfoOneMng();

        private static ExamArrangeMng ExamArrangeMng = new ExamArrangeMng();

        private static ScoreAnalysis ScoreAnalysisMng = new ScoreAnalysis();

        private static ScoreAreaSetDetailMng ScoreAreaDtlMng = new ScoreAreaSetDetailMng();

        private static OrganizationManager orgMng = (OrganizationManager)ControlFactory.Instance.CreateManager(typeof(OrganizationManager));

        protected static EnrollGradeManager EnrollMng = (EnrollGradeManager)ControlFactory.Instance.CreateManager(typeof(EnrollGradeManager));

        protected static CourseStoreManager courseStoreMng = (CourseStoreManager)ControlFactory.Instance.CreateManager(typeof(CourseStoreManager));

        public static string ExamID, CourseCode, ScoreArea, ScoreArea2, ClassIDes;

        public static bool IsHaveScore, IsContran;

        protected void Page_Load(object sender, EventArgs e)

        {

            if (!IsPostBack)

            {

                ExamID = Request.QueryString["ExamID"];

                CourseCode = Request.QueryString["CourseCode"];

                ScoreArea = Request.QueryString["ScoreArea"];

                ScoreArea2 = Request.QueryString["ScoreArea2"];

                ClassIDes = Request.QueryString["ClassIDes"];

                IsContran = Request["IsContran"] == "1" ? true : false;

                IsHaveScore = false;

                if (!string.IsNullOrEmpty(ExamID))

                    RadorGroupInit(ScoreArea2);

                if (ExamArrangeMng.ValidExam(new Guid(ExamID)))

                {

                    string NewCls = string.Empty;

                    foreach (string str in ClassIDes.Split(','))

                    {

                        if (ExamArrangeMng.ValidExam(new Guid(ExamID), new Guid(str)))

                            NewCls += str + ",";

                    }

                    if (!string.IsNullOrEmpty(NewCls))

                    {

                        ClassIDes = NewCls.TrimEnd(',');

                        IsHaveScore = true;

                    }

                }

            }

        }

        /// <summary>

        /// 學校ID

        /// </summary>

        protected Guid SchoolID

        {

            get

            {

                return base. CurrentSchoolID;

            }

        }

        void RadorGroupInit(string scoreAreaID)

        {

            ArrayList ScoreAreaSet2 = ScoreAreaDtlMng.GetAllScoreAreaID(scoreAreaID);

            rdoList.DataSource = ScoreAreaSet2;

            rdoList.DataTextField = "ListName";

            rdoList.DataValueField = "ID";

            rdoList.DataBind();

            if (ScoreAreaSet2.Count > 0)

                rdoList.SelectedIndex = 0;

        }

        //生成圖形報表

        public string GetProductChartHtml()

        {

            if (!string.IsNullOrEmpty(rdoList.SelectedValue)&&IsHaveScore)

            {

                string ClassName = string.Empty;

                string ClassData = string.Empty;

                string[] Classes = ClassIDes.Split(',');

                string GradeCode = Request.QueryString["GradeCode"];

                ScoreAreaSetDetail detail = ScoreAreaDtlMng.SearchRecord(rdoList.SelectedValue);

                ExamArrange exam = ExamArrangeMng.GetExamArrange(new Guid(ExamID));

                DataTable dt = dt = ScoreAnalysisMng.ComprehensiveAnalysis(ExamID, CourseCode, Classes, ScoreArea, ScoreArea2, IsContran, SchoolID.ToString());

                lblTopInfo.Text = orgMng.QueryByID(new Guid(GradeCode)).Name + exam.ExamName + courseStoreMng.FindCourseStoreByCode(CourseCode).Name + "各率分布圖";

                if (dt.Rows.Count > 0)

                {

                    //增加年級資訊

                    //計算班級平均分和标準差

                    for (int I = 0; I < dt.Rows.Count; I++)

                    {

                        ClassName = ClassName + dt.Rows[I]["ClassName"].ToString() + ",";

                        ClassData = ClassData + dt.Rows[I][detail.ListName].ToString() + ",";

                    }

                    string[] dataTypeName = new string[1];

                    dataTypeName[0] = rdoList.SelectedItem.Text;

                    string[] dataType = new string[1];

                    dataType[0] = "P";

                    string[] DataName = ClassName.TrimEnd(',').Split(',');

                    string[] DataValue = new string[1];

                    DataValue[0] = ClassData.TrimEnd(',');

                    //标題

                    string title = rdoList.SelectedItem.Text + "直方圖";

                    //橫坐标說明标題

                    string xTitle = "";

                    //是否動态顯示 1為是 其他是否

                    string xmlDataYear = "<chart caption='" + title + "' numberSuffix='%25' XAxisName='" + xTitle + "' subcaption='" + "" + "' showValues='1' yAxisMaxValue='100' yAxisName='百分比' rotateyaxisname='0' baseFontSize='12'>";

                    xmlDataYear += FusionCharts.GetHistogramData(dataTypeName, dataType, DataName, DataValue);

                    xmlDataYear += "<styles><definition><style type='font' color='555555' name='CaptionFont' size='16' /><style type='font' name='SubCaptionFont' bold='0' size='12' /></definition><application><apply toObject='caption' styles='CaptionFont' /><apply toObject='SubCaption' styles='SubCaptionFont' /></application></styles>";

                    xmlDataYear += "</chart>";

                    return FusionCharts.RenderChart("FusionCharts/StackedColumn3D.swf", "", xmlDataYear, "SalesByYear", "550", "380", false, true);

                }

            }

            return "";

        }

        protected void RG_SelectedIndexChanged(object sender, EventArgs e)

        {

            GetProductChartHtml();

        }

    }

    public class FusionCharts

    {

        #region 生成直方圖資料

        /// <summary>

        /// 生成資料字元串

        /// </summary>

        /// <param name="DataTypeName">圖形資料分布種類名稱</param>

        /// <param name="DataType">圖形資料類型：S為線形，P為方形</param>

        /// <param name="DataName">資料名字</param>

        /// <param name="DataValue">資料值(個數與DataTypeName數一緻,每一個字元串都為種類的資料并用,号隔開)</param>

        /// <returns></returns>

        public static string GetHistogramData(string[] DataTypeName, string[] DataType, string[] DataName, string[] DataValue)

        {

            StringBuilder xmlData = new StringBuilder();

            if (DataTypeName.Length > 0 && DataValue.Length > 0)

            {

                StringBuilder categories = new StringBuilder();

                StringBuilder strAmtDS = new StringBuilder();

                categories.Append("<categories>");

                for (int j = 0; j < DataName.Length; j++)

                {

                    categories.Append("<category label='" + DataName[j] + "'/>");

                }

                categories.Append("</categories>");

                for (int i = 0; i < DataTypeName.Length; i++)

                {

                    strAmtDS.Append("<dataset seriesname='" + DataTypeName[i] + "' parentYAxis='" + DataType[i] + "'>");

                    string[] values = DataValue[i].Split(',');

                    for (int j = 0; j < values.Length; j++)

                        strAmtDS.Append("<set value='" + values[j] + "'/>");

                    strAmtDS.Append("</dataset>");

                }

                xmlData.Append(categories);

                xmlData.Append(strAmtDS);

            }

            return xmlData.ToString();

        }

        //string[] formatStrings(string[] DataValue)

        //{

        //    string[] newValue;

        //    for (int i = 0; i < DataValue.Length; i++)

        //    {

        //        string[] tmpStr = DataValue[i].Split(',');

        //        newValue = new string[tmpStr.Length];

        //        for (int j = 0; j < tmpStr.Length; j++)

        //        {

        //            newValue[j] += tmpStr[j]+",";

        //        }

        //    }

        //}

        #endregion

        /// <summary>

        /// 生成圖形字條串

        /// </summary>

        /// <param name="chartSWF"></param>

        /// <param name="strURL"></param>

        /// <param name="strXML"></param>

        /// <param name="chartId"></param>

        /// <param name="chartWidth"></param>

        /// <param name="chartHeight"></param>

        /// <param name="debugMode"></param>

        /// <param name="registerWithJS"></param>

        /// <returns></returns>

        public static string RenderChart(string chartSWF, string strURL, string strXML, string chartId,

                string chartWidth, string chartHeight, bool debugMode, bool registerWithJS)

        {

            StringBuilder builder = new StringBuilder();

            builder.AppendFormat("<!-- START Script Block for Chart {0} -->" + Environment.NewLine, chartId);

            builder.AppendFormat("<div id='{0}Div' align='center'>" + Environment.NewLine, chartId);

            builder.Append("Chart." + Environment.NewLine);

            builder.Append("</div>" + Environment.NewLine);

            builder.Append("<script type=/"text/javascript/">" + Environment.NewLine);

            builder.AppendFormat("var chart_{0} = new FusionCharts(/"{1}/", /"{0}/", /"{2}/", /"{3}/", /"{4}/", /"{5}/");" + Environment.NewLine, chartId, chartSWF, chartWidth, chartHeight, boolToNum(debugMode), boolToNum(registerWithJS));

            if (strXML.Length == 0)

            {

                builder.AppendFormat("chart_{0}.setDataURL(/"{1}/");" + Environment.NewLine, chartId, strURL);

            }

            else

            {

                builder.Append("chart_" + chartId + ".setDataXML(/"" + strXML + "/");" + Environment.NewLine);

            }

            builder.AppendFormat("chart_{0}.render(/"{1}Div/");" + Environment.NewLine, chartId, chartId);

            builder.Append("</script>" + Environment.NewLine);

            builder.AppendFormat("<!-- END Script Block for Chart {0} -->" + Environment.NewLine, chartId);

            return builder.ToString();

        }

        private static int boolToNum(bool value)

        {

            return value ? 1 : 0;

        }

    }

}

報表 string styles stylesheet server dataset
上一篇: 編譯器（解釋器）編寫指南-編寫編譯器（解釋器）的工具-LEX
下一篇: QT信号函數和槽函數的基本代碼實作

繼續閱讀