利用owc11绘制图（显示的是图片）

基本原理：

通过html页面传递一些参数到.aspx.cs执行，然后得到返回的图片显示在html页。

 需引用 Interop.OWC11.dll

1、html页代码：

<img id="ImgZZT" src="images/chartlaoding.gif" />

 

    <script type="text/javascript">

 function ShowImage(url, imgid) {
           document.getElementById("" + imgid + "").src = url;
       }

       var title = "";
       var fxsj = "百分比（%）";
       var tblx = "pie";//图的类型，pie表示饼图，bar表示柱状图
       var rdm = Math.random();
       var xfjgbh=<%=hdXfjgbh.Value%>;
       var xfdwjb=<%=hdXfdwjb.Value%>;

       var url = encodeURI("Graph_jdpg.aspx?xfjgbh=" + xfjgbh + "&xfdwjb=" + xfdwjb + "&tblx=" + tblx + "&fxsj=" + fxsj + "&title=" + title + "&rdm=" + rdm);

ShowImage(url, "ImgZZT");

</script>

 

2、Graph_jdpg.aspx.cs代码

　　　　　　DataSet ds = null;
                string sql = string.Empty;
                string xfdwjb = string.Empty;
                string xfjgbh = string.Empty;
                if (Request.QueryString["xfdwjb"] != null && Request.QueryString["xfjgbh"] != null)
                {
                    xfdwjb = Request.QueryString["xfdwjb"].ToString().Trim();
                    xfjgbh = Request.QueryString["xfjgbh"].ToString().Trim();
                    DAL.XFJG d_xfjg = new DAL.XFJG();

                    ds = d_xfjg.GetXFJGListProc(xfdwjb, xfjgbh, "getGraph_jdpg");//获取要显示的数据
                }
               
                if (ds.Tables[0].Rows.Count > 0)
                {
                   

　　　　　　　 object objPic = MyChart.GetPic(ds, Request.QueryString["tblx"].ToString(), Request.QueryString["title"].ToString(), 　　　　　　Request.QueryString["fxsj"].ToString(), 230, 150, "#ffffff", "#ffffff");//这是画图的真正核心方法
                    if (objPic == null)
                        Response.End();

                    Array arr = (Array)objPic;
                    Response.Expires = 0;
                    Response.Buffer = true;
                    Response.Clear();

                    MemoryStream memStream = new MemoryStream((byte[])arr);
                    memStream.WriteTo(Response.OutputStream);
                    memStream.Close();

                    Response.ContentType = "image/gif";
                    Response.StatusCode = 200;
                    Response.End();

　　　　}

 

3、MyChart.cs

 using OWC11;

 

GetPic（）方法

/// <summary>
///
/// </summary>
/// <param name="ds"> 含有显示数据的dataset </param>
/// <param name="chartType"> pie,bar,line </param>
/// <param name="chartTitle"></param>
/// <param name="axesTitle"> 图的标题 </param>
/// <param name="width"></param>
/// <param name="height"></param>
/// <param name="strbackcolor"> 背景颜色，比如：#e8efed </param>
/// <param name="strBoderColor"> 边框颜色，比如：#ffffff </param>
/// <returns></returns>
public static object GetPic(DataSet ds, string chartType, string chartTitle, string axesTitle, int width, int height, string strbackcolor, string strBoderColor)
{
string strTitles = "" ,strValues = "" ;
DsToStr( ref strTitles, ref strValues,ds.Tables[ 0 ]);
ChartSpace chartSpace = new ChartSpaceClass(); // 创建ChartSpace对象来放置图表
ChChart chart = chartSpace.Charts.Add( 0 ); // 在ChartSpace对象中添加图表,Add方法返回Chart对象

chart.Border.Color = strBoderColor; // 设置边框颜色

chart.Interior.Color = strbackcolor;

if (chartTitle != "" )
{
chart.HasTitle = true ;
chart.Title.Caption = chartTitle;
chart.Title.Font.Size = 12 ;
chart.Title.Font.Bold = true ;
chart.Title.Font.Name = " 宋体 " ;
}

if (chartType == " bar " )
{
chart.Type = OWC11.ChartChartTypeEnum.chChartTypeColumnClustered3D; // .chChartTypeColumnStacked3D;，如果要平面柱状图，则为chChartTypeColumnClustered 20100701 yg
chart.PlotArea.BackWall.Interior.Color = " #FFFFFF " ; // 背景墙的颜色
chart.PlotArea.BackWall.Thickness = 0 ; // 背景墙的厚度
chart.PlotArea.SideWall.Interior.Color = " #FFFFFF " ; // 边墙的颜色
chart.PlotArea.SideWall.Thickness = 0 ; // 边墙的厚度
chart.PlotArea.Floor.Interior.Color = " #FFFFFF " ; // 底墙的底色
chart.PlotArea.Floor.Thickness = 0 ; // 设置底墙的厚度
chart.ProjectionMode = OWC11.ChartProjectionModeEnum.chProjectionModeOrthographic; // 设置投影方式
chart.Inclination = 8 ; // 设置倾角,指定三维图表的视图斜率(-90 - 90)
chart.ChartDepth = 15 ; // 设置深度比,指定三维图表相对于宽度的深度(0-500)
chart.ExtrudeAngle = 55 ; // 延伸方向(0-360)，仅在chProjectionModeOrthographic时有效

chart.Axes[ 1 ].Scaling.Minimum = 0 ;
if (axesTitle != "" )
{
chart.Axes[ 1 ].HasTitle = true ;
chart.Axes[ 1 ].Title.Caption = axesTitle; // 设置数据轴标题,即X轴
chart.Axes[ 1 ].Title.Font.Size = 10 ;
}

chart.Axes[ 1 ].Orientation = ( int )ChartLabelOrientationEnum.chLabelOrientationHorizontal; // 设置分类标签的字体方向，X轴
chart.Axes[ 0 ].Font.Size = 9 ;
chart.Axes[ 0 ].Font.Name = " 宋体 " ;
chart.Axes[ 0 ].Orientation = ( int )ChartLabelOrientationEnum.chLabelOrientationHorizontal; // 设置分类标签的字体方向，Y轴
chart.Axes[ 1 ].HasMajorGridlines = false ; // 去掉水平网线
chart.Axes[ 1 ].HasMinorGridlines = false ; // 去掉水平网线

ChSeries objSeries = chart.SeriesCollection.Add( 0 ); // 添加一个series
ChDataLabels objDataLabels = objSeries.DataLabelsCollection.Add();
objDataLabels.HasValue = true ; // 柱子上面的数字是否显示
// objDataLabels.HasPercentage = true;
objDataLabels.Font.Color = " Black " ; // 柱子上面的数字颜色是黑色的

objSeries.SetData( OWC11.ChartDimensionsEnum.chDimCategories,( int )OWC11.ChartSpecialDataSourcesEnum.chDataLiteral,strTitles ); // 给定series的分类
objSeries.SetData( OWC11.ChartDimensionsEnum.chDimValues,( int )OWC11.ChartSpecialDataSourcesEnum.chDataLiteral,strValues ); // 给定具体值

for ( int i = 0 ;i < objSeries.Points.Count;i ++ )
{
if (i > 14 )
break ;
objSeries.Points[i].Interior.Color = colorArr[i];
objSeries.Points[i].Border.Color = colorArr[i];
}
}
else if (chartType == " line " )
{
chart.Type = OWC11.ChartChartTypeEnum.chChartTypeSmoothLineMarkers; // 曲线
chart.PlotArea.Interior.Color = " #FAFAFA " ; // 背景墙的颜色
if (axesTitle != "" )
{
chart.Axes[ 1 ].HasTitle = true ;
chart.Axes[ 1 ].Title.Caption = axesTitle; // 设置数据轴标题
chart.Axes[ 1 ].Title.Font.Size = 10 ;
}
chart.Axes[ 1 ].Scaling.Minimum = 0 ;
chart.Axes[ 0 ].Font.Size = 10 ;
chart.Axes[ 0 ].Font.Name = " 宋体 " ;
chart.Axes[ 0 ].Orientation = ( int )ChartLabelOrientationEnum.chLabelOrientationHorizontal; // 设置分类标签的字体方向
ChSeries objSeries = chart.SeriesCollection.Add( 0 ); // 添加一个series
ChDataLabels objDataLabels = objSeries.DataLabelsCollection.Add();
objDataLabels.HasValue = true ; // 柱子上面的数字是否显示
objDataLabels.Font.Color = " Black " ; // 柱子上面的数字颜色是黑色的
objSeries.SetData( OWC11.ChartDimensionsEnum.chDimCategories,( int )OWC11.ChartSpecialDataSourcesEnum.chDataLiteral,strTitles ); // 给定series的分类
objSeries.SetData( OWC11.ChartDimensionsEnum.chDimValues,( int )OWC11.ChartSpecialDataSourcesEnum.chDataLiteral,strValues ); // 给定具体值
objSeries.Line.Color = colorArr[ 0 ];
objSeries.Interior.Color = colorArr[ 3 ];
}
else if (chartType == " pie " )
{
// chart.HasTitle = true;
// chart.Title.Caption = axesTitle.Substring(0,axesTitle.IndexOf("（"));
// chart.Title.Font.Size = 10;
// chart.Title.Font.Bold = true;
// chart.Title.Font.Name = "宋体";

chart.Type = OWC11.ChartChartTypeEnum.chChartTypePieExploded3D;
chart.ProjectionMode = OWC11.ChartProjectionModeEnum.chProjectionModePerspective; // 设置投影方式,透视
chart.Perspective = 15 ; // 透视系数
chart.Inclination = 64 ;
chart.HasLegend = true ;
chart.Legend.Position = ChartLegendPositionEnum.chLegendPositionRight; // 图例在图片右侧

chart.Legend.Font.Size = 9 ; // 设置图例字体
chart.Legend.Font.Name = " 宋体 " ;
ChSeries objSeries = chart.SeriesCollection.Add( 0 ); // 添加一个series
objSeries.SetData( OWC11.ChartDimensionsEnum.chDimCategories,( int )OWC11.ChartSpecialDataSourcesEnum.chDataLiteral,strTitles ); // 给定series的分类
objSeries.SetData( OWC11.ChartDimensionsEnum.chDimValues,( int )OWC11.ChartSpecialDataSourcesEnum.chDataLiteral,strValues ); // 给定具体值

ChDataLabels objDataLabels = objSeries.DataLabelsCollection.Add();
objDataLabels.HasValue = false ; // 显示各部分的数值
objDataLabels.HasPercentage = true ; // 显示各部分的百分比
objDataLabels.Font.Size = 10 ; // 设置饼状图中字体的大小
objDataLabels.Font.Color = " Black " ;
for ( int i = 0 ;i < objSeries.Points.Count;i ++ )
{
if (i > 14 )
break ;
objSeries.Points[i].Interior.Color = colorArr[i];
objSeries.Points[i].Border.Color = colorArr[i];
}
}
else
{
return null ;
}
object objPic = chartSpace.GetPicture( " GIF " , width, height);
return objPic;
}

 

 

 

DsToStr方法

/// <summary>
/// 转换DataTable为OWC特定格式字符串
/// </summary>
/// <param name="strTitles"> 组标签字符串 </param>
/// <param name="strValues"> 数据字符串 </param>
/// <param name="dt"> DataTable数据源 </param>
private static void DsToStr( ref string strTitles, ref string strValues,DataTable dt)
{
string [] titles = new string [dt.Rows.Count];
string [] values = new string [dt.Rows.Count];
for ( int i = 0 ;i < dt.Rows.Count;i ++ )
{
titles[i] = dt.Rows[i][ 0 ].ToString() == "" ? " 未知 " : dt.Rows[i][ " mc " ].ToString();
values[i] = dt.Rows[i][ 1 ].ToString() == "" ? " 0 " : dt.Rows[i][ " val " ].ToString();
}
strTitles = String.Join( " \t " ,titles);
strValues = String.Join( " \t " ,values);
}

 

增值服务哈：office自带的关于owc的帮助文档：

C:\Program Files\Common Files\Microsoft Shared\Web Components\11\2052\OWCVBA11.CHM

转载于:https://www.cnblogs.com/yugen/archive/2010/08/12/1798436.html