报表

最新推荐文章于 2022-08-09 16:44:05 发布

别有滋味

最新推荐文章于 2022-08-09 16:44:05 发布

阅读量677

点赞数

分类专栏： C# 文章标签：报表 microsoft dataset oa办公 asp webform

C# 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

SELECT [bid]
      ,[bname]
      ,[bdate]
      ,[state]
      ,[model]
      ,[bugcount]
      ,[pname]
  FROM [Bug].[dbo].[BugInfo]

1001	ddd	09 19 2010 12:18AM	待修复	用户管理	4	OA办公自动化
1002	bbbb	09 19 2010 12:18AM	以修复	个人设置	2	OA办公自动化
1003	eee	09 19 2010 12:18AM	待验证	BUG设置	7	OA办公自动化

DBHelper：

  public class DBHelper
    {
        SqlConnection conn = new SqlConnection("server=.;database=BUG;uid=sa;pwd=**");
        public DataSet GetBugInfo()
        {
            string sql = "select * from BugInfo";
            SqlDataAdapter da = new SqlDataAdapter(sql, conn);
            DataSet ds = new DataSet();
            da.Fill(ds);
            return ds;
        }
    }

Default.aspx:

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Chart ID="Chart1" runat="server" Height="296px" Width="600px" ImageLocation="~/TempImages/ChartPic_#SEQ(300,3)"
        Palette="BrightPastel" ImageType="Png" BorderDashStyle="Solid" BackSecondaryColor="White"
        BackGradientStyle="TopBottom" BorderWidth="2" BackColor="#D3DFF0" BorderColor="26, 59, 105">
        <Legends>
            <asp:Legend IsTextAutoFit="False" Name="Default" BackColor="Transparent" Font="Trebuchet MS, 9pt"
                TitleFont="Microsoft Sans Serif, 8pt">
            </asp:Legend>
        </Legends>
        <BorderSkin  SkinStyle="Emboss"></BorderSkin>
        <Titles>
            <asp:Title Font="Microsoft Sans Serif, 20pt" ForeColor="138, 175, 225" Name="Title1"
                Text="Bug模块分布">
            </asp:Title>
        </Titles>
        <Series>
            <asp:Series Name="Series1" BorderColor="180, 26, 59, 105" ChartType="Pie" IsValueShownAsLabel="True"
                LegendText="#AXISLABEL" Label="#PERCENT{P1}" ToolTip="模块：#AXISLABEL #VAL个">
            </asp:Series>
        </Series>
        <ChartAreas>
            <asp:ChartArea Name="ChartArea1" BorderColor="64, 64, 64, 64" BorderDashStyle="Solid"
                BackSecondaryColor="White" BackColor="PowderBlue" ShadowColor="Transparent" BackGradientStyle="TopBottom">
                <Area3DStyle Enable3D="True" />
            </asp:ChartArea>
        </ChartAreas>
    </asp:Chart>
    
    </div>
    </form>
</body>
</html>

Default:

   public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            ShowProjectData();
        }
        #region IReport 成员

        public void ShowProjectData()
        {
            DBHelper db = new DBHelper();
            Series series = new Series("");
            series.ChartArea = "ChartArea1";
            series.ChartType = SeriesChartType.Pie;
            series.IsValueShownAsLabel = true;
            DataSet data = db.GetBugInfo();
            for (int i = 0; i < data.Tables[0].Rows.Count; i++)
            {
                series.Points.AddXY(data.Tables[0].Rows[i]["model"], String.Format("{0:F2}", data.Tables[0].Rows[i]["bugcount"]));
                series.Points[i].LegendText = data.Tables[0].Rows[i]["model"].ToString();
            }
            series.Label = "#PERCENT{P1}";
            series.ToolTip = "模块:#AXISLABEL #VAL个"; ;
            Chart1.Series.Add(series);
        }


        #endregion
    }

WebForm.aspx:

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
 <asp:Chart ID="Chart1" runat="server" Height="296px" Width="600px" ImageLocation="~/TempImages/ChartPic_#SEQ(300,3)"
        Palette="BrightPastel" ImageType="Png" BorderDashStyle="Solid" BackSecondaryColor="White"
        BackGradientStyle="TopBottom" BorderWidth="2" BackColor="#D3DFF0" BorderColor="26, 59, 105">
        <Legends>
            <asp:Legend IsTextAutoFit="False" Name="Bug数量" BackColor="Transparent" Font="Trebuchet MS, 9pt"
                TitleFont="Microsoft Sans Serif, 8pt">
            </asp:Legend>
        </Legends>
        <BorderSkin SkinStyle="Emboss"></BorderSkin>
        <Titles>
            <asp:Title Font="Microsoft Sans Serif, 20pt" ForeColor="138, 175, 225" Name="Title1"
                Text="Bug状态分布">
            </asp:Title>
        </Titles>
        <ChartAreas>
            <asp:ChartArea Name="ChartArea1" BorderColor="64, 64, 64, 64" BorderDashStyle="Solid"
                BackSecondaryColor="White" BackColor="PowderBlue" ShadowColor="Transparent" BackGradientStyle="TopBottom">
                <AxisY LineColor="204, 204, 204">
                    <MajorGrid LineColor="204, 204, 204" />
                </AxisY>
                <AxisX LineColor="204, 204, 204">
                    <MajorGrid LineColor="204, 204, 204" />
                </AxisX>
            </asp:ChartArea>
        </ChartAreas>
    </asp:Chart>
    </form>
</body>
</html>

后台：

public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            ShowProjectData();
        }
        #region IReport 成员

        public void ShowProjectData()
        {
            DBHelper db = new DBHelper();
            Series series = new Series("");
            series.ChartArea = "ChartArea1";
            series.ChartType = SeriesChartType.Column;
            series.IsValueShownAsLabel = true;
            series.IsVisibleInLegend = true;
            DataSet data = db.GetBugInfo();
            for (int i = 0; i < data.Tables[0].Rows.Count; i++)
            {
                series.Points.AddXY(data.Tables[0].Rows[i]["state"], String.Format("{0:F2}", data.Tables[0].Rows[i]["BugCount"]));
            }
            series.LegendText = "Bug数量";
            series.ToolTip = "状态:#AXISLABEL #VAL个";
            Chart1.Series.Add(series);
        }

        #endregion
    }

WebForm2.aspx:

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
<asp:Chart ID="Chart1" runat="server" Height="296px" Width="600px" ImageLocation="~/TempImages/ChartPic_#SEQ(300,3)"
        Palette="BrightPastel" ImageType="Png" BorderDashStyle="Solid" BackSecondaryColor="White"
        BackGradientStyle="TopBottom" BorderWidth="2" BackColor="#D3DFF0" BorderColor="26, 59, 105">
        <Legends>
            <asp:Legend IsTextAutoFit="False" Name="Bug数量" BackColor="Transparent" Font="Trebuchet MS, 9pt"
                TitleFont="Microsoft Sans Serif, 8pt">
            </asp:Legend>
        </Legends>
        <BorderSkin SkinStyle="Emboss"></BorderSkin>
        <Titles>
            <asp:Title Font="Microsoft Sans Serif, 20pt" ForeColor="138, 175, 225" Name="Title1"
                Text="Bug日期分布">
            </asp:Title>
        </Titles>
        <ChartAreas>
            <asp:ChartArea Name="ChartArea1" BorderColor="64, 64, 64, 64" BorderDashStyle="Solid"
                BackSecondaryColor="White" BackColor="PowderBlue" ShadowColor="Transparent" BackGradientStyle="TopBottom">
                <AxisY LineColor="204, 204, 204">
                    <MajorGrid LineColor="204, 204, 204" />
                </AxisY>
                <AxisX LineColor="204, 204, 204">
                    <MajorGrid LineColor="204, 204, 204" />
                </AxisX>
            </asp:ChartArea>
        </ChartAreas>
    </asp:Chart>
    </form>
</body>
</html>

后台：

  public partial class WebForm2 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            ShowProjectData();
        }
        #region IReport 成员

        public void ShowProjectData()
        {
            DBHelper db = new DBHelper();
            Series series = new Series("");
            series.ChartArea = "ChartArea1";
            series.ChartType = SeriesChartType.Spline;
            series.IsValueShownAsLabel = true;
            series.IsVisibleInLegend = true;
            DataSet data = db.GetBugInfo();
            for (int i = 0; i < data.Tables[0].Rows.Count; i++)
            {
                series.Points.AddXY(data.Tables[0].Rows[i]["bdate"], String.Format("{0:F2}", data.Tables[0].Rows[i]["BugCount"]));
            }
            series.LegendText = "Bug数量";
            series.BorderWidth = 3;
            series.ShadowOffset = 2;
            Chart1.Series.Add(series);
        }

        #endregion
    }

别有滋味

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
报表

SELECT [bid] ,[bname] ,[bdate] ,[state] ,[model] ,[bugcount] ,[pname] FROM [Bug].[dbo].[BugInfo] 1001 ddd 09 19 2010 12:18AM 待修复用户管理 4 OA办公自动化1002 bbbb
复制链接

扫一扫

专栏目录