使用DundasWebChart.dll 版本号:4.1.0.1669 画图表

来源:互联网 发布:qq飞车卓越数据 编辑:程序博客网 时间:2024/05/19 13:29

样式很好看,也很好用的报表工具

前台:

<dcwc:chart id="Chart1" runat="server" Width="970" Height="360px" ImageType="Png" TitleFontColor="WhiteSmoke" TitleFont="Microsoft Sans Serif, 12pt">
<SERIES>
<dcwc:Series BackGradientType="VerticalCenter" Name="Default" Color="0, 192, 192" BackGradientEndColor="PaleTurquoise"></dcwc:Series>
</SERIES>
<LEGEND Enabled="false">
</LEGEND>
<BORDERSKIN SkinStyle="FrameThin6" FrameBackGradientEndColor="255, 192, 128" FrameBackHatchStyle="OutlinedDiamond"
FrameBackColor="Cornsilk" FrameBackGradientType="LeftRight"></BORDERSKIN>
<CHARTAREAS>
<dcwc:ChartArea BackColor="FloralWhite" BackGradientType="LeftRight" Name="Default" BackGradientEndColor="NavajoWhite"
ShadowColor="DarkGray" ShadowOffset="3"></dcwc:ChartArea>
</CHARTAREAS>
</dcwc:chart>

后台:

protected Dundas.Charting.WebControl.Chart Chart1;

//生成图表
    Chart1.ChartAreas["Default"].AxisY.Title=DpPramt.SelectedItem.Text;
    Chart1.ChartAreas["Default"].AxisX.Title="DATE";
    Chart1.Title =tit;

    if (this.RBColunm.Checked==true)
    {
     Chart1.Series[0].ChartType = "Column";
    }
    else
    {
     Chart1.Series[0].ChartType = "Line";
    }

    //改变标题颜色 
    Chart1.TitleFontColor = Color.Red;
    Chart1.Series[0]["LabelStyle"] = "Center";
    Chart1.BackHatchStyle = ChartHatchStyle.Shingle;
    Chart1.BackGradientType = GradientType.None;    
    Chart1.BorderStyle = ChartDashStyle.DashDotDot;
    Chart1.ForeColor=Color.LightGray;
    Chart1.BorderWidth = 1;
    // 控制图形上显示的toolstip提示
    Chart1.Series[0].ToolTip = "#VALX: #VALY ";//VALX表示X值 ,VAL{C}表示Y值

    // 控制图形上显示的toolstip提示
    Chart1.Series[0].LegendToolTip = "#PERCENT";//表示所占的百分比
    Chart1.Series[0]["FontColor"] ="Red";

    OracleDataReader dr = db.GetDataReader(str);
    if (dr.HasRows==true)
    {     
     if (DpPramt.SelectedItem.Text=="running time")
     {
      Chart1.Series[0].Points.DataBindXY(dr, "rd_day"/*横轴*/, dr, "cd_acctime"/*纵轴*/);  
     }
     else if (DpPramt.SelectedItem.Text=="work time")
     {    
      Chart1.Series[0].Points.DataBindXY(dr, "rd_day"/*横轴*/, dr, "cd_worktime"/*纵轴*/);  
     }
     else if (DpPramt.SelectedItem.Text=="dig number")
     {
      Chart1.Series[0].Points.DataBindXY(dr, "rd_day"/*横轴*/, dr, "cd_dignumber"/*纵轴*/);  
     }
     else if (DpPramt.SelectedItem.Text=="travel time")
     {
      Chart1.Series[0].Points.DataBindXY(dr, "rd_day"/*横轴*/, dr, "cd_traveltime"/*纵轴*/);  
     }
     else
     {   
      Chart1.Series[0].Points.DataBindXY(dr, "rd_day"/*横轴*/, dr, "cd_workhour"/*纵轴*/);  
     }
        
    }
    db.ConnClose();
    SetAxisInterval(Chart1.ChartAreas["Default"].AxisX, 1, DateTimeIntervalType.Days);//连续显示横轴坐标
    Chart1.ChartAreas["Default"].AxisX.LabelsAutoFit = false;//auto样式关
    Chart1.ChartAreas["Default"].AxisX.LabelStyle.OffsetLabels = false;//一行显示横轴坐标,非上下交错
    // Chart1.ChartAreas["Default"].AxisX.LabelStyle.FontAngle = -30; 横轴坐标倾斜角度
    Chart1.ChartAreas["Default"].AxisX.LabelStyle.Font = new Font("Arial", 10);//横轴坐标字体大小
    Chart1.ChartAreas["Default"].AxisY.LabelStyle.Font = new Font("Arial", 10);//纵轴坐标字体大小
    Chart1.ChartAreas["Default"].AxisX.TitleFont = new Font("Times New Roman",10, FontStyle.Bold);//横轴标题字体
    Chart1.ChartAreas["Default"].AxisY.TitleFont = new Font("Times New Roman",10, FontStyle.Bold);

    Chart1.ChartAreas["Default"].AxisY2.Enabled =AxisEnabled.False;//允许右侧有数字显示
    Chart1.ChartAreas["Default"].AxisY2.LineColor = Color.Red;//控制线的颜色
    Chart1.ChartAreas["Default"].AxisY2.LineStyle = ChartDashStyle.Solid;//控制线的类型 实线还是点划线等等
    Chart1.ChartAreas["Default"].AxisY2.Arrows = ArrowsType.None;//控制线是否带箭头 

原创粉丝点击