基于MSChar的报表程序原理基础

第一步：下载安装文件（安装顺序  先安装MSChart_dotnet3.5.exe，再安装MSChart_VisualStudioAddOn.exe）11.11  金山网盘的开发软件中有

          安装完成后重启  visual studio   ，vs2010中自带了。

第二步：参数解释

 

①legends：图例 

②series ：系列   每个对象  比方说  腾讯微博和新浪微博的市场占有率中的腾讯微博和新浪微博就是两个对象 即为两个 series

           series 是一个序列 一个索引  通过索引找到具体的

其中series中重要的几个参数   name：要通过那么找到具体哪个系列哪个对象:例如  Series series1=chart1.Series["Series1"];

                                       points即为点的数据，例如腾讯微博2月份的收入和三月份的收入series1.Points.add(3);

                                      ChartType:图形的显示方式 是直方图还是曲线图等等

private void Form坐席本月接话量报表_Load(object sender, EventArgs e)
        {
            DataTable dt = SqlHelper.ExecuteDataTable(@"select u.UserName as uname,Count(*) as WorkCount from T_Records r
                        left join T_Users u
                        on r.SeatId=u.Id
                        where DateDiff(month, r.StartDateTime, GETDATE())=0
                        group by u.UserName");
            Series 接话数量 = chart1.Series["接话数量"];
            foreach (DataRow row in dt.Rows)
            {
                String uname = (String)row["uname"];
                int count = (int)row["WorkCount"];
                DataPoint  point = new DataPoint();//一个点
                point.YValues = new double[]{count};//点的值
                point.Label = uname;//这个点的显示值
                接话数量.Points.Add(point);//点添加到图中
            }
        }

 

private void DrawLine()
    {
        string startdate = ""; //开始日期
        string enddate = "";//结束日期

        enddate = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
        startdate = Convert.ToString(Convert.ToDateTime(enddate).AddDays(-7));
        string jcxmdm = ""; //检测项目代码
        string jcxmmc = ""; //检测项目名称
       
        string zzbm = ""; //子站编码
        string warnMax = "";//警报上线
        string warnMin = "";//警报下线
        string unitOfMea = "";//单位

        zzbm = TextBox1.Text.Trim();
        string[] jcxm; //检测项目
        if (drojcxm.Text != "")
        {
            jcxm = drojcxm.Text.Split('-');
            if (jcxm.Length > 1)
            {
                jcxmdm = jcxm[0];
                jcxmmc = jcxm[1];
            }
        }
        if (!string.IsNullOrEmpty(jcxmdm) && zzbm != null)
        {
            Sqltxt = "select Value,Time,A.ItemCode,WarnMaxValue " +
                " from T_BAS_SubStData A " +
                " left join T_BAS_SubStQuota B on A.ItemCode=B.ItemCode and B.SubStCode='" + zzbm + "' " +
                " where A.ItemCode='" + jcxmdm + "'";
            Sqltxt += " and A.SubStCode='" + zzbm + "'";
            Sqltxt += " and Time between '" + startdate + "' and '" + enddate + "' order by Time";
            //Sqltxt = "select WarnMaxValue,WarnMinValue,D.UnitOfMea from T_BAS_SubStQuota A" +
            //     " left join T_BAS_SubStation B on B.SubStCode=A.SubStCode" +
            //     " left join T_BAS_ItemCatalog D on D.ItemCode=A.ItemCode" +
            //     " where B.SubStCode='" + zzbm + "'and D.ItemCode='" + jcxmdm + "'";
            DataTable dt = DBHelper.ExecuteDataTable(Sqltxt, false);
            StripLine lin = new StripLine();
            lin.BackColor = Color.Red;
            if (dt.Rows.Count > 0)
            {
                if (dt.Rows[0]["WarnMaxValue"] is DBNull)
                //if (string.IsNullOrEmpty(dt.Rows[0]["WarnMaxValue"].ToString()))
                {
                    lin.IntervalOffset = 1;

                }
                else
                {
                    lin.IntervalOffset = Convert.ToInt32(dt.Rows[0]["WarnMaxValue"]) + 0.2;
                }
            }
            lin.StripWidth = 0.01;
            lin.Text = "国标";
            lin.TextAlignment = StringAlignment.Near;
            Chart1.ChartAreas[0].AxisY.StripLines.Add(lin);
            Series serires1 = Chart1.Series.Add("lines1");
            Chart1.ChartAreas[0].AxisY.MajorTickMark.LineColor = Color.DarkGray;//Y轴刻度线颜色

            Chart1.ChartAreas[0].AxisX.Interval = 1;
            serires1.ChartType = SeriesChartType.Spline;

            serires1.Points.DataBind(dt.DefaultView, "Time", "Value", "");
            //Series serires2 = Chart1.Series.Add("lines2");

            //Chart1.ChartAreas[0].AxisX.Interval =
            //serires2.ChartType = SeriesChartType.Spline;

           
            
            //if (dt.Rows.Count > 0)
            //{
            //    warnMax = dt.Rows[0]["WarnMaxValue"].ToString();
            //    warnMin = dt.Rows[0]["WarnMinValue"].ToString();
            //    unitOfMea = dt.Rows[0]["UnitOfMea"].ToString();
            //}
        }
       
        //Page.RegisterClientScriptBlock("", "<script language='javascript'>GetQX('001','拉开门','2009-07-20 00:00:00','2009-07-22 23:59:59');</script>");
        //Page.RegisterClientScriptBlock("", "<script language='javascript'>GetQX('" + zzbm + "','" + jcxmdm + "','" + jcxmmc + "','" + startdate + "','" + enddate + "','" + warnMax + "','" + warnMin + "','" + unitOfMea + "')</script>");
    }